syntax error when using " ' "

[guineamation]

Each time i'm using an inverted comma( " ' &quot inside a text submitted through a form i'm getting a syntax error message from the server. Any solution?

 

[onpnt]

thread333-577153

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[DreXor]

I have a general reference function SSI that i have on my servers, one of the fucntions is :

Function SQLQuotes(Str1)
If IsObject(str1) then
SQLQuotes = ""
ElseIf IsNull(Str1) then
SQLQuotes = ""
Else
SQLQuotes = Replace(Str1,"'","''&quot
End If
End Function

Then in Your Update or Query Statements where you're using references from recordsets or values from requested form elements etc...

SQL = "Update DB set field1='" & sqlquotes(request("ailment&quot) & "' where PrimID=" & Trim(Request("RecordID&quot)

Hope it helps

 

[vbkris]

guineamation:

when do u get the error? when using the database or simply while reading the values?

Known is handfull, Unknown is worldfull