http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T23:06:31 en-us http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Tags-pt219.htm#4249 In some instances, combined with db design and platform, cfqueryparam will throw an error if using cf_sql_numeric and attempting to add a variable that contains a null value. One solution is to always test for a blank field value and use the NULL parameter if a zero-length field value is found.<br /><cfqueryparam cfsqltype="CF_SQL_NUMERIC" value="#form.myField#" null="#YesNoFormat(not Len(form.myField))#"> MattRobertson 0 0 2003-12-01T09:28:12 http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Tags-pt219.htm#3032 The attribute cfsqltype of tag cfqueryparam seems to accept arbitrary values besides those listed. For example cfsqltype="cf_sql_string" or cfsql_type="xxx". It would be better if MX threw an exception, as CF5 did. Alexander Bunkenburg 0 0 2003-10-23T08:01:17