> This is something i havent had to deal with before - might seem
> strange to you Americans, but I have to figure out how to handle a
> client who wants teh double quote symbol to represent inches. He's
> a car parts retailer, and sells shock absorbers that are known to his
> market by inches not centimetres. He doesnt want to represent a 12
> inch shock as <quote> 12in throw</quote> he wants to use the double
> quote symbol.
Sounds pretty normal on my end.
> However the quote symbol is seen by the form as teh end of the field
> when he wants to update his database on line, so the form has to be
> given 12" not 12". I either have to make sure there are no
> double quote symbols in teh database, or put a replace() somewhere
> before the variable goes to the form html.
Right, you want
<input name="yadda" value="#htmleditformat(thevalue)#" />
> Here's my question. do you store 12" in the database, or 12"
> Does it matter?
I would recommend not storing anyting with entities like " in the
database, because there's no guarantee the data will always be used for
HTML. Maybe it will, maybe it won't. Maybe it'll go out in an email.
Maybe it'll go into a PDF. Maybe it'll go into an Excel spreadsheet.
Maybe it'll get sent to someone via a webservice. It's usually
impossible to know in advance really what formats it might potentially
be used in, so generally speaking I recommend storing the value with no
formatting and then applying the formatting when outputing or sending to
wherever you want it.
hth,
ike
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 781.769.0723
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
