Hi all. I am working with a cfgrid and keep getting an invalid CF_SQLTYPE for my columns. When i run the <cfgridupdate> for my table, it tells me I have an invalid data type. My columns are all floats, and i'm trying to put in just numbers. i even tried just entering 1 for the columns.

I wouldn't think I would need to use the <cfquery> method.

Ideas?

Make sure the the colum it is designated to is carrying the same credentials as cf sql statement. ill often use var char for more flexibility.
Additionally look at http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p55.htm
because i can see from your question that you have not set all the proper information for cfgridupdate to work as expected.


if i understood your problem correctly...



Enjoy