[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