Badotz,
Sorry...I'm a newbie and wasn't clear. All forms, grids, etc are runat = "server". There is no client side SQL. I guess my real question is "How do I code this so if the user checks the box it will switch from "ALL" records selected (as in the first SQL) to "Select only criteria matching in test box" (as in the second SQL). Should this be handled in some kind of event like:
<script runat="server">
Protected Sub CheckBox1_empty (something)
SQL_select = "do 1st sql"
End Sub
Protected Sub CheckBox1_checked (something)
SQL_select = "do 2nd sql"
End Sub
</script>
Thanks again for your feedback....
dmasini
Main Topics
Browse All Topics





by: BadotzPosted on 2007-03-31 at 07:46:33ID: 18828696
I would eliminate the radio button - if there is no search text, then there is no need to filter. If there is search text, then filter on that.
Creating SQL on the client is not very secure. You might want to submit the filter text to the server via AJAX, and build the SQL there.