Jump to content

This topic is 8706 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I'm having a hard time getting a particular CDML function to work properly and I am puzzled as to what might be wrong.

Here's what I'm trying to do:

Visitors must log in (using -find function) before signing in to an afterschool program. To log in they need to enter their first initial, last initial, and student ID number in three text fields. If *all three* match an existing student in the database, they are welcomed and allowed to sign in. If any one of the three fields is not correct (or left blank a situation validated by a javascript on the login page), they will receive an error message.

At least, that's the way it's *supposed* to work. Instead, the second of the three fields (last initial) seems to be irrelevant to the records returned. That is, if first initial and student number match, then it doesn't matter what the last initial says: the DB returns the record correct for the student ID. (If the first initial and ID don't match, it returns the desired error message.)

I've spent more time than I'd like to admit trying to find the problem. Any HTML tinkerers want to tell me what's wrong? If so, The URL for the existing page, if you'd care to try it out, is http://169.204.215.43/hms/login.htm (For the record, the DB fields we're dealing with are named firstinit, lastinit, and number, and the following represents a valid record in the DB:

first initial: t (for test)

last initial: s (for student)

number: 1234 ).

Many thanks if you can see where I'm missing the boat. It's probably something very simple, but I sure can't seem to find it.

Posted

well, everyone and their dog has made that mistake. Solution is simple. Directly in front of each field have the line:

<input type=hidden name="FieldName" Value="=">

(substitute FieldName with all the respective Field Names)

OR

<input type=hidden name="FieldName" Value="==">

Some work with 2 "=" signs, some work with 1. Not sure why, i use one and it works, but when use two it doesn't. But Filemaker.com tech support says to use 2 "=" signs. So try both.

jeremy

Posted

Thanks, Jeremy, for the info on the # of =. I'll keep it in mind for future puzzlers.

However, I ended up making the fix on my own, and cleaning up the database on the back end, by changing the lop from lastinit.eq." ", to lastname.bw" ". (Don't know why I thought I needed two different fields in the database to start with, but now at least I know how to calculate the first initial of a particular field.)

Now it works, but again, thanks for the reply. (Glad to know I'm in the same league as many filemaker users.....and their dogs,too. ;-)

This topic is 8706 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.