- Code: Select all
var query='SELECT aktiviteitid FROM aktiviteit WHERE begintijd BETWEEN \''+utils.dateFormat(globals.calendar_datum, 'yyyy-MM-dd 00:00:00.000')+'\' AND \''+utils.dateFormat(globals.calendar_datum, 'yyyy-MM-dd 23:59:59.999')+'\'';
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, null, 1000);
controller.loadRecords(dataset);
It generates the following SQL-query
- Code: Select all
SELECT aktiviteitid FROM aktiviteit WHERE begintijd BETWEEN '2004-04-21 00:00:00.000' AND '2004-04-21 23:59:59.999'
it also generates the following error:
- Code: Select all
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131: Syntax error near 'BETWEEN' on line 1 ASA Error -131: Syntax error near 'BETWEEN' on line 1
Now i tried using " instead of ' and various variations.....I also used another query like
- Code: Select all
SELECT aktiviteitid FROM aktiviteit WHERE begintijd >= '2004-04-21 00:00:00.000' AND begintijd <= '2004-04-21 23:59:59.999'
it generated a similar error.....only instead the error beeing near to BETWEEN it now was near >=
The date-notation is according to ASA.
What am i doing wrong here?? Thx for the help in advance
Servoy Developer
Version R2 2.0 rc12-build 271
Java version 1.4.2_04-b05 (Windows 2000)