I am trying create a recordset from a recordset I have opened. I keep getting a 0x800A0BB9 error. Anyone know what could be wrong?


Set Rs1 = blah

 

Use Java...

 

Thanks for your helpful insight...

If you read the subject you would understand I am not a programmer. I know enough to be dangerous and certainly don't know crap about coffee related technologies.

 

I don't know the answer, but try searching for the error message on groups.google.com

it's amazing sometimes

 

I don't think it likes having Rs1 as the data source for Rs2. What are you trying to do really? Do you just want Rs2 to be a subset of the records from Rs1? Just change the query that defines Rs2...unless I'm missing something?

 

do you use ICQ/AIM/Yahoo by chance? If so, PM me and tell me how to get in touch with you.

First of all, try 'remming' (remarking/marking out) the RS2 lines to make sure all works with RS1 and then doing response.writes with the RS1's records that return.

For example

Set RS1 blah blah
more blah blah
more blah blah

'Set RS2 blah blah <--- notice the remarks on these lines
'more blah blah <--- these marks at the first of the line are
'more blah blah <--- single quotes which tell vbscript NOT to read the line

next, response write the rs1 in the HTML by doing the following:

<%=rs1(0)%> <-- writes out the FIRST returned record from the SQL statement
<%=rs1(1)%> <--- writes out the second returned record from the SQL statement

(Only do one at a time in case something is set where you are only returning one column/record in the recordset.

But again, PM me if you are still up.

Thanks.

 

ASP doesn't let you use a recordset as a connection. I can't use filters because it's an access db. Now I am trying to do it in one big select. Thanks for the input.

 

[QUOTE]Originally posted by saliv8
[B]I am trying create a recordset from a recordset I have opened.

 

go here for your ans:

http://www.4guysfromrolla.com/webtech/083101-1.shtml

also create virtual directory iisHelp to generate the explanation for the error code