I tend to focus on development topics of late. Specifically ColdFusion/Railo, Coldbox Framework, SQL Server and Eclipse.
Saturday, April 13, 2013
UltraEdit -- Syntax Highlighting not Working (How to fix)
With the last few versions of UltraEdit (up to v19 as of this writing) on my home machine (but not another machine I use UltraEdit on daily), my Coldfusion files would not correctly highlight upon opening.
There were two symptoms:
1. CFM files would highlight, but not CFC files.
2. The CFM file highlighting seemed "off" somehow.
Turns out the two symptoms had two causes:
1. The "cfm" file extension was associated with the HTML wordfile
2. The line terminators were wrong on the Coldfusion wordfile.
Steps to corret:
1. Removed the CFM extension from the HTML wordfile.
2. On the Coldfusion wordfile, which did have the CFM and CFC extensions, I had to convert the file.
On the Coldfusion wordfile, after opening, I could see "UNIX" in the status bar:
As of UltraEdit v19, you change this by choosing:
File > Conversions > Unix/Mac to DOS
You get a dialog about "can't undo", just choose "OK".
I had a CFC file open in another editor tab. As soon as I saved the converted Wordfile, it automatically picked up the syntax highlighting. Yay.
I found the original information on how to correct here, but it mentions hitting F12, but that might be old. Use the steps above with "Conversion" to properly correct.
http://www.ultraedit.com/support/tutorials_power_tips/ultraedit/add_a_wordfile.html
- WIll Belden
April 13, 2013
Sunday, October 07, 2012
Customer Service / Phone Menus
When you begin to wade through the phone menu, one of the first things the system does is ask you for your wireless phone number and then the last four digits of the account holder's Social Security number. After sitting on hold for however long, what's the first thing the representative asks you? They ask you for your wireless number and the last four of your SSN. What *is* the point of entering it in the first place?
After I finished what I needed, I had a question about a (basically bogus) feature on my plan called "International Calling - Expanded". The rep indicated she should transfer to me another department to get more information. Okay, fine. I have no problem with that.
I get to the next department and, sure enough, the system asks for my wireless number and last four SSN digits. And, sure as the sun rises in the east, the rep asks me for the same information again.
This definitely falls under my blog's title of "rants". I don't mind that the system asks me for it and I don't mind that the representative on the phone asks for it. But pick one!
AT&T isn't the only vendor that does this either. I would say that 85% of all vendors I deal with on the phone, that have phone menus, do exactly the same thing.
It's not so much that it's a waste of time (which is actually is), but it's just plain annoying and shows no respect for the customer's time.
- Will Belden
October 7, 2012
Thursday, June 14, 2012
(Possible) Tool for managing Scottrade Portfolios (not OFX)
I am Scottrade customer. I have a bad habit (maybe) of wanting to watch my portfolio. Now, I'm in it for the long haul, meaning I don't really do day trading or even monthly trading. We usually put funds into my wife's IRA account at tax time for the deductions or, if we have some spare cash, into our joint non-retirement account.
I, too, also have an IRA account and sometimes use dividend payment amounts to purchase new stocks within the account. But now that I have a 401K at work, any contributions I make to the account (if allowed at all) are not tax-deductible. You can't contribute to both a 401K and an IRA. Why would you, really, when a 401K has much higher contribution limits (and typically, employer matching) than does a self-managed IRA? However, please take any tax-related information I provide with a grain of salt and do your own research. I am not a CPA.
For a long time, I used Google Portfolios to watch my stocks and ETF's. However, I became extremely frustrated with the limitations of their system. I love Google, don't get me wrong, but Google Portfolios just doesn't provide what I want. (And who can really complain? It's free, after all.) Here are some of the areas that I wanted improved, but haven't seen:
- They offer imports OFX and CSV, but they don't work very well.Best I can tell, Scottrade doesn't provide an export to OFX. Scottrade only offers CSV exports from your account history.
- Their OFX import isn't perfect and can't handle all transactions types.
(I went through many downloads and trial installations of CSV-to-OFX software (paid and free) just to end up more frustrated than when I started in the first place.) I attempted to import a three-line Scottrade account history CSV export containing three dividend payments. The "Preview Import" seems to show them, but once you commit, you just get: "Some transactions in this portfolio are invalid. Edit transactions to correct errors." with Google Portfolios. - Google Portoflios cares pretty much nothing about dividends.Why does this matter?
- Dividends affect account cash balances.
- To me, dividends are a part of performance. (A $10 purchase of a stock now at $20 a share, that's 100% growth. But if you also received another $100 in dividends, wouldn't you say that stock is performing better than another stock at the same purchase/growth that hasn't paid any dividends?)
- To be fair, I think you can enter dividends (or at least cash transactions) manually. But who wants that.
- I can pretty much guarantee you that every brokerage's data exports are going to be different.
So, I can understand Google needing to make things a bit generic. I use Scottrade and am going to continue to use Scottrade for the forseeable future, so that's where my focus is. If Scottrade puts "CASH" as a ticker symbol in the export, I need to be able to deal with it. - I have multiple accounts I manage.
With my IRA, my wife's IRA and our joint non-retirement account, I want to see three different account cash balances but I want to see performance of all three accounts as a combined portfolio. (And perhaps each account individually, too.) There are some stocks that we own that we have purchased by different accounts. So I might have 10 shares of (F)ord in my IRA and another 30 in our joint account. - More things I can't think of offhand.
It wasn't just Google that had incompatibilities with my needs. It was pretty much every other free online or downloadable portfolio manager I tried.
Here are some features I've included:
- Security
There is never a need to provide your login information for Scottrade to us. You don't want to, we don't want you to. You handle the exports from Scottrade manually. (Perhaps later we'll add an API call (if Scottrade makes that possible in the future) or some sort of screen scraping. Personally, I'd like to have the system check my Scottrade accounts one or two times a day. I'd like to see Scottrade offer some sort of public-key API that lets a service pull transactions, but never, ever be able to modify anything about the account. That'd be swell!) - Account Creation
If you're like me, and have multiple accounts, you can create those accounts, with any label you want. It is not necessary to reveal your Scottrade account number to the site. - Transaction Import:
- Positions Report
This is the screen you'll look at most of the time. Shows all your stocks, the semi-current values of each stock, what type it is (Stock, ETF, etc.) and all the values regarding investment, unrealized value, growth, growth with dividend, dividends total, average dividend, etc. The page can be set with a customizable refresh time (15 minutes at a minimum or more) so that if you keep the page open in your browser, it will automatically update all the values as the stock prices change. (The stock prices are updated every 15 minutes, so any refresh on the report less than that is a waste of bandwidth and webserver processing because there will be no difference shown most of the time.)
- A "slim" version of the Positions Report
My wife and I like to be able to see the report on our customized Google home pages, too. There are a couple different Google page "gadgets" that allow for an iframe tag to pull content from another site. In the slim view, the totals are at the top to avoid scrolling.
- Stock quote updates via Google API every 15 minutes during market hoursThis system isn't meant to be realtime. It's meant to give you an idea of how things look in your portfolio. It answers "Am I up?", "How much am I down?" and "How's my portolio doing?" in a rough fashion. If you need more detailed and much quicker information, try the Java app that Scottrade provides after meeting minimum account balance criteria.
- Daily Closing Balance retrievals
After the market closes each day, the system automatically looks at all the stocks ticker symbols it knows about (assuming some account has an active positions for it) and retrieves the balance for each and stores in our history. Also, if I were to import a new stock that I purchased, they system will go to the earliest transaction date I imported and retrieve all possible history for that stock from that date through today. - History Charts (incomplete)
The Daily Closing Balance retrievals are important to create stock position graphs. The feature is not yet complete (drawing the charts, etc.), but will allow you to filter by one or more of your available accounts and by a given date range. I also intend to allow multiple chart line comparisons (limit five stocks) for a given date range. Charts would be available by most of the value fields such as by growth, growth with dividend, dividend totals, etc.
I hope this gives you an idea of what I've developed and where I'd like to go with it. If there's enough interest by folks wanting to use the site to view their own Scottrade portfolios I'd like to continue my development and allow a few beta testers to sign up and work out the kinks once the security model is firmly in place and has passed my own QA process.
Long term, I'd like to make it a free-mium type site. Free accounts would be limited to a single brokerage account and probably less-frequent data refreshes, such as 30 or 45 minutes instead of a 15 minute minimum. Still functional, highly useful, but just, well, free users would hammer the server a lot less and utilizes less bandwidth. The likely price-point would be around $8-10/month or $80-100/year (shaving off two months cost for a yearly purchase). Another option would be to offer a certain time frame (probably 30 days) free to let folks see how great it is.
In addition, once the Scottrade portion is complete and running bug-free we could begin to offer support for other brokerage houses if people feel like what they get with other tools or a given brokerage's built in tools doesn't meet their needs.
Wednesday, March 02, 2011
CSS Trick for HTML5, Edit CSS inline for the page
Check it out for yourself:
http://css-tricks.com/show-
Wednesday, June 02, 2010
Very cool Javascript debugging trick (Firefox, Javascript)
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
Saturday, August 22, 2009
Gmail Notifier -- Wasn't working, here's the fix...
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
Tuesday, May 19, 2009
Better Javascript in Coldfusion
- 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?)
May 19, 2009
Updated: August 22, 2009
Monday, March 16, 2009
SQL Server Error: Dynamic SQL and 'you must declare scalar variable @whatever'
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
Wednesday, February 11, 2009
Trillian Astra -- Awesome hidden feature
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!
Monday, November 17, 2008
Implementing Transfer Observers across all your decorators, the easy way!
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
Tuesday, November 11, 2008
How to reintegrate SVN branch back to trunk using Tortoise
Now, these steps below do not include manually merging any changes. I was fortunate enough in this first exercise to have auto-merge ability for my changes to shared files and all my other files were new.
(Be sure you have any files saved and closed, like edits in Eclipse.)
1. Commit your branch back to the repo.
2. IMPORTANT! Export your branch for backup. Quick way: Make sure you can see your desktop, open a window that shows your root branched folder (in my case, "wwwroot"), right-drag it to your desktop, choose "Export here". Ignore this new export folder from here, unless you have problems.)
3. Right click on your branched folder ("wwwroot" again for me), choose "Merge" from the Tortoise submenu.
4. On the Merge screen that comes up, choose the first option: "Merge a range of revisions". Click "Next".
5. Change the "URL to merge from" to the trunk path. Leave the "Revision range to merge" field empty to bring the HEAD changes to you. (This example is assuming that the trunk has received commits after you branched and committed changes to your branch.) Click "Next" (or test merge to see what will happen).
6. Resolve any conflicts you might have, if this applies to your example.
7. You have now brought the latest trunk changes, and integrated them into your branch, bringing your branch up to date. Your branch now contains the most current commits to the trunk, as well as your branch's deviated changes.
8. Now, with the branch containing trunk changes, you need to re-commit your branch to SVN. Do this now.
9. Now, do an update on your branch, just to be sure. You should receive no updates, but this will ensure the metadata is up to date.
10. Next, do a "switch" on your folder, back to the trunk counterpart. This is in in the Tortoise submenu after right-clicking your branched folder. This allows you to merge the changes from your branch into your working copy of trunk, so that you can commit the branch-to-trunk merge back to SVN. (Earlier you brought the latest trunk changes to your branch, the opposite.)
11. After the switch is complete, go ahead and do an update.
12. Right click on your [trunk] folder, choose Merge from the submenu.
13. Choose "Reintegrate a branch" then click "Next".
14. Change, if needed, the "From URL:" dropdown to the branch SVN location.
Tuesday, November 04, 2008
FancyBox, jQuery and z-index
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
Wednesday, June 18, 2008
Losing my mind with a form...
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
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
Tuesday, March 25, 2008
Eclipse and getting .htm and .html files to open in CFEclipse...
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
Thursday, March 20, 2008
ColdBox Framework, Filename Incorrect error I keep getting...
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
Friday, December 28, 2007
SQL, WHERE clause vs. JOIN clause conditions...
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
Wednesday, October 03, 2007
Apache and Local vs. Remote on the same network...
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
Friday, September 14, 2007
Network Solutions, Nameservers and DNS work...
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.
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
Monday, September 10, 2007
Illudium PU-36 Code Generator and Matching table and column names...
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
Tuesday, September 04, 2007
SQL Server 2005, Views, Optimizing and UNION
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



