Re: trying to shorten long string

2015-03-07 Thread Captain Obvious

Variable I is undefined.

This works,










#variables.description#

On Sat, Mar 7, 2015 at 1:31 AM, Mark Spence  wrote:
>
> I have a long product description I am trying to truncate.  I could just
> truncate it, but I don't want to break off sentences.  Here is the solution
> I came up with but it does not seem to have any effect.
>
> Any ideas?
>
> 
> 
> 
>  listDeleteAt(variables.description,listLen(variables.description, "."),
> ".")>
> 
> 
> 
> 
> 
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360223
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: need a host

2014-11-20 Thread Captain Obvious

Same here, no complaints with Hostek service or support at all.
On Nov 20, 2014 9:39 AM, "Rick Faircloth"  wrote:

>
> I've always gotten quick, personal attention to any issues that may arise.
>
>
> On 11/19/2014 9:27 PM, Rick Eidson wrote:
> > I posted about this last week... Yes, you are right. It seems they have
> > become a bit drone like. Before with a tech problem things seems more
> > personable.
> >
> >
> >
> > Rick
> >
> > -Original Message-
> > From: Rick Faircloth [mailto:r...@whitestonemedia.com]
> > Sent: Wednesday, November 19, 2014 7:41 PM
> > To: cf-talk
> > Subject: Re: need a host
> >
> >
> > KickAssVPS.com
> >
> > Been with them for years; very little trouble; always quick with support.
> >
> > They even tailor VPS's for me.
> >
> >
> > On 11/19/2014 7:49 PM, Brian Thornton wrote:
> >> So sorry to bring up an old thread. BUt things have changed at Hostek.
> >> Simple common sense have changed into support phone scripts,
> >> unresponsive tickets, beuracy over account confirmatino over the
> >> phone.
> >>
> >> Some examples:
> >> EXAMPLE 1:
> >> Me: "Hi Can you make this change on the account since the online
> >> portal is not working using the username and password you provided?"
> >> Hostek Support: "Yes as long as you answer your secret question with
> >> the correct answer."
> >> Me: "Sure what is the question that you'd like me to answer?"
> >> Hostek: "Sir due to confidentiality, I cant give you the question or
> >> the answer but you can login online to get the question."
> >> Me: "I understand that but I'm calling since the autogenerated
> >> password you just created and emailed me isn't valid this cannot login
> >> to the portal. If I can't login how would I get the question or the
> >> answer and if I could login I wouldn't be calling you."
> >> Hostek: "Well sir, if you like you can login and change your password
> >> if you like."
> >>
> >> or EXAMPLE 2:
> >> Me: When you setup a VPS server for a client you gave them a username
> >> and password for RDS to the machine, however your policy is to block
> >> all access unless the IP address is whitelisted. What is the password
> >> to login to add an IPto the whitelist table?"
> >> Hostek: "Sorry sir, that's a different password that you will need to
> >> login with. I don't have access to it, to allow you to reset it, or to
> >> create a new one. You will need to login to change it."
> >>
> >> etc etc..
> >>
> >> So kudos to Hostek for being CF tailored, but folks they have become
> > drones.
> >> I recommend the others found at:
> >> http://www.adobe.com/uk/products/coldfusion-family/hosting-partners.ht
> >> ml
> >>
> >> On Sun, Jul 20, 2014 at 5:19 PM, Stephen Hait 
> > wrote:
> >>> Just switched a client from Newtek to Hostek and everyone's a lot
> > happier.
> >>> CF11, though, not sure about CF9.
> >>>
> >>>
> >>> On Sun, Jul 20, 2014 at 5:09 PM, Matthew Smith
> >>> 
> >>> wrote:
> >>>
>  not newtek, no hostmedia.co.uk(no mssql), no viviotek.  Any
> suggestions?
> 
>  Need cf 9 and ms sql.  Thanks.
> 
>  --
>  Regards,
>  chedder is bedder
> 
> 
> 
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359690
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone have experience running CyberSource Secure Acceptance

2014-09-16 Thread Captain Obvious

http://www.bennadel.com/blog/2412-crypto-cfc-for-hmac-sha1-hmac-sha256-and-hmac-md5-code-generation-in-coldfusion.htm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359304
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Package routing and maps

2014-07-25 Thread Captain Obvious

Just use the google maps javascript api. No cf or java required. As
with the cf UI tags, skip the cfmap tags - after ten minutes with the
js api you won't need them.

On Fri, Jul 25, 2014 at 8:20 PM, Eric Roberts
 wrote:
>
> Google has the best integration with CF as it is a java API.  Plus there are
> CF tagsd that work together with google maps.
>
> -Original Message-
> From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
> Sent: Friday, July 25, 2014 6:08 PM
> To: cf-talk
> Subject: Re: Package routing and maps
>
>
> You are correct. There's Google, TMW, Webfleet, etc. What have I missed and
> what have people used?
>
>
> On Fri, Jul 25, 2014 at 5:35 PM, Eric Roberts <
> ow...@threeravensconsulting.com> wrote:
>
>>
>> I believe the google API has something for that.  I don't remember
>> details, but that is the direction I would look.  You can then
>> leverage java to access the api.
>>
>> -Original Message-
>> From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
>> Sent: Friday, July 25, 2014 4:08 PM
>> To: cf-talk
>> Subject: Package routing and maps
>>
>>
>> I'm doing some research on routing packages using something like
>> Google maps. Basically, if you take a starting location, give it a few
>> waypoints, and an ending location, the program/api will calculate the
>> best route for it. The classic traveling salesman problem.
>> I've found a few examples but I was wondering if anyone has such a
>> system in place with CF and what they are using? What pitfalls have
>> they found?
>> What spurred the choice for one system over another?
>>
>> Thanks
>> Michael
>>
>>
>>
>>
>>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358999
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Run or spawn a desktop program

2014-05-02 Thread Captain Obvious

No. Thank God


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358540
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Creating Grayscale PDF with CFDocument in CF8?

2014-01-31 Thread Captain Obvious

Perhaps a print stylesheet?

On Fri, Jan 31, 2014 at 12:57 PM, Dave  Hatz  wrote:
>
> Anyone know how to create a PDF document in grayscale?  We have a web page 
> that we give the user the ability to create a PDF of the page.  The client 
> doesn't want any of the color that we have in our table columns to print in 
> color.
>
> I did a quick search on google, doesn't seem to be way to tell CFDocument to 
> create the PDF in grayscale.
>
> Anyone know of a way to do this without creating another web page without 
> colors?
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357555
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Make Lead Story in Information Week

2013-11-08 Thread Captain Obvious

meh - Not really specific to CF. The first comment in the original blog
post summed it up well enough - "lack of due diligence by sysadmins".


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF10 dump bug

2013-09-11 Thread Captain Obvious

For me it works as you expect if I alter the regex by adding a question
mark like this

"[[:space:]]{2,}?"

See Lazy Quantifier: http://msdn.microsoft.com/en-us/library/3206d374.aspx


On Wed, Sep 11, 2013 at 12:02 PM, Nando  wrote:

>
> Ray,
>
> Thanks again for your suggestion to try it outside any application. I was
> then able to isolate the issue (even tho' I thought I couldn't at first!),
> and it seems indeed that it occurs if whitespace is stripped from the
> cfdump output. You'll find a pair of very simple templates in this zip -
> http://aria-media.com/testDump.zip - that demonstrate the issue. Change
> the
> query in test.cfm to something that will work. Browse to test.cfm and it's
> fine. Browse to testDump.cfm and it's broken.
>
> It could be argued that the developers need to be careful when stripping
> whitespace, but it could also be argued that this would be a simple fix and
> cfdump should be a little more robust, so why not? As I wrote, I
> *think*someone just needs to open the source template and repetitively
> search and
> replace all instances of 2 consecutive spaces with one space until no
> space-space instances are found. That should prevent any regex that strips
> whitespace from collapsingcodetogether and thereby breaking functionality.
> What do you think?
>
>
> On Wed, Sep 11, 2013 at 5:15 PM, Nando  wrote:
>
> > Ray,
> >
> > I think I have a clue what might be going on. I compared the browser view
> > source of both the standalone template and the fw/1 template. The fw/1
> > version has the whitespace striped out. I selectively strip some of the
> > white space from the rendered views at times, but I've seen that doing so
> > can sometimes inadvertently collapse 2 bits of code that should be
> > separated by a space into something that doesn't work anymore, depending
> on
> > the regex, or regex sequence, used. Lemme follow up on this and see how
> > that is occurring. Sean might have introduced this at some point into the
> > framework.
> >
> > That said, what I would do at this point if I maintained the dump.cfm
> > template is to run a search and replace on the source code, searching
> for 2
> > consecutive spaces and replacing it with one space - repeating that as
> many
> > times as necessary until all instances of 2 consecutive spaces are
> > eliminated. This assumes that the code is formatted using tab characters
> > rather than spaces ...
> >
> >
> > On Wed, Sep 11, 2013 at 4:54 PM, Raymond Camden  >wrote:
> >
> >>
> >> I had a FW/1 app handy but I can't recreate it. Can you please create a
> >> repo zip that I can extract and run here? Since you said the DB call
> >> didn't
> >> matter, just make it obvious for me and I'll replace it with another
> >> query.
> >> Or, if you ALSO see it with a fake query, use that.
> >>
> >>
> >>
> >> On Wed, Sep 11, 2013 at 9:49 AM, Nando  wrote:
> >>
> >> >
> >> > Ray,
> >> >
> >> > The cfdump error was seen on a FW/1 view template. When I try the same
> >> > query within a single template outside any application, cfdump works
> >> fine.
> >> > So that was a good suggestion. I have no idea how to interpret it
> tho',
> >> > especially since I cannot see the source code of of dump.cfm.
> >> >
> >> > I've been developing on FW/1 almost exclusively for the last several
> >> years.
> >> > I'm not sure when this crept in, but I do know that I've used cfdump
> >> often
> >> > in the past to examine query data while constructing the view
> >> templates. It
> >> > might not even be related to FW/1. What do you suggest as a next step?
> >> >
> >> >
> >> > On Wed, Sep 11, 2013 at 4:19 PM, Raymond Camden <
> >> raymondcam...@gmail.com
> >> > >wrote:
> >> >
> >> > >
> >> > > To be clear, no one else in this thread is seeing what Nando does,
> >> right?
> >> > >
> >> > > Nando, can you ensure you are doing a dump with NOTHING else in the
> >> > > request. No App.cfm. Also, try different browsers.
> >> > >
> >> > >
> >> > >
> >> > > On Wed, Sep 11, 2013 at 9:18 AM, Nando  wrote:
> >> > >
> >> > > >
> >> > > > Yes, it's obviously malformed HTML, but since the ACF cfdump
> >> template
> >> > is
> >> > > > encoded, I can't reasonably do anything about it.
> >> > > >
> >> > > >
> >> > > > On Wed, Sep 11, 2013 at 2:48 PM, Rodney Enke 
> >> > wrote:
> >> > > >
> >> > > > >
> >> > > > > At this point I would look at bad HTML preceding the cfdump or
> CSS
> >> > > styles
> >> > > > > causing the reformatting.
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > > --
> >> > > > Nando Breiter
> >> > > >
> >> > > > *Aria Media
> >> > > > via Rompada 40
> >> > > > 6987 Caslano
> >> > > > Switzerland
> >> > > > *
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356

Re: Syntax is driving me nuts!

2013-08-20 Thread Captain Obvious

IsDefined("form.rel_#ar#")


On Tue, Aug 20, 2013 at 11:55 AM, Raymond Camden wrote:

>
> Use structKeyExists.
>
> 
>
>
>
> On Tue, Aug 20, 2013 at 10:48 AM, Rick Sanders  wrote:
>
> >
> > Hey guys,
> >
> > I'm trying to add multiple items to a database based on if a check box is
> > checked.
> >
> > This code works fine:
> > 
> >
> > But I want to make sure the box is checked or not. When I do this:
> > 
> > I get: Element rel_1 is undefined in a Java object of type class
> > coldfusion.filter.FormScope.
> >
> > If I do this:
> > 
> > I get: Parameter 1 of function IsDefined, which is now form['rel_' & ar],
> > must be a syntactically valid variable name.
> >
> > I'm doing all this in a loop. The form's check boxes are defined as:
> > rel_#currentrow#. Then I'm looping around them:
> > 
> > Numrows comes from the recordcount of the hidden form variable output
> > query displaying the checkboxes.
> >
> > All I need to know is what the right syntax I need to use for IsDefined?
> >
> > Kind Regards,
> >
> > Rick Sanders
> > T: 902-401-7689
> > W: www.webenergy.ca
> >
> >
> >
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356506
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Short Question? CFOUTPUT converting " to "

2013-04-30 Thread Captain Obvious

If you view source for the cfoutput block you will find
"mystring" Looks like your html doc, not cfohtput, is rendering
the entity code as expected.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355635
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Case Sensitive QofQ and Operators

2013-04-09 Thread Captain Obvious

Use the UPPER operator native to your SQL dialect or set a cf var to the
desired value and then use that var to construct your query.
On Apr 9, 2013 11:45 AM, "Brian Thornton"  wrote:

>
> If you have a solution that would be great, and an explanation would be
> even better...
>
> Here's my quandary . without "UPPERing" or "LOWERing" my results out of
> MSSQL can I do a equal operator and ignore casing?
>
> According to Adobe (
>
> http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html
> )
>
> "Unlike the rest of ColdFusion, Query of Queries is case-sensitive.
> However, Query of Queries supports two string functions, UPPER() and
> LOWER(), which you can use to achieve case-insensitive matching."
>
> The cf error using UPPER is "Invalid Operator upper
>
> SQL = "select * from this table where upper(columnname) = '"
>
>
> --
> Brian Thornton
> (260) 267-6520
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355317
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfm files bypass permissions -- htm files get 401 unauthorized

2012-10-26 Thread Captain Obvious

Chris - glad it worked out (this is jt)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353008
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Getting data from MS Access and importing into SQL.

2012-08-13 Thread Captain Obvious

If end users have connectivity to the sql server, yes (no special interface
required though).

On Mon, Aug 13, 2012 at 1:15 PM, Russ Michaels  wrote:

>
> it is possible to add a custom interface for msaccess that links it to sql
> server, so users can do this directly.
> I don;t know how to do this as I don;t do VBA, but we have a customer that
> does this very thing. He runs msaccess locally and uses it to conenct to
> his hosted database and manage data and sync with his local access db
>


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352137
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Getting data from MS Access and importing into SQL.

2012-08-13 Thread Captain Obvious

Maybe this:

 - have end-users upload entire MDB.
 - in uploaded MDBs insert links to SQL Server tables.
 - execute a set of Insert queries to copy data from MDB tables to SQL
Server tables.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: I doubt anyone can help me with this, but...

2012-02-22 Thread Captain Obvious

Just charge for the labor accordingly... Have managed to talk clients out
of all sorts of outlandish impulses by bringing up the costs ($ or time or
both). Questions that start with "Can we [some technical thing]?" can
usually be answered "Yes, given [required resources]." The more interesting
question is often "How best should we [some technical thing] given
currently available resources\workflows\future plans\etc]?"


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350045
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Escaping #

2012-01-22 Thread Captain Obvious

/* note: your cfparam needs "form.namefirst" not just "namefirst" */









  





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349594
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: KCfinder with CKeditor and Coldfusion?

2011-12-08 Thread Captain Obvious

CKfinder and CKeditor and Coldfusion? Yes.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349031
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: SOT: Mobile Web App Dev Problem

2011-12-06 Thread Captain Obvious

FWIW - could not reproduce the problem on my Transformer, using "Browser".


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: SOT: Mobile Web App Dev Problem

2011-12-05 Thread Captain Obvious

500 error : Table 'holtzmanrentals.rentalmainphotos' doesn't exist


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348952
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: arraydeleteat display issue

2011-10-12 Thread Captain Obvious

ArrayDeleteAt returns true\false based on the success of the operation. Both
your samples create the impression you want to display that value. Try this,






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious

Tried that (specifying XML in filenme attribute of cfheader tag) but Excel
2010 appends ".xls" to the filename, which then results in the "extension"
prompt. No such problem prior to MS-Office 2007. But thanks Bill, appreciate
the input.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious

Ah, thanks Leigh.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious

Me too. Have you figured a way to avoid Excel 2010 from producing the
message below when opening files generated in this manner?


"The file you are trying to open is in a different format than specified by
the extension..."


On Mon, Aug 1, 2011 at 1:07 PM, Bill Franklin wrote:

> The way we have always handled excel spreadsheet generation (CF8), has been
> to take a formatted spreadsheet, save it as and XML sheet, open that XML in
> Notepad, copy the XML code and paste it inside a  variable="strXmlData"> tag...
>


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm