The function query is the basic SQL query function. It queries the database specified by database with a SQL query statement given by sql-exp.
The argument database defaults to *default-database*.
result-types is a list of symbols such as :string and :integer, one for each field in the query, which are used to specify the types to return. It is ignored if sql-exp is a prepared-statement.
flatp is used as in select and is ignored if sql-exp is a prepared-statement.
result-list is a list of values as per select, and field-names is a list of field names selected in sql-exp.
ExampleThe following two queries, on a table whose second column contains dates that we want to return as strings, are equivalent:
(sql:query "select * from some_table"
:result-types '(nil :string))
(sql:query [select [*]
:from [some_table]
:result-types '(nil :string)])
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4