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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
