Cannot read data from server easily?

Hi

I use ASP, SQL server with a EdgaCam database (that is a CNC tool)

when I read data, I need to read out the fields in the right order,
otherwise they are empty, such as:

rsJob.open="select job.[description],job.[comment],job.[sequence],
job.[nc file], job.[revision],ListJobStatus.[job status],ListJobStatus.
[color], job.[history], job.[Location], job.[programmer] from job LEFT
JOIN ListJobStatus ON job.[list job status]=ListJobStatus.ID where job.
[cam file] like '"+request("part")+"' order by 1"
field0=rsjob.fields(0).value
field1=rsjob.fields(1).value
field2=rsjob.fields(2).value
field3=rsjob.fields(3).value
field4=rsjob.fields(4).value
field5=rsjob.fields(5).value
field6=rsjob.fields(6).value
field7=rsjob.fields(7).value
field8=rsjob.fields(.value
field9=rsjob.fields(9).value


reading out field 1 before 0 will cause 0 to be empty

next, when I use movefirst, it seems like some data gets lost...

what can cuase this?