You don't need a WHERE clause on an insert
-----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 20 February 2001 13:08
> > 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]
