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:279128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
