RE: Problem with data formatting in CFINSERT

2013-11-04 Thread David Phelan
It's been a long time since I've used Access, but if I remember correctly the currency data type only accepts 2 decimal places. You need to make sure that the data that you are supplying only has 2 decimal places. It is impossible to determine where the extra decimal places are coming from

Re: Problem with data formatting in CFINSERT

2013-11-04 Thread Claude Schnéegans
but if I remember correctly the currency data type only accepts 2 decimal places. I know, and my form only supplies 2 decimal places. Java adds all these decimals, due to floating approximation errors. And it does not explain whay there is an error with 57.49 and not with 57.50. Anyway, I

Removing bullets from textarea

2013-11-04 Thread Joy Paulose
Hi, I want to remove bullets and other strange characters from textarea. if the user enters the text by copying and pasting from Word, it does not display properly. On submission, the bullets and the double quotes basically turn into a ? (question mark). Did anyone ever find a solution for

Re: Removing bullets from textarea

2013-11-04 Thread Phillip Vector
Run the entry through a REReplace and only allow characters you want in there. On Mon, Nov 4, 2013 at 1:08 PM, Joy Paulose kalappura...@hotmail.comwrote: Hi, I want to remove bullets and other strange characters from textarea. if the user enters the text by copying and pasting from Word,

Re: Removing bullets from textarea

2013-11-04 Thread John M Bliss
http://cflib.org/udf/convertSpecialChars On Mon, Nov 4, 2013 at 4:08 PM, Joy Paulose kalappura...@hotmail.comwrote: Hi, I want to remove bullets and other strange characters from textarea. if the user enters the text by copying and pasting from Word, it does not display properly. On

Re: Problem with data formatting in CFINSERT

2013-11-04 Thread Money Pit
IMO the worst problem with CFINSERT or CFUPDATE is that you have to supply the list of all form fields I'm afraid you can add to that chasing your tail for no reason thanks to creating a semi-opaque layer between yourself and JDBC/SQL If you use CFINSERT/CFUPDATE the above seems, sooner or

Re: Problem with data formatting in CFINSERT

2013-11-04 Thread Russ Michaels
Thst is a rather hlanket statement though, it could just as easy be said about frameworks or even cfml itself. Not all middle tiers are restrictive. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 5 Nov 2013 00:10, Money Pit websitema...@gmail.com wrote: IMO the

Re: Problem with data formatting in CFINSERT

2013-11-04 Thread Money Pit
Perhaps. Every time I flirt with cfinsert/cfupdate I learn to love them all over again and then some stupid thing like what the OP is experiencing ruins my afternoon and I remember why I swore them off in the first place. When I write straight SQL I experience extra wear on my fingertips but my

Re: Problem with data formatting in CFINSERT

2013-11-04 Thread Russ Michaels
I wont disagree that CFINSERT et al should best be a avoided though, it is pretty much a legacy tag that is there for backwards compatibility, you certainly don't see many devs using it these days though. It's like the Tesco value version of database tags :-) On Tue, Nov 5, 2013 at 1:07 AM,

Re: CFMX 10 cluster question

2013-11-04 Thread Carl Meyer
Hi Alex, That all makes sense. What tho about users browsing to IIS, will they URL to one or the other or both somehow via a load balancer? Regards, Carl. - On BOX1 connect IIS to the local cluster - On BOX2 connect IIS to the local cluster Does this sound correct? Is