Re: [Haskelldb-users] DBDirect ELF incompatibility (zlib) when using mysql driver

[Marc W. <mar...@gm...>]

> I once ran into a similar problem in ghci when I had an unneccessary 
> "-lc" in the package configuration, and my libc.so was a linker script. 
Thanks a lot.. It's working like a charm now..

I have some suggestions.. I don't know wether you've already thought
about this?

The example still use genericConnect (which seems to be dynConnnect
,now)...
One thing I checked for (because I had this problem some years ago using
different databases) is quoting that they use different quoting. It took
me some time to realize that this is not implemented (I've grepped the
whole source many times for ` and [. beeing used by MySQL and MS
Access. So by now it's not possible to use whitespaces in field names.

Databases have additional functions. Such as adding dates, random
numbers (what the hell there might be) String functions (might be done
in haskell.. What might be faster?)..  Would be really unbeatable to
have some kind of abstraction here, too. Unfortunately I'm not familiar
enough with the code, yet.

I'm still trying to get everything to work.
Is this correct 
myquery=do -- << query works find
  t<-Q.table TblLang.languages
  return t

main=do
  t <- connect $ \db -> query db myquery
  (\r -> (putStrLn.show) r!TblLang.iD) (GHC.List.head t) -- << here many errors after trying to only get field TblLang.iD
  mapM_ (putStrLn . show) t -- showing all works fine


errors: (copied from vim)
test2.hs|34| 26:
||     No instance for (Select (Attr StoreDatabase.Languages.ID Int)
|| 			    (IO ())
|| 			    (IO a))
      arising from use of `!' at test2.hs|34| 26
||     Probable fix:
||       add an instance declaration for (Select (Attr StoreDatabase.Languages.ID
|| 						    Int)
|| 					      (IO ())
|| 					      (IO a))
||     In a lambda abstraction:
|| 	\ r -> ((putStrLn . show) r) ! StoreDatabase.Languages.iD
||     In a 'do' expression:
|| 	(\ r -> ((putStrLn . show) r)
|| 		! StoreDatabase.Languages.iD) (GHC.List.head t)
||     In the definition of `main':
|| 	main = do
|| 		 t <- connect $ (\ db -> query db myquery)
|| 		 (\ r -> ((putStrLn . show) r)
|| 			 ! StoreDatabase.Languages.iD) (GHC.List.head t)
|| 		 mapM_ (putStrLn . show) t

Does this mean I've forgotton to import a module?
i've tried adding all exposed modules (ghc-pkg describe haskelldb)
Same result.
Do you have again some hints?

Marc