[thelist] database field order with VBScript
Peter Brunone (EasyListBox.com)
peter at easylistbox.com
Tue Aug 10 13:36:35 CDT 2004
> 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.
GetRows is *always* a good idea. Stepping through a recordset
can really bog down performance.
-----Original Message-----
From: thelist-bounces at lists.evolt.org On Behalf Of 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.
--
More information about the thelist
mailing list