Cannot read data from server easily?

J

jodleren

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(8).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?
 
B

Bob Barrows

jodleren said:
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:

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?
You're probably using an obsolete ODBC driver which has the bug you
describe when dealing with columns with TEXT (SQL Server) or Memo (Jet)
datatypes. My recommendation would be to switch to a native OLE DB
provider:

http://www.aspfaq.com/show.asp?id=2126

If that is not possible for some reason, then you need to rewrite the
sql statement used to retrieve the data and put the TEXT column last in
the SELECT list. See:
http://databases.aspfaq.com/databas...memo-text-hyperlink-and-currency-columns.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,794
Messages
2,569,641
Members
45,355
Latest member
SJLChristi

Latest Threads

Top