Re: [ic] Search How to pass Where Clause Conditions

[Dan Browning <suppressed>]

At 09:23 PM 2/24/2003 -0500, you wrote:

> How to I qualify the search used in include/checkout/shipping_address?
>
> The country name search as coded in shipping_address is:
>                   [loop option=country search="
>                         ra=yes
>                         fi=country
>                         st=db
>                         rf=code,name

Add the following:

        sf=active
        op=eq
        se=yes

>                         ml=1000
>                         tf=name
>                   "]
> Produces the query "select * from country".
>
> I would like to know how to modify shipping_address to
> produce the query "select * from country where active = 'yes'"
> I've added the data base field active to the country table.
>
> Your help would be greatly appreciated.

It's in the docs, BTW.

--
/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies,      <suppressed> |
| 6700 NE 162nd Ave, Suite 210, Vancouver, WA (360) 843-4074 x217 |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
First Law of Socio-Genetics:
        Celibacy is not hereditary.

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users