coldfusion - CF ORM: Filter data using composite/FK -
i having difficulty in filtering table tab1 had fk key tab2 (tab1 had many 1 relation tab2) using orm.i wanted filter data in tab1 using fk column. used var items= entityload("tab1",{fk_col_name=value_variable}).
now getting error: have attempted dereference scalar variable of type class java.lang.string structure members.
let me share solution below if there better alternatives please share.
the solution paved way through lot googling usual. seems because entityload() convenience function works against defined properties. entityload(), breedid not property. instead, breed property, being of type breed. around can use hql instead.
so
ref: http://blog.nictunney.com/2011/02/coldfusion-orm-filtering-on-composite.html
Comments
Post a Comment