[thelist] DB error

[David Mccreath]

Hi, Kevin --

You just need to use VBScript's Replace function to swap the single 
quotes for something valid.

here's a pretty decent explanation with an example:

http://www.devguru.com/features/knowledge_base/A100206.html

David

----- Original Message -----
From: "Kevin Stevens" <kjs at ratking.co.uk>
Date: Friday, July 13, 2001 2:11 pm
Subject: [thelist] DB error


> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing 
> operator) in
> query expression ''that's')'.
> 
> /gbook_entry.asp, line 284
> 
> The offending line in question is
> 
> set RSUdate = conn.execute ("insert into guests (name, email, message)
> values('"&(request.form("from"))&"', '"&(request.form("email"))&"',
> '"&(request.form("message"))&"')")
> 
> Any of you ASP bods out there know how to fix this?