1 Reply Latest reply: Jun 22, 2008 1:38 PM by Mike_Watt RSS

    Creating a recordset filtered by login credentials

    Mike_Watt Community Member
      Hello everyone... I'm really hoping I can get an answer to this...

      I've created a login page using the "login user" behavior and it works perfectly. But I'm having trouble identifying the user after they've logged in. For example, I may want to greet them by name "Hello Michael!" after they've logged in... for the life of me I can't get it to work.

      I've tried using the POST variables sent from the login form and I've tried using cookies set from the login form... neither works.

      When I test the recordset in the recordset dialogue box (where it asks you to provide a value for testing) it works, so I'm just totally confused.

      How can I perform a database query using the data supplied at login? (Login being the inherit "login user" behavior in DWCS3)...

      Seriously, I can't tell you how much I would appreciate some help here... Maybe it's because it's 3:15am and I'm tired... but I'm pulling my hair out.

      GRACIAS.
        • 1. Re: Creating a recordset filtered by login credentials
          Mike_Watt Community Member
          I solved my problem and I thought I'd come back and post it here in case anyone else has the same problem.

          The log-in server behavior creates a session variable for the username submitted on the login page. The variable is called "MM_Username". You can use that session variable as your filter criteria on following pages to call that user's record from the DB.

          Hope that helps...