We use the CF_CSV2Query.. works great for importing CSVs.. even REALLY large ones
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, March 23, 2007 4:52 PM To: [email protected] Subject: RE: [ACFUG Discuss] cfform bug stuck on variable. Awesome! I am interested in buying that tool, But I must ask if you see anything in our form that looks odd... 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] 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&ProductID=c f_csv2query http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv On 3/23/07, Robert Reil <[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.cfm : 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, 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] Atlanta ColdFusion User Group - http://www.acfug.org Atlanta Flash & Flex User Group - http://www.affug.org ------------------------------------------------------------- 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 FusionLink <http://www.fusionlink.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 -------------------------------------------------------------
