Just to confirm, its working now! :) Its amazing what a fresh set of eyes will do.
On Wed, Mar 2, 2011 at 3:36 PM, Mallory Woods <[email protected]>wrote: > 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:342702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
