Hi,



Is finished a check box in the access database? If so then try -1 for yes

 and 0 for no, methinks.



Patrick



----- Original Message -----

From: theab@l...

Sent: Monday, October 15, 2001 01:16

To: Access ASP

Subject: [access_asp] Re: (0x80040E14) Syntax error (missing operator) in

 query expression



> Hi, again



I tried the 0 instead of false, but I got the same error - thanx in anywa

y

Jim! Does anybody have any other ideas?



Thea



Finished is boolean so I would try using 0 instead of false.

>

> ----- Original Message -----

> From: <theab@l...>

> To: "Access ASP" <access_asp@p...>

> Sent: Wednesday, October 03, 2001 3:15 PM

> Subject: [access_asp] (0x80040E14) Syntax error (missing operator) in

query

> expression

>

>

> > Hi, all

> >

> > I'm using a Access database and I keep on getting this error:

> >

> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)

> > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in

criteria

> > expression.

> > /oasismk2/changedepartment.asp, line 34

> >

> > The code that I get the error on is this:

> >

> > Sql =3D "Update FaultReport Set FaultCategory =3D '" & Request.form

> > ("categoryid") & "',finished =3D False, acceptedby =3D 0 Where FaultN

umber

> > =3D '" & request.form("faultnumber") & "'"

> >

> > DataSave.ExecutetoAccess sql

> >

> > All the fields' type is number except for Finished is Yes/No.

> >

> > If I remove the single quotes I get the following error:

> >

> > Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

> > [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expecte

d

1.

> > /oasismk2/changedepartment.asp, line 34

> >

> > Can anyone help with this, what am I doing wrong?

> >

> > Thanx in advance!

> >

> > Thea Burger

> > @lantic Internet Services

> >

> >

> >

> >

This is easy enough to verify in the Access QBE



Select "New Query", and use the GUI to build a query. You can see the SQL by

switching to SQL view. The following works in my copy of Access (v2000),

where I created a yes/no field called yesnotestfield.



SELECT

    field1, field2, field3

FROM

    table1

WHERE

    yesnotestfield=yes



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Paddy Anigbo" <dirosky@h...>

Subject: [access_asp] Re: (0x80040E14) Syntax error (missing operator) in

query expre





Hi,



Is finished a check box in the access database? If so then try -1 for yes

and 0 for no, methinks.



Patrick



----- Original Message -----

From: theab@l...

Sent: Monday, October 15, 2001 01:16

To: Access ASP

Subject: [access_asp] Re: (0x80040E14) Syntax error (missing operator) in

query expression



> Hi, again



I tried the 0 instead of false, but I got the same error - thanx in anyway

Jim! Does anybody have any other ideas?



Thea



Finished is boolean so I would try using 0 instead of false.

>



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~