Re: SOT: How do you version control with your CF code?

2007-10-06 Thread Brian Kotek
Subversion with trunk and branches (for development). ANT for deployment. It's wonderful to click a batch file and have everything deploy (including maintenance message, reinit of the app, etc.). On 10/5/07, J W [EMAIL PROTECTED] wrote: I am looking to have better version control at our company

New Article posted on Coldfusion and .Net integration

2007-10-06 Thread vishnu prasad
Hi all I have posted a new article on Coldfusion and net to get OS , Computer information , HArdisk , IP address , Mac address details ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features -

Re: Elapsed time/DB question...

2007-10-06 Thread Jochem van Dieten
Will Tomlinson wrote: I have an evaluation form and trying to work out the best way to add an elapsed time to the db for the eval. In the reporting, I guess I just needta show a MIN(), MAX(), and AVG() on that field. But what's the best way to grab the time and insert something my DB

Re: New Article posted on Coldfusion and .Net integration

2007-10-06 Thread vishnu prasad
oops forget to post the url its wrvishnu.wordpress.com Hi all I have posted a new article on Coldfusion and net to get OS , Computer information , HArdisk , IP address , Mac address details ~| ColdFusion is delivering

Re: SOT: How do you version control with your CF code?

2007-10-06 Thread Jochem van Dieten
J W wrote: I am looking to have better version control at our company and am wonder how YOU deal with this. What is your setup? Local development against a local CF and local resources. Full working copy of a SVN repository. Code gets tagged in the repo and then a build server will use an Ant

Re: Elapsed time/DB question...

2007-10-06 Thread Will Tomlinson
And what datatype should the field be? INTERVAL is especially designed for this. Thanks jochem! Will ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out

RE: CF Coding Standards

2007-10-06 Thread ColdFusion
Claude, Ok I do agree that the Database section should be tailored to the database platform As you mentioned Oracle is one that does maintain case sensitivity. I do agree that MySQL, MS-SQL, and even Access is case-insensitive. I recall a benchmark results from along time ago indicating that if

RE: CF Coding Standards

2007-10-06 Thread ColdFusion
Actually my coding standards are based on standards that a project I worked on with a company in Virginia had in place. Based on those plus my own style is what you see. Now if the original company took them from something you did or posted awhile back, then my apologies. However I did not or

RE: SOT: How do you version control with your CF code?

2007-10-06 Thread John Mason
I second the recommendation for SVN as a centralized versioning system but you shouldn't pay too much attention to all the people claiming it is hard to set up. It may be tedious when you do it for the first time, but not hard, you just have to follow the manual. But if for some reason you do

RE: CF Coding Standards

2007-10-06 Thread ColdFusion
I will make a note at the bottom to indicate about Macromedia, however I did not adopt them from there. Again if the previous company did, then I was unaware but will make the annotation. Along with some of the comments, I will update the standards. My goal is to get a code set that everyone can

CF Code readability (Where Clause)

2007-10-06 Thread ColdFusion
How many use the query coding (where clause) as: where x = 1 and Deleted = 0 OR where x = 1 and Deleted = 0 I prefer the second one as if I need to remove or simply comment the line out for testing, I only do the one line rather than having

Re: CF Code readability (Where Clause)

2007-10-06 Thread Zaphod Beeblebrox
yep, I pretty much do the same thing, also my selects look like this: SELECT col1 ,col2 ,col3 FROM table1 INNER JOIN table2 ON table1.col1 = table2.col2 WHERE x = 1 AND Deleted = 0 In essence, I capitalize my sql keywords, I place the

Re: CF Code readability (Where Clause)

2007-10-06 Thread Dominic Watson
I always go for either: WHERE x = 1 AND y = 2 or: WHERE x = 1 AND y = 2 Usually the first but never either of the options you gave (that's just me). Dom On 06/10/2007, Zaphod Beeblebrox [EMAIL PROTECTED] wrote: yep, I pretty much do the same thing, also my selects look like this: SELECT

Re: CF Coding Standards

2007-10-06 Thread Aaron Rouse
You can create tables/columns with mixed case in modern versions of Oracle. The values stored within those columns is what is case sensitive so SELECT MyValue FROM MyTable WHERE theValue = 'abc' would return something different than SELECT MyValue FROM MyTable WHERE theValue = 'aBc' I

RE: CF Code readability (Where Clause)

2007-10-06 Thread ColdFusion
Thanks for the comments. I will update the wiki with it http://wiki.mindkeeper.net/index.php?title=ColdFusion_Coding_Standards -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 11:28 AM To: CF-Talk Subject: Re: CF Code readability (Where

[NEWS] Mashable.com Gives ColdFusion Some Love

2007-10-06 Thread Rey Bango
Mashable.com, a top site dedicated to social networking news and on par with heavyweight Techcrunch in terms of reporting, has given ColdFusion some love by posting about CF-related resources: COLDFUSION TOOLBOX: 20+ Resources for ColdFusion http://mashable.com/2007/10/06/coldfusion-toolbox/

Eclipse to DW WAS: RE: SOT: How do you version control with your CF code?

2007-10-06 Thread Dawson, Michael
It does take some discipline to develop this way, but it is the best an easiest way. get rid of dreamweaver and move to CFEclipse as I said you will not look back. Not to get too off-topic, but I did look back. In fact, I went back to DW after a few months with Eclipse. I used only CFE on my

RE: SOT: How do you version control with your CF code?

2007-10-06 Thread Rick Faircloth
I'm very interested in the VMWare approach to testing Subverison, Eclipse, CFEclipse, etc. However, after looking over the selections in the Virtual Appliance Marketplace on vmware.com, I don't see anything that fits what I'm looking for. I've never used VMWare before and I'm trying to be

Re: [NEWS] Mashable.com Gives ColdFusion Some Love

2007-10-06 Thread Christopher Jordan
That's really cool, Rey! Thanks for posting that. There are a couple on there that I'd never heard of, and that I'm definitely going to have to visit! :o) Cheers, Chris On 10/6/07, Rey Bango [EMAIL PROTECTED] wrote: Mashable.com, a top site dedicated to social networking news and on par with

RE: CF Code readability (Where Clause)

2007-10-06 Thread Dawson, Michael
I use a SQL format such as this: SELECT t1.id ,t1.firstname ,t1.lastname FROM table t1 LEFT OUTER JOIN table t2 ON t1.id = t2.id AND t2.id IS NOT NULL WHERE t1.x = 1 AND t1.deleted = 0 ORDER BY t1.lastname ,t1.firstname M!ke -Original

Re: SOT: How do you version control with your CF code?

2007-10-06 Thread J W
Ok... Without sounding too naive about versioning and more complex dev systems... Help me understand this a bit better. 1. Local Development with local code to those machines. How do you keep those machines current? Many of the coldfusion programs we code and make improvements to are part of a

OS X Spotlight plugin for CF files?

2007-10-06 Thread Ben Mueller
It would appear that, by default, OS X Spotlight will not index .cfm files, and that in order to get Spotlight to index them, one has to somehow install a plugin. Have people been able to get Spotlight to search CFM files? If so, are there instructions on the web anywhere? I've spent some

Re: SOT: How do you version control with your CF code?

2007-10-06 Thread Larry Lyons
As others have said Subversion works pretty good as a version control, but it can be somewhat hairy to set up. There's a one-click installer for Windows on tigris.org that's really helpful, http://svn1clicksetup. tigris.org/ Not only does it install the Windows binaries for SVN 1.2.3 and

Re: CF Code readability (Where Clause)

2007-10-06 Thread Aaron Rouse
I do this a lot for my search queries, the only difference is I usually have after WHERE 0 = 0, a loop over say all my varchar column names I may be searching on then I do a check to see if the key exists in the structure I am searching on and if it has a value to build a AND COLUMN LIKE '%asd%'

Re: CF Code readability (Where Clause)

2007-10-06 Thread Thomas Flagg
Don't forget--another trick you can use if/when using IF or CASE logic within your CFML pages, you can do the following as a trick: SELECT * FROM TABLE WHERE 1=1 cfif condition 1 AND CONSTRAINT 1 /cfif cfif condition 2 AND CONSTRAINT 2 /cfif cfif condition 3 AND CONSTRAINT 3 /cfif cfif condition

Implementing a Google Custom Search Engine

2007-10-06 Thread Larry Lyons
Hi all, I thought I'd start at HOF first with this question. Has anyone implemented the Google Custom Search Engine Business Edition on a web site? I'm not entirely sure where to start and I'd appreciate any suggestions. thx, larry

How would I make this code work?

2007-10-06 Thread Rick Faircloth
Hi, all. I'm trying to output a weekly schedule which will list the day only one time for the first event of a particular day. When the day changes, the new day of the week is displayed. I did something like this successfully recently with a calendar by running a query for the dates,

RE: CF Code readability (Where Clause)

2007-10-06 Thread William Seiter
I prefer the second line for easy 'adjusting' as well. If I end up adding a conditional, it is easier to have them all on 1 line to begin with. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove

RE: SOT: How do you version control with your CF code?

2007-10-06 Thread Dave Watts
However, after looking over the selections in the Virtual Appliance Marketplace on vmware.com, I don't see anything that fits what I'm looking for. No, you won't. The appliances are quite narrow in their focus, and limited mostly to free, open-source software. I've never used VMWare before

Re: CF Coding Standards

2007-10-06 Thread Sean Corfield
On 10/6/07, Dave Watts [EMAIL PROTECTED] wrote: I will make a note at the bottom to indicate about Macromedia, however I did not adopt them from there. There does appear to be a lot of similarity to Sean's document. Especially since it includes references to Macromedia. If it did not come

RE: How would I make this code work?

2007-10-06 Thread Rick Faircloth
I got it... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 4:05 PM To: CF-Talk Subject: How would I make this code work? Hi, all. I'm trying to output a weekly schedule which will list the day only one time for the first

RE: CF Coding Standards

2007-10-06 Thread Dave Watts
I will make a note at the bottom to indicate about Macromedia, however I did not adopt them from there. Again if the previous company did, then I was unaware but will make the annotation. There does appear to be a lot of similarity to Sean's document. Dave Watts, CTO, Fig Leaf Software

Re: CF Coding Standards

2007-10-06 Thread Sean Corfield
These were exactly the same comments I posted in the discussion section of Randy's wiki :) OMG, I'm in complete agreement with Claude! The world must be ending... LOL! As for the UPPERCASE DB stuff - that came from the Oracle DBA team at Macromedia (so, yeah, it's a legacy Oracle guideline). On

Re: CF Coding Standards

2007-10-06 Thread Sean Corfield
On 10/6/07, ColdFusion [EMAIL PROTECTED] wrote: Along with some of the comments, I will update the standards. My goal is to get a code set that everyone can share and agree that they are in best interest of the coding project. Don't you agree? Why not just use the LiveDocs guidelines and post

RE: CF Code readability (Where Clause)

2007-10-06 Thread ColdFusion
I agree 100% as I have done this as well. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 3:32 PM To: CF-Talk Subject: Re: CF Code readability (Where Clause) I do this a lot for my search queries, the only difference is I usually have

RE: CF Coding Standards

2007-10-06 Thread ColdFusion
I will make mention of the company I derived my standards from within the Wiki. Again I have no problems is indicating such or giving credit. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 7:17 PM To: CF-Talk Subject: Re: CF Coding

Re: CF Coding Standards

2007-10-06 Thread Claude Schneegans
My goal is to get a code set that everyone can share and agree What an utopia! For instance, I cannot argue with the fact that many people want to go XHTML, and use tags in lower case, why not? Personally I don't have any interest for XHTML, I'm quite satisfied with HTML and I prefer having

RE: CF Coding Standards

2007-10-06 Thread ColdFusion
I have mentioned Sean as well as Macromedia. I am really learning that the place I did derive mine from adopted theirs from one of those sources. I emailed Sean directly to indicate I mean no disrect and was not trying to take credit for anyone's work. -Original Message- From: Dave Watts