multi-table date sort problem thingy
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45395
interpreted = N
texte = 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 BalletThis 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, 7PMBill Cosby April 18, 2003, 3 PMBill Cosby April 18, 2003, 7 PMHowever, 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: Ballet¹s 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/
Associated Messages, from the most recent to the oldest:
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 BalletThis 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, 7PMBill Cosby April 18, 2003, 3 PMBill Cosby April 18, 2003, 7 PMHowever, 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: Ballet¹s 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/
PatrickJ
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:
Renumbering/changing sort order of lineitems (2004)
A Global Variable (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[WebDNA] Apache 2 httpd.conf Question (2008)
Re2: frames & carts (1997)
problem with applets embedded in tpl files (1997)
Database flushing does not work any more... (2000)
Pulling Captions from JPGs (2003)
RE: Redirect (1998)
Bug? (1997)
ShowNext (1997)
test (2006)
Simple way to create unique SKU (1997)
Break out of a loop? (2000)
More news on 5.0 (2003)
Replace Statement (1997)
Date math (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Further tests with the infamous shipCost (1997)
Faxing orders in place of email (1997)