RE: confused about how to port some sql queries...

2003-11-24 Thread Ron Gallagher
d "tSin") that are found in the criteria/column list are resolved to actual table/column names. HTH Ron Gallagher Atlanta, GA [EMAIL PROTECTED] -Original Message- From: Jason Pyeron [mailto:[EMAIL PROTECTED] Sent: Saturday, November 22, 2003 9:03 PM To: OJB Users List Subject:

RE: confused about how to port some sql queries...

2003-11-24 Thread Ron Gallagher
d "tSin") that are found in the criteria/column list are resolved to actual table/column names. HTH Ron Gallagher Atlanta, GA [EMAIL PROTECTED] -Original Message- From: Jason Pyeron [mailto:[EMAIL PROTECTED] Sent: Saturday, November 22, 2003 9:03 PM To: OJB Users List Subject:

Re: confused about how to port some sql queries...

2003-11-22 Thread Jason Pyeron
btw, this is what I am doing for now: PersistenceBroker broker=PersistenceBrokerFactory.defaultPersistenceBroker(); Connection C=broker.serviceConnectionManager().getConnection(); PreparedStatement stmt=C.prepareStatement("SELECT min(tsin) FROM timeclock WHERE ref_employee= ? AND tsout=0;

confused about how to port some sql queries...

2003-11-22 Thread Jason Pyeron
I have a prepared statement like so: "SELECT min(tsin) FROM timeclock WHERE ref_employee= ? AND tsout=0;" I use this to decide what to query next, it sounds like I should use the "report" feature in OJB but I have no idea how. I looked at ReportQueryByCriteria(java.lang.Class targetClass, j