[thelist] database field order with VBScript
Peter Brunone (EasyListBox.com)
peter at easylistbox.com
Tue Aug 10 13:02:09 CDT 2004
Is there a field of type 'text' or 'memo'? I've heard that
these need to be at the end of the query.
-----Original Message-----
From: thelist-bounces at lists.evolt.org On Behalf Of Joel D Canfield
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