|
Subject:
|
Strange: get data but canīt see it
|
|
Posted By:
|
rtr1900
|
Post Date:
|
1/11/2006 7:59:52 AM
|
When I do a SELECT i afterwards use the date with rs("field")
But when I want to us it in a "DO WHILE NOT rs.EOF" it seem to loose sometime the data(???)
there are some fields which I canīt retrieve. When I put in front of the "DO WHILE NOT rs.EOF", RESPONSE.WRITE rs("FIELDX") it shows on the screen, if I put it in the "DO WHILE NOT rs.EOF" it doesnīt exists....
Anybody knows what it could be???
Cheers and thx,
David
|
|
Reply By:
|
rtr1900
|
Reply Date:
|
1/11/2006 10:46:03 AM
|
Ok, I found the solutions.
I used "SELECT * FROM CLIENTS WHERE[CONDITIONS]", which gave me zero results.
But if I uses" SELECT name,adress,.... FROM CLIENTS WHERE[CONDITIONS]" if gives me results when I use "rs("field")
Anybody knows why this is? The table has a lot of fields, so is it posible that SQl server only can return an amount of fields?
regards,
David
|
