Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
createUUID() into sql server uniqueidentifier field
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162606
anotha fine idea...
thanks dave.
happy weekend everyone!
later.
> so I guess, now ill use createGUID() from cflib, and that'll reformat
> it for me ....
You could let the database generate the UUIDs for you, using the NEWID
function.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
Author: Dave Watts
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162602
> so I guess, now ill use createGUID() from cflib, and that'll
> reformat it for me ....
You could let the database generate the UUIDs for you, using the NEWID
function.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162601
so I guess, now ill use createGUID() from cflib, and that'll reformat it for
me ....
thanks!
tony
oh.
really.
so, If I generate one, using createUUID() and try to insert into that type
of column in sql server its not going to go in ok?
that sucks...no wonder, oh, its micro$oft
> do our cfmx createUUID() uuid's jive with the mssql field/datatype?
The UUID and GUID formats are different
There are minor changes in the layout and length, enough to make them look
completely different
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162598
oh.
really.
so, If I generate one, using createUUID()
and try to insert into that type of column in sql server its not going to go
in ok?
that sucks...no wonder, oh, its micro$oft
> do our cfmx createUUID() uuid's jive with the mssql field/datatype?
The UUID and GUID formats are different
There are minor changes in the layout and length, enough to make them look
completely different
Author: Philip Arnold
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162597
> From: Tony Weeg
>
> do our cfmx createUUID() uuid's jive with the mssql field/datatype?
The UUID and GUID formats are different
There are minor changes in the layout and length, enough to make them
look completely different
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162595
never mind.
I figured it out.
wasn't the problem.
later.
its Friday.
almost time.
later.
do our cfmx createUUID() uuid's jive with the mssql field/datatype?
thanks!
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
tony@navtrak.net
410.548.2337
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32380#162594
do our cfmx createUUID() uuid's jive with the mssql field/datatype?
thanks!
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
tony@navtrak.net
410.548.2337
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
