createUUID() into sql server uniqueidentifier field

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

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

> 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

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

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

> 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

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