Re: [Sedna-discussion] Collection problem
Sedna is a native full-featured XML database management system.
Brought to you by:
mozinsur,
shcheklein
From: Lewis, M. <mar...@me...> - 2009-09-09 13:56:00
|
Ivan, It works well, thank so much, your help is greatly appreciated. I take this opportunity to let you know that your software is great. As a beginner, I have tried many softwares and Sedna is one of the most user-friendly. It is also simple. I wish to be able to let you know soon that it is also one of the most complete !!! (but it will take me time to learn XQuery more deeply). So, again, thanks to share your knowledge with new users. Martin. ________________________________ From: Ivan Shcheklein [mailto:shc...@gm...] Sent: Wednesday, September 09, 2009 8:37 AM To: sed...@li... Cc: Lewis, Martin Subject: Re: [Sedna-discussion] Collection problem Martin, you should declare namespace in your query. For example, try the following query: declare default element namespace "http://www.cdisc.org/ns/odm/v1.3"; for $a in collection("MyCollection") return $a//ODM/@ODMVersion Ivan Shcheklein, Sedna Team On Wed, Sep 9, 2009 at 4:04 PM, Lewis, Martin <mar...@me...> wrote: Hello Ivan, Thanks for the help. I can provide an example of namespaces used in our typical XML file (CDISC standard), the only thing that I have changed is the "but" reference for privacy: <?xml version="1.0" encoding="iso-8859-1"?> <ODM xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:but="http://www.but.com/ODM/XMLSchema" xmlns="http://www.cdisc.org/ns/odm/v1.3" FileType="Transactional" FileOID="20090804T131629394" CreationDateTime="2009-08-17T09:44:12" ODMVersion="1.3" Originator="tests" PriorFileOID="Tests_V1.0" SourceSystem="ODMClinicalRelease" SourceSystemVersion="1.1.12.0"> <ClinicalData StudyOID="100000084" MetaDataVersionOID="2000000165">.... Many thanks in advance, Martin. ________________________________ From: Ivan Shcheklein [mailto:shc...@gm...] Sent: Wednesday, September 09, 2009 4:15 AM To: sed...@li... Cc: Lewis, Martin Subject: Re: [Sedna-discussion] Collection problem Hi Martin, It's likely that you use namespaces in your data. Can you give us an example of your documents? Ivan Shcheklein, Sedna Team On Wed, Sep 9, 2009 at 12:22 AM, Lewis, Martin <mar...@me...> wrote: Hello, First, not sure that I am at the right place to ask for my problem, sorry if it is not the case. I have try to find answers in archives but all posts are more complex and not very at my level (I'm a beginner in XML Query). My problem: I use Sedna (version 3.2.18) and SednaAdmin (version 1.0) and when I try do retrieve information inside collections, I have problems. The following code gives me all documents and is working well: for $a in collection("MyCollection") return $a Based on my reading, I should be able to write the following code and retrieve all ODM elements: for $a in collection("MyCollection") return $a//ODM Or attributes: for $a in collection("MyCollection") return $a//ODM/@ODMVersion But these two queries doesn't give me any results (blank pages but no errors). Maybe I'm doing something wrong. If you have any hints or advice for me, it would be a pleasure for me to test them, Thanks in advance for your help, Martin. Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------ ------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Sedna-discussion mailing list Sed...@li... https://lists.sourceforge.net/lists/listinfo/sedna-discussion Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. |