|
 |
asp_databases thread: HTML Table
Message #1 by "Noumaan Abubakar" <noumaan_abubakar@m...> on Thu, 24 May 2001 13:14:39
|
|
Can someone help me...
I have created ASP pages which extract information from a SQL database. I
need to be able to basically store statistics such as averages and totals
in a seperate HTML table, every week.
So every time the user visits the page say every friday, then a new row is
added to the table to reflect the statistics for the past week. Is there a
way of adding a new row to an existing table, every week?? without adding
multiple duplicate rows??
Thankyou in advance
Noumaan Abubakar
Message #2 by Gregory_Griffiths@c... on Thu, 24 May 2001 13:49:51 +0100
|
|
why not automate the ASP and have it create the HTML file each week ?
> -----Original Message-----
> From: noumaan_abubakar@m...
> [mailto:noumaan_abubakar@m...]
> Sent: 24 May 2001 13:15
> To: asp_databases@p...
> Cc: noumaan_abubakar@m...
> Subject: [asp_databases] HTML Table
>
>
> Can someone help me...
>
> I have created ASP pages which extract information from a SQL
> database. I
> need to be able to basically store statistics such as
> averages and totals
> in a seperate HTML table, every week.
>
> So every time the user visits the page say every friday, then
> a new row is
> added to the table to reflect the statistics for the past
> week. Is there a
> way of adding a new row to an existing table, every week??
> without adding
> multiple duplicate rows??
>
> Thankyou in advance
>
> Noumaan Abubakar
>
Message #3 by "Charles Feduke" <webmaster@r...> on Thu, 24 May 2001 09:12:14 -0400
|
|
> So every time the user visits the page say every friday, then a
> new row is
> added to the table to reflect the statistics for the past week.
Question: why don't you just try creating your statistics from IIS's server
logs for the week? Configure IIS to generate a new log every 7 days, and
have a SQL Agent fire a stored proc to digest the data once a week. Hell,
if you're lucky you can reconfigure IIS to write XML logs, then you'd
definately be in business.
Of course if you're not tracking IIS information (which it appears that
you're not and I read the question all wrong), you could still have a SQL
Agent run once a week and execute a stored proc that adds the new averages
and what not.
? Chuck
> -----Original Message-----
> From: Noumaan Abubakar [mailto:noumaan_abubakar@m...]
> Sent: Thursday, May 24, 2001 1:15 PM
> To: ASP Databases
> Subject: [asp_databases] HTML Table
>
>
> Can someone help me...
>
> I have created ASP pages which extract information from a SQL database. I
> need to be able to basically store statistics such as averages and totals
> in a seperate HTML table, every week.
>
> So every time the user visits the page say every friday, then a
> new row is
> added to the table to reflect the statistics for the past week.
> Is there a
> way of adding a new row to an existing table, every week?? without adding
> multiple duplicate rows??
>
> Thankyou in advance
>
> Noumaan Abubakar
>
Message #4 by "Noumaan Abubakar" <noumaan_abubakar@m...> on Thu, 24 May 2001 14:26:11
|
|
> why not automate the ASP and have it create the HTML file each week ?
Because, if I automate the ASP The statistics for previous weeks will
change, as the database will constantly be updated, the stats will change.
I am trying to basically build up a historic table of stats for each week.
But I don't think you can add a new row to an existing HTML table, if you
can I don't know how to. Maybe I could check whether the day is friday
when the user visits the page, and add a row to the HTML table if it is
friday. But theres still the question of being able to add a new row to a
HTML table, whilst maintining all the other rows.
Does anybody have the answer, ideas??
Noumaan Abubakar
Message #5 by "Dallas Martin" <dmartin@z...> on Thu, 24 May 2001 09:44:30 -0400
|
|
The solution is so simple.
Create a "SUMMARY" table in your db.
Each week either manually or using the SQL
Scheduler, add the weekly statistics to the
summary table. Use the summary table as
the data input into your HTML page.
Dallas Martin
----- Original Message -----
From: "Noumaan Abubakar" <noumaan_abubakar@m...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, May 24, 2001 2:26 PM
Subject: [asp_databases] RE: HTML Table
> > why not automate the ASP and have it create the HTML file each week ?
>
> Because, if I automate the ASP The statistics for previous weeks will
> change, as the database will constantly be updated, the stats will change.
> I am trying to basically build up a historic table of stats for each week.
>
> But I don't think you can add a new row to an existing HTML table, if you
> can I don't know how to. Maybe I could check whether the day is friday
> when the user visits the page, and add a row to the HTML table if it is
> friday. But theres still the question of being able to add a new row to a
> HTML table, whilst maintining all the other rows.
>
> Does anybody have the answer, ideas??
>
> Noumaan Abubakar
>
>
>
>
|
|
|
View Cart
