Piyush Posted November 2, 2009 Share Posted November 2, 2009 table scrap has these columns...id(autoincrement),scrapfrom(number),time(number),scrapto(number),message(text)i had executed this queryINSERT INTO scrap (scrapfrom,time,scrapto,message) VALUES (1,1257148511,1,'Hellow akdkjlasdkjlsaasdkjl')and the following error came...Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\Inetpub\wwwroot\php_new\scrap.php on line 24please help me with this...i am using access database.... Link to comment Share on other sites More sharing options...
justsomeguy Posted November 2, 2009 Share Posted November 2, 2009 That query looks fine to me, unless something like "scrap" or "time" is a reserved word in Access. Link to comment Share on other sites More sharing options...
thescientist Posted December 3, 2009 Share Posted December 3, 2009 That query looks fine to me, unless something like "scrap" or "time" is a reserved word in Access. time is. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.