[ic] [query] tag has me dazed and confused

[Dan Browning]

At 01:57 PM 8/29/2001 -0400, you wrote:
>On Wed, Aug 29, 2001 at 10:14, Dan Browning wrote:
> > At 12:59 PM 8/29/2001 -0400, you wrote:
> > >On Wed, Aug 29, 2001 at 17:00, Jonathan Clark wrote:
> > > >
> > > > > When I access a page that consists of the following:
> > > > > ---------------------------------------------------
> > > > > <p>Testing sql query<br>
> > > > > [query sql="select * from products"]
> > > > > Result: [sql-code]<br>
> > > > > [/query]
> > > > >
> > > > > <p>Testing loop<br>
> > > > > [loop search="ra=yes/fi=products"]
> > > > >  [loop-code]<br>
> > > > > [/loop]
> > > > > ---------------------------------------------------
> > > >
> > > > How about this scenario:
> > > >
> > > >   using SQL db eg. MySQL.
> > > >   list of items in products.txt
> > > >   All items deleted from the SQL table?
> > >
> > >$ mysql tpe08 -e 'select sku from products'
> > >
> > >sku
> > >4600-HO
> > >B2040035
> > >30-10005
> > >7901
> > >PP-815
> > >10-10004
> > >10-10012
> > >2067
> > >30-10004
> > >10-10005
> > >30-10006
> > >30-10011
> > >C14000
> > >C14000AT
> > >C14024
> > >C14025
> > >C14099
> > >C15000
> > >C20000
> > >C20002
> > >00067
> > >
> > > > your [loop] tag list is using the products.txt without st=db?
> > >
> > >Nope, that ain't it.  :-(
> > >
> > >Cheers,
> > >  Pann
> >
> > Turn on your MySQL logging and see what's actually getting passed to the
> > database.  Also, try [sql-param sku] instead of [sql-code] just to see if
> > it helps.  HAND,
>
>010829 13:54:14      77 Connect    ratbert@localhost on tpe08
>                      77 Query      select * from products
>                      77 Quit
>
>Looks fine to me?
>
>And [sql-param sku] changes nothing.  :-(
>
>Cheers,
>  Pann

And nothing in the error logs either?

I'm sure it's something really simple staring us in the face.

How about trying a list-style for your query:

[query prefix=test list=1 type=list sql=|
         SELECT  *
         FROM    products
         ; | ]
         [no_match]
                 No matches<BR>
         [/no_match]
         [on_match]
                 Match!<BR>
         [/on_match]
         [list]
                 [test-param sku]
         [/list]
[/query]

HTH,

Dan Browning <danpb@mail.com>