robinalmond
New Member
I'm working on an old classic asp project. The database is structured terribly, each row is well in excess of limits (18 different nvarchar(2000), numerous nvarchar(256), and more...)I made a small fix which changes the order in which the fields are retrieved from the recordset.What I am now seeing has me mystified. Fields that do initially exist disappear as I use other fields.For Example, I have:\[code\]if(RS.Fields('field1').value){ //do something}if((RS.Fields('field2').value){ //do something}\[/code\]In some of my results, field2 is not showing up when checked (after field1), but if I check immediately before field1, it does exist.Is this a known behavior? Is there a work around?