FOLLOW UP on "column names not liked by odbc/php/access"

From: Date: Wed, 05 Dec 2001 10:45:51 +0000
Subject: FOLLOW UP on "column names not liked by odbc/php/access"
Groups: php.general 
Request: Send a blank email to php-general+get-76690@lists.php.net to get a copy of this message
Hello, On the same database, this query works: $SQL_Exec_String = "INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link) VALUES ('prova titolo','prova descrizione','.gif','prova link');"; $cur= odbc_exec( $cnx, $SQL_Exec_String ); This one gives this error: ISQL_exec_String = "Insert Into (Artista, Opera, Label, Anno, Nazione, CDNow, Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato, Unico, VALUES ('prova2', 'inedita', 'ignota', '2001','IT', 'nonesiste', 'io', 'lui','3', 'ulteriori dettagli sul genere musicale', 'http://www.no.it', '1', '20011205111456', 'asdas erfver', 'ciao ni', '2.5', 'Non andare a capo!');" Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\domini\m.net\inserzione3.php on line 115 Error in odbc_exec( no cursor returned ) Does the second qyury look syntactically wrong to you? May it be that some column name or quoting is wrong, or some value I try insert is not matching the column type? If so, why would this be a *syntax* error? Is it possible to query access via Php so that it will tell the internal strucure of the table? (this database was developed and left online by somebody else, that's why I don't have all this info) Any help is greatly appreciated, as are working sql statements for similar (php+odbc+access) cases. regards, mweb

« previous php.general (#76690) next »