Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^6: mysql update table how to

by VC (Novice)
on Mar 20, 2019 at 16:56 UTC ( [id://1231502]=note: print w/replies, xml ) Need Help??


in reply to Re^5: mysql update table how to
in thread mysql update table how to

It is PART of another sub routine that only the Admin can access, no user or hacker could even guess or get to were it is, besides no one else came up with an answer? But thanks anyway!

Replies are listed 'Best First'.
Re^7: mysql update table how to
by poj (Abbot) on Mar 20, 2019 at 17:03 UTC

    Why take the risk, it's easy enough to avoid

    my $sql= 'UPDATE EmployerJobs SET Disabled = ? WHERE USERID = ?'; my $dbh = DB::connect (); my $count = $dbh->do($sql,undef,$DISABLED,$userid); $dbh->disconnect (); printf "%d records updated\n",$count;

    also be aware that by not using the ->update_record() method in package DB::TableInfo you could be missing important audit logging or database consistency/integrity checks.


    poj
      Thanks, That's a good Idea!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (2)
As of 2024-04-20 05:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found