Advanced Lookup Options

[carmina]

I'm not sure if this is a known bug but the SQL query doesn't works in the Advanced Lookup Options after I modify it.

I always run my queries in the SQL editor to make sure I don't have a syntax error
but even when my sql statement is valid and returns a data set in the SQL Admin tool,
I can't get it to work in app gini.

I don't get any errors or warnings when I generate the project but
In the web page the drop down , it says "Searching" but never returns anything.

For example
this is my modified query

SELECT `challenge_activity`.`id`, `challenge_activity`.`activityDate` FROM `challenge_activity` LEFT JOIN `challenge` as challenge1 ON `challenge1`.`challenge_id`=`challenge_activity`.`challengeID`
WHERE `challenge_activity`.`activityDate`= CURDATE() (this is the only thing I added to the original query)
ORDER BY 2

And the below this is what I get. Anybody else having this issue?

Thanks
Carmina

[Bertv]

Hi,
I had the same problem. The reason is a linefeed or cr in the code. All code must be on one row.

[carmina]

Thank you so much Bert! Problem solved!

Carmina