Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
m
Text replacement - "</syntaxhighlight>" to "</pre>"
<pre lang='xquery'>
sql:connect('dbc:sqlserver://DBServer', map { 'autocommit': true() })
</syntaxhighlightpre>
|}
}+
}?
</syntaxhighlightpre>
With {{Code|$options}}, the following parameter can be set:
* {{Code|timeout}}: query execution will be interrupted after the specified number of seconds.
let $id := sql:connect("jdbc:postgresql://localhost:5432/coffeehouse")
return sql:execute($id, "SELECT * FROM coffees WHERE price < 10")
</syntaxhighlightpre>
The result may look like:
<sql:column name="total">14</sql:column>
</sql:row>
</syntaxhighlightpre>
==Prepared Statements==
(: Execute prepared statement :)
return sql:execute-prepared($prep, $params)
</syntaxhighlightpre>
==SQLite==
sql:execute($conn, "select * from person")
)
</syntaxhighlightpre>
=Errors=
