I have a custom UD and it creates a dmProfile record
(sorry Blair - I lied)
But I went and created it with the same obJectID as the client record.
So I am thinking I can just run the following script
Then fix refObjects in the webtop
and it will all be good again (given that I have fixed the issue itself as
well that is)
<cfquery name="qryProfile" datasource="#application.dsn#">
SELECT userName
FROM dmProfile
WHERE (userDirectory = 'MYCLIENTUD')
</cfquery>
<cfloop query="qryProfile">
<cfquery name="qryUpdateProfile" datasource="#application.dsn#">
update dmProfile
set objectID = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#APPLICATION.fc.utils.createJavaUUID()#" />
WHERE userName = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#qryProfile.userName#" />
</cfquery>
</cfloop>
--
AJ Mercer
http://webonix.net
http://twitter.com/webonix
--
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
