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

Pann McCuaig interchange-users@interchange.redhat.com
Wed Aug 29 16:06:00 2001


On Wed, Aug 29, 2001 at 20:22, Jonathan Clark wrote:
> > That works! See two attached files (and then tell me why, please).
> >
> > And here is the log entry:
> >
> > 010829 15:00:25      87 Connect    ratbert@localhost on tpe08
> >                      87 Query      select * from products
> >                      87 Query      select * from products
> >                      87 Query      SELECT  *
> >          FROM    products
> >          ;
> >                      87 Quit
> >
> [snip]
> > >
> > > [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]
> 
> there are a couple of differences:
> 
> type=list, but this is the default..
> 
> use of [list] tags, which I suspect is the _real_ reason - I still use the
> [sql query=] format, which doesnt seem to need these (but doesn't allow
> [no_match] etc.
> 
> 
> So, I recon that:
> 
> <p>Testing sql query<br>
> [query sql="select * from products"]
> [list]
> Result: [sql-code]<br>
> [/list]
> [/query]
> 
> should work..

Alas, it does not. Same (blank) result.

Cheers,
 Pann
-- 
geek by nature, Linux by choice                     L I N U X       .~.
                                                    The Choice      /V\
http://www.ourmanpann.com/linux/                     of a GNU      /( )\
                                                    Generation     ^^-^^