CODEWITHSUNDEEP
asp.netvb.netlinqlinqdatasource
JanBorup
JanBorup

Reputation: 5615

Character constant must contain exactly one character

When you get this error "Character constant must contain exactly one character"

I had this code but it constant gave me the above error in my LinqDataSource:

 <asp:LinqDataSource ID="LinqViewLogs" runat="server" 
    ContextTypeName="ScanFakDataContext" OrderBy="Dato desc" 
    TableName="ViewLogs" 
        Where="(@Filter='' OR (@Filter='UserNotes' AND LogType=1)">
     <WhereParameters>
         <asp:QueryStringParameter DbType="String" DefaultValue="" Name="Filter" QueryStringField="Filter" />
     </WhereParameters>
</asp:LinqDataSource>

Upvotes: 2

Views: 5940

Answers (1)

JanBorup
JanBorup

Reputation: 5615

The problem was to reverse the quotes, so "" is '', and '' was ""

Here is the correct code:

 <asp:LinqDataSource ID="LinqViewLogs" runat="server" 
    ContextTypeName="ScanFakDataContext" OrderBy="Dato desc" 
    TableName="ViewLogs" 
        Where='(@Filter="" OR (@Filter="UserNotes" AND LogType=1)'>
     <WhereParameters>
         <asp:QueryStringParameter DbType="String" DefaultValue="" Name="Filter" QueryStringField="Filter" />
     </WhereParameters>
</asp:LinqDataSource>

Upvotes: 1

Related Questions