<cfquery name="AgentDetails" datasource="020">
UPDATE
PropertyAgent
SET
PropertyAgentCompanyName = <cfqueryparam
value="#Form.PropertyAgentCompanyName#" cfsqltype="CF_SQL_VARCHAR" />,
PropertyAgentFlatNumberHouseName = <cfqueryparam
value="#Form.PropertyAgentFlatNumberHouseName#"
cfsqltype="CF_SQL_VARCHAR" />,
PropertyAgentStreetNumber = <cfqueryparam
value="#Form.PropertyAgentStreetNumber#" cfsqltype="CF_SQL_NUMERIC" />,
.
.
.
WHERE
PropertyAgentID = <cfqueryparam value="#Client.PropertyAgentID#"
cfsqltype="CF_SQL_NUMERIC" />
</cfquery>
HTH,
--Nathan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
