im not sure, but have you tested to see what the value of getHim.recordcount actually shows up as?
have you tried <cfdump var="#getHim#"> to check? also, not to sure that you should put @ in front of the sp params that you are sending over to the db. I know that I only send over the values, and in my sp I have @'s in front of where the values show up in my queries. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 9:16 AM To: CF-Talk Subject: Seemingly different interterpretation of logic (CF5 vs. CFMX) <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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
