[ic] Search How to pass Where Clause Conditions

[Dan Browning]

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,      <dan.browning@kavod.com> |
| 6700 NE 162nd Ave, Suite 210, Vancouver, WA (360) 843-4074 x217 |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
First Law of Socio-Genetics:
         Celibacy is not hereditary.