[thelist] database field order with VBScript

Joel D Canfield joel at spinhead.com
Tue Aug 10 12:22:32 CDT 2004


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


More information about the thelist mailing list