Recordset value return as 0?

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Recordset value return as 0?

Logged in as: Guest

arrSession:exec spGetSession 2,2,833

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Recordset value return as 0?
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Recordset value return as 0? - 4/21/2003 12:41:41 AM

kclow

Posts: 1
Score: 0
Joined: 4/21/2003
From:
Status: offline

Hi, just facing some weird problem as I am running a VBS program.
Am using this VBS to generate a report to Excel by selecting from a DB (through DSN)... but I faced 2 strange problems:

a) After calling
sql_str = "select * from POSITION_HOLD"
Set rs = conn.execute(sql_str)

All the numeric fields selected returns 0 when I do as follow:
Total_Investment_unit = rs("POS_T_INVEST_UNIT")

b) If I call the sql_str as "select * from POSITION_HOLD order by FUND_CODE", I will get an error:
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

Can anyone help me, as I normally use VB without any problem... but now I am required by user to use VBS instead!

Thanks in advance...

kclow