[ic] [more] / [more-list] Alpha Numeric

Mike Heins interchange-users@interchange.redhat.com
Tue Oct 9 17:10:01 2001


Quoting Brian Kosick (briank@nacs.net):
> Here's my code:
> [query list=1 ml=50 more=1 st=db ma=yes mc=1 
> rf=p.code,p.name,p.short_desc,p.price,p.qty,p.new_plant,p.disc tf=p.name sql=|
>          SELECT p.code, p.name, p.short_desc,
>          p.price, p.qty, p.new_plant, p.avail,
>          p.disc, z.zone
>          FROM products AS p, zip_zone AS z
>          WHERE z.zip = '[value search_zip]'
>          AND p.zones ~ z.zone
>          AND p.disc != '0'
>          ORDER BY p.name;
>          |
> ]
> 
> I've tried putting the rf values in double quotes and single quotes, I've 
> added and removed the "p."

If you have p.anything, it will break stuff. It should always not be
there except in the query itself. This is documented.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Prove you aren't stupid.  Say NO to Passport.