• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Long Varchar and distinct
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Long Varchar and distinct


  • Subject: Re: Long Varchar and distinct
  • From: Chuck Hill <email@hidden>
  • Date: Wed, 6 Oct 2010 16:07:14 -0700

On Oct 6, 2010, at 12:38 PM, Jeffrey Simpson wrote:

> The database that I am working with is DB2.  I have a very old plugin.  I plan on writing a new plugin and submitting it to Wonder.  With that said,  I ran into a problem with a column defined as a Long Varchar.  When I batch fetch the entity with the long varchar the Sql that is generated includes a distinct and you can not distinct a long varchar.  Is there someway to tell EOF not to distinct an entity with a long varchar in it?  When I do rewrite our plugin do I need to do something special to handle the cases of long varchars?

My guess is that you will need to do something special to handle this case.

Chuck

>
> I did notice that ERXSQLHelper has shouldPerformDistinctInMemory but as far as can see it is never called.
>
>
> Thanks.
>
>
> Jeffrey Simpson
> Senior Software Engineer
> Telephone: 240.235.2144
> Fax: 240.235.2174
> email@hidden
>
> Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world.
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >Long Varchar and distinct (From: Jeffrey Simpson <email@hidden>)

  • Prev by Date: Re: TurnKey Installer Components
  • Next by Date: Re: D2W & an Unmodeled Relationship
  • Previous by thread: Long Varchar and distinct
  • Next by thread: Problem launching WO533 project
  • Index(es):
    • Date
    • Thread