[ic] Page scan SQL problems

interchange-users@interchange.redhat.com interchange-users@interchange.redhat.com
Mon Feb 4 12:19:01 2002


Does setting ra=no (don't return all) help anything?

[page scan
	st=sql
	sq="select * from products where sku = '1'"
	ra=no
]
	The Link
[/page]

> When I run this code, instead of returning the single product, I get all the
> products in the database returned.
> 
>     [page scan
>               st=sql
>               sq="select * from products where sku = '1'"
>      ] Sample Link
>      [/page]

-- 

Brev Patterson <bpatters@redhat.com>
red hat, inc.  reston office  design engineer  phone: (703)456-2955
website: http://www.brevpatterson.com  gpg uid: 0xC055B93C 
fingerprint: B1C7 2CC4 A401 82D0 D978 EDC5 A703 F64C C055 B93C
"this town don't feel mine, i'm fast to get away"