Skip navigation
Currently Being Moderated

createodbcdatetime problem in cf9

Apr 11, 2012 9:27 AM

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



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?




  • Currently Being Moderated
    Apr 11, 2012 11:50 AM   in reply to WebDevKid

    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.

    Mark as:
  • Currently Being Moderated
    Apr 11, 2012 2:00 PM   in reply to WebDevKid

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


    How is form.payment_date get populated?




    Mark as:
  • Currently Being Moderated
    Apr 12, 2012 5:54 AM   in reply to WebDevKid

    WebDevKid wrote:


    So try using parsedatetimne instead of createodbcdatetimne? Or instead of ulrencode?

    Yes. Why not just


    <cfif isdefined("form.payment_date")>

           <cfset payment_date=parseDatetime(form.payment_date)>


    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points