lulu50
asked on
'<' cannot display this operator
Hi,
I have a table called Major update that has the following fields
I am trying to just loop thru the query and display the MajorUpgradeCost
the problem that I am having is that AppID 9 is not displaying '<$100K' because of this operator
<
It display the operater > fine but not this < and I am not sure why!
I have a table called Major update that has the following fields
AppID AppName MajorUpgradeCost
9 name1 <$100K
10 name2 $100K to $500K
13 name3 $500K to $1M
14 name4 $500K to $1M
18 name5 $1M to $5M
20 name6 >$5M
22 name7 <$100K
23 name8 NULL
24 name9 NULL
I am trying to just loop thru the query and display the MajorUpgradeCost
the problem that I am having is that AppID 9 is not displaying '<$100K' because of this operator
<
It display the operater > fine but not this < and I am not sure why!
<cfoutput query="FiveYearPlan">
#FiveYearPlan.MajorUpgradeCost#
</cfoutput>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh!!!!!!!
YOU ARE awesome!!!!!
It's working now!!!!
I tryed so many things but I couldn't get it to work.
Thank you for all your help and HAPPY HOLIDAY :-)
YOU ARE awesome!!!!!
It's working now!!!!
I tryed so many things but I couldn't get it to work.
Thank you for all your help and HAPPY HOLIDAY :-)
ASKER
Thank youuuuuuuuuuuuuuuuuu
Happy Holidayyyyyyyyyyyyyyyyyyy
Happy Holidayyyyyyyyyyyyyyyyyyy
You're very welcome and Happy Holidays!!
You could also wrap it in <pre> </pre> tags although that makes the font monospaced as well (such as courier)