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

OOPS... of couse the query below doesn't work, it doesn't have the table name.... (see below however) > 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 ) Adding the table name, I "simply" get: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\domini\m.net\inserzione3.php on line 116 Error in odbc_exec( no cursor returned ) This is clear, but, since I just take over the database, no docs exists about it, and I only have Linux running right now at home, how do I fins out quickly which columns are type mismatch? the 2.5 value almost sure doesn't go into quotes, right? but what about the others? TIA, Mweb