1 2 Previous Next 15 Replies Latest reply on Feb 10, 2014 11:17 AM by beverly

    Searching text fields that contain the @ symbol


      I have been creating a database that contians multiple users and a login script. My login script is based off the email address. The email entered in the email login field is stored as a variable and the script goes to a table containg every possible user in the database and performs a find in the email field based on what they entered. However, every time it runs the find it returns no records found. I have tried every type of find I can think of and finally discovered that the @ sign simlpy breaks the find. It will find all records that match the email up until the @ sign but, if entered, the @ sign causes no records to be found. Does anyone know why this is and/or if there is a work around and how to worko around it.

        1 2 Previous Next