I have two queries. One gets the trial expiration date for today in the
trials_info dbase.
The other Select takes the trial name (dynamic as #get.name#) and searches for
the trial in the trials datasource and then grabs the email registrants in this
trial and emails them. I use an embedded
To: CF-Talk
Subject: Only one record
I have two queries. One gets the trial expiration date for today in the
trials_info dbase.
The other Select takes the trial name (dynamic as #get.name#) and
searches for the trial in the trials datasource and then grabs the email
registrants in this trial
]
cc_test2 -- [EMAIL PROTECTED]
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 12:55 PM
To: CF-Talk
Subject:RE: Only one record
Since you are only doing ONE grouping, that is all you will get in
return:
Try this:
cfoutput query
The simple cringe method would be to add maxrows=1 to your query or
your output code.
Chris
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 1:24 PM
To: CF-Talk
Subject: RE: Only one record
Thanks Randy, however, same result. It only
Validate your query using CFDUMP VAR=#gettrial#
You may only be getting the single result set.
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 1:24 PM
To: CF-Talk
Subject: RE: Only one record
Thanks Randy, however, same result
the dateAdd(now()) do for you?
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 1:24 PM
To: CF-Talk
Subject: RE: Only one record
Thanks Randy, however, same result. It only displays the one record
(table) and its emails.
cc_test -- [EMAIL
I have 2 queries and I need to know what to do to fix code that looks like
this.
As you will see I am only getting one record from my second query. In the
cfouput tags I have to specify a query and a group because I have nested
tags there is a reason for this. I just need to know how to make it
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED]
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:24 AM
To: CF-Talk
Subject: Returning only one record HELP PLEASE
I
!
--
SCOTT VAN VLIET
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED]
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:24 AM
To: CF-Talk
Subject: Returning only one record
-Talk
Subject: RE: Returning only one record HELP PLEASE
with that also work with 2 queries?
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002
, STEVEN M. (JSC-OL) (BAR)
[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 1:02 PM
Subject: RE: Returning only one record HELP PLEASE
I am not allowed to post data. but what I put out is very close to what I
have..
I have multiple records in both tables and query2
At 12:02 PM 3/26/02 -0600, LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote:
cfquery Name=query2 Datasource=DSN
Select column12, column22
From Table1
/cfquery
If you just do this:
CFOUTPUT Query=Query2
BR #Column12, #column22#
/CFOUTPUT
Do you get multiple records?
CFOUTPUT Query=query1
Get rid of the group parameter of your cfoutput
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 1:02 PM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE
I am not allowed to post data. but what I
query2 can output up to 7 records..
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:24 PM
To: CF-Talk
Subject: Re: Returning only one record HELP
yes
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:23 PM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE
At 12:02 PM 3/26
you can't when you have nested tags.
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Albrechtas, Adam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:14 PM
To: CF-Talk
Subject: RE: Returning only one record HELP
: RE: Returning only one record HELP PLEASE
query2 can output up to 7 records..
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:24 PM
PROTECTED]]
Sent: Tuesday, March 26, 2002 10:32 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE
you can't when you have nested tags.
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Albrechtas, Adam
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:54 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE
What are you trying to accomplish?
The GROUP
:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:39 PM
To: CF-Talk
Subject: Re: Returning only one record HELP PLEASE
OK, so are the results in query2 dependent upon what's returned in query1 or
is it just listing the query results everytime?
Sharon
- Original Message -
From
: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 10:43 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE
Actually after I get the result which are dates I take the dates from query1
and put up against the dates in query2, but query1
That Worked Thank You!!
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 12:39 PM
To: CF-Talk
Subject: RE: Returning only one record HELP
22 matches
Mail list logo