- see footer for list info -<
That's a sillyism of CF. How much effort would it be for them to fix or add
a proper createGUID() function? Anyway, here's how to fix it:
<CFSET newGUID=insert("-", CreateUUID(), 23)>
The above will create a new genuine GUID, compatible with MS SQL for
example.
Gary.
On 11/22/06, Andy Allan <[EMAIL PROTECTED]> wrote:
>- see footer for list info -<
Yeah, is GUID not 36 chars, whereas UUID (from CF) is 35?
Or something.
Quoting Snake <[EMAIL PROTECTED]>:
> >- see footer for list info -<
> It seems a UUID is a different format to a GUID
> So I resorted to a regular identity field for my PK and having the GUID
as a
> separate field.
>
> Russ
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Gene Brown
> Sent: 22 November 2006 15:05
> To: Coldfusion Development
> Subject: RE: [CF-Dev] uniqueIdentifier datatype
>
> >- 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
> >-<
>
>
> _______________________________________________
>
> 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
-<
>
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
www.scottishcfug.com
_______________________________________________
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 -<
