Re: More Funky Email Address Validation Stuff
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 you really care, have the user enter it twice (like a password) and/or scan for bounce backs - like nukeing from orbit, the latter is the only way to be sure and even then *still* doesn't cover email that is silently deleted (i.e. as spam). -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace comma in replace list
Robert Harrison wrote: > How do I indicate a comma in a replace list so I can replace the comma? > > Example: >,/,\,*,?,<,>,|,:,$,.,',&,@,#chr(44)#", > "_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> > > chr(44) is the comma, but that doesn't work and neither does ,,. You could use a different list delimiter, as suggested; a neater solution might be to use rereplace. <|:$.'&~,]", "_", "ALL")/> If (taking a wild guess) this is for generating something like part of a permalink from a title string, you might want to squash multiple matching characters to a single underscore: <|:$.'&~,]+", "_", "ALL")/> You can simplify this even more if you actually want to hit all non-alphanumerics: -- Regards, Pete Jordan Horus Web Engineering Ltd http://www.webhorus.net/ phone: +44 1275 543971 mobile: +44 7973 725120 ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trying to read a text file of data and input into db...
Here's my solution, for anyone interested: delete from hmls_office_temp insert into hmls_office_temp ( temp_office_id, office_name, mail_address_1, mail_address_2, mail_city, mail_state, mail_zipcode, phone, fax, office_email ) values( , , , , , , , , , ) ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trying to read a text file of data and input into db...
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 ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
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 back on even doing a > simple loop over over a large set of rows seems to have the same issues. > Anyone have any ideas how to deal with this? > > If you run this code on watch the memory on the CF Server it will just keep > climbing until garbage collection runs. > > > > > > > > thanks, > -- Sam > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion.navigate question
Hello, Can I use coldfusion.navigate to refresh the contents of 2 cfpods. I have this sort of layout (simplified): Click Here For Poddy Funkiness Which will obviously update the first pod's content. Can I amend this to update the second pod's content at the same time? Will Swain Hot Horse Ltd - Web Design and Development 0845 458 2536 www.hothorse.com The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, you are not authorised and must not disclose, copy, distribute or retain this message or any part of it. The contents of this message may contain personal views which are not the views of Hot Horse Ltd, unless specifically stated. Hot Horse Ltd Company Number 3877066 Registered Office The Stables, Connaught Road, Seaford, East Sussex. BN25 2PT. Should you experience any problems with opening and reading emails and attachments or you are not the intended recipient, please contact [EMAIL PROTECTED] ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: coldfusion.navigate question
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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion.navigate question
How about... Click Here For Poddy Funkiness ? ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: coldfusion.navigate question
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... Click Here For Poddy Funkiness ? ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
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 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 concatenation using CF you'll use large amounts of memory > > because every concatenation creates a new String object. > > > > On Wed, Jun 25, 2008 at 9: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 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 back on even doing > a > > > > simple loop over over a large set of rows seems to have the same > > issues. > > > > Anyone have any ideas how to deal with this? > > > > > > > > If you run this code on watch the memory on the CF Server it will > just > > > keep > > > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > thanks, > > > > -- Sam > > > > > > > > > > > > > > > > > > > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QoQ string as field
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 http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion.navigate question
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 liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trying to read a text file of data and input into db...
Hi, Tom... it's MySQL 5. The code in my last email is working properly. However, now I have a problem executing this: I'm trying to run code like this at the end of each document that is processed as a scheduled task to set up the next task one the current task is complete. (The tasks are dependent) I keep getting this error: Error 500: Internal Server Error Is there anything wrong with the code above? Thanks, Rick > -Original Message- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2008 5:29 AM > To: CF-Talk > Subject: Re: Trying to read a text file of data and input into db... > > 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 ? > > -- > Tom Chiverton > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England and > Wales under registered > number OC307980 whose registered office address is at Halliwells LLP, 3 > Hardman Square, Spinningfields, > Manchester, M3 3EB. A list of members is available for inspection at the > registered office. Any > reference to a partner in relation to Halliwells LLP means a member of > Halliwells LLP. Regulated by The > Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and may > be confidential or legally > privileged. If you are not the addressee you must not read it and must not > use any information > contained in nor copy it nor inform any person other than Halliwells LLP or > the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells > LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with Flash Remoting with AS3/Flash/CF
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 Flex too much as
of yet. Can someone post the include files or dir paths I'd need to add that
functionality to Flash AS3? Sounds like its worth a shot. Also since I like
posting threads that clearly state progress up to a certain point, here is the
proper AS 3 code to suposibly make a Flash Remoting connection. If anyone
knows how to actually retireve variables out of it that would be nice to see as
well.
var connection:NetConnection = new NetConnection();
connection.connect("http://localhost:8500/flashservices/gateway/";);
//create result handler function 1 runs on result, 2 runs on error
var responder:Responder = new Responder(onResult, onError);
// call http://localhost/example/testcfc.cfc
connection.call("example.testcfc", null, param1, param2);
And thats where it gets blurry, I'm yet to see an onResult function that
properly pulls variables retreived from a cfc call.
~|
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:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308185
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
>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 file of data and input into db... Hi, Tom... it's MySQL 5. The code in my last email is working properly. However, now I have a problem executing this: ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Flash Remoting with AS3/Flash/CF
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 http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replace comma in replace list
>>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: a|a:a$a.a'a&[EMAIL PROTECTED],a"> #REReplace (MyString, "[##""%/\\*?<>|:$.'&@,]", "_", "all")# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checking SMTP service before application load
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 dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
.dat files urgent help!
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 data and a ton of funky chars. I am assuming it is comma delimited list of all the data but not 100%. Does anyone have any ideas on how I can find out what I need to open these files and get the data out? I really need this asap!!! Thanks! Lori ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trying to read a text file of data and input into db...
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 '\r\n' ignore 1 lines (aStr, @dummy1, @dummy2, @dummy3, aInt) set aDate=str_to_date(@dummy1,'%d/%m/%Y'), aDatetime=str_to_date(@dummy2,'%d/%m/%Y %T'), aTimeStamp=str_to_date(@dummy3,'%d/%m/%Y %T') It's very very quick. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking SMTP service before application load
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 bit hackish though. On Thu, Jun 26, 2008 at 9:18 AM, Keith McGee <[EMAIL PROTECTED]> wrote: > 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 dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: .dat files urgent help!
..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 somewhere a program called HEdit, it will display a file in both ASCII and binary format. You may also use it to look at the ,exe file of the DOS application and see if you can find any information about the system which created it and some library which was used. This could give you some hint about the format of the data file. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replace comma in replace list
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 either/or... It must be &. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2008 10:15 AM To: CF-Talk Subject: Re: Replace comma in replace list >>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: a|a:a$a.a'a&[EMAIL PROTECTED],a"> #REReplace (MyString, "[##""%/\\*?<>|:$.'&@,]", "_", "all")# -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace comma in replace list
>>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. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: .dat files urgent help!
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. 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 data and a ton of funky chars. I am assuming it is comma > delimited list of all the data but not 100%. Does anyone have any ideas > on how I can find out what I need to open these files and get the data > out? I really need this asap!!! > > > > Thanks! > > Lori > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8, IE7, Data Sources File Tree Applet
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] To: cf-talk@houseoffusion.com Date: Sat, 21 Jun 2008 23:29:25 -0400 Subject: RE: CF8, IE7, Data Sources File Tree Applet > The JRE is installed, Plug-in 1.6.0_06, and enabled in the > browser.Have you tested it with other Java applets?Dave > Watts, CTO, Fig Leaf Softwarehttp://www.figleaf.com/Fig Leaf > Software provides the highest caliber vendor-authorizedinstruction at our > training centers in Washington DC, Atlanta,Chicago, Baltimore, Northern > Virginia, or on-site at your location.Visit http://training.figleaf.com/ > for more information! ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
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, 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 '\r\n' > ignore 1 lines > (aStr, > @dummy1, > @dummy2, > @dummy3, > aInt) > set aDate=str_to_date(@dummy1,'%d/%m/%Y'), > aDatetime=str_to_date(@dummy2,'%d/%m/%Y %T'), > aTimeStamp=str_to_date(@dummy3,'%d/%m/%Y %T') > > It's very very quick. > -- > Tom Chiverton ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Code Cleaning Tool -Removing Tab characters
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 clean things up a bit. I found my old "Count the lines of code" thread, where the tool runs through the directory and counts the lines. Could I modify this to fit my needs? OR should I just build a new regex tool? #name# #totalLines# Thanks, Will ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
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 working fine. Here's the final solution:
http://localhost/real_estate_data/tasks/02_process_hmls_offices_text_file.cfm";
startdate = "#DateFormat(Now(), 'm/d/')#"
starttime = "#TimeFormat(DateAdd('n', 5,
now()), 'h:mm tt')#"
interval = "once" >
Rick
> -Original Message-
> From: Dave Francis [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2008 10:13 AM
> To: CF-Talk
> Subject: RE: Trying to read a text file of data and input into db...
>
> 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".
~|
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:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308200
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: .dat files urgent help!
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 help! 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. 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 data and a ton of funky chars. I am assuming it is comma > delimited list of all the data but not 100%. Does anyone have any ideas > on how I can find out what I need to open these files and get the data > out? I really need this asap!!! > > > > Thanks! > > Lori > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: .dat files urgent help!
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 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 help! > > 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. 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 data and a ton of funky chars. I am assuming it is comma > > delimited list of all the data but not 100%. Does anyone have any > ideas > > on how I can find out what I need to open these files and get the data > > out? I really need this asap!!! > > > > > > > > Thanks! > > > > Lori > > > > > > > > > > > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 Server Monitor stops working
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 root but one problem at a time. any ideas on how to jury rig this to work outside the web root? I have the form with the boxes for server, context root, port, u/n and password... but I don't see any clear docs on how to configure those settings appropriately. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Code Cleaning Tool -Removing Tab characters
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. #totalLines# ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Cleaning Tool -Removing Tab characters
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? #totalLines# ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
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? thanks, -- Sam On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek <[EMAIL PROTECTED]> wrote: > 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 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 concatenation using CF you'll use large amounts of memory > > > because every concatenation creates a new String object. > > > > > > On Wed, Jun 25, 2008 at 9: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 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 back on even > doing > > a > > > > > simple loop over over a large set of rows seems to have the same > > > issues. > > > > > Anyone have any ideas how to deal with this? > > > > > > > > > > If you run this code on watch the memory on the CF Server it will > > just > > > > keep > > > > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > thanks, > > > > > -- Sam > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
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 and, assuming you aren't in a cfoutput block, see if that makes any difference. Essentially, unless you're positive that no content is actually being generated in these loop calls, that alone will probably cause a lot of memory usage. What, by the way, is "too much memory"? And what exactly is the issue with the memory climbing until the GC runs...that's exactly what its supposed to do. On Thu, Jun 26, 2008 at 12:48 PM, Sam Roach <[EMAIL PROTECTED]> wrote: > 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? > > > > > > > thanks, > > -- Sam > > > On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek <[EMAIL PROTECTED]> wrote: > > > 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 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 concatenation using CF you'll use large amounts of > memory > > > > because every concatenation creates a new String object. > > > > > > > > On Wed, Jun 25, 2008 at 9: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 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 back on even > > doing > > > a > > > > > > simple loop over over a large set of rows seems to have the same > > > > issues. > > > > > > Anyone have any ideas how to deal with this? > > > > > > > > > > > > If you run this code on watch the memory on the CF Server it will > > > just > > > > > keep > > > > > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > thanks, > > > > > > -- Sam > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
By the way, this runs in about 5 seconds and uses no memory on my machine. 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 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 enablecfoutputonly="true"> and, assuming you aren't in a cfoutput block, see > if that makes any difference. Essentially, unless you're positive that no > content is actually being generated in these loop calls, that alone will > probably cause a lot of memory usage. > > What, by the way, is "too much memory"? And what exactly is the issue with > the memory climbing until the GC runs...that's exactly what its supposed to > do. > > On Thu, Jun 26, 2008 at 12:48 PM, Sam Roach <[EMAIL PROTECTED]> > wrote: > >> 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? >> >> >> >> >> >> >> thanks, >> >> -- Sam >> >> >> On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek <[EMAIL PROTECTED]> wrote: >> >> > 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 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 concatenation using CF you'll use large amounts of >> memory >> > > > because every concatenation creates a new String object. >> > > > >> > > > On Wed, Jun 25, 2008 at 9: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 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 back on even >> > doing >> > > a >> > > > > > simple loop over over a large set of rows seems to have the same >> > > > issues. >> > > > > > Anyone have any ideas how to deal with this? >> > > > > > >> > > > > > If you run this code on watch the memory on the CF Server it >> will >> > > just >> > > > > keep >> > > > > > climbing until garbage collection runs. >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > > thanks, >> > > > > > -- Sam >> > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > >> > >> > >> >> ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
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. > > > > > > > > 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 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 > enablecfoutputonly="true"> and, assuming you aren't in a cfoutput block, > see > > if that makes any difference. Essentially, unless you're positive that no > > content is actually being generated in these loop calls, that alone will > > probably cause a lot of memory usage. > > > > What, by the way, is "too much memory"? And what exactly is the issue > with > > the memory climbing until the GC runs...that's exactly what its supposed > to > > do. > > > > On Thu, Jun 26, 2008 at 12:48 PM, Sam Roach <[EMAIL PROTECTED] > > > > wrote: > > > >> 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? > >> > >> > >> > >> > >> > >> > >> thanks, > >> > >> -- Sam > >> > >> > >> On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek <[EMAIL PROTECTED]> > wrote: > >> > >> > 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 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 concatenation using CF you'll use large amounts of > >> memory > >> > > > because every concatenation creates a new String object. > >> > > > > >> > > > On Wed, Jun 25, 2008 at 9: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 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 back on even > >> > doing > >> > > a > >> > > > > > simple loop over over a large set of rows seems to have the > same > >> > > > issues. > >> > > > > > Anyone have any ideas how to deal with this? > >> > > > > > > >> > > > > > If you run this code on watch the memory on the CF Server it > >> will > >> > > just > >> > > > > keep > >> > > > > > climbing until garbage collection runs. > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > thanks, > >> > > > > > -- Sam > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > >> > >> > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Email "on behalf of"
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 emails come from "[EMAIL PROTECTED] on behalf of [submitters email]". I dont think its done by just using the from "Yahoo groups...Dinowitz <[EMAIL PROTECTED]>" because outlook lets me click on each name individually. Is there any way to do this in CF? ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email "on behalf of"
use the "replyTo" attribute of ? 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 > to yahoo groups. > > On the webforms of one of my sites I want to try to set something like this > up (so the emails come from "[EMAIL PROTECTED] on behalf of [submitters > email]". > > I dont think its done by just using the from "Yahoo groups...Dinowitz <[EMAIL > PROTECTED]>" because outlook lets me click on each name individually. > > Is there any way to do this in CF? > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Email "on behalf of"
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): If you try it out you will see how its different from Reply-To. Now that I see how easy it is, I am going to use this all over the place. >use the "replyTo" attribute of ? > >On Thu, Jun 26, 2008 at 10:16 AM, James Wolfe <[EMAIL PROTECTED]> wrote: >> ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email "on behalf of"
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 find it): > > > > If you try it out you will see how its different from Reply-To. Now that I > see how easy it is, I am going to use this all over the place. > >>use the "replyTo" attribute of ? >> >>On Thu, Jun 26, 2008 at 10:16 AM, James Wolfe <[EMAIL PROTECTED]> wrote: >>> > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP - why are there duplicates?
>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 being called once ?? Bob ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Email "on behalf of"
This does what you want: http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=cfmail.msoutlook Like it says, it is only reliable in outlook, and does not always work in your email reader of choice =\ ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, IE7, Data Sources File Tree Applet
> 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/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8, IE7, Data Sources File Tree Applet
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 IE6? > > > Sure, just paste in the location of your database c:/databases/theDB ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Code Cleaning Tool -Removing Tab characters
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 task. We don't do it ourselves, but I've seen posts where people use SVNANT for code deployment, and let ANT remove all whitespace (tab, new line) from templates at that time. This helps them maintain code readability during the development phase, but helps to reduce bandwidth and storage space in the deployment phase. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Will Tomlinson wrote: > 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 clean things up a bit. > > I found my old "Count the lines of code" thread, where the tool runs through > the directory and counts the lines. > > Could I modify this to fit my needs? OR should I just build a new regex tool? > > filter="*" sort="directory" recurse="yes"> > > > > > > > > > > > #name# > > > > > > > > #totalLines# > > Thanks, > Will > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Cleaning Tool -Removing Tab characters
>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 are about 150 standards that are checked with the code review tool. I've built a prototype that seems to get the job done. It checks via Regex, then spits out an error array if there were any errors. I can do whatever I want with it now. Write to file, email, add more regexs, etc. The only thing I'm worried about now is bringing down the server. lol! Thanks! Will ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Cleaning Tool -Removing Tab characters
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. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8, IE7, Data Sources File Tree Applet
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 Sources File Tree Applet 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 IE6?>>>Sure, just paste in the location of your databasec:/databases/theDB ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking SMTP service before application load
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 the API some time ago. 2008/6/26 Raymond Camden <[EMAIL PROTECTED]>: > 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 > bit hackish though. > > On Thu, Jun 26, 2008 at 9:18 AM, Keith McGee <[EMAIL PROTECTED]> wrote: >> 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 dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simulate click on ListBox down arrow
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, set the form field to that option joe velez Charlie Griefer wrote: > Hi Walter: > > Sorry, I misunderstood you. I thought you were asking if there was a > way to pre-select a given option. > > Still not sure I fully understand. Is this to allow users to select > multiple options? Because otherwise the functionality you're after is > the default behavior of the element... onclick it opens up. > it may not show all of the options, but it shows the first batch. > Unless you're shooting for allowing the user to select more than one > option, is there any reason to show all? > > If this is a route you want to go, you might try manipulating the > z-index value of the element to try and float it over the > element(s) below it. > > > On Tue, Jun 24, 2008 at 1:20 PM, Walter Conti <[EMAIL PROTECTED]> wrote: > >> Thank You Charlie, that shows me just the fourth option. I would like to >> have all of them visible. >> >> this.size = this.length works >> but the listbox does not open on top of the other form element, instead push >> them down. >> >> >> > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replace comma in replace list
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: Re: Replace comma in replace list You can't supply an alternate delimiter to replaceList, unfortunately, so that won't work. cheers, barneyb On Wed, Jun 25, 2008 at 3:05 PM, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > Change your list delimiter so a comma isn't interpreted as a delimiter. > Check out listChangeDelims() (or something like that) > > ..:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
eseminar: introduction to cf components (today!)
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 use the built-in ColdFusion application framework component." 2PM-3PM Sydney Time -- June 27, 2008 (that's today!) Really aimed at those new to ColdFusion and those who might have been thinking about learning how CFCs work but could never find the time. It's an APAC seminar I'm hosting, but i guess anyone is invited :) Meeting room opens about ten minutes before: http://pacific.adobe.acrobat.com/developer Register if you can, but its not essential -- happy to take last minute strays: http://events.adobe.co.uk/cgi-bin/event.cgi?country=pa&eventid=6781 All the best, geoff http://www.daemon.com.au/ Adobe Community Expert for ColdFusion ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: eseminar: introduction to cf components (today!)
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 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 use the > built-in ColdFusion application framework component." > > 2PM-3PM Sydney Time -- June 27, 2008 (that's today!) ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: eseminar: introduction to cf components (today!)
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)Friday, 27 June 2008, 14:00:00UTC+10 hours EST San Francisco (U.S.A. - California) Thursday, 26 June 2008, 21:00:00UTC-7 hours PDT Corresponding UTC (GMT) Friday, 27 June 2008, 04:00:00 >From http://www.timeanddate.com/worldclock/ -- geoff http://www.daemon.com.au/ ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem accessing https on sub-domain where base domain not accessible
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 the www. HTTPS addresses at house.gov with a sub-domain work fine in all browsers but CF (Java?) can't access them any longer. Below is some quick test code where you can see the response from ColdFusion and click to see the browser response. Any ideas or options here? Hopefully house.gov magically starts working soon and fixes this. Not getting this working will mean a lot of manual work. Thanks for any help == Test Code == http://www.house.gov";, "http://house.gov";, "http://forms.house.gov";, "https://www.house.gov";, "https://forms.house.gov"; ]> #address# == Example Response == Charset [empty string] ErrorDetail I/O Exception: peer not authenticated Filecontent Connection Failure Header [empty string] Mimetype Unable to determine MIME type of file. Responseheader http://www.house.gov - struct [empty] Statuscode Connection Failure. Status code unavailable. Text YES ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem accessing https on sub-domain where base domain not accessible
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 Header [empty string] Mimetype Unable to determine MIME type of file. Responseheader https://forms.house.gov - struct [empty] Statuscode Connection Failure. Status code unavailable. Text YES ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem accessing https on sub-domain where base domain not accessible
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. This procedure should not be necessary if the certificate is signed (issued) by an authority that the JSSE (Java Secure Sockets Extension) recognizes (for example, Verisign); that is, if the signing authority is in the cacerts already. However, you might need to use the procedure if you are issuing SSL (secure sockets layer) certificates yourself. To manually import a certificate: 1. Go to a page on the SSL server in question. 2. Double-click the lock icon. 3. Click the Details tab. 4. Click Copy To File. 5. Select the base64 option and save the file. 6. Copy the CER file into C:\CFusionMX7\runtime\jre\lib\security (or whichever JRE ColdFusion is using). 7. Run the following command in the same directory (keytool.exe is located in C:\CFusionMX7\runtime\jre\bin): keytool -import -keystore cacerts -alias giveUniqueName -file filename.cer > 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] > ErrorDetailI/O Exception: peer not authenticated > FilecontentConnection Failure > Header [empty string] > Mimetype Unable to determine MIME type of file. > Responseheader > https://forms.house.gov - struct [empty] > Statuscode Connection Failure. Status code unavailable. > Text YES ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem accessing https on sub-domain where base domain not accessible
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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
