handy yes, its just a shame its another thing to add to the list of things that make CF unsuitable for shared hosting.
Russ -----Original Message----- From: "Munson, Jacob" <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Date: Mon, 24 Apr 2006 14:50:49 -0600 Subject: RE: Why is there query.recordcount with non-SELECT queries? > Oh, sweet! That is a better way to do it. I guess as long as > servicefactory doesn't go away, this should work with furture versions. > I'd hate to see Adobe drop that, because I know a lot of people use it. > > > -----Original Message----- > > From: Denny Valliant [mailto:[EMAIL PROTECTED] > > Sent: Friday, April 21, 2006 11:57 PM > > > > It might b e worth noting that you can use undocumented > > "don't use these > > and expect them to work over time" type functions to use an existing > > datasource, so you don't need to save your db user & pass "hard"ly. > > > > Something like: > > daFactory = CreateObject ("Java"," > > coldfusion.server.ServiceFactory"); > > conn = daFactory.getDataSourceService > > ().getDatasource("yourDataSourceName").getConnection(); > > for the connection and the rest like the rest. > > > > Worth it for me, to use non public api whatnot. Be warned, may not > > work in the future (but there would be something else anyway ;) > > :de > > > > On 4/20/06, Qasim Rasheed <[EMAIL PROTECTED]> wrote: > > > > > > Jacob, > > > > > > Here is an example implementation for Oracle. You can > > definitely modify it > > > for any other database. > > > > > > <cfscript> > > > //connection url > > > connURL = "jdbc:macromedia:oracle://.........."; > > > jclass = createobject('java','java.lang.Class'); > > > jclass.forName('macromedia.jdbc.oracle.OracleDriver'); > > > driverManager = CreateObject('java', 'java.sql.DriverManager'); > > > //user name and passwword > > > conn = driverManager.getConnection( connURL, 'USER', 'PASSWORD' ); > > > sql = "delete from atable where id = ?"; > > > ps = conn.prepareStatement(sql); > > > ps.setString(1,'2'); > > > n = ps.executeUpdate(); > > > </cfscript> > > > <cfoutput> > > > Records Affected: #n# > > > </cfoutput> > > > [INFO] -- Access Manager: > This transmission may contain information that is privileged, > confidential and/or exempt from disclosure under applicable law. If > you are not the intended recipient, you are hereby notified that any > disclosure, copying, distribution, or use of the information contained > herein (including any reliance thereon) is STRICTLY PROHIBITED. If you > received this transmission in error, please immediately contact the > sender and destroy the material in its entirety, whether in electronic > or hard copy format. Thank you. A2 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238562 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
