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:
Searching for a Blank Field (2000)
IIS error and webcat (2000)
WebCatalog for Postcards ? (1997)
Two options to consider (2008)
WebCat2b15MacPlugin - showing [math] (1997)
Feature Request [TABLE ... &delimiters=] (2007)
Sending emails (went[ot] ) (2002)
Three new problems, maybe a fourth (1997)
Help! WebCat2 bug (1997)
Displaying photo attached to first record (1997)
Plugin or CGI or both (1997)
Shopping Cart Deletion (2000)
triggers (2003)
Multiple Users.db Possible? (1997)
Quit revisited (1997)
Temporary Serial Numbers for the Beta (2000)
Need relative path explanation (1997)
NT BETA BUG???? (1997)
Requiring that certain fields be completed (1997)
Results table formatting (2003)