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: [email protected]
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/[email protected]
test.cfc
Description: Binary data
