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 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

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 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

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?


~|
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

2009-11-19 Thread Agha Mehdi

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

2009-11-19 Thread Agha Mehdi

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

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 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

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. 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

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 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

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 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

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 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

2009-11-13 Thread Agha Mehdi

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

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 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

2009-11-13 Thread Agha Mehdi

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

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. 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

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 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

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 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

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


~|
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

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 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

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 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, it’s 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

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 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

2009-10-22 Thread Agha Mehdi

   - 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

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 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

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 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?

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 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

2009-10-09 Thread Agha Mehdi

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

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 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

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 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

2009-10-08 Thread Agha Mehdi

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

2009-10-08 Thread Agha Mehdi

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...

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,
  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

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 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

2009-09-29 Thread Agha Mehdi

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

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, 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

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 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

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 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

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 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

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 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

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 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.

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 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.

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 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

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
 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

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 : 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

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 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

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
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

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: 
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

2009-08-21 Thread Agha Mehdi

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

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 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?

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 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?

2009-08-20 Thread Agha Mehdi

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