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

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