I just spent most of my work day tracking down a bug. There's a little bug in coldfusion's query on queries feature that will cause a null pointer exception even though your code is perfectly fine. To solve the error you have to filter your query results by adding a field, field, field IS NOT NULL to your WHERE statement. People have had a problem with this since 04, and it still hasn't been fixed. Absolutely pathetic.
Join Now to Reply!
To add your own reply, sign in or join Pownce today!