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!
>
> --> [groundZER�]
> --> [t:o:m:c:a:r:r]
> --> [[EMAIL PROTECTED]]
> --> [847:757:4188]
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
--> [groundZER�]
--> [t:o:m:c:a:r:r]
--> [[EMAIL PROTECTED]]
--> [847:757:4188]
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
