I'm curious about a couple of things: - you refer to "two tables(files) in the tdatabase", but being CSV files, there is no "database", right? Do you mean in "the datasource"? If so, why/how would you have two CSV files defined in one datasource? Does anything change if you create two DSNs, one for each file? Or if you flip the order of their definition in the one datasource (or database)? That's just a wild guess. The bigger questions are the two. - when you say things "are outputting" funky, are you outputting them as HTML? Have you looked at the underlying HTML source (in the browser)? Maybe the data is there, but something else is causing them to appear to be "empty". I've seen it happen. As an alternative to doing "view source" all the time, you can also use HTMLCodeFormat in CFML for the output you're generating, to show the resulting HTML on screen as the tags that would be built , rather than seeing the result of the HTML being rendered on screen.
Not much, but hope that helps. /charlie From: [email protected] [mailto:[email protected]] On Behalf Of Dusty Hale Sent: Tuesday, September 07, 2010 9:42 PM To: [email protected] Subject: [ACFUG Discuss] bizarre issue with output from cfquery 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 -- Dusty Hale - President Hale Technologies, Inc. Email: [email protected] Phone (Toll Free USA): 1.877.841.3370 Phone (Atlanta): 1.404.474.3754 Website: www.DustyHale.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
