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: confused about how to port some sql queries...
I have a prepared statement like so:
SELECT min(tsin) FROM timeclock WHERE
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: confused about how to port some sql queries...
I have a prepared statement like so:
SELECT min(tsin) FROM timeclock WHERE
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,
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