Archive for 2008 » Page 4

Well today was interesting – I had my appointment this morning at the San Francisco Italian Consulate to apply for my citizenship. I used Google Maps street view to recognize the building before my brother, dad and I drove up to San Francisco but still managed to drive by it not paying attention. [...]

Thanks to a tip from Elliott Sprehn on the Transfer list, I installed Java 1.6 u10 RC on my laptop to see how my Model-Glue/Transfer/Coldspring application performed with the JRE ClassLoader bug fixed. I’ve gotten in the habit of simply restarting my CF instance rather than reinitialize my application because it’s been faster in [...]

Next Tuesday at 11am I will enter the Italian Consulate in San Francisco to apply to become a citizen of Italy. My brother is flying in from Florida and my Dad is coming down from Northern California to also apply. I have been working on it for several years now at a leisurely [...]

As I mentioned in my last post, there has been a fast-moving SQL Injection script targeting many ColdFusion sites around the web lately that relies on SQL queries unprotected by CFQUERYPARAM. The script kids finally got around to probing one of my sites and while my application is protected, the requests are generating lots [...]

I don’t work with SQL Server much so I thought this might save someone else some effort when trying to figure out the right combination of CFQUERYPARAM and Transact-SQL keywords. We have a search object that stores keywords and want to loop over the keywords to create a dynamic search query against our full-text [...]

* WPG2 Plugin Not Validated *
I found out not long ago that my good friend and college housemate Jerry Tam had made the cut and would be appearing on Season 5 of Bravo TV’s Project Runway. I’m currently in Europe right now so I went looking to find some details about the season premiere [...]

Update – this issue appears to be fixed with CHF3.
I’m testing an application on ColdFusion 8 in preparation for an upgrade and have found a strange error. My reinit process clears the trusted cache using the Admin API along with restarting Coldspring and Model-Glue. On CF7, the following code works very reliably:
<cfinvoke [...]

It’s pretty common knowledge that the Java 6 JRE in ColdFusion 8 has a bug from Sun that makes loading CFC-heavy applications slow. This impacts most framework-based apps that use Model-Glue, Mach-II, Coldspring, Transfer and so forth. To be clear, it’s not the frameworks, it’s a bug in the underlying Sun JRE.
I have [...]

In the same member merging process described in my last post, I was running a bit of code with a TRY/CATCH that looked for a duplicate primary key condition and, if found, deleted it from the source account:
<cfquery name=”select” datasource=”#variables.datasource.getName()#”>
SELECT *
FROM roles
WHERE id = ‘#id#’
</cfquery>
<cfloop query=”select”>
<cftry>
<cfquery name=”update” datasource=”#variables.datasource.getName()#”>
UPDATE roles
SET id = ‘#target#’
WHERE id = ‘#id#’
AND [...]

Something I learned today in my very rare use of CFTRANSACTION. I have a process that merges member accounts. This is needed when people create more than one account because they forget or can’t access their email account, etc. Because of the scale of this operation and it’s total behind-the-scenes nature, I’m [...]