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 featuredresult, and then gives a listing of remaining results alphabetically. I dothis in the following way:In my database, featured results have a field of Sorting which is set toA if featured, and B if not featured.Then when WebCat does it's query, I tell it to sort first by Sorting andsecond by Name. This has been working, typically, with one glitch.When I have two results that have the same name, it groups the featured andnon-featured result together. At least, that's what I'm assuming ishappening...the anomoly only happens when searching for items with similaror exactly similar names.Any idea how to work around this?An example can be found by going to:http://www.foodspot.com/searchand searching for Mel's Diner ...The exact search string I use is as follows:[searchdb=../foodspot.db&eqmultihomedatarq=No&group1field=name+name2&wogroup1datarq=[url][name][/url]&group2field=city2+zip+region&group2word=ww&wsgroup2datarq=[url][city][/url]&eqIAmARestaurantdatarq=restaurant&Sortingsort=1&Sortingsdir=as&Namesort=2&Namesdir=as&max=25&startat=[startat]]Thanks --ChrisChristopher FeyrerSystem AdministratorFoodSpot.comchris@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:
|
- Featured results and sorting. (Christopher Feyrer 2000)
|
Hi all,One of the features of my current search is that it sorts first by featuredresult, and then gives a listing of remaining results alphabetically. I dothis in the following way:In my database, featured results have a field of Sorting which is set toA if featured, and B if not featured.Then when WebCat does it's query, I tell it to sort first by Sorting andsecond by Name. This has been working, typically, with one glitch.When I have two results that have the same name, it groups the featured andnon-featured result together. At least, that's what I'm assuming ishappening...the anomoly only happens when searching for items with similaror exactly similar names.Any idea how to work around this?An example can be found by going to:http://www.foodspot.com/searchand searching for Mel's Diner ...The exact search string I use is as follows:[searchdb=../foodspot.db&eqmultihomedatarq=No&group1field=name+name2&wogroup1datarq=[url][name][/url]&group2field=city2+zip+region&group2word=ww&wsgroup2datarq=[url][city][/url]&eqIAmARestaurantdatarq=restaurant&Sortingsort=1&Sortingsdir=as&Namesort=2&Namesdir=as&max=25&startat=[startat]]Thanks --ChrisChristopher FeyrerSystem AdministratorFoodSpot.comchris@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)