Thursday, December 8, 2011

Error - CFForm, CFDiv, ColdFusion.Navigate, AJAX, and input="button"

I was killing myself trying to figure out what was going wrong here.  I had a cfform inside a cfdiv that was refreshing the entire page instead of refreshing through AJAX.  The idea was that a button was going to be used for the submit action, which would call a js function to use cfnavigte to refresh the cfdiv.  It went something like this.

<cfdiv id="refreshdiv">
     <cfform name="refreshform">
          <input type="hidden" value="#thatvalue#" name="valuetoupdate">
          <input type="button" src="images/mybutton.jpg" onClick="refreshfunction('refreshform')" />
     </cfform>
</cfdiv>

Javascript:

function refreshfunction(form) {
coldfusion.navigate(http://....../update.cfm,'refreshdiv',null,null,Post,form);
};

In any other case, that would submit the form and cause an AJAX refresh of just the div leaving any content before or after unaffected.  The example though refreshes the entire page.

I finally pieced this apart to realize that type="button" is the culprit.  I switched to a regular img tag instead of the input tag and it worked fine.  Maybe that's common knowledge, but I had no idea.  What a PITA.

Friday, November 18, 2011

SAS Error "Width specified for format F is invalid."

I came across the SAS error "ERROR: Width specified for format F is invalid." As that provides absolutely no hint as to what the actual problem is, it took me forever to figure it out.

What I've determined is it's a result of importing a file using proc import. Apparently there is some variable SAS doesn't like in that file (if you know exactly why, I'm all ears).

The solution is to write a "format _all_;" statement in a data step for the file before anything else is done to it. Something like this:

proc import datafile="your file" out=mydataset replace;
run;

data mydataset;
set mydataset;
format _all_;
run;

I hope it helps!

Inspiration

There are so many things I come across where the answers on the internet are either incredibly difficult to find or misleading. Sometimes the answer isn't there at all. So, here is my attempt to share some knowledge with the world. It will be random, from ColdFusion to automotive repair to photography and probably lots more, but hopefully it will be that one answer someone needs.

My inspiration: http://xkcd.com/979/