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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
