Using own SQL for a ft:objectAdmin

Hi there,

I need to use an own SQL for a ft:objectAdmin as I need to make some 
joining in there:

    <cfloop from="1" to="#ArrayLen (session.dmProfile.aCompany)#" index="i">
        <cfset stlocal.company = 
application.fapi.getContentObject(objectid="#stlocal.companies[i]#", 
typename="company") />
        <cfset myQuery = QueryNew('SELECT * FROM client c INNER JOIN 
client_acompany a ON c.ObjectID = a.parentID WHERE a.DATA = 
"#stlocal.company.objectid#" ')>
        <cfdump var="#myQuery#" />

        <h3>#stlocal.company.companyname#</h3>

            <ft:objectAdmin
            title=""
            qRecordSet="#myQuery#"
            typename="client"
            ColumnList="label,website,clienttype"
            SortableColumns=""
            lFilterFields=""
            lButtons="" 
            bPreviewCol="false"
            bViewCol="false"
            bCheckAll="false"
            bSelectCol="false"
            />

    </cfloop>

What is the correct way of doing this? I thought I "only" need to set my 
own query "nyQuery" and bring that into the fr:objectAdmin with qRecordSet.

Unfortuantely that doen't work.

Does someone has an idea what is my fault?

Thanks Kay

-- 
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry