Where is the date you need to insert coming from as well? A form? and/or is it a literal string like 'Dec. 10, 2010'... or is the form field passing an actual date variable?
Jim Eisenhauer On Fri, Aug 20, 2010 at 9:28 AM, Jim Eisenhauer <eisenha...@gmail.com>wrote: > Is your field in the db set up as a DATE or DATETIME? > > Jim Eisenhauer > > > > On Fri, Aug 20, 2010 at 9:26 AM, Rob Voyle <r...@voyle.com> wrote: > >> >> Hi Folks >> >> I have a coldfusion variable >> expireDate=Dec. 10, 2010 >> >> That I want to insert as a date into a mySql database >> The table cell is set up as a date but I can't find the right cf date >> format to get >> the insert to work. I keep getting a syntax error. >> >> Thanks >> >> Rob >> >> Robert J. Voyle, Psy.D. >> Director, Clergy Leadership Institute >> For Coaching and Training in Appreciative Inquiry >> Author: Core Elements of the Appreciative Way >> http://www.clergyleadership.com/ >> 503-647-2378 or 503-647-2382 >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm