From Guillaume.Barre@technomedia.ca  Wed Jun  4 19:33:15 2003
Return-Path: <Guillaume.Barre@technomedia.ca>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 94777 invoked from network); 4 Jun 2003 19:33:15 -0000
Received: from pop.technomedia.ca (HELO ns1.technomedia.ca) (207.236.152.194)
  by daedalus.apache.org with SMTP; 4 Jun 2003 19:33:15 -0000
Received: from msrvmail.msrvmail (mail.technomedia.ca [192.168.204.2])
	by ns1.technomedia.ca (8.11.6/linuxconf) with ESMTP id h54KZH013902
	for <torque-user@db.apache.org>; Wed, 4 Jun 2003 16:35:17 -0400
Received: by msrvmail.msrvmail with Internet Mail Service (5.5.2655.55)
	id <CF0VHZGH>; Wed, 4 Jun 2003 15:34:32 -0400
Message-ID: <8218615EEB92064490C951D0AF028CA975AF91@msrvmail.msrvmail>
From: Guillaume Barre <Guillaume.Barre@technomedia.ca>
To: "'torque-user@db.apache.org'" <torque-user@db.apache.org>
Subject: Problem with Date in Criteria
Date: Wed, 4 Jun 2003 15:34:30 -0400 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2655.55)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C32AD0.51352F30"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C32AD0.51352F30
Content-Type: text/plain;
	charset="iso-8859-1"

Hello,

I try to use one Date object in a Criteria like in the code below :

	
Iterator iterator1 = TqEntrepriseTypePeer.doSelect(new
Criteria()).iterator();
while(iterator1.hasNext()){
	TqEntrepriseType obj1 = (TqEntrepriseType)iterator1.next();

	System.out.println("getId " + obj1.getId());
	System.out.println("date " + obj1.getAuLastUpdateDate());
	
	Criteria criteria2 = new Criteria();	
	criteria2.add(TqEntrepriseTypePeer.AU_LAST_UPDATE_DATE,
obj.getAuLastUpdateDate() );
	Iterator iterator2 =
TqEntrepriseTypePeer.doSelect(criteria2).iterator();
	while(iterator2.hasNext()){
		TqEntrepriseType obj2 = (TqEntrepriseType)iterator2.next();

		System.out.println("getId(2) " + obj2.getId());
		System.out.println("date " + obj2.getAuLastUpdateDate());
	}
}

My problem is that this code never find the second object "obj2", iterator2
is always empty ???

Notes :
	- obj.getAuLastUpdateDate() return a java.util.Date object

	- My shcema definition for the field AuLastUpdateDate is :
	<column javaName="AuLastUpdateDate" name="AU_LAST_UPDATE_DATE"
required="false" type="TIMESTAMP"/>

	- And I use MSSQL Server

Thanks for any suggestions.
Guillaume


------_=_NextPart_001_01C32AD0.51352F30--