Who's that to? :OP Put your code back to the way it was. Comment out the cfquery's that are causing the errors. Add cfoutput's in their place. cfabort after that. Use pre tags to keep the formatting if it helps.
You'll then get the SQL statement as it is being passed to the DB. This will help you find the problem. Ade -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 08 June 2005 17:13 To: CF-Newbie Subject: Re: Update dilemma Okay...so....thank you for that! Would you mind telling me how to fix it? Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1129 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
