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:
<cfset dl = len(payment_date)>
<cfset cut = dl - 3>
<cfset paymentdate = #createodbcdatetime(paymentdate_temp)#>
The script works fine in CF7 and 8 but kicks an error in CF9. I use cfcatch to snag the error. The error is this:
Error at decoding the payment_date, Expression, , 08:38:49 Apr 11, 2012 is an invalid date or time string.
I cannot figure out what to do to save my live. Can someone please help?
The documentation for createodbcdatetime says that it takes a date as an argument. You are sending a string. The fact that it worked in earlier versions of CF is par for the course. I've had similar upgrading adventures.
There is another function called parsedatetime that might be more appropriate for your situation.
So try using parsedatetimne instead of createodbcdatetimne? Or instead of ulrencode?
Yes. Why not just