+5
On Fri, 19 Nov 2004 18:15:25 -0500, Matthew Small <[EMAIL PROTECTED]> wrote: > Wow, I do think that you should rethink your position on the DB as just a > place to store data. T-SQL will seriously increase the processing speed of > your larger queries. If you're doing any kind of nested queries in CF, > T-SQL is the way to go. It's not necessarily the easiest thing to program, > and there are some hoops to jump through on some occasions, but for any data > manipulation that requires more than one query to implement, TSQL is your > best friend from a performance standpoint - and it is front-end neutral as > well. > > > > - Matt Small > > -----Original Message----- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Friday, November 19, 2004 6:07 PM > To: CF-Community > Subject: RE: Advice Needed > > I've done this before, but what my manager wants is for himself to be able > to write the reports. I agree, that this probably should have been made > with stored procs to begin with, but I've always thought that t-sql was > really limited in it's functionality. > > I've always looked at a database as just a place to store data, not > necessarily to manipulate it. Maybe I need to rethink that position. > > > -----Original Message----- > > From: Matthew Small [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 19, 2004 4:49 PM > > To: CF-Community > > Subject: RE: Advice Needed > > > > Hmmm... I don't think it's necessarily a step backwards. Unfortunately, > > your code is usable only on an interface that can use straight text output > > (be it a web page or a comma-delimited file or...) It might have been > > more > > sensible to write them initially as SQL stored procedures and have the > > CFCs > > use those. However, if you really wanted to do the work, you could write > > your own reports that will print out as well as CR. Use CSS to set exact > > font sizes and placement, and then the nested CFOUTPUTs to create > > reports > > that you save as a text file and open in WORD as an HTML file for > > pagination > > and printing. It might save your SQL guy a lot of work. :-) > > > > - Matt Small > > > > -----Original Message----- > > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 19, 2004 5:42 PM > > To: CF-Community > > Subject: Advice Needed > > > > I've just about finished up an app that took several months to complete. > > I've programmed most of the business logic into CFC's. Granted, these > > aren't real complex calculations and such, but there are a lot of them. > > My > > manager wanted to write a report against them and I told him that > > either I > > could make some HTML reports or I could expose the data via web > > services. > > He only wants it in sql views so that he can write Crystal reports against > > them. Is there a better way of doing this? I'm not really complaining > > since it won't be me recreating all of the code since we have a sql guy, > > other than most of my work being worthless :-). It just seems to me that > > this line of thinking is a step backwards. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:5:137244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
