QueryNew

[emmim44]

Hi guyz,

I am looping thru a read of xls records (POI.cfc) and inserting any warning or error into a session.querynew object... some how come some of elements of querynew object comes as empty even though there enough warnings... Any help appreciated..

     <cfloop query="myResultSet.query">
         <cfif column6 eq "">
         <cfset newRow = QueryAddRow(session.myQuery)>
         <cfset temp = QuerySetCell(session.myQuery, "EID", "#column1#", counterQuery)>
         <cfset temp = QuerySetCell(session.myQuery, "Message",
          " doesnt have a Department", counterQuery)>
        <cfelse>
         <cfset ValDept = Validate.Dept(application.orc,#column6#)>
         <cfif ValDept.recordcount gt 0>
          <cfset DCode= ValDept.dep>
         <cfelse>
          <cfset newRow = QueryAddRow(session.myQuery)>
          <cfset temp = QuerySetCell(session.myQuery, "EID",
           "#column1#", counterQuery)>
          <cfset temp = QuerySetCell(session.myQuery, "Message",
           " Department <i>"& column6
          & "</i> doesnt exist in Database<br>", counterQuery)>        
         </cfif>
        </cfif>
      

        <cfif column7 eq "">
         <cfset newRow = QueryAddRow(session.myQuery)>
         <cfset temp = QuerySetCell(session.myQuery, "EID",
          "#column1#", counterQuery)>
         <cfset temp = QuerySetCell(session.myQuery, "Message",
          " doesnt have a Location", counterQuery)>           
        <cfelse>
         <cfset ValLoc = Validate.Loc(application.orc,#column7#)>
         <cfif ValLoc.recordcount gt 0>
          <cfset LCode= ValLoc.loc>
         <cfelse>
          <cfset newRow = QueryAddRow(session.myQuery)>
          <cfset temp = QuerySetCell(session.myQuery, "EID",
           "#column1#", counterQuery)>
          <cfset temp = QuerySetCell(session.myQuery, "Message",
           " Location <i>"& column7
          & "</i> doesnt exist in Database<br>", counterQuery)>         
          </cfif>
        </cfif>

     <cfset counterQuery = counterQuery + 1>

</cfloop>

[Dan_Bracuk · Accepted solution]

For these commands,

<cfset temp = QuerySetCell(session.myQuery, "EID", "#column1#", counterQuery)>

You are better off using session.myQuery.recordcount to specify the row instead of counterquery.

[emmim44]

Thank you Dan