Problems with If Statement 1

[Castanz]

Hi Everyone,
I am stuck on this (what should be easy) task.

I am retrieving "MealCard" from a calling forms page. Then I want to match to check for duplicates by comparing what was entered on the form with what is in the data base.

The nearest I can tell is that the data types might be different because "MealCardData = MealCardvalue" never tests to be true.

Alreadyexists = FALSE
MealCardvalue = Request("MealCard")
LNamevalue = Request("LastName")

	While Not RS.EOF
	   MealCardData = RS("MealCard")
	 
	    If  MealCardData = MealCardvalue  Then
		Alreadyexists = TRUE
		Response.write "<p>Alreadyexists = " & Alreadyexists & "</p>"
	    Else
		Response.write "<p>Alreadyexists Else = " & Alreadyexists & "</p>"
	    End If
		
		Response.write "<p>MealCardData = " & MealCardData & "</p>"
		Response.write "<p>MealCardvalue = " & MealCardvalue & "</p>"
	   RS.movenext
	wend

Can anyone tell me what I am doing wrong?

Thanks in advance,
Al

 

[gmmastros]

If [!]Trim([/!]MealCardData[!])[/!] = [!]Trim([/!]MealCardvalue[!])[/!] Then

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Castanz]

Thanks, that did it

 

[Sheco]

If it is possible the column MealCard column in will contain the value Null then do this:
[tt]
MealCardData = RS("MealCard") [red]& ""[/red]
[/tt]

By adding an empty string you can avoid an error that may result when passing Null to the Trim() method.

 

[trollacious]

Once AlreadyExists is set to True, it will display True for every subsequent record because it's not reset to False at the beginning of the loop.

I'd recommend:

If  MealCardData = MealCardvalue  Then
  Response.write "<p>Already exists = " & True & "</p>"
Else
  Response.write "<p>Already exists = " & False & "</p>"
End If

Lee