Hi,
   I am new to .asp pages and have a basic question. I am trying to code a function which returns multiple values. Here is the scenerio:
The userid and department will be sent to a function. The function will query this info and return 5 fields. These fields are used by the calling form to route processing within the application.

Code example from calling form:
 If strUIDType = "Common" Then
      processCBUnits strUsername, strDepartment
 End if

Function code:
Function processCBUnits(strUsername, strDepartment, byRef strFormNo1, byRef strFormNo2, byRef strFromNo3)

The function then queries the database for appropriate values.

I'd like to send strFormNo1, strFormNo2, and strFormNo3 back to the calling form.

Thanks!

I beleive a function can only return one value. You could return an array and pull the values out. Or you can create a string, and separate each value with a comma, then pull the values out of that.

Also, since you function queries the Db, you can return a recordset which would probably be the best choice.

Well as already advised, array is a good choice. I guess you can also get the function to Return an XML stream and then you can read the stream and pull the values out.

Regards

Thanks for your advise/feedback. I will give that a try. Question: would either of you recommend passing variables back using the 'by ref' keywords?

Thanks in advance for answering...