simple sql shows only first digit from int column

[hozyali]

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

[LifeinAsia]

Can you provide the relevant code?

[hozyali]

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