sp using a uniqueidentifier

[wah222]

when I try to run a stored procedure which contains a select statement I get

[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting from a
character string to uniqueidentifier.

I have tried casting the past param, setting it to CF_SQL_VARCHAR,
CF_SQL_IDSTAMP, ive tried with and without single quotes and still get the same
error. Any help on the correct method of doing this would be helpful.

WAH

[mxstu]

It works fine for me. Is the procedure parameter type "uniqueIdentifier" or
"char"? If it is "char" did you make sure the length is long enough?



create procedure testUUID (@uuid uniqueIdentifier)
as
begin
select titleColumn from yourTable where uuidColumn = @uuid
end
go

<cfset yourUUID = "6F9619FF-8B86-D011-B42D-00C04FC964FF">
<cfstoredproc procedure="testUUID" datasource="#yourDSN#">
<cfprocparam dbvarname="@uuid" cfsqltype="CF_SQL_IDSTAMP" type="in"
value="#yourUUID#">
<cfprocresult name="results">
</cfstoredproc>
<cfdump var="#results#">