Unable to query a Column

[Eileen Tan]

Hi,

Hope someone can help me out with this.

I'm trying to query a column of a table. I'm able to query all columns except 1 particular one (the column is called amount). I'm not sure what is wrong. It always return a null value although there it's not.

Can someone pls help me out?

Set RS_Get = Server.CreateObject("ADODB.Recordset")
RS_Get.Open "SELECT * FROM order_hd where orderID = 41, objConn, 2, 2
Dim amount
amount = RS_Get("amount")