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:
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)