Thanks Sean, I'll try these out. Much appreciated. On Feb 4, 5:51 am, Sean Coyne <[email protected]> wrote: > oh you will want to change the query as follows: > > select left(c.label,35) as objectid, refObjects.typename, r.objectid as > ruleObjectId from container c join container_aRules cr on c.objectid = > cr.parentid join ruleForm r on cr.data = r.objectid left join refObjects > on left(c.label,35) = refObjects.objectid where cr.typename = 'ruleForm'; > > Otherwise you will get ALL rules, not just the ruleForm rules.
-- 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
