[thelist] database field order with VBScript

[Anthony Baratta]

Joel D Canfield wrote:

> I've lately encountered what seems an oddity. On occasion (or all the
> time, guess I'm not sure) if I assign the values of database fields to
> variables in a different order from the order specified in the 'select'
> statement (or perhaps it's in a different order from the database
> design?) the fields which are out of order don't seem to have any value.
> I'm specifying the field names in the select statement, not selecting
> '*'

If you have any Text field types, accessing the Text column can cause 
all other columns accessed later to return blank.

I always the Text field at the end of the select list and access it 
last. If there are multiples I use the GetRows function to assign the 
list to an array and then access the list.


--
Anthony Baratta

This is clearly another case of too many
mad scientists, and not enough hunchbacks.