Re: bind variables with array

[gmax]

I see two three potential problems with your code:

• your query is using 1 = ?. Was that just a careless example or are you trying to put some column names as parameters?
• Are you sure that $1 and $2 are set to a meaningful value before you call the sub?
• Your sub is not returning anything. What's going to happen after the execute?

Apart from that, passing an array of parameters is a legitimate way of calling execute, as you can see in DBI docs and DBI Recipes.

Can you build a simple and short test case, with sample data, so we can see where and how your script fails?

[hakkr]

Thanks yes that was just a rough example , I found my problem !! If you call execute(()); that is with a blank array you get an error so I had to put in a check to prevent it getting called when no placeholders are passed in
my $res = (defined @$vars) ? $sth->execute(@$vars) : $sth->execute;

Thanks for the pointer to the docs looks like execute(@) justs calls bind_param() for each value in the array so it does work.