Re: find surname from query

["virtually_john"]

with a syntax error (omit the AND in your cfloop statement)

 as long as all the variables are assigned somewhere in the code AND the 
collection exists and has been "<cfindex"ed then it should work fine.