Getting a 'Null Pointers' error when using query ofQueries

[DaveLrs01]

Hi,

I am using text in a file to create a new query.
This section works correctly.

I am then using query of Queries:-

<cfquery dbtype="query" name="MyQoQQuery">
SELECT *
FROM qMyQuery
</cfquery>

"qMyQuery" is the name of the new query I have created from the text file.

It all works fine until I get 54 rows in the query when it sotps working and
gives me a

'java.lang.NullPointerException'

any ideas?

Dave

[shp.jc]

Whenever I've had problems with QofQ it's come down to datatyping problems.

CF looks at the first row to assign column data types.

If later on in the data set a value is introduced that doesn't match what it
guessed (let's say it was a blank column and CF figured STRING and later on an
INT appears), it can throw that error.

Hope that helps.

[DaveLrs01]

Thank you,

I looked at the datatypes and values and found 1 Int value missing therefore it threw up an error.

Dave