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:

    
  1. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  2. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  3. Re: multi-table date sort problem thingy (PatrickJ 2002)
  4. Re: multi-table date sort problem thingy (Gary Krockover 2002)
  5. Re: multi-table date sort problem thingy (PatrickJ 2002)
  6. Re: multi-table date sort problem thingy (Donovan Brooke 2002)
  7. multi-table date sort problem thingy (PatrickJ 2002)
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:

RE: Adding a product from another site (1997) Shownext! (1998) Roundup function? (1997) A multi-processor savvy WebCatalog? (1997) Calendar (1997) [setcookie] & [redirect] (1998) Multiple prices (1997) WebCat2 - Getting to the browser's username/password data (1997) RE: Emailer prefs in two places ... (1997) Timeout question .. (2003) Listing Words Backwords (2001) WebCommerce: Folder organization ? (1997) Removing [showif] makes a big difference in speed (1997) New Command prefs ... (1997) THANKS (1997) WebDNA Video Poker (was ...dice result) (2007) Banners (1997) Faxing orders in place of email (1997) Greeting Card System (2000) Applescript, WebDNA, and PDF (1997)