compare two fields and output to a third

R

Raven

I've created an Access dbase and created the forms, etc in ASP using FrontPage. In the edit.asp page I would like to compare two fields (one with a radio button - yes/no) and the other with: <%=FP_FieldHTML(fp_rs,"player1")%> (players 1 through 16) and output the info into either: <%=FP_FieldHTML(fp_rs,"winner1")%> the winners field or <%=FP_FieldHTML(fp_rs,"loser1")%> the loser's field. I have tried (in a variety of formats):

<p class="<%IF inStr=FP_FieldHTML(fp_rs,"player1") AND <%=FP_FieldHTML(fp_rs,"winner1")%> ) THEN <%=FP_FieldHTML(fp_rs,"player1")%> = <%=FP_FieldHTML(fp_rs,"winner1")%> ELSE <%=FP_FieldHTML(fp_rs,"player1")%> = <%=FP_FieldHTML(fp_rs,"loser1")%>"

result is

Microsoft VBScript compilation error '800a03ea'

Syntax error

/LGS_interface/LGS_PLAYERS_REPORT/editor/edit.asp, line 570

inStr=FP_FieldHTML(fp_rs,"player1") AND <%=FP_FieldHTML(fp_rs,"winner1"

Then, there is the problem of where to locate the correct if/else/then statement

Your help would be greatly appreciated

Rave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two fields each record of table, update record or not in new table 3
Comparing two fields and output message 1
Access 2k -> Word 2k merge question: COMPARE mergefields and output text + mergefield data as result 3
need some help for linear interpolation 1
OLK2K3: Standard Field Printing Issue 18

Top