Re: CF to MySQL stored proc question

["MichaelSJudd" <mikejudd@xxxxxxxxxxxxxxxx>]

Well, when I use the Stored Procedures, I simply access the cfprocresult's 
RecordCount to see if anything was returned. The specifics (from example 2 that 
you had) is:

 <cfif searchResults.RecordCount GT 0>
 do the "yup he's a real guy"
 <cfelse>
 do your failure routine
 </cfif>

 You should get an error message, for instance, if you tried to do a cfoutput 
on that variable, that you are trying to access a complex data type (or 
something like that). So I would try to access the RecordCount as 0 or not 0 if 
you are simply looking to see if it found SOMETHING.

 - Mike