var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Working on a MAC 10.6 using Cocamysql:
I have a table field definition of decimal and the length set to 8,2 to save currency amounts. Works great in the datbas but when I export the text file has "3235302E3030" for an amount of "250.00" when I reload the text file is shows "999999.99.
Originally Posted by oldnickj
3235302E3030 ~is~ 250.00
you seem to be displaying hex
try using the CAST function in your query
(i'm guessing, on account of i can't see your query)
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
CocaMYSql has a hidden function it uses to build the export file. I'm just usingthe Export and import functions.
CoacaMYSQL has been replaced by Sequel Pro which does not make the same mistake.
Ah well... not my fault...
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors