Hi,
I have associated 2 DB Multi-Record Loader. Each of them have been named a ModelID and that's how they are associated and a Join is created. Now, the SQL statement that is generated out of this to retrieve the records is correct(Verified with the help of the Debugger). However, I want to know in which ModelID will the result set be stored, so that I can retrieve it and display .
Hi,
My First DB Multi-Record Loader has ModelID "Fav" and here the Enable Assocations = Yes and Associated Models = "Comp".
My Second DB Multi-Record Loader has ModelID "Comp" and here Enable Associations = NO and Join Rule is Comp.cf_user_id=Fav.userid.
My SQL Statments which i see from the Debugger mode are
1) SELECT `Fav`.*, `Comp`.`CompanyID` AS `Comp.CompanyID`, `Comp`.`companyname` AS `Comp.companyname`, `Comp`.`BusinessType` AS `Comp.BusinessType`, `Comp`.`description` AS `Comp.description`, `Comp`.`logo` AS `Comp.logo`, `Comp`.`cf_created` AS `Comp.cf_created`, `Comp`.`cf_modified` AS `Comp.cf_modified`, `Comp`.`cf_created_by` AS `Comp.cf_created_by`, `Comp`.`cf_modified_by` AS `Comp.cf_modified_by`, `Comp`.`cf_user_id` AS `Comp.cf_user_id` FROM `jos_chronoforms_data_Favorites` AS `Fav` INNER JOIN `jos_chronoforms_data_Company` AS `Comp` ON Comp.cf_user_id=Fav.userid WHERE Fav.cf_user_id = '121' And companyname not like 'Sahana Dance Events'
2)SELECT `Comp`.* FROM `jos_chronoforms_data_Company` AS `Comp` .
Now, the ResultSet from the First SQL is what i need, And would like to know in which ModelID the this First SQL Result set is stored , SO i can use it for display.
Hi,
Yes, in the Debugger I do see the Result set in the Array Fav.
[attachment=0]Result Set.JPG[/attachment]
I would like to Display the following the information -
> Companyname
>description.
Thanks,
Sahana.
Hi,
I need to Display the data only with the Array called Comp inside the Fav Array. How do i display only those Data. I have attached the File, in which I have Highlighted the data that I need to display. Can you please help me on that.
Thanks,
Sahana.