| Author |
 Topic  |
|
Alfred
Senior Member
USA
1527 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
 Posted - 09 August 2003 : 21:23:54
|
As I said member-medal is easy, NEW medals will mean exactly maintenance.
Put it this way, you have X medals now, they can be awarded to any member quite easily, and you have the process & code in place to do that. If you suddenly want to award the V8Central Excellence Medal you will need to change your ASP code to make that medal available to any/all members.
Don't worry about it now, it works fine, but if you have a LOT of medal additions (like I mean a brand new medal every week or so) then the db design should allow that function simply, without the need to change code. |
 |
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 09 August 2003 : 21:36:24
|
I see what you mean.
I have been thinking about that too when I wrote the original member_medals form.
However, there will not be that many additions, and if there is any, I will have to add it to the code I suppose.
BTW, something weird happened here in my previous post.
The link or the txt file brings up the page like it was an htm page!
You too? |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 09 August 2003 21:38:54 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 09 August 2003 : 21:44:00
|
It's because your file contains "normal" HTML tags, the browser sees these and renders them properly. That's one of the pluses with 100% Response.Writes  you see ALL the code. |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 10 August 2003 : 03:59:57
|
| OK, so you add a new medalID (e.g. 50) .... how does that translate to a filename without modifying ANY code ??? |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 10 August 2003 : 11:08:52
|
Of course it does not do that.
However, it enables me to insert the data into the medals table without having to shut down and download/upload the database.
I still have to modify display files, but only need to do a replacement upload then. |
Alfred
The Battle Group
CREDO
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 10 August 2003 : 17:16:37
|
quote:
Originally posted by Alfred
Of course it does not do that.
But a better db design makes it possible
quote:
However, it enables me to insert the data into the medals table without having to shut down and download/upload the database.
NO need to do this at all. Table Editor is fantastic for online updating
quote:
I still have to modify display files, but only need to do a replacement upload then.
Exactly my point. There is no need for this. It 'should' all be done by updating the database via forms, not by altering code and uploading all the time. |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 11 August 2003 : 12:12:24
|
Well, via forms is what I have been doing, and I put the forms in the admin option section.
But I still need to rewrite the code for the pages that display the data, and upload the new one.
I guess the "table editor" cannot eliminate that need. |
Alfred
The Battle Group
CREDO
|
Edited by - Alfred on 11 August 2003 14:16:40 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 11 August 2003 : 17:34:07
|
Alfred, you're not listening properly .....
With a better designed database, you will NOT need to edit code to change anypart of your application. At the moment if you want to add on to your medal list you have to change code. Using forms is fine (look at Snitz, everything is handled by forms), do you ever see instructions in Snitz that say "now go and edit this code to make it work". The only time you see that is when you inserting a mod (not really what I'm talking about here).
Anyway, as I said, it doesn't really matter. You know what you need to change when you have new medals, members, or links between the two. All I was trying to show was there is a better (more complex to write, more easy to maintain) method that you might want to consider. |
|
|
|
Alfred
Senior Member
USA
1527 Posts |
Posted - 11 August 2003 : 18:43:35
|
Well, as you can see, anything more complex to write does not have good prospects with me.
Basically, I like the idea of putting extra efort into the design, so that maintenance is easier, but alas, I better recognize my limitations, and for once curb my ambitions.
I want to thank you very much for your patience and tenacity to see me through this challenge. |
Alfred
The Battle Group
CREDO
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 August 2003 : 04:22:26
|
no probs mate, my reward is to see your code working 
I only bring it up now, because you have something that now works. You can now choose to further develop the medal feature or leave it like it is.
Whichever you choose, it's on to the next challenge |
|
|
|
Topic |
|
Topic Locked
