RE: cfoutput or cfloop? which is the more practical solution

2010-09-25 Thread GLM
Mike thanks for the lead. It had crossed my mind to build a numbers table but I didn't think it would work. (I've never used them myself.) I thought that it was somewhat excessive as there would have to be at least 365x220 rows (over 80,000). In the examples I gave I think one row per year (220)

Re: Working with a webservice. Help.

2010-09-25 Thread Dave Watts
> Hmm. I guess I'll have to actually build the xml myself then. The reason I > need the xml is because I only really use cf as a proxy for hitting the > webservice then sending it off to a flex app which consumes it as E4X. The > webservice provider won't add the crossdomain file to their server s

Re: cfoutput or cfloop? which is the more practical solution

2010-09-25 Thread Mike Chabot
You can do this in SQL, although the methods I can think of involve advanced techniques so I hesitate to recommend them based on your stated SQL experience. One technique involves joining to a "numbers table" which will transform the start and end dates into one row per year. You can use the cflo

Re: Trying to set cfform focus in an Ajax window

2010-09-25 Thread John Pullam
Well, it still doesn't work. I've been doing CF for several years myself and this one doesn't make a lot of sense. I have tried the various combos you are alluding to and the code now is: Access ID Pas

Re: Streaming images with links to a non-coldfusion website

2010-09-25 Thread Richard Steele
Success! Even though the cache was disabled, closing and reopening the FF 3.6.10 browser did the trick. Now it works like a champ on all tested browsers. Thanks to everyone for your patience and your great help! This forum rocks! ~~~

Re: Streaming images with links to a non-coldfusion website

2010-09-25 Thread Richard Steele
Dave, Wow, turns out any number of the configurations I had before were working. It works fine on IE8 and Firefox 3.6.6 and Firefox 3.6.10 on the PC (just tried that). And it works fine on the current version of Safari for the Mac. However, unfortunately none work in Mozilla Firefox 3.6.10 on

multiple related cfselects

2010-09-25 Thread John M Bliss
Starting with http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Related-Selects I've developed a page with nine related cfselects like this: etc This sort of works. Page loads with no errors and selects fill in their options. The problem is that FireBug shows an appare

Re: Working with a webservice. Help.

2010-09-25 Thread Michael Grant
Hmm. I guess I'll have to actually build the xml myself then. The reason I need the xml is because I only really use cf as a proxy for hitting the webservice then sending it off to a flex app which consumes it as E4X. The webservice provider won't add the crossdomain file to their server so I can'

Re: modifying a pdf file

2010-09-25 Thread Dave Watts
> Is there anyway to modify a pdf file on the fly from a CF Form > > I have a pdf document that I want to append a copyright notice based on what a > client sumits on a form. Yes, you can use CFPDF to append one PDF to another. There's an example of that in the Advanced ColdFusion 8 materials wri

Re: Parsing/Processing a SOAP package

2010-09-25 Thread Dave Watts
> Dave... you are feeling quite verbose for a Saturday. Can I assume your team > is losing or it's cold and rainy?  :) I've been out of the office for two weeks, so I have a lot of email to catch up with! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fi

Re: Streaming images with links to a non-coldfusion website

2010-09-25 Thread Dave Watts
> Here's my current iteration, which creates the javascript, but still doesn't > show on the > http://www.photoeye.com/advertising/test_ad.cfm > > href=#qGetCurrentAdLink.link_url#> src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#> > > > > #text# > > > > >         >        do

RE: Parsing/Processing a SOAP package

2010-09-25 Thread Mark A. Kruger
Dave... you are feeling quite verbose for a Saturday. Can I assume your team is losing or it's cold and rainy? :) -Mark -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Saturday, September 25, 2010 1:06 PM To: cf-talk Subject: Re: Parsing/Processing a SOAP packag

Re: Parsing/Processing a SOAP package

2010-09-25 Thread Leigh
... My bad. I am responding to the wrong thread. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://w

Re: Parsing/Processing a SOAP package

2010-09-25 Thread Leigh
> Yikes! What's with everyone trying to parse raw XML from > web services lately? The reason *I* suggested using xmlParse in the first place is because I mistakenly thought they were using CFHTTP to call the web service ;) In which it would make sense. But receiving a string back from cfinvoke

Re: Parsing/Processing a SOAP package

2010-09-25 Thread Dave Watts
> Here's the situation: > I use a cfinvoke to call a SOAP web service, and it's stored in a variable. > > I do the following to store the results into a variable: > > > When I cfdump it, it gives me a nice structure diagram - var="#resultXML#"> > > But I am having problems accessing the nodes to

Re: Working with a webservice. Help.

2010-09-25 Thread Dave Watts
> However I don't seem to know how to get to the actual XML anymore. When I > hit the web service it seems to return an object and I'm at a loss as to how > to get the xml I used to get. Any help would be great. > > There's a full description with example code and example response here: > *http://

Re: cfinsert/cfupdate

2010-09-25 Thread Dave Watts
> Ok, so I found out I WAS correct.  Either that or yet another article I > found on prepared statements is wrong.  Here's a quote from the article: > "The PreparedStatement object contains not just an SQL statement, but an SQL > statement that has been precompiled. This means that when the > Prep

Re: Streaming images with links to a non-coldfusion website

2010-09-25 Thread Richard Steele
Sorry, I had tried so many iterations that I inadvertently left it in a bad state. Here's my current iteration, which creates the javascript, but still doesn't show on the http://www.photoeye.com/advertising/test_ad.cfm http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#> #tex

modifying a pdf file

2010-09-25 Thread Rob Voyle
Hi Folks Is there anyway to modify a pdf file on the fly from a CF Form I have a pdf document that I want to append a copyright notice based on what a client sumits on a form. Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative

RE: cfinsert/cfupdate

2010-09-25 Thread Leigh
> I think you are referring to SCOPE_IDENTITY() No, I did mean @@IDENTITY. Though I am going off of much older threads where it was used within a cftransaction, and separate cfquery, to retrieve the Autonumber value from an Access table. Rick's post contained the basic concept, but with cfinse