Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 cleaning up the work of php
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sogoth
New Member

United Kingdom
73 Posts

Posted - 20 June 2001 :  15:13:46  Show Profile  Visit sogoth's Homepage
Hi

my site used to be written in php, but recently my server upgraded and now supports Chilisoft asp which makes my life a lot easier, but my database has a legacy problem from it's php background.

any ' or " symbol is prefixes with a slash thanks to PHP's built in addslash routine. This wasn't a problem as it also had a remove slash routine. The problem lies in the fact that I now have a database full of these things and I can't work out how to remove these slashes with ASP.

any help would be absolutely fantastic

thanks
Paul

inworg
Junior Member

Italy
153 Posts

Posted - 20 June 2001 :  19:32:01  Show Profile  Visit inworg's Homepage
try

MyString=Replace(MyString,"\'","'")
MyString=Replace(MyString,"\""","""")

The first replaces \' with '
the second one \" with "

bye

Go to Top of Page

sogoth
New Member

United Kingdom
73 Posts

Posted - 21 June 2001 :  02:58:46  Show Profile  Visit sogoth's Homepage
That worked brilliantly, thanks :)

Paul

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 2.5 seconds. Powered By: Snitz Forums 2000 Version 3.4.07