How to use @dbxml:name in an XQuery in DBXML?

Grimbal · *nix forums beginner Joined: 24 Feb 2005 Posts: 9

Ah... That explains it. I saw plenty of examples with @dbxml:name,
but none worked.

But both your examples work fine. Thanks a lot.

Florian

George · *nix forums Guru Wannabe Joined: 26 Feb 2005 Posts: 198

Grimbal wrote:

Grimbal · *nix forums beginner Joined: 24 Feb 2005 Posts: 9

Hello,

I am desperately trying to select a record by name in an XML container.

I want to select a record using something like:
collection("current.dbxml")/*[@dbxml:name="pump_def"]
It doesn't find the record.

If I do
collection("current.dbxml")/*
I can see it. And if I use
lookupIndex(qc, uri, name, strategy)
with
uri = http://www.sleepycat.com/2002/dbxml
name = name
strategy = "unique-node-metadata-equality-string
I can see the record I am looking for, with the name 'pump_def'.

I tried to add the dbxml namespace to qc, it doesn't help.

It works if I add the dbxml:name and dbxml namespace in the XML
document that I store, but then, it selects the records based on that
attribute, and not on the name I gave when I put() the record.

Any ideas?

I am using DBXML 2.0.7, in C++ (gcc), on Solaris.

Thanks in advance.
Florian Fischer

Google