Guest_imported
New member
- Jan 1, 1970
- 0
This is an ASP problem. where no recordset is appear. eventhough there's record in DB.
I face a problem where I using the IBM DB2 Database (version 5). I try to retrieve a numeric field using ADO. Somehow it just won't load to the ADO recordset. the recordset is 0.
the SQL statement is very simple. Just a normal "SELECT AMOUNT FROM BILL.BILL_TABLE" or "SELECT SUM(AMOUNT) FROM BILL.BILL.TABLE". There no records to be loaded to ADO. But in back-end using the SQL in DB2 Command line processor, Is able to retrieve everything.
I have tried using connection.execute method, recordset.Open method. But doesn't to seems to work.
Please advice.
I face a problem where I using the IBM DB2 Database (version 5). I try to retrieve a numeric field using ADO. Somehow it just won't load to the ADO recordset. the recordset is 0.
the SQL statement is very simple. Just a normal "SELECT AMOUNT FROM BILL.BILL_TABLE" or "SELECT SUM(AMOUNT) FROM BILL.BILL.TABLE". There no records to be loaded to ADO. But in back-end using the SQL in DB2 Command line processor, Is able to retrieve everything.
I have tried using connection.execute method, recordset.Open method. But doesn't to seems to work.
Please advice.