RE: [CFCDev] OT: Using JDBC instead of in CFC's

[Dave Carabetta]

Along the same line, what is the best way to retrieve data from multiple 
queries in a cfquery?

In procedures you use cfprocresult, but I haven't found anything in the 
documentation to
hint at how one would get the data from the second query in this:

<cfquery name="TopicInfo" datasource="dslkf">
        SELECT Description
        FROM Vocab
        WHERE Display=1 AND Type='GS'
        ORDER BY DisplayOrder;
        SELECT Name
        FROM VAggregates
        WHERE Display=1 AND Type IN ('Teacher','Student')
        ORDER BY Name;
</cfquery>
Not sure why you'd really need to do that. Since CF pools database 
connections, there is virtually no overhead whatsoever to using separate 
cfquery calls for each query. It's not like each cfquery call is a separate 
open-execute-close connection to the database.

Regards,
Dave.
----------------------------------------------------------
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]