Thank you for your reply.
I did get code below to work inside Test Query in Visual Web
Developer. If I
set the [dvbs] field to True and no default value for the
parameters is set,
it returns [dvbs] True items just like I want. But if I set
up an url with
a querystring like <A href="newsindex.aspx?dvbs=TRUE">
no data is returned.
How do I accomplish the same result from an url like I can
get with Test
Query in Visual Web Developer?
<asp:SqlDataSource ID="nyhedsindex" runat="server"
ConnectionString="<%$
ConnectionStrings:nyhederConnectionString %>"
ProviderName="<%$
ConnectionStrings:nyhederConnectionString.ProviderName %>"
SelectCommand="SELECT [Dato], [Titel], [Resume], [Pic],
[dvbs],
[dvbc], [dvbt], [hdtv], [iptv], [tvnyt], [ArticleID] FROM
[artikler] WHERE
(([dvbs] = ?) OR ([dvbc] = ?) OR ([dvbt] = ?) OR ([hdtv] = ?)
OR ([iptv] =
?) OR ([tvnyt] = ?)) ORDER BY [Dato] DESC">
<SelectParameters>
<asp:QueryStringParameter Name="dvbs"
QueryStringField="dvbs"
Type="Boolean" />
<asp:QueryStringParameter Name="dvbc"
QueryStringField="dvbc"
Type="Boolean" />
<asp:QueryStringParameter Name="dvbt"
QueryStringField="dvbt"
Type="Boolean" />
<asp:QueryStringParameter Name="hdtv"
QueryStringField="hdtv"
Type="Boolean" />
<asp:QueryStringParameter Name="iptv"
QueryStringField="iptv"
Type="Boolean" />
<asp:QueryStringParameter Name="tvnyt"
QueryStringField="tvnyt"
Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>
Paul Whitham AdobeCommunityExpert wrote:
> Your current statement uses AND to link all the fields
together hence
> your problem. Just change it to OR in the SQL statement