Hello fellow friday attendees!
 
I now have this custom tag (thanks to Teddy's reccomendation, 
(
<http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductID
=cf_csv2query>
http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductID=
cf_csv2query ) )
and now I have to install it.
 
I did a google search and didnt really find any step by step info on how to
install it. 
Any pointers out there?
 

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: Teddy Payne [mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] 
Sent: Friday, March 23, 2007 2:45 PM
To: Carbs Sales&Service
Subject: Re: [ACFUG Discuss] cfform bug stuck on variable.

A quick Google Search:

http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail
<http://www.masrizal.com/index.cfm?fuseaction=idea.download_detail&ProductID
=cf_csv2query> &ProductID=cf_csv2query 



On 3/23/07, Robert Reil <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>  > wrote: 

My Day, My Turn. You knew it was coming. Afterall it is FRIDAY!

Studied w/ group last night. Working on building the CSV import tool.

Very basic stuff.

We got the CFQuery roughed in but are trying to detail it and got stuck in
the Form.

We want to call a field from a table and list the entries once.

There are about 4000 rows, but only about a dozen entries.

For some reason we can not seem to get or find data in a google search that
uncovers the following:

Error:

------------------------------------

Variable VEND_NAME is undefined. 

The error occurred in 

C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\development\vendorupdate1.cf
m: line 25
23 :    style = "style specification"
24 :    query = "vendordata"
25 :    value = "#Vend_Name#"
26 : >
27 :   <option
value="#vendordata.Vend_Name#">#vendordata.Vend_Name#</option>
-----------------------------

coldfusion.runtime.UndefinedVariableException: Variable VEND_NAME is
undefined.

---------------------------------------

 

file code shows:

---------------

<!--- Establish parameters for first time through --->
<cfparam name="FORM.vendor" default="0"> 
<cfquery name="vendordata" datasource="carbs"> 
SELECT sku, name, Vend_Name, Vend_Number, Unit_Measure, Deal_Price, Volume,
UnitRetail, UnitPrice, Description1, Description2
FROM carbs.products
WHERE Vend_Name = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#FORM.vendor#" maxlength="40" />
</cfquery>

 

<!-- Some stuff removed for clarity --->

 

<cfform>
<cfselect 
   name = "vendorname"
   style = "style specification"
   query = "vendordata"
   value = "#Vend_Name#"
>
  <option value="#vendordata.Vend_Name#">#vendordata.Vend_Name#</option>
</cfselect>
  <input type="submit" name="Button1" value="Go">
</cfform>

 

Any ideas what we are overlooking?

 

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/>   




-- 
Teddy R. Payne
Adobe Certified ColdFusion MX 7 Developer
Google Talk - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

Atlanta ColdFusion User Group - http://www.acfug.org <http://www.acfug.org> 
Atlanta Flash & Flex User Group - http://www.affug.org
<http://www.affug.org>  
------------------------------------------------------------- 
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>  
------------------------------------------------------------- 


------------------------------------------------------------- 
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>  
------------------------------------------------------------- 




-- 
Teddy R. Payne
Adobe Certified ColdFusion MX 7 Developer
Google Talk - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

Atlanta ColdFusion User Group - http://www.acfug.org <http://www.acfug.org> 
Atlanta Flash & Flex User Group - http://www.affug.org
<http://www.affug.org>  
------------------------------------------------------------- 
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>  
------------------------------------------------------------- 




-- 
Teddy R. Payne
Adobe Certified ColdFusion MX 7 Developer
Google Talk - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

Atlanta ColdFusion User Group - http://www.acfug.org <http://www.acfug.org> 
Atlanta Flash & Flex User Group - http://www.affug.org
<http://www.affug.org>  
------------------------------------------------------------- 
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>  
------------------------------------------------------------- 

Reply via email to