chickadee » freetds » send-query

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))