David J.

I use my local machine at work to diary work efforts and important dates. I've found that because I am given a windows machine to work with that the Web Platform Installer is the easiest way to get quick applications. going.

I use ScrewTurn for a wiki, my wiki, to record processes and important information. I started using BlogEngine.net for a work blog (local) because it does not require a database.

I accessed my blogengine.net blog this morning to be greeted with the characteristic ASP.Net yellow error screen. The basic message was 'Unable to Validate Data.'

Oddly, the only fix I found was to delete the cookies at the local client. I hope that this isn't the permanent fix and that it doesn't happen again.

After deleting my cookies for that site, I was able to use the blogengine.net blog again.

I will update this post if it continues to happen, and provide any additional solutions as necessary.

posted on 2012-05-08 15:08:30

permalink: http://www.davidj.org/blog.html/2012/5/8/22/BlogEngine.Net_Unable_To_Validate_Data

I worked hard to get my pages cleaned up and in Google's index.

I watched the pages climb to a good point based on specific terms.

They stayed at a certain level after about 3 to 4 months.

Then I removed the webmasters/tools and the analytics code from the pages.

I changed nothing else on the page but to remove the scripts, which google (as script) should ignore anyway.

The pages fell in the index.

Not because of a content change, but because I stopped having my pages tracked by google analytics or google webmasters/tools.

That's dumb.

posted on 2012-04-27 13:31:02

permalink: http://www.davidj.org/blog.html/2012/4/27/21/Google_Wants_You_To_Track_Your_Website

Let's say you have a query that returns numbers in multiple rows:

Select carbrands, count(id) as theCount group by carbrands having theCount > 0

Instead of setting a variable like request.carbrandcount and adding to it in a loop, you can use ArraySum against the query.

<cfset request.carbrandcount = ArraySum(qryName['carbrandcount'])>

Just saying.

posted on 2012-03-07 11:50:51

permalink: http://www.davidj.org/blog.html/2012/3/7/20/Coldfusion_ArraySum_to_Total_Query_Results_Without_Looping

I grabbed the audio from the videos that are on youtube as mp3 files.

These files are not great quality. If I ever record good sounds, I'll let you know, and probably put them on soundcloud.

Call Me
Cheshire Cat
Cody
Dizzy
Gold Rush
Wild and Free

posted on 2012-02-16 10:37:51

permalink: http://www.davidj.org/blog.html/2012/2/16/19/Songs_Available_for_Download

Please remember this is not scalable and should be improved with possibly a cflock. This was a one-off request that had to be done quickly.

My user needed to be able to download a zip file of photos in a folder.

I create a directory, copy the files in to that folder, and then zip the folder for downloading.

Upon running the page, past folders are deleted. This is the part that does not scale. Either a lock or an age check should be done.

I have included comments in the code.

<!---~ A simple form post of listed ID's posts to this page --->
<cfparam name="form.zipids" default="0">

<!---~ Run the query to get the filenames --->
<cfquery name="request.qryGetInfo" datasource="THEDATASOURCE">
	 	SELECT	
			fname,
			lname, 
			leadid,
			filename
		FROM
			containingTable
		WHERE 
			leadid in (<cfqueryparam cfsqltype="cf_sql_integer" value="#form.zipids#">)
</cfquery>

<!---~ Get any current directories in our temp path zips folder --->
<cfdirectory action="list" directory="#GetTempDirectory()#zips" name="directorylist">

<!---~ Loop through and delete any existing directories (not scalable) --->
<cfloop query="directorylist">
	<cfdirectory action="delete" directory="#GetTempDirectory()#zips/#NAME#" recurse="true">
</cfloop>

<!--- Get some random directory names --->
<cfset request.randomzip  = randrange(1000,9999)>
<cfset request.randompath = "#GetTempDirectory()#zips/#randrange(1000,9999)#">

<!--- Create the directory that will contain the files to be zipped --->
<cfdirectory action="create" directory="#request.randompath#" mode="777">

<!--- Copy the files to the created directory --->
<cfloop query="request.qryGetInfo">
<cftry>
	<cffile action="copy" destination="#request.randompath#/#fname#.#lname#.#leadid#.jpg"
source="#AnApplicationVar#/#filename#.jpg" />
	<cfcatch type="any">
		<!---~ Missing File --->
	</cfcatch>
</cftry>
</cfloop>

<!---~ Create the zip file --->
<cftry>
	<cfzip action="zip" source="#request.randompath#"
file="#request.randompath#/#request.randomzip#.zip" overwrite="yes" recurse="no" storepath="no" />
	<cfcatch type="any">
		<!---~ Zip Problem --->
	</cfcatch>
</cftry>

<!---~ Send as content --->
<cfheader name="content-disposition" value="attachment; filename=images.zip" />
<cfcontent type="application/zip" file="#request.randompath#/#request.randomzip#.zip" deletefile="true" />

Hope that helps!

posted on 2012-02-15 15:54:37

permalink: http://www.davidj.org/blog.html/2012/2/15/18/Using_ColdFusion_to_Create_a_Zip_File_of_the_Files_in_a_Folder