minority
07-28-2005, 03:51 AM
Hi i was wondering how to get the id for the inserted data?
I tried this but not sure how to use it or if it even works with access
strSQL = "INSERT INTO Ticket ([Raised_By], [Date_Open], [Source_ID], [Details], [Descriptionncr], [Type_ID], [Raised_Against]) VALUES ('" &Fullname& "' , '" &DateOpen& "' , '" &SourceSelect& "' , '" &Details& "' , '" &Descriptionncr& "' , '" &TypeSelect& "', '" &Against& "') @@IDENTITY AS Report_ID"
rsinsert.open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Intranet\ncr\database\ncr.mdb;User Id=admin;Password=;"
'response.write(strsql)
'response.end()
set rsID = rsinsert.execute (strSQL)
intNewID = rsID("Report_ID")
rsinsert.Close
Set rsinsert = Nothing
I tried this but not sure how to use it or if it even works with access
strSQL = "INSERT INTO Ticket ([Raised_By], [Date_Open], [Source_ID], [Details], [Descriptionncr], [Type_ID], [Raised_Against]) VALUES ('" &Fullname& "' , '" &DateOpen& "' , '" &SourceSelect& "' , '" &Details& "' , '" &Descriptionncr& "' , '" &TypeSelect& "', '" &Against& "') @@IDENTITY AS Report_ID"
rsinsert.open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Intranet\ncr\database\ncr.mdb;User Id=admin;Password=;"
'response.write(strsql)
'response.end()
set rsID = rsinsert.execute (strSQL)
intNewID = rsID("Report_ID")
rsinsert.Close
Set rsinsert = Nothing