I'm trying to get a mulitple member picker working also with uComponents autocomplete, but no luck so far, because I don't know how to set the XPath setting to retrieve all (or a subset of) members. The things I tried gave me an error "SQL Server Compact does not support calls to HasRows property if the underlying cursor is not scrollable."
I've not tested it with SQL Server Compact edition, but a quick investigation reveals that a fix might be to try and read the SQL results before testing to see if there are results... (have logged an issue here)
Thank you very much fro your reply! It's not working, so it must be the database that is causing the problem. Google is also showing that more people encounter this problem with CE. Gonna try with MySql... Thanks for logging the issue.
Multiple member picker
Is there a datatype for selecting multiple members?
Hi Jannik, the AutoComplete package can be used to pick multiple members...
Update: The AutoComplete datatype was moved into uComponents.
HTH,
Hendy
Lovely thanks. I haven't seen that before
Hi,
I'm trying to get a mulitple member picker working also with uComponents autocomplete, but no luck so far, because I don't know how to set the XPath setting to retrieve all (or a subset of) members. The things I tried gave me an error "SQL Server Compact does not support calls to HasRows property if the underlying cursor is not scrollable."
Any help on this one pls?
Hi Chizzi,
I've not tested it with SQL Server Compact edition, but a quick investigation reveals that a fix might be to try and read the SQL results before testing to see if there are results... (have logged an issue here)
The XPath to get all members would be:
To get all members of a particular type:
HTH,
Hendy
Thank you very much fro your reply! It's not working, so it must be the database that is causing the problem. Google is also showing that more people encounter this problem with CE. Gonna try with MySql... Thanks for logging the issue.
And it's working with MySql !! :)
How to do it in Umbraco 7?
Thanks
is working on a reply...