Skip to Content
0
Mar 22, 2012 at 12:52 PM

How to fetch results from SQL query returning multiple rows?

56 Views

Hi,

I need to use sql query in custom code for reminder emails.

I refered below code :

import com.frictionless.api.common.platform.IapiDbHandleIfc;    dbHandle = session.getDbHandle();  dbHandle.beginTransaction();  sQuery = "SELECT DOC_DESCRIPTION " +       "FROM " +       "FCI_CUSTOM_MD2 " +       "WHERE " +       "EID = '" + sParameter + "'";  dbHandle.executeQuery(sQuery);

But my query would return multiple rows with different types of column data.

What will be the return type of Query Results?

How to fetch multiple rows, where to return them?

Please guide me through.

Thanks,

Saloni