Thanks for the reply Alvaro!
If I don't use a criterion, I get another extra weird error written here below:
java.lang.Error: Unresolved compilation problem:
The method add(String, Object, SqlEnum) is ambiguous for the type Criteria
So it has a problem with:
criteria.add(AreaPeer.POSTCODE, "NULL", Criteria.NOT_EQUAL);
If anyone has any clues or hints or anything useful, I'd be very thankful,
Daniel
Quoting Alvaro Coronel <[EMAIL PROTECTED]>:
> Well... it might have nothing to do with it but for me it is just weird to
> use a Criterion there.
>
> What about this?
>
> criteria = new Criteria();
> criteria.add(AreaPeer.POSTCODE, "NULL", Criteria.NOT_EQUAL);
> criteria.setDistinct();
>
> If this selects distinct, you can go on to adding the order
>
> criteria.addAscendingOrderByColumn(AreaPeer.POSTCODE)
>
> Good luck!
>
> Álvaro.
>
> [EMAIL PROTECTED] wrote:
>
> Hi,
>
> I have a very strange problem with Torque. I'm building a website using
> struts
> where on a certain page, a form is populated by having access to the database
> (MySql) using Torque. So in my ActionForm, I have the following to populate
> an
> option collection.
>
> criteria = new Criteria();
>
> // No postcode with a null value
> Criteria.Criterion notNullPost = criteria.getNewCriterion
> (AreaPeer.POSTCODE, "NULL", Criteria.NOT_EQUAL);
> criteria.add(notNullPost);
>
> // Order the list
> criteria.addAscendingOrderByColumn(AreaPeer.POSTCODE);
>
> // Show only distinct
> criteria.setDistinct();
>
> System.out.println(criteria.toString());
>
> List post = AreaPeer.doSelect(criteria);
> request.getSession().setAttribute("add_postcode_letters", post);
>
> The problem is that the list I get on the page is a list with multiple values
> as
> if the setDistinct() wouldn't have worked.
>
> Yet, when I query the database from the MySql command line using the query I
> got
> from this bit of code: System.out.println(criteria.toString());
> It works under MySql... Here's the sql query:
> mysql> SELECT DISTINCT area.POSTCODE FROM area WHERE area.POSTCODE<>'NULL'
> ORDER
> BY area.POSTCODE ASC;
>
> The table is called area and has 5 columns including the postcode column.
> I'm using Torque 3.1, Tomcat v5 and MySql v4.1
>
> If anyone has any clues or hints or anything useful, I'd be very thankful,
>
> Daniel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
