[ic] Need help with a perl query

Peter peter at pajamian.dhs.org
Tue May 26 02:44:12 UTC 2009


On 05/25/2009 07:04 PM, Mark Lipscombe wrote:
> The problem is most likely you're missing quotes around $lookup, 
> something like:
> 
> my $ary2 = $db2->query('select sku from orderline where code like 
> "$lookup");

SQL uses single quotes, also you need to double quote the string for
$lookup to be interpolated, so:
my $ary2 = $db2->query("select sku from orderline where code like
'$lookup'");

...other than that, Mark's advice is correct.


Peter




More information about the interchange-users mailing list