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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
