Category: Debugging

FireFox 3 has Infinet Loop Protection

I had to write a conversion utility to move an old database contained a few hundred thousand records from MySQL to MSSQL, making the structure more normalized and running some calculations, bla bla bla. In my need to bang this out quickly and since it was a one time throw it away app I wrote a quick ColdFusion script to do the transformation for me and save some time.

I decided to run in blocks and do a CFLOCATION at the bottom of the page, essentially creating on the fly pagination of my work.

Well as an FWI for developers, if FireFox redirects too many times you get a nice phat error... Not really a huge deal and nothing we ever have to worry about with a normal application; but this is something I had never run into before having always been an IE guy before FF3 beta...

1 comments - Posted by Russell Brown at 3:16 PM - Categories: ColdFusion | Debugging | Development

Running Multiple Versions of Firefox

Having recently switched to using Firefox and having always complained about Microsoft's PIA move by making it so difficult to run multiple version of IE at one, I was suprised to find that FireFox has the same stupid issue. Fire fox uses the same default non segrated profile path for every version.

The Fix (same idea for win and mac I believe):

Run c:\{your Firefox path}\firefox -profilemanager -no-remote

Create a 2 new profiles, I called mine FireFox3Rc1 and Firefox2. Use alpha-numeric and stay away from spaces. Once you've created them go ahead and exit.

Now you must modify the shortcuts for firefox, respectfully.

c:\{FF2 Path}firefox.exe -P FireFox3 -no-remote
c:\{FF3 Path}firefox.exe -P FireFox3RC1 -no-remote

Technically there is no need to change profiles for both FF version. But I'm assuming I'll even have a 3rd version here of FF3 soon and I hate using default profile paths...

Read more...

1 comments - Posted by Russell Brown at 3:06 PM - Categories: Debugging | Development

Wow, sorry for the feed dump!

Due to server and software changes my blog paths were no longer the same and I stopped getting aggregated by Adobe Feed/MXNA. I ignored this aside from an email that didn't get me anywhere; until this afternoon. With the new feeds software the feeds list actualy worked and I found out what URL Adobe was looking for my feed at. A quick 301 error inside a cfif tag fixed my problems...

Unfortunetly the result was ALL of my posts showing up in Adobe feeds at the top all at once. For this I apologize, I had figuered it would go off my modified or posted date, not when it read it for the first time...

<cfif url.event EQ "showBlogRss">
    <cfheader statuscode="301" statustext="Moved Permanently">
    <cfheader
          name="Location"
          value="http://www.EmpireGPServices.com/blog/feeds/rss.cfm"
    />
    <cfabort>
</cfif>

1 comments - Posted by Russell Brown at 4:27 PM - Categories: ColdFusion | Debugging | Development | General News

Are all your CFC variables Scoped? Find Out!

I was reading Ray Camden's blog and my interest got peeked by his post on a CF app called varScoper. I downloaded the app from RIA Forge and had it parse my MachBug's source code within about 30 seconds. Depsite how meteculous I try to be with my scoping I was suprised when I found almost a dozen fumbles in my ruffly 320 cffunctions spread across 39 CFC files.

I had never thought of whipping something like this up, but this would be fantastic rehashed as an Eclipse plugin...

Untill then, I definetly recomend you check out this helper app (varScoper).

1 comments - Posted by Russell Brown at 1:04 PM - Categories: ColdFusion | Debugging | Reviews | Development

How to find a table based on a column name

I've been asked how to do this about a dozen times by developers who were not very entrenched with SQL and I've had to do it my self a handful of times.

I know the column name (or at least part of it) but I have no idea what table in this massive DB it lives in; how do I find it?

A simple query will net you the results you need:

SELECT
    so.name AS [Table], sc.name AS [Column],
    so.xType AS [Table Type], st.name AS [Data Type]
FROM dbo.syscolumns AS sc
    LEFT JOIN dbo.sysobjects AS so
        ON so.id = sc.id
    LEFT JOIN dbo.systypes AS st
        ON st.xtype = sc.xType
WHERE sc.name LIKE '%Partial Column Name Here%'
ORDER BY so.xType, so.name, sc.name

Read more...

0 comments - Posted by Russell Brown at 11:31 AM - Categories: Debugging | SQL | Development

How-to: Windows Debugging Tools to analyze a crash dump

Every now and then I need to analyze a BSOD dump and have to look up a how-to each time. I found this nice little how-to on analyzing BSOD crash dumps with Windows Debugging Tools randomly and decided to blog/bookmark it for a later time from The Back Room Tech.

0 comments - Posted by Russell Brown at 8:05 AM - Categories: Debugging | Development