RE: Can this be improved

2012-12-03 Thread Eric Roberts
alk Subject: Re: Can this be improved On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge wrote: > I did not use stored procs because I have having issues with making > them on MySQL since I am new to the db, so I know that is one > improvement that I could make. > In addition to casey&#x

Re: Can this be improved

2012-12-03 Thread Bryan Stevenson
Thanks Cameronand sorry on the portable/better goof ;-) I'd say from what you and Russ have said that there is no urgent need for me to experience the learning curve. I'll swing back and take a peek so I am better informed and give it a fair kick at the can ;-) Cheers On Mon, 2012-12-03 a

Re: Can this be improved

2012-12-03 Thread Bryan Stevenson
Thanks Russ.in my world that is not an issueand I'll stay custom if that's the only benefit. I can re-write T-SQL to PL-SQL in my sleep, but the only place I use PL-SQL is for custom system dev clientsand we are mostly moved to a product based company where our DBs of choice are T-SQL

Re: Can this be improved

2012-12-03 Thread Cameron Childress
On Mon, Dec 3, 2012 at 11:36 AM, Bryan Stevenson < br...@electricedgesystems.com> wrote: > So what is it about ORM that makes this "WAY WAY WAY better" > I didn't say "better", actually, I said "portable" > Why is ORM (or ORM with CF) the magic bullet? Simple real life example? There is no

Re: Can this be improved

2012-12-03 Thread Russ Michaels
ORM should allow your app to run on any database on any platform (MySQL, MSSQL, Oracle) without you having to change any code. Although it doesn't cover all possible queries you may ever need to write, you may still find some instances where ORM doesn't do what you need. On Mon, Dec 3, 2012 at 4

Re: Can this be improved

2012-12-03 Thread Bryan Stevenson
Hey All, I'm curious as to what is behind statements like Cameron's (not picking on you Cameron.just a good example of what I'm talking about) "ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and

Re: Can this be improved

2012-12-03 Thread Cameron Childress
On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge wrote: > I did not use stored procs because I have having issues with making them > on MySQL since I am new to the db, so I know that is one improvement that I > could make. > In addition to casey's comments, I would generally say that using Stored Pr

Re: Can this be improved

2012-12-01 Thread Casey Dougall - Uber Website Solutions
On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge wrote: > Since I have been out of CF dev for several years, I thought I would work > on some simple stuff. Looking at this code below, can this be improved? > I am using CF 10 with MySQL backend. I did not use stored procs because I > have having issue