Re: CFBuilder RDS Query Viewer max rows
Sorry I did not see the CFBuilder forum in the list before posting. I reposted this question there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. On Thu, Mar 25, 2010 at 9:12 AM, Rob Barthle r...@barthle.com wrote: Is there a setting somewhere in CFBuilder where I can increase the max rows returned in the RDS Query View? 50 is not enough for me at times. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 10:38 AM, Raymond Camden rcam...@gmail.com wrote: No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. What SQL Editor view? RDS Query Viewer is only thing I can find and it's limited to 50 records ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Inside a cfquery, right click and do SQL Editor. Here is a video on the topic: http://www.coldfusionjedi.com/index.cfm/2010/2/19/Video-Using-ColdFusion-Builders-SQL-Editor On Thu, Mar 25, 2010 at 9:50 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 10:38 AM, Raymond Camden rcam...@gmail.com wrote: No, but the SQL Editor view has no limit. That's both good and bad obviously. ;) But if you want more than 50, just use it instead. I'd still use a TOP/LIMIT though so you don't get thousands of records. What SQL Editor view? RDS Query Viewer is only thing I can find and it's limited to 50 records ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Inside a cfquery, right click and do SQL Editor. Thanks for the tip. The video show how to build a select with an ORDER BY clause. Is there any provision for more complex clauses and queries like WHERE, GROUP BY, UNION, or JOINs ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
It is a SQL Editor. You can write _anything_. On Thu, Mar 25, 2010 at 10:11 AM, wrote: Inside a cfquery, right click and do SQL Editor. Thanks for the tip. The video show how to build a select with an ORDER BY clause. Is there any provision for more complex clauses and queries like WHERE, GROUP BY, UNION, or JOINs ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
You can write _anything_. Ok, so, if I understand well the editor will just help you to select tables and column names, the rest of the syntax, commands, parenthesis and clauses is up to you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. On Thu, Mar 25, 2010 at 10:52 AM, wrote: You can write _anything_. Ok, so, if I understand well the editor will just help you to select tables and column names, the rest of the syntax, commands, parenthesis and clauses is up to you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 12:10 PM, Raymond Camden rcam...@gmail.com wrote: Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. ok skip sql editor... where is autoComplete / tag insite inside cfquery cfquery name=UpdateLog datasource=#request.dsn# Update Log SET ThisSomthing = cfq does not provide insite for cfqueryparam /cfquery I have to actually do this below the query tag to get insite to work. am I missing something? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. On Thu, Mar 25, 2010 at 11:18 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:10 PM, Raymond Camden rcam...@gmail.com wrote: Right - it gives hinting for table/cols,and color coding. It is not a Visual Query Builder. ok skip sql editor... where is autoComplete / tag insite inside cfquery cfquery name=UpdateLog datasource=#request.dsn# Update Log SET ThisSomthing = cfq does not provide insite for cfqueryparam /cfquery I have to actually do this below the query tag to get insite to work. am I m ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder RDS Query Viewer max rows
I've found that if I click tab, by accident, the CI won't work. I've also found that you can force the CI if you don't see it popup. On my Mac I believe it is command+. (sorry, my muscle memory doesn't always translate to real memory). On Thu, Mar 25, 2010 at 11:43 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! -- === Raymond Camden, ColdFusion Jedi Master Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFBuilder RDS Query Viewer max rows
I have found if I have an error on the page where a line is checked by the little red X CI does not work. Like leave a hanging # inside CFOutput and try CI after that error line. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, March 25, 2010 12:53 PM To: cf-talk Subject: Re: CFBuilder RDS Query Viewer max rows I've found that if I click tab, by accident, the CI won't work. I've also found that you can force the CI if you don't see it popup. On my Mac I believe it is command+. (sorry, my muscle memory doesn't always translate to real memory). On Thu, Mar 25, 2010 at 11:43 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, Mar 25, 2010 at 12:30 PM, Raymond Camden rcam...@gmail.com wrote: I know code insight works for table/col names. I also see CI for cfqueryparam. For example, it showed the arguments, and when I picked cfsqltype, it gave me a list of types. when I start to type cfqueryparam it doesn't always work. It does and doesn't Code insight is really buggy here! -- === Raymond Camden, ColdFusion Jedi Master Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm