|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
I am in the midst of creating a shopping website. However i'm stuck here. I can view my list of products and click to further go into an update form with previously entered details. But when i click "update", i always get this error below.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933: SQL command not properly ended /manageproducts.asp, line 105 Why do they keep throwing me this error? whats wrong with my sql? I only have these fields in my table. Create table Products( product_id INTEGER, product_name VARCHAR(50), product_price REAL, product_description VARCHAR(3000), product_category VARCHAR(30), product_subcategory VARCHAR(30), product_stock INTEGER, product_image VARCHAR(50), product_status INTEGER, PRIMARY KEY (product_id) ); My code: <% ' Update Product IF updateProduct <> "" THEN sqlString = "UPDATE Products SET " &_ "product_name='" & fixQuotes( productName ) & "'," &_ "product_price=" & productPrice & "," &_ "product_description='" & fixQuotes( productDescription ) & "'," &_ "product_category='" & fixQuotes( productCategory ) & "'," &_ "product_subcategory='" & fixQuotes( productSubcategory ) & "'," &_ "product_stock='" & productStock & "'," &_ "product_image='" & fixQuotes( productImage ) & "'," &_ "product_status=" & productStatus &" WHERE " &_ "product_id=" & productID Conn.Execute sqlString %> Pls help. Thanks! |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > SQL not properly ended error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|