In my quest to learn how to use reactor better :-) I have another SQL statement I am having hard time deciphering how I should approach this, because its not necessarily a join.but.well check this out.
Heres the SQL: SELECT userPermissionId, userPermissionName FROM userPermission WHERE UserPermissionId IN (SELECT UserPermissionId FROM userPermissionJoin Where UserID IN (SELECT UserID from User where UserName = 'perezd')) I basically want to be able to supply what the username is and be able to get the permissions they have attached to their account via the userPermissionJoin table. Any ideas on where I should begin to start? I figured inside the IN I would create another gateway to the userPermissionJoin.but I don't know what I'd do after that. Any suggestions friends?? :-) Thanks for your help! - Derek -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
