Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update one field
- Thread starter samauto
- Start date
I believe this will do what you want.
<cfquery name="q1" datasource="myDsn">
update table1
set field1 = '#textValue#'
where recordID = #recNum#
</cfquery>
If the field is a numeric field, change the ='textValue' to = #numberValue#. You put single quotes around text values and leave them off for numeric or date values. If you want to update all the rows and not just a single row, leave off the "where recordID = #recNum#".
Hope this helps,
GJ
<cfquery name="q1" datasource="myDsn">
update table1
set field1 = '#textValue#'
where recordID = #recNum#
</cfquery>
If the field is a numeric field, change the ='textValue' to = #numberValue#. You put single quotes around text values and leave them off for numeric or date values. If you want to update all the rows and not just a single row, leave off the "where recordID = #recNum#".
Hope this helps,
GJ
- Status
Similar threads
- Locked
- Question