Jquery to get list items from SharePoint list

The same James mentioned plus the ViewFields tag is not closed. I recommend you to use Firebug on Firefox to play with the Sharepoint webservice changing the code until you get the expected results or use Fiddler to find out what's the webservice sending back.

You have a redundant AND clause in your CAML query.

Also, your code looks for CustomerID and BANKID in the results but you never request those fields in the ViewFields section.

The best way to go about this is to start with the basic call so that you get results. In other words, remove any filters, etc. just to be sure that you can get results from the list. Use alert(xData.responseText) to see what is returned from the call

Then add your filters back in one at a time (CAMLQuery, CAMLViewFields), making sure that each is doing what you want..

You should change from the "z:\row" notation to "[nodename='z:row']" as I show in the SPServices docs for cross browser compatibility.

Hi David Thanks for being there,David after your careful view and reply to me ,I removed view-fields.A I tried the sample code to get the value form list item based on ID of a list.But i don't know why i am not able to access list item values.I used alert message var i=$(this).attr('A'); alert(i); .I don't know why i am not able to get the value.alert(i) shows me message as undefined value.Hope you will respond to e David and James

 var query = "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Number'>" + 2 + "</Value></Eq></Where></Query>"; $().SPServices ({ operation:"GetListItems", listName:"Test", async:false, CAMLQuery:query, completefunc: function(xData, status) { $(xData.responseXML).find("z\\:row").each(function() { var i=$(this).attr('A'); alert(i); }); } }); 

Can you please Change the value type to "Counter" in Caml query:

The query is like:

var query = "<Query><Where><Eq><FieldRef Name='ID'/><Value Type='Counter'>" + 2 + "</Value></Eq></Where></Query>";