I've been banging my head on the desk this morning looking at this code. I don't know what I'm doing wrong. I can cfdump the data I want, but then I can't output it with cfoutput. Here's the code:
<cfdump var="#userSearch#" >
The cfdump returns the following:
The cfoutput gives this error message: Variable GIVENNAME is undefined.
You have a query with 5 rows in it. It has two columns, called respectively 'Name' and 'Value'. So when you try to access #givenName# it fails because it doesn't know what you're on about.
Instead you'd have to refer to #userSearch.Name# (notice I've query-scoped the column, always a good idea).
If you're specifically wanting to get just the value of the givenName, you could refer to it like this (if you know that it will always be the third column):
NB: this will just output 'givenName'. So you'd maybe rather use #userSearch.Value#
But it would be better to turn your query into a struct. Alternatively, loop over the query. Check the Name column on each iteration of the loop. If Name = 'givenName', output the Value column.