mysql (query with parameter master detail) ?

abi · Post by **abi** » 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

abi · Post by **abi** » Tue Feb 22, 2011 5:48 pm

problem solved..

thanks guys

Post by **Andrew** » Tue Feb 22, 2011 11:41 pm

Ok! Have a nice day!

abi · Post by **abi** » Wed Feb 23, 2011 8:17 am

tips:
on child datasource make sure Reconnect on each row must set TRUE and cast your parameter if necessary

Post by **Alex K.** » Wed Feb 23, 2011 8:26 am

Hello,

Thank you for sharing your experience with other users. Have a nice day!