Function

Summary

Queries a database and returns a list of values.

Package

sql

Signature

query sql-exp &key database result-types flatp => result-list, field-names

Arguments

sql-exp

An SQL query statement to be performed.

database

A database.

result-types

A list of symbols.

flatp

A boolean.

Values

result-list

A list of values.

field-names

A list of strings.

Description

The function query is the basic SQL query function. It queries the database specified by database with an SQL query statement given by query-expression .

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.

flatp is used as in select .

result-list is a list of values as per select, and field-names is a list of field names selected in sql-exp .

See also

do-query
execute-command
loop
map-query
select