System.Web.UI.Page.Reuqest' denotes a 'property' where a 'method; was expected

Question

i have create a datalist that displays book titles once click the hiperlink takes you to an edit page. the hyperlink looks like this. ' NavigateURL=' '/> my problem is as follow when i get to the edit page. instead of displaying one record at a time it displays all records one after the other one. I have tried to use the following query to select the data and only display one record at a time. cmdSelect = new SqlCommand( Select book_id title passage date location where book_id '  + Request.(ID) + ' Order by passage cn ); I am getting an error System.Web.UI.Page.Reuqest' denotes a 'property' where a 'method; was expected all help will be appreciated to get passed this error.

sjones · Answer

Did you cut-n-past this code or re-type it? I as because your text cmdSelect = new SqlCommand( Select book_id title passage date location where book_id '  + Request.(ID) + ' Order by passage cn );  does not have an = between book_id and the 'value'. Don't know if that would cause the error you are getting but the database should not like this very much.