documentation, I was actually able to get the following to work:
<cfscript>
clazz = CreateObject("java", "java.lang.Class");
// replace the package/class name of your db driver
clazz.forName("macromedia.jdbc.MacromediaDriver");
driverManager = CreateObject("java", "java.sql.DriverManager");
// replace w/ your server, database name, username & password
conurl =
"jdbc:macromedia:oracle://********:1521;SID=*********;user=*********;password=*********";
connection = driverManager.getConnection(conurl);
query = "DELETE FROM IDS WHERE ID=1";
preparedStatement = connection.prepareStatement(query);
result = preparedStatement.executeUpdate();
WriteOutput("result = " & result);
connection.close();
</cfscript>
For what it's worth, this is the second time I've resorted to using the
datadirect documentation to solve a driver-related issue with Cold
Fusion :)
- Rick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
