Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^2: SQL prepared statements using MySQL In ()

by djlerman (Sexton)
on Aug 11, 2023 at 16:53 UTC ( [id://11153822]=note: print w/replies, xml ) Need Help??


in reply to Re: SQL prepared statements using MySQL In ()
in thread SQL prepared statements using MySQL In ()

Thank You. This is similar to how I solved it.
# Set up variable for the Parameters for the entire query my @sqlParameters = (); # set up variable for just the IN() statement my @valuesForIn = (1,2,3,4,5); # a value for another field my $field3 = 'abc123'; my $query = " SELECT field1 FROM table1 WHERE field2 IN (@{[join',', ('?') x @valuesForIn]}) AND field3 = ? "; push(@sqlParameters, @valuesForIn); push(@sqlParameters, $field3); my $sth = $dbh->prepare($query) or die $dbh->errstr; $sth->execute(@sqlParameters) or die $dbh->errstr;
Note: I kept separate @sqlParameters variable J.I.C. the query needs to be extended with more parameters.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11153822]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-07-16 07:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.