RE: Data Truncation on CFquery Update: SOLVED
Thanks Rob Parkhill. It was the Max data length in cf admin.It was set to 64,000 characters by default. Adjusting that solved the problem. Robert Harrison Director of Interactive Services Austin & Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Date Truncation on CFquery Update
He specifically said data was not list on the post. Check your dan for chat limits, you may also need to enable blob support. On Jun 13, 2012 5:19 PM, "Edward Chanter" wrote: > > There's a post limit in the CF admin, I think the default is 100Mb but > given > that your post is so huge you might want to see if increasing that setting > helps. > > > -Original Message- > > From: Robert Harrison [mailto:rob...@austin-williams.com] > > Sent: 13 June 2012 17:17 > > To: cf-talk > > Subject: Date Truncation on CFquery Update > > > > > > I have a client who is essentially entering a document of 50+ pages into > a > text > > area field (tiny MCE). The data is being saved to a data base via CFquery > > Update. The data base is MS SQL server and the field length is set to > > VARCHAR(MAX). Data is being truncated on update to data base (same place > > every time). > > > > I have checked and the data is not being lost by the text area. If I > display the > > post field after the Update Query, all the data is there. It's definitely > being > > truncated either by CFQuery or by the data base. > > > > I have (temporarily) removed cfqueryparam, so that is not the culprit. > > > > Any ideas what is causing the truncation? > > > > Thanks > > > > > > > > Robert Harrison > > Director of Interactive Services > > > > Austin & Williams > > Advertising I Branding I Digital I Direct > > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X > > 119 F 631.434.7022 http://www.austin-williams.com > > > > Blog: http://www.austin-williams.com/blog > > Twitter: http://www.twitter.com/austin_ > > > > > > ~| > > Order the Adobe Coldfusion Anthology now! > > http://www.amazon.com/Adobe-Coldfusion- > > Anthology/dp/1430272155/?tag=houseoffusion > > Archive: http://www.houseoffusion.com/groups/cf- > > talk/message.cfm/messageid:351564 > > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > > Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Date Truncation on CFquery Update
Probably Max data length in cf admin. Look at the advanced DB connection settings. Will be set to default of 6 characters. I ran into something similar saving a wddx variable. Cheers, Rob On Jun 13, 2012 12:17 PM, "Robert Harrison" wrote: > > I have a client who is essentially entering a document of 50+ pages into a > text area field (tiny MCE). The data is being saved to a data base via > CFquery Update. The data base is MS SQL server and the field length is set > to VARCHAR(MAX). Data is being truncated on update to data base (same > place every time). > > I have checked and the data is not being lost by the text area. If I > display the post field after the Update Query, all the data is there. It's > definitely being truncated either by CFQuery or by the data base. > > I have (temporarily) removed cfqueryparam, so that is not the culprit. > > Any ideas what is causing the truncation? > > Thanks > > > > Robert Harrison > Director of Interactive Services > > Austin & Williams > Advertising I Branding I Digital I Direct > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 > T 631.231.6600 X 119 F 631.434.7022 > http://www.austin-williams.com > > Blog: http://www.austin-williams.com/blog > Twitter: http://www.twitter.com/austin_ > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Date Truncation on CFquery Update
There's a post limit in the CF admin, I think the default is 100Mb but given that your post is so huge you might want to see if increasing that setting helps. > -Original Message- > From: Robert Harrison [mailto:rob...@austin-williams.com] > Sent: 13 June 2012 17:17 > To: cf-talk > Subject: Date Truncation on CFquery Update > > > I have a client who is essentially entering a document of 50+ pages into a text > area field (tiny MCE). The data is being saved to a data base via CFquery > Update. The data base is MS SQL server and the field length is set to > VARCHAR(MAX). Data is being truncated on update to data base (same place > every time). > > I have checked and the data is not being lost by the text area. If I display the > post field after the Update Query, all the data is there. It's definitely being > truncated either by CFQuery or by the data base. > > I have (temporarily) removed cfqueryparam, so that is not the culprit. > > Any ideas what is causing the truncation? > > Thanks > > > > Robert Harrison > Director of Interactive Services > > Austin & Williams > Advertising I Branding I Digital I Direct > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X > 119 F 631.434.7022 http://www.austin-williams.com > > Blog: http://www.austin-williams.com/blog > Twitter: http://www.twitter.com/austin_ > > > ~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion- > Anthology/dp/1430272155/?tag=houseoffusion > Archive: http://www.houseoffusion.com/groups/cf- > talk/message.cfm/messageid:351564 > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Date Truncation on CFquery Update
I have a client who is essentially entering a document of 50+ pages into a text area field (tiny MCE). The data is being saved to a data base via CFquery Update. The data base is MS SQL server and the field length is set to VARCHAR(MAX). Data is being truncated on update to data base (same place every time). I have checked and the data is not being lost by the text area. If I display the post field after the Update Query, all the data is there. It's definitely being truncated either by CFQuery or by the data base. I have (temporarily) removed cfqueryparam, so that is not the culprit. Any ideas what is causing the truncation? Thanks Robert Harrison Director of Interactive Services Austin & Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Urgent: Server queues all requests for one loop
I have a jar file with a couple of methods that do decryption that I am calling in a loop. The loop is big, 6000 iterations and while its running the server is basically brought to a grinding halt and other requests start to queue and/or execute very slowly. The cpu is at 40% or so, memory usage does not spike. How does one thread cause the entire server to grind to a halt? The funny thing is, If I add a thread.sleep(10) in between each iteration then the server is able to serve other requests fairly quickly and nothing queues. This code does not cause the server to queue all other requests because of the thread.sleep(), without it, this loop takes over and everything else queues (or completes very slowly): This is the method that is being called: /** * Decodes a string encoded using its corresponding private key. This must be done manually due to the unusual padding and * byte ordering involved. * @param encryptedString the encrypted string, in aec/TRSA's version of RSA, in aec's version of base-64 encoding. * @param aecPrivateKey the corresponding private key, in aec/TRSA's version of base-64 encoding. * @return a String representing the original plaintext message. */ public static String aecDecrypt(String encryptedString, String aecPrivateKey) { RSAPrivateKeySpec privKeySpec = AECKeyToPrivateKeySpec(aecPrivateKey); BigInteger d = privKeySpec.getPrivateExponent(); BigInteger n = privKeySpec.getModulus(); byte[] src = unpackAECEncodedBase64(encryptedString); // this is where the time is spent.. BigInteger c = new BigInteger(1,src); BigInteger m = c.modPow(d,n); byte[] decrypted = m.toByteArray(); for(int i=0; ihttp://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Installing CF10 on IIS7.5 Win7 64-bit - SOLVED
That did it :D It's now installing quite happily. Thanks very much Paul -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, June 13, 2012 1:50 PM To: cf-talk Subject: re: Installing CF10 on IIS7.5 Win7 64-bit I had that happen, too. Go through Control Panel and install CGI and re-try it: * Control Panel * Turn Windows features on or off * Internet Information Services * World Wide Web Services * Application Development Features * check CGI and hit OK - Jason From: "Paul Vernon" Sent: Wednesday, June 13, 2012 8:37 AM To: "cf-talk" Subject: Installing CF10 on IIS7.5 Win7 64-bit Iâm having real trouble getting CF10 Developer Edition installed and Iâve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... âCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.â The thing is, I checked and these components are already installed and running in IIS and the error log isnât much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iâm not getting very far that would be a great help... I should add that this is my brand new system so itâs a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Installing CF10 on IIS7.5 Win7 64-bit
Make sure the IIS6 interface is installed. That was a problem in 9...I am guessing they didn't fix that in 10. I just installed 10 on my Win 7 Ultimate 64 bit system with no problems a couple of days ago. Eric -Original Message- From: Paul Vernon [mailto:paul.ver...@web-architect.co.uk] Sent: Wednesday, June 13, 2012 7:36 AM To: cf-talk Subject: Installing CF10 on IIS7.5 Win7 64-bit Iââ¬â¢m having real trouble getting CF10 Developer Edition installed and Iââ¬â¢ve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... ââ¬ÅCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.ââ¬Â The thing is, I checked and these components are already installed and running in IIS and the error log isnââ¬â¢t much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iââ¬â¢m not getting very far that would be a great help... I should add that this is my brand new system so itââ¬â¢s a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: Installing CF10 on IIS7.5 Win7 64-bit
I had that happen, too. Go through Control Panel and install CGI and re-try it: * Control Panel * Turn Windows features on or off * Internet Information Services * World Wide Web Services * Application Development Features * check CGI and hit OK - Jason From: "Paul Vernon" Sent: Wednesday, June 13, 2012 8:37 AM To: "cf-talk" Subject: Installing CF10 on IIS7.5 Win7 64-bit Iâm having real trouble getting CF10 Developer Edition installed and Iâve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... âCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.â The thing is, I checked and these components are already installed and running in IIS and the error log isnât much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iâm not getting very far that would be a great help... I should add that this is my brand new system so itâs a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Installing CF10 on IIS7.5 Win7 64-bit
Iâm having real trouble getting CF10 Developer Edition installed and Iâve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... âCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.â The thing is, I checked and these components are already installed and running in IIS and the error log isnât much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iâm not getting very far that would be a great help... I should add that this is my brand new system so itâs a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm