HI
I using a form to enter data into an Access database, then go to a confirmation screen. However i enter the information, it then goes to a confirmation page, but no infomation is placed n the database. I have used the following code to try and enter information, could anybody tell me what the error could be?
<%
' Add New Product
IF addProduct <> "" THEN

sqlString = "INSERT INTO Products " &_
"( product_name, product_price, product_picture, " &_
"product_category, product_briefdesc, product_fulldesc, "&_
"product_status ) VALUES ( " &_
" '" & productName & "', "&_
cCur( productPrice ) & ", " &_
" '" & productPicture & "', " &_
" '" & productCategory & "', " &_
" '" & productBriefDesc & "', " &_
" '" & productFullDesc & "', " &_
productStatus & " )"


%>