numero = 52822
interpreted = N
texte = If you are using WebDNA 5, you can append the found brand names into a [table], then search the table with alphabetical sorting to build your menu. Under WebDNA 4, you can do the same by writing to a temporary db and then searching and sorting that. But my preferred way, which would work in both environments and doesn't require the table or temp db overhead is this: [text]tBrandList=[/text] [search db=admin/products.db...BRANDsumm=T&rank=off][founditems] [text]tBrandList=[tBrandList] [BRAND][/text] [/founditems][/search] .... you now have a list of all the BRAND IDvalues in the text variable [tBrandList]. Search the brand.db for all these IDs with alpha sorting... - brian On Friday, September 12, 2003, at 04:32 AM, Alan White wrote: > 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 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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:
If you are using WebDNA 5, you can append the found brand names into a [table], then search the table with alphabetical sorting to build your menu. Under WebDNA 4, you can do the same by writing to a temporary db and then searching and sorting that. But my preferred way, which would work in both environments and doesn't require the table or temp db overhead is this: [text]tBrandList=[/text] [search db=admin/products.db...BRANDsumm=T&rank=off][founditems][text]tBrandList=[tBrandList] [BRAND][/text] [/founditems][/search] .... you now have a list of all the BRAND IDvalues in the text variable [tBrandList]. Search the brand.db for all these IDs with alpha sorting... - brian On Friday, September 12, 2003, at 04:32 AM, Alan White wrote: > 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 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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...