Hi Rob,
>You are appending a right-parenthesis ")" to your projectId variable so if your projectId is 12345, >you are feeding 12345) in to your query >parameter. >IOW, the last line of your query string should read: "where empproj.projectId=?)", projectId); Thanks for the correction...was trying with many combination for query so the mistak happened Im still trying hard to fetch the records now trying the other way ..will update you on the same soon >HTH, >Rob Hills >Waikiki, Western Australia -- View this message in context: http://www.nabble.com/Help-needed-for-Many-to-Many-relation-tp16547740s2369p16603627.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]