SQL error (But I'm certian this is a PHP error)

I have a query that's long and full of escaped chars and it refuses to work.
So to simplify things, I tried this:

$query = odbc_exec($cls_odbc->db_conn(), "INSERT INTO settings_data
(setting, value) VALUES ('setting1', 'value1')") or die (odbc_errormsg());

And when I run it, I get this error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
in INSERT INTO statement., SQL state 37000 in SQLExecDirect in
c:\inetpub\wwwroot\dbase.php on line 95
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.


Am I missing something? Surely that should work?!?

I've only done DB stuff in ASP before so this is my first time in PHP doing
this...

Hope someone can shed some light...

Plankmeister.

The Plankmeister wrote:

> I have a query that's long and full of escaped chars and it refuses to
> work. So to simplify things, I tried this:
>
> $query = odbc_exec($cls_odbc->db_conn(), "INSERT INTO settings_data
> (setting, value) VALUES ('setting1', 'value1')") or die (odbc_errormsg());
>
> And when I run it, I get this error:
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
> in INSERT INTO statement., SQL state 37000 in SQLExecDirect in
> c:\inetpub\wwwroot\dbase.php on line 95
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
>
> Am I missing something? Surely that should work?!?
>
> I've only done DB stuff in ASP before so this is my first time in PHP
> doing this...
>

IIRC, MS Access likes to have a semicolon (";") at the end of queries; also
it may have a problem with using certain words as fieldnames, if they're
reserved in Jet - try quoting them:

INSERT INTO settings_data("setting", "value")
VALUES ('setting1', 'value1');

Or try uysing different fieldnames!

HTH

Pure genius!

Thanks for that golden tip. It appears that 'setting' is a reserved word. A
thousand thanks! I would never have thought of that!

Plankmeister.

"matty" <matt+nntp@askmenoquestions.co.uk> wrote in message
news:07y%a.4387$z7.798568@wards.force9.net...
> The Plankmeister wrote:
>
> > I have a query that's long and full of escaped chars and it refuses to
> > work. So to simplify things, I tried this:
> >
> > $query = odbc_exec($cls_odbc->db_conn(), "INSERT INTO settings_data
> > (setting, value) VALUES ('setting1', 'value1')") or die
(odbc_errormsg());
> >
> > And when I run it, I get this error:
> >
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax
error
> > in INSERT INTO statement., SQL state 37000 in SQLExecDirect in
> > c:\inetpub\wwwroot\dbase.php on line 95
> > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> > statement.
> >
> >
> > Am I missing something? Surely that should work?!?
> >
> > I've only done DB stuff in ASP before so this is my first time in PHP
> > doing this...
> >
>
> IIRC, MS Access likes to have a semicolon (";") at the end of queries;
also
> it may have a problem with using certain words as fieldnames, if they're
> reserved in Jet - try quoting them:
>
> INSERT INTO settings_data("setting", "value")
> VALUES ('setting1', 'value1');
>
> Or try uysing different fieldnames!
>
> HTH
>