[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cgi-list
Subject:    Re: [CGI] server push for text data
From:       Tommy Butler <tommy () atrixnet ! com>
Date:       2003-05-30 18:19:16
[Download RAW message or body]

Rhodes, Phillip C. wrote:
> You need to escape ticks...
> 
> I think you have to convert each tick  to 3 ticks.
> 
> ' -> '''
> 
> -----Original Message-----
> From: Richard Heintze [mailto:sieg_heintze@yahoo.com]
> Sent: Wednesday, May 21, 2003 8:52 PM
> To: CGI List
> Subject: RE: [CGI] server push for text data
> 
> 
> 
> I'm trying to use an SQL insert statement to insert a
> zero length string in to a record in a relation in a
> MS Access relational database, using the ODBC
> connection.
> 
> When I use '' (two consecutive apostrophies) it
> complains of a syntax error.

Try using the builtin function "quotemeta(string)".  It will correctly escape 
all characters for you.  If you are using DBI, use the "DBI::quote()" function.

-- 

   -Tommy Butler
    see if I'm online »http://ooopps.sourceforge.net/online

    Tommy Butler <tommy@atrixnet.com>
    phone: (817)-468-7716
    6711 Forest Park Dr
    Arlington, TX
         76001-8403

    Download my résumé in PDF, MS Word, HTML, text
    http://www.atrixnet.com/

    the ooOPps Code Library
    http://ooopps.sourceforge.net/pub/


--
To unusbcribe, send an email contining the words: 'unsubscribe cgi-list' to the \
following email address: majordomo@jann.com

Archives of the following mailing lists are available at: http://www.perl.jann.com/
the CGI Mailing List
the mod_perl mailing list
the embperl mailing list
Searching, browsing and posting are available at http://www.perl.jann.com/


[prev in list] [next in list] [prev in thread] [next in thread]