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
