Re: [htoolkit-users] HSQL 1.6 only returning

[Mark W. <mwa...@bi...>]

A call is being made to set SQL_ATTR_ROW_ARRAY_SIZE to 2 however this is =
only compiled in if MSSQL_ODBC is defined which it was in the Setup.lhs =
that I had.=20

I can't access CVS to confirm if this is in the main source tree or why =
it was put in.

Cheers

Mark
  ----- Original Message -----=20
  From: Mark Wassell=20
  To: hto...@li...=20
  Sent: Tuesday, November 01, 2005 9:12 PM
  Subject: [htoolkit-users] HSQL 1.6 only returning


  Hi,

  I am using HSQL 1.6 with ODBC to a MySQL database on Windows XP. When =
I do a query only every other row is being returned (ie only half of the =
rows).=20

  Does anyone have any idea what might be going on? I don't have a =
problem using Ruby.

  The code is based on the example code:

  retrieveRecords :: Connection -> IO [[String]]
  retrieveRecords c =3D do
   query c "select * from treenode " >>=3D collectRows getRow
   where
    getRow :: Statement -> IO [String]
    getRow stmt =3D do
     f1           <- (getFieldValue stmt "id")
     return [show (f1::Int)]


  main =3D handleSql print $ do
   bracket (connect datasource user_id password) disconnect $ \c ->
       inTransaction c $ \c -> do
                 rs <- retrieveRecords c
          mapM print rs
          putStrLn ""

  Cheers

  Mark