Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Problem with table joins with Class::DBI

by Anarion (Hermit)
on Dec 24, 2003 at 16:38 UTC ( [id://316887]=note: print w/replies, xml ) Need Help??


in reply to Problem with table joins with Class::DBI

You can do various things. According to documentation of Class::DBI you can use something like:
__PACKAGE__->set_sql('update', <<"");
                UPDATE __TABLE__
                SET    %s
                WHERE  __IDENTIFIER__

[download]
and then construct the statement on the fly.

You can use the set_sql method on the fly to create it using a function on the base class of your Class::DBI classes to construct the statements too, something like: 
sub my_sqlset
{
    my ($self,$name,$statement) = @_;
    # escape your statement here
    $self->set_sql($name,$statement);
}

[download]
You can use placeholders to use it latter in a similar search.

And perhaps use UNIVERSAL to check if you already created that function to not waste time.

$anarion=\$anarion;

s==q^QBY_^=,$_^=$[x7,print

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://316887]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2025-07-07 22:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found
    Notices?
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.