This content has been marked as final. Show 10 replies
A Google of coldfusion "error 18" produces a link to a page that contains the following:
*ERROR 18: File cannot be read
34 0 import ColdFusion.iff
35 0 deport ColdFusion.iff
Have no clue what this means.
What happens when you run the problem-causing query against your database outside of ColdFusion (in MS SQL Query Analyzer, for instance)? Instead of placing your SQL statement inside of the <cfquery> tags, output it to the screen and then copy and paste into Query Analyzer (make sure it is the H='H' condition). Try that then let us know what happens.
I couldn't find very much on google. File cannot be read? but only some of the time?
The query where it stops is a Query of Query, so it won't run directly against the database without a great deal of modification. The modified version did run, but how can we trust the results?
What we need is one of the ColdFusion developers to tell us what makes '18' come up.
Seen wild things with QoQ when the column-datatypes were not defined, for ex. with queries created qith QueryNew().
The participating queries, where do they come from, DB or other? What CF-version are you using?
I have ColdFusion version 7,0,2,142559.
The database is Oracle, and the columns have datatypes. If H = 'X' is okay, why wouldn't H = 'H' ? Could datatypes have anything to do with that? The two participating queries come from Oracle, and I can run them fine, everytime.
Could we see the query?
Hold on. Where are you getting the H or X from? Are these really hard coded in or are they actually variables?
So is it H='#H#' or really H='H' ?
It really is a literal: H = 'H'.
You are right, seeing the SQL queries might help, and I hope it doesn't confuse.
Since the query of queries orders by Short_Building_no, one would expect Short_Building_no to be in the select-list.
In standard SQL ordering by a column that isn't selected isn't a problem. But this is a QoQ, so maybe the rules are different. But what is the difference then if I say H='X' (this works) or H='H' (this doesn't work).