Your queries should be AOK...as long as you are not using any Oracle Specific SQL commands......though really apart from some quirky join syntax you should all be good.
If you are simply sticking to Insert, delete etc. -----Original Message----- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 14:14 To: CF-Talk Subject: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity) Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:189630 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
