Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

SQL Component

Updated: 21 May 2010 | 2 comments
Tommy Van Roye's picture
0 0 Votes
Login to vote

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

discussion Filed Under:

Comments

P. van Leeuwen's picture
20
Nov
2008
0 Votes 0
Login to vote

That has probably something to do with the datatype. Can you give more info on what your sql component returns (datatypes) and how you set up your dropdown? Or maybe pacakage the project and attach it?

Peter van Leeuwen

If your question has been resolved, please be sure to click Mark as Solution! Thank you.

paro's picture
03
Mar
2009
0 Votes 0
Login to vote

Hey slivvv.



Did you get any further with the issues you described?



If so, can you post them here?



Cheers,



Patrik

Project Manager / Founder
Asterio AB, Sweden
www.asterio.se