GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  RESOURCEPOOL::COMMAND::DBI::SELECTROW (3)

.ds Aq ’

NAME

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

CONTENTS

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.

CW$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.



Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 RESOURCEPOOL::COMMAND::DBI::SELECTROW (3) 2004-05-02

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.