I am attempting my first use of the Query Builder and need help replicating the following SQL statement:
SELECT index, mailcode FROM eom WHERE period = ?
Simple, eh?
Here is the initial Query Builder code:
- Code: Select all
var query = databaseManager.createSelect( 'db:/ucsd/eom' )
query.where.add( query.columns.charge_period.eq( query.getParameter( 'period' ) ) )
query.params[ 'period' ] = period
var fs = databaseManager.getFoundSet( 'db:/ucsd/eom' )
fs.loadRecords( query )
and, it loads all records for the given period. Now, I want to select a specific column:
- Code: Select all
var query = databaseManager.createSelect( 'db:/ucsd/eom' )
query.result.add( query.columns.index )
query.where.add( query.columns.charge_period.eq( query.getParameter( 'period' ) ) )
query.params[ 'period' ] = period
var fs = databaseManager.getFoundSet( 'db:/ucsd/eom' )
fs.loadRecords( query )
and, it returns a single column of data for the period as expected. Now, I want to select two specific columns:
- Code: Select all
var query = databaseManager.createSelect( 'db:/ucsd/eom' )
query.result.add( query.columns.index )
query.result.add( query.columns.mailcode )
query.where.add( query.columns.charge_period.eq( query.getParameter( 'period' ) ) )
query.params[ 'period' ] = period
var fs = databaseManager.getFoundSet( 'db:/ucsd/eom' )
fs.loadRecords( query )
and, this is where the problem arises. The following error is emitted:
I have tried re-writing the 'query.result' in two different ways:
- Code: Select all
query.result
.add( query.columns.index )
.add( query.columns.mailcode )
and as:
- Code: Select all
query.result.add( query.columns.index ).add( query.columns.mailcode )
but, they all produce the same error.
What am I doing wrong?