Insert Error

[imryn]

Hello Everyone,

I am getting an Insert error in my message board when ever a user tries to enter something like this " The email address is from for Kathy's email " the issue is the " ' " how can I fix this?

Thanks,
imryn

 

[DotNetGnat]

try replace function...something like this...

Replace(myfield,"'","''")..so that your string looks like this:

" The email address is from for Kathy''s email "

-DNG

 

[imryn]

Thank you by the way. Case Closed, I used php str_replace to due the work for me.

imryn