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>
----------------------------------------------------------
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]
