Repeated arguments in a prepared statement

Question

consider a query that looks something like this:

my $query=<<QUERY;

select * from foo1 where col < ?
union all
select * from foo2 where col < ?
QUERY

Assume that the actual query really needs unions and can't be efficiently solved another way. The variable in the where clause will always be the same. Is there any way I can structure this so that I only need to pass 1 argument to execute instead of passing the same argument twice?

Answer 1

Could try the following, I'm assuming you're passing an integer to the where clause...

DECLARE @variableName as int

SET @variableName = ? --the value gets passed here once

select * from foo1 where col < @variableName -- and gets used here
union all
select * from foo2 where col < @variableName -- and here!

Answer 2

You could use the list repetition operator.

$sth->execute(($value) x 2);