Apostrophe problems!! 1

[mattys]

I am aware that this is quite a common problem.

I am updating info from a form textfield, info sourced from the database using this code in the head

Conn.Execute ("UPDATE Property SET Property.PropertyInfo='" & Request.Form("PropertyInfo") & "' " & strWhereClause )

and this code to call the info into textfield

<%=RS(&quot;PropertyInfo&quot;)%>

I am aware that there is a fix of how to overcome the sql apostrophe problem, but not sure how to integrate into my code.

Any help appreciated!

Matt

 

[onpnt]

Conn.Execute ("UPDATE Property SET Property.PropertyInfo='" & Replace(Request.Form("PropertyInfo&quot,"'","''&quot & "' " & strWhereClause )

http://www.4guysfromrolla.com/webtech/051899-1.shtml

_____________________________________________________________________

_{Hakuna matata!!}

 

[mattys]

That worked a treat, thanks!