OK Funny thing here. After a few days the SQL error has gone away and I can search on all fields. Kinda scary.<br><br>
<div><span class="gmail_quote">On 8/4/08, <b class="gmail_sendername">Steve G</b> <<a href="mailto:smgustafson@gmail.com">smgustafson@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Update: When searching by directory number under BAT phone templates I am able to find my templates, but all other fields produce the error below.
<div><span class="e" id="q_11b8e59ffdf41b55_1"><br><br>
<div><span class="gmail_quote">On 8/2/08, <b class="gmail_sendername">Steve G</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:smgustafson@gmail.com" target="_blank">smgustafson@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>When trying to find BAT phone templates (I have three of them built) I get this error.
<table>
<tbody>
<tr>
<td style="VERTICAL-ALIGN: middle">Error occurred during find. java.sql.SQLException: A subquery has returned not exactly one row. I don't know what might have changed. This has been working fine all week, and now I can't search on phone templates in bat. All other searches seem to be working just fine.</td>
</tr></tbody></table></div>
<div> </div>
<div>Any Ideas?</div>
<div> </div><span>
<div>Steve</div></span></blockquote></div><br></span></div></blockquote></div><br>