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) Gecko/20070216 Firefox/1.5.0.10
Remote Address 10.34.129.103
Referrer 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, Inc.
4292 Country Garden Walk NW
Kennesaw, Ga. 30152
Office 770-974-8851
Fax 770-974-8852
www.motorcyclecarbs.com <http://www.motorcyclecarbs.com/>
