[thelist] database field order with VBScript

[Joel D Canfield]

> >Is order important in this case?
> >
> it depends how you create your recordset.  what are you doing in that 
> respect?

Matt: Yup, I've tried just rearranging with no other changes, and values
disappear.

Here's some code:

strQuery = "SELECT WO_NUM, TASK, TYPE, REQUEST, REQDATE, PRIORITY,
RESPONS, DESCRIPT, WO_TEXT1, WO_TEXT2, WO_TEXT3, WO_TEXT4, NOTE, STATUS,
LOOKUP1, PARENTWOID, WOID, WOTYPE2, WOTYPE3 FROM TASKS WHERE WO_NUM = "
& intWO_NUM

Set ListWOs = objConn.Execute(strQuery)

If Not(ListWOs.BOF And ListWOs.EOF) Then
	intWO_NUM = ListWOs("WO_NUM")
	strTASK = ListWOs("TASK")
	strTYPE = ListWOs("TYPE")
	strREQUEST = ListWOs("REQUEST")
	datREQDATE = ListWOs("REQDATE")
	strPRIORITY = ListWOs("PRIORITY")
	strRESPONS = ListWOs("RESPONS")
	strDESCRIPT = ListWOs("DESCRIPT")
	strWO_TEXT1 = ListWOs("WO_TEXT1")
	strWO_TEXT2 = ListWOs("WO_TEXT2")
	strWO_TEXT3 = ListWOs("WO_TEXT3")
	strWO_TEXT4 = ListWOs("WO_TEXT4")
	strNOTE = ListWOs("NOTE")
	strSTATUS = ListWOs("STATUS")
    	strLOOKUP1 = ListWOs("LOOKUP1")
	intPARENTWOID = ListWOs("PARENTWOID")
	intWOID = ListWOs("WOID")
	strWOTYPE2 = ListWOs("WOTYPE2")
	strWOTYPE3 = ListWOs("WOTYPE3")
	
	. . . do stuff . . .
	
End If