[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:

WebMerchant when CC network is down - bug? (1998) Problems with SELECT MULTIPLE (1999) [WebDNA] El Capitan (2017) Re[4]: Problem with new formvariables (2000) math on date? (1997) Major Security Hole IIS NT (1998) browser info.txt and SSL (1997) Showif, Hideif reverse logic ? (1997) Ship via options price (2000) PIXO support (1997) webcat2b12 CGI -- Date comparisons (1997) [BULK] [Spam Low] [WebDNA] Suggested Platform (2013) Emailer choke (1997) Fun with dates (1997) [WebDNA] Successful, working WebDNA7/CentOS install? (2013) Simple Database close connection (2001) [OT] Domain Name Scam (2000) Hard Questions ? (1997) Webmerchant quitting (1998) multiple prices (1998)