Empty Table Notification

[BBobinski]

I have a Table entitled rpdnotification that has the following fields - subject, authority, startdate, narrative, and rundays. It prints out on a report for x number of days (Normally the user will select 5 days). Sometimes there are no notifications. Is there a way to load a message into the subject field that if the table has 0 records than subject would equal "None at this time"?

 

[stefanwagner]

You have a table (SQL?) and a report (Crystal-Reports? JReport? some self build one? some RDBMS-specific?) and a subject-field (email? report-subject?).

Is your question somehow related to java?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[BBobinski]

I use JSP. What I was basically looking for was that if the rpdnotification table is empty - prompt a line where the data would normally go saying "None at this time" using JSP.

 

[stefanwagner]

And what do you have so far?
Without more information I only may answer:

int cnt = 0;
while (rs.next ())
{
   ++cnt;
   // fill fields...
}
if (cnt == 0) fillFieldXY ("None at this time");

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung