ADODB.Recordset error 1

[vias]

Hi,

I have a program called 'search-eventx.asp' and i call a function "getDropdownCity()". I'm getting the following error :

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/search-eventx.asp, line 73

------------------------------------------------------------

function getDropdownCity()
Dim description, rs, strSQL
Set rs = Server.CreateObject("ADODB.Recordset&quot
if isobject(rs) then
strSQL = "SELECT Location from locations;"
=> line 73 rs.Open strsql, Conn
do until rs1.eof
description = description & &quot;<OPTION value='&quot; & rs(&quot;Location&quot & &quot;'&quot; & &quot;>&quot; & rs(&quot;Location&quot & &quot;</opt&quot; & &quot;ion>&quot;
rs.moveNext
loop
end if
getDropdownCity = description
end function
%>
------------------------------------------------------------

Could you please feedback me the possible causes.

Thanks.

 

[mwolf00]

why rs1?????

rs.Open strsql, Conn
do until rs1.eof


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[vias]

Sorry, in the code it is 'rs' and not 'rs1'.
I had edited the text for this forum and
forgot to change it.

So, the problem remains.

Any other feedback.

 

[mwolf00]

Is your connection open?

Try this method...

set rs = conn.execute(strSQL)

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[vias]

Your feedback helped.

Thanks