> I can't seem to get CFSTOREDPROC to accept a SQL UUID type
> variable. I've tried CF_SQL_VARCHAR, CF_SQL_CHAR, and
> CF_SQL_IDSTAMP, and they all return an error of "Error
> converting data type varchar to uniqueidentifier." Anyone
> run into this before? The variable in question is a
> MS SQL Server 7 uniqueidentifier datatype.
I suspect that the uniqueidentifier datatype isn't supported by CFPROCPARAM.
As an admittedly ugly workaround, you may be able to change your sp to
accept a varchar parameter, then use CONVERT to change it to
uniqueidentifier.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
