jakebur01 Posted May 3, 2007 Share Posted May 3, 2007 I have a column that has ########0 in all of its fields. How to I get whats in these fields? How do I decode this? P.S. The data originally came out of a mssql database. I now have all of the data in a mysql database and I am using php. `Jake Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted May 3, 2007 Share Posted May 3, 2007 Looks more like query browser (excel) tuncation than any encoded value... widen the columns! I do not know of any mySQL coding that results in #'s. Quote Link to comment Share on other sites More sharing options...
jakebur01 Posted May 3, 2007 Author Share Posted May 3, 2007 The website for the table was built by a big programming company using asp and visual basic. I am now using the products table so I can built another website off it using php. I am having trouble finding the column in the database that holds the quanities of the products. This one column has those #### in it and I am wondering if thats going to be my quanity in there. I was thinking it was just encoded. The table was originally in a mssql database, I migrated it into mysql. It shows #######0 in both databases. `Jake Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted May 4, 2007 Share Posted May 4, 2007 The field in mssql may have been set to # fill values, just update all those values to zero if the value is supposed to be zero. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.