Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Not A Problem
-
1.5.0
-
None
Description
See forum entry
http://www.nabble.com/forum/ViewPost.jtp?post=20293296&framed=y&skin=22882
With (mysql db)
<from uri="timer://pollTheDatabase?delay=10000" />
<setBody>
<constant>select username as userid from mdl_user
where firstname='' or lastname = '' or email = '' or idnumber=''
</constant>
</setBody>
<to uri="jdbc:moodleDB" />
I get the error
Column 'username' not found.
If I remove "as userid" the route works...