Dear all,

I want to know the Last Userid no: which is inserted in Mysql. i did with Mysql AutoIncrement option but it is not the solution for other reasons.

In my data base there is a table with cmp fields Userid and UseridNumber ,this useridNumber should increment for every user who registers .

So can you tell me how can i get Last Userid No: from my sql ? is there any Ejb-QL in xml files ? Iam using Java servlets and Ejb's .as iam new ,,, i need help ...

Regards
kiran