Re: Query of Queries Error

[lakshmi Suresh]

try to dump query docQry chk if it is returning any row.
On Wed, Sep 26, 2012 at 6:50 PM, Chad Baloga cbal...@gmail.com wrote:


 I am try to run a query of queries to order a query I create on the fly.
 On DEV I do not get an error.  On PROD I am getting:

 The system has attempted to use an undefined value, which usually
 indicates a programming error, either in your code or some system code.

 Null Pointers are another name for undefined values.

 My Code:
 cfquery name=docQryReordered dbtype=query
SELECT * FROM docQry ORDER BY sysModule
 /cfquery

 If I take the ORDER BY out, I still get the error.

 Any suggestions?


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352766
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[lakshmi Suresh]

in select statement try to select one column at a time to chk which
column's data is causing the error.

On Wed, Sep 26, 2012 at 7:12 PM, Chad Baloga cbal...@gmail.com wrote:


 Yes it is, I have been playing with it and dumping results to see what
 data may be causing the error

 try to dump query docQry chk if it is returning any row.
 
 
 


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm