[ic] Variants table and mv_searchspec

[graham hadgraft]

Thank you i had not seen the mv_like_field, and mv_like_spec they certainly
sound like they may be useful for what i need.
Can anyone suggest some examples of this in use the documentation on RTFM is
very sparse on these two fields it seems.

In regards to Stefan Hornburg the reason for me want to use the search
region and search parameters, is that i am adding a feature to an already
existing site heavily reliant on these.  I do not want to recode the pages i
am adding the feature to as it is likely that i may miss something which is
reliant on what already shows.
Graham Hadgraft

On Wed, Mar 18, 2009 at 2:32 PM, <ic at 3edge.com> wrote:

> graham hadgraft writes:
>
> > Im having trouble trying to perform a search.  Im creating a search and i
> > need to do to clauses where products.description LIKE '%something%' and
> > variants.description LIKE '%something%'.  Im using the search-region and
> > mv_searchspec parameters but i cant seem to get it to perform the search.
> >
> > As far as i can tell from the interchange docs you suppose to reference
> > another table using the format table:field in the mv_search_fields
> parameter
> > but it does not seem to be searching using this.
> >
> > I have the following search parameters.
> >
> > mv_coordinate = 'yes'
> > mv_search_file = 'products'
> > mv_searchtype = 'db'
> > mv_return_fields = 'sku, description, prod_group, category, option_type,
> > manufacturer, comment, rrp, price'
> > mv_sort_field = 'category, manufacturer, price, description'
> > mv_sort_option = 'f,f,n,f'
> >
> > mv_search_field = 'prod_group'
> > mv_column_op = 'rm'
> > mv_search_spec = 'something'
> >
> > mv_search_field = 'variants:description'
> > mv_column_op = 'rm'
> > mv_search_spec = 'something'
> >
> > As i said this does not seem to match the desired results the equivalent
> sql
> > query for this would be:
> >
> > SELECT p.sku, p.description, p.prod_group, p.category, p.option_type,
> > p.manufacturer, p.comment, p.rrp, p.price
> > FROM products AS p, variants AS v
> > WHERE v.sku = p.sku AND p.prod_group LIKE '%something%' AND v.description
> > LIKE '%something%'
> > ORDER BY category, manufacturer, price, description
> >
> > Unfortunatly for certain resons i can not use  query i have to uise the
> > search-region. What is wrong with the search parameters i am adding.
> >
> > Graham
>
> Did you look at mv_like_field (lf)  and mv_like_spec (ls)  ?
>
> CU,
>
> Gert
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>



-- 
====================================
http://www.8bitscraps.co.uk  -  Tech Tips & tools
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.icdevgroup.org/pipermail/interchange-users/attachments/20090318/e2a53228/attachment.htm