04-24-2010 01:48 PM
Hello every one
I have a problem with my Xml file ,and i need your help ;
Thank you very much :
Best regards ;
04-24-2010 03:44 PM
- How does your question relates to SQL? If you have XML data and that what you want to work with, SQL will not help you in any way AFAIK.
- Using XQuery (SQL like quiery langage for XML), you can write a query that does the "group by" analog of SQL. But all it does is baically nested loop thing collecting all the things you want for every element in the representative group. So what I am saying, you can try to use XQuery (if you are brave ) which will mean finding XQUery processor implementation for BB and learning XQuery to construct the needed request or you can just parse the query and use nested loops to solve the problem. Or better yet parse the file and put it into a datastructure (if it fits into memory) and then process the DS, which will most likely be much more efficient than reparsing the XML several times.
I am assuming here that you are familiar with basics of XML and XML parsing (this is exactly what Peter is asking you in the previous post), so in case you do, my post would be useful to you, in case you dont - well you need to get a grasp of XML first - there's no silver bulet unfortunately (yet... )
04-25-2010 03:51 PM
thank you peter ,and Comitic :
So ,as you know , iam still a student , idon't have experiences in BB devloppement ,so i think that
Instead of using SQL, i can also use data structures for storing the data and search them for what i need to display.
i will Create a class named Document. Have the attributes of document as Document's class variables.
....................;;and see what's can give me !!!!!