This is because the Fields COM object only takes a numeric index, not a string.

Change your SQL statement to read SELECT Nickname FROM TableName WHERE TableID = 1
and then use $com(objFields, Item, 2, int, 0) to retrieve the value stored in that field. You can
also use the Collect method on the objRecordset without creating the objFields using
$com(objRecordset, Collect, 2, int, 0) - remember that the index starts at zero instead of one.


DALnet: #HelpDesk and #m[color:#FF0000]IR[color:#EEEE00]C