RE: Sql in Perl!!

["Mike Wolf" <mdwolf@okdirectpets.com>]

Are you getting an error of some sort or it does not return any information
(SQL return code = 100 ; no information matching your query was found). It
looks like you are trying to find the string $cod and probably the database
column code is a number.  Try

where code = " , $cod [/sql]


Mike Wolf
Orchard Kennels, Inc
You source for pet supplies, all natural treats.
http://www.okdirectpets.com

 -----Original Message-----
From: 	owner-minivend-users@minivend.com [mailto:shahed@avalanche.bc.ca]  On
Behalf Of Shahed Khalili
Sent:	Friday, June 18, 1999 7:17 PM
To:	'minivend-users@minivend.com'
Subject:	Sql in Perl!!

Hi All

I'm trying to write sql tags in [perl]. can someone tell me why this doesn't
work??

$html .= join '' , "[sql type=array]select description from products where
code ='" , $cod "'[/sql]";

$html
[/perl]


thanks

winmail.dat