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

[Pann McCuaig]

And here's the mysql.log entry after I added st=db to the loop search:

010829 14:19:46      84 Connect    ratbert@localhost on tpe08
                     84 Query      select * from products
                     84 Query      select * from products 
                     84 Quit      

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,
> 
> Dan Browning <danpb@mail.com>
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> 

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