Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Re: DBI execute() args in array format (or similar) possible?

by perrin (Chancellor)
on Aug 12, 2002 at 22:26 UTC ( [id://189661]=note: print w/replies, xml ) Need Help??


in reply to Re: DBI execute() args in array format (or similar) possible?
in thread DBI execute() args in array format (or similar) possible?

Whoa! What is that and why are you doing it? This just doesn't make sense to me. You are supposed to pass an array to @args, not a comma-separated string. What's in your @args array?
  • Comment on Re: Re: DBI execute() args in array format (or similar) possible?

Replies are listed 'Best First'.
Re: Re: Re: DBI execute() args in array format (or similar) possible?
by snafu (Chaplain) on Aug 12, 2002 at 22:33 UTC
    lol...Ok. The array by itself didn't work. Here is some better output:

    $perl * -d 01-Jul-2002 -c uslecatl5e1 Preparing statement: select clli, traffic_date, count(distinct(traffic_hour)) from gvc_traffic30 where traffic_date in (?) and clli in (?) and traffic_type = 'N' group by clli, traffic_date, traffic_hour running with args : 01-Jul-2002 uslecatl5e1 For all those that question...@args is: 0 :01-Jul-2002 1 :uslecatl5e1

    It was the only way I could match the number of args that I needed to send to execute with the number of '?'s that I prep'ed $statement with.

    _ _ _ _ _ _ _ _ _ _
    - Jim
    Insert clever comment here...

Log In?
Username:
Password:

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

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

    No recent polls found