|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 6th, 2003, 11:16 AM
|
|||
|
|||
|
recordset doesn't support this method
I can't seem to go through this recordset, method isn't supported on any of the commented out lines, anyone know what my problem is?
Code:
dim objConn
set objConn = server.CreateObject("ADODB.CONNECTION")
objConn.Open "Received", "t", "b"
Dim RS
Set RS = Server.CreateObject("ADODB.Recordset")
dim strSQL
strSQL = "select TOP 15 (requestNumber) as rn from request_received"
RS = objConn.Execute(strSQL)
'RS.MoveFirst
'do while not RS.EOF
' Response.Write reqnum("rn")
' objRS.MoveNext
'loop
'response.write RS.Fields.Count
objConn.Close
|
|
#2
August 6th, 2003, 11:30 AM
|
|||
|
|||
|
You'll kick yourself...:-)
You forgot the Keyword Set here: Dim RS 'Set RS = Server.CreateObject("ADODB.Recordset") dim strSQL strSQL = "select TOP 15 (requestNumber) as rn from request_received" Set RS = objConn.Execute(strSQL) I've commented the entire line in bold. Let the connection object create your IMPLICIT recordset Hope this helps! Sincerely Vlince
|
|
#3
August 6th, 2003, 11:52 AM
|
|||
|
|||
|
aww for cryin out loud..... I'm never copying old .net code to pure asp again. I was beatin myself in the head trying to figure out why one was working and the other wasn't.
Thanks vlince
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > recordset doesn't support this method |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
