CAML - Getting the URL's ID for the Where Clause

Question

Is there a way to get the ID from the SPGetCurrentSite? I want to use in my Where clause for my CAML Statement/ID field in the SharePoint list item. I'm new to CAML and I was using the below but I'm not getting the individual list item (getting the whole list).

  var urlParam = GetUrlKeyValue("ID");  
    <Query><OrderBy><FieldRef Name='ID' Ascending='True' /><Where><Eq>" + urlParam + "</Eq></Where></OrderBy></Query>";

Answer 1

I figured it out. My CAML Query Statement was all wrong. From above the above:

 <Query><OrderBy><FieldRef Name='ID' Ascending='True' /><Where><Eq>" + urlParam + "</Eq></Where></OrderBy></Query>";

To

"<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>" + urlParam + "</Value></Eq></Where></Query>";