[ic] nuttyness with database select

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Fri Sep 6 09:24:02 2002


Quoting John Allman (allmanj@houseofireland.com):
> 
> [query arrayref=myref sql="select code,descrip,template from cattable 
> where code=252"]
> <!--body not used... -->
> [/query]
> [perl]
>         foreach $line (@$ary) {
>                 ($code,$descrip,$template) = @$line;
>                 $Scratch->{foundstuff}="yes";
>         }
> [/perl]
> did i find stuff?[scratch foundstuff] says i<br>
> 
> it just prints out "did i find stuff? says i"

If cattable is not in the same database as "products", then you
would need [query base=cattable ....]. Otherwise it should work.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

How far can you open your mind before your brains fall out?