how to get all the query result if there is more than one record?

jjin

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

kclark

What type of object are you placing row["MEETINGDATE"] into? If it's in a grid or single data element then it won't iterate. You would need to put it into a table or list. If you do want to display all of the results for MEETINGDATE in a table you could create a computed column and use concatenate then use the computed column as the data and everything will be displayed.