We do what we have to do, no? However, I think it might be advisable to use CFHTTP to pull the data into a query... then you can dump it off into your own table in a real DB. Use a cron template to refresh the data at intervals, and you have control over managing existing data and updates from their side, plus being able to easily update the data from your side.
Just a thought. J On Thu, 10 Feb 2005 11:22:37 -0400, cf coder <[EMAIL PROTECTED]> wrote: > Hi Jared, > > Thanks for responding (I work with cfcoder btw). You're right; we don't have > to do it this way, but it fitted in nicely with some other stuff, and being > stubborn and not liking to admit defeat, we'd been wanting to get this to > work. In the end though, even if it does work we'll still need to employ > other methods as the driver only supports SELECT & INSERT, ie no support for > UPDATE & DELETE, which we obviously need on a user admin page. As for your > second point, yes, the file is being created by a php web app that we have no > control over, and even if we knew any php, is encrypted anyway! Mind you, we > have ordered a text book! ;o) > > For the time being, we've used CFFILE to copy and rename the file, we'll do > our work on it, and then use it to copy over the original. Clunky I know - > the original app developers have advised that a SQL backed version will be > out hopefully this year, so with a bit of luck this is only a stop gap until > then. > > Regards, > Mat > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194090 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
