SYNOPSIS

DBStatement<a> prepare( DBHandle<a> con, String query )

ARGUMENTS

con The database connection

query The query template. This may contain replacement characters at some places (consult the manual for the specific database to find out what replacement syntax should be used) which will be replaced with variables in the DB.execPrepared (3kaya) function.

DESCRIPTION

Prepare a database query. Prepared queries can then be executed later, using a parameter-replacement method that generally avoids SQL injection attacks.

  • st = prepare(con,"SELECT * FROM Users WHERE username = $1");

AUTHORS

Kaya standard library by Edwin Brady, Chris Morris and others ([email protected]). For further information see http://kayalang.org/

LICENSE

The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation.

RELATED

DB.DBStatement (3kaya)

DB.execPrepared (3kaya)