Problema with Migration CF8 for CF10

[Guest]

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.

[Aegis_Kleais]

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.