THATS IT!!!!! Thanks so much!!!! -->to infinity.!!!!!!!!! Now I can move forward. Thank again to all on this list who have helped in all my stumbles.
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: Ajas Mohammed [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 8:39 AM To: Carbs Sales&Service Subject: Re: [ACFUG Discuss] Variable Undefined. You got that error because when you write <cfoutput>, you are not providing the query name whose OUTPUT you want to display. The correct method is <cfoutput query="product">. Replace your cfoutput with this and see what happens. Ajas Mohammed. On 3/11/07, Robert Reil <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: After all of you guys tutulage I have revised and am having still one problem. Doing a </cfoutput> <cfdump var="#product#" /><cfabort /> the data shows. under the following columns: DESCRIPTION1 DESCRIPTION2 VEND_NAME With this code though: *********** <cfquery name="product" datasource="carbs"> SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = <cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.sku#" maxlength="40" /> </cfquery> <html> <head> <title>Product Search Results</title> </head> <body> <!--- Display search text ---> <cfoutput> <strong>SKU:</strong> <table> <tr> <th colspan="2"> <font size="+2"> Products </font> </th> </tr> <tr bgcolor="##cccccc"> <td> <strong>: #sku# </strong> <br> #Description1# </td> <td> #Vend_Name# </td> </tr> <tr> <td colspan="2"> <font size="-2">#Description2#</font> </td> </tr> </table> </cfoutput> </body> </html> ******************** I get: ******************** SKU: Products : 1234 Error Occurred While Processing Request Variable DESCRIPTION1 is undefined. The error occurred in C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\form1_action.cfm: line 30 28 : </strong> 29 : <br> 30 : #Description1# 31 : </td> 32 : <td> _____ Please try the following: * Check the ColdFusion documentation <http://www.macromedia.com/go/proddoc_getdoc> to verify that you are using the correct syntax. * Search the Knowledge Base <http://www.macromedia.com/support/coldfusion/> to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10 <http://1.8.0.10> ) Gecko/20070216 Firefox/1.5.0.10 Remote Address 10.34.129.103 <http://10.34.129.103> Referrer http://intranet.motorcyclecarbs.com/sales/form1.cfm <http://intranet.motorcyclecarbs.com/sales/form1.cfm> Date/Time 11-Mar-07 06:58 AM Stack Trace at cfform1_action2ecfm1129753331.runPage(C:\Inetpub\wwwroot\intranet.motorcycle carbs.com\sales\form1_action.cfm:30) coldfusion.runtime.UndefinedVariableException: Variable DESCRIPTION1 is undefined. ********************** I have looked at plenty of examples and I can not figure out why #Description1# is not pulling the data. The cfdump shows the data.... What gives? I have tried #products.description1# also but that does not work either. Any ideas? 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 <http://www.motorcyclecarbs.com/> -- <Ajas Mohammed /> http://ajashadi.blogspot.com <http://ajashadi.blogspot.com> ------------------------------------------------------------- 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> -------------------------------------------------------------