That should be fine. But just in case, you should search the code base for ftJoin="dmProfile". If there are hits, you'll have to update those fields with the new objectid.
I understand why you didn't say, I'm embarrassed when I look at my own old code too. Blair On Fri, Feb 5, 2010 at 7:02 PM, AJ Mercer <[email protected]> wrote: > 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]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- 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
