Hello, I am using the following code to display a message based on the RecordCount variable's value. Everything works ok as long as the query returns some records. However when it is zero no message displays, nothing. I am getting no errors so i don't think it's syntax related?
Any Ideas? Thanks and Merry Chistmas Rick Here's the code I am using <blockquote> <div align="left" style="font-family: 'Century Gothic'; font-size: medium; font-style: normal; font-weight: bold; background-color: #7CA3B6; color: White;"> <cfoutput query="qSearchIt" maxrows="1"> Your search for, #SearchIt# found #qSearchIt.RecordCount# items: <cfif qSearchIt.RecordCount IS 0> <div align="left" > Sorry no records found for, #SearchIt# </div> <cfelse> </cfif> </cfoutput> ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
