Re: Searching a database...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
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:
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] [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:
[WebDNA] Code Library (2013)
If Empty ? (1997)
Paranoid about serial numbers...not (1998)
WebMerchant - MacAuthorize (1999)
BadSuffix with 2.1b3 cgi (1997)
Bug or syntax error on my part? (1997)
Remove me from your list immeadiately (1998)
SET-payment (2000)
Not really WebCat (1997)
Generating Report Totals (1997)
Summary search -- speed (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Not really WebCat (1997)
select multiple (1997)
What am I missing (1997)
A workaround for handling date range search in yyyy/mm/dd form (1997)
[WriteFile] problems (1997)
Webcat no longer supported? (2006)
2.0Beta Command Ref (can't find this instruction) (1997)
error: Too many nested [xxx] contexts (1997)