Re: SQL...INSERT INTO / Quotes Problem

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: ''
or
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)actofmind.com     http://www.actofmind.com     (604) 734-5098


----- Original Message -----
From: "Shull, Conrad" <cshull(at)shscares.org>
To: <hwg-languages(at)hwg.org>
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),
but
> am stumped on how to get past the problem when using INSERT INTO.
>
> __________________________________
> Conrad Shull
> Information Technology Associate
> Learning Resources Center
> Susquehanna Health System
> www.shscares.org
> cshull(at)shscares.org
> webmaster(at)shscares.org
> 570.321.2266
>

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