Welcome to WebmasterWorld Guest from 54.147.44.13

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

simple sql shows only first digit from int column

     
3:04 pm on May 31, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:Aug 7, 2008
posts: 93
votes: 0


Having a strange issue. My sql statement was working fine earlier.
but now it shows only first digit from ID field.

for example if the actual value is 315, it shows only 3

I have nothing special in my code, please help.

thanks
4:06 pm on May 31, 2011 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5550
votes: 24


Can you provide the relevant code?
4:16 pm on May 31, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:Aug 7, 2008
posts: 93
votes: 0


Nevermind. I had an error in my sql statement actually.
I was calling two fields with same name and and different tables. So I had to change the name of the other field. it fixed.

thanks very much