[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-developers] Interbase V6 Classic INSERT INTO gives token unknown error



Here is the error below with my SQL and variables beneath that. I found
on google someone saying my INSERT INTO statement is now illegal in
Firebird, is this the same for my version of IB6 Classic? Anyone have
some help for me?

SQLState: HY000
Native Error Code: 335544569
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 67
,


SQL -
INSERT INTO ORDERDETAILS (PRODUCTID, UNITPRICE, QUANTITY) 
VALUES (rqProductID,rqUnitPrice,rqQuantity) 

Variables -
rqProductID = Request.Form("txtProductID")
rqUnitPrice = Request.Form("txtUnitPrice")
rqQuantity = Request.Form("txtQuantity")

 
regards,
 
Todd Kirk