Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
Yes I am using CF8. On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
I'm using a java stringbuffer which works great for the portion of the code, but the main issue is with the cfloop tag. On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek [EMAIL PROTECTED] wrote: If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV. If you do the

Re: Replace comma in replace list

2008-06-26 Thread Sam Roach
I don't know if you can do it with the ReplaceList function at all... But you can wrap your var with a replace first.. Example: cfset new_var=#ReplaceList(trim(replace(my_var,,,_,all)), ##,,%,,/,\,*,?,,,|,:,$,.,',,@,#chr(44)#,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_)# hope this helps. -- Sam On

Re: More Funky Email Address Validation Stuff

2008-06-26 Thread Tom Chiverton
On Wednesday 25 Jun 2008, Les Mizzell wrote: http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-add ress-until-i.aspx Jezz, it's worse than we all thought, huh? Only because I've got bored of saying it over and over and over and over again. Just send the email to it. If

Re: Replace comma in replace list

2008-06-26 Thread Pete Jordan
Robert Harrison wrote: How do I indicate a comma in a replace list so I can replace the comma? Example: cfset new_var=#ReplaceList(trim(my_var), ##,,%, ,/,\,*,?,,,|,:,$,.,',,@,#chr(44)#, _,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_)# chr(44) is the comma, but that doesn't work and

RE: Trying to read a text file of data and input into db...

2008-06-26 Thread Rick Faircloth
Here's my solution, for anyone interested: cfquery name=delete_offices datasource=#application.dsn# delete from hmls_office_temp /cfquery cfset filepath = e:\inetpub\webroot\real_estate_data\hmls\data\#DateFormat(now(), '_mmdd')#_idx_custom\office.txt cffile action = read file =

Re: Trying to read a text file of data and input into db...

2008-06-26 Thread Tom Chiverton
On Thursday 26 Jun 2008, Rick Faircloth wrote: I'm trying to read a tab-delimited text file of data and separate it into field data so I can input it into a database. Almost all databases have a special bulk import tool or command, which may or may not require cfexecute. What database is this

Re: cfloop using to much memory

2008-06-26 Thread rex
Sam Roach wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step

coldfusion.navigate question

2008-06-26 Thread Will Swain
Hello, Can I use coldfusion.navigate to refresh the contents of 2 cfpods. I have this sort of layout (simplified): a href=javaScript:ColdFusion.navigate('pod1_updated.cfm','pod1')Click Here For Poddy Funkiness/a cfpod source=pod1.cfm name=pod1 width=280 height=600 / cfpod

RE: coldfusion.navigate question

2008-06-26 Thread Will Swain
Apologies for the signature malarkey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive:

Re: coldfusion.navigate question

2008-06-26 Thread Brian McCairn
How about... a href=javaScript:ColdFusion.navigate('pod1_updated.cfm','pod1');ColdFusion.navigate('pod2_updated.cfm','pod2)Click Here For Poddy Funkiness/a ? ~| Adobe® ColdFusion® 8 software 8 is the most important and

RE: coldfusion.navigate question

2008-06-26 Thread Will Swain
Hmmmneed more coffee. Thanks Brian! -Original Message- From: Brian McCairn [mailto:[EMAIL PROTECTED] Sent: 26 June 2008 11:34 To: CF-Talk Subject: Re: coldfusion.navigate question How about... a href=javaScript:ColdFusion.navigate('pod1_updated.cfm','pod1');ColdFusion.n

Re: cfloop using to much memory

2008-06-26 Thread Brian Kotek
Can you post the code? Because a loop tag itself woudn't be causing memory to spike. It has to be something inside the loop tag. On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach [EMAIL PROTECTED] wrote: I'm using a java stringbuffer which works great for the portion of the code, but the main issue

QoQ string as field

2008-06-26 Thread AJ Mercer
Can QoQ strings as a field? eg SELECT '#myVariable#' as myVariable -- AJ Mercer Web Log: http://webonix.net ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: coldfusion.navigate question

2008-06-26 Thread Tom Chiverton
On Thursday 26 Jun 2008, Will Swain wrote: Apologies for the signature malarkey Don't worry to much about it :-) -- Tom Chiverton, stand clear... This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited

RE: Trying to read a text file of data and input into db...

2008-06-26 Thread Rick Faircloth
Hi, Tom... it's MySQL 5. The code in my last email is working properly. However, now I have a problem executing this: cfschedule action = run task = 02_Process HMLS Office Data Text File startdate =

Re: Help with Flash Remoting with AS3/Flash/CF

2008-06-26 Thread Tom Smith
I've seen the BlazeDS solution when I was beta testing scorpio (cf8) as I bought up the same issue to them. My understanding of it is its similar to the LiveCycle ES services built into CF8. Issue again would be, yeah the lack of Flash support for that means of sending. I'm not fimilar with

RE: Trying to read a text file of data and input into db...

2008-06-26 Thread Dave Francis
From a CF5 lang ref, so may be out of date... Is the task registered? Also try for startdate format. And you don't need Interval. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2008 9:31 AM To: CF-Talk Subject: RE: Trying to read a text

Re: Help with Flash Remoting with AS3/Flash/CF

2008-06-26 Thread Jo�o_Fernandes
Tom, /flashServices/gateway endpoint is for AMF0 calls.If you want to call that endpoint from a AS3 app you should define the client-side encoding to AMF0. If you are using CF7.0.2/CF8 you should point it to /flex2gateway instead to take advantage of the AMF3 format. -- João Fernandes

Re: Replace comma in replace list

2008-06-26 Thread Claude Schneegans
How do I indicate a comma in a replace list so I can replace the comma? replaceList is not the right tool for this, and since you are replacing all characters by the same one, what you need is REReplace. ie : REReplace (MyString, [##%/\\*?|:$.'@,], _, all) Example: CFSET myString =

Checking SMTP service before application load

2008-06-26 Thread Keith McGee
Is there a way to check to status of the SMTP server/service before I load an application in ColdFusion? Then not load the application if the server/service is down? ~| Adobe® ColdFusion® 8 software 8 is the most important and

.dat files urgent help!

2008-06-26 Thread Stone, Lori
I have acquired a really old dos application that I have rewritten. All of the data was stored in .dat files. I have no idea of what they used to create it because all I got was a compiled version of the app so I can't see how the data was written. I open the dat files in notepad and saw some

Re: Trying to read a text file of data and input into db...

2008-06-26 Thread Tom Chiverton
On Thursday 26 Jun 2008, Rick Faircloth wrote: Hi, Tom... it's MySQL 5. By coincidence, I'm doing bulk loads into that too. You can use CFQUERY to do: LOAD DATA LOCAL INFILE '/a/file/on/the/web.server' INTO TABLE demoTable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY

Re: Checking SMTP service before application load

2008-06-26 Thread Raymond Camden
The Admin API lets you check a few things, but doesn't let you do the verify option that you have in the cf admin. That may be a good addition to the api. You could always do a cfmail w/ a try/catch in onApplicationStart. You could mail to some dummy account that gets auto-emptied. That seems a

Re: .dat files urgent help!

2008-06-26 Thread Claude Schneegans
..dat is a generic extension for ANY data. It could have been generated by ANY application in ANY format. If you see funky chars, it is probably because they are not chars, but binary data. NotePad won't give you much information about binary data. Search the web to see if you can download from

RE: Replace comma in replace list

2008-06-26 Thread Robert Harrison
Thanks... that is how I did it in the end, after playing with regex for 2 hours. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be

Re: Replace comma in replace list

2008-06-26 Thread Claude Schneegans
after playing with regex for 2 hours. Not bad. The average is at leat 6 hours ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks.

Re: .dat files urgent help!

2008-06-26 Thread Fred Anderson
If you can make the file available we can give it a look.. it you cannot, then there is not much we can do. Fred On Thu, Jun 26, 2008 at 9:28 AM, Stone, Lori [EMAIL PROTECTED] wrote: I have acquired a really old dos application that I have rewritten. All of the data was stored in .dat files.

RE: CF8, IE7, Data Sources File Tree Applet

2008-06-26 Thread jgeorges
Yes, went to a few sites to check if Java applets work, one being the Sun site. It just does not work with displaying the file tree in the CF administrator. Any other thoughts? TIA --- On Sat 06/21, Dave Watts [EMAIL PROTECTED] wrote: From: Dave Watts [mailto: [EMAIL PROTECTED]

RE: Trying to read a text file of data and input into db...

2008-06-26 Thread Rick Faircloth
Thanks for the suggestion, Tom. I may need to go that route. Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2008 10:31 AM To: CF-Talk Subject: Re: Trying to read a text file of data and input into db... On Thursday 26 Jun 2008,

Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Will Tomlinson
Hey, I'm working for a company with a pretty sharp code review tool. There are hundreds of things it checks for. One of them is tab characters. We can't have any tabs in our source. I thought I could stay ahead of the curve by using my own tool that'd run a few checks on my directory, and

RE: Trying to read a text file of data and input into db...

2008-06-26 Thread Rick Faircloth
Hi, Dave, and thanks for the feedback... Yes, the tasks are registered and I did change the startdate year format to '' per your suggestion. I also ended up having to set the action to update rather than run, which also required operation=HTTPRequest, the url, and interval. But now it's

RE: .dat files urgent help!

2008-06-26 Thread Stone, Lori
I will see if I can get one made available. If not, could I email it to you directly? (or anyone else that feels like taking a look) -Lori -Original Message- From: Fred Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2008 10:58 AM To: CF-Talk Subject: Re: .dat files urgent

Re: .dat files urgent help!

2008-06-26 Thread Fred Anderson
Lori, feel free to email it to me (assuming it is less that 10mb) whitefalcon at gmail If I get it by noon(central) today I can take a look over lunch. Thanks, Fred On Thu, Jun 26, 2008 at 10:32 AM, Stone, Lori [EMAIL PROTECTED] wrote: I will see if I can get one made available. If not, could I

Re: CF 8 Server Monitor stops working

2008-06-26 Thread Dana Kowalski
I ended up solving this, well the problem anyhow... If I move the administrator back under the web root and access it via the actual ip and not the local loopback the monitor works again like a champ. It doesn't explain why it initially worked when I moved the administrator out of the web

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Will Tomlinson
I've got this, but if I try dumping the contents of the file it's reading, it just says newfile as plain text in the browser. cfdirectory directory=c:\webRoot\TestSite2\TestClean action=list name=mySite filter=* sort=directory recurse=yes cfset totalLines = 0 !---loop over all the files and

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Will Tomlinson
This seems to be working. I just haven't tried it on a huge directory. it could crash or somethin lol... Anybody got any performance tips? cfdirectory directory=c:\webRoot\TestSite2\TestClean action=list name=mySite filter=* sort=directory recurse=yes cfset totalLines = 0 !---loop over all

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
This empty loop as posted here will cause the same memory spikes. You can create just a simple .cfm page and run this and watch the memory go out of control. Maybe it is a Coldfusion bug? cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam On Thu, Jun

Re: cfloop using to much memory

2008-06-26 Thread Brian Kotek
Well I'm not sure it is a bug, you're talking about 20 MILLION loop iterations. If nothing else you're going to get 20 million carriage returns in the output buffer. You could try wrapping it in cfsetting enablecfoutputonly=true and, assuming you aren't in a cfoutput block, see if that makes any

Re: cfloop using to much memory

2008-06-26 Thread Brian Kotek
By the way, this runs in about 5 seconds and uses no memory on my machine. cfsilent cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop /cfsilent On Thu, Jun 26, 2008 at 1:02 PM, Brian Kotek [EMAIL PROTECTED] wrote: Well I'm not sure it is a bug, you're talking about 20

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
Thanks, the cfsilent did the trick.. -- Sam On Thu, Jun 26, 2008 at 10:04 AM, Brian Kotek [EMAIL PROTECTED] wrote: By the way, this runs in about 5 seconds and uses no memory on my machine. cfsilent cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop /cfsilent

Email on behalf of

2008-06-26 Thread James Wolfe
I sometimes get email where the from reads something like: Yahoo Groups on behalf of Michael Dinowitz where the specific names are obviously irrelevant. When i his reply, it goes to yahoo groups. On the webforms of one of my sites I want to try to set something like this up (so the

Re: Email on behalf of

2008-06-26 Thread Charlie Griefer
use the replyTo attribute of cfmail ? On Thu, Jun 26, 2008 at 10:16 AM, James Wolfe [EMAIL PROTECTED] wrote: I sometimes get email where the from reads something like: Yahoo Groups on behalf of Michael Dinowitz where the specific names are obviously irrelevant. When i his reply, it goes

Re: Email on behalf of

2008-06-26 Thread James Wolfe
Reply-To is different - it doesnt show up in the from. The actual answer is to set the Sender email header (I tore apart some email headers to find it): CFMAILPARAM NAME=Sender VALUE=[EMAIL PROTECTED] If you try it out you will see how its different from Reply-To. Now that I see how easy

Re: Email on behalf of

2008-06-26 Thread Charlie Griefer
gotcha. cool. thanks for sharing the answer (lots of folks don't do that) :) On Thu, Jun 26, 2008 at 10:51 AM, James Wolfe [EMAIL PROTECTED] wrote: Reply-To is different - it doesnt show up in the from. The actual answer is to set the Sender email header (I tore apart some email headers to

Re: CFLOOP - why are there duplicates?

2008-06-26 Thread Robert Bell
I assume the insert is going directly into a table and not into a query? [mailto:[EMAIL PROTECTED] Sent: 19 June 2008 20:35 To: CF-Talk Subject: Re: CFLOOP - why are there duplicates? Thanks. I thought I was going crazy. Not a cflocation somewhere else is there ? Is the page definitely only

Re: Email on behalf of

2008-06-26 Thread Dana Kowalski
This does what you want: http://mkruger.cfwebtools.com/index.cfm?mode=aliasalias=cfmail.msoutlook Like it says, it is only reliable in outlook, and does not always work in your email reader of choice =\ ~| Adobe® ColdFusion®

RE: CF8, IE7, Data Sources File Tree Applet

2008-06-26 Thread Dave Watts
Yes, went to a few sites to check if Java applets work, one being the Sun site. It just does not work with displaying the file tree in the CF administrator. Does it work if you view it with another browser? With another computer? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

Re: CF8, IE7, Data Sources File Tree Applet

2008-06-26 Thread Casey Dougall
On Sat, Jun 21, 2008 at 10:13 AM, jgeorges [EMAIL PROTECTED] wrote: Running ColdFusion 8, IE7, Windows Server 2K3. When creating a data source in the CF Administrator I get the following error trying to browse the server for the database file. Is ther a fix other than reverting back to

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Cutter (CFRelated)
Will, You can't have tabs? In the deployment phase, or in development? It would be a shame to lose that formatting in the development phase, as that type of formatting (aside from being very standard practice) really does help with code readability. I would suggest you look at ANT for your

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Will Tomlinson
Will, You can't have tabs? In the deployment phase, or in development? It would be a shame to lose that formatting in the development phase, as that type of formatting (aside from being very standard practice) really does help with code readability. I believe it's just in deployment. There

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Charlie Griefer
On Thu, Jun 26, 2008 at 12:50 PM, Will Tomlinson [EMAIL PROTECTED] wrote: The only thing I'm worried about now is bringing down the server. lol! I wouldn't worry about it. I have every confidence in you that you can bring down the server. -- A byte walks into a bar and orders a pint.

Re: CF8, IE7, Data Sources File Tree Applet

2008-06-26 Thread jgeorges
Doing that now. Would like to determine why the applet is not running. Thanks --- On Thu 06/26, Casey Dougall [EMAIL PROTECTED] wrote: From: Casey Dougall [mailto: [EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Thu, 26 Jun 2008 14:45:28 -0400 Subject: Re: CF8, IE7, Data

Re: Checking SMTP service before application load

2008-06-26 Thread Andy Allan
Whilst the Admin API doesn't expose the verify mail server option, as Ray states, you can still drop down and use the ServiceFactory if that option is available to you. Whilst not officially support it's what the CFAdmin uses anyway. Andy ps I logged a bug about the lack of verityServer() in

Re: Simulate click on ListBox down arrow

2008-06-26 Thread Joe Velez
You know how when you click on the select menu it opens up and you see several choices and you need to select one. He wants the select field to automatically open when it's onfocus not onclick Instead of opening the select menu, create a DIV/menu that opens. When the user selects the option,

RE: Replace comma in replace list

2008-06-26 Thread Bobby Hartsfield
Yeah that is unfortunate. I've never found a need for it personally though :-) ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 6:08 PM To: CF-Talk Subject:

eseminar: introduction to cf components (today!)

2008-06-26 Thread Geoff Bowers
Introduction to Adobe(R) ColdFusion(R) Components --- Join us for an introduction to creating ColdFusion components. During this essential eSeminar you'll learn basic ColdFusion syntax, find out how to invoke static ColdFusion methods, and discover where to

Re: eseminar: introduction to cf components (today!)

2008-06-26 Thread Phillip Vector
For those of us not in the outback, can you please tell us the time in GMT or explain the offset of sydney time? :) On Thu, Jun 26, 2008 at 3:23 PM, Geoff Bowers [EMAIL PROTECTED] wrote: Introduction to Adobe(R) ColdFusion(R) Components --- Join us for

Re: eseminar: introduction to cf components (today!)

2008-06-26 Thread Geoff Bowers
2008/6/27 Phillip Vector [EMAIL PROTECTED]: For those of us not in the outback, can you please tell us the time in GMT or explain the offset of sydney time? :) Sydney time is normally +10 GMT -- but it depends on your local daylight savings regime. Example: Sydney (Australia - New South Wales)

problem accessing https on sub-domain where base domain not accessible

2008-06-26 Thread Daniel Roberts
I have a process that interacts with encrypted pages on the house.gov website. Everything was working fine until a few days ago. It appears that there is a DNS problem with house.gov though sub-domains including www are fine. IE throws an error when going to house.gov while firefox redirects to

Re: problem accessing https on sub-domain where base domain not accessible

2008-06-26 Thread Daniel Roberts
That response above is misleading the way I copied it out with the http address. It is the response from an HTTPS request. Below is a better example https://forms.house.gov - struct Charset [empty string] ErrorDetail I/O Exception: peer not authenticated Filecontent Connection Failure

Re: problem accessing https on sub-domain where base domain not accessible

2008-06-26 Thread William Seiter
the certificate on that site was issued on 6.8.2008, chances are the new certificate is not in your system yet. See below. From the Docs: To use HTTPS with the cfhttp tag, you might need to manually import the certificate for each web server into the keystore for the JRE that ColdFusion uses.

Re: problem accessing https on sub-domain where base domain not accessible

2008-06-26 Thread Daniel Roberts
Thanks! I'll give it a try. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive:

CF Newbie Developer - NYC

2008-06-26 Thread kim torrance
I am currently looking for a 1-3 year CF developer for a major bank located downtown NYC. Base salary is in the $75-95K range. Description Below: A Bachelor's degree in Computer Science or Information Science or equivalent education and/or work experience; Experience developing systems

CF Newbie Developer NYC

2008-06-26 Thread Rita Mehta
Hello Kim, Will you client sponsor H1? Thanks, Rita Mehta Resource Point LLc IT Staffing / Projects Outsourcing - eCommerce | ERP | CRM | Content Management Tel (248) 649-5600 *11 | Fax (248) 649-4300 blocked::mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] www.resourcepoint.net

Re: CF Newbie Developer NYC

2008-06-26 Thread Michael Dinowitz
If you need, I'm available for teaching and mentoring in the NY area (I'm in Brooklyn), though not as a full time employee. This may allow you to 'grow' someone into a better ColdFusion programmer or even train one from the ground up. On Thu, Jun 26, 2008 at 11:12 AM, kim torrance [EMAIL