Multiple Selects with a ASP Page 1

[blackte]

I have an asp page that I have two selects, the first is for paging using a cursor, the second is for building a textarea within the main page. The first select works just fine, but when I attempt to execute the second select I get an error message

"No value given for one or more required parameters."

on the following line

Set rsttext = adoAccess.Execute(strSQL1)

All of my variables are defined. I'm using this second select to retrieve some text lines based on what each record that is displayed from the first select. As the user pages, I want to load the approperiate text lines.


Can someone help me, can this even be done?

Thanks in advance for the help with this, your input is greatly appreciated.



Thanks TBlack.

 

[ggriffit]

can you do a :

response.write(strSQL1)
response.end

just before the code snippet you have provided and then try the output in your Query Analyzer / SQL Plus etc.

 

[blackte]

ggriffit, thanks, I found my the problem as you suggested with the sql statement. I did not realize it was talking about the sql statement, I thought it dealt with the set statement. Thanks again for your help.

Thanks TBlack.