Return-Path: <eric@ericemminger.com>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 57113 invoked from network); 14 Mar 2003 15:32:32 -0000
Received: from www3.kc.aoindustries.com (209.15.201.111)
  by daedalus.apache.org with SMTP; 14 Mar 2003 15:32:32 -0000
Received: from ericemminger.com (163-44.9-67.se.rr.com [67.9.44.163] (may be
 forged))
	(authenticated)
	by www3.kc.aoindustries.com (8.11.6/8.11.6) with ESMTP id h2EFWYg26691
	for <torque-user@db.apache.org>; Fri, 14 Mar 2003 09:32:34 -0600
Message-ID: <3E71F60B.5060105@ericemminger.com>
Date: Fri, 14 Mar 2003 10:32:27 -0500
From: Eric Emminger <eric@ericemminger.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3b) Gecko/20030210
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Turbine Torque Users List <torque-user@db.apache.org>
Subject: Re: modified column
References: <20030313045301.A6849@mojavelinux.com>
 <3E709EF7.60902@ericemminger.com> <20030313135529.C6849@mojavelinux.com>
In-Reply-To: <20030313135529.C6849@mojavelinux.com>
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

Dan

I'm pretty sure you'll have to use a CUSTOM Criteria, unless you'd like 
to add this feature to Torque, which is always welcome! The other option 
I've seen is to create the SQL statement and execute it as a prepared 
statement; this is sometimes easier with complex queries.

It would *really* help if you could give a simple example that would 
actually require this.

Eric

> Exactly what I didn't want as an answer.   That was just a simple
> example that has nothing to do what I am actually going to do.  Yes,
> how do I run a function or modify the column database side.
> 
> I want to create a criteria where the database field is modified
> before doing the comparison.
> 
> Dan
>