Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: Inserting Apostrophes into SQL

by runrig (Abbot)
on Nov 18, 2011 at 20:14 UTC ( [id://938910]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Inserting Apostrophes into SQL
in thread Inserting Apostrophes into SQL

Sybase can only have one active statement handle, but will transparently clone a database handle when necessary (unless you set the "I don't want that" flag).

This means you may run into issues like deadlocks if you're, e.g., inserting in the same loop that you're selecting and fetching in (or other strangeness from having two separate sessions).

And then I also ran into a bug where the cloned database handle didn't have the same client character set as the original (reported on the DBI mailing list).

Update: And I just noticed that the OP doesn't mention Sybase anywhere...so this point may be moot anyway...

Replies are listed 'Best First'.
Re^4: Inserting Apostrophes into SQL
by mpeppler (Vicar) on Nov 24, 2011 at 16:38 UTC
    Just a small clarification - it's not Sybase that clones the connection handle - it's DBD::Sybase that does this to try to provide the behavior that DBI expects.

    Michael

      Yes, sorry, it's kind of like when the tea kettle boils ... :-)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2024-03-29 14:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found