Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2014-08-30 15:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (293 votes), past polls