<cfquery name="Update" datasource="db" dbtype="ODBC">
UPDATE tblField
SET
data1='Yes' ,
data2='Yes'
WHERE strUsername='test'
</cfquery>
WG
> From: FlashGuy [mailto:[EMAIL PROTECTED]]
> Hi,
>
> I need to update two fields in my database. For example, I have
> two fields called "data1" and "data2". THe below code updates
> only "data1" field.
> Whats the correct syntax to also update "data2" field at the same time?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
