[thelist] database field order with VBScript

[brian cummiskey]

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
>'*'
>
>Is order important in this case?
>
>joel
>  
>
it depends how you create your recordset.  what are you doing in that 
respect?