.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Andy Matthews
To: CF-Talk
Sent: Mon Jul 31 20:49:48 2006
Subject: Cfloop timing out.
I'm going to be running a scheduled task nightly. It looks like this:
- Run a query (which will return probably around 130,000 rows
an UPDATE statement on each row.
- I'm importing data from another source and am not able to do this on
INSERT.
So the code itself works, but the query/cfloop is timing out. Any ideas on
how I can make sure this thing runs without error
cfsetting requesttimeout=largeValueInSeconds
At the top of the page in question. Just set the value to how long you would
like to allow ColdFusion to run this template. With all the usual caviots
about system resources and such.
--
Ian Skinner
Web Programmer
BloodSource
www.nylontechnology.com
Some people call me the space cowboy. Some people call me the gangster of
love.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:50 PM
To: CF-Talk
Subject: Cfloop timing out.
I'm going to be running a scheduled task nightly. It looks
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 3:00 PM
To: CF-Talk
Subject: RE: Cfloop timing out.
Can you have it run 100 rows at a time... Then CFLocation back to itself
with a new record offset and then run 100 more rows... Etc.
Ben Nadel
Web Developer
Nylon
What database is it that you are using?? If SQL Server and you have access to
it, and if it is possible and applicable in your case, the best thing to do
would be to create and schedule a DTS package.
cfsetting requesttimeout=largeValueInSeconds
At the top of the page in question. Just
Is there a way to prevent a cfloop from timing out? It is parsing a
gargantuan amount of data from UPS; the file in question is called by
cfmodule to ask it do this parsing...we have no control over the chunk
size we get
Process was working well for 4 years, and then boom, a weird one
cfsetting requesttimeout=1000
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 3:37 PM
To: CF-Talk
Subject: Prevent CFLOOP Timeout?
Is there a way to prevent a cfloop from timing out? It is parsing a
gargantuan amount of data from
Is there a way to prevent a cfloop from timing out? It is
parsing a gargantuan amount of data from UPS; the file in
question is called by cfmodule to ask it do this parsing...
we have no control over the chunk size we get
You can't control what happens within a page, but a loop
. If verification is
required please request a hard-copy version.
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tue 7/11/2006 2:47 PM
To: CF-Talk
Subject: RE: Prevent CFLOOP Timeout?
Is there a way to prevent
.
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tue 7/11/2006 2:47 PM
To: CF-Talk
Subject: RE: Prevent CFLOOP Timeout?
Is there a way to prevent a cfloop from timing out? It is
parsing a gargantuan amount of data from UPS; the file in
question
I'm pretty sure it still works... might be deprecated though...
-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 4:02 PM
To: CF-Talk
Subject: Re: Prevent CFLOOP Timeout?
The query string variation was discontinued in MX7 in favor
You can set the request timeout really high like this:
cfsetting requesttimeout=#aLotOfSeconds#
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 1:37 PM
Is there a way to prevent a cfloop from timing out? It is parsing a
gargantuan
FYI, IIRC the URL variable option doesn't work anymore, since they added
requesttimeout to the cfsetting tag.
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 1:58 PM
Okay, I was doing via URL variable, but I will do some
cfsetting
I'm pretty sure it still works... might be deprecated though...
No, it doesn't work as of CFMX 6.x.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Can we agree that with the code above, the expected output would be:
Outside Loop: a = 1 ,
Inside Loop: a = 1 , a = 1 , a = 1 , a = 1 , a = 1 ,
Outside Loop: b = 2 ,
Inside Loop: b = 2 , b = 2 , b = 2 , b = 2 , b = 2 ,
Outside Loop: c = 3 ,
Inside Loop: c = 3 , c = 3 , c = 3 , c = 3 , c = 3 ,
Sorry about resurrecting an old issue. I found what seems to be a similar
bug. Even if I save those to local variables at the top of the cfloop, if I
have a lot of processing in the middle I sometimes get that even outside the
inner cfloop/cfoutput.
In my case, query2 and query3 are set inside
, March 30, 2006 10:43 PM
To: CF-Talk
Subject: CFLOOP: Select Form in Edit Mode with Multiple Selections
(selected help)
All,
I'm trying to populate a (categories) select form with element in edit mode.
I'm
trying to loop through the entire list of categories while highlighting
(selected
size=3 multiple id=cat_id
CFOUTPUT query=GetCategoriesOutput
option value=#categorie_id# CFIF ISDEFINED (PRSubmit_EDIT)cfloop index
= ListElement list = #Edit_Get_Selected_PressRel.pre_cat_id#CFIF
ListElement IS
GetCategoriesOutput.categorie_idselected/CFIF/cfloop/CFIF#cat_name#/option
cfloop index = ListElement list =
#Edit_Get_Selected_PressRel.pre_cat_id# is the problem I think. The
column in the query won't be automatically expanded to a list - I'd
use a query-based cfloop instead.
On 3/31/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
All,
I'm trying to populate
value=#categorie_id# CFIF ISDEFINED (PRSubmit_EDIT) AND
ISDEFINED (pre_existing)cfloop index = ListElement list =
#Edit_Get_Selected_PressRel.pre_cat_id#CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF/cfloop/CFIF#cat_name#/option
683 : /CFOUTPUT
684 : /select/td
BAD: CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF
GOOD: CFIF #ListElement# IS
#GetCategoriesOutput.categorie_id#selected/CFIF
In if statement is CF you have to use
IS, EQ, NEQ
=]
--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer
Oh yeah,
You don't need the pound signs either.
CFIF ListElement IS GetCategoriesOutput.categorie_idselected/CFIF
--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer
~|
Message:
BAD: CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF
GOOD: CFIF #ListElement# IS
#GetCategoriesOutput.categorie_id#selected/CFIF
BETTER: CFIF ListElement IS
GetCategoriesOutput.categorie_idselected/CFIF
:-)
--
___
REUSE CODE! Use
Even better cfif ListElement IS
GetCategoriesOutput.categorie_idselected=selected/cfif
;)
On 3/9/06, Claude Schneegans [EMAIL PROTECTED] wrote:
BAD: CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF
GOOD: CFIF #ListElement# IS
: option value=#categorie_id# CFIF ISDEFINED (PRSubmit_EDIT) AND
ISDEFINED (pre_existing)cfloop index = ListElement list =
#Edit_Get_Selected_PressRel.pre_cat_id#CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF/cfloop/CFIF#cat_name#/option
683 : /CFOUTPUT
Try
CFOUTPUT query
=#categorie_id# CFIF ISDEFINED (PRSubmit_EDIT) AND
ISDEFINED (pre_existing)cfloop index = ListElement list =
#Edit_Get_Selected_PressRel.pre_cat_id#CFIF #ListElement# =
#GetCategoriesOutput.categorie_id#selected/CFIF/cfloop/CFIF#cat_name#/option
683 : /CFOUTPUT
Try
CFOUTPUT query
It is valid XHTML
Ah ok.
Personnally, I'll use XHTML when I'll need to, for the time being,
I prefer having all CFML and HTML tags and attributes in upper case,
and all variables and the rest of the code in lower case, question of
readibility,
but of course it is personal.
Closing unnecessary
If you do a cfexit method=exittag in your custom tags then you could do
the / method with them. Although maybe there are times that could not be
done, can not honestly think of a time but I am sure there are some. We use
a system here that uses a ton of custom tags and unfortunately it is just
If you do a cfexit method=exittag in your custom tags then you
could do
the / method with them.
Just what I mean: you have to do something.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any
client2
City2
client3
client4
Region 2
and so on.
Since the GROUP parameter since to conflict with the query of queries
(see previous message for details), can I achieve the same output
with a CFLOOP tag? I tried a few combinations
client2
City2
client3
client4
Region 2
and so on.
Something like:
cfset i = 1
cfoutput
cfloop condition=i LTE queryname.recordcount
cfset groupval1 = queryname.groupcol1[i]
#groupcol1[i]#
cfloop condition=i LTE queryname.recordcount
At 10:37 AM 3/4/2006, Jochem van Dieten wrote:
Regarding the CFOUTPUT GROUP issue with query of queries, is it
feasible to convert the output below to cfloop's?
Something like:
cfset i = 1
cfoutput
cfloop condition=i LTE queryname.recordcount
Thanks, I was trying loops with the query
querySetCell(variables.queryTwo,col1,0) /
cfdump var=#variables.queryTwo# /
cfloop query=variables.queryOne
br /
Outside Loop:cfdump var=#variables.queryOne.colA# /=cfdump
var=#variables.queryOne.currentRow# /,
br /
Inside Loop:
cfloop query=variables.queryTwo
I think this issue has been discussed a few days before.
It is a bug in CF (not in blue Dragon).
The current row of a first level loop is alway on when seen from an
inner loop.
The workaround is to store column values in variables at the first level.
--
___
The current row of a first level loop is alway on
Scuse, I meant is always ONE
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
But thats not the case. The current row is correct, even in the inner
loop, but the value is not.
On 3/3/06, Claude Schneegans [EMAIL PROTECTED] wrote:
I think this issue has been discussed a few days before.
It is a bug in CF (not in blue Dragon).
The current row of a first level loop is
Erf, I hit send before reading what I typed, last closing tag should be
/cfloop not /cfquery
On 2/25/06, Aaron Rouse [EMAIL PROTECTED] wrote:
If I need to actually output something from the query and I am not already
in a cfoutput block then I do cfoutput with the query attribute. I do
something that pops in my head when i do it and was just curious.
~Dave the disruptor~
From: Aaron Rouse [EMAIL PROTECTED]
Sent: Saturday, February 25, 2006 11:30 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: cfloop vs cfquery
If I need to actually
Most of the time I use cfoutput, but if I'm concerned about whitespace
output and I'm inside a cfsetting enablecfoutputonly=yes, I'll use
cfloop and then place cfoutput tags only around what I want to output.
Rick
~|
Message
I'm in your RabidAJAXChat...
where are ya dude?
Will
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233486
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
And it's definitely rabid tonight. Keeps refreshing whenever I send in some
text.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233487
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
I noticed =) I think ther's some kinda of javascript error.. gimme a
few minutes =)
Will Tomlinson wrote:
And it's definitely rabid tonight. Keeps refreshing whenever I send in some
text.
~|
Message:
I ain't got all night. lol! It's past my bedtime.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233490
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
I noticed =) I think ther's some kinda of javascript error.. gimme a
few minutes =)
This is the only chat room I've ever seen where you hafta enter your messages
via your login name. lol!!
I've been using these as logins tonight:
Hey Guys!
Wow, this is a cool chat room!
Rick, when will
Will Tomlinson wrote:
I ain't got all night. lol! It's past my bedtime.
me neither.. it's a javascript error in the cfajax engine.js but I don't
know why it started happening. Oh well, I'll figger it out eventually.
Rick
~|
Will Tomlinson wrote:
This is the only chat room I've ever seen where you hafta enter your messages
via your login name. lol!!
It's fixed Will! You can get on with life now!
Yay!
~|
Message:
Consider the following code:
cfoutput query=getRoster group=ENTITYID
cfset volunteers = getVolunteers(ENTITYID)
!-- volunteers is a query ---
cfoutput!-- output some stuff here --/cfoutput
cfloop query=volunteers
foo bar #ENTITYID#
/cfloop
stuff here --/cfoutput
cfloop query=volunteers
foo bar #ENTITYID#
/cfloop
/cfoutput
The reference to ENTITYID inside the cfloop breaks, says it doesn't
exist. Is that because CF only looks at the current query being looped
over?
It works fine if I add
PROTECTED]
Sent: Wednesday, February 22, 2006 12:17 PM
To: CF-Talk
Subject: cfloop over a query inside cfoutput over a query
Consider the following code:
cfoutput query=getRoster group=ENTITYID
cfset volunteers = getVolunteers(ENTITYID)
!-- volunteers is a query ---
cfoutput
Message -
From: Rick Root [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, February 22, 2006 9:16 AM
Subject: cfloop over a query inside cfoutput over a query
Consider the following code:
cfoutput query=getRoster group=ENTITYID
cfset volunteers = getVolunteers
= getVolunteers(ENTITYID)
!-- volunteers is a query ---
cfoutput!-- output some stuff here --/cfoutput
cfloop query=volunteers
foo bar #ENTITYID#
/cfloop
/cfoutput
The reference to ENTITYID inside the cfloop breaks, says it doesn't
exist
Ian Skinner wrote:
IIRC CF is going to automatically scope to the nearest query. To override
this you will need to fully scope the variable.
when I tried scoping it using getRosters.ENTITYID, it *ALWAYS* returned
the same entity id - the first one. It only works if I assign it to a
Strange, I code like that quite often and never have it return just the
first instance. It would return a repeat though since it would be inside an
inner loop. So if getRosters has a record count of 5 and then each
volunteers query has a record count of 4 you get displayed the same entity
ID 20
);
querySetCell(qry2,VOLUNTNAME,Jane E. Doe);
/cfscript
cfoutput query=qry1 GROUP=ENTITYID
#ENTITYID# #FULLNAME# #ZIP# br
Degrees: cfoutput#DEGREE# /cfoutputbr
cfloop query=qry2
!--- qry1.entityid should output the CURRENT entity,
but it does not ---
Volunteer: #qry1
Wow, the sample code I just posted behaves as I describe in CFMX7 on
Linux and Windows see: http://www.opensourcecf.com/test.cfm
but it behaves as I think it *SHOULD* on Bluedragon 6.2 JX (on Linux)
http://www.bobguiney.com/test.cfm
Could this be a bug in CF?
I don't have access to a
# #FULLNAME# #ZIP# br
Degrees: cfoutput#DEGREE# /cfoutputbr
cfloop query=qry2
!--- qry1.entityid should output the CURRENT entity,
but it does not ---
Volunteer: #qry1.ENTITYID# #VOLUNTID# #VOLUNTNAME#br
/cfloop
br
/cfoutput
Aaron Rouse wrote:
Interesting, now wouldn't a simple enough fix be to just add entityID to the
output of volunteers since that query is built off the id anyway?
That's called a workaround =) But yeah
But what if, for some reason, you couldn't return the entityid in the query?
Clearly,
6.1 on Windows here Rick. Here's the output of the code you provided:
123450 John A. Doe 48169
Degrees: BS
Volunteer: 123450 janedoe1 Jane A. Doe
Volunteer: 123450 janedoe2 Jane B. Doe
Volunteer: 123450 janedoe3 Jane C. Doe
Volunteer: 123450 janedoe4 Jane D. Doe
Volunteer:
It behaves as you described on 6.1
On 2/22/06, Rick Root [EMAIL PROTECTED] wrote:
Wow, the sample code I just posted behaves as I describe in CFMX7 on
Linux and Windows see: http://www.opensourcecf.com/test.cfm
but it behaves as I think it *SHOULD* on Bluedragon 6.2 JX (on Linux)
Rick, I ran into something like this myself not so long ago ans solved
it by adding the currentrow to the variable call, as in
cfloop query=volunteers
foo bar #getRoster.ENTITYID[currentRow]#
/cfloop
~|
Message: http
but it behaves as I think it *SHOULD* on Bluedragon 6.2 JX (on Linux)
IMHO this is clearly a bug in CF. I've noticed the same behaviour and
I'm also assigning columns to temporary variables.
It seems that CF retains only the deeper level query current row. Any
reference to an outter query is
okay good, so I wasn't going crazy. CF can't reference variables in the
current row of a a parent query loop from within a nested query loop
(but Bluedragon can)
Inside of another query, CF will treat the variable as simple string--much
like it would outside a cfloop query loop. There's 2 ways
by adding the currentrow to the variable call
This is it: The currentRow variable contains the right value, but the
row by default in an expression
is not set to currenRow, but to one.
--
___
REUSE CODE! Use custom tags;
See
Aaron Rouse wrote:
True, although ultimately my workaround would be to just pull out all the
data in one query and group over the entity ID then group over the volunteer
information.
Can't do that in my case, because I'm already grouping over OTHER data -
the degrees. That's why I had to go
it to a
different variable.
The solution was given in an earlier post. To use the complete, fully
qualified query scope, which is queryName.columname[rowNumber].
So this fob bar #getRoster.EntityID[currentRow]# should get what you want.
It is important to note that using cfoutput query=... and cfloop query
Well that's okay then. But I was HOPING you'd tell me you had a way to group
using cfloop darnit!
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL
Well you can, but you wouldn't want to. Just do the logic yourself by seeing
if the grouping column has changed, if it has, you've moved onto the next
group.
Ade
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: 16 December 2005 14:13
To: CF-Talk
Subject: RE: cfloop
, 2005 8:24 AM
To: CF-Talk
Subject: RE: cfloop vs cfoutput query - best practice
Well you can, but you wouldn't want to. Just do the logic yourself by seeing
if the grouping column has changed, if it has, you've moved onto the next
group.
Ade
-Original Message-
From: Andy Matthews [mailto
Well that's okay then. But I was HOPING you'd tell me you had a way to group
using cfloop darnit!
Well you can do it...but it's not that efficientrole your own code that
keeps track of the LAST loops value of the field you want to group onwhen
LAST value is not equal to current value
and will be not
displaying the data, is it better practice/more efficient to use cfloop
query= instead of cfoutput query=???
thanks in advance
charlie hanlon
developer
food service enablers, inc.
~|
Discover CFTicket - The leading ColdFusion
Ben Forta ran some tests on this one a while back, and I think it came out
pretty even.
You can probably google it and find his results.
Will
~|
Logware (www.logware.us): a new and convenient web-based time tracking
Here it is:
http://coldfusion.sys-con.com/read/41568.htm
Will
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message:
I prefer CFLOOP for all my query looping needs (even when I'm
outputting) assuming I don't need the grouping provided by CFOUTPUT.
I don't know if it's more efficient, but I think it makes the code
easier to read.
cheers,
barneyb
On 12/15/05, Charlie Hanlon [EMAIL PROTECTED] wrote:
First
IIRC, it doesn't matter anymore in terms of speed with CF6+
As a matter of personal preference, if there's no output I use a loop.
If there *is* output and I am using a loop I make sure I put the
cfoutputs outside the loop, but again I don't believe that makes any
difference unless you are on CF
used to matternot anymore...if ya want the technical details I can fill
them
in for you...I use CFLOOP exclusively
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL
That's not possible.
What if you want to group on a column? Cfloop can't do that, only cfoutput.
How do you get around that limitation? Because I would maim to be able to
use group with cfloop.
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530
That's not possible.
What if you want to group on a column? Cfloop can't do that, only cfoutput.
How do you get around that limitation? Because I would maim to be able to
use group with cfloop.
Well yes it is possible if you never (at least not in about 5 years) use the
grouping ability
I doubt you'll see a big performance hit either way. It would probably be
mostly up to you and what you find easier to read/follow when looking at
your code.
Generally speaking though, most people would expect to have something
displayed between cfoutput tags and would probably use cfloop
Hi guys,
I've appended a list and on this occasion my list outputs 1,3,5 (for
instance).
cfloop list=incorrectList index=thisItem
cfoutput#GetQuizQuestions.questionText[thisItem]# this
wrong/cfoutput
/cfloop
The problem i'm coming across an error which
Wack some #'s in there.
list=#incorrentList#
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 22:15
To: CF-Talk
Subject: cfloop list
Hi guys,
I've appended a list and on this occasion my list outputs 1,3,5 (for
instance
put poundage around the LIST attribute of your CFLOOP tag.
cfloop list=#incorrectList# index=thisItem
otherwise you're looping over the literal list 'incorrectList' which
is a one element list with the one element of 'incorrectList' :)
On 10/3/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote
) [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 4:15 PM
To: CF-Talk
Subject: cfloop list
Hi guys,
I've appended a list and on this occasion my list outputs 1,3,5 (for
instance).
cfloop list=incorrectList index=thisItem
cfoutput#GetQuizQuestions.questionText
Shouldn't that list variable have quotes around it?
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 5:15 PM
To: CF-Talk
Subject: cfloop list
Hi guys,
I've appended a list and on this occasion my list outputs
1,3,5
Subject: cfloop list
Hi guys,
I've appended a list and on this occasion my list outputs 1,3,5 (for
instance).
cfloop list=incorrectList index=thisItem
cfoutput#GetQuizQuestions.questionText[thisItem]# this
wrong/cfoutput
/cfloop
The problem i'm coming
Hi all,
I want to loop a structure and present the output in a form list select.
I'm able to put the query in a structure and dump it successfully, but the
cfloop collection code keeps throwing errors. How do I fix this? BTW: each
companyID is a UUID string; the QueryToStructofStructures is from
option
value=#companyID##SESSION.companyIDList[companyID].companyName
#/option
But why don't you just use the query?
Pascal
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: 29 April 2005 15:19
To: CF-Talk
Subject: Cfloop collection
Hi all,
I want to loop
!--- Form page ---
form
select name=companyID
option value=0- Select A Company/option
cfloop collection=#SESSION.companyIDList#
item=companyID
option
value=#SESSION.companyIDList.companyID##SESSION.company
IDList.companyName
#/option
/cfloop
/select
/form
Hi mark
Thanks, that worked.
I'm not using the query directly in this instance as I need to pass the
query to a different page for further processing.
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 9:32 AM
To: CF-Talk
Subject: RE: Cfloop collection
Thanks for helping me understand this correctly.
Mark
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 9:35 AM
To: CF-Talk
Subject: Re: Cfloop collection
!--- Form page ---
form
select name=companyID
option value=0- Select
Glad to help. :)
Thanks for helping me understand this correctly.
Mark
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
Is there any way to do grouped query output using cfloop? Reason is
that I use a switch/case statement for my page, and wrap the entire
thing in a cfoutput tag to make my code more readable. I would like
to do something like:
cfoutput query=foo group=groupcolumn
h1#groupcolumndata#/h1
cfoutput
output with cfloop?
Is there any way to do grouped query output using cfloop? Reason is
that I use a switch/case statement for my page, and wrap the entire
thing in a cfoutput tag to make my code more readable. I would like to
do something like:
cfoutput query=foo group=groupcolumn h1
You could put your grouped output in a separate file and cfinclude it...
-Brad
- Original Message -
From: Pete Ruckelshaus [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, March 22, 2005 9:53 AM
Subject: Grouped output with cfloop?
Is there any way to do grouped
against the column I
wanted to loop by.
Then, I'd loop over that query using CFLOOP and for every iteration,
I'd run a QofQ to select my data from the first query and loop that
for output.
I know, I know... performance, performance! Yeah, whatever.
It's squeaky clean, readable, sensible code. The first
I've got a structure like so:
Events[]
ARSG90IFNwcmluZ3M=7
MITGFtYXI=3
TXQXJsaW5ndG9u5
Yes, the elements are base64 encoded.
Anyway, I do a dump of the structure before running it in cfloop and it
is in the correct order that I want. Then I run this:
cfloop collection
are equivalent:
cfloop collection=#myStruct# item=i
#myStruct[i]#
/cfloop
cfloop list=#structKeyList(myStruct)# index=i
#myStruct[i]#
/cfloop
The latter can have a listSort wrapped around the structKeyList to
sort the keys which may or may not solve your problem, depending on if
the desired key
Thanks for that Barney. I did a search and found the same thing but it
still listed everything in that weird order. I played around with some
other things and finally found it, but for the life of me the change I
made didn't seem to make sense that it would affect the sort order. Ah
well, its
Incidentally MX also introduced StructSort() which does the same thing
for the collection loop because CF5 collection loops used to be sorted
automatically and they figured this was the fix (I've never understood
why they didn't just make this automatic in the cfloop tag for
backward compatibility
I choose based on my need.
If the page already has cfoutput blocks, then I use cfloop, unless I need to
group output and then I use cfoutput. On a new page, I typically choose
cfloop...
- Calvin
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 20
401 - 500 of 1085 matches
Mail list logo
