>- see footer for list info -<
Russ,
Why not use the Scope_Identity() Method, I use this in my SP's
---
SELECT
@id = [id], -- integer
@uid = uid -- uniqueidentifier
FROM
dbo.TableName
WHERE
[id] = Scope_Identity()
---
Cheers
Gene
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Snake
Sent: Wednesday, November 22, 2006 2:53 PM
To: 'Coldfusion Development'
Subject: [CF-Dev] uniqueIdentifier datatype
>- 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
-<
_______________________________________________
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 -<
