Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Problem with Dynamic LOV in WebDB 2.2
Problem with Dynamic LOV in WebDB 2.2 [message #364988] Mon, 31 July 2000 13:51
pygmyfish
Messages: 2
Registered: July 2000
Junior Member
Hi All,

I have a sports teams database. On one form, users enter the league information, then, they need to enter the team information. I want to restrict the team LOV to those teams associated with the league that was just entered. Does anyone know the syntax required to do this?

The query looks roughly like:

select team_name, team_id
from teams a
where a.league_id = :league_id

I thought ':league_id' would reference the value entered in the form, but I can't get it to work. I've tried a variety of other syntax too. Help!!
Previous Topic: Migrating from WebDB 2.1 to 2.2
Next Topic: how can I do this on webdb????urgent???
Goto Forum:
  


Current Time: Thu Mar 28 05:48:38 CDT 2024