db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fred Gerson <fredg...@wrath.forked.net>
Subject Re: order by column problem (fwd)
Date Sat, 15 Mar 2003 23:41:05 GMT
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 <fredgers@wrath.forked.net>
To: Eric Emminger <eric@ericemminger.com>
Cc: Turbine Torque Users List <torque-user@db.apache.org>
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
>



Mime
View raw message