Re: SQL...INSERT INTO / Quotes Problem

by "Kevin Haidl" <kevinh(at)>

 Date:  Mon, 7 Feb 2000 10:58:06 -0800
 To:  "Shull,
Conrad" <cshull(at)>,
"Languages" <hwg-languages(at)>
 References:  ntmail1
  todo: View Thread, Original
I don't know ASP, but it's got to have some means of escaping quote
characters (and other meta-characters).  For MySQL you can either
double-tick: ''
backslash: \'
ASP must have an analogous convention (most likely backslash I bet).

Kevin Haidl
Act of Mind Communications
Web Assessment, Site Design, Site Production and Site Promotion
kevinh(at)     (604) 734-5098

----- Original Message -----
From: "Shull, Conrad" <cshull(at)>
To: <hwg-languages(at)>
Sent: February 7, 2000 8:19 AM
Subject: SQL...INSERT INTO / Quotes Problem

> I've seen several solutions to SELECT data from an Access database via ASP
> when the string contains an apostrophe (typically a name like O'Toole),
> am stumped on how to get past the problem when using INSERT INTO.
> __________________________________
> Conrad Shull
> Information Technology Associate
> Learning Resources Center
> Susquehanna Health System
> cshull(at)
> webmaster(at)
> 570.321.2266

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA