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
