Limiting the number of records displayed on a page when the query is based on another request variable

The padmcode is an integer.  Therefore my original query structure is correct.  There are total of 30 records.  There is no problem for the dispaly of first 10 records.  I said the problem is  occuring when I press the number for the subsquent pages numbers.  In the present case
page 2, and page 3.

seems u are with MS Access DB.
First of all make sure there is value for padmcode

or try if the form method is post try
rscdbadd.open "select * from tblbasicAPPL where padmcode=" & Request.form("padmcode"), objdbconnPGDclr,1,1

else

rscdbadd.open "select * from tblbasicAPPL where padmcode=" & Request.QueryString("padmcode"), objdbconnPGDclr,1,1


let me know

Put the select query in a string and response.write it right before using the Open method (the line above).  If you need use Response.End right about the Open line so you can see the query.  Let us see the one when you use page 1 and the one you have for the other page.

What type of DB is this?  Once you get these queries try running the SQL line in the DB itself to see if you get results.  These steps will help us narrow down the problem.

bol

I am using Microsoft Access database
The padmcode is an integer.  The problem is not with syntax of the query  There are total of 30 records.  There is no problem for the dispaly of first 10 records.  The problem is  occuring when I press the number for the subsquent pages numbers.  In the present case
page 2, and page 3.
Obviously, when we are clicking for page 2 and 3, the PADM code is not being captured.

>> Obviously, when we are clicking for page 2 and 3, the PADM code is not being captured. <<

Well then is it being sent?  How?  You are using Request("padmcode") it seems to try to get the value.  If you feel the problem is the query not getting that value (it is a logical reason for the problem and certainly would cause a problem if you are right) then how are you trying to send it.  Looking at the html you posted I don't see anywhere you set it.  It either needs to be passed by the URL or using another method like a form or cookie for Request to use it.

If it should use the value of page then you could just replace the Request("padmcode") parts with Request.Querystring("page").  Even better set a variable and use it.  Using Request in the SQL query is asking for serious problems (ie. SQL injection).  You should alway validate the values you get from places like the URL and then set them to a variable.

bol

thats why i comment
>>First of all make sure there is value for padmcode

Please use the following link get the exact picture of the problem that I am facing.  Temporarily, I created a user account and password to open the relevant pages.  
 The username is username and password is password
http://www.nimsexams.net/apPGDclr/apPGDclreclogin.asp
After logging in, the selected default padmcode i.e 1 in the combobx.  Click provisional admission information.  This lists all the 30 candadates with  padmcode 1.  Please click the admission proceedings.  This will give the first 10 of the 30 candidates.When we click page number 2 at the bottom of the page with title scroll through more candidates, information for next 10 candidates is not displayed because, there is no way to capture the padm code.

when i click on admision padmcode i get first 10 and when i click on 2 it takes me to
http://www.nimsexams.net/apPGDclr/apPGDclrecPADMadmproc.asp?page=2

where is the padmcode in the url ? u should pass that in the url
http://www.nimsexams.net/apPGDclr/apPGDclrecPADMadmproc.asp?page=2&padmcode=1

then it will work perfactly. just click on links
http://www.nimsexams.net/apPGDclr/apPGDclrecPADMadmproc.asp?page=2&padmcode=1
http://www.nimsexams.net/apPGDclr/apPGDclrecPADMadmproc.asp?page=3&padmcode=1

This is what exactly what I was trying to ask the experts.  How to write that those links programaticlly for different initial selections of padmcode.  Since the padmcode code initially selected was 1, the above URLs i.e  .......... & padmcode=1 will work.  Let us say the intial selection of padmcode was 2, then the described urls will not work. Therefore the code should be modified to capture any initially selected padmcode.
The code originally written (without capture of initially selected padmcode) was as follows:
Response.Write " <a href=""apPGDclrecPADMadmproc.asp?page=" & intDisplayPage & """>" & intDisplayPage &"</a> "
It should be rewritten.  The following is erroneous giving " expected end of statement" error
Response.Write " <a href=""apPGDclrecPADMadmproc.asp?page=" & intDisplayPage & "&" padmcode=" & request("padmcode") &"  "">" & intDisplayPage &"</a> "
Experts can put correct quotes to eliminate the error

2 :
now when that form is submited you will notice the url will be like
http://www.nimsexams.net/apPGDclr/apPGDclrecPADMinfo.asp?padmcode=1 (1or 2 based on ur selection)

i have a question here about this page:
apPGDclrecPADMinfo.asp

there is already a hidden input field "padmcode"  the value =1 is dynamic or you static ?
if it is static then u will have to change this page and make it dynamic

change form method to GET

<form name="frmadmpro" method=get action="apPGDclrecPADMadmproc.asp">
<input type=submit value="Adminission procedings">
<input name="padmcode" type="hidden" value="<%=request.queryString("padmcode")%>">
</form>

i recommend you to open new question with diff issue(s) as this question is already been answered.