WOPopupButton bind to database and dynamic dependant ( newbie question )
WOPopupButton bind to database and dynamic dependant ( newbie question )
- Subject: WOPopupButton bind to database and dynamic dependant ( newbie question )
- From: Alvaro Muir <email@hidden>
- Date: Mon, 10 Feb 2003 01:20:42 -0500
Hello all,
Sorry for the newbie question, but I'll try to be specific. Does anyone
have any examples or can point me to some resources on binding WOPopupButton
to a database? Here's is what I would like to do.
1. I have created an EOModel of my database, really a small DB with just one
table. Lets suppose its a small db of sports as follows:
teamID | state | city | sport | team
----------------------------------------------------
0101 NY NY basketball Knicks
0102 NY NY baseball Yankees
0103 NY Buffalo football Bills
0304 FL Miami footballl Dolphins
0302 FL Miami basketball Heat
0310 FL Orlando basketball Magic
0320 FL Tampa football Buccaneers
0330 FL Jacksonville football Jaguars
Etc.
2. I would like to bind WOPopupButton to a certain table, lets say the State
with a basic SQL query like "SELECT DISTINCT state from TEAMTABLE", to
return just the states, one time only.
3. From that, I would like my next WOPopupButton to populate based on the
previous selection. I.e., If "FL" was selected, the next WOPopupButton
should only have FL cities, like Orlando, Jacksonville, Tampa, Miami, blah
blah. Then down the line to populate the other WOPopups based on previous
selection.
So my question is two-tier. First binding my WOPopup button to my already
created EOModle database, and secondly ( if possible ) how to create dynamic
dependant WOPopupButtons. The first is much more important, Im sure I can
find the second part somewhere.
If anyone has any ideas, sample code or whatever please feel free to let me
know. Sorry for the long question, thanks for your time.
--
Alvaro Muir
Language Resource Center
Columbia University
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.