[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