It's the date, As Jochem said, use cfqueryparam, should help.
-----Original Message----- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 16:57 To: CF-Talk Subject: Cfquery - whats wrong with this!? 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
