kastellu Posted October 27, 2006 Share Posted October 27, 2006 Hello,Can someone help me with this code , i tried to create an filter that if a check box is checked the select case would test one sql select and if not would do the other one. I was checking what i get (response.write sqlresponse.end ) , the only result that i get was when if ch1 = "" was like this ufcourse the forum is not written in full version. What am i doing wrong , mabe someone can repair my code. Thank you response.write("<tr><td><input type='checkbox' name='ch1'></td></tr>")ch1 = Request.Form("ch1")If ch1 ="1" then test= 1 else test = 2 end ifSelect Case test Case 1 sql = "SELECT * FROM tblxx;" Case 2 sql = "SELECT * FROM tblxx WHERE O xx_date BETWEEN " & fncleto(a) & " AND " & fncdanes(b) & " ;"End Select Link to comment Share on other sites More sharing options...
justsomeguy Posted October 28, 2006 Share Posted October 28, 2006 <input type='checkbox' name='ch1' value='1'>If they check it, the value '1' comes back, otherwise nothing comes back. Link to comment Share on other sites More sharing options...
kastellu Posted October 29, 2006 Author Share Posted October 29, 2006 <input type='checkbox' name='ch1' value='1'>If they check it, the value '1' comes back, otherwise nothing comes back.Thanks it works! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now