Focal Point
How to populate combobox with the data fetched from the table

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9561086181

August 22, 2006, 12:52 AM
Aditya
How to populate combobox with the data fetched from the table
Hi,

I am pasting my code below.
I am basically trying to fetch data from the database using a procedure.The procedure returns me P_REPORT.Then i call a HTML page that allows the users to execute four different options.I need the P_REPORT to be assigned to a as a hidden field inside my HTML BEGIN so that i can use it in furthure processing.However i am not able assign P_REPORT to the hidden input text box as i dont know the syntax.I am able to display it using
!IBI.FIL.&P_REPORT;.

This message has been edited. Last edited by: Aditya,
August 22, 2006, 03:33 AM
Tony A
That's because you do not have an !IBI.FIL.&P_REPORT; this is due to the fact that you have the line in your code -

ON TABLE HOLD FORMAT HTMTABLE AS REPORT

so your inclusion should be !IBI.FIL.REPORT;

Also, when you include HTML on this forum, use the code tags enclosed in square brackets (e.g. [ code] and [/code] without spaces) and then we won't have the problem of trying to read your HTML.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 22, 2006, 03:38 AM
Tewy
The IBI.FIL command needs to be on its own line.

Try:

  
<input type="text" value="
!IBI.FIL.REPORT;
">



Tewy


WF 7.6.11
Output: HTML, PDF, Excel
August 22, 2006, 07:19 AM
Tony A
You can always edit it again to insert the []



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 22, 2006, 07:44 AM
Tony A
Not really the effect required Smiler

Delete your last two postings. You do this by clicking on the icon showing a folder overlaid with a pencil. Select Delete and then confirm you want to delete it.

Now edit the one before my last post. Again use the folder and pencil icon to get to the edit.

Go to the beginning of your code and insert [ code] (without the space) before the first piece of code.

Now go to the very end of your code and insert [/code] after it.

Now you should be OK.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10