cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paul cannon <p...@datastax.com>
Subject Re: execute_prepared_cql_query and variable range filter parameter
Date Mon, 30 Apr 2012 21:36:12 GMT
Hi Pierre-

Yes, each ? can only represent one value at a time (although it can take on
a different value for each actual execution of the prepared query). This is
certainly normal for SQL binding libraries. Not sure why you feel that
defeats statement preparation.

p

On Mon, Apr 30, 2012 at 3:45 PM, Pierre Chalamet <pierre@chalamet.net>wrote:

> Hi all,****
>
> ** **
>
> Is there a support in Cassandra 1.1 for variable range filter parameter
> (sorry I can’t find a right name for that):****
>
> select * from TestCF where key in (?)****
>
> ** **
>
> using execute_prepared_cql_query ?****
>
> ** **
>
> In the query above, it seems I can only bind one value to ‘?’.****
>
> I mean, if several values are required for ‘?’ then I have to rewrite the
> query using several jokers.****
>
> ** **
>
> My problem is that this defeats statement preparation (using
> prepare_cql_query).****
>
> ** **
>
> Maybe there is a way to bind an array of values to a single command joker ?
> ****
>
> ** **
>
> Thanks !****
>
> - Pierre****
>
> ** **
>

Mime
View raw message