FW: [PHP-WIN] PHP4 and MS Access
| From: | Gregory_Griffiths at cargill dot com | Date: | Tue, 20 Feb 2001 14:16:56 +0000 |
| Subject: | FW: [PHP-WIN] PHP4 and MS Access | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5654@lists.php.net to get a copy of this message | ||
You don't need a WHERE clause on an insert
-----Original Message-----
> > From: glenn@yeayea.com [mailto:glenn@yeayea.com]
> > Sent: 20 February 2001 13:08
> > To: php-windows@lists.php.net
> > 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: php-windows-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-windows-help@lists.php.net
> > To contact the list administrators, e-mail:
> > php-list-admin@lists.php.net
> >
> >
>