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 http://posta.email.it/caselle-di-posta-z-email-it/?utm_campaign=email_Zimbra...
Sponsor: Registra i domini che desideri ed inizia a creare il tuo sito web Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=13323&d=5-9