Thanks Brad, I'll see if I can find an example of what you suggested.
Best
Steve
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 26, 2008 8:02 PM
To: CF-Talk
Subject: RE: cfloop question
Try creating and looping over a query object instead of a
Try creating and looping over a query object instead of a list.
Then you can have a column in each record for the first name, last name,
e-mail, and whatever else you want.
The Cfmail tag actually has a query attribute built in for that purpose.
Then you output the variables just like you would
#thisTerm#
;
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 7:08 PM
To: CF-Talk
Subject: RE: cfloop question
;
-Original Message
;
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 11:41 AM
To: CF-Talk
Subject: RE: cfloop question
Leaves a trailing semi-colon at the end
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05
Leaves a trailing semi-colon at the end
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 1:14 PM
To: CF-Talk
Subject: RE: cfloop question
why not just type a semi-colon after it? ie. #thisTerm#;
-Original Message-
From: Scott
why not just type a semi-colon after it? ie. #thisTerm#;
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 10:25 AM
To: CF-Talk
Subject: cfloop question
Hey All,
I have a cfloop over a semi colon delimited list
Blah; yadda; whatever
On 4/5/07, Scott Stewart <[EMAIL PROTECTED]> wrote:
> Hey All,
> I have a cfloop over a semi colon delimited list
>
> "Blah; yadda; whatever"
>
>
>
>
>
> href="#request.site.myself##XFA.search#&latSearchType=i&term=#request.objSea
> rchEngine.RemoveHighlights(thisTermlink)#">#thisTer
Thanks to everyone, CurrentRow did the trick.
- Charles
>Charles,
>
>Don't forget that any query object has a few variables built into it
>that you can make use of, RecordCount, the total number of records in
>a query, and CurrentRow - the current one.
>
>Here's a guess at a query loop that might
Hes trying to get the count inside the nested list loop not the cfoutput of
the query
_
From: Nando [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 28, 2004 1:21 AM
To: CF-Talk
Subject: Re: CFLoop question...
Charles,
Don't forget that any query object has a few variables
Charles,
Don't forget that any query object has a few variables built into it
that you can make use of, RecordCount, the total number of records in
a query, and CurrentRow - the current one.
Here's a guess at a query loop that might be helpful in your case.
Adapt to suit your need.
Select a nam
Try using something else as your counter
I is being used as your index
Here, the county will be the number of loops
#foo# -- #i#
Use QueryName.CurrentRow to get the current row number from your query
_
From: Charles Heizer [mailto:[EMAIL P
I suppose ;)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 5:06 PM
To: CF-Talk
Subject: RE: cfloop question
Hey, you
, October 27, 2003 4:31 PM
To: CF-Talk
Subject: RE: cfloop question
Tony:
Put pound signs around your queryName.recordCount in the CFLOOP tag as in:
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message
, 2003 4:31 PM
To: CF-Talk
Subject: RE: cfloop question
Tony:
Put pound signs around your queryName.recordCount in the CFLOOP tag as in:
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From
, 2003 4:24 PM
To: CF-Talk
Subject: Re: cfloop question
index i is the value of "currentRow"
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: Tuesday, October 28, 2003 10:18 AM
Subject: cfloop question
#queryName.currentRow[i]# #queryName
Tony:
Put pound signs around your queryName.recordCount in the CFLOOP tag as in:
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, October
Just use 'i'. currentrow is the index that CF uses internally when it's
doing a CFOUTPUT query="get" or a CFLOOP of hte same type. it's not part of
the recordset object.
banreyb
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:18 PM
To
index i is the value of "currentRow"
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: Tuesday, October 28, 2003 10:18 AM
Subject: cfloop question
#queryName.currentRow[i]# #queryName.address[i]#
#get.currentRow[i]# for some reason doesn't parse. it errors a
Something along those lines should work.
Ade
-Original Message-
From: Paul Campano [mailto:[EMAIL PROTECTED]
Sent: 30 June 2003 16:55
To: CF-Talk
Subject: CFLOOP question
I am looping through items in a shopping cart and need to add up the price
of each item to get a total
In your loop you can do
> I am looping through items in a shopping cart and need to add up the
price
> of each item to get a total price. How would I do this? I thought
about
> setting a variable "price" per iteration through the loop, but that
just
> gets overwritten each time. Thanks.
mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 11:51 AM
To: CF-Talk
Subject: CFLOOP question
I am looping through items in a shopping cart and need to add up the price
of each item to get a total price. How would I do this? I thought about
setting a variable "price" per iteration throug
Mike
- Original Message -
From: "Paul Campano" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 11:55 AM
Subject: CFLOOP question
> I am looping through items in a shopping cart and need to add up the price
> of each item to get a total price. Ho
You can simply add up the column total beforehand. - no need to loop and
add them up etc.
-Original Message-
From: Paul Campano [mailto:[EMAIL PROTECTED]
Sent: 30 June 2003 16:55
To: CF-Talk
Subject: CFLOOP question
I am looping through items in a shopping cart and need to add up the pr
How about if you put # sign's around insert_counter in
the first cfswitch expression?
Heidi
--- JB Mentzer <[EMAIL PROTECTED]> wrote:
> Hi all
>
> I'm attempting to overwrite the index value of a
> CFLOOP from within the
> loop:
>
> STEP="1">
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Don't try to change a loop index.
Use a CASE tag to take care of the cases for which an action is required, as
you do for VALUE="1". Don't provide a CASE tag for the values for which no
action is required.
And don't forget the pound signs around the expression:
EXPRESSION="#insert_counter#"
Many thanks - I was focusing on tblGroups and didn't even think going the
other way as you have suggested
your first code worked beautifully
thanks again
Seamus
At 11:59 am 10/05/01 , you wrote:
>You could probably do this with cfloop but why. Let the database do the
>work for you. I am a li
You could probably do this with cfloop but why. Let the database do the
work for you. I am a little confused to when you say zero product
descriptions. Does this mean an entry in tblproduct where there is a
groupcode but no productdescription, meaning its null. Another option,
which what
You can get a comma-delimited list of all the values in any query column
using the ValueList() function. You can also use the RecordCOunt property
of a query to see how many rows it returned. Example:
SELECT id FROM myTable
-Rick
-Original Message-
From: aslam bajaria [mailto:[EMAIL
At 03:51 AM 7/7/00 -0400, you wrote:
>Sorry about all the detail. I just thought it would make it easy to
>explain my problem.
Detail is our friend.
>I am doin g two queries in a loop 1 to get main items and one to get
>item details. I am trying to get them to match by the two fields
>ScenarioD
29 matches
Mail list logo