RE: [KCFusion] Assigning unique ID's

[Ramphal, Ron]

Robin,
 
No joy it just sets all values to timestamp when the query started
 
  <CFQUERY NAME="AssignNewID" DATASOURCE = "#ODBC_DSN#">
      UPDATE STImport
      SET uid = '#timeformat(Now(),"hh:mm:sstt")#'
  </CFQUERY>

Other thoughts appreciated
 
Thanks,
Ron.

        -----Original Message----- 
        From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] 
        Sent: Thu 1/24/2002 10:39 AM 
        To: [EMAIL PROTECTED] 
        Cc: 
        Subject: RE: [KCFusion] Assigning unique ID's
        
        
        Maybe you shouldn't use a GUID, use a timestamp of some sort (whatever VFP 
gives you with the finest precision).  It will still free up your "two records that 
look exactly alike" issue.
         
        Just a thought.

        Thanks, 
        Robin Greenhagen 
        President 
        GSI (GreenSoft Solutions, Inc.) 
        http://www.gsi-kc.com/ 

                -----Original Message-----
                From: Ramphal, Ron [mailto:[EMAIL PROTECTED]]On Behalf Of 
Ramphal, Ron
                Sent: Thursday, January 24, 2002 10:28 AM
                To: [EMAIL PROTECTED]
                Subject: RE: [KCFusion] Assigning unique ID's
                
                
                Robin & Ryan,
                 
                I am using Visual Foxpro database for this app, don't believe I have 
any of the operators/functions you mentioned available thru ODBC... :(
                 
                Thanks for the swift replies,
                 
                Ron.

                        -----Original Message----- 
                        From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] 
                        Sent: Thu 1/24/2002 9:47 AM 
                        To: [EMAIL PROTECTED] 
                        Cc: 
                        Subject: RE: [KCFusion] Assigning unique ID's
                        
                        

                        What about running a query like this in SQL Ent Mgr.
                        
                        UPDATE table_name SET new_guid_fld=NEWID()
                        
                        Now you will have a new Unique GUID on each record, and you 
can fix your IDENTITY/INDEX issue.
                        
                        Thanks,
                        Robin Greenhagen
                        President
                        GSI (GreenSoft Solutions, Inc.)
                        http://www.gsi-kc.com/
                        
                        
                        > -----Original Message-----
                        > From: Ramphal, Ron [mailto:[EMAIL PROTECTED]]
                        > Sent: Thursday, January 24, 2002 9:34 AM
                        > To: [EMAIL PROTECTED]
                        > Subject: [KCFusion] Assigning unique ID's
                        >
                        >
                        > Hello,
                        > 
                        > Might be real simple but it eludes me at this moment...
                        > I have a table in which the app somehow managed to assign
                        > duplicate id's to different records, to fix I decided to add
                        > an extra  field and propagate with a guid using CF's
                        > CreateUUID function, can anyone explain how to do the whole
                        > table in one pass, therefore creating a unique id for each 
record?
                        > 
                        > TIA,
                        > 
                        > Ron.
                        > N[  w鲲+Ȳo!♙w
                        > p븸
                        > +    Vry
                        > 
NJq捲zˢ{i۬i)>궶[疖+z~zぁ:&+rzG麺ȞNrzf~Xᶶ鹻&Dz*
                        >
                        N[    b2֧w+^h2םo!wR^Z'p8
                        ܆+޲m   
Vry&
dq
.zϬb{i(䀬ih)
>隊[h+--z~"z+䠁:&ޙ+-rzGȨN'蠲rzf~Xࢬ        
&ޑ*' 




winmail.dat
Description: application/ms-tnef