Member Avatar for snehalj

How check that database record is not present in ASP page?
i have two combo boxes, selecting both if the record is present in the database it is showing, but if the record is not present how to check that & how to show msg?

Edited by snehalj because: n/a
  • 2 Contributors
  • 4 Replies
  • 97 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by snehalj
Member Avatar for ArtistScope

A better explanation may help. For example, are you first querying if a particular record/s exist in the database and how?

Member Avatar for snehalj 
<p> Consumer Court Cases - Particulars of litigation pending against IDBI Homefinance Ltd. </P>
<table border="1" width="90%" cellspacing="0" cellpadding="0">			
<tr ALIGN="center">
<td width=5%><font SIZE="2" face="Verdana"><b>Case No</b></font></td>
<td width=10%><font SIZE="2" face="Verdana"><b>Customer Name</b></font></td>
<td width=7%><font SIZE="2" face="Verdana"><b>Start Month</b></font></td>
<td width="5%"><font SIZE="2" face="Verdana"><b>Amount</b></font></td>
<td width="20%"><font SIZE="2" face="Verdana"><b>Case Description</b></font></td>
<td width="20%"><font SIZE="2" face="Verdana"><b>Current Status</b></font></td>
</tr>
</table>
<%set list=con.execute("Select * from courtcase_new where FinYear='"& FinYear &"' and BranchName='"& BranchName &"' and casedrop is null and decreed is null and casecategory ='Consumer'")%>
<%while not list.Eof%>
<%casecat= trim(list("casecategory") )
var1= 0
var1 = len(casecat)%>		
<% if var1 = 8 then %> 
<table border="1" width="90%" cellspacing="0" cellpadding="0">	
<%flag = true%>  
<tr align="center">
<td width=5%><font SIZE="2" face="Verdana"><%=list("caseno")%></font></td>
<td width=10%><font SIZE="2" face="Verdana"><%=list("partyname")%></font></td>
<td width=7%><font SIZE="2" face="Verdana"><%=list("iMonth")%></font></td>
<td width="5%"><font SIZE="2" face="Verdana"><%=list("amount")%></font></td>
<td width="20%"><font SIZE="2" face="Verdana"><%=list("particulars")%></font></td>
<td width="20%"><font SIZE="2" face="Verdana"><%=list("currentstatus")%></font></td>
</tr>
</table>
<%end if %>
<%list.MoveNext%>
<%Wend%>

i have written above code for displaying database records, and now i want code for displaying msg if record is not present in database as per the query.
i hope this explanation will enough to understand problem.Pls tell me if u need info other than this.
thanks in advance

Member Avatar for ArtistScope

Between line 23 and 14 add...

if NOT list.EOF then

Then after line 32 add...

else
response.write"No record found"
end if
Member Avatar for snehalj

thank u so much
i had tride same code but it didnt work because of position where i had written.
now its working perfectly

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.