By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,706 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,706 IT Pros & Developers. It's quick & easy.

doesnt display char type data field length 1

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
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

.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.