You could try a slightly different SQL statement: select max(Last_Insert_ID) as Last_ID from table Mark
ILyas <[EMAIL PROTECTED]> wrote: HI list Im trying to get the last inserted user_id (integer - auto increment) using the below sql: Dim strSQL As String = "SELECT LAST_INSERT_ID() AS LAST_ID" However, i only get '0'. Why this happens? Pls help me here Thanks ILyas Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
