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: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
