Something overlooked with SQL?
Hopefully this is some simple error I'm overlooking in syntax. I get the following error:
And here is the related lines (JScript):
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]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 ''TestUser','Sun Mar 30 00:17:42 UTC 2008','Foo bar text')' at line 1
/temp/chatBox.asp, line 35
Any suggestions? Or is more info needed?
SQL = "CREATE TABLE t_chat("+
//add a test record
var dt = new Date();
SQL = "INSERT INTO t_chat"+
"VALUES ('TestUser','"+ dt +"','Foo bar text');";
adoConn.Execute(SQL); //<-- Line 35
nevermind, it was something simple.....I forgot a space.
SQL = "INSERT INTO t_chat"+ ---> SQL = "INSERT INTO t_chat "+
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)