Problems with ' 2

[Gatorajc]

Anyone have the line of code to allow you to put in a ' into a database without erroring out. I seem to have misplaced mine.


AJ

 

[onpnt]

thread333-600736
Replace(MyString, "'", "''&quot

____________________________________________________
_{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-3811}

http://www.onpntwebdesigns.com

 

[vickero007]

' To replace ' in sql with ''
Private Function fix(x)
x = "" & x
if x<>&quot;&quot; then
fix = Replace(x, &quot;'&quot;, &quot;''&quot
else
fix = x
end if
End Function

-Volkoff007

 

[Gatorajc]

sqlString = &quot;INSERT INTO dailydata (Dte,tblDept_DeptID,TotDeptFte)&quot;
sqlString = sqlString & &quot; VALUES ('&quot; & datefield & &quot;','&quot; & department & &quot;','&quot; & totftescheduled & &quot;')&quot;

For some reason I can not get it to work
I either get a SQL syntax error or

Cannot use parentheses when calling a Sub

/HTMLpages/Web_Projects/AccountablityReport/enterdata3.asp, line 35

Replace(sqlString, &quot;'&quot;, &quot;''&quot




AJ

 

[Gatorajc]

Nevermind Thanks u 2

AJ

 

[Tarwn]

Note: Generally defining a function called fix is not a good idea since tere is already a built-in function called fix. I'm not to sure what effect this will have, but even if it works it will probably hurt efficiency as the system attempts to figure out which fix to use. If it uses scope of declaration to decide than you have lost the use of the built-in fix function since you have redeclard it.

Of course if you were using python...

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}

http://www.tiernok.com/

The never-completed website