Re: Logic question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43174
interpreted = N
texte = Robert and John -Thank you both so much for opening my eyes to this possibility. A different way of thinking for me, to be sure.I've never done anything like this where I would need to post, retrieve and summarize information from so many different sources though.Let me give it a shot:A company comes a long and sponsors a Gold Package for Movie 1, Theatre 1 Day 1. So they get 20 tickets for themselves or customers they want to treat, etc.The filmfest personnel go to the package db and enter 1 gold package for the First showing of The Frustrated Programmer on Thursday at 4 PM.When they hit submit, several things happen: 1) The package purchased is stored in the packages.db 2) The available seats for that show is diminished accordingly in the schedule.db and total seats available for that show is automatically updated 3) What do I do with all the other databases?I guess I need to know what a typical flow of events would be with a system like this. Do I need some kind of field to tie them together? John, I never even thought I could have multiple entries with the same SKU. How do summaries work on something like that? I mean, if I have 3 entries with the same SKU representing 60 tickets sold (20 each)...how will I get that out of the database? I really appreciate your guidance.-- Patrick Junkroski > > Multiple tables should make this much easier: > ------------------------------------------------------------- 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: Logic question (PatrickJ 2002)
  2. Re: Logic question (John Peacock 2002)
  3. Re: Logic question (ROBERT MCPEAK 2002)
  4. Logic question (PatrickJ 2002)
Robert and John -Thank you both so much for opening my eyes to this possibility. A different way of thinking for me, to be sure.I've never done anything like this where I would need to post, retrieve and summarize information from so many different sources though.Let me give it a shot:A company comes a long and sponsors a Gold Package for Movie 1, Theatre 1 Day 1. So they get 20 tickets for themselves or customers they want to treat, etc.The filmfest personnel go to the package db and enter 1 gold package for the First showing of The Frustrated Programmer on Thursday at 4 PM.When they hit submit, several things happen: 1) The package purchased is stored in the packages.db 2) The available seats for that show is diminished accordingly in the schedule.db and total seats available for that show is automatically updated 3) What do I do with all the other databases?I guess I need to know what a typical flow of events would be with a system like this. Do I need some kind of field to tie them together? John, I never even thought I could have multiple entries with the same SKU. How do summaries work on something like that? I mean, if I have 3 entries with the same SKU representing 60 tickets sold (20 each)...how will I get that out of the database? I really appreciate your guidance.-- Patrick Junkroski > > Multiple tables should make this much easier: > ------------------------------------------------------------- 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:

Moment of Thanks (1997) WebCat2 Append problem (B14Macacgi) (1997) ShowIf & HideIf Question? (1998) Appending data from an IFrame (2002) WCS Newbie question (1997) Problems with cybercash (2000) WebCat 5 Intranet Question (2003) [replaceChars] would be nice ... (1997) HELP! Only 1/2 of pricing.db loading!?! (1999) Last Day of the Month (2005) Error Lob.db records error message not name (1997) WCS Newbie question (1997) Some ThankYou page problems (1997) off topic