[thelist] DB error

[rudy]

> it threw an error which he suspected was due to the single quote
> he had used in an abbreviation.
>
>     Syntax error (missing operator) in query expression ''that's')'.
>
>set RSUdate = conn.execute ("insert into guests (name, email, message)
>values('"&(request.form("from"))&"', '"&(request.form("email"))&"',
>'"&(request.form("message"))&"')")


hi kev

i don't know asp but what you have to do is scan each string to be
inserted, and for every single quote inside the string, substitute two of
them

does asp have a replace function?

rudy