Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-08 Thread Tim Docker
Jason: Thanks for the reply. I suspect the solution is to correctly tell Haskell what type you expect and then hopefully HDBC will do the conversion. For example, using fromSql: http://software.complete.org/static/hdbc/doc/Database-HDBC.html#v% 3AfromSql Yes. I can use fromSql to

Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-08 Thread John Goerzen
Tim Docker wrote: Jason: Thanks for the reply. I suspect the solution is to correctly tell Haskell what type you expect and then hopefully HDBC will do the conversion. For example, using fromSql: http://software.complete.org/static/hdbc/doc/Database-HDBC.html#v% 3AfromSql Yes. I can

Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-08 Thread Tim Docker
John Goerzen wrote: Tim Docker wrote: Yes. I can use fromSql to convert the result back to an appropriate numerical type. But internally the numeric data has still been converted to an intermediate string representation. I'm wondering if this is intentional, and whether it matters. Yes

Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-08 Thread John Goerzen
Tim Docker wrote: *Main fmap (fromSql.head.head) $ quickQuery c select getdate() [] :: IO Data.Time.Clock.UTCTime 2010-04-09 09:59:20.67 UTC *Main fmap (fromSql.head.head) $ quickQuery c select getdate() [] :: IO Data.Time.LocalTime 2010-04-09 09:59:26.313 *Main fmap (fromSql.head.head) $

Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-07 Thread Jason Dagit
On Wed, Apr 7, 2010 at 9:08 PM, Tim Docker t...@dockerz.net wrote: I'm experimenting with haskell and relational databases. I have successfully coupled unixodbc + freetds + hdbc-odbc, and can make trivial queries. However, I'm surprised at the result types: $ ghci GHCi, version 6.10.3:

Re: [Haskell-cafe] HDBC-ODBC and SqlValues

2010-04-07 Thread Jason Dagit
On Wed, Apr 7, 2010 at 9:45 PM, Jason Dagit da...@codersbase.com wrote: darcs get --lazy http://darcs.haskell.org/takusen Oops. That's a dead link, try this instead: darcs get --lazy http://code.haskell.org/takusen/ http://code.haskell.org/takusen/