Server Validation Question

I'm after some guidance on how i can achieve following.

My logged in users are able to select tags from a drop down and im using INSERT to add their selection to a table.

The user ID is added along with the selected items ID

I want to prevent the user from selecting the same item 2 or more times from the drop down and adding it to their tag list.

I tried using validation on the selected item against a recordset that looked at the values already selected by the user, but that failed!

suggestions welcome.

Originally Said By: Paul

  I tried using validation on the selected item against a recordset that looked at the values already selected by the user, but that failed!  

The recordset is the correct way to do it.

The recordset should be set to filter on the selection made and the users ID.

In the validation, use numeric validation.

for the server variable, use:
$totalRows_<recordsetName>

where <recordsetNamer> is the name of the recordset.

for the numeric validation, set the minimum to -1 and the max to 0. That will pass validation only if the Recordset does not return any rows.

Ok, i'm not sure how to apply two filters, or can you explain a different way?

"The recordset should be set to filter on the selection made and the users ID."

Use the advanced recordset dialog to create more than one filter.

Hi Jason,

I've created a Recordset, including two filters, however the drop down is not populating from it.

you should not be using this recordset to populate the dropdown,

it is only used to validate that selection.

to populate the dropdown, use another recordset.

I think i see.

So ive populated my drop down with my tag options.

In the validation, use numeric validation, I have;

please send a copy of the page so i can see the code in context.

Attached

The problem is code order.

The code for the server validaiton is at line 122 -137:

<?php 

if (isset($_POST["Tag_submit"]) || isset($_POST["Tag_submit_x"]))  {

  $WAFV_Redirect = "";

  $_SESSION['WAVT_index_902_Errors'] = "";

  if ($WAFV_Redirect == "")  {

    $WAFV_Redirect = $_SERVER["PHP_SELF"];

  }

  $WAFV_Errors = "";

  $WAFV_Errors .= WAValidateRQ(((isset($_POST["SelectTag"]))?$_POST["SelectTag"]:"") . "",false,1);

  $WAFV_Errors .= WAValidateNM($row_rsDuplicate['usrtags_type'] . "",-1,0,"",",.",true,2);



  if ($WAFV_Errors != "")  {

    PostResult($WAFV_Redirect,$WAFV_Errors,"index_902");

  }

}

?>

this is after the code to insert the record which begins at line 84. Move the validation code to line 84 so the validation can take place before the record is inserted.