View Single Post
  #1 (permalink)  
Old April 7th, 2016, 02:44 AM
Amuthapriya Amuthapriya is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to pass checkbox selected value to Query

Hi,

my code details is below
----
Do Until RS.EOF%>
<tr>
<td valign="middle" align="center" class="style1">
<input type="checkbox" name="CompanyID_Merge" value="<%=(RS("CompanyID"))%>" onchange="checkboxlimit();" />

</td>
<td valign="middle" align="center" class="style1">
-- </td>
</tr>
<%
RS.MoveNext
Loop
%>
</table>
<%


End If
RS.Close
SET RS = Nothing
Conn.Close
%>

<%
CompanyID_Merge=Request.Form("CompanyID_Merge")
Conn.Open strConn
SQL = "SELECT"
SQL = SQL & " Projects.CompanyID, Projects.ProjectID, Projects.ProjectName, Projects.SeasonYear, Seasons.Season, Activities.ActivityName,"
------------------ SQL = SQL & " WHERE Projects.CompanyID = " & CheckNumber(CompanyID_Merge)
SET RS = Conn.Execute(SQL)

I am getting CompnayID_Merge value is null only. I need to pass that checkbox value to above query. I am struggling from past one week.
can somebody please find out what I did wrong?
Reply With Quote