[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openmrs-dev
Subject:    http/www.tickets.openmrs.org/browse/REPORT-641
From:       ayuk etta <ettaayuk () gmail ! com>
Date:       2014-03-26 9:05:06
Message-ID: CAP7+G89cYK4v7562D=zXd5qO5vGqe5DV8gkEsHgTHijeUuyx3A () mail ! gmail ! com
[Download RAW message or body]

Hey Darius you asked if i have faced the same problem using the proposed
case study with which this issue was reported, i have . Take a look at this:

Query:
select encounter_id, encounter_datetime, location_id
from encounter
where location_id in :<Laboratory,Pharmacy>




result:

An Internal Error has Occurred
*java.lang.RuntimeException*

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'Pharmacy' in 'where clause'



Consult the help document <http://localhost:8082/openmrs/help.htm>.
Contact your friendly neighborhood administrator if it cannot be resolved.

Show stack trace<http://localhost:8082/openmrs/module/reporting/parameters/queryParameter.form#>


 The following data will be submitted with the report to enable the team to
resolve the problem.

   - The error message and stack trace
   - OpenMRS version
   - Application server name and version
   - Username of the user currently logged in
   - The implementation id of this installation (if defined)
   - Names and versions of all installed modules


Concerns:


There is no opportunity to input second parameter when the query is
executed, i thinks it does not detect it as a list. what do you think?

 any contributions will be greatly appreciated.



*Dream and Innovate*

*Software Engineeer :ActivSpaces,Cameroon*


*Developer:OpenMRS*

-- 
OpenMRS Developers: http://go.openmrs.org/dev
Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/

To unsubscribe from this group and stop receiving emails from it, send an email to \
dev+unsubscribe@openmrs.org.


[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_default" style="font-family:comic sans \
ms,sans-serif;color:rgb(61,133,198)">Hey Darius you asked if i have faced the same \
problem using the proposed case study with which this issue was reported, i have . \
Take a look at this:<br> <br><div class="gmail_default" style="font-family:comic sans \
ms,sans-serif;color:rgb(61,133,198)">Query:<br>select encounter_id, \
encounter_datetime, location_id<br>from encounter<br>where location_id in \
:&lt;Laboratory,Pharmacy&gt;<br>


<br><br><br><br></div><div class="im">result:<br><br><h2>An Internal Error has \
Occurred</h2>

	

</div><b>java.lang.RuntimeException</b><div class="im">
<pre>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \
&#39;Pharmacy&#39; in &#39;where clause&#39;</pre>

	
	<br><br></div>
	Consult the <a href="http://localhost:8082/openmrs/help.htm" target="_blank">help \
document</a>. <br><div class="im">  Contact your friendly neighborhood administrator \
if it cannot be resolved.  
	<br><br>
	
	<a href="http://localhost:8082/openmrs/module/reporting/parameters/queryParameter.form#" \
style="font-size:12px" target="_blank">Show stack trace</a>  <br>
	 

<br>


</div><div class="im">
The following data will be submitted with the report to enable the team to resolve \
the problem. </div><ul><div class="im"><li>The error message and stack \
trace</li></div><li>OpenMRS version</li><div class="im"><li>Application server name \
and version</li></div><div class="im"><li>Username of the user currently logged \
in</li> </div><div class="im"><li>The implementation id of this installation (if \
defined)</li> </div><div class="im"><li>Names and versions of all installed \
modules</li></div></ul><br><div class="im"><div class="gmail_default" \
style="font-family:comic sans \
ms,sans-serif;color:rgb(61,133,198)">Concerns:<br><br><br> </div><div \
class="gmail_default" style="font-family:comic sans \
ms,sans-serif;color:rgb(61,133,198)">

There is no opportunity to input second parameter when the query is 
executed, i thinks it does not detect it as a list. what do you \
think?<br></div></div><div class=""><br></div><div class=""> any contributions will \
be greatly appreciated.<br clear="all"></div><br clear="all"></div><div> <div \
dir="ltr"><div><div><b>Dream and Innovate<br><br></b></div><b>Software Engineeer \
:ActivSpaces,Cameroon<br></b></div><b>Developer:OpenMRS<br><br></b></div></div> \
</div>

<p></p>

-- <br />
OpenMRS Developers: <a \
                href="http://go.openmrs.org/dev">http://go.openmrs.org/dev</a><br />
Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org<br />
Manage your OpenMRS subscriptions at <a \
href="https://id.openmrs.org/">https://id.openmrs.org/</a><br />

<p></p>

To unsubscribe from this group and stop receiving emails from it, send an email to <a \
href="mailto:dev+unsubscribe@openmrs.org">dev+unsubscribe@openmrs.org</a>.<br />



[prev in list] [next in list] [prev in thread] [next in thread]