Hi,

I'm trying to get certain record into an array like this.

Function GetItemParameters(iItemID)
Dim aParameters
rsTemp.Open "Select * From list Where pid = " & iItemID
If Not rsTemp.EOF Then
aParameters = Array(
rsTemp("productThumbnail"),
rsTemp("productName"),
rsTemp("productPrice")
)
GetItemParameters = aParameters
End If
rsTemp.Close
End Function

And then when I call the aParameters, I'm getting this error

Type mismatch: 'aParameters'

So, I think I'm having syntax problem with the array. I know that it would work if I put in

aParameters = Array("1","2","3")

I think it's not working because I'm missing the quotation mark but then it wouldn't understand that it's a record and not text. What's the right syntax to use here?

Thanks