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:

Dual processors? (2000) Formatting date to number (2000) WebDNA for Dummies (2004) form data submission gets truncated (1997) Sort Order on a page search (1997) WYSIWYG HTML editor for use in browser (2001) First Attempts (2000) math problems (2000) error count with $purchase (1997) Artwork (1997) WebCat2b13MacPlugIn - [include] (1997) [WebDNA] lighttpd and gzip compression with webdna? (2015) Word Break (1999) fix permissions on osx ... (2004) WebDNA wholesale ... (2002) encryption madness (2003) Follow-up to listfiles bug report ... (2003) Add sizes from check boxes (2002) Caching [include] files ... (1997) [sendmail] v. [writefile] (2000)