cfupdate and sql update
Posted on 2004-03-23
cfupdate is working fine with MS ACCESS but when I changed my database to SQL SERVER 2000 for some reason its not working. Is there any way to update the database with cfupdate?
I tried <cfupdate datasource="datasourcename" tablename="tablename" formfields="field1,primarykey"> and working in SQL SERVER 2000 but when I add more form fields its not working.
I tried typical update sql command too but one of my formfield is depend upon the cfif statement like:
<cfif #CourseType# CONTAINS "student" AND #courseName# IS "Onsite">
with this kind of loops cfupdate is working fine but when i use
<cfquery name="update" datasource="databasename">
and its working fine but courserate is not updating in the database. Any help????????