SteveS
Posts: 41
|
Posted: 03/20/2004, 10:47 AM |
|
Hi,
Help apprechiated with the following problems.
1 - I have a table called 'pupil_names' with several fields that represent pupils in a school. One of the fields is called 'year_id'. At the end of the academic year these pupils move up to the next year group ie from year 7 to year 8, this happens across the whole school. Is there an easy ASP way to run through all the pupil records and add '1' to the year_id of each pupil ie increasing their year group automatically??
2. What do you good folks do about backing up your asp and db files after distribution to your customer?
Best wishes, Steve.
|
|
|
Robert Rodgers
|
Posted: 03/21/2004, 5:48 AM |
|
Steve,
You can run a sql statement with the ConnectionObject.execute
The problem would be how to identify the students not to update? I am assuming there is another flag somewhere that is set
by another person? The teacher? what happens when a student graduates? Does the year_id just go to the next academic year?
Even if it something like 13?
obj.execute "Update pupil_names set year_id = year_id + 1 where (this student is elegible for promotion)"
rob
"SteveS" <SteveS@forum.codecharge> wrote in messagenews:6405c91cb37aac@news.codecharge.com...
> Hi,
>
> Help apprechiated with the following problems.
>
> 1 - I have a table called 'pupil_names' with several fields that represent pupils in a school. One of the fields is called
'year_id'. At the end of the academic year these pupils move up to the next year group ie from year 7 to year 8, this
happens across the whole school. Is there an easy ASP way to run through all the pupil records and add '1' to the year_id of
each pupil ie increasing their year group automatically??
>
> 2. What do you good folks do about backing up your asp and db files after distribution to your customer?
>
> Best wishes, Steve.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
SteveS
Posts: 41
|
Posted: 03/21/2004, 1:36 PM |
|
Thanks, this worked well. Another lesson learned!!
|
|
|
Robert Rodgers
|
Posted: 03/24/2004, 6:58 AM |
|
Good to here
rob
"SteveS" <SteveS@forum.codecharge> wrote in messagenews:6405e0aecae3cf@news.codecharge.com...
> Thanks, this worked well. Another lesson learned!!
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|