You can also create an arbitrary QueryTable (with columns you specify). I wish there was a way to do this without having to reference cfusion.jar...
I do it to help maintain a back-end (in java) vs front-end (in cfml) distinction in the system. -----Original Message----- From: Dave Ross [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:09 PM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? >I think you need to use the class "coldfusion.sql.QueryTable" to do >what you want. It's in either cfx.jar or cfusion.jar. > Mark > >-----Original Message----- >From: George Abraham [mailto:[EMAIL PROTECTED] >Sent: Friday, December 02, 2005 9:17 AM >To: CF-Talk >Subject: interacting with java and return a ColdFusion query > >All, >I am working with CFMX and a set of Java libraries. I need to code a >Java class that can serve as the liaison between CFMX and Java. This >class will interact with the Java libraries and return the information >to CF in the form of a CF query (using com.allaire.cfx.Query.) I want >to stress that I am not making a Java CFX tag, I am just using >com.allaire.cfx.Query. However I looked through this site ( >http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2 .. >htm#1142286) >for the methods available for the Query interface and I don't see any >way to actually add a query or to name its columns. This is possible >only through the Request interface. How can I name a CF query and its >columns in a Java class and then return it to CFMX? > >Hope that makes sense! > >TIA, >George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:225961 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
