<cfquery datasource="#dsn#" name="q7">
select media_uuid,media_file_type
,media_by_folder_uid,media_by_user_uid
,media_file_size,substring(media_create_datetime,1,10) as media_create_datetime
from z_media_file_list
where media_file_isdelete = 0
and media_by_folder_uid = <cfqueryparam value="#var1.folder_uid#" cfsqltype="cf_sql_varchar">
and substring(media_create_datetime,1,10)
in ('#arr_updateTime[1]#','#arr_updateTime[2]#','#arr_updateTime[3]#','#arr_updateTime[4]#','#arr_updateTime[5]#')
</cfquery>
<cfdump var="#q7#">
<cfloop list="#arraytolist(arr_updateTime)#" index="i">
<cfoutput>#i#</cfoutput>
<cfquery dbtype="query" name="q7_0">
select media_uuid,media_file_type,media_create_datetime
from q7
where q7.media_file_type = '0'
and q7.media_create_datetime = '#i#'
</cfquery>
<cfdump var="#q7_0#">
</cfloop>
------解决方案--------------------------------------------------------
我说明下：这个程序运行是正常的。但是结果<cfdump var="#q7_0#">是空。正确的话loop内<cfdump var="#q7_0#">一定有值得，我经过数据库对比过的。出错的地方是 and q7.media_create_datetime = '#i#' 这个句话。但这个条件我怎么看都是正确的呀。请高手帮忙找找原因。谢谢