Common Man's Rants and Raves

CSS Trick for HTML5, Edit CSS inline for the page

2011-03-02T06:36:00.000-08:00

We all have our favorite RSS feeds to follow and I'm no exception. One my favorites, CSSTricks.com, had a great post this morning about how you can use HTML5 along with an easy setup to edit CSS for a page right there *on* the page. Pretty neat trick. Be sure to try the demo!

Check it out for yourself:
http://css-tricks.com/show-and-edit-style-element/

Very cool Javascript debugging trick (Firefox, Javascript)

2010-06-02T13:39:00.000-07:00

I'm working along on a page, an interface for some configuration data. I have a javascript validation routine that runs upon hitting save. I had all my various dynamic HTML elements exactly like I wanted them, and didn't want to hard reload the page, yet again, to get the new Javascript code.

In Firefox, I opened Firebug, went to the "Console" tab, and pasted a whole new copy of the function into the console line. After pasting a multiline piece of code into the small console line, a larger side window popped up to allow better editing, also available from the small icon to the bottom right of that section:

I proceeded to hit my "Save" button to begin my validation and, volia!, my new function worked correctly with the bug fix in place. And I didn't have to refresh the entire page and start from scratch. Not a bad little trick!

- Will Belden
Wednesday, June 2, 2010

Gmail Notifier -- Wasn't working, here's the fix...

2009-08-22T21:43:00.000-07:00

For some months now, I've been having errors with Google Gmail Notifier. Whenever my machine restarts, I'm asked to login for that little app, which I do. It promptly says "Can't connect..." or some such thing. I typically just exit the app and don't think about it until my next reboot. The wheels on the bus go round and round....

I finally decided to investigate after installing the latest round of Windows Updates (which, of course, nags me to death until I reboot!) Seems that the culprit lies in the Gmail setting of "always use https" to connect to Gmail. Apparently that setting prevents the native Gmail Notifier of being able to fetch the data.

After some brief searching, it appears there is a very simple registry hack (done by double clicking a .reg file in a zip file you can grab.)

Here's the Google post with the zip and the details:
http://mail.google.com/support/bin/answer.py?hl=en&answer=9429

- Will Belden
August 22, 2009

Better Javascript in Coldfusion

2009-05-19T09:31:00.000-07:00

I gave a presentation today at work on improving your Javascript skills, as it relates to Coldfusion development. While there were a million things I would've like to cover, I only had an hour. Here are some highlights that might be worth passing on:

Avoid <cfinput> and <cfform>
These tools, while helping to make your Coldfusion development faster, really cripple us as coders. I believe that every HTML developer (those who code in PHP, CF, etc.) needs to know Javascript. The js code generated by Coldfusion is very bulky and not necessarily optimized.
Avoid using Coldfusion variables in your Javascript code.
Think it through and parameterize your JS rather than being lazy and including #variable# directly in the code.
Move your Javascript to external files
By placing your js in an outside file, linked to by your Coldfusion code, you allow the browsers to cache something that doesn't change too often. This results in increased bandwidth savings, better logical separation and enforcement of keeping CF out of JS.

In addition, if you have access to a "resource service" that you can tell to include a particular js file (as opposed to using the <script> tag) you'll be able to implement a minify/pack/gzip solution as well as a combining technique at a later date. A service like this can prevent multiple script tags for the same file when the HTML is rendered.
Think cross-browser, at all times.
Sure, maybe today your company says "We only support IE". But I can almost guarantee you that tomorrow it will be "We only support IE and Firefox." In one set of code I saw recently, the js would simply reference "myInput.value". Apparently this works in IE, but doesn't work as well in Firefox. If they had done a proper getElementById() or even
document.myForm.myInput.value there wouldn't have been issues.
Get behind jQuery (or some Javascipt abstraction library)
By using a tool like jQuery for DOM element selection, like $('#myInput'), you enable abstraction of how you get the object. These tools are also optimized differently for different browsers, allowing you to use a single style of object fetching, without writing a lot of "if IE" statements.
If you name an object, also give it an ID.
Remember, ID's are meant to be unique amongst all elements on a page.
If you need to "group" objects, just add a non-styled class element to the objects. Then you can use something like jQuery to get all the elements with that class.
Don't use versioning in your file names.
If you have myCode.1.2.3.js and you reference that in your code, then you have to refactor all your pages that reference that file when you want to upgrade. Just copy that file to myCode.js, then you swap out the files when a newer version comes along with no code changes.
Comment, comment, comment!
Can't stress this enough. Even if you're the only developer on the project and always will be, commenting is still valuable. I can't tell you how many times I've come back to some code, no matter what language I used, and had no immediate recognition of the code I had written or how it worked. Commenting is so important.
Try dynamic event binding
If you have 10 phone fields with onblur="formatPhone(this);", why not add a class to those fields, like class="phone". Then with something like jQuery, you can create an document.ready event that will bind the formatPhone() custom function to all objects of input#phone that it can find. You could save a whole lot of bandwidth on a site that dishes out such a page frequently.
Remember, there's always more optimization to be done
Most developers are receiving a paycheck from a company that has hired them to produce results. Because of this we have to balance speed with quality. Typically, however, a little forethought can go a long way. Rush, rush, rush is never the answer. Spend 3 hours now to do it right versus 1 hour to "bang it out" and you'll be spending that 1 hour now and 5 later trying to refactor it and correct it. (And that's just you....what about other developers on your team that may get saddled with having to fix your poorly thought out code?)

- Will Belden
May 19, 2009
Updated: August 22, 2009

SQL Server Error: Dynamic SQL and 'you must declare scalar variable @whatever'

2009-03-16T14:05:00.000-07:00

A good CF-er friend of mine says blogging about mistakes makes me look bad to potential employers. I think that it might help someone out there save some time, and to remind myself that I certainly don't know as much as I think I do!

So here's a fun one for today.

I had to modify an MSSQL stored procedure to pass an already defined parameter to another proc. That inner proc helps build dynamic SQL. So I [roughly] modified the WHERE clause setup of the query like so:

SET @dSQL = @dSQL + ' AND PersonId = @PersonId'

Drove me crazy trying to find out why it kept telling me to declare the variable. After about 20 minutes of digging, I realized my mistake.

When the dynamic SQL runs, @PersonId is no longer defined! Seems obvious now that I mention it, but, well...you had to be there. The correct syntax is:

SET @dSQL = @dSQL + ' AND PersonId = ' + @PersonId

Again...it might seem obvious now that you're reading it, but trust me...it wasn't at all obvious when I was trying to debug it.

- Will Belden
March 16, 2009

Trillian Astra -- Awesome hidden feature

2009-02-11T09:56:00.000-08:00

So I've been on the Trillian Astra (multi-service instant messenger program) beta for some time now. I totally love it and can't wait for it to go to production so I can pay these guys for their great work.

I just discovered a nifty feature today by accident and wanted to share. Typically, I use the custom hotkeys to show and hide the contact list, then double click the contact I want to IM with.

You can, however, drag individual names or entire groups out of the contact list and drop it, and it will create an always-on-top mini list. I tend to only IM about three people most of the time, so it fits quite nicely hovering in the corner!

Way to go Trillian!

Implementing Transfer Observers across all your decorators, the easy way!

2008-11-17T09:12:00.000-08:00

In our framework, we use Transfer "Decorators" as a common way to extend the functionality of the generated objects that are based on the configuration XML.

For this system, we have a record (media) that represents each user upload of images. For example, we allow multiple profile images to be uploaded, and you can select your current profile image from the "gallery" of your previous uploads. In addition, however, you can delete these images. If you're familiar with transfer, you know it's as easy to delete the database record as saying oMedia.delete(). That removes the object from the database and from Transfer's cache. In this case, however, we also need to remove the actual files from the webserver.

One possible solution was to create a manager service, and make sure that all media deletions go through it. However, this removes some of the intuitive nature of Transfer providing a delete() function for you to use. With Transfer Observers (or "Transfer Event Model"), you can easily extend your decorators to do this on the normal delete() call.

After my initial creation of a mediaObserver.cfc, which I register with Transfer as an observer, I realized I was going down the wrong path. The problem with this is that all observers registered with Transfer get called on each of these seven events:

observerAfterNew,
observerBeforeCreate,
observerAfterCreate,
observerBeforeUpdate,
observerAfterUpdate,
observerBeforeDelete,
observerAfterDelete

The problem with that? Naming my file MediaObserver has nothing to do with my Media records. The events in the observer get called for any object that is getting ready to be created, updated, deleted, etc. So the first thing I did was to rename the file as TransferObserver.cfc. This is a more generic name, obviously, and reflects more accurately what the file is.

So...the question remains at this point: How do I get it to fire an event specifically for my Media records being deleted? Each of the functions you place in the observer receive a single argument when called: transfer.com.events.TransferEvent

From that event, you can do:

arguments.event.getTransferObject()

This gives you the actual Transfer object being modified for this event. That still doesn't tell us this is the Media object, though. But we can do this:

arguments.event.getTransferObject().getClassName()

That returns, in my case, "media.Media". Now I know that this is the object I want rather than, say, an invoice, product or customer object. So I could now write:

<cfif arguments.event.getTransferObject().getClassName() IS "media.Media">
<cfset arguments.event.getTransferObject().deleteMyFiles()/>
</cfif>

After writing this, though, it occurred to me that every time I wanted to have a decorator respond to a Transfer event, I would have to modify my TransferObserver.cfc to respond to a new class name. It seemed that I could perhaps do this in such a way that I could just add a function, with a specific naming convention, to each decorator, as needed, and it would just work. And you can. Here is the format now for every function I added to the TransferObserver.

<cffunction name="actionBeforeDeleteTransferEvent" returntype="void" access="public" output="false" hint="I am called BEFORE a Transfer object has been deleted from the database.">
  <cfargument name="event" type="transfer.com.events.TransferEvent" hint="The event object" required="true" />
  <cfset var stLocal = structNew() />
  <cfif structKeyExists(arguments.event.getTransferObject(), "observerBeforeDelete")>
    <cfset arguments.event.getTransferObject().observerBeforeDelete() />
  </cfif>
</cffunction>

What is this? The Transfer observer looks to see if there is a function named "observerBeforeDelete" in the Transfer object (or the decorated Transfer object, since this function naming convention is not part of Transfer's generated file format). If the function exists, it calls it. It's that simple, really.

If you'd like to download the entire TransferObserver file, along with a portion of the Coldspring file showing how to set it up. I've linked it here on my site as a tiny zip file (1.2K). Enjoy!

Just a note: Performing a structKeyExists() on a Coldfusion component, as in structKeyExists(object, "functionName") is not a guaranteed way of ensuring that "functionName" is indeed a function. If you have certain property types (like object.propertyName = true), then that "propertyName" is also a structure key. The correct way is to use the getMetaData() function, then you can ascertain for sure that what you are looking for is actually a function. However, the getMetaData() is a slow performing method and would decrease performance significantly to implement. The structKeyExists() should work just find, because you probably won't have a property of the object using this naming convention. And you can actually use a different decorator naming convention for these event-related functions, too. The cffunction names in the TransferObserver.cfc must, however, remain as in my example.

- Will Belden
November 17, 2008

FancyBox, jQuery and z-index

2008-11-04T10:12:00.001-08:00

So yesterday I'm working with the jQuery plugin called FancyBox. It's a great little popup gizmo, similar to Lightbox, Thickbox, et. al. But I'm having a problem. In the page I'm working in, I find that we have some crazy high z-index values having been set. One of them is 100,000. Dude. Crazy.

Anyway...so I wrote a small jQuery-based javascript to determine the highest z-index value of all the elements within the page. After some research into the jQuery selectors, I find what I need. Unfortunately, as I return the .css("zIndex") value back from each object, compare it to a running max, I find that in the end the value "auto" is the highest. That's not helpful. I end up finding a simple isNumeric() function I can include, but it only checks the characters in the value against numbers and the decimal point. So I find that, with my routine, 2000 > 100000. Um...that's not right. That lets me know, though, that it's not comparing numbers to numbers, but rather numbers and character values. The parseInt() function solves this.

In the end, here's the basic function I came up with, how to determine the greatest z-index on the page, using jQuery:
<script>
  var zmax = 0 ;
  function buildZMax() {
    $('*').each(function() {
      var cur = parseInt($(this).css('zIndex'));
      zmax = cur > zmax ? $(this).css('zIndex') : zmax;
    });
  }
</script>

With this, you can now call buildZMax() and the var zmax will hold the highest value. Now, that's not all I set out to do. Getting the highest z-index value was the prelude to modifying my FancyBox setups to make sure the FancyBox is on top of everything.

Here's how it ended up looking, though we will modify more today to actually incorporate this functionality directly into the FancyBox code, submit it to the author, and perhaps he'll include it in his next version. But this will get you by:

<script>
   var zmax = 0 ;

   function buildZMax() {
     $('*').each(function() {
       var cur = parseInt($(this).css('zIndex'));
       zmax = cur > zmax ? $(this).css('zIndex') : zmax;
     });
   }

   function goFancy() {
     buildZMax();

     // Get all the outermost fancy_wrap id'ed objects built by the FancyBox calls
     // ...then bump the z-index to whatever the highest we found, plus 1
     $('#fancy_wrap').each(function() {
       zmax = zmax + 1 ;
       $(this).css("z-index", zmax);

       // Get the overlay children in each iteration of the outer
       // ...fancy_wrap, bump it's z-index up.
       $(this).children("div#fancy_overlay").each(function() {
         zmax = zmax + 1 ;
         $(this).css("z-index", zmax);
       });

       // And again for another major child div
       zmax = zmax + 1 ;
       $(this).children("div#fancy_outer").each(function() {
         zmax = zmax + 1 ;
         $(this).css("z-index", zmax);
       });
     });
});

   $(document).ready(function(){
     $("a#myFancyLink").fancybox({
       'frameWidth': 600,
       'frameHeight': 600,
       'overlayShow': true
     });

     // Call our z-index fixer.
     goFancy() ;

   });
  </script>

Now, something a bit important to note here. You very likely, if you're a jQuery user, have other scripts that might be creating objects, etc. as you go along. It might be beneficial to put your goFancy() call near the end of your document.ready() code to ensure this ends up where you need it. But the buildZMax() function might very well come in handy for other things you might develop with.

Also, while the selectors in jQuery are screaming fast, if you know that you never, ever put z-index on anything but, say, <div> tags, then replace the "*" in the line:
$('*').each(function() {
... with "div" or whatever you apply your z-index'es to. This will make the whole function run faster, obviously.

Post a comment if you're interested in our incorporation to Fancybox code directly.

- Will Belden
Tuesday, November 4, 2008

Losing my mind with a form...

2008-06-18T09:00:00.000-07:00

Yesterday I created a form. I actually had two on the page. One that did a search, and the results allowed for inline editing. After saving the values in the fields that accompanied the search results, I wanted the search to run again, showing the saved values.

Unfortunately, while my save operation worked just fine, the search wouldn't run again. I didn't understand. My form variables existed in the form scope, but they were always blank. I had added the search criteria to hidden variables within the

It took me twenty minutes to figure out the problem. I had copied and edited these from commands. Instead of value="#whatever#", the all have default="#whatever#". So you get the fields in the form scope, but, well..no values.

Maybe this post will save someone 5-10 minutes of their life. Clearly, I'm never getting those 20 minutes back for mine!

- Will Belden
June 18, 2008

Eclipse and getting .htm and .html files to open in CFEclipse...

2008-03-25T15:14:00.002-07:00

I've been working lately with a lot of HTML files that primary templates, read in by ColdFusion and Java for processing. I love CFEclipse, with it's great color coding making my files easier to read and scan.

However, with my current "company-provided" Eclipse setup, .htm* files opened in the regular text editor. I finally figured out how to change it, instead of right clicking on each file in the navigator and selecting "Open With...CFML Editor".

Select the Window menu, then choose Preferences. Under General, Editors select File Associations. Then, scroll down in the list to .htm and .html. Click on the first, ".htm". In the bottom section, called "Associated Editors", depending on your configuration, you might see multiple options. These, apparently, are the choices you have when you right click the specific file. But highlight "CFML Editor", then click the "Default" button to the right. Do this again for .html in the top list, and you'll be set!

- Will Belden
Tuesday, April 25, 2008

ColdBox Framework, Filename Incorrect error I keep getting...

2008-03-20T10:36:00.001-07:00

If you're using the [awesome] Coldbox framework from Luis Majano, you might have run into this error more than once, but can never remember why it happens, even though you've solved it forty million times already.

Application Execution Exception
Error Type: java.io.IOException : [N/A]
Error Messages: The filename, directory name, or volume label syntax is incorrect
ID: CFINCLUDE
Line: 107
Template: C:\[your root]\html\coldbox\system\plugins\renderer.cfc

Well, here's what it is, so you can quit banging your head. You've set the view in your handler, but you included the .cfm at the end, like thus:
<cfset Event.setView("tester/testDumper.cfm") />

Since I've already hit this error many times, and cannot seem to learn from my mistakes, I'm hoping like crazy that actually blogging about it might help me remember for next time!

- Will Belden
Thursday, March 20, 2008

SQL, WHERE clause vs. JOIN clause conditions...

2007-12-28T14:36:00.000-08:00

Today I found that there's a difference between the a condition in the WHERE clause and in the JOIN clause in a SQL Statement. Now, I realize there really isn't a difference, but in this case...it made all the difference.

Here's an approximation of the original SQL:
SELECT A.id_a, B.id_B
FROM apple A
LEFT JOIN banana B ON B.id_a = A.id_a
WHERE GetDate() BETWEEN B.start_date AND B.end_date

The idea here is to obviously only get the records where the current date falls in the range provided by the Banana table record. This worked great in all my scenarios where I had a Banana record. When I went to try it on a set of Apple records that did not have corresponding Banana record, I got no results at all.

So I took the WHERE clause (or the line containing the date check) and placed it on the LEFT JOIN clause, like so:
SELECT A.id_a, B.id_B
FROM apple A
LEFT JOIN banana B ON B.id_a = A.id_a AND GetDate() BETWEEN B.start_date AND B.end_date

Now it only applies to excluding out of range records in the JOIN only, rather than applying to the result set as a whole. In the initial flavor of the SQL statement, the date comparison would be made against two NULL values for the date fields. The Banana record requires those date values if it exists, but I want Apple records even if there is no corresponding Banana record, and do no date comparison at all. Only exclude the Banana record if the dates are out of range.

Just a gotcha to keep an eye out for!

- Will Belden
Friday, December 28, 2007

Apache and Local vs. Remote on the same network...

2007-10-03T08:51:00.000-07:00

Okay...the subject is almost misleading. But not intentionally. Here's the deal.

Don't ask why, but I had to reinstall Apache on my laptop. My laptop is better than my desktop, so I use it as my local development server. I do all my browsing, Eclipse, graphics, etc. on the desktop, though, because of the bigger screen, keyboard, etc.

So I reinstall Apache and all of a sudden, I can't get to the site anymore. (http://local.site.com). Been doing this for months. I haven't changed webroot paths, IPs, nothing but the reinstall. So I'm going crazy and I'm asking all my buddies what could cause this.

One of them suggests the firewall, but I never use it on my laptop since I'm always behind the router. So I sweat and sweat some more, about an hour of this. Finally, I use my old test that I did for testing SMTP servers. From a command line you can run:
telnet www.google.com 80

You get a blank screen, hit enter, escape, whatever and you'll get a bunch of HTML and be returned to the command prompt. So I tried it with local.site.com and got nothing...but "Connecting to....." until it times out. So...clearly port 80 is blocked on either the desktop or the laptop.

On a whim, I pull up the Windows Firewall configuration. Somehow, it got turned on! I never turn it on, therefore never thought to check it.

So, thanks, Tom. Who would of thought! You, obviously.

- Will Belden
October 3, 2007

Network Solutions, Nameservers and DNS work...

2007-09-14T11:33:00.000-07:00

Look -- I've been in this web business for a long time. I first started web design, while doing other programming, back in 1995, 1996? I know the web. I'm pretty handy with the concepts of routing, DNS, etc. I'm no network guru, but after looking up the color sequences, I can build an RJ-45 cable. I even have my own tools. I've owned a website design business, pretty successful, too. We had staff and everything before we sold it off. We made Dallas Business Journal's Top 20 Web Design and Hosting companies three years in a row!

All this having been said, Network Solutions really angered me today. I quit using them for personal (or side business) stuff several years ago. GoDaddy rocks, in my opinion, whereas Network Solutions charges an arm and a leg for less services, less quality.

Now, even though *I* don't use them anymore, the company I work for does have several domain names registered with NetSol. That's fine...I'm not sweating it. But this week I needed to setup a new dedicated server (which I did at CrystalTech because they also rock) but didn't want to go through the hassle of having our current hosting company do DNS work, when we'll just be leaving them. And I wanted the control over the DNS records that I'm qualified to have.

So I finally got access and I see that they offer DNS management, much like GoDaddy does, so I'm thinking "Okay...I can do this." So I do.

First problem: I couldn't setup new DNS entries under the NetSol system unless I went ahead and confirmed that the nameservers would be switched. Why can't I set it all up, then make the nameserver change when I'm ready. Makes more sense...but noooooo.

Second problem: This is the one that really lit me up. I've done this a million times. I get the DNS concepts. I understand DNS propagation takes time. For those of you who might be reading and don't understand, here's a brief explanation.

Zog wants to go to the website for www.foobar.com
Zog asks the Internets to take him there.
Zog's ISP says "foobar.com?" Wuzzat?
Zog's ISP goes to "the almighty root servers" and asks "Where do I find foobar.com?"
The root servers say "Check with Network Solutions".
Zog's ISP asks NetSol, "Where's foobar.com?"
Netsol says, "I know the answer, you want the www? Go to IP 266.266.266.5" (Yeah, yeah).
Zog's Firefox says "Okay...I know that www.foobar.com is 266.266.266.5" and goes there.

Pretty simple. Now here's where NetSol screwed up. When it made itself the active registrar for the domain, it SHOULD have been able to pick up the IP address records VERY quickly. After all, it's their system. It's not like with propagation where all the ISP's in the world try to keep a list of domain names and who knows all the mail, www, etc. individual records. Those only get updated once or twice a day or more, I don't know.

The point is that NetSol's "worldnic" nameservers should immediately know the answer to "where's the www IP?" Once you (or an ISP) starts looking there, it should know the answer. Propagation is about all the ISP's getting the right information. Propagation is NOT about their own nameservers not knowing how to answer the questions.

Using DNSStuff.com, another great site, tells me whats' going on. First, it says that I have "lame nameservers". Other than the obvious pun there, it means that the nameservers associated with my domain name do not answer authoritatively. What? Why don't they? Another test on the DNSStuff site tells me that the root servers say "Check NetSol nameserver A". Nameserver A says "No...check back with the root servers." The root servers say "Okay...check Nameserver B, then." Nameserver B says "Check back with the root servers." Being round-robin, the root servers tell us again, "look at Nameserver A". You can see where I'm going with this. DNSStuff.com says it stops automatically after 20 rounds of this crap.

I didn't expect to bring down the site, email, etc. today. But I did. And it's not my fault. I did everything right, but Network Solutions decided to screw it up. And then their technical support tries to tell me this is normal. Lies. Period. I've done this same thing with GoDaddy enough to know that once you change the nameservers, it should say SOMETHING. Maybe not what you set in the last five minutes, but something.

How long will the site be down? I don't know. The nice tech support man said that it could be 2 to 3 hours before it has the right information. And that I should expect this. Made me angry, but I was polite. Now I have a batch file running an ipconfig /flushdns and ping www.foobar.com loop running. It's been running the whole time I've been writing this, and for an hour and a half before. Let's call it about one hour and 45 minutes. And it's still not working.

As soon as I get this straightened out, I'm moving the domain name to GoDaddy, where domain names belong.

- Will Belden
September 14, 2007

Illudium PU-36 Code Generator and Matching table and column names...

2007-09-10T13:36:00.000-07:00

First, let me say that I love the Illudium PU-36 Code Generator. It has made my life a lot simpler, even when I find myself editing the xslt files to get code more like I want. But I truly cannot imagine life without it since Rob Gonda introduced me to it.

I will readily admit that I may not have the latest version. Once you start editing those xslt files, you kinda want to stick with it. But I ran into this issue today, and it took me a bit to figure it out. Here's the error:

Bean creation exception in com.model.vendorTypeA.vendorTypeAService
Cannot declare local variable vendorTypeA twice.:Local variables cannot
have the same names as parameters or other local variables.:
Line: -1

Obviously a line number of -1 isn't helping. It did tell me, though, that the object can't be created. This error, technically, is thrown by Coldspring, but has nothing to do with it.

The issue here is that I have a table called "vendorTypeA". It has a field called "vendorTypeA". This is bad. Here's the code portion, and it seems obvious, once you've been through this.

<cffunction name="createVendorTypeA" access="public" output="false" returntype="com.model.vendorTypeA.vendorTypeA">
<cfargument name="vendorTypeID_A" type="numeric" required="true" />
<cfargument name="vendorTypeA" type="string" required="false" />
<cfargument name="isActive" type="boolean" required="false" />

<cfset var vendorTypeA = createObject("component","com.model.vendorTypeA.vendorTypeA").init(argumentCollection=arguments) />
<cfreturn vendorTypeA />
</cffunction>

Note the two portions in bold, red. I have an argument of "vendorTypeA" and I'm trying to create a local variable of the same name. One is the field, the other is the object, which uses the table name as the object name. The easy solution here is to simply add "_obj" to the last two lines, as in:

<cfset var vendorTypeA_obj= createObject("component","com.model.vendorTypeA.vendorTypeA").init(argumentCollection=arguments) />
<cfreturn vendorTypeA_obj />

Problem solved. Now the object can be created, either "manually" or through Coldspring.

- Will Belden
September 10, 2007

SQL Server 2005, Views, Optimizing and UNION

2007-09-04T08:35:00.000-07:00

I'm not typically a SQL View fan. I know many who are, and their arguments are all completely valid. In fact, I'm not much of a trigger or stored procedure fan, even though I clearly understand the benefits. It's just a "I like to have my code in one place" kind of thing. Crazy, but there it is.

Well, I needed a view. It was a three table UNION'ed join and....I just needed it simpler than putting all that nasty SQL in my ColdFusion objects. However, my modeling tool, PowerDesigner (PD), isn't always great with views that have computed columns. This particular view was performing too slowly, so I set about to add some indexes to it. Because of the PD problem, the indexes couldn't be built through the modeler. So I'd have to write the index code manually. As I began looking for the code samples, I found this page:
Improving Performance with SQL Server 2005 Indexed Views

One of the things I found was that if you do a UNION'ed view, and you use the same table names again, you should use different table identifiers. For example:

BAD:
SELECT * FROM Table T WHERE T.type="A"
UNION
SELECT * FROM Table T WHERE T.type="B"

GOOD:
SELECT * FROM Table Ta WHERE Ta.type="A"
UNION
SELECT * FROM Table Tb WHERE Tb.type="B"

When I changed my view's code to have this style, the speed on it more than doubled. And I hadn't even done the indexes that I was planning. I will, though...you just watch!

- Will Belden
September 4, 2007

Server Mechanic game...

2006-10-23T11:53:00.000-07:00

This is a pretty cool gizmo game. Check it out!
http://digg.com/playable_web_games/Server_Mechanic/
Digg it, if you like it!

- Will Belden
October 23, 2006

ColdFusion MX 7, VMWare, VM Shared Folders, Win2003 and Model Glue: Unity

2006-10-01T06:34:00.000-07:00

I found myself using a VMWare workstation setup to run my CF7 server with IIS, JRun (Multiserver) configuration and SQL Server 2000 to handle development for a new project. I could have used my live production server, but wanted it to be completely separate as I am learning to use Model Glue as my framework.

Initially, I was simply doing an "upload" via Eclipse to the "server", but the Deployer plugin I use for Eclipse only allows a single file upload, no folders per round. I often modify four or more files at a time and quickly tired of picking each file, right clicking, choosing Upload, and hitting the spacebar to push the OK button on the "Overwrite...?" dialog. Times 4. Wore me out. ( I have never been able to get the builtin FTP of Eclipse to be my friend.)

So my next option was to see if I could use the Shared Folders feature to have the website setup in IIS point to that shared folder as the site. Then I could simply save the file after editing within Eclipse and click Refresh/Reload in the browser.

( I should note that the "shared folder" of which I speak is on the host machine. I wanted the VM "server" to see that folder on my real machine, as all my development code is on an external USB drive connected to my network. - WB)

Let me say this...the right combo can be a bit tricky. I think, honestly, more so because I didn't want the ColdSpring, Reactor and ModelGlue folders in the root, which means adding CF Mappings. (I wish there was another way to do this without adding mappings for the WHOLE server!!!)

Here was the solution that I came up with after much trial and error. (I had to reinstall the VM setup this morning and had to trial-and-error it until I got it right again because I didn't have my earlier successful attempt as a reference. (Blogging here means *I* can find it again if I need it...)

With the VM Workstation or higher, a "network share" looks like this:
\\.host\Shared Folders\MySite

Now you can map these to a drive letter, but don't even try it. Works fine for Windows in general, but not for IIS and CF mappings.

I buried the Reactor, ColdSpring and ModelGlue folders within [siteroot]\_system\, which meant adding those pesky mappings.

In the VM's IIS config, you set the Home Directory of the site to:
\\.host\Shared Folders\NewDevSite
...assuming your site is "NewDevSite", which I'm sure it isn't. You have to make sure that you have the radio button "A share located on another computer" checked first.

That allows IIS find the site itself. Then you have the ColdSpring globalConfig rootPath mapping in the ColdSpring.xml file:

\\.host\Shared Folders\NewDevSite\

And finally...the CF mappings:
\\.host\Shared Folders\NewDevSite\_system\ModelGlue

The problem was that I had [mis]remembered being able to use a mapped drive in IIS, but you cannot do this, at least I wasn't able to to that. I tried and tried, but to no avail.

Hope that helps someone out there!

- Will Belden
October 1, 2007

ColdFusion ColdSpring - Evaluate variables in ColdSpring.xml

2006-09-02T08:33:00.000-07:00

As part of my new implementation of ModelGlue:Unity, I found that I have to place the values of different things in many different places. In this situation, that was the applications datasource name, user ID and password. I dislike having more than one or two places to have to place values, in the event they need to change. (A good security policy for databases is to change those passwords every so often.)

In my ColdSpring's XML config file, I had attempted to place the following:

<bean id="oDatabase" class="com.oDatabase" >
<constructor-arg name="dbDatasource">
<value>#APPLICATION.dbName#</value>
</constructor-arg>
<constructor-arg name="dbUser">
<value>#APPLICATION.dbUser#</value>
</constructor-arg>
<constructor-arg name="dbPass">
<value>#APPLICATION.dbPass#</value>
</constructor-arg>
</bean>

However, this only resulted in a query error along the lines of a datasource not being found with a name of "#APPLICATION.dbName#".

Perhaps my solution to my need is not the best way, since I modified ColdSpring files directly. Perhaps there is even another way, but a couple hours of searching did not reveal the answer to me. I thought "there has to be a way to tell CS to evaluate the XML value entry instead of just seeing it as a literal string."

I opened DefaultXMLBeanFactory.cfc in the /coldspring/beans/ directory and modified the "constructBean" function. There are two places you'll find this line, one in a regular bean function setup, I believe, and the other specifically for init() functions.

<cfinvokeargument name="#argDefs[arg].getArgumentName()#" value="#argDefs[arg].getValue()#"/>

I replaced that line with this block:

<cfset VARIABLES.csTempEval = argDefs[arg].getValue() />
<cfif FindNoCase("~~~", VARIABLES.csTempEval) GT 0>
<cfset VARIABLES.csTempEval = mid(VARIABLES.csTempEval, 4, 999999) />
<cfset VARIABLES.csTempEval = Evaluate(VARIABLES.csTempEval) />
</cfif>
<cfinvokeargument name="#argDefs[arg].getArgumentName()#" value="#VARIABLES.csTempEval#"/>

In my ColdSpring XML config file, I changed the section above to look like this:

<bean id="oDatabase" class="com.oDatabase" >
<constructor-arg name="dbDatasource">
<value>~~~#APPLICATION.dbName#</value>
</constructor-arg>
<constructor-arg name="dbUser">
<value>~~~#APPLICATION.dbUser#</value>
</constructor-arg>
<constructor-arg name="dbPass">
<value>~~~#APPLICATION.dbPass#</value>
</constructor-arg>
</bean>

Voila! Now my ColdSpring dynamically evaluates APPLICATION.dbName instead of trying to use it as a literal. It will only do this is the tag has the three tildes (~~~) at the front. Obviously, you can modify it to do it with any character combination you find more appealing. I would avoid anything too crazy, or anything you might actually want as a true value down the road. I considered having the changes look for anything beginning and ending with "#" characters but that would eliminate the ability for more complex combinations, if needed, such as "myTest_v#APPLICATION.version#" where it evaluates to "myTest_v01" or similar.

If anyone out there knows of a more ColdSpring acceptable way (that I was unable to find), please let me know. Of course, I made a backup of the original CFC in the event that someone brings it to my attention!

Will Belden,
September 9, 2006

ColdFusion - Crazy Error

2006-09-01T07:31:00.000-07:00

While coding today, I received the following error:

"The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values."

After my initial bafflement, it occurred to me that the problem wasn't where it was saying it was, in a call to the CFC, but rather in the CFC function itself. I had specified a function returntype of "numeric", but had neglected to setup to return anything at all. Even when I modified the call to the function to not accept a return, as in:
myFunctionCall(parm1=value1, parm2=value2) ;
instead of
myRetVal = myFunctionCall(parm1=value1, parm2=value2) ;

... it still didn't work and threw the same error.

Hopefully, if you're having this problem, and search on some of that text, you'll end up here with a search and save yourself some headache!

Will Belden
September 1st, 2006

Not your Personal Conveyance

2006-02-22T05:10:00.000-08:00

You've seen it. Likely every day if you commute to and from work daily, anyway. A lone shopping cart, often on it's side, at the entrance to some apartment complex. Sometimes you'll even see the (apparently vehicle-less) individual or family pushing it along, full of their groceries.

This...irritates...me...to...no...end. I can understand needing to purchase groceries. I can understand not having a vehicle. I can even fathom being too weak to carry everything you need. But I cannot comprehend, condone or even conceive of "stealing" a shopping cart to take your purchased goods back to your dwelling.

Why do people do this? Pure laziness, in my opinion. If you don't have a car, then when you walk to and from the grocery store you need to buy less. Certainly no more than you can carry from point A to point B, whether that distance covers a quarter of a mile or three miles.

That shopping cart does not belong to you! It's not yours. That store paid good money for that cart and has to maintain it, clean it, repair it and replace it when it goes missing. What makes you think you can just run off with it?

Now, to my detractors who think to holler about "poor" and "indigent" or whatever words you want to synonimize with "lazy" -- don't, okay? I have been without transportation in the past and I have never STOLEN a grocery cart. And to be honest, I wouldn't have as much a problem with this concept if it was returned to the store! I'm not above borrowing, but you've got to return the thing. Now its missing from the store so that when I make a 5:00 pm run to the store to pick up a handful of things and the store is crowded -- I have nothing to use. Leaving it at a hotel parking lot, the entrance to your apartment complex or beside the road is an unsightly blot on my view. It makes everyone who lives in that area look like trailer trash.

Don't buy more than you can carry, get someone to give you a ride back home, grow your own food, whatever. Quit stealing the shopping carts! It's NOT your personal conveyance.

Will Belden
February 22, 2006

Customer Service Apologies -- UGH!

2005-11-10T06:12:00.000-08:00

At one point or another we've all needed to contact a vendor's customer serivce department to correct some sort of billing issue or arrange for something to be replaced, corrected or otherwise handled. Invariably, it's a "complaint" of sorts that prompts your call. (After all, how many of us call to say "Good Job, Mr. Vendor"?)

We are taught as kids that it's not good enough to say "I'm sorry", but rather the apology needs to be indicative of admitting a wrong doing, with the intention of not doing it again. When a customer service representative says, over and over, "I apologize for that, Mr. Belden" they are not indicating that they are truly sorry. After all, this particular individual probably had nothing to do with the problem that I'm calling about. Secondly, they aren't making that implied promise of handling the situation better in the future. How can they? They aren't a decision-making individual within their company.

I think I would find it more satisfactory if they just said "I can understand your frustration, Mr. Belden." This would make far more sense, imply an empathy (that of course they don't possess) and save me the grief of having to say, after their tenth apology, "Please stop apologizing and let's just get it corrected." To which I typically expect them to say, "I'm sorry for all the apologies, Mr. Belden."

I'm sure all this is laid out in the "Vendor's Guide to Handling Customer Complaints" or whatever little green book that they give all the $4.00/hr customer service call center employees. I think one of the difficulties I have is that I don't care much for following other people's guidelines, but rather feel I am appropriately intelligent to handle the situation well without a script to follow. (Hence I never joined the military!)

Anyway...a short rant about why I despise calling any customer service center. I also would rather pull my fingernails out than call because I'm pretty sure, from the moment I dial the phone, that whatever I have to be calling about probably won't be fixed anyway. My typical pessimism at work, mind you!

Will Belden
November 10, 2005

The Beauty of Irfanview...

2005-08-09T07:18:00.000-07:00

I read a blog post today about Macromedia not including Freehand in their latest product package, Studio 8. the author indicated that he had used Freehand in the past, rarely, to open Illustrator files. Reading this, it occurred to me that the free graphic viewer Irfanview is one of my favorite pieces of software.

Here are some of the reasons I love this program so much:

It's free.

It can open almost ANY image, including Photoshop, Illustrator, .gif, .jpg, .png, etc. (Be sure to get the plugins...)

It can open almost ANY video files, including .mpg, .avi, etc...

You can do basic operations such as pasting in a screenshot and saving. You can crop, resize, resample, reduce colors or go to grayscale (I often do this when pasting a screenshot into email to minimize message size and bandwidth usage.)

It has support for basic effects, but also lets you use Adobe .8BF filters, too!

Did I mention it's free? If not, it's free!

It's updated frequently. I had v3.95 on my machine when I started this, but found that v3.97 was available. (I updated immediately...!)

It can whip out thumbnails for a whole directory for quick viewing super fast. Very useful to find a file you seek quickly.

You can defined an external editor per file type. I have my image files (all types) associated with Irfanview. When I double click a .psd file, it opens there and shows me if it's the file I think it is. Then I can hit SHIFT+E and it opens in Adobe. But I was able to determine if it was the file I was looking for without having to actually load Photoshop.

If you haven't ever used this little program I highly recommend downloading it and trying it. You have nothing to lose, but you might find you'll wonder how you ever lived without it!

- Will Belden
August 9, 2005

Shopping Carts and the Lazy People Who Use Them

2005-07-29T11:43:00.000-07:00

When I was in high school in Sugar Land (a suburb of Houston, Texas), like many others, I worked at a grocery store. I was a sacker, then later a checker. One of the funnest jobs I've had really. Of course one of the duties of the sackers wasn't just to put your groceries into the bag and take them out, but also to collect the carts from the parking lot. At the time, it didn't really bother me that shoppers would go, unload the cart into their car, and then just push the cart onto the grass sections or other areas of the parking lot. No biggie, it gave me something to do. At the time, however, I did not own a car.

As an adult, I don't know if there's anything that bothers me more than people who do this. It is probably my biggest pet peeve. The reason it bothers me so much is because people are super lazy. Most stores place a little section multiple places in the lot where you can place the cart into it, and it has a lip to keep them from rolling back out amongst the parked vehicles. I have watched people who are parked just across the aisle from the cart return areas and still not put the cart there.

It's begun to bother me more recently. We've all heard the stories of the "runaway carts" that invariably put a dent in someone vehicle. My mother-in-law, Linda, had it happen to her at Wal-Mart. Some lazy shopper just couldn't find the time or take the effort required to put the cart away and left in a place that it could roll into Linda's car. She has a nice new Toyota hybrid that she very much loves, but it now has a HUGE dent in the door. Most people love the cars they have. Most people take care of it. The individual who let the cart roll probably has a 2005 Cadillac that they would be very upset to see a scratch on, but don't give another thought to the people who could be affected by their carelessness.

I see people leaving the cart just whereever, but I don't have what it takes to say something to them. I'm certainly not going to leave my ice cream to melt and go gather them up and put them away, either. But I always put my own cart away. If it's a smaller store that doesn't have a cart return gizmo in the lot, I take it in.

Shame on Wal-Mart, too. I can see them saying "Uh, look...we can't be responsible for that." And I agree. However, when Linda talked to the store about it, they actually told her they would take care of the cost. When she told my wife and I this, we couldn't believe. "Kudos for Wal-Mart" I exclaimed. I asked her about it roughly two weeks later and she told me that Wal-Mart changed their mind and were not going to cover the cost. BOO on Wal-Mart! If they had told her no upfront, that's understandable, but to let Linda believe they were going to pay for it, then dash the hopes...well....that's just piss-poor customer service.

The worst part is that you, for something you didn't even have anything to do with, can't really report it to your insurance company because that will just raise your rates. So what happens? You're disgusted every time you go to your car and see the big dent.

All because some lazy, irresponsible, selfish shopper couldn't take 15 seconds to walk the cart to the return area.

PUT YOUR DAMN CART AWAY! Maybe I'll start saying something to people. Maybe I'll politely ask them to put their cart away. Maybe, while they are getting into their car, I'll walk in front of them, grab the cart, scowl and put it where it belongs. Maybe I'll just get angrier. Maybe I won't do anything. But you can bet I'm "ranting" about it here. This is the primary reason I started this blog, so I could complain (out loud) about lazy people and their runaway shopping carts.

- Will Belden
July 29,2005

Sometimes I really hate people. (In cars...)

2005-07-25T12:27:00.000-07:00

Any of you who are familiar with me may know that my wife and I are training for the MS 150 Bike Tour. It's 75 miles from St. Augustine to Daytona Beach, FL on one day then back the second day. It'll be grueling for someone like me...a bit out of shape.

Part of this training is actually riding the bike for long distances. (Go figure...) This past weekend, we did 30 miles on Saturday morning, then another 30 again on Sunday. While it's great that Ponte Vedra has some good distances of running/biking trails, they don't go the whole distance that we need to train on. Past that, there's a good length of "HOV" lane, reserved for bikers. But it, too, runs out before the mileage we need to cover. At that point, we're on A1A, riding with traffic.

On Sunday, the roads were still wet from rain the night before. Puddles were everywhere, and so getting a bit wet and muddy was a given. However, I wasn't prepared for what happened to us.

We were riding along, and a white or silver Nissan 280Z honked at us, and then deliberately hit a puddle to splash us. At first I wasn't sure this was the case, but another biker who had passed us and stopped on the road further up had exactly the same thing happen to her. As a guy, I can understand wanting to do that. Guys are mischievious and sometimes bad mannered. But there is a BIG difference between thinking about it and actually doing it.

What prompted the title of this posting is that it's really sad that many people, especially people in cars, have no social conscience whatsoever. People do things in cars they would never consider doing on foot. Like speeding up, running you out of your lane so they can cut in front of you or flipping you off as they pass by. Apparently being in a moving vehicle afford a feeling of anonymity that you can partake of to do as you please, regardless of the consequences to others.
My advice of the day.... THINK about others when you're driving.

- Will Belden
July 25, 2005