//curYear=2012
//start_dts is column in my table.
- Code: Select all
foundset.loadRecords('SELECT id from tablename WHERE datepart(yyyy,start_dts)=?',[curYear]
Above syntax is incorrect. anyone please correct me where I went wrong.
Thank you in advance.