- see footer for list info -<
Sounds like a need for an API ;). What other ways do they supply the data?
One this you could do it loop over the database columns and dynamically create you tables/layout this way? The problem with this could be that your column names arn't very user friendly. But you can code around this. HTH. On 30/10/06, Paul Swingewood <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< I have an application that displays school budget information every year. The appication provides information on S52 and standards fund budgets. http://www.bgfl.org/services/budget/default.htm Select Schools a-z and then select a school ... You'll get the idea from there .... So, The data for this system is provided each year on an excel spreadsheet. There are approx 500 schools and boat loads of columns ...... I upload this information to an SQL database table (there is a table for nuresery, primary, secondary and special) each of the reports for these schools have a different layout. So I make a template for each and then display the data. There is also a different layout for each again for an excel view that can be downloaded. (I had to do this as the HTML differs in 'colspans' etc for the EXCEL view) - Thats a real pain doing it twice ..... So all works well. Then next year comes along and the grants have completely changed. The view is different the excel column names are different and so the templates are different. (AGhhh) multiply this by four years (So far) and you start to see how much of a pain this app is. As always I get the data the day it has to go live ... Which means a real late night getting everything transferred and re-writing the template each time ... Also every few months the Standards Fund changes ..... I am looking for ideas to automate this? I am going to DEVCON and would love to talk to anyone who is interested in this app. Its a real pain and I know there must be a MUCH better way of doing it if my CF skills were bettter. Is anyone else working for an LEA that provides this info ... (DFES directive)? - How do you do it ? Regards - Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
-- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
