return distinct records using subsonic 3 query and VB
Posted
by HR
on Stack Overflow
See other posts from Stack Overflow
or by HR
Published on 2010-04-07T13:21:02Z
Indexed on
2010/04/07
13:23 UTC
Read the original article
Hit count: 604
I have been having issues trying to return distinct records from a subsonic3 query using VB. My base query looks like so:
Dim q As New [Select]("Region")
q.From("StoreLocation")
q.Where("State").IsEqualTo(ddlState.SelectedValue)
q.OrderAsc("Region")
This returns duplicates. How can I add a distinct clause in this to return distinct records? I have been trying to place around with Contraints, but to no avail.
Thanks in advance HR
© Stack Overflow or respective owner
