I think what you want is something like so:
#name#
#address#
#email#
See if that works.
-d
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Ma
The SEARCH RESULT count is: 3.
It only displayed the full details of 1 record???
--Original Message--
From: "Olive, Christopher M Mr NMR" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Sent: August 30, 2000 2:20:38 PM GMT
Sub
August 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
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 an additional field that makes
whatever distinction having them i
Adam,
If you want only the records that match from table 1 and table 2, try this:
SELECT *
FROMSearchDetails, UserDetails
WHERE SearchDetails.name = UserDetails.name AND
SearchDetails.address = UserDetails.address AND
SearchDetails.email = UserDetails.
Try this...
SELECT *
FROM SearchDetails, UserDetails
WHERE SearchDetails.name = UserDetails.name
AND SearchDetails.adress = UserDetails.address
AND SearchDetails.email = UserDetails.email
> -Original Message-
> From: Adam Smith [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30,
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 you wrap the second CFQUERY in a CFOUTPUT, you'll be good.
eg.
SELECT name,address,email
FROMSearchDetails, UserDetails
WHERE
Sear
7 matches
Mail list logo