Casey, take a look at http://www.dotnet247.com/247reference/msgs/2/13712.aspx http://www.webxel-dw.co.uk/FAQs/FaqAnswers.html?FaqID=17 ----- Original Message ----- From: "Casey" <aspnet at thecrookstons.com> To: "The List" <thelist at lists.evolt.org> Sent: Wednesday, August 10, 2005 12:30 PM Subject: [thelist] simple query building question > 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. > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !