Question: Passing Text Quotes into Sql Database

<i><b>Originally posted by : Phil D. (phild@cuttingedgemedia.com)</b></i><br />Hello All,<br /><br />I am trying to pass qoutes from an HTML form to a SQL database. The problem that I am experiencing is that the quotes truncate the text in when it is passed into the database. So far i have tried to use the Replace Function to no avail..<br /><br />ex.<br />tempSqlText = Replace(tempFormText,""","''")<br /> no go of course ...<br />also tried<br />tempSqlText = Replace(tempFormText,chr(39),"''")<br /> and this too did not work properly.<br /><br />does anyone have any other suggestions? Your help would be greatly appreciated.<br /><br />Thanks,<br />Regards,<br />Philip E. Deren<br />