Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

URL - comma separated list of values to assign page items includes '&'

Don Grubbs-83624Apr 2 2009 — edited Jul 4 2011
I want to pass values to page items in a URL that include ampersands ' &'

example: ...f?p=209:1:::::P1_IND:AEROSPACE%20%26%20DEFENSE
the expectation is that AEROSPACE & DEFENSE would be passed to the P1_IND item on Page 1 of application 209
the page item is a select_list and the display value in the select list is AEROSPACE & DEFENSE
This URL results in an error - mod_plsql: /pls/eds/f HTTP-400 Missing '=' in query string or post form (from firefox) ...(IE only returns a HTTP 400 ...but you can find the mod_plsql error in the Apache error_log)

If I issue the same URL as above, but this time change the page item P1_IND to Display as Text (escape Special characters, does not save state)
the URL successfully calls the page and displays the value in item P1_IND -- AEROSPACE & amp; DEFENSE (without the space between the & and amp... I could not determine how to get the combined word to render here)

Once again with the same URL but this time the page item P1_IND set to Display as Text (Does not save state)
the URL successfully calls the page and displays the value in item P1_IND -- AEROSPACE & DEFENSE

QUESTION: How do you pass a value to a 'select list' page item in a URL when the page item includes an ampersand?
...and what is the relevance of the mod_plsql error .../f HTTP-400 Missing '=' in query string or post form
This post has been answered by 660196 on Jul 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2011
Added on Apr 2 2009
8 comments
3,835 views