Has anyone ever experienced anything like this: 1. I have an ODBC datasource set up to query comma delimited text files. Works great except ....
2. I have two tables(files) in the tdatabase and both are identical in structure and both have a phone number field. In both tables some of the phone numbers contain dashes and some don't. 3. When I query table one and test the output, no problem, works great. When I query table two, also works fine except one very bizarre thing. The phone numbers with dashes are outputting as empty or null. Phone numbers that don't have dashes output as normal. So I've been struggling with this issue and don't see how it's possible being that both table are identical in structure. Since they're not identical in data, I assume it has to be something data related but still can find nothing wrong. Does anyone have any experience with CF and using text files as a database and had a problem like this. Any thought or advice is greatly appreciated. Kind regards, Dusty
