set rs to a variable

RinoDM · December 21st, 2011, 12:07 PM

Hi to all...
i'm having an issue with the following... it doesn't like
var Counter = rs("Counter1")
line...

Set rs = connDB.Execute("sp_GetCounter")
If not rs.eof Then
Do until rs.eof
var Counter = rs("Counter1")
rs.MoveNext
Loop
End If
Set rs = Nothing

if i comment out the line i get no errors...
i'm i doing somthing wrong???

thank you in advance
Rino

disel2010 · December 22nd, 2011, 06:25 AM

Hi,

two things.

first, to declare a variable in vbscript you have to use the "Dim" keyword.
Second, in vbscript you must declare a variable first before using it.
So either on two lines or on one line with a colon as end-of-line separator.

Code:

 
Dim Counter : Counter = rs("Counter1")

Since you use it in a loop, declaring it separately is the obvious choice.
The following should work for you:

Code:

 
Dim Counter 
Set rs = connDB.Execute("sp_GetCounter")
  If not rs.eof Then
    Do until rs.eof
    Counter = rs("Counter1")
    rs.MoveNext
  Loop
End If
Set rs = Nothing