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
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
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',
hi,
in your sql command there are several errors:
it has the form
INSERT INTO (list of fieldnames)
VALUES (list of values);
but:
- there are more items in the list of values than in the list of
fieldnames. these lists should match.
- there's an extra comma after fieldname 'unico', and the
On Wednesday 05 December 2001 12:21, Dr. Michael Wittmann wrote:
- you dont need apostrophes for numeric fields. you get the table
definition using sql command 'DESC tablename'
Thanks to Michael and all the others who pointed out my errors. The query
works now. The real problem however,
mweb,
I suggest you use the ODBC Metadata functions in PHP to describe your
database, e.g. odbc_tables, odbc_columns, odbc_primarykeys,
odbc_foreignkeys, etc.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data