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. <br>Can anyone suggest some examples of this in use the documentation on RTFM is very sparse on these two fields it seems.<br>
<br>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.<br>
Graham Hadgraft <br><br><div class="gmail_quote">On Wed, Mar 18, 2009 at 2:32 PM, <span dir="ltr"><<a href="mailto:ic@3edge.com">ic@3edge.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5">graham hadgraft writes:<br>
<br>
> Im having trouble trying to perform a search. Im creating a search and i<br>
> need to do to clauses where products.description LIKE '%something%' and<br>
> variants.description LIKE '%something%'. Im using the search-region and<br>
> mv_searchspec parameters but i cant seem to get it to perform the search.<br>
><br>
> As far as i can tell from the interchange docs you suppose to reference<br>
> another table using the format table:field in the mv_search_fields parameter<br>
> but it does not seem to be searching using this.<br>
><br>
> I have the following search parameters.<br>
><br>
> mv_coordinate = 'yes'<br>
> mv_search_file = 'products'<br>
> mv_searchtype = 'db'<br>
> mv_return_fields = 'sku, description, prod_group, category, option_type,<br>
> manufacturer, comment, rrp, price'<br>
> mv_sort_field = 'category, manufacturer, price, description'<br>
> mv_sort_option = 'f,f,n,f'<br>
><br>
> mv_search_field = 'prod_group'<br>
> mv_column_op = 'rm'<br>
> mv_search_spec = 'something'<br>
><br>
> mv_search_field = 'variants:description'<br>
> mv_column_op = 'rm'<br>
> mv_search_spec = 'something'<br>
><br>
> As i said this does not seem to match the desired results the equivalent sql<br>
> query for this would be:<br>
><br>
> SELECT p.sku, p.description, p.prod_group, p.category, p.option_type,<br>
> p.manufacturer, p.comment, p.rrp, p.price<br>
> FROM products AS p, variants AS v<br>
> WHERE v.sku = p.sku AND p.prod_group LIKE '%something%' AND v.description<br>
> LIKE '%something%'<br>
> ORDER BY category, manufacturer, price, description<br>
><br>
> Unfortunatly for certain resons i can not use query i have to uise the<br>
> search-region. What is wrong with the search parameters i am adding.<br>
><br>
> Graham<br>
<br>
</div></div>Did you look at mv_like_field (lf) and mv_like_spec (ls) ?<br>
<br>
CU,<br>
<br>
Gert<br>
<div><div></div><div class="h5"><br>
<br>
<br>
_______________________________________________<br>
interchange-users mailing list<br>
<a href="mailto:interchange-users@icdevgroup.org">interchange-users@icdevgroup.org</a><br>
<a href="http://www.icdevgroup.org/mailman/listinfo/interchange-users" target="_blank">http://www.icdevgroup.org/mailman/listinfo/interchange-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>====================================<br><a href="http://www.8bitscraps.co.uk">http://www.8bitscraps.co.uk</a> - Tech Tips & tools<br>