Re: [ACFUG Discuss] SQL trace

2006-10-12 Thread Teddy Payne
Charlie has some valid points.  I just roll my own use a framework and there are actually about 4 or 5 Bean, DAO and Gateway generators that turn that work into short work if you like that pattern.Teddy
On 10/12/06, Charlie Arehart <[EMAIL PROTECTED]> wrote:







Chris, as for you getting "a blank page when you get an 
error in your SQL code", are you sure someone hasn't turned on either CFERROR or 
CFTRY/CFCATCH that's intercepting the error and causing this? That's the only 
thing I can imagine. And as for it being a "blank page", have you tried doing a 
"view source" in the browser? It could be that the HTML is just malformed so the 
browser doesn't show it.
 
As for 
wizards, do you really mean "in Studio"? Or Eclipse (which Douglas was referring 
to)? Or DWMX? There are indeed some old wizards in CF Studio but they use very 
old techniques and I'd not recommend them anymore. As for the complexity of the 
CFCPowertools output though, are you referring to their use to CFCs? Or perhaps 
to their using some pattern like getters/setters, or more?
 
This 
is a common problem in the CF world: with all these new approaches to how to 
develop code, people at different levels will look at the same code and one will 
say, "that's too complicated" (such as if they're new to OO development in 
general) while another will say "that's too simplistic" (if they're familiar 
with design patterns and would see a "still better" way to do a thing). Sadly, 
no one solution can satisfy everyone. :-)
 
So 
when you ask for a better process, I'm afraid you have to be a lot more specific 
about what you do (and don't) want. Sorry that it can't be easier than that. 
:-)
 
/charlie
http://www.carehart.org/blog/
 


From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] 
On Behalf Of Chris C. CooperSent: Thursday, October 12, 2006 
1:21 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] 
SQL trace


I'm working on a shared Server and 
don't have access to the Coldfusion Administrator. 

Whenever I have a problem with my 
SQL code I just get a blank page in the browser. Is there some way I can get the 
error message back from the SQL Server displayed in the 
browser?
 
I'm using SQL server 2005 ,CF7. and 
SQL Server Mgmt. Studio and looked to see if there was any logs and don't see 
anything. So I'm kind of working in the dark. 
 
Also I'm doing a lot of forms with a 
lot of fields, is there a way to use the new wizards in Studio to speed this up? 
I usually create the form and get the users signoff on the form then go and code 
CRUD functions. This takes a very long time and is very tedious. The code 
generators I've see seem llike CFCPowertools seem to over complicate this. Does 
anyone have a better process? 
 
 
 
 


-
Chris C. 
Cooper
Cooper 
e.Business Solutions
Atlanta
, 
Georgia 
404.691.4816
 
Cooper 
e.business Solutions – http://www.cooperebusiness.com

 - 
To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform
 
For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink 
- 



-

To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by FusionLink

-



-- Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.org



RE: [ACFUG Discuss] SQL trace

2006-10-12 Thread Charlie Arehart



Chris, as for you getting "a blank page when you get an 
error in your SQL code", are you sure someone hasn't turned on either CFERROR or 
CFTRY/CFCATCH that's intercepting the error and causing this? That's the only 
thing I can imagine. And as for it being a "blank page", have you tried doing a 
"view source" in the browser? It could be that the HTML is just malformed so the 
browser doesn't show it.
 
As for 
wizards, do you really mean "in Studio"? Or Eclipse (which Douglas was referring 
to)? Or DWMX? There are indeed some old wizards in CF Studio but they use very 
old techniques and I'd not recommend them anymore. As for the complexity of the 
CFCPowertools output though, are you referring to their use to CFCs? Or perhaps 
to their using some pattern like getters/setters, or more?
 
This 
is a common problem in the CF world: with all these new approaches to how to 
develop code, people at different levels will look at the same code and one will 
say, "that's too complicated" (such as if they're new to OO development in 
general) while another will say "that's too simplistic" (if they're familiar 
with design patterns and would see a "still better" way to do a thing). Sadly, 
no one solution can satisfy everyone. :-)
 
So 
when you ask for a better process, I'm afraid you have to be a lot more specific 
about what you do (and don't) want. Sorry that it can't be easier than that. 
:-)
 
/charlie
http://www.carehart.org/blog/
 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Chris C. CooperSent: Thursday, October 12, 2006 
1:21 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] 
SQL trace


I’m working on a shared Server and 
don’t have access to the Coldfusion Administrator. 

Whenever I have a problem with my 
SQL code I just get a blank page in the browser. Is there some way I can get the 
error message back from the SQL Server displayed in the 
browser?
 
I’m using SQL server 2005 ,CF7. and 
SQL Server Mgmt. Studio and looked to see if there was any logs and don’t see 
anything. So I’m kind of working in the dark. 
 
Also I’m doing a lot of forms with a 
lot of fields, is there a way to use the new wizards in Studio to speed this up? 
I usually create the form and get the users signoff on the form then go and code 
CRUD functions. This takes a very long time and is very tedious. The code 
generators I’ve see seem llike CFCPowertools seem to over complicate this. Does 
anyone have a better process? 
 
 
 
 
-
Chris C. 
Cooper
Cooper 
e.Business Solutions
Atlanta, 
Georgia 
404.691.4816
 
Cooper 
e.business Solutions – http://www.cooperebusiness.com
 - 
To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform 
For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink 
- 



-

To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by FusionLink

-