[thelist] database field order with VBScript
Joel D Canfield
joel at spinhead.com
Tue Aug 10 13:21:30 CDT 2004
> >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
More information about the thelist
mailing list