I have a variable in my vbscript that I need to assign a value from the Oracle db. Assuming I connect to the db and all.
Is this how i retrieve the value
Dim intMonth
strSQL = "select fld from tble where ...."
set rs = db.execute(strSQL)
if rs.eof then
...some code here
else
intMonth = rs("fld"
end if
I know this will work for Access, but is it the same for Oracle?
Is this how i retrieve the value
Dim intMonth
strSQL = "select fld from tble where ...."
set rs = db.execute(strSQL)
if rs.eof then
...some code here
else
intMonth = rs("fld"
end if
I know this will work for Access, but is it the same for Oracle?