You will probably get a thousand responses. I don't know of a way to do
it in SQL, but for ColdFusion
<CFIF myquery.recordcount is 0>
"Sorry No Record Has Been Found"
</CFIF>
At 11:24 PM 03/04/2001 -0500, you wrote:
>OK maybe it's getting too late. What is the correct SQL to display "Sorry
>No Record Has Been Found" after a Query show no results? In other words
>What is the correct statement for <cfif no results> then "Sorry ..."?
>
>Thanks,
>Rich
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
