What I would like to do is have the page "http://www.XYZ.com/videos.aspx" load the MAX ID record by default. I tried this, but it won't even load the page portion that is suppose to contain the data and returned no errors;
Here is the Query;
SELECT *, (SELECT MAX(ID) FROM myMovies) as Max_IDFROM [myMovies] WHERE ([ID] = ?) '"Select all the record data of either the passed querystring value OR get and use the MAX ID of the records if no querystring passed"
My ASP.NET code;
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="_database/92592_Web.mdb" SelectCommand="SELECT *, (SELECT MAX(ID) FROM myMovies) as Max_IDFROM [myMovies] WHERE ([ID] = ?)" CancelSelectOnNullParameter="False">
<asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />