Lines Matching refs:statement
29 Foo->set_sql($sql_name, $statement, $db_name);
30 Foo->set_sql($sql_name, $statement, $db_name, $cache);
36 $sth = $obj->sql_*; # Where * is the name of the sql statement.
51 use of database connections and statement handles by storing DBI and
82 the Perl). Alternatively, you can place your SQL statement alongside
95 you actually prepare a statement on that connection.
157 one prepared statement handle (per statement, per database user).
164 information straight into the SQL statement. Bind columns are more
193 you never use the same SQL statement twice. Not sure, I haven't
219 Use sql_* to retrieve your statement handles ($sth) as needed and db_*
327 Foo->set_sql($sql_name, $statement, $db_name);
328 Foo->set_sql($sql_name, $statement, $db_name, $cache);
330 This method is used in place of DBI->prepare to create your statement
331 handles. It sets up a new statement handle associated to $sql_name using
332 the database connection associated with $db_name. $statement is passed
334 $cache) to create the statement handle.
337 prepare the statement handle and it will be cached. If $cache is false
338 then a normal prepare() will be used and the statement handle will be
339 recompiled on every sql_*() call. If you have a statement which changes
342 A new method is created for each statement you set up. This new method
347 The actual statement handle creation is held off until sql_* is first
350 To make up for the limitations of bind parameters, $statement can contain
358 my ($class, $sql_name, $statement, $db_name, $cache) = @_;
376 $class->_mk_sql_closure($sql_name, $statement, $db_meth, $cache);
382 my ($class, $sql_name, $statement, $db_meth, $cache) = @_;
390 my $sql = $class->transform_sql($statement => @_);
482 you'd run that statement with sql_GetAllFoo().
485 already connected, and the statement handle is prepared. It returns a
486 prepared statement handle for you to use. (You're expected to
490 your statement, assuming you have sprintf() formatting tags in your
491 statement. For example:
496 # statement 'Select * From Bar'
634 # Uses cached database and statement handles