Syntax Looks valid to me, perhaps it is just tempremental about the quotes.
try
returnobj = EntityLoad("Campaign",{company="1"},"#sortColumn# #sort#");
are you sure sortorder and sort are simple variables and not complex
variables ?
Russ
On Tue, Oct 19, 2010 at 6:50 PM, Glyn Jackson <[email protected]>wrote:
>
> Hi,
>
> quick question, if anyone can help.
>
> below you can see a entity for Campaign model. I want to get all campaign
> that have a company id of x (1 to many relationship) so i tried this....
>
>
> returnobj = EntityLoad("Campaign",{company='1'},"#sortColumn# #sort#");
>
> however this gives me the following error...
> "You have attempted to dereference a scalar variable of type class
> java.lang.String as a structure with members."
>
>
> how can i get all the campaign that have a company of x from my
> realtionship??
>
> Model....
>
> component output="false" persistent="true" {
>
> property name="camp_id" type="numeric" ormtype="int" fieldtype="id"
> generator="identity" sqltype="int";
> property name="camp_description" column="camp_description" type="string"
> ormtype="string";
>
>
> /* relationships*/
> property name="company" fieldtype="many-to-one" fkcolumn="com_id"
> cfc="company";
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338324
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
