[cfaussie] Coldfusion Server problems

2006-09-12 Thread Scott Thornton

services are running.

machine has been rebooted a couple of times.


 [EMAIL PROTECTED] 12/09/2006 3:56 pm 
Check the services running on the machine and make sure that the ColdFusion
ones have restarted.

Blair

On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote:


 A colleague of mine writes:
 

 Hi All,

 I have an intranet site that went down due to a power outage, and now no
 matter what I do it will not serve cfm pages.
 IIS will serve a text file, or jpg image, but any cfm pages come back with
 just an empty page.

 CFM Pages come back without any errors, but blank. The view source for
 these pages is just

 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META http-equiv=Content-Type content=text/html;
 charset=windows-1252/HEAD
 BODY/BODY/HTML


 Have looked through IIS, and can't find any glaring issues.

 Have tried using the Web Server Configuration tool to remove and
 reconfigure the web site as Server Name, IIS, ALL.

 Short of reinstalling CFMX, I am out of ideas.

 Any help appreciated.

 Thanks,
 

 Scott Thornton, Programmer
 Application Development
 Information Services and Telecommunications
 Hunter-New England Area Health Service
 p: +61 02 49213589
 m: 0413800242



 





--~--~-~--~~~---~--~~
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

2006-09-12 Thread Joel Cass

This looks like the generic page created by IE when a server cannopt be
contacted

Try accessing the site in a non-MS browser - you may get a different page

Or try using telnet, or more easily wget to view the actual result

We had this same issue but it turned out to be the cryptic 503 error
mentioned earlier. Could only find this out by examining the http headers

Joel

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Scott Thornton
Sent: Tuesday, 12 September 2006 3:35 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Coldfusion Server problems



A colleague of mine writes:


Hi All,

I have an intranet site that went down due to a power outage, and now no
matter what I do it will not serve cfm pages.
IIS will serve a text file, or jpg image, but any cfm pages come back with
just an empty page.

CFM Pages come back without any errors, but blank. The view source for these
pages is just

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type content=text/html;
charset=windows-1252/HEAD
BODY/BODY/HTML


Have looked through IIS, and can't find any glaring issues.

Have tried using the Web Server Configuration tool to remove and reconfigure
the web site as Server Name, IIS, ALL.

Short of reinstalling CFMX, I am out of ideas.

Any help appreciated.

Thanks,


Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
p: +61 02 49213589
m: 0413800242








--~--~-~--~~~---~--~~
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] Coldfusion Server problems

2006-09-12 Thread Scott Thornton

thanks,

do you think that is different from an ordinary reboot, which has been 
performed?

 [EMAIL PROTECTED] 12/09/2006 4:28 pm 
Try stopping all of the ColdFusion Services, then reboot.




On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote:


 Hmm, In Firefox the page tries to download (like a file).

 The cfm page when opened in notepad is empty.

 Strange.



  [EMAIL PROTECTED] 12/09/2006 4:00 pm 

 This looks like the generic page created by IE when a server cannopt be
 contacted

 Try accessing the site in a non-MS browser - you may get a different page

 Or try using telnet, or more easily wget to view the actual result

 We had this same issue but it turned out to be the cryptic 503 error
 mentioned earlier. Could only find this out by examining the http headers

 Joel

 -Original Message-
 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] 
 Behalf Of Scott Thornton
 Sent: Tuesday, 12 September 2006 3:35 PM
 To: cfaussie@googlegroups.com 
 Subject: [cfaussie] Coldfusion Server problems



 A colleague of mine writes:
 

 Hi All,

 I have an intranet site that went down due to a power outage, and now no
 matter what I do it will not serve cfm pages.
 IIS will serve a text file, or jpg image, but any cfm pages come back with
 just an empty page.

 CFM Pages come back without any errors, but blank. The view source for
 these
 pages is just

 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META http-equiv=Content-Type content=text/html;
 charset=windows-1252/HEAD
 BODY/BODY/HTML


 Have looked through IIS, and can't find any glaring issues.

 Have tried using the Web Server Configuration tool to remove and
 reconfigure
 the web site as Server Name, IIS, ALL.

 Short of reinstalling CFMX, I am out of ideas.

 Any help appreciated.

 Thanks,
 

 Scott Thornton, Programmer
 Application Development
 Information Services and Telecommunications
 Hunter-New England Area Health Service
 p: +61 02 49213589
 m: 0413800242











 





--~--~-~--~~~---~--~~
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

2006-09-12 Thread David Pietersen
If a file somewhere is locked, or some other weirdness related to the loss of power is occurring, by shutting down the services then rebooting you might give Windows a chance to clean up after itself.

The problem could bewith IIS, or in the underlying JRE, but is probably a locked file somewhere. Not that I am an expert or anything.


On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote:
thanks,do you think that is different from an ordinary reboot, which has been performed?
 [EMAIL PROTECTED] 12/09/2006 4:28 pm Try stopping all of the ColdFusion Services, then reboot.On 9/12/06, Scott Thornton 
[EMAIL PROTECTED] wrote: Hmm, In Firefox the page tries to download (like a file). The cfm page when opened in notepad is empty.
 Strange.  [EMAIL PROTECTED] 12/09/2006 4:00 pm  This looks like the generic page created by IE when a server cannopt be
 contacted Try accessing the site in a non-MS browser - you may get a different page Or try using telnet, or more easily wget to view the actual result We had this same issue but it turned out to be the cryptic 503 error
 mentioned earlier. Could only find this out by examining the http headers Joel -Original Message- From: cfaussie@googlegroups.com
 [mailto:cfaussie@googlegroups.com]On Behalf Of Scott Thornton Sent: Tuesday, 12 September 2006 3:35 PM To: 
cfaussie@googlegroups.com Subject: [cfaussie] Coldfusion Server problems A colleague of mine writes:  Hi All, I have an intranet site that went down due to a power outage, and now no
 matter what I do it will not serve cfm pages. IIS will serve a text file, or jpg image, but any cfm pages come back with just an empty page. CFM Pages come back without any errors, but blank. The view source for
 these pages is just !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html;
 charset=windows-1252/HEAD BODY/BODY/HTML Have looked through IIS, and can't find any glaring issues. Have tried using the Web Server Configuration tool to remove and
 reconfigure the web site as Server Name, IIS, ALL. Short of reinstalling CFMX, I am out of ideas. Any help appreciated. Thanks,  Scott Thornton, Programmer
 Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242
 

--~--~-~--~~~---~--~~
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

2006-09-12 Thread Dale Fraser

No it's not.

I'd say your missing your connector for CF in IIS.

Check to see if there is one

Home Directory, Configuration.

Make sure .cfm has an entry it should be pointing to.

C:\CFusionMX7\runtime\lib\wsconfig\jrun_iis6.dll

Regards
Dale Fraser

http://dale.fraser.id.au


 

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Tuesday, 12 September 2006 16:31 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Coldfusion Server problems


thanks,

do you think that is different from an ordinary reboot, which has been
performed?

 [EMAIL PROTECTED] 12/09/2006 4:28 pm 
Try stopping all of the ColdFusion Services, then reboot.




On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote:


 Hmm, In Firefox the page tries to download (like a file).

 The cfm page when opened in notepad is empty.

 Strange.



  [EMAIL PROTECTED] 12/09/2006 4:00 pm 

 This looks like the generic page created by IE when a server cannopt be
 contacted

 Try accessing the site in a non-MS browser - you may get a different page

 Or try using telnet, or more easily wget to view the actual result

 We had this same issue but it turned out to be the cryptic 503 error
 mentioned earlier. Could only find this out by examining the http headers

 Joel

 -Original Message-
 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] 
 Behalf Of Scott Thornton
 Sent: Tuesday, 12 September 2006 3:35 PM
 To: cfaussie@googlegroups.com 
 Subject: [cfaussie] Coldfusion Server problems



 A colleague of mine writes:
 

 Hi All,

 I have an intranet site that went down due to a power outage, and now no
 matter what I do it will not serve cfm pages.
 IIS will serve a text file, or jpg image, but any cfm pages come back with
 just an empty page.

 CFM Pages come back without any errors, but blank. The view source for
 these
 pages is just

 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
 HTMLHEAD
 META http-equiv=Content-Type content=text/html;
 charset=windows-1252/HEAD
 BODY/BODY/HTML


 Have looked through IIS, and can't find any glaring issues.

 Have tried using the Web Server Configuration tool to remove and
 reconfigure
 the web site as Server Name, IIS, ALL.

 Short of reinstalling CFMX, I am out of ideas.

 Any help appreciated.

 Thanks,
 

 Scott Thornton, Programmer
 Application Development
 Information Services and Telecommunications
 Hunter-New England Area Health Service
 p: +61 02 49213589
 m: 0413800242











 








--~--~-~--~~~---~--~~
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

2006-09-12 Thread Joel Cass

There could be an issue with your connectors, since you can get non-cf pages

You can try using the wsconfig (/bin/wsconfig.exe or
/runtime/lib/wsconfig.jar) utility to remove and reinstall the connectors,
just make sure IIS and CF are stopped first.

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Scott Thornton
Sent: Tuesday, 12 September 2006 4:25 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Coldfusion Server problems



Hmm, In Firefox the page tries to download (like a file).

The cfm page when opened in notepad is empty.

Strange.



 [EMAIL PROTECTED] 12/09/2006 4:00 pm 

This looks like the generic page created by IE when a server cannopt be
contacted

Try accessing the site in a non-MS browser - you may get a different page

Or try using telnet, or more easily wget to view the actual result

We had this same issue but it turned out to be the cryptic 503 error
mentioned earlier. Could only find this out by examining the http headers

Joel

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Scott Thornton
Sent: Tuesday, 12 September 2006 3:35 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Coldfusion Server problems



A colleague of mine writes:


Hi All,

I have an intranet site that went down due to a power outage, and now no
matter what I do it will not serve cfm pages.
IIS will serve a text file, or jpg image, but any cfm pages come back with
just an empty page.

CFM Pages come back without any errors, but blank. The view source for these
pages is just

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type content=text/html;
charset=windows-1252/HEAD
BODY/BODY/HTML


Have looked through IIS, and can't find any glaring issues.

Have tried using the Web Server Configuration tool to remove and reconfigure
the web site as Server Name, IIS, ALL.

Short of reinstalling CFMX, I am out of ideas.

Any help appreciated.

Thanks,


Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
p: +61 02 49213589
m: 0413800242
















--~--~-~--~~~---~--~~
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

2006-09-12 Thread ACTCFUG

Or certain crucial files have been corrupted meaning a re-install is a
possibility. Of course you have backed up crucial data?


--~--~-~--~~~---~--~~
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: Compressing the output to the browser via CF

2006-09-12 Thread Dale Fraser








Andrew,



Interesting concept, be interesting to do some
metrics on speed etc.



Gives me another idea.



Regards
Dale Fraser

http://dale.fraser.id.au











From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Scott
Sent: Tuesday, 12 September 2006
3:06 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
Compressing the output to the browser via CF





Mark, thanks I was just about to switch
them thanks.









Senior Coldfusion Developer

Aegeon Pty. Ltd.

www.aegeon.com.au

Phone:+613 8676 4223

Mobile: 0404 998 273













From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Mark Mandel
Sent: Tuesday, 12 September 2006
3:05 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
Compressing the output to the browser via CF





Got it... it allhad to do
with the headers - 

cfcomponent name=Application

cffunction name=onRequestEnd returntype=boolean
output=true
cfargument name=thePage type=string
required=true 

 cfscript
  var fileOut = '';
  var out = '';

  pageOut =
getPageContext().getCFOutput().getString();

  fileOut = createobject(java,
java.io.ByteArrayOutputStream ).init();
  out =
createobject(java,java.util.zip.GZIPOutputStream).init(fileOut);
  out.write(variables.pageOut.getBytes(),
0, len(variables.pageOut.getBytes()));

  // Complete the GZIP file 
  out.finish();
  out.close();
 /cfscript

 cfheader name=Content-Encoding
value=gzip
 cfcontent type=text/html
reset=true variable=#fileOut.toByteArray()# 
/cffunction

/cfcomponent

Enjoy

Mark



On 9/12/06, Andrew
Scott 
[EMAIL PROTECTED] wrote:


Mark no go, however I was reading somewhere that I may need to use the 
getRequest().getRequest() and flush it that way and write the content in
application.cfc



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +6138676 4223
Mobile: 0404
998 273






-- 
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: Fullasagoog Still Very Sick

2006-09-12 Thread darryl lyons

If you don't like Goog, then use MXNA. I've got the ColdFusion smart
category set up as a live bookmark in Firefox, and the top 15 or so
entries in it (at the time of writing) are all ColdFusion related.

http://weblogs.macromedia.com/mxna/xml/rss.cfm?query=bySmartCategorylanguages=1smartCategoryId=1smartCategoryKey=D0382F3A-9D2B-69E8-C7BC317066FA1CC2


On 11/09/06, Dale Fraser [EMAIL PROTECTED] wrote:




 I'm going to keep pushing this barrow.



 Here's the 9 Coldfusion Blend Goog entries Google is currently showing me.



 Season 3 Lost footage leaked

 Hanso exposed

 Flash, Flex, and the Capital Area Flex Users Group

 icu4j 3.6 hits alpha

 Michael Schumacher bids adieu

 Windows System Restore Actually Works

 ColdFusion Position In SC

 Ted Patrickâ??s 10 Reasons Convinced Me to go to MAX

 Looking for Design Work on a Flex 2 Application

 Just out of interest, have a look through these blogs. Some of these people
 have Coldfusion categories but we still get all the crap.

 And before the abuse starts, I'm pushing this barrow as I like Goog and hope
 it can be improved.

 Regards
  Dale Fraser

 http://dale.fraser.id.au


  



-- 

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
-~--~~~~--~~--~--~---



[cfaussie] Re: Compressing the output to the browser via CF

2006-09-12 Thread Andrew Scott
Ok have blogged this on my website..

http://www.andyscott.id.au/

On 9/12/06, Dale Fraser [EMAIL PROTECTED] wrote:




Andrew,

Interesting concept, be interesting to do some metrics on speed etc.

Gives me another idea.


RegardsDale Fraser

http://dale.fraser.id.au





From:
 cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of Andrew ScottSent: Tuesday, 12 September 2006 3:06 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Compressing the output to the browser via CF




Mark, thanks I was just about to switch them thanks.




Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au

Phone:+613 8676 4223
Mobile
: 0404 998 273





From:
 cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of Mark MandelSent: Tuesday, 12 September 2006 3:05 PM
To: cfaussie@googlegroups.comSubject: [cfaussie] Re: Compressing the output to the browser via CF


Got it... it allhad to do with the headers - cfcomponent name=Applicationcffunction name=onRequestEnd returntype=boolean output=true
cfargument name=thePage type=string required=true  cfscript  var fileOut = '';  var out = '';  pageOut = getPageContext().getCFOutput().getString();
  fileOut = createobject(java, java.io.ByteArrayOutputStream ).init();  out = createobject(java,java.util.zip.GZIPOutputStream).init(fileOut);  
out.write(variables.pageOut.getBytes(), 0, len(variables.pageOut.getBytes()));  // Complete the GZIP file   out.finish();  out.close(); /cfscript cfheader name=Content-Encoding value=gzip
 cfcontent type=text/html reset=true variable=#fileOut.toByteArray()# /cffunction/cfcomponentEnjoyMark

On 9/12/06, Andrew Scott 
 [EMAIL PROTECTED] wrote:
Mark no go, however I was reading somewhere that I may need to use the getRequest().getRequest() and flush it that way and write the content in
application.cfcSenior Coldfusion DeveloperAegeon Pty. Ltd.www.aegeon.com.auPhone: +6138676 4223
Mobile: 0404 998 273-- 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: Compressing the output to the browser via CF

2006-09-12 Thread Dale Fraser








Ok,



My idea was to do a similar thing to remove
whitespace. It works a treat, Ive blogged it here. I think removing the
whitespace and then gzipn it could have some potential as a simple
application.cfc addon.



http://dale.fraser.id.au/blog/index.cfm/2006/9/12/Remove-Coldfusion-Whitespace



Regards
Dale Fraser

http://dale.fraser.id.au











From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Scott
Sent: Tuesday, 12 September 2006
9:05 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
Compressing the output to the browser via CF







Ok have blogged this on my website..











http://www.andyscott.id.au/













On 9/12/06, Dale Fraser [EMAIL PROTECTED] wrote:








Andrew,



Interesting concept, be interesting to do some metrics on speed
etc.



Gives me another idea.







Regards
Dale Fraser

http://dale.fraser.id.au















From: cfaussie@googlegroups.com
[mailto:
cfaussie@googlegroups.com] On Behalf Of Andrew
Scott
Sent: Tuesday, 12 September 2006
3:06 PM






To: cfaussie@googlegroups.com

Subject: [cfaussie]
Re: Compressing the output to the browser via CF









Mark, thanks I was just about to switch them thanks.









Senior Coldfusion Developer

Aegeon Pty. Ltd.

www.aegeon.com.au


Phone:+613 8676 4223

Mobile : 0404 998 273













From: cfaussie@googlegroups.com
[mailto:
cfaussie@googlegroups.com] On Behalf Of Mark
Mandel
Sent: Tuesday, 12 September 2006
3:05 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
Compressing the output to the browser via CF 





Got it... it allhad to do with the headers - 

cfcomponent name=Application

cffunction name=onRequestEnd returntype=boolean
output=true 
cfargument name=thePage type=string
required=true 

 cfscript
  var fileOut = '';
  var out = '';

  pageOut =
getPageContext().getCFOutput().getString(); 

  fileOut = createobject(java,
java.io.ByteArrayOutputStream ).init();
  out = createobject(java,java.util.zip.GZIPOutputStream).init(fileOut);
  out.write(variables.pageOut.getBytes(),
0, len(variables.pageOut.getBytes()));

  // Complete the GZIP file 
  out.finish();
  out.close();
 /cfscript

 cfheader name=Content-Encoding
value=gzip 
 cfcontent type=text/html
reset=true variable=#fileOut.toByteArray()# 
/cffunction

/cfcomponent

Enjoy

Mark



On
9/12/06, Andrew Scott 
[EMAIL PROTECTED] wrote:


Mark no go, however I was reading somewhere that I may need to use the 
getRequest().getRequest() and flush it that way and write the content in 
application.cfc



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +6138676 4223 
Mobile: 0404
998 273






-- 
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: Compressing the output to the browser via CF

2006-09-12 Thread Mark Mandel

What.. not even a nice link to the cfaussie list awww.. no kudos :o(

I think I'm gonna go eat worms...

:oD

Mark



On 9/12/06, Andrew Scott [EMAIL PROTECTED] wrote:

 Ok have blogged this on my website..

 http://www.andyscott.id.au/




 On 9/12/06, Dale Fraser [EMAIL PROTECTED] wrote:
 
 
 
 
 
  Andrew,
 
 
 
  Interesting concept, be interesting to do some metrics on speed etc.
 
 
 
  Gives me another idea.
 
 
 
  Regards
  Dale Fraser
 
   http://dale.fraser.id.au
 
 
   

 
  From:  cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] On Behalf Of 
  Andrew Scott
  Sent: Tuesday, 12 September 2006 3:06 PM
 
  To: cfaussie@googlegroups.com
  Subject: [cfaussie] Re: Compressing the output to the browser via CF
 
 
 
 
 
 
 
  Mark, thanks I was just about to switch them thanks.
 
 
 
 
 
 
 
 
  Senior Coldfusion Developer
 
  Aegeon Pty. Ltd.
 
  www.aegeon.com.au
 
  Phone: +613  8676 4223
 
  Mobile : 0404 998 273
 
 
 
   

 
  From:  cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] On Behalf Of 
  Mark Mandel
  Sent: Tuesday, 12 September 2006 3:05 PM
   To: cfaussie@googlegroups.com
  Subject: [cfaussie] Re: Compressing the output to the browser via CF
 
 
 
  Got it... it allhad to do with the headers -
 
  cfcomponent name=Application
 
  cffunction name=onRequestEnd returntype=boolean output=true
  cfargument name=thePage type=string required=true
 
  cfscript
  var fileOut = '';
  var out = '';
 
  pageOut = getPageContext().getCFOutput().getString();
 
  fileOut = createobject(java, java.io.ByteArrayOutputStream 
  ).init();
  out = 
  createobject(java,java.util.zip.GZIPOutputStream).init(fileOut);
   out.write(variables.pageOut.getBytes(), 0, 
  len(variables.pageOut.getBytes()));
 
  // Complete the GZIP file
  out.finish();
  out.close();
  /cfscript
 
  cfheader name=Content-Encoding value=gzip
  cfcontent type=text/html reset=true 
  variable=#fileOut.toByteArray()#
   /cffunction
 
  /cfcomponent
 
  Enjoy
 
  Mark
 
 
  On 9/12/06, Andrew Scott   [EMAIL PROTECTED] wrote:
 
 
  Mark no go, however I was reading somewhere that I may need to use the
  getRequest().getRequest() and flush it that way and write the content in
  application.cfc
 
 
 
  Senior Coldfusion Developer
  Aegeon Pty. Ltd.
  www.aegeon.com.au
  Phone: +613  8676 4223
  Mobile: 0404 998 273
 
 
 
 
 
 
  --
  E: [EMAIL PROTECTED]
  W:  www.compoundtheory.com
 
 
 
 
 
 
 
 
 


  




-- 
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: Compressing the output to the browser via CF

2006-09-12 Thread Andrew Scott
Hey Mark,

I did on my blog:-)

On 9/12/06, Mark Mandel [EMAIL PROTECTED] wrote:
What.. not even a nice link to the cfaussie list awww.. no kudos :o(I think I'm gonna go eat worms...
:oDMarkOn 9/12/06, Andrew Scott [EMAIL PROTECTED] wrote: Ok have blogged this on my website.. 
http://www.andyscott.id.au/ On 9/12/06, Dale Fraser [EMAIL PROTECTED] wrote: 
  Andrew, Interesting concept, be interesting to do some metrics on speed etc.   
  Gives me another idea. Regards  Dale Fraser  http://dale.fraser.id.au 
     From:cfaussie@googlegroups.com [mailto: 
cfaussie@googlegroups.com] On Behalf Of Andrew Scott  Sent: Tuesday, 12 September 2006 3:06 PM   To: cfaussie@googlegroups.com  Subject: [cfaussie] Re: Compressing the output to the browser via CF
 Mark, thanks I was just about to switch them thanks. 
 Senior Coldfusion Developer   Aegeon Pty. Ltd.   www.aegeon.com.au 
  Phone: +6138676 4223   Mobile : 0404 998 273   From:
cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of Mark Mandel  Sent: Tuesday, 12 September 2006 3:05 PM To: 
cfaussie@googlegroups.com  Subject: [cfaussie] Re: Compressing the output to the browser via CF Got it... it allhad to do with the headers - 
  cfcomponent name=Application   cffunction name=onRequestEnd returntype=boolean output=true  cfargument name=thePage type=string required=true
   cfscript  var fileOut = '';  var out = '';   pageOut = getPageContext().getCFOutput().getString(); 
  fileOut = createobject(java, java.io.ByteArrayOutputStream ).init();  out = createobject(java,java.util.zip.GZIPOutputStream).init(fileOut);
 out.write(variables.pageOut.getBytes(), 0, len(variables.pageOut.getBytes()));   // Complete the GZIP file  out.finish();  out.close
();  /cfscript   cfheader name=Content-Encoding value=gzip  cfcontent type=text/html reset=true variable=#fileOut.toByteArray()#
 /cffunction   /cfcomponent   Enjoy   MarkOn 9/12/06, Andrew Scott 
[EMAIL PROTECTED] wrote:Mark no go, however I was reading somewhere that I may need to use the  getRequest().getRequest() and flush it that way and write the content in
  application.cfc Senior Coldfusion Developer  Aegeon Pty. Ltd.  www.aegeon.com.au  Phone: +6138676 4223
  Mobile: 0404 998 273--  E: [EMAIL PROTECTED]  W:
www.compoundtheory.com 
--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: Why buy into CF?

2006-09-12 Thread M@ Bourke
Given that a number companies are now giving away, for free, theirpropriety products for limited use, when is Adobe going to jump on the
bandwagon with JRun and Coldfusion? Well, actually I currently know ofonly one application server that's now free: the IBM WebSphereApplication Server Community Edition, but number of database vendorsare doing it: IBM DB2, Oracle, Microsoft. What Adobe's position on
this?Ben said they are going to pretty much every Ajax function there is and giving away cd's. if the cd's are full versions or not I didn't ask. He couldn't talk to much on cf 8 just yet but said (as we have heard before) most new info on it will come at Max
The server debugging sounded really exciting though.M@

--~--~-~--~~~---~--~~
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?

2006-09-12 Thread Charlie Arehart



M@, are you referring to interactive step debugging? Or 
something else? I'd just not heard of any plans for Adobe to do step debugging, 
so just curious what you may have heard.

In the meantime, for those interested, I have started a 
series of entries on the interactive step debugger from Intergral, 
FusionDebug:

http://carehart.org/blog/client/index.cfm/fusiondebug

/charlie
http://www.carehart.org/blog/



From: cfaussie@googlegroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of M@ BourkeSent: 
Tuesday, September 12, 2006 11:32 AMTo: 
cfaussie@googlegroups.comSubject: [cfaussie] Re: Why buy into 
CF?


Given 
  that a number companies are now giving away, for free, theirpropriety 
  products for limited use, when is Adobe going to jump on the bandwagon 
  with JRun and Coldfusion? Well, actually I currently know ofonly one 
  application server that's now free: the IBM WebSphereApplication Server 
  Community Edition, but number of database vendorsare doing it: IBM DB2, 
  Oracle, Microsoft. What Adobe's position on 
this?Ben said they are going to pretty 
much every Ajax function there is and giving away cd's. if the cd's are full 
versions or not I didn't ask. He couldn't talk to much on cf 8 just yet but 
said (as we have heard before) most new info on it will come at Max The 
server debugging sounded really exciting though.M@ 

--~--~-~--~~~---~--~~
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] Coldfusion Server problems

2006-09-12 Thread Scott Thornton

naturally.

 [EMAIL PROTECTED] 12/09/2006 7:27 pm 

Or certain crucial files have been corrupted meaning a re-install is a
possibility. Of course you have backed up crucial data?





--~--~-~--~~~---~--~~
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?

2006-09-12 Thread Scott Barnes
I meet Ben once.. he wasa 6ft tall, arms like tree trunks andhair as red as fire, he bespoken with harmony in his voice he-be,and when he stared at you, it felt as if the devil be watchin ya, it did.

He affectionately referred to me as weird little man and i remember his words fondly... could you stop humping my leg, you weird little man.

(Sorry, i figured since this topic has degraded into mindless dribble, i'd throw in my 2c to close it out maybe? ) heh

On 9/13/06, Barry Beattie [EMAIL PROTECTED] wrote:
hi M@ Ben said they are going to pretty much every Ajax function there is and giving away cd's.
so, if ppl at gatherings are interested in Ajax, they're obviouslyinterested in building web applications per se, yes? That's one attackthrust I suppose. Anything else?So... did the Magic Forta say anything else? c'mon, you can tell us.
give us the gossip - no one else will know...b-- Regards,Scott Barneshttp://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] Re: Why buy into CF?

2006-09-12 Thread M@ Bourke
On 9/12/06, Charlie Arehart [EMAIL PROTECTED] wrote:





M@, are you referring to interactive step debugging? Or 
something else? I'd just not heard of any plans for Adobe to do step debugging, 
so just curious what you may have heard.


Hi Charlie good to hear from a fellow long time BD user, 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
M@PS: he talked very fast and was the only person (in my life time) who has managed to have ever kept my concentration, my brain usually runs to fast and loses concentration on slow speakers, everyone commented on how fast he spoke, but I found it to be nice and smooth


--~--~-~--~~~---~--~~
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?

2006-09-12 Thread M@ Bourke
On 9/12/06, Scott Barnes [EMAIL PROTECTED] wrote:
I meet Ben once.. he wasa 6ft tall, arms like tree trunks andhair as red as fire, he bespoken with harmony in his voice he-be,and when he stared at you, it felt as if the devil be watchin ya, it did.

He affectionately referred to me as weird little man and i remember his words fondly... could you stop humping my leg, you weird little man.

(Sorry, i figured since this topic has degraded into mindless dribble, i'd throw in my 2c to close it out maybe? ) hehHi scott (old fellow drinker pal)I to offered to hump his leg, he informed us that he can't let out secrets and has only ever done that after being offered large amounts of alcohol.
I was planning on offering him some pints at the local but he had to shoot off to the airport to fly to Boston which was good of him to think his whole England stoppage was simply to attend our user group which we invited him to. 
M@

--~--~-~--~~~---~--~~
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] CF8 Features

2006-09-12 Thread Dale Fraser

On the topic of features.

The under the hood tweaking and image manipulation tags are features of CF8.

It's no big secret as there are sessions at Max on these two features.

It's interesting that they are at a point of demonstrating features, but no
beta program yet. Make me wonder when or if we will see a beta.

Regards
Dale Fraser

http://dale.fraser.id.au


 

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Barry Beattie
Sent: Wednesday, 13 September 2006 08:55 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Why buy into CF?


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!)




--~--~-~--~~~---~--~~
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: CF8 Features

2006-09-12 Thread Peter Tilbrook
http://prerelease.adobe.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: Why buy into CF?

2006-09-12 Thread Chris Velevitch

On 9/13/06, M@ Bourke [EMAIL PROTECTED] wrote:
  Given that a number companies are now giving away, for free, their
  propriety products for limited use, when is Adobe going to jump on the
  bandwagon with JRun and Coldfusion? Well, actually I currently know of
  only one application server that's now free: the IBM WebSphere
  Application Server Community Edition, but number of database vendors
  are doing it: IBM DB2, Oracle, Microsoft. What Adobe's position on
  this?

 Ben said they are going to pretty much every Ajax function there is and
 giving away cd's. if the cd's are full versions or not I didn't ask.

So they are going to release a free limited use CF like FDS Express?


Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.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: Why buy into CF?

2006-09-12 Thread Scott Barnes
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 itencouragement at last!I hope the knobs at Adobe realise some of the best advertising isfree: next time an Adobe bigwig gives an interview to tech press, CF
gets an honerable mention when the names Flash, Flex, LiveCycle, etcare rattled off...cheersbarry.bPS: Give up, Barnes. No one takes you seriously anymore now thatyou've moved into the realm of pointy-haired types...with _nothing_ to
do with web solutions(just joking!)-- Regards,Scott Barneshttp://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] Re: CF8 Features

2006-09-12 Thread Mark Ireland


So, how do you register?




From:"Peter Tilbrook" [EMAIL PROTECTED]Reply-To:cfaussie@googlegroups.comTo:cfaussie@googlegroups.comSubject:[cfaussie] Re: CF8 FeaturesDate:Wed, 13 Sep 2006 09:44:07 +1000
http://prerelease.adobe.com/


The future of MSN Messenger is here:   download now 

--~--~-~--~~~---~--~~
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] ZeroOne Community Talks - Flex 2.0 UI components

2006-09-12 Thread Justin Carter

Has anyone got the URL for the ZeroOne Community Talks - Flex 2.0 UI
Components Breeze Persentation? On Monday I got a reminder about it and
it said that another email would be sent today with the URL to attend
the presentation, but I haven't received anything.

See the original email below... It's a little contradictory since it
says Wednesday 13 Sept 2006 :  12:00 - 13:00, All times are for
Sydney, Australia but then the next line says Please remember that
this event begins at 12pm New Zealand time, which is 10am AEST.

I hope it hasn't started already, but if the second part is to be
believed then it has been going for almost 20 minutes by now... Doh!




Just a short note to remind you that you are booked to attend the
following event:

ZeroOne Community Talks
Flex 2.0 UI components
Wednesday 13 Sept 2006 :  12:00 - 13:00
Online Seminar
All times are for Sydney, Australia


Please remember that this event begins at 12pm New Zealand time, which
is 10am AEST.

You will be sent a URL on the day of the event to allow you to
participate in the webinar. Just click on the link and this will take
you directly into the presetation

--


--~--~-~--~~~---~--~~
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

2006-09-12 Thread Justin Carter

P.S. If anyone did want to attend some of the talks, you can register
here:
http://events.adobe.co.uk/events/cgi/event.cgi?country=paeventid=3373


--~--~-~--~~~---~--~~
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] Querying across multiple databases

2006-09-12 Thread Barry Beattie

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

--~--~-~--~~~---~--~~
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

2006-09-12 Thread Steve Onnis

Whats the database type your using?
and are botht he databases on the same server?

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Barry Beattie
Sent: Wednesday, September 13, 2006 10:52 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Querying across multiple databases



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





--~--~-~--~~~---~--~~
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

2006-09-12 Thread Scott Thornton

Hi,

The query you have posted shows the correct syntax for using a table from a 
different database. (i think I would add the server name too).

you could always create a view with the table inside of it.

 [EMAIL PROTECTED] 13/09/2006 10:52 am 

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




--~--~-~--~~~---~--~~
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

2006-09-12 Thread Barry Beattie

Thanx Rod

well, bugger me, it worked!

cfquery name=qry datasource=FOUREX
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
/cfquery

cfdump var=#qry# expand=false

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 dbname.dbuser.dbtable

 
  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
 
  
 



 


--~--~-~--~~~---~--~~
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

2006-09-12 Thread Chris Velevitch

http://zeroone.partner.breezecentral.com/p58922012/

Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.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
-~--~~~~--~~--~--~---