WhereExpression for Scaffold

 Hi there,

 

I am just wondering if it's possible to add  WhereExpression for scaffold so that I can filter some data out.

Please let me know

Thanks

Alan 

 Yes. The property is called WhereExpression. ;)

 http://subsonichelp.com/html/ab350a6d-0ef5-47da-5c06-808e669f2d87.htm 

 I am using SubSonic 2.0.3 version and <subsonic:Scaffold> doesn't have WhereExpression property. At lease I can't see from VS 2005. By the way, I am talking about <subsonic:Scaffold> not <subsonic:QuickTable>.

 

Please let me know if  did anything wrong.

Thanks in advance

Alan 

It should be there

<subsonic:Scaffold ID="" runat="server" WhereExpression="" />

 No, Visual Studio 2005 gave me error message as follow:

 

Error    2    Type 'SubSonic.Scaffold' does not have a public property named 'WhereExpression'.    E:\backup\web\Mahayana\Mahayana.Web\Default.aspx    24   

 

By the way, I am using SubSonic 2.0.3 and also wondering it it works for you.

 
Alan
 

 I checked out API Doc online and WhereExpression property is only available for <subsonic: QuickTable> control, but not for <subsonic: Scaffold> control. The point is  <subsonic:QuickTable> control can't edit record like <subsonic:Scaffold>. I guess I have to write my own edit record for <subsonic:QuickTable> control using detailsview or formview.

Alan 

 This works for me

    <subsonic:Scaffold ID="tryout" runat="server" WhereExpression="LogUserID=1"
            ReturnOnSave="True" TableName="EventLog" ></subsonic:Scaffold>

 What version of SubSonic do you use and wondering if you could post your source code for me.

 Thanks  in advance

Alan 

 I used the latest stuff downloaded from GoogleCode (SNV server)

 Thanks, it works now. I didn't use the latest version before.

 

By the way is there any way we can do the paging on the <subsonic:Scaffold> control?

Thanks again. It helps a lot.

Alan