Dear list,

I have a URL variable like so:

<a  
href="viewtasks.cfm? 
insert=closetask&task_id=#task_id#&status_id=2">change status to 2</a>

Going to a CFUPDATE like so:

<CFSWITCH expression="#insert#">
        <CFCASE value="closetask">
                <CFUPDATE datasource="taskomatic" tablename="tasks"
                formfields="task_id, status_id">
        </CFCASE>
</CFSWITCH>

I was hoping it'd change the relevant status_id to 2, but no, it  
doesn't seem to do anything.  Not even give me an error message.  Can  
anybody help?  Is it because the FORMFIELDS aren't actually coming from  
a form?

Thanks in advance,
CK.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192717
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to