• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
String Qualifier for Number
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

String Qualifier for Number


  • Subject: String Qualifier for Number
  • From: Carter Wojcik <email@hidden>
  • Date: Thu, 13 Mar 2008 10:47:39 -0700 (PDT)

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%';

Thanks.
Carter


      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


 _______________________________________________
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

  • Follow-Ups:
    • Re: String Qualifier for Number
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Sybase character set problem
  • Next by Date: Problem deleting an object with a flattened relationship
  • Previous by thread: Sybase character set problem
  • Next by thread: Re: String Qualifier for Number
  • Index(es):
    • Date
    • Thread