
March 21st, 2003, 08:56 AM
|
|
Junior Member
|
|
Join Date: Mar 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL/ASP syntax problem
Hi people,
I'm new to ASP/SQL 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.
Regards,
Neoxy
|