landslide
11-09-2009, 07:44 PM
I wrote the following SQL in accessSELECT talleyhalfhour.STATE_CODE_3, Count(talleyhalfhour.STATE_CODE_3) AS [COUNT], TIM.L4_DESC
FROM talleyhalfhour, TIM
WHERE TIM.XXXX=talleyhalfhour.EMP_EXTRA_1 And FormatDateTime(STATE_TIME_3,4)="09:00"
GROUP BY talleyhalfhour.STATE_CODE_3, TIM.L4_DESC
ORDER BY talleyhalfhour.STATE_CODE_3; it works great but when I writh the same thing in Dreamweaver. First I get a "ODBC error Undefined function FormatDateTime". Then I remove it and I get a datatype mismatch. This happens to me from time to time and drive me crazy how can I fix this? What is causing this. From reading some stuff it is because access assignes a text value by default how do I write the sql in dreaweaver to aviod this?Thanks in advance
FROM talleyhalfhour, TIM
WHERE TIM.XXXX=talleyhalfhour.EMP_EXTRA_1 And FormatDateTime(STATE_TIME_3,4)="09:00"
GROUP BY talleyhalfhour.STATE_CODE_3, TIM.L4_DESC
ORDER BY talleyhalfhour.STATE_CODE_3; it works great but when I writh the same thing in Dreamweaver. First I get a "ODBC error Undefined function FormatDateTime". Then I remove it and I get a datatype mismatch. This happens to me from time to time and drive me crazy how can I fix this? What is causing this. From reading some stuff it is because access assignes a text value by default how do I write the sql in dreaweaver to aviod this?Thanks in advance