DataAssist Insert and update issues with login Page

Hi Jason,

I am having a perculiar problem with DataAssist Insert server bahviour. It appeared to be working correctly and well in one instance but not so well in this particular instance contained in the login page.

I am trying to accomplish three things that I have done before in the not so distant past and they are as follows: (1) Login Count, (2) Login Date and (3) Log table (logged_users) capturing clients login record populated by the insert single record behavior.

I created two columns in the main security assist users table for LoginCount and LoginDate, then created a recordset (rsLoggedin) with filtered record using the ScurityAssist_UserID as the session variable.

I then added the update single record bahvior as follow:

DataAssist: Update Single Record

General Tab

Trigger: any form post
Database connection set to Registered Users Table.
Key Column: UserID
Value: <?php echo $_SESSION['SecurityAssist_UserID']; ?>

Bindings:

Column: LoginCount
Type: Numeric
Value: <?php echo $row_rsLoggedin['LoginCount'] +1; ?>

Column: LoginDate
Type: Date
Value: <?php echo (date("Y-m-d h:n:s")); ?>

I also did a single update for UserIP address to capture that information too.

The update LoginCount, LoginDate and UserIP are not updating.

The insert single record behaviour as well is not capturing and inserting data into the logged_users table.

I have I think ensured the codes are in the right order but I am not getting any result.

Please have a look at the login page and tell me what I am doing wrong.

Thanks.

i dont see an obvious issue in the code. I'll need to troubleshoot directly, see the private message section.

Hil Jason,

The insert and update server behaviour is working as it should now. I removed and re-entered the updates server behaviour first tested it and it was fine, then I proceeded with the insert server behaviour last and that too was tested and proved to be working fine. So overall, the issue is sorted.

Anyway thanks.