Hi,
when you join (by nesting for statements) you will always get the combinations unless you provide more constraints.
You might try something like:
declare function local:indice() as xs:integer* {
for $i in (1 to 10) return $i };
declare function local:nome() as xs:string* {
for $n in ('a', 'b', 'c', 'd') return $n };
for $indice at $pos in local:indice() for $nome in local:nome()[$pos]
let $params:= sql:parameters <sql:parameter type="int">{$indice}</sql:parameter> <sql:parameter type="string">{$nome}</sql:parameter> </sql:parameters> return $params
Regards, Max
2015-09-08 16:20 GMT+02:00 michele.greco2@email.it:
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