November 28th, 2008, 07:48 AM
SHPT Caml Query Error
I use the U2U caml builder for queries and I use the shpt web services to retrieve data from shpt lists.
I am facing a problem. When I want to get the data from a particular view of the list, I pass the view's guid in the getlistitems method and it returns me the rows belonging to that view only.
However, when I try getting the data from a view based on a query, the query returns the data from the global view i.e. the all items view rather than from that particular view only, and as a result I get extra rows, what should i do to prevent this?
For example, I have list called SampleList with 2 columns - StudentName and CourseName.
In the view "all items" - I have 38 rows (i.e. 38 students, 19 are for course = Englist and 19 for course = MAths)
and I create view, SampleView - where I have 8 rows only, 4 for englist and 4 for maths.
Now when I execute the statement - GetListItems(listName, viewName, Query, viewFields, null, queryOptions, null);
where viewName - SampleView and Query is null - i.e. no filtering.
I get only 8 rows (which is perfect).
but when i run the same query for the SampleView and with the query - course = Maths
the result should give 4 rows from the SampleView but I get the 19 rows from the "all items".
Where's the error????
Thanks a lot
Last edited by codenamevirus; November 28th, 2008 at 09:28 AM.
Reason: giving more information
By cheyenne1212 in forum Miscellaneous Security Discussions
Last Post: February 1st, 2012, 01:51 PM
By wolfman1984 in forum Programming Security
Last Post: December 8th, 2007, 06:50 PM
By w0lverine in forum Other Tutorials Forum
Last Post: December 19th, 2003, 07:58 PM
By cdkj in forum Tech Humor
Last Post: October 14th, 2003, 12:52 PM
By antihaxor in forum Non-Security Archives
Last Post: January 24th, 2002, 04:42 PM