Good Morning,
Simply use a comma to separate the next database fields/value pair and
continue your list
<cfquery name="Update" datasource="db" dbtype="ODBC">
UPDATE tblField
SET data1='Yes',
data2='anothervalue'
WHERE strUsername='test'
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
