<cfquery name="Update" datasource="db" dbtype="ODBC">
UPDATE tblField
SET data1='Yes',
data2='No'
WHERE strUsername='test'
</cfquery>
HTH
Clint
----- Original Message -----
From: "FlashGuy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 8:22 AM
Subject: Updating two fields
> 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?
>
>
> <cfquery name="Update" datasource="db" dbtype="ODBC">
> UPDATE tblField
> SET data1='Yes'
> WHERE strUsername='test'
> </cfquery>
>
>
>
>
> ---------------------------------------------------
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---------------------------------------------------
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
