Charlie: This whole time I have been an observer. I and Daniel have gone along for the WACK ride weekly for a few hours to get a grasp on the big picture. Now we know what CF is, have an idea of how it works, have tweaked it a little in WACK form and now we are actually doing our FIRST bit of code. Honestly we were estatic when we took a chapter 10 piece of code and just changed some of the cfquery data and got it to hook to my DB. (Gosh what a NOOB!) I know I sound like an idiot on here with these stupid rudimentary questions. Its just after all these months the data in my/our mind is not fresh. I will scan your suggested document and I hope that will be a condensed version of the 15 chapters I have read in the past what must be 6 months. Bottom line: I have to build a sales and purchasing intranet for my company. The funds at this time are not there till we get more efficient. More efficiency will come with this intranet which forces me to do this myself. Thanks for your harshness, and advise.
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 <http://www.motorcyclecarbs.com/> _____ From: Charlie Arehart [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 12:35 AM To: Carbs Sales&Service Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP! Robert, the problem is as that you don't want to be doing that dump and abort inside the cfquery. And as long as you're showing the code, it seems worth asking why you have two cfoutputs (one nested inside the other), and if the query returns multiple records, why are you not making the CFOUTPUT a query loop? And if it returns only one, then even if you don't choose to use a loop, you will need to name prefix the columns when you refer to them after the query. And why are you bothering to copy them into variables after the query? To be honest, I'm quite surprised to see you struggling with these sort of issues, after all these months you've been using CF. Have you been writing code all this time? Or just managing those who do? I think you may have said that you had someone doing work and now you have to do it. If that's the case, it may really pay to revisit something fundamental like the "Getting Started Guide" for CF. It would be great for you both in covering the fundamentals of CFML as well as showing all the great code-generating and time-saving features of Dreamweaver for working with CF. Check it out at: http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_get _started.pdf <http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_ge t_started.pdf> I'm sorry if that sounds a bit harsh. I don't mean it to be. Just being frank. Really, it's in your interest, if you're going to be coding, to get firmer fundamentals before trying to edit your code for business use. You'll just be chasing your tail. Even one day (or just a few hours) spent with that book will pay enormous dividends for you. /Charlie http://www.carehart.org/ <http://www.carehart.org/> _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Saturday, March 10, 2007 10:37 PM To: [email protected] Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP! Boy now I am REALLY CONFUSED! Based on Doug and Teddy's email replies I modied as suggested, I don't understand what I am looking for. Or really what you are doing with the cfdump/cfabort. I know you are trying to see the status of things but the error makes not a bit of sence to me. <snip> ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform <http://www.acfug.org?fa=login.edituserform> For more info, see http://www.acfug.org/mailinglists <http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ <http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink <http://www.fusionlink.com> -------------------------------------------------------------
<<attachment: attef230.jpg>>
