SQL Insert Command Problem...

[ckay]

my problem is centered on the txtpdetails textbox section. Whenever a value with ' such as "It's a wonderful day" is type in the textbox and error occurs due to the quotation mark.

Is there anyway around this problem? Other than having to make the user go type "It''s a wonderful day" ?

s_sql = "Insert into " & s_tblname & (quot_no, prod_no, prod_details, prod_qty, prod_price, prod_amount)
values ('" & txtrefno & "','" & s_current & "','" & txtpdetails & "'," & txtqty & "," & s_curr & "," & s_curr2 & ")"
env.cnn.Execute s_sql

[john_murphy]

What you should do is change the ' to a " in the code then when they type a ' there is no problem. You should also check for a " in the text and replace it with a ' if one is typed.

Understand???

john_m_murphy@hotmail.com if not.

John Murphy
Co Galway
Republic of Ireland