<cfquery name="Update" datasource="db" dbtype="ODBC">
UPDATE tblField
SET data1='Yes', data2='no'
WHERE strUsername='test'
</cfquery>
-----Original Message-----
From: FlashGuy [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 8:22 AM
To: CF-Talk
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
