Derived attributes 
Author Message
 Derived attributes

Hi folks,

sorry if this might seem a bit too specific to WebObjects: I've used a
couple of derived attributes in my WebObjects app's EOModel. Simple stuff
along the lines of:

(SELECT COUNT(*) FROM address WHERE address.eoid_customer = customer.eoid)

in the Customer entity. (eoid being pk and eoid_customer fk) This worked
nicely with OpenBase, i.e. it simply returned the number of addresses a
particular customer has registered. Using the same expression with Postgres
returns in fact the row count of the address table. Is there a way to make
Postgres use the eoid of the current row instead of checking for matches
between eoid_customer and _any_ eoid in the customer table?

Any hints greatly appreciated!


---------------------------(end of broadcast)---------------------------

Sun, 03 Jul 2005 21:52:54 GMT
 [ 1 post ] 

 Relevant Pages 

1. attribute's attributes

2. xsl:element | xsl:attribute - How do i dynamically assign values to the attributes before output

3. Please help: Derived or Temporary tables

4. SP3 bug in derived table?

5. Trying to use stored procedure as derived table in a join

6. Check if a Derived Member exists ?

7. Derived value

8. using derived columns in computations

9. help with nested/derived select [filtering duplicate records]

10. derived data with select query

11. Derived select help needed

12. Stored Proc Result (derived)

Powered by phpBB® Forum Software