On Wed, 28 Apr 2004 15:59:13 +0100 "Adrian P Wilkinson" <suppressed> wrote: > Hi, > > I'm trying to create a drop-down list that contains the only unique values > stored in the 'vendor' field (in the products table) for use on the advanced > search form, etc. > > ================================================================= > [loop search=" > fi=products > st=db > ra=yes > ml=100 > tf=vendor > to=x > " > option=vendor] > > [on-match]<SELECT NAME=vendor>[/on-match] > [list] > <OPTION VALUE="[loop-code]">[loop-pos 1] > [/list] > [on-match]</SELECT>[/on-match] > [no-match]<INPUT NAME=vendor VALUE="[value vendor]" SIZE=20>[/no-match] > [/loop] > ================================================================= > > The anticipated result is that it gives me a drop-down list in the form of: > > 3Com > Belkin > Hewlett Packard > Sony > (etc) > > The above effort is failing miserably - could someone point me in the right > direction? Take at look at the mv_unique search parameter, see the documentation for more information. Bye Racke -- LinuXia Systems => http://www.linuxia.de/ Expert Interchange Consulting and System Administration ICDEVGROUP => http://www.icdevgroup.org/ Interchange Development Team _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.