Passing concatenated string to page item passes only part of string
458506Nov 13 2006 — edited Nov 15 2006I have a select list, based on query with the same concatenated display and return values:
select distinct db_patcher d, db_patcher r
from cpujan2006
where db_patcher is not null
and db_patcher <> ' '
order by 1
I also have another text item that displays concatenated version of app user's name:
select db_patcher r from cpujan2006 where db_patcher = (select last_name||', '||first_name
from wwv_flow_users
where user_name = :APP_USER)
I'm setting up a shortcut button for patchers whereby they click and filters are set to show their open requests, which means I need to set the patcher select list to same value of app user item. The button's redirect should pass the concatentated app_user, text value to the select list, but it doesn't work. I tried passing it to a text field and found that only the last name was getting rendered, minus the comma and first name. Looking at the source, it looks like the entire string is passed, it just doesn't render that way. Here is an excerpt from redirect source:
.... P98_X_DB_PATCHER:Patch%2C%20Michelle .....
and the
app user item value:
...TYPE="text" NAME="p_t01" SIZE="30" MAXLENGTH="2000" VALUE="Patch, Michelle"...
Any help appreciated!