var result = 'select message from people.users where event_time > ? and event_time < ? allow filtering';
client.execute(result,[startdate,enddate], function(err,result)
This is not working its showing :
GET /favicon.ico 500 17.785 ms - 386
{ [ResponseError: Expected 8 or 0 byte long for date (10)]
name: 'ResponseError',
message: 'Expected 8 or 0 byte long for date (10)',
info: 'Represents an error message from the server',
code: 8704,
query: 'select message from people.users where event_time > ? and event_time <
? allow filtering' }
There is a mismatch between the type expected by Cassandra (timestamp) and the value provided (it looks like it is not Ecmascript Date).
It should be something like:
var startDate = new Date('2015-01-01');
var endDate = new Date();
var query = 'select message from people.users where event_time > ?' +
' and event_time < ? allow filtering';
client.execute(query, [startDate, endDate], { prepare: true}, callback);