> I draw out the date in an Access db and have it in a
> text field to change if I want. Resubmitting it worked
> fine on cf5. On MX I now get a datatype mismatch
> error.
>
> date text: 2004-03-21 09:42:12.0
> sql: dateadded = '#dateadded#'
> db datatype: date/time
>
> Using cfqueryparameter it now works again - I didn't
> use it before. So:
>
> 1) what change was made in MX that I'm getting an
> error?
Everything changed. Since CF MX is written in Java, there is a
complete new JDBC layer in addition to the ODBC layer between your
database and CF.
> 2) when should I use cfqueryparameter? On what
> datatypes? Surely not every single time?
Always, for every datatype, every single time.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
