[thelist] simple query building question
Casey
aspnet at thecrookstons.com
Wed Aug 10 14:30:52 CDT 2005
In a web matrix datagrid, I need a variable WHERE clause.
SelectCommand="SELECT * FROM MCCIME_Doctor WHERE state = 'CA' "
that works fine, but
SelectCommand="SELECT * FROM MCCIME_Doctor WHERE state = ' " & get_state & "
' "
does not work. Not sure if it's because I'm declaring the variable wrong,
of if my syntax is wrong.
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
dim get_state as string = request.querystring("state")
end sub
</script>
"The server tag is not well formed" is the error.
More information about the thelist
mailing list