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

[Dan Browning <db@cyclonehq.dnsalias.net>]

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