[ic] Multistage search page

Ed LaFrance interchange-users@lists.akopia.com
Wed Aug 1 16:15:01 2001


At 01:54 PM 08/01/2001 -0400, you wrote:
>Is there a tag that can be used in a scan only certain item numbers?
>
>Page 1 says look for all items by color (picked BLUE)
>it returns items 123, 456, 789, 101, 121 ,314
>on page 2 it wants to know size (we pick Medium)
>this scans for Medium in the items 123, 456, 789, 101, 121 ,314
>and returns like... 123, 789, 121
>on page 3 wants to know style (we pick cotton)
>this scans for cotton in 123, 789
>keeps going.
>
>I cannot seem to find a tag to do this where you say
>
>scan/sf=style/se=cotton/"scanitems"=123, 789/
>
>Was just thinking this could be a solution for my "range searching" 
>problem i've posted for in the past.
>
>Ven

Ven -

I have gotten a little better at coordinated searches since the last time I 
replied to one of your posts on the subject; try this:

[page scan=
         st=db
         co=yes
         sf=color
         se=BLUE
         op=rm
         sf=size
         se=Medium
         op=rm
         sf=style
         se=cotton
         op=rm
]Search</a>

...Basically, I follow these rules with coordinated searches
1. If 'op' (mv_column_op) is needed for one spec, it must be used for all
2. Ditto for 'nu' (mv_numeric)
3. Even if the mv_search_file (sf) is not products, fully qualify each 'sf' 
for a non-products field with tablename:fieldname.  Example:

[page scan
         fi=inventory
         st=db
         co=yes
         sf=color                #IC will search the 'color' field in the 
products table
         se=BLUE
         op=rm
         nu=0
         sf=inventory:quantity
         se=1
         op=>=
         nu=1
]blue items in stock</a>

...a contrived example, but I think you get the idea.

- Ed L.




>_______________________________________________
>interchange-users mailing list
>interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================