|
| |
|
|
steveg
Posts: 309
Joined: 10/20/2004
Status: offline
 |
If Statement in DRW - 8/3/2009 12:06:29
I have an IF statement in my DRW in which I would like to include another field from the current DRW.
<tr>
<td><font size="1" face="Verdana">
<%=FP_FieldVal(fp_rs,"DRUG NAME")%></font> </td>
<td><font size="1" face="Verdana">
<%=FP_FieldVal(fp_rs,"CO-PAY TIER")%></font> </td>
<td><font size="1" face="Verdana">
<%=FP_FieldVal(fp_rs,"DISPENSING EDITS")%></font> </td>
<td><font size="1" face="Verdana">
<%IF trim(FP_Field(fp_rs,"Medtipstercom")&"") > "" THEN%> <a target="_blank" href="http://www.medtipster.com/search2.php?orig_drug_name=Drug Name"><img border="0" src="logo_medtipster.jpg" align="absbottom"><%END IF%></font> </td>
<td><font size="1" face="Verdana">
<%=FP_FieldVal(fp_rs,"THERAPEUTIC CLASS")%></font> </td>
<td><font size="1" face="Verdana">
<%=FP_FieldVal(fp_rs,"THERAPEUTIC CLASS 2")%></font> </td>
</tr>
I would like to have the Drug Name text in red replaced by the field Drug Name shown earlier in the DRW. I want to take people to the site with the drug name already populated?
Thanks
Steve
|
|
|
|
steveg
Posts: 309
Joined: 10/20/2004
Status: offline
|
RE: If Statement in DRW - 8/14/2009 4:06:02
I am really close but there is something that I can't quite spot.
<%IF trim(FP_Field(fp_rs,"Medtipstercom")&"") >"" THEN%><a target="_blank" href="http://www.medtipster.com/search2.php?orig_drug_name=<%=FP_FieldVal(fp_rs,"DRUG NAME")%><img border="0" src="logo_medtipster.jpg" align="absbottom"> <%END IF%></font> </td>
The result I get is:
http://www.medtipster.com/search2.php?orig_drug_name=ACEBUTOLOL<img border=
I appear to have an imbalance of <> but I have tried adjusting them without success. Can anybody spot anything?
Thanks
Steve
| |
|
|
|
steveg
Posts: 309
Joined: 10/20/2004
Status: offline
|
RE: If Statement in DRW - 8/14/2009 5:38:12
Hi again
With a litle more tinkering I now have this which seems to work:
<%IF trim(FP_Field(fp_rs,"Medtipstercom")&"") >"" THEN%><a target="_blank" href="http://www.medtipster.com/search2.php?orig_drug_name=<%=FP_FieldVal(fp_rs,"DRUG NAME")%>"><img border="0" src="logo_medtipster.jpg" align="absbottom">
<%END IF%></font> </td>
However, I get the image in the cell and an underlined blank space. If I remove the space then I do not get cell demarcation lines apart from where there is an image link. Any ideas on how I might get around this?
Steve
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
