Re: Another ODBC/SQL question

Article View: comp.lang.perl.misc

Article #69

Back to comp.lang.perl.misc Previous Next

#69

From: Glenn Euloth
Date: Wed, 30 Oct 1996 00:00

17 lines
1261 bytes

In article <32719a0a.23151825@news.netvision.net.il>, yossik@accentsoft.com 
says...
>
>Ok, I solved the first problem, it was a problem that
>ServiceRecords.Status='ON' only receives 1 and 0 and QueryId should be
>compared to a number without the quotes.
>
>Still waiting fo help on number 2 (entering a single quote in a text
>field using SQL).
>
One solution I found, not perl specific but SQL specific, and I haven't tried 
it in perl is to double up the single quote.  ie:

INSERT INTO TABLE test (last_name = 'O''Brien');

Good Luck

Technical Details

Message-ID: <5584a3$kk5@news.nstn.ca>

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: fa0ae,5d3951a8a6107760
X-Google-Attributes: gidfa0ae,public
X-Google-Thread: f6611,5d3951a8a6107760
X-Google-Attributes: gidf6611,public
From: eulothg@gov.ns.ca (Glenn Euloth)
Subject: Re: Another ODBC/SQL question
Date: 1996/10/30
Message-ID: <5584a3$kk5@news.nstn.ca>
X-Deja-AN: 193236386
references: <54nomb$j88@news.NetVision.net.il> <32719a0a.23151825@news.netvision.net.il>
content-type: Text/Plain; charset=US-ASCII
organization: Nova Scotia Gov't
mime-version: 1.0
newsgroups: comp.lang.perl.misc,comp.lang.perl.modules,bit.databases.mssql-l

Reply to Parent Message