I've got a strange problem with a forward-only recordset.
The front-end is an ASP web. The backend is a sql2005 database.
In the code, there are sql statements using '*'. For example "select *
from
tableA" The recordset is populated using the connection.execute method.
i.e. set rs = conn.execute(sql)
When referencing the fields in the recordset, if they are not referenced
in
the same order as the underlying table, we are getting blanks returned.
If
I use explicit field names in the sql call, it doesn't matter the order of
how we read the rs fields.
Is this the way a forward-only RS works when using a '*' clause??
By the way, I would have used a RS.open(source, etc) instead, but there is
so much of this code, we can't change it unless we have to.
Thanks for your time.
|
