How do I find the number of users returned by a cfldap query?

Forum|Forum|16 years ago
July 16, 2009
1 reply
762 views

I'm not allowed to do something like:

I then get an error:

faultCode:Server.Processing faultString:'Unable to invoke CFC - Object of type class coldfusion.tagext.net.LdapResultTable cannot be used as an array' faultDetail:''

Many thanks for any light you can shed

This topic has been closed for replies.

Correct answer ilssac

To expand on Dan's answer.

#results.USNCreated# is a reference to the entire column. Inside of an <cfoutput query=""> OR a <cfloop query=""> loop this short cut is allowed. But if you want to access the record set directly outside of one of these loop structures, you need to use the fully qualified query.column[row] or query["column"][row] syntax.

I.E

<cfqueryparam value="#results.USNCreated[1]#" cfsqltype="cf_sql_varchar">

ilssac

Inspiring

The <cfldap...> tag returns a query result set not an array. Or rather it is a very specialized array.

Anyway you use normal query features just like one you got from a relational database sql statement.

I.E.

<cfoutput>#result.recordCount#</cfoutput>

Or for your example.

nikos101Author

Inspiring

Cheers again Ian for your many helps,

it now won't let me do

I get the message:

faultCode:Server.Processing faultString:'Unable to invoke CFC - Error Executing Database Query.' faultDetail:'[Macromedia][SQLServer JDBC Driver][SQLServer]The name "results.USNCreated" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.'

D

Dan_Bracuk

Inspiring

Depending on what you are attempting, either

specify a row number

or

use a valuelist and set the list attibute to yes.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded