04_custom_styles_connector.cfm:
<cfinclude template="../config.cfm">
<cfset tree = createObject("component",request.dhtmlxConnectors["tree"]).init(request.dhtmlxConnectors["datasource"],request.dhtmlxConnectors["db_type"])>
<cffunction name="custom_format">
    <cfargument name="item" type="any" required="yes">
    <cfif ARGUMENTS.item.get_value("duration") gt 10>
        <cfset ARGUMENTS.item.set_image("lock.gif")>
    </cfif>            
    <cfif ARGUMENTS.item.get_value("complete") gt 75>
        <cfset ARGUMENTS.item.set_check_state(1)>
    </cfif>            
</cffunction>
<cfset tree.event.attach("beforeRender",custom_format)>
<cfset tree.render_sql("SELECT taskId,taskName,duration,complete from tasks WHERE complete>49","taskId","taskName","","parentId")>