Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Dynamic Input Fields
Dynamic Input Fields [message #247866] Wed, 27 June 2007 07:07 Go to next message
lehenbkp
Messages: 3
Registered: June 2007
Junior Member
I have a package that generates a web page on which the user is asked to select options from various questions. The page is then submitted and answers are posted to the database. For one of the questions, if the user selects "Yes" (default = No) from a drop-down box, I'd like to immediately display additional fields for input. I don't want the additional fields displayed by default since they are not required if the users chooses "No".

Any help would be greatly appreciated. Thanks.
Re: Dynamic Input Fields [message #247885 is a reply to message #247866] Wed, 27 June 2007 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this a PL/SQL question?

Regards
Michel
Re: Dynamic Input Fields [message #247898 is a reply to message #247866] Wed, 27 June 2007 08:11 Go to previous messageGo to next message
lehenbkp
Messages: 3
Registered: June 2007
Junior Member
Sorry, perhaps I didn't explain properly. The web page is created by a PL/SQL package compiled on our Oracle database (9.2.0.6). Most of the web elements (i.e. text, drop-down boxes, radio buttons) are created using PL/SQL Toolkit commands (htp, htf).

Since I am writing PL/SQL packages to create the web pages I thought the PL/SQL forum was the proper place to post my question.
Re: Dynamic Input Fields [message #248098 is a reply to message #247898] Thu, 28 June 2007 01:18 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
This is a javascript thing. Totally unrelated to the tool that generates the page-source.
Re: Dynamic Input Fields [message #248154 is a reply to message #248098] Thu, 28 June 2007 03:18 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
This article talks about that kind of thing for Oracle Application Express. Since it is all handled at the client, you might the solution works even when you are using plain PL/SQL web pages.

Ross Leishman
Re: Dynamic Input Fields [message #248366 is a reply to message #248154] Thu, 28 June 2007 14:20 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Of course this is a relevant Apex question.
Re: Dynamic Input Fields [message #248383 is a reply to message #247866] Thu, 28 June 2007 15:34 Go to previous messageGo to next message
lehenbkp
Messages: 3
Registered: June 2007
Junior Member
Thanks for all the replies, especially the article re: javascript...much appreciated.

[Updated on: Thu, 28 June 2007 15:35]

Report message to a moderator

Re: Dynamic Input Fields [message #248844 is a reply to message #247866] Mon, 02 July 2007 07:05 Go to previous messageGo to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
You can do this by keeping the optional fields in a different page and call the page by validation using AJAX. Since AJAX does not require page submit, controls will be displayed when user selects appropriate option in the dropdown.
Re: Dynamic Input Fields [message #254733 is a reply to message #248154] Fri, 27 July 2007 14:09 Go to previous message
rj_gom
Messages: 2
Registered: July 2007
Location: Manila
Junior Member
That is a good article...thank you for the sharing
Previous Topic: Shell Script in HTMLDB
Next Topic: Apex & Ebusiness Suite
Goto Forum:
  


Current Time: Tue Apr 16 08:26:31 CDT 2024