Re: Online magazine- monthly updates and such
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22549
interpreted = N
texte = At 21:58 Uhr -0800 11.01.1999, Bill Heissenbuttel wrote:>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 >... > >and the date will change (the next issue might be 03/01/1999). I am currently working on a website with three magazines (weekly and monthly) and an admin interface for updates. The admin can collect as much data as he likes and when the day comes he just clicks on a button - the new issue goes online and the old one goes into the archive. I have all data in the database. If that is somehow similar to your project, my experiences might be helpful:Do not use dates only, number the issues. And use a field as a flag to mark the records as online or offline. Here are the most relevant fields of my database:Field Example Description of field ------------------------------------------------------------------------ db_ID 12345678 (the SKU) db_Medium aw (code for this magazine) db_Jahr 1999 (year) db_Ausgabe 13 (number of the issue) db_AusgabeID aw_1999_13 (unique code for one issue of one magazine, consists of db_Medium, db_Jahr and db_Ausgabe) db_Artikel 6 (number of one text-article in one issue) db_Status active (can have three states: new, active, old)The system is that I have a code for the specific magazine, a number for the issue of this magazine and numbers for all text-articles within this magazine. It is even easy to link an image to an article if you give it a name which fits into the system. The field db_Status is very important - you will actually have 3 possibilities: a magazine can be online, old (maybe in the archive) and you need a place where you can collect data BEFORE it goes online. If I put you an issue online, WebCat changes all active records to old and all which belongs to the new issue to active. So the admin can work on a new magazine whenever he like and finally it goes smooth online with a mouseclick... :-) Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++
Associated Messages, from the most recent to the oldest:
At 21:58 Uhr -0800 11.01.1999, Bill Heissenbuttel wrote:>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 >... > >and the date will change (the next issue might be 03/01/1999). I am currently working on a website with three magazines (weekly and monthly) and an admin interface for updates. The admin can collect as much data as he likes and when the day comes he just clicks on a button - the new issue goes online and the old one goes into the archive. I have all data in the database. If that is somehow similar to your project, my experiences might be helpful:Do not use dates only, number the issues. And use a field as a flag to mark the records as online or offline. Here are the most relevant fields of my database:Field Example Description of field ------------------------------------------------------------------------ db_ID 12345678 (the SKU) db_Medium aw (code for this magazine) db_Jahr 1999 (year) db_Ausgabe 13 (number of the issue) db_AusgabeID aw_1999_13 (unique code for one issue of one magazine, consists of db_Medium, db_Jahr and db_Ausgabe) db_Artikel 6 (number of one text-article in one issue) db_Status active (can have three states: new, active, old)The system is that I have a code for the specific magazine, a number for the issue of this magazine and numbers for all text-articles within this magazine. It is even easy to link an image to an article if you give it a name which fits into the system. The field db_Status is very important - you will actually have 3 possibilities: a magazine can be online, old (maybe in the archive) and you need a place where you can collect data BEFORE it goes online. If I put you an issue online, WebCat changes all active records to old and all which belongs to the new issue to active. So the admin can work on a new magazine whenever he like and finally it goes smooth online with a mouseclick... :-) Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++
Peter Ostry
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:
Getting total number of items ordered (1997)
Include a big block of text (1997)
[WebDNA] WebDNA Crashing or Not **YES** (2008)
What am I missing? (1998)
[WebDNA] [if] or [case] or something else (2012)
Process SSI and WebCatalog.acgi (1998)
WebCat2: Formulas.db question (1997)
A dynamic database. (1997)
WebCatalog can't find database (1997)
Rumpus & WebCat (1998)
Nested tags count question (1997)
Founditems Add/remove graphic display problem (1999)
Billing when shipped (2006)
Stuck - Figured out?? (2003)
Download URL & access on the fly ? (1997)
new cart IDs being assigned somehow (1997)
[isfolder] and [filename] (1997)
WebCommerce: Folder organization ? (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Quiz question: Return all green and blank records? (2001)