Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: bind variables with array

by gmax (Abbot)
on Jun 07, 2004 at 15:45 UTC ( #362024=note: print w/ replies, xml ) Need Help??


in reply to bind variables with array

I see two three potential problems with your code:

  • your query is using 1 = ?. Was that just a careless example or are you trying to put some column names as parameters?
  • Are you sure that $1 and $2 are set to a meaningful value before you call the sub?
  • Your sub is not returning anything. What's going to happen after the execute?

Apart from that, passing an array of parameters is a legitimate way of calling execute, as you can see in DBI docs and DBI Recipes.

Can you build a simple and short test case, with sample data, so we can see where and how your script fails?

 _  _ _  _  
(_|| | |(_|><
 _|   


Comment on Re: bind variables with array
Download Code
Re^2: bind variables with array
by hakkr (Chaplain) on Jun 08, 2004 at 11:27 UTC
    Thanks yes that was just a rough example , I found my problem !! If you call execute(()); that is with a blank array you get an error so I had to put in a check to prevent it getting called when no placeholders are passed in
    my $res = (defined @$vars) ? $sth->execute(@$vars) : $sth->execute;

    Thanks for the pointer to the docs looks like execute(@) justs calls bind_param() for each value in the array so it does work.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2014-12-28 16:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (182 votes), past polls