<div>
Try this: 
 
if (c == 0) { 
 
Javier 

</div>

<div>
I get 1 error now:- 
 
com.inqmy.services.servlets_jsp.server.jsp.CompilingException: ID17013: e:\sap\SAP_J2EEngine6.20\cluster\server\services\servlet_jsp\work\jspTemp\_$SAP_J2EE_Engine_default_context\work\jsp_sortASC1080304023812.java:879: cannot resolve symbol 
symbol &nbsp;: variable Out &nbsp; 
location: class jsp_sortASC1080304023812 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Out.println(&quot;There are no records in our database that match your search Criteria&quot;); 
&nbsp; &nbsp; &nbsp; &nbsp; ^ 
1 error 

</div>

I get 1 error now:-

com.inqmy.services.servlets_jsp.server.jsp.CompilingException: ID17013: e:\sap\SAP_J2EEngine6.20\cluster\server\services\servlet_jsp\work\jspTemp\_$SAP_J2EE_Engine_default_context\work\jsp_sortASC1080304023812.java:879: cannot resolve symbol
symbol  : variable Out  
location: class jsp_sortASC1080304023812
      Out.println("There are no records in our database that match your search Criteria");
        ^
1 error


<div>
<div class="content wysiwyg-content">
I want to run an if Statement on a SQL count from a database: 
 
 
sql34 = &quot;select count (ShipNum) AS counter from shipData&quot;; 
int c = rs34.getInt(&quot;counter&quot;); 
 
 
//The count itself works fine but I want to add the following IF statement. 
 
if (c = 0) { 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Out.println(&quot;&lt;center&gt;&lt;font size='4' color='red'&gt;&lt;b&gt;&lt;i&gt;There are no records in our database that match your search Criteria&quot;); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
} 
 
But this fails - what am I doing wrong?!
</div>
</div>

I want to run an if Statement on a SQL count from a database:


sql34 = "select count (ShipNum) AS counter from shipData";
int c = rs34.getInt("counter");


//The count itself works fine but I want to add the following IF statement.

if (c = 0) {
	
	Out.println("<center>There are no records in our database that match your search Criteria");
	
}

But this fails - what am I doing wrong?!

If Statement

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.