Hi,

I wrote this xquery,who want to save the query result in myql.

 

declare namespace pkg="http://schemas.microsoft.com/office/2006/xmlPackage";

declare namespace w="http://schemas.openxmlformats.org/wordprocessingml/2006/main";

sql:init("com.mysql.jdbc.Driver"),

let $conn:= sql:connect("jdbc:mysql://localhost:3306/DbName","user","password")

return

(let $q:= "insert into person values("","||nome||","","","","","","")"

return sql:execute($conn,$q)),

for $document in collection("curriculum")

let $c:= document-uri($document)

order by $c

return <nome>

{for $e in doc($c)//w:tc[.//text()="Nome"]

 return $e/./following::text()except

  (for $x in doc($c)//w:tc[.//text()="Indirizzo"]

return $x//following::text())

}</nome>

 

 

but this is my error:

[XPDY0002] nome: no context value bound.

where am i wrong?

----
ZE-Light e ZE-Pro: servizi zimbra per caselle con dominio email.it, per tutti i dettagli clicca qui

Sponsor:
Registra i domini che desideri ed inizia a creare il tuo sito web
Clicca qui