From: jodleren on 7 Jul 2010 07:56
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:
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"
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?
From: Bob Barrows on 7 Jul 2010 09:56
> 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
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:
Prev: Using COM DLLs from SQL
Next: Select Inner.* from nested(outer)-nested(inner) query