Forum Moderators: coopster

Message Too Old, No Replies

mssql odbc, problem with numbers

         

web_server

11:40 am on May 22, 2006 (gmt 0)



Hi,
I'm using MSSQL ODBC connectivity.I'm having a problem with numbers.
when I insert a number in the data base through my php script, it is inserted correctly . but if I retrive it using SELECT stmt , the number is returend saperated with commas . for example if I insert 1000 it will be returned as 1,000.
I used the types numeric,int ,smallint but nothing works.
any ideas?
thank you in advanced..

omoutop

12:30 pm on May 22, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



You may use number_format() funtion to manipulate the number of yours.

But I can't offer any assistanse as to why the db shows you the numbers in this way.