Online magazine- monthly updates and such

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22486
interpreted = N
texte = I've got a magazine that will need monthly updates, generally once a month (but may become bi-monthly). I'm thinking about putting all the info into one db, with the different issue dates in the db.For example, The db will look like this:issue location airline AircraftType regn MSN update 02/01/1999 USA ABX Air 767-281 N775AX 22790/LN 90 bought from KC Two 11/25/98 02/01/1999 USA Air Alaska Cargo Convair 440-75 N94CF 394 sold to Sion Air Express 10/98 02/01/1999 USA Air Cargo Carriers SD3-30 N58DD SH3008 bought from Tikal Jets 02/01/1999 USA Air Cargo Masters Beech 1900C-1 N122GL UC-122 returned to Raytheon 02/01/1999 USA AirTran DC-9-32 N931VV 47674/LN 793 reregistered N831ATand the date will change (the next issue might be 03/01/1999).Now the question is, how would be the easiest way to organize it by month? This is the first non-store WebCat site i've done and it's actually a bit scary (no SKU or [cart] to deal with)I was thinking about having an embedded search at the top of the page that looked for the different issue dates. Something like:02/01/1999 03/01/1999 04/01/1999... etcand weeding out all the duplicate dates with a search like this:[search db=fleet.db&geissuedata=0&issuetype=date&issuesumm=T&issuesort=1][founditems ][issue][/founditems][/search]Is this a stupid idea, or is there a better way to get the individual issue info out of the DB?Thanks for the help...Bill-- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Associated Messages, from the most recent to the oldest:

    
  1. Re: Online magazine- monthly updates and such (Bill Heissenbuttel 1999)
  2. Re: Online magazine- monthly updates and such (Peter Ostry 1999)
  3. Re: Online magazine- monthly updates and such (PCS Technical Support 1999)
  4. Re: Online magazine- monthly updates and such (Martin Bech 1999)
  5. Online magazine- monthly updates and such (Bill Heissenbuttel 1999)
I've got a magazine that will need monthly updates, generally once a month (but may become bi-monthly). I'm thinking about putting all the info into one db, with the different issue dates in the db.For example, The db will look like this:issue location airline AircraftType regn MSN update 02/01/1999 USA ABX Air 767-281 N775AX 22790/LN 90 bought from KC Two 11/25/98 02/01/1999 USA Air Alaska Cargo Convair 440-75 N94CF 394 sold to Sion Air Express 10/98 02/01/1999 USA Air Cargo Carriers SD3-30 N58DD SH3008 bought from Tikal Jets 02/01/1999 USA Air Cargo Masters Beech 1900C-1 N122GL UC-122 returned to Raytheon 02/01/1999 USA AirTran DC-9-32 N931VV 47674/LN 793 reregistered N831ATand the date will change (the next issue might be 03/01/1999).Now the question is, how would be the easiest way to organize it by month? This is the first non-store WebCat site i've done and it's actually a bit scary (no SKU or [cart] to deal with)I was thinking about having an embedded search at the top of the page that looked for the different issue dates. Something like:02/01/1999 03/01/1999 04/01/1999... etcand weeding out all the duplicate dates with a search like this:[search db=fleet.db&geissuedata=0&issuetype=date&issuesumm=T&issuesort=1][founditems ][issue][/founditems][/search]Is this a stupid idea, or is there a better way to get the individual issue info out of the DB?Thanks for the help...Bill-- Bill Heissenbuttel PageHouse, Inc. bill@pagehouse.com Internet Presence Provider http://www.pagehouse.com (509) 892-1973 Bill Heissenbuttel

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:

problems with 2 tags (1997) Update quantity (2000) Why isn't this working (1999) Re:quit command on NT (1997) Credit Card Checking?? (1998) 2.0Beta Command Ref (can't find this instruction) (1997) Roundup function? (1997) Expire Cookie in 8 Hours (2004) input type=file has no value? (2003) Re:Emailer and encryption (1997) emailer (1997) WebCat2 several catalogs? (1997) Extended [ConvertChars] (1997) WC2.0 Memory Requirements (1997) OT: Need (a tiny bit) of help setting up MySQL (2000) [WebDNA] Store module/site (2012) WCS Newbie question (1997) [WebDNA] [sendmail] attachment on unix (2014) [WebDNA] Security best practice (2009) OT: SMSI stock (2003)