|
 |
access_asp thread: (0x80040E14) Syntax error (missing operator) in query expression
Message #1 by theab@l... on Wed, 3 Oct 2001 15:15:19
|
|
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 = "Update FaultReport Set FaultCategory = '" & Request.form
("categoryid") & "',finished = False, acceptedby = 0 Where FaultNumber
= '" & 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. Expected 1.
/oasismk2/changedepartment.asp, line 34
Can anyone help with this, what am I doing wrong?
Thanx in advance!
Thea Burger
@lantic Internet Services
Message #2 by "Jim Losi" <jlosi1@t...> on Wed, 3 Oct 2001 10:36:42 -0400
|
|
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 = "Update FaultReport Set FaultCategory = '" & Request.form
> ("categoryid") & "',finished = False, acceptedby = 0 Where FaultNumber
> = '" & 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. Expected 1.
> /oasismk2/changedepartment.asp, line 34
>
> Can anyone help with this, what am I doing wrong?
>
> Thanx in advance!
>
> Thea Burger
> @lantic Internet Services
>
>
>
>
>
>
>
>
Message #3 by theab@l... on Mon, 15 Oct 2001 13:10:16
|
|
> 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.
>
> ----- 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 = "Update FaultReport Set FaultCategory = '" & Request.form
> > ("categoryid") & "',finished = False, acceptedby = 0 Where FaultNumber
> > = '" & 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. Expected
1.
> > /oasismk2/changedepartment.asp, line 34
> >
> > Can anyone help with this, what am I doing wrong?
> >
> > Thanx in advance!
> >
> > Thea Burger
> > @lantic Internet Services
> >
> >
> >
> >
> >
> >
> >
> >
>
|
|
|
View Cart
