RE: Application.cfc - normal request or web service?

2008-12-01 Thread Hugo Ahlenius
|On Fri, Nov 28, 2008 at 10:59 AM, Hugo Ahlenius wrote: | Is there any way that the processing (e.g. OnRequestStart) |can know about the request to figure out if it is a web |service call (calling a component as a web service) or a |normal/plain .cfm request? I guess one can always parse this

Re: Application.cfc - normal request or web service?

2008-12-01 Thread Azadi Saryev
because http:/host/testobject.cfc?method=testfunction request is NOT invoking a web service. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Hugo Ahlenius wrote: |On Fri, Nov 28, 2008 at 10:59 AM, Hugo Ahlenius wrote: | Is there any way that the processing (e.g. OnRequestStart) |can

Detecting Dirty Data inside a cflayout (aka Ext.TabPanel)

2008-12-01 Thread Mark Pitts
The problem I was trying to solve was to be able to prompt the user before changing tabs whenever there is dirty data on the current tab. My first approach was to use the Ext.TabPanel's beforetabchange event. This strategy works if I did not implement any sort of prompting. As soon as I

Re: Verity writing stuff to my text files

2008-12-01 Thread Tom Chiverton
On Monday 01 Dec 2008, Scott Doc wrote: I can't seem to find anything about verity having a user account. The process must be running as some user or other... -- Tom Chiverton Helping to conveniently strategize high-yield customized unique user-centric methodologies

Re: Borked my CF8 dev install

2008-12-01 Thread Tom Chiverton
On Friday 28 Nov 2008, Pete Ruckelshaus wrote: Thanks for the suggestion, but that's easier said than done with directories in the C:\ drive of Vista. If you say so. OOI, what is wrong with Vista that it wont let you delete files ? -- Tom Chiverton Helping to appropriately reinvent

Re: Borked my CF8 dev install

2008-12-01 Thread Dave Watts
Thanks for the suggestion, but that's easier said than done with directories in the C:\ drive of Vista. If you say so. OOI, what is wrong with Vista that it wont let you delete files ? It will certainly let you do that. You may have to pass through a UAC prompt, however, or if you're doing

SQL between dates problem

2008-12-01 Thread Will Tomlinson
SQL server 2000. I have two columns - startdate and enddate, why would this not return a record if the startdate and enddate are the same. ex. 12/01/2008 for both. AND GETDATE() = couponstartdate and GETDATE() = couponenddate Is there a better way to write this? I need it to return a record.

Re: SQL between dates problem

2008-12-01 Thread John M Bliss
Because GETDATE() will return the current date *and time* and I'll bet that your start/end dates are coming back as 12/1/2008 12:00 AM. On 12/1/08, Will Tomlinson [EMAIL PROTECTED] wrote: SQL server 2000. I have two columns - startdate and enddate, why would this not return a record if the

RE: To cfinterface or not to cfinterface

2008-12-01 Thread Andy Matthews
Would an established framework like Model Glue or Mach II work well with an all AJAX app? From what I've heard those frameworks store lots of stuff in the app, and session, scope. andy -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2008

Re: SQL between dates problem

2008-12-01 Thread Will Tomlinson
Because GETDATE() will return the current date *and time* and I'll bet that your start/end dates are coming back as 12/1/2008 12:00 AM. Ahhh yes! That makes sense. Thanks John! Will ~| Adobe® ColdFusion® 8 software 8 is

Re: Borked my CF8 dev install

2008-12-01 Thread Tom Chiverton
On Monday 01 Dec 2008, Dave Watts wrote: Thanks for the suggestion, but that's easier said than done with directories in the C:\ drive of Vista. If you say so. OOI, what is wrong with Vista that it wont let you delete files ? It will certainly let you do that. You may have to pass through

RE: SQL between dates problem

2008-12-01 Thread Duane Boudreau
Try this: AND GETDATE() = '#couponstartdate# 00:00:00' and GETDATE() = '#couponenddate# 23:59:59' -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 10:17 AM To: cf-talk Subject: SQL between dates problem SQL server 2000. I have two

RE: SQL between dates problem

2008-12-01 Thread Dawson, Michael
If you are using MS SQL... SELECT CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime) This will remove any time part from a datetime field. Mike -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 8:32 AM To: cf-talk Subject: Re: SQL between

Re: SQL between dates problem

2008-12-01 Thread Will Tomlinson
Try this: AND GETDATE() = '#couponstartdate# 00:00:00' and GETDATE() = '#couponenddate# 23:59:59' Except the values I want to match them against are the value in a column - not a couponstartdate or couponenddate variable. Thanks! Will

Re: SQL between dates problem

2008-12-01 Thread Will Tomlinson
If you are using MS SQL... SELECT CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime) This will remove any time part from a datetime field. So then I write it like this? AND datetime = couponstartdate and datetime = couponenddate Thanks! Will

RE: SQL between dates problem

2008-12-01 Thread Dawson, Michael
I would do something like: WHERE datetime BETWEEN CAST(FLOOR(CAST(couponstartdate AS float)) AS datetime) AND CAST(FLOOR(CAST(couponenddate AS float)) AS datetime) -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 9:05 AM To: cf-talk

Re: SQL between dates problem

2008-12-01 Thread John M Bliss
Another CFMLish option: couponstartdate = #CreateODBCDateTime(CreateDateTime(DatePart(, Now()), DatePart(m, Now()), DatePart(d, Now()), 23, 59, 59))# and couponenddate = #CreateODBCDateTime(CreateDateTime(DatePart(, Now()), DatePart(m, Now()), DatePart(d, Now()), 0, 0, 1))# On Mon, Dec

Re: Verity writing stuff to my text files

2008-12-01 Thread Dave Watts
I can't seem to find anything about verity having a user account. Can you point me in the right direction? I'm assuming this is a server level security thing - which I don't really have access to as our server is hosted halfway around the world. Every process runs with some set of

PayPal Integration

2008-12-01 Thread Robert Rawlins
Hello Guys, Looking for the first time in ages to getting up and running with processing credit card payments using PayPal. I have myself a PayPal Payments Pro account setup and paid for, now just looking to get up and running with the API to process the payments from our site. After a

RE: SQL between dates problem

2008-12-01 Thread Dawson, Michael
Although this will work perfectly, if provided with CF variables. However, I think Will's dates were already in the database where he would need to stick to the database's date functions. In other words, he wasn't in a situation where he was passing in CF variables to his SQL statement. Mike

RE: PayPal Integration

2008-12-01 Thread Dawson, Michael
We rolled our own using PayPal's HTTP request/response solution. It was pretty easy to do. Mike -Original Message- From: Robert Rawlins [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 9:46 AM To: cf-talk Subject: PayPal Integration Hello Guys, Looking for the first time

RE: PayPal Integration

2008-12-01 Thread Robert Rawlins
Mike, Thanks. Was this website payments pro? And this was using the SOAP web services, correct? At the moment my requirements are very simple, I'm simply making single payment transactions for set amounts, I don't have a cart of products or anything like that. Cheers, Rob -Original

Re: PayPal Integration

2008-12-01 Thread Gerald Guido
There are a couple of CFC's on RiaForge. Both are v 0.1 but it may shorten your learning curve. http://cfpayflowpro.riaforge.org/ http://paypalcfc.riaforge.org/ hth G On Mon, Dec 1, 2008 at 10:46 AM, Robert Rawlins [EMAIL PROTECTED] wrote: Hello Guys, Looking for the first time in ages to

RE: PayPal Integration

2008-12-01 Thread Dawson, Michael
We use Payflow Pro and simple HTTP requests. No SOAP or nuttin fancy. Other than setting some params for amount, credit card number, etc, the HTTP request looks like this: cfhttp url=https://pilot-payflowpro.verisign.com:443; method=post resolveurl=no timeout=30 cfhttpparam type=header

Re: To cfinterface or not to cfinterface

2008-12-01 Thread Dominic Watson
Yep. If anything, the extensive use of the application scope would speed up your ajax calls. Using the app scope is otherwise unrelated to the fact that your app is all ajax. In terms of MVC, each of your ajax calls would result in a *view* of the data, in whatever format that may be. Dominic

RE: PayPal Integration

2008-12-01 Thread Robert Rawlins
Mike, Thanks for this, someone mailed me off list with code very similar to this which looks as if it'll do the job I want. The real challenge right now is getting sandbox access in the UK, seems they're not properly setup for it yet and you have to jump through hoops, real pain in the arse.

Re: SQL between dates problem

2008-12-01 Thread Will Tomlinson
I would do something like: WHERE datetime BETWEEN CAST(FLOOR(CAST(couponstartdate AS float)) AS datetime) AND CAST(FLOOR(CAST(couponenddate AS float)) AS datetime) I'm remote right now, but will give it a whirl tonight. Thanks for your help! Will

IIS Application Pools and ColdFusion

2008-12-01 Thread Johnny Le
We have recently migrated all of our applications to a new MS 2003 server. Ever since the applications kept going down even though the server was still up and functioning normally. Eventually we figured out that it was the application pool that went down. We separated the applications out to

RE: IIS Application Pools and ColdFusion

2008-12-01 Thread Gaulin, Mark
I don't know about MS 2003 too much, but in 2008 the app pools have two related Rapid-fail protection settings that we had to tweak: the maximum failures and failure interval. It appears that app pools can be set up to shut themselves down when IIS sees too many errors within a given amount of

Enabling SSL for CF-Site

2008-12-01 Thread Joseph Bugeja
Hello Experts, This is more of a curiosity rather than a technical problem. We have a CF powered site hosted under IIS/JRun server on Win 2K 64-bit. This site works brilliantly, but now we need to make it available on SSL. From an application perspective, do you forsee any changes or it is

Re: Enabling SSL for CF-Site

2008-12-01 Thread Jason Fisher
If you use sessions anywhere and if those sessions have to be sticky from non-SSL across to SSL, then you'll need to write the handlers for that. Otherwise, it all works as is. CF doesn't care, it just serves pages. Basically, if you need to 'cross' the SSL line with sessions, you want to

Display PDF on page with other data

2008-12-01 Thread Kevin Stone
Is it possible to display a PDF document on a page with a bunch of input fields? I have only been able to display a pdf on a page by itself using cfheader and cfcontent but now want to display it in a frame/div on the bottom of another page. Anybody know how to do this? thanks

RE: Display PDF on page with other data

2008-12-01 Thread Robert Harrison
You could use an iframe. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message-

Re: Display PDF on page with other data

2008-12-01 Thread Nicholas M Tunney
Have you tried rendering it in an iframe? Kevin Stone wrote: Is it possible to display a PDF document on a page with a bunch of input fields? I have only been able to display a pdf on a page by itself using cfheader and cfcontent but now want to display it in a frame/div on the bottom of

Re: Display PDF on page with other data

2008-12-01 Thread Kevin Stone
Works like a champ. I was so caught up in doing it with CF tags that I didn't even think about the iframe. THanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Display PDF on page with other data

2008-12-01 Thread Dave Watts
Is it possible to display a PDF document on a page with a bunch of input fields? I have only been able to display a pdf on a page by itself using cfheader and cfcontent but now want to display it in a frame/div on the bottom of another page. Anybody know how to do this? Yes, and you don't

Re: Enabling SSL for CF-Site

2008-12-01 Thread Wil Genovese
If you have hard coded http://; anywhere that will be under the SSL then you'll run into browsers complaining about mixed secure and non-secure content. Wil Genovese Sr. Web Application Developer On Mon, Dec 1, 2008 at 2:45 PM, Jason Fisher [EMAIL PROTECTED] wrote: If you use sessions

Re: IIS Application Pools and ColdFusion

2008-12-01 Thread Matthew Small
Any shutdown in an IIS application pool is a process crash and needs to be debugged with a post-mortem userdump. My recommendation is that you open a support ticket with Microsoft to identify the root cause. Be aware, however, that in 90% of the cases we see, the cause is in a 3rd party

Re: SQL between dates problem

2008-12-01 Thread Will Tomlinson
If you are using MS SQL... SELECT CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime) This will remove any time part from a datetime field. I'm getting an error from the SQL. I've played around with it with no luck. SELECT couponpercdisc, CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime) FROM

cf.Objective() 2009 Call for Speakers (Topics) is open!

2008-12-01 Thread Nicholas M Tunney
The cf.Objective() Steering Committee just opened the Call for Speakers and Topics. Instructions may be found here: http://www.cfobjective.com/callforspeakers.cfm Thanks, Nic ~| Adobe® ColdFusion® 8 software 8 is the most

Fwd: Guru available in DC Metro area

2008-12-01 Thread Guru
I am a Senior level developer with 12+ years of experience in CF with MS SQL Server and Oracle. I am looking for a new position as a senior CF developer OR as a manager of a development team. I also have extensive experience managing full-cycle development projects. I have drilled deeply into

What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
I don't recall ever having a problem with the cfoutput group attribute. But I can't figure out why it isn't woring right here. My table looks like this: ID Date ZIP code - 1 12/01/200827403 2 12/01/200890210 3 12/01/2008

Re: What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
Crap, it goes back to my stupid date/time datatype for the field. All the times are different, and CF IS group the data, but they're all different so it output each row. I used Michael's example from my other thread to do this. Seems to work: SELECT estshiplogid,CAST(FLOOR(CAST(estshiplogdate

cfautosuggest copying the CFIDE folder problems

2008-12-01 Thread Seamus Campbell
Hi I'm using cfautosuggest and I want to edit the css to change the default colours. I have done so on my local server copying the CFIDE folder to the current folder then using cfajaximport to point to that folder. This works fine. I then uploaded my local folder CFIDE to my production server

display field in autosuggest

2008-12-01 Thread Seamus Campbell
Hi I'm using cfautosuggest and I am displaying surname first_name fields in the dropdown box. However these 2 fields appear to be the only 2 fields that are passed onto the form action page. I need the contact-id field (as there are sometimes more than one person with the same surname and

cfpop using hotmail

2008-12-01 Thread Javier Buzzi
Hi, Im working on a prof of concept using the pop service on hotmail. I've found info on Google saying that hotmail give pop access to premium access users - i have a one of those accounts. I heard that it does SSL only and cfpop does not right off the bat, so i did some digging and found this:

Cfdocumentitem broken

2008-12-01 Thread James Holmes
If I use a cfdocumentitem in a doc to create a footer in CF 8.01 Enterprise (with all the updaters) the doc generation churns for minutes and eventually causes a page load error. While the doc is being produced, FusionReactor shows this for the request: State:TIMED_WAITING jrpp-390

Re: Verity writing stuff to my text files

2008-12-01 Thread Scott Doc
Thanks for all your advice, Dave. I refreshed my articles collection today after uploading backup versions of the text files (hurray, I had them) and it didn't add that text to them.. so looks like, for now at least, it has stopped. Possibly I did something funny in a cfindex a while back when

Re: Cfdocumentitem broken

2008-12-01 Thread James Holmes
Fixed it. It turns out the server wasn't configured for headless mode properly. Adding the headless flag cleared up the root cause of the problem: Exception in thread AWT-EventQueue-0 java.awt.HeadlessException: No X11 DISPLAY variable was set, but this program performed an operation which

Simple ecommerce -- not exactly CF but may be relevant

2008-12-01 Thread Don L
About a few weeks ago I asked a question related to cc processing, silly me, I forgot the CFform family's CFinput has an attribute of cc validation, so, say, 85% customers provide good card and up front say something like if your card is rejected (you shall bear bank fee). Ok this is the first

Re: Simple ecommerce -- not exactly CF but may be relevant

2008-12-01 Thread Wil Genovese
The company that you will be using to validate and process the card will take care of telling you if the card is accepted or rejected and then you code your user response accordingly. You usually have a large number of setup options that lets you set how much info you want to collect for