Displaying of Variables 1

[minoad]

I am using a database entry regarding the Sex (M or F) to decide on whether the salutaion gets a Mr. or a Mrs.. I have run this code with no errors so i believe it is fine. My problem is getting a variable to write. The variable is Sexx, i have tried ' Response.Write(sexx) to no avail. Any ideas? HEre is the code.

set sex = conn("Patinet Sex&quot
If Sex = M Then
Set Sexx= "Mr"
ElseIf Sex = F Then
Set Sexx= "Mrs"
End If

 

[link9]

If your variables are strings, then you need to enclose them in quotes:

If Sex = "M" Then


see if that works --

if you are response.write'ing the sexx, then it is doing it, I suspect that the variable is simply empty due to neither of your conditions being satisfied.

 

[GlennBSI]

You use the set verb to assign an object to a variable and you can't response.write an object. I suspect you have more problems than that, but, for one, change the set sexx = "Mr." to just sexx = "Mr.".