flywithoutwings
06-25-2009, 11:43 AM
Hi,
I'm trying to use IViewCursor's findAny() to search the XMLListcollection by including multiple search criterion but it's not working properly.
herez my scenario:
I've three tables users,courses and privileges. The users and courses tables contains the details of the existing courses and users and the privileges table contains the course-->user mappings and access levels.
Now in flex, i'm using datagrid to show the privileges...and another form to create new priviliges. This form contains
two list boxes for users and courses and checkboxes for each privilege.
So when the admin of my application selects a course and user and if that user has already has some privileges over that course, those privileges have to be shown by autoselcting the corresponding checkboxes.
So to match the selected user and course with the existing privileges, i'm using IViewCursor. but the IviewCursor's findAny() method returns true if either course or user is found in the privileges list which is not exactly what i'm expecting...i.e return true only if a row contains both the selected user and course.
I've created a sample using some sample xml files. can some one please check the code and help me in how to make the findAny()/findFirst() method return true only when both the user and course are found...or is there any other way to achieve what i'm trying to do...
here is the link for the example with the ViewSource option enabled:
http://ravimarella.com/XmlListCollection/XMLListCollectionSearch.html
Any help would be greatly appreciated..
cheers,
ravi
I'm trying to use IViewCursor's findAny() to search the XMLListcollection by including multiple search criterion but it's not working properly.
herez my scenario:
I've three tables users,courses and privileges. The users and courses tables contains the details of the existing courses and users and the privileges table contains the course-->user mappings and access levels.
Now in flex, i'm using datagrid to show the privileges...and another form to create new priviliges. This form contains
two list boxes for users and courses and checkboxes for each privilege.
So when the admin of my application selects a course and user and if that user has already has some privileges over that course, those privileges have to be shown by autoselcting the corresponding checkboxes.
So to match the selected user and course with the existing privileges, i'm using IViewCursor. but the IviewCursor's findAny() method returns true if either course or user is found in the privileges list which is not exactly what i'm expecting...i.e return true only if a row contains both the selected user and course.
I've created a sample using some sample xml files. can some one please check the code and help me in how to make the findAny()/findFirst() method return true only when both the user and course are found...or is there any other way to achieve what i'm trying to do...
here is the link for the example with the ViewSource option enabled:
http://ravimarella.com/XmlListCollection/XMLListCollectionSearch.html
Any help would be greatly appreciated..
cheers,
ravi