Re: Basic user stats via Coldfusion

2009-12-15 Thread Agha Mehdi
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

Consuming Webservice

2009-12-04 Thread Agha Mehdi
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

CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
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? ~|

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
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

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
/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

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
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

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
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.

Re: CFHTTP Connection Failure

2009-11-19 Thread Agha Mehdi
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

MySQL Limit

2009-11-16 Thread Agha Mehdi
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

Re: MySQL Limit

2009-11-16 Thread Agha Mehdi
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

Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi
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

Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi
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

Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi
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

Better manage bulk update process

2009-11-12 Thread Agha Mehdi
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.

Re: Better manage bulk update process

2009-11-12 Thread Agha Mehdi
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

Re: Better manage bulk update process

2009-11-12 Thread Agha Mehdi
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

CF Builder RDS Issue

2009-11-05 Thread Agha Mehdi
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

License Key in DW CS3

2009-11-03 Thread Agha Mehdi
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

Re: License Key in DW CS3

2009-11-03 Thread Agha Mehdi
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

Flex2gateway not accessible

2009-10-22 Thread Agha Mehdi
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

Re: Flex2gateway not accessible

2009-10-22 Thread Agha Mehdi
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

Re: Flex2gateway not accessible

2009-10-22 Thread Agha Mehdi
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

Re: zip code list

2009-10-14 Thread Agha Mehdi
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

Re: cfbugs.adobe.com down?

2009-10-12 Thread Agha Mehdi
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

Re: CF 9 + EC2

2009-10-09 Thread Agha Mehdi
/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

Re: application.cfc for security

2009-10-09 Thread Agha Mehdi
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

CF 9 + EC2

2009-10-08 Thread Agha Mehdi
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

Re: CF 9 + EC2

2009-10-08 Thread Agha Mehdi
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

Re: CF 9 + EC2

2009-10-08 Thread Agha Mehdi
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

Re: GROUP BY problem...

2009-10-02 Thread Agha Mehdi
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,

MySQL Auto Increment Field

2009-09-29 Thread Agha Mehdi
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

Re: MySQL Auto Increment Field

2009-09-29 Thread Agha Mehdi
-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

Re: MySQL Auto Increment Field

2009-09-29 Thread Agha Mehdi
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,

Coldfusion + Cloud

2009-09-16 Thread Agha Mehdi
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

Re: Coldfusion + Cloud

2009-09-16 Thread Agha Mehdi
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

Re: Coldfusion + Cloud

2009-09-16 Thread Agha Mehdi
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

Re: Coldfusion + Cloud

2009-09-16 Thread Agha Mehdi
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

Re: stop cursor typing past 500 characters

2009-09-11 Thread Agha Mehdi
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

Re: Getting UDF's into a custom tag.

2009-09-02 Thread Agha Mehdi
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

Re: Getting UDF's into a custom tag.

2009-09-02 Thread Agha Mehdi
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

Re: ColdFusion + SMS

2009-09-01 Thread Agha Mehdi
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

RDS Connection from Coldfusion Builder

2009-08-26 Thread Agha Mehdi
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 :

Re: Throttling CFMail

2009-08-24 Thread Agha Mehdi
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

Re: Simultaneous Web Service Requests From Same Template

2009-08-21 Thread Agha Mehdi
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

Coldfusion + Flex

2009-08-21 Thread Agha Mehdi
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:

Re: Coldfusion + Flex

2009-08-21 Thread Agha Mehdi
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

Re: Coldfusion + Flex

2009-08-21 Thread Agha Mehdi
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

Re: How do I remove execute permissions from a directory in IIS?

2009-08-20 Thread Agha Mehdi
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

Re: How do I remove execute permissions from a directory in IIS?

2009-08-20 Thread Agha Mehdi
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