[cfaussie] Re: Querying across multiple databases

2006-09-13 Thread darryl lyons
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! cfquery name=qry datasource=FOUREX SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID, INST.AbsoluteSerialNum FROM

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Shane Farmer
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

[cfaussie] step debugging in CFML with FusionDebug (was RE: [cfaussie] Re: Why buy into CF?)

2006-09-13 Thread Charlie Arehart
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

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Barry Beattie
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

[cfaussie] Re: ZeroOne Community Talks - Flex 2.0 UI components

2006-09-13 Thread Justin Carter
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,

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Barry Beattie
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

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Charlie Arehart
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

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Barry Beattie
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

[cfaussie] createobject() class not found

2006-09-13 Thread Adam Chapman
Hi All, Can anyone tell me why this fails or where the java class would be? cfset jsch = createobject('java',com.jcraft.jsch.JSch) / 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,

[cfaussie] Re: createobject() class not found

2006-09-13 Thread Adam Chapman
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

[cfaussie] Re: createobject() class not found

2006-09-13 Thread Mark Mandel
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

[cfaussie] Re: Why buy into CF?

2006-09-13 Thread Robin Hilliard
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,

[cfaussie] createobject() class not found

2006-09-13 Thread Adam Chapman
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

[cfaussie] Re: createobject() class not found

2006-09-13 Thread Adam Chapman
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

[cfaussie] Re: createobject() class not found

2006-09-13 Thread Dale Fraser
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

[cfaussie] Re: createobject() class not found

2006-09-13 Thread Dale Fraser
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] Outputting to Excel - how to incorporate styles

2006-09-13 Thread Mike Kear
I'm outputting a report to excel spreadsheet, using the technique in the CFDOCS - i.e. cfcontent type=application/vnd.ms-excel cfheader name=Content-Disposition value=attachment; filename=#outputfilename# and then assembling a table which is output to the spreadsheet. I remember seeing an app

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Mark Mandel
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 table border=1 tr

[cfaussie] Apache IIS running CF

2006-09-13 Thread cfgroupie
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

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Mike Kear
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

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Dale Fraser
Just embed the style tag style .myStyle color: #00; /style 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] Re: Apache IIS running CF

2006-09-13 Thread cfgroupie
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

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Dale Fraser
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. cfcontent type=application/vnd.ms-excel table border=1 tr td bgcolor=#CCHello/td td

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Mike Kear
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: cfcontent type=application/vnd.ms-excel table border=1 tr td style=border-bottom:1px solid #164677;border-top:2px solid

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Dale Fraser
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] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Dale Fraser
And my third post about embedding the style was correct. cfcontent type=application/vnd.ms-excel html head style .forMike { color:red; background:#00FF99; } /style /head body table

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread skateboard.com.au
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

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Mike Kear
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

[cfaussie] Re: Outputting to Excel - how to incorporate styles

2006-09-13 Thread Blair McKenzie
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