On that mote, try putting square brackets around On if you don't want to change the column name. I don't know if that works in mysql but it would in access and sql2k.
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 12:12 PM To: CF-Talk Subject: Re: Cfquery - whats wrong with this!? "ON" is a reserved word. You shouldn't use it as a field name. Also, use cfqueryparam for parameters. At 04:56 PM 1/17/2003, you wrote: >Hello > >I've just moved from access to mysql, and I'm noticing that a lot of my >insert queries aren't working, and I cant figure out why!! > >For example... > > <cfquery name="log" connection info here> > INSERT INTO Log > (Action, On, StaffUser) > VALUES ('#description#', #now()#, '#getstaff.name#') > </cfquery> > >Updates work fine, as do selects etc, but why isnt this (or any other) >insert working?! > >Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
