OK. this is the dilio
I have a query that get the count of the records. This is what i had at first…
SELECT Count(*) AS total FROM events WHERE intdate >= " & timeStamp() & " Limit 4;
then it gave me this error.
[color=#000000][font=verdana] Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Limit 4’ at line 1
/ambersdiary/home.asp, line 75[/font][/color]
then I thought, "well its just returning a number, so the Limit 4 shouldn’t be helping at all, so i took it off. So now im down to.
SELECT Count(*) AS total FROM events WHERE intdate >= " & timeStamp() & ";
And I get the error…
[color=#000000][font=verdana] Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
**/ambersdiary/home.asp, line 75
**[/font][/color]Then I tried both the querying the in MySQL Command line client.
They both work fine. I really dont get it. I’m also using MyODBC, But i dont think that will do anything.
thanks for any help,
-Naaman