CFLOOP sort order

2002-04-24 Thread Jake McKee
Is there an easy way to spit out the contents of a CFLOOP backwards? So if my CFLOOP yields this: Item 1 Item 2 Item 3 Item 4 .. how do I make it spit out this: Item 4 Item 3 Item 2 Item 1 Thanks! __ Signup for the

RE: CFLOOP problem with commas

2002-04-24 Thread Ryan Kime
haracter delimiters." -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:55 PM To: CF-Talk Subject: RE: CFLOOP problem with commas Huh. Okay. I've never experienced a problem with them. Which isn't to say that no one will.

Re: CFLOOP problem with commas

2002-04-23 Thread James Sleeman
> As you can see, the first URL outputs normally, but the second URL > breaks at every comma. Is there a way around this? I don't want to > insert Chr() codes if I can help it! Remember that when picking a delimiter, any character is fair game, you can be pretty much assured that something like t

RE: CFLOOP problem with commas

2002-04-23 Thread Ryan Kime
-Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:25 PM To: CF-Talk Subject: CFLOOP problem with commas I am trying to CFLOOP through a collection of URLs. The problem comes from the fact that there are commas in some of the URLs. To illustr

RE: CFLOOP problem with commas

2002-04-23 Thread Tim Claremont
Thanks for the help. Ray came through for me for the second time today. Since I *KNOW* that I am looping through URLs, then I *KNOW* that a space is a valid delimiter. I plugged it in and it worked perfectly. Now I can go home on time. Thanks, Ray! _

RE: CFLOOP problem with commas

2002-04-23 Thread Ryan Kime
How about URLEncodedFormat in, URLDecode out? That way, you can keep your comma as the delimiter. Ryan Kime -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:39 PM To: CF-Talk Subject: RE: CFLOOP problem with commas Guys

RE: CFLOOP problem with commas

2002-04-23 Thread Lon Lentz
Huh. Okay. I've never experienced a problem with them. Which isn't to say that no one will. > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 23, 2002 4:39 PM > To: CF-Talk > Subject: RE: CFLOOP problem

Re: CFLOOP problem with commas

2002-04-23 Thread Matthew Walker
it's much safer. - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 8:30 AM Subject: RE: CFLOOP problem with commas > >As you can see, the first URL outputs normally, b

RE: CFLOOP problem with commas

2002-04-23 Thread Raymond Camden
rce, and a powerful ally it is." - Yoda > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 23, 2002 4:39 PM > To: CF-Talk > Subject: RE: CFLOOP problem with commas > > > Guys, > > Delimeters that are m

RE: CFLOOP problem with commas

2002-04-23 Thread Mark A. Kruger - CFG
Guys, Delimeters that are more than 1 (or 2?) characters don't always work in my experience. CF kinda just uses 1 character for a delimeter. -mk -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:40 PM To: CF-Talk Subject: RE: CFLOOP pr

RE: CFLOOP problem with commas

2002-04-23 Thread Mark A. Kruger - CFG
lto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 3:25 PM To: CF-Talk Subject: CFLOOP problem with commas I am trying to CFLOOP through a collection of URLs. The problem comes from the fact that there are commas in some of the URLs. To illustrate the problem, my code is as follows: http://www.

RE: CFLOOP problem with commas

2002-04-23 Thread Lon Lentz
3, 2002 4:25 PM > To: CF-Talk > Subject: CFLOOP problem with commas > > > I am trying to CFLOOP through a collection of URLs. The problem comes > from the fact that there are commas in some of the URLs. To illustrate > the problem, my code is as follows: > > "http://www

RE: CFLOOP problem with commas

2002-04-23 Thread Shawn Grover
change your delimiter. that should solve the problem. (it's off the top of my head, so could be a little wrong). Shawn Grover -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 2:25 PM To: CF-Talk Subject: CFLOOP problem with comma

RE: CFLOOP problem with commas

2002-04-23 Thread Raymond Camden
>As you can see, the first URL outputs normally, but the second URL >breaks at every comma. Is there a way around this? I don't want to >insert Chr() codes if I can help it! Actually, why not? Normally I don't like this hack because you have to assume your inserted char doesn't exist, but for U

CFLOOP problem with commas

2002-04-23 Thread Tim Claremont
I am trying to CFLOOP through a collection of URLs. The problem comes from the fact that there are commas in some of the URLs. To illustrate the problem, my code is as follows: http://www.foobar.com/selector/en/prodselect.asp?Xcntry=USA&Xlang=en_US &error=novars"> http://www.foo

Re: CFLOOP and CFOUTPUT

2002-03-09 Thread Jochem van Dieten
Plane, Nathaniel wrote: > Eek, what about ? You wouldn't be able to group result > sets in this case. Just use a conditional loop which is not over the query as a query, but over the query as a structure of arrays. Have to do that anyway if you want to jump back and forth between rows. > And

RE: CFLOOP and CFOUTPUT

2002-03-08 Thread Tyler M. Fitch
From: Plane, Nathaniel [mailto:[EMAIL PROTECTED]] -- Eek, what about ? And what about page includes, those would be out of the question (including a page with another cfoutput without a group parameter would throw an error). This coding method has quite a few consequences associated with it, i w

RE: CFLOOP and CFOUTPUT

2002-03-08 Thread Plane, Nathaniel
Subject: RE: CFLOOP and CFOUTPUT Correct, when first introduced was s-l-o-w, but nowadays you'll actually find that it outperforms . --- Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:12 AM To: CF-Talk Subject: Re: CFLOO

RE: CFLOOP and CFOUTPUT

2002-03-08 Thread Plane, Nathaniel
age- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 10:54 AM To: CF-Talk Subject: Re: CFLOOP and CFOUTPUT This one came through the list abouyt a month ago, so you may want to check the archives. The basic result was that CFLOOP is the way to go. Personally I w

Re: CFLOOP and CFOUTPUT

2002-03-08 Thread Paul Giesenhagen
So, does cfloop perform better than cfoutput or are they now comparable? Gunna have to change my way of thinking! Paul Giesenhagen QuillDesign http://www.quillldesign.com SiteDirector - Commerce Builder - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" &

RE: CFLOOP and CFOUTPUT

2002-03-08 Thread Ben Forta
Correct, when first introduced was s-l-o-w, but nowadays you'll actually find that it outperforms . --- Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:12 AM To: CF-Talk Subject: Re: CFLOOP and CFOUTPUT Yup. CFLO

Re: CFLOOP and CFOUTPUT

2002-03-08 Thread ksuh
Yup. CFLOOP no longer sucks. Thank god. - Original Message - From: "Park, Simon" <[EMAIL PROTECTED]> Date: Friday, March 8, 2002 8:13 am Subject: CFLOOP and CFOUTPUT > I know that the prevailing wisdom is that CFOUTPUT with the Query > attributeis faster than

Re: CFLOOP and CFOUTPUT

2002-03-08 Thread Bryan Stevenson
This one came through the list abouyt a month ago, so you may want to check the archives. The basic result was that CFLOOP is the way to go. Personally I wrap my entire page in CFOUTPUT tags and always use CFLOOP to output queries etc. IMHO it makes the code easier to read becaue I don&#

Re: CFLOOP and CFOUTPUT

2002-03-08 Thread Stephen Moretti
uld use for writing your own grouping in a CFLOOP. I've use both grouped cfoutputs and grouped cfloops. Really it just depends what I want to do with the data and the groups. (warning favourite phrase of the moment) Horses for courses. Choose the one that matches your needs best. Simpl

Re: CFLOOP and CFOUTPUT

2002-03-08 Thread Dave Carabetta
>I know that the prevailing wisdom is that CFOUTPUT with the Query attribute >is faster than CFLOOPing over a query. However, in Forta's CF 5 >Certification Study Guide, he states that CFLOOP performs better (p. 37 and >374). Has CF 5 improved the performance of CFLOOP (Steve

CFLOOP and CFOUTPUT

2002-03-08 Thread Park, Simon
I know that the prevailing wisdom is that CFOUTPUT with the Query attribute is faster than CFLOOPing over a query. However, in Forta's CF 5 Certification Study Guide, he states that CFLOOP performs better (p. 37 and 374). Has CF 5 improved the performance of CFLOOP (Steve Drcuker referred

RE: simple cfloop

2002-03-05 Thread Bill Killillay
try this for your query select, this, that, theotherthing from tblName where id IN (#form.ids#) -Original Message- From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:33 PM To: CF-Talk Subject: simple cfloop Beginner CFer with an easy question. The situation

RE: simple cfloop

2002-03-03 Thread stas
You don't need multiple queries. Just run one query with WHERE ID IN (#form.id#) and do a . -Original Message- From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:33 PM To: CF-Talk Subject: simple cfloop Beginner CFer with an easy question. The situation

Re: simple cfloop

2002-03-03 Thread Kelly Matthews
Yep in is much better, quicker too! [EMAIL PROTECTED] writes: > >SELECT this, that, theotherthing >FROM tblName >WHERE ID IN (#id#) > > > >#this##that##theotherthing# > ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35

Re: simple cfloop

2002-03-03 Thread Paul Giesenhagen
this##that##theotherthing# You could also do "IN" SELECT this, that, theotherthing FROM tblName WHERE ID IN (#id#) #this##that##theotherthing# - Original Message - From: "Sorgatz, Rex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: S

simple cfloop

2002-03-03 Thread Sorgatz, Rex
Beginner CFer with an easy question. The situation: the user selects the rows to query based upon ticking checkboxes. So, this is the first page: Using a list and a cfloop to return multiple columns in only the rows the user selects, what would the tally.cfm page look like? I'm lo

CFLOOP?

2001-12-16 Thread Joel Blanchette
iqtest. How to I parse the text and the variables?? Do I use a cfloop??? If yes how? Thanks for all the help! Joel ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community

Re: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Don Vawter
Lol just yankin your chain, wanted to make sure you were awake. - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 2:43 PM Subject: RE: Stumped: Getting recordcount f

FW: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Dave Wilson
Tried sending this earlier but it returned undeliverable > -Original Message- > From: Dave Wilson [mailto:[EMAIL PROTECTED]] > Sent: 05 December 2001 17:50 > To: [EMAIL PROTECTED] > Subject: RE: Stumped: Getting recordcount for dynamic query within a > c

RE: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Raymond Camden
CF-Talk > Subject: Re: Stumped: Getting recordcount for dynamic query within a > cfloop > > > If that doesnt work try > > > > (now I will sit back and wait for Raymond to present solution that doesn't > use evaluate ;} ) > > ~

Re: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Don Vawter
5, 2001 10:50 AM Subject: Re: Stumped: Getting recordcount for dynamic query within a cfloop > I may be way off.hope not > > > Can you do a > > > > do this > > do this > > > > > Doug > > > > - Original Message - > From: "

RE: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Zac Belado
> 01 > 02 > 03 > 04 > 05 > 06 DO THIS > 07 DO THAT > 08 > 09 > 10 Try using evaluate ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/

RE: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Mike Townend
To do what you want to do you will need to use the Evaluate function... Ie etc -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 05 December 2001 17:30 To: CF-Talk Subject: Stumped: Getting recordcount for dynamic query within a cfloop I have a

Re: Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Douglas Brown
count for dynamic query within a cfloop > I have a cfapp that is working fine except for one small item and I > can't figure out how to handle this piece of it. Simplest way to > describe the issue is probably to describe the two steps involved that > are giving me a problem. > &g

Stumped: Getting recordcount for dynamic query within a cfloop

2001-12-05 Thread Paul Sinclair
ne in the following query cfloop is pretty simple - it just takes the results of an earlier query, and then generates a series of new queries with the query names based on a field from the earlier query. select * from newsletterItems where newsletterID = #newsletterid# and newsletterHead

RE: Counting in a Field? cfloop

2001-10-26 Thread Mark Stewart
Field? cfloop How can i take the values of a field & count them? GP Phase: #GF_Phases# returns: GF_Phases: 4,2,7 GP Phase: 4 GP Phase: 2 GP Phase: 7 i would like it to count like this instead GP Phase: 1 GP Phase: 2 GP Phase: 3 how could i do this? thank

Re: Counting in a Field? cfloop

2001-10-26 Thread Stephen Moretti
quot;CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 12:44 PM Subject: Counting in a Field? cfloop > How can i take the values of a field & count them? > > > GP Phase: #GF_Phases# > > > returns: GF_Phases: 4,2,7 > > GP Phase: 4 > GP Phase:

Counting in a Field? cfloop

2001-10-26 Thread Paul Ihrig
How can i take the values of a field & count them? GP Phase: #GF_Phases# returns: GF_Phases: 4,2,7 GP Phase: 4 GP Phase: 2 GP Phase: 7 i would like it to count like this instead GP Phase: 1 GP Phase: 2 GP Phase: 3 how could i do this? thank you -paul ~

RE: Using CFLoop to delete from an Array 2

2001-10-01 Thread Owens, Howard
OTECTED]] > Sent: Monday, October 01, 2001 7:28 AM > To: CF-Talk > Subject: RE: Using CFLoop to delete from an Array 2 > > Change > > > the array is empty > > > to > > > the array is empty > > > Assuming that session.cart is not an arra

RE: Using CFLoop to delete from an Array 2

2001-10-01 Thread Owens, Howard
o1956 > -Original Message- > From: Raymond Camden [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 5:47 AM > To: CF-Talk > Subject: RE: Using CFLoop to delete from an Array 2 > > So, your saying that you delete all the items in the array, and the >

RE: Using CFLoop to delete from an Array 2

2001-10-01 Thread Craig Dudley
Change the array is empty to the array is empty Assuming that session.cart is not an array of arrays. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 October 2001 01:07 To: CF-Talk Subject: RE: Using CFLoop to delete from an Array 2 OK, Now that

RE: Using CFLoop to delete from an Array

2001-10-01 Thread Raymond Camden
powerful ally it is." - Yoda > -Original Message- > From: Hanz Zarcovic [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 5:44 PM > To: CF-Talk > Subject: Re: Using CFLoop to delete from an Array > > > You probalby

RE: Using CFLoop to delete from an Array 2

2001-10-01 Thread Raymond Camden
r for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 8:27 PM > To: CF-Talk > Subje

RE: Using CFLoop to delete from an Array 2

2001-09-30 Thread howard
CFLoop to delete from an Array 2 How about trying the Arraylen() function? Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http

RE: Using CFLoop to delete from an Array 2

2001-09-30 Thread Kevin Langevin
How about trying the Arraylen() function? Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 8:07 PM > To: CF-Talk > Subject: RE: Using C

RE: Using CFLoop to delete from an Array 2

2001-09-30 Thread howard
OK, Now that I've got the multiple deletes from the array working (thanks, guys) .. I've got a problem when every element in the array is deleted (an option a user could conceivably take). There is later on the page, of course, code that assumes there is going to be information in the array to r

RE: Using CFLoop to delete from an Array

2001-09-30 Thread howard
Doh! I knew it would be something simple. Thanks. H. -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 2:25 PM To: CF-Talk Subject: RE: Using CFLoop to delete from an Array Then you'll need to do "desc")>

Re: Using CFLoop to delete from an Array

2001-09-30 Thread Hanz Zarcovic
> > > > > #ArrayDeleteAt(session.cart, i)# > > #ArrayResize(session.cart, 1)# > > > > > > > > - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 5:25 PM Subje

RE: Using CFLoop to delete from an Array

2001-09-30 Thread cf refactoring
] > Sent: Sunday, September 30, 2001 1:46 PM > To: CF-Talk > Subject: Re: Using CFLoop to delete from an Array > > > I think what you are describing is a common problem. > The problem is that when you start your loop the > array is 7 elements long, > you delete the first a

RE: Using CFLoop to delete from an Array

2001-09-30 Thread howard
That's what I was trying to do with the ListSort() function. H. -Original Message- From: Hanz Zarcovic [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 1:46 PM To: CF-Talk Subject: Re: Using CFLoop to delete from an Array I think what you are describing is a c

Re: Using CFLoop to delete from an Array

2001-09-30 Thread Hanz Zarcovic
*down to* the first item. This way you are never trying to delete an item that dosen't exist. Hope this helps. -eric - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 4:08 PM Subject: Using CFLoop to

Using CFLoop to delete from an Array

2001-09-30 Thread howard
se the first element isn't a simple variable), and trying to get the cfloop to remove the bottom item before the top item. That isn't working. Below is my current code, but my question is ... how can I loop through the array and remove all of the items I want? Current Co

RE: CFLOOP inside CFMAIL query

2001-09-11 Thread Erika L. Walker
yes. Erika (with a *K*) -- >>--| -Original Message- >>--| From: Bruce Holm [mailto:[EMAIL PROTECTED]] >>--| Sent: Tuesday, September 11, 2001 9:32 PM >>--| To: CF-Talk >>--| Subject: CFLOOP inside CFMAIL q

CFLOOP inside CFMAIL query

2001-09-11 Thread Bruce Holm
Can a CFLOOP be placed between CFMAIL and /CFMAIL tags that are looping over a query and group? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED

RE: CFLoop inside an update query

2001-07-17 Thread Bryan Love
] -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 9:20 AM To: CF-Talk Subject: CFLoop inside an update query Hi, Im building a dynamic update query by looping over the form structure within the query- but how can I build the loop so that the comma is

RE: CFLoop inside an update query

2001-07-17 Thread Costas Piliotis
: CFLoop inside an update query Hi, Im building a dynamic update query by looping over the form structure within the query- but how can I build the loop so that the comma is left off after the last iteration of the loop? I've tried nesting loops to no avail. Any quick pointers appreciated. Here i

RE: CFLoop inside an update query

2001-07-17 Thread Russel Madere
, July 17, 2001 11:20 AM > To: CF-Talk > Subject: CFLoop inside an update query > > > Hi, > Im building a dynamic update query by looping > over the form structure within the query- but how can I > build the loop so that the comma is left off after the last > iteration of t

RE: CFLoop inside an update query

2001-07-17 Thread Gary Longford
- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 17:20 To: CF-Talk Subject: CFLoop inside an update query Hi, Im building a dynamic update query by looping over the form structure within the query- but how can I build the loop so that the comma is left off after the last

CFLoop inside an update query

2001-07-17 Thread Tristram Charnley
Hi, Im building a dynamic update query by looping over the form structure within the query- but how can I build the loop so that the comma is left off after the last iteration of the loop? I've tried nesting loops to no avail. Any quick pointers appreciated. Here is the query so far: UPDATE

RE: CFFILE Output--how do I include CFLOOP and session variables

2001-07-16 Thread Bud
On 7/16/01, Megan Cytron penned: > > I don't believe you can place cf tags inside of ANY cf >> tags. Try something like this: >> >> >> >> > To="#ArrayLen(session.cart)#"> >> > #session.cart[loopcount][3]# >> VARIETY: #session.cart[loopcount][1]# >> QUANTITY:

RE: CFFILE Output--how do I include CFLOOP and session variables

2001-07-16 Thread Megan Cytron
> I don't believe you can place cf tags inside of ANY cf > tags. Try something like this: > > > > To="#ArrayLen(session.cart)#"> > #session.cart[loopcount][3]# > VARIETY: #session.cart[loopcount][1]# > QUANTITY: #session.cart[loopcount][4]# > "> > Yes

RE: CFFILE Output--how do I include CFLOOP and session variables

2001-07-16 Thread Paul Mone
nsulting Group [EMAIL PROTECTED] http://www.ninthlink.com 619.222.7082 -Original Message- From: Megan Cytron [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 15, 2001 11:01 PM To: CF-Talk Subject: CFFILE Output--how do I include CFLOOP and session variables I'll preface this dodo-brain

Re: CFFILE Output--how do I include CFLOOP and session variables

2001-07-16 Thread Bud
On 7/16/01, Megan Cytron penned: >Here's my code: > > > ITEM CODE:#session.cart[loopcount][3]# > VARIETY: #session.cart[loopcount][1]# > QUANTITY: #session.cart[loopcount][4]# > > >"> > > FILE="E:\websites\foo.txt" > OUTPUT="#textoutpu

CFFILE Output--how do I include CFLOOP and session variables

2001-07-15 Thread Megan Cytron
led "textoutput". When I put CFLOOP in "textoutput" and then reference it within CFFILE, all of my session variables (from a shopping cart) get messed up and I get an error message saying that my session variables are no longer there. (My shopping cart is working fine elsewhere and

Re: cfloop and group

2001-07-10 Thread Jennifer Knoblock
array of only two items (documentID and headingID). If this is the > case then why are you looping over the second dimension? This would cause > the exact same query to be run twice, outputting the same single record each > time. If this is the case then just eliminate the inner CFLOOP and r

RE: cfloop and group

2001-07-07 Thread Bryan Love
is is the case then why are you looping over the second dimension? This would cause the exact same query to be run twice, outputting the same single record each time. If this is the case then just eliminate the inner CFLOOP and remove GROUP= from the CFOUTPUT. Secondly, putting a query ins

cfloop and group

2001-07-05 Thread Jennifer Knoblock
Hello! (It's good to see all of you back!) I posted this on Allaire/Macromedia support forums also, but I really, really need an answer to this... Is there some reason CF group wouldn't work if it was wrapped up in cfloop tags? I can't get this query to group the the articles

Re: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bill Davidson
t? -Bill www.brainbox.tv - Original Message - From: "David E. Crawford" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 3:10 PM Subject: Re: Is it possible to nest CFQUERY inside CFLOOP? > The cfoutput inside a cfloop is unneces

RE: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Steve Martin
CFQUERY is allowed in any type of CFLOOP so the addition of CFOUTPUTs into the loop is irrelevant. This thread reminded me of a BUG in CF which I can confirm is still in CF5RC (haven't checked with the final release yet but I doubt it has changed!) which concerns the nesting of query driven

Re: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread David E. Crawford
The cfoutput inside a cfloop is unnecessary to resolve the variables within the cfquery block. I use cfquery inside cfloop all the time to do any number of different things. There is something else going on with the code if it is not working. DC - Original Message - From: "

RE: Recall: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
to Scott Weikert for that! -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 12:34 PM To: CF-Talk Subject: RE: Recall: Is it possible to nest CFQUERY inside CFLOOP? yes, but you shouldn't. There is almost always a better solution that is

RE: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Steve Martin
To: CF-Talk > Subject: FW: Is it possible to nest CFQUERY inside CFLOOP? > > > I just noticed the loop index variable is wrong, I changed it to > from "i" to > "region" as it should be and still got the same error message... > > -Original Message

Re: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bill Davidson
You should be able to nest cfquery in a cfloop that is not query based... Maybe the actual problem is that cfloop doesn't implicitly force a cfoutput, so chances are your variables are not getting resolved. Include a inside the loop. Here's a code snippet where I am nesting a quer

Re: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Dave f
Don't know what your problem is, but it is definitely OK to have cfquery inside cfloop. Do you perchance have improperly closed prior cfquery?? (My usual trick is to dup the and forget to put the "/" in ):) - Original Message - From: "Kevin Gilchrist" &l

RE: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bryan Love
-Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 8:36 AM To: CF-Talk Subject: Is it possible to nest CFQUERY inside CFLOOP? I get an error when I try to do this: SELECT sum(severity

RE: Recall: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bryan Love
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 8:37 AM To: CF-Talk Subject: Recall: Is it possible to nest CFQUERY inside CFLOOP? Kevin Gilchrist would like to recall the message, "Is it possible to nest CFQUERY ins

FW: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
ible to nest CFQUERY inside CFLOOP? I get an error when I try to do this: SELECT sum(severity_minutes) as sev_sum, max(total_minutes) FROM history_view, site_name

Recall: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
Kevin Gilchrist would like to recall the message, "Is it possible to nest CFQUERY inside CFLOOP?". ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http:

Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
I get an error when I try to do this: SELECT sum(severity_minutes) as sev_sum, max(total_minutes) FROM history_view, site_name WHERE query_id =259

RE: CFLOOP and multiple variables

2001-05-15 Thread Chad Gray
h currQty ] > > > >Bryan Love ACP >Internet Application Developer >[EMAIL PROTECTED] > > > >-Original Message- >From: Chad Gray [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, May 15, 2001 11:26 AM >To: CF-Talk >Subject: CFLOOP and multiple variables >

Re: CFLOOP and multiple variables

2001-05-15 Thread Chad Gray
Im reading about arrays. Could i stick my form variables into an array and use that? (I have no idea how to use arrays.. im reading about them now.) Thanks again, Chad At 02:25 PM 5/15/2001 -0400, you wrote: >I have a shopping cart system (part of the one that came with CF Server) >and i wou

RE: CFLOOP and multiple variables

2001-05-15 Thread Bryan Love
] -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:26 AM To: CF-Talk Subject: CFLOOP and multiple variables I have a shopping cart system (part of the one that came with CF Server) and i

CFLOOP and multiple variables

2001-05-15 Thread Chad Gray
I have a shopping cart system (part of the one that came with CF Server) and i would like to have users be able to order multiple items with different quantities. IE a user could order 4 red hammers, 2 blue hammers, and 5 green hammers in one click of the button. When they hit the submit butt

RE: COM & CFLOOP error

2001-05-11 Thread Per Kleven
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Shadovitz Sent: 11. mai 2001 14:52 To: CF-Talk Subject: RE: COM & CFLOOP error I know I've tried every combinations I can think of, but i just end up with: "Error on Invoke fo

RE: COM & CFLOOP error

2001-05-11 Thread David Shadovitz
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Critter > Sent: 9. mai 2001 14:47 > To: CF-Talk > Subject: Re: COM & CFLOOP error > > > Hmmm.. > > > That doesn't work either. > I don't know if

RE: COM & CFLOOP error

2001-05-11 Thread Per Kleven
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Critter Sent: 9. mai 2001 14:47 To: CF-Talk Subject: Re: COM & CFLOOP error Hmmm.. That doesn't work either. I don't know if the problem lies in CF or the object itself Now my cod

RE: cfloop vs cfoutput

2001-05-10 Thread Kola Oyedeji
Thanks for clearing that up for me KOla -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 12:03 To: CF-Talk Subject: RE: cfloop vs cfoutput > Sorry for the crosspost (had conflicting answers from other lists) > > but is there a con

RE: cfloop vs cfoutput

2001-05-10 Thread Philip Arnold - ASP
> Sorry for the crosspost (had conflicting answers from other lists) > > but is there a consensus on which method of looping over a query > is fastest? > > cfloop or cfoutput.. OK, I know you've posted a "Winner" post, but here's the reasoning behind why CF

RE: cfloop vs cfoutput - THE WINNER IS...

2001-05-10 Thread Kola Oyedeji
Seems to me no-ones 100% sure.           I've found cfloop to execute better overall in most situations when I am working with very large amounts of data, Chris. I don't generally see much difference in execution time between the two, in any other situation (and

Re: CFLOOP question

2001-05-09 Thread Heidi Belal
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 with

RE: CFLOOP question

2001-05-09 Thread David Shadovitz
PRESSION="#insert_counter#" -David On Wednesday, May 09, 2001 9:57 AM, JB Mentzer [SMTP:[EMAIL PROTECTED]] wrote: > Hi all > > I'm attempting to overwrite the index value of a CFLOOP from within the > loop: > > > > > > > > > > >

RE: cfloop question (I think)

2001-05-09 Thread Seamus Campbell
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 y

RE: cfloop question (I think)

2001-05-09 Thread John
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

cfloop question (I think)

2001-05-09 Thread Seamus Campbell
ProductDescriptions in them I want to be able to have a list of GroupCodes but only show the GroupCodes which actually have records I'm sure there must be a way to do this with cfloop but I can't see how to do it Can anyone help please Seamus ~~ Stru

Re: cfloop vs cfoutput

2001-05-09 Thread Jon Hall
I think that has made it into Hals Helms worst practices list. Learn to use SQL joins and this is never necessary. jon - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 2001 1:08 PM

<    4   5   6   7   8   9   10   11   >