Generally, we just use straight up sql around here, too. But, we also found that an error was thrown (in the logs, not to the user) whenever a DSN was used that did not have an explicitly set username and password in the cfadmin, and which used a transaction. So, anytime we need a transaction, we have to use SP. I also use them for things like nested set models. I also have several custom functions that I use for formatting, for instance, an employee's name - something I do over and over and it's so much easier to just say "formatfullname(personid)" than the case statement it would otherwise require.
A lot of the more complicated stuff goes unused around here, too. I think we'd use more of it if we had app developers dedicated to doing Oracle work. But, we don't. I'm about as close as it gets in our little shop, and I fully admit there's boatloads of stuff I don't know yet. On 6/7/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:208821 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
