http://qs321.pair.com?node_id=1103424

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks!

I am trying to add place holders to a SQL query, but I am formatting the second query based on a first SQL query.
The code sample here shows what I am trying to do, if its possible:

# The first SQL query to get the state value<br> my $citydata = $dbh->exec_select( "select city,state from mytable wher +e city = ?", $city ); # This one gets me all the values found for state my $statedata = join ' OR ', map { "state = $_->{ state}" } @$citydata +; # Now $statedate gets this: “state = NH OR state = NY”. # I would like to add place holders and pass these values into the sec +ond query # To read like “state = ? OR state ?” my $codedata = $dbh->exec_select( "select code from othertable where + (year=2014 and ($statedata)), $citydata->{state},$citydata->{state} + );

Any help?
Thanks for looking!