The mm cfx.ar file contains a query interface, you'll need to convert your class into a cfx to use it though, but it's not hard.
Then just iterate over the sql resultset and do somethgin like .... int row = query.addRow(); query.setData( int row, int column, String value ) ; The Java CFX guide in the cf docs is pretty good at explaining how to use the query interface. -----Original Message----- From: Phil Spitler [mailto:[EMAIL PROTECTED] Sent: 25 June 2003 13:53 To: CF-Talk Subject: java recordset to cf recordset I have created a class in java that returns a result set (java.sql.ResultSet). I need to output that as a query in CF. I know some sort of conversion must take place in order to do this. Does anyone know of a java class out there that deals with this and where I can get it? I've been searching on google and can't come up with anything. THANKS! -- Phil Spitler [Applications Developer] American City Business Journals p: 704.973.1049 f: 704.973.8049 e: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
