locating the node and then replacing



Hi

most of the example in BOL for xquery seem to have the xpath hardcoded in
the query, how do you search a xml document and then decide if you should do
an insert or a replace if you did not really know the exact path of the
node. Also, you can only insert one node at a time, how do you insert more
than one node at the same position.

thanks

Paul


.



Relevant Pages

  • Re: Ignore other records but first (highest) record
    ... The suggested query doesn't care how many records ... BOL values are in the table. ... >there are instances where I will have 2 lines of data to compare and ... >>>the carrier, ...
    (microsoft.public.access.queries)
  • Re: Newbie: Update From Excel
    ... Latest query in DTS ... then the price from the spreadsheet overwrites the ... > BOL is one of the single most useful resources for your SQL Server ... >>> Is the data still in Excel or have you imported it? ...
    (microsoft.public.sqlserver.dts)
  • Using XPath to copy nodes
    ... private Element getAnswers(Element root, String queID) throws ... XPath xpath = factory.newXPath; ... //Design the query to search through the XML Document ...
    (comp.lang.java.programmer)
  • Using XPath to copy nodes
    ... private Element getAnswers(Element root, String queID) throws ... XPath xpath = factory.newXPath; ... //Design the query to search through the XML Document ...
    (comp.lang.java.programmer)
  • AJAX, XML and Caching(?)
    ... use JSP to create dinamically an XML document, something like an SQL ... query, and printing of DB result in an XML form. ...
    (comp.lang.javascript)