Re: multi-table date sort problem thingy
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45396
interpreted = N
texte = would help if we saw the code me thinks.If this is one search it could be an Allhit=1 scenereo.(sorting per rank)DonovanPatrickJ wrote:> Long one. Ready?>> One of our clients has an events database, in three tables:>> Table 1 is an Artists database which contains only names:> Cosby, Bill> Cirque Eloize,> Miami City Ballet>> This table is used to generate a select menu for users to search for a> specific performer.>> Table 2 is the actual Event db with, among other fields, Billing (which> replicates what's in the artist db - there is a reason, don't worry),> Description, Underwriter, etc.>> Table 3 is the performance dates table.>> So...If I search for Bill Cosby from the select menu, that name is sent to> the next page to look for a match in the Billing field of the events.db.> Using the SKU (primary key) for that event, it looks for all related> performances in the performance db and lists them in chronological order.> This works perfectly when there is one match for the first part of the> search. Example:>> Bill Cosby> April 17, 2003, 7PM>> Bill Cosby> April 18, 2003, 3 PM>> Bill Cosby> April 18, 2003, 7 PM>> However, when more than one match is made on the FIRST part of the search, I> can't sort by date properly. For instance, the Miami City Ballet has 5> separate, unrelated shows, some with multiple performances. So, in my> search results, I get chronological listings *within each event* but not> overall. As below:>> Miami City Ballet #3: Coppélia: Ballet1s Comic Masterpiece> March 18, 2003, 8 p.m.> March 19, 2003, 8 p.m.>> The Neighborhood Ballroom> December 11, 2002, 8 p.m.>> Miami City Ballet #1: Some Balanchine Heroes> January 14, 2003, 8 p.m.> January 15, 2003, 8 p.m.>> George Balanchine's The Nutcracker> November 27, 2002, 8 p.m.> November 29, 2002, 8 p.m.> November 30, 2002, 8 p.m.> November 30, 2002, 2 p.m.> December 01, 2002, 2 p.m.> December 01, 2002, 7 p.m.>> In the example above, you can see that The Nutcracker, with all of its> dates, should be FIRST on the list, followed by The Neighborhood Ballroom,> Balanchine's Heroes, and Comic Masterpiece.>> Because the performance dates are in a separate table, I have no way to> perform a sort on the order in which these events come up, rather only for> the dates FOR each event.>> Does anyone understand my problem? If so, are there suggestions for how I> can address this?>> TIA> --> Patrick Junkroski> http://www.vsm.net> (239) 642.0304>> -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
would help if we saw the code me thinks.If this is one search it could be an Allhit=1 scenereo.(sorting per rank)DonovanPatrickJ wrote:> Long one. Ready?>> One of our clients has an events database, in three tables:>> Table 1 is an Artists database which contains only names:> Cosby, Bill> Cirque Eloize,> Miami City Ballet>> This table is used to generate a select menu for users to search for a> specific performer.>> Table 2 is the actual Event db with, among other fields, Billing (which> replicates what's in the artist db - there is a reason, don't worry),> Description, Underwriter, etc.>> Table 3 is the performance dates table.>> So...If I search for Bill Cosby from the select menu, that name is sent to> the next page to look for a match in the Billing field of the events.db.> Using the SKU (primary key) for that event, it looks for all related> performances in the performance db and lists them in chronological order.> This works perfectly when there is one match for the first part of the> search. Example:>> Bill Cosby> April 17, 2003, 7PM>> Bill Cosby> April 18, 2003, 3 PM>> Bill Cosby> April 18, 2003, 7 PM>> However, when more than one match is made on the FIRST part of the search, I> can't sort by date properly. For instance, the Miami City Ballet has 5> separate, unrelated shows, some with multiple performances. So, in my> search results, I get chronological listings *within each event* but not> overall. As below:>> Miami City Ballet #3: Coppélia: Ballet1s Comic Masterpiece> March 18, 2003, 8 p.m.> March 19, 2003, 8 p.m.>> The Neighborhood Ballroom> December 11, 2002, 8 p.m.>> Miami City Ballet #1: Some Balanchine Heroes> January 14, 2003, 8 p.m.> January 15, 2003, 8 p.m.>> George Balanchine's The Nutcracker> November 27, 2002, 8 p.m.> November 29, 2002, 8 p.m.> November 30, 2002, 8 p.m.> November 30, 2002, 2 p.m.> December 01, 2002, 2 p.m.> December 01, 2002, 7 p.m.>> In the example above, you can see that The Nutcracker, with all of its> dates, should be FIRST on the list, followed by The Neighborhood Ballroom,> Balanchine's Heroes, and Comic Masterpiece.>> Because the performance dates are in a separate table, I have no way to> perform a sort on the order in which these events come up, rather only for> the dates FOR each event.>> Does anyone understand my problem? If so, are there suggestions for how I> can address this?>> TIA> --> Patrick Junkroski> http://www.vsm.net> (239) 642.0304>> -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
Donovan Brooke
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:
One cent added (1998)
Field name-subcategory (1997)
Using WebMerchant Only? (1998)
random in arizona (2003)
Error 11 (1996)
Search returns all, not 20 (1997)
Permission denied? (2004)
writefile - continued (1997)
Problem: 3.0 doesn't update carts (1997)
Text variables do not show (1999)
Spaces in sendmail (1998)
[subtotal] and others (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
Pithy questions on webcommerce & siteedit (1997)
Pull Down Search (2000)
Keep away (1997)
Cart Question (1998)
Getting total number of items ordered (1997)
multi-paragraph fields (1997)
[WebDNA] WebDNA restart script (2015)