Newbies WhoIsGregg Posted February 24, 2006 Newbies Share 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? Link to comment Share on other sites More sharing options...
comment Posted February 24, 2006 Share Posted February 24, 2006 Try: =*".."* Link to comment Share on other sites More sharing options...
Newbies WhoIsGregg Posted February 24, 2006 Author Newbies Share Posted February 24, 2006 Beautiful! Works perfectly. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6636 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