Just a thought. 'Label' might be a reserved name on win as it is/was used to
describe the name of a volume (drive).
But then again, maybe not.
George
----- Original Message -----
From: "mweb" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 10:45 AM
Subject: [PHP] FOLLOW UP on "column names not liked by odbc/php/access"
> 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
>
> --
> 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]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
