Just by adding the CF Web Service to your project as a WebReference. Then you iterate over it as an array of arrays like this:
Dim ws As New CFWS.testService Dim q As CFWS.QueryBean Dim row As Array Dim x, y As Integer q = ws.GetAQuery() For x = 0 To q.columnList.GetUpperBound(0) Debug.Write(q.columnList(x) & vbTab) Next Debug.Write(vbCrLf) For x = 0 To q.data.GetUpperBound(0) row = CType(q.data(x), Array) For y = 0 To row.GetUpperBound(0) Debug.Write(row(y) & vbTab) Next Debug.Write(vbCrLf) Next Works like a champ :) Roland -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Rinehart Sent: Friday, January 28, 2005 7:48 AM To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL > > The CF Query object is consumable from CF, Java, and .NET - those are our > > target platforms. It works quite nicely. > > I didn't realize it was consumable from anything other than CF but > it's good to know. I haven't seen, or been able to consume a CFQuery directly from .NET - how've you been able to do this? -Joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org
test.cfc
Description: Binary data