When doing FORM submission, you can add hidden types with these symbols.
<input type="hidden" name="EMAIL_ADDRESS" value="=" />
<input type="text" name="EMAIL_ADDRESS" value="" size="50" />
This effectively concatenates your user's input with the "=" sign. The actual ARG will
be the correct submission to FileMaker Pro. No need to change anything else.
For _exact_ matches, use "==". See the other symbol you might use as hidden input
types for submitting find criteria.
Since this is a field with "@", you might try to index the field as ASCII in the
database. Otherwise you may need to use the same method to place double quotes
_around_ the EMAIL_ADDRESS field.
Beverly
Hello, Tom Carr! On 10/04/2002 6:26 PM -0500, you wrote in whole or part:
>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!
>>
>> --> [groundZERX]
>> --> [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
>
>
>--> [groundZERX]
>--> [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
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
