[Oscarmcmaster-cvscommit] oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarEncounter/oscarMeasurements/bean EctMeasurementTypesBeanHandler.java,1.6,1.7

[Ivy C. <ic...@us...>]

Update of /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarEncounter/oscarMeasurements/bean
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28675

Modified Files:
	EctMeasurementTypesBeanHandler.java 
Log Message:
update the mysql query



Index: EctMeasurementTypesBeanHandler.java
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarEncounter/oscarMeasurements/bean/EctMeasurementTypesBeanHandler.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** EctMeasurementTypesBeanHandler.java	18 Oct 2004 22:46:52 -0000	1.6
--- EctMeasurementTypesBeanHandler.java	18 Nov 2004 17:51:42 -0000	1.7
***************
*** 102,106 ****
                  //Get the data last entered for the current measurement type
                  String sqlData = "SELECT * FROM measurements WHERE demographicNo='"+ demo + "' AND type ='" + rsMT.getString("type")
!                                  + "' ORDER BY dateEntered DESC";
                  ResultSet rsData = db.GetSQL(sqlData);
                  boolean hasPreviousData = false;
--- 102,106 ----
                  //Get the data last entered for the current measurement type
                  String sqlData = "SELECT * FROM measurements WHERE demographicNo='"+ demo + "' AND type ='" + rsMT.getString("type")
!                                  + "' ORDER BY dateEntered DESC LIMIT 1";
                  ResultSet rsData = db.GetSQL(sqlData);
                  boolean hasPreviousData = false;