Send Beginners mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
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" <[email protected]>
Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database
in Windows Vista
To: "Kathleen Lynch" <[email protected]>,
<[email protected]>
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: [email protected]
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
[email protected]
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" <[email protected]>
Subject: Re: [Haskell-beginners] Can't find or open a Sqlite3 database
inWindows Vista
To: "Patrick Lynch" <[email protected]>,
<[email protected]>
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 ; [email protected]
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: [email protected]
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
[email protected]
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 <[email protected]>
Subject: [Haskell-beginners] Lujvo forming with cmavo rafsi
To: beginners <[email protected]>
Message-ID:
<[email protected]>
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 <[email protected]>
Subject: Re: [Haskell-beginners] Lujvo forming with cmavo rafsi
To: [email protected]
Message-ID: <[email protected]>
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" <[email protected]>
Subject: [Haskell-beginners] Sqlite3 - INSERT statement question
To: <[email protected]>
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
[email protected]
http://www.haskell.org/mailman/listinfo/beginners
End of Beginners Digest, Vol 32, Issue 6
****************************************
