Re: Best CF editor?
On Friday 30 May 2008, Aaron Rouse wrote: I looked earlier and believe I have 3.3.2 Workspace-wide search is in the 3.3 series too. Probably 3.2 if I remember my home machine right... -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF editor?
On Sunday 01 Jun 2008, Aaron Rouse wrote: How do you know with 100% certainty that some other editor is not going to change the code on you in some odd ball case? DW mangles my code (I've seen it do it, years ago). Eclipse, in many years of using it, has never mangled my code. So just on the balance of probability, Eclipse wins. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
On Saturday 31 May 2008, Michael Christensen wrote: and HomeSite for the large files (until I may eventually have time to split them up). That's the thing, CFEclipse chokes on files once their size gets so big you should refactor them anyway :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
On Friday 30 May 2008, Qing Xia wrote: But work set? Have not done that. I am going to look it up in the online references you have so graciously provided. I'd skip learning it, and jump straight to the (free) Mylyn plugin, which automatically filters the file navigator based on what files you actually worked with. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF editor?
On Sunday 01 Jun 2008, s. isaac dealey wrote: the unlikely event that Dreamweaver did corrupt a file, recovery is pretty simple. *When you notice*. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Guide for reviewing a website
Hi there I'm just wondering if anyone out there would have a guide or some things to look for when critically analyzing a website for a client. I have 2 websites to review - not so much for a client but as part of selection process of acquiring a new position with a firm working in theor IT section specifically working on web projects. Whilst I do have some ideas I'm wondering if any people out there might have a tested approach for reviewing websites. Areas I was thinking of looking at include overall look and feel,navigation, content, ease of use. Any other ideas to consider would be greatly appreciated. Regards ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Get length of .WAV file
You may look out there at some java classes and see if you can find something that can read the attributes of the wav file or even load the whole wav into memory and then pull the length or something. I don't know of any specific classes that do it for wav but I know I've used some for mp3s and ID3 tagging and such. If you can find one, anything you can do in java you can do in CF. Hope that gets you going in the right direction. John Burns -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2008 9:24 PM To: CF-Talk Subject: Re: Get length of .WAV file As a follow up, I installed the CFX tag and it is returning 0 seconds on my .WAV files, so it doesn't seem to work anyway. I really need to find a way to identify the length in time of a .WAV file. Please let me know if you know how. Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse Question
I personally think that is completely worthless. Autocomplete for tags/functions might be useful, but that's generally not. -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2008 1:54 PM To: CF-Talk Subject: RE: Eclipse Question It does that not just with queries, but also with variable names...it is quite annoying and one of my beefs with eclipse. Eric /*-Original Message- /*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /*Sent: Sunday, June 01, 2008 10:37 AM /*To: CF-Talk /*Subject: Eclipse Question /* /*Since we are talking about Eclipse... /* /*When I type some code, allot of times, a window will show up giving me /*choices of queries above it. Does anyone know how to disable this? I /*hate pressing enter after a line and have it put a query name where I /*meant to just end the line. /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best CF editor?
After being at cf.Objective() and seeing Eclipse used and promoted by so many developers, I'm doing my best to adopt it. Code completion and integrated FTP are the two items I miss the most. I get frustrated with Eclipse closing my elements but not enough to have to type the closing tag every time. Yes, I'm aware that there are some behaviors that I can tweak with regard to closing and auto-insertion. Unfortunately, there is no 'work exactly like DW does' checkbox. :) It's nice to see some DWers come out of the closet! So who's going to get the DW logo tattooed on their arm and apply for a project with Mark? :) -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 3:55 AM To: CF-Talk Subject: Re: Best CF editor? On Saturday 31 May 2008, Michael Christensen wrote: and HomeSite for the large files (until I may eventually have time to split them up). That's the thing, CFEclipse chokes on files once their size gets so big you should refactor them anyway :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best Coldfusion Formatters or Coldfusion Beautifiers
There is a pretty good thread about this over at Ray Camden's site http://www.coldfusionjedi.com/index.cfm/2007/10/11/ColdFusion-Code-Beautifiers There is also a wonderful thread on formatting preferences. http://www.coldfusionjedi.com/index.cfm/2008/4/22/What-makes-a-code-diva I'd go with dreamweaver or CFEclipse. They are not perfect, but they will get you a good starting point. On Sun, Jun 1, 2008 at 1:19 PM, Gerald Guido [EMAIL PROTECTED] wrote: Yeah, but *GREAT* indenting :)) Oddly enough both of those came from the same script. By far the highest wtfpm ratio I have seen to date. http://www.osnews.com/story/19266/WTFs_m On Sat, May 31, 2008 at 12:19 AM, Dave Francis [EMAIL PROTECTED] wrote: He also did not grasp the concept of variable scopes: http://www.nomorepasting.com/getpaste.php?pasteid=16315 Yeah, but *GREAT* indenting :)) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CSV Generation MEMORY SUCK
So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
I am sure you know as well as I, that sometimes refactoring is just not an option... On Saturday 31 May 2008, Michael Christensen wrote: and HomeSite for the large files (until I may eventually have time to split them up). That's the thing, CFEclipse chokes on files once their size gets so big you should refactor them anyway :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse Question
Yah...it might be useful for java coding, but anything that uses html or CF...that is completely useless and pretty stupid. Eric /*-Original Message- /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 8:29 AM /*To: CF-Talk /*Subject: RE: Eclipse Question /* /*I personally think that is completely worthless. Autocomplete for /*tags/functions might be useful, but that's generally not. /* /*-Original Message- /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /*Sent: Sunday, June 01, 2008 1:54 PM /*To: CF-Talk /*Subject: RE: Eclipse Question /* /*It does that not just with queries, but also with variable names...it is /*quite annoying and one of my beefs with eclipse. /* /*Eric /* /*/*-Original Message- /*/*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /*/*Sent: Sunday, June 01, 2008 10:37 AM /*/*To: CF-Talk /*/*Subject: Eclipse Question /*/* /*/*Since we are talking about Eclipse... /*/* /*/*When I type some code, allot of times, a window will show up giving me /*/*choices of queries above it. Does anyone know how to disable this? I /*/*hate pressing enter after a line and have it put a query name where I /*/*meant to just end the line. /*/* /*/* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSV Generation MEMORY SUCK
Rick, What's your DB platform? Are you sure there is not a better non-cf way to do it? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:04 AM To: CF-Talk Subject: CSV Generation MEMORY SUCK So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best CF editor?
ROFL /*-Original Message- /*From: Jason Durham [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 8:59 AM /*To: CF-Talk /*Subject: RE: Best CF editor? snipped /*It's nice to see some DWers come out of the closet! So who's going to /*get the DW logo tattooed on their arm and apply for a project with Mark? /*:) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306564 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Best CF editor?
Hi. I'm Mike and I'm a Dreamweaver user. It's nice to see some DWers come out of the closet! So who's going to get the DW logo tattooed on their arm and apply for a project with Mark? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
You are aware - I hope - that CFEclipse has FTP support? It's the FIle Browser. It works both with local paths and FTP paths. One benefit it has over RDS is: a) Most folks disable RDS on production b) I love that w/ FTP, I can specify a folder to jump to immediately. With RDS I have to dig down to my files. On Mon, Jun 2, 2008 at 8:59 AM, Jason Durham [EMAIL PROTECTED] wrote: After being at cf.Objective() and seeing Eclipse used and promoted by so many developers, I'm doing my best to adopt it. Code completion and integrated FTP are the two items I miss the most. I get frustrated with Eclipse closing my elements but not enough to have to type the closing tag every time. Yes, I'm aware that there are some behaviors that I can tweak with regard to closing and auto-insertion. Unfortunately, there is no 'work exactly like DW does' checkbox. :) -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
SQL Server 2005. I'm open to suggestion. This is part of an application that allows users to generate CSV files of their own based on their own criteria, so though I'm open to non-CF solutions, I'm not sure there really would be anyway except maybe a homegrown java class to handle the work and be more strict with memory consumption Rick On Mon, Jun 2, 2008 at 10:13 AM, Mark Kruger [EMAIL PROTECTED] wrote: Rick, What's your DB platform? Are you sure there is not a better non-cf way to do it? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:04 AM To: CF-Talk Subject: CSV Generation MEMORY SUCK So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: When is is time to upgrade to Enterprise Edition?
Much thanks to everyone who's responded to my posting. This community is bar-none the best out there! Tweaking the JVM based on your suggestions has made a world of difference. So far, my CF server has been running without interruption for 1 day, 14 hours, and 22 minutes, and things seem to be humming along. Here's my current JVM settings, in case anyone else can benefit from this: # java.home=C:/j2sdk1.4.2_16/jre # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms1024m -Xmx1024m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=256m -XX:PermSize=256m -XX:NewSize=48m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars,c:\\CfusionMX7\\classpath -Dsun.rmi.dgc.client.gcInterval=30 -Dsun.rmi.dgc.server.gcInterval=30 # From what I could tell, increasing the permsize/maxperm size to 256mb and setting the gcInterval to 30 made the biggest differences. Thanks again for all your help, Michael I've seen various postings around this subject, but wanted to get some advice on my particular situation. I have a dedicated Win2K3 box with 4 GB ram and a dual-core xeon running IIS 6 and CFMX7 Standard Edition. The box is located at a tier-one data center. I have 18 web sites ranging from a few pages up to several thousand pages. In total, my sites generate around 50,000 hits per day; and the largest of my sites sees around 75K users per month. I realize that doesn't seem like a lot of traffic; but all of these sites are for non-profit associations with small membership levels (avg. 600 members/association). What these sites *do* have are a lot of Coldfusion applications. All the members areas are run on a commercially built CF application (12 instances of this), and we have upwards of 50 other custom-built applications. Several of these applications make use of persistent CFCs (scoped at the application level), so at any given time, at least 350 MB of the server's RAM is being used by JRUN. I have CF datasources set up for 47 separate MS SQL 2000 databases, all of which run on a separate, dedicated server at a different location from my webserver. Lately, I've been noticing a lot of instability on the server, with request timeouts, what appear to be memory leaks, and general end-user unhappiness. I've been trying my darndest to tune my applications and the CF server using best practices found on various sources (including this site, Coldfusion Muse, Robi Sen's blog, etc.), but lately I've been spending at least an hour/day wrestling with the server, and I'm about ready to say uncle. Adobe's info says that CFMX Standard edition is ideal for delivering a single website or application on a single server, and clearly I'm way beyond having a single site or application. However, I'm wondering whether others on the list have run the standard edition with a similar number of sites/applications. Let me know if you think it's time to upgrade, or whether I should just keep tuning this fiddle. Thanks, Michael ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
Then turn it off. It takes 5 seconds. On Sun, Jun 1, 2008 at 2:53 PM, Eric Roberts [EMAIL PROTECTED] wrote: It does that not just with queries, but also with variable names...it is quite annoying and one of my beefs with eclipse. Eric /*-Original Message- /*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /*Sent: Sunday, June 01, 2008 10:37 AM /*To: CF-Talk /*Subject: Eclipse Question /* /*Since we are talking about Eclipse... /* /*When I type some code, allot of times, a window will show up giving me /*choices of queries above it. Does anyone know how to disable this? I /*hate pressing enter after a line and have it put a query name where I /*meant to just end the line. /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSV Generation MEMORY SUCK
We had a similar issue with an internal application and we made good improvements using the standard java classes PrintStream, FileOutputStream, and BufferedOutputStream to handle the writing to your file. Something like this (shown in java, so you'd have to wrap it properly with cfscript): PrintStream out = new PrintStream(new BufferedOutputStream(new FileOutputStream(filename, true), bufferSize)); // pick a decent-sized buffer.. Maybe 100k to start This will let you do out.print(...) and out.println(...) from CF that I think will be much more efficient than what CF can do. Be sure to do out.close() within the page (so use try/catch to be sure that the close happens). Also, test you page with the user's query but with the output part (actually writing the file) commented out... If the page is still slow and a huge memory hog then the file stuff above won't help much and you'll have to look at running the query in java too, but I but you'll get something by handling the file better. Thanks Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 10:33 AM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK SQL Server 2005. I'm open to suggestion. This is part of an application that allows users to generate CSV files of their own based on their own criteria, so though I'm open to non-CF solutions, I'm not sure there really would be anyway except maybe a homegrown java class to handle the work and be more strict with memory consumption Rick On Mon, Jun 2, 2008 at 10:13 AM, Mark Kruger [EMAIL PROTECTED] wrote: Rick, What's your DB platform? Are you sure there is not a better non-cf way to do it? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:04 AM To: CF-Talk Subject: CSV Generation MEMORY SUCK So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
Yah...it might be useful for java coding, but anything that uses html or CF...that is completely useless and pretty stupid. To you. And, as Charlie pointed out, it can easily be turned off so no need for beef. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfquery returns db tinyint(1) as boolean
hi, after lots of problematic select statements we have realised that if a db column has a type of tinyint(1) and that column in the mysql db has '2' stored in it, then running a cfquery will only return 0 or 1 so we realise that cfquery must convert tinyint(1) columns to boolean we couldn't believe that a the same select statement directly in mysql returned a value of 2 but a cfquery returned the value 1 - on the tinyint(1) column is this right?, is this a bug? or is there a way we can turn this conversion to a boolean off? or will we have to change any tinyint(1) columns to smallint(1) thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Eclipse Question
If it worked correctly it would be incredibly useful. The logic to parse CFML is hardly trivial. sarcasm I'm sure Mark is very sorry that he can't spend all of his spare time improving everything that you think is useless and stupid. I'll make a point to remind him to remove it at CFUnited, along with anything else you dislike. /sarcasm On Mon, Jun 2, 2008 at 10:13 AM, Eric Roberts [EMAIL PROTECTED] wrote: Yah...it might be useful for java coding, but anything that uses html or CF...that is completely useless and pretty stupid. Eric /*-Original Message- /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 8:29 AM /*To: CF-Talk /*Subject: RE: Eclipse Question /* /*I personally think that is completely worthless. Autocomplete for /*tags/functions might be useful, but that's generally not. /* /*-Original Message- /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /*Sent: Sunday, June 01, 2008 1:54 PM /*To: CF-Talk /*Subject: RE: Eclipse Question /* /*It does that not just with queries, but also with variable names...it is /*quite annoying and one of my beefs with eclipse. /* /*Eric /* /*/*-Original Message- /*/*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /*/*Sent: Sunday, June 01, 2008 10:37 AM /*/*To: CF-Talk /*/*Subject: Eclipse Question /*/* /*/*Since we are talking about Eclipse... /*/* /*/*When I type some code, allot of times, a window will show up giving me /*/*choices of queries above it. Does anyone know how to disable this? I /*/*hate pressing enter after a line and have it put a query name where I /*/*meant to just end the line. /*/* /*/* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
I know when I had to do this at a previous job I used ArrayAppend to build each line in the CSV, but I see you are using the string buffer. I had no performance diffs at the time, so I just stayed with the CF solution. The one thing I would look at is not using list functions, but instead using Array functions and then one ArrayToList at the end. Also, make sure the queries being executed aren't intensive either. I found in our CSV generation, for every second the query took, it took one second on output so my resources were essentially 50/50 between query and output, Phil On Mon, Jun 2, 2008 at 10:33 AM, Rick Root [EMAIL PROTECTED] wrote: SQL Server 2005. I'm open to suggestion. This is part of an application that allows users to generate CSV files of their own based on their own criteria, so though I'm open to non-CF solutions, I'm not sure there really would be anyway except maybe a homegrown java class to handle the work and be more strict with memory consumption Rick On Mon, Jun 2, 2008 at 10:13 AM, Mark Kruger [EMAIL PROTECTED] wrote: Rick, What's your DB platform? Are you sure there is not a better non-cf way to do it? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:04 AM To: CF-Talk Subject: CSV Generation MEMORY SUCK So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best CF editor?
Oh it may be. I'm just saying you can also do it with CFE. On Mon, Jun 2, 2008 at 10:18 AM, Jason Durham [EMAIL PROTECTED] wrote: I thought FTP support was provided via the Aptana plugin. I've also been busy learning Coldbox, Transfer and Coldspring so I haven't had much time to explore (cf)Eclipse. :) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:20 AM To: CF-Talk Subject: Re: Best CF editor? You are aware - I hope - that CFEclipse has FTP support? It's the FIle Browser. It works both with local paths and FTP paths. One benefit it has over RDS is: -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best CF editor?
I thought FTP support was provided via the Aptana plugin. I've also been busy learning Coldbox, Transfer and Coldspring so I haven't had much time to explore (cf)Eclipse. :) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:20 AM To: CF-Talk Subject: Re: Best CF editor? You are aware - I hope - that CFEclipse has FTP support? It's the FIle Browser. It works both with local paths and FTP paths. One benefit it has over RDS is: a) Most folks disable RDS on production b) I love that w/ FTP, I can specify a folder to jump to immediately. With RDS I have to dig down to my files. On Mon, Jun 2, 2008 at 8:59 AM, Jason Durham [EMAIL PROTECTED] wrote: After being at cf.Objective() and seeing Eclipse used and promoted by so many developers, I'm doing my best to adopt it. Code completion and integrated FTP are the two items I miss the most. I get frustrated with Eclipse closing my elements but not enough to have to type the closing tag every time. Yes, I'm aware that there are some behaviors that I can tweak with regard to closing and auto-insertion. Unfortunately, there is no 'work exactly like DW does' checkbox. :) -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306575 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
On Mon, Jun 2, 2008 at 10:50 AM, Gaulin, Mark [EMAIL PROTECTED] wrote: Also, test you page with the user's query but with the output part (actually writing the file) commented out... If the page is still slow and a huge memory hog then the file stuff above won't help much and you'll have to look at running the query in java too, but I but you'll get something by handling the file better. I honestly don't think it's the file writing that's the problem. I just commented out the fileWrite() statements inside the cfloop tags that would write each line to the file, (the file still being opened with the header row being written to it... and it made zero difference at all in the length of time it took to complete. The query itself runs quite fast. Returns a lot of rows but isn't a complex query. Anyway, I put some cfoutput statements in my gateway (I'm calling it as a direct cfc call not a gateway for testing).. output now().gettime() to see the ms as the method call progresses. The query returns its results in less than 4 seconds. The process of generating the csv (around line 330-340 of the sample code I posted earlier) took 62 of the 68 seconds. And that was without actually WRITING the file. the GOOD news is that a TAB delimited file takes considerably less time (32 seconds vs. 68 seconds), cutting the output time from 62 seconds to 26 seconds. Which means the csvFormat() function is taking up a very large part of the processing time. This is my csvFormat() function: cffunction name=csvFormat output=false access=public returnType=string cfargument name=str type=string required=yes cfif arguments.str neq and not isNumeric(arguments.str) cfreturn #Chr(34)##replace(arguments.str,chr(34),#chr(34)##chr(34)#,ALL)##Chr(34)# cfelse cfreturn arguments.str /cfif /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse Question
How would it be useful? I can't think of a useful aspect of it, working right or wrong, in CF and TML. Mine is turned off. Not sure if it is CFEclipse or eclipse, but that should be turned off by default. That's part and parcel of developing something, whether it is in a paid position or something you do because you just like doing it. If people don't like it, they won't use it. So because of that, you have to be responsive...which does suck when you are the only guy working on it. That's not intended to criticize Mark, who I thin has done a great job on it...just your lame sarcasm. Bad Brian ;-) Eric /*-Original Message- /*From: Brian Kotek [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 10:09 AM /*To: CF-Talk /*Subject: Re: Eclipse Question /* /*If it worked correctly it would be incredibly useful. The logic to parse /*CFML is hardly trivial. /* /*sarcasm /*I'm sure Mark is very sorry that he can't spend all of his spare time /*improving everything that you think is useless and stupid. I'll make a /*point /*to remind him to remove it at CFUnited, along with anything else you /*dislike. /*/sarcasm /* /*On Mon, Jun 2, 2008 at 10:13 AM, Eric Roberts /[EMAIL PROTECTED] wrote: /* /* Yah...it might be useful for java coding, but anything that uses html or /* CF...that is completely useless and pretty stupid. /* /* Eric /* /* /*-Original Message- /* /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /* /*Sent: Monday, June 02, 2008 8:29 AM /* /*To: CF-Talk /* /*Subject: RE: Eclipse Question /* /* /* /*I personally think that is completely worthless. Autocomplete for /* /*tags/functions might be useful, but that's generally not. /* /* /* /*-Original Message- /* /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /* /*Sent: Sunday, June 01, 2008 1:54 PM /* /*To: CF-Talk /* /*Subject: RE: Eclipse Question /* /* /* /*It does that not just with queries, but also with variable names...it /*is /* /*quite annoying and one of my beefs with eclipse. /* /* /* /*Eric /* /* /* /*/*-Original Message- /* /*/*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /* /*/*Sent: Sunday, June 01, 2008 10:37 AM /* /*/*To: CF-Talk /* /*/*Subject: Eclipse Question /* /*/* /* /*/*Since we are talking about Eclipse... /* /*/* /* /*/*When I type some code, allot of times, a window will show up giving /*me /* /*/*choices of queries above it. Does anyone know how to disable this? I /* /*/*hate pressing enter after a line and have it put a query name where /*I /* /*/*meant to just end the line. /* /*/* /* /*/* /* /* /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
#Chr(34)##replace(arguments .str,chr(34),#chr(34)##chr(34)#,ALL)##Chr(34)# There is your bottle neck. CF does not like string manipulation on a large scale. I have tried to parsed large text files before only to watched my dev box just keel over. I see two options off the top of my head, let SQL server do the work or use Java for the string manipulation. Last time I had to parse a large text file like this I ended up writting an ActiveX script for DTS (long time ago) . G On Mon, Jun 2, 2008 at 11:19 AM, Rick Root [EMAIL PROTECTED] wrote: On Mon, Jun 2, 2008 at 10:50 AM, Gaulin, Mark [EMAIL PROTECTED] wrote: Also, test you page with the user's query but with the output part (actually writing the file) commented out... If the page is still slow and a huge memory hog then the file stuff above won't help much and you'll have to look at running the query in java too, but I but you'll get something by handling the file better. I honestly don't think it's the file writing that's the problem. I just commented out the fileWrite() statements inside the cfloop tags that would write each line to the file, (the file still being opened with the header row being written to it... and it made zero difference at all in the length of time it took to complete. The query itself runs quite fast. Returns a lot of rows but isn't a complex query. Anyway, I put some cfoutput statements in my gateway (I'm calling it as a direct cfc call not a gateway for testing).. output now().gettime() to see the ms as the method call progresses. The query returns its results in less than 4 seconds. The process of generating the csv (around line 330-340 of the sample code I posted earlier) took 62 of the 68 seconds. And that was without actually WRITING the file. the GOOD news is that a TAB delimited file takes considerably less time (32 seconds vs. 68 seconds), cutting the output time from 62 seconds to 26 seconds. Which means the csvFormat() function is taking up a very large part of the processing time. This is my csvFormat() function: cffunction name=csvFormat output=false access=public returnType=string cfargument name=str type=string required=yes cfif arguments.str neq and not isNumeric(arguments.str) cfreturn #Chr(34)##replace(arguments.str,chr(34),#chr(34)##chr(34)#,ALL)##Chr(34)# cfelse cfreturn arguments.str /cfif /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306579 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
How could it be useful? You're kidding, right? Having introspection for all variables, component methods, and method arguments would be unbelievably great. This is the number one complaint I've ever heard regarding CF IDE's. Without a compiler, the only way this can possibly work is by parsing the CFML in the editor, which is exactly what this feature is trying to do. If you don't like it, turn it off. It's a simple check box. On Mon, Jun 2, 2008 at 11:28 AM, Eric Roberts [EMAIL PROTECTED] wrote: How would it be useful? I can't think of a useful aspect of it, working right or wrong, in CF and TML. Mine is turned off. Not sure if it is CFEclipse or eclipse, but that should be turned off by default. That's part and parcel of developing something, whether it is in a paid position or something you do because you just like doing it. If people don't like it, they won't use it. So because of that, you have to be responsive...which does suck when you are the only guy working on it. That's not intended to criticize Mark, who I thin has done a great job on it...just your lame sarcasm. Bad Brian ;-) Eric /*-Original Message- /*From: Brian Kotek [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 10:09 AM /*To: CF-Talk /*Subject: Re: Eclipse Question /* /*If it worked correctly it would be incredibly useful. The logic to parse /*CFML is hardly trivial. /* /*sarcasm /*I'm sure Mark is very sorry that he can't spend all of his spare time /*improving everything that you think is useless and stupid. I'll make a /*point /*to remind him to remove it at CFUnited, along with anything else you /*dislike. /*/sarcasm /* /*On Mon, Jun 2, 2008 at 10:13 AM, Eric Roberts /[EMAIL PROTECTED] wrote: /* /* Yah...it might be useful for java coding, but anything that uses html or /* CF...that is completely useless and pretty stupid. /* /* Eric /* /* /*-Original Message- /* /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /* /*Sent: Monday, June 02, 2008 8:29 AM /* /*To: CF-Talk /* /*Subject: RE: Eclipse Question /* /* /* /*I personally think that is completely worthless. Autocomplete for /* /*tags/functions might be useful, but that's generally not. /* /* /* /*-Original Message- /* /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /* /*Sent: Sunday, June 01, 2008 1:54 PM /* /*To: CF-Talk /* /*Subject: RE: Eclipse Question /* /* /* /*It does that not just with queries, but also with variable names...it /*is /* /*quite annoying and one of my beefs with eclipse. /* /* /* /*Eric /* /* /* /*/*-Original Message- /* /*/*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /* /*/*Sent: Sunday, June 01, 2008 10:37 AM /* /*/*To: CF-Talk /* /*/*Subject: Eclipse Question /* /*/* /* /*/*Since we are talking about Eclipse... /* /*/* /* /*/*When I type some code, allot of times, a window will show up giving /*me /* /*/*choices of queries above it. Does anyone know how to disable this? I /* /*/*hate pressing enter after a line and have it put a query name where /*I /* /*/*meant to just end the line. /* /*/* /* /*/* /* /* /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
Use a Java StringBuffer or StringBuilder. Concatenating large strings in CF is always a memory hog because every single concatenation creates a new String instance. Check RIAForge, there are CFC libraries that wrap using these Java classes for exactly this purpose. You'll find memory usage drops dramatically. On Mon, Jun 2, 2008 at 10:03 AM, Rick Root [EMAIL PROTECTED] wrote: So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Guide for reviewing a website
On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
On Monday 02 Jun 2008, Rick Root wrote: generating the csv (around line 330-340 of the sample code I posted earlier) took 62 of the 68 seconds. Why not output the file all at once, rather than a line at a time (scrap lines ~336 - just keeping .append()'ing to a StringBuffer till your done) ? Also, have you benchmarked the EnquireLookupCFC (line 333) ? What does that do ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
Sure, but again, Ruby has URL and FORM variables that their editors still have introspection. You're right that it can't know about incoming variables in those scopes, but for CFC methods where things are declared as arguments we could still get the benefit of hinting. If you really need intellisense for incoming variables, you could implement them the way DW does on its Binding panel. You define their names, DW stores on the file's metadata and make them available from the panel. DW's implementation has two drawbacks: 1) DW's is page-centric so this gets defined on a page by page basis. Very annoying if you want to do that for session/application data or the like. There should be a way to define this on a project basis 2) DW creates a different notes file for each file where you use this feature. Very annoying, metadata should be stored in one single place for each project (here Eclipse does it right) Once again, both DW and CFEclipse doesn't make me happy... Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery returns db tinyint(1) as boolean
hi dave. yeah we just found that it is a previously submitted bug for mysql jconnector which we use in dreamweaver. to get around it we just changed those columns to smallint(1) thanks after lots of problematic select statements we have realised I don't know if this is a problem specific to MySQL or the MySQL JDBC drivers. You might work around this by simply casting within your SQL. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
It's also my number one complaint on CF IDEs, and that's the main reason I am unhappy about both CFEclipse and DW. Agreed. There are some IDEs that offer code assist/completion for the functions in included scripts/Libraries (JS, PHP etc.) which can be invaluable when working with large libraries. What Aptana does with Ajax (YUI, EXT, Dojo, MooTools etc) libraries, Adobe AIR and JS include files is pretty amazing. I would be beside myself with joy if this sort of functionality was avalible in a CF IDE. G On Mon, Jun 2, 2008 at 12:46 PM, Massimo Foti [EMAIL PROTECTED] wrote: I'm not sure what you mean by the outside world. But for CFCs, I'm not saying it would be easy, as it definitely would be extremely difficult. And it would never be perfect. But if through convention or configuration options one could point Eclipse at CFC paths, introspection of non-dynamic component methods and arguments would definitely be possible. The Ruby editors do this. Aptana does this pretty well for JavaScript too. And JavaScript isn't an easy beast. It's also my number one complaint on CF IDEs, and that's the main reason I am unhappy about both CFEclipse and DW. Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
On Mon, Jun 2, 2008 at 12:28 PM, Eric Roberts [EMAIL PROTECTED] wrote: No...I find it to be a PIA when I am trying to type out code and it automatically inserts a variable name that has nothing to do with what I am doing. Not sure what world you are in, but that is not useful at all...it slows down my productivity because I am always either backspacing to get rid of the variable or any time I use an end bracket on a tag I am having to click on it to get rid of the drop down instead of just typing. The better way to handle that is if you want to use it, have a hot key that can bring up the dropdown if you want it. Having it as a option that is automatically checked in Eclipse's very unintuitive, clumsy, and time wasting preferences menu is not a good solution. There is already enough useless crap in there as it is. And I do have it disabled BTW. If you have it disabled, what is your problem? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
On Mon, Jun 2, 2008 at 11:40 AM, Gerald Guido [EMAIL PROTECTED] wrote: #Chr(34)##replace(arguments .str,chr(34),#chr(34)##chr(34)#,ALL)##Chr(34)# There is your bottle neck. CF does not like string manipulation on a large scale. I have tried to parsed large text files before only to watched my dev box just keel over. This is only being done on a per field basis, so it's not a manipulation being done on a large scale. At least not on a large string. It's being done on the individual fields. I suspect that the largest string of data being dealt with by the csvFormat() function is 50 characters. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
On Mon, Jun 2, 2008 at 11:42 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Rick Root wrote: generating the csv (around line 330-340 of the sample code I posted earlier) took 62 of the 68 seconds. Why not output the file all at once, rather than a line at a time (scrap lines ~336 - just keeping .append()'ing to a StringBuffer till your done) ? I could do that but as I mentioned, the file writing is not the problem. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Eclipse Question
I'm not sure what you mean by the outside world. But for CFCs, I'm not saying it would be easy, as it definitely would be extremely difficult. And it would never be perfect. But if through convention or configuration options one could point Eclipse at CFC paths, introspection of non-dynamic component methods and arguments would definitely be possible. The Ruby editors do this. Aptana does this pretty well for JavaScript too. And JavaScript isn't an easy beast. It's also my number one complaint on CF IDEs, and that's the main reason I am unhappy about both CFEclipse and DW. Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery returns db tinyint(1) as boolean
after lots of problematic select statements we have realised that if a db column has a type of tinyint(1) and that column in the mysql db has '2' stored in it, then running a cfquery will only return 0 or 1 so we realise that cfquery must convert tinyint(1) columns to boolean we couldn't believe that a the same select statement directly in mysql returned a value of 2 but a cfquery returned the value 1 - on the tinyint(1) column is this right?, is this a bug? or is there a way we can turn this conversion to a boolean off? or will we have to change any tinyint(1) columns to smallint(1) I don't know if this is a problem specific to MySQL or the MySQL JDBC drivers. You might work around this by simply casting within your SQL. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
Didn't look at the code, eh? On Mon, Jun 2, 2008 at 12:07 PM, Brian Kotek [EMAIL PROTECTED] wrote: Use a Java StringBuffer or StringBuilder. Concatenating large strings in CF On Mon, Jun 2, 2008 at 10:03 AM, Rick Root [EMAIL PROTECTED] wrote: http://cfm.pastebin.org/40043 -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse Question
How could it be useful? You're kidding, right? Having introspection for all variables, component methods, and method arguments would be unbelievably great. This is the number one complaint I've ever heard regarding CF IDE's. Without a compiler, the only way this can possibly work is by parsing the CFML in the editor, which is exactly what this feature is trying to do. Since CF programs can receive arbitrary variables from the outside world, I can't see how this would possibly work whether you parse the CFML in the editor or not. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse Question
No...I find it to be a PIA when I am trying to type out code and it automatically inserts a variable name that has nothing to do with what I am doing. Not sure what world you are in, but that is not useful at all...it slows down my productivity because I am always either backspacing to get rid of the variable or any time I use an end bracket on a tag I am having to click on it to get rid of the drop down instead of just typing. The better way to handle that is if you want to use it, have a hot key that can bring up the dropdown if you want it. Having it as a option that is automatically checked in Eclipse's very unintuitive, clumsy, and time wasting preferences menu is not a good solution. There is already enough useless crap in there as it is. And I do have it disabled BTW. Eric /*-Original Message- /*From: Brian Kotek [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 11:05 AM /*To: CF-Talk /*Subject: Re: Eclipse Question /* /*How could it be useful? You're kidding, right? Having introspection for /*all /*variables, component methods, and method arguments would be unbelievably /*great. This is the number one complaint I've ever heard regarding CF /*IDE's. /*Without a compiler, the only way this can possibly work is by parsing the /*CFML in the editor, which is exactly what this feature is trying to do. If /*you don't like it, turn it off. It's a simple check box. /* /*On Mon, Jun 2, 2008 at 11:28 AM, Eric Roberts /[EMAIL PROTECTED] wrote: /* /* How would it be useful? I can't think of a useful aspect of it, working /* right or wrong, in CF and TML. Mine is turned off. Not sure if it is /* CFEclipse or eclipse, but that should be turned off by default. /* /* That's part and parcel of developing something, whether it is in a paid /* position or something you do because you just like doing it. If people /* don't like it, they won't use it. So because of that, you have to be /* responsive...which does suck when you are the only guy working on it. /* That's not intended to criticize Mark, who I thin has done a great job /*on /* it...just your lame sarcasm. Bad Brian ;-) /* /* Eric /* /* /*-Original Message- /* /*From: Brian Kotek [mailto:[EMAIL PROTECTED] /* /*Sent: Monday, June 02, 2008 10:09 AM /* /*To: CF-Talk /* /*Subject: Re: Eclipse Question /* /* /* /*If it worked correctly it would be incredibly useful. The logic to /*parse /* /*CFML is hardly trivial. /* /* /* /*sarcasm /* /*I'm sure Mark is very sorry that he can't spend all of his spare time /* /*improving everything that you think is useless and stupid. I'll make a /* /*point /* /*to remind him to remove it at CFUnited, along with anything else you /* /*dislike. /* /*/sarcasm /* /* /* /*On Mon, Jun 2, 2008 at 10:13 AM, Eric Roberts /* /[EMAIL PROTECTED] wrote: /* /* /* /* Yah...it might be useful for java coding, but anything that uses /*html /* or /* /* CF...that is completely useless and pretty stupid. /* /* /* /* Eric /* /* /* /* /*-Original Message- /* /* /*From: Andy Matthews [mailto:[EMAIL PROTECTED] /* /* /*Sent: Monday, June 02, 2008 8:29 AM /* /* /*To: CF-Talk /* /* /*Subject: RE: Eclipse Question /* /* /* /* /* /*I personally think that is completely worthless. Autocomplete for /* /* /*tags/functions might be useful, but that's generally not. /* /* /* /* /* /*-Original Message- /* /* /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /* /* /*Sent: Sunday, June 01, 2008 1:54 PM /* /* /*To: CF-Talk /* /* /*Subject: RE: Eclipse Question /* /* /* /* /* /*It does that not just with queries, but also with variable /*names...it /* /*is /* /* /*quite annoying and one of my beefs with eclipse. /* /* /* /* /* /*Eric /* /* /* /* /* /*/*-Original Message- /* /* /*/*From: Phillip M. Vector [mailto:[EMAIL PROTECTED] /* /* /*/*Sent: Sunday, June 01, 2008 10:37 AM /* /* /*/*To: CF-Talk /* /* /*/*Subject: Eclipse Question /* /* /*/* /* /* /*/*Since we are talking about Eclipse... /* /* /*/* /* /* /*/*When I type some code, allot of times, a window will show up /*giving /* /*me /* /* /*/*choices of queries above it. Does anyone know how to disable /*this? /* I /* /* /*/*hate pressing enter after a line and have it put a query name /*where /* /*I /* /* /*/*meant to just end the line. /* /* /*/* /* /* /*/* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
I'm not sure what you mean by the outside world. But for CFCs, I'm not saying it would be easy, as it definitely would be extremely difficult. And it would never be perfect. But if through convention or configuration options one could point Eclipse at CFC paths, introspection of non-dynamic component methods and arguments would definitely be possible. The Ruby editors do this. There is also the option to embed some form of CFML runtime directly into the IDE, or to connect to a local CF install in a way similar to the step debugger, to get some form of true runtime information. On Mon, Jun 2, 2008 at 12:17 PM, Dave Watts [EMAIL PROTECTED] wrote: How could it be useful? You're kidding, right? Having introspection for all variables, component methods, and method arguments would be unbelievably great. This is the number one complaint I've ever heard regarding CF IDE's. Without a compiler, the only way this can possibly work is by parsing the CFML in the editor, which is exactly what this feature is trying to do. Since CF programs can receive arbitrary variables from the outside world, I can't see how this would possibly work whether you parse the CFML in the editor or not. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306588 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Exchange error Code : 501
Hi, I am wondering whether can I get any solution with attachmentpath attribute of cfexchangeemail tag, when I am trying to put some folder path which has all sorts of permissions given, I hit with this error, I kindly request to post the solution for this issue. This would be of great help. Thanks, Vamsi Krishna ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
On Mon, Jun 2, 2008 at 12:34 PM, Brian Kotek [EMAIL PROTECTED] wrote: The difference is that you have to use the StringBuffer for everything. Since you aren't passing the StringBuffer into the CSVFormat method and I don't see the code for that method, I assume it is still suffering from the creation of large numbers of String instances. Try passing the StringBuffer into CSVFormat and use it within the method to append the data. Now *THAT* I hadn't though of. Lemme give that a whirl. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
No, I opened it and saw that it was 400 lines long and didn't have time to go through it all. But sweeping through it quickly, the same advice applies. The difference is that you have to use the StringBuffer for everything. Since you aren't passing the StringBuffer into the CSVFormat method and I don't see the code for that method, I assume it is still suffering from the creation of large numbers of String instances. Try passing the StringBuffer into CSVFormat and use it within the method to append the data. On Mon, Jun 2, 2008 at 12:25 PM, Rick Root [EMAIL PROTECTED] wrote: Didn't look at the code, eh? On Mon, Jun 2, 2008 at 12:07 PM, Brian Kotek [EMAIL PROTECTED] wrote: Use a Java StringBuffer or StringBuilder. Concatenating large strings in CF On Mon, Jun 2, 2008 at 10:03 AM, Rick Root [EMAIL PROTECTED] wrote: http://cfm.pastebin.org/40043 -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse Question
I'm not sure what you mean by the outside world. I mean things like the form and URL scopes, among other scopes. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 server for intranet, which OS? what hardware? what netwo rk?
My situation is that since the DB of choice is MS-SQL, I need a windows server that host the CF8 (Standard), and MS-SQL Server 2005. 1. Which version of windows is appropriate for a CF SQL server for a small Intranet ( 10 clients)? - Windows Server 2008? - Windows Server 2003 SP2? - Windows Vista Business version? is this enough??? I wouldn't use Vista for a server for any purpose, since it's not designed to do this. Windows Server 2003 would be sufficient for an application server, as would Linux or Solaris. I haven't done any serious work with Windows Server 2008, so I'll reserve judgment on that. Ideally, you shouldn't run your database server on the same machine as your application server. There are many reasons for this: security, performance, stability. With ten users, you'll probably only care about the security reasons. You could run SQL Server on Windows, and CF on any platform you like, if you separate the two. Of course, that means you have to purchase two servers instead of one. 2. Is 4GB on 32-bit OS enough? Or should I go for 64-bit? (keep in mind I'll be using CF8 Standard with no 64bit Windows support) Yes, that's plenty for your application server, if you're running CF Standard. 3. Is ECC RAM necessary? If not, when is it necessary? It's always a good idea for servers, but I don't know if I'd go so far as to say it's necessary. 4. When is using active directory on CF8 for authentication a good idea? When you are currently using AD for all your other authentication. If you plan to allow public or semi-public access, you probably don't want to authenticate those users via AD. Using AD doesn't necessarily require that you do anything special in CF, since AD authentication can be implemented at the web server if you're using IIS. 5. If I want the intranet to also have access to the internet, should they all go through the windows server by a hub/switch? Or should they be connected directly to the internet router using another network cable? Well, here, things get a little difficult. To host servers that will be accessible from the outside world, you really need a segmented network, with separate zones for internal, external, and DMZ. Your public servers would go in the DMZ. 6. Will there be any foreseeable problem with clients running Linux? I'm not exactly sure what you mean by this, but in the absence of any other information I'll say no. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Eclipse Question
Sure, but again, Ruby has URL and FORM variables that their editors still have introspection. You're right that it can't know about incoming variables in those scopes, but for CFC methods where things are declared as arguments we could still get the benefit of hinting. On Mon, Jun 2, 2008 at 12:40 PM, Dave Watts [EMAIL PROTECTED] wrote: I'm not sure what you mean by the outside world. I mean things like the form and URL scopes, among other scopes. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
I found a nice little java class library called JavaCSV that handles all the file writing and dropped my time from 68 seconds to 18 seconds. That has potential! It basically handles the writing of delimiters and the proper csv formatting.. so here's my code: cfset var fileOutput = createObject(java,com.csvreader.CsvWriter) cfset fileOutput.init(#expandPath(..)#\drops\#filename#) cfloop query=resultSet !--- write record --- cfloop from=1 to=#numFields# index=i step=1 cfset fileOutput.write( resultSet[fieldsArray[i]][resultSet.currentRow].toString() ) /cfloop !--- write end of record --- cfset fileOutput.endRecord() /cfloop cfset fileOutput.close() ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse Question
Ok.. This isn't what I wanted... :) Yes, it removes that window, but I LIKE the filling in of the variables for the tags. Isn't there a way I can have that without having that window pop up showing old query names? On Sun, Jun 1, 2008 at 11:44 AM, Charlie Griefer [EMAIL PROTECTED] wrote: On Sun, Jun 1, 2008 at 8:37 AM, Phillip M. Vector [EMAIL PROTECTED] wrote: Since we are talking about Eclipse... When I type some code, allot of times, a window will show up giving me choices of queries above it. Does anyone know how to disable this? I hate pressing enter after a line and have it put a query name where I meant to just end the line. window - preferences - cfeclipse - file parser - parse variables as you type (uncheck) -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MS SQL / Mac OS X
I just got a MacBook Pro and everything is great, but I was wondering what the best way would be to manage a MS SQL server would be. Obviously I can't install MSSQL Studio natively. I have Parallels, but having a hell of a time getting Windows XP running in a VM. My original plan was to just run SQL Studio in the VM, but its not going as well as I had expected. What do you all use to manage a SQL server from OS X, if you do at all? Thanks! Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 1 IP address, 2 websites
One idea: I think you can set up separate virtual sites in IIS with the same IP and port... Secondly, write a quick redirect script in CF that goes to a directory based on the domain name passed in via CGI. I forget which variable it is. The only drawback is that this file must be index.cfm in the root. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2008 12:48 PM To: CF-Talk Subject: 1 IP address, 2 websites I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
dropped my time from 68 seconds to 18 seconds Nice. Is that entirety of the code sans the query? little java class library called JavaCSV that handles The the one from SourceForge? I am going to need something like this shortly. G -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: One IP address, Two websites
Isn't there open source bludragon now? I would've though that they got rid of the one ip limitation. Russ -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2008 3:04 PM To: CF-Talk Subject: One IP address, Two websites I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How do you create a scalable solution?
Hello, I have been reading about Twitter having scalability issues lately. This morning I was thinking to myself: If I had to make a site like Twitter that was scalable, how would I do that? Then it hit me, I don't really know how to make a site scalable. I have read and heard about things like: Load Balancers, Server Clusters etc... My answer has always been I would work with my hosting company if I ever needed to start dealing with that stuff. They are professionals, they will be able to set that up for me. That may or may not be a good answer for the hardware part of scalability. But really that's only part of it. My coldfusion site needs to be coded to be scalable too.. So I decided to do some research. I googled Scalable Coldfusion: http://articles.techrepublic.com.com/5100-10878_11-1045128.html talks about coldfusion being scalable, but is a little outdated. It was published in 2002. http://livedocs.adobe.com/coldfusion/6/Using_ClusterCATS/overview.htm talks about Scalability and Availability. It's a good read about the different hardware and software options. I read some other articles about making sure that you cache queries at all costs, make sure not to use Select *, being cautious of links etc, making sure code is organized and modular as possible. This was a good overview: http://www.adobepress.com/articles/article.asp?p=31089seqNum=1 It is one of Ben Forta's books. It had a lot of cool basics in there. So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. I am sure there is more to it. The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If one DB server goes down, how would CF Server know to switch to another one. I need to do more research. I also have read about geocoded servers. Not sure what the proper term is, but from what I understand it is where you have servers around the country or globe and based on the user's ip address the user would download graphics and other site items from those servers making things quicker. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Did you learn based on trial and error? Is there 1 or 2 comprehensive resources that have all this information or did you have to research each piece separately? Thank you to anyone who would like to provide their feedback. I am not asking you to do my research, I am curious to learn how you got started, and any other helpful feedback you may have and any resources that were crucial in helping you create a scalable website solution. Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How do you create a scalable solution?
Hello, I sent this yesterday around 2PM EDT and it did not seem to go through so I am sending again. Sorry if they both come through. I have been reading about Twitter having scalability issues lately. This morning I was thinking to myself: If I had to make a site like Twitter that was scalable, how would I do that? Then it hit me, I don't really know how to make a site scalable. I have read and heard about things like: Load Balancers, Server Clusters etc... My answer has always been I would work with my hosting company if I ever needed to start dealing with that stuff. They are professionals, they will be able to set that up for me. That may or may not be a good answer for the hardware part of scalability. But really that's only part of it. My coldfusion site needs to be coded to be scalable too.. So I decided to do some research. I googled Scalable Coldfusion: http://articles.techrepublic.com.com/5100-10878_11-1045128.html talks about coldfusion being scalable, but is a little outdated. It was published in 2002. http://livedocs.adobe.com/coldfusion/6/Using_ClusterCATS/overview.htm talks about Scalability and Availability. It's a good read about the different hardware and software options. I read some other articles about making sure that you cache queries at all costs, make sure not to use Select *, being cautious of links etc, making sure code is organized and modular as possible. This was a good overview: http://www.adobepress.com/articles/article.asp?p=31089seqNum=1 It is one of Ben Forta's books. It had a lot of cool basics in there. So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. I am sure there is more to it. The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If one DB server goes down, how would CF Server know to switch to another one. I need to do more research. I also have read about geocoded servers. Not sure what the proper term is, but from what I understand it is where you have servers around the country or globe and based on the user's ip address the user would download graphics and other site items from those servers making things quicker. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Did you learn based on trial and error? Is there 1 or 2 comprehensive resources that have all this information or did you have to research each piece separately? Thank you to anyone who would like to provide their feedback. I am not asking you to do my research, I am curious to learn how you got started, and any other helpful feedback you may have and any resources that were crucial in helping you create a scalable website solution. Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS SQL / Mac OS X
Hi Steve, I've been using Aqua Data Studio. It works quite well for doing most things in SQL Server. I'm not sure if it can be completely used to manage but for doing queries, writing stored procs and things like that it's fine. The one time I ran into an issue was trying to log into an account that needed to change it's password. Aqua Data Studio didn't seem to know how to do that. Thanks, Ben On Sat, May 31, 2008 at 3:11 AM, Steve Good [EMAIL PROTECTED] wrote: I just got a MacBook Pro and everything is great, but I was wondering what the best way would be to manage a MS SQL server would be. Obviously I can't install MSSQL Studio natively. I have Parallels, but having a hell of a time getting Windows XP running in a VM. My original plan was to just run SQL Studio in the VM, but its not going as well as I had expected. What do you all use to manage a SQL server from OS X, if you do at all? Thanks! Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery returns db tinyint(1) as boolean
iirc, this is not a cfquery doing, but rather the mysql jdbc driver's. there is some setting for the connector-j and/or in mysql server config file that changes this behaviour, but you will have to look it up in the mysql reference manual - i do not remember the details of this setting... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Richard White wrote: hi, after lots of problematic select statements we have realised that if a db column has a type of tinyint(1) and that column in the mysql db has '2' stored in it, then running a cfquery will only return 0 or 1 so we realise that cfquery must convert tinyint(1) columns to boolean we couldn't believe that a the same select statement directly in mysql returned a value of 2 but a cfquery returned the value 1 - on the tinyint(1) column is this right?, is this a bug? or is there a way we can turn this conversion to a boolean off? or will we have to change any tinyint(1) columns to smallint(1) thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306614 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
One IP address, Two websites
I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
1 IP address, 2 websites
I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: One IP address, Two websites
He has the aliases set up. He can navigate to report1 and get the correct site. After a bounce of the Bluedragon service, he can navigate to report2 and get the correct site. This seems like IIS and the aliases are working properly. I'm still betting that if Bluedragon is shut down and he puts HTML pages in those folders he will get to them both without any problems. Steve -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 2:27 PM To: CF-Talk Subject: RE: One IP address, Two websites It shouldn't matter whether it is adobe or blue dragon, the web server controls that. It's just a matter of setting up virtual sites in IIS or aliases (I will use alias to describe both) in apache. So then if you have report1.com and report2.com, you set up aliases in your web server that point to the appropriate directories. On my work laptop, I do all of my development locally and have it set up like that...and in my hosts file I have an entry for each dev site...the same could be done for your local dns if you are doing this for several people on a separate dev server. Eric /*-Original Message- /*From: Steven Milburn [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 1:20 PM /*To: CF-Talk /*Subject: RE: One IP address, Two websites /* /*Using multiple web sites on 1 IP address is called name-based virtual /*hosting. Based on what you are describing - you can get to report1 after /*bouncing Bluedragon and can get to report2 after bouncing Bluedragon - IIS /*is configured and working properly. I have never used Bluedragon before, /*but I suspect therein lies the problem, not with IIS or any network /*administration issue. /* /*One way to test this may be to place a few plain ol' HTML files in those /*web sites and browse to them (so the Bluedragon server does not come into /*play). My bet is that you will be able to get to the HTML files in both /*sites without any problems. /* /*Steve /* /* /*-Original Message- /*From: Billy Cox [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, May 28, 2008 3:04 PM /*To: CF-Talk /*Subject: One IP address, Two websites /* /*I want to host two separate internal development websites (report1 and /*report2) on one IP address. The problem is that when I go to /*http://report2, /*I get the report1 site. /* /*I have set up the two websites in IIS 6. Both websites are on port 80, /*which /*according to what I have read should be okay since I am setting a distinct /*host header for each site. I have set up report1 and report2 as hostnames /*on /*my DNS server, both pointing at 192.168.0.55. /* /*The CF server is Bluedragon (free) which has a one IP address limitation, /*hence my desire to use one IP address. If I restart the Bluedragon /*service, /*I can browse to report2, but then when I browse to report1, I get the /*report2 site. /* /*I haven't needed to do much network administration in the past, so this is /*new to me. What am I missing? Is there a better way to accomplish this /*(separate ports maybe)? /* /* /*Thanks, /* /*Billy Cox /*Old World Spices /[EMAIL PROTECTED] /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: One IP address, Two websites
Is the version of BD you are using limited to 1 site by any chance...I am not familiar with what they do with their product. I would test that...if html is served ok with BD off, then there may be some sort of restriction in BD doing it...kind of like the IP restriction on the CF developer edition from Adobe /*-Original Message- /*From: Steven Milburn [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 1:33 PM /*To: CF-Talk /*Subject: RE: One IP address, Two websites /* /*He has the aliases set up. He can navigate to report1 and get the correct /*site. After a bounce of the Bluedragon service, he can navigate to /*report2 and get the correct site. This seems like IIS and the aliases are /*working properly. I'm still betting that if Bluedragon is shut down and /*he puts HTML pages in those folders he will get to them both without any /*problems. /* /*Steve /* /* /*-Original Message- /*From: Eric Roberts [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 2:27 PM /*To: CF-Talk /*Subject: RE: One IP address, Two websites /* /*It shouldn't matter whether it is adobe or blue dragon, the web server /*controls that. It's just a matter of setting up virtual sites in IIS or /*aliases (I will use alias to describe both) in apache. So then if you /*have report1.com and report2.com, you set up aliases in your web server /*that /*point to the appropriate directories. On my work laptop, I do all of my /*development locally and have it set up like that...and in my hosts file I /*have an entry for each dev site...the same could be done for your local /*dns /*if you are doing this for several people on a separate dev server. /* /*Eric /* /*/*-Original Message- /*/*From: Steven Milburn [mailto:[EMAIL PROTECTED] /*/*Sent: Monday, June 02, 2008 1:20 PM /*/*To: CF-Talk /*/*Subject: RE: One IP address, Two websites /*/* /*/*Using multiple web sites on 1 IP address is called name-based virtual /*/*hosting. Based on what you are describing - you can get to report1 /*after /*/*bouncing Bluedragon and can get to report2 after bouncing Bluedragon - /*IIS /*/*is configured and working properly. I have never used Bluedragon /*before, /*/*but I suspect therein lies the problem, not with IIS or any network /*/*administration issue. /*/* /*/*One way to test this may be to place a few plain ol' HTML files in those /*/*web sites and browse to them (so the Bluedragon server does not come /*into /*/*play). My bet is that you will be able to get to the HTML files in both /*/*sites without any problems. /*/* /*/*Steve /*/* /*/* /*/*-Original Message- /*/*From: Billy Cox [mailto:[EMAIL PROTECTED] /*/*Sent: Wednesday, May 28, 2008 3:04 PM /*/*To: CF-Talk /*/*Subject: One IP address, Two websites /*/* /*/*I want to host two separate internal development websites (report1 and /*/*report2) on one IP address. The problem is that when I go to /*/*http://report2, /*/*I get the report1 site. /*/* /*/*I have set up the two websites in IIS 6. Both websites are on port 80, /*/*which /*/*according to what I have read should be okay since I am setting a /*distinct /*/*host header for each site. I have set up report1 and report2 as /*hostnames /*/*on /*/*my DNS server, both pointing at 192.168.0.55. /*/* /*/*The CF server is Bluedragon (free) which has a one IP address /*limitation, /*/*hence my desire to use one IP address. If I restart the Bluedragon /*/*service, /*/*I can browse to report2, but then when I browse to report1, I get the /*/*report2 site. /*/* /*/*I haven't needed to do much network administration in the past, so this /*is /*/*new to me. What am I missing? Is there a better way to accomplish this /*/*(separate ports maybe)? /*/* /*/* /*/*Thanks, /*/* /*/*Billy Cox /*/*Old World Spices /*/[EMAIL PROTECTED] /*/* /*/* /*/* /*/* /*/* /*/* /*/* /*/* /*/* /*/* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: One IP address, Two websites
It shouldn't matter whether it is adobe or blue dragon, the web server controls that. It's just a matter of setting up virtual sites in IIS or aliases (I will use alias to describe both) in apache. So then if you have report1.com and report2.com, you set up aliases in your web server that point to the appropriate directories. On my work laptop, I do all of my development locally and have it set up like that...and in my hosts file I have an entry for each dev site...the same could be done for your local dns if you are doing this for several people on a separate dev server. Eric /*-Original Message- /*From: Steven Milburn [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 1:20 PM /*To: CF-Talk /*Subject: RE: One IP address, Two websites /* /*Using multiple web sites on 1 IP address is called name-based virtual /*hosting. Based on what you are describing - you can get to report1 after /*bouncing Bluedragon and can get to report2 after bouncing Bluedragon - IIS /*is configured and working properly. I have never used Bluedragon before, /*but I suspect therein lies the problem, not with IIS or any network /*administration issue. /* /*One way to test this may be to place a few plain ol' HTML files in those /*web sites and browse to them (so the Bluedragon server does not come into /*play). My bet is that you will be able to get to the HTML files in both /*sites without any problems. /* /*Steve /* /* /*-Original Message- /*From: Billy Cox [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, May 28, 2008 3:04 PM /*To: CF-Talk /*Subject: One IP address, Two websites /* /*I want to host two separate internal development websites (report1 and /*report2) on one IP address. The problem is that when I go to /*http://report2, /*I get the report1 site. /* /*I have set up the two websites in IIS 6. Both websites are on port 80, /*which /*according to what I have read should be okay since I am setting a distinct /*host header for each site. I have set up report1 and report2 as hostnames /*on /*my DNS server, both pointing at 192.168.0.55. /* /*The CF server is Bluedragon (free) which has a one IP address limitation, /*hence my desire to use one IP address. If I restart the Bluedragon /*service, /*I can browse to report2, but then when I browse to report1, I get the /*report2 site. /* /*I haven't needed to do much network administration in the past, so this is /*new to me. What am I missing? Is there a better way to accomplish this /*(separate ports maybe)? /* /* /*Thanks, /* /*Billy Cox /*Old World Spices /[EMAIL PROTECTED] /* /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Calling one CFC file from another using cfobject
I use cfobject to instantiate my components in my Application.cfm file. cfobject name=test1obj component=cfc/test1 cfobject name=test2obj component=cfc/test2 Can I use test1.cfc to call a method from test2.cfc? In a typical .cfm page I would invoke the component like this, cfinvoke component=#test2obj#... However, if I use this same code inside of test1.cfc, I get the error Variable test2obj is undefined. Is there a way I can create the object so that it is available to use in a CFC? Thanks Brian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306619 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery returns db tinyint(1) as boolean
oh i see, i didnt think they had fixed it yet, ok thanks ill look into the config - thanks azadi iirc, this is not a cfquery doing, but rather the mysql jdbc driver's. there is some setting for the connector-j and/or in mysql server config file that changes this behaviour, but you will have to look it up in the mysql reference manual - i do not remember the details of this setting... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Richard White wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 1 IP address, 2 websites
You need to setup the host-header for each site (or just for one should do): IIS - Websites - MySite - Properties - Website tab - Advanced button: Then for host header value enter the the host, i.e. www.mysite.com HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: One IP address, Two websites
Using multiple web sites on 1 IP address is called name-based virtual hosting. Based on what you are describing - you can get to report1 after bouncing Bluedragon and can get to report2 after bouncing Bluedragon - IIS is configured and working properly. I have never used Bluedragon before, but I suspect therein lies the problem, not with IIS or any network administration issue. One way to test this may be to place a few plain ol' HTML files in those web sites and browse to them (so the Bluedragon server does not come into play). My bet is that you will be able to get to the HTML files in both sites without any problems. Steve -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2008 3:04 PM To: CF-Talk Subject: One IP address, Two websites I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse Question
My problem is that I had to go do something to disable a useless feature that caused me to be less efficient Eric /*-Original Message- /*From: Brian Kotek [mailto:[EMAIL PROTECTED] /*Sent: Monday, June 02, 2008 11:42 AM /*To: CF-Talk /*Subject: Re: Eclipse Question /* /*On Mon, Jun 2, 2008 at 12:28 PM, Eric Roberts /[EMAIL PROTECTED] wrote: /* /* No...I find it to be a PIA when I am trying to type out code and it /* automatically inserts a variable name that has nothing to do with what I /*am /* doing. Not sure what world you are in, but that is not useful at /*all...it /* slows down my productivity because I am always either backspacing to get /* rid /* of the variable or any time I use an end bracket on a tag I am having to /* click on it to get rid of the drop down instead of just typing. The /*better /* way to handle that is if you want to use it, have a hot key that can /*bring /* up the dropdown if you want it. Having it as a option that is /* automatically /* checked in Eclipse's very unintuitive, clumsy, and time wasting /*preferences /* menu is not a good solution. There is already enough useless crap in /*there /* as it is. /* /* And I do have it disabled BTW. /* /* /*If you have it disabled, what is your problem? /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Calling one CFC file from another using cfobject
I use cfobject to instantiate my components in my Application.cfm file. cfobject name=test1obj component=cfc/test1 cfobject name=test2obj component=cfc/test2 Can I use test1.cfc to call a method from test2.cfc? In a typical .cfm page I would invoke the component like this, cfinvoke component=#test2obj#... However, if I use this same code inside of test1.cfc, I get the error Variable test2obj is undefined. Is there a way I can create the object so that it is available to use in a CFC? CFC instances are just like any other variables in this regard. If you want to have a variable available in a CF program, it either has to be local to that program or in one of the scopes that is accessible from that program. So, you can either put the variables in the Application or Session or Request scopes, or you can pass the value you want to the CFC as a parameter, so that it can be used locally within the CFC. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: One IP address, Two websites
I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? I haven't worked with the free version of BlueDragon, but it sounds to me like it's not storing the full path to .cfm files, just like CFMX 6.0 didn't do by default. So, when you go to site1/index.cfm, it's just remembering the index.cfm part, and when you go to site2/index.cfm it's just serving up the other file. I don't know if that can be changed, as in CFMX 6.0 and subsequent versions, or if it's a limitation of the free version. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
On Mon, Jun 2, 2008 at 1:44 PM, Gerald Guido [EMAIL PROTECTED] wrote: dropped my time from 68 seconds to 18 seconds Nice. Is that entirety of the code sans the query? Entirety. The query itself takes about 4 seconds to execute and return all its data. little java class library called JavaCSV that handles The the one from SourceForge? I am going to need something like this shortly. Yeah, that's the one. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One IP address, Two websites
Dave Watts wrote: I want to host two separate internal development websites (report1 and report2) on one IP address. The problem is that when I go to http://report2, I get the report1 site. I have set up the two websites in IIS 6. Both websites are on port 80, which according to what I have read should be okay since I am setting a distinct host header for each site. I have set up report1 and report2 as hostnames on my DNS server, both pointing at 192.168.0.55. The CF server is Bluedragon (free) which has a one IP address limitation, hence my desire to use one IP address. If I restart the Bluedragon service, I can browse to report2, but then when I browse to report1, I get the report2 site. I haven't needed to do much network administration in the past, so this is new to me. What am I missing? Is there a better way to accomplish this (separate ports maybe)? I haven't worked with the free version of BlueDragon, but it sounds to me like it's not storing the full path to .cfm files, just like CFMX 6.0 didn't do by default. So, when you go to site1/index.cfm, it's just remembering the index.cfm part, and when you go to site2/index.cfm it's just serving up the other file. I don't know if that can be changed, as in CFMX 6.0 and subsequent versions, or if it's a limitation of the free version. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ This is exactly what's happening. BlueDragon Server JX has a Cache Per site option that can be enabled or disabled via the BD Administrator. I'm not sure if BD Free has this option or not, but it's worth looking into. Also, if using BD Free doesn't work out for you, I'd highly recommend checking out Open BlueDragon: http://www.openbluedragon.org/ As it doesn't have the same limitations that BD Free has. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Rick, So... The file is a selection of columns and filter criteria - right? It always varies per user Your right - it's a sticky problem :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:33 AM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK SQL Server 2005. I'm open to suggestion. This is part of an application that allows users to generate CSV files of their own based on their own criteria, so though I'm open to non-CF solutions, I'm not sure there really would be anyway except maybe a homegrown java class to handle the work and be more strict with memory consumption Rick On Mon, Jun 2, 2008 at 10:13 AM, Mark Kruger [EMAIL PROTECTED] wrote: Rick, What's your DB platform? Are you sure there is not a better non-cf way to do it? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 9:04 AM To: CF-Talk Subject: CSV Generation MEMORY SUCK So I've got a problem with generating large csv files.. it's a memory suck. I do this in an event gateway so that these file drops are generated in the background... here's the gateway code: http://cfm.pastebin.org/40043 The larger the file drop, the worse the memory suck is. A relatively small drop of about 7200 rows and 138 columns (just over 1 million pieces of data) took 68 seconds. In my production environment, I've estimated that I can generate between 15,000 and 20,000 pieces of data per second using the code above. The problem is this drop (which only generates a 5MB file) causes a memory suck of about 100MB... Take a look at this output from the server monitor: www.it.dev.duke.edu/public/temp.rtf It shows the memory graph generated from two file drops, at 9:38 and 9:45 am... the first one spiked the memory from 70MB to 170MB...the second one dropped the memory back to about 90MB and then spiked it to 140MB. Of course, this size drop is not what causes my concern, it's when people are dropping 10x that amount.. say 80,000 rows at 130 columns. Over 10 million pieces of data, would take nearly 9 minutes ASSUMING you had no memory issues, which I would. Such a drop would basically crash the instance. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Don't forget to turn off debugging (or remove the 127.0.0.1 ip) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 10:19 AM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK On Mon, Jun 2, 2008 at 10:50 AM, Gaulin, Mark [EMAIL PROTECTED] wrote: Also, test you page with the user's query but with the output part (actually writing the file) commented out... If the page is still slow and a huge memory hog then the file stuff above won't help much and you'll have to look at running the query in java too, but I but you'll get something by handling the file better. I honestly don't think it's the file writing that's the problem. I just commented out the fileWrite() statements inside the cfloop tags that would write each line to the file, (the file still being opened with the header row being written to it... and it made zero difference at all in the length of time it took to complete. The query itself runs quite fast. Returns a lot of rows but isn't a complex query. Anyway, I put some cfoutput statements in my gateway (I'm calling it as a direct cfc call not a gateway for testing).. output now().gettime() to see the ms as the method call progresses. The query returns its results in less than 4 seconds. The process of generating the csv (around line 330-340 of the sample code I posted earlier) took 62 of the 68 seconds. And that was without actually WRITING the file. the GOOD news is that a TAB delimited file takes considerably less time (32 seconds vs. 68 seconds), cutting the output time from 62 seconds to 26 seconds. Which means the csvFormat() function is taking up a very large part of the processing time. This is my csvFormat() function: cffunction name=csvFormat output=false access=public returnType=string cfargument name=str type=string required=yes cfif arguments.str neq and not isNumeric(arguments.str) cfreturn #Chr(34)##replace(arguments.str,chr(34),#chr(34)##chr(34)#,ALL)##Chr(34 )# cfelse cfreturn arguments.str /cfif /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Guide for reviewing a website
Lets not forget: Branding Logo Compatibility (IE,NS,FF,O...)(win,Mac,Lynux...) Load Time (10 sec) SEO There is a LOT that goes into a good website. On Mon, Jun 2, 2008 at 11:59 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS SQL / Mac OS X
Ben, Thanks for the reply. I ended up throwing vista into a VM and installing SMSS. Turns out my XP disc is the cause of my parallels woes, not parallels. Steve Good http://lanctr.com On Jun 2, 2008, at 12:59 PM, Ben Densmore wrote: Hi Steve, I've been using Aqua Data Studio. It works quite well for doing most things in SQL Server. I'm not sure if it can be completely used to manage but for doing queries, writing stored procs and things like that it's fine. The one time I ran into an issue was trying to log into an account that needed to change it's password. Aqua Data Studio didn't seem to know how to do that. Thanks, Ben On Sat, May 31, 2008 at 3:11 AM, Steve Good [EMAIL PROTECTED] wrote: I just got a MacBook Pro and everything is great, but I was wondering what the best way would be to manage a MS SQL server would be. Obviously I can't install MSSQL Studio natively. I have Parallels, but having a hell of a time getting Windows XP running in a VM. My original plan was to just run SQL Studio in the VM, but its not going as well as I had expected. What do you all use to manage a SQL server from OS X, if you do at all? Thanks! Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How do you create a scalable solution?
I read some other articles about making sure that you cache queries at all costs, make sure not to use Select *, being cautious of links etc, making sure code is organized and modular as possible. Some of that stuff has to do with scalability, and other bits have to do with maintainability. Basically, the golden rule of maximizing scalability is to do as little work at runtime as possible. This can be accomplished through caching (doing work before runtime) and asynchronous processing (doing work after runtime). So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. I am sure there is more to it. Yes, there is more to it, of course. A big part of the problem is simply figuring out what your scalability requirements are, in advance, and building to them. Given an infinite amount of resources, even poorly written code may scale (although even then it may not). But no one has an infinite amount of resources, so you have to determine what resources you need, and how to allocate them, etc. So, this process may involve identifying bottlenecks and rewriting that code, or identifying bottlenecks and solving them with hardware, etc. The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If one DB server goes down, how would CF Server know to switch to another one. I need to do more research. This kind of stuff tends to be platform-specific. For example, with SQL Server, you can configure a database server cluster so that if a cluster member goes down, the cluster software automatically figures out to send requests to other cluster members. Alternatively, you can have CF trap errors, and connect to another database server in your error handler. I also have read about geocoded servers. Not sure what the proper term is, but from what I understand it is where you have servers around the country or globe and based on the user's ip address the user would download graphics and other site items from those servers making things quicker. Some of our clients have used Akamai for this, and it's worked out fairly well. For the most part, it just helps out for static content, though. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Did you learn based on trial and error? Is there 1 or 2 comprehensive resources that have all this information or did you have to research each piece separately? I don't think there's a single source for all this stuff, as it tends to be very specific to environments, platforms, etc. If I had to pick one general resource, I think it would be http://highscalability.com/. 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, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF with PostgreSQL
I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF with PostgreSQL
I use it at home.. I like it.. it's a little hefty for small things though. On Mon, Jun 2, 2008 at 3:03 PM, Wil Genovese [EMAIL PROTECTED] wrote: I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF with PostgreSQL
I was looking into it, but saw something about not being able to turn off case sensitivity. Since we're currently using MSSQL on which case insensitivity is default, that was the deal killer for us. Also I didn't see any free way of doing high availability. Russ -Original Message- From: Wil Genovese [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 4:03 PM To: CF-Talk Subject: CF with PostgreSQL I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you create a scalable solution?
Here's something to think about when programming for scalability: If you have a query, and you execute that query a thousand times in 1 minute, how many times does the data returned by that query change? More importantly, if it changes, how important is it that the change be displayed to the end user the instance that change occurs? Query caching is your friend. Of course sometimes that's not enough. So then you have to think.. well, if I load this page 1000 times in a minute, how often does it change? Then, you start writing out static files and writing scheduled tasks that update the static files every minute.. or whatever. Programming for scalability is about reducing repetition of CPU and database intensive operations. When you post something to craigslist, it doesn't appear on craigslist for up to 15 minutes.. that's because they're writing out static files for the categories and stuff. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Guide for reviewing a website
This might point out areas where load times could be improved: http://developer.yahoo.com/performance/index.html#rules along with the YSlow plugin for firebug. -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 1:51 PM To: CF-Talk Subject: Re: Guide for reviewing a website Lets not forget: Branding Logo Compatibility (IE,NS,FF,O...)(win,Mac,Lynux...) Load Time (10 sec) SEO There is a LOT that goes into a good website. On Mon, Jun 2, 2008 at 11:59 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
recursive functions and cfqueries
hi i am having a problem with a recursive function resetting the contents of a query, so i must be doing it wrong, can anyone spot what i should be doing please, thanks basically i pass in a folderid and query to see if it has any children, if it does then it adds the child and goes on to recall if the sub folder has children. the problem is that when it reaches the bottom and finds a folder that doesnt have any children then it comes back up a level and the query is blank. so how can i get it to keep the contents of an array local to that recursion of the function i.e. when it comes up a lavel, it remembers the query for that folder the recursive function builds up a tree as follows: cffunction name=addXMLFolderNodes cfargument name=xmlElement type=xml required=yes cfargument name=childXMLCountReference type=numeric required=yes cfargument name=parentID type=numeric required=yes !--- first see if this folder has any children folders --- cfquery name=childFolders datasource=portexunitich username=#session.dbUsername# password=#session.dbPassword# SELECT * from querytree where folderParentID = cfqueryparam value=#parentID# cfsqltype=cf_sql_bigint maxlength=20 null=no; /cfquery !--- loop through adding them to the tree --- cfloop index=ax1 from=1 to=#childFoldersTemp.recordcount# cfset xmlElement.xmlChildren[childXMLCountReference] = XmlElemNew(MyDoc, row) cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[id] = childFoldersTemp.folderID cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[bgColor] = white cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1] = XmlElemNew(MyDoc, cell) cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlText = childFoldersTemp.folderName cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlAttributes[image] = folderOpen.gif cfoutput'#childFoldersTemp.folderID[ax1]#'/cfoutput cfset temp = addXMLFolderNodes(xmlElement.xmlChildren[childXMLCountReference],2,childFoldersTemp.folderID[ax1]) cfset childXMLCountReference++ /cfloop /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: recursive functions and cfqueries
I'll admit, I only briefly scanned your code, but start by varring all your local variables including the query at the top of the function cfset var childFolders = cfset var ax1 = Etc... ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 4:06 PM To: CF-Talk Subject: recursive functions and cfqueries hi i am having a problem with a recursive function resetting the contents of a query, so i must be doing it wrong, can anyone spot what i should be doing please, thanks basically i pass in a folderid and query to see if it has any children, if it does then it adds the child and goes on to recall if the sub folder has children. the problem is that when it reaches the bottom and finds a folder that doesnt have any children then it comes back up a level and the query is blank. so how can i get it to keep the contents of an array local to that recursion of the function i.e. when it comes up a lavel, it remembers the query for that folder the recursive function builds up a tree as follows: cffunction name=addXMLFolderNodes cfargument name=xmlElement type=xml required=yes cfargument name=childXMLCountReference type=numeric required=yes cfargument name=parentID type=numeric required=yes !--- first see if this folder has any children folders --- cfquery name=childFolders datasource=portexunitich username=#session.dbUsername# password=#session.dbPassword# SELECT * from querytree where folderParentID = cfqueryparam value=#parentID# cfsqltype=cf_sql_bigint maxlength=20 null=no; /cfquery !--- loop through adding them to the tree --- cfloop index=ax1 from=1 to=#childFoldersTemp.recordcount# cfset xmlElement.xmlChildren[childXMLCountReference] = XmlElemNew(MyDoc, row) cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[id] = childFoldersTemp.folderID cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[bgColor] = white cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1] = XmlElemNew(MyDoc, cell) cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlText = childFoldersTemp.folderName cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlAttribu tes[image] = folderOpen.gif cfoutput'#childFoldersTemp.folderID[ax1]#'/cfoutput cfset temp = addXMLFolderNodes(xmlElement.xmlChildren[childXMLCountReference],2,child FoldersTemp.folderID[ax1]) cfset childXMLCountReference++ /cfloop /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: recursive functions and cfqueries
This was also my first inclination. We sometimes add a cfset var local = StructNew() to open a function, then anything that needs to be var'd is just 'scoped' as 'local' (cfset local.myVarredVariable = ) On Mon, Jun 2, 2008 at 4:09 PM, Brad Wood [EMAIL PROTECTED] wrote: I'll admit, I only briefly scanned your code, but start by varring all your local variables including the query at the top of the function cfset var childFolders = cfset var ax1 = Etc... ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Order by another query
I have a query that pulls all the top messages in a forum for each area (So I have the thread titles). I want to sort by the last posted, but it isn't working.. This is the code I came up with so far.. cfquery datasource=#datasource# name=AllMessages select * from forum_messages where areaID = #session.areaID# order by sticky DESC, Posted DESC /cfquery cfquery name=Messages dbtype=query select * from AllMessages where MainThread = 1 order by sticky DESC /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF with PostgreSQL
I *adore* PostgreSQL and use it almost exclusively (unless told to use something else). It's got a slight learning curve as far as permissions goes, but once you're comfortable with that, PostgreSQL is small enough for tiny sites and scalable enough for multi-server clustering. It's benchmarks are also extremely impressive. Not to mention, you can't get much better then the BSD license! I highly recommend it to anyone. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Wil Genovese wrote: I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: recursive functions and cfqueries
good tip, thanks morgan This was also my first inclination. We sometimes add a cfset var local = StructNew() to open a function, then anything that needs to be var'd is just 'scoped' as 'local' (cfset local.myVarredVariable = ) On Mon, Jun 2, 2008 at 4:09 PM, Brad Wood [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: recursive functions and cfqueries
spot on, thanks brad, works perfectly, just so i understand, does this make a difference because then it is creating a new variable each iteration, and if you don't set it then just puts it into the existing variable? i don't use many vars in my code, is that bad practise? thanks again for your help I'll admit, I only briefly scanned your code, but start by varring all your local variables including the query at the top of the function cfset var childFolders = cfset var ax1 = Etc... ~Brad hi i am having a problem with a recursive function resetting the contents of a query, so i must be doing it wrong, can anyone spot what i should be doing please, thanks basically i pass in a folderid and query to see if it has any children, if it does then it adds the child and goes on to recall if the sub folder has children. the problem is that when it reaches the bottom and finds a folder that doesnt have any children then it comes back up a level and the query is blank. so how can i get it to keep the contents of an array local to that recursion of the function i.e. when it comes up a lavel, it remembers the query for that folder the recursive function builds up a tree as follows: cffunction name=addXMLFolderNodes cfargument name=xmlElement type=xml required=yes cfargument name=childXMLCountReference type=numeric required=yes cfargument name=parentID type=numeric required=yes !--- first see if this folder has any children folders --- cfquery name=childFolders datasource=portexunitich username=#session.dbUsername# password=#session.dbPassword# SELECT * from querytree where folderParentID = cfqueryparam value=#parentID# cfsqltype=cf_sql_bigint maxlength=20 null=no; /cfquery !--- loop through adding them to the tree --- cfloop index=ax1 from=1 to=#childFoldersTemp.recordcount# cfset xmlElement.xmlChildren[childXMLCountReference] = XmlElemNew(MyDoc, row) cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[id] = childFoldersTemp.folderID cfset xmlElement.xmlChildren[childXMLCountReference].XmlAttributes[bgColor] = white cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1] = XmlElemNew(MyDoc, cell) cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlText = childFoldersTemp.folderName cfset xmlElement.xmlChildren[childXMLCountReference].XmlChildren[1].XmlAttribu tes[image] = folderOpen.gif cfoutput'#childFoldersTemp.folderID[ax1]#'/cfoutput cfset temp = addXMLFolderNodes(xmlElement.xmlChildren[childXMLCountReference],2,child FoldersTemp.folderID[ax1]) cfset childXMLCountReference++ /cfloop /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: recursive functions and cfqueries
Yes, each time the function recurses into itself you want it to start over with a new set of variables specific to that particular run. Unless otherwise specified, your variables such as the query are placed in the variables scope which is global. That means as soon as your function called itself, it would overwrite the variables from the previous iteration, and when it returned back to the original iteration, the variables were not as they had been left. Think of recursion as a stack, where every time you recurse back into your self, you place the previous function call on hold on top of a stack to come back to later. There are in fact times when a variable should not be varred, like if you wanted to keep some global counter of how many times your function ran or something. In general though most variables (especially result sets and loop indexes) should be local. As a broad rule, all variables should be varred inside of a function or a method of a CFC if you want them to be local to that method only. If for nothing else then to make sure you don't inadvertently overwrite another variable on your page with the same name. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 4:29 PM To: CF-Talk Subject: Re: recursive functions and cfqueries spot on, thanks brad, works perfectly, just so i understand, does this make a difference because then it is creating a new variable each iteration, and if you don't set it then just puts it into the existing variable? i don't use many vars in my code, is that bad practise? thanks again for your help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF with PostgreSQL
Does it support clustering out of the box? From what I remember the only solutions were commercial third party solutions. Russ -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 5:27 PM To: CF-Talk Subject: Re: CF with PostgreSQL I *adore* PostgreSQL and use it almost exclusively (unless told to use something else). It's got a slight learning curve as far as permissions goes, but once you're comfortable with that, PostgreSQL is small enough for tiny sites and scalable enough for multi-server clustering. It's benchmarks are also extremely impressive. Not to mention, you can't get much better then the BSD license! I highly recommend it to anyone. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Wil Genovese wrote: I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: recursive functions and cfqueries
thanks brad thats really understandable, much appreciated! Yes, each time the function recurses into itself you want it to start over with a new set of variables specific to that particular run. Unless otherwise specified, your variables such as the query are placed in the variables scope which is global. That means as soon as your function called itself, it would overwrite the variables from the previous iteration, and when it returned back to the original iteration, the variables were not as they had been left. Think of recursion as a stack, where every time you recurse back into your self, you place the previous function call on hold on top of a stack to come back to later. There are in fact times when a variable should not be varred, like if you wanted to keep some global counter of how many times your function ran or something. In general though most variables (especially result sets and loop indexes) should be local. As a broad rule, all variables should be varred inside of a function or a method of a CFC if you want them to be local to that method only. If for nothing else then to make sure you don't inadvertently overwrite another variable on your page with the same name. ~Brad spot on, thanks brad, works perfectly, just so i understand, does this make a difference because then it is creating a new variable each iteration, and if you don't set it then just puts it into the existing variable? i don't use many vars in my code, is that bad practise? thanks again for your help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF with PostgreSQL
I *adore* PostgreSQL and use it almost exclusively (unless told to use something else). I have never used it before. I love MySQL and have been using MSSQL since forever (love/hate). I was always amazed that MySQL 4.x would be handling my dev work and have a 5-7meg footprint. I understand that PostgreSQL is a lot like Oracle. So do tell, what is it that makes you adore it so? G -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 6.1 installer?
Hey All, I need to find the CF6.1 installer. I don't need a license, or a serial, or media or anything like that, just need to DL and install developer edition. Anybody got any leads as to where I'm going to find that? Willy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion singletons in flex
Hi, I'm playing with a flex application (non-wizard). I'm at the point where I'm connecting to ColdFusion. It all works just fine. However, going beyond the basics, is there a way for flex to access application singletons in ColdFusion? I.e. if I init() a DAO or gateway in application.cfc, can flex access that gateway or DAO (application.myDAO)? Is this what LiveCycle DataServices is for? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF with PostgreSQL
We did a couple of big projects using it, but that was 8+ years ago if memory serves me correctly. At the time we opted for it because the other free solutions just did not compare. Shortly after that I used it for a couple of small projects but never really touched it since. I think a big reason I never went back was because work moved me to MSSQL briefly then Oracle. I would use it again if a project ever called for it but almost all the small projects I work on outside of here end up using MSSQL. On Mon, Jun 2, 2008 at 3:03 PM, Wil Genovese [EMAIL PROTECTED] wrote: I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? PostgreSQL is a powerful ACID compliant db server that is more than capable of handling anything you can through at MS/MY SQL. Just looking for your thoughts and opinions. And if anyone knows of a OO CF project that uses PostgreSQL. BTW: I know it usually does not take much to alter code to work with PGsql. I already converted BlogCFC. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4