I know you can use derived attributes in Raw Row fetches (I do this
all the time).  I don't see why they wouldn't work in regular fetches
too.

The exception explains why you can't do that. It's one thing to included derived columns in the results of a query, and quite another to make a derived column part of your qualifier. The derived column is defined in the model, but how would EOF generate a WHERE clause using a derived attribute, since there's no column in the database to access?

On Apr 16, 2007, at 2:08 PM, John Huss wrote:

I know you can use derived attributes in Raw Row fetches (I do this
all the time).  I don't see why they wouldn't work in regular fetches
too.

John

On 4/16/07, Ken Anderson <[EMAIL PROTECTED]> wrote:
No.  Fetch specs work directly against the database, so if the column
doesn't exist (as with derived attributes), it can't work.  You would
have to do a fetch on a superset, then use an in-memory qualifier to
include your derived attribute.

Ken

On Apr 16, 2007, at 10:45 AM, Catarina Vieira Simoes wrote:

> Hi!
>
> Is it possible to do a FetchSpecification over derived attributes?
> I tried and I got the error:
>
> java.lang.IllegalStateException: sqlStringForAttribute: attempt to
> generate SQL for attribute 'attributeName' on entity 'EntityName'
> with undefined column name. You must define a column name for this
> attribute before attempting a database operation.
>
> Since the derived attribute doesn't have a real column it should
> work, no? :)
> Thank you in advance.
> Sincerely,
>
> Catarina
>
>  _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/kenlists%
> 40anderhome.com
>
> This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/johnthuss% 40gmail.com

This email sent to [EMAIL PROTECTED]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1% 40mac.com

This email sent to [EMAIL PROTECTED]

--
Robert Walker
[EMAIL PROTECTED]



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to