I need to do either an update, or insert. Rather then get a lock, get a
recordcount, and then perform an UPDATE/INSERT based on the result of my
count, I was hoping to just do the update, and if nothing happened then I
know I need to do an insert...
So, the application is written in ColdFusion, and someone suggested doing
this:
<cfquery name="update_recent"
datasource="#variables.local_datasource_name#">
UPDATE user_recent_list
SET access_stamp = now()
WHERE user_id = '#variables.local_user_id#'
AND app_name = '#variables.local_app_name#';
SELECT @@rowcount as rows_updated;
</cfquery>
But this part:
SELECT @@rowcount as rows_updated;
Does not work on Postgres. Does anyone know what the equivalent statement
is for Postgres?
Thanks
Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com