Re: An instance of CF 7, CF 8, CF 9 on single pc
sadly thats the MAX my laptop can take, its an ultra mobile, not really intended to be a evelopment machine. i'm sure I ran a linux VM it would be fine as that requires far less Ram, but I don;t really wish to torture myself :-) On Wed, Sep 15, 2010 at 3:01 AM, Andrew Scott andr...@andyscott.id.auwrote: Not surprised it struggles with 2.5g of ram :-) Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, 15 September 2010 11:10 AM To: cf-talk Subject: Re: An instance of CF 7, CF 8, CF 9 on single pc that's the easiest option as long your machine has the power and diskspace and probably better even to have just 1 VM to save cluttering up your desktop pc with all those server apps auto starting and consuming your resources and slowing it down. If you have a single CPU this could be a bit slow though, I would suggest a dual core as minimum. I run windows 7 64bit on my desktop with 8gb RAM and a quad core CPU, so I don't really have any issues with running everything at the same time in here, so no need for a VM, although I do keep an unbuntu VM to hand in case I need it. On my laptop I have windows 7, a core2 mobile cpu and 2.5 gb ram. It struggles a bit running a VM (prob due to the mobile cpu) and everything runs fairly slow, so I prefer to just run Multiple instances of CF, railo, MSSQL, MySQL etc in a STOPPED state and just start the services I need as and when I need them. I do this with a batch file for each setup. ~| 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:337039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: cfimage and imageutils.cfc...
Here's the code: (The first part is using the method Ben used in the cfc and the second section (which is commented out) is using the TextLayout method... Eric cfscript // initialize the text properties Font = CreateObject(java, java.awt.Font); text = { x = 10, y = 30, string = Sheehan Funeral Home Sheehan Funeral Home Sheehan Funeral Home Sheehan Funeral Home }; text.prop = { font=Times New Roman, style=bolditalic, javaStyle= BitOr(Font.BOLD, Font.ITALIC), size=30 }; // create a new image and draw the text img = ImageNew(, 10, 10, rgb, lightgray); // get the underlying graphic of the image graphics = ImageGetBufferedImage( img ).getGraphics(); // recreate the font used to draw the text currentFont = Font.init( javacast(string, text.prop.font), javacast(int, text.prop.javaStyle), javacast(int, text.prop.size) ); // get text measurements using font metrics fontMetrics = graphics.getFontMetrics( currentFont ); fontBounds = fontMetrics.getStringBounds( javacast(string, text.string), graphics ); img = ImageNew(, fontBounds.getWidth()+20, fontBounds.getHeight()+10, rgb, lightgray); ImageSetDrawingColor( img, black ); yOffset= javacast(int, text.y)/2 + javacast(int,(fontBounds.getHeight())/2) ; xOffset=text.x; ImageDrawText( img, text.string,xOffset,yOffset , text.prop ); // draw a rectangle indicatating the font bounds Color = createObject(java, java.awt.Color); graphics.setColor(Color.RED); graphics.drawRect( javacast(int, text.x)-5, javacast(int, text.y) - fontMetrics.getAscent()-5, fontBounds.getWidth()+10, fontBounds.getHeight()+10); // get the dimensions dimensions.xoffset=xoffset; dimensions.yoffset=yoffset; dimensions.type = FontMetrics; dimensions.width = fontBounds.getWidth(); dimensions.height = fontBounds.getHeight(); dimensions.height_int = javacast(int,fontBounds.getHeight()); dimensions.leading = fontMetrics.getLeading(); dimensions.ascent = fontMetrics.getAscent(); dimensions.descent = fontMetrics.getDescent(); graphics.dispose(); /cfscript cfdump var=#dimensions# cfimage action=writeToBrowser source=#img#--- !--- cfscript // get the text measurements using text layout graphics = ImageGetBufferedImage( img ).getGraphics(); context = graphics.getFontRenderContext(); TextLayout = createObject(java, java.awt.font.TextLayout); layout = TextLayout.init( text.string, currentFont, context ); layoutBounds = layout.getBounds(); // draw a rectangle to indicating the layout bounds Color = createObject(java, java.awt.Color); graphics.setColor( Color.BLUE ); graphics.drawRect( javacast(int, text.x) - layout.getLeading() - 2, javacast(int, text.y) - layout.getAscent() + 1, layoutBounds.getWidth(), layoutBounds.getHeight() );// get the dimensions dimensions.type = TextLayout; dimensions.width = layoutBounds.getWidth(); dimensions.height = layoutBounds.getHeight(); dimensions.leading = layout.getLeading(); dimensions.ascent = layout.getAscent(); dimensions.descent = layout.getDescent(); graphics.dispose(); /cfscript cfdump var=#dimensions# cfimage action=writeToBrowser source=#img# ~| 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:337040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Saving files locally
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
Nope, you can't with a traditional web based app. You can with AIR easily enough. On Wed, Sep 15, 2010 at 7:00 AM, Chad Baloga cbal...@gmail.com wrote: 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:337042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
What would be the best way to do this? Just install them all in standalone mode side by side, it works fine. This is just for development and testing so you're unlikly to be using them all at the same time, infact unless you are part of a team your server is likley to be doing nothing most of the time anyway. As an example. I have here in my office my humble old development server. It's a 9 year old 1.5GHz Pentium 4 with a grand total of 768Mb of RAM running windows 2000 server (IIS5). I currently have installed... wait for it. Coldfusion 5. Coldfusion 6.1. Coldfusion 7. Coldfusion 8. Coldfusion 9. Bluedragon 7.0.1 I did have openDB/Jetty installed at one point too. CF9 was a bit of a pain to install as Adobe have dropped support for windows 2000 but it can be done. See here : http://www.delbridge.org/post.cfm/how-to-install-coldfusion-9-on-windows-2000-iis-5 Oh I also have MySQL 5.1 and SQL Server express installed, plus Apache too for my SVN repos. I have IIS setup serving virtual hosts for all my dev sites and set each site up for the required CF version depending on the project/client's requirements. (I run DNS too on this server but you could do the same BY editing your hosts file). To keep things sane I tend to turn off the older CF's in the services control panel as it's getting really rare to need CF5 6 and BD is specific to a single client so I turn that off too. But even then right now that leaves CF7,8 and 9 running. As I said, this is for development so although they are all running they mostly get paged out to swap except for the CF driving the project I'm working on at that moment so memory is not big issue (I have around 100Mb free at the moment!) The only tweaking I've done is to set the number of simultaneous requests quite low (4) to cope with the crappy CPU. For ease of access to the the docs and admin I have a virtual host for each CF that has the home directory pointing at the wwwroot folder in the relevant CF directory. That way I can access all the admins easily eg. http://cf8/cfide/administrator/ So my advice is just to go for it. If you have an anywhere near new PC you shouldn't have any issues with memory or processing power. Install the oldest CF first and work your way up to CF9. And of course remember that this is just for dev purposes... nothing live or under any significant load. Regards Matt Casey ~| 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:337043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Saving files locally
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
Oh yeah, that's definitely possible. Show us your code - that shoulda worked fine. On Wed, Sep 15, 2010 at 7:57 AM, Chad Baloga cbal...@gmail.com wrote: 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:337045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
I currently have installed... wait for it. That cracked me up. Coldfusion 5. Coldfusion 6.1. Coldfusion 7. Coldfusion 8. Coldfusion 9. Bluedragon 7.0.1 I did have openDB/Jetty installed at one point too. Matt, you are an ill man. ;) G! On Wed, Sep 15, 2010 at 8:52 AM, Matt Catmacey m...@catmacey.com wrote: What would be the best way to do this? Just install them all in standalone mode side by side, it works fine. This is just for development and testing so you're unlikly to be using them all at the same time, infact unless you are part of a team your server is likley to be doing nothing most of the time anyway. As an example. I have here in my office my humble old development server. It's a 9 year old 1.5GHz Pentium 4 with a grand total of 768Mb of RAM running windows 2000 server (IIS5). I currently have installed... wait for it. Coldfusion 5. Coldfusion 6.1. Coldfusion 7. Coldfusion 8. Coldfusion 9. Bluedragon 7.0.1 I did have openDB/Jetty installed at one point too. CF9 was a bit of a pain to install as Adobe have dropped support for windows 2000 but it can be done. See here : http://www.delbridge.org/post.cfm/how-to-install-coldfusion-9-on-windows-2000-iis-5 Oh I also have MySQL 5.1 and SQL Server express installed, plus Apache too for my SVN repos. I have IIS setup serving virtual hosts for all my dev sites and set each site up for the required CF version depending on the project/client's requirements. (I run DNS too on this server but you could do the same BY editing your hosts file). To keep things sane I tend to turn off the older CF's in the services control panel as it's getting really rare to need CF5 6 and BD is specific to a single client so I turn that off too. But even then right now that leaves CF7,8 and 9 running. As I said, this is for development so although they are all running they mostly get paged out to swap except for the CF driving the project I'm working on at that moment so memory is not big issue (I have around 100Mb free at the moment!) The only tweaking I've done is to set the number of simultaneous requests quite low (4) to cope with the crappy CPU. For ease of access to the the docs and admin I have a virtual host for each CF that has the home directory pointing at the wwwroot folder in the relevant CF directory. That way I can access all the admins easily eg. http://cf8/cfide/administrator/ So my advice is just to go for it. If you have an anywhere near new PC you shouldn't have any issues with memory or processing power. Install the oldest CF first and work your way up to CF9. And of course remember that this is just for dev purposes... nothing live or under any significant load. Regards Matt Casey ~| 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:337046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
i'm surprised his laptop even runs LOL On Wed, Sep 15, 2010 at 2:26 PM, Gerald Guido gerald.gu...@gmail.comwrote: I currently have installed... wait for it. That cracked me up. Coldfusion 5. Coldfusion 6.1. Coldfusion 7. Coldfusion 8. Coldfusion 9. Bluedragon 7.0.1 I did have openDB/Jetty installed at one point too. Matt, you are an ill man. ;) G! On Wed, Sep 15, 2010 at 8:52 AM, Matt Catmacey m...@catmacey.com wrote: What would be the best way to do this? Just install them all in standalone mode side by side, it works fine. This is just for development and testing so you're unlikly to be using them all at the same time, infact unless you are part of a team your server is likley to be doing nothing most of the time anyway. As an example. I have here in my office my humble old development server. It's a 9 year old 1.5GHz Pentium 4 with a grand total of 768Mb of RAM running windows 2000 server (IIS5). I currently have installed... wait for it. Coldfusion 5. Coldfusion 6.1. Coldfusion 7. Coldfusion 8. Coldfusion 9. Bluedragon 7.0.1 I did have openDB/Jetty installed at one point too. CF9 was a bit of a pain to install as Adobe have dropped support for windows 2000 but it can be done. See here : http://www.delbridge.org/post.cfm/how-to-install-coldfusion-9-on-windows-2000-iis-5 Oh I also have MySQL 5.1 and SQL Server express installed, plus Apache too for my SVN repos. I have IIS setup serving virtual hosts for all my dev sites and set each site up for the required CF version depending on the project/client's requirements. (I run DNS too on this server but you could do the same BY editing your hosts file). To keep things sane I tend to turn off the older CF's in the services control panel as it's getting really rare to need CF5 6 and BD is specific to a single client so I turn that off too. But even then right now that leaves CF7,8 and 9 running. As I said, this is for development so although they are all running they mostly get paged out to swap except for the CF driving the project I'm working on at that moment so memory is not big issue (I have around 100Mb free at the moment!) The only tweaking I've done is to set the number of simultaneous requests quite low (4) to cope with the crappy CPU. For ease of access to the the docs and admin I have a virtual host for each CF that has the home directory pointing at the wwwroot folder in the relevant CF directory. That way I can access all the admins easily eg. http://cf8/cfide/administrator/ So my advice is just to go for it. If you have an anywhere near new PC you shouldn't have any issues with memory or processing power. Install the oldest CF first and work your way up to CF9. And of course remember that this is just for dev purposes... nothing live or under any significant load. Regards Matt Casey ~| 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:337047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Saving files locally
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
CFFM Update
So I got around to updating CFFM to remove the flash-based uploadify plugin and I've gone with a straight jquery file upload implementation. It only seems to do multiple file uploads in Chrome (maybe Safari too) - not in Firefox or IE, which don't seem to support the ability to select multiple files on the file input... Anyone care to test it out for me? http://www.it.dev.duke.edu/public/cffm/cffm.cfm Rick ~| 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:337049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Saving files locally
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
Problem with getting cfhttp to do a post
I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
but then tells me I don't have p[ermission to use the system What's the exact error message? On Wed, Sep 15, 2010 at 8:59 AM, Rick Mason rhma...@gmail.com wrote: I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Saving files locally
I believe what you tried to do (an ajax call to a url that used cfcontent) is not possible. Stress - I believe. I think your document.location was the right way to do it. Please take with a grain of salt the size of my big head. On Wed, Sep 15, 2010 at 8:45 AM, Chad Baloga cbal...@gmail.com wrote: 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:337053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
If the variable CN contains a textual message saying you don't have permission, perhaps the remote url is expecting you to authenticate... ~| 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:337054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Saving files locally
On Wed, Sep 15, 2010 at 10:02 AM, Raymond Camden rcam...@gmail.com wrote: I believe what you tried to do (an ajax call to a url that used cfcontent) is not possible. Stress - I believe. I think your document.location was the right way to do it. I think Ray is correct. Typicaly what I've done is had the ajax call write a file then return a url to the file, then the result handler just does window.location.href=urltofile; if you want the file to be deleted after retrieval, then you just have to make urltofile be something like getfile.cfm?file=whatever.zip and have it do your cfcontent/cfheader stuff along with delete=yes on the cfcontent. Rick ~| 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:337055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV?
Use the JavaCSV library to read and writing CSV files with coldfusion. You'll NEVER have to worry about parsing CSV files again =) This java library handles all kinds of things like this. Dealing with CSV files in coldfusion can be a real pain in the ass once you start dealing with files where fields contain carriage returns or commas. I don't have any examples of reading a CSV but here's some code for writing one. http://www.opensourcecf.com/1/2008/06/JavaCSV-for-creating-large-CSV-and-other-delmiited-files-with-Coldfusion.cfm Rick ~| 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:337056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
John, The exact message is 'You are not authorized to access this page'. So somehow it sees a cfhttp post as different than a simple form post of the same information. Something doesn't look right and is triggering its error mechanism as it calls a pageaccessdenied.aspx. Rick On Wed, Sep 15, 2010 at 10:01 AM, John M Bliss bliss.j...@gmail.com wrote: but then tells me I don't have p[ermission to use the system What's the exact error message? On Wed, Sep 15, 2010 at 8:59 AM, Rick Mason rhma...@gmail.com wrote: I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
dbDiscover - Update available at RIAForge
Hi everyone! To those of you that have downloaded dbDiscover from RIAForge, I have made some updates over the past week. (To those that have not, check it out and let me know what you think!) The largest portion of the update is the ability to generate Entity Relationship Diagram images of the selected database in the web browser. It is just a first cut of the ERD capability, with all of the line math being done by hand. I plan to improve on it in the near future. All of the details are over at the RIAForge project site... http://dbdiscover.riaforge.org Thanks! Paul ~| 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:337058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
Rick, How is it that it doesn't ask to authenticate when I do a simple form post? What is different about a cfhttp post request masquerading as a form post that it triggering its error system? On Wed, Sep 15, 2010 at 10:04 AM, Rick Root rick.r...@gmail.com wrote: If the variable CN contains a textual message saying you don't have permission, perhaps the remote url is expecting you to authenticate... ~| 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:337059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
Then I agree with Mr. Root: perhaps the remote url is expecting you to authenticate. And/or, get with people in charge of payment service, let them know what you're sending and what's happening, and see what they say... On Wed, Sep 15, 2010 at 9:16 AM, Rick Mason rhma...@gmail.com wrote: John, The exact message is 'You are not authorized to access this page'. So somehow it sees a cfhttp post as different than a simple form post of the same information. Something doesn't look right and is triggering its error mechanism as it calls a pageaccessdenied.aspx. Rick On Wed, Sep 15, 2010 at 10:01 AM, John M Bliss bliss.j...@gmail.com wrote: but then tells me I don't have p[ermission to use the system What's the exact error message? On Wed, Sep 15, 2010 at 8:59 AM, Rick Mason rhma...@gmail.com wrote: I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
Maybe it can somehow tell that CFHTTP is not a real browser even though you've put in a user agent... maybe the lack of a refererer? On Wed, Sep 15, 2010 at 10:18 AM, Rick Mason rhma...@gmail.com wrote: Rick, How is it that it doesn't ask to authenticate when I do a simple form post? What is different about a cfhttp post request masquerading as a form post that it triggering its error system? On Wed, Sep 15, 2010 at 10:04 AM, Rick Root rick.r...@gmail.com wrote: If the variable CN contains a textual message saying you don't have permission, perhaps the remote url is expecting you to authenticate... ~| 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:337061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
I found this earlier post on cfhttp only supporting basic authentication, this was in 2002. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:10601 Do either of you know whether this is sitll the case with CF-8? Does CF-9 fix this problem? Someone at the CFUG last night said CF-9 fixed problems he was having with cfhttp, but I can't find in the docs that the tag was even updated. Rick On Wed, Sep 15, 2010 at 10:20 AM, John M Bliss bliss.j...@gmail.com wrote: Then I agree with Mr. Root: perhaps the remote url is expecting you to authenticate. And/or, get with people in charge of payment service, let them know what you're sending and what's happening, and see what they say... On Wed, Sep 15, 2010 at 9:16 AM, Rick Mason rhma...@gmail.com wrote: John, The exact message is 'You are not authorized to access this page'. So somehow it sees a cfhttp post as different than a simple form post of the same information. Something doesn't look right and is triggering its error mechanism as it calls a pageaccessdenied.aspx. Rick On Wed, Sep 15, 2010 at 10:01 AM, John M Bliss bliss.j...@gmail.com wrote: but then tells me I don't have p[ermission to use the system What's the exact error message? On Wed, Sep 15, 2010 at 8:59 AM, Rick Mason rhma...@gmail.com wrote: I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
On Wed, Sep 15, 2010 at 10:27 AM, Rick Mason rhma...@gmail.com wrote: I found this earlier post on cfhttp only supporting basic authentication, this was in 2002. As opposed to what? Windows authentication? I doubt it's been fixed. Remember, cfhttp is not you, it's coldfusion .. so if you had to authenticate via windows authentication to do that as a simple form post, then you won't be able to do it with cfhttp Rick ~| 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:337063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV?
BTW in my own interest, having never actually used the CsvReader class (only the CsvWriter class), I started to attempt to write some sample code... Unfortunately, this is as far as I got :) cfset filename = test.csv cfset fileInput = createObject(java,com.csvreader.CsvReader) cfset fileInput.init(filename) cfset fileInput.close() The third line errors with the following error: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Which I don't get because the CsvReader class is neither an abstract class nor an interface. Oh well, I tried =) Rick ~| 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:337064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
I did a little more research and both CF-8 and CF-9 do not provide support for Integrated Windows, NTLM, or Kerebos authentication - only for basic authentication. I am going to check back with the service to confirm which authentication (if any) that they are using. Still curious how a simple form post is able to bypass this security check? Rick On Wed, Sep 15, 2010 at 10:27 AM, Rick Mason rhma...@gmail.com wrote: I found this earlier post on cfhttp only supporting basic authentication, this was in 2002. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:10601 Do either of you know whether this is sitll the case with CF-8? Does CF-9 fix this problem? Someone at the CFUG last night said CF-9 fixed problems he was having with cfhttp, but I can't find in the docs that the tag was even updated. Rick On Wed, Sep 15, 2010 at 10:20 AM, John M Bliss bliss.j...@gmail.comwrote: Then I agree with Mr. Root: perhaps the remote url is expecting you to authenticate. And/or, get with people in charge of payment service, let them know what you're sending and what's happening, and see what they say... On Wed, Sep 15, 2010 at 9:16 AM, Rick Mason rhma...@gmail.com wrote: John, The exact message is 'You are not authorized to access this page'. So somehow it sees a cfhttp post as different than a simple form post of the same information. Something doesn't look right and is triggering its error mechanism as it calls a pageaccessdenied.aspx. Rick On Wed, Sep 15, 2010 at 10:01 AM, John M Bliss bliss.j...@gmail.com wrote: but then tells me I don't have p[ermission to use the system What's the exact error message? On Wed, Sep 15, 2010 at 8:59 AM, Rick Mason rhma...@gmail.com wrote: I need to interact with an asp.Net based payment service. I am able to do a simple form post to the https:// URL with no problems. However I can't make it work with cfhttp and I've spent days trying. Even after importing their SSL cert into CF, it connects (gives me a 200) but then tells me I don't have p[ermission to use the system. Here's a short version of the code that I am using: cfhttp url =https://myurl.com method = POST Port=443 charset=utf-8 UserAgent=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0) multipart=No timeout = 1 result=CN cfhttpparam type = formfield encoded = no name = NAME value = Rick Mason cfhttpparam type = formfield encoded = no name = ADDR value = 123 Main cfhttpparam type = formfield encoded = no name = CITY value = East Lansing cfhttpparam type = formfield encoded = no name = STATE value = MI cfhttpparam type = formfield encoded = no name = ZIP value = 48823 cfhttpparam type = formfield encoded = no name = COUNTRY value = USA cfhttpparam type = formfield encoded = no name = EMAIL value = rhma...@gmail.com cfhttpparam type = formfield encoded = no name = ItemCode1 value = Merchandise cfhttpparam type = formfield encoded = no name = ItemCount1 value = 1 cfhttpparam type = formfield encoded = no name = Amount1 value = 1 cfhttpparam type = formfield encoded = no name = refType1 value = sku cfhttpparam type = formfield encoded = no name = refval1 value = memento /cfhttp cfdump var=#CN# Alternatively I tried the cfx_http5 tag and it gave me a Windows 12006 error which is defined as the URL scheme could not be recognized or supported. I'm pretty certain the problem is a networking one with the Windows 2003 server on our end (and the services techs agree) but I've run out of things to try. Anyone have an answer? Rick ~| 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:337065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
On Wed, Sep 15, 2010 at 10:34 AM, Rick Mason rhma...@gmail.com wrote: authentication (if any) that they are using. Still curious how a simple form post is able to bypass this security check? if it's windows integrated, you'd never get prompted to authenticate... well, if your browser is IE I guess... Ric ~| 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:337066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV?
If I recall correctly, I experienced problems when using just a file name as well. But was successful by using constructor using the filename, delimeter, and charset. I hope you can see what changes you're need from the code below which works within the context of my app but doesn't work on its own. cffunction name=getReader output=false access=public returntype=any hint=Returns the reader object cfargument name=fileName required=true type=string hint=The full path to the filename cfargument name=delimiter required=true type=string hint=The delimiter cfargument name=charset required=false type=string default=Cp1252 hint=The text encoding. Default is Cp1252. The same default for coldfusion. !--- Create reader --- cfset var csvreader = controller.getPlugin(JavaLoader).create(com.csvreader.CsvReader) !--- Create a charset object to pass to the function --- cfset var charsetObject = createObject(java,java.nio.charset.Charset).forName(arguments.charset) !--- Readobject --- cfset var readObject = csvreader.init(arguments.fileName,arguments.delimiter,charsetObject) cfreturn readObject /cffunction - Gabriel On Wed, Sep 15, 2010 at 10:33 AM, Rick Root rick.r...@gmail.com wrote: BTW in my own interest, having never actually used the CsvReader class (only the CsvWriter class), I started to attempt to write some sample code... Unfortunately, this is as far as I got :) cfset filename = test.csv cfset fileInput = createObject(java,com.csvreader.CsvReader) cfset fileInput.init(filename) cfset fileInput.close() The third line errors with the following error: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Which I don't get because the CsvReader class is neither an abstract class nor an interface. Oh well, I tried =) Rick ~| 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:337067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
Rick, Well the problem isn't authentication. I got off the phone with the payment service techs and the service doesn't use authentication by default unless we request it, which we did not. So what else might it be? Rick On Wed, Sep 15, 2010 at 10:31 AM, Rick Root rick.r...@gmail.com wrote: On Wed, Sep 15, 2010 at 10:27 AM, Rick Mason rhma...@gmail.com wrote: I found this earlier post on cfhttp only supporting basic authentication, this was in 2002. As opposed to what? Windows authentication? I doubt it's been fixed. Remember, cfhttp is not you, it's coldfusion .. so if you had to authenticate via windows authentication to do that as a simple form post, then you won't be able to do it with cfhttp Rick ~| 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:337068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with getting cfhttp to do a post
Payment service is seeing your request and some ASP.NET code that *they* wrote is redirecting you to pageaccessdenied.aspx and giving you the message you're seeing. At the very least, they should be able to tell you under what circumstances that happens. At best, they should be able to tell you what's wrong with your request or, better yet, check their logs to tell you exactly what's happening. On Wed, Sep 15, 2010 at 9:55 AM, Rick Mason rhma...@gmail.com wrote: Rick, Well the problem isn't authentication. I got off the phone with the payment service techs and the service doesn't use authentication by default unless we request it, which we did not. So what else might it be? Rick On Wed, Sep 15, 2010 at 10:31 AM, Rick Root rick.r...@gmail.com wrote: On Wed, Sep 15, 2010 at 10:27 AM, Rick Mason rhma...@gmail.com wrote: I found this earlier post on cfhttp only supporting basic authentication, this was in 2002. As opposed to what? Windows authentication? I doubt it's been fixed. Remember, cfhttp is not you, it's coldfusion .. so if you had to authenticate via windows authentication to do that as a simple form post, then you won't be able to do it with cfhttp Rick ~| 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:337069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
The answer is it depends, Frankly, according to your results, I would rather answer the difference is marginal. ~| 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:337070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
Rex, wonderful results. Thanks. On Tue, Sep 14, 2010 at 9:48 PM, rex li...@pgrworld.com wrote: Over 100,000 queries this is what I got (in ms): LIKELEFT MyISAM 16,215.60 16,069.00 InnoDB 16,168.60 15,987.80 MSSQL Server 28,268.60 26,775.20 Won's Test 1,184.401,168.80 INDEXED MyISAM 16,256.20 16,303.20 INDEXED InnoDB 16,112.40 16,119.00 INDEXED MSSQL Server 24,509.40 25,337.40 INDEXED Won's Test 1,156.601,159.00 LEFT() wins for unindexed columns, LIKE wins for indexed columns. The answer is it depends, but eventually the answer becomes it won't matter. These days, the sql engine/optimizer is smart enough to decide how to approach the problem. It depends on certain things: how wide your column is if the column is indexed how wide the search string is how many records returned how many records being searched datatype of the column etc. etc. Then eventually it won't matter, since the results would only be nanoseconds apart (if you are comparing exactly the same columns). This is over 100K queries and they're only ms apart. I'd love to see other people's test results though! Won Lee wrote: I ran a quick test CREATE TABLE HoF ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, LastName VARCHAR(100) ) ENGINE = InnoDB; ~| 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:337071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: CFImage and imageutils.cfc
BTW...sorry i am not threading this properly as I download my email on my personal computer, and read ti there normally, but this is being sent via a web interface from work.. Where I am at: I have it so that the banner is getting the proper width...now to figure out the vertical centering issue... cfcomponent output=false hint=Image utility functions that abstract out complex ColdFusion image manipulation processes. cffunction name=img_create_banner access=public output=true returntype=Any hint=Creates banner grapic with custom text cfargument name = text type = string required=true cfargument name = fontname type = string required=true cfargument name = style type = string required=true hint=Must be Plain, Bold, Italics, or Bolditalics cfargument name = size type = string required=true cfargument name = color type = string required=true hint=hex value with put pound sign cfargument name = bgcolor type = string required=true hint=hex value with put pound sign cfargument name = path type = string required=true cfargument name = name type = string required=true cfargument name = xOffsetVal type = anyrequired=true cfargument name = yOffsetVal type = anyrequired=true cfscript Font = CreateObject(java, java.awt.Font); variables.color=##arguments.color; variables.bgcolor=##arguments.bgcolor; variables.style=arguments.style; variables.fontname=#trim(arguments.fontname)#; variables.text={x=10, y=30, string=arguments.text}; variables.text.prop={font = variables.fontname, Size=arguments.size, style=variables.style, javaStyle= BitOr(Font.BOLD, Font.ITALIC), txtColor=variables.color, bgColor=variables.bgcolor}; //variables.text = { x = 10, y = 30, string = arguments.text }; // variables.text.prop = { font_name=LunaITC TT, style=arguments.style, javaStyle= BitOr(Font.BOLD, Font.ITALIC), size=arguments.size, txtColor=variables.color, bgcolor=variables.bgColor}; //writedump(variables.text.prop); param name=arguments.xOffsetVal default=0; param name=arguments.yOffsetVal default=0; variables.offsetVal={x=arguments.xOffsetVal, y=arguments.yOffsetVal}; variables.imageOffset={x=20, y=10}; //strObject=createObject(java,java.lang.String); //strTemp=#UCase(arguments.text)#; //isAllCaps=compare(strTemp,arguments.text); // initialize the text properties // create a new image and draw the text img = ImageNew(, 10, 30, rgb, arguments.bgcolor ); // get the underlying graphic of the image graphics = ImageGetBufferedImage( img ).getGraphics(); /cfscript !--- brcfdump var=#variables.text#br --- !--- Check for a defined style. --- cfswitch expression=#variables.text.prop.style# cfcase value=Bold cfset variables.text.prop.javastyle = Font.BOLD /cfcase cfcase value=Italic cfset variables.text.prop.javastyle = Font.ITALIC /cfcase cfcase value=BoldItalic cfset variables.text.prop.javastyle = BitOR(Font.BOLD,Font.ITALIC) /cfcase !--- Otherwise, just use the default PLAIN style --- cfdefaultcase cfset variables.text.prop.javastyle = Font.PLAIN /cfdefaultcase /cfswitch cfscript // recreate the font used to draw the text CurrentFont = Font.init( javacast(string, variables.text.prop.font), javacast(int, variables.text.prop.javaStyle), javacast(int, variables.text.prop.size) ); // get text measurements using font metrics fontMetrics = graphics.getFontMetrics( CurrentFont ); fontBounds = fontMetrics.getStringBounds( javacast(string, variables.text.string), graphics ); img = ImageNew(, fontBounds.getWidth()+20, fontBounds.getHeight()+10, rgb, variables.text.prop.bgcolor); graphics = ImageGetBufferedImage( img ).getGraphics(); //graphics.setColor(variables.text.prop.bgcolor); ImageSetDrawingColor( img, variables.text.prop.txtColor ); variables.OffsetVal.y= javacast(int, variables.text.y)/2 + javacast(int,(fontBounds.getHeight())/2)+variables.OffsetVal.y ; variables.offsetVal.x=variables.text.x+variables.OffsetVal.x; ImageDrawText( img, variables.text.string,variables.OffsetVal.x,variables.OffsetVal.y , variables.text.prop ); // draw a rectangle indicatating the font bounds //graphics.setColor(variables.text.prop.bgcolor); //ImageSetDrawingColor( img, variables.text.prop.bgColor );
Re: Removing new line from CSV?
Unfortunately, using your code (except using createObject instead of javaloader, as I have the library in CF's classpath), I get the same error. On Wed, Sep 15, 2010 at 10:52 AM, Dorioo dor...@gmail.com wrote: If I recall correctly, I experienced problems when using just a file name as well. But was successful by using constructor using the filename, delimeter, and charset. I hope you can see what changes you're need from the code below which works within the context of my app but doesn't work on its own. cffunction name=getReader output=false access=public returntype=any hint=Returns the reader object cfargument name=fileName required=true type=string hint=The full path to the filename cfargument name=delimiter required=true type=string hint=The delimiter cfargument name=charset required=false type=string default=Cp1252 hint=The text encoding. Default is Cp1252. The same default for coldfusion. !--- Create reader --- cfset var csvreader = controller.getPlugin(JavaLoader).create(com.csvreader.CsvReader) !--- Create a charset object to pass to the function --- cfset var charsetObject = createObject(java,java.nio.charset.Charset).forName(arguments.charset) !--- Readobject --- cfset var readObject = csvreader.init(arguments.fileName,arguments.delimiter,charsetObject) cfreturn readObject /cffunction - Gabriel On Wed, Sep 15, 2010 at 10:33 AM, Rick Root rick.r...@gmail.com wrote: BTW in my own interest, having never actually used the CsvReader class (only the CsvWriter class), I started to attempt to write some sample code... Unfortunately, this is as far as I got :) cfset filename = test.csv cfset fileInput = createObject(java,com.csvreader.CsvReader) cfset fileInput.init(filename) cfset fileInput.close() The third line errors with the following error: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Which I don't get because the CsvReader class is neither an abstract class nor an interface. Oh well, I tried =) Rick ~| 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:337073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re:CFImage and imageutils.cfc
BTW...That does work with all of the fonts i tested (45 of them) in both all caps and mixed case... Fonts (the 0 or 1 is indicating bold (0) or Bolditalics(1)): 1 AlgerianBasD 0 2 Arial Narrow 0 3 Atlantic Inline-Normal 0 4 Avant Garde Book BT 0 5 Baker Signet BT 0 6 Bank Gothic Medium BT 0 7 Belwe Light BT 0 8 BibleScrT 0 9 Bodoni Book Italic BT 1 10 Bruce Old Style BT 1 11 Bruce Old Style BT 0 12 Calligraphic 421 BT 0 13 Carleton 0 14 Cataneo BT 0 15 Charlesworth 0 16 Cloister Black BT 0 17 Copperplate Gothic BT 0 18 Copperplate Gothic Condensed BT 0 19 Dutch 801 Italic Headline BT 0 20 English 111 Presto BT 0 21 English 111 Vivace BT 0 22 Engravers' Old English Bold BT 0 23 Engravers' Old English BT 0 24 Friz Quadrata BT 0 25 Geometric 231 Light BT 0 26 Georgia Italic 1 27 Latin Extra Condensed BT 0 28 LunaITC TT 0 29 Lydian BT 0 30 MariageD 0 31 Mona Lisa SolidITC-Normal 0 32 Nuptial BT 0 33 Palamino Regular 0 34 Parisian BT 0 35 PenguinLight 0 36 PhyllisD 0 37 PlazaDReg 0 38 ProseAntique 0 39 Times New Roman Italic 1 40 Trebuchet MS 0 41 Verve 0 42 VivaldiD 0 43 Wedding Text BT 0 44 Zapf Chancery Medium Italic BT 0 45 Zapf Humanist 601 BT 0 ~| 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:337074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is there a way to force lock release on Access database? (CF9)
I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP.I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enterprise). IN CF5, which is the last time i used Access with ColdFusion, it was a simple case of doing an invalid query but that doesnt work in MX days. There was a non-documented function once as well ... CFusion_DBConnections_Flush( ) ... but that's not valid in CF9. Has anyone found a way to break that connection programmatically in CF9? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:337075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re:CFImage and imageutils.cfc
To center the text vertically, you could try something like this. Doing the drawing with CF makes it a little convoluted. But it should work okay BTW: I was not sure what you meant by offset. As that would imply something other than centered .. ? cfscript // initialize the text properties Font = CreateObject(java, java.awt.Font); prop = {string = Sheehan Funeral Home Sheehan Funeral Home Sheehan Funeral Home Sheehan Funeral Home, font=Georgia, style=bolditalic, javaStyle=BitOr(FONT.BOLD, Font.ITALIC), size=24 }; // create sample image. used for measuring text only img = ImageNew(, 10, 10, rgb, lightgray); graphics = ImageGetBufferedImage( img ).getGraphics(); // create font used to draw the text currentFont = Font.init( javacast(string, prop.font), javacast(int, prop.javaStyle), javacast(int, prop.size) ); // get text measurements using font metrics graphics.setFont( currentFont ); fontMetrics = graphics.getFontMetrics( ); //fontMetrics = graphics.getFontMetrics( currentFont ); fontBounds = fontMetrics.getStringBounds( javacast(string, prop.string), graphics ); // save dimensions dimensions = { width = fontBounds.getWidth(), height = fontBounds.getHeight(), leading = fontMetrics.getLeading(), ascent = fontMetrics.getAscent(), descent = fontMetrics.getDescent() }; // prepare to draw text on new image img = ImageNew(, dimensions.Width+20, dimensions.height+10, rgb, lightgray); ImageSetDrawingColor( img, black ); // center text horizontally dimensions.xOffset = (img.width - dimensions.width) / 2; // center text vertically (This includes any leading value!) dimensions.yOffset = (img.height - dimensions.height) / 2 + dimensions.ascent; ImageDrawText( img, prop.string, dimensions.xOffset, dimensions.yOffset , prop ); // draw a rectangle indicatating the font bounds dimensions.boxXPos = (img.width - dimensions.width) / 2; dimensions.boxYPos = (img.height - dimensions.height) / 2; Color = createObject(java, java.awt.Color); // must retrieve the underlying graphics object from the new image first graphics = ImageGetBufferedImage( img ).getGraphics(); graphics.setColor(Color.RED); graphics.drawRect( javacast(int, dimensions.boxXPos), javacast(int, dimensions.boxYPos), dimensions.width, dimensions.height ); // draw a line indicating baseline (approximate) dimensions.baseLineY = ((img.height - dimensions.height) / 2) + dimensions.ascent; graphics.setColor(Color.ORANGE); graphics.drawLine( javacast(int, 0), javacast(int, dimensions.baseLineY), img.width, javacast(int, dimensions.baseLineY) ); // draw a line indicating vertical center (approximate) dimensions.verticalCenter = img.height / 2; graphics.setColor(Color.MAGENTA); graphics.drawLine( javacast(int, 0), javacast(int, dimensions.verticalCenter), img.width, javacast(int, dimensions.verticalCenter) ); graphics.dispose(); /cfscript cfimage action=writeToBrowser source=#img# cfdump var=#dimensions# label=FontMetrics cfscript // get the text measurements using text layout graphics = ImageGetBufferedImage( img ).getGraphics(); graphics.setFont( currentFont ); context = graphics.getFontRenderContext(); TextLayout = createObject(java, java.awt.font.TextLayout); layout = TextLayout.init( prop.string, currentFont, context ); layoutBounds = layout.getBounds(); // save dimensions. some fonts may extend above the ascent dimensions = { width = layoutBounds.getWidth(), height = layoutBounds.getHeight(), leading = layout.getLeading(), ascent = layout.getAscent(), descent = layout.getDescent() }; dimensions.boxXPos = (img.width - dimensions.width) / 2; dimensions.boxYPos = (img.height - ceiling(dimensions.height))
re:CFImage and imageutils.cfc
BTW: Please ignore anything after the cfabort. That non-functioning section was posted in error. ~| 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:337077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
unchecking the maintain database connections in the DSN may work. If not then try the release all client connections option. If still no go, just delete the DSN. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:337078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
I think I have a slight obsessive streak... I started on CF3.1... so it'd be nice to have the full set. ;oD ~| 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:337080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
This has to happen automatically because the process is initiated by an event when a manager logs on and maintains a record in the product file. When that happens, it causes the system to generate a new database for the users around the country to download when they next log on.So i need to connect and disconnect from the access database programmatically. Are you meaning when I set the DSN up in the first place, i uncheck the Maintain Database Connections checkbox and that should do the trick for future connects/disconnects?? Our control panel doesnt set access DSNs up that way but i can get my sysadmin to set the DSNs up manually through the administration interface instead though. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Sep 16, 2010 at 2:31 AM, Rick Root rick.r...@gmail.com wrote: On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is there a way to force lock release on Access database? (CF9)
We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]
On 9/15/2010 9:33 PM, Rick Root wrote: The third line errors with the following error: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. out of curiosity i gave that lib a spin, very nice. your error looks like a poorly worded file not found message. try full path to CSV file. ~| 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:337083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
Yes, that's what i used to do too, Will. But that was in the CF5 days. With MX that stopped doing the trick. Cheers Mike Kear On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com wrote: We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is there a way to force lock release on Access database? (CF9)
Sorry - like I said, it's been a while. -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 15 September 2010 18:21 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) Yes, that's what i used to do too, Will. But that was in the CF5 days. With MX that stopped doing the trick. Cheers Mike Kear On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com wrote: We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re:CFImage and imageutils.cfc
the x and y vars are coordinates...I have to offset those coordinates to get the center position. Eric ~| 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:337086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
It's ok. It's been a while for me too. I havent touched Access in any way for any reason since way back in the mid 90s. Now i have to use it because of a legacy of LOTS of point of sale terminals that all use it for importing updates into their systems. My hope is that we'll get rid of this application pretty soon. But in the mean time I'm stuck with it. Cheers Mike Kear On Thu, Sep 16, 2010 at 3:30 AM, Will Swain w...@hothorse.com wrote: Sorry - like I said, it's been a while. -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 15 September 2010 18:21 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) Yes, that's what i used to do too, Will. But that was in the CF5 days. With MX that stopped doing the trick. Cheers Mike Kear On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com wrote: We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
Mike, You could use the ColdFusion Admin API to create the datasource on the fly, do whatever you need to do and then kill the datasource programatically. I have a code sample but it'll be another week or so before I can get to it. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.html On Wed, Sep 15, 2010 at 11:58 AM, Mike Kear afpwebwo...@gmail.com wrote: I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP. I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enterprise). IN CF5, which is the last time i used Access with ColdFusion, it was a simple case of doing an invalid query but that doesnt work in MX days. There was a non-documented function once as well ... CFusion_DBConnections_Flush( ) ... but that's not valid in CF9. Has anyone found a way to break that connection programmatically in CF9? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:337088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re:CFImage and imageutils.cfc
This may not be the perfect solution, but it works... I multiplied the Y Offset value by .95 and it centers close enough (or close enough for government work as they say hehehe) across the font sizes we use (16-30)...YAY! Thank for your help Eric cfcomponent output=false hint=Image utility functions that abstract out complex ColdFusion image manipulation processes. cffunction name=img_create_banner access=public output=true returntype=Any hint=Creates banner grapic with custom text cfargument name = text type = string required=true cfargument name = fontname type = string required=true cfargument name = style type = string required=true hint=Must be Plain, Bold, Italics, or Bolditalics cfargument name = size type = string required=true hint=Font size in pixels cfargument name = color type = string required=true hint=hex value with put pound sign cfargument name = bgcolor type = string required=true hint=hex value with put pound sign cfargument name = path type = string required=true hint=local path to where image is to be saved cfargument name = name type = string required=true hint=image name with extention cfscript Font = CreateObject(java, java.awt.Font); variables.color=##arguments.color; variables.bgcolor=##arguments.bgcolor; variables.style=arguments.style; variables.fontname=#trim(arguments.fontname)#; variables.text={x=10, y=30, string=arguments.text}; variables.text.prop={font = variables.fontname, Size=arguments.size, style=variables.style, javaStyle= BitOr(Font.BOLD, Font.ITALIC), txtColor=variables.color, bgColor=variables.bgcolor}; variables.imageOffset={x=20, y=10}; // create a new image and draw the text img = ImageNew(, 10, 30, rgb, arguments.bgcolor ); // get the underlying graphic of the image graphics = ImageGetBufferedImage( img ).getGraphics(); /cfscript !--- Check for a defined style. --- cfswitch expression=#variables.text.prop.style# cfcase value=Bold cfset variables.text.prop.javastyle = Font.BOLD /cfcase cfcase value=Italic cfset variables.text.prop.javastyle = Font.ITALIC /cfcase cfcase value=BoldItalic cfset variables.text.prop.javastyle = BitOR(Font.BOLD,Font.ITALIC) /cfcase !--- Otherwise, just use the default PLAIN style --- cfdefaultcase cfset variables.text.prop.javastyle = Font.PLAIN /cfdefaultcase /cfswitch cfscript // recreate the font used to draw the text CurrentFont = Font.init( javacast(string, variables.text.prop.font), javacast(int, variables.text.prop.javaStyle), javacast(int, variables.text.prop.size) ); // get text measurements using font metrics fontMetrics = graphics.getFontMetrics( CurrentFont ); fontBounds = fontMetrics.getStringBounds( javacast(string, variables.text.string), graphics ); context = graphics.getFontRenderContext(); img = ImageNew(, fontBounds.getWidth()+20, fontBounds.getHeight()+10, rgb, variables.text.prop.bgcolor); graphics = ImageGetBufferedImage( img ).getGraphics(); ImageSetDrawingColor( img, variables.text.prop.txtColor ); variables.OffsetVal.y= (javacast(int, variables.text.y)/2 + javacast(int,(fontBounds.getHeight())/2))*.95; variables.offsetVal.x=variables.text.x; ImageDrawText( img, variables.text.string,variables.OffsetVal.x,variables.OffsetVal.y , variables.text.prop ); //dimensions.xoffset=variables.OffsetVal.x; //dimensions.yoffset=variables.OffsetVal.y; //dimensions.type = FontMetrics; //dimensions.width = fontBounds.getWidth(); //dimensions.height = fontBounds.getHeight(); //dimensions.height_int = javacast(int,fontBounds.getHeight()); //dimensions.leading = fontMetrics.getLeading(); //dimensions.ascent = fontMetrics.getAscent(); //dimensions.descent = fontMetrics.getDescent(); graphics.dispose(); /cfscript !--- cfdump var=#dimensions# --- !--- cfimage action=writeToBrowser source=#img# --- cfimage action=write source=#img# destination=#path#/#name# overwrite=true /cffunction /cfcomponent ~| 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:337089
RE: CFFM Update
I was able to upload two image files at the same time (20100307_frontYard.jpg and 20100307_frontYard02.jpg) on firefox 3.6.9. Very slick! (P.S. Those are the before shots - we're re-landscaping and the front yard doesn't look like hot fried crap anymore. LOL) Jen Perkins McVicker Adobe Certified ColdFusion Developer Phone/Fax: (925) 757-1839 Email: jen.mcvic...@gmail.com Linked In: http://www.linkedin.com/in/jmcvicker -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Wednesday, September 15, 2010 6:49 AM To: cf-talk Subject: CFFM Update So I got around to updating CFFM to remove the flash-based uploadify plugin and I've gone with a straight jquery file upload implementation. It only seems to do multiple file uploads in Chrome (maybe Safari too) - not in Firefox or IE, which don't seem to support the ability to select multiple files on the file input... Anyone care to test it out for me? http://www.it.dev.duke.edu/public/cffm/cffm.cfm Rick ~| 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:337090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
you can give it go is all I can suggest. It works sometimes and not others. If NOT maintaining the database conenctions doesn;t work, then you will need to programatically deleted and re-create the DSN instead. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| 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:337091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFM Update
On Wed, Sep 15, 2010 at 2:37 PM, Jen Perkins McVicker snarkmeis...@gmail.com wrote: I was able to upload two image files at the same time (20100307_frontYard.jpg and 20100307_frontYard02.jpg) on firefox 3.6.9. Very slick! Thanks.. that's cool, I'm still running Firefox 3.5, and it only lets me select one at a time. Also cool that you got it to work while I was working on it :) I removed all the buttons and added context menus for the file actions like delete, rename, etc. Rick ~| 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:337092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]
On Wed, Sep 15, 2010 at 1:01 PM, Paul Hastings p...@sustainablegis.com wrote: your error looks like a poorly worded file not found message. try full path to CSV file. Yeah, that was it. And yes, VERY poorly worded =) Rick ~| 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:337093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
seriously, u still have sites on CF versions that old in production ? On Wed, Sep 15, 2010 at 5:31 PM, Matt Catmacey m...@catmacey.com wrote: I think I have a slight obsessive streak... I started on CF3.1... so it'd be nice to have the full set. ;oD ~| 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:337094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]
Okay, I wrote some sample code and tested it for using JavaCSV to read a CSV file. http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm My test file didn't have headers so this just generically dumps the csv into a very generic query. Rick ~| 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:337095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: An instance of CF 7, CF 8, CF 9 on single pc
Well in all honesty no certainly not for CF5, not for many years. For CF6.1 there's just a single client. CF7 is still very common out there in the wild. I have a couple of clients with VPS's running 7 for quite large sites that they don't want to upgrade due to the unknown factors. But on a daily basis it's really just CF8 and BD7. I only have one project with a CF9 requirement... Don't talk to me about the new local scope... ~| 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:337096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGRID sort order
I've got a cfgrid that I put together using this tutorial: http://www.garyrgilbert.com/tutorials/coldfusion/intermediate/cfgrid.cfm It is working fine except there is an issue with the sorting of one column, the column is called DISPATCHNUM, but the data is not all numeric. The datatype is nvarchar and some entries contain letters. The issue is that most of the entries are sorting fine, but there are quite a few of them that are out of order and I can't figure out why. For instance I'll see 14317, 14316, and 14313, but 14314 will be 20-30 pages back. I've checked to see if there are spaces or anything entered around the number but it is nothing like that. I don't know if I have missed something obvious or there is a better way to troubleshoot this out there. Thanks! I have a cfc called joborder.cfc with the following code: cffunction name=getJoborders access=remote cfargument name=page required=yes cfargument name=pageSize required=yes cfargument name=gridsortcolumn required=yes cfargument name=gridsortdirection required=yes cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = dispatchnum / cfset arguments.gridsortdirection = desc / /cfif cfquery datasource=companysql name=joborders SELECT DISPATCHNUM, SUBMITDATE, WORKCOMPLETE + ' ' as workcomplete, EDITDATE, JOBID, ORDERNUM, JOBNAME, CONTACTFIRST, CONTACTLAST, SERVICEENGINEER FROM JOBORDERS cfif gridsortcolumn neq '' order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfif /cfquery cfreturn queryconvertforgrid(joborders,page,pagesize)/ /cffunction On the cfm page this is the cfgrid code: cfform cfgrid format=html name=adlist striperows=yes fontsize=12 pagesize=25 selectmode=row bind=cfc:joborder.getJoborders({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}) cfgridcolumn name=dispatchnum header=Dispatch Num href=fieldticket.cfml hrefkey=jobid width=100/ cfgridcolumn name=submitdate header=Submit Date width=90 cfgridcolumn name=jobname header=Job Name width=200 cfgridcolumn name=contactlast header=Contact Last Name width=150 cfgridcolumn name=serviceengineer header=Service Engineer width=175 cfgridcolumn name=workcomplete header=Completed width=100 cfgridcolumn name=jobid header=Edit href=fieldticketedit.cfml hrefkey=jobid width=40 / cfgridcolumn name=editdate header=Edit Date width=80/ cfgridcolumn name=jobid header=DELETE hrefkey=jobid width=60 href=delete.cfml?jobid=url.jobid /cfgrid /cfform -- ExchangeDefender Message Security: Click below to verify authenticity http://www.exchangedefender.com/verify.asp?id=o8FK66RW024954from=sa...@tdai.net ~| 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:337097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Really odd problem - cpu utilization at idle
Hi list, I have an issue where after sitting idle for a while JRUN spikes to 100% of it's cpu usage and just sits there. I ran it and did some stack traces and it wasn't even serving any web pages. Process monitor yielded that Jrun.exe's only IO activity was rescanning some XML files in the ColdFusion install folder. We pulled the server from production and this issue recurs if its just sitting there by itself. Any suggestions on how to figure out what JRUN is doing ?? I've never had this problem before. Thanks Dan ~| 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:337098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Really odd problem - cpu utilization at idle
have you tried using the built in server monitor to diagnose the problem ? On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman dan.baugh...@gmail.comwrote: Hi list, I have an issue where after sitting idle for a while JRUN spikes to 100% of it's cpu usage and just sits there. I ran it and did some stack traces and it wasn't even serving any web pages. Process monitor yielded that Jrun.exe's only IO activity was rescanning some XML files in the ColdFusion install folder. We pulled the server from production and this issue recurs if its just sitting there by itself.tor Any suggestions on how to figure out what JRUN is doing ?? I've never had this problem before. Thanks Dan ~| 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:337099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Really odd problem - cpu utilization at idle
Dan, What's the setting for client vars? -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, September 15, 2010 6:31 PM To: cf-talk Subject: Re: Really odd problem - cpu utilization at idle have you tried using the built in server monitor to diagnose the problem ? On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman dan.baugh...@gmail.comwrote: Hi list, I have an issue where after sitting idle for a while JRUN spikes to 100% of it's cpu usage and just sits there. I ran it and did some stack traces and it wasn't even serving any web pages. Process monitor yielded that Jrun.exe's only IO activity was rescanning some XML files in the ColdFusion install folder. We pulled the server from production and this issue recurs if its just sitting there by itself.tor Any suggestions on how to figure out what JRUN is doing ?? I've never had this problem before. Thanks Dan ~| 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:337100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Really odd problem - cpu utilization at idle
Russ: I have ColdFusion 9 standard, when I click on server monitor in the cfadmin it says not available for this version Mark: It is set to registry, but this is one site that does not use any CLIENT. variables it uses all SESSION. The purge period is set to 1 hour and 7 minutes. On Wed, Sep 15, 2010 at 5:36 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Dan, What's the setting for client vars? -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, September 15, 2010 6:31 PM To: cf-talk Subject: Re: Really odd problem - cpu utilization at idle have you tried using the built in server monitor to diagnose the problem ? On Thu, Sep 16, 2010 at 12:27 AM, Dan Baughman dan.baugh...@gmail.comwrote: Hi list, I have an issue where after sitting idle for a while JRUN spikes to 100% of it's cpu usage and just sits there. I ran it and did some stack traces and it wasn't even serving any web pages. Process monitor yielded that Jrun.exe's only IO activity was rescanning some XML files in the ColdFusion install folder. We pulled the server from production and this issue recurs if its just sitting there by itself.tor Any suggestions on how to figure out what JRUN is doing ?? I've never had this problem before. Thanks Dan ~| 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:337101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Debug Output
Hi Michael, It was just an issue of which IP address CF Admin was seeing. I was working on a local test server with a local IP so I added the local IP of my work station to CF Admin. But as I was accesing the site in development on a url with the external IP, I needed to add that to the CF Admin. Bit rusty of me really, been away from coding for a short while. Jenny -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 13 September 2010 15:00 To: cf-talk Subject: Re: Debug Output For the sake of Google love... how did you fix it? On Mon, Sep 13, 2010 at 9:32 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Ignore this please .. fixed it. -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: 13 September 2010 14:30 To: cf-talk Subject: Debug Output Hi all, For some strange reason my debug output has stopped showing. I have my IP added in CF Admin and I added cfsetting showdebugoutput=yes to my application.cfm. Any ideas much appreciated, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.851 / Virus Database: 271.1.1/3131 - Release Date: 09/12/10 19:34:00 ~| 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:337102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]
On 9/16/2010 2:45 AM, Rick Root wrote: http://www.opensourcecf.com/1/2010/09/Example-of-using-JavaCSV-CSVReader-class-to-read-CSV-files.cfm pretty sure the numeric columns for csvReader are 0 based (ie 1st column is referenced as 0 not 1). yes, i'm too lazy to register on your blog. ~| 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:337103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm