If you are only inserting into the address table in this bit of code, you could also serialize the whole thing by using <cflock> around the transaction, but I don't like using application-level locking where I should be using database-level locking.
>Is this the best way to do this: > ><cftransaction> > <cfquery name="InsertAddress" datasource="#DSN#"> > INSERT INTO Address (City) > VALUES (<cfqueryparam value="#City#" cfsqltype="cf_sql_integer" />) > </cfquery> > > <cfquery name="getInsertedID" datasource="#DSN#"> > SELECT MAX(AddressID) as MaxID > FROM Address > </cfquery> ></cftransaction> > >I'm using MySQL. > >Cheers, >Baz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
