[ic] Not able to retrieve fields from custom table
john-rennie at thechampagneshop.co.uk
Wed May 12 14:05:46 EDT 2004
> -----Original Message-----
> From: interchange-users-bounces at icdevgroup.org
> [mailto:interchange-users-bounces at icdevgroup.org] On Behalf
> Of Tim Good
> Sent: 12 May 2004 18:35
> To: interchange-users at icdevgroup.org
> Subject: [ic] Not able to retrieve fields from custom table
> Hello list,
> First sorry for the double post previously, I was not sure
> which email address was setup. I did not get a response to
> my first post so I am reposting with a more specific
> Why would this code not work?
> [perl table='delivery_schedule']
> $Tag->data("delivery_schedule", "charge", "[loop-data
> transactions order_number]"); [/perl]
> (mysql 3.23.58 on Redhat 8.0 non threaded perl 5.8.2 interchange 5.2
> All help is much appreciated.
You don't say exactly what 'not work' means, so this is a guess...
>From the interchange rtfm tags reference, perl tags are not interpolated
by default. So
[perl table='delivery_schedule' interpolate=1]
$Tag->data("delivery_schedule", "charge", "[loop-data
transactions order_number]"); [/perl]
should work better.
You might also want to switch to single quotes within your perl, to avoid
the risk of any interpolation (e.g. \n or $) of your data (unlikely with
an order number, but you may have an odd format).
More information about the interchange-users