Re: Search String
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51963
interpreted = N
texte = I just ran into this myself. It seems the wo searches for any occurance of the search string, even if it's within a larger set of text. In this case, the 6 in your wo search is going to find 16 because 6 is a part of the forumid of 16. What I did to get around that was use the Word Matching option ww: &FORUMIDword=ww This forces it to look for a whole word match for 6 which should not find the 16. See if that does the trick. -----Original Message----- From: Jesse Williams-Proudman [mailto:j.list@ninewire.com] Sent: Monday, July 28, 2003 10:50 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Search String Here's my search; [search db=^DNAForum/DNAmessages.db&eqKEYdatarq=se&woFORUMIDdatarq=20,24,11,18,13,9, 22,5,12,6,17,14,8,19,4,21,10,23,2,1,3,7,15,&eqMSGDTdatarq=07/28/2003&rnMSGTM datarq=09:48:23 10:48:23&max=25&startat=1&deMSGLSTPSTDTsort=1&deMSGLSTPSTTMsort=2&MSGLSTPSTD Ttype=date&MSGLSTPSTTMtype=time&MSGTOPIDsumm=t&FORUMIDwbrk=,] Problem is that it's pulling up messages that have a forumid of 16. In other words, the woFORUMIDdatarq part isn't firing... Any ideas? -- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:
I just ran into this myself. It seems the wo searches for any occurance of the search string, even if it's within a larger set of text. In this case, the 6 in your wo search is going to find 16 because 6 is a part of the forumid of 16. What I did to get around that was use the Word Matching option ww: &FORUMIDword=ww This forces it to look for a whole word match for 6 which should not find the 16. See if that does the trick. -----Original Message----- From: Jesse Williams-Proudman [mailto:j.list@ninewire.com] Sent: Monday, July 28, 2003 10:50 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Search String Here's my search; [search db=^DNAForum/DNAmessages.db&eqKEYdatarq=se&woFORUMIDdatarq=20,24,11,18,13,9, 22,5,12,6,17,14,8,19,4,21,10,23,2,1,3,7,15,&eqMSGDTdatarq=07/28/2003&rnMSGTM datarq=09:48:23 10:48:23&max=25&startat=1&deMSGLSTPSTDTsort=1&deMSGLSTPSTTMsort=2&MSGLSTPSTD Ttype=date&MSGLSTPSTTMtype=time&MSGTOPIDsumm=t&FORUMIDwbrk=,] Problem is that it's pulling up messages that have a forumid of 16. In other words, the woFORUMIDdatarq part isn't firing... Any ideas? -- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/
Brent Cannon
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:
update on wn searching (1997)
RE: Nesting [ListFiles] (1998)
SEA files (1996)
Great product and great job ! (1997)
Max Record length restated as maybe bug (1997)
Uh...can someone help me out with the b10? (1997)
Updating Prices in Online Database (1999)
taxRate is fine but taxTotal isn't (1997)
(1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Country & Ship-to address & other fields ? (1997)
Problems appending to database (1997)
Help formatting search results w/ table (1997)
Emailer file formats (1998)
Re:Message Board (1998)
Progress !! WAS: Trouble with formula.db (1997)
Server Freeze...not always (1998)
Members register & gain access system (1998)
Multiple Pulldowns/Gary (1997)
Order not created error (1997)