Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
how to get all the query result if there is more than one record?
Migrateduser
Hi,
I have the query like this:
select a.orgname, a.tndrnum, a.quotetype,a.orgId,
a.openclose, a.closeddate, a.createdby,
a.seqformat, b.firstname, b.lastname, b.title,
c.meetingdate
from sttender a
left join scuser b
on a.createdBy = b.userid
left join sttendersitemeeting c
on a.sysId = c.sysId and a.orgId = c.orgId and a.tndrId = c.tndrId
where a.sysId = ?
and a.orgId = ?
and a.tndrId = ?
I need to show all the meetingdate in one unit.
And I try to get the meetingdate like this:
row["MEETINGDATE"];
I can see there is 2 records for this query through Edit Data Set - Preview Results.
But I only get one record for row["MEETINGDATE"].
How can I get all records?
Thanks,
Jason
Find more posts tagged with
Comments
There are no comments yet