Re: [ACFUG Discuss] SQL Question
Assuming that you have properly joined the two tables you can try adding DISTINCT to the query. A proper join between the tables normally results in distinct rows being return. If you simply include the table names in the FROM clause, you will get a cross-product join which will result in many duplicates. A proper join eliminates the duplicates be only joining rows between the tables where a primary key = a foreign key. Sometimes you can join tables but still need to add DISTINCT ... SELECT DISTINCT * FROM tableA, tableB WHERE tableA.primaryKey = tableB.foreignKey Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] Singles Concepts, Inc. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2007 02:56 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] SQL Question Hey CF Crew, I have a question concerning SQL; I have two database tables. I would like to merge and purge the two tables an end with result table that is free of duplicates. I was seeking a application written in CF. Thanks Michael gifsOwg9WWmJ2.gif Description: GIF image
[ACFUG Discuss] CF vs Velocity
Not meaning to start some thing but here goes and somehow I smell one side of a flame war being sparked. AbleCommerce CFMX5.5 uses Jakarta Velocity to manage dynamic email generation. I have bought 2 books on Velocity and done much searching about Velocity on the net and the more I read I find that it may be an alternative application language to CF. In my application I have: Able Commerce (Java Based Cart) with a CF built Web Output and management application. I am running MySQL4, but will upgrade to 5 when I know it will be ok, and have the time to do it. I use Navicat (and LOVE IT) to manage MySQL. I have a need to develop an intranet to bring AbleCommerce to the level that it isn't, for my application. With all that my mind asks the question... Could Struts and Velocity do the same job? If yes what are the pros and cons? What motivated me to ask this question? I stumbled onto this blog comment at http://weblogs.macromedia.com/cantrell/archives/2003/04/controlling_whi.cfm And if you are on MX, and are using Java, why use CF at all? Just move over to a struts/Velocity/Servlet framework and do away with the crap called ColdFusion. Comments?? PS. Charlie I know its not my day but what the hey? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.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 http://www.fusionlink.com -
Re: [ACFUG Discuss] CF vs Velocity
On 1/21/07, Robert Reil [EMAIL PROTECTED] wrote: AbleCommerce CFMX5.5 uses Jakarta Velocity to manage dynamic email generation. I have bought 2 books on Velocity and done much searching about Velocity on the net and the more I read I find that it may be an alternative application language to CF. You're correct. Velocity is a Java-interpreted web scripting language similar to CF. With all that my mind asks the question... Could Struts and Velocity do the same job? Sure. Struts is an Java-based application framework, analagous to Fusebox or Mach II or Model-Glue. And if you are on MX, and are using Java, why use CF at all? Just move over to a struts/Velocity/Servlet framework and do away with the crap called ColdFusion. What you've stumbled upon is politely called a troll. Both because he's ugly and because the behavior is much like a fisherman in a bass boat moving slowly across a lake trying to get a bite on their line. Notice the name he signed the post with: I Hate CF. Such people are not to be taken seriously when they offer advice. From a more pragmatic point of view, yes, Struts and Velocity could most likely do the same job, as could half-a-dozen or more other frameworks. The question you have to answer is which is best for you. If you have the budget to hire some programmers fluent in the framework in question, then you can debate the merits of the framework. If you don't and you're going to be doing the coding yourself, then you should poke around at Java some and see if you seem more at home than in CF. My bet is that you're better off in CF. -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 http://www.fusionlink.com -
[ACFUG Discuss] DB Application Terms: (Was:) CF vs Velocity
I agree that this TROLL could have been a bit more polite in order to have a better response than the ones he probably got. But it did spark my curiosity as to what all this dynamic web programming is all about. Im still so new and green at this that until you said Java-interpreted Wed Scripting Language I never knew what that phrase meant. LOL. I still am wondering the pros and cons though. Maybe for contemplation, maybe for just general knowledge. Now it seems to me that that layers come into play here and it is all about layers. I remember when I used to teach MCSE 4.0 tract that I spent quite a bit of time on the OSI Model. Mostly on the Networking perspective but I remember there were areas of it that I was cloudy on it, as I would always be working from the physical layer. It stands to reason that there should be some sort of layer management system in the DB to browser Application layer of the OSI Model or something like it. So in trying to understand this stuff I think I need to separate things better. From the terms I have heard used in the past I assume layers kind of lay out like this. Database Scripting Language Brower I am sure there are more layers than this but Im trying to understand. Once I have the layers I will try to understand what all of the technologies I am and may work with so that I can see better what I am working with. This will help me make decisions in the future on how to grown my skills, decisions, and applications in the future. Thanks again. Robert Reil -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: Sunday, January 21, 2007 3:24 PM To: Carbs SalesService Subject: Re: [ACFUG Discuss] CF vs Velocity On 1/21/07, Robert Reil [EMAIL PROTECTED] wrote: AbleCommerce CFMX5.5 uses Jakarta Velocity to manage dynamic email generation. I have bought 2 books on Velocity and done much searching about Velocity on the net and the more I read I find that it may be an alternative application language to CF. You're correct. Velocity is a Java-interpreted web scripting language similar to CF. With all that my mind asks the question... Could Struts and Velocity do the same job? Sure. Struts is an Java-based application framework, analagous to Fusebox or Mach II or Model-Glue. And if you are on MX, and are using Java, why use CF at all? Just move over to a struts/Velocity/Servlet framework and do away with the crap called ColdFusion. What you've stumbled upon is politely called a troll. Both because he's ugly and because the behavior is much like a fisherman in a bass boat moving slowly across a lake trying to get a bite on their line. Notice the name he signed the post with: I Hate CF. Such people are not to be taken seriously when they offer advice. From a more pragmatic point of view, yes, Struts and Velocity could most likely do the same job, as could half-a-dozen or more other frameworks. The question you have to answer is which is best for you. If you have the budget to hire some programmers fluent in the framework in question, then you can debate the merits of the framework. If you don't and you're going to be doing the coding yourself, then you should poke around at Java some and see if you seem more at home than in CF. My bet is that you're better off in CF. -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 http://www.fusionlink.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 http://www.fusionlink.com -
