why not make it two different cfqueries?
----- Original Message -----
From: "Brian Alexander Lee" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:50 AM
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
