i am retreving my data from database(by using following code) with some fields(Prereq and CourseId)linked to other mypage.asp by using anchor tab.
now my problem is that my all records fetched would point to the same page..but i would like them to
link them to different pages....ex all the couserIDs i retreive should be linked with differnt pages and not the same page ,in my case its mypage.asp..
how shud i solve this problem?


response.write "<b>[u]Title: " & RS("title") & "</b></u><br><br>"
response.write "<b> " & RS("CoreType") & " </b><br>"
while not RS.eof
response.write " <a href='http://localhost/smita/mypage.asp'>" & RS("PreReq") & "</a> "
response.write " <a href='http://localhost/smita/mypage.asp'>" & RS("CourseId") & "</a> <br>"
response.write " " & RS("Description") & "<br><br>"
RS.movenext
wend
RS.close
Set RS = nothing
Set Con = nothing

hello,

  what do you mean by different pages? I understand that every record from the database should have an anchor to different page but not to mypage.asp If so how many pages you had?

its not good way of doing like this. You can do with querystring...


while not rs.eof
response.write "<a href='mypage.asp?courseid=" & rs("courseid") & "'>" & rs("courseid") & "</a>"

  rs.movenext
wend


like that you can pass different values throug querystring.

hi there,
wht i meant was for example..i have 5 records of my courses..say LEST 3002
LEST 6002
..
..
now when i put an hyperlink to each of the course...ex if user clicks on LEST 3002..i want it to go to another page which would give description of this course in detials,if user clikcs on LEST 6002 ,it shud give detials of this course...
Thats wht i want and dont know how i shud do it..
hope u understood my problem!
waiting for ur reply

This is simple.

As Rajanikrishna told, you can pass the course name to a page as querystring and do it as below.

If the course deescription is static,
------------------------------------------
if Request.QueryString("courseid")="LEST 3002" then
    Response.Write <course description of LEST 3002>
elseif Request.QueryString("courseid")="LEST 4002" then
    Response.Write <course description of LEST 4002>
elseif Request.QueryString("courseid")="LEST 5002" then
    Response.Write <course description of LEST 5002>
elseif Request.QueryString("courseid")="LEST 6002" then
    Response.Write <course description of LEST 6002>
elseif Request.QueryString("courseid")="LEST 7002" then
    Response.Write <course description of LEST 7002>
endif
-----------------------------------------------------------
If course description is in a table, you may either write a function to fetch the description from table. Possibly the description will be in the same table as the course name. Then you can write a single query like

select description from <course table> Where coursename='" & Replace(Request.QueryString("courseid"), "'", "''")) & "'"

Then print description.

hi madhu..
Well i dint get you....the thing i want is..i retreive these couse ids from data base by using a loop in my ASP codes..liek this:

while not RS.eof
response.write " & RS("CourseId") & " <br>"
response.write " " & RS("Description") & "<br><br>"
RS.movenext
wend


Now if for example my output with this looks like this:
L 122
L 223
now the person shud be able to click on L 122 and get a detials description of the course..same goes for other courses which gets displayed on the page.If i have around 100 courses like this..i can give a query string manaually for each course.Wht i want is i put this in a loop where i get them on my output page with different hyperlinks for each course...
Hope u are understanding my problem!!

Do you want to display the deescription without refreshing the page ? i.e. when user clicks course 1, the corresponding description is shown at a specified place on the page. Then when you click the next course, the corresponding desc. is shown at the same place all this without refreshing the whole page.

You can use an Iframe to achieve this. First create a page which will just fetch the description. Then show that page in a IFrame. The target of the links of courses should be the name of IFrame.

If the information is comming from a data base a page refresh is required as it needs to get this information from the server.

You could use simple conditional statements within the <td> where you want to show the description, what ever id came via the QS get that description and show it...



Wind is your friend
Matt