Re: JVM help!

2011-02-16 Thread Jochem van Dieten
Why do you believe this is a JVM problem? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: SELECT - Option selected

2011-02-16 Thread Torrent Girl
Does this not work on cfselect? If you are talking the HTML select element it is selected=selected Sent from my iPhone On Feb 15, 2011, at 4:47 PM, Torrent Girl moniqueb...@gmail.com wrote: ~| Order the Adobe Coldfusion

RE: JVM help!

2011-02-16 Thread Mark A. Kruger
+1 on this suggestion... set a permsize. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Carl Meyer [mailto:ca...@tassweb.com.au] Sent: Wednesday, February 16, 2011 1:29 AM To:

RE: JVM help!

2011-02-16 Thread Mark A. Kruger
Duncan, Yes... tell us what you mean by slow? Page execution is slow... Database queries... What's going on with the ap... What are these other aps... What leads you to believe it's the JVM? -Mark -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent:

Re: SELECT - Option selected

2011-02-16 Thread Azadi Saryev
depends on cfselect... in simple cfselect - one based on an in-page query, for example - you can provide a value in the 'selected' attribute and an option with that value will be pre-selected. advanced cfselect - one with a binding - does not support this functionality. but there are

Re: JVM help!

2011-02-16 Thread Wil Genovese
Duncan, Sorry about _MY_ confusion. I was reading and responding to your request, while 'out', with my phone and the small screen sometimes jumbles up a message enough to be confusing. I think I saw this running out of memory and thought that was the issue. I just noticed that the entire

RE: JVM help!

2011-02-16 Thread Mark A. Kruger
When you get varied response times like that I often take a closer look at the network (duplexing, flow control etc). -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Wednesday, February 16, 2011 10:11 AM To: cf-talk Subject: Re: JVM help! Duncan, Sorry

cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread James Skemp
Greetings. In one of our systems we're upgrading from ColdFusion 7 to CF 8. While testing a piece of functionality we were getting 0 returned as 0E-8 for a query using a stored procedure. If the value is greater than 0, there's no issue. Updating the procedure to cast the returned value as a

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread Mike Chabot
What is the data type of the field in SQL Server? If you run the query in Management Studio, what do you see for that value? How are you outputting the value in CF to see the 0E-8 number? What tag are you using to call the stored procedure in ColdFusion? Which version of MS SQL Server are you

Re: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Matt Robertson
Hey everybody, we're in a bind here and I pitched the idea to the client of bringing in a ringer. Is there someone out there who is interested in building a direct-to-SQL Server or direct-to-mySQL-based solution? Solution would have to, on a scheduled basis, grab a file in a location on the

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread James Skemp
Thanks for the clarification questions, Mike. What is the data type of the field in SQL Server? numeric(10,2) If you run the query in Management Studio, what do you see for that value? 0.00 How are you outputting the value in CF to see the 0E-8 number? In a tossed error it was displayed

RE: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Rick Faircloth
Hi, Matt... I know you might have looked at this link at dev.mysql.com for a solution to processing your data feed, but I thought I'd bring it up, just in case you haven't seen it. Looks like it might be right up your alley.

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread Mike Chabot
It occurred to me that I should first ask if this issue is causing any problems, or if it is only an unexpected way to format a number? For example 0.00 = 0E-8. They are both the same number regardless of how they are displayed. For clarification, which number has the unexpected formatting, the

RE: cfx_pwtextcrypt CF9

2011-02-16 Thread Brook Davies
Thanks for your help, I was able to get this working using your suggestions and the original code from encryption http://www.12robots.com/index.cfm/2010/7/19/Using-Asymmetric-Cryptography-in -your-ColdFusion-Application--Security-Series-1610. I modified that code to add support for the

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread James Skemp
It occurred to me that I should first ask if this issue is causing any problems, or if it is only an unexpected way to format a number? For example 0.00 = 0E-8. They are both the same number regardless of how they are displayed. Unfortunately, it is causing an issue in this particular instance

Re: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Matt Robertson
Yeah I have seen that, but I'm up against a time constraint and there are a number of issues I don't have my head wrapped around, and the client needs a solution asap given that he has a daily feed encompassing thousands of records and dozens of clients ... that has now been dead about 10 days.

Re: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Russ Michaels
Matt, as you want a non CF solution, you might be best posting elsewhere to find a database guru who could do it all directly on the DB. If no-one here pipes up then try www.odesk.com On Wed, Feb 16, 2011 at 6:09 PM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, Matt... I know you

(ot) field data restriction

2011-02-16 Thread Orlini, Robert
I have some Javascript code below that restricts a user from typing in letters, but they can type in numbers. Is there a way I can allow one character that is not a number? How can I edit the code to allow the : character only as well as numbers? Thanks. RO HWW SCRIPT LANGUAGE=JavaScript

Inline structure notation as argument fails

2011-02-16 Thread Jason Durham
I'm re-writing an event handler to utilize CF9s scripting enhancement. The majority of the handler was already written in cfscript, including the line of code I'm having problems with. After making the change to full script, I'm getting an exception indicating Variable EVENT is undefined.

Re: CFX_HTTP5 - returns partial string

2011-02-16 Thread Dave Watts
Thanks for your reply. In this case CFHTTP won't do it since the connection requires NTLM due to internal security requirements. OK. In that case, you might consider using Apache Commons HTTPClient instead. This is a Java library (or set of libraries) that will definitely work from a 64-bit

Re: JVM help!

2011-02-16 Thread Duncan
Hi everyone, thanks for all the good feedback. Let me first tell you WHY I think its a JVM issue, then show you what results I have had. We took the exact same code, and connected it to the exact same DB (and DB server) and ran the exact same code in isolation. The comparison was outstanding

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread Mike Chabot
Why would a SQL cast fix the issue? Casting a numeric(10,2) to a numeric(10,2) would not solve anything, which means that the value you are casting to numeric must be of a different data type, likely float or varchar. Floating point numbers often display in scientific notation. The numeric value

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread James Skemp
Thanks Mike. Opened up the procedure and gave it a look. It looks like there's some multiplication and division going on, which is resulting in a change. Relevant part for one of the returned values: MemberPrice = (case when qp.productid is null then p.MemberPrice else

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread Carl Von Stetten
Looks like you might need to revise the procedure to CAST the calculated value back to Numeric(10,2) before returning it? Carl On 2/16/2011 2:30 PM, James Skemp wrote: Thanks Mike. Opened up the procedure and gave it a look. It looks like there's some multiplication and division going on,

Re: JVM help!

2011-02-16 Thread Sean Corfield
On Wed, Feb 16, 2011 at 1:34 PM, Duncan duncan.lox...@gmail.com wrote: java.args=-server -Xms4096m -Xmx8192m -Dsun.io.useCanonCaches=false One thing I would be cautious about here: a heap that large can be susceptible to stop the world GC sweeps and if the heap ever grows near the 8GB max,

Re: Inline structure notation as argument fails

2011-02-16 Thread Sean Corfield
CF9 or CF9.0.1? ISTR a bug in this area that got fixed sometime along the way...? On Wed, Feb 16, 2011 at 1:05 PM, Jason Durham jqdur...@gmail.com wrote: I'm re-writing an event handler to utilize CF9s scripting enhancement.  The majority of the handler was already written in cfscript,

Re: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Jochem van Dieten
On Mon, Feb 14, 2011 at 11:44 PM, Matt Robertson wrote: I am tasked with doing an import on a file whose size can essentially be unlimited.  We've been able to handle in the 10-15mb range but it recently ballooned to 100 mb, and its going to get larger.  Processing time seems to be about 66

Re: cfquery returning 0 in scientific notation in CF 8 but not CF 7

2011-02-16 Thread James Skemp
Looks like you might need to revise the procedure to CAST the calculated value back to Numeric(10,2) before returning it? Carl Yeah, which is what we're doing for this one to resolve the issue. But since this is a legacy, third-party, application ... it worries me the number of places this

Using Google Apps/Gmail for CFMail - limitations?

2011-02-16 Thread Pete Ruckelshaus
I'm switching several domains over from multiple shared hosting accounts to a virtual private server. For a number of reasons (server resources, managing accounts), I am using the Gmail that comes with Google Apps for domain email for each domain.Without an SMTP server, I'll need to use

Re: Using Google Apps/Gmail for CFMail - limitations?

2011-02-16 Thread Matt Quackenbush
In my personal experience, Gmail for Domains is perfectly fine for sending/receiving small bits of mail here and there. However, with a mailing list of only about 300, it fails miserably. Very few go through, and it is quite arbitrary as to which ones go and which ones don't. That said, it is

Re: Using Google Apps/Gmail for CFMail - limitations?

2011-02-16 Thread Pete Ruckelshaus
OK, using GMail is probably out, then. What do I need to install/enable in order to send mail from multiple domains on a Windows 2008 Server? Just install MS SMTP, or are there better (free) third-party SMTP servers? Thanks, Pete On Wed, Feb 16, 2011 at 7:59 PM, Matt Quackenbush

Re: Using Google Apps/Gmail for CFMail - limitations?

2011-02-16 Thread Sean Corfield
I think you should serious consider something like a PowerMTA server at your hosting company... On Wed, Feb 16, 2011 at 4:51 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm switching several domains over from multiple shared hosting accounts to a virtual private server.  For a number of

Re: Using Google Apps/Gmail for CFMail - limitations?

2011-02-16 Thread Pete Ruckelshaus
I think that'd be overkill, given the relatively low volume. FWIW, I'm with KickAssVPS and have been happy with them now that I have my server set up. Pete On Wed, Feb 16, 2011 at 9:01 PM, Sean Corfield seancorfi...@gmail.comwrote: I think you should serious consider something like a

Re: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Matt Robertson
On Wed, Feb 16, 2011 at 3:49 PM, Jochem van Dieten wrote: Would it help if you split the file into individual records before processing them? I think it would help immensely I think. I'd prefer to fight my way thru this in CF if at all possible and things are just complex enough that I may

RE: Big XML files processing Really s-l-o-w. Solution?

2011-02-16 Thread Rick Faircloth
Hi, Matt... I've been tinkering with parsing the xml file and, though I haven't developed a full solution, I've made some progress that I thought I'd share. I created a MySQL 5 database called, xmlTest. I created a MySQL 5 database table called, xmlBlob. Fields: - rowID (int, not

Re: JVM help!

2011-02-16 Thread Carl Meyer
NewGen can sometimes be a problem. The temptation with 64 bit is setting a large initial heap size -Xms4096m. This can be quite fine however can lead to problems in JVM performance since the JVM is not making good decisions how to size the New Generation (which is made up of Eden and two

Re: JVM help!

2011-02-16 Thread Carl Meyer
Where else to make gains in JVM? You say the server is Quad Core CPU. Suggest allow the Garbage Collector in your case -XX:+UseParallelGC to multi thread and use all those cores. The JVM is going to GC so reduce the time of the GC’s is desirable especially for the Full GC as part of the

Re: JVM help!

2011-02-16 Thread Carl Meyer
Some Java / CF systems I have seen have done well to change the collector in use. Currently you are running -XX:+UseParallelGC which is a throughput GC. Perhaps you can experiment with changing to a low pause GC? Caveat UseParallelGC may be working well for the environment and changing

cf-talk replies

2011-02-16 Thread Rob Voyle
Hi Folks I have noticed recently that when I reply to a cf-talk email My email is not showing up in my email box. For example I recently replied to: Pete Ruckelhaus' email Here are my mail headers: From:Rob Voyle robvo...@voyle.com To: Pete Ruckelshaus pruckelsh...@gmail.com,

Re: cf-talk replies

2011-02-16 Thread Azadi Saryev
the last (before this one) post from you i see in my mailbox is from Jan 26 to thread session Variables Security if you have posted in-between Jan 26 and today then your posts did not show up in the list... Azadi On 17/02/2011 14:42 , Rob Voyle wrote: Hi Folks I have noticed recently that