replace function in asp/vbscript

[scroce]

here's some code. After reading some of the other postings, I think I understand it. I'm just looking for some clarification from someone who knows better than I:

sRegion = Replace(Session("Region&quot, "'", "''&quot
sBranch = Replace(Session("Branch&quot, "'", "''&quot
sBuilding = Replace(Session("Building&quot, "'", "''&quot
sStreetAddress = Replace(Session("StreetAddress&quot, "'", "''&quot

What I think this is doing is a check on the session variables called Region, Branch, Building, and Street Address. If there are any single apostrophes in the aforementioned variables (which incidentally are pulled from a database), then this code replaces them with an extra ' in order to prevent errors. Am I accurate?

thanks. How much water would there be in the ocean if it weren't for sponges?

 

[vasah20]

you are correct.

 

[JohnYingling]

The "errors" I think only occur in data base operations using that data in an SQL statement with a clause like WHERE followed by data conatining a sigle quote. If it is in data itself it should not cause a problem or be "doubled".

http://WWW.VBCompare.Com

 

[scroce]

thank you! How much water would there be in the ocean if it weren't for sponges?