Skip to main content
A
Anonymous
October 25, 2013
Question

Problema with Migration CF8 for CF10

  • October 25, 2013
  • 1 reply
  • 623 views

Hi,

After that I installation CF10 FULL STANDART my codes in CF have a problem. Every queries with date not working and to working I have chande for <cfqueryparam ....>, but my application WEB is very big and this very difficult. What I have do? Hotfix? This is a BUG?

This is error:

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.

Thanks,

Eduardo.

    This topic has been closed for replies.

    1 reply

    A
    Aegis_Kleais
    Inspiring
    October 25, 2013

    Are your queries using <cfqueryparam>?  Not only do they help prevent SQL injection, but they'll ensure that you get less issues with datatype conversions.

    By the sound of it, you're attempting to send a string character and interpret it as a datetime.  For example:

    <cfset dateAsString = '2003-09-30' />

    The above is a string object, even though its value looks like a date.  But it's a string, often seen as a varchar by SQL.  Instead, create an actual date object:

    <cfset dateAsDate = createDate( 2003, 9, 30 ) />

    That way, you can pass it in a <cfqueryparam> along with the proper cf_sql_type attribute, and it should be acceptable.

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