pass a varble in WHERE clause instaed of a constant

[naveen yadav]

hi ranchers ,

i'm developing a application in JavaScript for TItanium(Android) where i need to execute a query something like :
i had number of rows in database with same date so i need to figure out that for each date how many rows are there
let say
var res = dbconn.execute("SELECT * FROM events WHERE start_date='2013-1-04' " );
above is working fine it is returing 2 rows

but i need to pass date in a variable like
var date = 2013-1-04 var res = dbconn.execute("SELECT * FROM events WHERE start_date="+date );

its not working as desired returning 0 rows.how can i resolve this?

[Ivan Jozsef Balazs]

You might have forgotten the apostrophes that delimit a string literal.