Ilyas, I think you have to execute this immediately after the last insert statement, without closing the connection
Freddie > -----Urspr�ngliche Nachricht----- > Von: ILyas [mailto:[EMAIL PROTECTED] > Gesendet: Sonntag, 2. Januar 2005 20:04 > An: [email protected] > Betreff: [AspNetAnyQuestionIsOk] last_insert_id = 0 > > > 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 Links > > > > > > > > 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/
