Eclipse Community Forums: DTP » 60 row max displayed in sql results window

Home » Eclipse Projects » DTP » 60 row max displayed in sql results window(DTP with Eclipse 20100218-1602 & DTP 1.7.2 & mysql 5.5.8)

Show: Today's Messages :: Show Polls :: Message Navigator

60 row max displayed in sql results window [message #654072]

Mon, 14 February 2011 01:35

Kurt Harless

Messages: 2
Registered: February 2011

Junior Member

Have a 1000+ row table that is only displaying the first 60 rows in the sql results window. Nothing constraining the rows from the sql perspective, check preferences, Changed max row count to 0 (unlimited?) and max display row row count to 1000000. No help. MYSQL workbench is able to query the table fine using the same sql. What am I doing wrong?

Report message to a moderator

Re: 60 row max displayed in sql results window [message #654450 is a reply to message #654072]

Tue, 15 February 2011 20:20

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

Just to clarify... You're talking about seeing query results in the SQL Results View?

Report message to a moderator

Re: 60 row max displayed in sql results window [message #655020 is a reply to message #654072]

Fri, 18 February 2011 01:15

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

If you execute a query that returns rows, the number of rows displayed
in the SQL Results view is set in the Preferences. The default is 500 rows.

By any chance are you doing a "Sample Contents" action on the table?
(Right click, Data -> Sample Contents). That is limited to 50 returned
rows. If you want to see all the rows you need to run a query against
the table, or edit the table (Data -> Edit).

On 2/13/2011 5:36 PM, Kurt Harless wrote:
> Have a 1000+ row table that is only displaying the first 60 rows in the
> sql results window. Nothing constraining the rows from the sql
> perspective, check preferences, Changed max row count to 0 (unlimited?)
> and max display row row count to 1000000. No help. MYSQL workbench is
> able to query the table fine using the same sql. What am I doing wrong?

Report message to a moderator

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!

Report message to a moderator

Previous Topic:	Oracle DB URL failure, must have slash
Next Topic:	Is it possible to use DTP to connect to server running SSL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 25 08:04:30 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter