>
> <cftransaction action="">
<cftransaction action="" isolation="serializable">
> <CFQUERY NAME="InsertPropertyDetails" datasource="020">
> INSERT INTO PropertyAgent
> (PropertyAgentCompanyName, PropertyAgentFlatNumberHouseName,
> PropertyAgentStreetNumber, PropertyAgentStreetName,
> PropertyAgentVillageTown, PropertyAgentCountyState,
> PropertyAgentPostcodeZip, PropertyAgentCountry,
> PropertyAgentTelephoneNumber, PropertyAgentContactFirstName,
> PropertyAgentContactSurname, PropertyAgentContactMobile,
> PropertyAgentEmailAddress, PropertyAgentAuthorityLevel,
> PropertyAgentDateAdded, PropertyAgentViewDefinitions,
> PropertyAgentCreatedBy)
> VALUES
> ('#Form.PropertyAgentCompanyName#',
> '#Form.PropertyAgentFlatNumberHouseName#',
> #Form.PropertyAgentStreetNumber#, '#Form.PropertyAgentStreetName#',
> '#Form.PropertyAgentVillageTown#',
> '#Form.PropertyAgentCountyState#',
> '#Form.PropertyAgentPostcodeZip#', '#Form.PropertyAgentCountry#',
> #Form.PropertyAgentTelephoneNumber#,
> '#Form.PropertyAgentContactFirstName#',
> '#Form.PropertyAgentContactSurname#',
> #Form.PropertyAgentContactMobile#,
> '#Form.PropertyAgentEmailAddress#',
> #Form.PropertyAgentAuthorityLevel#, #UKDate#,
> '#GetDefaultViewDefinitions.ViewDefinitions#',
> #Client.PropertyAgentID#)
> </CFQUERY>
>
> <CFQUERY NAME="GetUserID" datasource="020">
> SELECT MAX(PropertyAgentID)
SELECT MAX(PropertyAgentID) AS PropertyAgentID
> FROM
> PropertyAgent
> </CFQUERY>
>
> </cftransaction>
<cfoutput>#GetUserID.PropertyAgentID#</cfoutput>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
