Hello Dear Friends,
My current project is a job search site. I am using ASP with VBSCRIPT. Currently, users can select a salary range and view the SQL info that falls in that range. The data they can see is JobPostDate, JobName, JobSalary, and CompanyName. How do I enable the user to click on a job and view details, such as:Company address, ContactName, ContactEmail etc. The info is populated in the tables already. But since I am using a while loop, I don't know how they can select a job and drill down on it. The primary key is JobId. Here is the code:
vb
<%
do while Not rs.EOF
'response.write (rs("JobName") & " --" & rs("JobSalary") & rs("CompanyName") & "<br>")
response.write "<tr>"
response.write "<td>" & rs("JobPostDate") & " </td>"
response.write "<td>" & rs("JobName") & " </td>"
response.write "<td align = center>" & "$" & FormatNumber( rs("JobSalary")) & " </td>"
response.write "<td>" & rs("CompanyName") & " </td>"
response.write "</tr>"
rs.MoveNext
loop
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
Thank you, as always, for your help.
Please use code tags when posting your code, it makes it much easier to read
This post has been edited by PsychoCoder: 28 Feb, 2008 - 09:19 PM
28 Feb, 2008 - 08:31 PM
| 