protected StringBuilder getPreparedStatementDatasetIDs( AbstractWhereBuilder builder ) { StringBuilder getDatasetIDs = new StringBuilder( 300 ); String rootTableAlias = builder.getAliasManager().getRootTableAlias(); getDatasetIDs.append( "SELECT DISTINCT " ); getDatasetIDs.append( rootTableAlias ); getDatasetIDs.append( '.' ); getDatasetIDs.append( idColumn ); // for SELECT DISTINCT, all ORDER BY columns have to be SELECTed as well if ( builder.getOrderBy() != null ) { // hack to transform the ORDER BY column list in select list String orderColList = builder.getOrderBy().getSQL().toString(); int i = 1; while ( orderColList.contains( " ASC" ) || orderColList.contains( "DESC" ) ) { orderColList = orderColList.replaceFirst( " ASC| DESC", " AS crit" + ( i++ ) ); } getDatasetIDs.append( ',' ); getDatasetIDs.append( orderColList ); } return getDatasetIDs; }
if ( builder.getOrderBy() != null ) { for ( SQLArgument o : builder.getOrderBy().getArguments() ) { o.setArgument( stmt, i++ );
idSelect.append( " WHERE " ).append( wb.getWhere().getSQL() ); if ( wb.getOrderBy() != null ) { idSelect.append( " ORDER BY " ); idSelect.append( wb.getOrderBy().getSQL() ); if ( wb.getOrderBy() != null ) { for ( SQLArgument argument : wb.getOrderBy().getArguments() ) { argument.setArgument( stmt, i++ );
if ( builder.getOrderBy() != null ) { idSelect.append( " ORDER BY " ); idSelect.append( builder.getOrderBy().getSQL() ); if ( builder.getOrderBy() != null ) { outerSelect.append( " ORDER BY " ); String sortCols = builder.getOrderBy().getSQL().toString(); String rootTableQualifier = builder.getAliasManager().getRootTableAlias() + "."; int columnCount = StringUtils.count( sortCols, "," ) + 1; if ( builder.getOrderBy() != null ) { for ( SQLArgument o : builder.getOrderBy().getArguments() ) { o.setArgument( preparedStatement, i++ ); arguments.add( o.getValue() );
String ftTableAlias = wb.getAliasManager().getRootTableAlias(); LOG.debug( "WHERE clause: " + wb.getWhere() ); LOG.debug( "ORDER BY clause: " + wb.getOrderBy() ); if ( wb.getOrderBy() != null ) { sql.append( " ORDER BY " ); sql.append( wb.getOrderBy().getSQL() ); if ( wb.getOrderBy() != null ) { for ( SQLArgument o : wb.getOrderBy().getArguments() ) { o.setArgument( stmt, i++ );