LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-p66.htm http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T22:18:02 en-us coldfusion/6.1/htmldocs/tags-p66.htm http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-p66.htm#31949 If the formFields list contains a single variable name and that variable is an empty string, CFINSERT does not insert any records. Example that does not insert a record: <br /><CFSET Form.myEmptyVar = ""><br /><CFINSERT tableName="myTable" datasource="myDSN" formfields="myEmptyVar"><br /><br />Tested on CFMX 6.1, Windows 2000 server, MySQL 4.1.11, MySQL JDBC 3.0.16. MarkZet 0 0 2005-04-20T10:04:19