Re: String Qualifier for Number
Re: String Qualifier for Number
- Subject: Re: String Qualifier for Number
- From: Chuck Hill <email@hidden>
- Date: Thu, 13 Mar 2008 11:20:58 -0700
On Mar 13, 2008, at 10:47 AM, Carter Wojcik wrote:
Hi All -
My users want to have the ability to search on a
Number attribute, but use String qualifiers such as
Contains ('*value*'), Begins With ('value*'), Ends
With ('*value').
I have a table named part that contains a primaryKey
named part_id (Number and exposed) and a String called
descriptor.
Is there a way to create an EOQualifier that
replicates the SQL in the example below?
Example: Select all parts with a part_id that begins
with 3.
select * from part where to_char(part_id) like '3%';
Maybe...
Add a new attribute called partIDAsString
Set the column to part_id
Set the datatype as string
Mark it as read only
Set the read format to to_char(%P)
Then make a qualifier on partIDAsString.
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden