CFIF return RecordCount EQ 0

[bpiersant]

Hi - need to check if there is a record in a MySQL database. If there is
display it if there not show a default Address. Here's what I have. It doen't
work though. Any ideas? <cfquery name='qGetSomeData'
datasource='SQL_ServerDS_Name'> SELECT 'A' AS B </cfquery>
<cfoutput> <cfif qGetSomeData.RecordCount EQ 0> <h2>There ain't
no such data rows (neither)!</h2> <cfelse> ... Displaying my
results here ... </cfif> </cfoutput>

[cf_menace]

That should work.

Try <cfdump var="#qGetSomeData#"> to see what's being returned to the query.

[Sameer]

Instead of SELECT 'A' AS B, do a real query from a table in the database.

Once you do query a table, do this : -

<cfif qGetSomeData.RecordCount>
<cfoutput query="qGetSomeData">
....display results......
</cfoutput>
<cfelse>
<h2>Empty!</h2>
</cfif>