RE: Database Lookup - Possible with CF?

2011-03-10 Thread Ian Vaughan
Hi Steve So my CFC would be like this? cfcomponent displayname=Employee hint=ColdFusion Component for getting Employee ID !--- This function retrieves employee info from the database --- cffunction name=retrieveEmployees hint=Gets employee info from the database returntype=query cfquery

(ot) lamp-system analyzer

2011-03-10 Thread cf-talk
Hi list, I know this is off topic, but is s.o. here who knows of a tool similar to fusion-reactor but for LAMP-servers ? Uwe ~| Order the Adobe Coldfusion Anthology now!

ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi All, I have a short turn around on this so hopefully someone can help. I have searched the Adobe website, but I didn't find the appropriate documents. As I understand it if you purchase ColdFusion Enterprise edition, you get to use it on 2 machines (Production, Development/Hot Spare),

Re: ColdFusion License and Builder

2011-03-10 Thread Russ Michaels
Steve, there was a special promotion to get a cfbuilder and flash builder with each purchase, I do not know if that promotion is still active, if you cannot find it on the Adobe site then I guess not. All editions of CF can be used for development completely FREE, they simply have an IP address

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. I thought that Adam had put both of the items out on this list, but I was looking for the

Re: To Fusionreactor or not to Fusionreactor

2011-03-10 Thread Steve 'Cutter' Blades
Bobby, This post will give you some insight on the environment, and it's challenges: http://blog.cutterscrossing.com/index.cfm/2008/6/22/Build-Applications-That-Scale As for settings and production...We didn't really run into any showstoppers. We pushed it to give us a lot of info (AMF

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I found the EULA for ColdFusion. Here are the appropriate sections: 3.1.3 If Licensee purchases one or more Production Software licenses, then Adobe also grants Licensee the right to install and use the Software as Development Software for internal development, testing and staging. 3.2

RE: ColdFusion License and Builder

2011-03-10 Thread Jason Fisher
Dev and Hot Spare are 2 different things. You can always install full Enterprise on any server in Dev mode for free, and that has a 2 IP limit. Hot spare is a licensing change (came in 8.0.1, iirc) that allows a 'dark' server to have a full installation re-using your production license, but

Re: ColdFusion License and Builder

2011-03-10 Thread Ian Skinner
On 3/10/2011 6:47 AM, DURETTE, STEVEN J (ATTASIAIT) wrote: I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. Yes, the EULA for CF9 has

Re: Database Lookup - Possible with CF?

2011-03-10 Thread Dean Lawrence
Ian, I think your a little confused about a couple of things. First off, AJAX really has no direct relationship with ColdFusion. AJAX runs on the client side and ColdFusion runs on the server side. AJAX simply allows your browser to make additional HTTP requests via JavaScript instead of having

How to pass a file to a web service.

2011-03-10 Thread Ian Skinner
What would be the web service equivalent of this HTTP request? wsTest.cfm |cfhttp url=https://secure-devsite/pur-loader/ws/ppur_v0.cfc; method=post multipart=yes cfhttpparam name=authentication value= type=formfield cfhttpparam name=ppurfile

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I found what I needed for the development server info in the EULA. Thanks though. I also found the info about CF Builder with ColdFusion. You had to purchase before Jan 1, 2011. If we had we would have gotten 3 complimentary copies with every purchase of CF 9 Enterprise.

Re: How to pass a file to a web service.

2011-03-10 Thread Dean Lawrence
Ian, you would need to convert the uploaded file to base64 before submitting it to the web service. This essentially will transfer the file as text. Once the web service has it, you would then convert it back to it's original binary format. Ben Nadel has an article describing this process.

Re: How to pass a file to a web service.

2011-03-10 Thread Ian Skinner
On 3/10/2011 8:05 AM, Dean Lawrence wrote: Ian, you would need to convert the uploaded file to base64 before submitting it to the web service. This essentially will transfer the file as text. What would be the result of converting a text file to base64? I'm not dealing with a binary file

Serving Content based on Geolocation of IP address

2011-03-10 Thread Michael Grant
One of our multi-national clients wants content specific to the location of the end user. Pretty straightforward stuff, but something we haven't done before. Does anyone have any recommendations of products or services they've had good experiences with?

Re: How to pass a file to a web service.

2011-03-10 Thread Dean Lawrence
If it is a file, then yes it is binary. The contents may be ASCII text, but the file itself is binary. When you convert the file to base64, you are converting it into a text string. This you can pass to the web service. The web service would then read the string, convert it back binary and use

Re: Serving Content based on Geolocation of IP address

2011-03-10 Thread Brian Cain
I use a product called ip2location. They have a dll that will return a country code based on ip. Usually work pretty well. It cost around $100/yr. I have mine setup as a com object under windows. Seems to be pretty low overhead. Sent from my iPhone On Mar 10, 2011, at 10:40 AM, Michael Grant

RE: To Fusionreactor or not to Fusionreactor

2011-03-10 Thread Bobby Hartsfield
Thanks again Steve. It looks like a good read. Hopefully, I will be able to wear them down if not convince them :-) On a side, we also had Mike Brunt help with some JVM performance tuning. I don't guess I need to tell you what a good choice that was. :-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby

Re: Serving Content based on Geolocation of IP address

2011-03-10 Thread Michael Grant
Thanks Brian. I was actually just checking them out. It also looks like you can just buy the data and use it locally. On Thu, Mar 10, 2011 at 12:16 PM, Brian Cain bcc9...@gmail.com wrote: I use a product called ip2location. They have a dll that will return a country code based on ip.

RE: Serving Content based on Geolocation of IP address

2011-03-10 Thread Rick Faircloth
If the client just wants reports on country of origin, Google Analytics provides that info for free. -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Thursday, March 10, 2011 12:16 PM To: cf-talk Subject: Re: Serving Content based on Geolocation of IP address I use

Re: Serving Content based on Geolocation of IP address

2011-03-10 Thread Casey Dougall
On Thu, Mar 10, 2011 at 12:30 PM, Rick Faircloth r...@whitestonemedia.comwrote: If the client just wants reports on country of origin, Google Analytics provides that info for free. http://ipinfodb.com/ also offers a free API you can use to lookup location info, it has worked for me in the

RE: ColdFusion License and Builder

2011-03-10 Thread Eric Roberts
I also remember that starting with 9 (or it could have been 8) that you can use your server license on development and testing servers. Please correct me if I am wrong on that. It may have been a special deal as well). Eric -Original Message- From: Russ Michaels

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Eric, You are correct on that. I posted the relevant parts of the EULA in a previous email. Steve -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Thursday, March 10, 2011 12:39 PM To: cf-talk Subject: RE: ColdFusion License and Builder I also

Re: using sum with average with mySQL

2011-03-10 Thread Torrent Girl
also, shouldn't those 2 tables be joined together some how? They are...not sure why the first post didn't include all of the query cffunction name=getAverageTotalCalls access=public cfargument name=employeeID type=numeric required=yes cfargument name=dateWorked

Re: using sum with average with mySQL

2011-03-10 Thread Torrent Girl
Shouldn't it be? SELECT avg(da.connects+ sum(ad.acd)) as averageTotalCalls I changed it and still got the same error: Invalid use of group function ~| Order the Adobe Coldfusion Anthology now!

Re: using sum with average with mySQL

2011-03-10 Thread Greg Morphis
can you provide a couple rows of data with no functions? just the ad.acd and the da.connects? and what you would like for it to show? whenever you use an aggregate function like avg you have to use group by like select studentId, avg(grade) from grades group by studentId On Thu, Mar 10, 2011

Re: using sum with average with mySQL

2011-03-10 Thread Torrent Girl
can you provide a couple rows of data with no functions? just the ad.acd and the da.connects? and what you would like for it to show? whenever you use an aggregate function like avg you have to use group by like select studentId, avg(grade) from grades group by studentId On Thu, Mar 10, 2011

Re: using sum with average with mySQL

2011-03-10 Thread Torrent Girl
can you provide a couple rows of data with no functions? just the ad.acd and the da.connects? and what you would like for it to show? whenever you use an aggregate function like avg you have to use group by like select studentId, avg(grade) from grades group by studentId Yes sorry I misread

Re: using sum with average with mySQL

2011-03-10 Thread Greg Morphis
So you want : (13 + 192) / 2? Or do you need 192/13 ? On Thu, Mar 10, 2011 at 2:07 PM, Torrent Girl moniqueb...@gmail.com wrote: can you provide a couple rows of data with no functions? just the ad.acd and the da.connects? and what you would like for it to show? whenever you use an

Re: using sum with average with mySQL

2011-03-10 Thread Greg Morphis
select avg(connects + acd) from ( SELECT da.connects as connects, sum(ad.acd) as acd FROM dialeragent da, agentDaily ad WHERE da.employeeID = ? AND da.employeeID = ad.employeeID AND da.dateWorked = ? AND ad.dateWorked = ? group by connects ) On Thu, Mar 10, 2011 at 2:20 PM, Greg Morphis

Re: To Fusionreactor or not to Fusionreactor

2011-03-10 Thread rex
Have you tried SeeFusion for your server monitoring needs? It's very lightweight. On 3/10/2011 9:16 AM, Bobby Hartsfield wrote: Thanks again Steve. It looks like a good read. Hopefully, I will be able to wear them down if not convince them :-) On a side, we also had Mike Brunt help with

RE: To Fusionreactor or not to Fusionreactor

2011-03-10 Thread Bobby Hartsfield
Thanks Rex. I have never used it actually. Do you think it has any advantages over FusionRactor? I've always heard others say FR is light weight as well. I thought about asking what people thought of the two in comparison but I found and read this:

Re: ColdFusion License and Builder

2011-03-10 Thread Carl Von Stetten
Adobe modified the EULA again for CF9 to allow Standard and Enterprise to installed as Production Software on one server, as Disaster Recovery Software (or as you called it a 'dark' server) on a different single server, and as Development Software for internal development, testing, and

Re: CFContent failing on large files since moving to ColdFusion 9

2011-03-10 Thread Chris Tsongas
This is a known bug, please log in at the Adobe site and vote for getting it fixed: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=83425 ~| Order the Adobe Coldfusion Anthology now!

Re: CFContent failing on large files since moving to ColdFusion 9

2011-03-10 Thread Chris Tsongas
This is a known bug, please log in at the Adobe site and vote for it: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=83425 ~| Order the Adobe Coldfusion Anthology now!

Re: Serving Content based on Geolocation of IP address [spamtrap bayes][spamtrap heur]

2011-03-10 Thread Paul Hastings
On 3/11/2011 12:49 AM, Casey Dougall wrote: http://ipinfodb.com/ also offers a free API you can use to lookup location i use ipinfodb webservice for a bike route planning app it fails (0,0 locations) a bit too often (its a back-burner side project so i don't care much). you'd be better off