Re: Searching a database...
This WebDNA talk-list message is from 2003
numero = 50549
interpreted = N
texte = Here are what I will use:
[search db=admin/ products.db&neCATEGORYdata=&CATEGORYsumm=T&CATEGORYsort=1][founditems] [CATEGORY] [search db=admin/category.db&eqCATEGORYdata=[CATEGORY]&CATsort=1][founditems] - [CAT] [/founditems] [/founditems][/search] Le mercredi, 21 mai 2003, à 17:26 Europe/Paris, Alan White a écrit :> Hi Everyone > > I am currently trying to add additional search features to our site > and am > trying to figure out how to make a menu that pulls out only the > Categories > (i.e.. footwear etc) that are in the products database and have an > inventory > of > 0. > > I haven't even tried to get the if inv > 0 working yet as it is the > next > task, all I want to be able to do at the moment is pull out the > available > categories and I should be able to do a lot of what I am trying to get > done > (here's hoping anyway). > > My products db is like follows:- > > ID SKU ... ... ... BRAND CATEGORY ... ... etc > 1 blah 8 3 > > I have a Categories database which is just :- > > ID CAT > 1 Footwear > 2 Accessories > etc > etc > > I have successfully pulled all of the categories into a menu using the > categories.db but then I realised this wasn't a very good idea as you > may > not have product in each category. > > This is the code I used:- > > ---------------------------------------------------- > > [search db=admin/category.db&neIDdatarq=find_all&CATEGORYsort=1] > >
> Category > [founditems] > value=results.html?cart=[cart]&the_CAT=[ID]&search_type=_CAT&RA=[rando > m][ra > ndom][random]>[CAT] > [/founditems] > [/search] > > ---------------------------------------------------- > > I know I have to use something similar to:- > > [search db=admin/products.db&neCATEGORYdatarq=find_all&CATEGORYsumm=T] > > Followed by a nested lookup in my search results to get the Category > title > and display it but I'm afraid I'm getting a little lost. > > Hope someone can help... > > Alan > ------------------------------ > http://www.streethreds.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/ > > ------------------------------------------------------------- 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: [search db=admin/ products.db&neCATEGORYdata=&CATEGORYsumm=T&CATEGORYsort=1][founditems] [CATEGORY] [search db=admin/category.db&eqCATEGORYdata=[CATEGORY]&CATsort=1][founditems] [cart]&the_CAT=[ID]&search_type=_CAT&RA=[random ][random] [random] > - [CAT] [/founditems] [/founditems][/search] Le mercredi, 21 mai 2003, à 17:26 Europe/Paris, Alan White a écrit :> Hi Everyone > > I am currently trying to add additional search features to our site > and am > trying to figure out how to make a menu that pulls out only the > Categories > (i.e.. footwear etc) that are in the products database and have an > inventory > of > 0. > > I haven't even tried to get the if inv > 0 working yet as it is the > next > task, all I want to be able to do at the moment is pull out the > available > categories and I should be able to do a lot of what I am trying to get > done > (here's hoping anyway). > > My products db is like follows:- > > ID SKU ... ... ... BRAND CATEGORY ... ... etc > 1 blah 8 3 > > I have a Categories database which is just :- > > ID CAT > 1 Footwear > 2 Accessories > etc > etc > > I have successfully pulled all of the categories into a menu using the > categories.db but then I realised this wasn't a very good idea as you > may > not have product in each category. > > This is the code I used:- > > ---------------------------------------------------- > > [search db=admin/category.db&neIDdatarq=find_all&CATEGORYsort=1] > > > Category > [founditems] > value=results.html?cart=[cart] &the_CAT=[ID]&search_type=_CAT&RA=[rando > m][ra > ndom][random] >[CAT] > [/founditems] > [/search] > > ---------------------------------------------------- > > I know I have to use something similar to:- > > [search db=admin/products.db&neCATEGORYdatarq=find_all&CATEGORYsumm=T] > > Followed by a nested lookup in my search results to get the Category > title > and display it but I'm afraid I'm getting a little lost. > > Hope someone can help... > > Alan > ------------------------------ > http://www.streethreds.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/ > > ------------------------------------------------------------- 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/
Laurent Bache
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List 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...
Related Readings:
Timeout question .. (2003) [WebDNA] Is WebDNA slowing things up - please try these URL's (2013) Template Encryption (1998) WC2f3 (1997) ftp to webstar (2001) Size images (2002) Need WebDNA that crashes server for testing (2000) Serial Numbers (2000) [item] appears after 'remove last item' ... (1997) Associative lookup style? + bit more (1997) Great product and great job ! (1997) A multi-processor savvy WebCatalog? (1997) Storebuilder, Smith-Micro Tech Support (2000) Emailer Erreur 551 (2001) target=_blank and form variables (1997) Problems getting parameters passed into email. (1997) Emailer setup (1997) About to give up (1998) PhotoMill -> PhotoMaster (1997) Running 2 two WebCatalog.acgi's (1996)