Because this is a big oilfield company that spent way too much money with Oracle and is looking for any excuse to just use it. They appear to not care if it is used "right" or not. The web applications do not do much more than simple queries, other groups might very well be doing things much more complex in Oracle. We also do not have access to any of the administrative side of things, typically a web application has a user in Oracle that would appear to have full access to that tablespace, although I do know when I was tried to create a "type" it did not have permissions but their fix was simply to grant that permission to all users. That same user is what is used by the CF server connection. I do believe I was saying simple inserts and updates, I just have to wonder what in the world people are collecting through a web interface that requires complex inserts and updates. Now some of the select queries, such as for some of the reports I would not label simple, not sure if I would use complex either but that is why I tried not to specify select queries. I was just trying to verify on cftransaction, the first email implied to me that the only way it could be done was through a stored procedure. On 6/7/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > > Hrmm, if you arent taking advantage of Oracle security and you are > just running simple queries... then why invest in such an expensive > database? > > As far as cftransaction, it does work that way, but that logic really > belongs in the model (the database) not the controller (cf). > > -Adam > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208815 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
