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:

Protect (1997) Formating found categories (1997) Self Signed SSL Certificate (2005) Just Testing (1997) Image upload (2000) How to download a database???/ (2000) RE: [WebDNA] anyone successfully using webdna with paypal's NVP API? (2008) OT: SEO (2007) Search for dates greater than [date] (1997) Practice runs ? (1997) RAM variables (1997) Pithy questions on webcommerce & siteedit (1997) upgrading (1997) Search or Lookup before Append (1998) WebCat2 - [format thousands] (1997) Showing Results Alphabetically in Columns (top to bottom) (2002) typo in docs (2000) WebDNA Quick Reference (Reserved Words) (2000) Nested tags count question (1997) Search and Change (2003)