Insert from Input fields to an oracle table

geogou1973 — Fri, 04 Apr 2014 10:53:54 GMT

Hello.

I have a vbscript module that inserts values into 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 ('$STORE', '$SALES');")

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

db.Close

end sub

i have created two input fields with variables STORE and SALES

Can anyone knows how can i read the data that the variables have when i input then and insert them into the oracle table ?

I attach a the file.

Thank you in advance.

Re: Insert from Input fields to an oracle table

sivarajs — Fri, 04 Apr 2014 10:59:41 GMT