title: Grails executeQuery giving me "no such property" exception
body: <p>I have a domain class called Event:</p>
  
  <pre><code>class Event{
      String eventID // an ID for the event, (there are multiple events with same eventID)
      .....
  }
  </code></pre>
  
  <p>In my eventService class I want to get all events with distinct eventIDs, so I have the following query:</p>
  
  <pre><code>Event.executeQuery("select distinct e.eventID from Event e", [max: max, offset: offset])
  </code></pre>
  
  <p>According to <a href="http://grails.org/doc/2.0.x/ref/Domain%20Classes/executeQuery.html" rel="nofollow">the grails docs</a> it should work. However, I'm getting this error:</p>
  
  <pre><code>| Error 2012-05-10 18:14:09,643 [http-bio-8080-exec-9] ERROR errors.GrailsExceptionResolver  - MissingPropertyException occurred when processing request: [POST] /events/event/list - 
  No such property: id for class: java.lang.String. Stacktrace follows:
  Message: No such property: id for class: java.lang.String
  
  Line | Method
  -&gt;&gt;   35 | run                 in C__src_Event_events_grails_app_views_event__List_gsp
  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  |     18 | render . . . . . .  in org.events.EventController
  |     67 | list . . . . . . .  in     ''
  |   1110 | runWorker           in java.util.concurrent.ThreadPoolExecutor
  |    603 | run . . . . . . . . in java.util.concurrent.ThreadPoolExecutor$Worker
  ^    722 | run                 in java.lang.Thread
  </code></pre>
  
  <p>I am fairly new to grails and any help would be greatly appreciated. Btw I'm using Grails 2.0.1.</p>