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]> 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)
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.motorcyclecarbs.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
--
<Ajas Mohammed />
http://ajashadi.blogspot.com
-------------------------------------------------------------
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
-------------------------------------------------------------
