All of the examples in the documentation for the db package use either question-mark placeholders or numbered placeholders, i.e. "select * from some_table where some_column = ?" "select * from some_table where some_column = $1"
The three databases that I use (SQL Server, MySQL, and Postgres) all support the question mark syntax, but you can only refer to a single parameter once in a query with the question mark. MySQL and Postgres support numbered parameters, but SQL Server does not. Or at least, not that I'm aware of. I've never seen anyone use it that way, and I can't find any examples online. Regardless, I rather much prefer named parameters, anyway, as it makes the queries easier to read. "select * from some_table where some_column = $param1" I know MySQL, Postgres, AND SQL Server all can support this style (well, replacing $ with @ for SQL Server), because I have a boat load of C# code doing it right now. But there is no indication of how to execute such a query in Racket with DB.
____________________ Racket Users list: http://lists.racket-lang.org/users
