> Well, that did work and it worked through a few entries, so I suspect > that it's reasonably sound now. > > BUT, it's breaks down on third entry with a "missing comma" entry > again. Back to debugging...
OK, I have Teddy's suggestion going and the one that's giving the missing comma problem is displayed below. I counted them and they both seem to add up to the same number of 'em. The commas all seem to be there too. INSERT INTO fsnep_ha_budgeting ( budgeting_id, login_id,stage, meal_plan, written_budget, check_food, read_ads, grocery_list, unit_pricing, use_coupons, compare_prices, buy_quantity, generic_brands, community_resources, food_eaten, budget_prob_oth, budget_prob_oth_text, interests_comparing, date_added ) VALUES ( unique_ha_budgeting_s.NEXTVAL, 461,1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 1, 1, dont really know how to shop., 1, {ts '2005-01-07 21:25:05'} ) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4