November 19, 2008 01:17am pst

1. GrahamSkan 489,054
2. matthews... 388,582
3. PaulHews 327,834
4. RobSamp... 319,732
5. zorvek 310,350
6. jpaulino 283,226
7. Idle_Mind 240,019
8. angelIII 197,709
9. rorya 196,990
10. danaseaman 171,880
11. BlueDevilF... 166,975
12. c0ldfyr3 157,345
13. capricorn1 128,322
14. saurabh726 116,195
15. webtubbs 114,001
16. robinu 112,221
17. TRobinJa... 109,490
18. robberbaron 97,170
19. emoreau 96,058
20. Dhaest 86,719
21. purplepo... 85,982
22. nutsch 83,701
23. chris_bot... 83,347
24. byundt 83,235
25. ee_rlee 81,307

1. Idle_Mind 1,866,555
2. GrahamSkan 1,526,909
3. PaulHews 1,460,773
4. AzraSound 1,400,747
5. angelIII 1,294,935
6. vinnyd79 1,242,790
7. Erick37 1,211,724
8. EDDYKT 1,143,342
9. emoreau 1,120,917
10. matthews... 1,025,038
11. TimCottee 1,010,616
12. BlueDevilF... 905,552
13. ryancys 868,939
14. Ark 856,902
15. egl1044 752,746
16. Shauli 718,021
17. sirbounty 669,716
18. zorvek 628,113
19. zzzzzooc 552,977
20. inthedark 529,097
21. Richie_Si... 508,332
22. RobSamp... 502,917
23. rorya 484,765
24. danaseaman 476,189
25. Dhaest 465,652

05.11.2007 at 02:00PM PDT, ID: 22567569

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.2

return list of values.

Asked by itortu in Visual Basic Programming, Programming Languages

Tags: list, return, values

i need to retrieve a list of clients, store the list in a variable and then use this variable a part of a WHERE IN
clause.

I wrote a small function to get the clients from a view in a sql server database.

Public Function FillClientList()
Dim strSQL As String
Dim Rs As private.Stmt

'Load the Clients
strSQL = "SELECT CLIENT FROM vw_AllClients
Set Rs = Conn.ExecSQL(strSQL)

If (Rs.Cursor) Then
While (Rs.Fetch())
g_strClients = Rs.Value("client")
Wend
End If
End Function

then i call the function from the controler initialize function like this:

FillClientList

and right below that part I test the results using a msgbox

MsgBox g_strClients

the problem is that when the msgbox is displayed, it only displays the last value that was returned by the function instead that showing a string of values like

val1, val2, val3, val4

how can this be fixed, i greatly appreciate your help.

thank you. Start Free Trial

Keywords: return list of values.

	Title
1	The pop-up filter does not filter the na…
2	strsql
3	Expected 'Wend' Error Message
4	While...Wend queston
5	Conn.Execute(strSQL)
6	strSQL

Loading Advertisement...

20081112-EE-VQP-44

return list of values.

Asked by itortu in Visual Basic Programming, Programming Languages

Tags: list, return, values

About this solution