Re: sql select with array

Or, if you're not stuck on using just $dbh->selectall_arrayref and your database supports placeholders, couldn' you do this?

$sth = $dbh->prepare("SELECT " . '? ' x $#selector . "FROM people WHER
+E (fornavn LIKE '%$search%') or (eternavn LIKE '%$search%') or (cpr L
+IKE '%$search%'", \%attr); #dunno if you can do the \%attr part...
$sth->execute(@selector);
[download]

And then you've got a statement handle to get your data from.. I don't know if it's more efficient, but it seems a bit more readable to me.

Comment on Re: sql select with array Select or Download Code

Replies are listed 'Best First'.
Re: Re: sql select with array by busunsl (Vicar) on Oct 23, 2001 at 10:09 UTC
No, you can't. Placeholders are allowed in `where` clauses and as `update` values only. Well, _some_ DBD's support them in the way you'd use them, but I wouldn't rely on that.	[reply] [d/l] [select]