I have a form that I submit and returns me about 500 rows. Before inserting into table I check the strings are not null. This means it loops all the strings.Is there a better way that it doesn't have to check all the values?Only wheel_winner will be an empty string, and emp_id will always have a number.<form><cfoutput>    <td><input type=text  name=wheel_winner#CurrentRow# id=sum value=></td>    <td> #emp_namefirst#     <input type=hidden name=emp_id#CurrentRow# value=#emp_id#></td></cfoutput><cfoutput>        <input type=Hidden name=ResCount value=#GetEmployees.RecordCount#></cfoutput></form><!-- after submitting values --><cfloop from=1 to=#ResCount# index=j>    <cfset  emp_id  = #Trim(form[emp_id & j])#>    <cfset  WHEEL_WINNER    = #Trim(form[WHEEL_WINNER & j])#><cfif WHEEL_WINNER neq  and emp_id neq  >        <cfquery datasource=test >            INSERT INTO stamps (emp_id, wheel_winner )            VALUES (<cfqueryPARAM value = #emp_id# CFSQLType = 'CF_SQL_INTEGER'>,             <cfqueryPARAM value = #wheel_winner# CFSQLType = 'CF_SQL_INTEGER'>)        </cfquery></cfif> </cfloop>
Inserting non-empty form values into database
database;form;coldfusion;cfml