sure you can!! All you have to do is put the file where only your script
can read/write it.
You make your script the owner of the file... and set owner-only rights.
It is that simple... your script reads/interprets it and sends html via
standard out as per normal
Chuck
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Gonzalo Q.
Sent: Sunday, March 11, 2001 6:45 PM
To: [EMAIL PROTECTED]
Subject: Doing a *safe* system command from the web
Hi,
I have web reports generated from a databse. Now, the way I figured is to
run one of the reports once adn saving the html out put to a file and any
subsequent querries made will be made to that file instad of requering the
database.
This will spead up the web report (millisenconds compared to 15 secs it
takes to generate my report) and lessen the load put on the database.
The thing I'm concerned about is when I do a system call (on a unix box) to
generate my file which will be my static report. Is this safe? Can bad
people do bad things if I release this?
My report consists of online registrations and summary numbers. Every time
someone pulls my web page up it make a about 10 querries to databases and
takes aprox. 7-15 seconds to generate and display. I love the idea of
generating the reult once and having all the rest of the people looking at
it from the output generated. It speeds things considerably..
My script does somthing like this..
If my date range is yesterday and the output file does not exist, it will
genereate it. If it is today it will go and query the database because
until midnight hits this report is always changing. Historical stuff (i.e
yesterday and before) is always static so quering the database is not
needed, unless my file does not exist.
Any ideas??
Hope you guys can unserstand my flipped up logic..
Thanks a lot in advance!
Gonzalo
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
