But that is what should happen according to that statement? If any field fails that len(trim()) test by return 0|false then the if statemement is false and it will run the else clause.
Do you mean that empty rows are returning true and getting into the database... or that your false else clause needs to do something else then it is doing. Maybe simplify this to make sure you are getting the logic you want. Just output the fields (with delimiter characters to tell which are empty. And a simple true or false string to confirm this is a problem or maybe something else is. <cfoutput> #instructorID# #len(trim(instructorID))# #lastname# #len(trim(lastname))# #firstname# #len(trim(firstNmae))# <cfif Len(trim(instructorid)) AND Len(trim(lastname)) AND Len(trim(firstname))> TRUE <cfelse> FALSE </cfif/ <BR/> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
