null pointer? need your expertise!
Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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. i have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
how do i get extra debugging information about the null pointers as just saying it tried to reference a null value isnt helping me find what the issue is? thanks richard Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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. i have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery Take those commas outa there. ?? Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 20, 2008 3:39 PM Subject: Re: null pointer? need your expertise! how do i get extra debugging information about the null pointers as just saying it tried to reference a null value isnt helping me find what the issue is? thanks richard Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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. i have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
oh i see, thanks very much josh i will give this a go :) good find! thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
that did it! thanks again Josh, good find, i have been tearing my hair out over that all night thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
Take those commas outa there. ?? hi will, i would actually like too, this scenario came up in a previous post i made about the best way to run a query on a particular scenario, the post is: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56792 even though this issue is now working i would appreciate it if you have any other suggestions as although it works it doesn't seem as if it is the most efficient way of doing it thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
Yeah, I think I ran across that one time and had to dig deep to find that. Query of queries is an odd beast, there are a lot of little gotchas to be dealt with. Also check out the case sensitivity issue, that got me one time too. -- Josh - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 20, 2008 4:42 PM Subject: Re: null pointer? need your expertise! that did it! thanks again Josh, good find, i have been tearing my hair out over that all night thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4