numero = 52830
interpreted = N
texte = You said your field is called THE_BRAND, then you written it wrongly in your search params just calling it BRAND, and that's why it's not sorting. [search db=admin/products.db&neTHE_BRANDdatarq=find_all[!] [/!]&grNO_INVENTORYdatarq=0[!] [/!]&THE_BRANDsumm=T&asTHE_BRANDsort=1] Regards, Tim > From: Alan White > Reply-To: (WebDNA Talk) > Date: Fri, 12 Sep 2003 12:32:10 +0100 > To: (WebDNA Talk) > Subject: sorting... > > Hi > > I have a menu that I need to sort alphabetically. The search is for a list > of brands available on our site but the brand is stored in the products.db > as a number in a field called THE_BRAND and a lookup is done on the brand.db > to find the name. > > The brands are coming out ok but I am having difficulty trying to sort them, > here is the code:- > > [search > db=admin/products.db&neBRANDdatarq=find_all&grNO_INVENTORYdatarq=0&BRANDsumm > =T&asBRANDsort=1] > > [/search] > > Any help appreciated... > > Thanks > Alan > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You said your field is called THE_BRAND, then you written it wrongly in your search params just calling it BRAND, and that's why it's not sorting. [search db=admin/products.db&neTHE_BRANDdatarq=find_all[!] [/!]&grNO_INVENTORYdatarq=0[!] [/!]&THE_BRANDsumm=T&asTHE_BRANDsort=1] Regards, Tim > From: Alan White > Reply-To: (WebDNA Talk) > Date: Fri, 12 Sep 2003 12:32:10 +0100 > To: (WebDNA Talk) > Subject: sorting... > > Hi > > I have a menu that I need to sort alphabetically. The search is for a list > of brands available on our site but the brand is stored in the products.db > as a number in a field called THE_BRAND and a lookup is done on the brand.db > to find the name. > > The brands are coming out ok but I am having difficulty trying to sort them, > here is the code:- > > [search > db=admin/products.db&neBRANDdatarq=find_all&grNO_INVENTORYdatarq=0&BRANDsumm > =T&asBRANDsort=1] > > [/search] > > Any help appreciated... > > Thanks > Alan > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Tim Robinson
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...