- send-query CONN QUERY #!rest PARAMSprocedure
Execute QUERY, which is a string containing one SQL statement. CONN indicates the connection on which to execute the query, and PARAMS is an arbitrary number of optional arguments indicating positional parameters represented by ? markers in QUERY. Each marker must have a corresponding PARAM.
This returns a result object (see below).
(use freetds) (let ((conn (make-connection "localhost" "user" "pass"))) (result-values (send-query conn "SELECT ?, 2" "hello"))) => (("hello" 2))