I'm working an asp page to record a

[danieljoo]

I'm working an asp page to record attendee information for a seminar. My first page (lookup.asp) allows the user to search for a company based on company name, city or company number. The results (list.asp) shows all companies matching the search (this comes from a connection to companytable). From these results I need to create a link from the company name and send a querystring of the customer number. The issue I am having is with the next page, attendee.asp, which is supposed to list the attendees matching the company from the querystring. The issue is that I open a second connection to pull the information out of attendees. How do I get around this?

 

[GabeC]

I'm not sure what you are asking here. The second recordset you are talking about is used in a second page. Since HTTP is stateless, the second page does not know what you did in the first page.

One way to get around this is to create your database object as a session object then you can access it from page to page.

I highly discourage this though.

Why don't you want to just create another recordset in your second page?

Thanks,

Gabe

 

[danieljoo]

The issue I am having with the second connection is that I get an error "The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened by another user.....". I believe this is from having 2 connection. Also when I open a connection on list.asp, I close the connection, but it doesn't matter becuase I still get this error on the next page.

 

[GabeC]

I don't use Access much so I'm not sure exactly what is going on. My only suggestion is to look through your code to make sure you close the database and set its object to nothing in the first page. Make sure this happens for all cases that the code flows through.

Maybe if you post the code that is causing the trouble someone may see what is going wrong.

Thanks,

Gabe