RE: Install coldfusion 8 on windows 7 64bit with IIS7 problem HTTP Error 500.0 - Internal Server Error

2010-04-27 Thread Libo Bian
Hi Dave, It fixed my problem! Thank you very much! -Original Message- From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] Sent: 26 April 2010 23:17 To: cf-talk Subject: Re: Install coldfusion 8 on windows 7 64bit with IIS7 problem HTTP Error 500.0 - Internal Server Error I had this

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Scott Brady
Is this a direct copy of your code? If so, this appears to be your problem: cfhttpparam type=url name=pdw value=#urlencodedformat(paypal_enviroment.api_pwd)# You misspelled pwd in the name attribute. Scott On Mon, Apr 26, 2010 at 6:16 PM, Matthew P. Smith m...@smithwebdesign.netwrote: I

Re: ssis 2005 question

2010-04-27 Thread Paul Ihrig
yeah we do have them linked. so select into may be better. i cant detach and reattach because we are changing the table names of about 90% of the tables.. or that's what i am telling my self.. i really do appreciate your guys opinions. thanks a bunch -paul On Mon, Apr 26, 2010 at 10:20 PM, rex

CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Scott Brady
Is anyone else using CFEclipse on the Mac with the Subclipse plug-in? For me, it seems really unstable (sometimes, I have to restart eclipse 5 times within 5 minutes). I tried a fresh install yesterday and I'm still having issues. Things like typing not showing up, errors when trying to save,

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Scott Stroz
I am using CF Builder now, but I used CFEclipse with Subclipse before that and never experienced issues like you are describing. On Tue, Apr 27, 2010 at 10:18 AM, Scott Brady dsbr...@gmail.com wrote: Is anyone else using CFEclipse on the Mac with the Subclipse plug-in?  For me, it seems

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Scott Brady
Which versions of CFEclipse/eclipse did you use? At my last job (which was a few weeks ago), I was having stability issues with the latest versions of CFEclipse/Eclipse, too, and that was on Windows XP. That didn't have subclipse on it (and, to be fair, it had some different symptoms -- mainly

Not so simple date format question...

2010-04-27 Thread Che Vilnonis
I'm working with an accounting database that stores order dates as a varchar (8) field. An example would be 20100420. Obviously, CF's dateformat chokes when used. Short of using a bunch of cfset statements with CF functions, how can I (in SQL preferrably or CF) easily format this string to

Re: Not so simple date format question...

2010-04-27 Thread Leigh
Which database are you using? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Not so simple date format question...

2010-04-27 Thread Barney Boisvert
s = 20100420; mid(s, 5, 2) / right(s, 2) / left(s, 4); cheers, barneyb On Tue, Apr 27, 2010 at 8:32 AM, Che Vilnonis ch...@asitv.com wrote: I'm working with an accounting database that stores order dates as a varchar (8) field. An example would be 20100420. Obviously, CF's dateformat

RE: Not so simple date format question...

2010-04-27 Thread Che Vilnonis
MSSQL 2005 I figured a db convert statement might be needed? -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, April 27, 2010 11:37 AM To: cf-talk Subject: Re: Not so simple date format question... Which database are you using?

RE: Not so simple date format question...

2010-04-27 Thread Leigh
MSSQL 2005 I figured a db convert statement might be needed? Yes, that is one way to do it. If you think you will be doing it frequently, you could create a view (containing the convert) and call the view in your CF code: SELECT convert(datetime, YourVarcharCol, 112) AS ConvertedToDateTime

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Wil Genovese
I use CFEclipse and CFBuilder on the Mac. I've switched from the Subclipse plug in to the Subversive plug in. Subversive is now part of the Eclipse project and seems to be getting more love and support. Wil Genovese Sr. Web Application Developer http://www.trunkful.com On Tue, Apr 27, 2010

Re: Not so simple date format question...

2010-04-27 Thread Jake Churchill
Just do something like this: cfset str = 20100420 / cfoutput #DateFormat(CreateDate(MID(str,1,4),MID(str,5,2),MID(str,7,2)),'mm/dd/')# /cfoutput On Tue, Apr 27, 2010 at 10:32 AM, Che Vilnonis ch...@asitv.com wrote: I'm working with an accounting database that stores order dates as a

RE: Not so simple date format question...

2010-04-27 Thread Che Vilnonis
Barney, thanks! I had something similar. Leigh, that is what I was looking for. Works perfectly. Thanks to you as well. Che -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, April 27, 2010 11:44 AM To: cf-talk Subject: RE: Not so simple date format

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Scott Brady
True. I guess I can try that to see if it's indeed subclipse instead of cfeclipse itself. Scott On Tue, Apr 27, 2010 at 9:46 AM, Wil Genovese jugg...@visi.com wrote: I use CFEclipse and CFBuilder on the Mac. I've switched from the Subclipse plug in to the Subversive plug in. Subversive

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread Scott Stroz
Cannot recall off hand, but I know they were the most recent versions of Eclipse, CFEclipse and Subclipse. On Tue, Apr 27, 2010 at 10:41 AM, Scott Brady dsbr...@gmail.com wrote: Which versions of CFEclipse/eclipse did you use? At my last job (which was a few weeks ago), I was having

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Matthew P. Smith
Thank you for spotting that. Unfortunately, I am still getting the same error. cfhttp method=get url=#paypal_enviroment.api_url# throwonerror=yes cfhttpparam type=url name=user value=#urlencodedformat(paypal_enviroment.api_user)# cfhttpparam type=url name=pwd

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Matthew P. Smith
Ok, after testing further, it looks like the issue is with the cfhttpparams. This works: cfset testurl =

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Dave Watts
Ok, after testing further, it looks like the issue is with the cfhttpparams. This works: cfset testurl = #paypal_enviroment.api_url#? user=#urlencodedformat(paypal_enviroment.api_user)#pwd=#urlencodedformat(paypal_enviroment.api_pwd)#

CFHTTP and APSX

2010-04-27 Thread Matthew Friedman
Ok this one has me stumped. We need to send a simple xml package to a partners site. We have set up the cfhttp to post to their site and we have tired both as an XML type and a form type. When we make the call cfhttp url=#form.post_url method=POST timeout=30 cfhttpparam type=Header

Re: CFHTTP and APSX

2010-04-27 Thread Phillip Duba
Matt, Make sure they aren't expecting that form field to be submitted as an XML type and not a form field. I've run into that a few times when dealing with .NET form submissions. Based on the type of data this may be the case, Phil On Tue, Apr 27, 2010 at 1:37 PM, Matthew Friedman

Re: CFHTTP and APSX

2010-04-27 Thread Matthew Friedman
Working with the developer on this. We have it just looking for the Request.xmlresponse value. I have tired it both ways also. Matt, Make sure they aren't expecting that form field to be submitted as an XML type and not a form field. I've run into that a few times when dealing with .NET form

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Matthew P. Smith
Yes, that was it. Thank you so much, Dave. Are there any other tags that do that automatically? On Tue, Apr 27, 2010 at 12:22 PM, Dave Watts dwa...@figleaf.com wrote: Ok, after testing further, it looks like the issue is with the cfhttpparams. This works: cfset testurl =

Re: Security Header is Not Valid - Paypal

2010-04-27 Thread Dave Watts
Are there any other tags that do that automatically? Not that I'm aware of, but I could be wrong. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest

number format mask

2010-04-27 Thread Matthew P. Smith
#numberformat(variables.ordertotal, .99)# Does this limit the left of the decimal place to 4 digits? Or am I good no matter how large the number. Sorry, the CFWACK docs are a bit off i think. ~| Want to reach the

Re: number format mask

2010-04-27 Thread Eric Cobb
Try it and see: cfset variables.ordertotal = 100 cfoutput#numberformat(variables.ordertotal, .99)#/cfoutput Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Matthew P. Smith wrote: #numberformat(variables.ordertotal, .99)# Does this

HTTP Upload Problems

2010-04-27 Thread John Foster
We are running a marketplace on ColdFusion8 and IIS with a widely geographically distributed user base and have been receiving complaints of issues with some HTTP uploads. Most of the complaints are coming from geographically distant locations from our main datacenter on the US east coast.

Re: HTTP Upload Problems

2010-04-27 Thread John Foster
Here's an excerpt from one of the packet traces showing the problems that the uploads seem to be stumbling on: 33400 277.18 10.162.147.150 169.254.169.254 TCP 49210 http [FIN, ACK] Seq=98 Ack=234 Win=65280 Len=0 33401 277.18 169.254.169.254 10.162.147.150 TCP http 49210 [ACK]

best way to extract these values

2010-04-27 Thread Matthew P. Smith
Response from paypal api: TOKEN=EC%2d56976134UR2195446TIMESTAMP=2010%2d04%2d27T22%3a22%3a01ZCORRELATIONID=e719ae821503cACK=SuccessVERSION=60%2e0BUILD=1268624 What is the easiest/best way to get each of these values? ~| Want

Re: best way to extract these values

2010-04-27 Thread Dorioo
Here is what I use. - Gabriel !-- Create struct to hold values --- cfset responseStruct = structNew() !--- Treat the string as a list delimited by ampersands --- cfloop list=#nvpString# index=aNVPPair delimiters= !--- Treat each pair as a list delimited by equal signs. The key is

Re: best way to extract these values

2010-04-27 Thread Matthew P. Smith
Awesome. Thank you. On Tue, Apr 27, 2010 at 5:28 PM, Dorioo dor...@gmail.com wrote: Here is what I use. - Gabriel !-- Create struct to hold values --- cfset responseStruct = structNew() !--- Treat the string as a list delimited by ampersands --- cfloop list=#nvpString# index=aNVPPair

Mail sent via cfmail flagged as spam

2010-04-27 Thread Paul H
Hi, I've been using the same cfmail script that loops through and sends one at a time to members of a mailing list for years but lately hotmail, yahoo and even Outlook 2007 are flagging all these emails as spam. I know the server itself hasn't been black listed. I am entering a subject and have

Re: Mail sent via cfmail flagged as spam

2010-04-27 Thread Brian Thornton
change the mailerid and setup reverse dns for the from address.. Here's some other tips courtesy of Charlie.. http://www.carehart.org/blog/client/index.cfm/2008/4/8/cfmail_messageid_solution_for_CF6and7 On Tue, Apr 27, 2010 at 6:48 PM, Paul H p...@smashedvision.com wrote: Hi, I've been using

Re: CFEclipse on Mac with Subclipse -- unstable?

2010-04-27 Thread denstar
All is well for me on a late 2008 MBP with the super-latest and greatest of both Subclipse and CFEclipse. Have you noticed a pattern? Like, is there a specific file you're working on that seems to have the problem whereas other files don't? I've literally had my CFE instance running for like a

Re: HTTP Upload Problems

2010-04-27 Thread Kym Kovan
On 28/04/2010 07:33, John Foster wrote: Here's an excerpt from one of the packet traces showing the problems that the uploads seem to be stumbling on: 33400 277.18 10.162.147.150 169.254.169.254 TCP 49210 http [FIN, ACK] Seq=98 Ack=234 Win=65280 Len=0 The IP address