Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: Flexible Update SQL

by bichonfrise74 (Vicar)
on Dec 02, 2010 at 01:14 UTC ( #874795=note: print w/ replies, xml ) Need Help??


in reply to Re: Flexible Update SQL
in thread Flexible Update SQL

But this does not solve the problems:

  • passing null parameters...
  • placement of the comma...


  • Comment on Re^2: Flexible Update SQL
    Re^3: Flexible Update SQL
    by roboticus (Chancellor) on Dec 02, 2010 at 02:53 UTC

      bichonfrise74:

      Actually, placeholders *do* handle the null parameter. Constructing the update statement can do the rest...

      my @fields = qw(name phone city country); my $SQL = "update table set " . join(", ", map { "$_=?" } @fields) . "where ...."; my $ST=$DB->prepare($SQL); while (...) { my @values = (.....); $ST->execute(@values); }

      ...roboticus

      When your only tool is a hammer, all problems look like your thumb.

    Log In?
    Username:
    Password:

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

    How do I use this? | Other CB clients
    Other Users?
    Others chanting in the Monastery: (3)
    As of 2015-07-05 16:28 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









      Results (67 votes), past polls