mysql (query with parameter master detail) ?
Posted: Tue Feb 22, 2011 3:00 pm
hai..
i use mysql adapter with mysql connector.
i try master detail with 2 datasource
sample code:
-- master
select idp,name from t1
--child
select idk,smr from t2 where idk=@idp
datasource on child have parameter @idp and expression with master.idp
then, i try preview -- on child datasource get empty data...
may you can help me?
thanks
i use mysql adapter with mysql connector.
i try master detail with 2 datasource
sample code:
-- master
select idp,name from t1
--child
select idk,smr from t2 where idk=@idp
datasource on child have parameter @idp and expression with master.idp
then, i try preview -- on child datasource get empty data...
may you can help me?
thanks