Query with a Query problem!

2000-08-30 Thread Adam Smith
Hi people, I'm new to ColdFusion and I'm already stuck with a query problem! Basically I have 2 tables, Table 1 contains fields name, address, email address. Table 2 has the same fields. I want to query all the records in Table 2 in one go with the values from Table 1. Then I want to output all

RE: Query with a Query problem!

2000-08-30 Thread Olive, Christopher M Mr NMR
t; AND SearchDetails.email = '#Query1.email#' /CFIF /CFQUERY CFIF Query2.recordcount NEQ 0 #name#br #address#br #email#br /CFIF /CFOUTPUT Chris Olive, DOEHRS Website Administrator -Original Message- From: Adam Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 10:06 AM To:

RE: Query with a Query problem!

2000-08-30 Thread Don Bellamy
-- From: Adam Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 10:06 AM To: [EMAIL PROTECTED] Subject: Query with a Query problem! Hi people, I'm new to ColdFusion and I'm already stuck with a query problem! Basically I have 2 tables, Table 1 contains fields name, address, emai

Re: Query with a Query problem!

2000-08-30 Thread Terri Stocke
UserDetails.address AND SearchDetails.email = UserDetails.email /cfquery Original Message Follows From: Adam Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Query with a Query problem! Date: Wed, 30 Aug 2000 10:06:04 -0400 (EDT) Hi people, I

Re: Query with a Query problem!

2000-08-30 Thread Graham Lewis
in two tables currently makes if you see what I mean. Graham On 30 Aug 00, at 10:06, Adam Smith wrote: Hi people, I'm new to ColdFusion and I'm already stuck with a query problem! Basically I have 2 tables, Table 1 contains fields name, address, email address. Table 2 has the same

Re: Query with a Query problem!

2000-08-30 Thread Adam Smith
30, 2000 2:50:54 PM GMT Subject: Re: Query with a Query problem! Just a thought: I don't know the details of your database application but from your description, I wonder whether you need to have two tables. If the same fields are in both, perhaps you could manage with one table and perhaps

RE: Query with a Query problem!

2000-08-30 Thread Adam Smith
ot; [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Sent: August 30, 2000 2:20:38 PM GMT Subject: RE: Query with a Query problem! by default, if you don't specify a QUERY attribute in the CFOUTPUT, and just scope the variable with the query name, you'll get the first record. if

Re: Query with a Query problem!

2000-08-30 Thread Deanna L. Schneider
I think what you want is something like so: cfoutput query="yourquery" group="thegroupthatthethreerelateto" cfoutput #name#br #address#br #email#br /cfoutput /cfoutput See if that works. -d Deanna Schneider Interactive Media