comment on

Brethern and cistern, I petition you. My forehead is much flatter than it was and my monitor is cracked.

I have an object where $self->things is an array. I would like to fill XXXXXXX in the code below with the name of the current $self->things and then do a query on each things name.

{
    my $self = shift;
    my $slobbo = "select * from bleh where whatever = ";
    my $connection = $self->connection;

foreach ($self->things) {
    my $name = new thang($_);
    my $thangsname = XXXXXXX
    my $sth = $connection->connection->prepare( $slobbo.$thangsname );
}
}
[download]

I have tried everything that I can think of. I have used tye's References Quick Reference, which I found wonderfully enlightening. Every time I try to view that concatenated SQL query, the name of thing is missing.

Please help.

In reply to Dereference an array reference by fmogavero

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


There's more than one way to do things
	PerlMonks