Re: [WebDNA] Search Question

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103278
interpreted = N
texte = Started from scratch on a clean page. It must have had something to do with the directory.db being a sub-search for the cat-directory.db search.

Featured Businesses

[Search db=[REL_ROOT_DIR]data/ directory.db&eqDAT_FEATdata=T&asDAT_BUSINESSsort=1&asDAT_BUSINESStype=te xt] [Founditems]
[DAT_BUSINESS]
[DAT_DESCRIPTION]  [HideIf DAT_WEBSITE=]Visit Site[/HideIf]
 
[/Founditems] [/Search] This seems to be working. Thanks for the ideas. Tony Miller tmiller@thehawkeye.com On Aug 17, 2009, at 11:24 AM, Kenneth Grome wrote: > Spelling error: &eqDAT_FEATdataarq > You might also have to add "&allblnk=T" > > Sincerely, > Ken Grome > > > >> All, >> >> I am trying to select records in the directory.db that >> have a value of 'T' in the DAT_FEAT field. It is giving >> me all the entries in the category regardless of what the >> DAT_FEAT is set to. I've looked at the docs, but I must >> be missing something simple. >> >> Here's the code: >> >> [Search db=[REL_ROOT_DIR]data/ >> cat_directory.db&eqCAT_VISIBLEdata=T&asCAT_IDsort=1&CAT_I >> Dtype=number] There are [numfound] records >> [Founditems] >> >>
>>

[CAT_TITLE]

>> [Search >> db=[REL_ROOT_DIR]data/directory.db&eqDAT_CAT_IDdatarq=[CA >> T_ID] >> &eqDAT_FEATdataarq=T&asDAT_BUSINESSsort=1&asDAT_BUSINESSt >> ype=text] [Founditems] >>
> alt=" " width="64" height="64" class="left" >> />[DAT_BUSINESS]
>> [DAT_DESCRIPTION]
>> >>
>> [/Founditems] >> [/Search] >> >> Thanks in advance. >> >> Tony Miller >> >> OS X.4.11 Server >> Commerce Edition 6.0a >> Site is a SiteBuilder site >> >> WebDNA server is running as root >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: >> http://forum.webdna.us/eucabb.html?page=topics&category=2 >> 88 > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html? > page=topics&category=288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search question (frank@cwolfe.com 2013)
  2. Re: [WebDNA] Search question ("Terry Wilson" 2013)
  3. RE: [WebDNA] Search question ("Terry Nair" 2013)
  4. Re: [WebDNA] Search question (Lawrence Banahan 2013)
  5. [WebDNA] Search question (frank@cwolfe.com 2013)
  6. Re: [WebDNA] Search question (Steve Craig 2012)
  7. Re: [WebDNA] Search question (Toby Cox 2012)
  8. Re: [WebDNA] Search question (Steve Craig 2012)
  9. Re: [WebDNA] Search question (Steve Craig 2012)
  10. Re: [WebDNA] Search question (Toby Cox 2012)
  11. [WebDNA] Search question (Steve Craig 2012)
  12. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  13. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  14. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  15. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Kenneth Grome 2011)
  16. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  18. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  20. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  21. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  22. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  23. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  24. Re: [WebDNA] SEARCH question (Kenneth Grome 2011)
  25. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  26. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  27. Re: [WebDNA] SEARCH question (Govinda 2011)
  28. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  29. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  31. Re: [WebDNA] SEARCH question (Steve Raslevich 2011)
  32. [WebDNA] SEARCH question (Stuart Tremain 2011)
  33. Re: [WebDNA] Search Question (Tony Miller 2009)
  34. Re: [WebDNA] Search Question (John Butler 2009)
  35. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  36. Re: [WebDNA] Search Question (Tony Miller 2009)
  37. Re: [WebDNA] Search Question ( 2009)
  38. Re: [WebDNA] Search Question (Tony Miller 2009)
  39. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  40. Re: [WebDNA] Search Question ( 2009)
  41. [WebDNA] Search Question (Tony Miller 2009)
Started from scratch on a clean page. It must have had something to do with the directory.db being a sub-search for the cat-directory.db search.

Featured Businesses

[Search db=[REL_ROOT_DIR]data/ directory.db&eqDAT_FEATdata=T&asDAT_BUSINESSsort=1&asDAT_BUSINESStype=te xt] [founditems]
[DAT_BUSINESS]
[DAT_DESCRIPTION]  [HideIf DAT_WEBSITE=]Visit Site[/HideIf]
 
[/Founditems] [/Search] This seems to be working. Thanks for the ideas. Tony Miller tmiller@thehawkeye.com On Aug 17, 2009, at 11:24 AM, Kenneth Grome wrote: > Spelling error: &eqDAT_FEATdataarq > You might also have to add "&allblnk=T" > > Sincerely, > Ken Grome > > > >> All, >> >> I am trying to select records in the directory.db that >> have a value of 'T' in the DAT_FEAT field. It is giving >> me all the entries in the category regardless of what the >> DAT_FEAT is set to. I've looked at the docs, but I must >> be missing something simple. >> >> Here's the code: >> >> [Search db=[REL_ROOT_DIR]data/ >> cat_directory.db&eqCAT_VISIBLEdata=T&asCAT_IDsort=1&CAT_I >> Dtype=number] There are [numfound] records >> [founditems] >> >>
>>

[CAT_TITLE]

>> [Search >> db=[REL_ROOT_DIR]data/directory.db&eqDAT_CAT_IDdatarq=[CA >> T_ID] >> &eqDAT_FEATdataarq=T&asDAT_BUSINESSsort=1&asDAT_BUSINESSt >> ype=text] [founditems] >>
> alt=" " width="64" height="64" class="left" >> />[DAT_BUSINESS]
>> [DAT_DESCRIPTION]
>> >>
>> [/Founditems] >> [/Search] >> >> Thanks in advance. >> >> Tony Miller >> >> OS X.4.11 Server >> Commerce Edition 6.0a >> Site is a SiteBuilder site >> >> WebDNA server is running as root >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: >> http://forum.webdna.us/eucabb.html?page=topics&category=2 >> 88 > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html? > page=topics&category=288 Tony Miller

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:

second question of the day... (2004) Forbidden CGI Error (1997) back button loses cart - ON SECURE PAGES ONLY (2000) WebCatalog for Mac 2.0.1 Released (1997) Speed Optimization - Mac (1997) Re:no [search] with NT (1997) Format date.... (2003) Type 11 errors setting up WebCAt 2 (1997) Re[3]: 2nd WebCatalog2 Feature Request (1996) Tab Charactor (1997) Using Plug-In while running 1.6.1 (1997) Anyone using WebCat UNIX on a busy server yet? (1999) [shownext] link disappears after first use. Why? - because w/out the formvar, max reset to def (2000) delete after x (1998) [WebDNA] [ArrayGet] [ArraySet] (2014) !!!!!!!!!!String Search!!!!!!!!!!!!!!!!!! (2001) Email tracking application? (2001) ShowNext for method=POST (1997) using listfiles to build a database? (2000) Rams SuperBowl Champs (2000)