[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] [query] tag has me dazed and confused
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
--
geek by nature, Linux by choice L I N U X .~.
The Choice /V\
http://www.ourmanpann.com/linux/ of a GNU /( )\
Generation ^^-^^
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users