04_custom_styles_connector.cfm:
<cfinclude template="../config.cfm">
<cffunction name="custom_format">
    <cfargument name="item">
    <cfset var cl = "">
    <cfif ARGUMENTS.item.get_value("complete")lt 75>
        <cfset cl = "##AAFFFF">
    <cfelse>
        <cfset cl = "##FFAAFF">    
    </cfif>
    <cfset ARGUMENTS.item.set_row_color(cl)>
    <cfif ARGUMENTs.item.get_value("duration") gt 10>
        <cfset ARGUMENTS.item.set_image("true.gif")>
    <cfelse>
        <cfset ARGUMENTS.item.set_image("false.gif")>
    </cfif>            
</cffunction>
<cfset tree = createObject("component",request.dhtmlxConnectors["treegrid"]).init(request.dhtmlxConnectors["datasource"],request.dhtmlxConnectors["db_type"])>
<cfset tree.event.attach("beforeRender",custom_format)>
<cfset tree.render_sql("SELECT * from tasks WHERE complete>49","taskId","taskName,duration,complete","","parentId")>