Re: [WebDNA] Search Question

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103283
interpreted = N
texte = it's in the docs.. but: the syntax is &eqFIELDNAMEdatarq=xxx you originally had this: &eqDAT_FEATdataarq=T instead of this: &eqDAT_FEATdatarq=T That is what they were talking about. -- If you leave off the "rq" then the search can find records even if this param's comparison requirement is not met. Like for example if you had another param which could also find records, then those would be found even if the first param's condition was not met. It has been some months since I worked deeply with webdna searches so I forget exactly what happens in your case.. your most recent posting of your code.. where you don't *require* ("rq") that returned record's field data match the string "T", and you also do not have a second param (field) to compare against. But the point is (to answer your question) is: Do you want the search to return only records where the DAT_FEAT field has "T" (exactly) for its value? If so then I would include the "rq" suffix. if you do not need the returned records to have "T" for the value of their DAT_FEAT field, then what exactly do you wish your [search] to find? Also, where did you get this? - &asDAT_BUSINESStype=te xt ?? Check the docs where you think it explains what you are doing with that param. It looks like bad code for 3 different reasons to me. (The last reason maybe just due to email adding that extra space.) -Govinda On Aug 17, 2009, at 1:59 PM, Tony Miller wrote: > I removed the 'arq' from the DAT_FEATdata for this one. > > is the correct syntax datarq instead of dataarq? > > Tony Miller > tmiller@thehawkeye.com > > On Aug 17, 2009, at 2:00 PM, > wrote: > >> The spelling error didn't fix it? >> >> >> 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] >>
> alt="[DAT_BUSINESS] Logo" width="64" class="left"> >> [DAT_BUSINESS]
>> [DAT_DESCRIPTION]  [HideIf DAT_WEBSITE=]> href="[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]
>>>>
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 >>>> >>>> >>>> >>>> --------------------------------------------------------- >>>> 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 >> >> --------------------------------------------------------- >> 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 >> --------------------------------------------------------- >> 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 > > --------------------------------------------------------- > 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 ------------ John Butler (Govinda) govinda.webdnatalk@gmail.com 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)
it's in the docs.. but: the syntax is &eqFIELDNAMEdatarq=xxx you originally had this: &eqDAT_FEATdataarq=T instead of this: &eqDAT_FEATdatarq=T That is what they were talking about. -- If you leave off the "rq" then the search can find records even if this param's comparison requirement is not met. Like for example if you had another param which could also find records, then those would be found even if the first param's condition was not met. It has been some months since I worked deeply with webdna searches so I forget exactly what happens in your case.. your most recent posting of your code.. where you don't *require* ("rq") that returned record's field data match the string "T", and you also do not have a second param (field) to compare against. But the point is (to answer your question) is: Do you want the search to return only records where the DAT_FEAT field has "T" (exactly) for its value? If so then I would include the "rq" suffix. if you do not need the returned records to have "T" for the value of their DAT_FEAT field, then what exactly do you wish your [search] to find? Also, where did you get this? - &asDAT_BUSINESStype=te xt ?? Check the docs where you think it explains what you are doing with that param. It looks like bad code for 3 different reasons to me. (The last reason maybe just due to email adding that extra space.) -Govinda On Aug 17, 2009, at 1:59 PM, Tony Miller wrote: > I removed the 'arq' from the DAT_FEATdata for this one. > > is the correct syntax datarq instead of dataarq? > > Tony Miller > tmiller@thehawkeye.com > > On Aug 17, 2009, at 2:00 PM, > wrote: > >> The spelling error didn't fix it? >> >> >> 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] >>
> alt="[DAT_BUSINESS] Logo" width="64" class="left"> >> [DAT_BUSINESS]
>> [DAT_DESCRIPTION]  [HideIf DAT_WEBSITE=]> href="[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]
>>>>
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 >>>> >>>> >>>> >>>> --------------------------------------------------------- >>>> 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 >> >> --------------------------------------------------------- >> 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 >> --------------------------------------------------------- >> 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 > > --------------------------------------------------------- > 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 ------------ John Butler (Govinda) govinda.webdnatalk@gmail.com John Butler

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:

Newspaper Portal (2005) Possible Bug in 2.0b15.acgi (1997) Databases going to sleep (1998) WC Database Format (1997) Server IP address (2004) carriage returns in data (1997) problem 'building' field names (2000) Add Unit Ship Cost to Cart (2000) Summing fields (1997) Counting records (2000) Error Msg (1998) Emailer setup (1997) New servers and new inline cache (1997) RE: protect tag on NT (1997) Using [Include] Context (1999) ShowIf & CountChars (2000) Problems getting parameters passed into email. (1997) problems with 2 tags shakur (1997) WebCat2b13MacPlugIn - [include] (1997) Generating Report Totals (1997)