After logging into DNN as admin, Under Admin -> Manager_Start:
When Viewing Pledge List, the pledge count is displaying an incorrect value. It is displaying 338 instead of 186 total pledge counts.
PledgeList.aspx.cs”:
<asp:SqlDataSource ID="PLedgeList"
runat="server"
ConnectionString="<%$
ConnectionStrings:SiteSqlServer %>"
SelectCommand="SELECT
FirstName, LastName, Email, City, CellPhone FROM [Pledge] order by
ResponseDateTime desc"
FilterExpression="FirstName like '%{0}%' and LastName like '%{1}%' and
Email like '%{2}%' and CellPhone like '%{3}%' and City like '%{4}%'">
<FilterParameters>
<asp:ControlParameter Name="FirstName"
ControlID="txtFirstName" DefaultValue=""
PropertyName="Text" ConvertEmptyStringToNull="false" />
<asp:ControlParameter Name="LastName"
ControlID="txtLastName" DefaultValue=""
PropertyName="Text" ConvertEmptyStringToNull="false" />
<asp:ControlParameter Name="Email" ControlID="txtEmail"
DefaultValue="" PropertyName="Text"
ConvertEmptyStringToNull="false" />
<asp:ControlParameter Name="CellPhone" ControlID="txtPhone"
DefaultValue="" PropertyName="Text"
ConvertEmptyStringToNull="false" />
<asp:ControlParameter Name="City" ControlID="txtCity"
DefaultValue="" PropertyName="Text"
ConvertEmptyStringToNull="false" />
</FilterParameters>
</asp:SqlDataSource>
<asp:SqlDataSource
ID="PledgeCount" runat="server"
ConnectionString="<%$
ConnectionStrings:SiteSqlServer %>"
SelectCommand="select
Count(*) from Pledge"></asp:SqlDataSource>
We tried to add the filter expression and parameter to pledge count, starting from selectcommand= but an error returned,
"
Server Error in '/'
Application.
Cannot find
column [FirstName]."
Is this fixable from the sql code?
Please advise thanks!