I don't believe that this is possible. You could do it with a stored
procedure and cfstoredproc, or you should use two CFQUERY tags.
Bob
-----Original Message-----
From: Brian Alexander Lee [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 11:50 AM
To: CF-Server
Subject: Multiple recordsets in one cfquery
If I have multiple recordsets (selects) in a cfquery tag, how do I access
the second recordset.
example:
<cfquery name="foo" datasource="bar>
select * from emp
select * from dept
</cfquery>
I want to loop through emp and then through dept. Is this possible?
Thanks,
BAL
-----Original Message-----
From: John Cesta - Lists [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 8:59 AM
To: CF-Server
Subject: RE: CFMAIL ERROR
>i realised that sometimes the mail is not fired out to the recipient but i
Could be that your mail server is not set up to relay mail for local
hosts/users
John Cesta
http://www.cybersmarts.net
-------------------------------------------------
ColdFusion ASP and ActiveState PERL Hosting
Includes 10 Domains
--------------------------------------------
SearchIt PRO - IIS Logfile Management Software
DomainReportIt PRO - Transfer IIS installs
http://www.serverautomationtools.com
-----Original Message-----
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 3:46 AM
To: CF-Server
Subject: CFMAIL ERROR
i realised that sometimes the mail is not fired out to the recipient but i
cannot find this unsent mail in any of the log file. Is there any way to
catch this error? if i use cfcatch , what error type does this belongs to ??
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
