Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Jason Stajich <jason at chg dot mc dot duke dot edu>
Subject: Re: single quotes and perl
Date: Jan 12 2001 5:25PM

my $quotedfield = $dbh->quote($field);

On Fri, 12 Jan 2001, Tanja Davidson wrote:

> I've got a newbie perl programmer question.
> I've been using sybase::Ctlib to do my database connections and all has
> gone fine until I realized that there's a problem with single quotes if
> they exist in the text fields of my web forms.
> Can anyone give me a work around for inserting and searching on text
> variables which may have embedded single quotes?  
> The docs I've found so far have said to $var=~s/'/''/g but that ends up
> inserting two single quotes into my database which is unacceptable.  
> This should be a fairly simple question for any guru who has done much
> perl programming with sybase databases and the web.
> Thanks in advance!

Jason Stajich
Center for Human Genetics
Duke University Medical Center