0 Replies Latest reply on Oct 14, 2004 12:45 PM by madadi

    Getting last insert Userid no: from Mysql using CMP.

    madadi Newbie

      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