The types.cfc which you should have extended has a CreateData() function which essentially assigns a new object ID. I often create a custom script that reads in the file and inserts records one by one. Use the CreateUUID() function to generate a new object id
_____ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: Wednesday, January 23, 2008 10:21 AM To: farcry-dev Subject: [farcry-dev] Importing Excel records into new SQL table (Need ObjectIDs) We created a new database table via adding a new type (.cfc file). We've also created the associated admin form in farcry so that add/ edit records. However, for the initial population, we want to import the 134 records into the SQL table from Excel via Enterprise Manager. If we do this, each record will not be assigned an ObjectID. Is there a way to manually generate ObjectIDs? Or better yet, does farcry have a way to import new records into a new database table? Thanks. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.9/1238 - Release Date: 1/22/2008 8:12 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.9/1238 - Release Date: 1/22/2008 8:12 PM --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
