List of addDescendingOrderByColumn() Examples

Examples of addDescendingOrderByColumn()

org.apache.torque.criteria.Criteria.addDescendingOrderByColumn()
Add order by column name, explicitly specifying descending. @param column The column to order by. @return A modified Criteria object.
org.apache.torque.util.Criteria.addDescendingOrderByColumn()
Add order by column name, explicitly specifying descending. @param name The name of the column to order by. @return A modified Criteria object.

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()

    }


    public void testOrderByDescendingIgnoreCaseString() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addDescendingOrderByColumn(stringColumnMap, true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT UPPER(TABLE.COLUMN1) FROM TABLE "
                    + "ORDER BY UPPER(TABLE.COLUMN1) DESC",

View Full Code Here

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()

    }


    public void testOrderByDescendingIgnoreCaseInteger() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addDescendingOrderByColumn(integerColumnMap, true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN4 FROM TABLE "
                    + "ORDER BY TABLE.COLUMN4 DESC",

View Full Code Here

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()


    public void testOrderByDescendingIgnoreCaseStringInCriteria()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addDescendingOrderByColumn(stringColumnMap);
        criteria.setIgnoreCase(true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT UPPER(TABLE.COLUMN1) FROM TABLE "

View Full Code Here

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()


    public void testOrderByDescendingIgnoreCaseIntegerInCriteria()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addDescendingOrderByColumn(integerColumnMap);
        criteria.setIgnoreCase(true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN4 FROM TABLE "

View Full Code Here

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()

          Criteria ordcrit = new Criteria();
          ordcrit.add(DorderPeer.DISTRIBUTOR_ID, distributorId);
          ordcrit.add(DorderPeer.PRODUCT_ID, productId);
          ordcrit.add(DorderPeer.STATUS, 50, Criteria.EQUAL);


          ordcrit.addDescendingOrderByColumn(DorderPeer.DORDER_CODE);
          context.put("orders", DorderPeer.doSelect(ordcrit));
        }
        catch (Exception e)
        {
        }

View Full Code Here

Examples of org.apache.torque.util.Criteria.addDescendingOrderByColumn()

            String sortCol= new String(getSortColumn(sortNo));
            if (sortCol.length()>0){
                if (orderStr.equals("ASC")){
                    criteria.addAscendingOrderByColumn(sortCol);
                }else{
                    criteria.addDescendingOrderByColumn(sortCol);
                }
            }
        }


        criteria.setIgnoreCase(true);

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.