Show distinct selection in webform?

Question

If I use a regular distinct selector with MySQL and show the results in a repeater I can show the the data in the webform with the following code.

<%# DataBinder.Eval(Container.DataItem, "posted") %>

But If I use this code:

"SELECT DISTINCT mid(posted,6,1) ORDER BY posted DESC"

I get the following error trying to use the code above.

DataBinding: 'System.Data.Common.DataRecordInternal' does not contain a
property with the name 'posted'.

So how do I get the data I've collected with the "DISTINCT mid"-selector to appear in the webform?

Answer 1

Do this, using an alias:

SELECT DISTINCT mid(posted,6,1) as posted 
FROM Something?
ORDER BY posted DESC