I am trying to run through an asp book i have but also trying to customize the lessons in there to my own personal needs.
i have created a database input form on addproduct.asp which then send info to manageproduct.asp for this page to process and add a record to my database.
when i try to add product i always get his annoying message saying:
but i cannot see anything wrong with the code here:
<%
'add new product
IF addProduct <> "" THEN
sqlString = "INSERT INTO record_webtest (ID, Artist, Title, Descrip, YR, Label, Format, Cat, Price GBP, Audio, Image, Stock) "&_
"VALUES ( " & id & "," &_
"'" & artist & "'," &_
"'" & title & "'," &_
"'" & descrip & "'," &_
yr & "," &_
"'" & label & "'," &_
"'" & format & "'," &_
"'" & catnumber & "'," &_
price & "," &_
"'" & audio & "'," &_
"'" & image & "'," &_
stock & ")"
Con.Execute sqlString **(LINE 50)**
%>
I have used response.write to get an output of the sql and it is absolutely fine:
INSERT INTO record_webtest (ID, Artist, Title, Descrip, YR, Label, Format, Cat, Price GBP, Audio, Image, Stock) VALUES ( 12234,'artist','title','desc',1224,'label','12inch','catnum' ,5.00,'audio','image',3)
can anyone advise me?
many thanks
mark
Edited by ainsworth14