ARTICLE AD BOX
On an asp page I have a html form with a text input field ID
<td align="left" width="430"><input TYPE="TEXT" placeholder="Enter value" ID="nayme2" NAME="nayme2" VALUE="<%=Server.HtmlEncode(Request("nayme2"))%>" ></td>. The user enters a value in the text form and submits.
I then use a database results wizard to query the Access database with a select statement, restricting rows by comparing a field against the form text field which works ok.
fp_sQry="SELECT * FROM ypcompare WHERE (Anumber = '::nayme:2:' ) "Again, I can display the results in a table, but if I want to take different action depending on the value of the text entered in nayme2 I don't know what the correct syntax is for this variable <% If fp_rs("Anumber") = THE VALUE IN THE FORM TEXT FIELD then %>
Action A
Else
Action B
End If
