<cfif thisCondition IS true>
<cfquery name="getHim" datasource="#request.ds#"
EXEC sp_getHim @param1='sdsd', @param2='sdsdsdfs'
</cfquery>
<!--- the query may return 0 or >0 recordsets --->
<cfelse>
<cfset getHim = QueryNew("recordcount,fkeyid")>
<cfset tp = QueryAddRow(getHim,1)>
<cfset tp = QuerySetCell(getHim,"recordcount","0",1)>
<cfset tp = QuerySetCell(getHim,"fkeyid","",1)>
</cfif>
<cfif getHim.recordcount GT 0>
Do this or that ...
</cfif>
I don't see any logical flaw with the above code, CF5
execute it well, but CFMX fails its logic,
specifically at <cfif getHim.recordcount GT 0> ...
</cfif>
Any thoughts appreciated.
Don Li
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
