Re: [sqlite] Starting with TCL

[Cecil Westerhof]

I have the following:
    set getLatestTeasStr {
        SELECT   Tea
        FROM     teaInStock
        ORDER BY LastUsed DESC
        LIMIT    5
        ;
    }

But because I want to define the limit at runtime I want to change it to:
    set getLatestTeasStr {
        SELECT   Tea
        FROM     teaInStock
        ORDER BY LastUsed DESC
        LIMIT    ?
        ;
    }

​In Java I would do something like:
     psSel.setInt(1, nrToFetch);​

​How do I do this in TCL?​

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users