|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 7th, 2004, 06:14 AM
|
|||
|
|||
|
Error which only happens for this code
Code:
<%
if (Trim(request.form("wantinsurance"))="Y") then
sSQL="UPDATE orders SET giftWrap = 3 WHERE ordID = "&Request.Form("ordernumber")
cnn.Execute(sSQL) // THIS IS LINE 2040
end if
%>
I get the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='. /vsadmin/inc/inccart.asp, line 2040 I can't see where I am going wrong - please can someone help. The column in the DB is set as type: float. Thanks!
|
|
#2
July 7th, 2004, 06:25 AM
|
||||
|
||||
|
check the return from Request.Form("ordernumber")
assuming ordID is a bigint, the request probably gives some unwanted char
|
|
#3
July 7th, 2004, 06:53 AM
|
|||
|
|||
|
fool
Yup - I'm a fool
I just put the code later on where I know Request.Form("ordernumber") was being called properly and now it works! Cheers!
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Error which only happens for this code |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
