PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Kiriakos Georgiou" <kiriakos dot georgiou at nrl dot navy dot mil>
Subject: RE: using sybperl, how to insert data that contains a quote with in it
Date: Jan 5 2001 4:54PM

DBI/DBD-Sybase has the very cool quote function so you can do things
like:
$dbh->do(sprintf "INSERT INTO table (a, b) values(%s, %s)",
$dbh->quote($a), $dbh->quote($b));

If sybperl lacks this function (I don't use sybperl) you probably want
to define your own and call it like above.

-Kiriakos


-----Original Message-----
From: owner-SYBPERL-L@list.cren.net
[mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of Michael Peppler
Sent: Friday, January 05, 2001 10:54 AM
To: SybPerl Discussion List
Subject: Re: using sybperl, how to insert data that contains a quote
with in it


Klein, Shoshana R writes:
 > Below is my sql statement to insert data into a table.
 > the variable $in_name  contains on occasion a single quote  for
example john
 > o'brien.

Double the quotes that you want to escape:

$in_name =~ s/'/''/g;

Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com