Well, I managed to get something working with everybody's help here. Thanks everyone! I'll try and post the exact solution, when I polish it.
George On 12/2/05, Gaulin, Mark <[EMAIL PROTECTED]> wrote: > > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225970 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
