• 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
help needed with query
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

help needed with query


  • Subject: help needed with query
  • From: Theodore Petrosky <email@hidden>
  • Date: Mon, 4 Feb 2008 05:57:52 -0800 (PST)

First, most of my experience is with cocoa. I could
write any query I wanted even across relationships. I
am having a problem with relationship in WO.

I am starting out with a new simple setup. My db is
normalized like this

table names:
firstname text
lastname text
nameid (serial)

namesbusinessmeta:
iscurrent bool  default true
phonenumber text
extension text
nbmid
namesFKid foreign key to names

I have a trigger and function on the db that creates a
new insert into namesbusinessmeta with the referenced
foreign key on insert into the names table.

This works fine.

but now I want to query from my WO app.
select * from names where nameid in (select namesFKid
from namesbusinessmeta where iscurrent = true) order
by lastname;

I am lost.... I want an array of current employees
where the iscurrent  bool is in relationship table.

Maybe I am barking up the wrong tree......

Ted








      ____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
 _______________________________________________
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

  • Follow-Ups:
    • Re: help needed with query
      • From: Don Lindsay <email@hidden>
    • Re: help needed with query
      • From: David Avendasora <email@hidden>
    • Re: help needed with query
      • From: "Daniele Corti" <email@hidden>
  • Prev by Date: Re: Question regarding new inline style
  • Next by Date: Re: help needed with query
  • Previous by thread: Re: Short question (legacy usage?)
  • Next by thread: Re: help needed with query
  • Index(es):
    • Date
    • Thread