Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
ResourcePool::Command:User:ContributedRPsourcePool::Command::DBI::SelectRow(3)

NAME
       ResourcePool::Command::DBI::SelectRow - A DBI command to	execute
       one-row select statements.

SYNOPSIS
	use ResourcePool::Command::DBI::SelectRow;

	# simple usage
	my $cmd	= ResourcePool::Command::DBI::SelectRow->new();
	eval {
	       my @row = $pool->execute($cmd
		       , 'select id, name, value from test where id = ?'
		       , 5
	       );
	    # @row holds an array holding three	values corresponding to	the
	    # selected fields
	};

DESCRIPTION
       This command can	be used	to execute one-row select statements in	a DBI
       database	using the ResourcePool command execution environment.

       In order	to understand this Class, and more importantly this document,
       you need	to know	a few terms I use in this document, if you are new to
       this class you should read the TERMS sections of
       ResourcePool::Command::DBI::Executefirst.

       The use of this class if	safe for all databases and drivers. If the
       select does not return any rows,	the array returned by the execute()
       method will be empty. If	the statement returns more than	one record,
       only the	first is fetched and returned.

   ResourcePool::Command::DBI::SelectRow->new
       Instantiates a new Select object. The parameters	are identical to those
       of the ResourcePool::Command::DBI::Execute class.

   $pool->execute
       Similar to the same named method	of the
       ResourcePool::Command::DBI::Execute class. The only difference is that
       it returns an array holding the columns of the selected row.

TODO
       Documentation
	   Year, we really need	documentation.

SEE ALSO
       DBI, ResourcePool, ResourcePool::Factory

AUTHOR
	   Copyright (C) 2001-2004 by Markus Winand <mws@fatalmind.com>

	   This	program	is free	software; you can redistribute it and/or
	   modify it under the same terms as Perl itself.

perl v5.32.0			  2004ResourcePool::Command::DBI::SelectRow(3)

NAME | SYNOPSIS | DESCRIPTION | TODO | SEE ALSO | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=ResourcePool::Command::DBI::SelectRow&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help