If I want delete xml (ex:ino:@1)
but I don’t know ino:id, how can i do?
-----
<%@ Page Language=“C#” %>
<%@ Import Namespace = “SoftwareAG.Tamino.Api” %>
<%@ Import Namespace = “SoftwareAG.Tamino.Api.DataAdapter” %>
-----
command.Delete(new TaminoUri(“./Property/@1”));
If i want insert a value(ex;name=“peter”) to fine the xml,and delete this data , but I don’t know it docname, how can i do.
I am use asp.net IIS 5.0
thx
This may or may not be what you want: http://tamino.forums.softwareag.com/viewtopic.php?p=2980. This article is describing how to delete particular documents by specific search criteria.
To be able to delete a specific document it is up to you to identify it. This means that either you need to know its name (docname or id) or it has to have a “primary key” that you can specify.
Can you give me some xquery and x-query example use asp.net, I find the tamino document but I don’t know how to add it to my asp.net program.
-----
Maybe use APIsimplesample collection, insert PropertyType=“3-Room-Apartment” or
email= “Jenny.Agutter@inetmessaging.com” then delete the document.
-----
thx
Try out sample XQueries in the interactive interface. But I’d do a “return” rather than “delete” until you are sure that you can identify the document that you want to delete (use the “where” clause).
I am use follow xml,schema
schema?xml
----------
I find follow command
update delete input()/bib/book[editor/last=“Gerbarg”]
----------
modify it
update delete input()/schedule/otime/affair[editor/title=“vb”]
----------
get the error message
<?xml version="1.0" encoding="Big5" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <xq:query xmlns:xq=“http://namespaces.softwareag.com/tamino/XQuery/result”>
- <![CDATA[ update delete input()/schedule/otime/affair[editor/title="vb"]
]]>
</xq:query>
- <ino:message ino:returnvalue=“8552”>
<ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
ino:messagelineIt is not possible to open a cursor with XQuery Update Request.</ino:messageline>
</ino:message>
</ino:response>
How can I modify it.
-----------
I use http://forums.tamino.com/3/OpenTopic?a=tpc&s=153292895 write the command
------------
declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction”
update for $i in input()/schedule/otime/affair[title=‘vb’]
where tf:getInoId($i) = 2036
do delete $i
----------------
but get the error message
<?xml version="1.0" encoding="Big5" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <xq:query xmlns:xq=“http://namespaces.softwareag.com/tamino/XQuery/result”>
- <![CDATA[
declare namespace tf="http://namespaces.softwareag.com/tamino/TaminoFunction"
update for $i in input()/schedule/otime/affair[title='vb']
where tf:getInoId($i) = 2036
do delete $i
]]>
</xq:query>
- <ino:message ino:returnvalue=“8552”>
<ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
ino:messagelineIt is not possible to open a cursor with XQuery Update Request.</ino:messageline>
</ino:message>
</ino:response>
Can you help me, get the right command
If you want to delete the WHOLE document rather than a node then the following answer is probably what you are after:
http://tamino.forums.softwareag.com/viewtopic.php?p=2980
declare namespace tf=“http://namespaces.softwareag.com/tamino/TaminoFunction”
update for $i in input()/schedule/otime/affair[title=‘vb’]
where tf:getInoId($i) = 2036
do delete $i
If I don’t know InoId,should I how to delete?
Either you will need to assign document names (docnames) to your documents or you will need a way of uniquely identifying the document (something similar to the primary key in SQL).
I say again.
I know ino:id what is mean.But,if I don’t know ino:id’s value,how to know ino:id’s value.
My English is very poor. Sorry ><"
Don’t tell me to look tamino’s db
A query of this form will return a list of matching ino:ids:
declare namespace tf="http://namespaces.softwareag.com/tamino/TaminoFunction"
for $x in input()/DataDocs
where $x/PHONE = "12345"
return <id>{tf:getInoId($x)}</id>