Jump to content


Photo

ftpget and load data infile issue


  • Please log in to reply
No replies to this topic

#1 dootch

dootch
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 04 April 2006 - 10:12 PM

I am using ftpget to get a price list and using LOAD DATA INFILE to upload it to a mysql db via a script problem is when the price is over 999.99 the price list's it as 1,000.00 with a comma in it. So all products over 1k load into the db as price 1.1 the column is set to decimal 15,2 I have tried to set it as varchar same thing any idea's. I would like this to be automated via a cron job




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users