Another Custom Query Question

M

Matt Shudy

Hi,

This is for a different table. I am trying to do a custom
query to update a db table. I get the following error.

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Syntax error (comma) in query expression 'Location='Akron,
Akron' AND Month=1, 1 AND Year=2004, 2004'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

Is there something common that i should look for to fix
this problem?

Thanks,

Matt Shudy
 
J

Jon Spivey

Hi Matt,
presumably you can see whats wrong with
'Location='Akron, Akron' AND Month=1, 1 AND Year=2004, 2004'.
Can you post up
1/ the form page url (or code)
2/ the custom query you're using
 
M

Matt Shudy

Hi,

Here is the query:

UPDATE Plans
SET
TIR=::TIR::,LTA=::LTA::,WorkersComp=::WorkersComp::,EHSaudi
t=::EHSaudit::,HazWaste=::HazWaste::,Recycled=::Recycled::,
EHStraining=::EHStraining::,ObservationsConducted=::Observa
tionsConducted::
WHERE Location='::Location::' AND Month=::Month:: AND
Year=::Year::

Every Field is a number field except for location which is
a text field.

Matt Shudy
-----Original Message-----
Hi Matt,
presumably you can see whats wrong with
'Location='Akron, Akron' AND Month=1, 1 AND Year=2004, 2004'.
Can you post up
1/ the form page url (or code)
2/ the custom query you're using

--
Cheers,
Jon
Microsoft MVP - FP

Hi,

This is for a different table. I am trying to do a custom
query to update a db table. I get the following error.

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Syntax error (comma) in query expression 'Location='Akron,
Akron' AND Month=1, 1 AND Year=2004, 2004'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

Is there something common that i should look for to fix
this problem?

Thanks,

Matt Shudy
Click to expand...


.
Click to expand...
 
K

Kevin Spencer

It looks to me like you've got multiple form fields and/or querystring
parameters with the same name. In HTML, when a form posts with multiple
fields having the same name, the value of "the" field by that name will be a
comma-delimited list of the values of ALL fields having that name.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
M

Matt Shudy

Thanks for the help, i forgot about some hidden fields i
had put in, and i put in duplicated fields.

Matt Shudy
-----Original Message-----
It looks to me like you've got multiple form fields and/or querystring
parameters with the same name. In HTML, when a form posts with multiple
fields having the same name, the value of "the" field by that name will be a
comma-delimited list of the values of ALL fields having that name.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

Hi,

This is for a different table. I am trying to do a custom
query to update a db table. I get the following error.

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Syntax error (comma) in query expression 'Location='Akron,
Akron' AND Month=1, 1 AND Year=2004, 2004'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

Is there something common that i should look for to fix
this problem?

Thanks,

Matt Shudy
Click to expand...


.
Click to expand...
 
Top