[ic] Page scan SQL problems

Ian Riddler interchange-users@interchange.redhat.com
Mon Feb 4 07:28:01 2002


Hi guys,

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]

Can anyone tell me what's going on?
I'm sure it's something obvious I'm missing.

Its like the where clause isn't being evaluated, or something.

I'm intending to use a much more complex SQL query, by the way, this simple
example is where I ended up after 5 hrs of scanning archives and lots of
testing variations.

*brain fried*

Ian