Can anyone tell me how to use the Expression attribute of MM:Dataset to stop the CommandText from executing on Page_Load?

My code:
<MM:DataSet
id="dsPermInfo1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings["MM_CONNECTION_STRING_DeathStarPERMPLUSRead"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings["MM_CONNECTION_DATABASETYPE_DeathStarPERMPLUSR ead"] %>'
CommandText='<%# "SELECT * FROM dbo.v_InspectionHistory WHERE PermitNo = @Year;" %>'
Expression='<%# Page.IsPostBack %>'
Debug="true" PageSize="15">

according to Macromedia, Expression='<%# Page.IsPostBack %>' should stop the Dataset from executing unless the page is postback. However it is still executing on Page_Load. I would like it to execute when a button is pressed.

Anyone know how to do this??

I'm not sure how dreamweaver handles 'Expression'. But page.isPostBack will either return true or false.

you can use:

If NOT IsPostBack Then
   call the sub here
Else
End If

Please post your code in the page_load sub.

Expression in Dreamweaver datasets is boolean and indicates if the dataset should be executed. In your example, the expression should be false until the postback. However...if you have autopostback enable on the page...it could become true unexpectedly. I would recommend that you change the dateset to:

EXPRESSION="false"

and use the following statement to execute the dataset within your subroutine

DatasetName.Expression="true"

Hope this helps