|
|
|
Re: 60 row max displayed in sql results window [message #655024 is a reply to message #654072] |
Fri, 18 February 2011 02:24 |
Kurt Harless Messages: 2 Registered: February 2011 |
Junior Member |
|
|
Greetings,
My stupidity. My loaded .csv had some missing dates that apparently prevent the query from running if you include that row. Interestingly, its stops the entire result set, not just the records with invalid dates. I have worked through my date issues using something like; date_closed = if(strcmp(@date_closed,''),STR_TO_DATE(trim(@date_closed), '%m/%d/%Y'),NULL). Setting it to NULL, which is what I thought STR_TO_DATE did if you found invalid dates, fixed this issue. Go figure. I am now working an EXPORT issue from the legacy DB that creates .CSV's that wrap if a new line or carriage return is embedded in a text field. I plan on exporting it in HEX and then converting it back to VARCHAR to keep the desire formatting. Ohhh what fun! Thanks for all the ideas!
|
|
|
Powered by
FUDForum. Page generated in 0.01209 seconds