|
| |
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
 |
Blank Field Suppression - 2/25/2008 12:02:59
I have DRW that shows prices from different suppliers.
I currently have doillar sign, an output field and an icon which links to the store locator for the company. e.g. $<<price>> iconlink.
Therefore all fields display a dollar sign and the icon link even though there is not content.
Any suggestions on how I should approach this?
Steve
|
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Blank Field Suppression - 2/25/2008 14:27:53
Something like this maybe?
<%IF trim(FP_Field(fp_rs,"ItemPrice")&"") > "" THEN%>$<%=FP_Field(fp_rs,"ItemPrice")&"")%><%END IF%>
That would need to be in a Dieted DRW. That help any?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Blank Field Suppression - 2/25/2008 15:22:24
I changed the field name to fit mine so it read:-
<%IF trim(FP_FieldVal(fp_rs,"Meijer")&"")) > "" THEN%>$<%=FP_Field(fp_rs,"Meijer")&"")%><%END IF%>
When I tried that I got the following message:-
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/4dollar/4dollar_search_copy(1).asp, line 247
Response.Write(FP_Field(fp_rs,"Meijer")&""))
-------------------------------------------------------^
Steve
| |
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Blank Field Suppression - 2/26/2008 3:48:06
Also, does this imply that there will only be something displayed if the field is not blank/null, without the need to have an else element?
Steve
| |
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Blank Field Suppression - 2/29/2008 12:05:52
Hey Roger
That worked great. I also added my store link into the expression and it's quite neat.
I now have a further problem and I am struggling to think of a way to approach it. If this should be a separate topic let me know and I will create it.
I have three fields which hold item information and then I have about 6 fields which hold pricing information from suppliers. It just fits on a page. I have now been given another 6 suppliers and told that there may be more!!!
I am happy to have the screen scroll right but I would like the 3 fields with the item information to remain visible so that the customer can remember which item they are looking at pricing details for.
Alternatively, can you think of a way that I can display all the fields relative to an item on the page while keeping things as simple as possible? The users will not be particularly computer literate. At the moment the search and display is fairly simple.
Cheers
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 
