March 21st, 2003, 07:10 AM
ASP with SQL insert statements
I'm new to ASP and have a problem which I hope you can help me with.
Question 1: How can have th asp script automatically convert the date generated by the system to a format which is acceptable by Sybase SQL (yyyymmdd)
Question 2: If the user were to insert a a string containing " ' ", how can I convert it into a special character so that it won't be treated by Sybase SQL as the start/end of a variable?
I would really appreciate it if anyone could spare me some advice.
March 21st, 2003, 12:24 PM
Re: ASP with SQL insert statements
Try this site. It's been a HUGE help to me. This link answers your specific question.
This link (same site) uses the replace function. Just select your 'special character' carefully.
Hope This Helps ~ Dave
March 21st, 2003, 12:45 PM
Thanks Dave !!!