selecting rows from stored procedure

[klinney]

I have a stored procedure that runs and outputs results onto an asp page. From there i want to select various rows that interest me via a checkbox and submit the rows to a new page where i can print my results.
I am struggling with getting the rows to display again after the checkboxes have been ticked.
The file that outputs the results the first time looks as follows:

Dim objField
For Each objField in objRSReport.Fields
Response.Write "<td class='ReportHeader'>" & objField.Name & "</td>"
Next
Response.Write "</tr><tr>"
Do While Not objRSReport.EOF
Response.Write "<td class='ReportHeader'>" & x & "</td>"
For each objField in objRSReport.fields
Response.Write "<td class='ReportContent'>" & objField.value & " </td> "
Next
Response.Write "</tr>"
x=x+1
objRSReport.MoveNext
Loop

Can you help please?

 

[Veep]

An easy way to do it is to create an IN CLAUSE on the receiving page. Give all of your check boxes the same name. For the Value of each checkbox use whatever unique ID field you have in your table. Quick example:

<input type="checkbox" name="chk" value="<%=objField.YourIDColumn.Value%>">

Then on the receiving page:

myInClause = "(" & request.form("chk") & ")"
strSql = "SELECT * FROM MyTable WHERE myIDColumn IN " & myInClause

 

[klinney]

I am having problems getting a proper value into the checkbox. In the code that follows you can see I get a value of x (row number) into checkbox. How do I get JobID (primary Key)into there. My table is called JobsGlasgow.
I have tried various ways but none seem to work. Obviously am missing something. Please help. Thanks


Do While Not objRSReport.EOF
Response.Write "<td class='ReportHeader'>" & x & "</td>"
Response.Write "<td class='ReportHeader'><input type=checkbox name=C1 value=" & x & "></td>"
For each objField in objRSReport.fields
Response.Write "<td class='ReportContent'>" & objField.value & " </td> "
Next
Response.Write "</tr>"
x=x+1
objRSReport.MoveNext
Loop

 

[simonchristieis]

what is the field name of the primary key?

add it like this


Response.Write "<input type=checkbox name=C1 value=" & objRSReport("myPrimaryKeyName") & "></td>"

 

[klinney]

Thank you!!!!