: query="select ID, title_full as TITLE_NAME, YEAR, : COUNTRY_OF_ORIGIN, modified as RELEASE_DATE from title limit 10">
Are you certian that the first 10 results returned (you have "limit 10") all have a value in the "modified" field? if modified is nullable you could very easily just happen to be getting 10 docs that don't have values in that field. -Hoss