Re: order by column problem (fwd)

[Fred Gerson]

Hey Eric,

Thanks again for your help. Per your request, attached below is my schema.
I can't seem to get addAscendingOrderByColumn() working on either of these
tables. Any strategies you would suggest for debugging? (Again I'm using
torque 3.0 that came with tdk 2.2)

Thanks,
Fred


<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<database>
    <table name="Affinityinfo">
        <column name="Afinfid" primaryKey="true"
            required="true" type="INTEGER"/>
        <column default="" name="Clientnumber" size="255" type="VARCHAR"/>
        <column default="" name="Cycle" size="255" type="VARCHAR"/>
        <column default="" name="Blocklogo" size="255" type="VARCHAR"/>
        <column default="" name="Clientref" size="255" type="VARCHAR"/>
        <column default="" name="Clientnamedifferent" size="255" type="VARCHAR"/>
        <column default="" name="Clientname" size="255" type="VARCHAR"/>
        <column default="" name="Signername" size="255" type="VARCHAR"/>
        <column default="" name="Signertitle" size="255" type="VARCHAR"/>
        <column default="" name="Phonenumber" size="255" type="VARCHAR"/>
        <column default="" name="Weblink" size="255" type="VARCHAR"/>
        <column default="" name="Maelig" size="255" type="VARCHAR"/>
        <column default="" name="Gsppct" size="255" type="VARCHAR"/>
        <column default="" name="Usr" size="255" type="VARCHAR"/>
        <column default="" name="Timestamp" size="255" type="VARCHAR"/>
        <column default="" name="Address" size="255" type="VARCHAR"/>
    </table>
    <table name="Changes">
        <column name="Changeid" primaryKey="true"
            required="true" type="INTEGER"/>
        <column default="" name="User" size="255" type="VARCHAR"/>
        <column default="" name="Changetable" size="255" type="VARCHAR"/>
        <column default="" name="Changecolumn" size="255" type="VARCHAR"/>
        <column default="" name="Oldval" size="255" type="VARCHAR"/>
        <column default="" name="Newval" size="255" type="VARCHAR"/>
        <column name="Primkey" size="255" type="VARCHAR"/>
        <column default="" name="Address" size="255" type="VARCHAR"/>
        <column default="" name="Timestamp" size="255" type="VARCHAR"/>
    </table>
</database>

---------- Forwarded message ----------
Date: Thu, 13 Mar 2003 03:04:17 -0800 (PST)
From: Fred Gerson <[EMAIL PROTECTED]>
To: Eric Emminger <[EMAIL PROTECTED]>
Cc: Turbine Torque Users List <[EMAIL PROTECTED]>
Subject: Re: order by column problem

Hey Eric,

Thank you very much for your reply. I tried your suggestion below (for
both the CYCLE and the CLIENTNUMBER columns) but still got the same
problem.

Any suggestions of where I can start to look to try and debug?

Thanks a lot,
Fred


On Wed, 12 Mar 2003, Eric Emminger wrote:

> The addAscendingOrderByColumn() method works for me, although I only use
> it once on a single Criteria. Does it work for you if you use it just
> once, as below?
>
> Criteria criteria = new Criteria();
> criteria.addAscendingOrderByColumn(AffinityinfoPeer.CYCLE);
> //criteria.addAscendingOrderByColumn(AffinityinfoPeer.CLIENTNUMBER);
> return AffinityinfoPeer.doSelect(criteria);
>
> Eric
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]