Return-Path: <sleberrig@dexem.com>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 85772 invoked from network); 19 May 2003 07:20:13 -0000
Received: from mailhub1.isdnet.net (195.154.209.21)
  by daedalus.apache.org with SMTP; 19 May 2003 07:20:13 -0000
Received: from dexem.com (ppp3021-cwdsl.fr.cw.net [62.210.104.22])
	by mailhub1.isdnet.net (8.9.3p2/8.9.3) with ESMTP id JAA56855
	for <torque-user@db.apache.org>; Mon, 19 May 2003 09:20:20 +0200 (CEST)
Message-ID: <3EC88618.3040205@dexem.com>
Date: Mon, 19 May 2003 09:22:00 +0200
From: Sam Le Berrigaud <sleberrig@dexem.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Turbine Torque Users List <torque-user@db.apache.org>
Subject: How to select only one column thanks to Criteria
References: <B0EC737D3663D411868C00D0B77A8BC49DC0B3@nt_exchange>
In-Reply-To: <B0EC737D3663D411868C00D0B77A8BC49DC0B3@nt_exchange>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,

does anyone know how to select only one column of a table with criteria. 
I want to do something like that:

SELECT CONTACT.CONTACT_ID FROM CONTACT WHERE CONTACT.LAST_NAME = 'Smith'

for example and to get ids in an array...

Thanks for Help,

SaM