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 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/
_____ 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 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 -------------------------------------------------------------
<<attachment: attef230.jpg>>
