« November 2006 | April 2007 »

March 14, 2007

"Can you create a web site for me?"

So, you're a web designer or developer… No doubt upon learning this, you've had more than one friend or family member ask, "Can you create a web site for me?" Of course you could create a web site for them… but you're a busy person and would rather do something else with your free time. So how do you politely decline the job while maintaining your friendship? This used to be a difficult question—but not any longer. Now there's Weebly.

Weebly makes creating a website as simple as drag and drop. You can select from various elements such as paragraphs, images, columns, Google Maps, RSS feed widgets, etc., which you drag onto your page. Once the items are on the page you can double click on them to edit them. (And, by the way, this ain't no Frontpage. Weebly creates surprisingly standards compliant web sites.) When you're done, you can customize the appearance by applying a predefined skin and then publish your web site. You have the option of publishing to yoursubdomain.weebly.com, using your own domain name, or downloading a zip file of your web site. Weebly is easy enough that even non technical users could use it to create web sites. So the next time some one asks, "Can you build me a web site?" just send them to Weebly.

Posted at 8:48 PM in Web Development

March 13, 2007

IE Developer Toolbar Beta 3 install hangs

I haven’t been able to successfully install beta 3 of the Internet Explorer developer toolbar on my work PC. At about 98% complete, the setup program reports “Internet Explorer Developer Toolbar is being installed. Please wait…” The msiexec.exe process always hangs and maxes out my CPU at this point.

I haven’t been able to figure out what’s causing this. Has anyone else experienced this problem and figured out a resolution? Any help would be appreciated! Here is my system info:

Microsoft Windows XP Professional 5.1.2600 Service Pack 2 Build 2600
Internet Explorer 6.0.2900.2180

I would revert back to beta 2 (which worked perfectly fine for me) if I could find the install file… I can’t find anywhere to download beta 2—it seems to have been replaced with beta 3.

P.S. Don’t bother suggesting that I use Firefox instead with its associated web developer toolbar—I already use it extensively for most of my development. But I do use the IE web developer toolbar when troubleshooting IE specific issues.

Posted at 12:00 PM in Web Development

March 9, 2007

Cfoutput group tip

Yesterday I experienced a problem with my first attempt to use the group attribute of the cfoutput tag. I was trying to use multiple nested cfoutput tags with the group attribute to create a table whose rows were grouped together by one column of a query. Within those groups, I wanted to group the rows by a second column value.

The problem I was having was that ColdFusion wasn’t grouping my 2nd level rows like it should. I assumed that cfoutput sorted the query appropriately in order to perform the necessary groupings. What I failed to realize was that you have to manually sort the query with the SQL order by clause.

In other words, any column used in the a cfoutput group attribute must be in the SQL order by clause (in the order that the cfoutput tags are nested).

Here’s a code sample:

<cfquery name="q">
	SELECT Year,Month,Col1,Col2,Col3
	FROM table
	ORDER BY Year,Month
</cfquery>

<cfoutput query="q" group="Year">
	<h3>#Year#</h3>
	<cfoutput group="Month">
		<table border="1">
		<tr>
			<td colspan="3">#Month#</td>
		</tr>
		<tr>
			<td>Col1</td>
			<td>Col2</td>
			<td>col3</td>
		</tr>
		<cfoutput>
			<tr>
				<td>#Col1#</td>
				<td>#Col2#</td>
				<td>#Col3#</td>
			</tr>
		</cfoutput>
		</table>
	</cfoutput>
</cfoutput>

Posted at 10:51 AM in ColdFusion | Comments (3)