Aaron, Read the concepts guide in the oracle docco, then check out the two books by Tom Kyte - "expert one on one oracle" (get it secondhand, it was written for 8i and the new edition will come out soon for 10g) and "effective oracle by design". There are plenty of "big companies looking for any excuse" to use oracle and it's actually fun. Twisted and bizarre fun, but fun. If you're gonna work with it anyway, you might as well use the opportunity to beef up your cv, it never hurts.
/t >-----Original Message----- >Subject: Get New Record ID in ORACLE >From: Aaron Rouse <[EMAIL PROTECTED]> >Date: Tue, 7 Jun 2005 10:48:52 -0500 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=40571&forumid=4#208815 > >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:208833 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
