Question
Sql query help
I have a question regarding a sql query I hope somebody can
help me with.
I have the select command below. I want to pass a query string from a link
like news.aspx?field1=TRUE. My problem is that if an entry in the database
includes TRUE setting for multiple fields I do not get all the entries with
the sql query only those where only field1 is TRUE. So basically I want to
retrive all entries from the database where field1=True including those
where either field2 or field3 also maybe True. Can anyone help?
<asp:SqlDataSource ID="newsindex" runat="server" ConnectionString="<%$
ConnectionStrings:newsConnectionString %>"
ProviderName="<%$
ConnectionStrings:newsConnectionString.ProviderName %>"
SelectCommand="SELECT [aDate], [Titel], [Short], [Pic], [field1],
[field2], [field3], [ArticleID] FROM [artikler] WHERE (([dvbs] = ?) AND
([dvbc] = ?) AND ([dvbt] = ?)) ORDER BY [aDate] DESC">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="FALSE" Name="field1"
QueryStringField="field1"
Type="Boolean" />
<asp:QueryStringParameter DefaultValue="FALSE" Name="field2"
QueryStringField="field2"
Type="Boolean" />
<asp:QueryStringParameter DefaultValue="FALSE" Name="field3"
QueryStringField="field3"
Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>
I have the select command below. I want to pass a query string from a link
like news.aspx?field1=TRUE. My problem is that if an entry in the database
includes TRUE setting for multiple fields I do not get all the entries with
the sql query only those where only field1 is TRUE. So basically I want to
retrive all entries from the database where field1=True including those
where either field2 or field3 also maybe True. Can anyone help?
<asp:SqlDataSource ID="newsindex" runat="server" ConnectionString="<%$
ConnectionStrings:newsConnectionString %>"
ProviderName="<%$
ConnectionStrings:newsConnectionString.ProviderName %>"
SelectCommand="SELECT [aDate], [Titel], [Short], [Pic], [field1],
[field2], [field3], [ArticleID] FROM [artikler] WHERE (([dvbs] = ?) AND
([dvbc] = ?) AND ([dvbt] = ?)) ORDER BY [aDate] DESC">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="FALSE" Name="field1"
QueryStringField="field1"
Type="Boolean" />
<asp:QueryStringParameter DefaultValue="FALSE" Name="field2"
QueryStringField="field2"
Type="Boolean" />
<asp:QueryStringParameter DefaultValue="FALSE" Name="field3"
QueryStringField="field3"
Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>
