Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^3: RFC: Placeholder creation for SQL statements

by Eily (Monsignor)
on Mar 09, 2018 at 18:40 UTC ( [id://1210586]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $username = 'LanX';
    my $req1 = $db->xprepare(ph { "SELECT from users WHERE nick = '$userna
    +me'" });
    $username = 'Eily';
    my $req2 = $db->xprepare(ph { "SELECT from users WHERE nick = '$userna
    +me'" });
    $req1->xexecute();
    $req2->xexecute();
    
  2. or download this
    my %vars = (rank => 'Pope', xp => 4);
    my $req1 = $mytool->xprepare(ph { "SELECT from users WHERE rank = '$_{
    +rank}' AND xp > '$_{xp}'" } %vars );
    $req1->execute(); #There's no reason your new object can't call its me
    +thod execute BTW
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2024-04-16 17:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found