 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| resource layout painter | Login/Join |
| Member |
I have a problem on resource layout painter. I'm trying to develop a html form in layout painter. The form input values' are sent to sql server procedure. I tried to show some value to user, but try to send another information to procedure.In a dynamic drop box is there a way to do it,is it possible to show users one column of table and send another column of that table to procedure,there is an option like display value and display text on static option but i could not find anything on dynamic drop down box And some other issue,when i restart the form page the values which i sent before the server remain same,i think it takes the value from the cache,what can i do to reset previous values from the html form? thanks for your help. | ||
|
| Expert |
Yes, there is. Just use two columns in your fex. For instance, if your SQL table has a column for service_name and service_code, and you want to show the name to your users and pass the code to your procedure, then just - SET HOLDLIST=PRINTONLY
SQL
SELECT service_code
, service_name
FROM [adapter].[owner].[tablename]
WHERE [place your predicate here]
ORDER BY service_name
;
TABLE FILE SQLOUT
PRINT service_code
service_name
ON TABLE PCHOLD FORMAT XML
END
-RUNT
| |||||||||
|
| Member |
as a matter of fact my problem is on the html part. for instance if i were using static list OPTION value=1 displaytext=one>1 OPTION this code shows the user "one" but sends to procedure "1". i'm asking that, if it is possible to do that operation in a dynamic drop down list? | |||
|
| Expert |
As I said, Yes there is, and I have posted the solution above. A dynamic drop-down is supplied by executing a fex at the time of the HTML loading. The above fex is just such an animal and will be run by the JavaScript module "ibirls.js" (actually by an activeX object called from the JS) where the resultant XML is parsed and loaded, dynamically, into the relevant SELECT tag. The XML output from a fex is expected to have the value first and the display as the second column. In your example I would expect it to show 1 to the user and also pass 1 to the fex. To do what you are suggesting (e.g. show "one" to the user and pass "1" to the fex) you would require the code - <OPTION value=1 displaytext=one>one T
| |||||||||
|
| Guru |
In R714 you can also use the HTML Layout Painter to define the data source rather than use an external procedure. In the parameter tab, set the parameter to dropdown, Control values to Dynamic, Select the master file, and then from the list of fields drag the appropriate field to the value field (the one you want to pass) and drag the second field to the display value (the one you want the user to see). ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Member |
piipster can you write the text code of that operation because in my layout painter, there is only data source field and avaliable fieds options are avaliable,that's why, i cant select more then one field | |||
|
| Guru |
What release are you using? ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Member |
we are using webfocus 5.2 | |||
|
| Member |
there was a displayfield option to be able to show users different value,for the older versions there wasnt a display value tag,you should add it to the text code. but i have something else to ask. in a drop down box, the values ordered by according to the data selected in the datafield option. Is there a way to order data in a drop down box, according to displayfield option? for instance if my tables ordered by displayfield,and the values in like these: datafield displayfield 2 january 1 march the drop down box appears in order by datafield march january | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |