How come if you use a rs.fields(0).value it sometimes is empty?

[Mike]

Why does this happen:

the code below works fine as-is. If I take out tempValue =
rs.fields(i).value and put rs.fields(i).value everywhere instead, some
fields end up empty!! Why does this happen? I'm using Access.


while not rs.eof
for i = 0 to rs.fields.count - 1
miniId = rs.fields(0).value
statId = i + 1
tempValue = rs.fields(i).value
if (not tempValue = "") And (not isNull(tempValue)) Then
response.write(tempValue & "<br>")
statValue = replace(tempValue, "'", "''")
else
response.write(tempValue & "<br>")
statValue = "--"
end if

[Bob Barrows [MVP]]

Mike wrote:

> Why does this happen:
>
> the code below works fine as-is. If I take out tempValue =
> rs.fields(i).value and put rs.fields(i).value everywhere instead, some
> fields end up empty!! Why does this happen? I'm using Access.

Huh? I don't understand what you are saying. Show us the modification you
are making (and explain the problem you are trying to solve that prompted
you to make the modification)

>
>
> while not rs.eof
> for i = 0 to rs.fields.count - 1
> miniId = rs.fields(0).value
> statId = i + 1
> tempValue = rs.fields(i).value
> if (not tempValue = "") And (not isNull(tempValue)) Then
> response.write(tempValue & "<br>")
> statValue = replace(tempValue, "'", "''")
> else
> response.write(tempValue & "<br>")
> statValue = "--"
> end if

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron [SQL Server MVP]]

Is the column MEMO? [url]http://www.aspfaq.com/2188[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Mike" <mike_newsgroups@yahoo.com> wrote in message
news:6a68ace3.0408111959.3667d6a6@posting.google.c om...

> Why does this happen:
>
> the code below works fine as-is. If I take out tempValue =
> rs.fields(i).value and put rs.fields(i).value everywhere instead, some
> fields end up empty!! Why does this happen? I'm using Access.
>
>
> while not rs.eof
> for i = 0 to rs.fields.count - 1
> miniId = rs.fields(0).value
> statId = i + 1
> tempValue = rs.fields(i).value
> if (not tempValue = "") And (not isNull(tempValue)) Then
> response.write(tempValue & "<br>")
> statValue = replace(tempValue, "'", "''")
> else
> response.write(tempValue & "<br>")
> statValue = "--"
> end if