Prevent display of empty database record

[DStracner]

I am displaying a lighting catalog image with description, height, and several
other descriptive fields below it. This is all being pulled from an Access db
via a SELECT * query. My display code is <table> <cfoutput
query='qInfo'><tr><td>#Description#</td></tr></cfoutput> <cfoutput
query='qInfo'><tr><td>#Shade#</td></tr></cfoutput> <cfoutput
query='qInfo'><tr><td>#MediumBase#</td></tr></cfoutput> <cfoutput
query='qInfo'><tr><td>Projection&amp;nbsp;#Project ion#</td></tr></cfoutput>
<cfoutput query='qInfo'><tr><td>#Options#</td></tr></cfoutput> </table>
The problem is that if there is no value in the record for MediumBase for this
particular record, I get a blank line. Is it possible to code this such that
if there is nothing in the record for that column, then the cfm output will not
show a blank line, but will just move on to the next filled record? BTW -- I
tried the below code, too, and that didn't work for me, either... <table>
<cfif IsDefined ('qInfo.Description')>
<cfoutput><tr><td>#qInfo.Description# </td></tr></cfoutput> </cfif>
<cfif IsDefined ('qInfo.Shade')> <cfoutput>
<tr><td>#qInfo.Shade#</cfoutput> </td></tr> </cfif> <cfif
IsDefined ('qInfo.MediumBase')> <tr><td>
<cfoutput><br>#qInfo.MediumBase#</cfoutput> </td></tr> </cfif> <cfif
IsDefined ('qInfo.Projection')> <tr><td>
<cfoutput><br>#qInfo.Projection#</cfoutput> </td></tr> </cfif> <cfif
IsDefined ('qInfo.Options')> <tr><td>
<cfoutput><br>#qInfo.Options#</cfoutput> </td></tr> </cfif>
</table>

[cf_menace]

You want to check <cfif qInfo.MediumBase IS "">. Checking <cfif IsDefined ("qInfo.MediumBase")> will always return true (it's defined, just empty).

HTH