Re: GIT Anyone?
On Wed, Mar 24, 2010 at 3:22 PM, Ben Alembick wrote: Hi, I am completely new to this (eclipse and GIT - actually just trying to switch from homesite :-) so project etc are a new phenomenon to me.), in fact i am pretty new to source control in general i looked into using some (SVN) about 6 years ago but never actually got round to doing anything. I have been recommended by a few people that if i am starting from scratch then it would be a good idea to try and get my head around GIT as opposed to using SVN. Plus my research seems to point towards GIT being the Future. Git is swell for open source projects, but it's got a totally different paradigm than SVN. To say Git's the Future might be overstating it a bit. :) There's really a whole philosophy behind version control, and that part is the same for all of them, mostly. Things like tagging, branching, and merging. Of course there's whole philosophies about those, too, so... One nice thing about SVN is that the GUIs are much more polished. Like, merging conflicts is much more enjoyable graphically, IMO. That said, EGit is /rocketing/ along -- I'm running off the nightly builds and stuff's getting better fast. There's years of work ahead to be totally awesome, still. They play nice with each other, which is cool beans. I have a general understanding of SVN in that a central repository is stored on a server somewhere, and everyone takes their code from there, but GIT is made up of lots of separate repositories 9not sure how they all link together) * I'm burly getting started with Git, so take what I say with a grain of salt * It seems like Git repositories are indexes, and there's some stuff that's great (fast history lookup, no network needed for most operations) and some stuff that's, eh (you have to check out the entire project, you carry the history with you). Since you have to check out the whole project, it's encouraged to make lots of little projects, vs. fewer monolithic projects. This probably isn't a bad practice in general. You add remote locations, which are other people's indexes. You can push and pull changes from your local index to remote ones. Due to the cycyliclinear-graph-whatsit nature of git revision storage, you can do all kinds of fancy stuff (edit commits, delete them, combine them, replace them), but you can also screw things up pretty bad. Which isn't too bad because you can unscrew them too, generally. Here's an online book: http://progit.org Mike Henke has been doing a little series on Git: http://www.henke.ws/ And there's some other swell stuff out there, too. The more i think about this the more i don't understand how its is all meant to work. I have EGIT installed and have kinda gotten the hang of committing, adding to version control resource history on a local project stored on my machine. YRMV, but I've had to add the remote locations on the command line and then restart Eclipse for EGit to pick them up in the push dialog. And you'll still need to pull from the command line, for now. However i have my live sites on a remote server hosted (at Alurium) how should i go about getting the sites onto my local machine and using GIT? then syncing? What Sean said. Download them using whatever you use to download, run the git init command in the top-level folder of each project (remember, you don't want one big project, unless everything in that project really belongs together), and add commit away. Upload them like normal (after you commit the change to your local repo), but don't upload the .git folder in the project root. Then set up Git on another computer, or find yourself someone who provides Git hosting, so you can start pushing to a location that's not on your hard-drive. =) :DeN* -- Leisure is the Mother of Philosophy. Thomas Hobbes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: var scope cfhttp within function
Yes, you *definitely* need to var scope implicitly created variables. This one bit me in the ass in production as it turned out not to be thread safe. However, I suggest using the result attribute, not doing var cfhttp= as that just seems dirty to me. When you do that you are relying upon the CF engine to assign its cfhttp variable into the one you created by yourself and while that does work, it isn't really explicit nor is it documented. I could see Adobe making a choice in CF10 to say, oh, cfhttp already exists, well I don't want to accidentally overwrite the programmers declared variable, I'll just make a little magic scope for my own so it doesn't conflict and you end up with weird behavior. Go with cfset var myresult = / cfhttp url=foo.com result=myresult / Cheers, Judah On Wed, Mar 24, 2010 at 6:40 PM, Dorioo dor...@gmail.com wrote: I believe so. Post below scoped the result name. Brian Kotek says in the comments you can also do cfset var cfhttp= / http://www.coldfusionmuse.com/index.cfm/2008/6/16/cfc.application.variables - Gabriel On Wed, Mar 24, 2010 at 8:27 PM, Andrew Grosset rushg...@yahoo.com wrote: using cfhttp within a function (get or head) should I be var scoping cfhttp? I'm fairly certain I should but have not been able to find any examples. cffunction name=youTubedata access=public output=true cfargument name=youtubeKey type=string required=true cfset var cfhttp = structNew() cfset var myreturn = structNew() cfset var thisimage = false cfset var xmlQuery = cfset var intRow = cfset var xmlRow = cfset var intChild = cfset var youtubeimage = cfset var youtubetitle = cfset var youtubeduration = cfhttp method=get url=http://gdata.youtube.com/feeds/api/videos/#arguments.youtubeKey#; cfif cfhttp.status_code eq 200 cfset xmlQuery = XmlParse( cfhttp.filecontent ) !--- etc, etc. --- /cfif /cffunction Andrew. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
Thank you Sean. On Wed, Mar 24, 2010 at 8:31 PM, Sean Corfield seancorfi...@gmail.comwrote: On Wed, Mar 24, 2010 at 2:22 PM, Ben Alembick benalemb...@gmail.com wrote: The more i think about this the more i don't understand how its is all meant to work. I have EGIT installed and have kinda gotten the hang of committing, adding to version control resource history on a local project stored on my machine. There are several CF folks who are much more experienced with git than I but I don't know if they're on cf-talk these days. Anyway, the basic concept of git is that instead of a single, central repo, everyone has a repo and git allows people to clone from one place to another and merge back so that everyone has the complete history locally and at any point, any given repo can be designated the master and patches from other repos merged into it. However i have my live sites on a remote server hosted (at Alurium) how should i go about getting the sites onto my local machine and using GIT? then syncing? You've got a lot of options - fortunately or unfortunately depending on your point of view. You could just maintain local git repos for each site simply by putting an up to date copy of each site on your local machine and then doing git init in each top-level folder. You could also get an account on one of the various service providers that offer git hosting - Assembla is extremely good but there are several others. The docs for the provider will walk you through the steps involved in either creating a remote repo, cloning it locally (empty), adding your code and then committing it back to the provider or importing your local git repo up to the provider. I'd highly recommend paying for a service like that since you then get remote access from any machine - including your live servers if you chose to deploy direct from git - as well as having your source code in a secure location that is backed up regularly. Hope that helps point you in a useful direction... -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Jrun server crashes when page has CFFORM, CFLAYOUT, CFGRID
Hi, I am having a weird problem. I have a CF application that works perfect in my development machine and UAT machine which is of windows 2003 server/CF8. When i uploaded the same application on Solaris box with CF8, and try to access the site it works perfect until i hit the page that has CFFORM, CFLAYOUT, CFGRID.. etc.. The Jrun Server just crashes[jrpp-2 unexpected constant#48...]. There is nothing available in any of the logs. Please help me how to resolve this thing...!! Thanks, Bittoo ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
inserting data into database from e-mail
I want to write an app where the user can e-mail an image, and the information be inserted into a database. title=e-mail subject description=e-mail text image=e-mail attachment date/time=e-mail date and time I have no idea where to start - can anyone help? -- mac jordan www.kestrel.org | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org twitter: @ramtops ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: inserting data into database from e-mail
Look at the CFPOP tag: send those emails to a specific box, have CFPOP read messages from that box, and then all those mail elements are exposed in the query-like return for each message. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: inserting data into database from e-mail
There are many solutions. The first one to look at is setup a mail account for this, then use cfmail to pop the account and get the imagae/attachement and do what you like. That should get you thinking some more. -Original Message- From: mac jordan [mailto:mac.jor...@gmail.com] Sent: Thursday, 25 March 2010 10:54 PM To: cf-talk Subject: inserting data into database from e-mail I want to write an app where the user can e-mail an image, and the information be inserted into a database. title=e-mail subject description=e-mail text image=e-mail attachment date/time=e-mail date and time I have no idea where to start - can anyone help? -- mac jordan www.kestrel.org | www.reactivecooking.com | www.nibblous.com | www.jordan-cats.org twitter: @ramtops ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: var scope cfhttp within function
I usually var two structures. Local and retStruct. Local is where I put all variables. retStruct would only get the things that need to be returned. At the end, I clear local and return retStruct With my memory, it's easier this way than remembering to var every variable I create. And I just like to clear out the things I don't need to return. cfset var local {} / cfset var retStruct {} / cfset local.someConditiaonalVar = whatever / cfif local.someConditionalVar cfhttp ... result=local.cfhttp / cfquery name=local.myQry... select/query cfset retStruct.fileContent = local.cfhttp.fileContent / cfset retStruct.myQry = duplicate(local.myQry) / /cfif cfset structClear(local) / cfreturn retStruct / Just don't forget to duplicate complex types when moving them to retStruct or clearing local will clear both. -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, March 25, 2010 12:43 AM To: cf-talk Subject: Re: var scope cfhttp within function Yes, you *definitely* need to var scope implicitly created variables. This one bit me in the ass in production as it turned out not to be thread safe. However, I suggest using the result attribute, not doing var cfhttp= as that just seems dirty to me. When you do that you are relying upon the CF engine to assign its cfhttp variable into the one you created by yourself and while that does work, it isn't really explicit nor is it documented. I could see Adobe making a choice in CF10 to say, oh, cfhttp already exists, well I don't want to accidentally overwrite the programmers declared variable, I'll just make a little magic scope for my own so it doesn't conflict and you end up with weird behavior. Go with cfset var myresult = / cfhttp url=foo.com result=myresult / Cheers, Judah On Wed, Mar 24, 2010 at 6:40 PM, Dorioo dor...@gmail.com wrote: I believe so. Post below scoped the result name. Brian Kotek says in the comments you can also do cfset var cfhttp= / http://www.coldfusionmuse.com/index.cfm/2008/6/16/cfc.application.variables - Gabriel On Wed, Mar 24, 2010 at 8:27 PM, Andrew Grosset rushg...@yahoo.com wrote: using cfhttp within a function (get or head) should I be var scoping cfhttp? I'm fairly certain I should but have not been able to find any examples. cffunction name=youTubedata access=public output=true cfargument name=youtubeKey type=string required=true cfset var cfhttp = structNew() cfset var myreturn = structNew() cfset var thisimage = false cfset var xmlQuery = cfset var intRow = cfset var xmlRow = cfset var intChild = cfset var youtubeimage = cfset var youtubetitle = cfset var youtubeduration = cfhttp method=get url=http://gdata.youtube.com/feeds/api/videos/#arguments.youtubeKey#; cfif cfhttp.status_code eq 200 ? ? ? ?cfset xmlQuery = XmlParse( cfhttp.filecontent ) ? ? ?!--- etc, etc. --- /cfif /cffunction Andrew. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Here is a SQL Server method ive used for paged results. Just tell it how many results per page and what page you are on. The example assumes 25 results and page 3 of those results DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 3; SET @PageSize = 25; WITH articlesRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY articleDate desc) AS RowNum , * FROMtblArticles ) SELECT * FROM articlesRN WHERE RowNum BETWEEN(@PageNum - 1) * @PageSize + 1 AND@PageNum * @PageSize ORDER BY articleDate desc; -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 7:45 AM To: cf-talk Subject: RE: how to incremently fetch data Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Bobby, this code is for SQL 2005 and newer right? I'm on SQL 2000 (yeah, I know...lame) and I've never been able to find a solution that works. ~Che -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 8:59 AM To: cf-talk Subject: RE: how to incremently fetch data Here is a SQL Server method ive used for paged results. Just tell it how many results per page and what page you are on. The example assumes 25 results and page 3 of those results DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 3; SET @PageSize = 25; WITH articlesRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY articleDate desc) AS RowNum , * FROMtblArticles ) SELECT * FROM articlesRN WHERE RowNum BETWEEN(@PageNum - 1) * @PageSize + 1 AND@PageNum * @PageSize ORDER BY articleDate desc; -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 7:45 AM To: cf-talk Subject: RE: how to incremently fetch data Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Yes, 2005 and up. I've not tested it on 2000 but I believe row_number() came about in 2005. -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, March 25, 2010 9:06 AM To: cf-talk Subject: RE: how to incremently fetch data Bobby, this code is for SQL 2005 and newer right? I'm on SQL 2000 (yeah, I know...lame) and I've never been able to find a solution that works. ~Che -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 8:59 AM To: cf-talk Subject: RE: how to incremently fetch data Here is a SQL Server method ive used for paged results. Just tell it how many results per page and what page you are on. The example assumes 25 results and page 3 of those results DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 3; SET @PageSize = 25; WITH articlesRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY articleDate desc) AS RowNum , * FROMtblArticles ) SELECT * FROM articlesRN WHERE RowNum BETWEEN(@PageNum - 1) * @PageSize + 1 AND@PageNum * @PageSize ORDER BY articleDate desc; -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 7:45 AM To: cf-talk Subject: RE: how to incremently fetch data Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Ps... you seriously need to upgrade :-) The longer you wait, the more things get deprecated and the worse the move is going to be... but im sure you know that. -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 9:11 AM To: cf-talk Subject: RE: how to incremently fetch data Yes, 2005 and up. I've not tested it on 2000 but I believe row_number() came about in 2005. -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, March 25, 2010 9:06 AM To: cf-talk Subject: RE: how to incremently fetch data Bobby, this code is for SQL 2005 and newer right? I'm on SQL 2000 (yeah, I know...lame) and I've never been able to find a solution that works. ~Che -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 8:59 AM To: cf-talk Subject: RE: how to incremently fetch data Here is a SQL Server method ive used for paged results. Just tell it how many results per page and what page you are on. The example assumes 25 results and page 3 of those results DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 3; SET @PageSize = 25; WITH articlesRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY articleDate desc) AS RowNum , * FROMtblArticles ) SELECT * FROM articlesRN WHERE RowNum BETWEEN(@PageNum - 1) * @PageSize + 1 AND@PageNum * @PageSize ORDER BY articleDate desc; -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 7:45 AM To: cf-talk Subject: RE: how to incremently fetch data Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
I'm curious if you considered using Hg and if you did why you picked it over GIT. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFBuilder RDS Query Viewer max rows
Is there a setting somewhere in CFBuilder where I can increase the max rows returned in the RDS Query View? 50 is not enough for me at times. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Sorry I did not see the CFBuilder forum in the list before posting. I reposted this question there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. On Thu, Mar 25, 2010 at 9:12 AM, Rob Barthle r...@barthle.com wrote: Is there a setting somewhere in CFBuilder where I can increase the max rows returned in the RDS Query View? 50 is not enough for me at times. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how to incremently fetch data
Thanks guys. But I think we are slightly deviating from my original intent :-) I need some functionality as it happens in hibernate. You do a query in hibernate, it will fetch 100 records. Now when you again do query (which should now return 150 records), hibernate will fetch just remaining 50 records from DB and rest from some sort of cache it maintains. Thus it gives performance boost. We can use Transfer ORM in CF for same kind of functionality but as soon as we write TQLs, it no more behaves like hibernate and will fetch 150 records(instead of 50) from the DB for this second query. So I need some way to achieve the hibernate sort of functionality. I think I did not confuse you a lot. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 10:38 AM, Raymond Camden rcam...@gmail.com wrote: No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. What SQL Editor view? RDS Query Viewer is only thing I can find and it's limited to 50 records ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Inside a cfquery, right click and do SQL Editor. Here is a video on the topic: http://www.coldfusionjedi.com/index.cfm/2010/2/19/Video-Using-ColdFusion-Builders-SQL-Editor On Thu, Mar 25, 2010 at 9:50 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 10:38 AM, Raymond Camden rcam...@gmail.com wrote: No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. What SQL Editor view? RDS Query Viewer is only thing I can find and it's limited to 50 records ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how to incremently fetch data
I need some functionality as it happens in hibernate. You do a query in hibernate, it will fetch 100 records. Now when you again do query (which should now return 150 records), hibernate will fetch just remaining 50 records from DB and rest from some sort of cache it maintains. Thus it gives performance boost. We can use Transfer ORM in CF for same kind of functionality but as soon as we write TQLs, it no more behaves like hibernate and will fetch 150 records(instead of 50) from the DB for this second query. So I need some way to achieve the hibernate sort of functionality. I think I did not confuse you a lot. You could upgrade to CF 9, which includes Hibernate. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
I don't recall you ever mentioning that as your original intent :-) -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 10:37 AM To: cf-talk Subject: Re: how to incremently fetch data Thanks guys. But I think we are slightly deviating from my original intent :-) I need some functionality as it happens in hibernate. You do a query in hibernate, it will fetch 100 records. Now when you again do query (which should now return 150 records), hibernate will fetch just remaining 50 records from DB and rest from some sort of cache it maintains. Thus it gives performance boost. We can use Transfer ORM in CF for same kind of functionality but as soon as we write TQLs, it no more behaves like hibernate and will fetch 150 records(instead of 50) from the DB for this second query. So I need some way to achieve the hibernate sort of functionality. I think I did not confuse you a lot. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFThread limitations with CF9 Standard vs Enterprise
Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Inside a cfquery, right click and do SQL Editor. Thanks for the tip. The video show how to build a select with an ORDER BY clause. Is there any provision for more complex clauses and queries like WHERE, GROUP BY, UNION, or JOINs ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
It is a SQL Editor. You can write _anything_. On Thu, Mar 25, 2010 at 10:11 AM, wrote: Inside a cfquery, right click and do SQL Editor. Thanks for the tip. The video show how to build a select with an ORDER BY clause. Is there any provision for more complex clauses and queries like WHERE, GROUP BY, UNION, or JOINs ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
NCDevCon (CFinNC 2.0) Call for Speakers and Registration
The Triangle Area ColdFusion Users Group (TACFUG) is holding another conference like the highly successful CFinNC in 2009. NCDevCon will be held May 22-23, 2010 at the NC State University Centennial Campus College of Textiles complex in Raleigh, North Carolina. The call for speakers and registration are now open. http://ncdevcon.com/ This is a free conference. That's right, it's free to attendees. How can we do this? We can due to very generous sponsors. You or your company could also be a sponsor and we would be very pleased if you would. Please see the sponsorship information on the web site. The change in name reflects new tracks including web design, Javascript/CSS/AJAX as well as the ColdFusion, AIR, Flex tracks. There will also be hands-on training during the event. See the web site at http://ncdevcon.com/ for information and links. -- http://www.linkedin.com/pub/roger-austin/8/a4/60 http://twitter.com/RogerTheGeek http://www.misshunt.com/ Home of the Clean/Dirty Magnet http://www.ncdevcon.com/ TACFUG 2010 Conference in North Carolina ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
You can write _anything_. Ok, so, if I understand well the editor will just help you to select tables and column names, the rest of the syntax, commands, parenthesis and clauses is up to you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. On Thu, Mar 25, 2010 at 10:52 AM, wrote: You can write _anything_. Ok, so, if I understand well the editor will just help you to select tables and column names, the rest of the syntax, commands, parenthesis and clauses is up to you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 12:10 PM, Raymond Camden rcam...@gmail.com wrote: Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. ok skip sql editor... where is autoComplete / tag insite inside cfquery cfquery name=UpdateLog datasource=#request.dsn# Update Log SET ThisSomthing = cfq does not provide insite for cfqueryparam /cfquery I have to actually do this below the query tag to get insite to work. am I missing something? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. On Thu, Mar 25, 2010 at 11:18 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:10 PM, Raymond Camden rcam...@gmail.com wrote: Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. ok skip sql editor... where is autoComplete / tag insite inside cfquery cfquery name=UpdateLog datasource=#request.dsn# Update Log SET ThisSomthing = cfq does not provide insite for cfqueryparam /cfquery I have to actually do this below the query tag to get insite to work. am I m ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFThread limitations with CF9 Standard vs Enterprise
Thanks James... -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Thursday, March 25, 2010 12:24 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
I've found that if I click tab, by accident, the CI won't work. I've also found that you can force the CI if you don't see it popup. On my Mac I believe it is command+. (sorry, my muscle memory doesn't always translate to real memory). On Thu, Mar 25, 2010 at 11:43 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! -- === Raymond Camden, ColdFusion Jedi Master Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
I love Git and have been using it on a couple of projects and pushing/pulling from Github repositories. That being said, I haven't had to do much more than the basics with it. Create a repository, add files, commit. Push/Pull from remote repositories. Works like a charm. I do everything command line though and that isn't everyone's cup o' tea. We are currently using CVS at work, which is not a very happy thing, and as we consider changing there is some momentum to move to Mercurial. You might want to check it out. It was developed in competition with Git as part of an effort to organize the Linux kernel development. Git won that particular competition but Mercurial looks quite good and has a lot more graphical tools available. It is written in Python, I believe, and so runs everywhere and is a bit easier to write GUI plugins for. SVN is good and you'll find support for it most everywhere. The big difference I've found between SVN/CVS and Git/Mercurial is that SVN/CVS has a central repository that all the developers are connecting to. When you save locally, you are keeping a dirty copy of the file and it stays unversioned until you send it up to the central repository. If someone else has changed it in the meantime, there is a conflict and those need to be merged. With Git/Mercurial, every developer has their own local repository. You could set it up to commit as often as you want to you local repo, every file save if you wanted. That gives you more freedom to commit changes that aren't necessarily in a working state. You wouldn't want to do that in SVN or CVS if your central repository is hooked up to a Continuous Integration environment as it would break the build. Then, once you have a set of changes in your local repository you are happy with, you can push those changes to the central, shared, repository. Git, at least, just pushes deltas, the changes, not the entire files like in CVS and SVN, so there is some performance gains there. And it also pushes the local repo history. So if another developer then grabs the current version from the central repo and it is different than their local version, there is some history that comes down with it that helps make merging a bit easier and more intelligent. At least that is the theory as I understand it :) The basic workflow I use for Git with Github is this: git clone git:myproject...@github git pull make a change to index.cfm git add index.cfm //this adds the file to the list of changed files Git knows about git commit -m 'the notes about my change to index.cfm' make a change to model.cfc git add model.cfc git commit -m 'the notes about my change to model.cfc' git push That last statement syncs my local commits back to the central repository at Github. Note I said commits. If I have files that are saved locally but not added to the changes and committed, it won't push those. Hope that helps. Cheers, Judah ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
I'm pretty sure in CF8 the limitation is 1 on standard, not 10. The default max concurrent threads setting in the CF Administrator is 10, but that's irrelevant on standard, since it's hard-capped at 1. cheers, barneyb On Thu, Mar 25, 2010 at 10:43 AM, Judah McAuley ju...@wiredotter.com wrote: Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
The cfthread limit was two in CF8 standard. http://www.adobe.com/products/coldfusion/pdfs/cf8_featurecomp.pdf -Mike Chabot On Thu, Mar 25, 2010 at 1:43 PM, Judah McAuley ju...@wiredotter.com wrote: Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFBuilder RDS Query Viewer max rows
I have found if I have an error on the page where a line is checked by the little red X CI does not work. Like leave a hanging # inside CFOutput and try CI after that error line. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, March 25, 2010 12:53 PM To: cf-talk Subject: Re: CFBuilder RDS Query Viewer max rows I've found that if I click tab, by accident, the CI won't work. I've also found that you can force the CI if you don't see it popup. On my Mac I believe it is command+. (sorry, my muscle memory doesn't always translate to real memory). On Thu, Mar 25, 2010 at 11:43 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! -- === Raymond Camden, ColdFusion Jedi Master Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
TLDR: I wouldn't worry too much about graphical tools for either Git or Hg unless you have a funky deployment plan. Both have plugins for CFBuilder. I can tell you that Hg works. I would like to add that I picked Hg over Git because I was able to get Hg working like I wanted within 20 minutes of download. Official Git, last time I checked, has horrible Windows support. I think there is a forked version that supports Windows but I don't think I'm exaggerating when I write that you are really taking a unnecessary, however small, risk if you work in a Windows environment. In reality, I don't think either Git or Hg is a bad choice. Heck, you can even pull from linux kernel repository using Hg. http://www.kernel.org/hg/linux-2.6/ Short: I recommend Hg due to a) easier install, b) easier to use, c) and better Windows support. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
On Thu, Mar 25, 2010 at 11:39 AM, Judah McAuley wrote: ... SVN is good and you'll find support for it most everywhere. The big difference I've found between SVN/CVS and Git/Mercurial is that SVN/CVS has a central repository that all the developers are connecting to. When you save locally, you are keeping a dirty copy of the file and it stays unversioned until you send it up to the central repository. If someone else has changed it in the meantime, there is a conflict and those need to be merged. You still get conflicts with Git, too. It's part of the whole version control deal. Git/SVN do auto-merging, when they can, but we don't have AIs yet, so there's times a human needs to get involved. With Git/Mercurial, every developer has their own local repository. You could set it up to commit as often as you want to you local repo, every file save if you wanted. That gives you more freedom to commit changes that aren't necessarily in a working state. You wouldn't want to do that in SVN or CVS if your central repository is hooked up to a Continuous Integration environment as it would break the build. Then, once you have a set of changes in your local repository you are happy with, you can push those changes to the central, shared, repository. It appears that you also push your local history, so you could have a git repo get pretty big, pretty fast, if you're not doing things like squashing and editing your commits before a push. Git, at least, just pushes deltas, the changes, not the entire files like in CVS and SVN, so there is some performance gains there. And it CVS does the whole file, but SVN does deltas as well. Especially useful when working with binary files. As far as Git on windows, it's wy better now, from my understanding, tho sorta lacking in some proxying support and whatnot. Mercurial seems cool. I think it uses the cyclicWhatzit approach too. I installed the Eclipse plugin and played with it a little while getting up to speed with Git (which I'm still not up to speed on :]). Just another reason to not limit yourself too much, and to try to focus on the overreaching ideas that are concerns for all source control systems. If you're getting into Git specifically, you *need* to be getting into the whole editing of commits deal, IMHO. For sure if you're working with a team -- hands down, no questions asked, you need to -- I found that out fast. :) :Den -- The obligation of subjects to the sovereign is understood to last as long, and no longer, than the power lasteth by which he is able to protect them. Thomas Hobbes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFThread limitations with CF9 Standard vs Enterprise
I think I'm running at least 7 simultaneous threads at times on CF9 dev using scheduled tasks. The code inside a thread only processes once a previously-running thread completes, but the thread names still show up in the CF Monitor... ??? -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, March 25, 2010 1:44 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
On Thu, Mar 25, 2010 at 12:18 PM, denstar wrote: ... It appears that you also push your local history, so you could have a git repo get pretty big, pretty fast, if you're not doing things like squashing and editing your commits before a push. To elaborate a little more, the philosophy for Git is the same as SVN (and most of them, it appears): Stage each change and check that the change are what you think they were. That's the Git way. - A helpful person from the EGit dev list I too was looking for something that let me commit with impunity, and basically you can do that with Git, but you need to then edit your impunities. :) Might as well just use two repos, and have one that you don't give a crap about a nice history for, and one that you share. Eh. I'm still super green with Git, so wouldn't be surprised if I'm missing some key bit of info (hell, I'm never surprised to be missing some key bit of info ;]). Salt grains. :den -- The Papacy is not other than the Ghost of the deceased Roman Empire, sitting crowned upon the grave thereof. Thomas Hobbes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
Well I think you should commit with relative impunity to your local repository with git. Having something in version control is Good(tm). The place where you need to pay more attention is pushing/pulling from shared repositories. And yes, you still have conflicts on merging and there are times where they can't be worked out automatically. Of course if you and another dev are working on the same code and making incompatible changes, you need to do more talking and not expect source control to save your ass :) Also true that git sends your commit history along with the file deltas, which is how it can do more intelligent merge changing. The changing bits can look back at the changes made from the 2 conflicting commits and find where they were originally the same, replay the changes that each made and try to figure out what each dude/dudette did. I'm happy to put up with a bit bigger repository for the abilities that gives you and then, yeah, you'll want to flatten your old commits periodically when code gets stable. I personally haven't gotten to that level yet but the projects I'm working on with git aren't that complicated and only have 2 devs at the moment. Cheers, Judah On Thu, Mar 25, 2010 at 11:34 AM, denstar valliants...@gmail.com wrote: On Thu, Mar 25, 2010 at 12:18 PM, denstar wrote: ... It appears that you also push your local history, so you could have a git repo get pretty big, pretty fast, if you're not doing things like squashing and editing your commits before a push. To elaborate a little more, the philosophy for Git is the same as SVN (and most of them, it appears): Stage each change and check that the change are what you think they were. That's the Git way. - A helpful person from the EGit dev list I too was looking for something that let me commit with impunity, and basically you can do that with Git, but you need to then edit your impunities. :) Might as well just use two repos, and have one that you don't give a crap about a nice history for, and one that you share. Eh. I'm still super green with Git, so wouldn't be surprised if I'm missing some key bit of info (hell, I'm never surprised to be missing some key bit of info ;]). Salt grains. :den -- The Papacy is not other than the Ghost of the deceased Roman Empire, sitting crowned upon the grave thereof. Thomas Hobbes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
Those wanting more Hg: http://hgbook.red-bean.com/read/ Those wanting more Git: http://progit.org/book/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
You know, I went back and looked for the CF8 comparison like you did and it does, indeed, say the limit is 2 manually spawned threads. Then I went and logged into my CF8 Standard server and under Request Tuning it says the following: Maximum number of threads available for CFTHREAD The maximum number of threads created by CFTHREAD that will be run concurrently. Threads created by CFTHREAD in excess of this are queued. On Standard Edition, the maximum limit is 10. So which is correct? On Thu, Mar 25, 2010 at 10:51 AM, Mike Chabot mcha...@gmail.com wrote: The cfthread limit was two in CF8 standard. http://www.adobe.com/products/coldfusion/pdfs/cf8_featurecomp.pdf -Mike Chabot On Thu, Mar 25, 2010 at 1:43 PM, Judah McAuley ju...@wiredotter.com wrote: Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
The limitation is when you are using cfthread in your code. Tasks run in the scheduler don't count toward the limit, nor does cfhttp. Cheers, Judah On Thu, Mar 25, 2010 at 11:25 AM, Rick Faircloth r...@whitestonemedia.com wrote: I think I'm running at least 7 simultaneous threads at times on CF9 dev using scheduled tasks. The code inside a thread only processes once a previously-running thread completes, but the thread names still show up in the CF Monitor... ??? -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, March 25, 2010 1:44 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFThread limitations with CF9 Standard vs Enterprise
I think that Max Concurrent Threads was back in CF7. In CF8, they split things up so that there are settings for simultaneous Template requests, Flash Remoting requests, Web Service requests, CFC function requests which takes care of inbound requests and then CFReport and CFThread threads which governs code-generated threading. Judah On Thu, Mar 25, 2010 at 10:49 AM, Barney Boisvert bboisv...@gmail.com wrote: I'm pretty sure in CF8 the limitation is 1 on standard, not 10. The default max concurrent threads setting in the CF Administrator is 10, but that's irrelevant on standard, since it's hard-capped at 1. cheers, barneyb On Thu, Mar 25, 2010 at 10:43 AM, Judah McAuley ju...@wiredotter.com wrote: Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
On Thu, Mar 25, 2010 at 12:48 PM, Judah McAuley wrote: Well I think you should commit with relative impunity to your local repository with git. Having something in version control is Good(tm). The place where you need to pay more attention is pushing/pulling from shared repositories. 'Zactly. The whole point of the social aspect of Git is the pushing and pulling. Sending the whole history defeats that purpose. Course, you don't *have* to push the whole history. Apparently Git thought about this, so there's all kinds of ways to pick what you push and pull, and to put your local repository in various states (like the stash command). Also true that git sends your commit history along with the file deltas, which is how it can do more intelligent merge changing. The changing bits can look back at the changes made from the 2 conflicting commits and find where they were originally the same, replay the changes that each made and try to figure out what each dude/dudette That's not really how it does the merging. :) I can flatten a 1000 commits into just one, and it'll still know how to merge it, or not. You can have histories that break the merging, too. There's commands like rebase which you need to look out for. You can pretty easily set up a history that breaks things (compared to SVN), due to how revisioning works with Git, and it's distributed nature. I'm still real fuzzy about histories and git merging and whatnot tho, so... most of my experience is with the projects I've set up, and trying to get a patch into EGit (those guys are professionals, and it's been interesting to see how actual eclipse plugins are managed). did. I'm happy to put up with a bit bigger repository for the abilities that gives you and then, yeah, you'll want to flatten your old commits periodically when code gets stable. I personally haven't Hey, I hadn't thought about that. So long as you've got back-ups of your repo, who cares, just edit it down! That is one thing that is pretty weird about Git tho... with SVN, you *know* you're seeing the whole history. Git can change it under your feet. It's flexible, but with flexibility, comes the need for self-imposed frameworks... it's rather similar to CFML in that regard... :) :DeN -- The secret thoughts of a man run over all things, holy, profane, clean, obscene, grave, and light, without shame or blame. Thomas Hobbe ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFThread limitations with CF9 Standard vs Enterprise
Thanks for clarifying! Rick -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, March 25, 2010 3:31 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise The limitation is when you are using cfthread in your code. Tasks run in the scheduler don't count toward the limit, nor does cfhttp. Cheers, Judah On Thu, Mar 25, 2010 at 11:25 AM, Rick Faircloth r...@whitestonemedia.com wrote: I think I'm running at least 7 simultaneous threads at times on CF9 dev using scheduled tasks. The code inside a thread only processes once a previously-running thread completes, but the thread names still show up in the CF Monitor... ??? -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, March 25, 2010 1:44 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise Wow, that is a big change. The limit is 10 in CF8 standard. I'm sure glad I haven't upgraded my production app to CF9 and going the Railo route instead for thread happiness. I just wanted to get past the 10 thread limitation, never expected it to drop down to 2. Cheers, Judah On Thu, Mar 25, 2010 at 9:23 AM, James Holmes james.hol...@gmail.com wrote: CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Application scope in a load balanced environment
Hi. I am considering moving an app to be load balanced. This will be on CF 9 standard. Is there any good information how to keep the application scoped variables in sync when data changes? Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Application scope in a load balanced environment
I suppose it depends on what you plan on keeping in the application scope. I typically only use the application scope for static info that I need on a general usage basis. Such as DSNs, file paths etc. These things can be statically loaded at startup and don't change very often. What were you thinking of putting into the Application scope that would only be generated on one server? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Application scope in a load balanced environment
What I do is store a list of alternate servers on each of the servers in the cluster. So each server has an array of the other servers IPS. When I need to propagate application scoped data to the other servers, I call a cfc method that loops over the array of alternate servers and calls a webservice method for each server that will update the application data on that server with the data sent. This is all done in a CFTHREAD Maybe theres a better way? Brook -Original Message- From: Victor Moore [mailto:victor.mo...@gmail.com] Sent: March-25-10 1:19 PM To: cf-talk Subject: Application scope in a load balanced environment Hi. I am considering moving an app to be load balanced. This will be on CF 9 standard. Is there any good information how to keep the application scoped variables in sync when data changes? Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how to incremently fetch data
Hey Bobby. Thanks for this incremental part also which you mentioned. appreciated. -sandy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How does Log size is taken careof in MachII
Guys, If we use CF Logger in MachII to create log files(if its not default application.log file), how does the size of log file is taken care of? What happens once it overflows? Is it automatically archieved (as other common coldfusion log files) as per settings in coldfusion administrator? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Server Manager/CF Builder Feature
Did you enter the required under the start/stop fields? Only when you enter the required fields under Start/Stop Details tab, start/stop menu items would be enabled as per the state of the server. Admin server should be restarted after making changes to the jrun-users.xml file. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FlashBuilder and Colfusion builder
If I have FlexBuilder 3 Pro and I want FlashBuilder 4 Premium for $299 do I get the upgrade to FB4 Premium and also a ColdFusion Builder license? http://www.adobe.com/products/flex/upgrade/ Paul. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm