Ecommerce - need it to allow vendors to manage their own inventory sections - any recommendations?
Hi, Need to set up an ecommerce site that will allow every vendor to manage their own items for sale while still being published to one central website. Can any one point me in a good direction to solve this issue? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ecommerce - need it to allow vendors to manage their own inventory sections - any recommendations?
Michael thank you, I'll take a look now... -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: 2011-09-08 09:11 To: cf-talk Subject: Re: Ecommerce - need it to allow vendors to manage their own inventory sections - any recommendations? Perhaps this module for Magento might be the ticket. You'd have to dig deeper than my ten second scan though. Good luck. http://www.magentocommerce.com/magento-connect/AITOC%2C+Inc./extension/1844/ advanced-permissions On Thu, Sep 8, 2011 at 9:00 AM, cfcom cf...@aceligent.com wrote: Hi, Need to set up an ecommerce site that will allow every vendor to manage their own items for sale while still being published to one central website. Can any one point me in a good direction to solve this issue? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT - adding password forgot function to Mura CMS
First, sorry for the SOT The current version of MURA does not have a 'forgot password' feature. It only gives the user a 'reset' All the emails/passwords are encrypted in the database Does anyone have a suggestion on how to add a traditional 'forgot password' feature that will query the db and return the info to the user's email address? Thank you for your consideration ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - adding password forgot function to Mura CMS
Correction: it appears that Mura hashes the info in the database First, sorry for the SOT The current version of MURA does not have a 'forgot password' feature. It only gives the user a 'reset' All the emails/passwords are encrypted in the database Does anyone have a suggestion on how to add a traditional 'forgot password' feature that will query the db and return the info to the user's email address? Thank you for your consideration ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - Members only app
Good point - am setting up install for Mura now Thank you all again -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-25 12:33 To: cf-talk Subject: Re: SOT - Members only app don't forget, CF only secures CF, if you have PDF, HTML or other types of pages, a CF login will not do anything to stop access to these as they do not involve CF, thus why .htaccess is better. using .htaccess you can still manage your logins via CF and pass them through to your app to restrict access on a more granular level within your app. Plenty of apps have built in user control, any CMS system for example. Farcry as mentioned, MuraCMS, just google ColdFusion CMS for other examples. Russ On Fri, Mar 25, 2011 at 1:00 AM, Gerald Guido gerald.gu...@gmail.comwrote: http://tutorial355.easycfm.com/ On Thu, Mar 24, 2011 at 6:56 PM, cfcom cf...@aceligent.com wrote: Need to make login feature that unlocks site pages for specific visitors -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-24 18:44 To: cf-talk Subject: Re: SOT - Members only app if you are simply asking about the security side of things, then the best way is to use .htaccess which will secure EVERYTHING, not use cf files. You should already have this or something equivalent available by default, ask your host. On Thu, Mar 24, 2011 at 10:35 PM, cfcom cf...@aceligent.com wrote: Can anyone recommend a good app for creating a simple and secure members section Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - Members only app
So if I set up mura I could then add the .htacess and it would be good -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-25 13:09 To: cf-talk Subject: Re: SOT - Members only app setting everything to run through CF would be a very cludgey solution. Rather like using a JCB as a shoehorn. On Fri, Mar 25, 2011 at 5:01 PM, Bryan Stevenson br...@electricedgesystems.com wrote: On Fri, 2011-03-25 at 16:32 +, Russ Michaels wrote: don't forget, CF only secures CF, if you have PDF, HTML or other types of pages, a CF login will not do anything to stop access to these as they do not involve CF, True, but the web server can be configured to have other file types run through CF. For example we have a client site that secures a load of PDF and HTML files via CF using this method. I missed the rest of this thread, so apologies if I've missed a key details.just had some potentially useful inputso I inputted ;-) Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT - Members only app
Can anyone recommend a good app for creating a simple and secure members section Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - Members only app
Need to make login feature that unlocks site pages for specific visitors -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-24 18:44 To: cf-talk Subject: Re: SOT - Members only app if you are simply asking about the security side of things, then the best way is to use .htaccess which will secure EVERYTHING, not use cf files. You should already have this or something equivalent available by default, ask your host. On Thu, Mar 24, 2011 at 10:35 PM, cfcom cf...@aceligent.com wrote: Can anyone recommend a good app for creating a simple and secure members section Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 Content extraction from PDF / CFspreadsheet excel extraction
Need to upload pdf's thru form post and have their text/images extracted and put into database. - if I upload a 10 page pdf will the extraction make logical page breaks and formatting etc? Also need to upload excel spreadsheets thru form post and extract their data into db. - need to extract data and post to cfchart Has anyone been doing this with CF9 that can share feedback on how it worked for them? Thank you in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL 139 transaction error
Is anyone familiar with MySql 139 transaction storage error. I've switched the engine from InnoDB to MyISAM but am still seeing issues. Am running MySql 5. Am wondering if I should move from open source to a different DB - Any suggestions or insight would be most appreciated. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL 139 transaction error
Error 139 appears to be some kind of bug http://bugs.mysql.com/bug.php?id=10035 Its occurring with a legacy form. Originally error would throw if upload attachment. Changed InnoDB to MyISAM and upload went fine Now if modify text box in form throws same error. Considering switching to MSSQL if cant resolve Any thoughts would be appreciated -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 2010-10-15 13:23 To: cf-talk Subject: Re: SQL 139 transaction error Since MyISAM is a non-transactional storage engine, the error doesn't make too much sense to me. Are you sure your migration from InnoDB was successful, and that you are infact using MyISAM and not InnoDB on this table? -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Oct 15, 2010 at 10:34 AM, cfcom cf...@aceligent.com wrote: Is anyone familiar with MySql 139 transaction storage error. I've switched the engine from InnoDB to MyISAM but am still seeing issues. Am running MySql 5. Am wondering if I should move from open source to a different DB - Any suggestions or insight would be most appreciated. TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFML broadcasting app
We have to do a large mailing in-house. Has anyone written an Email Broadcasting system in Coldfusion and/or can recommend one? Thank you ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFML broadcasting app
Several hundred thousand, possible 2MM -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: 2010-08-06 14:48 To: cf-talk Subject: RE: CFML broadcasting app We have to do a large mailing in-house. Has anyone written an Email Broadcasting system in Coldfusion and/or can recommend one? How large do you consider large? -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sensitive data collection practices with cf
Question about collecting sensitive data. We have a form set up with an ssl cert On the form there is an tax id number / social security box The data gets posted to a mysql database a) do you recommend adding additional encryption to the data when we put it into the database b) there is an auto email sent to the client's backoffice where the data is received - what is a good practice for handling the sensitive data on the email? Thank you ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: sensitive data collection practices with cf
Thank you Dave, you made some good points and I'm grateful for your feedback. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 2010-07-30 11:38 To: cf-talk Subject: Re: sensitive data collection practices with cf Question about collecting sensitive data. Any answer you're likely to get here will be incomplete - including mine. You may have specific statutes with which you must comply, also. We have a form set up with an ssl cert On the form there is an tax id number / social security box The data gets posted to a mysql database a) do you recommend adding additional encryption to the data when we put it into the database A yes or no answer here isn't really that useful. What is the threat profile for the data? Where would you store encryption keys? Any time you start talking about encryption, that should really be the first question you address - where do the keys go? As a short answer, if you encrypt the data from your CF application, and the same CF application has the ability to decrypt the data, then if your CF application is compromised - which is the most likely outcome from an external attack - the encryption won't really provide much value. Ideally, your public-facing application would have the ability to encrypt data, but not decrypt it. You might have an internal, private-facing application on a separate server that can decrypt the data, but not encrypt it. b) there is an auto email sent to the client's backoffice where the data is received - what is a good practice for handling the sensitive data on the email? One option is to exclude the sensitive information from the email. The email could simply contain a link to a page that requires authentication to view the sensitive data. Alternatively, there are mechanisms for encrypting email, although I don't know offhand how well they play with CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: sensitive data collection practices with cf
That's an excellent point - thank you Scott -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: 2010-07-30 11:38 To: cf-talk Subject: Re: sensitive data collection practices with cf b) there is an auto email sent to the client's backoffice where the data is received - what is a good practice for handling the sensitive data on the email? Dont.. set up an admin interface and let them know they have data to attend to. Sending SSN's and TIN's over email is a bad idea. Stick the admin interface behind an SSL cert On Fri, Jul 30, 2010 at 11:24 AM, cfcom cf...@aceligent.com wrote: Question about collecting sensitive data. We have a form set up with an ssl cert On the form there is an tax id number / social security box The data gets posted to a mysql database a) do you recommend adding additional encryption to the data when we put it into the database b) there is an auto email sent to the client's backoffice where the data is received - what is a good practice for handling the sensitive data on the email? Thank you ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: sensitive data collection practices with cf
Wow, nice technique - yes I would definitely like to see the code -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 2010-07-30 12:06 To: cf-talk Subject: RE: sensitive data collection practices with cf b) there is an auto email sent to the client's backoffice where the data Is received - what is a good practice for handling the sensitive data on the email? I do exactly this on one of my sites. Instead of putting the data in an email I write out an encrypted password protected PDF file to a protected area on disk, then I attach the file to the email; then delete the file from disk. The email recipient knows the password to the PDF. This works very well. I can send you some code snips if you need but it's rather straight forward. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF - data excel
I need to export to excel. Will be provided only html pages that are not from cf server. Is there a way to set up an import feature to regrab the html data (name, company, address, etc fields) back into CF so it can be easily exported to excel? Thank you ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cflock and cfloop question
Am having some un predictable results with a loop. My code is supposed to copy upload jpegs from a temp folder to the images Folder. But only one jpeg is being moved from temp folder to images folder and the loop isn't grabbing any additional pictures. When the cflock was removed, it grabbed a second image but no more. Any help would be most appreciated - thank you again in advance. CFLOCK TIMEOUT=20 THROWONTIMEOUT=YES TYPE=EXCLUSIVE SCOPE=SERVER cfdirectory action=LIST directory=#house_dir#\temp\#client.userID# name=allimages filter=*.jpg CFLOOP query=allimages cffile action=copy source=#house_dir#\temp\#client.userID#\#name# destination=E:\webs\xyz\images_houses_new\#current_ListingID#_#currentr ow#.jpg nameconflict=overwrite cffile action=copy source=#house_dir#\temp\#client.userID# destination=E:\webs\xyz\images_houses\#current_ListingID#_#currentrow#. jpg nameconflict=overwrite /CFLOOP /CFLOCK ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
FIXED: cflock and cfloop question
ISSUE IS FIXED - THANKS EVERYONE! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need CF help- is anyone available
Having serious problem with a piece of code Is there anyone who could take a look Been racking my head on this all day Please contact off list And thank you in advane ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need CF help- is anyone available
We have a legacy site that was originally written without error handling. Yesterday the old programmer ran a script to clear out the images folder that had grown to 20 gigs. He set up a new image folder but all the images stopped showing up in queries. We've spent all day chasing down globals but it keeps throwing errors and the pictures aren't showing up. Heres notes from what the old programmer did: wrote a script to break up the directory in to smaller directories. The created 900 subdirectories inside a new folder called images_new The image 90031_7.jpg will be in the folder images_houses_new\900\ because it begins with 900. then put a url redirect on the original directory to redirect any 404 errors to a script which will try to find the correct image. also threw the file Directorybreaker.exe into the root dir of the e drive. running it with the old dir as param one and the new drive as param two will break up any new images. only updated the listings pages. His note goes on to something about creating an object called Image.cfc and then extend that to HouseImages.cfc With the exception of the images-folder too big before he touched the code we had most things functioning and now they are not. - any help would be greatly appreciated. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 2010-05-25 16:50 To: cf-talk Subject: Re: Need CF help- is anyone available The best solution is to ask directly here. It allows for allot of people to help. So what's the issue? On Tue, May 25, 2010 at 1:47 PM, cfcom cf...@aceligent.com wrote: Having serious problem with a piece of code Is there anyone who could take a look Been racking my head on this all day Please contact off list And thank you in advane ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need CF help- is anyone available
look for image logic but its not working cfset var mlnumber=Arguments.mlnumber_unformmated cfset var physical_img_path_primary = image_dir ( original image folder) cfset var physical_img_path_secondary = image2_dir ( new image folder ) cfif Mid(mlnumber,1,1) EQ * cfset mlnumber=RemoveChars(mlnumber, 1,1) cfelse cfset mlnumber=mlnumber /cfif cfloop from=1 to=10 index=x !--- assuming there will be maximum up to 10 images for a single listing --- cfif len(trim(mlnumber)) cfif FileExists(#physical_img_path_primary#/#mlnumber#_#x#.jpg)--this one is pulling the ads showing cfreturn #arguments.directory_to_Check#/#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_secondary#/P#mlnumber#_#x#.jpg) --this one I just added cfreturn #arguments.directory2_to_Check#/P#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_primary#/P#mlnumber#_#x#.jpg) cfreturn #arguments.directory_to_Check#/P#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_secondary#/#mlnumber#_#x#.jpg)_ thus you would think this would bring the missing ones up , bneing there is no P added as prefix cfreturn #arguments.directory2_to_Check#/#mlnumber#_#x#.jpg cfabort/ /cfif /cfif cfif FileExists(#physical_img_path_primary#/#arguments.listingID#_#x#.jpg) cfreturn #arguments.directory_to_Check#/#arguments.listingID#_#x#.jpg cfabort/ /cfif /cfloop cfreturn #arguments.directory_to_Check#/nopic.gif /cffunction _ From: Charlie Stell [mailto:charlie.st...@gmail.com] Sent: 2010-05-25 18:39 To: cf...@aceligent.com Subject: Re: Need CF help- is anyone available As long as the image names follow your pattern, you should be able to use a http redirect to a cfm, and in the cfm have something like ...logic to determine X - the complete current file path. cfcontent file=#X# type=image/x-jpgcfsetting showdebugoutput=no **this assumes its a jpg... On Tue, May 25, 2010 at 5:28 PM, cfcom cf...@aceligent.com wrote: We have a legacy site that was originally written without error handling. Yesterday the old programmer ran a script to clear out the images folder that had grown to 20 gigs. He set up a new image folder but all the images stopped showing up in queries. We've spent all day chasing down globals but it keeps throwing errors and the pictures aren't showing up. Heres notes from what the old programmer did: wrote a script to break up the directory in to smaller directories. The created 900 subdirectories inside a new folder called images_new The image 90031_7.jpg will be in the folder images_houses_new\900\ because it begins with 900. then put a url redirect on the original directory to redirect any 404 errors to a script which will try to find the correct image. also threw the file Directorybreaker.exe into the root dir of the e drive. running it with the old dir as param one and the new drive as param two will break up any new images. only updated the listings pages. His note goes on to something about creating an object called Image.cfc and then extend that to HouseImages.cfc With the exception of the images-folder too big before he touched the code we had most things functioning and now they are not. - any help would be greatly appreciated. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 2010-05-25 16:50 To: cf-talk Subject: Re: Need CF help- is anyone available The best solution is to ask directly here. It allows for allot of people to help. So what's the issue? On Tue, May 25, 2010 at 1:47 PM, cfcom cf...@aceligent.com wrote: Having serious problem with a piece of code Is there anyone who could take a look Been racking my head on this all day Please contact off list And thank you in advane ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need CF help- is anyone available
This query brought up a few more pictures but still not all of them CFQUERY name=getListings datasource=#123# maxrows=250 SELECT script_listings.*, Barns.*, script_listings.ml_num as listing FROM script_listings LEFT OUTER JOIN Barns ON script_listings.ml_num = Barns.ml_num !---WHERE script_listings.hide = 0 I commented this line AND script_listings.tmp = 0 AND script_listings.class = 'res' ,,,to this line to show more prpperties ORDER BY !---script_listings.town, script_listings.lp_dol script_listings.ListingDate DEsc /cfquery look for image logic but its not working cfset var mlnumber=Arguments.mlnumber_unformmated cfset var physical_img_path_primary = image_dir ( original image folder) cfset var physical_img_path_secondary = image2_dir ( new image folder ) cfif Mid(mlnumber,1,1) EQ * cfset mlnumber=RemoveChars(mlnumber, 1,1) cfelse cfset mlnumber=mlnumber /cfif cfloop from=1 to=10 index=x !--- assuming there will be maximum up to 10 images for a single listing --- cfif len(trim(mlnumber)) cfif FileExists(#physical_img_path_primary#/#mlnumber#_#x#.jpg)--this one is pulling the ads showing cfreturn #arguments.directory_to_Check#/#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_secondary#/P#mlnumber#_#x#.jpg) --this one I just added cfreturn #arguments.directory2_to_Check#/P#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_primary#/P#mlnumber#_#x#.jpg) cfreturn #arguments.directory_to_Check#/P#mlnumber#_#x#.jpg cfabort/ /cfif cfif FileExists(#physical_img_path_secondary#/#mlnumber#_#x#.jpg)_ thus you would think this would bring the missing ones up , bneing there is no P added as prefix cfreturn #arguments.directory2_to_Check#/#mlnumber#_#x#.jpg cfabort/ /cfif /cfif cfif FileExists(#physical_img_path_primary#/#arguments.listingID#_#x#.jpg) cfreturn #arguments.directory_to_Check#/#arguments.listingID#_#x#.jpg cfabort/ /cfif /cfloop cfreturn #arguments.directory_to_Check#/nopic.gif /cffunction _ From: Charlie Stell [mailto:charlie.st...@gmail.com] Sent: 2010-05-25 18:39 To: cf...@aceligent.com Subject: Re: Need CF help- is anyone available As long as the image names follow your pattern, you should be able to use a http redirect to a cfm, and in the cfm have something like ...logic to determine X - the complete current file path. cfcontent file=#X# type=image/x-jpgcfsetting showdebugoutput=no **this assumes its a jpg... On Tue, May 25, 2010 at 5:28 PM, cfcom cf...@aceligent.com wrote: We have a legacy site that was originally written without error handling. Yesterday the old programmer ran a script to clear out the images folder that had grown to 20 gigs. He set up a new image folder but all the images stopped showing up in queries. We've spent all day chasing down globals but it keeps throwing errors and the pictures aren't showing up. Heres notes from what the old programmer did: wrote a script to break up the directory in to smaller directories. The created 900 subdirectories inside a new folder called images_new The image 90031_7.jpg will be in the folder images_houses_new\900\ because it begins with 900. then put a url redirect on the original directory to redirect any 404 errors to a script which will try to find the correct image. also threw the file Directorybreaker.exe into the root dir of the e drive. running it with the old dir as param one and the new drive as param two will break up any new images. only updated the listings pages. His note goes on to something about creating an object called Image.cfc and then extend that to HouseImages.cfc With the exception of the images-folder too big before he touched the code we had most things functioning and now they are not. - any help would be greatly appreciated. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 2010-05-25 16:50 To: cf-talk Subject: Re: Need CF help- is anyone available The best solution is to ask directly here. It allows for allot of people to help. So what's the issue? On Tue, May 25, 2010 at 1:47 PM, cfcom cf...@aceligent.com wrote: Having serious problem with a piece of code Is there anyone who could take a look Been racking my head on this all day Please contact off list And thank you in advane
OT - Problems with CF code in Adminprotools
Sorry for the off topic - but am having some trouble with cfml code from Adminprotools. If anyone knows how to contact Jared or Isaac from Adminprotools please contact me off-list. Thank you in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
anyone using adminpro's Email list mgr ?
My personalization variables are not working - any suggestions? [First Name] [Last Name] [Email] [List] [Date Short] [Date Med] [Date Long] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem porting Justin Anderson's CF_X_Survey to MySql
Has anyone successfully ported Justin Anderson's CF_X_Survey to MySql - I haven't been able to get mine to work. http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetailloc=en _usextid=1000426 thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: problem porting Justin Anderson's CF_X_Survey to MySql
Survey.mdb (access 97 file format) Comments (table) Commentid = autonumber Surveyid = number dateEntered = date/time username = text userEmail = text usersWeb = text subject = text comments = memo Options (table) OptionId = autonumber surveyid = number questionOption = text votes = number Schedule (table) SurveyId = number Startdate = date/time Enddate = date/time Survey (table) surveyId = autonumber dateEntered = date/time question = memo http://aceligen.com/cfxsurvey/ I am unable to see the results or vote. when I press vote it throws this error: Error Occurred While Processing Request The value '' cannot be converted to a number. -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: 2009-08-26 10:55 To: cf-talk Subject: Re: problem porting Justin Anderson's CF_X_Survey to MySql What errors are you getting? And what is the original database format? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: problem CF_X_Survey to MySql - same error on MSSql
I'm getting the same error thru MSSql also - anyone have any ideas what is causing it? Error Occurred While Processing Request The value cannot be converted to a number http://www.aceligent.com/cfxsurvey/survey/surveyResults.cfm http://www.aceligent.com/cfxsurvey/ -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: 2009-08-26 11:38 To: cf-talk Subject: RE: problem porting Justin Anderson's CF_X_Survey to MySql Survey.mdb (access 97 file format) Comments (table) Commentid = autonumber Surveyid = number dateEntered = date/time username = text userEmail = text usersWeb = text subject = text comments = memo Options (table) OptionId = autonumber surveyid = number questionOption = text votes = number Schedule (table) SurveyId = number Startdate = date/time Enddate = date/time Survey (table) surveyId = autonumber dateEntered = date/time question = memo http://aceligen.com/cfxsurvey/ I am unable to see the results or vote. when I press vote it throws this error: Error Occurred While Processing Request The value '' cannot be converted to a number. -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: 2009-08-26 10:55 To: cf-talk Subject: Re: problem porting Justin Anderson's CF_X_Survey to MySql What errors are you getting? And what is the original database format? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT - Large Multi Question Polling App recommendation
Sorry for the SOT, but can anyone recommend a polling system that can present apx 30 questions at a time with barchart results. Most systems I've seen are based on one question with several answers. Thank you for your consideration. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: phone formating string and removing hidden characters
I set up a form to identify the character, but the square doesnt paste. When I opened the orig file of the phone numbers in word it did list the numbers on single lines so it may be a newline character. My Loop must be wrong, it's only passing one value, any suggestions would be most appreciated. form action=phone_action2.cfm enctype=multipart/form-data method=post pEnter the complete path and filename of the file to upload: input type=file name=FiletoUpload size=45 /p input type=submit value=Upload /form cfoutput cfloop list=#FiletoUpload# index=i delimiters=chr(10) chr(13) , cfset form.phone = #FiletoUpload# cfset cleanPhone = ReReplace(form.phone, [^0-9], , ALL) cfoutput#cleanPhone#/cfoutput,br / /cfloop /cfoutput !--- if the character string is not empty, output its ASCII value --- cfif IsDefined(FORM.charVals) cfif FORM.charVals is not cfoutput#Left(FORM.charVals,1)# = #Asc(FORM.charVals)#/cfoutput cfelse !--- if it is empty, output an error message --- h4Enter a character/h4 /cfif /cfif form action = asc.cfm method=post pEnter a character to see its ASCII value brinput type = Text name = CharVals size = 1 maxlength = 1 pinput type = Submit name = input type = RESET /form -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: 2009-05-19 14:13 To: cf-talk Subject: Re: phone formating string and removing hidden characters just read it in doing a cffile and then do a cfloop over the content using the newline as the delimiter (as Mark suggested). no need for importing into a database or having to count 'x' number of characters. you've already got the data delimited. just loop over it and use the regex you posted earlier to remove any non-numeric characters from each list element. On Tue, May 19, 2009 at 11:09 AM, cfcom cf...@aceligent.com wrote: Mark, I think it's a newline character I'm thinking I have to import the list into the database. Then query it With the cfloop. My question is how to I set the loop to do a 10 count sequence? Thanks Steve -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: 2009-05-19 13:53 To: cf-talk Subject: RE: phone formating string and removing hidden characters That screenshot looks like a newline character (or is it a linefeed?) as shown by an editor that was expecting a more Windows-ly standard line ending. Other editors (like EditPad) would probably show each phone number on its own line. Anyway, you can use cf's asc() method to find the actual value of the Nth character (the one that shows up as a box) and then you'll know what delimiter to use with the list functions. (I bet the character is 10 or 13, so you could try to set a delimiter of chr(10) or chr(13) and see what happens.) Once you know the delimited you can use a list function like cfloop list=.. delimiter=.. or ListToArray(list, delimiter) to convert your file content to individual lines. (You have lots of options... The key is figuring our what delimiter to use.) Thanks Mark -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Tuesday, May 19, 2009 1:23 PM To: cf-talk Subject: phone formating string and removing hidden characters Hi, I have a text file of 100,000 plus phone numbers that I need to change formatting and export to a clean list. There is an unusual hidden character that doesn't appear when pasting. Here is a screen shot http://www.aceligent.com/post/hidden.html The list is compiled in this manner, 'X' is supplemented for where the hidden character is: 212,2000876x212,2002686x212,2005799x212,2007697x212,2010062x212,2010087x 212, 2010112x212,2010192x212,2010237x212,2010306x212,2010326x212,2010710x212, 2010 714x212,2010740x212,2010754x212,2010800x212,2010978x212,2011063x212,2011 065x I need to process the list as a batch. How would I adapt this to clean and count a 10 number sequence; add a coma; and repeat on new line? Then export as a text file. cfset form.phone = #form.phoneinput# cfset cleanPhone = ReReplace(form.phone, [^0-9], , ALL) cfoutput#cleanPhone#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
phone formating string and removing hidden characters
Hi, I have a text file of 100,000 plus phone numbers that I need to change formatting and export to a clean list. There is an unusual hidden character that doesn't appear when pasting. Here is a screen shot http://www.aceligent.com/post/hidden.html The list is compiled in this manner, 'X' is supplemented for where the hidden character is: 212,2000876x212,2002686x212,2005799x212,2007697x212,2010062x212,2010087x212, 2010112x212,2010192x212,2010237x212,2010306x212,2010326x212,2010710x212,2010 714x212,2010740x212,2010754x212,2010800x212,2010978x212,2011063x212,2011065x I need to process the list as a batch. How would I adapt this to clean and count a 10 number sequence; add a coma; and repeat on new line? Then export as a text file. cfset form.phone = #form.phoneinput# cfset cleanPhone = ReReplace(form.phone, [^0-9], , ALL) cfoutput#cleanPhone#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: phone formating string and removing hidden characters
Mark, I think it's a newline character I'm thinking I have to import the list into the database. Then query it With the cfloop. My question is how to I set the loop to do a 10 count sequence? Thanks Steve -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: 2009-05-19 13:53 To: cf-talk Subject: RE: phone formating string and removing hidden characters That screenshot looks like a newline character (or is it a linefeed?) as shown by an editor that was expecting a more Windows-ly standard line ending. Other editors (like EditPad) would probably show each phone number on its own line. Anyway, you can use cf's asc() method to find the actual value of the Nth character (the one that shows up as a box) and then you'll know what delimiter to use with the list functions. (I bet the character is 10 or 13, so you could try to set a delimiter of chr(10) or chr(13) and see what happens.) Once you know the delimited you can use a list function like cfloop list=.. delimiter=.. or ListToArray(list, delimiter) to convert your file content to individual lines. (You have lots of options... The key is figuring our what delimiter to use.) Thanks Mark -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Tuesday, May 19, 2009 1:23 PM To: cf-talk Subject: phone formating string and removing hidden characters Hi, I have a text file of 100,000 plus phone numbers that I need to change formatting and export to a clean list. There is an unusual hidden character that doesn't appear when pasting. Here is a screen shot http://www.aceligent.com/post/hidden.html The list is compiled in this manner, 'X' is supplemented for where the hidden character is: 212,2000876x212,2002686x212,2005799x212,2007697x212,2010062x212,2010087x 212, 2010112x212,2010192x212,2010237x212,2010306x212,2010326x212,2010710x212, 2010 714x212,2010740x212,2010754x212,2010800x212,2010978x212,2011063x212,2011 065x I need to process the list as a batch. How would I adapt this to clean and count a 10 number sequence; add a coma; and repeat on new line? Then export as a text file. cfset form.phone = #form.phoneinput# cfset cleanPhone = ReReplace(form.phone, [^0-9], , ALL) cfoutput#cleanPhone#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFML server alternatives - Railo, JBoss, Smith
Has anyone set-up a Jboss, Railo, Sava cms intranet environment? I am interested in setting up Sava on windows in as reasonable cost basis as possible. Can anyone comment on their experience doing so; it's current practicality and ease of setting up an alternative coldfusion server environment. Thank you ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Solved --- CFChart DateRange
All fixed, thank you anyway. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFChart DateRange
I have a form to pass date ranges to cfchart but its coming up empty, any ideas? form method=post action=chartresults.cfm name=request_range pStart Date: input type=text name=startDate value=cfoutput#DateFormat(Now(), '-mm-dd')#/cfoutput onfocus=this.value='' style=background-color:#f2f2f2; br End Date: input type=text name=endDate value=cfoutput#DateFormat(Now(), '-mm-dd')#/cfoutput onfocus=this.value='' style=background-color:#f2f2f2; br / input type=submit name=submit value=Submit / /form CFSET start = #CREATEODBCDATETIME(startdate)# CFSET end = #CREATEODBCDATETIME(enddate)# cfquery name=Red datasource=xyz Select * From Counts WHERE ((counts.sentdate BETWEEN #CreateODBCDate(start)# AND #CreateODBCDate(end)#)) AND msgtype = 'Red' /cfquery The total number of Red submissions are: bcfoutput#Red.recordcount#/cfoutput/b p /p cfquery name=Blue datasource=xyz Select * From Counts WHERE ((counts.sentdate BETWEEN #CreateODBCDate(start)# AND #CreateODBCDate(end)#)) AND msgtype = 'Blue' /cfquery The total number of Blue submissions are: bcfoutput#Blue.recordcount#/cfoutput/b p /p cfquery name=Green datasource=xyz Select * From Counts WHERE ((counts.sentdate BETWEEN #CreateODBCDate(start)# AND #CreateODBCDate(end)#)) AND msgtype = 'Green' /cfquery The total number of Green submissions are: bcfoutput#Green.recordcount#/cfoutput/b p /p cfquery name=Yellow datasource=xyz Select * From Counts WHERE ((counts.sentdate BETWEEN #CreateODBCDate(start)# AND #CreateODBCDate(end)#)) AND msgtype = 'Yellow' /cfquery The total number of Yellow submissions are: bcfoutput#Yellow.recordcount#/cfoutput/b !--- sent by email --- p /p cfquery name=Everything datasource=xyz Select * From Counts /cfquery The total number of All Color submissions are: bcfoutput#Everything.recordcount#/cfoutput/b p /p p /p cfchart format=flash scalefrom=1 scaleto=40 backgroundcolor=##CC showxgridlines=yes showygridlines=yes showborder=no fontbold=no fontitalic=no xaxistitle=CATEGORIES yaxistitle=COUNT show3d=yes rotated=no sortxaxis=no showlegend=yes showmarkers=yes cfchartseries type=bar serieslabel=Color Teams seriescolor=##0099FF paintStyle=shade markerStyle=rectangle colorlist = ##99ccFF, ##0099FF, ##9966FF, ##990099 cfchartdata item=RED value=#red.recordcount# cfchartdata item=BLUE value=#blue.recordcount# cfchartdata item=GREEN value=#green.recordcount# cfchartdata item=YELLOW value=#yellow.recordcount# /cfchartseries /cfchart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (OT) W32.Virut.W
ESet will give you the path of virus file and registry values to delete. I believe Panda's free online scanner that will remove viruses for you once you register with an email. HTH. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 2009-03-26 05:13 To: cf-talk Subject: Re: (OT) W32.Virut.W Thanks but neither solution seems to have an option to actually remove the viruses. On Wed, Mar 25, 2009 at 11:33 PM, Kym Kovan dev-li...@mbcomms.net.auwrote: Michael Dinowitz wrote: The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to remove this virus remotely on a windows 2000 machine? I can't boot it into safe mode so that's not an option. Thanks We have used TrendMicro's Housecall successfully on some virii or check the other online ones: http://www.precisesecurity.com/antivirus/online-scan.htm -- Yours, Kym Kovan mbcomms.net.au ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Date Range blank
I am trying to do a single page form for a Date Range query, with no luck. I have a record in 'counts.sentdate' with 03/24/2009 but when I use a range in the form of 03/20/2009 to 03/26/2009 no records are retrieved. I have also tried it as a 'form/action page' two part with same results. Any suggestions? Is it the dateformating? cfparam name=request.submit default= cfif request.submit eq Submit cfelse !--- show form --- form method=post action=# name=ranges pStart Date: input type=text name=startDate value=cfoutput#DateFormat(Now(), 'mm/dd/')#/cfoutput onfocus=this.value='' style=background-color:#f2f2f2; br End Date: input type=text name=endDate value=cfoutput#DateFormat(Now(), 'mm/dd/')#/cfoutput onfocus=this.value='' style=background-color:#f2f2f2; br / input type=submit name=submit value=Submit / /form /cfif -- cfquery name=testresults SELECT * From counts WHERE ((counts.sentDate BETWEEN #CreateODBCDate(form.StartDate)# AND #CreateODBCDate(form.EndDate)#)) ORDER BY msgtype /cfquery --- table cellpadding=1 cellspacing=0 width=100% border=1 bordercolor=silver tr thMember Name/th thCompleted/th /tr !-- IF THERE ARE NO RESULTS -- cfif #testresults.recordcount# is 0 tr td colspan=2 align=centerNo records found in that date range/td /tr /cfif !-- IF THERE ARE RESULTS THEN DISPLAY THEM -- cfoutput query=testresults tr td#testresults.msgType#/td td#DateFormat(testresults.sentDate, 'mm/dd/')#/td /tr /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHeader - appending date to xls file name
I want to add the DATE to my file name in cfheader but it did not work. Any suggestions cfcontent type=application/msexcel cfquery datasource=dsn name=foobar SELECT * FROM blasts ORDER BY memberid /cfquery cfset TheDate = Now() cfheader name=Content-Disposition value=filename=ResolveIT_Listcfoutput#Now()#/cfoutput.xls table cfoutput query=foobar tr td#FirstName#/td td#LastName#/td td#Email#/td td#Address1#/td td#City#/td td#State#/td td#Zip#/td /tr /cfoutput cfheader name=Content-Disposition value=filename=MyFilescfoutput#DateFormat(TheDate, 'mm-dd-yy')#/cfoutput.xls ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Solved:---- CFHeader - appending date to xls file name
Thanks all solved! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (OT) W32.Virut.W
Michael I think the online virus scanner by Eset can do that. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 2009-03-25 22:55 To: cf-talk Subject: (OT) W32.Virut.W The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to remove this virus remotely on a windows 2000 machine? I can't boot it into safe mode so that's not an option. Thanks -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional Si, soy el senor chico malo para todos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
increment problem
I'm having a brain drain on a simple increment I need to log and count who sends an email, how often it's sent, which category its sent from and how many times a recipient gets it. I'm sure theres a better way === Sender Table: Sender_id, Fname, lname, address, email, date, category, count Recip Table: Recip_id, Recip_Fname, Recip_lname, Recip_email, Category_Count Table: BlueGroup_id (int), Bluecreate_date, Bluecreate_time, Bluecount, Bluesentby_email, BlueRecip_id RedGroup_id (int), Redcreate_date, Redcreate_time, Redcount, Redsentby_email, RedRecip_id YellowGroup_id (int), yellowcreate_date, yellowcreate_time, yellowcount, yellowsentby_email, YellowRecip_id WhiteGroup_id (int), Whitecreate_date, Whitecreate_time, Whitecount, Whitesentby_email, WhiteRecip_id Cfquery name=updateuser' Insert into sender (fname, lname, email, date, etc) /cfquery cfquery name='update_count UPDATE Category_Count SET count = count +1 /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: increment problem
Each sender selects from four different types of content categories to send an email from. A loop is used to send out to each email on the list. I was trying to work out using an update + 1 to count how to keep track of everything, but ran into a wall. -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: 2009-03-06 19:49 To: cf-talk Subject: Re: increment problem Not entirely sure what you're trying to do, but certainly you shouldn't have four category/count tables. Something closer to this: Category_Count -- Category_id (int) Group_id (int) create_date create_time count sentby_email Recip_id Category id (int) colour (varchar?) But I don't understand how the counting actually occurs, or what the colours signify. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FCKeditor not retaining format when used in CF CMS
Tom - Am using the SAVA cms and they did modify the fckeditor.js Need to be able to retain formatting in form... looking into to options. -Original Message- From: Tom McNeer [mailto:tmcn...@gmail.com] Sent: 2009-03-05 09:19 To: cf-talk Subject: Re: FCKeditor not retaining format when used in CF CMS On Wed, Mar 4, 2009 at 5:49 PM, cfcom cf...@aceligent.com wrote: Does anyone know how to configure the FCKconfig.js to correct this issue? It's very doubtful that the FCKconfig.js has anything to do with this, unless the builder of your CMS modified it hugely. I've used FCKEditor in a number of CF applications without problems. It's more likely that the HTML is being stripped somewhere else. Is there a reason you can't ask the builder of the CMS about the issue? And have you dumped the output of the form, before it undergoes any further processing, to see what it shows? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FCKeditor not retaining format when used in CF CMS
I am running a CF based CMS that uses FCKeditor. Everytime I put content into a textarea it loses its line breaks and formatting. Does anyone know how to configure the FCKconfig.js to correct this issue? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to Form variables from: request.servletEvent.getValue('fieldName')
I need to pass the variables from a third party application form to my own
cfmail. The third party app states them as (3fname, lname, address, state,
city, zip, email')
The form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')
Would they be accessible if you used this way?
#request.serlvetEvent.getValue('fname')#
#request.serlvetEvent.getValue('lname')#
CFIF IsDefined(form.submit)
cfinsert datasource=myName_dsn tablename=myTableName
formfields=sender_firstname, sender_lastname, sender_email,
sender_address, sender_city, sender_state, sender_zip,
sender_time, sender_date, sender_ip, sender_msgType
CFQUERY NAME=GetRecipients datasource=myName_dsn
SELECT *
FROM recipients
/CFQUERY
cfloop query=GetRecipients
cfmail to=#GetRecipients.recip_email#
from=#form.sender_email#
subject=MySubject
Dear #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# ,
This is my written note.
Yours truly,
#sender_firstname# #sender_lastname#
#sender_address#
#sender_city#, #sender_state# #sender_zip#
#sender_email#
/cfmail
/cfloop
2. I need to pass the ', is there a specific method I need to use to call up
the sava form variables in my own cfmail?
All of your form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Form variables from: request.servletEvent.getValue('fieldName')
It would start from a Sava Form,
Pass variables to my CF actions
Then do a confirmation page back with in Sava Framework
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 2009-02-26 12:35
To: cf-talk
Subject: Re: How to Form variables from:
request.servletEvent.getValue('fieldName')
I need to pass the variables from a third party application form to my own
cfmail. The third party app states them as (3fname, lname, address, state,
city, zip, email')
The form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')
I'm not sure exactly what you mean. Is this third-party form posting
to the URL of one of your CF pages? If so, you'll just get a bunch of
form variables - no need to use request.yaddaYaddaYadda.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Form variables from: request.servletEvent.getValue('fieldName')
Yes, it would post to myCF then return to Sava
-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com]
Sent: 2009-02-26 21:17
To: cf-talk
Subject: Re: How to Form variables from:
request.servletEvent.getValue('fieldName')
That still isn't answering the question. Is your Sava form going to
perform a POST to your CF page or not?
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/2/27 cfcom cf...@aceligent.com:
It would start from a Sava Form,
Pass variables to my CF actions
Then do a confirmation page back with in Sava Framework
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 2009-02-26 12:35
To: cf-talk
Subject: Re: How to Form variables from:
request.servletEvent.getValue('fieldName')
I need to pass the variables from a third party application form to my
own
cfmail. The third party app states them as (3fname, lname, address,
state,
city, zip, email')
The form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')
I'm not sure exactly what you mean. Is this third-party form posting
to the URL of one of your CF pages? If so, you'll just get a bunch of
form variables - no need to use request.yaddaYaddaYadda.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Server Administration
We want to migrate a client from ASP/MSSql to CF/MySql Server: Can anyone describe how CF Server is easier to administrate that ASP? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
counting questions with cf
I want to count each time an email is sent to a different group. I have listID(identity increment), fname, lname, email, grp1, grp2, grp3 I have 3 groups (grp1, grp2, grp3) that I want to track My example email goes out to grp1: Would an UPDATE work for adding the counts cfquery Update MyEmailList Set sendcount = grp1 +1 /cfquery And would a dataType of BigInit be correct in the SQL? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: counting questions with cf adding time tracking
how would I add the ability to track the date and time of each email per group (grp1, grp2, grp3) would I add grp1_sendDate, grp1_sendTime, grp2_sendDate, grp2_sendTime, grp3_sendDate, grp3_sendTime to listID(identity increment), fname, lname, email, grp1, grp2, grp3, cfquery UPDATE MyEmailList SET grp = grp1 + 1 /cfquery -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: 2009-02-13 13:50 To: cf-talk Subject: Re: counting questions with cf INT should work fine. unless you foresee going over 2,147,483,647 trackable emails (which I suppose is possible... in which case bigint would work as well... it'd just take up twice the space). for the actual SQL, you'd want SET grp1 = grp1 + 1 On Fri, Feb 13, 2009 at 10:44 AM, cfcom cf...@aceligent.com wrote: I want to count each time an email is sent to a different group. I have listID(identity increment), fname, lname, email, grp1, grp2, grp3 I have 3 groups (grp1, grp2, grp3) that I want to track My example email goes out to grp1: Would an UPDATE work for adding the counts cfquery Update MyEmailList Set sendcount = grp1 +1 /cfquery And would a dataType of BigInit be correct in the SQL? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Implementing Coldfusion and Sava CMS
I have custom CF form that I need to use in Sava. I have first made a
component, then I called my custom form thru
[sava]dspInclude('display_objects/custom/friendclean1.cfm')[/sava]
But I am having trouble connecting it to the 'action page' thru Sava.
my form is:
cfform action=MyCustomAction.cfm method=POST enablecab=Yes
name=MyCustomform onsubmit='return checkForm();'
I have tried a couple of approaches without success
1) I made another component that I called up thru a page with use of a
similar sava tag:
[sava]dspInclude('display_objects/custom/mycustomaction.cfm')[/sava]
2) I tried using the Unique ID that Sava places to each component, but it
didn't work
[sava]dspInclude('display_objects/custom/965321_SavaID')[/sava]
Does anyone know the correct procedure?
Thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318909
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfloop newletter - need to add send counts
cfloop list=#recipients# index=recipient I loop over a list of email addresses to send out a newsletter. I need to add the ability to count how many times it is sent to each different recipient on the list; ie: date, time, count, and category - any recommendations? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adding send counts to CFLoop Newsletter
cfloop list=#recipients# index=recipient I loop over a list of email addresses to send out a newsletter. I need to add the ability to count how many times it is sent to each different recipient on the list; ie: date, time, count, and category - any recommendations? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Personalizing a CFLoop
CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. cfinsert datasource=mynamedsn tablename=mytablename formfields=sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType cfset recipients=b...@domain.com, a...@domain.com, em...@domain.com, j...@domain.com cfloop list=#recipients# index=recipient delimiters=, cfmail to=#recipient# from=#sender_email# subject=My Message To You 2009 #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# /cfmail /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:01 PM To: cf-talk Subject: Personalizing a CFLoop CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. cfinsert datasource=mynamedsn tablename=mytablename formfields=sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType cfset recipients=b...@domain.com, a...@domain.com, em...@domain.com, j...@domain.com cfloop list=#recipients# index=recipient delimiters=, cfmail to=#recipient# from=#sender_email# subject=My Message To You 2009 #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# /cfmail /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop
Not sure if I have this right. Some of the recipients Names are not used in
their email, such as ('Mark Jones', 'mana...@zzz.com') How would that
structure work?
cfset fisttoat = find(#recipient#, '@')
cfset firstname = left(#recipient#, #firsttoat#)
cfset recipients=b...@domain.com, a...@domain.com, em...@domain.com,
j...@domain.com
cfloop list=#recipients# index=recipient delimiters=,
cfmail to=#recipient# from=#sender_email# subject=My Message
To You 2009
Dear #left#,
This is my message to the recipient. This is my message to the
recipient.
Yours truly,
#sender_firstname# #sender_lastname#
/cfmail
/cfloop
-Original Message-
From: Rob Parkhill [mailto:robert.parkh...@gmail.com]
Sent: 2009-01-05 2:08 PM
To: cf-talk
Subject: Re: Personalizing a CFLoop
Well I am sure that there is a more elegant REGEX solution, but you can
always do a FIND and then a LEFT
so:
cfset fisttoat = find(#recipient#, '@')
cfset firstname = left(#recipient#, #firsttoat#)
I am sure someone will post something more elegant, but that will work.
Rob
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). cfinsert datasource=mynamedsn tablename=mytablename formfields=sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType CFQUERY NAME=GetRecipients datasource=mynamedsn SELECT * FROM mytablename /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# /cfmail /cfloop -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. CFQUERY NAME=GetRecipients DATASOURCE=#DataSource# SELECT * FROM Recipients /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.Email# from=#sender_email# subject=My Message To You 2009 #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# /cfmail /cfloop -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
They all have email addresses, I just don't know why it's throwing the validation error on the CFMail 'TO'. I want to send out to about 100 different addresses, is there any issues with that? -Original Message- From: Billy Cox [mailto:bi...@oldworldspices.com] Sent: 2009-01-05 4:07 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error How about amending your query to only return results that have an email address? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 3:01 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). cfinsert datasource=mynamedsn tablename=mytablename formfields=sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType CFQUERY NAME=GetRecipients datasource=mynamedsn SELECT * FROM mytablename /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# /cfmail /cfloop -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. CFQUERY NAME=GetRecipients DATASOURCE=#DataSource# SELECT * FROM Recipients /CFQUERY cfloop query=GetRecipients cfmail to=#GetRecipients.Email# from=#sender_email# subject=My Message To You 2009 #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# /cfmail /cfloop -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
Ok, I'll try. -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: 2009-01-05 4:20 PM To: cf-talk Subject: Re: Personalizing a CFLoop - validation error I know this will sound odd, but put them on separate lines... so this: cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 becomes this: cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 I have always found that with CFMAIL, it likes it better when the arguments are on different lines. HTH Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - cfmail validation error
No still throwing validation error. For the most part the application is now working - if I can only eliminate the error. -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: 2009-01-05 4:20 PM To: cf-talk Subject: Re: Personalizing a CFLoop - validation error I know this will sound odd, but put them on separate lines... so this: cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 becomes this: cfmail to=#GetRecipients.recip_email# from=#form.sender_email# subject=My Message To You 2009 I have always found that with CFMAIL, it likes it better when the arguments are on different lines. HTH Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop - validation error
It's more like a newsletter, except it's not sent out by site owner to all
the members - but from individual that is filling out the form. So have to
personalize apx. one hundred different members on list of 'TO' and end it
personalized in the 'FROM'.
-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com]
Sent: 2009-01-05 4:38 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop - validation error
Agreed. If you are having problems finding the offending record, just
wrap a try around the cfmail and output that record in the catch.
I am slightly confused as to exactly what you are building. At first I
assumed it was something like an E-mail this page to a friend feature
on your site, but now it sounds more like a newsletter feature.
If you know your E-mails are all valid, the cfmail tag actually has a
query attribute for the purpose of sending out an E-mail to everyone in
a resultset.
~Brad
Original Message
Subject: RE: Personalizing a CFLoop - validation error
From: webmas...@pegweb.com
Date: Mon, January 05, 2009 3:27 pm
To: cf-talk cf-talk@houseoffusion.com
The only reason it should give you that error is if there is an empty
email for one of the records. Try dumping out the same query to a
cfoutput to verify.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error- fixed
I separated the Recipients and Senders into two different tables and the validation error resolved. Thanks so much! -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 4:28 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error The only reason it should give you that error is if there is an empty email for one of the records. Try dumping out the same query to a cfoutput to verify. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Extranet App
Looking to purchase a cf extranet application, I've looked at adobe exchange and other cf tagstores but most are so outdated. Does anyone have a recommendation? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Firebird or SQLite
We have a situation that requires an easy to admin database (other than MSSql). Any suggestion on which would be the best combination for db administration and cf development? Using... Firebird / cf Sqlite / cf Maybe something else? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Firebird or SQLite
Do you see any need to put an app like sqlmaestro on top of it to control admin? -Original Message- From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com] Sent: 2008-12-15 5:31 PM To: cf-talk Subject: Re: Firebird or SQLite MySQL has become much easier to work with over the years, especially with the GUI tools available on the MySQL site. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com cfcom wrote: We have a situation that requires an easy to admin database (other than MSSql). Any suggestion on which would be the best combination for db administration and cf development? Using... Firebird / cf Sqlite / cf Maybe something else? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using Coldfusion with Filemaker
I'll take a look at them, thank you Mike -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: 2008-12-10 4:49 PM To: cf-talk Subject: Re: Using Coldfusion with Filemaker The list archives have a good discussion on this topic. -Mike Chabot On Tue, Dec 9, 2008 at 6:10 PM, cfcom cf...@aceligent.com wrote: Does any one have any experience using CF with Filemaker... good, bad, etc Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using Coldfusion with Filemaker
Does any one have any experience using CF with Filemaker... good, bad, etc Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLoop died help
My CFloop died, it used to work but now doesn't and I haven't touched the code. Any help would be greatly appreciated. Thanks !--- insert start --- cfinsert datasource=myname_dsn tablename=mytablename username=xyz password=abc formfields=sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType !--- query get start --- cfquery name=GetHolidays datasource=mydsn_dsn username=xyz password=abc SELECT sender_email, sender_firstname, sender_lastname, sender_address, sender_city, sender_state, sender_zip, sender_date, sender_time, sender_ip, sender_msgType FROM Holidays WHERE sender_email = '#Form.sender_email#' /cfquery !--- query get end --- !--- X MAIL ACTION XX --- cfoutput#DateFormat(Now(), d, )# /cfoutput cfset recipients=[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cfloop list=#recipients# index=recipient cfmail to=#recipient# from=#GetHolidays.sender_email# subject=MySubjectName query=GetHolidays #getholidays.sender_date# Dear Jon, This is my written statement here. Thank you. Yours truly, #GetHolidays.sender_firstname# #GetHolidays.sender_lastname# #GetHolidays.sender_address# #GetHolidays.sender_city#, #GetHolidays.sender_state# #GetHolidays.sender_zip# #GetHolidays.sender_email# /cfmail /cfloop !--- X MAIL ACTION END XX --- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLoop died help
Previously it would loop over the list and send an email to each address in the cfloop. Now I do not receive emails to each address. I'm looking into the host as I think it was on cf7 and now cf8. Any ideas Thanks Steve -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 2008-12-07 9:05 PM To: cf-talk Subject: Re: CFLoop died help My CFloop died, it used to work but now doesn't and I haven't touched the code. Any help would be greatly appreciated. What do you mean by died. What's the error? Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
