ASP Access database query [closed]

6 days ago 8
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

Read Entire Article