here ya go.
<cfquery name="Update" datasource="db" dbtype="ODBC">
UPDATE tblField
SET data1='Yes', data2='something'
WHERE strUsername='test'
</cfquery>
:)
..tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-----Original Message-----
From: FlashGuy [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 9: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
Get the mailserver that powers this list at http://www.coolfusion.com
