I should add, this is CF9.
If you are using a version of CF that doesn't have cfcontinue you will have
to go about it a different way. If it's really just as simple as meeting the
two conditions to skip the current iteration you could just set a var.
pseudo:
var doContinue=false
if condition1 a
>
>
>
>
>
>
>
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34
Sorry, just read the rest of the comment. I got a little send happy.
Try
On Mon, Jan 31, 2011 at 11:26 AM, Michael Grant wrote:
>
>
>
> On Mon, Jan 31, 2011 at 11:11 AM, Adam Bourg wrote:
>
>>
>> I have this Cfloop over a query. In the loop I have 4 conditional
>> statements that basically
I need to make a revision.
I have an if with a nested if.
How do I do it with this?
> I have this Cfloop over a query. In the loop I have 4 conditional
> statements that basically call a template that generates an email if
> the condition is met.
>
> Let's say condition 1 is met
On Mon, Jan 31, 2011 at 11:11 AM, Adam Bourg wrote:
>
> I have this Cfloop over a query. In the loop I have 4 conditional
> statements that basically call a template that generates an email if the
> condition is met.
>
> Let's say condition 1 is met, is there a way to break the loop and go to
use CFSWITCH instead of a sequence of CFIFs
On Mon, Jan 31, 2011 at 11:11 AM, Adam Bourg wrote:
>
> I have this Cfloop over a query. In the loop I have 4 conditional
> statements that basically call a template that generates an email if the
> condition is met.
>
> Let's say condition 1 is met,
if the text users enter into your textarea looks like this:
Osram|11324;11324-10;11324-15
Eiko|11224;11225;11226
then this is how you can format the output:
#listfirst(brandgroup, '|')#
#productgroup#
Azadi
On 30/12/2010 23:10 , Teed Younger wrote:
>> Shouldn't that be listLast(bran
>Shouldn't that be listLast(brandGroup,";") ? Otherwise, where is
>productGroup defined above this?
>
>> #listLast(productGroup,";")#
>>
>>
ok here is what I have now. I had this originally just like this. As you
suggested, the second cfloop should have listLas
On Wed, Dec 29, 2010 at 8:31 AM, Teed Younger wrote:
>
> Cross References
>
>
> delimiters="#chr(13)##chr(10)#">
>
> #listFirst(brandGroup,"#chr(13)##chr(10)#")#
> list="#listLast(productGroup,";")#" delimiters
Subject: Re: cfloop working but not how I want it too:
Ok this is an application I built myself that essentially builds new html
pages via input forms stored as cf variables. The goal of this particular
piece of code would ultimately be that the user can create a list or
multiple lists dynamically. Here
Ok,
Given your goals then, I think that using a WYSIWYG editor would be far
simpler than having to instruct your users on a complex scheme of delimiters
to get the desired visual result.
With something like CKEditor (a version of which is available natively in
ColdFusion 8 and up - http://livedo
Ok this is an application I built myself that essentially builds new html pages
via input forms stored as cf variables. The goal of this particular piece of
code would ultimately be that the user can create a list or multiple lists
dynamically. Here would be a quick example of how one current m
As an alternative...
Given what you are trying to accomplish and not knowing all of your goals
this may not work, but it's an option.
Have you considered giving your users access to a WYSIWYG editor such as
CKEditor (http://ckeditor.com/) or the many other offerings around these
days:
http://www
How about something more like this:
Test
#REQUEST.Arr[1]#
#REQUEST.i#
Steve 'Cutter' Blades
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer
http://blog.cutterscrossing.com
"The best way to predict the future is to help create it"
>Just to say it, I too had lots of trouble with CFB, and while I liked
>some things about CFEclipse before that, its bloat and bugginess
>bummed me out (Eclipse more than CFE).
YES! That's what we had issues with, getting CFEclipse to work properly... we
even tried the older version as well wit
Just to say it, I too had lots of trouble with CFB, and while I liked
some things about CFEclipse before that, its bloat and bugginess
bummed me out (Eclipse more than CFE).
But now I'm a happy camper, using IntelliJ IDEA with its CFML plugin.
No, it's not perfect by any means, but it's just a re
> There just hasn't been a good enough reason for my company to purchase it when
> DW doesn't just about everything it does for a fraction of the cost.
I am going to argue that CFB is not buggy, or that people should
definitely switch to CFB from DW. However, I don't agree with your
statement he
If ur docs are out of date then you can alays use cfquickdocs.com or
coldfusiondocs.com as your reference
On 29 Oct 2010 17:57, "Matthew Lowrey" wrote:
> On Wed, Oct 27, 2010 at 4:22 PM, Matthew Lowrey
> wrote:
> > I wasn't aware o...
I really wanted to switch over to CF Builder but when we w
> On Wed, Oct 27, 2010 at 4:22 PM, Matthew Lowrey
> wrote:
> > I wasn't aware of that. We're still learning all the new tags and
> it doesn't come up win DreamWeaver so it was a shot in the dark to
> find something that would allow us to "continue"
>
> Time to switch to ColdFusion Builder...
On Wed, Oct 27, 2010 at 4:22 PM, Matthew Lowrey wrote:
> I wasn't aware of that. We're still learning all the new tags and it doesn't
> come up win DreamWeaver so it was a shot in the dark to find something that
> would allow us to "continue"
Time to switch to ColdFusion Builder...
--
Sean A
On Wed, Oct 27, 2010 at 10:16 AM, Jacob Munson wrote:
> You probably noticed this, but cfcontinue is a new CF9 tag, so won't work in
> older versions of CF.
cfcontinue was new in CF9 but continue existed in cfscript before that...
--
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, Inc. --
>You probably noticed this, but cfcontinue is a new CF9 tag, so won't work in
>older versions of CF.
I wasn't aware of that. We're still learning all the new tags and it doesn't
come up win DreamWeaver so it was a shot in the dark to find something that
would allow us to "continue"
I'll have
You probably noticed this, but cfcontinue is a new CF9 tag, so won't work in
older versions of CF.
Sent with my Droid
On Oct 27, 2010 9:57 AM, "Matthew Lowrey" wrote:
>
> Thank you guys, I think it's time I update my CF References... I
shamefully have been using the MX version too often and Goog
eb 12, 2010 at 11:54 AM, Paul Alkema
wrote:
>
> Hey Aaron, Thanks for the information. Very helpful. :)
>
> Paul
>
>
> -Original Message-
> From: Aaron Neff [mailto:w...@itisdesign.com]
> Sent: Friday, February 12, 2010 1:05 PM
> To: cf-talk
> Subject: Re:
Hey Aaron, Thanks for the information. Very helpful. :)
Paul
-Original Message-
From: Aaron Neff [mailto:w...@itisdesign.com]
Sent: Friday, February 12, 2010 1:05 PM
To: cf-talk
Subject: Re: Cfloop List Multiple Charecter Delimiters
Hi Paul,
Just fyi, CF9 added a 4th parameter
Hi Paul,
Just fyi, CF9 added a 4th parameter (boolean "multiCharacterDelimiter") to the
listToArray function:
You have a few options!
HTH,
-Aaron
I have a list that I'm trying to loop, I was wondering if it was possible to
>have multiple character delimiter.
~~
Do this:
...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330646
Subscript
re I need to use multiple character delimiters, I just
> wasn't sure if there was a better way of doing this.
>
> Thanks though!
> Paul
>
> -Original Message-
> From: Leigh [mailto:cfsearch...@yahoo.com]
> Sent: Thursday, February 11, 2010 10:55 PM
> To: cf-ta
ere I need to use multiple character delimiters, I just
wasn't sure if there was a better way of doing this.
Thanks though!
Paul
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Thursday, February 11, 2010 10:55 PM
To: cf-talk
Subject: Re: Cfloop List Multiple
> My answer was just... keep it simple :)
Always good advice :)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.
Leigh - just to clarify, I wasn't suggesting the straightforward loop
w/conditional was more straightforward/legible than the UDFs on cflib... I
meant in general compared to some of the suggestions so far in this thread.
Not taking anything away from any the suggestions themselves... they're all
> Wouldn't it be pretty straightforward and more legible to
Yes, it should not be that hard to implement and probably with less code than
one of those udf's. But the other looks elegant enough. You might see if it
does the trick first, before re-inventing the wheel.
~~
Wouldn't it be pretty straightforward and more legible to just loop over the
list and do a conditional on each loop iteration? Unless you've got a
ridiculously large list it should still perform well enough.
#i#
As far as your original question regarding multiple delimiters... cflo
> multiple character delimiter.
I believe CF does not support that natively. Check cflib.org. I have not tried
them, but it looks like there are a few functions for multi-character delimiters
http://www.cflib.org/udf/splitMX
http://www.cflib.org/udf/split
~
>> From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
>> Sent: Thursday, February 11, 2010 5:00 PM
>> To: cf-talk
>> Subject: Re: Cfloop List Multiple Charecter Delimiters
>>
>>
>> I don't know if it would work and I'm shooting in the dark,
e-
> From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
> Sent: Thursday, February 11, 2010 5:00 PM
> To: cf-talk
> Subject: Re: Cfloop List Multiple Charecter Delimiters
>
>
> I don't know if it would work and I'm shooting in the dark, but if you
> made &q
Good idea, but unfortunately it didn't work. Thanks though. :)
-Original Message-
From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
Sent: Thursday, February 11, 2010 5:00 PM
To: cf-talk
Subject: Re: Cfloop List Multiple Charecter Delimiters
I don't know if it would wo
I don't know if it would work and I'm shooting in the dark, but if you
made "oat" into a variable, would that work?
On Thu, Feb 11, 2010 at 1:57 PM, Paul Alkema
wrote:
>
> Hey all,
> I have a list that I'm trying to loop, I was wondering if it was possible to
> have multiple character delimiter.
Excellent advise -- thank you both for taking the time to respond.
Best Regards,
Dakota
On Wed, Sep 23, 2009 at 4:11 PM, Rick Root wrote:
>
> If you're trying to dynamically generate code to put in a file, you
> can't do it that way.
>
> Do this instead:
>
>
>
>
>
>
>
>
>"c:\inetpub
If you're trying to dynamically generate code to put in a file, you
can't do it that way.
Do this instead:
#out#
Of course you won't see the output because it won't render ... but you
can write the contents of the "out" variable to a file or put it in a
DB or whatever.
ALTERNATIVELY
use associative array notation:
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 24/09/2009 04:44, Dakota Burns wrote:
> I have the following code below (codeblock 01), which outputs the following
> three lines correctly:
> CFSET varMergeFile1 = "c:\inetpub\uploads\pdf\resume_1.pdf"
d) where
> it's been of any benefit to NOT use queryparam.
>
> - Gabriel
>
> -Original Message-
> From: Justin Scott [mailto:jscott-li...@gravityfree.com]
> Sent: Wednesday, 10 June 2009 12:42 PM
> To: cf-talk
> Subject: RE: CFLOOP inside a CFQuery
>
>
>
been debated before), however I've
not come across a situation (except the caching issue as mentioned) where
it's been of any benefit to NOT use queryparam.
- Gabriel
-Original Message-
From: Justin Scott [mailto:jscott-li...@gravityfree.com]
Sent: Wednesday, 10 June 2009 12
> WOW! Thanks for all the feedback! One question
> about CFQUERYPARAM, I use this when I accept anything
> that is available to the general public, but is it
> necessary to use this when the form is only accessible
> via username/password?
I would use it regardless of who is going to be hitting
WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this
when I accept anything that is available to the general public, but is it
necessary to use this when the form is only accessible via username/password?
Is there ever a reason not to use CFQUERYPARAM?
Thanks everyone
> >
> >
> >
> > May I also point out the use of CFQUERYPARAM. It's basic principles;
> > unless you've got a *very* fine reason not to, always use cfqueryparam.
> > Protect yourself from SQL injection attacks, make your life easier.
> >
> >
> you've got a *very* fine reason not to, always use cfqueryparam. Protect
> yourself from SQL injection attacks, make your life easier.
>
> No offence intended, but Will I urge you to ignore the 'evaluate' based
> advice.
>
> Cheers,
> Gabriel
>
>
Ryan Letulle [mailto:bayous...@gmail.com]
Sent: Wednesday, 10 June 2009 11:11 AM
To: cf-talk
Subject: Re: CFLOOP inside a CFQuery
@gabrieldoes the cfqueryparam matter or can you just use #form['type'&idx]#
in any way?
--
Ryan LeTulle
On Tue, Jun 9, 2009 at 7:58 PM, Gabriel wr
o ignore the 'evaluate' based
advice.
Cheers,
Gabriel
-Original Message-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: Wednesday, 10 June 2009 10:25 AM
To: cf-talk
Subject: Re: CFLOOP inside a CFQuery
I agree with NK pay attention to the evaluate function. It works li
ou use it or not, but why make your
(coding) life harder than it needs to be? I find the alternative far easier
to write, read and maintain than the evaluate alternative.
Cheers,
Gabriel R
-Original Message-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: Wednesday, 10 June 2009 11
nce intended, but Will I urge you to ignore the 'evaluate' based
> advice.
>
> Cheers,
> Gabriel
>
> -Original Message-
> From: Ryan Letulle [mailto:bayous...@gmail.com]
> Sent: Wednesday, 10 June 2009 10:25 AM
> To: cf-talk
> Subject: Re: CFLOOP inside a CF
> you've got a damn fine reason not to, always use cfqueryparam. Protect
> yourself from SQL injection attacks, make your life easier.
>
> No offence intended, but Will I urge you to ignore the 'evaluate' based
> advice.
>
> Cheers,
> Gabriel
>
> -Orig
-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: Wednesday, 10 June 2009 10:25 AM
To: cf-talk
Subject: Re: CFLOOP inside a CFQuery
I agree with NK pay attention to the evaluate function. It works like a
charm for dynamically created form variables. I use it often. :)
--
Ryan LeTull
I agree with NK pay attention to the evaluate function. It works like a
charm for dynamically created form variables. I use it often. :)
--
Ryan LeTulle
On Tue, Jun 9, 2009 at 6:30 PM, N K wrote:
>
> Check the following link might help...
> http://tutorial431.easycfm.com/
>
>
> > Hello all,
>Check the following link might help...
>http://tutorial431.easycfm.com/
>
Thank you! I was thinking I had to do something like this to get it to work.
I just did not know exactly what it was I needed to do so searching for it was
difficult.
Thanks again!
Will
~
Check the following link might help...
http://tutorial431.easycfm.com/
> Hello all,
> I have a dynamically generated form that I need to figure out how to
> get the data from that form in to our database. Here is the way it
> works. First the client types in the number of machines they ha
No, it's not right. As the documentation on the tag states, if you don't
specify a "result" attribute, the result is contained in "cfstoredproc".
On Wed, Mar 25, 2009 at 10:42 AM, Priya Koya wrote:
>
> I have a query and looping the results of a query. I want to display the
> names from the cfd
Yes! That did the trick.
Thank you!
> Try this:
>
>
>
>
> #variables["F_Name#i#"]#
>
>
>
> I think that's what you're looking for. I used variables scope simply
> to more easily use the struct notation of struct["varName"] in the
> outpu
Try this:
#variables["F_Name#i#"]#
I think that's what you're looking for. I used variables scope simply to more
easily use the struct notation of struct["varName"] in the output. You could
as easily do:
~
Not sure exactly what you are asking where are you looking to store this
or do with it? In any event it sounds like an array may come in handy.
On Thu, Jan 29, 2009 at 5:24 PM, cfcom wrote:
>
>
>
> I loop over a list of email addresses to send out a newsletter.
> I need to add the ability
If the page itself isn't throwing an error, it sounds like an email
problem.
If you have access to the host, check the Spool and Undeliverable Mail
directories.
Failing that, try creating an absolutely basic page which just sends
an email to your own address. If this doesn't get through, yo
ECTED]
Sent: 2008-12-07 9:05 PM
To: cf-talk
Subject: Re: < CFLoop died help >
>My CFloop died, it used to work but now doesn't and I haven't touched the
>code. Any help would be greatly appreciated.
What do you mean by "
>My CFloop died, it used to work but now doesn't and I haven't touched the
>code. Any help would be greatly appreciated.
What do you mean by "died".
What's the error?
Will
~|
Adobe® ColdFusion® 8 software 8 is the most import
I would guess that there is an illegal format of an email address and
cfmail is throwing an exception.
Adam
On Sun, Dec 7, 2008 at 1:44 PM, cfcom <[EMAIL PROTECTED]> wrote:
> My CFloop died, it used to work but now doesn't and I haven't touched the
> code. Any help would be greatly appreciated
in the form's action page, loop through #form.fieldnames#, if the
fieldname starts with "qty_" and has a value - get the prodid from field
name using removechars() or listlast() and update the db. something like
this:
INSERT INTO yourtable
(product_id
, quantity)
VALUES
(
,
)
Azadi Sary
On Sat, Sep 13, 2008 at 10:37 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:
> the only time i remember a cfloop getting confused wa when it was inside
> a cfoutput of another query and there was column name duplication in the
> outer and inner queries. when i have a cfloop inside a cfoutput of
> anot
the only time i remember a cfloop getting confused wa when it was inside
a cfoutput of another query and there was column name duplication in the
outer and inner queries. when i have a cfloop inside a cfoutput of
another query i usually set explicit vars for outer query's values i
need to use in th
yeah i think your right, thanks, i will def post if i see the problem again
thanks again for your advice
>Chances are it was your code rather than cfloop being broken.
>
>Post up some code and we might stop the problem.
>
>Adrian
>
>hi,
>
>i have noticed on a couple of occasions when i use the cf
Chances are it was your code rather than cfloop being broken.
Post up some code and we might stop the problem.
Adrian
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: 13 September 2008 14:14
To: CF-Talk
Subject: cfloop query
hi,
i have noticed on a couple of occa
thanks rob, i will start using it and see if i get a similar problem again
richard
>Richard,
>I have never had an issue using the cfloop query, and I use it all the time.
>
>Rob
>
>
>
>>
~|
Adobe® ColdFusion® 8 software 8 is th
Richard,
I have never had an issue using the cfloop query, and I use it all the time.
Rob
On Sat, Sep 13, 2008 at 9:13 AM, Richard White <[EMAIL PROTECTED]> wrote:
> hi,
>
> i have noticed on a couple of occasions when i use the cfloop query that it
> sometimes doesn't loop it correctly, and som
Then you are looking at 2 different things, and getting 2 different
results should be no big surprise.
What does a cfdump of the form scope return?
-Original Message-
From: Kenny Kinds [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2008 2:56 PM
To: CF-Talk
Subject: Re: cfloop
On Thu, Jul 17, 2008 at 11:42 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
>
> Here's a sample of the list getting passed from the form
>
> ACIS---Midwest'CAMPS---Midwest'CAMPS12345678901234X---Midwest123456789012Y'SORD---Southwest'SORD---West'SUPPORT---ChangeMan'SUPPORT---MVS
> Support'WBS---Midwes
>What do you see with:
>
> #x#
>
>
>thought
>>you looked a bit off."
>
>
>Here's a sample of the list getting passed from the form
>
>ACIS---Midwest'CAMPS---Midwest'CAMPS12345678901234X---Midwest12345678901
>2Y'SORD---Southwest'SORD---West'SUPPORT---ChangeMan'SUPPORT---M
What do you see with:
#x#
-Original Message-
From: Kenny Kinds [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2008 2:43 PM
To: CF-Talk
Subject: Re: cfloop
>On Thu, Jul 17, 2008 at 11:30 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
>
&g
>On Thu, Jul 17, 2008 at 11:30 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
>
>
>
>it's very possible.
>
>but again, it would be helpful to see a sample of the data that you're
>receiving, and a sample of what the result should look like :)
>
>--
>A byte walks into a bar and orders a pint. Bartender
On Thu, Jul 17, 2008 at 11:30 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
> >Looks like you're having a list of lists now.
> >One solution is to use some different delimiter for the elements in one
> >of the lists.
> >
> >--
> >___
> >REUSE CODE! Use custom tags;
>Looks like you're having a list of lists now.
>One solution is to use some different delimiter for the elements in one
>of the lists.
>
>--
>___
>REUSE CODE! Use custom tags;
>See http://www.contentbox.com/claude/customtags/tagstore.cfm
>(Please send any spam
Looks like you're having a list of lists now.
One solution is to use some different delimiter for the elements in one
of the lists.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this a
>On Thu, Jul 17, 2008 at 10:58 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
>
>
>
>
>not sure what you're trying to do in your code.
>
>what is the listQualify() meant to do? if you're trying to create a comma
>delimited list from a string, i'd use listChangeDelims() and change the
>spaces to commas
On Thu, Jul 17, 2008 at 10:58 AM, Kenny Kinds <[EMAIL PROTECTED]> wrote:
> greetings,
>
> I have some code that takes a string and breaks it into to components and
> set each component into a seperate variable.
>
> This code was set up to only take one string and perform this function.
>
> Now the
>I assume the insert is going directly into a table and not into a query?
>
>[mailto:[EMAIL PROTECTED]
>Sent: 19 June 2008 20:35
>To: CF-Talk
>Subject: Re: CFLOOP - why are there duplicates?
>
>
>Thanks. I thought I was going crazy.
Not a cflocation somewhere e
Thanks, the cfsilent did the trick..
-- Sam
On Thu, Jun 26, 2008 at 10:04 AM, Brian Kotek <[EMAIL PROTECTED]> wrote:
> By the way, this runs in about 5 seconds and uses no memory on my machine.
>
>
>
>
>
>
>
> On Thu, Jun 26, 2008 at 1:02 PM, Brian Kotek <[EMAIL PROTECTED]> wrote:
>
> > We
By the way, this runs in about 5 seconds and uses no memory on my machine.
On Thu, Jun 26, 2008 at 1:02 PM, Brian Kotek <[EMAIL PROTECTED]> wrote:
> Well I'm not sure it is a bug, you're talking about 20 MILLION loop
> iterations. If nothing else you're going to get 20 million carriage retu
Well I'm not sure it is a bug, you're talking about 20 MILLION loop
iterations. If nothing else you're going to get 20 million carriage returns
in the output buffer. You could try wrapping it in and, assuming you aren't in a cfoutput block, see
if that makes any difference. Essentially, unless you
This empty loop as posted here will cause the same memory spikes. You can
create just a simple .cfm page and run this and watch the memory go out of
control.
Maybe it is a Coldfusion bug?
thanks,
-- Sam
On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek <[EMAIL PROTECTED]> wrote:
> Can you po
Can you post the code? Because a loop tag itself woudn't be causing memory
to spike. It has to be something inside the loop tag.
On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach <[EMAIL PROTECTED]>
wrote:
> I'm using a java stringbuffer which works great for the portion of the
> code,
> but the main is
Sam Roach wrote:
> We are trying to create a CSV file with about 250,000 rows with about 40
> dynamic columns which we need to loop over so we can get the correct order.
>
> We see an issue coming from the nested loops on the large dataset and the
> server is running out of memory. We took a step
I'm using a java stringbuffer which works great for the portion of the code,
but the main issue is with the cfloop tag.
On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek <[EMAIL PROTECTED]> wrote:
> If you aren't, use a Java StringBuffer or StringBuilder to build up the
> CSV.
> If you do the concate
Yes I am using CF8.
On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote:
> Are you using CF8 because they made many improvements to this very problem
> in 8.
>
> Dan
>
>
> On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]>
> wrote:
>
> > We are trying to create a CSV f
I assume the insert is going directly into a table and not into a query?
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 19 June 2008 20:35
To: CF-Talk
Subject: Re: CFLOOP - why are there duplicates?
Thanks. I thought I was going crazy
If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV.
If you do the concatenation using CF you'll use large amounts of memory
because every concatenation creates a new String object.
On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote:
> Are you using CF8 be
Are you using CF8 because they made many improvements to this very problem
in 8.
Dan
On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]>
wrote:
> We are trying to create a CSV file with about 250,000 rows with about 40
> dynamic columns which we need to loop over so we can get the co
Thanks. I thought I was going crazy.
>[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
>> That's why I'm showing the following after the first query and
>> it confirms that it's the 100k
>> #getmailids.recordcount#
>>
>> Strange isn't it?
>
>There isn't anything in the code you have shown so far that
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
> That's why I'm showing the following after the first query and
> it confirms that it's the 100k
> #getmailids.recordcount#
>
> Strange isn't it?
There isn't anything in the code you have shown so far that would
account for there to be more inserts th
That's why I'm showing the following after the first query and
it confirms that it's the 100k
#getmailids.recordcount#
Strange isn't it?
>Have you confirmed that the record set labeled 'getMailIds' does not
>contain more records then you expect.
~~
SELECT DISTINCT mailprofiles.mailprofileID
FROM dbo.mailprofiles
INNER JOIN subscriptions ON mailprofiles.mailprofileID =
subscriptions.mailprofileID
WHERE (dateunsubscribed IS NULL OR datesubscribed > dateunsubscribed)
AND newslettertypeID IN (10,11,1,12,16)
#getmailids.recordcount#
>
>
Have you confirmed that the record set labeled 'getMailIds' does not
contain more records then you expect.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.double
Not a dumb question ... could have been the issue. But it not in this instance.
>dumb question but... gotta ask. are you inserting the 100 records
>into the table that originally had 100 records (thus resulting in
>200)?
>
>how do you know that the "getmailids" query had 100 records? can you
>v
What is the getmailids Query?
You don't have it inside a mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 2:15 PM
To: CF-Talk
Subject: CFLOOP - why are there duplicates?
I'm trying to us the output from a query to loop through and insert
statement.
My original query has 100k for a recordco
1 - 100 of 510 matches
Mail list logo