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