ColdFusion Purists

What have I been up to?

2008-04-24T13:41:00.002-05:00

During my time of looking for coldfusion work, I have also had my right leg broken.

But since I have had a lot of off time, I have been learning, studying and playing with apache, mysql and php. I am even practing and playing with Drupal, a php content management system.

I still love coldfusion, but php is very nice as well. I just prefer not to do anything object oriented.

This blog used to be very important to me, just not sure if where I want to go, is where coldfusion is going.

I would love to see what new things coldfusion 8 can do.

Hope you all are doing well.

Hal Helms gets it right...

2007-04-13T16:39:00.000-05:00

First off, I love long philosophical discussion such as this.

To me this is a sign of realizing that we don't need to be like other programming languages, to be a a solid application language.

And that's what I like, we're here to innovate, drive the market with what is our strength rapid-application development.

Now that does not mean in anyway we can't learn from other languages to improve our programming ideas and methods, but that should not be in an attempt to make us just a clone or copy, we have to stick to what we're about.

If you really want to code in Java, go ahead and do so, just stop trying to make coldfusion into java programming.

I feel we do have a lot to learn as an industry, to improve our training, to create common standards that we all learn from, then as we get more experience, develop our own way's and style's.

To me, I think this is a first good step to common sense, and focusing on what we're about, not trying to mold coldfusion into java which it's not.

Think about it.

In pursuit of excellence

2007-03-28T10:11:00.001-05:00

The road to this field, can take us from many directions, but in the end it is our own drive to be the best, that gets us there.

For me this road started in 1996, when I worked for a local isp as a tech support person, sadly it was not a very well run isp, but that is what gave me the opportunities for growth I sought.

I worked my way up from Tech Support, to Webmaster, to Hostmaster, and mainly it was because I was bored of just answering calls, trying to solve customer's problems, when my employer didn't care about the customer's just getting them off the phone as soon as possible.

So I started to read about HTML, Javascript, then I heard of coldfusion. I had gotten some training in setting up IIS, but to do actual web programming really intrigued me. I already had made my mark, by taking all our piles of training material, to create a html based step-by-step problem solving intranet.

I am a person who wants change, to desires for things to always improve, and life is not always like that, but sometimes you have to create your own opportunities.

So I started to bug the web design/development department of the isp, asking questions, what's a cfoutput, what's a cfquery...

Playing with access databases, eventually in time working my way up to SQL Server...and over time, my knowledge, skills and experiences kept expanding, but that's not what I want this post to be about.

I think that I had some weird expectations, that I would reach some level of skill/experience, where i could work for a good company that recognized my potential, offered training, and that I would have chances to grow with them.

But that may be the reality for some, but mostly a fantasy...

A lot of us have to work for shlocky companies, that slowly change, don't really care, just do the work, and that can really hurt our desire to do our job, if we're always the janitors of the web.

Which is not what I had signed up for.

For me, I want to be the best, not so much for the recognition of others, but to find something I can do with my life that I am proud of.

Success, Excellence, I feel is really a mental attitude, do you really care about your craft, even when other's don't?

Do you do what's right even if no one else agree's with you?

Can you stand to be alone in a crowd, and stand by what you believe in, even if no one agree's with you?

I've been reading a lot of Jeff Atwood's Coding Horror Blog, and DailyWTF, because they show where we and others screw up in our programming, and perhaps give us clues as to how to improve ourselves...

I think what kind of upset's me now, is a big lack of vision and clarity about where coldfusion is going?

I just don't feel that after this many changes of owners, anyone has a clear vision of what does coldfusion mean, what is it's future, and what is good for both industry and company..

I mean, for me, i focus on the core values of coldfusion programming: performance, documentation, commenting, variables, sql queries, project management.

But i just don't see much discussion on those topics anymore, instead it's what the trends are on, which are cool, but have we as an industry shown that as coldfusion programmer's we've mastered those basic core values?

I don't believe that is so....

Until we're Coldfusion Professional Programmer's, where when people pick both the language and the people to program in it, they will know they will get solid quality, that plans for long term as well as take cares of the short term..

Just my thoughts...

SQL Server Bind Variables

2007-02-16T12:35:00.000-06:00

Lately I have been looking for new ways to improve the performance/scalability of my t-sql code. I had remembered that with ORACLE and using cfqueryparam, took advantage of ORACLE's bind variables functionality.

Basically a bind variable, means it treats the queries the same, in terms of performance/explanation plans, even though certain variables are different.

Now while cfqueryparam is always a good practice for preventing sql injection and protecting, I was not aware of how to do bind variables for SQL Server, until now.

sp_executesql

is a very powerful but limited dynamic sql building tool.

execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @level',
N'@level tinyint',
@level = 35

Above is an example from http://doc.ddart.net/mssql/sql70/sp_ea-ez_4.htm

Notice how N is in front of each line, that is to force it to be nvarchar, because the stored procedure accepts only nvarchar, even though the fields in your table may just be int, varchar etc.

Secondly this allows 3 parameters

first parameter is the sql query
second parameter is the declaration of any incoming parameters
third parameter is the setting of those parameters

The problem is that if you have multiple incoming parameters, they all have to be declared on one line. The Sql query can be multiple lines but itself consists of the first slot in this stored procedure.

So if you want to not use up memory by caching a query, this is one way to improve performance, by taking advantage of the bind variables, capability.

BTW, if you want more tips on t-sql query optimization, I recommend that you check out this article.

http://www.sql-server-performance.com/transact_sql.asp

IE7 Breaks Relative URLS

2007-01-30T10:03:00.000-06:00

My own company's site has had huge problems lately because we did not include base href tags at the correct spot in all our code.

How many of you are noticing bad links, bad images, bad forms, that just do not work in IE7.

Especially if you have a page that has search engine friendly url's.

Well in order for those to work you must have the BASE Tag in a specific spot.

BASE Element--Internet Explorer 7 strictly enforces the BASE element rule, as documented in the HTML 4.01 standard. We no longer allow BASE tags outside of the HEAD of the document. The standard specifies that the base element must appear within the head of the document, before any elements that refer to an external source.

Which means every coldfusion page has to have a base href in it. Which can be a tad difficult, if you have different development, production, testing or q&a servers.

It kind of makes me wonder if this was a necessary for IE7 feature. Or if any of you have had other IE7 issues.

Communicating your ideas

2007-01-24T12:14:00.000-06:00

Rather fascinating post at 37signals, about The Curse of Knowledge. What is interesting, is that it points out that the more you know about a topic, the less likely you are able to communicate it.

And this comes home to me, in the many times, working on projects, and not always able to communicate what I plan to do, what my logic steps are, in a way that others will understand.

People tend to think that having a great idea is enough, and they think the communication part will come naturally. We are in deep denial about the difficulty of getting a thought out of our own heads and into the heads of others. It’s just not true that, “If you think it, it will stick”.

This is so true, because what good is our great ideas, if we can not explain them, communicate them or persuade others that they have value?

What tools or methods do you use to help communicate or persuade your ideas?

Flowcharts, Wireframes, Project Specs?

Tools I love and use

2007-01-19T08:58:00.000-06:00

Textpad has to be my number one tool, although I am willing to migrate to a newer text-editor. It just is easy for me to search/replace thru many folders/drivers, regular expressions, macro programming.

Compare-It, is a file comparing tool. Let's say you have a code on development server and code on production, and you need to see what's different. Or I have also used it to compare stored procedures, after saving them as text files. Just a very nice file comparer.

I use Firefox as my web browser, but I use many extensions to help me test code, such as the Web Developer Extension, Extended Statusbar, Firebug to debug javascript errors, IETab to view a new tab as if IE was inside firefox, ServerSwitcher is a great extension that allows you to view a web page on dev or production, then switch back and forth.

I recentally got the Multi-IE Package, that installs multiple versions of IE on your pc, each in it's own folders.

For database querying, I use a great query tool called Advanced Query Tool, I like it because it makes it easier to design, visualize queries, test them, on each database server you have.

I have been playing with this SQL Server Monitoring Tool, called SQL Stripes, which is a freeware/shareware
that provides a powerful console for managing multiple servers running Microsoft SQL Server ™

I also love this trial version of Toad for SQL Server, it has a very powerful, sql tuning component. Basically, you give it a query that you think could be re-written for better performance, and it will try re-writing that query many times, until it has the sql query version, that provides the best solution. I can't yet afford this tool, but it is a very wonderful tool for improving performance of your sql queries.

For FTPing, I use FileZilla, it just is a very easy to use, and open source costs, make it a very nice and powerful ftp client.

There are a lot of nice tools out there, what are your favorites?

Coding Inside and Out

2007-01-18T09:39:00.000-06:00

Steve Jobs really makes sense in this quoted interview on Jeff Atwood's Coding Horror. He really identifies that Microsoft may be great financial company, but their products are third rate. They are third-rate because they have no thought about taste, style or culture in their design process.

And here's Jeff Atwood's comment, that really sinks the hole in one for me.

At Apple, taste and culture are designed into every product from day one. Nothing is released until it looks as good on the outside as it works on the inside.

That is so blindingly true, look at the ipod, maybe it doesn't have every feature that other mp3 players have, but it is so easy to use, and it is so intuitive.

And part of the cause of the not thinking about taste and culture, is short-term thinking.

Here's another comment by Jeff Atwood, that makes this clearer, and I do hope you read his blog posting, it is well worth it.

Jobs is dead on with his criticism. But the problem is much deeper than Microsoft; it extends to the entire PC industry. In the PC world, taste and culture are rarely considered, and if they are, it's always as an afterthought. Ship it first, make it look good later. If you ever do.

Isn't it time for us to wake up smell the roses, see the huge consequences of not caring about the quality of our applications, other than ship it fast, ship it now!

I mean it's obvious that Google has a similar strategy, 37signals.com, all the really good companies, care about the long term.

It's even in 37signals, philosophy, to release fast, but release with less features.

Or like how Google has a very simple page for their front page. which is so attractive in fulfilling our basic needs to search the internet.

Where are the people who really care about their applications, more than just when their creating it, or having to fix some one else's code.

I think I am personally sick to death of always having to fix someone else's code, or that it is so horribly complex and undocumented, that it takes forever to figure out what does what.

I think it's time for us application programmers to take a stand, we're not just monkey's on type-writers, we care for our apps, we want them to be the best, inside and outside.

I mean, they say your just a coldfusion programmer, so that is supposed to mean, don't care about the database, don't care about the design, interface or usability of their apps.

Just create it, and create it now..

And let someone else try to fix what bugs you introduce...

I know I am a tad cynical, but I also have hope, and would love to hear from anyone else who cares too...

Do small companies/departments need structure?

2007-01-17T09:40:00.000-06:00

This has been a question that has been hitting me home. Some companies think that because they are small, they don't need to spend any time or energy being organized/structured.

By structured/organized technically I mean:

1. Bug Tracking System - That helps developers kill all bugs, which incites them to create less bugs.

2. Project Management System - can be excel, notepad, anything that helps developers manage their time, and managers set priorities, due dates and manage that.

3. Documentation of Code Logic/Business Rules - So that if lead developer dies, and he/she had it all in their head, how in the world would the next lead developer figure out the code/logic and business rules?

4. Common Coding Styles - Including page naming, commenting, indenting. And have this written to train new members, and remind old.

5. Set, Record and aim for Technical Goals not related to specific projects but affect overall success of developers. IT Architecture, Scalability, Updating ColdFusion, Updating databases, Security, etc. Do you just create more code, or do you also work on improving the environmment, universe the code resides?

Maybe the size of the company can dictate the complexity or depth you go to provide solutions to your main needs, but to not provide them sounds like something that should be on the DailyWTF.com

How do you explain the importance of organization/structure to those who think small companies don't need them?

OT: 9-11 Also My Birthday

2006-09-11T09:52:00.000-05:00

I am always sad this day, and probably will be for the rest of my life.

All i ask for is that we rememeber all the lives and blood that have been spent to protect and fight for our country.

I think now of two people that mean a lot to me...

Todd Beamer, of Flight 93, who said the words that sparked our nation, "Let's Roll"

And Nathan Hale, first american spy, who said, "I only regret that I have but one life to lose for my country. "

It means to me that there are still american heroes, and that if we can unify and find ways to work together, we can be a great nation again...

But today is not about politics, it is about recognizing the sacrifice of life, love and liberty that others have made, and that we should honor their deaths..

Thank you...

OT: I stand by Israel and America

2006-07-18T14:44:00.000-05:00

It is time that we got rid of all those jerks who are constantly getting away with killing in Israel and worldwide.

Btw, in case you didn't know I am jewish, but I am American first, and on this day I am proud of Israel for doing what America rarely has the guts to do.

Stand up for the lives and rights of our family and loved ones.

Like when we bombed Nagasaki or Hiroshimo, neither a pleasant experience. But when it was discovered that for us to manually take down those cities would cost us hundreds of thousands of our men's lives we chose for the attackers/evil people to die before us.

I stand by Israel and any who has to defend themselves against evil that kills them and their families daily.

I am a proud american this day, to know there are nations out there, who know and does what it takes to defeat evil!

Because this is a holy war of evil people!

They must be defeated, and if it's a choice of us dead vs them dead, I always choose them dead.

God Bless America and Israel!

How are we really taking advantage of code reusability?

2006-07-10T09:06:00.000-05:00

This is something we always wanted, and now we have the tools to take advantage of it, but yet, the way companies are structured, there's no interest in having a universal library of coding modules.

I mean we like cflib.org, it feels a niche, but we need something a step up, where we can share full coding modules.

And this is also part of the difference between coders and designers, designers can show web designs and portfolio's, what can we really show?

So to fulfill two needs, our community should create a new type of modulare code sharing.

Here are my simplistic ideas for the structure of this code sharing community.

People would submit code, and put it into a category, registered members would review, and rate the code.

The code submitted should be framework neutral, something that could be used in almost any method. That of course could change as the amount code modules were available.

You can view the code, download the code, test the code, except code that is database specific, or File IO Specific.

Also other members can try to compete against the same code goal, and see if they can write it better in any of the following ways:

1. Clearer Documentation
2. Scalible to different levels of needs
3. Can it be done in less lines of functionality
4. Is there a version of it, in each of the popular frameworks of the times?

Etc. Keep it simple at first, but competition would provide coding examples of what good code was, and make good code available to beginners, or those who want to deliver products/services faster.

Rapid Application Development

There would also be a Dreamweaver Extension or Webservice, where you can browse, view, or download modules as you had a need for it.

I just had the idea, does this interest people?

What do you expect to be at new cf jobs?

2006-07-10T08:55:00.000-05:00

I mean as we get more experienced, we have certain expectations of the way the development environment is setup. And each of us may slightly vary on that list, or what solutions.

When I start a new job, I expect:

1. Source Control
2. Coding Style Documentation or at least an example
3. Development Life Cycle, of where we do code from development to production
4. Project Management Process/System: So I know how to correctly manage my time, especially since there usually is a lot of multi-tasking.
5. Am I working alone or as part of a team, and how is the division of labor of that team organized?
6. What kind of training or training support is there?
7. What is the architecture of the code and database?

That's my basic list, what is your list?

Where's the beef?

2006-07-06T15:58:00.000-05:00

Well here's the thing, when i start off at a new company, I usually have to bring my bag own set of standard needs as a developer. And it's hard to find the solutions that fit every company.

1. What source control to use, and will it be cheap and work with many different ide's?

2. What kind of project management process or system aka How do we manage our time and priorities so that work that should be getting done is getting done.

3. What's our development environment? Do we have a dev server, production server, perhaps even a testing or qa server? And do each have seperate web and database servers?

4. What database are we using, is it well designed, what tools do i need to help make sure it's being used correctly and is well maintained. Are they using any maintenance plans, is there any diagrams of the database structure or ERD's?

5. What kind of coding style/framework are we using, what's the naming conventions, I want all of this info right away, so that the work I do, can fit in, with the best practices of cfml and the practices that this company wants it's way of doing things?

6. What tools/software do i need to download to have an elite developer's station? What OS? What DB Tools..

7. What kind of training plan is there or should we have?

I mean that's my point, there is no universal starting point or standards for the above question.

Every place I go, there is a mass discussion as to how what I consider bare minimum requirements. Why worry about what framework, if we don't have hte basics covered first?

That is my current blog point..

Think about it.

Framework Evangelism

2006-07-06T14:46:00.001-05:00

This is what irritates me about coldfusion, i love to code. But if i don't code the way everyone else does, that somehow makes me a crappy coder.

If your happy with the way you work, so be it.

But we have to think more than just short term.

What if you died, and no one using your specific method was available for hire, and had to hire any variation of a coldfusion developer, how easy is it to take off from where you were to make changes, understandable.

But instead of seeing that as a practical need, you see that somehow as an attack on your favorite framework.

And honestly it really is irritating, the constant insinuations, the evangelization, join us, be with the good coders.

Because if your not with us, your against us.

That is totally purille.

I am not here out to defame or destroy the way you code..

But like with any method, even how you vacuum your home, there are pros and cons of every method of doing anything. And i try to bring up a few things, not because i want to hurt, insult or destroy your framework or methodology, but because I want to bring it to your attention as something to think about.

Is it so hard to admit that your framework or method of choice has flaws?

I know i try to always improve how I do things, make sure I understand the short term and long term costs of the way I do things.

All I ever wanted was to stop coldfusion from producing bad code, but you just can't believe that the way to do that may not be your way. And I am not saying my way is 100% perfect, there is no such thing.

Let's grow up a tad, and stop pushing X framework as the solution of all problems...

I may disagree with you,, but I don't hate you for disagreeing with me.

But it seems the more i try to participate in helping this industry grow as a blogger.

The more i get hate mail or the wrongful assumption i am trying to hurt or destroy someone's framework.

I honestly do not see OO or Java as the way to be the best coders, that's my humble opinion. It may work for you, and htat's fine I am not trying to persuade you one way or the other.

I was only trying to have a logical discussion.

But instead I get comments like, well you've not used OO or OOP, so your obviously a low quality programmer.

Is that what Hal Helms and Steve Nelson and other greats really had in mind when they had these ideas for improving coldfusion, that it's our way or the highway?

Where are all the nice people in coldfusion?

Being Mr. Clean

2006-06-30T07:48:00.000-05:00

I'd like to share some of my experiences as a coder in the Mr. Clean role, where've i've had thru the last 3+ years, been the person cleaning up the code for other people.

And maybe it's having to do that constantly, that has made more my focus on the basics, rather than soem advanced cf programming.

So i'd like to share some of my systematic approaches I have to improving the code.

1. Documentation

Commenting is essential as more programmers are aware of, but when you have a lot of coldfusion files and applications, it's time to step up and document your applications as well.

And this doesn't have to be something highly complex.

For example if your a dba, you'd create a Entity Relationship Diagram as both document and reference material.

As a coder create an Informational Architechture of your Applications

Pick an Application on your site.

A. What files/folders does it contain
B. What custom tags/includes/cffunctions does it use
C. What datasource/databases does it use?
D. Any kind of major current problems going on with it?
E. And if you have the information, perhaps a small history would be nice as well.

This is all about my belief in the importance of preparing for the worst, and also providing training information, for either a peer, a successor, your manager, etc.

2. Source Control

This may sound sad or amusing, but not every company has source control in place, or knows what one is easiest to use and deploy. Or what ones can be cheap to try out and cause the least problems

This takes time and trying different ones out.

3. Pick and Document a Method/Framework

It doesn't matter to me what method you pick, but document as much of it as possible, what naming conventions your gonna use, coding styles, working in any kind of teamwork styles etc.

Even if your using the most known framework in cf world, each company tends to have it's own unique flair for how they implement it. So document it, for your posterity's sake.

4. Know and Train to be expert on all levels of application development.

Where you may start out by being a part of a team, using methods like fusebox where you only have to code in certain aspects of coldfusion application development, in the end, if someone leaves, or you move on, you may not always have the option of just coding in what you've done so far.

So I still believe that training in all aspects are important, good coding styles, using your variables/incoming data, parsing/manipulating strings/data, interaction with databases in writing great sql, basic layout and design.

I am not claiming to be an expert, I just suggest it's wise in the long haul to know as much as possible.

Now of course, it may not always be easy to implement all of these ideas, right away at full 100%, so you need to find small things, small incremental ways, so that you're gradually becoming the full rounded, long term thinking/planning developer.

I hope someday where I can stop having to go to places and be Mr. Clean, and just write good code.

Thank you.

P.S. Happy Forth of July

How did you get your ColdFusion Training?

2006-06-28T06:20:00.000-05:00

After a lot of the comments back and forth, I am kind of curious to here some comments on the different ways and methods that we all got trained to learn to use coldfusion.

I myself, learned by bothering the web development team, when I was a tech support person, to learn how to do everything from html, javascript and coldfusion.

I was always a person who wanted to learn more, do more.

No one was offering any training, classes, books.

But on my own I had started off by getting an Instant HTML book, then just started to play with html, javascript etc.

As for training companies provide, in my personal job experience:

1. I have been to exactly 1 ColdFusion Conference, CFNorth, loved it tremendously, but the company wouldn't pay to go a second time. Most of the companies I worked for did not seem willing to spend money on training, other than to maybe buy a book for you, and that was if you were lucky.

2. I also went to a free Allaire Spectra Demonstration in Minneapolis, where I saw Raymond Camden for the first time. Not because I really was into Spectra, but because it was free and it was any kind of coldfusion training that i could actually hear other developers from.

3. And this was before the days I even heard there was a CFUG, but I really did like the early days of the CFUG. I even was lucky enough to present a few times.

4. But most of my training was either me buying books on my own, learning on my own. I just asked a lot of questions.

5. Eventually I got the opportunity to help train others at 1 company, and I tremendously enjoyed that, not because I want to shove my preconceived notions down someone's throat, but really because I want to help other people have to go thru the painful process of learning that I and many others had to go thru. The CF Developer's Guidebook is awesome both for learning to get certified, but to also help know what are all the aspects of cf to master.

6. But as I get exposed more to different jobs, companies, it just became obvious to me that companies didn't really want to help train you. They wanted you to be trained in how ever many programming languages and methods, but didn't want to take the time or money to help you really master it.

7. And I've done a lot of job interviews, it would be very shaming that I would see all these web shops, that just didn't care about the quality of their code, yet I would have to try to get those jobs because sometimes that's all there was.

8. So because of that, I started to write my first articles, and I posted thme on defusion.com, they are still there.

I mean I even created this blog, because I want to both learn more, share more, hopefully to bring the quality of our industry as high as it gets.

But it really upsets and insults me all the negative comemnts I get. Like that because I don't agree with them, or didn't have the same experiences as them, that I am somehow not a good programmer.

I mean we are all shaped by our experiences, and none of us exactly have the same ones, can't we respect that out of each other?

I really hope you can see past your biases, to our common desires and dreams for coldfusion to be the best it can be, and that we as an industry can shine...

I am no Ben Forta, Charlie Arehart, I am just a ColdFusion Developer who loves ColdFusion, I just want to both be the best, and help us all as i can be the best.

So tell us all what kind of training experiences you had, I really would like to hear.

Thank you.

Are we going down a healthy path of ColdFusion?

2006-06-27T08:31:00.000-05:00

Lately all i hear is eclipse, java, .net, code reuse, database introspection, and I find it rather irritating, I mean honestly have we as an industry really proven that we create stable, usable applications?

Maybe that's why I care less about what the trends are, because I see us more focus on what's new than doing ColdFusion at higher level's of quality.

I've had a lot of job interviews with many different companies, but what strikes me is this drive to new technology, without even been to the point of creating good code.

I think we've lost track of the lessons we should have learned with the dot-bomb.

Here are some of the lessons I learned:

1. There has to be solid financial stability, could care less for IPO's, porsche's but just to have a job I can keep, and be at for 10-20 years would be really ncie for a change.

2. The end of all these schlock shops that just churn out code, that 1-2 years later embarrasses or destroy's their reputation, because it was crappy coding.

3. New Trends/Fads are fun, but are no replacement for solid standards, good work ethics, and giving a damn about the applications you sell/provide or service.

4. The end of Short Term Planning/Thinking, I mean sure there are things we have to get done in the short term, but why keep self-destructing by avoiding what is essential to being a top knotch language...

Maybe that is why I am a fan of Charlier Arehart and a few others out htere, that try to help us create better code and applications....

Maybe that's why I could care less about OO, Fusebox, MachII, ColdReactor, ColdSpring.. Because are we really as a whole industry really turning out applications like we should be, something to be proud of, that lasts, instead of having to always re-write everything in 2-3 years because we didn't give a crap...

Maybe that's why I use to go to CFUG meetings and read the CFDJ....

Instead I get, have you done an enterprise application, focus on inane details instead of am I proud of the code I create, do I give a hoot that 5-15 years later it is still reasonably easy to read, scalable, can be easily fixed or changed...

I love programming in ColdFusion, just not sure where I fit in an industry that cares more about having/creating the next dot-com explosion when we really know it's just gonna blow in our faces again...

Just think about it...

From Fluff to Functional:Dotcom Titles Evolve

2006-05-18T10:19:00.000-05:00

I am completely frustrated with the whole mass confusion that exists as part of the IT/Web Job Search...

I want to open a discussion between recruiters, job seekers and big resume sites, to help clear this confusion up...

read more | digg story

Dealing with non-standard boolean values

2006-04-27T14:15:00.000-05:00

I am have worked with how Access and other sources deliver non-standard variances of boolean variables.

After all when you update/insert to the database, all you want is a 1 or 0.

So I created this udf to help speed that process up.

<cfset one = "false">
<cfset two = "0">
<cfset new_one = 0>
<cfset new_two = 0>

default values: 
<cfoutput>
one = #one# 
two = #two# 
</cfoutput>

<cfscript>
function booleanize(value) {
if (not isboolean(value)) {
value = replacenocase(value,'on',1);
value = replacenocase(value,'off',0);
}
if (yesnoformat(value) eq 'Yes') {
value = 1;
}
if (yesnoformat(value) eq 'No') {
value = 0;
}
return value;
}
</cfscript>

<cfoutput>
New Values: 
one = #booleanize(one)# 
two = #booleanize(two)# 
</cfoutput>

This includes the udf as well as the test example.

I know it sounds simple, but this is easier than having to adjust your code logic for every checkbox, access on/off or true/false value.

Think about it.

FEMA needs to be scrapped, senators say

2006-04-27T06:37:00.000-05:00

Instead of fixing the problem, they want create a new organization in the same image. Ah but here is the punchline, they want to do this, 5 weeks before the Hurrican Season.

Amazing stupidity...

read more | digg story

Why SQL programming is so important to a CF Developer?

2006-04-07T09:05:00.000-05:00

Right now I am listening to the ColdFusion Podcast, and I have to strongly agree with them, on the importance of learning to write correct and scalable sql code.

There are many different databases, and most cfers, start with access, which is great for beginners or very low traffic sites.

However if you want to build something that has to be able to handle lots of transactions.

Now the first part is to understand what causes blocks of performance?

Well for first off, any time you interact with the database with a cfquery or cfstoredproc, you are creating seperate blocks of memory, that need to be processed.

So how many cfqueries and correctly written queries is what really matters.

When you write the queries, identify the columns of data that you want to bring back. And Only have those columns in your select statement. In addition, having the columns in the correct order, as they are created in the tables, helps for performance...

Learn your table structures, make queries that work with the grain of their structure instead of warping it, making it go thru extra processing just because you were too lazy to put things in the correct order....

Now if it is just one table in the query, there are limits to what more you can do, to improve performance...

But with joins, you can take the query from the cfquery to a view or stored procedure. Views are usually the easiest, to create, from within sql enterprise manager.

Now when you run the page you can identify the performances of each cfquery, and over time you will get a hang for what query is causing problems or not...

For example if you are looping and doing a cfquery within that loop. That is actually causing a performance problem. The better approach is to combine the top query with the query in the loop, so that it is one connection with the server instead of looping.

Part of the problem is having the right tools and using them correctly...

But this all that i have time to discuss, please ask any questions. I'd be glad to help.

Charlie Arehart: A Pragmatic CFer

2006-04-04T12:17:00.000-05:00

I know it's sad he's leaving Blue Dragon, and I know it feels like he's leaving. He isn't.

But perhaps this is our time, to give thanks and respect to one of the true leaders of our community.

I can still remember reading some of his first articles in cfdj, and I was really impressed, because to me, I wanted to learn more, do more, and be as efficient as possible.

To me, he seemed, how can I help people from any level of experience in cfml, program faster, easier and more efficiently.

From his tips about CF Studio and Homesite, to his different articles on developing.

I mean we all knew synax of Cf, but putting it together in a professional and efficient manner isn't something that we had the ability to take classes on.

So in bits and pieces, he is the guy that gave you that extra depth, made things faster for you to develop.

Gave you some undocumented features and knowledge of how CFML works.

I think that is is because of cf writers and programmers like Charlie Arehart, are the reason I wanted to blog and become a writer.

Remember your committment to the cf community is not just about how many articles or books, it's about your passionate committment to the craft of programming in cfml.

Thank you Charlie.....

Textpad: Still the best coding tool

2006-04-03T01:10:00.000-05:00

It is still amazing, after 10 years, I still use textpad for my code editing. There are many reasons why it is superior to any ide.

* the ability to maintain block indents
* automatic code indentation (see indent style)
* regular expression based search and replace, including multiline regex
* Macro recording feature to facilitate complex text transformations and data processing.
o Macro feature supports multiple regex searches (and replacements) within a macro
* syntax highlighting (extendable to many different languages)
* ability to call external programs (such as Java compilers)
* large file support
* support for editing multiple files, with tabbed document selection
* block select mode
* synchronized scrolling of multiple files

Pure and simple it is the best text editor, at least so for me.

The interface is customizable, it has clip libraries so you can have snippets, auto commands etc.

But where it excels is the speedy file/folder search which can be enhanced by using Regular Expressions.

Why a text editor vs an IDE?

Well i believe in something called feature over-creep, where the at some point the application fulfilled all the core needs, but because they wanted to keep making money, they added more and more features, that probably would be best as a seperate application...

Do we really need an application that does everything? Or the best application for each specific need?

I guess it depends on your style, old school vs new school...

I'd rather have a fast and powerful editor, then something that did so many things i really could care less for. And look at how the memory requires of each is quite different...

What are the favorite old school software you still love to use?

Here is a few of my favorite's:

1. Namewiz - Batch file renamer for renaming digital photo files and any other files, according to masks or however you format it.
You can get NameWiz here.
2. Eyedropper - a system tray color grabber http://eyedropper.inetia.com/
3. IrfanView - greatest image viewer ever
4. Freenote - a notes system that i used to create all my notes for every task/project. It stays right in the system tray, ready when you need it. Get it here

That's enough for now...Please add your favorites as a comment...

I think I am getting OO

2006-03-29T08:35:00.000-06:00

After that's all the cf blogs talk about lately, and so I am kind of slowly but surely getting on to that path.

To me it's all about better architecture for applications. I kind of like the idea of Model-View Controller, it was the methodology that was taught in that Fusebox Class I took..

It honestly was very interesting, if you work in team environments.

My big pet peeves was, the parsing fusebox has to do, to enable mvc. Now I admit I am still new to MVC and OO.

And that was my big problem with the whole process, was the whole setup process, how it affects performance, having to do all the parsing to enable MVC.

Secondly, how can we tell if we're going too far into OO, aka focusing more on the architechture then speed of delivery.

I think it would be nice to get some opportunity to learn and practice more MVC/OO.

And get my hands dirty in Ajax.

But until then, I will focus on my basics.

Project Management, Scalability, Documentation, Performance, Best Practices.

One of the ideas, I had posted a long time ago, was to have some kind of global code repository, like cflib, but it would be full applications, not tags. The purpose of this is to share code, review code, to see who writes what kind of application, in what way, that is both optimal and scalable.

Other than that, let's keep bring the bar up on CFML being the language to program in. We should be both coders and scientists...