Re: [mv] [perl] question

["Mr. Christopher F. Miller" <cfm@maine.com>]

On Mon, Nov 22, 1999 at 01:01:27AM -0700, Mike Gross wrote:
> 
> foreach $itemcode (@related_products) {
>    my $productdescriptionhash=<<'EOF';
>    [sql type=hash][arg]$itemcode[/arg]select description from products
> where product_id = %s[/sql]
> EOF

Did you try:
 [sql type=hash]select description from products where product_id ='[item-code]'[/sql]

The [item-code] is usually early enough in order of precedence.
> 
> The problem is that the sql query is processed to be:
> 
> select description from products where product_id = $itemcode
> 
> where $itemcode is literaly $itemcode instead of the value of $itemcode.


-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.