[plt-scheme] Parameters in sqlite

From: Jay McCarthy (jay.mccarthy at gmail.com)
Date: Mon Apr 6 11:02:54 EDT 2009

I've replied to your bug report.

Short version: You are looking at the version 4 docs but using the
version 3 package.

Jay

On Mon, Apr 6, 2009 at 4:12 AM, Erich Rast <erich at snafu.de> wrote:
> Hi,
>
> Is anyone using the Planet sqlite package successfully in 4.1.5 with the
> scheme language? I don't have a machine with examples here, but (from
> memory) the following things don't seem to work:
>
> 1.) Using exec/ignore or any other function with optional parameters
> produces a contract violation, indicating that in contrast to the manual
> only (exec/ignore db "sql-statement as string") without parameters is
> allowed. Strange enough, I've looked at the source code and it looks
> alright to me---optional parameters are passed as rest like in (define
> (fun arg1 arg2 . rest). I can't any problem with that. Something with
> the contracts?
>
> 2.) Preparing a statement like "CREATE TABLE ? (id INTEGER PRIMARY KEY,
> name TEXT);" using prepare, and then loading the parameter like in
> (load-params stm "test") yields an SQL syntax error near "?". But AFAIK,
> the ? is perfectly valid for an unnamed parameter in SQLITE3. It's as if
> the unicode string is incorrectly converted to something invalid in
> SQLITE.
>
> I've filed a bug report on PLanet, but still wonder whether I'm not
> doing something obviously wrong or just misunderstood the docs. Or is
> this a sort of Plt Scheme version incompatibility?
>
> Best regards,
>
> Erich
>
> _________________________________________________
>  For list-related administrative tasks:
>  http://list.cs.brown.edu/mailman/listinfo/plt-scheme
>



-- 
Jay McCarthy <jay at cs.byu.edu>
Assistant Professor / Brigham Young University
http://teammccarthy.org/jay

"The glory of God is Intelligence" - D&C 93


Posted on the users mailing list.