Hi Michele,
could you provide some more information, please?
E.g. the complete error message (with line number), the OS and BaseX version etc.
Regards,
Max
2015-09-07 11:41 GMT+02:00 michele.greco2@email.it:
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