Re: [PHP] Partial answer to FOLLOW UP on column names not liked by odbc/php/access

2001-12-05 Thread Pavel Jartsev 

mweb wrote:

 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!');



Maybe it's just typo (like missing table name),
but U have in statement  ... Unico, VALUES ( ... .

It should be  ... Unico) VALUES ( ... .


-- 
Pavel a.k.a. Papi


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Partial answer to FOLLOW UP on column names not liked by odbc/php/access

2001-12-05 Thread mweb 

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]