Thanks Carl that was a big DUH on that part for me. I will check it out. Thanks for the help!
On Wed, Mar 2, 2011 at 3:30 PM, Carl Von Stetten <[email protected]>wrote: > > First, you need to move the Truncate query outside the loop. Otherwise > it is being called on each loop iteration, and erasing any records you > inserted on the previous iteration. > > Second, close your table with a </table> tag after the </tr> > > Third, you have a comment about blank rows being invalid, but you have > no tests to trap for this. I'd suggest adding something like this > before the insert transaction: > > <cfif Len(Trim(objSheet.Column1))> > > Then add a </cfif> after the transaction to close the <cfif> tag. > > HTH, > Carl > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
