Hi, i have tihsi error :[bxerr:BXSQ0003] Number of parameters differs from number of placeholders in this xquery:
declare namespace w="http://schemas.openxmlformats.org/wordprocessingml/2006/main";
declare function local:nome() as xs:string* {
for $document in collection("curriculum")
let $c:= document-uri($document)
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())
};
let $init := sql:init("com.mysql.jdbc.Driver"),
$conn := sql:connect("jdbc:mysql://localhost:3306/DbName","user","password"),
$stmt := sql:prepare($conn, "INSERT INTO person VALUES('',?,'','','','','')")
for $nome in local:nome()
return sql:ute-prepared($stmt,
<sql:parameters>
<sql:parameter type="string">{$nome}</sql:parameter>
</sql:parameters>)
Why?
----
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