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]

Re: doesnt display char type data field length 1

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" <anonymous@disc ussions.microso ft.com> wrote in message
news:1817c01c44 9c8$37baeaa0$a0 01280a@phx.gbl. ..[color=blue]
> 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[/color]

[dave]

Re: doesnt display char type data field length 1

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("fiel d0")%></td>
<td><%=rs(field 1)%></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
[color=blue]
>-----Original Message-----
>What happens when you just do "select [fieldname] from[/color]
table?"[color=blue]
>
>And then you do:
>
>Response.Wri te rs.Fields.Item( 0).Value
>
>Ray at home
>
>"dave" <anonymous@disc ussions.microso ft.com> wrote in[/color]
message[color=blue]
>news:1817c01c4 49c8$37baeaa0$a 001280a@phx.gbl ...[color=green]
>> 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[/color]
>
>
>.
>[/color]