Skip to main content
WolfShade
WolfShade
Legend
July 5, 2012
Answered

CFB2 - RDS Query Viewer 50 row limit

  • July 5, 2012
  • 2 replies
  • 1552 views

Is there any way to increase the maximum number of records returned from within CFB2's RDS Query Viewer?  50 is pretty stifling considering the test queries that I run usually return over 10,000 records.

^_^

This topic has been closed for replies.
Correct answer

No, but you can use SQL Editor which has no limit.

Inside a cfquery, right click and do SQL Editor.


You can check this: http://www.raymondcamden.com/index.cfm/2010/2/19/Video-Using-ColdFusion-Builders-SQL-Editor

2 replies

K
konatala
Participating Frequently
July 6, 2012

As of now  RDS query viewer show max 50 rows, there is an enhancement logged for this #3231028.

itisdesign_-_AH
itisdesign_-_AH
Inspiring
July 6, 2012

konatala wrote:

As of now  RDS query viewer show max 50 rows, there is an enhancement logged for this #3231028.

Hi konatala,

Do you have a URL?  This isn't working for me: https://bugbase.adobe.com/index.cfm?event=bug&id=3231028

It says: "The information requested is not found"

Thanks,

-Aaron

A
Anonymous
Correct answer
July 6, 2012

No, but you can use SQL Editor which has no limit.

Inside a cfquery, right click and do SQL Editor.


You can check this: http://www.raymondcamden.com/index.cfm/2010/2/19/Video-Using-ColdFusion-Builders-SQL-Editor

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices