Re^2: Simple DBI question, select rows based on an array


Clear questions and runnable code get the best and fastest answer
	PerlMonks

by ruzam (Curate)

on Nov 05, 2009 at 13:44 UTC ( [id://805264]=note: print w/replies, xml )

Need Help??

That could get you into trouble with quote problems in @array values or worse sql-injection. At the very least you should use the DBI quote method:

my $sql = 'SELECT * FROM table WHERE column IN (' .
   ( join ',', map { $dbi->quote($_) } @array ) . ')';
[download]

Or better, use placeholders

my $sql = 'SELECT * FROM table WHERE column IN (' .
   '?' . (',?' x $#array) . ')';
[download]

Comment on Re^2: Simple DBI question, select rows based on an array Select or Download Code

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://805264]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others cooling their heels in the Monastery: (6)

As of 2024-04-23 07:43 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found