Colums

I know this has been answered quite a few times, but I cant find it with the search. SO here it goes AGAIN.....

I want to save this text in my database

I'll go


but since it has the ' it sends me an error. I did the replace(str,"'","''") but that saves i''l go and I dont want that... I want I'll go

how can I do this?

Code:

---


myStr=replace(myStr, "'", "''")

'for you understanding same thing but with extra spaces

'replace(myStr," ' ", " ' ' ")

---

yeah but that will save '' in the database.. I just want one.. '

like this I'll go
not... I''ll go

??

It will save just one '.

it doesnt...!! I laredy tried!! :mad:

why is this happening?

how are you saving the data?

Oh it is working now.. sorry... it is so confusing....