Hi,

I'm trying to get a 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

When i call it example like this aParameters(1) I get
Type mismatch: 'aParameters'

I think it's syntax error cause if I have
aParameters = Array("1","2","3")
It would work okay.

I think it's because I'm missing the quotation mark around rsTemp("value"), but if I add the quote around it, the program would not understand that it is a value and not text. What should be the right syntax be?

Thanks

Nevermind. It wasn't working because the recordset was emtpy. But the array syntax didn't work either. I had to use.


aParameters(1) = rsTemp("productThumbnail")
aParameters(2) = rsTemp("productName")
aParameters(3) = rsTemp("productPrice")

Thanks for the info...