numero = 52820
interpreted = N
texte = try this, might work... stranger things have happened...I'm assuming the reason you are searching the products database is becauseyou only want to show BRANDS of which you have products allocated too...otherwise there would be no need...----- Original Message ----- From: "Alan White" To: "WebDNA Talk" Sent: Friday, September 12, 2003 11:32 PMSubject: sorting...> Hi>> I have a menu that I need to sort alphabetically. The search is for alist> 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 thebrand.db> to find the name.>> The brands are coming out ok but I am having difficulty trying to sortthem,> 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:
try this, might work... stranger things have happened...I'm assuming the reason you are searching the products database is becauseyou only want to show BRANDS of which you have products allocated too...otherwise there would be no need...----- Original Message ----- From: "Alan White" To: "WebDNA Talk" Sent: Friday, September 12, 2003 11:32 PMSubject: sorting...> Hi>> I have a menu that I need to sort alphabetically. The search is for alist> 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 thebrand.db> to find the name.>> The brands are coming out ok but I am having difficulty trying to sortthem,> 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/
"Andrew Simpson"
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...