Hi i have following xquery:
declare function local:indice() as xs:integer* {
count(for $document in collection("curriculum")
let $c:= document-uri($document)
for $a in doc($c)
order by $c
return
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()))
};
declare function local:nome() as xs:string* {
for $document in collection("curriculum")
let $c:= document-uri($document)
for $a in doc($c)
order by $c
return
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())
};
for $ indice in local:indice()
let $init := sql:init("com.mysql.jdbc.Driver"),
$conn := sql:connect("jdbc:mysql://localhost:3306/DBName","user","password''),
$stmt := sql:prepare($conn, "INSERT INTO informazionipersonali(idInformazioniPersonali,nome,indirizzo,telefono,fax,email,nazionalità,dataNascita) VALUES(?,?,'null','null','null','null','null','null') ")
for $nome in local:nome()
let $params:= <sql:parameters>
<sql:parameter type="int">{$indice}</sql:parameter>
<sql:parameter type="string">{$nome}</sql:parameter>
</sql:parameters>
return sql:execute-prepared($stmt,$params)
which return a combination of index and names, but i want only one row for each index and name.
How can i do?
-- 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=8-9