Cant delete a row using a UUID as the PK

[zorg]

I'm trying to delete a row - that uses the datatype unique
identifyer...(SQL2000)
I get an error, I've tried using cfquerypqram (both the varchar and idstamp)
to no avail.

code:
<cfquery name="DeleteInfo" datasource="xxx">
DELETE FROM MembersMessageLog
WHERE ID = '#url.UID#'
</cfquery>

OR
<cfquery name="DeleteInfo" datasource="xxx">
DELETE FROM MembersMessageLog
WHERE ID = <cfqueryparam value="#url.UID#" cfsqltype="CF_SQL_VARCHAR">
</cfquery>

OR
<cfquery name="DeleteInfo" datasource="xxx">
DELETE FROM MembersMessageLog
WHERE ID = <cfqueryparam value="#url.UID#" cfsqltype="CF_SQL_IDSTAMP">
</cfquery>

all yield the same error.....


Executing the SQL statement is not allowed.

The error occurred in D:\FS Clients\ExWivesJewelry.com\Site
Live\ContactSeller.cfm: line 4

2 : <cfquery name="DeleteInfo" datasource="xxx">
3 : DELETE FROM MembersMessageLog
4 : WHERE ID = <cfqueryparam value="#url.UID#"
cfsqltype="CF_SQL_VARCHAR">
5 : </cfquery>

--------------------------------------------------------------------------------
SQL DELETE FROM MembersMessageLog WHERE ID = (param 1)
DATASOURCE xxx

[zorg]

UGH - dissregard.....

I've been using soft deletes....and forgot I set the DSN to not allow deletes....