RE: [ACFUG Discuss] CFQuery Basics: HELP!
Doug said: I know you, Robert, are a one man army :-) Thanks Doug. Loose a couple battles, win the war. It will pay off one day as I collect checks while sitting on the beach sipping pina colada's! CHARGE! 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: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 10:26 PM To: Carbs Sales&Service Subject: Re: [ACFUG Discuss] CFQuery Basics: HELP! Certainly check into the FastStart ColdFusion class too. I know you, Robert, are a one man army, but the course could really jump start that motor bike. DK On 3/11/07, Charlie Arehart <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Again, I can't stress enough that the gentle teacher could be the "Getting Started Guide". I even recommend it over the WACK as a true first step. No, it's not a teacher, but it's really written in a very gentle hand-holding approach. /Charlie http://www.carehart.org/ <http://www.carehart.org/> _ From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] On Behalf Of Robert Reil Sent: Sunday, March 11, 2007 7:04 AM To: discussion@acfug.org <mailto:discussion@acfug.org> Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP! You are correct Charlie! it worked! query 1 DESCRIPTION1 Fits SUZUKI GS750 Carburetor Repair Kit. DESCRIPTION2 Suzuki 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 - 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> - -- Douglas Knudsen http://www.cubicleman.com <http://www.cubicleman.com> this is my signature, like it? - 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> - <>
RE: [ACFUG Discuss] CFQuery Basics: HELP!
Maybe this fall. Busy season is ramping up. 3 days away from income would be a disaster, 1200$ is something I am scrambling to come up with to make the mortgage. This fall will be a different story. Wish I could swing the time and money as Charlie stated. Someday sure, Now? There is no way. Thanks for thinking about me for that though. I will pitch it to the CFO (wife) though and maybe we will find a way to bite for the next one. I will forward your note as well. Thanks for your continued support guys. You are great! 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 11:16 PM To: Carbs Sales&Service Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP! Ah, good point, Doug. I guess my sense was that Robert might be reluctant to make the investment (in time and money), but you're certainly right that it would be a good thing for him and indeed any new CF Developer. In fact, as I've mentioned at the CFUG a couple times, I do teach that class (called "FastTrack to ColdFusion"), right there in the facility where the UG meeting is held (the classrooms are in the front of the building). This is, of course, the official Adobe curriculum, and I'll point out that it's also offered by others in Atlanta. But if Robert or anyone else is interested in attending my class in particular, the class description is at: http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/cla ss-descriptions/coldfusion-courses/fast-track-to-coldfusion-mx-7/index.cfm <http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/cl ass-descriptions/coldfusion-courses/fast-track-to-coldfusion-mx-7/index.cfm> And the details and registration form, for the April 3-5 class are at: http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/reg istration/index-cfm <http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/re gistration/index-cfm&&method=home.ShowRegistrationForm&CourseID=104D36E1-999 0-7A20-5365AA6FC616FD93> &&method=home.ShowRegistrationForm&CourseID=104D36E1-9990-7A20-5365AA6FC616F D93 Thanks for mentioning it, Doug. /Charlie http://www.carehart.org/ <http://www.carehart.org/> _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Sunday, March 11, 2007 10:25 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFQuery Basics: HELP! Certainly check into the FastStart ColdFusion class too. I know you, Robert, are a one man army, but the course could really jump start that motor bike. DK - 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> - <>
RE: [ACFUG Discuss] CFQuery Basics: HELP!
Ah, good point, Doug. I guess my sense was that Robert might be reluctant to make the investment (in time and money), but you're certainly right that it would be a good thing for him and indeed any new CF Developer. In fact, as I've mentioned at the CFUG a couple times, I do teach that class (called "FastTrack to ColdFusion"), right there in the facility where the UG meeting is held (the classrooms are in the front of the building). This is, of course, the official Adobe curriculum, and I'll point out that it's also offered by others in Atlanta. But if Robert or anyone else is interested in attending my class in particular, the class description is at: http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/cla ss-descriptions/coldfusion-courses/fast-track-to-coldfusion-mx-7/index.cfm And the details and registration form, for the April 3-5 class are at: http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/reg istration/index-cfm <http://www.echoeleven.com/go.cfm?path=/go/macromedia-authorized-training/re gistration/index-cfm&&method=home.ShowRegistrationForm&CourseID=104D36E1-999 0-7A20-5365AA6FC616FD93> &&method=home.ShowRegistrationForm&CourseID=104D36E1-9990-7A20-5365AA6FC616F D93 Thanks for mentioning it, Doug. /Charlie http://www.carehart.org/ _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Sunday, March 11, 2007 10:25 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFQuery Basics: HELP! Certainly check into the FastStart ColdFusion class too. I know you, Robert, are a one man army, but the course could really jump start that motor bike. DK - 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] CFQuery Basics: HELP!
Certainly check into the FastStart ColdFusion class too. I know you, Robert, are a one man army, but the course could really jump start that motor bike. DK On 3/11/07, Charlie Arehart <[EMAIL PROTECTED]> wrote: Again, I can't stress enough that the gentle teacher could be the "Getting Started Guide". I even recommend it over the WACK as a true first step. No, it's not a teacher, but it's really written in a very gentle hand-holding approach. /Charlie http://www.carehart.org/ -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Robert Reil *Sent:* Sunday, March 11, 2007 7:04 AM *To:* discussion@acfug.org *Subject:* RE: [ACFUG Discuss] CFQuery Basics: HELP! You are correct Charlie! it worked! query 1 DESCRIPTION1 Fits SUZUKI GS750 Carburetor Repair Kit. DESCRIPTION2 Suzuki 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 - 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 FusionLink <http://www.fusionlink.com> - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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] CFQuery Basics: HELP!
Again, I can't stress enough that the gentle teacher could be the "Getting Started Guide". I even recommend it over the WACK as a true first step. No, it's not a teacher, but it's really written in a very gentle hand-holding approach. /Charlie http://www.carehart.org/ _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Sunday, March 11, 2007 7:04 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFQuery Basics: HELP! 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 - 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] CFQuery Basics: HELP!
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. <>
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 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: 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. - 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] CFQuery Basics: HELP!
Not to one up Doug, but a good practice after his suggestion is also to put in a maxlength on cfqueryparam to the maxlength of the data columns you are referring to. If the maxlength for the SKU column is a varchar(40), then: SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = This is an added check on strings to prevent large strings inadvertantly. The maxlength is for strings and not for numbers. Teddy On 3/9/07, Douglas Knudsen <[EMAIL PROTECTED]> wrote: RIght after SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = '#FORM.sku#' try adding this for testing purposes Also, others may jump on this before I, really should use cfqueryparam SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = Ask Charlie all about the null attribute :) DK On 3/8/07, Robert Reil <[EMAIL PROTECTED]> wrote: > > thanks doug. I tired the products.name but still did not work. Im > tired. Bed time. > > MY DAY IN 1.5 hrs u know!! > I think u see it coming too > > > Robert P. Reil > > Managing Director, > > Motorcyclecarbs.com <http://motorcyclecarbs.com/>, Inc. > > 4292 Country Garden Walk NW > > Kennesaw, Ga. 30152 > > Office 770-974-8851 > > Fax 770-974-8852 > > www.motorcyclecarbs.com > > > -- > *From:* Douglas Knudsen [mailto:[EMAIL PROTECTED] > *Sent:* Thursday, March 08, 2007 9:51 PM > *To:* Carbs Sales&Service > *Subject:* Re: [ACFUG Discuss] CFQuery Basics: HELP! > > > hey, its 2 hours away to your Friday! > > Ok, first off, from the looks of it you are assuming you will always get > one record from this SQL, with your data this maybe a fair assumption, but > be careful of assumptions, they'll bite you someday in code. I'm living > proof carrying many scars from the code dog. > > Now, a couple things with this line: > > > 1) You should always scope your variables, a few rare cases where you > may not want to, but this is definitely not one of them. So change the line > to > > 2) # use, you do not need pounds inside tags and functions unless you > are inside quotes, so change the above to > > 3) Are you always 100% sure your SQL will return at least one row? I'm > guessing in this case it is not. So, need to wrap your line above in a > check for this > > > > > That said, I'd urge you to use CFOUTPUT and its QUERY attribute, then > you can write code not worrying about 1 so much, depending on your situation > of course. This would lead you to something like the below. With this, no > need to use the cfset lines you have and this will work when the SQL has no > records returned. Note also if the SQL returns more than one record, the > cfoutput will loop over all of them for you. > > > >: #form.sku# > #product.Desc1# > >#product.Vend_Name# > > > > #product.Description2# > > > > > > > > > > > HTH! > > DK > > On 3/8/07, Robert Reil < [EMAIL PROTECTED]> wrote: > > > > Well we got somewhere in the WACK group tonight but did not quite > > reach the > > goal. I have a small problem with the following file, can anyone help > > me > > figure out what is wrong with my call for my descriptions and vend > > name? > > > > -- > > > > SELECT Description1, Description2, Vend_Name > > FROM carbs.products > > WHERE sku = '#FORM.sku#' > > > > > > > > Product Search Results > > > > > > > > > > > > > > > > > > SKU: > > > > > > > > > >Products > > > > > > > > > > > > > > : > > #sku# > > > > > > #Desc1# > > > > > > #Vend_Name# > > > > > > > > > > #Description2# > > > > > > > > > > > > > > > > > > - > > Problem is that it gets stuck at: > > Variable DESCRIPTION1 is undefined. > > > > The error occurred in > > C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: > > line > > 20 > > > > 18 : > > 19 : > > 20 : > > 21 : > > 22 : > > > > > > > > > > - > > To unsubscribe from this list, manage your profile @ > > http://www.acfug
Re: [ACFUG Discuss] CFQuery Basics: HELP!
RIght after SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = '#FORM.sku#' try adding this for testing purposes Also, others may jump on this before I, really should use cfqueryparam SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = Ask Charlie all about the null attribute :) DK On 3/8/07, Robert Reil <[EMAIL PROTECTED]> wrote: thanks doug. I tired the products.name but still did not work. Im tired. Bed time. MY DAY IN 1.5 hrs u know!! I think u see it coming too 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 -- *From:* Douglas Knudsen [mailto:[EMAIL PROTECTED] *Sent:* Thursday, March 08, 2007 9:51 PM *To:* Carbs Sales&Service *Subject:* Re: [ACFUG Discuss] CFQuery Basics: HELP! hey, its 2 hours away to your Friday! Ok, first off, from the looks of it you are assuming you will always get one record from this SQL, with your data this maybe a fair assumption, but be careful of assumptions, they'll bite you someday in code. I'm living proof carrying many scars from the code dog. Now, a couple things with this line: 1) You should always scope your variables, a few rare cases where you may not want to, but this is definitely not one of them. So change the line to 2) # use, you do not need pounds inside tags and functions unless you are inside quotes, so change the above to 3) Are you always 100% sure your SQL will return at least one row? I'm guessing in this case it is not. So, need to wrap your line above in a check for this That said, I'd urge you to use CFOUTPUT and its QUERY attribute, then you can write code not worrying about 1 so much, depending on your situation of course. This would lead you to something like the below. With this, no need to use the cfset lines you have and this will work when the SQL has no records returned. Note also if the SQL returns more than one record, the cfoutput will loop over all of them for you. : #form.sku# #product.Desc1# #product.Vend_Name# #product.Description2# > > > HTH! DK On 3/8/07, Robert Reil < [EMAIL PROTECTED]> wrote: > > Well we got somewhere in the WACK group tonight but did not quite reach > the > goal. I have a small problem with the following file, can anyone help me > figure out what is wrong with my call for my descriptions and vend name? > > -- > > SELECT Description1, Description2, Vend_Name > FROM carbs.products > WHERE sku = '#FORM.sku#' > > > > Product Search Results > > > > > > > > > SKU: > > > > >Products > > > > > > > : > #sku# > > > #Desc1# > > > #Vend_Name# > > > > > #Description2# > > > > > > > > > - > Problem is that it gets stuck at: > Variable DESCRIPTION1 is undefined. > > The error occurred in > C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: > line > 20 > > 18 : > 19 : > 20 : > 21 : > 22 : > > > > > - > 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 > - > > > > -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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 FusionLink <http://www.fusionlink.com> - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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] CFQuery Basics: HELP!
thanks doug. I tired the products.name but still did not work. Im tired. Bed time. MY DAY IN 1.5 hrs u know!! I think u see it coming too 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: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:51 PM To: Carbs Sales&Service Subject: Re: [ACFUG Discuss] CFQuery Basics: HELP! hey, its 2 hours away to your Friday! Ok, first off, from the looks of it you are assuming you will always get one record from this SQL, with your data this maybe a fair assumption, but be careful of assumptions, they'll bite you someday in code. I'm living proof carrying many scars from the code dog. Now, a couple things with this line: 1) You should always scope your variables, a few rare cases where you may not want to, but this is definitely not one of them. So change the line to 2) # use, you do not need pounds inside tags and functions unless you are inside quotes, so change the above to 3) Are you always 100% sure your SQL will return at least one row? I'm guessing in this case it is not. So, need to wrap your line above in a check for this That said, I'd urge you to use CFOUTPUT and its QUERY attribute, then you can write code not worrying about 1 so much, depending on your situation of course. This would lead you to something like the below. With this, no need to use the cfset lines you have and this will work when the SQL has no records returned. Note also if the SQL returns more than one record, the cfoutput will loop over all of them for you. : #form.sku# #product.Desc1# #product.Vend_Name# #product.Description2# HTH! DK On 3/8/07, Robert Reil < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: Well we got somewhere in the WACK group tonight but did not quite reach the goal. I have a small problem with the following file, can anyone help me figure out what is wrong with my call for my descriptions and vend name? -- SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = '#FORM.sku#' Product Search Results SKU: Products : #sku# #Desc1# #Vend_Name# #Description2# - Problem is that it gets stuck at: Variable DESCRIPTION1 is undefined. The error occurred in C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: line 20 18 : 19 : 20 : 21 : 22 : - 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 http://www.fusionlink.com <http://www.fusionlink.com> - -- Douglas Knudsen http://www.cubicleman.com <http://www.cubicleman.com> this is my signature, like it? - 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> -
Re: [ACFUG Discuss] CFQuery Basics: HELP!
hey, its 2 hours away to your Friday! Ok, first off, from the looks of it you are assuming you will always get one record from this SQL, with your data this maybe a fair assumption, but be careful of assumptions, they'll bite you someday in code. I'm living proof carrying many scars from the code dog. Now, a couple things with this line: 1) You should always scope your variables, a few rare cases where you may not want to, but this is definitely not one of them. So change the line to 2) # use, you do not need pounds inside tags and functions unless you are inside quotes, so change the above to 3) Are you always 100% sure your SQL will return at least one row? I'm guessing in this case it is not. So, need to wrap your line above in a check for this That said, I'd urge you to use CFOUTPUT and its QUERY attribute, then you can write code not worrying about 1 so much, depending on your situation of course. This would lead you to something like the below. With this, no need to use the cfset lines you have and this will work when the SQL has no records returned. Note also if the SQL returns more than one record, the cfoutput will loop over all of them for you. : #form.sku# #product.Desc1# #product.Vend_Name# #product.Description2# HTH! DK On 3/8/07, Robert Reil <[EMAIL PROTECTED]> wrote: Well we got somewhere in the WACK group tonight but did not quite reach the goal. I have a small problem with the following file, can anyone help me figure out what is wrong with my call for my descriptions and vend name? -- SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = '#FORM.sku#' Product Search Results SKU: Products : #sku# #Desc1# #Vend_Name# #Description2# - Problem is that it gets stuck at: Variable DESCRIPTION1 is undefined. The error occurred in C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: line 20 18 : 19 : 20 : 21 : 22 : - 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 - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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 -