Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Russ Michaels
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

re: cfimage and imageutils.cfc...

2010-09-15 Thread Eric Roberts
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 =

Saving files locally

2010-09-15 Thread Chad Baloga
Does anyone know how to save a file to a users local machine? I am writing some code to export data to various file types and I have an input where a user can specify where they want the file to save to. Thanks ~| Order the

Re: Saving files locally

2010-09-15 Thread Raymond Camden
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Matt Catmacey
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

Re: Saving files locally

2010-09-15 Thread Chad Baloga
Ok, thanks Ray. Is it possible to use cfheader/cfcontent in my cffunction to prompt the user with the file download box? I tried it but nothing seems to happen. Thanks ~| Order the Adobe Coldfusion Anthology now!

Re: Saving files locally

2010-09-15 Thread Raymond Camden
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Gerald Guido
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Russ Michaels
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

Re: Saving files locally

2010-09-15 Thread Chad Baloga
What I am doing is calling a jQuery function which then uses a CFC method to create my file. I am returning a message of how many files were created and zipped up. I then want to present the user with the File Download box to download the newly created file. It seems the cffunction does not

CFFM Update

2010-09-15 Thread Rick Root
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

Re: Saving files locally

2010-09-15 Thread Chad Baloga
I was able to get it to work by just using... window.location.href = 'test.zip' But still curious about how to get it to work with the function call ~| Order the Adobe Coldfusion Anthology now!

Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread John M Bliss
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

Re: Saving files locally

2010-09-15 Thread Raymond Camden
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Root
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!

Re: Saving files locally

2010-09-15 Thread Rick Root
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

Re: Removing new line from CSV?

2010-09-15 Thread Rick Root
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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,

dbDiscover - Update available at RIAForge

2010-09-15 Thread Paul Day
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread John M Bliss
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:

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Root
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Root
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

Re: Removing new line from CSV?

2010-09-15 Thread Rick Root
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Root
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

Re: Removing new line from CSV?

2010-09-15 Thread Dorioo
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

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread Rick Mason
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:

Re: Problem with getting cfhttp to do a post

2010-09-15 Thread John M Bliss
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

Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

2010-09-15 Thread Claude Schnéegans
The answer is it depends, Frankly, according to your results, I would rather answer the difference is marginal. ~| Order the Adobe Coldfusion Anthology now!

Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

2010-09-15 Thread Michael Grant
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

re: CFImage and imageutils.cfc

2010-09-15 Thread Eric Roberts
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

Re: Removing new line from CSV?

2010-09-15 Thread Rick Root
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.

re:CFImage and imageutils.cfc

2010-09-15 Thread Eric Roberts
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

Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Mike Kear
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

re:CFImage and imageutils.cfc

2010-09-15 Thread Leigh
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

re:CFImage and imageutils.cfc

2010-09-15 Thread Leigh
BTW: Please ignore anything after the cfabort. That non-functioning section was posted in error. ~| Order the Adobe Coldfusion Anthology now!

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Russ Michaels
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:

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Rick Root
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Matt Catmacey
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!

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Mike Kear
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

RE: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Will Swain
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

Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]

2010-09-15 Thread Paul Hastings
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

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Mike Kear
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.

RE: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Will Swain
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

re:CFImage and imageutils.cfc

2010-09-15 Thread Eric Roberts
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!

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Mike Kear
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

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Scott Stewart
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.

re:CFImage and imageutils.cfc

2010-09-15 Thread Eric Roberts
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

RE: CFFM Update

2010-09-15 Thread Jen Perkins McVicker
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

Re: Is there a way to force lock release on Access database? (CF9)

2010-09-15 Thread Russ Michaels
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

Re: CFFM Update

2010-09-15 Thread Rick Root
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

Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]

2010-09-15 Thread Rick Root
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Russ Michaels
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

Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]

2010-09-15 Thread Rick Root
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

Re: An instance of CF 7, CF 8, CF 9 on single pc

2010-09-15 Thread Matt Catmacey
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

CFGRID sort order

2010-09-15 Thread Sarah LaValle
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

Really odd problem - cpu utilization at idle

2010-09-15 Thread Dan Baughman
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

Re: Really odd problem - cpu utilization at idle

2010-09-15 Thread Russ Michaels
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

RE: Really odd problem - cpu utilization at idle

2010-09-15 Thread Mark A. Kruger
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

Re: Really odd problem - cpu utilization at idle

2010-09-15 Thread Dan Baughman
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

RE: Debug Output

2010-09-15 Thread Jenny Gavin-Wear
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

Re: Removing new line from CSV? [spamtrap bayes][spamtrap heur]

2010-09-15 Thread Paul Hastings
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.