[WebDNA] Search Question

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103267
interpreted = N
texte = 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_IDtype=number] There are [numfound] records [Founditems]

[CAT_TITLE]

[Search db=[REL_ROOT_DIR]data/directory.db&eqDAT_CAT_IDdatarq=[CAT_ID] &eqDAT_FEATdataarq=T&asDAT_BUSINESSsort=1&asDAT_BUSINESStype=text] [Founditems]
[DAT_BUSINESS]
[DAT_DESCRIPTION]
Read more
[/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 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)
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_IDtype=number] There are [numfound] records [founditems]

[CAT_TITLE]

[Search db=[REL_ROOT_DIR]data/directory.db&eqDAT_CAT_IDdatarq=[CAT_ID] &eqDAT_FEATdataarq=T&asDAT_BUSINESSsort=1&asDAT_BUSINESStype=text] [founditems]
[DAT_BUSINESS]
[DAT_DESCRIPTION]
Read more
[/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 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:

(1997) WebCat2b15MacPlugin - showing [math] (1997) [searchString] (1997) PCS Frames (1997) Text data with spaces in them... (1997) Press Release hit the NewsWire!!! (1997) Separate SSL Server (1997) Web Catalog 2 demo (1997) question: search return in order (1997) WebCat2 - [format thousands] (1997) Re:2nd WebCatalog2 Feature Request (1996) WebCatalog Upgrade Pricing? (1997) docs for WebCatalog2 (1997) database editor add field, etc. (2005) Secure server question (1997) writefile on OSX (2004) OT (But could use some help) Meta refresh not working. (2001) Jimmy Houssen (1998) Searching multiple Databases (1997) WebDNA on Intel Mac? (2006)