Its is as easy as
> where city = '#cities.city#'
At 09:09 PM 13/08/00 -0400, you wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
><CFQUERY name='cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city = '#city#'
> </CFQUERY>
> <CFOUTPUT>#neighborhood#<br></CFOUTPUT>
>
></CFOUTPUT>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.