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
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
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
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,
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 ?
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
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
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,
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
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,
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
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
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
13 matches
Mail list logo