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.

Reply via email to