Monthly Archives: February 2008

February 28, 2008
Can’t access shared music with Rhythmbox (Ubuntu)?

Probably quite old news for those in the know, but if you’re using Rhythmbox to play music on Ubuntu and want to listen to shared music over a network where people are using iTunes version 7+….it ain’t going to work
You can view who is sharing music, but their actual libraries won’t load into [...]

February 28, 2008
Changing the cfeclipse ‘tag insight’ delay time

Having ‘tag insight’ is a great part of any IDE, one which almost every developer takes advantage of irrespective of which editor they use. Tag insight of course being when your IDE provides information (attribute or return information etc) about the tag or function you are currently typing.
Normally when writing a function or tag like [...]

February 26, 2008
Code Tip: How to structure your queryparams

If I were a betting man I’d bet a LOT of money (and perhaps even the house!) that you’ve done this before.
Try to spot the error in the query below:

<cfquery name="qCreate" datasource="#getDSN()#">
INSERT INTO myTable
(
ObjectId,
Country,
DateOfBirth,
Email,
FirstName,
Gender,
LastName,
MainSchoolId,
PhoneHome,
PhoneMobile,
PostCode,
State,
Street,
StudentId,
StudentPassword,
StudentPodId,
Suburb
)
VALUES
(
<cfqueryparam cfsqltype="cf_sql_varchar" value="#createUUID()#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.oUser.get(‘country’)#" />,
<cfqueryparam cfsqltype="cf_sql_date" value="#createODBCDate(arguments.oUser.get(‘dateOfBirth’))#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.oUser.get(‘email’)#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.oUser.get(‘firstName’)#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.oUser.get(‘gender’)#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.oUser.get(‘lastName’)#" />
<cfqueryparam cfsqltype="cf_sql_integer" [...]

February 21, 2008
cfdocs on air (livedocs for CF8)

Brian Love recently released an AIR application he wrote which wraps up the ColdFusion 8 ‘livedocs’.
This is a great idea and a fantastic tool to add to your list. I’m sure most developers use livedocs as a reference (I do all the time) but historically the are SO slow (not to mention that I think [...]

February 21, 2008
Using MySQL Administrator to view real time stats

I was working on piece of code today which was sending an Ajax request to the server. The result of this request could have been 0 – 5 database UPDATE statements.
What I needed was a way to test my code to make sure the correct number of database statements were being executed based on the [...]