Re: Problem with table joins with Class::DBI


Perl-Sensitive Sunglasses
	PerlMonks

Re: Problem with table joins with Class::DBI

by Anarion (Hermit)

on Dec 24, 2003 at 16:38 UTC ( #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

Comment on Re: Problem with table joins with Class::DBI Select or Download Code

In Section Seekers of Perl Wisdom

Node Status^?

node history
Node Type: note [id://316887]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others chanting in the Monastery: (9)

As of 2013-06-19 03:32 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

How many continents have you visited?

Results (639 votes), past polls