Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhig2002
Starting Member
2 Posts |
 Posted - 2002-08-26 : 06:57:02
|
| how can i view the recordset fields in reverse order using ASP .and i want to view the new inserted row suppose jobid='110' as my last inserted row how can i view this row using ASP pls guide me and give full details.thank u very muchabhishek |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-26 : 08:18:57
|
| #1) How to view a recordset's fields in reverse order - For i = Recordset.Fields.Count - 1 To 0 Step -1 Call Response.Write(Recordset.Fields.Item(i).Value & "<br />")Next #2) How to view a single recordset where jobid=110 SELECT * FROM MyJobs WHERE jobid = 110 This can be in a procedure, in a dynamical sql statement... just change it to match your database schema. Try reading some books on SQL, ASP and ADO. MSDN has good examples on how to's and such. |
 |
|
|
|
|
|
recordset