PetalPoco.Page and DISTINCT Incorrect syntax

Open eman1986 opened this issue 12 years ago • 3 comments

Hi,

It seems when I try to use a query using .Page that has the DISTINCT keyword it throws an error:

Incorrect syntax near '*'

The query I'm using executes with no errors when I run it from SQL Studios so I'm curious what the problem could be.

Dec 16 '13 16:12 eman1986

Yeah I am getting the same error. Does anyone know if there is an update on this?

Apr 06 '15 04:04 ghost

Is there something about this?

Dec 13 '18 04:12 arhandres

Can someone provide a specific example of a query that fails?

Dec 13 '18 11:12 asherber