Home All Groups Group Topic Archive Search About

Quotes, tags, and "greater than" signs

Author
23 Dec 2005 12:36 AM
danthman
I'm trying to write a complex multi-line SQL select command on an
ASP.NET 2.0 page, but I'm not sure how to get the "greater than" sign
(>) into the quotes without it thinking it's a tag. Can this be done?

Here's my code (notice where it says SelectCommand= [multi-line
quote]):

-------------------------
<asp:SqlDataSource
        ID="EntryDataSource"
        ConnectionString="<%$ ConnectionStrings:JIGSAWExp2 %>"
        SelectCommand=
            "Select Name, Address, Date
            WHERE Name=@CustomerName
            AND Date >= @MinimumDate"
        runat="server">
        <SelectParameters>
            <asp:SessionParameter
                Name="CustomerName"
                SessionField="CustomerName"
                Type="String" />
            <asp:SessionParameter
                Name="MinimumDate"
                SessionField="MinimumDate"
                Type="DateTime" />
        </SelectParameters>
</asp:SqlDataSource>
-------------------------

I've tried a few things, like putting the whole quote inside <% %>,
putting each line of the quote inside <% %>, and just ">=" inside <%
%>, but none of that worked.

Should I just give up and set the command in the code-behind or is
there some easy way to do this I'm just missing?

Thanks in advance,

-Dan

Author
23 Dec 2005 3:24 AM
Joshua Flanagan
Try using the HTML escaped version.
> becomes &gt;
< becomes &lt;

so, you would write:
AND DATE &gt;= @MinimumDate


Joshua Flanagan
http://flimflan.com/blog
Are all your drivers up to date? click for free checkup

Author
23 Dec 2005 8:20 PM
danthman
Yes! That was it. Thanks.

-Dan

Bookmark and Share