Multiple SelectParameters
Hey guys I need to set the field name and search value by QueryParameters.
Is this Possible? I can get the @searchDate to work but not @searchType.
I'd also like to set the operators in a variable too, but not that important.
If this isn't possible does anyone have a work-around?
<asp:AccessDataSource ID="ADSlessDateSearch" runat="server"
DataFile="~/App_Data/DAC.accdb"
SelectCommand="SELECT * FROM Library WHERE (@searchType < @searchDate) ORDER BY LastRevised DESC">
<SelectParameters>
<asp:QueryStringParameter DbType="String" Name="searchDate"
QueryStringField="searchDate" />
<asp:QueryStringParameter DbType="String" Name="searchType"
QueryStringField="searchType" />
</SelectParameters>
</asp:AccessDataSource>
|