I'm trying to get a record into an Array like this :
rsTemp.Open "Select * From list Where pid = " & iItemID
If Not rsTemp.EOF Then
aParameters = Array(rsTemp("productThumbnail"), rsTemp("productName"), rsTemp("productPrice"))
GetItemParameters = aParameters
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?