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: charmanp at bolon dot uk dot ml dot com (Paul Charman "LADS" X8283)
Subject: Re: Using an array in SQL
Date: Jul 31 1998 3:31PM

I do it something like this

map { $_ = "'$_'" } @array ; #put quotes round each item
$db->sql("select * from table where name in (" . join(',', @array) . ")" ) ;