[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