Featured results and sorting.

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 25928
interpreted = N
texte = Hi all,One of the features of my current search is that it sorts first by featured result, and then gives a listing of remaining results alphabetically. I do this in the following way: In my database, featured results have a field of Sorting which is set to A if featured, and B if not featured.Then when WebCat does it's query, I tell it to sort first by Sorting and second by Name. This has been working, typically, with one glitch.When I have two results that have the same name, it groups the featured and non-featured result together. At least, that's what I'm assuming is happening...the anomoly only happens when searching for items with similar or exactly similar names.Any idea how to work around this?An example can be found by going to: http://www.foodspot.com/search and searching for Mel's Diner ... The exact search string I use is as follows: [search db=../foodspot.db&eqmultihomedatarq=No&group1field=name+name2&wogroup1datarq=[ur l][name][/url]&group2field=city2+zip+region&group2word=ww&wsgroup2datarq=[url][c ity][/url]&eqIAmARestaurantdatarq=restaurant&Sortingsort=1&Sortingsdir=as&Nameso rt=2&Namesdir=as&max=25&startat=[startat]]Thanks --ChrisChristopher Feyrer System Administrator FoodSpot.com chris@foodspot.com ------------------- PGP 6.x key available.------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Featured results and sorting. (Christopher Feyrer 2000)
Hi all,One of the features of my current search is that it sorts first by featured result, and then gives a listing of remaining results alphabetically. I do this in the following way: In my database, featured results have a field of Sorting which is set to A if featured, and B if not featured.Then when WebCat does it's query, I tell it to sort first by Sorting and second by Name. This has been working, typically, with one glitch.When I have two results that have the same name, it groups the featured and non-featured result together. At least, that's what I'm assuming is happening...the anomoly only happens when searching for items with similar or exactly similar names.Any idea how to work around this?An example can be found by going to: http://www.foodspot.com/search and searching for Mel's Diner ... The exact search string I use is as follows: [search db=../foodspot.db&eqmultihomedatarq=No&group1field=name+name2&wogroup1datarq=[ur l][name][/url]&group2field=city2+zip+region&group2word=ww&wsgroup2datarq=[url][c ity][/url]&eqIAmARestaurantdatarq=restaurant&Sortingsort=1&Sortingsdir=as&Nameso rt=2&Namesdir=as&max=25&startat=[startat]]Thanks --ChrisChristopher Feyrer System Administrator FoodSpot.com chris@foodspot.com ------------------- PGP 6.x key available.------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Christopher Feyrer

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:

Newbie needs advice to learn to use WebDNA (2003) A Global Variable (1997) New commands in Final candidate (1997) Sorting error (1997) Pithy questions on webcommerce & siteedit (1997) NewCart+Search with one click ? (1997) show all problem (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) Emailer (1997) Protect vs Authenicate (1997) Summing fields (1997) Newbie Question about a Logical AND in a show if statement.... (1999) [WebDNA] Passing a text variable via copyfile (2019) RAM variables (1997) Validation (2000) question: writing files textb in webmerch (1997) Webten + Webcat running smooth (1998) NetForms for mail, sorry (1998) RE: OK, here goes... (1997) Banners (1997)