How do you convert the following simplified SQL statement into Query Builder code using the .between() function?
- Code: Select all
SELECT date_start, date_end
FROM table
WHERE ? BETWEEN date_start AND date_end
var args = [ dateTest ]
We tried the QB code below, but a warning is emitted.
- Code: Select all
var query = datasources.db.database.table.createSelect()
query.params[ 'dateTest' ] = dateTest
query.where.add( query.getParameter( 'dateTest' ).between( query.columns.date_start, query.columns.date_end ) )
The method between() is undefined for the type QBParameter<db:/database/table>
Any ideas?