Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: question mark?

by sachmet (Scribe)
on Apr 29, 2001 at 20:08 UTC ( #76479=note: print w/replies, xml ) Need Help??


in reply to question mark?

As Trimbach pointed out, creating a subroutine to handle miscellaneous SQL is not always a good idea unless you know what you're doing with it.

That said, your real problem is that you're using " and not '. In my testing, I have found that text inside 's is immune to being replaced by bind variables. I could be wrong, though. :-)

INSERT INTO some_tbl (some_text) VALUES('Hello?') works in Oracle, at least, using your subroutine.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2021-04-20 19:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?