Re: help with web-database

Justin Langseth wrote: > Certainly having more of a drill-down live-generation approach would be nicer, > but the complexities of hooking database to web server are not always if the db is Oracle, their WebServer products make it pretty painless, imo. especially for routine reporting of table info. for example: procedure showit is ok boolean; begin ok:=owa_util.tablePrint('the_table','BORDER=6',HTML_TABLE, '*','where foo=3 and bar > sysdate - 10 order by bar'); end; of course, helping user build query, adding insert/update support, etc can greatly complicate things but still...plus you cant do those sorts of things from static pages anyway. > justified or organizationaly surmountable. > > And you can't beat the response time of pre-generated data > pages... I'll post the URL of this project when it goes public -- and you can of course use the "on the fly" procedures to produce pre-generated pages. one might, for example, run the procedures nightly to generate pages and just show users those static pages. thomas > it may be of interest to some people thinking about this sort of thing. > > - Justin Langseth > MIT Sloan > -- Thomas Dunbar 540 231-3938 (fax 3714) http://gserver.grads.vt.edu/