Re: [ACFUG Discuss] ATL Code Camp
I signed up for this a while ago. I will be there and hope to see others there! Teddy Sent from my iPad On Aug 21, 2013, at 12:50 PM, Charlie Arehart char...@carehart.org wrote: Thanks for that heads-up, Doug. I’d missed news of it, even attending some recent MS user groups, sadly. There are at least a couple of interesting topics. Thanks. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Douglas Knudsen Sent: Tuesday, August 20, 2013 8:36 PM To: discussion@acfug.org Subject: [ACFUG Discuss] ATL Code Camp Hey, this is happening this Saturday. Its cheap and packed full of some gems. http://www.atlantacodecamp.org/2013/ Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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 -
Re: [ACFUG Discuss] Images as Blobs
Mike, Have you looked into using cfimage tag to reference, render, or manipulate BLOB data? If I recall, you can directly feed a database call into a cfimge tag. Cheers, Teddy Sent from my iPad On Apr 1, 2013, at 4:12 PM, Mike Staver sta...@fimble.com wrote: I've been thinking about keeping all user-uploaded images in the DB for one of my projects. I know how I will work the process to get them into the DB and keep them off the hard drive. It would go something like: 1) Image uploaded to temp file system location from form post. 2) Image inserted into DB as blob. 3) Temp image removed from file system. Displaying the images is a bit more work I think. I assume I'd have to follow a similar process in reverse: 1) Extract image from DB to temp file system location. 2) Display it in HTML via web server as img tag. 3) Remove image after a certain period of time... Step 3 has me wondering: How long should I wait before removing the image from the file system? Meaning - in theory, I could remove the image before it would even have a chance to display via the web server, and I don't want that. Anybody have a good process to do this already? I'd love if there was a way to display an image directly from the DB, but I'm not aware of such a method. I'll probably just fall back on leaving those images on the file system as part of the display, and have my code check for their existence before retrieving them again. I didn't want to have to worry about the disk space, but I can't think of another way. - 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 - - 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 -
Re: [ACFUG Discuss] coldfusion web hosting
CF-Talk, which is hosted by House of Fusion, has a mail archive: http://www.mail-archive.com/cf-talk%40houseoffusion.com/ This is the archive for the mailing list. I am a subscriber and reader of the list and I have noticed that this question is asked often. It might be a good resource to search through to get a pool of opinions. Teddy On 4/9/07, Kevin [EMAIL PROTECTED] wrote: I use http://www.crystaltech.com/ for several sites. They have great server monitoring systems and let you know when they detect issues. Their control panel is set up very well. I have never had to call customer support to do anything. On 4/9/07, Jeff Osmus [EMAIL PROTECTED] wrote: can anyone suggest cheap, reliable coldfusion web hosting for personal use? - 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 - -- K / -A history of the Universe, the short story: 'Hydrogen is a light, odorless gas, which, given enough time, turns into people.' - 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 -
Re: [ACFUG Discuss] A whole new key for CFEclipse =)
CFEclipse probably won't support WYSIWYG, but as Howard Fore had mentioned that part of the MyEclipse project that there is a designer perspective. You can see a screen shots here: http://www.myeclipseide.com/ContentExpress-display-ceid-54.html On 4/4/07, Robert Reil [EMAIL PROTECTED] wrote: Thanks for that... 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 -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 1:03 PM To: Carbs SalesService Subject: Re: [ACFUG Discuss] A whole new key for CFEclipse =) Then you should probably stick to DW. I don't see CFEclipse fully supporting WYSIWYG in the near future. Many code centric developers felt abandoned when Homesite/CFStudio development ended. DW has never really been acceptable to this group, and that's where CFEclipse really came from - a desire to have a good code centric IDE. -Cameron On 4/4/07, Robert Reil [EMAIL PROTECTED] wrote: Im a windoze wysiwyg gui kinda guy. - 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 - - 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 - -- 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 -
Re: [ACFUG Discuss] cfform bug stuck on variable.
Robert, A custom tag like cf_csv2query refers to a template with the name of cs2query.cfm As Duty said (bummer about the hand), you can either put it in the same folder as the calling page or inside your CF Administrator you can define a custom tag folder other than the default folder to put your custom tags. There is no installation. CF already knows what it is supposed to do. On 3/30/07, Dusty Hale [EMAIL PROTECTED] wrote: i think you should be able to drop the custom tag files into the same folder that you are calling the tag from. or drop them in the customtags folder within your cf server folders. sorry for sloppy typing. broke my right hand and typing in slow motion :( -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Robert Reil *Sent:* Friday, March 30, 2007 12:42 PM *To:* discussion@acfug.org *Subject:* RE: [ACFUG Discuss] cfform bug stuck on variable. Hello fellow friday attendees! I now have this custom tag (thanks to Teddy's reccomendation, (http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=cf_csv2query http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=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 *From:* Teddy Payne [mailto:[EMAIL PROTECTED] *Sent:* Friday, March 23, 2007 2:45 PM *To:* Carbs SalesService *Subject:* Re: [ACFUG Discuss] cfform bug stuck on variable. A quick Google Search: http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=cf_csv2query 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
Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005
I am not sure why the behavior of the cfgrid is getting the value when it queries the data source. Did you check to make sure that the specified column does not have a default value of some type? If 2005 is actually able to send the string null to the cfgrid, then that is indeed a behavior that is odd. When you submit or read data through whichever process, can you perform a quick check for the word null prior to committing and querying to cleanse the data? This may be a band-aid, but would alleviate some frustration to ensure the correct behavior. On 3/29/07, Troy Jones [EMAIL PROTECTED] wrote: While I am not terribly versed in MSSQL, it sounds like it may be treating the word NULL as a varchar or text value? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Thursday, March 29, 2007 1:26 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] cfqueryparam and NULL attribute SQL Server 2005 Tom, Syntax error on my part. It is an UPDATE that I'm doing and not an INSERT. The code I provided is the update statement. As far as the old code, it exists in a backup file but is not present at all in the live code. The behavior that the app is displaying is as follows: 1. If I click into the formfield and DELETE anything in the field and hit submit it passes an empty string to the action page 2. On the action page I have a CFDUMP and I output this here-- #len(trim(Form.assetgrid.equiptype[Row]))# --#yesNoFormat(NOT len(trim(Form.assetgrid.equiptype[Row])))# BR and this is displayed: here-- 0 --Yes 3. Using Management Studio I look into the DB and see *NULL*displayed there in the appropriate column and row. 4. I revisit my CFGRID/CFFORM and the field is blank (the behavior I am expecting) 5. I submit the form again and this time in the CFDUMP I see the word/string null 6. This time for the output of this code: here-- #len(trim( Form.assetgrid.equiptype[Row]))# --#yesNoFormat(NOT len(trim( Form.assetgrid.equiptype[Row])))# I get this: here-- 4 --No 7. When I then look at the DB in Management Studio I see the word/string null in the appropriate column and row. If I run a query against it looking for all with a value of NULL the record is NOT returned. 8. I then load the form again and in the formfield the word/string null now appears. Any ideas what I'm doing wrong or what I'm over looking? thanks in advance, Jeff On 3/29/07, *Tom McNeer* [EMAIL PROTECTED] wrote: Jeff, Bottom line, why is isnerting the string null into my db instead of NULL??? There's nothing in the code you showed that would insert that value. Just a guess, but -- is your old code in place, the code that tried to create null in a string value? You're experiencing the same behavior you describe when using your old code. And the only way that a string value of null would be inserted is if the variable held that value *before* you ran the INSERT. In that case, your yesNoFormat function would return false, because the form variable would have a length. And the string null would be inserted. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com/http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 - 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/mailinglistshttp://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 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
Re: [ACFUG Discuss] cfeclipse crashing?
Did you upgrade your JRE at that time? One suggestion has been to completely uninstall your Java JRE and then get a fresh non-upgrade version. On 3/23/07, Cheyenne Throckmorton [EMAIL PROTECTED] wrote: First off, I'll state that I'm fairly new to Eclipse. I installed it and have really enjoyed its use since being convinced to give it a go after a good discussion about it during the last perimeter cf_lunch (read - shameless plug for cf_lunches). Unfortunately, starting last night, it is crashing constantly. Has anyone else had problems that last few days? The only thing that I can throw out there as a guess to whats going on is that I did upgrade from Firefox 1.5to Firefox 2.0, around the same time. Do they maybe use some of the same files? Anyone heard of this? Googling around it seems that at least in older postings (ca. 2005) they were related, but I can't find anything newer. *I'm running with* Windows XP Eclipse Version: 3.2.2 Build id: M20070212-1330 cfeclipse 1.3.1.3 (just upgraded from 1.3.0 where it crashed as well) firefox 2.0.0.3 java version 1.5.0_6 Any ideas or help would be greatly appreciated. I dont really utilize the design view that often in DW so I'm not really looking forward to going back, especially since its having all sorts of sync issues right now. Probably something with the timestamps being off on files. I've had that issue with it in the past, and I was just waiting til after DST would be normal again before trying to fix something that might resolve itself in a few weeks. Cheyenne - 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 -
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 SalesService *Subject:* Re: [ACFUG Discuss] cfform bug stuck on variable. A quick Google Search: http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=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
Re: [ACFUG Discuss] cfform bug stuck on variable.
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 SalesService *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 SalesService *Subject:* Re: [ACFUG Discuss] cfform bug stuck on variable. A quick Google Search: http://www.masrizal.com/index.cfm?fuseaction=idea.download_detailProductID=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
Re: [ACFUG Discuss] Sturcture help. No answers just guidance
Robert, Before you approach applying a formula or business logic against a piece of data, you need to practice how to read the data from the DB and how to import a CSV from your file system onto a CFM template. I am not sure what you mean by pitfalls of querying. SQL is made to handle exceptions, conditional processing and complex business calculations. Bad queries usually stem from badly planned schemas or business logic implementation. You need to have two separate mind sets when writing queries: 1) Business - What do I need in the end to show? 2) Development - What kind of data input do I need and how should I process it? I would practice more with cfquery for database connected queries and also with cffile for CSV data. More advanced implementations just use the database to import and process the CSV, so that you can perform data joins. Keep in mind that a good practice would be to not have your business logic formula on your display template. Your display page should just show the end result, while you processing pages or database routines will apply business logic and transform your data. There are a lot of examples online for doing both. On 3/19/07, Robert Reil [EMAIL PROTECTED] wrote: Im trying to logic through how to do the following. Any input would be appreciated. I understand in the end I can just use cfquery to call this data when I am ready to build an app to do this but for now I am trying to get a grip on how to structure this logic. I have 2 pieces of data: A: Original exported data from a DB from the below venor. Included are: PartNo, my OLD cost, our sales price, text formula of how to turn my OLD cost, into our sales price. B: New price sheet in csv form from the vendor showing PartNo, and my cost. My goal is to update our sales price to new prices based on our new costs, and the formula. To do that I need to: 1Populate the formula field with a REAL CF READABLE formula. Where can I get info on how to structure these kinds of formula? 2Build guidelines for updates. I see there are many pitfalls in selecting, and updating data. I wonder if some patient folks out there could share with this normally Friday only guy. Thanks in advance for your patience and guidance. 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] Error handler, included template not shown. The calling template is shown.
Also, if you use cftry with cfcatch, you can cfdump the cfcatch structure to show the error received and thus also place it in your email. On 3/16/07, Ajas Mohammed [EMAIL PROTECTED] wrote: Yes, its part of cfmail. I usually use cfdump for form client vars to get an idea of what user was working with when the error occurred. I might try cfdump of error also. Dont know if it will point me to what I need i.e. exception generating template which is included in main template. Ajas. On 3/16/07, Troy Jones [EMAIL PROTECTED] wrote: Is this code from your cfmail tag? We have begun using cfdump in place of mail formatting. It gets a lot extra stuff, but it puts everything you need in there. For example: cfmail….. cfdump var=#error# /cfmail Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ajas Mohammed *Sent:* Friday, March 16, 2007 11:12 AM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] Error handler, included template not shown. The calling template is shown. Hi, I have a error handler template which sends me an email whenever an error is encountered. When there is error on an included template, the my error handler always points to main template that included the error generating template. For example : Main page : *PageStart.cfm* contains/includes cfinclude for *page_error.cfm*. When there is error in* Page_Error.cfm*, I am shown as error in *PageStart.cfm*. Here is code from my error handler *URL*: cfif isDefined(cgi.server_name ) and isDefined(* cgi.script_name*) a href=https://#cgi.server_name##cgi.script_name#;https://#cgi.server_name## * cgi.script_name*#/a/cfif br / *Address*: cfif isDefined(error.remoteAddress)#error.remoteAddress#/cfifbr /br / *Template*: cfif isDefined(error.template)#error.template#/cfifbr / *Error*: cfif isDefined( error.Diagnostics)span class=Mail_Red#error.Diagnostics#/span/cfifbr /br / *Error on* cfif isDefined( cgi.path_translated)#*cgi.path_translated *#/cfifbr / *From page* cfif isDefined(cgi.http_referer) a href=#cgi.http_referer##cgi.http_referer#/a/cfifbr /br / If you have CF debugging enabled, then CF debugging will point me to Page_Error.cfm and line no. where the error occurred. This is exactly what I need in my error handler also. Probably I might be missing a property of error object. Any ideas?? -- 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 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 - -- 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 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
Re: [ACFUG Discuss] List Usage
List members, ACFUG attendees and Board members, During our recent board meeting after elections, we had create responsibilities to coordinators and committees to handle certain monthly tasks to keep ACFUG progressive. One of these assignments is the list moderator or mother if you are a fan of CIA movies. John was given this responsibility. If you have questions about what is acceptable or not on our lists, both John and I will be monitoring and responding to difficult situations. We are here to share knowledge, insight and advice. We are not beyond taking advice and we are always looking for feedback. I hope that we can take this as an example that overly emotional responses should be reconsidered if you do not have a full picture of a situation. There is a mantra about Don't Take things Personally that is hard to live by. I will spare you the new age literature references, but if you get to the point where you do take something personally then talk to someone first before subjecting our entire membership to your frustration or concern. We have 15 people on the board that are meant to try and be objective about the daily situational awareness of the group. Help us be more proactive instead of Reactive. Teddy On 3/14/07, John Mason [EMAIL PROTECTED] wrote: Ok, a few things to consider for everyone here when posting to the lists. It's been awhile since we stated some of the basic ground rules so I guess it's time to review. 1- Each list has a specified purpose Discussion at acfug.org is for CF related topics and questions Jobs at acfug is for CF jobs Community is for anything else When posting a question, please do it to one list not 2 or 3. 2- Noise level is always a concern on these lists. If you feel you're posting each and every technical question you run across, please google for the answer first before posting. The lists are for technical questions but naturally sometimes people need to take things off list to reduce the noise level. There is also an archive of this list. You may be asking a question that has previously answered. 3- Complaints should NOT be posted directly on the lists. Please direct any complaints to myself or to Teddy at [EMAIL PROTECTED] or for that matter anyone on the board. We do monitor things and try to keep the noise level down. Thanks for your cooperation. John [EMAIL PROTECTED] - 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 - -- 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 -
Re: [ACFUG Discuss] cf administrator
For IIS in the past, it is usually a file called iis.msc, which may have changed for IIS 6 and later. You usually can find your IIS manager from your Administrative tools that is available from your start menu or it can be located in your Control Panel menu. I agree with Dean about your web server not knowing how to serve CF pages. What happens in IIS, is a DLL file is associated to a .cfm or .cfml files. This DLL has the responsibility of calling and executing the CF engine to parse the .cfm page being requested. If IIS doesn't know what to do with a file extension, it will download it like it an executable or .zip file. Teddy On 3/15/07, Dean H. Saxe [EMAIL PROTECTED] wrote: There should be a IIS plugin to handle the CF content, is it configured in the IIS Admin? Check out the docs on adobe.com for specific config information. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free. -- Theodore Roosevelt, 1918 On Mar 15, 2007, at 12:33 PM, Troy Jones wrote: IIS should be the one handling that, but therein lies my problem. I can't open the CF administrator to edit any settings in IE. Kinda catch 22. Anyways, is there another way to access that or will this problem have to be addressed first? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 15, 2007 12:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator Which is serving up the CF content then? You'll have to ensure CF is configured appropriately to use one or the other. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Mar 15, 2007, at 12:14 PM, Troy Jones wrote: It has both Apache and IIS installed. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 15, 2007 12:09 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator What kind of web server is it? Apache? IIS? It sounds like the web server isn't calling the CF executable to process the page and is instead returning the source to you. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Mar 15, 2007, at 11:32 AM, Troy Jones wrote: Hello, I am new to this group and, quite honestly, not terrible experienced. Please bear with me as I try to lay out my problem. I am trying to access the cfadministrator on our server. It will not open in IE or Firefox. It closes the browser and forces me to use Notepad or save the file to hard drive. In another issue that may or may not be related, when I type in the value to open the administrator, the browser tells me that it cannot find the url requested, which, in this case, is itself. Does anyone have any suggestions? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 - - 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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa 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 - - 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 -
Re: [ACFUG Discuss] cf administrator
Well, the external website has its own web server. To server ColdFusion, the web server that is handling the requests for the external web site would need to have ColdFusion installed on it as well. On your local system, you would have a developer copy of ColdFusion typically, but on external websites you will either have the hosting provider having ColdFusion installed or the dedicated server having ColdFusion installed. Either way, you need a software piece to be able to interpret and parse ColdFusion pages. ColdFusion is not native to IIS or Apache. The developer edition is free, but for servers that have more than one connection connecting to it, then you will need to buy additional software. Teddy On 3/15/07, Troy Jones [EMAIL PROTECTED] wrote: Would that still be true if the pages were served externally in the proper manner? This problem only exists when trying to open a .cfm locally on the server. For example, this site, http://www.superlawntrucks.com is served as requested and there are no errors with it when accessed externally. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Thursday, March 15, 2007 1:26 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] cf administrator For IIS in the past, it is usually a file called iis.msc, which may have changed for IIS 6 and later. You usually can find your IIS manager from your Administrative tools that is available from your start menu or it can be located in your Control Panel menu. I agree with Dean about your web server not knowing how to serve CF pages. What happens in IIS, is a DLL file is associated to a .cfm or .cfml files. This DLL has the responsibility of calling and executing the CF engine to parse the .cfm page being requested. If IIS doesn't know what to do with a file extension, it will download it like it an executable or .zip file. Teddy On 3/15/07, *Dean H. Saxe *[EMAIL PROTECTED] wrote: There should be a IIS plugin to handle the CF content, is it configured in the IIS Admin? Check out the docs on adobe.com for specific config information. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free. -- Theodore Roosevelt, 1918 On Mar 15, 2007, at 12:33 PM, Troy Jones wrote: IIS should be the one handling that, but therein lies my problem. I can't open the CF administrator to edit any settings in IE. Kinda catch 22. Anyways, is there another way to access that or will this problem have to be addressed first? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 15, 2007 12:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator Which is serving up the CF content then? You'll have to ensure CF is configured appropriately to use one or the other. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Mar 15, 2007, at 12:14 PM, Troy Jones wrote: It has both Apache and IIS installed. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 15, 2007 12:09 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator What kind of web server is it? Apache? IIS? It sounds like the web server isn't calling the CF executable to process the page and is instead returning the source to you. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Mar 15, 2007, at 11:32 AM, Troy Jones wrote: Hello, I am new to this group and, quite honestly, not terrible experienced. Please bear with me as I try to lay out my problem. I am trying to access the cfadministrator on our server. It will not open in IE or Firefox. It closes the browser and forces me to use Notepad or save the file to hard drive. In another issue that may or may not be related, when I type in the value to open the administrator, the browser tells me that it cannot find the url requested, which, in this case, is itself. Does anyone have any suggestions? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] - To unsubscribe from this list, manage your profile @ http
Re: [ACFUG Discuss] cf administrator
Ok, here we go: Assuming you have IIS installed and CF installed and you have access to your IIS Administrator: Use the + symbols to expand to your default web site Right click the default web site and then click Properties Click Home Directory tab Click Configuration button Under the scrollable list of Application Mappings, you should see .cfm under teh extensions column If you do not see .cfm, then your IIS server will not be able to serve up the page Teddy On 3/15/07, Troy Jones [EMAIL PROTECTED] wrote: Yes as I have been able to access the administrator in the past. This is recent problem and, because others have access to the server, I do not know what, if any changes have been made. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Thursday, March 15, 2007 2:35 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] cf administrator When you install CF in server mode, you will be prompted on which web server to use and then the bindings for the CFM interpreter are created at that point. Do you know for a fact that CF is indeed installed? Teddy On 3/15/07, *Troy Jones* [EMAIL PROTECTED] wrote: In response to Teddy, that is exactly right. As far as why both are installed, I just work here. It was that way from day one when I started. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Steven Ross Sent: Thursday, March 15, 2007 2:21 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator You are asking for trouble running apache and IIS... why do you need both on the same box? On 3/15/07, Troy Jones [EMAIL PROTECTED] wrote: It has both Apache and IIS installed. Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, March 15, 2007 12:09 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf administrator What kind of web server is it? Apache? IIS? It sounds like the web server isn't calling the CF executable to process the page and is instead returning the source to you. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] What is objectionable, what is dangerous about extremists is not that they are extreme, but that they are intolerant. -- Robert F. Kennedy, 1964 On Mar 15, 2007, at 11:32 AM, Troy Jones wrote: Hello, I am new to this group and, quite honestly, not terrible experienced. Please bear with me as I try to lay out my problem. I am trying to access the cfadministrator on our server. It will not open in IE or Firefox. It closes the browser and forces me to use Notepad or save the file to hard drive. In another issue that may or may not be related, when I type in the value to open the administrator, the browser tells me that it cannot find the url requested, which, in this case, is itself. Does anyone have any suggestions? Troy Jones Dynapp Support Team 678-528-2952 [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 - - 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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.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 - -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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
Re: [ACFUG Discuss] CFQuery Basics: HELP!
Not to one up Doug, but a good practice after his suggestion is also to put in a maxlength on cfqueryparam to the maxlength of the data columns you are referring to. If the maxlength for the SKU column is a varchar(40), then: 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 This is an added check on strings to prevent large strings inadvertantly. The maxlength is for strings and not for numbers. Teddy On 3/9/07, Douglas Knudsen [EMAIL PROTECTED] wrote: RIght after cfquery name=product datasource=carbs SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = '#FORM.sku#' /cfquery try adding this for testing purposes cfdump var=#product# /cfabort / Also, others may jump on this before I, really should use cfqueryparam cfquery name=product datasource=carbs SELECT Description1, Description2, Vend_Name FROM carbs.products WHERE sku = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.sku# / /cfquery Ask Charlie all about the null attribute :) DK On 3/8/07, Robert Reil [EMAIL PROTECTED] wrote: thanks doug. I tired the products.name but still did not work. Im tired. Bed time. MY DAY IN 1.5 hrs u know!! I think u see it coming too 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 -- *From:* Douglas Knudsen [mailto:[EMAIL PROTECTED] *Sent:* Thursday, March 08, 2007 9:51 PM *To:* Carbs SalesService *Subject:* Re: [ACFUG Discuss] CFQuery Basics: HELP! hey, its 2 hours away to your Friday! Ok, first off, from the looks of it you are assuming you will always get one record from this SQL, with your data this maybe a fair assumption, but be careful of assumptions, they'll bite you someday in code. I'm living proof carrying many scars from the code dog. Now, a couple things with this line: cfset desc1 = #Description1# 1) You should always scope your variables, a few rare cases where you may not want to, but this is definitely not one of them. So change the line to cfset desc1 = #product.Description1# / 2) # use, you do not need pounds inside tags and functions unless you are inside quotes, so change the above to cfset desc1 = product.Description1 / 3) Are you always 100% sure your SQL will return at least one row? I'm guessing in this case it is not. So, need to wrap your line above in a check for this cfif product.recordcount GTE 1 cfset desc1 = product.Description1 / /cfif That said, I'd urge you to use CFOUTPUT and its QUERY attribute, then you can write code not worrying about 1 so much, depending on your situation of course. This would lead you to something like the below. With this, no need to use the cfset lines you have and this will work when the SQL has no records returned. Note also if the SQL returns more than one record, the cfoutput will loop over all of them for you. cfoutput query=product tr bgcolor=##cc tdstrong: #form.sku# /strong br #product.Desc1# /td td#product.Vend_Name#/td /tr tr td colspan=2 font size=-2#product.Description2#/font /td /tr /cfoutput HTH! DK On 3/8/07, Robert Reil [EMAIL PROTECTED] wrote: 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 titleProduct Search Results/title /head body cfset desc1 = #Description1# cfset desc2 = #Description2# cfset vendor = #Vend_Name# !--- Display search text --- cfoutput strongSKU:/strong table tr th colspan=2 font size=+2 Products /font /th /tr cfoutput tr bgcolor=##cc 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 @
Re: [ACFUG Discuss] Slides or notes from recent meeting ACFUG
I also noticed that Steve was recording on his own Adobe Connect. Is his audio/video going to be available on UGTV? Teddy On 3/9/07, Charlie Arehart [EMAIL PROTECTED] wrote: I've not received them yet, folks. Steve's on this list so may see your request. I've also asked him privately now, in case he doesn't. As soon as they're up, I'll announce it. /Charlie http://www.carehart.org/blog/ -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ajas Mohammed *Sent:* Thursday, March 08, 2007 10:20 PM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] Slides or notes from recent meeting ACFUG Hi, I would like to request any presentation or notes for the last ACFUG meeting from FigLeaf Software. I am very much interested in Google SEO methods and the last time I was in a Adobe session about the same topic, the session was interrupted because of some technical issues. Thanks, -- 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 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 http://www.fusionlink.com - attachment: image002.jpg
Re: [ACFUG Discuss] ColdFusion project lifecycle tools ??? - Configuration Management to Versioning to Testing
I agree Charlie. Any future threads on this would be a good candidate for community list. Teddy On 3/9/07, Charlie Arehart [EMAIL PROTECTED] wrote: This is getting quite off-topic (for the CF list). Should it move over to the acfug community list? (And Ajas, perhaps you may also get better results on a bugzilla list, too.) /Charlie http://www.carehart.org/blog/ -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ajas Mohammed *Sent:* Friday, March 09, 2007 12:23 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] ColdFusion project lifecycle tools ??? - Configuration Management to Versioning to Testing Sorry guys, I didnt realise somehow we had 2 threads running parallel for this topic. So here is my question again 1) Whenever I login to Bugzilla, if i dont do any activity for sometime, and try to open bugzilla open by doing refresh, I get this error : CGI ErrorThe specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Any one seen this error before? 2) as per my last email which was in diff thread in response to Roberts email about having multiple instances of bugzilla.I was wondering if thats the case but I dont think it will be like that... it would be nice if someone who has used bugzilla for multiple projects can clarify this point..I think it will be a pain to have seperate installs of bugzilla for each project... what abt Trac for the similar situation? does it support multiple projects? Thanks, Ajas Mohammed. - 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 - attachment: image002.jpg
[ACFUG Discuss] CFEclipse Update
CFEclipse 1.3.1.3 released today. You can use the normal update process or download from http://www.cfeclipse.org/update It was a bug fix release. -- 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 -
Re: [ACFUG Discuss] Search engine for ColdFusion
For Flex, you should try the www.gotswf.com website, which is a companion site. Of course, Steve showed us this last night as well. =) Thanks again Steve for the generous search engine. Teddy On 3/8/07, Steven Ross [EMAIL PROTECTED] wrote: my first thought on this was a big question mark, but this is really nice. FYI for those who didn't click through they are searches on CF or flex related stuff (see screenshot) On 3/8/07, Steve Drucker [EMAIL PROTECTED] wrote: http://www.gotadobe.com for CF developers http://www.gotswf.com for Flash/Flex developers Feedback appreciated. Regards, Steve Drucker CEO Fig Leaf Software www.figleaf.com -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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 - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
[ACFUG Discuss] CFEclipse Update
CFEclipse recently had a release from 1.3 to 1.3.1.1 to 1.3.1.2 As fixes are submitted and found, Mark Drew has provided a new link for those who do not have direct access to the Eclipse update. You can perform manual update from the following: http://www.cfeclipse.org/update/ You can add the updates from an archived size or via a local site. The normal update process is still intact. You can always find out about the cfeclipse news from: http://www.cfeclipse.org/index.cfm?event=pagepage=news Teddy -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] ColdFusion project lifecycle tools ??? - Configuration Management to Versioning to Testing
Ajas, The drop down for Trac when referring to users is one complaint that it would be nice to choose who assign tickets to, but on the opposite side or people who can take action on bugs, they can assign themselves to the ticket. Regardless if 10 people swear that Trac is better than Bugzilla, I would recommend that you try both on your own and make your own informative decision. Advice is just advice and your personal preference for your development needs will be the final choice. Just avoid the pitfall of saying that you do not have time to test applications. You are telling yourself at that point that you do not have time to find the best way to make yourself more productive. Teddy On 3/1/07, Ajas Mohammed [EMAIL PROTECTED] wrote: Hi, Can anyone clarify what Steven pointed out about not being able to pick a user from dropdown in demo on their site? Does it work in regular version of trac? So far, looking at the responses ppl seem to be very happy using Trac since it integrates directly with Subversion. I decided I would give ratings/points to Trac/Bugzilla, so anyone who reads this thread can decide which route to take. So far I think Trac (6) Bugzilla(4) and rating is 1-10 , 10 being highest. If anyone has experience using these tools then please share your experience with Trac/Bugzilla. Thanks, Ajas Mohammed. On 2/28/07, Steven Ross [EMAIL PROTECTED] wrote: The only downside to trac is that it doesn't have the detail that bugzilla does. There is also the annoyance of not being able to pick a user from a dropdown. In trac you just enter their name... at least that is the way the demo is on their site. I haven't used trac but, I like the hooks into SVN. Course you can do that with bugzilla too, its just hard to setup. On 2/28/07, Ajas Mohammed [EMAIL PROTECTED] wrote: Justin, I looked at the link you sent and it reminded me of Bugzilla. So now the question boils down to Bugzilla vs Trac ? 1)which one would you prefer and why? 2) benefits 3)support for Subversion? i read bugzilla needs another component to interact with Subversion Plz share your experience if you have seen both of them working... Thanks. This thread is getting interesting. On 2/28/07, Paul Kenney [EMAIL PROTECTED] wrote: I have seen cfcunit cfunit but at this point it doesnt look very natural way of doing things to me. I would prefer the GUI tools, atleast for now. If it is unit testing you are interested in, there really isn't any way to write your tests in a GUI fashion. Tests are code, and you have to write them just like you have to write your application code. The only visual aspect of unit tests right now would be the test runner application that reports results back to you once you run the tests. I'm pretty sure this isn't what you wanted to hear, but sorry, that's just the way it is. -- Paul Kenney [EMAIL PROTECTED] http://www.pjk.us - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Ajas Mohammed / http://ajashadi.blogspot.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Ajas Mohammed / http://ajashadi.blogspot.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 G-Talk: [EMAIL PROTECTED] Adobe
[ACFUG Discuss] SQL Prompt
If you use SQl Server 2000 or 2005, there is a tool that I highly recommend: SQL Prompt by Red Gate Software This little gem makes creating queries and joined queries so quick, that testing your schema or instrospecting your metadata a thing of the past. There is a demo of the tool in action at the following link: http://www.red-gate.com/products/SQL_Prompt/index.htm It is not free. It is $195, but I am seriously considering writing this on off as a business critical expense. -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] documentation
I see a great deal of adhoc commenting styles that do not have a semblance of coherence. When using CFCs, the hint is invalueable. When using version control, comments made on check-in are very helpful. Dreamweaver uses design notes on code templates. I have seen external documents with code explnation. The primary issue and thus need is that when you comment code that you should be able to do so at the same time that you code. You really do not want to create several bodies of code or commenting documents. It is also a management decision if you want to implement fusedocs or concreate commenting versus adhoc commenting that can be anywhere. A con to production commenting is that you really don't want your production code with ehavy amounts of comments. I would suggest staging documentation that would record the API trhough version control with good code hints. Teddy On 2/19/07, John Mason [EMAIL PROTECTED] wrote: We're talking about implementing a formal documentation procedure here. Besides for fusedocs, what other options are people currently using out there and what do you see as the pros and cons. thanks in advance, John [EMAIL PROTECTED] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] Calling DTS package from CFM page
Ajas, I would not really approach DTS tracking just from a COM package. SQL Server stores all of the information about a DTS package, the execution, steps and failures in the master DB. Create a read-only user to connect to your SQL Server's master DB and then just start exploring all of the metadata and process information is stored for your database. Everything is in there. Teddy On 2/13/07, Ajas Mohammed [EMAIL PROTECTED] wrote: Hi, I was looking around to find code for calling a DTS package from cfm page. I found this code below. I am able to connect and everything but I would like to see the status of DTS package execution not just individual steps. I got the individual steps there status codes by adding some code the cfscript code below. My question is 1) How do you track success/failure message from DTS using this script? This is very important because I want to let you user know what happened after the dts was run since the DTS inserts records into a table from a holding table and I need to confirm that to the user. If DTS failed, I would give error msg and if it succeeded, then I will take the user to next step i.e. create an export text tab delimited file. For ex : Stored Proc returns 0 for no error and 1 for error. cfscript *create dts package object* pkg = createObject(COM,DTS.Package); * // load package * pkg.LoadfromSQLServer (NameOfSQLServer, SQL_Username, sql_password , 0, , , , nameOfTheDtsPackage , ); * // execute* pkg.Execute(); /cfscript // this will get individual steps execution cfset sErr = cfset bSuccess = True cfset test = StructNew() cfset DTSStepExecResult_Failure = 1 cfloop item=oStep collection=#pkg.Steps# cfset sErr = sErr p Step [ oStep.Name ] cfif oStep.ExecutionResult eq DTSStepExecResult_Failure cfset sErr = sErr failedbr cfset bSuccess = False cfelse cfset sErr = sErr Succeeded br /cfif cfset sErr = sErr Task ( oStep.TaskName) /p /cfloop cfif bSuccess cfset sErr = sErr pPackage [ Pkg.Name ] succeeded/p cfelse cfset sErr = sErr pPackage [ Pkg.Name ] failed/p /cfif cfoutput#sErr#/cfoutput Any suggestions are welcome. Thanks in advance... -- 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 FusionLink http://www.fusionlink.com - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] CFC and reuse query
What database are you using? Teddy On 2/2/07, Anthony Mathis [EMAIL PROTECTED] wrote: I'm looking for a solution to reusing a query in a cfc where the where clause needs to change. example: cfquery name=qry datasource=#APPLICATION.dsn# select * from table where #field# = #value# /cfquery How would I pass the info from my cfm to the cfc and continue to run the same query from the same cfm using different values for #field# and #value#? Can this be done? thanks, Anthony - 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 - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] CFC and reuse query
The solution should still work with the latest version of mySQL. mySQL ahs support for stored procedures and the coalesce function. You will need however, CF 7 with the Hot Fix 1 that re-enables the use of directly mapping stored procedure named paramaters. Teddy On 2/2/07, Anthony Mathis [EMAIL PROTECTED] wrote: mysql On Fri, 2007-02-02 at 11:57 -0500, Teddy Payne wrote: What database are you using? Teddy On 2/2/07, Anthony Mathis [EMAIL PROTECTED] wrote: I'm looking for a solution to reusing a query in a cfc where the where clause needs to change. example: cfquery name=qry datasource=#APPLICATION.dsn# select * from table where #field# = #value# /cfquery How would I pass the info from my cfm to the cfc and continue to run the same query from the same cfm using different values for #field# and #value#? Can this be done? thanks, Anthony - 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 - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 - - 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 - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] video of new tool from Cynergy
It is a beautiful web piece. I like the reflective component and the rotating box navigation. I had one issue and I am probably just being picky: From a useability case and branding perspective, I do not like the fact that you launch a new window to view the case study on the solution/product. This diverts the attention of the user from the central branding page. It woud have been nice if the left aspect of the stage transitioned into a scrollable area with the case study information and then offered either an additional information link, download a case study, send me email about this case study or click her to launch a new window with more detail. Warn your user about your transitions otherwise they may get lost in the amount of information you provide. I felt that reading about their case study was more important than the brochure-ware of the Flex stage as it would either spawn over the Flex application or load in a new tab. Aesthetically, it is brilliant. It just needs to merge content in the same medium. Teddy On 2/1/07, Robert Reil [EMAIL PROTECTED] wrote: WOW! Very NICE!!! 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 -- *From:* Douglas Knudsen [mailto:[EMAIL PROTECTED] *Sent:* Thursday, February 01, 2007 9:12 AM *To:* Carbs SalesService *Subject:* [ACFUG Discuss] video of new tool from Cynergy couple folks here are involved in real estate, so thought I'd pass this on http://www.cbetta.com/blog/index.cfm/2007/1/31/see-adobe-flex-best -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] Building my IDE Tool Box
Mary, Click the following for background change: Window Preferences CFEclipse CFML Colours You will see background at the bottom. Those crazy brits and their spelling. =) Cheers, Teddy On 1/29/07, Shifang (Frank) Sun [EMAIL PROTECTED] wrote: Eclipse does allow you to change the background color. On 1/29/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: As with others on the list, I go between CFEclipse and DW. Eclipse has some nice plugins to allow you to modify your database without having to use some other application (there probably is something like this in DW, but I haven't gone searching). I do prefer searching in DW, it seems to have an easier interface. I suppose if I did a lot of layout, DW would be easier than there. A drawback with Eclipse is that I can't change the background to black but DW does allow for that, but I can get close enough (try it, it's easier on the eyes). As for the large file size, I haven't had a problem with a 1700 line file, other than it's 1700 lines (only one of the thousands of reasons this app is being rewritten)! mcg [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/26/2007 03:47 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] Building my IDE Tool Box It may be an issue with the plugin. If you want to test it out though...just copy and paste some code into cfeclipse that makes a file that's 2,500 lines of code and then go and try to add some code in the middle of the page. You could type three lines of code and then watch it come across the screen in Doogie Howser fashion 15-20 seconds later! It's insane. Allen -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of Dean H. Saxe Sent: Friday, January 26, 2007 3:42 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Damn dude... what kind of box are you on the Eclipse is a dog on large files? I've never seen that behavior, but that's not using CFEclipse, just the base Eclipse for Java projects... Could it be an issue with the plugin? -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] [U]nconstitutional behavior by the authorities is constrained only by the peoples' willingness to contest them --John Perry Barlow On Jan 26, 2007, at 3:32 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Briefly... The ONLY reason I've ever liked DW is the fact that you can synchronize files between the local machine and a server very easily. Eclipse is supposed to have synchronize plugins but they've never seemed to work (at all). Also, DW is great for design type of work, as Ajas mentions below, but it's a resource hog. If you're low on memory you should probably look elsewhere - that being stated, Eclipse isn't exactly a light-weight either! One last thing - a negative for eclipse...if you're working with files that contain thousands of lines of code (I know, everyone says it shouldn't happen, but it does), just typing in a line of code in the middle of the page can be very annoying...it is SO SLOW... But, other than that, both have their uses but the one huge plus of eclipse - it's free -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of Ajas Mohammed Sent: Friday, January 26, 2007 3:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Best IDE? well thats a tough question and it depends on persons own taste preferences. I like to play with all IDE's there in market and finally stick to ones which I like more. In this case its DW Eclipse. As John Mason mentioned earlier, from coder's point of view no one can beat Eclipse for the simple reason that its meant for a developer who does coding day in day out. Its a very wise option to get familiar with Eclipse because sooner or later some place you join will have developers who only use Eclipse. As for DW is concerned, it is also a great tool for a developer who wants to do design as well write code. Personally, I use both DW Eclipse. I use DW a lot because when I want to edit code, I just select the html element and I get to the point where I want to make the changes instead of searching for it. Thats the biggest plus for me as far as using DW is concerned. On the other side, whenever I have to refactor code or make code changes in CFC's etc, I prefer to stick to Eclipse. Also the Eclipse IDE has some very cool features like 1) You can go to previously viewed file by using cntl + F6 keys. I dont think you could do the same in DW. In DW, cntl + tab takes you through list of files that are open. I hate that. Usually i have lots of files open and I always like to go back forth between 2 open windows/files. Its much easier to do this in Eclipse. 2) The appearance of Eclipse editor looks very good to the
Re: [ACFUG Discuss] Building my IDE Tool Box
Mary, When you click the Background button under the CFEclipse CFML Colours, you get the standard colors associated with your operating system. If you would like to have a custom color, you click Define Custom Colors. As I am sure you know, it is based upon RGB, which translates every web safe octet like 0, 51,102,153, 204 and 255. So, there is no problem changing the background color to black which would be R:0 G:0 B:0 Teddy On 1/29/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Not to #00 for the background mcg *Shifang (Frank) Sun [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/29/2007 09:05 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] Building my IDE Tool Box Eclipse does allow you to change the background color. On 1/29/07, [EMAIL PROTECTED] *[EMAIL PROTECTED] [EMAIL PROTECTED][EMAIL PROTECTED] wrote: As with others on the list, I go between CFEclipse and DW. Eclipse has some nice plugins to allow you to modify your database without having to use some other application (there probably is something like this in DW, but I haven't gone searching). I do prefer searching in DW, it seems to have an easier interface. I suppose if I did a lot of layout, DW would be easier than there. A drawback with Eclipse is that I can't change the background to black but DW does allow for that, but I can get close enough (try it, it's easier on the eyes). As for the large file size, I haven't had a problem with a 1700 line file, other than it's 1700 lines (only one of the thousands of reasons this app is being rewritten)! mcg [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] 01/26/2007 03:47 PM Please respond to* [EMAIL PROTECTED] discussion@acfug.org To [EMAIL PROTECTED] discussion@acfug.org cc Subject RE: [ACFUG Discuss] Building my IDE Tool Box It may be an issue with the plugin. If you want to test it out though...just copy and paste some code into cfeclipse that makes a file that's 2,500 lines of code and then go and try to add some code in the middle of the page. You could type three lines of code and then watch it come across the screen in Doogie Howser fashion 15-20 seconds later! It's insane. Allen -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:* [EMAIL PROTECTED][EMAIL PROTECTED]]On Behalf Of Dean H. Saxe Sent: Friday, January 26, 2007 3:42 PM To: [EMAIL PROTECTED] discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Damn dude... what kind of box are you on the Eclipse is a dog on large files? I've never seen that behavior, but that's not using CFEclipse, just the base Eclipse for Java projects... Could it be an issue with the plugin? -dhs Dean H. Saxe, CISSP, CEH* [EMAIL PROTECTED] [EMAIL PROTECTED] [U]nconstitutional behavior by the authorities is constrained only by the peoples' willingness to contest them --John Perry Barlow On Jan 26, 2007, at 3:32 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Briefly... The ONLY reason I've ever liked DW is the fact that you can synchronize files between the local machine and a server very easily. Eclipse is supposed to have synchronize plugins but they've never seemed to work (at all). Also, DW is great for design type of work, as Ajas mentions below, but it's a resource hog. If you're low on memory you should probably look elsewhere - that being stated, Eclipse isn't exactly a light-weight either! One last thing - a negative for eclipse...if you're working with files that contain thousands of lines of code (I know, everyone says it shouldn't happen, but it does), just typing in a line of code in the middle of the page can be very annoying...it is SO SLOW... But, other than that, both have their uses but the one huge plus of eclipse - it's free -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:* [EMAIL PROTECTED][EMAIL PROTECTED]]On Behalf Of Ajas Mohammed Sent: Friday, January 26, 2007 3:27 PM To: [EMAIL PROTECTED] discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Best IDE? well thats a tough question and it depends on persons own taste preferences. I like to play with all IDE's there in market and finally stick to ones which I like more. In this case its DW Eclipse. As John Mason mentioned earlier, from coder's point of view no one can beat Eclipse for the simple reason that its meant for a developer who does coding day in day out. Its a very wise option to get familiar with Eclipse because sooner or later some place you join will have developers who only use Eclipse. As for DW is concerned, it is also a great tool for a developer who wants to do design as well write code. Personally, I use both DW Eclipse. I use DW a lot because when I want to edit code, I just select the html element and I get to the point
[ACFUG Discuss] CFEclipse
If you have not already read it on the blogosphere, CFEclipse 1.3 beta is out. http://www.cfeclipse.org The have refactored their site, which has a nice feel to it. CFEclipse 1.3 works on 3.1.2, 3.2.1 and 3.3M4 without any issues. -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - 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 -
Re: [ACFUG Discuss] css styling assistance
No worries. You amy also want to be interested in an analagous product called ThickBox. http://jquery.com/demo/thickbox/ This is more content driven than images. Teddy On 1/26/07, rlash [EMAIL PROTECTED] wrote: Yes this is the effect I am going for Thanks Teddy - Original Message - *From:* Teddy Payne [EMAIL PROTECTED] *To:* discussion@acfug.org *Sent:* Friday, January 26, 2007 4:36 PM *Subject:* Re: [ACFUG Discuss] css styling assistance http://www.huddletogether.com/projects/lightbox2/ Light Box On 1/26/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I would like to know if someone in the community knows of the following techinque or can supply some possible link resources. I have googled enough to give in to asking for help. Here is what I am trying to do: I have a basic cfm page that lists information. A link on each listing to edit the listing. When edit link is clicked a popup via hide/show div appears as expected. When this happens I want the rest of the screen (not including the actual div) to have a transparent background or transparent image applied to the entire page and not the activated div. I have seen this used in Ajax slide show applications etc, but can't seem to find the styling to do this. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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 G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash Flex User Group (AFFUG)
Re: [ACFUG Discuss] MySpace growth
I have to applaud New Atlanta for adopting hardware and VM editions quickly. The benefits from adopting architecture with native support are extremely visible in terms of data channel bandwidth. I can only wish that one day that the two product will merge and support one another so that developers don't have to choose between long time loyalty to the original code base versus the immediate performance gain of 64-bit and next generation JVMs. Developers choose Adobe for a specific feature sets and BlueDragon for increased performance and yet other New Atlanta specific features. I will be evaluating both products over the coming months. I cannot say that choosing one over the other is up to me. My clients will determine that most of the time. The offerings by both companies are equally compelling. I wish Adobe success this summer with CF 8.0 and New Atlanta with BD 7.0. The saving grace with multiple large platforms with support is the solidification of the need for CF developers. The learning curve to switch in between these platforms is based upon specific nuance. Teddy On 1/19/07, Robert Reil [EMAIL PROTECTED] wrote: I notice that MySpace is so darn slow! Is that the servers or the code I wonder? 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 -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Friday, January 19, 2007 10:12 AM To: Carbs SalesService Subject: RE: [ACFUG Discuss] MySpace growth The MySpace servers running BlueDragon.NET are all still 32-bit. As for 64-bit support, I spoke at a conference in Rome last November with Ben Forta, where he said publicly it's unlikely that Scorpio will provide native 64-bit support. You can also read the comments by Damon Cooper (CFMX Director of Engineering) regarding 64-bit support (he's less than enthusiastic): http://www.fekke.com/blog/index.cfm/2006/12/20/Does-ColdFusion-need-64-bit-S upport-Short-answer-Yes Our plans are to provide native 64-bit support for BlueDragon 7.0 on the widest number of platforms possible. In fact, there's already a beta of native 64-bit BD 7.0 for Red Hat Linux 4 (RHEL4) and the x64 architecture: ftp://ftp.newatlanta.com/public/bluedragon/7_0b2/server/BlueDragon_Server_JX _70_326-Linux64.sh Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, January 19, 2007 9:48 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] MySpace growth I think the most interesting part is that they no longer use CF, actually the article mentions that they moved away from CF awhile ago. And the reason why they are using BD .NET is because they want to run native .NET code as it is faster. Granted it is probably faster due to the fact that it can actually utilize the 64 bit processor better than running CF on 32 bit java under a 64bit OS/CPU (not the only reason but, probably one). I hope this issue is addressed with the release of scorpio. If you want to understand this you can read this article by Andy (http://www.infoaccelerator.net/index.cfm/2006/12/7/ColdFusion --64Bit-and-What-It-Means-To-You) On 1/18/07, Alex Pilson [EMAIL PROTECTED] wrote: At 7:04 PM -0500 1/18/07, Alex Pilson wrote: It's quite an interesting read on scalability and how they dealt with it. Coldfusion mentioned. http://www.baselinemag.com/article2/0,1540,2082921,00.asp Oh I forgot and BlueDragon.NET! -- - 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 - - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] MySpace growth
Adam, Thank you for the colorful commentation. Can you offer a more thoughtful and objective point of view that would not slander one side or the other and would avoid a flame war? I am sure our readers would be interested in the ramifications of enterprise business to business partnerships versus product bias. Teddy On 1/19/07, Adam Churvis [EMAIL PROTECTED] wrote: I can only wish that one day that the two product will merge and support one another... Oh, God, no no no NO NO NO NO!! Lord, I know I've done You wrong before. I know I've had my differences with You in the past and not done as You'd wished from time to time. And I'm deeply sorry, Lord, *deeply* sorry, if I've offended You in any way, and I thank You for showing me the Light. I know now that I should have never invented the Puppy Trebuchet, had them manufactured by child slave labor in China, and sold them at an obscene profit to the idle rich. I know that now, because You've showed me The Way. I know now, Dear Lord, that it is not right to initiate dozens of simultaneous office pools around Atlanta on which employee can give the boss Herpes the fastest, take 10% For The House, and use that money to finance underground Free First Taste Of Crack Day for middle schoolers. You've shown me that it's wrong. But Lord, if You have any mercy left in You for the wretch that is me... If You can forgive me just one more time... If You can do one thing for me, then please please *PLEASE* don't ever let Adobe get their hands on BlueDragon.NET, Lord, please. Please keep them apart, Dear Lord, so that the pristine nature of BlueDragon.NET is not sullied. So that it remains a shining beacon of CFML performance when loads get heavy. So that we, it's disciples, can hear The Voice Of Reason when we need support, and not have to wait for generations in hopeless bondage. So that freedom of choice may reign. Thank you, and Amen. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in *C# ASP.NET http://asp.net/ 2.0 for ColdFusion Developers* at ProductivityEnhancement.com http://www.productivityenhancement.com/ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org attachment: BDAsmall.jpg
Re: [ACFUG Discuss] Image from DB
This seems to be asked often about images and BLOBs. I know you are testing
an idea out and maybe you can get it to work somehow, but from a data
perspective you just don't want to use a BLOB. There is only one technique
to reduce up front cost of a BLOB and that is to have a BLOB table. The
table would not be a part of the primary table, so you would not intefere
with indexing and collation. You would have a normalized table with a
foreign key that you would only use for that web service.
Now for the webservice, wouldn't you want to return the lowest common
denomenator of data? If you are returning HTML or something that needs to
reference the image, it is acceptable to have a reference with an absolute
URL back to your server. The benefit here is that the web service is
consumed quicker, but the page load would be based on the network retrieving
the data.
In addition, you would want inside of your web service a way not to return
the image that would even speed up the browsing unless the user really wants
the image.
Teddy
On 1/18/07, Fennell, Mark P. [EMAIL PROTECTED] wrote:
I'm just curious. What are the benefits of storing the image in the db
rather than storing the file on the filesystem and the path in the db? I
mean, for a web page, all you need is the img and the path. I can
understand how it might be useful in some VB or C or Java app where the
client doesn't display images with such ease, but for a web app...? Thanks.
mf
-Original Message-
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *John Mason
*Sent:* Thursday, January 18, 2007 10:16 AM
*To:* discussion@acfug.org
*Subject:* RE: [ACFUG Discuss] Image from DB
I believe there would still be three http requests here. The images would
still be called up in the html like img src= right? Sorry but in http
that would still create seperate http requests.
John
[EMAIL PROTECTED]
--
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Derrick
Peavy
*Sent:* Thursday, January 18, 2007 9:35 AM
*To:* discussion@acfug.org
*Subject:* [ACFUG Discuss] Image from DB
Probably an easy problem for someone...
I want to put two small images in my database and then output them in my
app, so that they do not constitute additional http requests. Consider it an
experiment - I know that it may seem a bit silly. The goal is for the entire
page to be delivered to the browser in one http request, instead of 3 (two
images and one cf page) without doing any Apache tinkering. I have looked
around the net for answers and cannot seem to make this work.
Database field is imageFile of type BLOB in MySQL 4.1.13. What is the
proper way to insert the image?
Example: INSERT into Images (imageFile) values ('#base64(image)#')
-Or-
Example: INSERT into Images (imageFile) values ('#image#')
And then of course, how do you retrieve it? Example: SELECT imageFile FROM
Images WHERE imageID=1
cfoutput
#toString(imageFile)#
/cfoutput
-OR-
cfoutput
#toBinary(imageFile)#
/cfoutput
As I say, I've not been able to make this work. If I use toString(), I
simply get the raw data. If I use toBinary(), I get an error that the data
cannot be converted to a string. Also, using CFCONTENT is fine to output the
image, but then any code after that is ignored. So, short of saving the
entire page and then outputting, it, I don't see a way to use CFCONTENT.
_
*Derrick Peavy*
*Sales and Web Services *
*Universal Advertising*
*Phone: 404-786-5036*
*Fax: 404-370-0470 *
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
*___*
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/
-
--
cf_payne /
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.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
Re: [ACFUG Discuss] DB Design Book Reccomendations?
MySQL Crash Course (Sams Teach Yourself in 10 Minutes) by Ben Forta On 1/12/07, Precia [EMAIL PROTECTED] wrote: Absolutely! On 1/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 *Robert Reil [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. 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 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. 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 - 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 - - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
By the way, the ..Mere Mortals book is in their library. Teddy On 1/12/07, Teddy Payne [EMAIL PROTECTED] wrote: I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. 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 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - - 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 Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Learning curve vs best allocation of time vs money.
Robert, If your goal is to be purely a business man, you will eventually seperate yourself from the technology and have a person or team handle this for you. As you are in the initial phases of this endeavor, you need to evaluate the time it takes to grow the business with technology versus the cost of the technology. If you spend 10 hrs per week for 10 weeks to get one technological deliverable, you will have have to wait for 10 weeks for growth. The real ability to grow is when you have your development working in paralell to the business goals. When the two coincide is when spurts of growth or growth oppurtunity occur. In your recent past and difficulty with your shopping cart choice, shrink wrapped solutions tend to be inflexible as they try and cater to a broad range of customers. There is no one product on the market for any one given requirement. Developers typically merge multiple solutions together to custom fit their clients. Eventually, you will have to work up towards having your own customized tool for managing your business. If you are the one to push technology, do you have anyone to help alleviate with business? If you are doing both, there is not much you can do until you have a way to delegate responsibilities based upon time versus growth. Corporate level developers are typically hoarded in their scope. A manager will buffer as much as he/she can to avoid the developer from not focusing on his/her forte. This is typically not possible in small to medium business. If your goal is to read the entire WACK, then that is your goal. Most CF developers do not read the WACK cover to cover. I see most of them tend to reference when they are trying to do something. We keep books, PDFs, blogs and technical websites as our many sources of ways to search how to do this widget and that widget. Over time, we reference less commont tasks. This is what I was referring to command line. If you do hire a full time developer, who will check his/her work? You will have to know enough to ensure that your requirements are met. Non-technical managers are a day to day challenge for developers. This is actually a trend that is slowing down. I have read reports that companies are expecting more of their C-level executives when it comes to technology. If he cannot read his email, how can he be in touch with his/her business? This is a lot to digest, but keep in mind that I have only covered an inkling over many topics. Most of the topics are also subjective, so you will have lots of different styles of management and experiences. You will need to choose what is the right choie for you. Teddy On 1/12/07, Robert Reil [EMAIL PROTECTED] wrote: Granted... But what about the fact that it takes lots of time to learn another way to do the same thing versus the time it takes to just navigate to the click. I am a business man working IN a business trying to find what precious little time I can to work ON the business, so that one day the BUSINESS can run the business. In my case I have to realize I do not want to become a professional programmer but gather enough skills to build tools that will generate income or save expences so that I can afford a professional programmer to do such work and that by that time I will be able to inteligently and effectively communicate with said programmer as to what we need to make the business run better. If you feel I am missing the mark please, please do advise. You guys know this stuff and the dynamics of corporations more than I. - 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 -
Re: [ACFUG Discuss] Learning curve vs best allocation of time vs money.
Caveat: If I refer to anything as he or him without having the analagous she or her, most of generalities are meant to be unisex and gender aganostic. Apologies in advance, Teddy On 1/12/07, Howard Fore [EMAIL PROTECTED] wrote: In my book, it's a tradeoff between knowing exactly what you told the tool to do on a command-line versus assuming what a GUI tool is doing. For instance MYSQL has the ability to set a collation (what I would have called a character set) on each table. You can do that explicitly in the command-line. But the designer of the GUI tool has to play trade-off between vomiting all the possible options on the user and hiding/showing them to the user based on some idea of the user's experience level. So if you just click the button that says Create Table, unless there's some verbosity to the GUI, you may be setting things that you may not want. I tend to start with the command line, then play around with various GUI tools until I find one that creates/manipulates the way I want it too, then just use the GUI. Howard On 1/12/07, Robert Reil [EMAIL PROTECTED] wrote: Granted... But what about the fact that it takes lots of time to learn another way to do the same thing versus the time it takes to just navigate to the click. -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Learning curve vs best allocation of time vs money.
*chuckle* Thanks Robert. If there is a need to continue this, we can move it over to the community list to spare folks the banter of me trying to be self effacing. Teddy On 1/12/07, Robert Reil [EMAIL PROTECTED] wrote: LOL. Go teddy, go teddy, go teddy Come on guys cheer him on! 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 -- *From:* Teddy Payne [mailto:[EMAIL PROTECTED] *Sent:* Friday, January 12, 2007 2:00 PM *To:* Carbs SalesService *Subject:* Re: [ACFUG Discuss] Learning curve vs best allocation of time vs money. Flattery gets you everywhere. Brownie points to the red head ;) Teddy On 1/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I think by now, most of us gals have figured that one out. Unless you are some traditional guy that expects dinner on the table when he gets home; which I don't think applies to you. :) mcg [EMAIL PROTECTED] wrote: - To: discussion@acfug.org From: Teddy Payne [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] Date: 01/12/2007 11:38AM Subject: Re: [ACFUG Discuss] Learning curve vs best allocation of time vs money. Caveat: If I refer to anything as he or him without having the analagous she or her, most of generalities are meant to be unisex and gender aganostic. Apologies in advance, Teddy On 1/12/07, Howard Fore [EMAIL PROTECTED] wrote: In my book, it's a tradeoff between knowing exactly what you told the tool to do on a command-line versus assuming what a GUI tool is doing. For instance MYSQL has the ability to set a collation (what I would have called a character set) on each table. You can do that explicitly in the command-line. But the designer of the GUI tool has to play trade-off between vomiting all the possible options on the user and hiding/showing them to the user based on some idea of the user's experience level. So if you just click the button that says Create Table, unless there's some verbosity to the GUI, you may be setting things that you may not want. I tend to start with the command line, then play around with various GUI tools until I find one that creates/manipulates the way I want it too, then just use the GUI. Howard On 1/12/07, Robert Reil [EMAIL PROTECTED] wrote: Granted... But what about the fact that it takes lots of time to learn another way to do the same thing versus the time it takes to just navigate to the click. -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 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?falogin.edituserformhttp://www.acfug.org/?falogin.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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] Urgent help needed.. CF custom tag to read tab delimited text file. HOw to add trim functionality??
Ajas, First, capitalization inside your emails does not emphasize a point, but rather will turn most people away from answering your question. As for your code, you are reading a file that has a set delimeter. As you are probably aware, CF has several handy functions around lists. Lists are not data types, but strings manipulated in very much the same functionality that you are creating. I would validate the overall string that it satisfied the delimeter that I would be looking for and then after that, I could either just use lists if it is a small data set or I would convert the list to an array using ListToArray() for alrger data sets. At that point, you can use Trim() to remove white space or if you want more control you can REReplace() other characters that you do not want inside of your element. It seems to me that you are introducing complexity. Teddy On 1/10/07, Ajas Mohammed [EMAIL PROTECTED] wrote: I parse to check data validation and if any required fields are empty. But as I mentioned earlier, the trim or replace or even the validation is temporary since the actual file is stored on the server and the Trim/Replace functions just works on the file by creating Array I think but doesnt ACTUALLY SAVE/WRITE TRIMMED COL VALUES TO THE FILE. I am sorry if its confusing but Please look at the code I had sent in 1st email for the Custom Tag. Thanks. Let me know if its not clear. On 1/10/07, Teddy Payne [EMAIL PROTECTED] wrote: In your custom tag, are you parseing your results? If you are, you can use any number of ways to get rid of spaces. Trim() and REReplace() are just a couple of ways. Teddy On 1/10/07, Ajas Mohammed [EMAIL PROTECTED] wrote: oh man... I was being so stupid... Heres what was happening. The custom tag was parsing the file etc which is fine but the file is uploaded to a server and then the custom tag does it stuff. So technically the file with spaces is there on the server to be loaded into SQL SERVER. Here is the code : !--- Upload file to shared folder. --- cffile action=upload fileField=demographics_file destination=#application.demographics_folder# nameConflict=overwrite / !--- Save file name. --- cfset file_location = cffile.serverDirectory \ cffile.serverFile / !--- Parse the file line by line. --- cf_demographicParser str_Filename=#file_location# So here the custom tag gets called and I check for errors in the file. Now my question is, How can i make the changes made in custom tag i.e. trim part saved in the file? maybe upload it again i.e. overwrite old file?? Is this doable?? Plz suggest... Thanks in advance... On 12/22/06, Ajas Mohammed [EMAIL PROTECTED] wrote: Thanks everyone. Douglas Knudsen -- Will replace take care of tabs also??? or shall i need to say chr(9) for example : str_Token = Replace(trim(mid(arguments.str_Content, int_CurrPos, int_NextPos - int_CurrPos)),' ','', 'All'); replaced with this code cfset str_Token = Replace(Replace(trim(mid(arguments.str_Content, int_CurrPos, int_NextPos - int_CurrPos)),' ','', 'All',Chr(9),'All'); Any suggestions?? should Chr(9) be in quotes??? Ajas Mohammed. On 12/22/06, Teddy Payne [EMAIL PROTECTED] wrote: If the records already exists in a database, you will need to run a stored procedure to scrub and clean your data. Since you are running SQL Server 2000, you can use table variables to perform this very quickly. Example: declare @firstName varchar(50) , @maxRows int , @currentRow int select @currentRow = 1 declare @dataSet table ( rowID int identity (1, 1) primary key not null , pkID int , firstName varchar(50) not null ) insert into @dataSet select firstName from tblFoo select @maxRows = count(rowID) from @dataSet while @currentRow = @maxRows begin select @firstName = firstName , @pkID = pkID from @dataSet where rowID = @currentRow select @firstName = LTrim(RTrim(@firstName)) update tblFoo set firstName = @firstName where pkID = @pkID select @currentRow = @currentRow + 1 end Kind of like that. You can scrub full tables at a time by adding more columns to the table variable. Teddy On 12/22/06, Douglas Knudsen [EMAIL PROTECTED] wrote: not sure of the SLQ Server stuff, but in the CF code below you can utilise: Trim(Replace(myString,' ','')). Actually, looks like the code is already using Trim(), just need to add the Replace() as above to remove intermediate spaces. str_Token = Replace(trim(mid(arguments.str_Content, int_CurrPos, int_NextPos - int_CurrPos)),' ','', 'All'); DK On 12/21/06, Ajas Mohammed
[ACFUG Discuss] January Presentation
Is there any status on the availability of Andy's presentation from the January meeting? I did not see a link available. Teddy -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
[ACFUG Discuss] CF 7.0.2 Security Update
If you have not already seen this from blog entries like Ray Camden or the Security Bulletins page http://www.adobe.com/support/security/#coldfusion , here is a security update released yesterday: http://www.adobe.com/support/security/bulletins/apsb07-02.html -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Urgent help needed.. CF custom tag to read tab delimited text file. HOw to add trim functionality??
In your custom tag, are you parseing your results? If you are, you can use
any number of ways to get rid of spaces. Trim() and REReplace() are just a
couple of ways.
Teddy
On 1/10/07, Ajas Mohammed [EMAIL PROTECTED] wrote:
oh man... I was being so stupid... Heres what was happening.
The custom tag was parsing the file etc which is fine but the file is
uploaded to a server and then the custom tag does it stuff. So technically
the file with spaces is there on the server to be loaded into SQL SERVER.
Here is the code :
!--- Upload file to shared folder. ---
cffile
action=upload
fileField=demographics_file
destination=#application.demographics_folder#
nameConflict=overwrite /
!--- Save file name. ---
cfset file_location = cffile.serverDirectory \ cffile.serverFile /
!--- Parse the file line by line. ---
cf_demographicParser str_Filename=#file_location#
So here the custom tag gets called and I check for errors in the file.
Now my question is, How can i make the changes made in custom tag i.e.
trim part saved in the file? maybe upload it again i.e. overwrite old
file??
Is this doable?? Plz suggest...
Thanks in advance...
On 12/22/06, Ajas Mohammed [EMAIL PROTECTED] wrote:
Thanks everyone.
Douglas Knudsen -- Will replace take care of tabs also??? or shall i
need to say chr(9) for example :
str_Token = Replace(trim(mid(arguments.str_Content, int_CurrPos,
int_NextPos - int_CurrPos)),' ','', 'All');
replaced with this code
cfset str_Token = Replace(Replace(trim(mid(arguments.str_Content,
int_CurrPos, int_NextPos - int_CurrPos)),' ','', 'All',Chr(9),'All');
Any suggestions?? should Chr(9) be in quotes???
Ajas Mohammed.
On 12/22/06, Teddy Payne [EMAIL PROTECTED] wrote:
If the records already exists in a database, you will need to run a
stored procedure to scrub and clean your data. Since you are running SQL
Server 2000, you can use table variables to perform this very quickly.
Example:
declare
@firstName varchar(50)
, @maxRows int
, @currentRow int
select
@currentRow = 1
declare @dataSet table
(
rowID int identity (1, 1) primary key not null
, pkID int
, firstName varchar(50) not null
)
insert into
@dataSet
select
firstName
from
tblFoo
select
@maxRows = count(rowID)
from
@dataSet
while @currentRow = @maxRows
begin
select
@firstName = firstName
, @pkID = pkID
from
@dataSet
where
rowID = @currentRow
select @firstName = LTrim(RTrim(@firstName))
update
tblFoo
set
firstName = @firstName
where
pkID = @pkID
select @currentRow = @currentRow + 1
end
Kind of like that. You can scrub full tables at a time by adding more
columns to the table variable.
Teddy
On 12/22/06, Douglas Knudsen [EMAIL PROTECTED] wrote:
not sure of the SLQ Server stuff, but in the CF code below you can
utilise: Trim(Replace(myString,' ','')). Actually, looks like the code is
already using Trim(), just need to add the Replace() as above to remove
intermediate spaces.
str_Token = Replace(trim(mid(arguments.str_Content, int_CurrPos,
int_NextPos - int_CurrPos)),' ','', 'All');
DK
On 12/21/06, Ajas Mohammed [EMAIL PROTECTED] wrote:
Hello everyone,
I need help on this one real quick. One of my colleauges used this
custom CF tag which parses a tab delimited text file and stores in
array.
How do I add functionality to this code so that it would trim all the
spaces
i.e either left or right or if value sent in txt file has
spaces?
If you understand the code , that will be great and if you could
pinpoint me to what needs to be done, then nothing like it... Also any
explanation of this code will help a lot.
I tried ltrim(rtrim(colvalue)) while inserting records but it
doesnt work in sql server 2000. Once records are inserted in table, I
am not
able to trim the records.. If you know any sql server 2000 fix for
removing
extra spaces left or right or remove extra spaces for values which are
sent
with empty tabs or spaces???
Thanks in advance..if u cant open attachment , here is the code...
cfparam name=attributes.str_Filename default= /
cfparam name=attributes.str_LineDelimiter
default=#chr(13)##chr(10)# /
cfparam name=attributes.str_TokenDelimiter default=#chr(9)#
cffunction name=TokenizeLine returntype=array
cfargument name=str_Content type=string required=true
/
cfargument name=str_Delimiter type=string required=true
/
cfset var ar_Tokens = arrayNew(1) /
cfset var int_CurrPos = 1 /
cfset var int_NextPos = 1 /
cfset var str_Token = /
cfscript
int_NextPos = REFind(#arguments.str_Delimiter#|$,
arguments.str_Content, int_CurrPos);
while (int_NextPos gt 0)
{
str_Token = trim(mid
Re: [ACFUG Discuss] Starting the New Year with ACFUG
Precia, That was a good recap of the evenings festivities. I will second that it was indeed was a solid meeting! =) Josh and Andy provided some great material. It is great to see ColdFusion(CFML) pushed into even more avenues of flexibility. CFML will soon be so diverse that Swiss Army will start feeling threatend. I also thank the group for the oppurtunity to win the BD JX server. I believe knowing both Adobe's and New Atlanta's offerings will give me a greater depth of knowledge for myself that translates into more options for my clients. The RSVP note was indeed important to note. I suspect we did not have enough pizza and frosty beverage for all of those who wanted to partake. All in all, I hope to see everyone at either the next ACFUG or the AFFUG meeting. I shall be attending both. I would gladly share another frosty beverage with anyone willing to come. Cheers, Teddy On 1/4/07, Precia [EMAIL PROTECTED] wrote: Brooks, This is a good point to bring up. I miss classses on Wednesday, as well. The first meeting is to get a voice from interested parties about such issues. I can not change the January date, but I will make an effort to get this changed to another day of the week. Precia On 1/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Precia: It was a good meeting with a good turn out. I know that the AFFUG has settled on the 3rd Wednesday of the month to meet. I am interested in attending, but my church choir meets on Wednesday. I'm already missing the first Wednesday for ACFUG and really can't afford to miss another rehearsal every month. Would AFFUG consider meeting on another night of the week? If not, I may split my time between the two groups. P.S. We just launched our third Flex/Flash application. Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] *Precia [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/04/2007 02:51 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] Starting the New Year with ACFUG To all of the subscribers of our mailing lists, our members, board and sponsors and friends, ACFUG would like to extend a very Happy New Year to you for being a part of our community! Last night, ACFUG started off the New Year off in an exciting way. We had a great showing of people that included old friends and some new faces (Eric Gutke, Tony Terrana, Todd Tabberer, Sarah Chodrow). Thank you everyone for taking the time to come and be a part of the ACFUG experience. The January meeting introduced several fresh ideas to the group. The new location was a collaboration of FusionLink and echo•eleven to provide a comfortable meeting location. Thank you John Mason of FusionLink for providing the meeting facilities and Scott Talsman of echo•eleven for extending hospitality to our members mingling in the echo•eleven facilities. New Atlanta of the BlueDragon fame provided a grand prize this past meeting with a free license of BlueDragon 6.2 JX server. Congratulations to Teddy Payne for winning!ACFUG extends a special thank you to Josh Adams and Richard Baker from New Atlanta for taking the time to help make our first meeting of the year more enjoyable and helping our group learn about the new features of BlueDragon 7. New Atlanta did not stop there as they sponsored the after party that compromised of adult beverages and snacks. Andy Powell of Universal Mind demonstrated yet another way that ColdFusion can be used in an AJAX based project from Adobe called Spry. Many of our members have heard of AJAX and Spry in recent days, but an actual testament of the usefulness of Spry reinforces a way to discern how and when to use Spry. The new user group, *Atlanta Flash Flex User* group (AFFUG) that will be meeting on the third Wednesday of each month. The topics covered 1/17/07 will be… Taming the Flex Wizard Shrew Jump into Flex with this tutorial on how to use the Flex wizards. Start using Flex and appreciating the power of Flex by using the Flex wizard to quickly and simply create rich interfaces. This tutorial will also go over what is happening during the wizard creation so that you can learn even more about good Flex code. Let's start creating mountains from a mole hill of work. Introduction to Flex Charting How do I populate a Flex chart component with data? What type of data can be used?If you have asked these questions before, this session will not only answer these questions, but provide working examples demonstrating how to use hard coded data, XML and ColdFusion returned queries. Flex Drag and Drop with ColdFusion How can Flex make your interface more user friendly? Drag and Drop. We will be discussing
Re: [ACFUG Discuss] XML CF
XML is typicaly there for storage of information in a homogenous way. John's suggestion of WDDX makes short hand of CFML constructs and is adaptable to JS and XML format. XML is used for configuration files, datasources and webservices just as a couple of examples. A lot of Flex examples use XML as a way to have a datasource for demo code without needing a remote call. If the test is for demo only, XML datasources work nicely. Teddy On 1/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: For this project, a) I'm learning it, b) figured it would be easier to deal with than creating a database and dealing with the ISP. But for another project, I'm looking at using it for faking that a prototype is working for demo purposes - namely because the database is REALLY complex. mcg *Chris C. Cooper [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/02/2007 08:40 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] XML CF What is a practical use for XML? What kind of situation would call for using it? -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Andrew Powell* Sent:* Monday, January 01, 2007 8:54 PM* To:* [EMAIL PROTECTED] Subject:* Re: [ACFUG Discuss] XML CF Also, I would suggest Jeff Peters' book on the CF XML Object: *http://www.cafepress.com/protonarts.50984013*http://www.cafepress.com/protonarts.50984013 ap On Jan 1, 2007, at 8:31 PM, Andrew Powell wrote: 1. Read the XML file with CFFILE 2. Parse the xml string with xmlParse() --optional, but recommended-- narrow your XML document down to an array of of your data elements using xmlSearch() and the xPath to your data 3. loop over data and do what you will with it (conditionals to check, etc.) 4. write it back to the server or whatever storage space you are using (database, etc.) As far as writing back the whole XML doc, that may be a matter of *not*using xmlSearch() and working with the whole document instead. I'm not sure if xmlSearch() returns its array by reference or by value. Someone else may be able to clear this up. In the livedocs someone says that searches on the same XML doc *are NOT thread-safe within a shared scope*. This leads me to think that the array returned by xmlSearch() is returned is a reference to the original xml doc. If that is the case, then you can just manipulate that data in the array that xmlsearch() returns and then write the original xml back to a string with changes intact. I would not write it to an array of structs or a query if you're going to write back as XML to the server or database. Just manipulate the original XML doc and save the processing of conversion. To write it back to the server, you just toString(myXMLObj) within your CFFILE action=write tag. On Jan 1, 2007, at 8:12 PM, [EMAIL PROTECTED][EMAIL PROTECTED]wrote: I've not really worked with XML and CF. I've gotten some basics down, and have looked, but am iffy on my logic. -You read the XML file -Read the length of the data from the XmlChildren array -Loop over the parsed XML to put things into a query -Output data or whatever -Now to get a specific 'record', you do the same above, except putting an if statement in your loop to add things your query (or select the specific item in the query) -To add/ modify/ delete things, you do whatever to the query, convert it to XML (or modify the XML object itself) and then rewrite the XML file This sounds cludgy to me, I've got to be missing something. What if you have a large dataset (which I won't in this case)? Thanks, mcg (Yes it's New Year's Day, but working on mom's website, and the USC - MICH game isn't terribly interesting) - 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 *http://www.fusionlink.com* 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/ - - To unsubscribe from this list, manage your profile @
Re: [ACFUG Discuss] XML CF
I need to chime in here. Charlie has given me this PDF in the past and I have used the sample code in it more than once now. It is a great and quick read. The types of examples are exactly what you need half the time. Teddy On 1/2/07, Charlie Arehart [EMAIL PROTECTED] wrote: MCG, your initial explorations with XML and CF are not unusual. You've gotten some good tips here so far. I'd like to offer a couple more--and not just for Mary-Catherine but for anyone learning to deal with XML in CF. It's one of those topics where--especially if you're new to XML in general--I'd argue one would NOT be well-served by just looking at/copying code snippets. You really need to get it first or you'll end up chasing your tail. Further, there are often many ways to do something (even more than what' s been proposed here). The best resource I ever found, and which really sparked an Aha! moment for me when I first read it a few years ago, is Nate Weiss's 30-page article: http://www.adobe.com/devnet/coldfusion/articles/xmlxslt.pdf It's a real page-turner. Seriously. :-) Don't let the 30 pages scare you off. You'll come out of it after an hour or so with tremendous appreciation for what XML processing in CFML is about, including tips and techniques that you might have struggled with to learn on your own. It was actually a chapter in the original CFMX version of the WACK book which he was permitted to release online. A wonderful resource, and as timely now as when it was first released. To address the why would I want to bother that Chris raised, in addition to Teddy's point about Flex, another is that Spry and indeed many Ajax solutions also leverage XML. Also, often one is given a file to read, whether for data interchange as Andy indicated or for reading a file already on your computer, since so many tools (including CF) now use XML files for configuration. /Charlie http://www.carehart.org/blog/ -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of * [EMAIL PROTECTED] *Sent:* Tuesday, January 02, 2007 10:04 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] XML CF I will be using CF to get things in and out, just not sure of the best logic. I'm been looking at the docs plus some other sites out there and copying code snippets. Hoping it will set up some of the page flow for later on. Come on, trying to learn stuff here. :) mcg *Steven Ross [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/02/2007 09:23 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] XML CF If you are faking something for demo data use WDDX, it will be a whole lot easier to use in CF. On 1/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Like I said, for faking things for demo purposes (figured it would be quick and dirty) and mom's little website (not much data). :) mcg Teddy Payne [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2007 09:02 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] XML CF XML is typicaly there for storage of information in a homogenous way. John's suggestion of WDDX makes short hand of CFML constructs and is adaptable to JS and XML format. XML is used for configuration files, datasources and webservices just as a couple of examples. A lot of Flex examples use XML as a way to have a datasource for demo code without needing a remote call. If the test is for demo only, XML datasources work nicely. Teddy On 1/2/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: For this project, a) I'm learning it, b) figured it would be easier to deal with than creating a database and dealing with the ISP. But for another project, I'm looking at using it for faking that a prototype is working for demo purposes - namely because the database is REALLY complex. mcg Chris C. Cooper [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2007 08:40 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] XML CF What is a practical use for XML? What kind of situation would call for using it? From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of Andrew Powell Sent: Monday, January 01, 2007 8:54 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] XML CF Also, I would suggest Jeff Peters' book on the CF XML Object: http://www.cafepress.com/protonarts.50984013 ap On Jan 1, 2007, at 8:31 PM, Andrew Powell wrote: 1. Read the XML file with CFFILE 2. Parse the xml string with xmlParse() --optional, but recommended-- narrow your XML document down to an array of of your data elements using xmlSearch() and the xPath to your data 3. loop over data and do what you will with it (conditionals to check, etc.) 4. write it back to the server or whatever
Re: [ACFUG Discuss] Spam Filtering Tools
The only time that I use Outlook is for when I am at the office. The Exchange server has a spam filter. I do not trust Outlook with my contacts. For my professional and personal accounts, I have a Google Mail (gmail) account which has a good filter for spam and not allowing picture downloads unless you request them. The standard tip for spam is never use the Unsubscribe feature unless it was a service you originally signed up for. I am not sure that helps you, but when I must use Outlook I will relay it through my gmail and then forward the email after it has processed the spam through to Outlook. Teddy On 12/27/06, Clarke Bishop [EMAIL PROTECTED] wrote: I don't know if it's just me, but it seems like I'm getting more and more spam these days. Do any of you have spam filtering tools that are working well for you and will integrate with Outlook? Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] CF. Object oriented its future. General Questions.
I also forgot conference. I suggest CF United for CF related work and Adobe MAX for Flex realted work. There is also CF Objective and CF Frameworks conferences as well. This of course is subject to availability and cost for you or your employer. Teddy On 12/27/06, Teddy Payne [EMAIL PROTECTED] wrote: Ajas, From what I read of your synopsis, you have the right idea going forward. The only thing that I would watch out for is the buzz word Agile. I would call that a recent fad if you will. I would suggest reading about it and seeing what are the practical practices are. Your knowledge of the database will make your CF easier. I would recommend upgrading your SQL Server knowledge to include 2005. The transition is not that difficult. Oracle exposure is hard due to the cost typically for organizations. The same can be said about CF, but that is a die hard argument. Also, I recommend getting on CF mailing lists (House of Fusion). If you already have, that is great. Another approach is to help an open source project or create an open source project to get exposure with working with your community more. And lastly and always, attend your local CFUG to get local exposure. ;) Teddy On 12/27/06, Ajas Mohammed [EMAIL PROTECTED] wrote: Thanks for all the replies. The comments from everyone make a lot of sense. I guess I will try to work on my datastructures concept in either java or C#. I have heard that majority of big companies like amazon ask questions related to datastructures, OOP's concepts etc so learning them might help in future. Just a quick overview of what I usually do so you guys can suggest something to me. I am working in CF for almost 2 years now with SQL Server 2000 as backend. Work involves development plus lot of maintenance. I also work extensively on SQL Server using Procedures, T-SQL, DTS etc. I have lot of interest in Web Technologies and in free time I work on building websites and CSS being one of the hobbies. I am believer in best practices, coding standards, commenting, Agile methodologies and I spend good time reading books and visiting forums. Dont have big plans for now but want to be an Web Architect or something like that. Trying to learn as much CF as I can. I want to know about every CF feature or cool thing out there and try it out. I have certifications in Oracle but didnt get much work exposure in it. I have thoughts of becoming Jr Oracle DBA by making switch but then I am not sure since I have already spent 2 yrs in CF and I think I am mid level developer in that. I pretty much do any work given to me. Like for Example I did Subversion setup stuff in my company. So thats the story. Some of my work http://geocities.com/masjid_annour/ http://impetusindia.org/ http://ajashadi.blogspot.com/2006/07/my-work-snapshots-please-comment.html Thanks once again for all the help. I really appreciate your time and patience. Ajas Mohammed. On 12/27/06, Dean H. Saxe [EMAIL PROTECTED] wrote: And the term architect or lead is also abused heavily in the industry. I can't tell you the number of lead developers or architects I have met who couldn't design an app or code for sh!t! Often times people wind up with these titles because they have N years experience... but it doesn't mean they actually know how to do anything worth a damn. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Great spirits have often encountered violent opposition from weak minds. --Einstein On Dec 27, 2006, at 11:48 AM, Douglas Knudsen wrote: adding to the cornucopia here, I'll add that the idea of a Lead or Architect may vary greatly from company to company or within a large organization. An Architect on team A using CF Technology might have no knowledge of Java at all that a Architect on team B does and conversely. Further more, their respective responsibilities maybe quite different, one may even code whilst the other lives in UML world. DK On 12/27/06, Teddy Payne [EMAIL PROTECTED] wrote: I am a little late on this thread and Charlie has provided a plethora of knowledge. To be a lead at anything, it first starts out with your personal character. Can you lead well? Do people look to you? Are people confident in your ability? I studied computer science before and really all you need is to learn the theory of architecture. Let me stress the word theory here. In computer science, you learn to apply the same pricipals over and over again to languages that only differed in syntax or implementation. Can you be a lead as a CF'er? Sure. Does knowing OO help? You betcha. Do I have to be uber Java guy to be an architect? Debateable. If you want to be an integration specialist, I would recommend learning Java with CF. If you want to be a future lead, you will have to learn to detach from code eventually. Higher
Re: [ACFUG Discuss] Problem with XML
I also got the same error, but it depends on what you want to do with the XML. What are you looking to learn from the snippet? Are you trying to get child nodes, attributes or values? Teddy On 12/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: This example is straight from the O'Reilly book Programming ColdFusion MX by Rob-Brooks-Bilson, but I can't get it to work. cfxml variable=myXml !-- employees for example.com -- company name=example.com !-- begin employee listings -- employee id=1 years-service=10 namePere Money/name titlePresident/title /employee employee id=2 years-service=5 nameAaron Ridge/name titleAnalyst/title /employee employee id=3 years-service=4 nameMartin Grant/name titleManager/title /employee /company /cfxml cfcontent type=text/xmlcfoutput#toString(myXml)#/cfoutput/cfcontent When I browse the page from within Homesite, and when I navigate to the page with IE, I get the following error: The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. End tag was not expected at this location. Error processing resource 'http://rtfustst.rtp.epa.gov/webteam/Practice/chapter0... /td/td/td/th/th/th/tr/tr/tr/table/table... If I cfdump the code, it looks like perfectly good XML. Any suggestions? ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Urgent help needed.. CF custom tag to read tab delimited text file. HOw to add trim functionality??
If the records already exists in a database, you will need to run a stored
procedure to scrub and clean your data. Since you are running SQL Server
2000, you can use table variables to perform this very quickly.
Example:
declare
@firstName varchar(50)
, @maxRows int
, @currentRow int
select
@currentRow = 1
declare @dataSet table
(
rowID int identity (1, 1) primary key not null
, pkID int
, firstName varchar(50) not null
)
insert into
@dataSet
select
firstName
from
tblFoo
select
@maxRows = count(rowID)
from
@dataSet
while @currentRow = @maxRows
begin
select
@firstName = firstName
, @pkID = pkID
from
@dataSet
where
rowID = @currentRow
select @firstName = LTrim(RTrim(@firstName))
update
tblFoo
set
firstName = @firstName
where
pkID = @pkID
select @currentRow = @currentRow + 1
end
Kind of like that. You can scrub full tables at a time by adding more
columns to the table variable.
Teddy
On 12/22/06, Douglas Knudsen [EMAIL PROTECTED] wrote:
not sure of the SLQ Server stuff, but in the CF code below you can
utilise: Trim(Replace(myString,' ','')). Actually, looks like the code is
already using Trim(), just need to add the Replace() as above to remove
intermediate spaces.
str_Token = Replace(trim(mid(arguments.str_Content, int_CurrPos,
int_NextPos - int_CurrPos)),' ','', 'All');
DK
On 12/21/06, Ajas Mohammed [EMAIL PROTECTED] wrote:
Hello everyone,
I need help on this one real quick. One of my colleauges used this
custom CF tag which parses a tab delimited text file and stores in array.
How do I add functionality to this code so that it would trim all the spaces
i.e either left or right or if value sent in txt file has spaces?
If you understand the code , that will be great and if you could
pinpoint me to what needs to be done, then nothing like it... Also any
explanation of this code will help a lot.
I tried ltrim(rtrim(colvalue)) while inserting records but it doesnt
work in sql server 2000. Once records are inserted in table, I am not able
to trim the records.. If you know any sql server 2000 fix for removing extra
spaces left or right or remove extra spaces for values which are sent with
empty tabs or spaces???
Thanks in advance..if u cant open attachment , here is the code...
cfparam name=attributes.str_Filename default= /
cfparam name=attributes.str_LineDelimiter
default=#chr(13)##chr(10)# /
cfparam name=attributes.str_TokenDelimiter default=#chr(9)#
cffunction name=TokenizeLine returntype=array
cfargument name=str_Content type=string required=true /
cfargument name=str_Delimiter type=string required=true /
cfset var ar_Tokens = arrayNew(1) /
cfset var int_CurrPos = 1 /
cfset var int_NextPos = 1 /
cfset var str_Token = /
cfscript
int_NextPos = REFind(#arguments.str_Delimiter#|$,
arguments.str_Content, int_CurrPos);
while (int_NextPos gt 0)
{
str_Token = trim(mid(arguments.str_Content, int_CurrPos,
int_NextPos - int_CurrPos));
arrayAppend(ar_Tokens, str_Token);
int_CurrPos = int_NextPos + len(arguments.str_Delimiter );
int_NextPos = REFind(#arguments.str_Delimiter#|$,
arguments.str_Content, int_CurrPos);
}
// If the line ends with a token, add
// an extra empty element to the array
if (len(arguments.str_Content) gt 0and mid(
arguments.str_Content, len(arguments.str_Content), 1) is
arguments.str_Delimiter)
{
arrayAppend(ar_Tokens, );
}
/cfscript
cfreturn ar_Tokens /
/cffunction
cfif ThisTag.ExecutionMode is Start
!--- Read the file and inititialize position and caller
variables. ---
cffile action=read file=#attributes.str_Filename#
variable=str_Content /
cfset int_CurrPos = 1 /
cfset caller.TextParse.str_Line = /
cfset caller.TextParse.ar_Tokens = arrayNew(1) /
/cfif
!--- Find the next delimiter. The regular expression
#attributes.str_LineDelimiter#|$
finds the next line delimiter OR the end of the string. ---
cfset int_NextPos = REFind(#attributes.str_LineDelimiter#|$,
str_Content, int_CurrPos) /
cfif int_NextPos gt 0
!--- Get and return the line and tokens. ---
cfset str_Line = mid(str_Content, int_CurrPos, int_NextPos -
int_CurrPos) /
cfset caller.TextParse.str_Line = str_Line /
cfset caller.TextParse.ar_Tokens = TokenizeLine(str_Line,
attributes.str_TokenDelimiter) /
!--- Reset the current position. ---
cfset int_CurrPos = int_NextPos + len(attributes.str_LineDelimiter)
/
/cfif
cfif ThisTag.ExecutionMode is End
!--- Keep looping as long as we have content to process. ---
cfif int_NextPos gt 0
cfexit method=Loop /
/cfif
/cfif
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform
Re: [ACFUG Discuss] image generator/validator spam prevention
1) Captcha (http://en.wikipedia.org/wiki/Captcha) 2) http://lyla.maestropublishing.com/ On 12/21/06, Tepfer, Seth [EMAIL PROTECTED] wrote: I know this has come up previously, but I don't know what to search for. I need to generate an image that has that skewed text on it, so that spammers can't read it, to validate the form submission is a human. 1) What do you *CALL *that* *thing? 2) Do you know if there is a tag or function out there somewhere (hopefully free) that auto generates it? Thanks seth - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] image generator/validator spam prevention
Seth, This may help you http://akismet.com/faq/ And check this out: http://devnulled.com/cfakismet Teddy On 12/21/06, Tepfer, Seth [EMAIL PROTECTED] wrote: Thanks for the help – depressing as it might seem. Well, I'm going to try Emerle for now and I'll start implementing a blacklist. What a pain! Thanks again. seth - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] Smith Project
Vince, That is excellent adoption of JVM integration. I can hope Adobe picks up on this trend as well. Teddy On 12/18/06, Douglas Knudsen [EMAIL PROTECTED] wrote: I've heard of some folks using Java 5 with CF. Seems these cases though only require standard CFML or something. I tried it for kicks, kills webservices and cfldap IIRC. DK On 12/18/06, Teddy Payne [EMAIL PROTECTED] wrote: I am just hoping the support of Java 5 will help alleviate previous bottlenecks. It is sad to see graphs of various performance charts and Adobe ranks pretty poorly. I understand some of these charts are deceptive and situational, but none-the-less you want Adobe as the original owner to look just as good. Teddy On 12/18/06, Robert Reil [EMAIL PROTECTED] wrote: VERY interesting... 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 -- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *Sent:* Monday, December 18, 2006 11:53 AM *To:* Carbs SalesService *Subject:* [ACFUG Discuss] Smith Project Anyone seen this yet? http://www.smithproject.org/ Smith is a freeware, cross-platform ColdFusion engine, written entirely in Java. Running on the top of *Java Runtime Environment* and *Java Servlet Container *, it can be virtually deployed on any operating system and work with any web server. Smith represents lightweight, yet reliable alternative to the existing ColdFusion servers. It supports most important CF features (see *Features*http://www.smithproject.org/product_features.cfm) and already drives several large ColdFusion applications. Deeply integrated in J2EE, Smith works as part of ordinary Java Web application and can easily be used together with servlets and JSPs. The server behaviour is easily configurable through the simple Web interface where database connections, debugging options, server mappings and more can be set. Smith is freeware software, which means that it comes with permission for anyone to use, copy, and distribute it. It is also being seriously considered to open-source it. Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Smith Project
I am just hoping the support of Java 5 will help alleviate previous bottlenecks. It is sad to see graphs of various performance charts and Adobe ranks pretty poorly. I understand some of these charts are deceptive and situational, but none-the-less you want Adobe as the original owner to look just as good. Teddy On 12/18/06, Robert Reil [EMAIL PROTECTED] wrote: VERY interesting... 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 -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *Sent:* Monday, December 18, 2006 11:53 AM *To:* Carbs SalesService *Subject:* [ACFUG Discuss] Smith Project Anyone seen this yet? http://www.smithproject.org/ Smith is a freeware, cross-platform ColdFusion engine, written entirely in Java. Running on the top of *Java Runtime Environment* and *Java Servlet Container*, it can be virtually deployed on any operating system and work with any web server. Smith represents lightweight, yet reliable alternative to the existing ColdFusion servers. It supports most important CF features (see *Features* http://www.smithproject.org/product_features.cfm) and already drives several large ColdFusion applications. Deeply integrated in J2EE, Smith works as part of ordinary Java Web application and can easily be used together with servlets and JSPs. The server behaviour is easily configurable through the simple Web interface where database connections, debugging options, server mappings and more can be set. Smith is freeware software, which means that it comes with permission for anyone to use, copy, and distribute it. It is also being seriously considered to open-source it. Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] unit testing
http://www.asfusion.com/blog/entry/cfcunit-runner-released On 12/15/06, Douglas Knudsen [EMAIL PROTECTED] wrote: http://corfield.org/blog/index.cfm/do/blog.entry/entry/cfcUnit_Runner_Flex_app with repect to a recent cf_lunch :) w00t! Swear I saw another runner around recently on a blog, but alas, too many disparate bookmark lists! DK On 12/14/06, Steven Ross [EMAIL PROTECTED] wrote: CFCUnit is good for most things just make sure when you are setting up your tests that you customize your fail scenarios to include your object/variable that fails. I've also had some issues with debugging giving me bad error messages (saying one thing when actually it was another) I think that has to do with the try/catch mechanism. I havent tried cfunit On 12/14/06, Douglas Knudsen [EMAIL PROTECTED] wrote: ok, I'm wanting to start messing with unit testing of CFCs and introduce it to some staff. I must admit, I'm a bit behind on this topic. I see two projects about cfcUnit and CFUnit. Any opinions on these? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 928-484-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] OT: Client talking points
Seth, You also have to look at your selling point. The client did not make this decision on his/her own. Someone has influenced this person. Are you primarily a CF developer? This may be a deal breaker if you cannot deliver the product in the same amount of time as if it was written in CF. Just real quick: CF can be deployed using more than just Microsoft products, so legacy support and future hybrid network topologies is possible. Teddy On 12/7/06, Tepfer, Seth [EMAIL PROTECTED] wrote: I have been in the preliminary stages with a client. I had set up an extensive project charter and a prototype website. Suddenly this client emails me last night and says I think I should be using .net instead of ColdFusion. Let's meet on Thursday afternoon and discuss this I am looking for some quick and dirty speaking points to say why CF over other languages (including .net). The obvious ones to me are * rapid development * ease of maintenance * less time in development/maintenance = lower bottom line * other? * stats to justify this? I do not want to start a flame war over .net versus CF. I'm just looking for speaking points (perhaps with some URLs for reference for some useful statistics). Any help would be appreciated. If this has been done previously and is archived in an FAQ, please point me in the right direction. I didn't see clear case justification at the Adobe/MM site – is it there and I just missed it? Thanks. Seth - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] OT: Client talking points
Not to mention, what can't CF plug into? Every major RDBMS is supported with either native drivers or the ability to use JDBC drivers that worked rather seamlessly. CF uses every major OS. CF uses every major web server as well. Teddy On 12/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: What about support? I know CF has a large community as well (AKA free support). What about BlueDragon (if you don't already have an Adobe CF server)? We had a customer say that they didn't want a calendar in our application because it would take to long to program. Um, cfcalendar anyone? mcg *Clarke Bishop [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 12/07/2006 11:25 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] OT: Client talking points Hi Seth. I am first and foremost a business guy. I'm currently managing projects in both .Net and ColdFusion. Of course, both work great and can be used to create nearly any application. Unless there's a compelling reason to use .Net (The project is for Microsoft or there's some other religious commitment to .Net), I prefer ColdFusion. The only downside is the extra cost to license CF, but this is quickly made up through: - Faster Development - Lower Cost Development - In general, CF developers with comparable capabilities are less expensive than their .Net counterparts. I don't have any stats for you, but this is the bottom line: Faster, Cheaper, and Just as Good. Clarke -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Tepfer, Seth* Sent:* Thursday, December 07, 2006 9:05 AM* To:* [EMAIL PROTECTED] Subject:* [ACFUG Discuss] OT: Client talking points I have been in the preliminary stages with a client. I had set up an extensive project charter and a prototype website. Suddenly this client emails me last night and says I think I should be using .net instead of ColdFusion. Let's meet on Thursday afternoon and discuss this I am looking for some quick and dirty speaking points to say why CF over other languages (including .net). The obvious ones to me are * rapid development * ease of maintenance * less time in development/maintenance = lower bottom line * other? * stats to justify this? I do not want to start a flame war over .net versus CF. I'm just looking for speaking points (perhaps with some URLs for reference for some useful statistics). Any help would be appreciated. If this has been done previously and is archived in an FAQ, please point me in the right direction. I didn't see clear case justification at the Adobe/MM site – is it there and I just missed it? Thanks. Seth - 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/ - - 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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] Read Receipts
I dislike the read receipt as well, but I have all my mail accounts sent to my gmail, so if the read receipt is actually happening then I would not know. Teddy On 12/7/06, John Mason [EMAIL PROTECTED] wrote: Thanks for catching that. I was about to send you an email to let me know. Take the following as an honest opinion. I don't want to anger anyone on this, but read-receipts are one of those things I have a problem with. It's nothing against you Mark or anyone else who uses them. I know it's a popular tool that people use. But I really don't see a good reason why anyone needs a receipt when/if I view an email. When you think about it, it's a bit rude actually. IMHO, I rather wish that it was never created in the first place. Ok, I got that off my chest. I'll check to see if there's some way to strip that out of the headers, but on the flip side, it would be far easier just to turn it off on the client side. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell, Mark P. Sent: Thursday, December 07, 2006 11:51 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Read Receipts Is there anyway a mail server could be setup to strip out the read_receipt requested part of the mail header so that idiots like myself who forget to turn the option off before sending mail to the list don't have to share their memory lapses? Just curious. Thanks. mf mark fennell athens regional medical center athens, ga - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.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 - - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] installing CF 701 or 702 dev edition on xp tablet edition
That is not good. This may be a case for either BD .Net or Railo. I am not sure of their supported systems. Perhaps others ahve deployed other CF flavors on custom PC solutions. Teddy On 12/6/06, Max Immelman [EMAIL PROTECTED] wrote: Teddy, Thanks for your prompt reply. The services you mention do not exist. Adobe documentation states supported OS's for Windows is XP home pro (and others), the exact OS is Microsoft windows XP tablet edition 2005, version 2002. I'm going to be on the road from now until 5pm today, so I won't be able to reply. But I'm desperately in need of a work around so if any of have any ideas please let me know, thx! Max - Original Message - *From:* Teddy Payne [EMAIL PROTECTED] *To:* discussion@acfug.org *Sent:* Wednesday, December 06, 2006 10:51 AM *Subject:* Re: [ACFUG Discuss] installing CF 701 or 702 dev edition on xp tablet edition When you installed CF 7, did it register ColdFusion MX 7 ODBC Agent and ColdFusion MX 7 ODBC Server in your XP services? If the servervices were loaded, are they started? Teddy On 12/6/06, Max Immelman [EMAIL PROTECTED] wrote: Hi all, I'm having a problem installing CF7 dev version on a XP tablet edition. Anyone done this before? It seems like the install is successful but no ODBC services exist. I checked the registry and there's nothing. I'd appreciate any help on this. Thanks in advance! Max Immelman Cell: (404) 409-6785 or txt/pic/vid [EMAIL PROTECTED] Skype: maxlegend http://www.JustRightBaskets.com http://www.justrightbaskets.com/ - consider us for your corporate Christmas gifts! - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] cftree
If you have a swf, supposedly this works: http://blog.deconcept.com/swfobject/ Teddy On 12/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Are you sure that you can do that? I thought that MS introduced the ActiveX control activation concept because they got sued. Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 *Jeff Howard [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 12/06/2006 03:09 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] cftree Hey, Figured I'd give it one more shot. Anyone have a link to a solution to have my an ActiveX control (cftree) activitated automatically in IE, please? I found a couple googling them but neither worked properly. Thanks, Jeff On 12/6/06, *Jeff Howard* [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hey there, I have one more question about cftree that I was hoping one of you gurus could help me decide on. I was asked to make it so you do not have to click on the cftree control in IE after loading the page. I've been googling about and it seems like there are quite a few solutions out there. The 2 that I've tried so far don't work correctly. So, I ask you if you have a solution that you use or can point me in the direction of one that funtions. Thanks in advance, Jeff - 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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Detecting Missing .cfm Templates
Well, you didn't say that you had IIS access. I have seen tricks with 404.htm that is handled by a 404.cfm before. I have that archived someplace from cf-talk. Teddy On 12/6/06, Clarke Bishop [EMAIL PROTECTED] wrote: Thanks for all the ideas. I think I can specify a 404 page via IIS, so I am going to try to do that. I played with it once before, but didn't get too far, and I was hoping there was another way. Thanks again, Clarke -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Tuesday, December 05, 2006 10:50 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] Detecting Missing .cfm Templates .htm? what is that? There is no html anymore. There is only parsed html. Bah! Teddy On 12/5/06, John Mason [EMAIL PROTECTED] wrote: Well that will do the trick for cfml pages but what about .htm files, etc. What is needed Clarke is for the 404 errors to be directed to a custom 404 page that you build in cfml. That will grab any missing file for sure. John [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Tuesday, December 05, 2006 8:05 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] Detecting Missing .cfm Templates Yes, BlueDragon does have an extra method for MissingTemplate. Not having access to the webserver or admin does make this very difficult. I am not sure you can achieve this unless you have your application.cfcusing the onRequest method to try and include every request and then if the request fails, then you cflocation over to the error page. Teddy On 12/5/06, Justin Haygood [EMAIL PROTECTED] wrote: I think you can if you're using BlueDragon, not sure if you can with CFMX. *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Clarke Bishop *Sent:* Tuesday, December 05, 2006 5:09 PM *To:* discussion@acfug.org *Subject:* RE: [ACFUG Discuss] Detecting Missing .cfm Templates No, just anywhere, including a user typing the URL in their browser or via bookmark. -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Tuesday, December 05, 2006 5:01 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] Detecting Missing .cfm Templates Are the missing templates being called from cfinclude? Or just handling missing .cfms just anywhere? Teddy On 12/5/06, *Clarke Bishop* [EMAIL PROTECTED] wrote: Is there a way to use Application.cfc's onError or onRequestStart methods to detect and handle a missing or moved .cfm template? Or is there another way to do this? I know there's a missing template section in CF Admin, but I am doing this on a shared host, and I can't access admin functions. Also, I can't use any server-level missing template functions. Thanks for any ideas! Clarke - 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 Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 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 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 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/ - -- cf_payne / Adobe
Re: [ACFUG Discuss] cftree
Only thing I can say at this point is to make a flex object and load the SWF. Teddy On 12/6/06, Jeff Howard [EMAIL PROTECTED] wrote: this is a solution that my team leader pointed me too that he used (and is actually exactly what made him request that i do it) but it renders an empty cftree control. thanks though. On 12/6/06, Teddy Payne [EMAIL PROTECTED] wrote: If you have a swf, supposedly this works: http://blog.deconcept.com/swfobject/ Teddy On 12/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Are you sure that you can do that? I thought that MS introduced the ActiveX control activation concept because they got sued. Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 *Jeff Howard [EMAIL PROTECTED] * Sent by: [EMAIL PROTECTED] 12/06/2006 03:09 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] cftree Hey, Figured I'd give it one more shot. Anyone have a link to a solution to have my an ActiveX control (cftree) activitated automatically in IE, please? I found a couple googling them but neither worked properly. Thanks, Jeff On 12/6/06, *Jeff Howard* [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hey there, I have one more question about cftree that I was hoping one of you gurus could help me decide on. I was asked to make it so you do not have to click on the cftree control in IE after loading the page. I've been googling about and it seems like there are quite a few solutions out there. The 2 that I've tried so far don't work correctly. So, I ask you if you have a solution that you use or can point me in the direction of one that funtions. Thanks in advance, Jeff - 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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Detecting Missing .cfm Templates
Are the missing templates being called from cfinclude? Or just handling missing .cfms just anywhere? Teddy On 12/5/06, Clarke Bishop [EMAIL PROTECTED] wrote: Is there a way to use Application.cfc's onError or onRequestStart methods to detect and handle a missing or moved .cfm template? Or is there another way to do this? I know there's a missing template section in CF Admin, but I am doing this on a shared host, and I can't access admin functions. Also, I can't use any server-level missing template functions. Thanks for any ideas! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Detecting Missing .cfm Templates
.htm? what is that? There is no html anymore. There is only parsed html. Bah! Teddy On 12/5/06, John Mason [EMAIL PROTECTED] wrote: Well that will do the trick for cfml pages but what about .htm files, etc. What is needed Clarke is for the 404 errors to be directed to a custom 404 page that you build in cfml. That will grab any missing file for sure. John [EMAIL PROTECTED] -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Tuesday, December 05, 2006 8:05 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] Detecting Missing .cfm Templates Yes, BlueDragon does have an extra method for MissingTemplate. Not having access to the webserver or admin does make this very difficult. I am not sure you can achieve this unless you have your application.cfcusing the onRequest method to try and include every request and then if the request fails, then you cflocation over to the error page. Teddy On 12/5/06, Justin Haygood [EMAIL PROTECTED] wrote: I think you can if you're using BlueDragon, not sure if you can with CFMX. *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Clarke Bishop *Sent:* Tuesday, December 05, 2006 5:09 PM *To:* discussion@acfug.org *Subject:* RE: [ACFUG Discuss] Detecting Missing .cfm Templates No, just anywhere, including a user typing the URL in their browser or via bookmark. -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Tuesday, December 05, 2006 5:01 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] Detecting Missing .cfm Templates Are the missing templates being called from cfinclude? Or just handling missing .cfms just anywhere? Teddy On 12/5/06, *Clarke Bishop* [EMAIL PROTECTED] wrote: Is there a way to use Application.cfc's onError or onRequestStart methods to detect and handle a missing or moved .cfm template? Or is there another way to do this? I know there's a missing template section in CF Admin, but I am doing this on a shared host, and I can't access admin functions. Also, I can't use any server-level missing template functions. Thanks for any ideas! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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
Re: [ACFUG Discuss] cftree
Here is a flash form way of how AS Fusion handled documents: http://www.asfusion.com/projects/fileexplorer/ I use it to manage my file directory easier than Wndows Explorer for my web related tasks. Teddy On 12/4/06, Jeff Howard [EMAIL PROTECTED] wrote: Hey all, I've not used this control before but I was wanting to use it for a document control application I am developing. I am having an issue with however that I'm hoping someone can help with. My tree is either expanded or collapsed but I can't seem to get it to work like a true tree control where when you click on a folder it expands or collapses. Is this an issue with CFTree or am I just overlooking something. I tried experimenting with the 'expand' parameter but it has no effect on the function of the tree. It either makes the tree expanded and unable to collapse on 'yes' or collapsed and unable to expand when set to 'no'. Any insight would be greatly appreciated. Thanks in advance. Jeff Howard - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] cftree
Jeff, As for the CFTree not expanding or expanding, the example that I sent you does both and allows for CFTree to populated dynamically in a flash form from a database. So in short, CFTree does have the technology. Teddy On 12/4/06, Charlie Arehart [EMAIL PROTECTED] wrote: Jeff, a couple places to start to help would be to ask what version of CF you are using, and if CFMX or above, whether you are using the format=Flash or the older (default) java applet-based approach. Better still, though, have you tried the samples that are provided with CF in the Getting Started Experience? Assuming you installed those and/or the docs, there are examples of both types, and more trees (XML and object) at: serverCFIDE/gettingstarted/experience/snippets/Tags/cftree/ They work fine for me and do demonstrate the expansion of folders that you're asking about. If you don't have them installed, let me know and I'll email you the 2 example files (they stand alone) off-list. /Charlie http://www.carehart.org/blog/ -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jeff Howard *Sent:* Monday, December 04, 2006 10:32 AM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] cftree Hey all, I've not used this control before but I was wanting to use it for a document control application I am developing. snip - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 - attachment: image002.jpg
Re: [ACFUG Discuss] Frame bustin'
Ok, you three are scary. That code was all the same.
Teddy
On 12/1/06, Justin Haygood [EMAIL PROTECTED] wrote:
If (window.top.location != window.location ) window.top.location =
window.location;
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Derrick
Peavy
*Sent:* Friday, December 01, 2006 11:27 AM
*To:* discussion@acfug.org
*Subject:* [ACFUG Discuss] Frame bustin'
Anyone have a good, working method of frame busting? I ask because the JS
i have been using does not work when someone uses a web proxy (annon.) to
browse a site.
Examples that do not work (among many):
SCRIPT LANGUAGE=JavaScript
if (top.frames.length!=0)
top.location=self.document.location;
/SCRIPT
script
if (parent.frames.length 0) {
parent.location.href = self.document.location
}
/script
When someone uses a service such as http://www.anonymousproxyworld.com/
they can strip the javascript but even when they don't, it does not work.
They frame the page and append the meta data with their URL.
_
*Derrick Peavy*
*Sales and Web Services *
*Universal Advertising*
*Phone: 404-786-5036*
*Fax: 404-370-0470 *
http://www.universaladvertising.com
http://www.collegeadvertising.com
http://www.collegeclassifieds.com
*___*
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserformhttp://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/
-
--
cf_payne /
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.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
-
Re: [ACFUG Discuss] MS 2k and CF/JRun and time zone patch
Have you dumped out now() on the servers? Are they correct? Teddy On 11/30/06, Douglas Knudsen [EMAIL PROTECTED] wrote: they were reset after the patch when the box was rebooted. I'm told the TZ piece was only a registry change too concerning when DST starts/stops. DK On 11/30/06, Teddy Payne [EMAIL PROTECTED] wrote: Were the CF isntances brought down during the patch? Teddy On 11/30/06, Douglas Knudsen [EMAIL PROTECTED] wrote: yeah, but at the OS level its set correctly. AFAIK, nowhere to change this in CF server. DK On 11/30/06, Bryan Tidd [EMAIL PROTECTED] wrote: Like its set to GMT instead of GMT-5 somewhere? Bryan -- *From:* Douglas Knudsen [mailto: [EMAIL PROTECTED] *Sent:* Thursday, November 30, 2006 10:26 AM *To:* discussion@acfug.org *Subject:* [ACFUG Discuss] MS 2k and CF/JRun and time zone patch The great and mighty syadmins here patched up our web servers last night. Apparently one of the patches was for a daylight savings time issue. Now all my CF logs, three different servers and 6 instances of CF, all are timestamping logs with a time 5 hours off. Anyone else see this? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] First try at a real CF edit
Justin, Considering we do not see % above the code or if the HTML is surrounded by a tag based JSP declaration, it can look like JSP, Perl and PHP. Robert, You can tell if a file is ColdFusion by the extension of the file. ColdFusion: .cfm, .cfc, .cfml PHP: .php Perl: .pl, .cgi JSP: .jpg These are the most commin file extensions for the related technologies. Teddy On 11/30/06, Mischa Uppelschoten ext 10 [EMAIL PROTECTED] wrote: Just a hunch, try to add (), like so: $orderitem.getPartNumber() /m I am sorry if this question seems so incredibly simple but I am lost as to what to do. I need to make an edit to a CF file. It has listed in some cells that create an email that is an order sheet for us from an AbleCommerce cart. [code] td class=Products /td td class=Products$orderItem.getSKU()/td td class=Products$orderItem.getName()brfont size=2strong$orderItem.getLineMessage()/strong/font/td td class=Products align=right $LocaleUtils.formatCurrency($store,$orderItem.getUnitPrice(),br,true)/td td class=Products align=center div align=center$orderItem.getQuantity()/div/td [/code] The question is: That I need the equivalent of a td class=Products $orderitem.getPartNumber /td For the first row to replace the td class=Products /td However when I revise that line of code to: td class=Products $orderitem.getPartNumber /td I get: $orderitem.getPartNumber? inside the cell output. What is happening? Why is it happening? How do I fix it? This app is CF on top of a Java app. I wonder if the $orderitem.getPartNumber is a Java command and I should be doing this some other way? Any and all help would be appreciated. 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 Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web:www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] First try at a real CF edit
I had a typo on my last email: JSP: .jsp Teddy On 11/30/06, Teddy Payne [EMAIL PROTECTED] wrote: Justin, Considering we do not see % above the code or if the HTML is surrounded by a tag based JSP declaration, it can look like JSP, Perl and PHP. Robert, You can tell if a file is ColdFusion by the extension of the file. ColdFusion: .cfm, .cfc, .cfml PHP: .php Perl: .pl, .cgi JSP: .jpg These are the most commin file extensions for the related technologies. Teddy On 11/30/06, Mischa Uppelschoten ext 10 [EMAIL PROTECTED] wrote: Just a hunch, try to add (), like so: $orderitem.getPartNumber() /m I am sorry if this question seems so incredibly simple but I am lost as to what to do. I need to make an edit to a CF file. It has listed in some cells that create an email that is an order sheet for us from an AbleCommerce cart. [code] td class=Products /td td class=Products$orderItem.getSKU()/td td class=Products$orderItem.getName()brfont size=2strong$orderItem.getLineMessage()/strong/font/td td class=Products align=right $LocaleUtils.formatCurrency($store,$orderItem.getUnitPrice(),br,true)/td td class=Products align=center div align=center$orderItem.getQuantity()/div/td [/code] The question is: That I need the equivalent of a td class=Products $orderitem.getPartNumber /td For the first row to replace the td class=Products /td However when I revise that line of code to: td class=Products $orderitem.getPartNumber /td I get: $orderitem.getPartNumber? inside the cell output. What is happening? Why is it happening? How do I fix it? This app is CF on top of a Java app. I wonder if the $orderitem.getPartNumber is a Java command and I should be doing this some other way? Any and all help would be appreciated. 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 Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web:www.BankersX.com http://www.bankersx.com/ Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserformhttp://www.acfug.org/?falogin.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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] First try at a real CF edit
Umm, wow. That was from no where. Flying cow patties would be a bad day. Teddy On 11/30/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I think it looks like cows flying Ok, I've had a bad day. Cows Flying would be a nice change. mcg *Mischa Uppelschoten ext 10 [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 11/30/2006 03:02 PM Please respond to discussion@acfug.org To Web Site discussion@acfug.org cc Subject re: [ACFUG Discuss] First try at a real CF edit Just a hunch, try to add (), like so: $orderitem.getPartNumber() /m I am sorry if this question seems so incredibly simple but I am lost as to what to do. I need to make an edit to a CF file. It has listed in some cells that create an email that is an order sheet for us from an AbleCommerce cart. [code] td class=Products /td td class=Products$orderItem.getSKU()/td td class=Products$orderItem.getName()brfont size=2strong$orderItem.getLineMessage()/strong/font/td td class=Products align=right $LocaleUtils.formatCurrency($store,$orderItem.getUnitPrice(),br,true)/td td class=Products align=center div align=center$orderItem.getQuantity()/div/td [/code] The question is: That I need the equivalent of a td class=Products $orderitem.getPartNumber /td For the first row to replace the td class=Products /td However when I revise that line of code to: td class=Products $orderitem.getPartNumber /td I get: $orderitem.getPartNumber? inside the cell output. What is happening? Why is it happening? How do I fix it? This app is CF on top of a Java app. I wonder if the $orderitem.getPartNumber is a Java command and I should be doing this some other way? Any and all help would be appreciated. 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 Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web:www.BankersX.com http://www.bankersx.com/ Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] First try at a real CF edit
I did send out a second email. Sorry about the typo. Java Server Pages (JSP) and Joint Photographic Experts Group (JPEG) are very different animals. Teddy On 11/30/06, Dusty Hale [EMAIL PROTECTED] wrote: I think Teddy may have meant for the JSP: .jpg to actually be JSP:.jsp … the .jpg is of course an image. Correct if wrong please. Dusty -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Teddy Payne *Sent:* Thursday, November 30, 2006 3:20 PM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] First try at a real CF edit Justin, Considering we do not see % above the code or if the HTML is surrounded by a tag based JSP declaration, it can look like JSP, Perl and PHP. Robert, You can tell if a file is ColdFusion by the extension of the file. ColdFusion: .cfm, .cfc, .cfml PHP: .php Perl: .pl, .cgi JSP: .jpg These are the most commin file extensions for the related technologies. Teddy On 11/30/06, *Mischa Uppelschoten ext 10* [EMAIL PROTECTED] wrote: Just a hunch, try to add (), like so: $orderitem.getPartNumber() /m I am sorry if this question seems so incredibly simple but I am lost as to what to do. I need to make an edit to a CF file. It has listed in some cells that create an email that is an order sheet for us from an AbleCommerce cart. [code] td class=Products /td td class=Products$orderItem.getSKU()/td td class=Products$orderItem.getName()brfont size=2strong$orderItem.getLineMessage()/strong/font/td td class=Products align=right $LocaleUtils.formatCurrency($store,$orderItem.getUnitPrice(),br,true)/td td class=Products align=center div align=center$orderItem.getQuantity()/div/td [/code] The question is: That I need the equivalent of a td class=Products $orderitem.getPartNumber /td For the first row to replace the td class=Products /td However when I revise that line of code to: td class=Products $orderitem.getPartNumber /td I get: $orderitem.getPartNumber? inside the cell output. What is happening? Why is it happening? How do I fix it? This app is CF on top of a Java app. I wonder if the $orderitem.getPartNumber is a Java command and I should be doing this some other way? Any and all help would be appreciated. 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 Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone:(404) 605-0100 ext. 10 Fax:(404) 355-7930 Web:www.BankersX.com http://www.bankersx.com/ Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserformhttp://www.acfug.org/?falogin.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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org
Re: [ACFUG Discuss] jrun.exe application error
What Java run time are you using and this may sound odd, but when was the last time the server received some sort of maintenance like disk defragmentation or a disk sector check? Teddy On 11/29/06, Debbie Gregory [EMAIL PROTECTED] wrote: We are running Win2K with CFMX7. Every day we get this error (sometimes several times a day). *The instruction at 0x0803ddf4 referenced memory at 0x. The memory could not be read. Click OK to terminate the program.* When we click OK, the CF application service restarts. Does anyone have any advice on how to stop this error? Thanks, *Debbie Gregory* *An ounce of peace is worth more than a pound of victory.* - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db
Instead of beating your head against the screen, why not write a quick CF template that will query for every title that has the word the in the beginning and run a batch update against it. In essence, you would just change The Big Lobowski to Big Lobowski, The. The template would probably not take too long depending on your record set size and you would not have to worry about badly formed titles. Since that site uses movie listings for certain things, IMDB has a Pro service: https://secure.imdb.com/signup/v4/?d=IMDbTab which they offer the ability to use their database. Teddy On 11/26/06, Tom Chambers [EMAIL PROTECTED] wrote: I've run into many issues using CF-built queries on an Access db over the years. I recall one that had about a dozen doublequotes in it. Freaky! Have you tried including the [] around the field name just for fun? T [EMAIL PROTECTED] wrote: Sorry, the double quotes in the query statements are simply a typo on my part. I didn't copy and paste the actual query, I simply retyped it as I wrote the email and out of bad habit used quotes. The quotes ' or is not the problem. This query and/or using the REPLACE function works perfectly well on all my SQL datasources. This particular site (still) has an Access db. And therein lies the rub. Yes, I could, and probably should, upsize the Access mdb to SQL-2000, but for right now that's more trouble than simply making the query behave. So, any ideas on how to use the REPLACE function in a query on an Access db? Or, baring that, how would you create a similar end result of ORDER BY the mTitle column ignoring the if it is the first word in a movie title? Thanks, Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Chambers Sent: Sunday, November 26, 2006 4:45 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] using REPLACE within CFQUERY for ACCESS db did you try single quotes? [EMAIL PROTECTED] wrote: I have an Access datasource for movie listings. mTitle is the column/field for the movie's Title. I need to output the records ordered by mTitle, however I need to ignore the when it is the first word. For example: The Big Lebowski should be ordered by B in Big, not T in The. My solution was to create an alias column in my query wherein I REPLACEd the with and then ORDER BY the alias column. SELECT mTitle, REPLACE(mTitle, the, ) AS titleOrder FROM movieTable ORDER BY titleOrder However, when I run this I get an error that the function REPLACE is undefined: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'REPLACE' in expression. I have Googled for an answer to my problem (till I'm blue in the face) but can't find anything HELPFUL. Can anyone help OR suggest a different solution? Thanks, Dan Kaufman - 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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.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 - - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Blue Dragon
What about hosting the site on an application service provider? You don't have to budget for the CF license then. Is the client firm on the fact that the Linux server must house the site? Teddy On 11/22/06, Dusty Hale [EMAIL PROTECTED] wrote: I have a new client I need to design a very simple app for and I would prefer to do it in cold fusion because I could do it fast and not have to charge much. The problem is that the dedicated server he has is a Linux server and does not have CF on it. Of course I know CF will run fine on a linux server but since there is no budget to purchase a license for it, I assumed I would need to rethink it and do this with PHP. However, then I though Blue Dragon maybe? Could anyone tell me if my thoughts are worth researching more? Will Blue Dragon allow me to develop my app with my local cf server then move to his server where I install Blue Dragon on it? Do you think I will run into headaches and issues with this approach. Thanks ahead of time for any advice I get. Dusty - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.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 -
Re: [ACFUG Discuss] Sun sending Java to Open Source
My apologies. I did not mean to smack Adam that hard. My hand slipped! Honest!TeddyOn 11/13/06, Adam Churvis [EMAIL PROTECTED] wrote: Among other things, it means that when the time comes (relatively soon), Sun will most likely wash their hands clean of-- *SMACK!* (Sorry...) Respectfully, Adam Phillip ChurvisCertified Advanced ColdFusion MX 7 DeveloperBlueDragon Alliance Founding Committee Get advanced intensive Master-level training inC# ASP.NET 2.0 for ColdFusion Developers atProductivityEnhancement.com - Original Message - From: Precia To: discussion@acfug.org Sent: Monday, November 13, 2006 8:52 AM Subject: Re: [ACFUG Discuss] Sun sending Java to Open Source How can Sun profit from such a move? How does this help sales andstock dividends? I'm all for open-source, but I would also like to see the company to stay in business. Precia On 11/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://news.yahoo.com/s/ap/20061113/ap_on_hi_te/sun_java_open_source_1 Shawn GorrellWeb Development Applications ArchitectFederal Reserve Bank - AtlantaOffice (404) 498-8449 - 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 - - 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 - - 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 - -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Sun sending Java to Open Source
I figured if I preemptively struck you, I could prevent anyone else from smacking you afterwards. This would cause them to hopefully take pity and be content with the initial effort and refrain from further abuse. So in my little logic, I was saving you!Teddy On 11/13/06, Adam Churvis [EMAIL PROTECTED] wrote: Oh, was that you, Teddy? I thoughtit was Ben, Sterling, and a few others. That's okay. I deserved it. :) Respectfully, Adam Phillip ChurvisCertified Advanced ColdFusion MX 7 DeveloperBlueDragon Alliance Founding Committee Get advanced intensive Master-level training inC# ASP.NET 2.0 for ColdFusion Developers atProductivityEnhancement.com - Original Message - From: Teddy Payne To: discussion@acfug.org Sent: Monday, November 13, 2006 10:31 AM Subject: Re: [ACFUG Discuss] Sun sending Java to Open Source My apologies. I did not mean to smack Adam that hard. My hand slipped! Honest!Teddy On 11/13/06, Adam Churvis [EMAIL PROTECTED] wrote: Among other things, it means that when the time comes (relatively soon), Sun will most likely wash their hands clean of-- *SMACK!* (Sorry...) Respectfully, Adam Phillip ChurvisCertified Advanced ColdFusion MX 7 DeveloperBlueDragon Alliance Founding Committee Get advanced intensive Master-level training inC# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Precia To: discussion@acfug.org Sent: Monday, November 13, 2006 8:52 AM Subject: Re: [ACFUG Discuss] Sun sending Java to Open Source How can Sun profit from such a move? How does this help sales andstock dividends? I'm all for open-source, but I would also like to see the company to stay in business. Precia On 11/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://news.yahoo.com/s/ap/20061113/ap_on_hi_te/sun_java_open_source_1 Shawn GorrellWeb Development Applications ArchitectFederal Reserve Bank - AtlantaOffice (404) 498-8449 - 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 - - 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 - - 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 - -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 - - 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 - -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Sun sending Java to Open Source
I am by no means the moderator of this list, but I might throw a yellow flag here in the back field.*announcer voice* Unnecessary spearing after the comment was dead. 5 second delay to the offense's line speed. Still first download. Game on.TeddyOn 11/13/06, Sterling Ledet [EMAIL PROTECTED] wrote: While your prescience was off-base, it's obvious in retrospect that you hadactually been a bit confused as to just which product would be next to beopen-sourced.You need to increase your doses of melange. (Apologies to the non-Dune fans who won't understand this reference.Java is in my opinion, a lot closer tied to the future of ColdFusion thanjust the ActionScript code previously discussed. So actually, in my opinion,this announcement, while not in-any-way validating everything you said, does indicate your point of view had at least some relevance. But, I would haveto venture that absolutely no one would ever dream that by outsourcing Java,Sun is actually washing it's hands of the technology. So let's say you earned me buying the first round of drinks went the timecomes for you to actually pay up.- Sterling-To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
[ACFUG Discuss] CF Dump in JS?
We all know and love cfdump. How would you like to being to dump your objects and datatypes in JS too?http://www.netgrow.com.au/files/_javascript__dump.cfm A friend sent me this earlier. Works for:Internet Explorer 6, Internet Explorer 7, Firefox 1.5, Opera 8, Safari 1.2 (Mac), Firefox (Mac) - all tested, should also work in most other browsersI see some interesting potential there.Teddy-- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/ Atlanta CFUG: http://www.acfug.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 -
Re: Re: Re: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla
I have to agree for the most part with Steve. I really do not see this move by Adobe as a choice of weakness because they cannot compete in lateral markets.Whenever code is contributed to Mozilla, this usually indicates a community centric approach to get more involvement in the world community environments to develop more open source solutions to create better products. Since ActionScript offers a substantial library for Object Oriented programming for rich interfaces, I would foresee the increase in RIA applications.Microsoft has used Flash for their public facing pages in the past. The world's adoption of the Flash Player as the quickest adopted rich media solution shows the acceptance of ActionScript based tools. Myself and most developers that I know have Firefox installed on their system out of personal choice and acceptance of community supported browsers that have a better history of security and adoption of web standards. The move seems logical to give Flash to the world internet community as a demonstration of desire to push web interfaces.TeddyOn 11/8/06, Steven Ross [EMAIL PROTECTED] wrote: And som more links:http://www.betanews.com/article/Adobe_Donates_Flash_Code_to_Mozilla/1162924245 http://news.google.com/news?q=adobe+donates+flash+scripting+enginehl=enlr=client=safarirls=ensa=Xoi=newsct=titleOn 11/8/06, Steven Ross [EMAIL PROTECTED] wrote: I think the above response is drawing some pretty large conclusions that aren't based on any substantiated facts. Here is an article concerning the move http://www.vnunet.com/vnunet/news/2168153/adobe-donates-flash-code article content below -- Adobe has donated its ActionScript Virtual Machine code to the Mozilla Foundation, kicking off a new open source project dubbed Tamarin. Tamarin will be a component of SpiderMonkey, the core _javascript_ engine for Mozilla's Firefox browser. Adobe's ActionScript offers a scripting language for the company's Flash player. Flash technology is best known for its use by online video websites such as Youtube and Google Video. The language is similar to _javascript_ and Microsoft's JScript. Adobe and Mozilla expect that the donation will speed up the creation of a standards based scripting language, promote the creation of online applications and increase their performance on Firefox. Scripting languages are at the core of today's Web2.0 applications. The Ajax technology that forms the basis of Gmail and Flickr for instance is an acronym for Asynchronous _javascript_ and XML. The Adobe contribution is the largest code donation that Mozilla has received in its 3 year history. On 11/7/06, Adam Churvis [EMAIL PROTECTED] wrote:Among other things, it means that when the time comes (relatively soon), Adobe will most likely wash their hands clean of ColdFusion via the open source route as well, rather than by trying to dump it on another company. But it most likely also signifies that Adobe realizes its Flash-centric development model and tools cannot keep pace with Microsoft's XAML-based offerings.When you compare the two, Flash-based development looks like an unwieldy cobbled together tinkertoy.And there just isn't enough Adobe funding available to change that in any significant way, so they give it up to the people and let them join in for free. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com- Original Message - From: Precia To: discussion@acfug.org Sent: Tuesday, November 07, 2006 4:42 PM Subject: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla Adobe has donated the Flash scripting engine code to Mozilla. The announcement was made at the Web 2.0 conference. Would someone enlighten me on the big picture of this gesture. Precia- 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 - - 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 - -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 928-484-4364--Steven Rossweb application interface developer http://www.zerium.com[mobile] 404-488-4364[fax]
Re: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla
I would like to vote Sterling for ColdFusion evangelist.Also, I think it is poor tact to comment in a ColdFusion mailing list that ColdFusion is some sort of toy ball that is being passed around.Eeach company that has purchased ColdFusion has pushed the product further. Allaire/Macromedia/Adobe all value the product and that is why it still exists. Plus, why was ColdFusion even entered into the argument when the article was about ActionScript? There are projects to integrate Flex with PHP, CF and .Net. At Adobe MAX, there were .Net sessions on how to integrate with Adobe product lines. Adobe is not trying to seperate, there are trying to integrate. I know this for a fact. Teddy On 11/8/06, Sterling Ledet [EMAIL PROTECTED] wrote: With all due respect, Adam, I think that is the most ridiculous comment I've ever heard you make in public. Have you been drinking? If Adobe ever washes its hands of ColdFusion, I hereby publicly pledge to buy you and your family dinner at the most expensive restaurant you can find in Atlanta. You mention relatively soon, how about we bet dinner that it doesn't happen within 3 years. If by Christmas, 2009 ColdFusion Enterprise is not released as open source and Adobe has clearly not washed their hands of it, then you owe me and my family dinner? My offer stands, whether or not you accept the bet. Here's three points I'd like to make. 1) Adobe is not going to wash their hands of ColdFusion.Do you think they are going to wash their hands of Acrobat as well? Do you know how much money they've been losing on the high-end, Java base LiveCycle product linesfor years, yet Bruce Chizen just moved that group to brand new, state of the art digs reinvesting even more into that effort. Acrobat itself was a money loser for half a decade before it became the most lucrative product line in Adobe's portfolio, surpassing PostScript and Photoshop. Adobe is used to making long-term investments, and the purchase of Macromedia/Allaire/eHelp by them is one of the best things that could have happened for tech junkies like me. Even eHelp products are seeing renewed investment, which even surprised me a bit. ColdFusion is so core to what Adobe is doing that any doubt about it's future is so clearly misdirected as to be humorous. 2) Adobe does not kill products, especially not core technology like ColdFusion. I even heard rumors that there is relevant code from LiveMotion (an early Flash competitor that Adobe extensible killed long ago, for those of you who haven't heard of it) that they can now roll into Flash. Adobe plays long-term chess games strategically. This was a strategic move. Not one made out of desperation. I have no idea why you would position it as such, but it is a most absurd deduction. 3) While you are certainly entitled to your opinion that Microsoft's XAML-based offerings are somehow competitive with Flex (and I doubt most of your peers would agree that Eclipse is a unwieldy cobbled together tinkertoy), the facts remain that Microsoft's approach remains one of adopting standards in a way that consistently (and many believe, intentionally) breaks competing technology platforms. They've repeatedly done so with Flash, you can't easily connect to Microsoft WSDL's using standard web service technologies (ever try to hook up ColdFusion of FRS to MS-CRM?), and the open sourcedeveloper community is a key target audience for Flex. In summary, by integrating the core Actionscript classes into the core _javascript_ standard, Adobe is making a major play on continuing to be the driving force behind standards. It's going to make development for Flex easier over the long haul. It was a brilliant move, not a desperate one. Seriously, with no disrespect intended, Sterling Ledet From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Adam ChurvisSent: Tuesday, November 07, 2006 10:38 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla Among other things, it means that when the time comes (relatively soon),Adobe will most likely wash their hands clean of ColdFusion via the open source route as well, rather than by trying todump it on another company. But it most likely also signifies that Adobe realizes its Flash-centric development model and toolscannot keep pace with Microsoft's XAML-based offerings. When you compare the two, Flash-based development looks like an unwieldycobbled together tinkertoy. And there just isn't enough Adobe funding available to change that in any significant way, so they give it up to the people and let them join in for free. Respectfully, Adam Phillip ChurvisCertified Advanced ColdFusion MX 7 DeveloperBlueDragon Alliance Founding Committee - To unsubscribe from this list, manage your profile @
Re: Re: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla
Ben Forta keeps a list of who uses CF:http://www.forta.com/cf/using/TeddyOn 11/8/06, Steven Ross [EMAIL PROTECTED] wrote:From Ben Forta: http://www.forta.com/blog/index.cfm?mode=entryentry=C7F3A45C-3048-80A9-EF3C7DA746A45DCEOn 11/8/06, Ajas Mohammed [EMAIL PROTECTED] wrote: Hi everyone,I think Adam's comment is not correctIf Adobe wanted to wash off there hands, then that would have happened long time back... Looking at the pace CF is going, I think it will be pretty much liked among the CF community. Plus not to forget the new version code named Scorpio which is due to be released next year. I dont think that CF will end up at hands of Open Source anytime. One of the biggest users of CF is Bank of America, the number 1 bank here There would be many more top companies that would be using CF today.. if anyone knows any big companies using CF, plz mention it here Ajas Mohammed. On 11/8/06, Sterling Ledet [EMAIL PROTECTED] wrote: With all due respect, Adam, I think that is the most ridiculous comment I've ever heard you make in public. Have you been drinking? If Adobe ever washes its hands of ColdFusion, I hereby publicly pledge to buy you and your family dinner at the most expensive restaurant you can find in Atlanta. You mention relatively soon, how about we bet dinner that it doesn't happen within 3 years. If by Christmas, 2009 ColdFusion Enterprise is not released as open source and Adobe has clearly not washed their hands of it, then you owe me and my family dinner? My offer stands, whether or not you accept the bet. Here's three points I'd like to make. 1) Adobe is not going to wash their hands of ColdFusion. Do you think they are going to wash their hands of Acrobat as well? Do you know how much money they've been losing on the high-end, Java base LiveCycle product lines for years, yet Bruce Chizen just moved that group to brand new, state of the art digs reinvesting even more into that effort. Acrobat itself was a money loser for half a decade before it became the most lucrative product line in Adobe's portfolio, surpassing PostScript and Photoshop. Adobe is used to making long-term investments, and the purchase of Macromedia/Allaire/eHelp by them is one of the best things that could have happened for tech junkies like me. Even eHelp products are seeing renewed investment, which even surprised me a bit. ColdFusion is so core to what Adobe is doing that any doubt about it's future is so clearly misdirected as to be humorous. 2) Adobe does not kill products, especially not core technology like ColdFusion. I even heard rumors that there is relevant code from LiveMotion (an early Flash competitor that Adobe extensible killed long ago, for those of you who haven't heard of it) that they can now roll into Flash. Adobe plays long-term chess games strategically. This was a strategic move. Not one made out of desperation. I have no idea why you would position it as such, but it is a most absurd deduction. 3) While you are certainly entitled to your opinion that Microsoft's XAML-based offerings are somehow competitive with Flex (and I doubt most of your peers would agree that Eclipse is a unwieldy cobbled together tinkertoy), the facts remain that Microsoft's approach remains one of adopting standards in a way that consistently (and many believe, intentionally) breaks competing technology platforms. They've repeatedly done so with Flash, you can't easily connect to Microsoft WSDL's using standard web service technologies (ever try to hook up ColdFusion of FRS to MS-CRM?), and the open sourcedeveloper community is a key target audience for Flex. In summary, by integrating the core Actionscript classes into the core _javascript_ standard, Adobe is making a major play on continuing to be the driving force behind standards. It's going to make development for Flex easier over the long haul. It was a brilliant move, not a desperate one. Seriously, with no disrespect intended, Sterling Ledet From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Adam Churvis Sent: Tuesday, November 07, 2006 10:38 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Adobe Donating Flash Scripting Engine to Mozilla Among other things, it means that when the time comes (relatively soon), Adobe will most likely wash their hands clean of ColdFusion via the open source route as well, rather than by trying to dump it on another company. But it most likely also signifies that Adobe realizes its Flash-centric development model and tools cannot keep pace with Microsoft's XAML-based offerings.When you compare the two, Flash-based development looks like an unwieldy cobbled together tinkertoy.And there just isn't enough Adobe funding available to change that in any significant way, so they give it up to the people and let them join in for free. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer
Re: [ACFUG Discuss] Re: Adobe Donating Flash Scripting Engine to Mozilla
This article pretty much sums it up what this provide for Mozilla:http://www.hecker.org/mozilla/adobe-mozilla-and-tamarinTeddy On 11/8/06, Precia [EMAIL PROTECTED] wrote: Coming back to the Flash scripting engine code.What's the bigpicture with this?What could this do in the Mozilla browser?Shallwe have a way to write AS for SWF files generating on the fly in that specific browser?I don't know how this is useful to Mozilla.PreciaOn 11/7/06, Precia [EMAIL PROTECTED] wrote: Adobe has donated the Flash scripting engine code to Mozilla. The announcement was made at the Web 2.0 conference. Would someone enlighten me on the big picture of this gesture. Precia- To unsubscribe from this list, manage your profile @http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com--- cf_payne /Adobe Certified ColdFusion MX 7 Developer Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Huge! 3000W UPS Available
Robert,I am not sure on the policy for the ACFUG lists, but part of me thinks that soliciting to sell something that service oriented may not be normal behavior. The discussion list is for discussion CF technology topics. The community list would be more appropriate as that list is a more off topic list. TeddyOn 11/7/06, Robert Reil [EMAIL PROTECTED] wrote: I am sorry for putting this on the discussion list but don't know where to get the publicity for it. I have a MONSTER UPS that I am putting up for sale. It is a 110VAC Unit that has run my 10 servers, switches, KVM, Backups etc for about 3 hours in the past. It was completely factory serviced, and technically upgraded to current technology in 2003 and is in fine shape. New batteries were purchased and the others were tested at Batteries plus. This system runs on 30amp service and is in great shape. It is rack mountable. There are 4 units, the main unit is 7U tall, and the other 3 battery units are 6U tall. Each battery unit holds 4 Riding lawnmower sized 12VDC batteries. There are also 2 spare batteries included. This system works wonderfully but it is too big for me, and is taking up too much space. Pics available on request. These items are HEAVY! I would guess the whole assembly would be 200-250 lbs. It has the same specs as http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItemitem=7611161217 The system on this link is a standup vs rack mount and it is newer than mine but is just as functional. Let me know if you or anyone you know are interested. This is said to run 4 cabinets for an hour. I am open to any reasonable bids. Call if interested. 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 -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] CFUNITED-07 Information
I stayed at the Woodfin Suites in Rockville:http://www.woodfinsuitehotels.com/rockville/The accommodations are not plush or ornate, but their convenience was nice. They are business suites. I stayed in a king size bed that had a sofa, love seat, kitchenette, refrigerator and cheap wifi. They have a shuttle to the Metro and are three stops from the Bethesda Metro location where the conference was at. They offered grocery shopping while you were away. Their breakfast was not spectacular, but the food was warm and edible. I would recommend a rental car as the hotel is about a mile from Rockville Pike aka 355.TeddyOn 11/2/06, Precia [EMAIL PROTECTED] wrote:Teddy, where did you stay at the last conference? You set up sounded much better than what the Marriott offered. Precia On 11/2/06, Maya Tulchinsky [EMAIL PROTECTED] wrote: CFUNITED-07 is Wed 6/27/06 - Sat 6/30/06 at North Bethesda Marriott, just outside Washington DC (same great hotel as last year!). http://www.cfunited.com/2007/Maya We have the perfect Group for you. Check out the handy changes to Yahoo! Groups. - 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 - - 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 - -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] CFUNITED-07 Information
I agree with Precia. I am from D.C. and I can assist in helping making things easier on travel considerations. Teddy On 11/2/06, Precia [EMAIL PROTECTED] wrote: If anyone is going to CF United, lets get together. We can make plans for a smooth trip. Precia On 11/2/06, Maya Tulchinsky [EMAIL PROTECTED] wrote: CFUNITED-07 is Wed 6/27/06 - Sat 6/30/06 at North Bethesda Marriott, just outside Washington DC (same great hotel as last year!). http://www.cfunited.com/2007/Maya We have the perfect Group for you. Check out the handy changes to Yahoo! Groups. - 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 - - 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 - -- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] CFUNITED-07 Information
Conferences represent good milestones for personal development. What can I achieve prior to CF United? What can I show exhibitors, other developers, potential clients or the conference staff in order to get more visibility? What can I study to take a certification test?What community involvement can I organize between now and then?These are questions that I have to ask myself after every conference postmortem. TeddyOn 11/2/06, Dean H. Saxe [EMAIL PROTECTED] wrote: SSL doesn't address authentication, authorization, data validation,auditing logging, configuration management, etc.Lots of otherways to screw up security.-dhsDean H. Saxe, CISSP, CEH [EMAIL PROTECTED]Great spirits have often encountered violent opposition from weakminds. --EinsteinOn Nov 2, 2006, at 11:04 AM, John Mason wrote: You've been connecting to one of the webservices via SSL in some of the webmail Flex stuff? I think that would cover most of the security concerns in passing the data between cf and flex. That's probably one of the better ways, but I would be curious to know the security around the other possible methods for flex. John From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Precia Sent: Thursday, November 02, 2006 10:48 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFUNITED-07 Information How to write secure code using CF and Flex (so a bit of AS 3.0 or MXML maybe mixed in)Considerations while passing data between. Precia On 11/2/06, Dean H. Saxe [EMAIL PROTECTED] wrote: What do you mean?How to write secure code with Flex? -dhs Dean H. Saxe, CISSP,CEH [EMAIL PROTECTED] [T]he people can always be brought to the bidding of the leaders. This is easy. All you have to do is to tell them they are being attacked, and denounce the pacifists for lack of patriotism and exposing the country to danger. It works the same in every country. --Hermann Goering, Hitler's Reich-Marshall at the Nuremberg Trials On Nov 2, 2006, at 10:02 AM, Precia wrote: Dean, Can you morph this with Flex in any way?Flex has become the most requested topic at MAX and I have a feeling it will be the same at the next conference...albeit, CF security is a highly NEEDED topic. Precia On 11/2/06, Dean H. Saxe [EMAIL PROTECTED] wrote: I'm hoping to be there this year with a talk (if Michael accepts my abstract) and possibly a Writing Secure Code: CFMX class.If you're interested in a 2 day version of this class, let me know.It may help my management make the decision to offer it. -dhsDean H. Saxe, CISSP, CEH [EMAIL PROTECTED] I have always strenuously supported the right of every man to his own opinion, however different that opinion might be to mine. He who denies another this right makes a slave of himself to his present opinion, because he precludes himself the right of changing it. -- Thomas Paine, 1783 On Nov 2, 2006, at 9:52 AM, Teddy Payne wrote:I agree with Precia.I am from D.C. and I can assist in helping making things easier on travel considerations. Teddy On 11/2/06, Precia [EMAIL PROTECTED] wrote: If anyone is going to CF United, lets get together.We can make plans for a smooth trip. Precia On 11/2/06, Maya Tulchinsky [EMAIL PROTECTED] wrote: CFUNITED-07 is Wed 6/27/06 - Sat 6/30/06 at North Bethesda Marriott, just outside Washington DC (same great hotel as last year!). http://www.cfunited.com/2007/ Maya We have the perfect Group for you. Check out the handy changes to Yahoo! Groups. - 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 - - 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 - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Blog: http://cfpayne.wordpress.com/ Atlanta CFUG: http://www.acfug.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 - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info
[ACFUG Discuss] Debbie Gregory
I wanted to say thank you to Debbie Gregory for her presentation last night. I was sincerely tickled at the visual aids on how strings, lists, arrays and queries were represented. Also, was I the only person that was impressed by the detail of the examples? I know she had some troubleshooting issues, but the code examples and the two games were a solid way to engage people in learning development ideas. Thanks again Debbie and best of wishes in your new adventure in marriage. Teddy-- cf_payne /Adobe Certified ColdFusion MX 7 DeveloperBlog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Figured I'd try one more time for some insight on CFGRID
Jeff,CFGrid being editable brings into play the idea of a webservice update. CFGrid is not really a good form container, but more of a interface to fire update, delete and create events. Now these webservices are created from actionscript that call CFCs. I would recommend http://www.asfusion.com and they have some good examples of how to call webservices from actionscript for flash forms. Flash forms in a hybrid experience that submitting to an action page slowly becomes a secondary processes. TeddyOn 10/25/06, Jeff Howard [EMAIL PROTECTED] wrote: Hey all, Was hoping there was someone that had some experience with the CFGRID tag that might give me some insight. I can't seem to make it function correctly. If I use a Flash format CFGRID in edit mode it passes all emptry strings to my action page. I can get it to work in java mode but I like the look and feel of the Flash mode more. I can create a Flash from that functions in edit mode but I can't actually get it to submit the edits to the action page. All variables come through as an empty string. Any insight? Thanks in advance for any light you can shed on this. Jeff - 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 - -- cf_payne /Adobe Certified Advanced ColdFusion Application DeveloperBlog: http://cfpayne.wordpress.com/ Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Flex / Cairngorm
Caringorm 2.1 utilizes Flex Data Services and has a future growth of three product offerings:Cairngorm EnterpriseCairngorm ApolloCairngorm MobileIt looks extremely promising a good core framework for Flex. Warning though, it is a heavy OO framework that utilizes multiple design patterns. TeddyOn 10/25/06, Precia [EMAIL PROTECTED] wrote: Cairngorm 2.1 is coming out on labs.adobe.com today...be on the look out. Precia - 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 - -- cf_payne /Adobe Certified Advanced ColdFusion Application DeveloperBlog: http://cfpayne.wordpress.com/ Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Reading the results of a cfselect form element
If it is a comma delimeted list then:Question 1: How would test to see if this actually is a String? ListLen(variableName) gt 0Question 2: How do I convert this String to an Array? Or is there a better way to process a cfselect element? ListToArray(variableName)TeddyOn 10/19/06, Leif Wells [EMAIL PROTECTED] wrote: All,Sorry for the beginner's question (and my absence from this list and the meetings).I have created a coldfusion file that has form that has a cfselect element. The multiple attribute is set to true. When processing the form I get what I believe are two UUIDs separated by a comma. A String, I believe.Question 1: How would test to see if this actually is a String?Question 2: How do I convert this String to an Array? Or is there a better way to process a cfselect element? Leif - 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 - -- cf_payne /Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Reading the results of a cfselect form element
To really detect for existance of a string you may want to additionally peformcfif IsSimpleValue(variable) and Trim(variable) new This will ensure that the variable is a string, number or a boolean and that the value of the variable is not empty. TeddyOn 10/19/06, Douglas Knudsen [EMAIL PROTECTED] wrote: everything in CF is a string! :)1) see above. ;) Really, I don't know how, there is no isString(). 2) checkout listToArray(). http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=part_cfm.htmIts been sometime since I did this, but I recall using listToArray() then looping. Or you could just use CFLOOP with the list attribute. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=part_cfm.htm HTH!DKPostScript: caution, developer under mucho stresso churning out next weeks work and sipping coffee!On 10/19/06, Leif Wells [EMAIL PROTECTED] wrote: All, Sorry for the beginner's question (and my absence from this list and the meetings).I have created a coldfusion file that has form that has a cfselect element. The multiple attribute is set to true. When processing the form I get what I believe are two UUIDs separated by a comma. A String, I believe.Question 1: How would test to see if this actually is a String?Question 2: How do I convert this String to an Array? Or is there a better way to process a cfselect element? Leif - 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 - -- Douglas Knudsenhttp://www.cubicleman.com this is my signature, like it? - 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 - -- cf_payne /Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search Feature
Query caching is one solution to alleviate the speed of the query execution. There is the need to search page by page by a certain amount of records. In an ad hoc solution, I have seen a second query that would perform a query on the original source based upon a start point. The cfouput will typically have a maxrows based upon the query of a query. For the search criteria form, storing the criteria in a shared scope other always helps. The goal would not to change the originating query in any way otherwise the cache will be reset for a different combination. The search criteria would need to exists in the query of the query. Non-adhoc solutions include stored procedures that have increased amounts of complexity to perform conditional queries that can be either dynamically written or programatically built queries.Object Realtional Mappers like Reactor for ColdFusion have a build in pagination scheme that makes that sort of nice. I have not tested Reactor recently for the notation, but I saw the object set for it. TeddyOn 10/16/06, Charlie Arehart [EMAIL PROTECTED] wrote: Are folks reading my note below? Ajas, please clarify if I have understood your need correctly. I had just gone through the same dilemma on my UGTV site. I had done a similar next/prev link, but if the user had entered search criteria, I was challenged because I needed to carry that search criteria to the next screen. So this was about more than just simple query caching but indeed about carrying the search criteria (from a form value obtained on the first result page) to subsequent next/previous pages. If this isn't the challenge you're trying to solve as well, my apologies. But if it is, I hope folks will see that there's more to it than just the general issues of query caching. /charlie http://www.carehart.org/blog/ From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Charlie ArehartSent: Monday, October 16, 2006 11:13 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search Feature Ajas, I think you confused people with the subject saying please disregard previous email. As for your challenge, your challenge isn't with caching but simplythat you needthe next or previous pages to know that you are still workingonthe subset of searched data. Youhave a couple of choices. You could pass your search criteria from page to page in the query string, or you could store it in a session variable and use some indicator on the query string to tell the next/previous page that you mean to use the subset of data (which will then pull the search criteria from the session to run that in its SQL). At that point, yes, you may want to use a cached result. Since the cache is per the SQL used, if you have the search string in the query and you'd previously run that same query within the cachedwithin time, then you will benefit from the cache. As always, something to be careful with in caching is that your underlying data may change as the user is browsing the searched results. You need to pick a cachedwithin time that balances the cost of doing repeated queries against the cost of getting inaccurate data. Only you can know what's best. Some may know that you can flush the query cache, but only all cached results in the entire application, not just one, using CFOBJECTCACHE Action="" BTW, query caching has nothing to do withthe save class files option, though yes the max cached queries does indeed limit how many cached query results (cachedwithin and cachedafter) you can have at one time (across the entire server). /charlie http://www.carehart.org/blog/ From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:17 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search Feature Good Morning everyone, Just wondering if anyone has any ideas/suggestions for the 2 questions I had asked??? I didnt see any reply which makes me think if it is very simple or if its difficult / time consuming. Thanks,Ajas. On 10/13/06, Ajas Mohammed [EMAIL PROTECTED] wrote: Hello everyone, I apologize for the earlier mail sent.. I dont know what happened and the incomplete message got sent. I have 2 questions.1) I have a search page which might return 1000's of records for a search/keyword. I have implemented Pagination i.e. showing NEXT / PREVIOUS (10) RECORDS at a time. My problem is that everytime I click on NEXT OR PREVIOUS, the query is getting executed all over again. I dont want the query to be run everytime NEXT/PREVIOUS link is clicked. I have this code to do the caching cfquery datasource=#client.dbname# name=StateRegs cachedwithin=#createTimeSpan (0,2,13,0)#/cfquerycfoutput query=StateRegs group=Reg_Name startrow=#start# maxrows=#end# data shown heretda href="" + disp)#Next
Re: [ACFUG Discuss] Issue with return from cfquery
Is this portion a typo wher there exists a space in the #ID#? Also, try #getIDs.ID#.cfoutput query=getIDs #getIDs.recordcount# --# ID# br /cfoutputTeddyOn 10/3/06, Jeff Howard [EMAIL PROTECTED] wrote: No offense taken, I thought I explained it fairly clearly.In any case, maybe this will help clarify the issue.Teddy Payne [EMAIL PROTECTED] wrote:Jeff, Saying that it worked this morning is not really the information needed to troubleshoot a problem remotely.Plase take no offense by that statement if it sounded harsh.From this thread, I have seen about three people ask if you have opened up the database and the values in the table you are querying has more than 1 value? Yes, by working I meant that it accessed the table and returned all the rows I requested. Thus, all connections were correct and functioning this morning.Then all of sudden it started returning just 1 record instead of the multiple records it was returning a half-hour earlier.No change to the .cfm file, just a change in the output. When this app quit working I created a new table called Test with one column called ID and 10 rows with a value of 1-10 for ID.CFQUERY name=getIDs datasource=sysmods SELECT IDFROM test/CFQUERYcfoutput query=getIDs#getIDs.recordcount#--#ID#br/cfoutputI had the same issue with this table that I created just to test if there was something I was missing in my other app.I broke it down to 1 extremely simple table with 1 extremely simple query and still only got the 1st record. This test app all of a sudden started functioning properly as well when I hit refresh on the browser after lunch.So my issue now is, what are possible causes of this behavior?The reason also that it sounds incredulous to most of us is that CF really makes it easy to query a database if you have the correct database connection set up in your CF Administrator. We are just looking for more information to assist you,TeddyOn 10/3/06, Jeff Howard [EMAIL PROTECTED] wrote:Yes, absolutely positive.I am getting a return, just 1 row instead of 10 and it was working this morning. Dean H. Saxe [EMAIL PROTECTED] wrote: And are you sure Sysmods is the correct DB? Are you connecting tothe same DB with enterprise manager? -dhsDean H. Saxe, CISSP, CEH[EMAIL PROTECTED]Great spirits have often encountered violent opposition from weakminds. --EinsteinOn Oct 3, 2006, at 12:53 PM, Jeff Howard wrote: Thanks, but still only getting one record returned and a recordcount of 1. [EMAIL PROTECTED] wrote: Maybe try this: SELECT [id] from test -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] ]On Behalf Of Jeff Howard Sent: Tuesday, October 03, 2006 12:32 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue: I have a very simple query: SELECT ID FROM test The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - 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 - - 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 - Stay in the know. Pulse on the new Yahoo.com . Check it out. - 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 -
Re: Re: [ACFUG Discuss] Client? Session?
I am curious as well. The example of not storing being being able to effectively store a value or service object is a limitation to be sure, but even then that can be worked around with a facade.Teddy On 10/2/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Just out of curiosity, why would you say Don't use the Client scope!? Thanks, Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeremy AllenSent: Saturday, September 30, 2006 12:30 AMTo: discussion@acfug.orgSubject: Re: Re: [ACFUG Discuss] Client? Session?Don't use the Client scope! There are only a few reasons to use Client scope and I would still think long and hard about it after having maintained an application that was almost purely Client scope for user state. I think you should avoid the client scope unless you have a real and hard requirement that you absolutely can't lose session data in the event of a server failure. I admit, it is kind of nice to still have all of your user sessions when you restart CF and that benefited our applications in some cases. However, I still don't think the benefits for Client scope are not worth it. Sticky sessions are OK in a load balanced situation. You may get some uneven clumping of clients in some cases, but in reality it turns out not to be a big deal. Playing with WDDX and the overheads involved in that and the pain of keeping track of the serialization state of your data just isn't worth it. You can't even serialize a CFC with WDDX, but they will happily live in the session scope. If you do use client scope make sure you abstract it with a good layer around it so that what scope you use is transparent to your application so that you can change it in the future without your application noticing. Look to the Facade design pattern for that.Jeremy On 9/27/06, Teddy Payne [EMAIL PROTECTED] wrote: Allen made a good point about WDDX. I tend to overlook CFWDDX. cfwddx action = "" input = #session# output=client.foocfdump var=#client.foo# can dump your session into foo variable stored into the client scope.Your result in the DB would look similar to:foo=wddxPacket version#='1.0'header/datastruct type#=' coldfusion.runtime.MemorySessionScope'var name#='cftoken'string88107569/string/varvar name#='urltoken'stringCFID#=7101amp;CFTOKEN#=88107569/string/varvar name#='cfid'string7101/string/varvar name#='sessionid'stringTESTAPP_7101_88107569/string/var/struct/data/wddxPacket# TeddyOn 9/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Just as an aside - you can still store complex structures in client variables but you'll have to wddx them into a string and then store them into the client variable. Also, if you do this and you have your client variables stored in the database, you'll want to make sure your datasource is enabled to retrieve BLOB's without the 64k limit. One other thing, if you're running on MX in JRUN configuration (not standalone), you can share the sessions between servers (if I remember right). J2EE has clustering built in and I believe it supports the equivalent of a session state server. Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 9:22 AMTo: discussion@acfug.orgSubject: Re: Re: [ACFUG Discuss] Client? Session?In general it seems to me that the rule is that once a user is on a server, they are on the same server. Define complex data. I potentially see structures and possibly an occasional object in the shared scope, but honestly I don't know yet. We don't officially have any code written. mcg Steven Ross [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/26/2006 08:04 PM Please respond todiscussion@acfug.org To discussion@acfug.org cc Subject Re: Re: [ACFUG Discuss] Client? Session? Yeah it depends on how you want your requests routed... it is myunderstanding that if you want the machines to round robin eachrequest then you need to do client variables, if you don't care andyou just want users to stay on one server th
Re: [ACFUG Discuss] Client? Session?
That would be a great presentation for people with concerns for failover.TeddyOn 10/2/06, Dean H. Saxe [EMAIL PROTECTED] wrote:At DI I wrote a session facade to allow runtime configuration of persistence to session, client or both scopes.This allowedflexibility in load balanced/failover environments while allowing thechoice of best performance (session), performance + failover (session client) or failover only (client).Worked like a charm, but it would require tweaking for your CFCs that need to be persisted.-dhsDean H. Saxe, CISSP, CEH[EMAIL PROTECTED]Dissent is the purest form of patriotism. --Thomas JeffersonOn Oct 2, 2006, at 10:31 AM, Teddy Payne wrote: Not the CFC reading the client scope Steve, but more of serializing the CFC into the client scope. The facade that I was referring to was a scope facade for the session scope.I recently came across a facade pattern from Dave Ross that to me shows serious promise for persistence if you want to create less dependency on the session scope. http://www.d-ross.org/index.cfm?objectid=0DF6FA41-EB39- B6C1-5D5D31A245991A2F The article is about Mach-II, but it can seperated and used elsewhere.It is the second article in the three article series. Teddy On 10/2/06, Steven Ross [EMAIL PROTECTED] wrote: Yeah same here and where is the info that says a CFC can't access the client scope? On 10/2/06, Teddy Payne [EMAIL PROTECTED] wrote: I am curious as well.The example of not storing being being able to effectively store a value or service object is a limitation to be sure, but even then that can be worked around with a facade. Teddy On 10/2/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Just out of curiosity, why would you say Don't use the Client scope!? Thanks, Allen -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]]On Behalf Of Jeremy Allen Sent: Saturday, September 30, 2006 12:30 AM To: discussion@acfug.org Subject: Re: Re: [ACFUG Discuss] Client? Session? Don't use the Client scope! There are only a few reasons to use Client scope and I would still think long and hard about it after having maintained an application that was almost purely Client scope for user state.I think you should avoid the client scope unless you have a real and hard requirement that you absolutely can't lose session data in the event of a server failure. I admit, it is kind of nice to still have all of your user sessions when you restart CF and that benefited our applications in some cases. However, I still don't think the benefits for Client scope are not worth it. Sticky sessions are OK in a load balanced situation. You may get some uneven clumping of clients in some cases, but in reality it turns out not to be a big deal. Playing with WDDX and the overheads involved in that and the pain of keeping track of the serialization state of your data just isn't worth it. You can't even serialize a CFC with WDDX, but they will happily live in the session scope. If you do use client scope make sure you abstract it with a good layer around it so that what scope you use is transparent to your application so that you can change it in the future without your application noticing. Look to the Facade design pattern for that. Jeremy On 9/27/06, Teddy Payne [EMAIL PROTECTED] wrote:Allen made a good point about WDDX.I tend to overlook CFWDDX. cfwddx action = "" input = #session# output= client.foo cfdump var=#client.foo# can dump your session into foo variable stored into the client scope. Your result in the DB would look similar to:foo=wddxPacket version#='1.0'header/datastruct type#=' coldfusion.runtime.MemorySessionScope 'var name#='cftoken'string88107569/string/varvar name#='urltoken'stringCFID#=7101amp;CFTOKEN#=88107569/ string/varvar name#='cfid'string7101/string/varvar name#='sessionid'stringTESTAPP_7101_88107569/string/var/ struct/data/wddxPacket# Teddy On 9/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:Just as an aside - you can still store complex structures in client variables but you'll have to wddx them into a string and then store them into the client variable.Also, if you do this and you have your client variables stored in the database, you'll want to make sure your datasource is enabled to retrieve BLOB's without the 64k limit. One other thing, if you're running on MX in JRUN configuration (not standalone), you can share the sessions between servers (if I remember right).J2EE has clustering built in and I believe it supports the equivalent of a session state server. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 9:22 AM To: discussion@acfug.org Subject: Re: Re: [ACFUG Discuss] Client? Session? In general it seems to me tha
Re: [ACFUG Discuss] OT: requesting help regarding my blog
I will take a look Charlie. I was listening to your CF Podcast interview. Good stuff :)TeddyOn 10/2/06, Charlie Arehart [EMAIL PROTECTED] wrote: Folks, this is an off-topic request. Can I ask some help of those who enjoy reading my blog (or would be interested in doing so if they've not yet)? The thing is, I've not had any comments for a few days, which is pretty unusual. Someone complained Thursday of a problem offering a comment, but I couldn't replicate it, nor could he. Still, I've had no more since then and frankly would have expected some for a couple of recent entries, like: -the drop in price on FusionDebug (http://carehart.org/blog/client/index.cfm/2006/9/29/fusiondebug_discounted_pricing ) - or my new UGTV service (http://carehart.org/blog/client/index.cfm/2006/10/2/ugtv_is_on_the_air ) among others. Can I ask anyone who may be so inclined to go there and offer any meaningfulcomment they may be so inclined to offer: not just a testing or works for me, please. And if you go into either of those two and find that there are comments, I'd still ask you try. There may be a browser-specific issue that affects some and not others. Despite my email being offered on the right side of the screen, perhaps people miss it and don't choose to tell me that it fails. Still, I'm looking for just a couple, so if you see more than a couple already posted, don't feel compelled to post if you really don't care to. Thanks in advance. /charlie http://www.carehart.org/blog/ - 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 - -- cf_payne /Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
Re: [ACFUG Discuss] asp version of cfhttp
Ok, I sense a whole people going, huh?Robert, this may not be soemthing the average CF developer or even the above average CF developer doesn't really looks for everyday. We use cfhttp to make our life easy for webservices and referencing remote pages. Perhaps those who are familiar with BD .Net may have more insight with comparison code.Sorry Robert,TeddyOn 9/29/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Can someone point me to a resource or supply some info if there is an ASP equvilent to cfhttp tag.All I want to do ispost form parameters and get the returned file content and then test it's value.It must be in asp only. ThanksRobert-To unsubscribe from this list, manage your profile @http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com--- cf_payne / Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.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 -
