> <cfif Len(instructorid) AND Len(lastname) AND Len(firstname) AND > len(URL.EID)> > Add data to the db > <cfelse> > Build a query in cf memory of bad data > </cfif>
Also your original logic says _all_ of the values must have a length > 0. So if even one of those values is empty, it will always hit the second step. There is nothing in the code that says "skip the row if all the values are emtpy". Make sense? Janet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
