Retrieving 2 or more values from a DB query

[basanth27]

Egun -
You may need to research more about arrays. Look up for arrays and see what exactly it means. you will get more info about the above code and the usage of split function.

The values are already stored in a variable. the variable here is adj. the values are within the variable adj. Each value has a reference point created begining from the location Zero to the max you utilize. So adj(0) will give you the pointer to the first value and adj(1) will give you the pointer to the second one, so forth. This concept is called Arrays. The values stored in an array has a reference point begining from zero.

A simple example would be,

Code:

Dim a

a = Array(10, 20, 30) ' Defining a array
msgbox Isarray(a) ' Should return True

msgbox a(0) ' Should Return 10
msgbox a(1)  ' Should Return 20
msgbox a(2)  ' Should Return 30

Similary, When you Split it stores all the items in an array. Hence you dont have to individually store them in separate variables but just use the same variable with the reference.

Let me know if it helps.