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" <[email protected]> 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
