[ic] Search definition question. Data-format-induced craziness.

[Ed LaFrance]

At 05:40 PM 6/24/2002 -0400, you wrote:
>I have a client who set up categories like:
>  Connectors
>  Connectors-Audio
>  Connectors-RF
>
>and so on.  Each has multiple subcategories.  The original code for pulling
>the subcategories out when a shopper clicked the category was:
>   [loop search="
>         st=sql
>         sf=category
>         se=[scratch catgy]
>         tf=subcategory
>         un=yes
>         rf=subcategory
>   "]
>
>However, for the plain Connectors category, it retrieved the subcategories
>for all categories beginning with "Connectors".  I tried every combination
>of search term, e.g., op=em (or op=eq em=yes - whichever it is) and ac=1 and
>so on and on and on.  Nothing worked.

When you tried op=eq or op=em, did you also add a co=yes to the search? My 
understanding (and generally my experience backs this up) is that co 
(mv_column_op) on works with coordinated searches (co), even if there is 
only one 'set' of terms.

- Ed L.



>Finally, I went to:
>   [query sql="select distinct subcategory from products where category =
>      '[scratch catgy]' order by subcategory" type=list]
>(with accompanying syntax changes in the loop) and it worked.  (This is IC
>4.8.1, and the tables are in mySQL.)
>
>So, it's just a curiosity at this point, but does anyone know how to make
>the loop type of search bring the same results as the query search?
>
>(I was about ready to change "Connectors" to "Connectors-Misc" which I'm
>pretty sure would work.  Come to think of it, that's probably what the
>client will do after they get everything sorted out!)
>
>Martin
>SecondStoreOnTheWeb
>SpeedSpan
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

===============================================================
Increase profits from your Interchange store...
http://www.newmediaems.com/cgi-bin/nm/software_fus.html
===============================================================
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
===============================================================