Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Insert record into Oracle database table from html page
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Insert record into Oracle database table from html page
 Login/Join
 
Member
posted
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();

if(request) {
var xmlDoc = getXmljQueryAjax(request)
} else {
alert("An error populating input control");
}
}


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,


8206
 
Posts: 1 | Registered: April 20, 2020Reply With QuoteReport This Post
Virtuoso
posted Hide Post
WF_Noob

Here is a link to how to use MODIFY. I don't think your example is valid as you have no rows of data... http://ecl.informationbuilders...ource%2Ftopic135.htm

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
 
Posts: 1876 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Insert record into Oracle database table from html page

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.