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

Re: DBI help please

by ruzam (Curate)
on Dec 07, 2010 at 21:28 UTC ( #875894=note: print w/ replies, xml ) Need Help??

in reply to DBI help please

execute() only accepts values to pass "into" the query. You can't use it as a two way communication channel. Each parameter must match exactly one place holder, and each place holder will be replaced by the matching parameter. The value of "$value" (and any other parameters) will be exactly the same after the query as it was before.

If this were MySQL you would probably read the $dbh->{'mysql_insertid'} value to get the inserted auto-increment key, after the execute(). I don't know how Oracle accomplishes the same trick.

Comment on Re: DBI help please

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2015-11-29 15:56 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (751 votes), past polls