|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 23rd, 2004, 08:04 AM
|
|||
|
|||
|
ASP code help!!
I have this code in my application:
strSQL = "SELECT activity_id FROM new_hires_activity ORDER by activity_id desc" objRSA.Open objCmd NumActivityID = objRSA(0) When it reaches the objRSA.open line it errors out. I do have the following lines in the code at the beginning of the app and the other open statements work fin Dim objRSA As ADODB.Recordset Set objRSA = CreateObject("ADODB.Recordset") Thanks for any help. krc
|
|
#2
November 23rd, 2004, 09:20 AM
|
||||
|
||||
|
Just do this
Code:
strSQL = "SELECT activity_id FROM new_hires_activity ORDER by activity_id desc"
Set rs = objCmd.Execute(strSql)
If Not rs.eof Then
do until rs.eof
NumActivityID = rs("activity_id")
Response.write(NumActivityID & "<br>")
rs.movenext
loop
End If
objCmd.Close
Set objCmd = Nothing
|
|
| Viewing: ASP Free Forums > Other > Programming Help > ASP code help!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
