Well, cfselect functionality should be fine.
On 3/23/07, Robert Reil <[EMAIL PROTECTED]> wrote:
At the moment I am on 6.1. Have not yet upgraded.
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
------------------------------
*From:* Teddy Payne [mailto:[EMAIL PROTECTED]
*Sent:* Friday, March 23, 2007 5:14 PM
*To:* Carbs Sales&Service
*Subject:* Re: [ACFUG Discuss] cfform bug stuck on variable.
For cfselect, you may be over complicating it:
<cfselect name="vendorName" value="Vend_Name" display="Vend_Name" query="
vendorData" />
cfselect produces the options tags for you if you use the value and
display attributes of the cf tag. This is handy when creating really simple
forms. Also, if you put preservedata="true" in your <cfform> a la <cfform
preserveData="true">, if you submit the form to the same page then the
selection you submitted with should stay selected.
This removes a lot of display logic code. preserveData works in CFMX 7
and I am not sure in CFMX 6.1.
On 3/23/07, Justin Haygood <[EMAIL PROTECTED]> wrote:
>
> 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:* discussion@acfug.org
> *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
>
>
>
>
> ------------------------------
>
> *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=cf_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
>
>
>
>
> --
> 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 FusionLink <http://www.fusionlink.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>
-------------------------------------------------------------
--
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 http://www.fusionlink.com
-------------------------------------------------------------
