Hello Martin,
Thank you. it works.
eve
From: mgainty_at_hotmail.com
To: users_at_glassfish.dev.java.net
Date: Fri, 13 Mar 2009 21:49:24 -0400
Subject: RE: List of JQL operators
can you use <> ?
import java.sql.SQLException;
import java.util.Properties;
import java.io.FileInputStream;
import com.ringlord.sql.Connector;
import com.ringlord.sql.Handle;
Properties config = new Properties();
FileInputStream configFile = new FileInputStream( "./system.conf" );
config.load( configFile );
configFile.close();
try
{
Handle system = new Handle( config );
system.execute( "select DBA_USERS.username,DBA_PROFILES.profile,DBA_PROFILES.RESOURCE_NAME,D
BA_PROFILES.LIMIT from DBA_USERS,DBA_PROFILES WHERE USERNAME='MGAINTY' AND DBA_U
SERS.PROFILE=DBA_PROFILES.PROFILE AND RESOURCE_NAME<>'PASSWORD_LIFE_TIME';" );
System.out.println( system.toString() );
system.close();
}
catch( SQLException x )
{
System.out.println( "Failed to get a database connection" );
}
?
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
From: gorgeous65_at_msn.com
To: users_at_glassfish.dev.java.net
Date: Sat, 14 Mar 2009 00:46:49 +0000
Subject: List of JQL operators
Hi,
Im looking for the JQL operator for '!='
Sorry it's a simple question.
Thanks
eve
Windows Live Hotmail just got better. Find out more!
Express your personality in color! Preview and select themes for Hotmail®. See how.
_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/