Re: Another ODBC/SQL question

Article View: comp.lang.perl.misc

Article #66

Back to comp.lang.perl.misc Previous Next

#66

From: Glenn Stanton
Date: Fri, 25 Oct 1996 00:00

21 lines
1523 bytes

Yossi Konijn wrote:
>> Oh, and while on the subject, does anyone know what
>> escape sequence I should use to send a single-quote
>> to a text field? I'm trying to type 'Can't' but the
>> quotes are confusing Access.

it seems to be a real problem for the ODBC "JetEngine".
Since most of my work involves the WWW I simply replace
them with an ISO equiv. value which is rendered as
a single quote:

$somevar =~  s/\'/\&\#146\;/g;

obviously this isn't the solution for non-WWW results.
for reports I have a script that simply reverses this
(and some other stuff...) 

-- 
///////////////////////////////////////////////////////////
// Glenn Stanton                            gms@lucent.com

Technical Details

Message-ID: <3270BBE6.5390@lucent.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <54nomb$j88@news.NetVision.net.il> <32719a0a.23151825@news.netvision.net.il>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f591,5d3951a8a6107760
X-Google-Attributes: gid10f591,public
X-Google-Thread: f6611,5d3951a8a6107760
X-Google-Attributes: gidf6611,public
X-Google-Thread: fa0ae,5d3951a8a6107760
X-Google-Attributes: gidfa0ae,public
From: Glenn Stanton <gms@lucent.com>
Subject: Re: Another ODBC/SQL question
Date: 1996/10/25
Message-ID: <3270BBE6.5390@lucent.com>
X-Deja-AN: 191986560
references: <54nomb$j88@news.NetVision.net.il> <32719a0a.23151825@news.netvision.net.il>
to: Yossi Konijn <yossik@accentsoft.com>
content-type: text/plain; charset=us-ascii
organization: Lucent Technologies
mime-version: 1.0
reply-to: gms@lucent.com
newsgroups: comp.lang.perl.misc,comp.lang.perl.modules,bit.databases.mssql-l
x-mailer: Mozilla 3.0Gold (Win95; I)

Reply to Parent Message