Ask a Question related to Coldfusion Database Access, Design and Development.
-
RuBot #1
Nothing displays if No Record is found
<CFQUERY NAME="EMP_DATA" DATASOURCE="EMP">
select a.*, b.locname, c.ou
from emptbl a, loctbl b, outbl c
where a.ouid = c.ouid and a.locid = b.locid
<cfif #Birthday# is "Yes">and a.DOB = '#DateFormat(Now(),"mmmm dd")#'</cfif>
<cfif #Anniversaries# is "Yes"><cfset today = #dateformat(now(),"mm/dd")#>
and Left(hiredate, 5) = '#Left(today, 5)#'</cfif>
<cfif #Search_Lname# is "Yes">and a.lname Like
'%#Search_LName_input#%'</cfif>
<cfif #Search_Fname# is "Yes">and a.fname Like
'%#Search_FName_input#%'</cfif>
<cfif #Search_EXT# is "Yes">and a.EXT Like '%#Search_EXT_input#%'</cfif>
<cfif #Search_locname# is "Yes">and a.locname Like
'%#Search_locname_input#%'</cfif>
ORDER BY
<cfif #Sort# is "Last_Asc">a.LNAME
<cfelseif #Sort# is "Last_DESC">a.LNAME DESC
<cfelseif #Sort# is "First_ASC">a.FNAME
<cfelseif #Sort# is "First_DESC">a.FNAME DESC
<cfelseif #Sort# is "EXT_ASC">a.EXT
<cfelseif #Sort# is "EXT_DESC">a.EXT DESC
<cfelseif #Sort# is "locname_ASC">a.locname
<cfelseif #Sort# is "locname_DESC">a.locname DESC<cfelse>a.LNAME</cfif>
</CFQUERY>
<body leftmargin="0" topmargin="0" alink="#000000" link="#000000"
vlink="#000000">
<table width="100%" height="25" border="1" cellpadding="0" cellspacing="0">
<cfoutput query="EMP_DATA">
<cfif emp_data.recordcount gt 0>
<tr bgcolor="###iif(currentrow MOD 2,DE('EEE8AA'),DE('ffffff'))#"
height="25">
<td width="110" nowrap> <a
href="EMP_Data.cfm?login=yes&EMPID=#ID#"
target="rightFrame"><b>#lname#</b></a></td>
<td width="110" nowrap> #fname#</td>
<td width="65" nowrap> #ext#</td>
<td nowrap width="200"> #ou# </td>
<td nowrap> #locname# </td>
</tr>
<cfelse>
<tr bgcolor="###iif(currentrow MOD 2,DE('EEE8AA'),DE('ffffff'))#"
height="25">
<td width="110" nowrap> </td>
<td width="110" nowrap> </td>
<td width="65" nowrap> </td>
<td nowrap width="200"> </td>
<td nowrap> </td>
</tr>
</cfif>
</cfoutput>
</table>
I've tried testing for emp_data.recordcount eq 0 then display but still
nothing will display. Not even a blank table with blank rows. Nothing.
RuBot Guest
-
How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
HI all Thanks for your time.. I have a question here.. How can i retrieve record ONLY From XXX - XXX in a million Record Table? eg. I have a... -
ASP newby needs no record found help
ok I'm new to ASP but I have everything working great I have a form in which client can look up status i want to be able to redirect to a no record... -
Find record w/ conditions met in the same child record
I'll use 2 files to demonstrate my question. The first file is Animal. It has 4 fields. Id (serial number) ZooId (number) Name (text) Food... -
using dropdown box to display db record & update record
Hi Folks, I have a web database written in asp and using access97. I have many projects, but each project is being held responsible by a person.... -
Stop adding record in subform after record count = 1
Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the... -
RuBot #2 Re: Nothing displays if No Record is found
Also, it was orignally
<cfif emp_data.recordcount eq 0>
<tr><td colspan="5">No record Found.</td></tr>
RuBot Guest
-
zoeski80 #3 Re: Nothing displays if No Record is found
Hi
You need to put the CFIF statement outside the <cfoutput query="EMP_DATA">. If
the query has no results then the <cfoutput query="EMP_DATA"> will not be
looping at all. There are no records so the <cfoutput query="EMP_DATA"> will be
skipped totally.
so you want something like this:
<CFIF emp_data.recordCount GT 0>
<cfoutput query="EMP_DATA">
table output code
</cfoutput>
<CFELSE>
no records message/table output
</CFIF>
Zoe
zoeski80 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
