Entries Tagged as 'Gotchas'

Adobe LifeCycle Designer and Tab Order A.K.A. Tab Index

Adobe LifeCycle , Gotchas , IDEs , Tips and Tricks No Comments »

I was creating a PDF form using Adobe LifeCycle Designer to collect some data from external users to be sent back for processing via ColdFusion.

Whilst doing so I came across a task that I thought would have been quite trivial / easy but I found it not to be that obvious so again in leiu of my last post I hope this saves someone from digging around to get the answer!

Firstly, I did what any other user would do in my situation and hit the F1 key to access the help.  My search results for "Tab Index" were proving unsuccessful until I discovered that LifeCycle refers to it as "Tab Order".  This made a huge difference and I was able to hone straight into the material I was after and was pleasantly surprised.

Anyway, in a nutshell here's what to do:

From the menu, select "View > Tab Order" - obvious I know but not really when you're looking through the object properties trying to find the damn thing!

The follow these steps:

  1. Hold Shift then click the object you want to be 1st with the left mouse button
  2. Click the remaining fields in order.  There is a number in the top left which represents the current order.  This should change as you click.
  3. When complete, select "View > Tab Order" again from the menu to return to edit mode.

And that's that.

On the upside, I found the Tab Order functionality above quite easy and intuitive to use and also saved me from having to manually update some property of each and every object in the form, of which I had approx. 60.

Here's a link to a video from Adobe TV which also shows the same process for Adobe Acrobat Pro.



Bookmark and Share

IE 8, Excel 2010 not opening content on Windows 7

ColdFusion , Gotchas , MS Office , Tips and Tricks No Comments »

Thought I'd dust the cobwebs off my blog by sharing something I came across today...

I came across an issue where a user reported that a web application was not opening Excel content they were requesting.

Basically the application was sending csv formatted text to the browser and the browser (Internet Explorer) was supposed to open this with Microsoft Excel 2010.

The template sending the content had the correct headers configured to instruct the browser to open this in Microsoft Excel and the content was valid but for some reason the new window was failing silently without promting the user to open \ save the file.  The only clue was that this was a new PC with Windows 7 and Internet Explorer 8 installed and their previous PC worked fine.

I decided to check with Firefox and voila - I was prompted to Open / Save the file.

So after diagnosing different scenarios through the code I then started looking into the settings on the PC for Internet Explorer.


neo-cron.xml corruption issue

ColdFusion , Gotchas , Misc , Server and Hosting 8 Comments »

After New Years - we returned to a sickly server, and something I never came across before - so I thought I'd share this with you all!


Our servers are deployed as Multiple J2EE Instances runnng the latest version of ColdFusion 9.0.1.

When we tried accessing one particular application, we got the following error:

The Cron service is not available.  
This exception is usually caused by service startup failure. Please check your server configuration.

Don't be fooled by the error message, the real issue lies in a corrupted server file.

Turns out the neo-cron.xml file was corrupted.


Microsoft TSQL and the GO Statement

Gotchas , SQL , Tips and Tricks No Comments »

Recently I was working on some SQL scripts using TSQL in SQL Server Management Studio and from force of habit I was using the "GO" statement between each of my SQL statements to seperate them.

I then started re-factoring the SQL, creating variables where I had hardcoded values etc. and placed those variable declarations at the top of the script.

After re-factoring, I executed the scipt and got an error message saying that the variable @varName was not defined? 

I checked for any typos...none.  I then started breaking down the script to see if I could isolate the issue.  When I removed the "GO" statements, the script executed without error.

It turns out that "GO" is not a TSQL statement, but rather a command that is recognised by the sqlcmd and osql utilities and SQL Server Management Studio.  These utilities interpret the "GO" statement as a signal that it should send the current batch of TSQL statements to an instance of SQL Server.  Therefore any variables declared before the last "GO" and the next will NOT be available in the current batch of statements. 

Just for fun I then copied my TSQL into a <cfquery> and when I executed this, found that the same error was thrown.

One to watch out for if you're not familiar with the true definition of the "GO" statement. 

Full details of the "GO" statement can be found here: http://msdn.microsoft.com/en-US/library/ms188037(v=SQL.90).aspx

Bookmark and Share

<cfhttp/> Connection Failure

ColdFusion , Gotchas , IIS , Misc , Server and Hosting 1 Comment »

I was working on calling a remote template via <cfhttp /> recently and was experiencing a Connection Failure Error.

Scratching my head I proceeded to inspect what was going on in my code and on the wire with Firebug. 

At first I thought I had resolved the issue when I discovered my return type was a complex value (struct) but my elation was quickly drowned by the "CTRL+F5" key combination :-(

Without any luck I decided to consult the WWW.

After a quick search I discovered that it was due to the reponse being Compressed from IIS.  Apparantly the HTTPCompression algorithm used by some versions of IIS is incompatible with ColdFusion (Java).


The work-around was to specify additional HTTP Headers telling IIS _NOT_ to use compression for that response.  See below...

    result="remoteCallResult" >
        <cfhttpparam type="header" name="Accept-Encoding" value="deflate;q=0" />
        <cfhttpparam type="header" name="TE" value="deflate;q=0" />



    result="remoteCallResult" >
        <cfhttpparam type="header" name="Accept-Encoding" value="*" />
        <cfhttpparam type="header" name="TE" value="deflate;q=0" />


That should do the trick!

Credit and a more detailed breakdown of this can be found at Steve Erat's Blog

Bookmark and Share
Powered by Mango Blog. Design and Icons by N.Design Studio
RSS Feeds