Workflow Soluiton

Hi everyone,

I wonder if there is any way to, when using an costumized sql component, return the data in a specific Datatype, like text.

I getting a array with 350 entries from a sql table, and I have to take this information to a dropdown list. But I can't put this information directly, first I have to convert all the 350 array entries into text (by "Build Text From Elements" component) and then use it in a dropdown list. And this is taking  A LOT of time, making my forms very slow.

Anyone can help ?

Thanks.

You shouldn't have to convert it to text if the resultset has the column that you want to display. Say you have a sql component called sp_get_cities which returns a resultset of name (text), zip (int), area_code (int) and you want to display the name in the drop-down.

You would take a drop-down component and make the datatype sp_get_cities_result or whatever the name of that sql component is and display the name column. In my experience it's quicker if you call the sql component before the form so when you hit the form all the data is already there and makes it quicker to load.

Thanks Aryanos,

I have already tried this, and I get an Exception when i try.

I opened a forum entry about this error, because this is not the only place where it happens.

https://www-secure.symantec.com/connect/forums/no-data-handler-found-type

Do you know anything about this?

Thanks again,

Joao