I need some help using single AND/OR double quotes in ASP. I have 3 pages, the first collects the info in a text box, the second page verifies that it is what the user wants and then passes it through hidden form fields to page 3 when the submit button is pressed. Page 3 will update a database (I DON'T need help with that). My problem is that I can use the "Replace" to either fix single quotes OR fix double quotes, but what happens when someone uses a combination of both? By the time the information reaches the third page, the single quotes have changed to double quotes and the double quotes have messed up the SQL. I need to be able to let a user input something like:
**Johnny's "First-Class" report**
in the text box and carry the same single and double quotes all the way through 3 pages and into the database. The demo pages I'm using can be seen at:
page 1 - [login to view URL]
page 2 - [login to view URL]
page 3 - [login to view URL]
The ASP code is printed on those pages so you can see what I'm doing. Any help will be appreciated.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP