I just played around with FileMaker and doing a find for e-mail addresses.
Instead of quotes try putting the equal sign "=" in front of the search string.
=<@LOWER STR='<@ARG EMAIL_ADDRESS>'>
On 10/4/2002 at 6:26 PM -0500, this was written:
>Well, maybe that is not the problem...
>I just assigned the quotes in an action before the search and I get the same
>error. So, my problem is not with the quotes as I first suspected.
>
>The form has several fields on it. The other fields work as expected, it is
>only the email address field that is not working properly.
>
>Here is the error:
>
>Error
>An error occurred while processing your request:
>
>File: FBNR_Subscribers_new.taf
>Position: Search
>Class: External
>Main Error Number: -1728
>
>Object not found.
>
>File: FBNR_Subscribers_new.taf
>Position: Search
>Class: Internal
>Main Error Number: -101
>
>General error during data source operation.
>
>
>This error mentions datasource, but as I mentioned, the other fields produce
>search results as expected.
>
>Any ideas?
>
>On 10/4/02 6:10 PM, "Tom Carr" <[EMAIL PROTECTED]> wrote:
>
>> I am running into a glitch that I can't remember how to work around.
>>
>> Trying to search a fileMaker data source on an email field.
>>
>> The "@" character in filemaker is a wild card, so I have to search on the
>> literal characters by enclosing the search criteria in quotes to force fmp
>> to not look at the @ in the email address as a wild card.
>>
>> When I do a search in fmp, I would write it like this: "[EMAIL PROTECTED]"
>> (note the quotes)
>>
>> In tango (4.0.136 mac) I do not have the option to quote value in the search
>> criteria action. I am experimenting with adding quotes around the <@ARG> but
>> no combination seems to be working.
>>
> > Here is the tag I need to quote: <@LOWER STR='<@ARG EMAIL_ADDRESS>'>
>>
>> Tried these options with no luck:
>> <@DQ><@LOWER STR='<@ARG EMAIL_ADDRESS>'><@DQ>
>> "<@LOWER STR='<@ARG EMAIL_ADDRESS>'>"
>>
>> I suppose I could add the quotes to the <@ARG> before the search action, but
>> I'm hoping there is a simpler solution.
>>
> > Can someone point me in the right direction? Thx!
> >
--
Tom
Voice: 416 760 0268
Fax: 416 760 7263
E-mail: [EMAIL PROTECTED]
Web Site: www.aboutcomputers.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
