>- see footer for list info -< I am trying to use the UniqueIdentifier data type in SQL Server 200 to generate a UUID for each record. But I can't seem to insert it.
Using <cfqueryparam cfsqltype="cf_sql_idstamp" value="#ticketID#"> Where ticket ID = CreateUUID() Results in [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting from a character string to uniqueidentifier. I would use the SQL built in function NEWID() to do it on the database, but then I can't easily select the last inserted record to get my new ID. -- Russ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
