doesnt display char type data field length 1

[dave]

Hi
I m facing strange problem...
I have one field char type data length 1..
It has data either 1 or 2 in all the field tht I have
checked through enterprise manager.

I'm running query
"select * from table" and fetching all the records and
displaying...
It display all the data except data from this
field..Doesnt display anything..

I had put Response.write rs("fieldname")

What could be the problem?
Any help would be grateful.
Thanx

dave

[Ray at]

What happens when you just do "select [fieldname] from table?"

And then you do:

Response.Write rs.Fields.Item(0).Value

Ray at home

"dave" <an*******@discussions.microsoft.com> wrote in message
news:18*****************************@phx.gbl...

Hi
I m facing strange problem...
I have one field char type data length 1..
It has data either 1 or 2 in all the field tht I have
checked through enterprise manager.

I'm running query
"select * from table" and fetching all the records and
displaying...
It display all the data except data from this
field..Doesnt display anything..

I had put Response.write rs("fieldname")

What could be the problem?
Any help would be grateful.
Thanx

dave

[dave]

Thanx
I found the what the problme was.
Previous field containing null data so it was affecting
next field data...
my code was
<td><%=rs("field0")%></td>
<td><%=rs(field1)%></td>
now if field0 contains null value, then it also doesnt
display field1 data..very strange isnt it??
neway, i found it so no proble..
thanx for your help
dave

-----Original Message-----
What happens when you just do "select [fieldname] from table?"
And then you do:

Response.Write rs.Fields.Item(0).Value

Ray at home

"dave" <an*******@discussions.microsoft.com> wrote in messagenews:18*****************************@phx.gbl...

Hi
I m facing strange problem...
I have one field char type data length 1..
It has data either 1 or 2 in all the field tht I have
checked through enterprise manager.

I'm running query
"select * from table" and fetching all the records and
displaying...
It display all the data except data from this
field..Doesnt display anything..

I had put Response.write rs("fieldname")

What could be the problem?
Any help would be grateful.
Thanx

dave

.