Re: Loop in Distinct loop with more then one column

2009-03-11 Thread Dominic Watson
No worries, welcome :) 2009/3/11 Sin Tec : > Im still a newbie to coldfusion and trying to make my way through it all as I > go so yeah my code doesnt have the best of structure. > > Your code below works great for what I am doing. Thank you. > > Also thank you for the class tip it will make it

Re: Loop in Distinct loop with more then one column

2009-03-11 Thread Sin Tec
Im still a newbie to coldfusion and trying to make my way through it all as I go so yeah my code doesnt have the best of structure. Your code below works great for what I am doing. Thank you. Also thank you for the class tip it will make it easier in the longrun. >I think your first problem

Re: Loop in Distinct loop with more then one column

2009-03-07 Thread Brian Kotek
Just a general note that any time you run a query and then loop over it and run more queries, there's almost always a way to accomplish the same task using a single query (which will be far more efficient). On Fri, Mar 6, 2009 at 4:17 PM, Sin Tec wrote: > > Im doing a loop within a loop to get

Re: Loop in Distinct loop with more then one column

2009-03-07 Thread Dominic Watson
I think your first problem is that your db is not normalised and if I were you I would look into imrpoving the db structure here. However, it is possible to do what you are after without resorting to two queries or rearranging your db. The following code assumes that there are always three categor

RE: loop in

2001-03-22 Thread Zhou, Mei Y (Mei)
Hi, Doug: Thanks, I will check it out later. If anyone knows on-line about this, it will be very grateful. Mei -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 11:49 AM To: CF-Talk Subject: RE: loop in Mei, Chapter 18 of

Re: loop in

2001-03-22 Thread Kevin Gilchrist
Check out Chapter 20 : Extending ColdFusion Pages with CFML Scripting in Developing Web Applications with ColdFusion in the online help. It gives examples of all the different types of loops and control flow statements. Aside from that, the best resource I've used is just browsing through

RE: loop in

2001-03-22 Thread James Lawrence
0207 5534832, M: 0797 1024911, F: 0207 5534866 -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 16:29 To: CF-Talk Subject: RE: loop in James: It works !! many thanks. By the way, do you have any resource for syntax within ? according to CF document

RE: loop in

2001-03-22 Thread Douglas Malcolm
lto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 11:13 AM To: CF-Talk Subject: RE: loop in Mei, try : arrayYes=Arraynew(1); for (x=1;x LTE varLength; x = x+1) { arrayYes[x] = (#SomeNum[k]#/#othernum[k]#)*100; } The increment needs to be x=x+1 - x++ doesn't work. Cheers

RE: loop in

2001-03-22 Thread Zhou, Mei Y (Mei)
]] Sent: Thursday, March 22, 2001 11:13 AM To: CF-Talk Subject: RE: loop in Mei, try : arrayYes=Arraynew(1); for (x=1;x LTE varLength; x = x+1) { arrayYes[x] = (#SomeNum[k]#/#othernum[k]#)*100; } The increment needs to be x=x+1 - x++ doesn't work. Cheers James Lawrence, Applic

RE: loop in

2001-03-22 Thread Jason Lees (National Express)
CTED]] Sent: 22 March 2001 16:02 To: CF-Talk Subject: RE: loop in It won't work, besides, for CF, array start with 1 not 0. Thanks though. Mei -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 10:45 AM To: CF-Talk

RE: loop in

2001-03-22 Thread James Lawrence
ondon EC1R OAU T: 0207 5534832, M: 0797 1024911, F: 0207 5534866 -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 16:02 To: CF-Talk Subject: RE: loop in It won't work, besides, for CF, array start with 1 not 0. Thanks though. Mei -Origin

RE: loop in

2001-03-22 Thread Zhou, Mei Y (Mei)
It won't work, besides, for CF, array start with 1 not 0. Thanks though. Mei -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 10:45 AM To: CF-Talk Subject: RE: loop in cant you use a arrayYes=Arraynew(1); for (

RE: loop in

2001-03-22 Thread Jason Lees (National Express)
cant you use a arrayYes=Arraynew(1); for (k=0;k lte varlength;k++) arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100; Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 15:33 To: CF-T