Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: DBI and money columns

by ncw (Friar)
on Aug 31, 2000 at 10:54 UTC ( [id://30479]=note: print w/replies, xml ) Need Help??

in reply to DBI and money columns

We used this for a while at work, ie MS SQL Server with DBI & DBD::ODBC & openlink. I seem to remember that the money field is buggy in DBD::ODBC or maybe it was in the openlink driver.

My memory of the problem was that money fields needed to be strings when input to the DBI ie in '', sending them as numbers ie without '' or as placeholders didn't work. (Or possibly the other way round - it was a while ago now.) I remember that we could never get the money fields to be entered as placeholders though.

We solved this problem (and many others) by switching to MySQL ;-)

Log In?

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

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (5)
As of 2024-05-28 00:38 GMT
Find Nodes?
    Voting Booth?

    No recent polls found