-
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 doesnt...!! I laredy tried!! :mad:
-
-
how are you saving the data?
-
Oh it is working now.. sorry... it is so confusing....