Send Beginners mailing list submissions to beginners@haskell.org To subscribe or unsubscribe via the World Wide Web, visit http://www.haskell.org/mailman/listinfo/beginners or, via email, send a message with subject or body 'help' to beginners-requ...@haskell.org
You can reach the person managing the list at beginners-ow...@haskell.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Beginners digest..." Today's Topics: 1. Re: Can't find or open a Sqlite3 database in Windows Vista (Patrick Lynch) 2. Re: Can't find or open a Sqlite3 database inWindows Vista (Patrick Lynch) 3. Lujvo forming with cmavo rafsi (Alex Rozenshteyn) 4. Re: Lujvo forming with cmavo rafsi (Brent Yorgey) 5. Sqlite3 - INSERT statement question (Patrick Lynch) ---------------------------------------------------------------------- Message: 1 Date: Thu, 03 Feb 2011 10:08:39 -0500 From: "Patrick Lynch" <kmandpjly...@verizon.net> Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database in Windows Vista To: "Kathleen Lynch" <kmandpjly...@verizon.net>, <beginners@haskell.org> Message-ID: <AA64B861B2784C8BA9C015579F4AC1CF@UserPC> Content-Type: text/plain; charset="iso-8859-1" ...could this be the problem...in Windows Vista I cannot change the file name in the directory c:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci but can change it in c:\users\user directory... ...> ren "c:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci\test1.db" test2.db Access is denied. ...but I can see the contents of this file: ...> type test1.db hello, world! ...is it possible to specify the directory c:\users\user in ghci so that Sqlite3 will look there to open the database and then to create a table in it? Good day ----- Original Message ----- From: Kathleen Lynch To: beginners@haskell.org Sent: Wednesday, February 02, 2011 5:28 PM Subject: [Haskell-beginners] Can't find or open a Sqlite3 database in Windows Vista ...seems like I 'kicked over another bee hive'...plenty of messages in regard to this when you do google search--->[sqlite3.operational error unable to open database file in windows vista] ...i'm getting the following error messages when I try to create a database in Sqlite3: *Sandbox> dbh <- connect "poddbtest.db" *** Exception: SqlError {seState = "", seNativeError = 21, seErrorMsg = "prepare 6: BEGIN: unable to open database file"} *Sandbox> dbh <- connect "test1.db" *** Exception: SqlError {seState = "", seNativeError = 1, seErrorMsg = "step: SQL logic error or missing database"} Both come from Chapters 21 and 22 in "Real World Haskell" I can't invoke Sqlite3 from the command line using---> Sqlite3 myDatabase.db... I created blank files in folder C:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci -- seemed to get me a bit further along...at least I was able to connect... Is it possible to specify the folder that the database should be created in? Is it possible to run Sqlite3 from the command line - when it has been installed using the Haskell wiki? Has anyone had better success with MySql - I've used it in the past and it was very reliable? Thank you ------------------------------------------------------------------------------ _______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://www.haskell.org/pipermail/beginners/attachments/20110203/1d0b2fa6/attachment-0001.htm> ------------------------------ Message: 2 Date: Thu, 03 Feb 2011 11:24:29 -0500 From: "Patrick Lynch" <kmandpjly...@verizon.net> Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database inWindows Vista To: "Patrick Lynch" <kmandpjly...@verizon.net>, <beginners@haskell.org> Message-ID: <2DCD8113D8DA4ED68B6699F18F8A66B8@UserPC> Content-Type: text/plain; charset="iso-8859-1" ...this seems to work: ghci> conn <- connectSqlite3 "/users/user/test1.db" ...this allows me to create a database in this directory, named test1.db, and then I can create a table in this database... ...I'm now working on writing some queries... ...wish me luck ----- Original Message ----- From: Patrick Lynch To: Kathleen Lynch ; beginners@haskell.org Sent: Thursday, February 03, 2011 10:08 AM Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database inWindows Vista ...could this be the problem...in Windows Vista I cannot change the file name in the directory c:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci but can change it in c:\users\user directory... ...> ren "c:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci\test1.db" test2.db Access is denied. ...but I can see the contents of this file: ...> type test1.db hello, world! ...is it possible to specify the directory c:\users\user in ghci so that Sqlite3 will look there to open the database and then to create a table in it? Good day ----- Original Message ----- From: Kathleen Lynch To: beginners@haskell.org Sent: Wednesday, February 02, 2011 5:28 PM Subject: [Haskell-beginners] Can't find or open a Sqlite3 database in Windows Vista ...seems like I 'kicked over another bee hive'...plenty of messages in regard to this when you do google search--->[sqlite3.operational error unable to open database file in windows vista] ...i'm getting the following error messages when I try to create a database in Sqlite3: *Sandbox> dbh <- connect "poddbtest.db" *** Exception: SqlError {seState = "", seNativeError = 21, seErrorMsg = "prepare 6: BEGIN: unable to open database file"} *Sandbox> dbh <- connect "test1.db" *** Exception: SqlError {seState = "", seNativeError = 1, seErrorMsg = "step: SQL logic error or missing database"} Both come from Chapters 21 and 22 in "Real World Haskell" I can't invoke Sqlite3 from the command line using---> Sqlite3 myDatabase.db... I created blank files in folder C:\Program Files (x86)\Haskell Platform\2010.2.0.0\winghci -- seemed to get me a bit further along...at least I was able to connect... Is it possible to specify the folder that the database should be created in? Is it possible to run Sqlite3 from the command line - when it has been installed using the Haskell wiki? Has anyone had better success with MySql - I've used it in the past and it was very reliable? Thank you ---------------------------------------------------------------------------- _______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://www.haskell.org/pipermail/beginners/attachments/20110203/7ef026b6/attachment-0001.htm> ------------------------------ Message: 3 Date: Thu, 3 Feb 2011 11:52:13 -0500 From: Alex Rozenshteyn <rpglove...@gmail.com> Subject: [Haskell-beginners] Lujvo forming with cmavo rafsi To: beginners <beginners@haskell.org> Message-ID: <AANLkTinDG=fzfvyadvbwayjo3wed4rashrx9ydegc...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Specifically, I want to form a lujvo meaning "omnicide" (to ta'o this is due to the tvtropes trope "Omnicidal Maniac" ta'onai toi). {ro zei catra} or {rolcatra} seems to be wrong. {ro zei se catra} seems like it's all the victims, so maybe selrolselcatra? I'm not quite clear on what it means to be a lujvo if you don't have a tanru as the basis. -- Alex R -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://www.haskell.org/pipermail/beginners/attachments/20110203/9bf5075f/attachment-0001.htm> ------------------------------ Message: 4 Date: Thu, 3 Feb 2011 12:10:38 -0500 From: Brent Yorgey <byor...@seas.upenn.edu> Subject: Re: [Haskell-beginners] Lujvo forming with cmavo rafsi To: beginners@haskell.org Message-ID: <20110203171037.ga13...@seas.upenn.edu> Content-Type: text/plain; charset=us-ascii On Thu, Feb 03, 2011 at 11:52:13AM -0500, Alex Rozenshteyn wrote: > Specifically, I want to form a lujvo meaning "omnicide" (to ta'o this is due > to the tvtropes trope "Omnicidal Maniac" ta'onai toi). {ro zei catra} or > {rolcatra} seems to be wrong. > > {ro zei se catra} seems like it's all the victims, so maybe selrolselcatra? > > I'm not quite clear on what it means to be a lujvo if you don't have a tanru > as the basis. Me neither. You probably need to use zygohistomorphic prepromorphisms. -Brent ------------------------------ Message: 5 Date: Thu, 03 Feb 2011 12:20:12 -0500 From: "Patrick Lynch" <kmandpjly...@verizon.net> Subject: [Haskell-beginners] Sqlite3 - INSERT statement question To: <beginners@haskell.org> Message-ID: <210F0EF34664470D8080C74D8689A9E5@UserPC> Content-Type: text/plain; charset="iso-8859-1" Good morning, I'm using "Real World Haskell" and a Windows Vista PC and I have Sqlite3 installed...[note: I had to change test1.db to /users/user/test1.db in order to get this to work, otherwise, neither the database nor the table could be created -- also, note c:/users/user/test1.db gives a syntax error], ghci doesn't like c:/]: I tried to use the following example from the book but it failed...see following: Prelude> :m Database.HDBC Database.HDBC.Sqlite3 Prelude Database.HDBC Database.HDBC.Sqlite3> conn <- connectSqlite3 "/users/user/test1.db" ... Prelude Database.HDBC Database.HDBC.Sqlite3> run conn "INSERT INTO test VALUES (?, ?)" [toSql 0, toSql "zero"] <interactive>:1:43: No instance for (Data.Convertible.Base.Convertible t SqlValue) arising from a use of `toSql' at <interactive>:1:43-49 Possible fix: add an instance declaration for (Data.Convertible.Base.Convertible t SqlValue) In the expression: toSql 0 In the third argument of `run', namely `[toSql 0, toSql "zero"]' In the expression: run conn "INSERT INTO test VALUES (?, ?)" [toSql 0, toSql "zero"] I'd appreciate any advice... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://www.haskell.org/pipermail/beginners/attachments/20110203/1a0c5b3d/attachment.htm> ------------------------------ _______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners End of Beginners Digest, Vol 32, Issue 6 ****************************************