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
