Re: Fetch Specifications and Regular Expressions
Mike Schrag <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
ERXRegExQualifier in Wonder supports in-memory, Oracle, MySQL, and Postgres. ms On Jul 9, 2007, at 1:42 PM, Joshua Marker wrote: > No, you can't use regular expressions with a fetch specification. > SQL has its own pattern matching Add multiple terms to the FS > dynamically, or use the SQL/EO pattern matching. Looks like the > first, based on what you're trying to do. > > > On 9 Jul 2007, at 8:37, Jeff Dunnett wrote: > >> Hello Everyone, >> >> I have been searching through my various WebObjects books, the >> archives for this list and the web for a solution to my problem but I >> can't find it. >> >> I have a fetch specification: >> >> ((contest.contestEvent like $contest) and (processed = $processed) >> and (schoolNumber like $schoolNumber)) >> >> For the value of $schoolNumber I want to pass in a regular expression >> like ^05(69|70|71|72). For some reason when try to fetch objects >> (after having passed in that string) it returns no objects (even >> though I know there are some in the test database. I have tried a >> few variations on the regex such as ^05(69|70|71|72)????? etc. Can >> anyone point out what i am doing wrong? Can I even use regular >> expressions with a fetch specification? >> >> Regards, >> Jeff >> >> _______________________________________________ >> WebObjects-dev mailing list >> [email protected] >> http://www.omnigroup.com/mailman/listinfo/webobjects-dev >> > > -- > Joshua Marker > Corporate Applications Manager > PGP Corporation - Rest Secured (TM) > > Tel: + 1 650 319 9357 | Fax 1 650 319 9001 > > This email and any attachments thereto may contain private, > confidential, and privileged material for the sole use of the > intended recipient. Any review, copying, or distribution of this > email (or any attachments thereto) by others is strictly > prohibited. If you are not the intended recipient, please contact > the sender immediately and permanently delete the original and any > copies of this email and any attachments thereto. > > > > _______________________________________________ > WebObjects-dev mailing list > [email protected] > http://www.omnigroup.com/mailman/listinfo/webobjects-dev _______________________________________________ WebObjects-dev mailing list [email protected] http://www.omnigroup.com/mailman/listinfo/webobjects-dev