Scaffold WhereExpression not filtering results

Hi All,

I have attempted to filter my scaffold as shown below with no luck.

<subsonic:Scaffold ID="MyScaffold"
                   runat="server"
                   TableName="MyTable"
                   WhereExpression="Status=0"
                   />

The result allways returns all records from the table. Any suggestions, or is this a bug?

Try adding the wheres to the WhereCollection using Code.

I think Eric fixed this for 2.1

can you give us example on adding wheres in wherecollection?

Hi I'm Having the same problem, And I'm using the 2.1.0.0 version.

Does any one has any idea? Thanks

Fwiw, I just reconciled (Oct 10, '08) and this is still an issue.

The scaffold calls the ExecuteJoinedDataset() method. It's hard to debug this because it's all encapsulated in subsonic, but from what I can tell, it's either a provider specific issue in GenerateWheres(), or it's the fact that parameters are never added to the QueryCommand object because the lines that do that are commented out in the ExecuteJoinedDataset() method of SqlQuery.cs.

So, first off, what provider are you using?

Has there been any solution for this issue? I'm not able to filter my scaffold at all using WhereExpression in the mark up or the code behind. Any suggestions?

In the end I ended up setting the WhereCollection in code behind:

myQuickTable.WhereCollection = null;

SubSonic.Where where = new SubSonic.Where();
where.ColumnName = myTable.Columns.myColumnName;
where.ParameterValue = paramValue;

List<Where> whereList = new List<Where>();
whereList.Add(where);

myQuickTable.WhereCollection = whereList;

hope that helps.