Skip to main content
W
WebDevKid
Participant
April 11, 2012
Question

createodbcdatetime problem in cf9

  • April 11, 2012
  • 1 reply
  • 873 views

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)>

       <cfset cut = dl - 3>

       <cfset paymentdate_temp=removechars(payment_date,cut,4)>

      <cfset paymentdate = #createodbcdatetime(paymentdate_temp)#>

</cfif>

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?

Thanks

Tony

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    April 11, 2012

    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.

    W
    WebDevKidAuthor
    Participant
    April 11, 2012

    Hi, Thanks for the reply. So try using parsedatetimne instead of createodbcdatetimne? Or instead of ulrencode?

    Tony

    A
    Adam Cameron.
    Inspiring
    April 11, 2012

    Why would you be urlDecoding a variable that was POSTed, not GETed (excuse the grammar)?

    How is form.payment_date get populated?

    --

    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices