Re: Num Sort Descending
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56083
interpreted = N
texte = I think "wrong" and "right" are oversimplifications... The first method, where each field is tested individually, should work fine. It's probably a little slower than using a group, but it does the same thing and actually has an advantage: IF you are using WebDNA's default sorting, then testing each field individually may give you better "best match" results. From my testing a while back (it should be in the archives somewhere), I determined that WebDNA's rankings are based on the number of search terms that got a match, and a match on a group of fields only counts as one hit. So, if you search multiple fields individually, then if you get a match on three different fields then the record will be ranked higher than a record that only matched on one or two fields. Of course, if you are overriding the default sorting with "allhit=1" or "rank=off", I'd certainly recommend the group field method, for simplicity and maintainability of the code as well as minor performance improvement. The one thing I would consider "wrong" in this example, though, is the common error of not wrapping user input in a [url] context. If the user enters an ampersand, the search will break. - brian On Feb 12, 2004, at 7:29 AM, John Peacock wrote: > This is wrong: > > &wsclient_namedata=[txtKeyword]&wsclient_repdata=[txtKeyword]&wsclient_ > phonedata=[txtKeyword]&wsclient_emaildata=[txtKeyword]&wsclient_numdata > =[txtKeyword] > > This is right: > > &GROUP1field=CLIENT_NAME+CLIENT_REP+CLIENT_PHONE+CLIENT_EMAIL+CLIENT_NU > M&wsGROUP1data=[txtKeyword] > > HTH > > John > > p.s. I changed the capitalization for a reason; think about it... > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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 think "wrong" and "right" are oversimplifications... The first method, where each field is tested individually, should work fine. It's probably a little slower than using a group, but it does the same thing and actually has an advantage: IF you are using WebDNA's default sorting, then testing each field individually may give you better "best match" results. From my testing a while back (it should be in the archives somewhere), I determined that WebDNA's rankings are based on the number of search terms that got a match, and a match on a group of fields only counts as one hit. So, if you search multiple fields individually, then if you get a match on three different fields then the record will be ranked higher than a record that only matched on one or two fields. Of course, if you are overriding the default sorting with "allhit=1" or "rank=off", I'd certainly recommend the group field method, for simplicity and maintainability of the code as well as minor performance improvement. The one thing I would consider "wrong" in this example, though, is the common error of not wrapping user input in a [url] context. If the user enters an ampersand, the search will break. - brian On Feb 12, 2004, at 7:29 AM, John Peacock wrote: > This is wrong: > > &wsclient_namedata=[txtKeyword]&wsclient_repdata=[txtKeyword]&wsclient_ > phonedata=[txtKeyword]&wsclient_emaildata=[txtKeyword]&wsclient_numdata > =[txtKeyword] > > This is right: > > &GROUP1field=CLIENT_NAME+CLIENT_REP+CLIENT_PHONE+CLIENT_EMAIL+CLIENT_NU > M&wsGROUP1data=[txtKeyword] > > HTH > > John > > p.s. I changed the capitalization for a reason; think about it... > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
Price problem (1997)
users.db (1999)
Proper way to save links in a db (2002)
WebCat2 Append problem (B14Macacgi) (1997)
Timeout question .. (2003)
default error on NT? (1997)
Server Freeze (1998)
Re:2nd WebCatalog2 Feature Request (1996)
SQL Tutorial (1998)
Navigator Parsing (1997)
$Append for Users outside the ADMIN group (1997)
Email template names (1997)
shownext (2001)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Help name our technology! I found it (1997)
Deleting Orders (1997)
AAAH: stupid sendmail (2001)
Signal Raised (1997)
question: Eudora 3.1.1 (1997)
Appending current [date] to a database (1997)