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 Sun, 16 Mar 2003 00:03:51 GMT
I just did some more testing regarding the below
add[Ascending|Descending]OrderByColum() problem and I want to report the
method works beautifully when it's passed an INTEGER column. When I pass
it a VARCHAR column I still nothing back.  (when I was using tdk2.1
I passed VARCHAR columns no problem though) Anyone know what might have
broke (or where I can look).

Thanks,
Fred



On Sat, 15 Mar 2003, Fred Gerson wrote:

> 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
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


Mime
View raw message