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
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:
--
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
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
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
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
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
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
8 matches
Mail list logo