Re: Basic user stats via Coldfusion
Ian, We track user activity in the db. this is the best approach I can think of. I'd just keep inserting every hit for every page from onRequestEnd method in Application.cfc. In your case, you can do it in Application.cfm. That will give you a lot of flexibility when creating reports. Currently our UserActivity table holds about 50M records. I have another process running every day, which normalizes the URLs and separate out key-value pairs for faster searching on URL variables example: keywords, page ids etc. Thanks Agha On Tue, Dec 15, 2009 at 1:42 PM, Jason Durham jdur...@cti-stl.com wrote: You could capture the CGI variables on onRequestStart and insert them into the DB onSessionEnd. You will lose data on server restarts for active sessions. -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Tuesday, December 15, 2009 10:54 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a database. Steve -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Tuesday, December 15, 2009 11:47 AM To: cf-talk Subject: RE: Basic user stats via Coldfusion Hi Jason All I am trying to do is track what url's on our Intranet a unique user accesses each day. There could be a couple of hundred pages. The problem with most analytics software is that they do not capture the user's windows logon/network ID so we can identify exactly who is viewing what on the Intranet. Analytic software such as Google just captures a users IP address which is dynamic and changes each day so we can't tell what employees are accessing certain areas of the Intranet. It would be great if Coldfusion could help provide a solution for this ot if anybody knows of any analytical software that would capture this information? -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: 07 December 2009 17:32 To: cf-talk Subject: RE: Basic user stats via Coldfusion Am I properly restating this... You want to track what pages each user hits in a day. How many pages are we talking about? Couple dozen? Couple hundred? Couple thousand? -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Monday, December 07, 2009 11:06 AM To: cf-talk Subject: Basic user stats via Coldfusion On our intranet I have a coldfusion script that captures a user's network/loginid cfset user = listLast(cgi.REMOTE_USER,\) This variable is then run against a user table with the following 'where' clause WHERE uPPER(NETWORK_ID) = '#ucASE(user)#' This then captures user info such as Loginid Name Job Title Department IP address etc How would you restrict the query so it only runs once on each page per day for each user, instead of running every time the page is loaded? And where would this query be better placed, as I don't really want to include it in each page manually. Any ideas would be welcome? ~| 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:329172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Consuming Webservice
Hi Guys, 1. I am trying to consume this webservice http://testservices.hubcast.com/CypressCustomer/OrderAC.svc?wsdl 2. Here is my code: cfset dcc = OCA / cfset hm = 279.4 / cfset hc = 1SS4RQ- / cfset q = ArrayNew(1) / cfset ArrayAppend(q, 100) / cfset ArrayAppend(q, 200) / cfset ArrayAppend(q, 300) / cfset slc = ArrayNew(1) / cfset ArrayAppend(slc, D5) / cfset ArrayAppend(slc, D9) / cfset Wm = 215.9 / cfinvoke webservice= http://testservices.hubcast.com/CypressCustomer/OrderAC.svc?wsdl; method=GetItemQuotes returnvariable=res cfinvokeargument name=DestinationCountryCode value=#dcc# / cfinvokeargument name=HeightInMillimeters value=#hm# / cfinvokeargument name=HubCastSKU value=#hc# / cfinvokeargument name=Quantity value=#q# / cfinvokeargument name=ServiceLevelCode value=#slc# / cfinvokeargument name=WidthInMillimeters value=#wm# / /cfinvoke 3. It throws this Web service operation GetItemQuotes with parameters {DestinationCountryCode={OCA},HubCastSKU={1SS4RQ-},Quantity={[100, 200, 300]},WidthInMillimeters={215.9},HeightInMillimeters={279.4},ServiceLevelCode={[D5, D9]}} cannot be found. What am I doing wrong? ~| 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:328880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHTTP Connection Failure
I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. On Thu, Nov 19, 2009 at 11:53 AM, Mark Kruger mkru...@cfwebtools.comwrote: Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.com wrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| 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:328546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Connection Failure
Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file On Thu, Nov 19, 2009 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. Are you sure the intermediate certs are also there? I ran into just this problem with a client yesterday - they'd installed the site cert, but not the intermediate certs, and couldn't connect. 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! ~| 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:328551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Connection Failure
I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? On Thu, Nov 19, 2009 at 3:27 PM, Dave Watts dwa...@figleaf.com wrote: Hmmm. not sure what the intermediate cert is. Shouldn't it also affect the one server that can connect? All four of them have the exact same config and cacerts file All the servers would presumably require the intermediate certs. Are you absolutely sure they all have the exact same list of certificates in their keystores? 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! ~| 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:328554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Connection Failure
Works fine accessing the service from the browser on all 4 servers. I even have small .net app on the servers, which connects just fine to this webservice. On Thu, Nov 19, 2009 at 4:19 PM, Dave Watts dwa...@figleaf.com wrote: I used Keytool to inspect the cacerts from two servers and randomly checked lines and they all match. I can go back and check it again but why would 3 out of 4 work before 4:00 PM yesterday and keep failing since? I don't know. What happens if you attempt to browse those HTTPS URLs from the server console (if you can possibly do that?) 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! ~| 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:328560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MySQL Limit
I have three tables tableA Rresources (resourceID) tableB Attributes (attributeID, attributeName) tableC ResourcesAttributesValues (ravID, resourceID, attributeID, value) I need to apply MySQL Limit clause to get paginated dataset from row 1 - 100/101-200/201-300 I'd like to run a single query to get 1-100... resources with all of their attributes and values. What is the most efficient way to do it? 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:328447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Limit
Awesome. thanks On Mon, Nov 16, 2009 at 4:56 PM, Barney Boisvert bboisv...@gmail.comwrote: select r.*, v.* from (select resourceId from resources limit 100) r inner join resourcesattributesvalues v on r.resourceId = v.resourceId cheers, barneyb On Mon, Nov 16, 2009 at 4:49 PM, Agha Mehdi aghaime...@gmail.com wrote: I have three tables tableA Rresources (resourceID) tableB Attributes (attributeID, attributeName) tableC ResourcesAttributesValues (ravID, resourceID, attributeID, value) I need to apply MySQL Limit clause to get paginated dataset from row 1 - 100/101-200/201-300 I'd like to run a single query to get 1-100... resources with all of their attributes and values. What is the most efficient way to do it? 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:328449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better manage bulk update process
there are other tasks that run at the same time too but none that would interact with the same tables. One thing I did notice though that there is only one task that runs at 8:00 PM (which is this one) and there are 4 different tasks that run at 8:00 AM (including this task). Could that be an issue? On Thu, Nov 12, 2009 at 6:25 PM, Maureen mamamaur...@gmail.com wrote: Is there any chance the morning run is conflicting with another task, like a backup, or another import, and just stalling? On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi aghaime...@gmail.com wrote: Yup. that's what I am doing now. CFTransaction is an option but it won't do me any good if for some reason the processing just stops without any error. It is strange but that's what's happening. I haven't found any errors in the logs. Also, it gets more interesting as the task runs every 12 hours. the one that runs in the evening is fine and the one running in the morning has started to not run after deleting records from two tables. I am also going to start writing each row's insert/update success to a log file to see exactly what's going on. ~| 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:328349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better manage bulk update process
I also just thought of something. I am using the following setting; Frequency: Daily every 12 hours start time: 11:00 PM. Do I need to specify End time too? On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com wrote: there are other tasks that run at the same time too but none that would interact with the same tables. One thing I did notice though that there is only one task that runs at 8:00 PM (which is this one) and there are 4 different tasks that run at 8:00 AM (including this task). Could that be an issue? On Thu, Nov 12, 2009 at 6:25 PM, Maureen mamamaur...@gmail.com wrote: Is there any chance the morning run is conflicting with another task, like a backup, or another import, and just stalling? On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi aghaime...@gmail.com wrote: Yup. that's what I am doing now. CFTransaction is an option but it won't do me any good if for some reason the processing just stops without any error. It is strange but that's what's happening. I haven't found any errors in the logs. Also, it gets more interesting as the task runs every 12 hours. the one that runs in the evening is fine and the one running in the morning has started to not run after deleting records from two tables. I am also going to start writing each row's insert/update success to a log file to see exactly what's going on. ~| 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:328353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better manage bulk update process
nope, the other tasks don't do anything to those tables. so here's what I did. wrapped cftransaction around the process. created two staging tables that hold the process updates. once the process finishes, i call a stored proc, which deletes old data from prod tables, copy data from staging to prod tables and truncates staging tables. This is working without crashing and the web site doesn't lose any data while the import job is running. thanks everyone for pitching in. that's why i love this list and rejoined after 3 years of absence. :) On Fri, Nov 13, 2009 at 4:18 PM, Maureen mamamaur...@gmail.com wrote: Do any of the other tasks use the tables you are deleting or updating? On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com wrote: there are other tasks that run at the same time too but none that would interact with the same tables. One thing I did notice though that there is only one task that runs at 8:00 PM (which is this one) and there are 4 different tasks that run at 8:00 AM (including this task). Could that be an issue? ~| 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:328387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Better manage bulk update process
All, I have a bulk update process for our products catalog. It needs to delete old data before it loads new data. Sometimes it fails to load new data after deleting old data, which causes product catalog to be empty. I don't have CFTransaction wrapped around it but I want to put it in place. What is the recommended method to do it? 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:328307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better manage bulk update process
Tell me about it. I would take that approach if it was an option. It has to be done through cf on a live production db before tomorrow morning. On Thu, Nov 12, 2009 at 1:02 PM, Alan Rother alan.rot...@gmail.com wrote: Well... There are a number of techniques for ensuring data integrity. In cases where I'm using CF to manage a bulk import (rather than the database itself) I tend to use a staging database to import the data and then I only transfer it to the production database IF the import passes some sort of checksum test. Then I manage the data transfer from the staging database to the production database using a DTS package(MS SQL) rather than using CF as database specific data migration tools tend to work far more quickly and a far more reliable. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:328322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Better manage bulk update process
Yup. that's what I am doing now. CFTransaction is an option but it won't do me any good if for some reason the processing just stops without any error. It is strange but that's what's happening. I haven't found any errors in the logs. Also, it gets more interesting as the task runs every 12 hours. the one that runs in the evening is fine and the one running in the morning has started to not run after deleting records from two tables. I am also going to start writing each row's insert/update success to a log file to see exactly what's going on. On Thu, Nov 12, 2009 at 4:01 PM, Alan Rother alan.rot...@gmail.com wrote: Hmm... Ok, any chance you could create Temp tables that match the production ones? Run your import on them, then once complete, table by table TRUNCATE the prod data and then transfer the new data over to the real tables? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:328339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Builder RDS Issue
All, I installed CF builder as a plugin for Flash builder 4 beta. I can create connection to me webserver but can't connect to RDS. it gives me Unable to contact the RDS Server localhost Error executing RDS command. Status code: 404, Reason : Not Found Any ideas? Thanks Agha ~| 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:328076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
License Key in DW CS3
Where is it stored in DW? Can't find it. need to reinstall it because it's crashing every time I try to select something ~| 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:327976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: License Key in DW CS3
Worked like a charm. Thanks a lot Casey. On Tue, Nov 3, 2009 at 4:54 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Tue, Nov 3, 2009 at 7:49 PM, Agha Mehdi aghaime...@gmail.com wrote: Where is it stored in DW? Can't find it. need to reinstall it because it's crashing every time I try to select something This may help, I know it has for me in the past. Corrupted file cache Dreamweaver creates a cache file called WinFileCache-.dat or MacFileCache-.dat inside your personal Dreamweaver configuration folder (the asterisks represent a series of letters and numbers that might differ from computer to computer). This occasionally gets corrupted causing instability, unpredictable error messages, and even crashes. To solve the problem, close Dreamweaver and delete WinFileCache-.dat or MacFileCache-.dat. Sometimes, deleting this file is not sufficient, and you need to delete your personal configuration folder in its entirety. *WARNING:* Do not confuse your personal configuration folder with the main configuration folder in Program Files in Windows or Applications on a Mac. You should never touch the main configuration folder unless you really know what you're doing. Locating your personal configuration folder The location of the personal configuration folder depends on your operating system and version of Dreamweaver. For Dreamweaver CS4, its as follows: - Vista: C:\Users\username\AppData\Roaming\Adobe\Dreamweaver CS4\language\Configuration - Windows XP: C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver CS4\language\Configuration - Mac OS X: Macintosh HD:username:Library:Application Support:Adobe:Dreamweaver CS4:language:Configuration In all cases, username is the name of your user account on the computer and language indicates the language of your operating system. The language is usually represented by two pairs of characters separated by an underscore, as in en_US (English), es_ES (Spanish), or fr_FR (French). Earlier versions of Dreamweaver locate the personal configuration folder in a slightly different location. This is where it can be found in Dreamweaver CS3: - Vista: C:\Users\username\AppData\Roaming\Adobe\Dreamweaver 9\Configuration - Windows XP: C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver 9\Configuration - Mac OS X: Macintosh HD:Users:username:Library:Application Support:Adobe:Dreamweaver 9:Configuration The Dreamweaver configuration folders are hidden on Windows, so you need to enable the option to view hidden files and folders in order to locate them, as follows: - In Vista, select Start Computer Organize Folder and Search Options View. In Advanced settings, choose Show hidden files and folders. - In Windows XP, select Start My Computer Tools Folder Options View. In Advanced settings, choose Show hidden files and folders. Once you turn on this option, hidden folders are displayed as dimmed icons to remind you to treat them with care. ~| 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:327978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flex2gateway not accessible
All, http://[servername]/flex2gateway comes back with error 404. My setup is Coldfusion on JRun integrated with IIS. have tried a bunch of suggestions from the web but nothing seems to be working. Please help 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:327542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex2gateway not accessible
- added JRunScripts virtual directory under IIS pointed to C:\JRun4\lib\wsconfig\2. - created a folder (flex2gateway) below the web root. Didn't think it would work. I could not find the connectors .bat files under JRun so not sure how to do that Thanks On Thu, Oct 22, 2009 at 3:08 PM, b...@bradwood.com wrote: If you wouldn't mind, could you tell us what you've tried so far. I've had luck in the past by running ColdFusion8\bin\connectors\Remove_ALL_connectors.bat and then ColdFusion8\bin\connectors\IIS_connector.bat ~Brad Original Message Subject: Flex2gateway not accessible From: Agha Mehdi aghaime...@gmail.com Date: Thu, October 22, 2009 5:01 pm To: cf-talk cf-talk@houseoffusion.com All, http://[servername]/flex2gateway comes back with error 404. My setup is Coldfusion on JRun integrated with IIS. have tried a bunch of suggestions from the web but nothing seems to be working. ~| 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:327549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex2gateway not accessible
recreating the connector using wsconfig did it. Thanks a bunch. Still don't know why you have to recreate it but it's one of those things where you don't complain when it starts to work :) Thanks again. On Thu, Oct 22, 2009 at 4:33 PM, b...@bradwood.com wrote: added JRunScripts virtual directory under IIS pointed to C:\JRun4\lib\wsconfig\2. I'm not sure what that would do. Where did you get that one from? created a folder (flex2gateway) below the web root. Didn't think it would work. You certainly don't want to do that. There is no folder called flex2gateway, but if you look in your web.xml there should be a servlet mapping for /flex2gateway/* that maps to the MessageBrokerServlet servlet. I could not find the connectors .bat files under JRun so not sure how to do that Hmm, I don't a multi-server install in front of me right now to look at. You could try using the Web Server Configuration Tool to manually remove and add your web server connectors. I don't know if it will work, but it's worth a try. ~Brad ~| 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:327558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: zip code list
it's because you can't send attachments to the list. Josh, you can send him directly On Wed, Oct 14, 2009 at 10:26 AM, Timothy Laureska tlaure...@dhmh.state.md.us wrote: Josh many thanks - but nothing was attached Joshua Rowe jr...@varimereweb.com 10/14/2009 1:18 PM Hello, Attached is a CSV file containing a zip code list. Contains zip code, city, state, state abbr, latitude, and longitude. It's a couple years old and I found it for free off the internet somewhere, so any cities added between now and the time it was created will not be included. Best regards, Joshua Rowe -Original Message- From: Timothy Laureska [mailto:tlaure...@dhmh.state.md.us] Sent: Wednesday, October 14, 2009 10:12 AM To: cf-talk Subject: zip code list Hello: Anybody know of a quick easy place to get a csv or other delimited file (or database) of zip codes by state? And yes, for free :-) ~| 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:327209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfbugs.adobe.com down?
nice. no password encryption, no cfqueryparam, no trimming. Well, at least they have enabled=1 filter instead of notEnabled=0. That would be totally hilarious. [WHERE notEnabled = 0] On Mon, Oct 12, 2009 at 2:04 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Mon, Oct 12, 2009 at 4:22 PM, b...@bradwood.com wrote: When I try to log ingo http://cfbugs.adobe.com/ I'm getting this ugly CF error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'betasite'. Login fails. LOL, even better * The error occurred in E:\WebRoot\mmbeta\mmBetaSite\betasite\login.cfm: line 96 94 : WHERE enabled = 1 AND 95 : email = '#form.email#' AND 96 : password = '#form.password#' 97 : /cfquery* Way to go Adobe Website Developer Team! ~| 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:327106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 9 + EC2
yup. Saw another article yesterday along the same lines. Alagad got some serious attention. It will be nice once it is released. On Fri, Oct 9, 2009 at 9:06 AM, b...@bradwood.com wrote: Here's some random info about CF9+EC2 that come down the wire this morning. http://www.alagad.com/blog/post.cfm/alagad-adobe-coldfusion-cf-ec2 ~Brad Original Message Subject: Re: CF 9 + EC2 From: Agha Mehdi aghaime...@gmail.com Date: Fri, October 09, 2009 12:19 am To: cf-talk cf-talk@houseoffusion.com Don't have a clue how they should've been ready with the AMI before the product got interpreted as should've delayed CF 9 launch and waited for the AMI. May be, it's because English is my 2nd language :) Apologies for that. Not in any hurry to run anything in the cloud so, I will wait for the official Adobe AMI. That will mean less work on my part. Cheers Agha On Oct 8, 2009, at 7:56 PM, Brian Kotek brian...@gmail.com wrote: Sure, it would have been much smarter to make the vast majority of the user base wait until the AMI deployment was fully tested, rather than let the them use the new version now. By the way, it might be obvious, but you can actually deploy a CF instance onto EC2 right now. You don't have to wait for some official Adobe AMI to do this. On Thu, Oct 8, 2009 at 1:20 PM, Agha Mehdi aghaime...@gmail.com wrote: hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. 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 On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| 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:327070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: application.cfc for security
first of all, users should not be able to upload files below the web root. that is a dangerous thing to offer to them. What are you defining as right credentials? If a user can create directories and upload files using some ftp client then there are a number of things you can do to make sure each user gets his own area for file management and restrict access to other files. Can you elaborate your process? On Fri, Oct 9, 2009 at 11:33 AM, Robert Harrison rob...@austin-williams.com wrote: I have a situation where is a user is creating subdirectories in a directory that I know. He's also uploading files via FTP. I know the name of the root directory, but don't necessarily know the name of the subdirectories and files. Is there any way I can put an application.cfc in the root directory so it would do a redirect on anyone who does not have the right credentials (e.g., a session variable)? I know I can make it work on all the .cfm files in the subs... but is there a way I can I make it work for all files? Thanks 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 4494 (20091009) __ The message was checked by ESET Smart Security. http://www.eset.com ~| 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:327076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 9 + EC2
So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| 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:327038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 9 + EC2
hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. 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 On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| 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:327040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 9 + EC2
Don't have a clue how they should've been ready with the AMI before the product got interpreted as should've delayed CF 9 launch and waited for the AMI. May be, it's because English is my 2nd language :) Apologies for that. Not in any hurry to run anything in the cloud so, I will wait for the official Adobe AMI. That will mean less work on my part. Cheers Agha On Oct 8, 2009, at 7:56 PM, Brian Kotek brian...@gmail.com wrote: Sure, it would have been much smarter to make the vast majority of the user base wait until the AMI deployment was fully tested, rather than let the them use the new version now. By the way, it might be obvious, but you can actually deploy a CF instance onto EC2 right now. You don't have to wait for some official Adobe AMI to do this. On Thu, Oct 8, 2009 at 1:20 PM, Agha Mehdi aghaime...@gmail.com wrote: hmmm. that sucks. they should've been ready with the AMI before the product launch. On Thu, Oct 8, 2009 at 9:38 AM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: My understanding, from the MAX info, is that the EC2 implementation is still in private beta. 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 On 10/8/2009 11:33 AM, Agha Mehdi wrote: So now that the new version is out, what are the steps to set it up in EC2 (Amazon)? Anyone on this list working on it? ~| 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:327061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY problem...
Why not just cfoutput query= group=name b#name#/bbr cfoutput #area_name#, #office_name#br /cfoutput /cfoutput On Fri, Oct 2, 2009 at 9:09 AM, Les Mizzell lesm...@bellsouth.net wrote: SELECT employees.empID employees.name, employees_office.theORDER office.office_name areas.area_NAME FROM employees INNER JOIN employees_office ON employees.empID = employees_office.empID INNER JOIN office ON employees_office.id_office = dbo.office.office_id INNER JOIN areas ON areas.empID = employees_office.empID ORDER BY employees.name, employees_office.theORDER OK, here's the problem I need to be able to GROUP BY employees.empID so each employee is returned only ONCE (a unique empID), but, I can't include any of the columns in the other tables in the GROUP BY, because there may be multiple records from those tables. An employee may exist in more than one city and may also be assigned to many areas. So, get the employee only ONCE, but return multiples from the other joined tables. Obviously using just GROUP BY empID get us the columns not included in aggregrate error. I'm not sure how to fix this. I'd like to do it one query, not multipe queries... Advice? ~| 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:326840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL Auto Increment Field
All, How do I get the ID value back in CF from MySQL after doing an insert with auto_inc data type in the table? Thanks for help Agha ~| 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:326747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Auto Increment Field
Thanks Azadi and Barney. Which approach is better in performance? I'm assuming result.generated_key? Thanks again for help Agha On Sep 29, 2009, at 12:20 PM, Barney Boisvert bboisv...@gmail.com wrote: select last_insert_id() as id http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id cheers, barneyb On Tue, Sep 29, 2009 at 12:16 PM, Agha Mehdi aghaime...@gmail.com wrote: All, How do I get the ID value back in CF from MySQL after doing an insert with auto_inc data type in the table? Thanks for help Agha ~| 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:326751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Auto Increment Field
Thank you all for the great inputs. On Tue, Sep 29, 2009 at 1:48 PM, Judah McAuley ju...@wiredotter.com wrote: I had to go and make that very same change a couple years ago, so I can totally understand missing that. Glad to be of help. Cheers, Judah On Tue, Sep 29, 2009 at 1:29 PM, Robert Harrison rob...@austin-williams.com wrote: Man. Now I'm glad I posted that. Just went through and changed all: SELECT @@Identity AS newId To SELECT SCOPE_IDENTITY() AS newId Looks like it worked. I've been using that statement for six or seven years. Never failed, but I could see where if it did I'd have had no idea what happened. Thanks for clearing that up. 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 4468 (20090929) __ The message was checked by ESET Smart Security. http://www.eset.com ~| 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:326764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion + Cloud
All, Where can I find comprehensive setup guidelines for CF on cloud including setting up dsn for mysql in windows environment. Thanks Agha ~| 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:326355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion + Cloud
Apologies for being vague.:) It's for Amazon EC2 and S3. Not sure about the front-ends. On Wed, Sep 16, 2009 at 9:32 AM, Dave Watts dwa...@figleaf.com wrote: Where can I find comprehensive setup guidelines for CF on cloud including setting up dsn for mysql in windows environment. There is not enough information in that question to provide an answer. What cloud vendor? Amazon? One of the myriad front-ends to Amazon, like Stax? Your own virtualization environment? 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! ~| 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:326359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + Cloud
CF enterprise will run on 10 conc. cloud instances (see attached). I am not so much worried about CF licensing at this point. I need to start playing with cf+Flex+db config in cloud. I have created Stax account and it looks promising. Not sure how mature that service is. Anybody knows if there is a Stax plugin for eclipse to use for Stax SDK? On Wed, Sep 16, 2009 at 11:30 AM, b...@bradwood.com wrote: I know Adobe is planning for cloud licensing in the CF9 licensing. You would probably be ok if you owned a license for each image being used at concurrently, but don't quote me on that. I think think I heard Sean Corfield say once that Adobe had made special exceptions on a a client-by-client basis for the time being. Why don't you call up your friendly neighborhood Adobe rep and ask! :) ~Brad Original Message Subject: RE: Coldfusion + Cloud From: Mark Kruger mkru...@cfwebtools.com Date: Wed, September 16, 2009 12:51 pm To: cf-talk cf-talk@houseoffusion.com If you are using EC2 you might find a saved instance with CF (trial) pre installed (I know there is one for Blue Dragon/MySQL/CentOS for example). Spool up the instance amd use it - keep in mind that the CF license agreements are probably violated by production cloud usage (not sure on this point ... Someone help me out). The learning curve here is not CF, it is EC2. ~| 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:326366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + Cloud
Sorry. Didn't realize. CF Ent. will be for 10 conc. cloud instances and CF standard will be for one. CF 9 will also have its AMI. On Wed, Sep 16, 2009 at 1:09 PM, Ian Skinner h...@ilsweb.com wrote: Agha Mehdi wrote: CF enterprise will run on 10 conc. cloud instances (see attached). We can't House of Fusion does not allow attachments. ~| 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:326377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
Use maxlength=500 for the input field Agha On Sep 11, 2009, at 6:28 AM, Damo Drumm damien.dr...@quinn-group.com wrote: Hi Iâve a text box on my form, and in the database it is set to allow 5 00 characters to be entered, however i can write any amount of chara cters above 500, I do get an error sayng: Error Executing Database Q uery. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. But the email still sends anyway, what im trying to do is get rid of the error message altogether, so is there a way I can stop the cursor from typing past 500 characters? 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:326220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting UDF's into a custom tag.
Ideal is to put them in a cfc and pass the object in Agha On Sep 2, 2009, at 2:20 PM, Gerald Guido gerald.gu...@gmail.com wrote: I have a custom tag to display my views, basically an encapsulated cfinclude, and I have a cfm that holds a set of common utility functions (I am debating whether or not to put them into a CFC). What would be the best way(s) to make the UDF's available in side the custom tags? Put them in a struct and pass them in as a variable? Put them in the application or the request scope? Any thoughts on the matter? As always, many TIA. G? -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:325958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting UDF's into a custom tag.
The only issue I have with having it in global scope and just using it in the tag is that it does not look cleaner to me. You will have other attributes passed into the tag and one var of UDFs with global scope (app/request) will be directly referred to in the tag. I can't think of a reason why it would bite in buttocks. I guess, it's a matter of preference. On Wed, Sep 2, 2009 at 4:41 PM, Rick Root rick.r...@webworksllc.com wrote: To be honest, I tend to put utility functions into a component called udf.cfc and then load that component into a shared scope (application or server) on initialization. That way they're always there in memory. I don't like the idea of passing functions into a custom tag though it would certainly follow the rules of encapsulation a bit more, either way seems like a violation to me, really. But then, I don't think I've used a custom tag in ages either. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm ~| 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:325966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion + SMS
You can send through GSM modem if going through SMS aggregator is not an option. you can send around 30 messages/minute On Tue, Sep 1, 2009 at 4:33 AM, Arsalan Tariq Keen arsalk...@hotmail.comwrote: Hello Guys, Can anyone tell me in detail what parameters I need to know from my GSM Operator for sending SMS using ColdFusion? I want to send actual SMS not the test machine that comes along Adobe CF8 Regards, Arsalan ~| 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:325902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RDS Connection from Coldfusion Builder
I can't connect to RDS on my localhost using CF Builder. seeing this error in the console [Test], (08/26 at 04:39:51): , Unable to connect to server. Using cached server settings [Test], Error, 08/26 at 04:40:18, Unable to fetch server mappings. Reason :Error executing RDS command. Status Code : 404 , Reason : Not Found [Test], Error, 08/26 at 04:40:18, Unable to get the log directory. Reason:Error executing RDS command. Status Code : 404 , Reason : Not Found [Test], Error, 08/26 at 04:40:18, Unable to retrive DataSource Any ideas? Thanks Agha ~| 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:325756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Throttling CFMail
Pete, An old discussion on CFTalk that may still be valid http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:47090 http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:47090 On Mon, Aug 24, 2009 at 2:07 PM, b...@bradwood.com wrote: I believe you will need to account for that throttling in your code. Once your CFMAIL tag as run, the CF server will sent your messages as soon as the mail spooler runs next. I suggest a queue table of your own that you dump ALL the E-mails into and a job that polls that table and sends out x number of mails per minute. Or, an even better solution would be to set up your own SMTP server or pay to use one that will allow for your load. ISP's tend to get very cranky if they think you are a spammer since that tends to get them blacklisted and they don't want that. ~Brad Original Message Subject: Throttling CFMail From: Pete Ruckelshaus pruckelsh...@gmail.com Date: Mon, August 24, 2009 3:58 pm To: cf-talk cf-talk@houseoffusion.com I got dinged by my ISP for sending 2,000 email newsletters at once. Any ideas on how to throttle these emails so that they are sent in small batches, i.e. 100 per minute? Is there a simple way to accomplish this, or do I just need to write my own code that loops through and sends emails incrementally? Thanks. Pete ~| 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:325641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simultaneous Web Service Requests From Same Template
I'd first try to call a WS method that returns all the rooms inventory (if one exists). Also, it might be better to schedule the inventory check. that will depend on how frequently the inventory changes and how important it is to show real time inventory. I'd even run the schedule task every 2-3 minutes and grab all the inventory and store it in my db. that way, your site visitors won't have to wait 15+ sec (which is a lot in web world) On Fri, Aug 21, 2009 at 7:34 AM, Rick Root rick.r...@webworksllc.comwrote: On Fri, Aug 21, 2009 at 10:13 AM, Jason Neidertja...@steelfusion.com wrote: Total execution time can be around 15+ seconds for the page to retrieve inventory for all rooms before displaying available ones. Thoughts?? Sounds like it might be a job for CFTHREAD Then the request can run all web services requests simultaneously then join back together after all 7 have completed. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm ~| 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:325587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion + Flex
What is the most common and best IDE people are using for Coldfusion and Flex combined? ~| 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:325588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion + Flex
I have to pay for FB and than run it as a plugin for Eclipse. I don't like that approach. I'd rather use FB if I pay for it. Especially when CFBuilder is coming out and though, I haven't looked at the Beta but I'm hoping that it would be good enough for Flex. On Fri, Aug 21, 2009 at 9:29 AM, Jake Churchill j...@cfwebtools.com wrote: You can use Eclipse with a CFEclipse and FlexBuilder plugins. Personally I use Flexbuilder standalone for Flex and CFEclipse separately. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Friday, August 21, 2009 11:22 AM To: cf-talk Subject: Coldfusion + Flex What is the most common and best IDE people are using for Coldfusion and Flex combined? ~| 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:325592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion + Flex
Thank you all for great feedback. I went ahead and installed Flash Builder Beta and CF Builder Plugin for it. Things look good. I used Flex Builder 3 years ago so, wasn't sure what smart people were using in the new world. I prefer single IDE for all different platforms. Seems like this will do it. Now I need to figure out how to load Cairngorm Framework onto it. I am sure a lot has changed in that framework too. Im gonna have to go back to school. :) Thanks again On Fri, Aug 21, 2009 at 11:12 AM, Mike Chabot mcha...@gmail.com wrote: I have used both Flex Builder standalone and the Flex Builder Eclipse plug-in for substantial periods of time. The stand-alone Flex Builder is easier to use, unless you are already an experienced user of Eclipse. The reason it is easier to use is that a typical Eclipse install has all this extra stuff unrelated to Flex, and the menu choices aren't as specific to Flex work. If you are learning the technology, the books and videos are going to show you how to do things in Flex Builder. Also, unless you clean up your Eclipse install to remove all the unnecessary plug-ins, it is going to be slower. The best combination is personal preference. I prefer HomeSite over Eclipse when editing CF code (not considering ColdFusion Builder). HomeSite is light-weight, simple to use, quick to load, doesn't use a lot of computer resources, and does one thing very well. Once ColdFusion Builder is released, the question of the best IDE will hopefully be answered definitively. There are IDEs for Flex other than what Adobe provides. One person I know who does full-time Flex and Flash work insists that FDT is a much better IDE. http://fdt.powerflasher.de/ There are other IDEs as well, some of which interface with the free Flex SDK, allowing you to program in Flex for free. I heard (possibly from Terrence Ryan) that if you install both Flash/Flex Builder and ColdFusion Builder, that you should install Flash/Flex Builder first. Whatever issues led to this recommendation might be fixed by the time CF Builder is released for sale. If you are installing these programs for the first time, I recommend using Flex Builder stand-alone and the ColdFusion Builder beta version. -Mike Chabot On Fri, Aug 21, 2009 at 12:47 PM, Tom McNeertmcn...@gmail.com wrote: As Andy says, no matter how you install it, if you run FlexBuilder, it's running as a plugin for Eclipse. The same is true for CFBuilder. It's just another Eclipse plug-in, no matter how you install it. So to handle both CF and Flex, you need some combination of Eclipse plug-ins, either FB and CFB, or FB and CFEclipse. No way around it. If you have FlexBuilder, even installed as a standalone, you can just add CFEclipse as a plugin. That's simple enough, and that's how I have things running on one of my machines. Although there's obviously been no official word, I have received strong suggestions that there will be some sort of Flex Builder 4/CF Builder combo pricing. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| 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:325597 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 do I remove execute permissions from a directory in IIS?
You can add application.cfm or Application.cfc to the folder and cfabort any request. that will ensure that no cfm file is executed On Thu, Aug 20, 2009 at 11:21 AM, Philip Kaplan pkap...@gmail.com wrote: I'm allowing people to FTP-upload into one of my web server directories, but I don't want them to be able to upload and run cfm (or asp, etc) scripts. I right-clicked on the directory in IIS and changed execute permissions to none, but it seems the cfm files in that directory are still running. Here's an example: http://hitmelater.com/affiliate/index.cfm Any ideas? ~| 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:325569 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 do I remove execute permissions from a directory in IIS?
There are multiple ways you can do it depending on your setup. 1. Have your ftp folder below the web root 2. Add cfabort to a directory above the ftp folder in the web root so that it stops any processing on any sub folders. 3. uncheck all options (Read, Write etc) under Directory for that folder and set the execute permission to None On Thu, Aug 20, 2009 at 11:47 AM, Philip Kaplan pkap...@gmail.com wrote: That's a clever idea but I would preferably like to give users delete permission on that directory, in which case someone could just delete the application.cfm file. On Thu, Aug 20, 2009 at 11:40 AM, Agha Mehdi aghaime...@gmail.com wrote: You can add application.cfm or Application.cfc to the folder and cfabort any request. that will ensure that no cfm file is executed On Thu, Aug 20, 2009 at 11:21 AM, Philip Kaplan pkap...@gmail.com wrote: I'm allowing people to FTP-upload into one of my web server directories, but I don't want them to be able to upload and run cfm (or asp, etc) scripts. I right-clicked on the directory in IIS and changed execute permissions to none, but it seems the cfm files in that directory are still running. Here's an example: http://hitmelater.com/affiliate/index.cfm Any ideas? ~| 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:325574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4