[ic] One click search method. maybe I need some help
Danilo Ingami
danilo.ingami at poste.it
Mon Aug 18 12:13:31 EDT 2003
Hi Jonathan,
thanks for your help. In the mail I've write bebore there was an error
the right query is the same without the DISTINCT statement.
but I absolutely need to join the prodmods table. Is this impossible
vith the one click search?
thanks
danilo
Jonathan Clark wrote:
>>I choose to use the one click search method to build the list of the
>>articles linked from the main menu, this for improve the spider access
>>to the site.
>>So this is the standar sql query that I need to build the list of
>>articles for id_model 22 and id_scat 24.
>>Someone can help me to translate this query, if it is possible, in the
>>one click search syntax?
>>I does some try, (I paste the last one at the end of the mail), but
>>without success.
>>thanks in advance.
>>Danilo
>>
>>SELECT DISTINCT
>>`products`.`id_product`,`products`.`description`,`products`.`price`
>>FROM `products`,`prodmods`
>>WHERE prodmods.id_model = 22
>>AND `products`.`id_scat`= 24
>>AND `products`.`id_product` = `prodmods`.`id_product`
>>ORDER BY `products`.`id_product` ASC
>>
>>
>
>You can't get the DISTINCT in your searchspec or the join, but should be the
>rest. Do you really need the join to prodmods?
>
>First, its a coordinated search:
>
>co=1
>
>now, you need sets for each field:
>
>sf=id_model
>se=22
>to=n
>
>sf=id_scat
>se=24
>to=n
>
>sf is search field, se= search spec, to is search option (numeric in this
>case).
>
>Then we add the sort order:
>
>tf=id_product
>
>So, you get:
>
>[area search="
> co=1
> sf=id_model
> se=22
> to=n
> sf=id_scat
> se=24
> to=n
> tf=id_product"]
>
>Note: you don't need to specify the table as the default is to search the
>products table.
>
>Search reference:
>http://www.icdevgroup.org/i/dev/docfly.html?mv_arg=icdatabase06%2e11
>One-click searches:
>http://www.icdevgroup.org/i/dev/docfly.html?mv_arg=icdatabase06%2e07
>
>Jonathan.
>
>
>--
>Jonathan Clark
>Webmaint.com - Building Clever Websites http://www.webmaint.com/
>Webmaint.net - Business Web Hosting http://www.webmaint.net/
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users at icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
More information about the interchange-users
mailing list