Database UUID problems

[jgladnick]

I am modifying the GetSubscribers() function to pull people who have signed up
for specific categories. It works great when I manually put in which blog post
ID to check for, but when I try to use a variable it fails completely.

I have tried several different permutations, including:

WHERE (tblBlogEntries.id = '#localid#')
WHERE (tblBlogEntries.id = #localid#)
WHERE (tblBlogEntries.id = 'N#localid#')
WHERE tblBlogEntries.id = <cfqueryparam value="#arguments.id#"
cfsqltype="CF_SQL_VARCHAR">

Nothing will work. However, if I simply replace it with:
WHERE (tblBlogEntries.id = '975A03C3-B3B3-4221-990A7DC23DFB0545'), where that
string is one of the blog entry id?s, the whole thing works perfectly just as
it should.

Arguments.id IS getting sent to the function, my test emails that send raw
output are getting through. And passing the info correctly.

Am I missing something obvious???

------------code-----------
<cffunction name="getSubscribers" access="public"
returnType="query" output="false"


hint="Returns all people subscribed to a specific blog post.">

<cfargument name="id" type="string" required="true"
hint="The id of the blog entry.">



<cfset var getPeople = "">

<cfset var localid = arguments.id>





<!---<cfqueryparam value="#arguments.id#"
cfsqltype="CF_SQL_VARCHAR">--->



<cfquery name="getPeople"
datasource="#instance.dsn#">



SELECT tblBlogSubscribers.email, tblBlogSubscribers.token

FROM tblBlogSubscribers INNER JOIN

tblBlogSubscriberAssociation ON tblBlogSubscribers.token
= tblBlogSubscriberAssociation.SubscriberID LEFT OUTER JOIN

tblBlogEntriesCategories INNER JOIN

tblBlogEntries ON tblBlogEntriesCategories.entryidfk =
tblBlogEntries.id ON

tblBlogSubscriberAssociation.CategoryID =
tblBlogEntriesCategories.categoryidfk

WHERE (tblBlogEntries.id = '#localid#')





</cfquery>



<cfmail from="test@test.com"
to="jgladnick@pma.com" subject="raw output">

You should get this:



<cfloop query="getpeople">

#email#, #token#

</cfloop>

recordcount: #getpeople.recordcount#

arguement id: #arguments.id#

localid: #localid#

</cfmail>



<cfreturn getPeople>

</cffunction>

[reenaroy]

Hi,

Can you please show me the whole code where you are using this function getSubscribers().

[BKBK]

Nothing will work.
That is probably because the id column in tblBlogEntries has a UUID datatype,
and UUID's may sometimes not work in a comparison operator (=) in a
where-clause. To check if that is the case, temporarily change the datatype to
varchar(35).