Databases
StackOverflow2013
Postsdbo
POAdding a custom error to a table after a invalid search has been run when there is already text in the table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdding a custom error to a table after a invalid search has been run when there is already text in the table
    primarykey
    data
    text
    <p>When a search is ran if there are no results a "No results found" line is added to the table. When a invalid search is ran such as a user searching for a fake country. I need to access the label database and enter the invalid country error instead of the "No results found". </p> <pre><code>if(SearchResults.empty){ searchError.add(ss.getLabel("UASJSNSER", request)); SearchResults.append(searchError); } </code></pre> <p>This doesn't override the "No results found" that happens when there are no results.<br> The SearchResults is the table and the searchError the variable that holds the error when an search error happens. </p> <p><em><strong>UPDATE</em></strong></p> <p>SearchResults is the table that is filled with the data after the search runs.</p> <pre><code>&lt;tr class="odd"&gt; &lt;td class=" sorting_1"&gt;0001UK&lt;/td&gt; &lt;td class=""&gt; &lt;td class=""&gt;Pl,anPlus Inc&lt;/td&gt; &lt;td class=""&gt;PlanPlus PlanIt&lt;/td&gt; &lt;td class=""&gt;Permanent Access&lt;/td&gt; &lt;td class=""&gt;&lt;/td&gt; &lt;td class=""&gt; &lt;a href="loadAdvisor.do?planner=0001UK"&gt;Edit&lt;/a&gt; | &lt;a href="javascript:popUp('deleteadvisor.jsp?action=&amp;planner=0001UK');"&gt;Delete&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; //this Is when a search happens that has results &lt;tr class="odd"&gt; &lt;td class="dataTables_empty" valign="top" colspan="7"&gt;No records found&lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; //Instead of it saying No records found I need it to say the error I call from the database. </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris Quibell
    1. USChris Quibell
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTDuplicate
    2. PL
      singulars
      1. LTDuplicate
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COwhat is `SearchResults` ?
      singulars
      1. POAdding a custom error to a table after a invalid search has been run when there is already text in the table
      1. USMohammad Adil
    2. COCan you show the generated html of the table?
      singulars
      1. POAdding a custom error to a table after a invalid search has been run when there is already text in the table
      1. USBlake Plumb
    3. COWe'd prefer that you don't keep asking the same question over and over. If you're not getting any answers then try to improve the question or earn some rep to post a bounty. Thanks.
      singulars
      1. POAdding a custom error to a table after a invalid search has been run when there is already text in the table
      1. USKev
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload