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:
Summary search -- speed (1997)
[WebDNA] OT - JS help (2008)
WebCat 5 on itools 7 Install Questions Problems Hey Nitai (2003)
PCS Frames (1997)
Orders and notification (1998)
Extended [ConvertChars] (1997)
[include file=filename.inc&strip=t] (2002)
Associative lookup style? (1997)
creator code (1997)
PCS Frames (1997)
Setting up WebCatalog with Retail Pro data (1996)
creator code (1997)
Same Table Opened Twice (2003)
Webdna sends your serial number on Internet (2003)
Email...Thanks (1997)
WCS Newbie question (1997)
japanese characters (1997)
2.0 Info (1997)
Apple event reply error (-1) (1997)
[WebDNA] Updating WebDNA 8.x to WebDNA 8.2 (2016)