> 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