[ic] [sql] And now without html=1

Jurrie Overgoor interchange-users@interchange.redhat.com
Mon Dec 31 06:16:01 2001


Hello,

I'm having problems with my sql queries... (Yes, I did search this list for
an awnser before posting this.)

I have a query like this:
[query html=1 sql="select sku from klantproduct where username='[value
mv_username]'"]
This works perfectly, it displays exactly what I want, so the problem isn't
the query itself.

Now, I want to do this without the html=1 argument, so I can make a link to
the product page using the sku's.
I tried this:
[query sql="select sku from klantproduct where username='[value
mv_username]'"]
   [list]
      [sql-param sku]
   [/list]
[/query]

And this doesn't work (no output at all).

What am I doing wrong?? Please help, thanks in advance.

        Greetz -- Jurrie
        jurr@tref.nl