[cfaussie] Re: Outputting to Excel - how to incorporate styles
Dale's suggestions works just fine and I have successfully used that
method several times in the past (both with and without styles)
I did however found something very interesting not too long ago about
how to create an Excel XML
I still haven't had the time to actually try it out and I have no idea
how to apply different styles but this is the basic format for the
Excel XML (including the CF Header/Content tags:
http://www.w3.org/TR/REC-html40";>
Header Title 1
Header Title 2
Header Title 3
Row 1 Col1 Value
Row 1 Col2 Value
Row 1 Col3 Value
Row 2 Col1 Value
Row 2 Col2 Value
Row 3 Col3 Value
The really cool thing about this (if it works) is that you could
generate multiple Excel Worksheets, something that wouldn't be possible
with the HTML-method.
Please let me know how it goes and if it works out.
/Max
p.s.
The source for this knowledge is from:
Tim Newton (MercuryFusion.com) and his QueryToSpreadSheetML CustomTag
Dale Fraser wrote:
> You can do html method and still download not view.
>
> If your interested in how, I can post more.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Mike Kear
> Sent: Thursday, 14 September 2006 13:58 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
>
>
> Thanks again Dale. I dont want to out put a HTML page, i want to
> output a XLS worksheet- an excel spreadsheet, not a HTML
> representation of an excel spreadsheet.
>
> If i do a html page, it displays on the browser screen. It doesnt
> download. After all, the whole purpose of this functionality is to
> allow users to download as a spreadsheet the data they're already
> seeing in the browser
>
> I sincerely appreciate your interest, Dale, but I dont think I've
> explained the task adequately enough perhaps.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
> On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> > And my third post about embedding the style was correct.
> >
> >
> >
> >
> >
> > .forMike { color:red; background:#00FF99; }
> >
> >
> >
> >
> >
> >
> > Just Guessing!
> >
> >
> >
> >
> >
> > I'm not sure what you tried, but it doesn't get much simpler than this.
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
> >
> >
> >
> >
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Mike Kear
> > Sent: Thursday, 14 September 2006 13:27 PM
> > To: cfaussie@googlegroups.com
> > Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
> >
> >
> > Dale are you suggesting this based on what you have ACTUALLY done or
> > what you think ought to be the case?
> >
> > Because as I said in my original posting, there are quire a few things
> > I've tried without success.
> >
> > Cheers
> > Mike Kear
> > Windsor, NSW, Australia
> > Adobe Certified Advanced ColdFusion Developer
> > AFP Webworks
> > http://afpwebworks.com
> > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
> >
> >
> >
> > On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> > >
> > > Just embed the style tag
> > >
> > >
> > > .myStyle color: #00;
> > >
> > >
> > >
> > > Regards
> > > Dale Fraser
> > >
> > > http://dale.fraser.id.au
> > >
> >
> >
> >
> >
> > >
> >
>
>
> --
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
You can do html method and still download not view.
If your interested in how, I can post more.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Thursday, 14 September 2006 13:58 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
Thanks again Dale. I dont want to out put a HTML page, i want to
output a XLS worksheet- an excel spreadsheet, not a HTML
representation of an excel spreadsheet.
If i do a html page, it displays on the browser screen. It doesnt
download. After all, the whole purpose of this functionality is to
allow users to download as a spreadsheet the data they're already
seeing in the browser
I sincerely appreciate your interest, Dale, but I dont think I've
explained the task adequately enough perhaps.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> And my third post about embedding the style was correct.
>
>
>
>
>
> .forMike { color:red; background:#00FF99; }
>
>
>
>
>
>
> Just Guessing!
>
>
>
>
>
> I'm not sure what you tried, but it doesn't get much simpler than this.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
> Of Mike Kear
> Sent: Thursday, 14 September 2006 13:27 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
>
>
> Dale are you suggesting this based on what you have ACTUALLY done or
> what you think ought to be the case?
>
> Because as I said in my original posting, there are quire a few things
> I've tried without success.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> > Just embed the style tag
> >
> >
> > .myStyle color: #00;
> >
> >
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
>
>
>
>
> >
>
--
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Actually Dale is correct. The standard way to generate excel spreadsheets the way you want is to generate an html table and set the doc type to application/vnd.ms-excel the way you have. When a user opens the page, their browser detects the mime type and opens the page in excel and excel 'magically' creates the spreadsheet. I can't speak for the style stuff though as I've never had that kind of requirement. BlairOn 9/14/06, Mike Kear <[EMAIL PROTECTED]> wrote: Thanks again Dale. I dont want to out put a HTML page, i want tooutput a XLS worksheet- an excel spreadsheet, not a HTMLrepresentation of an excel spreadsheet.If i do a html page, it displays on the browser screen. It doesnt download. After all, the whole purpose of this functionality is toallow users to download as a spreadsheet the data they're alreadyseeing in the browserI sincerely appreciate your interest, Dale, but I dont think I've explained the task adequately enough perhaps.CheersMike KearWindsor, NSW, AustraliaAdobe Certified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/monthOn 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:>> And my third post about embedding the style was correct. >> > > >
> .forMike { color:red; background:#00FF99; }
> > >> > > > Just Guessing! > > > > >> I'm not sure what you tried, but it doesn't get much simpler than this. >> Regards> Dale Fraser>> http://dale.fraser.id.au>> -Original Message-> From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf> Of Mike Kear> Sent: Thursday, 14 September 2006 13:27 PM> To: cfaussie@googlegroups.com> Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles>>> Dale are you suggesting this based on what you have ACTUALLY done or> what you think ought to be the case? >> Because as I said in my original posting, there are quire a few things> I've tried without success.>> Cheers> Mike Kear> Windsor, NSW, Australia> Adobe Certified Advanced ColdFusion Developer > AFP Webworks> http://afpwebworks.com> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Dale Fraser < [EMAIL PROTECTED]> wrote:> >> > Just embed the style tag> >> >
> > .myStyle color: #00;
> > > >> >> > Regards> > Dale Fraser> >> > http://dale.fraser.id.au> >> > >-- --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Thanks again Dale. I dont want to out put a HTML page, i want to
output a XLS worksheet- an excel spreadsheet, not a HTML
representation of an excel spreadsheet.
If i do a html page, it displays on the browser screen. It doesnt
download. After all, the whole purpose of this functionality is to
allow users to download as a spreadsheet the data they're already
seeing in the browser
I sincerely appreciate your interest, Dale, but I dont think I've
explained the task adequately enough perhaps.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> And my third post about embedding the style was correct.
>
>
>
>
>
> .forMike { color:red; background:#00FF99; }
>
>
>
>
>
>
> Just Guessing!
>
>
>
>
>
> I'm not sure what you tried, but it doesn't get much simpler than this.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Mike Kear
> Sent: Thursday, 14 September 2006 13:27 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
>
>
> Dale are you suggesting this based on what you have ACTUALLY done or
> what you think ought to be the case?
>
> Because as I said in my original posting, there are quire a few things
> I've tried without success.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> > Just embed the style tag
> >
> >
> > .myStyle color: #00;
> >
> >
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
>
>
>
>
> >
>
--
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Hi Mike If maintenance is the issue, cant you just have the style attribute a cf variable? Just a thought. cheers Drew -Original Message- From: "Mike Kear" <[EMAIL PROTECTED]> To: cfaussie@googlegroups.com Date: Thu, 14 Sep 2006 13:49:25 +1000 Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles > > Thanks, Dale, but as I've posted several times, I'm looking for a way > NOT to have to put the styles in every cell. I dont want to have to > do this: > > > > > #164677;border-top:2px solid #164677;padding:2px 3px 5px > 3px>There > > > > That's a nighmare to read, and pure hell to maintain. I would much > rather do this (which is smaller, cleaner, easier to maintain, and > easier to get consistency:. > > > > > Hello > There > > > > > I know it's possible , because I've seen it done but i cant remember > how. > > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > > On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > > > Mike, > > > > I don't waste my time guessing. My first post worked fine, you > haven't > > specified what you want to style other than cells or rows. But it > does work > > try this. > > > > > > > > > > Hello > > There > > > > > > > > Regards > > Dale Fraser > > > > http://dale.fraser.id.au > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
And my third post about embedding the style was correct.
.forMike { color:red; background:#00FF99; }
Just Guessing!
I'm not sure what you tried, but it doesn't get much simpler than this.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Thursday, 14 September 2006 13:27 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
Dale are you suggesting this based on what you have ACTUALLY done or
what you think ought to be the case?
Because as I said in my original posting, there are quire a few things
I've tried without success.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> Just embed the style tag
>
>
> .myStyle color: #00;
>
>
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
And my second post about looking at the Excel generated code was correct. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Thursday, 14 September 2006 13:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles Dale are you suggesting this based on what you have ACTUALLY done or what you think ought to be the case? Because as I said in my original posting, there are quire a few things I've tried without success. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Just embed the style tag > > > .myStyle color: #00; > > > > Regards > Dale Fraser > > http://dale.fraser.id.au > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Thanks, Dale, but as I've posted several times, I'm looking for a way NOT to have to put the styles in every cell. I dont want to have to do this: There That's a nighmare to read, and pure hell to maintain. I would much rather do this (which is smaller, cleaner, easier to maintain, and easier to get consistency:. Hello There I know it's possible , because I've seen it done but i cant remember how. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Mike, > > I don't waste my time guessing. My first post worked fine, you haven't > specified what you want to style other than cells or rows. But it does work > try this. > > > > > Hello > There > > > > Regards > Dale Fraser > > http://dale.fraser.id.au > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Mike, I don't waste my time guessing. My first post worked fine, you haven't specified what you want to style other than cells or rows. But it does work try this. Hello There Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Thursday, 14 September 2006 13:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles Dale are you suggesting this based on what you have ACTUALLY done or what you think ought to be the case? Because as I said in my original posting, there are quire a few things I've tried without success. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Just embed the style tag > > > .myStyle color: #00; > > > > Regards > Dale Fraser > > http://dale.fraser.id.au > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Apache & IIS running CF
Running Windows XP Professional. I just want to be able to run applications in Apache and IIS on the same development machine. I'm running port 80 so I if I need to change the port for Apache to port 81 then I will. I just want to use the same CF server. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Apache & IIS running CF
Download the ACME Guide and work you way through it. Nice, simple instructions :) http://www.stephencollins.org/acme/ Tom On 9/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: On Thu, Sep 14, 2006 at 03:20:32AM -, wrote:> Bored out of my friggin mind here. Anyway, just attempting to run > ColdFusion on Apache and ColdFusion. Can this be done?Yes. It works well.Depending on what OS, CF version and Apache version theCF installer might have problems setting the connector up. If that happens, do an install where you only select the internal(testing) CF webserver, then run the Apache connector installerafterwards.CheersPaul HaddonTechnical Services ManagerFormstar Print Technologies --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Apache & IIS running CF
On Thu, Sep 14, 2006 at 03:20:32AM -, wrote: > Bored out of my friggin mind here. Anyway, just attempting to run > ColdFusion on Apache and ColdFusion. Can this be done? Yes. It works well. Depending on what OS, CF version and Apache version the CF installer might have problems setting the connector up. If that happens, do an install where you only select the internal (testing) CF webserver, then run the Apache connector installer afterwards. Cheers Paul Haddon Technical Services Manager Formstar Print Technologies --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Dale are you suggesting this based on what you have ACTUALLY done or what you think ought to be the case? Because as I said in my original posting, there are quire a few things I've tried without success. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Just embed the style tag > > > .myStyle color: #00; > > > > Regards > Dale Fraser > > http://dale.fraser.id.au > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Just embed the style tag .myStyle color: #00; Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Thursday, 14 September 2006 13:21 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles Thats my problem too, Mark. How to embed it. I saw this too and thought it was pretty neat, and made the spreadsheet output look pretty spiffy. It used regular old CSS and therefore had all the power of a CSS style sheet. All i need to do is figure out how to embed the styles into teh spreadsheet. The technique only exports the table to the spreadsheet file, so the entire thing has to be inside the table tag. But i dont know how to include a spreadsheet inside a table tag. Anyone? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Mark Mandel <[EMAIL PROTECTED]> wrote: > > I always thought you could use regular old CSS, as long as you > embedded it in the document... > > I'm sure I did this before at a previous job... but now I can't remember... > > Mark > > On --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Thats my problem too, Mark. How to embed it. I saw this too and thought it was pretty neat, and made the spreadsheet output look pretty spiffy. It used regular old CSS and therefore had all the power of a CSS style sheet. All i need to do is figure out how to embed the styles into teh spreadsheet. The technique only exports the table to the spreadsheet file, so the entire thing has to be inside the table tag. But i dont know how to include a spreadsheet inside a table tag. Anyone? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/14/06, Mark Mandel <[EMAIL PROTECTED]> wrote: > > I always thought you could use regular old CSS, as long as you > embedded it in the document... > > I'm sure I did this before at a previous job... but now I can't remember... > > Mark > > On --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Apache & IIS running CF
Hi Guys, Bored out of my friggin mind here. Anyway, just attempting to run ColdFusion on Apache and ColdFusion. Can this be done? Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Outputting to Excel - how to incorporate styles
I always thought you could use regular old CSS, as long as you embedded it in the document... I'm sure I did this before at a previous job... but now I can't remember... Mark On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Just use normal html I think > > Ie > > > > Content > > > > What you can do is make the document you want in excel, then save it as html > then look at the code to see how it was done. > > Regards > Dale Fraser > > http://dale.fraser.id.au > > > > > > -Original Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Mike Kear > Sent: Thursday, 14 September 2006 13:04 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Outputting to Excel - how to incorporate styles > > > I'm outputting a report to excel spreadsheet, using the technique in > the CFDOCS - i.e. > > > > > and then assembling a table which is output to the spreadsheet. > > I remember seeing an app a couple of years ago that used this > technique and had a zillion styles applied, to make the spreadsheet > look pretty cool but now I cant figure out how it was done. > > Does anyone know how to apply styles to spreadsheet cells and/or whole > rows? I can apply styles in line cell by cell but i'd rather use > classes and/or IDs if possible. If my memory serves me right, the app > I saw used an external css sheet imported. > > Can anyone help please? > > oh and I've tried a few things wihtout success - e.g. > adding a
[cfaussie] Re: Outputting to Excel - how to incorporate styles
Just use normal html I think Ie Content What you can do is make the document you want in excel, then save it as html then look at the code to see how it was done. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Thursday, 14 September 2006 13:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Outputting to Excel - how to incorporate styles I'm outputting a report to excel spreadsheet, using the technique in the CFDOCS - i.e. and then assembling a table which is output to the spreadsheet. I remember seeing an app a couple of years ago that used this technique and had a zillion styles applied, to make the spreadsheet look pretty cool but now I cant figure out how it was done. Does anyone know how to apply styles to spreadsheet cells and/or whole rows? I can apply styles in line cell by cell but i'd rather use classes and/or IDs if possible. If my memory serves me right, the app I saw used an external css sheet imported. Can anyone help please? oh and I've tried a few things wihtout success - e.g. adding a
[cfaussie] Outputting to Excel - how to incorporate styles
I'm outputting a report to excel spreadsheet, using the technique in the CFDOCS - i.e. and then assembling a table which is output to the spreadsheet. I remember seeing an app a couple of years ago that used this technique and had a zillion styles applied, to make the spreadsheet look pretty cool but now I cant figure out how it was done. Does anyone know how to apply styles to spreadsheet cells and/or whole rows? I can apply styles in line cell by cell but i'd rather use classes and/or IDs if possible. If my memory serves me right, the app I saw used an external css sheet imported. Can anyone help please? oh and I've tried a few things wihtout success - e.g. adding a
[cfaussie] Re: createobject() class not found
Yeah, I suggested that for a reason, had the same problem myself in the past. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 14 September 2006 12:32 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Hi Dale, It would seem the readme instructions did not work.. but putting the jar file str8 into the lib directory and a restart did. Cheers, Adam -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 12:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam, Just put the .jar file into C:\CFusionMX7\lib\ Restart Coldfusion and you should be good. The com.blah package structure will be in the jar. A JAR being a zip file containing a directory structure of java goodies. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 14 September 2006 12:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Hi Mark, Frommy limited java knowledge, the code is expecting to get the java class from the jcraft web server. Im actually trying the implement the sftp.cfc (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip) An extract from the jcraft readme http://www.jcraft.com/jsch/README How To Try == This archive does not include java byte code, so please compile the source code by your self. $ cd jsch-?.?.?/src $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java com/jcraft/jzlib/*.java '/examples/' directory has included some samples to demonstrate what JSch can do. Please refer to '/examples/README' file. Cheers, Adam -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 11:55 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam - Have you moved the library into your ClassPath or anything of the like? Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi All, > > Can anyone tell me why this fails or where the java class would be? > > > > Error: > Object Instantiation Exception. > Class not found: com.jcraft.jsch.JSch > > > Here is the site it comes from.. > http://www.jcraft.com/jsch/index.html > > Cheers, > Adam > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Adam,
There is no difference. Just open the .jar with winzip and you will see that
com is just a folder etc.
Try it in the lib directory.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Adam Chapman
Sent: Thursday, 14 September 2006 12:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] createobject() class not found
Hi Mark,
I have done all that.. followed the sftp.cfc readme to the letter
1. Put the cfsftp.jar file on your web server.
2. In CFADMIN select Java and JVM from the server settings and add the
full
path to the cfsftp.jar file to the ColdFusion Class Path.
e.g. c:\cfsftp\cfsftp.jar
3. Restart ColdFusion server.
Then I get the error as described when calling the init() method of the
sftp.cfc
I have a fair bit of experience calling and using java with
createObject, but only with calls to classes..
output = createObject("java","java.io.FileOutputStream").init()
but not:
jsch = createobject('java',"com.jcraft.jsch.JSch")
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 12:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
You need to have your Java code in the ColdFusion classpath.
I would highly recommend picking up a Java book of some description
and getting to know the language a little bit more before continuing
down this road - it sounds like it might be painful :o(
Mark
On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
>
> Hi Mark,
>
> Frommy limited java knowledge, the code is expecting to get the java
> class from the jcraft web server.
>
> Im actually trying the implement the sftp.cfc
> (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip)
>
>
> An extract from the jcraft readme
> http://www.jcraft.com/jsch/README
>
> How To Try
> ==
> This archive does not include java byte code, so please compile
> the source code by your self.
> $ cd jsch-?.?.?/src
> $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java
> com/jcraft/jzlib/*.java
> '/examples/' directory has included some samples to demonstrate what
> JSch can do. Please refer to '/examples/README' file.
>
>
> Cheers,
> Adam
>
> -Original Message-
> From: Mark Mandel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 14 September 2006 11:55 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: createobject() class not found
>
>
> Adam -
>
> Have you moved the library into your ClassPath or anything of the
like?
>
> Mark
>
> On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
> >
> > Hi All,
> >
> > Can anyone tell me why this fails or where the java class would be?
> >
> >
> >
> > Error:
> > Object Instantiation Exception.
> > Class not found: com.jcraft.jsch.JSch
> >
> >
> > Here is the site it comes from..
> > http://www.jcraft.com/jsch/index.html
> >
> > Cheers,
> > Adam
> >
>
>
> >
>
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Hi Dale, It would seem the readme instructions did not work.. but putting the jar file str8 into the lib directory and a restart did. Cheers, Adam -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 12:14 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam, Just put the .jar file into C:\CFusionMX7\lib\ Restart Coldfusion and you should be good. The com.blah package structure will be in the jar. A JAR being a zip file containing a directory structure of java goodies. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 14 September 2006 12:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Hi Mark, Frommy limited java knowledge, the code is expecting to get the java class from the jcraft web server. Im actually trying the implement the sftp.cfc (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip) An extract from the jcraft readme http://www.jcraft.com/jsch/README How To Try == This archive does not include java byte code, so please compile the source code by your self. $ cd jsch-?.?.?/src $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java com/jcraft/jzlib/*.java '/examples/' directory has included some samples to demonstrate what JSch can do. Please refer to '/examples/README' file. Cheers, Adam -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 11:55 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam - Have you moved the library into your ClassPath or anything of the like? Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi All, > > Can anyone tell me why this fails or where the java class would be? > > > > Error: > Object Instantiation Exception. > Class not found: com.jcraft.jsch.JSch > > > Here is the site it comes from.. > http://www.jcraft.com/jsch/index.html > > Cheers, > Adam > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] createobject() class not found
Hi Mark,
I have done all that.. followed the sftp.cfc readme to the letter
1. Put the cfsftp.jar file on your web server.
2. In CFADMIN select Java and JVM from the server settings and add the
full
path to the cfsftp.jar file to the ColdFusion Class Path.
e.g. c:\cfsftp\cfsftp.jar
3. Restart ColdFusion server.
Then I get the error as described when calling the init() method of the
sftp.cfc
I have a fair bit of experience calling and using java with
createObject, but only with calls to classes..
output = createObject("java","java.io.FileOutputStream").init()
but not:
jsch = createobject('java',"com.jcraft.jsch.JSch")
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 12:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
You need to have your Java code in the ColdFusion classpath.
I would highly recommend picking up a Java book of some description
and getting to know the language a little bit more before continuing
down this road - it sounds like it might be painful :o(
Mark
On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
>
> Hi Mark,
>
> Frommy limited java knowledge, the code is expecting to get the java
> class from the jcraft web server.
>
> Im actually trying the implement the sftp.cfc
> (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip)
>
>
> An extract from the jcraft readme
> http://www.jcraft.com/jsch/README
>
> How To Try
> ==
> This archive does not include java byte code, so please compile
> the source code by your self.
> $ cd jsch-?.?.?/src
> $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java
> com/jcraft/jzlib/*.java
> '/examples/' directory has included some samples to demonstrate what
> JSch can do. Please refer to '/examples/README' file.
>
>
> Cheers,
> Adam
>
> -Original Message-
> From: Mark Mandel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 14 September 2006 11:55 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: createobject() class not found
>
>
> Adam -
>
> Have you moved the library into your ClassPath or anything of the
like?
>
> Mark
>
> On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
> >
> > Hi All,
> >
> > Can anyone tell me why this fails or where the java class would be?
> >
> >
> >
> > Error:
> > Object Instantiation Exception.
> > Class not found: com.jcraft.jsch.JSch
> >
> >
> > Here is the site it comes from..
> > http://www.jcraft.com/jsch/index.html
> >
> > Cheers,
> > Adam
> >
>
>
> >
>
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Adam, Just put the .jar file into C:\CFusionMX7\lib\ Restart Coldfusion and you should be good. The com.blah package structure will be in the jar. A JAR being a zip file containing a directory structure of java goodies. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 14 September 2006 12:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Hi Mark, Frommy limited java knowledge, the code is expecting to get the java class from the jcraft web server. Im actually trying the implement the sftp.cfc (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip) An extract from the jcraft readme http://www.jcraft.com/jsch/README How To Try == This archive does not include java byte code, so please compile the source code by your self. $ cd jsch-?.?.?/src $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java com/jcraft/jzlib/*.java '/examples/' directory has included some samples to demonstrate what JSch can do. Please refer to '/examples/README' file. Cheers, Adam -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 11:55 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam - Have you moved the library into your ClassPath or anything of the like? Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi All, > > Can anyone tell me why this fails or where the java class would be? > > > > Error: > Object Instantiation Exception. > Class not found: com.jcraft.jsch.JSch > > > Here is the site it comes from.. > http://www.jcraft.com/jsch/index.html > > Cheers, > Adam > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
I thought Adobe's support for CFEclipse was pretty common knowledge - what about all the CFEclipse plugins they've distributed with 702 for starters? It got a lot of coverage at webDu with both Dean Harmon and Rob Rohan there... __ Robin Hilliard On 14/09/2006, at 10:07 AM, Barry Beattie wrote: > Adobe (and Macromedia before) make IDE's for a living. However (AFAIK) > only New Atlanta have given any support to Mark Drew and Rob Rohan for > CFEclipse. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
You need to have your Java code in the ColdFusion classpath. I would highly recommend picking up a Java book of some description and getting to know the language a little bit more before continuing down this road - it sounds like it might be painful :o( Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi Mark, > > Frommy limited java knowledge, the code is expecting to get the java > class from the jcraft web server. > > Im actually trying the implement the sftp.cfc > (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip) > > > An extract from the jcraft readme > http://www.jcraft.com/jsch/README > > How To Try > == > This archive does not include java byte code, so please compile > the source code by your self. > $ cd jsch-?.?.?/src > $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java > com/jcraft/jzlib/*.java > '/examples/' directory has included some samples to demonstrate what > JSch can do. Please refer to '/examples/README' file. > > > Cheers, > Adam > > -Original Message- > From: Mark Mandel [mailto:[EMAIL PROTECTED] > Sent: Thursday, 14 September 2006 11:55 AM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: createobject() class not found > > > Adam - > > Have you moved the library into your ClassPath or anything of the like? > > Mark > > On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > > > Hi All, > > > > Can anyone tell me why this fails or where the java class would be? > > > > > > > > Error: > > Object Instantiation Exception. > > Class not found: com.jcraft.jsch.JSch > > > > > > Here is the site it comes from.. > > http://www.jcraft.com/jsch/index.html > > > > Cheers, > > Adam > > > > > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Hi Mark, Frommy limited java knowledge, the code is expecting to get the java class from the jcraft web server. Im actually trying the implement the sftp.cfc (http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip) An extract from the jcraft readme http://www.jcraft.com/jsch/README How To Try == This archive does not include java byte code, so please compile the source code by your self. $ cd jsch-?.?.?/src $ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java com/jcraft/jzlib/*.java '/examples/' directory has included some samples to demonstrate what JSch can do. Please refer to '/examples/README' file. Cheers, Adam -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 September 2006 11:55 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: createobject() class not found Adam - Have you moved the library into your ClassPath or anything of the like? Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi All, > > Can anyone tell me why this fails or where the java class would be? > > > > Error: > Object Instantiation Exception. > Class not found: com.jcraft.jsch.JSch > > > Here is the site it comes from.. > http://www.jcraft.com/jsch/index.html > > Cheers, > Adam > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Adam - Have you moved the library into your ClassPath or anything of the like? Mark On 9/14/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi All, > > Can anyone tell me why this fails or where the java class would be? > > > > Error: > Object Instantiation Exception. > Class not found: com.jcraft.jsch.JSch > > > Here is the site it comes from.. > http://www.jcraft.com/jsch/index.html > > Cheers, > Adam > > > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] createobject() class not found
Hi All, Can anyone tell me why this fails or where the java class would be? Error: Object Instantiation Exception. Class not found: com.jcraft.jsch.JSch Here is the site it comes from.. http://www.jcraft.com/jsch/index.html Cheers, Adam --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
thanx Charlie, I did see the post but too late. I will definately give it a whirl when I reach a hiatus in my work later today. I read some pearls of wisdom somewhere tho, that may also apply to, ahem, ColdFusion IDE's. "As a commercial product, you can also take consolation that it will indeed work as advertised and if it doesn't that there will be a company behind it to help support, improve, and evangelize it." couldn't have said it better me'self. Joel: Railo, yes but surprised how far they've got since I last looked and astounded by the existance of others On 9/14/06, Charlie Arehart <[EMAIL PROTECTED]> wrote: > > I don't want to sound like a broken record, but since it's unclear if Barry > has seen or will see the note I'd sent an hour or so before his, I'll say > again that there is indeed interactive step debugging for CFML now, in > FusionDebug, albeit it's not from Adobe and it's not for free (though it is > based on Eclipse). The question of whether Adobe should provide such instead > is a whole other discussion, of course, some of which you've addressed below > and your later note. Just want to make sure that those calling for debugging > know that it is indeed now available. > > /charlie > http://www.carehart.org/blog/ > > -Original Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Barry Beattie > Sent: Wednesday, September 13, 2006 6:39 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: Why buy into CF? > > > to tie these comments back to the thread title, I really hope that this is > more than some lame thread-watching tool. > > I'm continually impressed with VisualStudio.NET's debugging. > breakpoints, line-by-line code execution, watching variables - anywhere in > the code - even being able to drill down thru complex datasets or > child-of-child-of-child objects. > > and before ppl say that ASP.NET and CF work differently, they're actually a > lot similar than you'd expect. Ya gotta admit - for all their faults and > failings, Microsoft makes damn decent developer tools. For years SQLServer's > Enterprise Mgr/QueryAnalyser was *the* standard set. the db tools in VS.NET > are even better (for coders, not necesarily DBA's) > > Where's the ColdFusion IDE that does that? I sure hope it's comming with > either CF8 or Studio9 (or whatever Flash+Dreamwaever will be bundled with). > I appreciate CFEclipse and Mark and Rob's efforts but I want more. > > Sure, you can get close by adding other plug-ins to Eclipse (QuantumDB, etc) > but both in key areas (eg debugging) and refinements, there's still lots of > catch-up (I admit source control is an area VS.NET loses on but unlike > debugging, that can be worked around). > > And why the heck is it left to a bunch of hard-working open-source > developers to create an IDE for a commercial prodct? What's the parent > company doing - sitting on it's hands? Macromedia, Adobe - both companies > that make a living creating IDE's... wot? they don't know how to do it? The > official IDE is *still* Homesite. > > It seems it comes down CF market share. Return on investment. But what about > belief in one's stable of products and provide the tools to use them? does > that have value? > > If there is a new CF IDE comming out from Adobe soon, I just hope it's the > bees-knees. With exellent in-editor debugging. > > I expect nothing less. It is, after all, the standard the competition is at. > I wait with abated breath... > > > > > On 9/13/06, Shane Farmer <[EMAIL PROTECTED]> wrote: > > > > > > > > On 9/13/06, M@ Bourke <[EMAIL PROTECTED]> > > wrote: > > > > > > he wouldn't elaborate to much on it but it seemed to be pretty much > > > that, > > he did also mention you'll be able to see/monitor all threads running > > and kill them etc, as well as open up cf more and see what exactly is > > happening under the hood and what you'll be able to tell from it > > > > > > > > Java 5 lets you do this (JConsole). We have to do this with Tomcat > > some times... it seems once you give Tomcat some memory, it really > > doesn't like giving it back until you make it! This could point us in > > the direction of future releases of CF running on Java 5 or maybe even > > Java 6 (which should be released soon). > > > > Leads into another interesting idea of attaching a Java debugger to > > the VM, but unless it is done like JSP is, you wont be able to step > > through the CF code (I know WebMacro can't be done like that). Maybe > > that is one direction that could be explored... its late and I really have > to stop day dreaming. > > It probably has been explored and found to not be feasable > > > > > > Shane > > > > > > > > > > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For m
[cfaussie] Re: Why buy into CF?
Has anyone ever seen this? http://www.ignitefusion.com/ Or this http://www.railo.ch/en/index.cfm?treeID=105 Or this http://www.pcaonline.com/prod/index.cfm?loc=coral Lots of CF clones out there.. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
I don't want to sound like a broken record, but since it's unclear if Barry has seen or will see the note I'd sent an hour or so before his, I'll say again that there is indeed interactive step debugging for CFML now, in FusionDebug, albeit it's not from Adobe and it's not for free (though it is based on Eclipse). The question of whether Adobe should provide such instead is a whole other discussion, of course, some of which you've addressed below and your later note. Just want to make sure that those calling for debugging know that it is indeed now available. /charlie http://www.carehart.org/blog/ -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, September 13, 2006 6:39 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Why buy into CF? to tie these comments back to the thread title, I really hope that this is more than some lame thread-watching tool. I'm continually impressed with VisualStudio.NET's debugging. breakpoints, line-by-line code execution, watching variables - anywhere in the code - even being able to drill down thru complex datasets or child-of-child-of-child objects. and before ppl say that ASP.NET and CF work differently, they're actually a lot similar than you'd expect. Ya gotta admit - for all their faults and failings, Microsoft makes damn decent developer tools. For years SQLServer's Enterprise Mgr/QueryAnalyser was *the* standard set. the db tools in VS.NET are even better (for coders, not necesarily DBA's) Where's the ColdFusion IDE that does that? I sure hope it's comming with either CF8 or Studio9 (or whatever Flash+Dreamwaever will be bundled with). I appreciate CFEclipse and Mark and Rob's efforts but I want more. Sure, you can get close by adding other plug-ins to Eclipse (QuantumDB, etc) but both in key areas (eg debugging) and refinements, there's still lots of catch-up (I admit source control is an area VS.NET loses on but unlike debugging, that can be worked around). And why the heck is it left to a bunch of hard-working open-source developers to create an IDE for a commercial prodct? What's the parent company doing - sitting on it's hands? Macromedia, Adobe - both companies that make a living creating IDE's... wot? they don't know how to do it? The official IDE is *still* Homesite. It seems it comes down CF market share. Return on investment. But what about belief in one's stable of products and provide the tools to use them? does that have value? If there is a new CF IDE comming out from Adobe soon, I just hope it's the bees-knees. With exellent in-editor debugging. I expect nothing less. It is, after all, the standard the competition is at. I wait with abated breath... On 9/13/06, Shane Farmer <[EMAIL PROTECTED]> wrote: > > > > On 9/13/06, M@ Bourke <[EMAIL PROTECTED]> > wrote: > > > > he wouldn't elaborate to much on it but it seemed to be pretty much > > that, > he did also mention you'll be able to see/monitor all threads running > and kill them etc, as well as open up cf more and see what exactly is > happening under the hood and what you'll be able to tell from it > > > > Java 5 lets you do this (JConsole). We have to do this with Tomcat > some times... it seems once you give Tomcat some memory, it really > doesn't like giving it back until you make it! This could point us in > the direction of future releases of CF running on Java 5 or maybe even > Java 6 (which should be released soon). > > Leads into another interesting idea of attaching a Java debugger to > the VM, but unless it is done like JSP is, you wont be able to step > through the CF code (I know WebMacro can't be done like that). Maybe > that is one direction that could be explored... its late and I really have to stop day dreaming. > It probably has been explored and found to not be feasable > > > Shane > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
just to be clear here - four points: Adobe CF (and BD for that matter) is a commercial product, not opensource. the CF marketshare is too small/fragile to leave support of the platform (tools) to outside sources... for a commercial product (why do I care? if the tools are inadequate, no one will want to use it) Adobe (and Macromedia before) make IDE's for a living. However (AFAIK) only New Atlanta have given any support to Mark Drew and Rob Rohan for CFEclipse. IMHO, the comparison of ASP.NET IDE's and CF's is more valid than with PHP or Ruby. They both create a revenue stream for the parent company, ensuring (hopefully) it's longevity. or is the CF community comfortable with this situation? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Coldfusion Server problems
My colleague says:" Hi Scott, This turned out to be a corruption of the $CF_HOME/lib/license.properties file. When replaced with a valid file, the server started processing CF pages again. Thanks for you help , and can you please thank all on CF Aussie who offerred assistance. Cheers, Phil. " --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: ZeroOne Community Talks - Flex 2.0 UI components
Chris Velevitch wrote: > http://zeroone.partner.breezecentral.com/p58922012/ > > Chris I did end up getting David's email after the presentation finished... It's just very strange that the email before the presentation never arrived :S Oh well, maybe next time. --- Hi, You can find the recording of the 'Flex 2.0 UI components' presentation here: http://zeroone.partner.breezecentral.com/p58922012/ Thank you for joining the Breeze meeting. Regards, David --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
to tie these comments back to the thread title, I really hope that this is more than some lame thread-watching tool. I'm continually impressed with VisualStudio.NET's debugging. breakpoints, line-by-line code execution, watching variables - anywhere in the code - even being able to drill down thru complex datasets or child-of-child-of-child objects. and before ppl say that ASP.NET and CF work differently, they're actually a lot similar than you'd expect. Ya gotta admit - for all their faults and failings, Microsoft makes damn decent developer tools. For years SQLServer's Enterprise Mgr/QueryAnalyser was *the* standard set. the db tools in VS.NET are even better (for coders, not necesarily DBA's) Where's the ColdFusion IDE that does that? I sure hope it's comming with either CF8 or Studio9 (or whatever Flash+Dreamwaever will be bundled with). I appreciate CFEclipse and Mark and Rob's efforts but I want more. Sure, you can get close by adding other plug-ins to Eclipse (QuantumDB, etc) but both in key areas (eg debugging) and refinements, there's still lots of catch-up (I admit source control is an area VS.NET loses on but unlike debugging, that can be worked around). And why the heck is it left to a bunch of hard-working open-source developers to create an IDE for a commercial prodct? What's the parent company doing - sitting on it's hands? Macromedia, Adobe - both companies that make a living creating IDE's... wot? they don't know how to do it? The official IDE is *still* Homesite. It seems it comes down CF market share. Return on investment. But what about belief in one's stable of products and provide the tools to use them? does that have value? If there is a new CF IDE comming out from Adobe soon, I just hope it's the bees-knees. With exellent in-editor debugging. I expect nothing less. It is, after all, the standard the competition is at. I wait with abated breath... On 9/13/06, Shane Farmer <[EMAIL PROTECTED]> wrote: > > > > On 9/13/06, M@ Bourke <[EMAIL PROTECTED]> > wrote: > > > > he wouldn't elaborate to much on it but it seemed to be pretty much that, > he did also mention you'll be able to see/monitor all threads running and > kill them etc, as well as open up cf more and see what exactly is happening > under the hood and what you'll be able to tell from it > > > > Java 5 lets you do this (JConsole). We have to do this with Tomcat some > times... it seems once you give Tomcat some memory, it really doesn't like > giving it back until you make it! This could point us in the direction of > future releases of CF running on Java 5 or maybe even Java 6 (which should > be released soon). > > Leads into another interesting idea of attaching a Java debugger to the VM, > but unless it is done like JSP is, you wont be able to step through the CF > code (I know WebMacro can't be done like that). Maybe that is one direction > that could be explored... its late and I really have to stop day dreaming. > It probably has been explored and found to not be feasable > > > Shane > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
I emailed Guiness Book of Records, they'll get back to me with regards to this being the longest thread. That's OK, Scott. It is good to hear I am not the only one into CF on this list who is committed to moving into high-paying jobs with ambiguous position titles. "Programmer" seems so routine (pun intended). Chad who is loving Brisbane, due largely to the incredible generosity of a few select people On 9/13/06, Scott Barnes <[EMAIL PROTECTED]> wrote: > > Its true.. > > I sit here daily thinking about how life in CF/FLEX programming was so damn > sweet. Now days, i spend most of my time in meetings, talking about what I'd > like to do with the two brands under my charge, yet can't quite execute them > due to some crap about governance or red tape here and there. So, i continue > on my week, simply talking and discussing things that have no outcome or > cost benefit realisation. > > Its funny at times, i have roughly around $20million in projects that I'm in > charge of, but they are simply "virtual" - ie nothing yet been done. It > feels like Dilbert most days, I go "I've come up with a great piece of > software, but first check out the box it comes in.. it has holograms, and > and bright colors etc"... and then dilbert goes "But sir.. we haven't yet > created the software" then i'd have to go "Have i not shown you the > box". > > Life was much simpler being a programmer, you had a rule book and you did > the doing... being a manager, you tend to have to delegate the doing and > hope the doing gets done and when it is done you turn and go "Is that > it?...thats what i just signed off 10k for? ... man, i'd like to grab the > CFAUSSIE crew in on this, get them to do the job(s) and buy all bigscreen > tv's with money left over!!!" > > I rant... > > The humour in this one post is - As i typed, I had my Outlook spring two > meeting reminders, turns out i'm double booked... dear god, i am going to > snap soon ;) hehe. > > Scott Out. > Working in the Govt has taught me one thing, Accountability is like a > Unicorn, I hear it exists and its magical, but yet to see it first hand. > > On 9/13/06, Barry Beattie <[EMAIL PROTECTED]> wrote: > > > > good on yer, M@ > > > he did mention a lot more print advertising as well as event advertising > etc > > I'd be very keen to see cf8 before stepping away from it > > encouragement at last! > > I hope the knobs at Adobe realise some of the best advertising is > free: next time an Adobe bigwig gives an interview to tech press, CF > gets an honerable mention when the names Flash, Flex, LiveCycle, etc > are rattled off... > > cheers > barry.b > > PS: Give up, Barnes. No one takes you seriously anymore now that > you've moved into the realm of pointy-haired types...with _nothing_ to > do with web solutions(just joking!) > > > -- > Regards, > Scott Barnes > http://www.mossyblog.com > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] step debugging in CFML with FusionDebug (was RE: [cfaussie] Re: Why buy into CF?)
Shane, you can indeed "attach a debugger" to CFMX (using Eclipse, as Haikal Saadh requested yesterday). That's exactly what FusionDebug is (fusiondebug.com). No, it's not free, but it's because as you hint CFMX is not "done like JSPs", so the company (Intergral) had to go through some hoops to get it all working. Still, for less than 300 US (with an additional 10% discount if you use CFCOMMUNITY as a code), it is indeed the very interactive debugging that many have long wanted. I do realize that there are many who don't think much of step debuggers at all. Let's not open that discussion here. For more on FusionDebug, as well as my take on why people should be interested (and back and forth comments from others who don't care for debuggers, and my rebuttal of 13 benefits of it over using CFDUMP/CFOUTPUT), see my (currently 3-part) series of blog entries at: http://carehart.org/blog/client/index.cfm/fusiondebug /charlie http://www.carehart.org/blog/ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shane FarmerSent: Wednesday, September 13, 2006 9:14 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Why buy into CF? On 9/13/06, M@ Bourke <[EMAIL PROTECTED]> wrote: he wouldn't elaborate to much on it but it seemed to be pretty much that, he did also mention you'll be able to see/monitor all threads running and kill them etc, as well as open up cf more and see what exactly is happening under the hood and what you'll be able to tell from it Java 5 lets you do this (JConsole). We have to do this with Tomcat some times... it seems once you give Tomcat some memory, it really doesn't like giving it back until you make it! This could point us in the direction of future releases of CF running on Java 5 or maybe even Java 6 (which should be released soon). Leads into another interesting idea of attaching a Java debugger to the VM, but unless it is done like JSP is, you wont be able to step through the CF code (I know WebMacro can't be done like that). Maybe that is one direction that could be explored... its late and I really have to stop day dreaming. It probably has been explored and found to not be feasable Shane --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Why buy into CF?
On 9/13/06, M@ Bourke <[EMAIL PROTECTED]> wrote: he wouldn't elaborate to much on it but it seemed to be pretty much that, he did also mention you'll be able to see/monitor all threads running and kill them etc, as well as open up cf more and see what exactly is happening under the hood and what you'll be able to tell from it Java 5 lets you do this (JConsole). We have to do this with Tomcat some times... it seems once you give Tomcat some memory, it really doesn't like giving it back until you make it! This could point us in the direction of future releases of CF running on Java 5 or maybe even Java 6 (which should be released soon). Leads into another interesting idea of attaching a Java debugger to the VM, but unless it is done like JSP is, you wont be able to step through the CF code (I know WebMacro can't be done like that). Maybe that is one direction that could be explored... its late and I really have to stop day dreaming. It probably has been explored and found to not be feasable Shane --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Querying across multiple databases
Nothing wrong with cross-database joins - heaps quicker than a QofQ. On 13/09/06, Barry Beattie <[EMAIL PROTECTED]> wrote: > > Thanx Rod > > well, bugger me, it worked! > > > SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID, > INST.AbsoluteSerialNum > FROM evaluationsQuizDev.dbo.tbl_Quiz_Schedule AS SCHED INNER JOIN > tbl_InstrumentReleased AS INST ON > INST.OnlineQuizID = SCHED.Quiz_ID > > > > > I suppose it'd crash'n'burn if the username/password was changed per > database, not just logon to the db server...yes? > > thanx again > b > > > > > > > On 9/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Are the databases on the same sql server? If so you can simply include the > > database name as part of the query. > > > > ie .. > > > > > > > > Hi all > > > > > > I think I remember a post on this before but I can't find it anywhere. > > > > > > the app I'm extending uses 2 databases (2 diff DSN's). I now need to > > > pull in data from both into the same recordset. > > > > > > eg: > > > > > > SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID, > > > INST.AbsoluteSerialNum > > > FROM tbl_Quiz_Schedule AS SCHED INNER JOIN > > > evaluations.dbo.tbl_InstrumentReleased AS INST > > > ON INST.OnlineQuizID = SCHED.Quiz_ID > > > > > > I could: > > > - use Query'o'query to combine 2 seperate queries into one (too much > > > irrelivant data) > > > - put the SQL onto one of the DB's as a SProc (back-up plan) > > > - work out how to join the two databases within the same CFQUERY > > > (preferred) > > > > > > any suggestions? > > > thanx > > > barry.b > > > > > > > > > > > > > > > > > > > > > > > > > -- Darryl http://www.acheron.org/darryl/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
