createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
Hi, im stuck on a problem that i just cannot seem to figure out. I have a script that recieves popsts from the paypal IPN. This is my code for decoding the date/time: cfif isdefined(form.payment_date) cfset payment_date=urldecode(form.payment_date) cfset dl = len(payment_date)

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Russ Michaels
Tony, which line does that error occur on ? the error doesn't really make sense with the code supplied as the only line where you are doing anything with payment_date is cfset payment_date=urldecode(form.payment_date) and this is not doing anything date/time related. Are you sure this error is

CF 9 and .txt files

2012-04-11 Thread Claude Schnéegans
Hi, I have an application (CMS) running fine for about 14 years under CF. In IIS 6, I have set .txt files to be treated by CF as well as .cfm file, so I can use a dynamic Robots.txt file. It has been working nice for years, but now I noticed that all requests for .txt files give an error 405

Re: CF 9 and .txt files

2012-04-11 Thread Dave Watts
Hi, I have an application (CMS) running fine for about 14 years under CF. In IIS 6, I have set .txt files to be treated by CF as well as .cfm file, so I can use a dynamic Robots.txt file. It has been working nice for years, but now I noticed that all requests for .txt files give an error

Re: CF 9 and .txt files

2012-04-11 Thread Russ Michaels
a better solution would probably be to do some URL rewriting so that requests for robots.txt is actually redirects to robots.cfm If you still on IIS6 then you can do this with APE from www.helicontech.com the free version will do what you need. On Wed, Apr 11, 2012 at 6:03 PM, Dave Watts

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Cameron Childress
I saw the same thing Russ saw in your code. The variable payment_date and paymentdate are named similarly, but are not the same. The error appears to be thrown on payment_date, which doesn't appear to interact with createodbcdatetime() in your example code at all. -Cameron On Wed, Apr 11, 2012

Re: CF 9 and .txt files

2012-04-11 Thread Claude Schnéegans
some URL rewriting Is it possible with IIS? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Claude Schnéegans
Are you using CFFORM? I never use it, but I kind of remember there is something special witf input fields containing _date. ~| Order the Adobe Coldfusion Anthology now!

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
Tony, which line does that error occur on ? the error doesn't really make sense with the code supplied as the only line where you are doing anything with payment_date is cfset payment_date=urldecode(form.payment_date) and this is not doing anything date/time related. Are you sure this error is

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
Are you using CFFORM? I never use it, but I kind of remember there is something special witf input fields containing _date. The data is actually being posted back from paypal. Paypal posts to my page with all the transaction vars and i parse them. The script was created by a much more

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Claude Schnéegans
The data is actually being posted back from paypal. Ok, I see. Well the problem is that CF is not able to parse the date in the format supplied by Paypal. Personally, I use createODBCDateTime(Now()) to register the date time. It will be the time related to your sever instead of Paypal's one,

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Russ Michaels
turn on FULL debug output in your cfadmin and it should give you more detail as well as exact line number for the error, in fact a try/catch will do this also. no create a page with a form that posts the exact same data as paypal, and you can use this to debug rather than waiting for paypal.

Re: CF 9 and .txt files

2012-04-11 Thread Russ Michaels
yes, see the rest of my previous reply which said how. On Wed, Apr 11, 2012 at 6:12 PM, wrote: some URL rewriting Is it possible with IIS? ~| Order the Adobe Coldfusion Anthology now!

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
turn on FULL debug output in your cfadmin and it should give you more detail as well as exact line number for the error, in fact a try/catch will do this also. no create a page with a form that posts the exact same data as paypal, and you can use this to debug rather than waiting for paypal.

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
The data is actually being posted back from paypal. Ok, I see. Well the problem is that CF is not able to parse the date in the format supplied by Paypal. Personally, I use createODBCDateTime(Now()) to register the date time. It will be the time related to your sever instead of Paypal's

Re: CF 9 and .txt files

2012-04-11 Thread Claude Schnéegans
You also have to configure CF to do something with them, by editing web.xml. Arhhh ! I knew they would have made it more difficult to do exactly the same thing :-( http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions Ok, I made exactly what is said here, it makes no

Re: CF 9 and .txt files

2012-04-11 Thread Claude Schnéegans
Ok, I made exactly what is said here, it makes no difference. Ok, I restarted IIS and now I get something. Thanks. ~| Order the Adobe Coldfusion Anthology now!

Re: createodbcdatetime change in cf9?

2012-04-11 Thread morgan lindley
What is the actual content of the form.payment_date coming from PayPal? It should be something like '08:38:49 Apr 11, 2012 PDT'. The code below works just fine on that value on CF9 in my testing environment. Without the ' PDT' part, the code tries to run createodbcdatetime() on '08:38:49 Apr 11,

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
What is the actual content of the form.payment_date coming from PayPal? It should be something like '08:38:49 Apr 11, 2012 PDT'. The code below works just fine on that value on CF9 in my testing environment. Without the ' PDT' part, the code tries to run createodbcdatetime() on '08:38:49 Apr 11,

Re: createodbcdatetime change in cf9?

2012-04-11 Thread morgan lindley
What I was saying is, I tested the actual code you originally posted on CF9 with 08:38:49 Apr 11, 2012 PDT as the input and it works fine. I was trying to verify that the data you're working with has the timezone on the end, since the cut portion of the code is designed to remove that, and will

Re: createodbcdatetime change in cf9?

2012-04-11 Thread Tony Paolillo
Thank you for your help. I just added this code into a simple cf page: cfset paymentdate = #createodbcdatetime('08:38:49 April 11, 2012 EST')# and i get an error just loading the page: Parameter validation error for the CREATEODBCDATETIME function. The value of parameter 1, which is currently

Re: createodbcdatetime change in cf9?

2012-04-11 Thread morgan lindley
That needs to be: cfset paymentdate = #createodbcdatetime('08:38:49 April 11, 2012')# The time zone on the end is invalid in CF. On Wed, Apr 11, 2012 at 2:46 PM, Tony Paolillo tpaoli...@gmail.com wrote: cfset paymentdate = #createodbcdatetime('08:38:49 April 11, 2012 EST')#

Re: Can I ask why this place has been taken over by Brian Thornton aka CFDeveloper

2012-04-11 Thread Michael Dinowitz
The list rules were once a week for a job but once every 3 days should be ok. I'm going to email the various people who have been posting daily and put something on the site about it. Eventually I'll have a job posting form rather than allow 'free form' posts. More work but cleaner posts. On

Re: Can I ask why this place has been taken over by Brian Thornton aka CFDeveloper

2012-04-11 Thread Larry C. Lyons
Agreed. I think with Ms. Danes etc is that the positions are hard to fill. Which is unfortunate because Rochester MN is a really nice town, and the projct is a year plus working at the Mayo Clinic. On Wed, Apr 11, 2012 at 3:47 PM, Cameron Childress camer...@gmail.com wrote: If I were to make a