<td>
<% IF FP_FieldVal(fp_rs,"Answer") = "" THEN %>
<font size="2">Not answered
<% ELSE %>
Yes
<% END IF %> </font>
</td>

Thanks!!

This is to prevent table cells collapsing and no end of frustration for you

Look for "&nbsp;" and not ""

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

<% IF FP_FieldVal(fp_rs,"Other_terms") = " " THEN (what do I put here so the field will not disply of null) end if%>

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

http://www.signingshotline.com/mailtest.asp?promoter=*mike%20riccio%20sports,%20llc

The info you gave me will get rid of the field names? Am I going to have to enter this 20 or so times for each field?

Thanks in advance Spooky

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

[This message has been edited by hzarabet (edited 03-23-2001).]

There really should be an option for this in the DRW. To only display fields with results in them.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

<% IF FP_FieldVal(fp_rs,"Other_terms") <> " " THEN %>
[display what you want to display]
<% END IF %>

Now the display part must be the complete TABLE row used "<tr><td>column 1</td><td>Column data</td></tr>"

If the data is empty , you want to not display the whole row

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

<% If FP_FieldVal(fp_rs,"YourBall") <> " " then response.write "<tr>
<td><b><font face="Arial" size="2">YourBall:</font></b></td>
<td><font face="Arial" size="2">
</font></td>
</tr>" else response.write " " end if%>

and here is the error:

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/mailtest2.asp, line 68

If FP_FieldVal(fp_rs,"YourBall") <> " " then response.write "<tr>
-----------------------------------------------------------------^

I have gotta go to class and learn this stuff

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

[This message has been edited by hzarabet (edited 03-25-2001).]

Asp thinks you have finished and looks for another statement

so :
<font face="Arial" size
would become :
<font face='Arial' size

<%If FP_FieldVal(fp_rs,"Other_terms") <>"" then response.write '<tr>
<td><b><font face='Arial' size='2'>Other_terms:</font></b></td>
<td><font face='Arial' size='2'> FP_FieldVal(fp_rs,'Other_terms')
</font></td>
</tr>' else response.write "" end if%>

And here is the error:

Microsoft VBScript compilation error '800a0400'

Expected statement

/mailtest_copy(1).asp, line 169

<td><b><font face='Arial' size='2'>Other_terms:</font></b></td>

There should be an option in the DRW to drop and field if it is empty

Thanks again Spooky

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

<%If FP_FieldVal(fp_rs,"Other_terms") <>"" then
response.write "<tr><td><b><font face='Arial' size='2'>Other_terms:</font></b></td>
<td><font face='Arial' size='2'>"&FP_FieldVal(fp_rs,'Other_terms')&"</font></td>
</tr>"
else
response.write ""
end if%>

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/mailtest_copy(1).asp, line 169

response.write "<tr><td><b><font face='Arial' size='2'>Other_terms:</font></b></td>

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

response.write "<tr><td><b><font face='Arial' size='2'>Other_terms:</font></b></td>
<td><font face='Arial' size='2'>"&FP_FieldVal(fp_rs,'Other_terms')&"</font></td>
</tr>"

Are actually just one line broken up by being displayed in the forum. Make them one line and everything will be ok

Vince

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Vince

------------------
Internet Business Solutions S.L.(Spain)