Oh man, how simple. Thank you very much Jerome. I guess this goes to show that Bryan's assessment was right.
thank you everyone. hopefully, I won't bring this up again. >Your text values in the query need to have single quote around them. > >-----Original Message----- >From: daniel kessler [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 24, 2007 2:20 PM >To: CF-Talk >Subject: Re: insert error > >> 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'} ) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
