SQL Component

Hi All,



Being a newbie if it comes to workflow solution I'm trying to create a Change Request Form with some built in intelligence.



However I'm stuck on an obviously simple component being the Select Command Component (SQL).



All I want to do is read out the contact information from the Helpdesk Database (+-1500 users).

Because the getallusers-component is not functioning and will probably be way too slow if it should be working I figured out this might have been the best way to go.



When I want to populate a dropdownlist with the values I received, I simply cannot use the output of the sql component within that webform/dropdownlist.

From the debug logging I can see I get a single column with all users included, so my sql query works fine.



As soon as I enter the result set variable name(rows only) within the select command component (local and global), it seems like the following components cannot find that variable anymore. If I right click on a following component and use Browse Data it does not appear anymore... Could this be a bug?!?!



Any assistence will be greatly appreciated.



Thanks in advance,

Slivvv