[CLOSED] Insert record into Oracle database table from html page
I have a html page designed using the Webfocus HTML designer with two textbox and a button.
Objective: To save the entered texts into a table in Oracle database.
Searched the forum and found this solution. Tried implementing for just one column. I am calling this javascript function via the ' task & animations - onClick'
function add_row() { new_row = document.getElementById("editbox1").value; var request = '/ibi_apps/WFServlet?IBIC_server=EDASERVE&|IBIAPP_app=reports&|IBIF_adhocfex=MODIFY FILE SAMPLE_EXP_TEST%0D%0AFREEFORM NAME%0D%0AMATCH NAME%0D%0AON MATCH REJECT%0D%0AON NOMATCH INCLUDE%0D%0ADATA%0D%0A'+new_row+',$%0D%0AEND&|Rand='+Math.random();
On button click the code executes, but there is no addition into the table. could someone please point what am I missing?This message has been edited. Last edited by: FP Mod Chuck,
Also I would put the MODIFY code in a fex that the html form references then you can also reference your edit box parameters for the data values you want to insert. The method of using a function may work but the other way is cleaner (just my opinion)
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats