I think the problem will be that MS GUID's in SQL and the UUID's created
using createUUID() are not the same format - the -'s are in different
positions in each, so the only way to store a UUID is to use something like
varchar field, or to parse the UUID to comply with SQL's GUID's...
-----Original Message-----
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 03:37
To: CF-Talk
Subject: CFPROCPARAM - CFSQLTYPE for UniqueIdentifier?
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.
This is the CFPROCPARAM language in question:
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="PageID"
VALUE="#Attributes.PageID#" NULL="No">
This is the stored proc in question:
CREATE PROCEDURE GetPage
@PageID UniqueIdentifier
AS
SELECT PageID,PageName
FROM Pages P
WHERE P.PageID = @PageID
AND P.IsActive = 1
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
