How to read values from an input field and add them into an oracle table?

[geogou1973]

Hello.

I have a vbscript module that inserts values in an oracle table.

sub oracle

set db = CreateObject("ADODB.Connection")

db.open "DSN=XXX;UID=XXX;PWD=XXX"

set Orderfile = db.execute("INSERT INTO QLIKVIEW (STORE, SALES) VALUES ('101', '42000');")

set Orderfile = db.execute("COMMIT;")

db.Close

end sub

It is working correct and inserts the values into the oracle table.

How can i insert values from an input box with variables into the oracle table ?

Let's say i create a variable $(STORE) and $(SALES)

How can i read the variables and insert the values into the oracle table ?

I attach a file.