' Causing an Error On a String Field

[ctau]

I am using a string field to allow the user to type in a description of their problem, but if they try to include a single quote in this field they receive an error. Is there anyway to fix this problem without removing the ' from the field?

 

[wushutwist]

You have to check the field for either ' or " and replace them with /' and /" . They will be inserted into the DB as ' and ".

Use a function similar to this:

' Replace Quotes Function
Function RQ(string_value)
  string_value = Replace(string_value,"'","/'")
  string_value = Replace(string_value,"""","/""")
  RQ = string_value
End Function

Wushutwist

 

[culshaja]

Try this, its a much more efficient solution, and a great way of using ADO.

set cmInsert as Server.CreateObject("ADODB.Command")
set cmInsert = cnDB 'your connection object
cmInsert.CommandType = 1
cmInsert.CommandText = "INSERT INTO myTable (Name) VALUES (?)"
cmInsert.Parameters.Append cmInsert.CreateParameter("Name",200,1,,myVar)
cmInsert.Execute

This can also be set to be prepared and so will become a temporary stored procedure.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[luciddream]

i thought you delimit ' with '' and " with ""? adam@aauser.com

 

[wushutwist]

Escape sequence in Oracle(what I use) is /.


Wushutwist