Search code examples
sqlcoldfusioncoldfusion-8qoq

ColdFusion Query Of query

This query:

SELECT * FROM getlogs WHERE id > #id# AND logType = "login" LIMIT 1

Gives me this error:

Error Executing Database Query.


Query Of Queries syntax error.
Encountered "logType. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 0, column 0. Encountered: "\"" (34), after : ""
Solution

  • Use max rows:

    < cfquery dbType="query" name"myQ" maxrows="1">
    SELECT * FROM getlogs WHERE id > #id# AND logType = "login"
    < /cfquery>