Check the contents of '$tblIngress' and '$tblText', some characters , such as ' , may
give you this error .
Darvin
-----Original Message-----
From: Glenn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 2:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] PHP4 and MS Access
Hallo!
I try to make an insert statment but get a ERROR msg, It looks like this
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
in INSERT INTO statement., SQL state 37000 in SQLExecDirect in
my insert statment look like this:
/* run insert */
$result = odbc_exec($connect, "INSERT INTO content (ingress, text) VALUES
('$tblIngress', '$tblText') where id = 1");
pleas help me
Best regards
//Glenn
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
--
PHP Windows 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 Windows 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]
