NAME

       DB::prepare - Prepare a database query

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  (kaya@kayalang.org).  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)

Kaya                                                July 2013                                  DB.prepare(3kaya)