Application error: "Set" assignment statements are no longer supported

[J. Muenchbourg]

The following line in part of my asp-sql block:

Set rs = Server.CreateOb ject("ADODB.Rec ordset")

creates an application error: "Set" assignment statements are no longer
supported

(in this particular block):
<%
Dim rs, strSQLd
Set rs = Server.CreateOb ject("ADODB.Rec ordset")
strSQLd = "Select * FROM category"
rsd.Open strSQLd, dbc
While Not rs.EOF
%>

I'm using this in an aspx file so that i can take advantage of the
paging and some of the other asp.net objects in the application. What is
a suitable replacement for "set" assignments?

thanks
Muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Chris Dunaway]

On Wed, 03 Mar 2004 16:01:10 -0800, J. Muenchbourg wrote:

What is a suitable replacement for "set" assignments?

Just don't use Set:

rs = Server.CreateOb ject("ADODB.Rec ordset")

--
Chris

To send me an E-mail, remove the underscores and lunchmeat from my E-Mail
address.