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?
------------------------------
<cfquery name="product" datasource="carbs">
SELECT Description1, Description2, Vend_Name
FROM carbs.products
WHERE sku = '#FORM.sku#'
</cfquery>
<html>
<head>
<title>Product Search Results</title>
</head>
<body>
<cfset desc1 = #Description1#>
<cfset desc2 = #Description2#>
<cfset vendor = #Vend_Name#>
<!--- Display search text --->
<cfoutput>
<strong>SKU:</strong>
<table>
<tr>
<th colspan="2">
<font size="+2">
Products
</font>
</th>
</tr>
<cfoutput>
<tr bgcolor="##cccccc">
<td>
<strong>:
#sku#
</strong>
<br>
#Desc1#
</td>
<td>
#Vend_Name#
</td>
</tr>
<tr>
<td colspan="2">
<font size="-2">#Description2#</font>
</td>
</tr>
</cfoutput>
</table>
</cfoutput>
</body>
</html>
-----------------------------
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 : <body>
19 : <cfset sku=#form.sku#>
20 : <cfset desc1 = #Description1#>
21 : <cfset desc2 = #Description2#>
22 : <cfset vendor = #Vend_Name#>
-------------------------------------------------------------
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
-------------------------------------------------------------
