Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^3: DBD_ODBC 1.21 does not accept DBI::SQL_LONGVARCHAR as data type anymore?

by mje (Curate)
on Jun 02, 2009 at 16:02 UTC ( #767660=note: print w/replies, xml ) Need Help??


in reply to Re^2: DBD_ODBC 1.21 does not accept DBI::SQL_LONGVARCHAR as data type anymore?
in thread DBD_ODBC 1.21 does not accept DBI::SQL_LONGVARCHAR as data type anymore?

This is technically a bug in DBD::ODBC since it does not follow the DBI specification in making parameter types sticky. However, an easy workaround for now is simply to leave the binding in the code but remove the data from the execute call.

A proper fix is available in DBD::ODBC 1.21_1 which will appear on CPAN shortly.

  • Comment on Re^3: DBD_ODBC 1.21 does not accept DBI::SQL_LONGVARCHAR as data type anymore?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://767660]
help
Chatterbox?
[hippo]: Make it an option?
[Corion]: hippo: Yes, but I'm not sure that it's even worth the effort of implementing it at all...
[Corion]: You'll only ever need that option if you have a long-running query whose results are not cached by your DB already, and in those cases I presume that the programmer will want to maintain the temporary tables themselves - I wouldn't know when to drop ...
[Corion]: ... the temporary tables, and also don't have a good idea on how to create unique table names for them
[hippo]: OIC. In that case leave it out but invite feature requests and see if any of the users suggest it. :-)
[Corion]: Talking about this makes me realize that it's likely only a half useful idea. But it still would be convenient to have as an option...
[Corion]: hippo: Hmmm - yeah, I could document it and wait for code implementing that option to show up ;-D

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (11)
As of 2017-02-23 15:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (347 votes). Check out past polls.