Submitting form with file and CFGRID - Exception in The submitted cfgrid form field is corrupt

[Chad Baloga]

I have a form with a file upload and a CFGRID. When submitted the following 
error occurs:

Exception in The submitted cfgrid form field is corrupt

This works with CF10 Update 13. When we upgraded to Update 14 this error 
started occurring.

~|
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:359507
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

Are there any other ways to merge two PDFs w/forms without having to use 
cfpdf action=merge ?

~|
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:355602
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

So now I am having an issue with digitally signing in Adobe Reader. I can sign 
it if I open the document with Acrobat.  I already enabled usage rights in 
Acrobat on the documents and saved them.  After I use cfpdfform to populate the 
form, I have:

cfpdf action=write source=#commFileSpec# destination=#commFileSpec# 
flatten=yes overwrite=yes saveOption=incremental

Which I used to disable the fields from being changed by the user while still 
maintaining the digital signature box.  Am I doing something wrong? 

~|
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:355594
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 I am creating a PDF document on the fly and need to know how to place 
 a digital signature block on the document.  Is this possible using 
 cfdocument/cfpdf?  

Anyone ever use iText directly to manipulate PDFs in CF10?  I can merge a PDF 
document with a dig signature, but cannot insert the signature where I want it 
to go on my generated PDF using CFPDF. 

~|
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:355575
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 I don't think you can use iText to manipulate LC Designer forms. PDFs
 that you create with Designer are not the same as regular PDFs -
 they're a different format called XFA.
 

Right, I could not even merge a LiveCycle generated PDF with the PDF which I 
was generating with cfdocument.  I had to use Acrobat 9 to create my PDF with 
the digital signature so I could get it to merge with the other PDF.  This 
doesn't satisfy the requirement though since the signature needs to be embedded 
into the dynamic PDF above a persons name.  This is why I was thinking if there 
was a way to use cfscripting to try to place a signature into the dynamic PDF.


~|
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:355578
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 Why not create the PDF in LC Designer, and make the person's name a
 form field that you can easily manipulate from CF using CFPDFFORM?
 

Hmm.. how about all of the other data on the PDF which comes from the database? 
 The data can't appear as form fields on the PDF.

~|
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:355580
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 Form fields don't have to look like form fields, or be editable by the 
 user.
 

I'll give it a try. Thanks 

~|
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:355582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 Form fields don't have to look like form fields, or be editable by the 
 user.
 


Got it working!  Created the PDF form in LiveCycle, then add data in with 
cfpdfform.  Then run cfpdf on it to flatten it after data was added while still 
maintaining the signature fields.  Then merged with another form which was 
created on the fly. 

~|
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:355584
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Creating a PDF document with signature

[Chad Baloga]

I am creating a PDF document on the fly and need to know how to place a digital 
signature block on the document.  Is this possible using cfdocument/cfpdf?  

~|
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:355520
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 I might not have made it clear enough: you'll have to create the form
 with the digital signature field in LC Designer. You can then merge
 the form with your other generated document using CF.
 

OK. That is what I was just about to try.  Thanks

~|
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:355523
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 I might not have made it clear enough: you'll have to create the form
 with the digital signature field in LC Designer. You can then merge
 the form with your other generated document using CF.
 
 I have installed LiveCycle designer.  Do I just use the signature field?  The 
signature will be from a CAC card. 

~|
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:355524
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

   I have installed LiveCycle designer.  Do I just use the signature 
 field?  The signature will be from a CAC card.
 
 Yes, that's it.
 
OK. It seems I need to change some security setting on the form since it says 
You cannot save data typed in this form.  I'll have to play with it.  This is 
the first time I've used LiveCycle. 

~|
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:355527
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Creating a PDF document with signature

[Chad Baloga]

 If this document was originally created in Acrobat, and you open it 
 in
 Reader, you will see this message by default. If you want Reader 
 users
 to save data, you'll need to use Reader Extensions to Reader-enable
 the form. You can do this from within Acrobat (not LC Designer).
 
 All that said, if you're going to put it on your web site and have
 people fill it out and submit back to your web site, Reader users
 won't need to save data - you'll just need to make sure you have a
 submit button that points to a URL on your server.
 

This is the message that I see when I created a new PDF in LiveCycle designer 
with the signature field

~|
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:355530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Creating DOC file with image using CFCONTENT

[Chad Baloga]

I am trying to create a word document with images.  I have all the of the HTML 
in a cfsavecontent, then I use that variable to write the document, then open 
it with cfcontent. I have done this successfully in the past but now I have a 
document with an image.  How can I get it to use an image from a img tag?  

~|
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:355270
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

jQuery appendTo in IE7/8

[Chad Baloga]

I have a function which moves a DIV from one window to the parent window. It 
works find in Firefox and Chrome but not in IE7/8 (seems like the appendTo 
fails). Any suggestions...

function appendCmtDiv(div,no) { // ** Now we need to change the ID on the 
comment we are putting over and increment the count to sync up with the parent 
// Increment the comment count from the parent window var cmtCount = 
window.opener.$(#cmtCount).val(); var newCmtCount = parseInt(cmtCount) + 1;

// Change attributes on child DIV to match parent $(#revCmtCat + 
no).attr(name,cmtCat + newCmtCount).attr(id,cmtCat + newCmtCount); 
$(#revCmtTextbox + no).attr(name,cmtTextbox + 
newCmtCount).attr(id,cmtTextbox + newCmtCount);

// Remove comment button $(#revCmtButton + no).remove();

// Rename whole div box $(#+ div).attr(id,TextBoxDiv + newCmtCount);

// Set variable to where on the parent we want to append the DIV var parentDiv 
= window.opener.$('#TextBoxesGroup');

// Append DIV $(#TextBoxDiv+ newCmtCount).appendTo(parentDiv);

// Set incremented counter on parent 
window.opener.$(#cmtCount).val(newCmtCount);

~|
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:355111
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ZingChart issue w/ Double Quotes

[Chad Baloga]

So I call a CFC to get my ZingChart data, then I put that data in as the graph 
data attribute…  

var randomNum = Math.random();
// Call to CFC to get data
$.getJSON
   
(cfoutput#application.path.cfcScriptPath/cfoutputcfcs/database/dashboard/dashboar.cfc?randomNum=
 + randomNum + _cf_nodebug=true,
   {method:'get_allLRrespByMonth',
datasource: 'cfoutput#session.datasource#/cfoutput',
cache: false
   },
 function(data){

// Render chart from data passed from CFC
zingchart.render({
   width: cfoutput#variables.chartWidth#/cfoutput,
   height: cfoutput#variables.chartHeight#/cfoutput,
   container: 'zingchart4',
   data: data
}); 

   }); 


The data I see when I click “View Source” on the ZingChart looks like:

{
graphset:[
{\show-progress\:false,\graphset\:[
{\type\: 
\mixed\,\title\:{\text\:\LRResponseStatus-Last6mo\,\background-color\:
 \#578FD5\},\plot\:{\tooltip-text\:\%v\ + 
\DRLsReviewed\},\scale-x\:{\values\:[\Mar-12\,\Apr-12\,\May-12\,\Jun-12\,\Jul-12\,\Aug-12\,\Sep-12\,\Oct-12\,\Nov-12\,\Dec-12\,\Jan-13\,\Feb-13\,\Mar-13\]},\legend\
 : {\margin-top\:40},\series\:[
{\type\ : 
\bar3d\,\values\:[1,2,3,0,1,0,1,2,0,0,0,0,1],\text\:\LRResponses\}]}]}]
}

If I so a JS alert out the “data” it does not have the \” ‘s  but has 
just the regular double quotes as it should.  The \”’s are getting put in 
somehow and I wasn’t sure if it was the ZingChart code or what.  Has anyone 
else experienced this?

Thanks

~|
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:354804
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ZingChart issue w/ Double Quotes

[Chad Baloga]

I have also tried using a dataurl to the CFC. Double quotes still getting 
replaced with \ ...

zingchart.render({
   width: cfoutput#variables.chartWidth#/cfoutput,
   height: cfoutput#variables.chartHeight#/cfoutput,
   container: 'zingchart4',
   dataurl: 
'cfoutput#application.path.cfcScriptPath/cfoutputcfcs/database/dashboard/dashboard.cfc?method=get_allLRrespByMonthdatasource=cfoutput#session.datasource#/cfoutputrandomNum='
 + randomNum + '_cf_nodebug=true'
}); 

~|
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:354806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ZingChart issue w/ Double Quotes

[Chad Baloga]

Are you perhaps re-JSONing JSON? I noticed you did not pass
returnformat=json to your CFC. How are you handling that?

My cffunction tag is:
cffunction name=get_allLRrespByMonth access=remote returntype=any 
returnformat=json

Then in my function after my query...

cfsavecontent variable=graphData
'{' +
'show-progress:false,' +
'graphset:[' +
   '{' +
   'type: mixed,' +
'title:{' +
            'text:LR Response Status - Last 6mo,' +
'background-color: #578FD5' +
'},' +
'plot:{' +
   'tooltip-text:%v 
+  DRLs Reviewed' +
'},' +
'scale-x:{' +
  
'values:[cfoutput#ValueList(get_allLRrespByMonth.chartDates)#/cfoutput]' +
'},' +
'legend : {' +
   'margin-top:40' +
'},' +
  'series:[' +
 '{' +   
   'type : 
bar3d,' +

'values:[cfoutput#ValueList(get_allLRrespByMonth.allDrl)#/cfoutput],' +
'text:LR Responses' +
 '}' +
']}]}'
   /cfsavecontent

cfreturn graphData/   

~|
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:354809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ZingChart issue w/ Double Quotes

[Chad Baloga]

Same result if I use a $.get and a returnformat=plain from the CFC

Are you perhaps re-JSONing JSON? I noticed you did not pass
returnformat=json to your CFC. How are you handling that? 

~|
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:354812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Issue with updated Oracle drivers - ojdbc6.jar

[Chad Baloga]

Recently we had to add ojdbc6.jar to our CF10 lib folder since the Oracle 
drivers (version 8) shipped with CF10 did not meet STIG requirements.  We have 
run into an issue where we get PLS-00306: wrong number or types of arguments 
in call to... to all of our procedure calls now.  Had anyone experienced this 
when using Oracle drivers other than the ones shipped with CF10? 

~|
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:354681
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF Dashboards

[Chad Baloga]

Does anyone know of any ColdFusion or JS/jQuery dashboard plugins/code packages 
out there? 

~|
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:354044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Default date in cfinput type=datefield

[Chad Baloga]

I am wiping out a cfinput type=datefield and when that happens, the selected 
date in the calendar still defaults to the value of the input when the page 
loaded.  Is there any way to change that default to a different date?? 

~|
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:353510
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Default date in cfinput type=datefield

[Chad Baloga]

I am using jQuery to populate the input date...

$('#contractDate').val(cfoutput#dateFormat(Now(), 'mm/dd/yy')#/cfoutput);

When reset the val it changes the field value but the calendar is still 
defaulting to the date that it was before I changed it.

 Just set the field value equal to the default date you want.  
 Value=mydate
 
 
 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_williams 
 
 -Original Message-
 From: Chad Baloga [mailto:cbal...@gmail.com] 
 Sent: Monday, December 17, 2012 11:21 AM
 To: cf-talk
 Subject: Default date in cfinput type=datefield
 
 
 I am wiping out a cfinput type=datefield and when that happens, the 
 selected date in the calendar still defaults to the value of the input 
 when the page loaded.  Is there any way to change that default to a 
 different date?? 


~|
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:353513
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Default date in cfinput type=datefield

[Chad Baloga]

Actually, it does change the calendar but I want the input field to be empty 
and the calendar to default to todays date.  When I set the value to todays 
date, then wipe it out, it defaults back to the date when the page was loaded.

 I am using jQuery to populate the input date...
 
 $('#contractDate').val(cfoutput#dateFormat(Now(), 
 'mm/dd/yy')#/cfoutput);
 
 When reset the val it changes the field value but the calendar is 
 still defaulting to the date that it was before I changed it.
 
  Just set the field value equal to the default date you want.  
  Value=mydate
  
  
  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_williams 
  
  -Original Message-
  From: Chad Baloga [mailto:cbal...@gmail.com] 
  Sent: Monday, December 17, 2012 11:21 AM
  To: cf-talk
  Subject: Default date in cfinput type=datefield
  
  
  I am wiping out a cfinput type=datefield and when that happens, the 
 
  selected date in the calendar still defaults to the value of the 
 input 
  when the page loaded.  Is there any way to change that default to a 
 
  different date?? 


~|
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:353514
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: $.get URL length CF10/Tomcat

[Chad Baloga]

Yep... that is what I ended up doing

Shouldn't you switch to $.post if your URL is getting too long?




 

~|
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:353515
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

60sec timeout CF10

[Chad Baloga]

We are having issues with requests timing out after 60sec.  We are running CF10 
in IIS 7.5.  I have checked all the timeout settings in IIS and set them to 
600sec.  I have changed the Tomcat connector in server.xml to 6 as well. 
Are there any other areas to check in CF10.  We have not had this issue with 
previous version. 

~|
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:353434
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: 60sec timeout CF10

[Chad Baloga]

We do not have that box checked in the CF Admin and it is set to 600sec

 Yes the ColdFusion Administrator is the place to start, by default
 ColdFusion is set to timeout after 60 secs. There is also a tag that 
 can
 override this on a per page request, which I would recommend over 
 changing
 the Administrator setting.
 
 http://help.adobe.com/en_US/ColdFusion/9.
 0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d68.html
 
 
 -- 
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+:  http://plus.google.com/113032480415921517411
 
 
 On Wed, Dec 12, 2012 at 10:11 PM, Chad Baloga cbal...@gmail.com 
 wrote:
 
 
  We are having issues with requests timing out after 60sec.  We are 
 running
  CF10 in IIS 7.5.  I have checked all the timeout settings in IIS and 
 set
  them to 600sec.  I have changed the Tomcat connector in server.xml 
 to 6
  as well. Are there any other areas to check in CF10.  We have not 
 had this
  issue with previous version.
 
  

~|
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:353445
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

$.get URL length CF10/Tomcat

[Chad Baloga]

We have run into a problem with CF10 where we throw a 500 error when the URL 
string to a CFC call is too long.  Does anyone know what setting needs changed??

isapi_redirect.log error is: jk_isapi_plugin.c (1920): error while getting the 
url

We are running CF10 w/ IIS 7.5 

~|
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:353272
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFCONTENT ClientAbortException: java.net.SocketException w/ CF10

[Chad Baloga]

We upgraded to CF10 over the weekend and now we are getting errors on large 
cfontent file downnloads.  The users say the download finishes fine for them 
and they do not see any errors.

Error Message: The cause of this output exception was that: 
ClientAbortException: java.net.SocketException: Connection reset by peer: 
socket write error.

Any ideas?


~|
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:353241
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reading a ColdFusion session with a JSP App

[Chad Baloga]

Anyone know how or if you can read Coldfusion session variables from a JSP 
Deployed app if you pass the jsessionId to the JSP app? 

~|
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:352891
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a ColdFusion session with a JSP App

[Chad Baloga]

CF10 is deployed in the boxed Tomcat and the JSP app is deployed in a seperate 
Tomcat install on that server.  So it sounds like I'll have to go with option 
#2.  Thanks

 
 If they're both deployed in the same container, and you're using J2EE
 sessions (which it appears you are), they'll share the same session
 variables, and you can just refer to them in JSP like you would any
 other session variables.
 
 If they're not both deployed in the same container, you'd need to
 write something in CF to expose the variable values, and something in
 JSP to fetch the CF page via HTTP.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

~|
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:352894
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a ColdFusion session with a JSP App

[Chad Baloga]

Any suggestions on how to expose the variable values?  We are a https secure 
site with PKI. Thanks
 
 CF10 is deployed in the boxed Tomcat and the JSP app is deployed in a 
 seperate Tomcat install on that server.  So it sounds like I'll have 
 to go with option #2.  Thanks
 
  
  If they're both deployed in the same container, and you're using 
 J2EE
  sessions (which it appears you are), they'll share the same session
  variables, and you can just refer to them in JSP like you would any
  other session variables.
  
  If they're not both deployed in the same container, you'd need to
  write something in CF to expose the variable values, and something 
 in
  JSP to fetch the CF page via HTTP.
  
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  http://training.figleaf.com/
  
  Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
  GSA Schedule, and provides the highest caliber vendor-authorized
  instruction at our training centers, online, or onsite.

~|
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:352895
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF10 Update Errors

[Chad Baloga]

Does anyone else keep getting the below message when trying to update CF10 from 
the administrator?:

Error occurred while installing the update: 
Failed Signature verification 

~|
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:352858
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF10 Update Errors

[Chad Baloga]

OK, thanks

 Yes - You will get that if you DID NOT do this update.
 
 http://blogs.coldfusion.com/post.cfm/coldfusion-10-mandatory-update
 
 
 
 Wil Genovese
 Sr. Web Application Developer/
 Systems Administrator
 CF Webtools
 www.cfwebtools.com
 
 wilg...@trunkful.com
 www.trunkful.com
 
 On Oct 5, 2012, at 11:20 AM, Chad Baloga wrote:
 
  
  Does anyone else keep getting the below message when trying to 
 update CF10 from the administrator?:
  
  Error occurred while installing the update: 
  Failed Signature verification 
  
  

~|
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:352860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Query of Queries Error

[Chad Baloga]

I am try to run a query of queries to order a query I create on the fly. On DEV 
I do not get an error.  On PROD I am getting:

The system has attempted to use an undefined value, which usually indicates a 
programming error, either in your code or some system code.

Null Pointers are another name for undefined values. 

My Code:
cfquery name=docQryReordered dbtype=query
   SELECT * FROM docQry ORDER BY sysModule
/cfquery

If I take the ORDER BY out, I still get the error.

Any suggestions? 


~|
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:352765
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[Chad Baloga]

Yes it is, I have been playing with it and dumping results to see what data may 
be causing the error

try to dump query docQry chk if it is returning any row.


 


~|
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:352767
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[Chad Baloga]

I figured it out.  The last column had some NULL values which I guess it didn't 
like even though other columns have NULLs and it's fine (Sounds like a bug).  I 
defaulted the NULL ones to N/A so it works now.  Also had to declare all my 
columns as VARCHARs in my QueryNew set statement.

try to dump query docQry chk if it is returning any row.


 


~|
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:352769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Slowness with SOLR Indexing

[Chad Baloga]

What file types are everyone indexing?  I have just setup SOLR (CF901) with a 
few of our projects and the initial indexing is taking forever, and in most 
cases it just spins.  I got a few heap errors but modified some SOLR settings. 
Currently I am trying to index .doc, .docx, .xls, .xlsx, .ppt, .pptx, .txt, 
.rtf files.  Are there any ways to make the cfindex run faster?  

~|
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:352678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ISAPI Filters w/ IIS, CF9 and Tomcat

[Chad Baloga]

We currently have a CF9/IIS7.5 setup.  We are trying to introduce a JSP 
application and needed to install Tomcat to run it (It's on port 8080).  We 
need both CF and the JSP app to work on the same HTTPS (443) site.  I tried 
adding a ISAPI Redirect in IIS but that just makes the entire site run with 
Tomcat.  Anything else you can do for both to work in parallel? 


~|
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:351898
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ISAPI Filters w/ IIS, CF9 and Tomcat

[Chad Baloga]

Hey Dave,

What would be the easiest way to deploy the app on JRun?

Thanks
Chad

On Mon, Jul 16, 2012 at 11:23 AM, Dave Watts dwa...@figleaf.com wrote:

 We currently have a CF9/IIS7.5 setup.  We are trying to introduce a JSP 
 application and needed to install Tomcat to run it
 (It's on port 8080).  We need both CF and the JSP app to work on the same 
 HTTPS (443) site.  I tried adding a ISAPI Redirect
 in IIS but that just makes the entire site run with Tomcat.  Anything else 
 you can do for both to work in parallel?

 You can't have both of them handling the same set of URLs. You can
 define different context paths for each (assuming you're using CF 9
 Enterprise multiserver configuration). Or you could just deploy your
 JSP app on JRun.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
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:351900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF10 Tomcat case sensitivity

[Chad Baloga]

Does anyone know how to turn off the file case sensitivity on CF10/Tomcat?  
That is the first thing I noticed today after installing some of my images 
which has different cases did not show up. EX: It is saying that Image.jpg is 
not the same as image.jpg, and a red X appears. 

~|
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:351377
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF10 Tomcat case sensitivity

[Chad Baloga]

Found out how.. look for context.xml under 
{drive}\ColdFusion10\cfusion\runtime\conf

Change the context tag to look like:
Context AllowLinking=true caseSensitive=true

Restart the CF service 

~|
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:351379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: How big is your CF JVM?

[Chad Baloga]

Quick poll... How much memory have you allocated to CF on your production 
servers?

We are running Win 2008 R2, CF 9.0.1x Enterprise, w/ 3GB of RAM allocated to 
the CF/JVM

How say you?

Our production has 8GB of RAM allocated 

~|
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:350920
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF9 ODBC Service standalone install

[Chad Baloga]

I must have unchecked to install the ODBC service when I installed CF last 
week. Are there any standalone installs out there for it? 

~|
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:350922
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 ODBC Service standalone install

[Chad Baloga]

 I must have unchecked to install the ODBC service when I installed CF 
 last week. Are there any standalone installs out there for it? 

Nevermind. Found how... 
http://helpx.adobe.com/coldfusion/kb/coldfusion-odbc-services-corrupt-or.html 

~|
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:350923
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

XML Security

[Chad Baloga]

I was presented with some questions regarding XML and was wondering if there 
are any setting in Coldfusion to disable any of these or I do not need to worry 
about it since we do not use any XML in our code:

1.  How application employs methods for XML schema validation.
2.  How application disables use of inline XML Document Type Definition (DTD) 
schemas in XML parsing objects.
3.  How application manages DTD parsing behavior as a key to preventing the 
invocation of XML bombs.

Is it safe to say IF we were to use XML we could use the XML validation 
function built in CF9? 

~|
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:350644
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Blank page with no HTML tags

[Chad Baloga]

Tried all suggestions... still see:

html
   head/head
   body/body
/html

In my firebug info when the page is blank 

~|
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:350403
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Blank page with no HTML tags

[Chad Baloga]

If I view source, it is empty, but when I choose edit  select all, the cursor 
appears which may be the space that the requester is picking up?

 If you see the view source for the same you would not find anything. 
 Believe that is how FireBug works.
 
 Thx  rgds,
 Pradeep Viswanathan R 
 

~|
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:350405
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Blank page with no HTML tags

[Chad Baloga]

I am trying to place my cfheader/cfcontent tags inside a function now instead 
of on a cfm page.  Does anyone know if this will work and prompt for a file 
download?

 This does not happen for me... if you can post the code, we can try ?
 
 Thx  rgds,
 Pradeep Viswanathan R 
 

~|
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:350410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Blank page with no HTML tags

[Chad Baloga]

Came across something but I don't know if it works until I get the other party 
on the phone for testing.. will provide an update shortly

Is there a way a can create a blank page without the browser automatically 
adding:

In my case with Explorer, this is what I get:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=text/html; charset=windows-1252 http-equiv=Content-Type/HEAD
BODYPRE/PRE/BODY/HTML

But with Opera, Firefox, Safari or Chrome: nothing.

So this must be some Browser feature and I doubt you can control it at the 
server level. 

~|
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:350414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Blank page with no HTML tags

[Chad Baloga]

Is there a way a can create a blank page without the browser automatically 
adding:
html
   head/head
   body/body
/html
My page is a page with a bunch of cfheaders and does not return anything, but 
the requester says he see a carriage return being sent back to him.  I created 
just an empty cfm page with the same result. Any thoughts?  

~|
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:350321
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Blank page with no HTML tags

[Chad Baloga]

Thanks for the ideas.. I'll give them a try

~|
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:350326
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reading a certain range of a file

[Chad Baloga]

Does anyone know how I can read a certain byte range of a file.  I am basically 
trying to read 1-500 bytes, 501-1000 bytes, etc then output each chunk with 
cfcontent.  I have the cfheader code written for the content length but just 
need to figure out how to read a certain range of the file. Thanks 

~|
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:350301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a certain range of a file

[Chad Baloga]

I think I was able to get it to work using cffile readbinary.  Then converting 
that to a string to get a specified range.  Then I converted the substring back 
to a binary/base64 to be outputted with cfcontent. 

~|
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:350305
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a certain range of a file

[Chad Baloga]

And CF9 added fileSeek - if you need to start from some other position than 0.


Can you used a range like 500-999 with fileSeek? 

~|
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:350307
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a certain range of a file

[Chad Baloga]

 I think I was able to get it to work using cffile readbinary.  Then 
 converting that to a string to get a specified range.  Then I 
 converted the substring back to a binary/base64 to be outputted with 
 cfcontent. 

Turns out this method only worked with text files. Need it to work with a wider 
range of files.

~|
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:350308
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Reading a certain range of a file

[Chad Baloga]

  I think I was able to get it to work using cffile readbinary.  Then 
 
  converting that to a string to get a specified range.  Then I 
  converted the substring back to a binary/base64 to be outputted with 
 
  cfcontent. 
 
 Turns out this method only worked with text files. Need it to work 
 with a wider range of files.

Maybe not.. I was passing my headers incorrectly

~|
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:350309
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Running Scheduled Tasks

[Chad Baloga]

We have a new server that I am trying to run scheduled tasks on.  Problem is, 
the server does not have internet access out and it is an SSL site.  So I 
cannot browse by IP because I get the SSL error that the host names do not 
match.  I am able to add the IP/URL to the hosts file and browse to the site 
address in a browser, but CF still does not like that.  Any suggestions how I 
can run my scheduled tasks?  

~|
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:350230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Remove all CF comments

[Chad Baloga]

Are there any programs out there that will remove all CF comments from your 
code?? 

~|
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:350128
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Input are becoming disabled in IE

[Chad Baloga]

I am trying to troubleshoot why my text input fields are suddenly becoming 
disabled.  I run something on the page and all inputs become disabled 
throughout the system until I refresh the browser.  There are no JS errors or 
anything to indicate errors.  I have the following on the page to re-enable but 
nothing works: 

$(input).removeAttr(disabled);
$(input).removeAttr(readonly);
$(input).attr(disabled, false);

Note that this application is running under FW1 framework.  

Any suggestions? 

~|
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:349793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfheader Content-Range

[Chad Baloga]

I have come up with a solution but it is not working 100%.  It seems like the 
Content-Range header is not working.  I return the correct Content-Length, but 
it always starts at the beginning of the file.  See code below...

!--- If range is specified, then change some header info ---
cfif StructKeyExists(GetHttpRequestData().headers, Range)
   !--- Range value ---
   cfset variables.range = ListLast(GetHttpRequestData().headers[Range],=) 
/

!--- Calculate Range length ---
cfset variables.max = ListLast(variables.range,-)/
cfset variables.min = ListFirst(variables.range,-)/
cfset variables.rangeLength = variables.max - variables.min + 1/

cfheader statuscode=206 statustext=Partial Content
cfheader name=Accept-Ranges value=bytes
cfheader name=Content-Range value=bytes 
#variables.range#/#getFileSize.size#
cfheader name=Content-Length value=#variables.rangeLength#
cfelse
   cfheader name=Content-Length value=#getFileSize.size#
/cfif

!--- Open the file. ---
cfheader name=Last-Modified value=#variables.dateStr#
cfheader name=Content-disposition 
value=attachment;filename=#origFileName# 
cfcontent type=application/octet-stream file=#decryptedDoc# 

~|
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:349424
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfheader Content-Range

[Chad Baloga]

 CF isn't going to know anything about your range headers. It's just
 going to serve the file. If you wanted to serve part of the file,
 you'd have to read it into memory and serve the slice that you want 
 to
 serve.

Using cffile read? Is 1 character considered to be a byte? 

~|
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:349444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfheader Content-Range

[Chad Baloga]

Does anyone know how to get Content-Range returned as a header response when 
the request has Range: bytes=in it?  I added cfheader 
name=Accept-Ranges value=bytes but do not get the Content-Range back. 

~|
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:349304
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

DoD CAC with IIS 7.5

[Chad Baloga]

Does anyone know to setup DoD CAC/ECA with IIS 7.5?  We have been using Apache 
now for years and are required to move to IIS now.  Thanks 

~|
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:348200
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFFTP with form browsed file

[Chad Baloga]

Does anyone know if it is possible to upload a file browsed by a user using 
CFFTP instead of CFFILE upload?  We are trying to find a solution which will 
upload files faster than using CFFILE upload.  Any ideas? 

~|
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:347423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFTP with form browsed file

[Chad Baloga]

OK thanks.  We were using the asfusion uploader and now started moving to the  
cffileupload tag as well, but users are still complaining it is taking too long 
to upload files (Some files are as big as 800mb).

 in order to FTP a file from the client machine you would need to be
 able to connect to the clients machine, which means they would need 
 to
 be running an FTP server, or you would need to run some kind of FTP
 client on their machine to FTP the file to your server. Otherwise the
 file needs to be on the server before CF can do anything with it.
 There is probably some Flash uploaders or something out there that
 does what you need, try www.asfusion.com
 
 
 
 On Tue, Sep 13, 2011 at 4:13 PM, Chad Baloga cbal...@gmail.com 
 wrote:
 
  Does anyone know if it is possible to upload a file browsed by a 
 user using CFFTP instead of CFFILE upload?  We are trying to find a 
 solution which will upload files faster than using CFFILE upload. 
  Any ideas?
 
  

~|
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:347425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CFFILE in CFWINDOW

[Chad Baloga]

Have you tried cffileupload? I wrote some code a few weeks ago that has a
cffileupload in a cfwindow
On Sep 13, 2011 6:33 PM, Scott Spurlock spurlock.sc...@yahoo.com wrote:


 In CF8, I'm trying to upload multiple files via a CFFORM in a CFWINDOW.
I've googled enough to know it can't be done with just good ol' ColdFusion
since the file upload fields aren't being passed along in the form.  I've
looked at uploadify and some other AJAX solutions, but I don't need anything
too crazy/complex.  I need to stay within the window, as well as perform
some validation and database inserts.  I am comfortable with jQuery and
AJAX, but am certainly no expert.  What would be my best bet?


 Tha

 

~|
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:347447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Cheap CF9 Hosting

[Chad Baloga]

I am looking for a cheap place to host a site with CF9.  This is just a site I 
am making for my family.  Has anyone has any problems with http://hostek.com? 
Thanks 

~|
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:346409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF9 ODBC Error

[Chad Baloga]

I tried connection to create a CF ODBC datasource connection today on a Windows 
2008 Server machine and got the following error: 

HError accessing available odbc datasources. - Cannot open 
HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources: Windows error 2 
occurred.The system cannot find the file specified. 

Any ideas how to fix this? 

~|
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:343969
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 ODBC Error

[Chad Baloga]

Figured out that I needed to make a 64bit DSN to initialize something on the 
server. I used firebug to manually enter my 32bit DSN, submit and get:

Connection verification failed for data source: merlinFoxPro
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal 
error: The driver doesn't support the version of ODBC behavior that the 
application requested (see SQLSetEnvAttr).
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC 
Driver][ODBC Socket]internal error: The driver doesn't support the version of 
ODBC behavior that the application requested (see SQLSetEnvAttr).

Any ideas? Thanks 

~|
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:343971
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: java.lang.OutOfMemoryError: Java heap space

[Chad Baloga]

Can you make the max any higher?  We finally resolved our issue with that when 
we upgraded to Win Server 2k8, 8gb ram, and CF9.  I was able to set the max to 
4gb.   

~|
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:343337
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: DoD CAC authentication

[Chad Baloga]

One way...

CFSET usersCert = 
GetPageContext().getRequest().getAttribute(javax.servlet.request.X509Certificate)/

CFSET usersEmail = usersCert[1].getSubjectAlternativeNames() / 

~|
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:343349
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Adding more than 1 row in CFGRID

[Chad Baloga]

I am having a problem with CFGRID where I get Multiple row insert is not 
supported when a user clicks the insert row button more than once.  Is there a 
way to disable the Add Row button after it is clicked, or does anyone know how 
to get CFGRID to insert more than 1 row at a time?  Thanks 

~|
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:343243
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Issue with new CF Update

[Chad Baloga]

I installed the CF901 (APSB11-04) hotfix on our development and now we are 
having problems when trying to access different applications in the same 
browser at the same time.  Each application wants to use its own CFID and 
CFTOKEN, but when you log into one app which is app name X, then try to open 
app Z, you cannot get in because the CFID and CFTOKEN are already there from 
the other application.  Our URL domain name is the same for both.  Was there 
something in the hotfix that prevents this from happening now with the same 
domain name?? 

~|
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:342143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Purging the JRun service

[Chad Baloga]

When we run CFCONTENT with big file downloads the JRun service keeps growing in 
size and stays at that size.  Does anyone know how to run a garbage collection 
or anything else to purge all of that temp data that seems to be hogging up 
memory.  I am trying to find a way to do it without restarting my JRun/cfusion 
service.  Thanks 

~|
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:340404
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Installing CF9

[Chad Baloga]

We are upgrading our web servers with new 64bit Win2k8 Machines.  We only run 1 
instance of Coldfusion.  Is it best to stay with the standard install or 
install CF with the multi instance install.  We have no plans to have multiple 
instances but was wondering if there were any advantages.  Thanks 

~|
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:340106
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 Not Restarting after Java Update

[Chad Baloga]

That would be a very good example why you test everything you can before
migrating to production.

One question I will have to ask though, is this update replacing the JVM
installed in the ColdFusion directory or have you pushed the config changes
to point to the new JVM? Also it would be worth noting on whether you have
indeed d'loaded the correct version of the JVM did you install a  32bit JVM
on a 64Bit ColdFusion installation or even the other way around?


I got it to work this morning.  I installed the full SDK and changed the CF 
settings to point to the new JVM.  Not sure if the newer version will make a 
difference or not. Our biggest hurdle until we move to 64bit and more memory is 
the CFCONTENT Java Heap Issue.  Does anyone know much about the Jrun process 
and why it will stay up around 1.5gb unless you give the service a restart? 

~|
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:340077
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF9 Not Restarting after Java Update

[Chad Baloga]

This morning I installed Java 1.6 update 22. Before I even changed any 
jvm.config settings, I tried to restart the CF9 service and it would not 
restart.  After uninstalling the Java update, the CF service would start again. 
 I am running Win 2k3 w/ CF901. Anyone else experience this? 

~|
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:340044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 Not Restarting after Java Update

[Chad Baloga]

I see a few errors:

Error: no `server' JVM at `C:/Java/jre6\bin\server\jvm.dll'. (after I installed 
the update, and changed the jvm.config file)

coldfusion could not be started because it is already running.

Error occurred during initialization of VM
Could not reserve enough space for object heap
Could not create the Java virtual machine. 

~|
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:340047
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 Not Restarting after Java Update

[Chad Baloga]

I was able to get the first error to go away by installed the full Java SDK on 
my local machine.  I will have to try that first thing tomorrow AM on the 
production box.


~|
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:340049
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 Not Restarting after Java Update

[Chad Baloga]

Any explanations why just the JRE install worked on our DEV machine?  On that 
machine we are running Win2k3 64bit, w/ a multi instance install of CF9.  
Installed the JRE, changed the jvm config file, and restarted the service with 
no errors.  Is it getting some of the files from the Jrun portion of the multi 
instance install? 

~|
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:340052
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9 Not Restarting after Java Update

[Chad Baloga]

 If you go to the JVM shown in the CF Administrator, does it have a 
 server DLL?

This is on dev with CF9 multi instance:

Server Product   ColdFusion
Version 9,0,1,274733  
Edition Enterprise  
Serial Number   ***
Operating SystemWindows 2003  
OS Version  5.2  
Update Level
/C:/ColdFusion9/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/updates/chf9010001.jar
  
Adobe Driver Version4.0 (Build 0005)  
JVM Details
Java Version1.6.0_22  
Java Vendor Sun Microsystems Inc.  
Java Vendor URL http://java.sun.com/
Java Home   C:\Program Files\Java\jre6  
Java File Encoding  Cp1252  
Java Default Locale en_US  
File Separator  \  
Path Separator  ;  
Line Separator  Chr(13)
User Name   SYSTEM  
User Home   C:\Documents and Settings\Default User  
User DirC:\ColdFusion9\bin  
Java VM Specification Version   1.0  
Java VM Specification VendorSun Microsystems Inc.  
Java VM Specification Name  Java Virtual Machine Specification  
Java VM Version 17.1-b03  
Java VM Vendor  Sun Microsystems Inc.  
Java VM NameJava HotSpot(TM) 64-Bit Server VM  
Java Specification Version  1.6  
Java Specification Vendor   Sun Microsystems Inc.  
Java Specification Name Java Platform API Specification  
Java Class Version  50.0   


~|
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:340055
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Alternative to CFCONTENT

[Chad Baloga]

We are serving files from a file server to users using cfcontent/cfheader.  
When we upgraded to CF9, we started getting the java heap space errors when 
users would try to download files larger than 250mb.  We have the min and max 
heap space settings on 1024mb.  Are there any other alternatives that we could 
use? 

~|
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:338678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Saving files locally

[Chad Baloga]

Does anyone know how to save a file to a users local machine?  I am writing 
some code to export data to various file types and I have an input where a user 
can specify where they want the file to save to.  Thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Saving files locally

[Chad Baloga]

Ok, thanks Ray. Is it possible to use cfheader/cfcontent in my cffunction to 
prompt the user with the file download box?  I tried it but nothing seems to 
happen. Thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Saving files locally

[Chad Baloga]

What I am doing is calling a jQuery function which then uses a CFC method to 
create my file.  I am returning a message of how many files were created and 
zipped up.  I then want to present the user with the File Download box to 
download the newly created file.  It seems the cffunction does not like to have 
the cfheader/cfcontent in the same function so I put it in its own function. It 
appears the 2nd function call is returning the file contents to my $get result 
set.  If I call the function directly from a CFM page, the File Download box 
will appear.  Below is my cfc call and my cffunctions...

function exportPartsData(){ 
  // Set a hidden variable to the selected rows lsa_aIds
  getGridValues();
  // Set variables
  var aplsToUse  = $('#selectedGrid').val();
  var outputType = $('input:radio[name=fileType]:checked').val();

  
$.getJSON(services/Parts.cfc?ajaxTS=cfoutput#Now()#/cfoutput_cf_nodebug=true,
 {method:'exportData',
  idsToUse:idsToUse,
  cache: false
  },
   function(data){
  alert('+data+' +  Records Exported into a zip file into the 
selected directory.);
  // Present the user the a File Download Box
  
$.get(services/Parts.cfc?ajaxTS=cfoutput#Now()#/cfoutput_cf_nodebug=true,
   {method:'openFile',
cache: false
   },
function(data){
   //alert(data);
}
  );
}
);
   }



CFFUNCTIONS...

cffunction name=exportData access=remote returnformat=json 
returntype=any
   
   cfargument name=idsToUse

   cfset test = this is my test file./
   cffile action=write file=c:\test.txt output=#variables.test#/

   cfset fileCount = ListLen(idsToUse)/

   !--- Return the Count of files we created ---
   cfreturn fileCount /

/cffunction



cffunction name=openFile access=remote returnformat=plain 
returntype=Any hint=Function which will present the download box

   !--- Present the download box ---
   cfheader name=Content-disposition VALUE=attachment;filename=test.txt
   cfcontent type=application/octet-stream FILE=c:\test.txt

   cfreturn /
/cffunction






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337048
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Saving files locally

[Chad Baloga]

I was able to get it to work by just using...

window.location.href = 'test.zip'

But still curious about how to get it to work with the function call 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337050
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Bind to a CFINPUT from a CFGRID

[Chad Baloga]

I can't seem to figure out how to bind a selected column value in a CFGRID to a 
text box later on the page. Any ideas?  Thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335854
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFSTOREDPROD question

[Chad Baloga]

Does anyone know if CFSTOREDPROC closes a cursor automatically if a store proc 
is called with one? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335403
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Oracle Stored Procedure Help

[Chad Baloga]

I have never used stored procedures before but have been working on some code 
where they might be helpful to use with CFSTOREPROC instead of CFQUERY since I 
am dealing with a ton of records.  Can anyone provide an example of a simple 
stored procedure which will return a set of data with more than 1 row? I got 
one to work when I am just getting 1 row of data but am getting errors when my 
stored procedure has more than 1 row.  Thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335312
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Oracle Stored Procedure Help

[Chad Baloga]

I can't seem to get cfprocresult to dump anything (it's undefined).  The proc 
runs and returns data but for some reason it doesn't put the record set in it. 
Any ideas?


 I'm not completely clear if you're asking about how to write the proc 
 or how to call the proc.  You call the proc via ColdFusion like so:
 
   cfstoredproc procedure= 
   datasource=
   username= 
   password=
   cfprocparam dbvarname=in_varNameinProc 
 cfsqltype=cf_sql_varchar value=theValue type=in
   cfprocresult name = 
 whatWoudldHaveBeenNameinCfquery
   /cfstoredproc
 
 Put in the procedure name, prefix the schema name and the package name 
 if applicable.
 
 DSN, user, pass, all normal from your cfquery experience.  
 cfprocresult is the same as the name attribute in cfquery, i.e. the 
 name you'll use to reference your result set.
 
 cfprocparam, you'll have one of these for each input variable, in 
 order as they appear in the stored proc; the dbvarname is the name in 
 the stored proc, the cfsqltype is the data type, then of course you 
 reference the value you are passing in.
 
 If you're also needing to know how to write a stored proc in Oracle, 
 that's probably beyond the scope of this list, but suffice it to say 
 you need to ensure that the proc returns a cursor (result set).  You 
 mentioned an issue whenever you have more than one row of data...shot 
 in the dark, but maybe your problem is related to the issue here:  
 http://www.dba-oracle.com/t_pl_sql_plsql_select_into_clause.htm  That 
 one was a stickler for me when I moved from SQL Server, which is much 
 more forgiving of these things.
 
 Best,
 Shannon
 
  I have never used stored procedures before but have been working on 
 
  some code where they might be helpful to use with CFSTOREPROC 
 instead 
  of CFQUERY since I am dealing with a ton of records.  Can anyone 
  provide an example of a simple stored procedure which will return a 
 
  set of data with more than 1 row? I got one to work when I am just 
  getting 1 row of data but am getting errors when my stored procedure 
 
  has more than 1 row.  Thanks 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Oracle Stored Procedure Help

[Chad Baloga]

Oracle 10g

 We'll really need to know which DB you're using.
 
 --
 WSS4CF - WS-Security framework for CF
 http://wss4cf.riaforge.org/
 
 
 
 On 14 July 2010 08:23, Chad Baloga cbal...@gmail.com wrote:
 
  I can't seem to get cfprocresult to dump anything (it's undefined). 
  The proc runs and returns data but for some reason it doesn't put the 
 record set in it. Any ideas?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Oracle Stored Procedure Help

[Chad Baloga]

I tried but get an error.  Here is my stored procedure:

create or replace
PROCEDURE GETALL_SP (
v_a OUT table.a%TYPE,
v_b OUT NOCOPY table.b%TYPE,
v_c OUT NOCOPY table.c%TYPE
) IS

CURSOR Cursor_table IS
select distinct a, b, c
from mytable
where d not in (select d from getDeleted_V);

BEGIN
OPEN Cursor_table;

LOOP
FETCH Cursor_table
INTO v_a, v_b, v_c; 
EXIT WHEN Cursor_table%NOTFOUND OR 
Cursor_table%NOTFOUND IS NULL;
 
DBMS_OUTPUT.PUT_LINE(TO_CHAR(v_a) ||' '|| TO_CHAR(v_b) ||' '|| TO_CHAR(v_c));

END LOOP;

CLOSE Cursor_table;

END GETALL_SP;


Have you declared your result as a ref cursor in the PL/SQL?

--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/



On 14 July 2010 08:31, Chad Baloga cbal...@gmail.com wrote:
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Oracle Stored Procedure Help

[Chad Baloga]

My error is:
Error(2,1): PLS-00410: duplicate fields in RECORD,TABLE or argument list are 
not permitted when I have...

create or replace
PROCEDURE GETALL_SP (
v_a OUT table.a%TYPE,
v_b OUT NOCOPY table.b%TYPE,
v_c OUT NOCOPY table.c%TYPE,
Cursor_table sys_refcursor
) IS



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335335
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Leading zeros being removed

[Chad Baloga]

Has anyone figured out how not to have an array value with leading zeros not 
remove the zeros?  I have an array from a query which I am getting from a 
Jquery $.getJSON but it it removing some zeros from strings where I want the 
the leading zeros.  Thanks 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Leading zeros being removed

[Chad Baloga]

I want to return the array like [{1:test},{2:00200}].  The actually array 
return is [{1:test},{2:200.0}].  I am just returning an array from a cfc. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333941
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFgrid default save and cancel buttons

[Chad Baloga]

Does anyone know how to change the default save and cancel buttons in an 
editable cfgrid (html format)? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333821
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Cfdebug and CFCs with $.get

[Chad Baloga]

I am using some jQuery $.get's with CFCs and my returns are including the cf 
debug info.  Does anyone know how to turn it off for just the CFCs?  I tried 
putting cfsetting tags on some of the pages but that is not working. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333748
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfgridcolumn bgcolor

[Chad Baloga]

I am displaying a cfgrid from a bind and need certain rows to be a certain 
color.  I am trying: bgColor=(C1 EQ K?red:black) but doesn't seem to work. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333759
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Change CFSELECT SELECTED value

[Chad Baloga]

I am trying to figure out how to make a selected value in a cfselect change 
based on other fields changing on the form.  I have the cfselect binded to a 
function to load when the page loads, but need to change my selected value in 
that cfselect to change dynamically.  Any ideas?  

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333427
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm