Newbies WhoIsGregg Posted February 24, 2006 Newbies Posted February 24, 2006 While building a FMP->MySQL PHP script, I've discovered that my FM database has some incorrectly formatted numbers. As I am inserting to a DECIMAL(30,2) field, MySQL is choking on double decimal point input, "2..25" or "0..15" I want to identify and correct all of the screwed up data, but can't figure out how to isolate them. I tried to do a find for the following values and the all turned up "no records found:" .. ".." ==.. =.. *..* .. What find criteria should I be using to find these screwed up records?
Newbies WhoIsGregg Posted February 24, 2006 Author Newbies Posted February 24, 2006 Beautiful! Works perfectly. Thanks!
Recommended Posts
This topic is 6866 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now