Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^2: DBI place holder for sub query problem

by Anonymous Monk
on Jan 02, 2008 at 16:52 UTC ( #660005=note: print w/ replies, xml ) Need Help??


in reply to Re: DBI place holder for sub query problem
in thread DBI place holder for sub query problem

Thank you for your input, but when I tried it I get

DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR: +error possibly near <*> indicator at char 30 in 'Update Customers set + RESULTS =:<*>p1....
is this because it is a sql string and not a number. The sqlstring, when executed alone returns a number. TIA


Comment on Re^2: DBI place holder for sub query problem
Download Code
Re^3: DBI place holder for sub query problem
by jettero (Monsignor) on Jan 02, 2008 at 18:09 UTC
    If it's not a bind variable then it's not a bind variable. The bind vars get meta-quoted automagically, sql probably should not be, so I don't think you can use a bind variable to do that job.

    -Paul

Re^3: DBI place holder for sub query problem
by olus (Curate) on Jan 02, 2008 at 22:06 UTC
    If you are using a sub-query then the parenthesis are needed. Just omit the single quotes.
    $sth=$dbh->prepare("Update Customers set RESULTS = (?) where rec_no = +?");
    From the error message, it seems like you are assigning RESULTS with something like SELECT.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2015-07-04 18:14 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 (60 votes), past polls