You are correct Charlie! it worked! query
1 DESCRIPTION1 Fits SUZUKI GS750 Carburetor Repair Kit. DESCRIPTION2Suzuki GS750ET, GS750EX, GS750EZ (80-82), GS750LT, GS750LX (80-81), GS750TZ, GS750TD (82-83) Carburetor Repair kit VEND_NAME K&L As to why 2 CFOUTPUT? I really dont know? I thought I used one of Forta's files as a starting point but must have overlooked something. I see my error and have fixed that. Thanks. Im not needing a query loop because I only want to know the data of the SKU which should only show once but now I realize that since it's not a primary key I probably should use a query loop. Will have to put that in there. I was going to reply to why copying into variables after the query but basically I am trying to get this thing to just work. The copying to variables was a test. I realize this is an example of how not to write code and appreciate and welcome further poor structure criticism. I want to write good code, I hope to write good code, and in reality this is the first page I have ever tried to write from scratch. Im using the WACK book for guidance, and guess I overlooked some stuff... To me this CF journey is like trying to learn Calculus with a text book and no teacher. I have occassional tutors, but no real teacher. I just have to get through using the fundamentals now that I am aware of the fundamentals before the fundamentals become part of the way I do things. Be patient with me guys, Ill get there. GO FRIDAY! 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: discussion@acfug.org 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.
<<attachment: attef230.jpg>>