CF9 beans, cfqueryparam, and dates

I'm using the new bean type of component in CF9 for the first time and I'm running into a frustrating problem when trying to insert into the database (SQL Server 2005). The bean is set up with the following code: cfcomponent name=myBean.cfc hint=This sets and gets properties for my bean

Re: CF9 beans, cfqueryparam, and dates

You have accessors=true on your component right? On Mon, Jan 11, 2010 at 3:05 PM, Scott Brady dsbr...@gmail.com wrote: I'm using the new bean type of component in CF9 for the first time and I'm running into a frustrating problem when trying to insert into the database (SQL Server 2005). The

Re: CF9 beans, cfqueryparam, and dates

I'm not seeing that in the docs for cfcomponent anywhere. I take that back. It's not in my local cfdocs. Awesome. But, that didn't solve the problem. I'm still getting the same error. On Mon, Jan 11, 2010 at 3:19 PM, David Mineer min...@gmail.com wrote: You have accessors=true on your

Re: CF9 beans, cfqueryparam, and dates

I found the problem (or at least a workaround). I changed the cfsqltype to be a timestamp instead of a datetime and that did the trick. Seems a little odd, but at this point, whatever works. Scott On Mon, Jan 11, 2010 at 3:29 PM, Scott Brady dsbr...@gmail.com wrote: I'm not seeing that in

Re: CF9 beans, cfqueryparam, and dates

I found the problem (or at least a workaround). I changed the cfsqltype to be a timestamp instead of a datetime and that did the trick.   Seems a little odd, but at this point, whatever works. There is no cfsqltype named cf_sql_datetime. So CF may be using the default instead cf_sql_char.

Re: CF9 beans, cfqueryparam, and dates

Well, that would explain it then. Obviously, we have a bug in our CFC generator code :) Scott On Mon, Jan 11, 2010 at 4:21 PM, Leigh cfsearch...@yahoo.com wrote: There is no cfsqltype named cf_sql_datetime. So CF may be using the default instead cf_sql_char.  Anyway, you are correct in