GUID and CFProcParam

[DeliK]

I have a new client who is using GUID's as the primary key of their Customer
table rather than the integer that most of my other clients use. When passing
a value for one of these GUID's into a SQL Server stored procedure from
ColdFusion, what datatype (cfsqltype) should I use? Is this what
cf_sql_idstamp would be used for? I can't seem to find an explanation of what
the different cfsqltypes mean anywhere. Most are pretty self explanatory, but
others?

Thanks in advance for any light you can shed on this.

[sthompson]

Use cf_sql_char with a max length of 36. GUIDs are 32 characters with 4 hyphens.

I found the following chart awhile back, it's very handy. It's a cross
reference of cf_sql_types to various database data types.

[url]http://www.blinex.com/~sam/CF_SQL_TYPES.cfm[/url]

[DeliK]

Thank you so much for the reply and especially for the chart! That will certainly come in handy!

[mxstu]

sthompson,

Nice reference table. The sql server entries for cf_sql_char and
cf_sql_idstamp look the same. Have you tried using cf_sql_idstamp instead
cf_sql_char ... and if you have ....any problems?

[sthompson]

I haven't done anything with cf_sql_idstamp. We've just always used cf_sql_char. I guess just give it a try. If it blows up, then I would recommend not using it :D.

[mxstu]

Perhaps that's why the idstamp type is mentioned so infrequently ;)

Definitely let me know. I don't have access to sql server db at the moment, but I'm curious about the results. Thanks!