Re: GIT Anyone?

2010-03-25 Thread denstar
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

Re: var scope cfhttp within function

2010-03-25 Thread Judah McAuley
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

Re: GIT Anyone?

2010-03-25 Thread John Allen
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

Jrun server crashes when page has CFFORM, CFLAYOUT, CFGRID

2010-03-25 Thread Bittoo Naidoo
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

RE: how to incremently fetch data

2010-03-25 Thread Bobby Hartsfield
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

inserting data into database from e-mail

2010-03-25 Thread mac jordan
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 |

re: inserting data into database from e-mail

2010-03-25 Thread Jason Fisher
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

RE: inserting data into database from e-mail

2010-03-25 Thread Andrew Scott
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]

RE: var scope cfhttp within function

2010-03-25 Thread Bobby Hartsfield
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

RE: how to incremently fetch data

2010-03-25 Thread Bobby Hartsfield
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 (

RE: how to incremently fetch data

2010-03-25 Thread Che Vilnonis
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:

RE: how to incremently fetch data

2010-03-25 Thread Bobby Hartsfield
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

RE: how to incremently fetch data

2010-03-25 Thread Bobby Hartsfield
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

Re: GIT Anyone?

2010-03-25 Thread Won Lee
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:

CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Rob Barthle
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Rob Barthle
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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

Re: how to incremently fetch data

2010-03-25 Thread sandeep saini
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Casey Dougall
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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,

Re: how to incremently fetch data

2010-03-25 Thread Dave Watts
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

RE: how to incremently fetch data

2010-03-25 Thread Bobby Hartsfield
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

CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Che Vilnonis
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Claude Schnéegans
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 ?

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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

NCDevCon (CFinNC 2.0) Call for Speakers and Registration

2010-03-25 Thread Roger Austin
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Claude Schnéegans
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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,

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Casey Dougall
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

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread James Holmes
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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,

RE: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Che Vilnonis
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.

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Casey Dougall
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

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Raymond Camden
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

Re: GIT Anyone?

2010-03-25 Thread Judah McAuley
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

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Judah McAuley
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,

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Barney Boisvert
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:

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Mike Chabot
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

RE: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Chad Gray
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

Re: GIT Anyone?

2010-03-25 Thread Won Lee
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

Re: GIT Anyone?

2010-03-25 Thread denstar
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

RE: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Rick Faircloth
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

Re: GIT Anyone?

2010-03-25 Thread denstar
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

Re: GIT Anyone?

2010-03-25 Thread Judah McAuley
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

Re: GIT Anyone?

2010-03-25 Thread Won Lee
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

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Judah McAuley
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

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Judah McAuley
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

Re: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Judah McAuley
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

Re: GIT Anyone?

2010-03-25 Thread denstar
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.

RE: CFThread limitations with CF9 Standard vs Enterprise

2010-03-25 Thread Rick Faircloth
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

Application scope in a load balanced environment

2010-03-25 Thread Victor Moore
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

Re: Application scope in a load balanced environment

2010-03-25 Thread Alan Rother
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

RE: Application scope in a load balanced environment

2010-03-25 Thread Brook Davies
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

Re: how to incremently fetch data

2010-03-25 Thread sandeep saini
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:

How does Log size is taken careof in MachII

2010-03-25 Thread sandeep saini
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?

Re: CF 9 Server Manager/CF Builder Feature

2010-03-25 Thread krishna reddy
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.

FlashBuilder and Colfusion builder

2010-03-25 Thread Paul Kukiel
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