|
 |
access_asp thread: missing operator error HELP
Message #1 by "tandy osborn" <tosborn@h...> on Sun, 8 Dec 2002 00:46:42
|
|
Some one please help, I'm not sure what is going on.
This is my error:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''6, Manufacture
= 'Fisher Price' WHERE (id = 14)'.
/asp/final/admin/testadmin.asp, line 180
This is line 180:
cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or adExecuteNoRecords
strSQL = "UPDATE toys SET " _
& "Name = '" & (Request.Form("Name")) & "', " _
& "AgeGroup = '" & (Request.Form("AgeGroup")) & ", " _
& "Manufacture = '" & (Request.Form("Manufacture")) & "' " _
& "WHERE (id = " & iRecordId & ")"
Please help!!!!!!!!!!!
Message #2 by "Larry Woods" <larry@l...> on Sat, 7 Dec 2002 17:48:55 -0700
|
|
No single quote after the AgeGroup value.
Larry Woods
> -----Original Message-----
> From: tandy osborn [mailto:tosborn@h...]
> Sent: Sunday, December 08, 2002 12:47 AM
> To: Access ASP
> Subject: [access_asp] missing operator error HELP
>
>
> Some one please help, I'm not sure what is going on.
> This is my error:
>
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression
> ''6, Manufacture
> = 'Fisher Price' WHERE (id = 14)'.
> /asp/final/admin/testadmin.asp, line 180
>
> This is line 180:
>
> cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or
> adExecuteNoRecords
>
> strSQL = "UPDATE toys SET " _
> & "Name = '" & (Request.Form("Name")) & "', " _
> & "AgeGroup = '" & (Request.Form("AgeGroup")) & ", " _
> & "Manufacture = '" & (Request.Form("Manufacture")) & "' " _
> & "WHERE (id = " & iRecordId & ")"
>
>
> Please help!!!!!!!!!!!
>
Message #3 by "tandy osborn" <tosborn@h...> on Sun, 8 Dec 2002 01:12:06
|
|
Thank you so much Larry, I feel silly to have missed that!
> No single quote after the AgeGroup value.
Larry Woods
> -----Original Message-----
> From: tandy osborn [mailto:tosborn@h...]
> Sent: Sunday, December 08, 2002 12:47 AM
> To: Access ASP
> Subject: [access_asp] missing operator error HELP
>
>
> Some one please help, I'm not sure what is going on.
> This is my error:
>
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression
> ''6, Manufacture
> = 'Fisher Price' WHERE (id = 14)'.
> /asp/final/admin/testadmin.asp, line 180
>
> This is line 180:
>
> cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or
> adExecuteNoRecords
>
> strSQL = "UPDATE toys SET " _
> & "Name = '" & (Request.Form("Name")) & "', " _
> & "AgeGroup = '" & (Request.Form("AgeGroup")) & ", " _
> & "Manufacture = '" & (Request.Form("Manufacture")) & "' " _
> & "WHERE (id = " & iRecordId & ")"
>
>
> Please help!!!!!!!!!!!
>
|
|
|
View Cart
