Re: Field Not Blank
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63797
interpreted = N
texte = This one doesn't work either: [search db=my.db &Group1field=ANSWER &Group2field=ANSWER &Group3field=ANSWER &Group4field=ANSWER &neGroup1datarq=0 &neGroup2datarq=NA &neGroup3datarq=[blank] &neGroup4datarq=NaN] On 1/12/06 10:02 AM, "Donovan Brooke"
wrote: > Clint Davis wrote: > >> Why is the search below finding a record where the ANSWER field is blank? >> >> [search db=my.db&wnANSWERdatarq=0,NA,[blank],NaN&ANSWERword=ww&ANSWERwbrk=,] > > > Well, I guess one could say that [blank] is not a word... so I suppose one > could > argue that it doesn't have to apply in the wo, wn context?? > > You could always: > [search > db=my.db&wnANSWERdatarq=[url]0,NA,[blank],NaN[/url]&ANSWERword=ww&ANSWERwbrk=[ > url],[/url]] > [founditems] > [hideif [ANSWER]=] > [INDEX]: ID: [ID], ANSWER: [ANSWER]
> [/hideif] > [/founditems] > [/search] > > > Donovan ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
This one doesn't work either: [search db=my.db &Group1field=ANSWER &Group2field=ANSWER &Group3field=ANSWER &Group4field=ANSWER &neGroup1datarq=0 &neGroup2datarq=NA &neGroup3datarq=[blank] &neGroup4datarq=NaN] On 1/12/06 10:02 AM, "Donovan Brooke" wrote: > Clint Davis wrote: > >> Why is the search below finding a record where the ANSWER field is blank? >> >> [search db=my.db&wnANSWERdatarq=0,NA,[blank],NaN&ANSWERword=ww&ANSWERwbrk=,] > > > Well, I guess one could say that [blank] is not a word... so I suppose one > could > argue that it doesn't have to apply in the wo, wn context?? > > You could always: > [search > db=my.db&wnANSWERdatarq=[url]0,NA,[blank],NaN[/url]&ANSWERword=ww&ANSWERwbrk=[ > url],[/url]] > [founditems] > [hideif [ANSWER]=] > [INDEX]: ID: [ID], ANSWER: [ANSWER]
> [/hideif] > [/founditems] > [/search] > > > Donovan ------------------------------------------------------------- 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://webdna.smithmicro.com/
Clint Davis
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:
Issues with the default db files ... (2003)
Searching multiple fields from one form field (1997)
Search Command, multiple dbs, etc. --Right! (2000)
NewCart+Search with one click ? (1997)
WCS Newbie question (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Multiple Merchant Accounts? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[BULK] RE: [WebDNA] [BULK] Should I be worried about this web traffic? (2017)
Emailer help....! (1997)
Flash artist needed (2005)
WebCat2b13MacPlugIn - More limits on [include] (1997)
[TaxableTotal] - not working with AOL and IE (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
Database Updates (1997)
NT vs Mac (1997)
Emailer setup (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Re[2]: New syntax feedback for 4.0 (2000)
syntax question, not in online refernce (1997)