Yep. Use a regular query update and you'll be fine. Emmet
-----Original Message----- From: Chris Kavanagh [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 10:09 PM To: CF-Talk Subject: CFUPDATE-ing without a form 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:192725 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
