Re: Search Philosophy
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39367
interpreted = N
texte = Donovan Brooke wrote: > > Hello, question from a confused designer.... > In a basic search string similiar to: > > [search db=some.db&eqFIELDdatarq=var] > [founditems] > some action > [/founditems] > [/search]That search will ONLY return the records where FIELD==var.> > If one wants to enact an action on both the found > items that equal FIELD and that founditems that dont equal > FIELD does one need two search contexts?Yes> > In otherwords, I want to change a variable to something > if it is found and something else if it is not found.If your search is binary (i.e. either the FIELD==var or not), do a search for everything and act accordingly on a record by record basis.If you are only searching for the existance of at least 1 record where FIELD==var, then you should use [lookup...] as it is vastly faster. If the lookup does not find a record matching the criteria, you can use the ¬Found= parameter to signal that case. NOTE: [lookup] is a case sensitive search (i.e. FISH != fish).John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Donovan Brooke wrote: > > Hello, question from a confused designer.... > In a basic search string similiar to: > > [search db=some.db&eqFIELDdatarq=var] > [founditems] > some action > [/founditems] > [/search]That search will ONLY return the records where FIELD==var.> > If one wants to enact an action on both the found > items that equal FIELD and that founditems that dont equal > FIELD does one need two search contexts?Yes> > In otherwords, I want to change a variable to something > if it is found and something else if it is not found.If your search is binary (i.e. either the FIELD==var or not), do a search for everything and act accordingly on a record by record basis.If you are only searching for the existance of at least 1 record where FIELD==var, then you should use [lookup...] as it is vastly faster. If the lookup does not find a record matching the criteria, you can use the ¬Found= parameter to signal that case. NOTE: [lookup] is a case sensitive search (i.e. FISH != fish).John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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://search.smithmicro.com/
John Peacock
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:
WebCatalog Technical Reference (1997)
practicing safe queries.. (2000)
WebCat b13 CGI -shownext- (1997)
WebCatalog NT beta 18 problem (1997)
Newbie HW/SW Setup Question (2000)
WebCatalog2 Feature Feedback (1996)
calender with business days (1998)
WebDNA maxing out processor (2008)
Hiding Brands (2004)
[WebDNA] OT - Wordpress Shopping Cart - will pay (2010)
[WebDNA] WebDNA version 7 feature list? (2011)
Firesite cache vs webcat cache (1997)
[OT] Who's got a cool link (2002)
Running 2 two WebCatalog.acgi's (1996)
'does not contain' operator needed ... (1997)
Updating a database once per day - An example (1998)
Header Values won't take. (1998)
Setting up shop (1997)
What file? (1997)
2.0 Info (1997)