Member since Feb 27, 2014
- Profile: /members/11660-mark-james.htm
- Comments: 1
Recent Blog Comments By Mark James
Encountered "(. Incorrect Select Statement, Expecting a 'FROM', But Encountered '(' Instead, A Select Statement Should Have a 'FROM' Construct.
Posted on Feb 27, 2014 at 3:28 PM
I found this same issue when trying to use MID() in a cfquery of a query (PDF Solr Collection). I've been going nuts trying to find away around this problem all day. I need part of the date string in the URL to order my results. <cfquery dbtype="query" datasource="search" ... read more »