|
From: Mark W. <mwa...@bi...> - 2005-11-03 09:27:19
|
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 |