Use to_date(#datevar#,'DD-MON-YYYY) replaceing #datvar# wtht he variable creating that time stamp. Orcale does not like time stamps very much in datetime fields. Also your strings need single quotes...
-----Original Message----- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 1: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:279170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
