Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 46439 invoked from network); 14 Mar 2005 12:06:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 14 Mar 2005 12:06:33 -0000 Received: (qmail 85041 invoked by uid 500); 14 Mar 2005 12:06:32 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 85020 invoked by uid 500); 14 Mar 2005 12:06:31 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 85003 invoked by uid 99); 14 Mar 2005 12:06:31 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of matotouraki@gmail.com designates 64.233.184.194 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.194) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 14 Mar 2005 04:06:30 -0800 Received: by wproxy.gmail.com with SMTP id 58so1367281wri for ; Mon, 14 Mar 2005 04:06:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=QTh4lgorfSdXmE17WncYI50IxG29OunyYzLzaWvP53BFfIbtoaY1nvHWwhkxXbyfmqcaEjtrMHKOPxhWtAD8WKOooFww/9z+m0PqfHELr8GTCJpYYEeRq4ZjHtB1eBGxF9cXOiUyXbHoXxBg7ooKqiAQeCe6ACM7hC/LXbIlMFk= Received: by 10.54.82.19 with SMTP id f19mr809771wrb; Mon, 14 Mar 2005 04:06:28 -0800 (PST) Received: by 10.54.42.54 with HTTP; Mon, 14 Mar 2005 04:06:28 -0800 (PST) Message-ID: Date: Mon, 14 Mar 2005 12:06:28 +0000 From: Abou Zarr Reply-To: Abou Zarr To: torque-user@db.apache.org Subject: Complexe torque crieteria Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi, how can i transform these query to torque criteria? sql = "select distinct salle " + "from tab1, tab2 where " + "((tab1.debut >= tab2 .debut " + "and tab1.debut < tab2 .fin) " + " or " + "(tab1.fin > tab2 .debut " + "and tab1.fin <= tab2 .fin)) " + "and tab2 .idsession = '" + session + "'"; --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org