Sorry, about previous reply.
Here's the solution. Replace your executeImmediate with something like this.
Use one of your data objects for "doSomeDataObject"
String sqlString = "select CONVERT(CHAR(10),LOGIN_TIMESTAMP,101),
CUSTOMER_ID, COUNT(*)" +
" from Web_Account_Login" +
" group by CONVERT(CHAR(10),LOGIN_TIMESTAMP,101),
CUSTOMER_ID",10000);
CSpDBExecuteControl execute =
new CSpDBExecuteControl(true, true,
CSpDBExecuteControl.MEMORY_TABLE_FETCH_METHOD,
0, 5, CSpDBExecuteControl.FROM_TABLE_BEGINNING,
CSpDBExecuteControl.ORDERED_FORWARD );
CSpDBConnection conn = new
CSpDBConnection(CSpider.getDataSource("DsMeasurement "));
CSpDBSQLRequest request = new CSpDBSQLRequest(conn, new
CSpDBTransactionControl(),
execute,
sqlString);
CSpDataObject aDataObject = CSpider.getDataObject("doSomeDataObject");
int x = aDataObject.execute(request);
CSpDBResult results = aDataObject.getLastResults();
Thanks,
Paul Gentile
_______________________________________________________
Cardinal Group International, Inc. 508 620 9119x170
495 Old Connecticut Path [EMAIL PROTECTED]
Framingham, MA 01701 www.cardinalgroup.com
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
