Respool mail on CFMX

[Nelson Winters]

Anyone know how to respool mail in CFMX?  Care to share?

I tried removing the "Undelievered_" prefix from the filename and place back
in the spool directory with no luck.

Thanks,

Nelson

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Verity: getting file size and date last modified from CFSEARCH

[Whiterod, David (PLNSA)]

Is is possible to get the file size and date last modified for results using
CFSEARCH?

cheers

David
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: ActiveX Treeview in a web page Help?

[Jon Hall]

This has happened to me not to long ago, all was working fine for a
while. Then I had the client who had never used the program, go to the
url and it didn't work. I had changed the directory that the program
had run in but forgot to update the code, but since the ActiveX
control was still installed, it kept working on all the machines I had
been testing on...doh!
Are you 100% sure that the lpk file is in the right place? Try entering
the url of the control into the browser...
Also have you uninstalled the control and started fresh?
Tools/Internet Options/Settings/View Objects/Right click/Remove

-- 
jon

Monday, July 15, 2002, 10:40:01 PM, you wrote:
SG> I was able to get the Treeview control from the MSCOMCTL.CAB file running
SG> properly in a web page.  I used a .LPK file, and things were great (even if
SG> I had to use VBScript instead of Javascript).

SG> Then, for no reason that I can see, the tree stopped loading, and I got the
SG> infamous "Object Required" error.  I've checked my .LPK file (and recreated
SG> it), and made sure any code that referenced the tree was placed after the
SG>  tag for the tree.  I'm not understanding why it's not working
SG> anymore, seeing as it was working fine, and I didn't make any changes to the
SG>  code when it stopped.  

SG> Anyone have any suggestions?  (I'm hoping that the expertise on this list
SG> will yeild more than a google search has - web and groups).  Thanks in
SG> advance.

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: ActiveX Treeview in a web page Help?

[Shawn Grover]

I was able to get the Treeview control from the MSCOMCTL.CAB file running
properly in a web page.  I used a .LPK file, and things were great (even if
I had to use VBScript instead of Javascript).

Then, for no reason that I can see, the tree stopped loading, and I got the
infamous "Object Required" error.  I've checked my .LPK file (and recreated
it), and made sure any code that referenced the tree was placed after the
 tag for the tree.  I'm not understanding why it's not working
anymore, seeing as it was working fine, and I didn't make any changes to the
 code when it stopped.  

Anyone have any suggestions?  (I'm hoping that the expertise on this list
will yeild more than a google search has - web and groups).  Thanks in
advance.

Shawn Grover

Here's the offending code:



   
 

CFHTTP on CFMX

[Jim Vosika]

Hi,
I have one server running CF5 and one I am testing with that
has CFMX. On the CFMX machine I run some code that cfhttp's a website a
few times each time it is run. Everything works great on the CF5 box but
when I run the same code on MX I get a "302 Moved Temporarily" error. I
tried looking through the docs and I couldn't find any changes that may
affect me. Has anyone else encountered this?
 
Thanks, 
Jim Vosika
http://tinyclick.com   
Free URL Shortening!


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JRUN BOOK

[Douglas Brown]

http://www.amazon.com/exec/obidos/ASIN/0789726009/ref=ase_drewfalkmanco-
20/102-8243078-6010513




Douglas Brown
Email: [EMAIL PROTECTED]

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JRUN books

[Ian Lurie]

Sorry, I know this was asked before but I can't find the e-mail thread.
What's a good introductory JRUN 4.0 book?

Ian

Portent Interactive
Helping clients build customer relationships on the web since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com
Talk with us: http://projects.portentinteractive.com

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Stacy Young]

I'm potty trained.


-Original Message-
From: Todd [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 6:12 PM
To: CF-Talk
Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

Whoot!  Stacy! You learned how to flush the toliet query cache =)

~Todd

At 05:43 PM 7/15/2002 -0400, you wrote:
>Thanks guys that's a bit beyond my reach from a skills perspective at the
>moment but I'll poke around...btw this seems to clear all query cache...
>
>CLASS="coldfusion.server.ServiceFactory" NAME="factory">
>
>
>
>
>-Original Message-
>From: Matt Liotta [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 15, 2002 5:33 PM
>To: CF-Talk
>Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
>
>
>Using the Java Profiler would likely be much easier. The Java Profiler
comes
>with the JDK and is executed using the command javap.
>
>Matt Liotta
>President & CEO
>Montara Software, Inc.
>http://www.montarasoftware.com/
>V: 415-577-8070
>F: 415-341-8906
>P: [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:27 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> > You can however get the interface of the class from the class file
> > (without decompiling it) through introspection.  Open the Jar file
> > with
>JBuilder,
> > and
> > it will generate a interface stub.  Forte also has an introspector
>built
> > in.
> >
> > _
> > Pete Freitag
> > CTO, CFDEV.COM
> > ColdFusion Tags, Products, and Free Resources http://www.cfdev.com/
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:34 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> >
> > Crap! Thanks Ben...On my way over to the suggestion box...
> >
> >
> > -Original Message-
> > From: Ben Forta [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:20 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> > Stacy,
> >
> > I tried that one, it is not exposed to the ServiceFactory and I
>checked
> > with the developer and he said there were no exposed API's for that
>one
> > at all. Sorry.
> >
> > --- Ben
> >
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:17 PM
> > To: CF-Talk
> > Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> >
> > Better yet, are there Javadocs available? :)
> >
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:06 PM
> > To: CF-Talk
> > Subject: coldfusion.server.ServiceFactory ?
> >
> > In one of Ben Forta's UDFs I see his getting into some Java
> > functionality to access query data. I'm wondering if anyone can lead
>me
> > onto a way of accessing what queries are currently cached in the app
> > server? I've always wanted to be able to actively monitor/adjust
> > querying caching based on what's in memory already and what not...
> >
> >
> >
> > Thanks in advance!
> >
> >
> >
> >
> >
> > Stacy Young
> >
> > System Integration Specialist, Architecture
> >
> > Surefire Commerce
> >
> > http://www.sfcommerce.com 
> >
> > (p) 514-380-2700 ext: 3234
> >
> > (f) 514-380-2760
> >
> >
> >
> >
> >
> > AVIS IMPORTANT:
> > ---
> > Les informations contenues dans le present document et ses pieces
> > jointes sont strictement confidentielles et reservees a l'usage de la
> > (des)
> > personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
> > soyez avise que toute divulgation, distribution, copie, ou autre
> > utilisation de ces informations est strictement prohibee.  Si vous
>avez
> > recu ce document par erreur, veuillez s'il vous plait communiquer
> > immediatement avec l'expediteur et detruire ce document sans en faire
>de
> > copie sous quelque forme.
> >
> > WARNING:
> > ---
> > The information contained in this document and attachments is
> > confidential and intended only for the person(s) named above.  If you
> > are not the intended recipient you are hereby notified that any
> > disclosure, copying, distribution, or any other use of the information
> > is strictly prohibited. If you have received this document by mistake,
> > please notify the sender immediately and destroy this document and
> > attachments without making any copy of any kind.
> >
> >
> >
> >
> >
> >
> >
>
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Todd]

Whoot!  Stacy! You learned how to flush the toliet query cache =)

~Todd

At 05:43 PM 7/15/2002 -0400, you wrote:
>Thanks guys that's a bit beyond my reach from a skills perspective at the
>moment but I'll poke around...btw this seems to clear all query cache...
>
>CLASS="coldfusion.server.ServiceFactory" NAME="factory">
>
>
>
>
>-Original Message-
>From: Matt Liotta [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 15, 2002 5:33 PM
>To: CF-Talk
>Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
>
>
>Using the Java Profiler would likely be much easier. The Java Profiler comes
>with the JDK and is executed using the command javap.
>
>Matt Liotta
>President & CEO
>Montara Software, Inc.
>http://www.montarasoftware.com/
>V: 415-577-8070
>F: 415-341-8906
>P: [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:27 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> > You can however get the interface of the class from the class file
> > (without decompiling it) through introspection.  Open the Jar file
> > with
>JBuilder,
> > and
> > it will generate a interface stub.  Forte also has an introspector
>built
> > in.
> >
> > _
> > Pete Freitag
> > CTO, CFDEV.COM
> > ColdFusion Tags, Products, and Free Resources http://www.cfdev.com/
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:34 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> >
> > Crap! Thanks Ben...On my way over to the suggestion box...
> >
> >
> > -Original Message-
> > From: Ben Forta [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:20 PM
> > To: CF-Talk
> > Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> > Stacy,
> >
> > I tried that one, it is not exposed to the ServiceFactory and I
>checked
> > with the developer and he said there were no exposed API's for that
>one
> > at all. Sorry.
> >
> > --- Ben
> >
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:17 PM
> > To: CF-Talk
> > Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> >
> >
> > Better yet, are there Javadocs available? :)
> >
> >
> > -Original Message-
> > From: Stacy Young [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:06 PM
> > To: CF-Talk
> > Subject: coldfusion.server.ServiceFactory ?
> >
> > In one of Ben Forta's UDFs I see his getting into some Java
> > functionality to access query data. I'm wondering if anyone can lead
>me
> > onto a way of accessing what queries are currently cached in the app
> > server? I've always wanted to be able to actively monitor/adjust
> > querying caching based on what's in memory already and what not...
> >
> >
> >
> > Thanks in advance!
> >
> >
> >
> >
> >
> > Stacy Young
> >
> > System Integration Specialist, Architecture
> >
> > Surefire Commerce
> >
> > http://www.sfcommerce.com 
> >
> > (p) 514-380-2700 ext: 3234
> >
> > (f) 514-380-2760
> >
> >
> >
> >
> >
> > AVIS IMPORTANT:
> > ---
> > Les informations contenues dans le present document et ses pieces
> > jointes sont strictement confidentielles et reservees a l'usage de la
> > (des)
> > personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
> > soyez avise que toute divulgation, distribution, copie, ou autre
> > utilisation de ces informations est strictement prohibee.  Si vous
>avez
> > recu ce document par erreur, veuillez s'il vous plait communiquer
> > immediatement avec l'expediteur et detruire ce document sans en faire
>de
> > copie sous quelque forme.
> >
> > WARNING:
> > ---
> > The information contained in this document and attachments is
> > confidential and intended only for the person(s) named above.  If you
> > are not the intended recipient you are hereby notified that any
> > disclosure, copying, distribution, or any other use of the information
> > is strictly prohibited. If you have received this document by mistake,
> > please notify the sender immediately and destroy this document and
> > attachments without making any copy of any kind.
> >
> >
> >
> >
> >
> >
> >
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Stacy Young]

Thanks guys that's a bit beyond my reach from a skills perspective at the
moment but I'll poke around...btw this seems to clear all query cache...






-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 5:33 PM
To: CF-Talk
Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)


Using the Java Profiler would likely be much easier. The Java Profiler comes
with the JDK and is executed using the command javap.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.montarasoftware.com/
V: 415-577-8070
F: 415-341-8906
P: [EMAIL PROTECTED]

> -Original Message-
> From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:27 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> You can however get the interface of the class from the class file 
> (without decompiling it) through introspection.  Open the Jar file 
> with
JBuilder,
> and
> it will generate a interface stub.  Forte also has an introspector
built
> in.
> 
> _
> Pete Freitag
> CTO, CFDEV.COM
> ColdFusion Tags, Products, and Free Resources http://www.cfdev.com/
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:34 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> 
> Crap! Thanks Ben...On my way over to the suggestion box...
> 
> 
> -Original Message-
> From: Ben Forta [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:20 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> Stacy,
> 
> I tried that one, it is not exposed to the ServiceFactory and I
checked
> with the developer and he said there were no exposed API's for that
one
> at all. Sorry.
> 
> --- Ben
> 
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:17 PM
> To: CF-Talk
> Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> 
> Better yet, are there Javadocs available? :)
> 
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:06 PM
> To: CF-Talk
> Subject: coldfusion.server.ServiceFactory ?
> 
> In one of Ben Forta's UDFs I see his getting into some Java 
> functionality to access query data. I'm wondering if anyone can lead
me
> onto a way of accessing what queries are currently cached in the app 
> server? I've always wanted to be able to actively monitor/adjust 
> querying caching based on what's in memory already and what not...
> 
> 
> 
> Thanks in advance!
> 
> 
> 
> 
> 
> Stacy Young
> 
> System Integration Specialist, Architecture
> 
> Surefire Commerce
> 
> http://www.sfcommerce.com 
> 
> (p) 514-380-2700 ext: 3234
> 
> (f) 514-380-2760
> 
> 
> 
> 
> 
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present document et ses pieces 
> jointes sont strictement confidentielles et reservees a l'usage de la
> (des)
> personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, 
> soyez avise que toute divulgation, distribution, copie, ou autre 
> utilisation de ces informations est strictement prohibee.  Si vous
avez
> recu ce document par erreur, veuillez s'il vous plait communiquer 
> immediatement avec l'expediteur et detruire ce document sans en faire
de
> copie sous quelque forme.
> 
> WARNING:
> ---
> The information contained in this document and attachments is 
> confidential and intended only for the person(s) named above.  If you 
> are not the intended recipient you are hereby notified that any 
> disclosure, copying, distribution, or any other use of the information 
> is strictly prohibited. If you have received this document by mistake, 
> please notify the sender immediately and destroy this document and 
> attachments without making any copy of any kind.
> 
> 
> 
> 
> 
> 
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Matt Liotta]

Using the Java Profiler would likely be much easier. The Java Profiler
comes with the JDK and is executed using the command javap.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.montarasoftware.com/
V: 415-577-8070
F: 415-341-8906
P: [EMAIL PROTECTED]

> -Original Message-
> From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:27 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> You can however get the interface of the class from the class file
> (without
> decompiling it) through introspection.  Open the Jar file with
JBuilder,
> and
> it will generate a interface stub.  Forte also has an introspector
built
> in.
> 
> _
> Pete Freitag
> CTO, CFDEV.COM
> ColdFusion Tags, Products, and Free Resources
> http://www.cfdev.com/
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:34 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> 
> Crap! Thanks Ben...On my way over to the suggestion box...
> 
> 
> -Original Message-
> From: Ben Forta [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:20 PM
> To: CF-Talk
> Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> Stacy,
> 
> I tried that one, it is not exposed to the ServiceFactory and I
checked
> with the developer and he said there were no exposed API's for that
one
> at all. Sorry.
> 
> --- Ben
> 
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:17 PM
> To: CF-Talk
> Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)
> 
> 
> Better yet, are there Javadocs available? :)
> 
> 
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:06 PM
> To: CF-Talk
> Subject: coldfusion.server.ServiceFactory ?
> 
> In one of Ben Forta's UDFs I see his getting into some Java
> functionality to access query data. I'm wondering if anyone can lead
me
> onto a way of accessing what queries are currently cached in the app
> server? I've always wanted to be able to actively monitor/adjust
> querying caching based on what's in memory already and what not...
> 
> 
> 
> Thanks in advance!
> 
> 
> 
> 
> 
> Stacy Young
> 
> System Integration Specialist, Architecture
> 
> Surefire Commerce
> 
> http://www.sfcommerce.com 
> 
> (p) 514-380-2700 ext: 3234
> 
> (f) 514-380-2760
> 
> 
> 
> 
> 
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present document et ses pieces
> jointes sont strictement confidentielles et reservees a l'usage de la
> (des)
> personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
> soyez avise que toute divulgation, distribution, copie, ou autre
> utilisation de ces informations est strictement prohibee.  Si vous
avez
> recu ce document par erreur, veuillez s'il vous plait communiquer
> immediatement avec l'expediteur et detruire ce document sans en faire
de
> copie sous quelque forme.
> 
> WARNING:
> ---
> The information contained in this document and attachments is
> confidential and intended only for the person(s) named above.  If you
> are not the intended recipient you are hereby notified that any
> disclosure, copying, distribution, or any other use of the information
> is strictly prohibited. If you have received this document by mistake,
> please notify the sender immediately and destroy this document and
> attachments without making any copy of any kind.
> 
> 
> 
> 
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Pete Freitag]

You can however get the interface of the class from the class file (without
decompiling it) through introspection.  Open the Jar file with JBuilder, and
it will generate a interface stub.  Forte also has an introspector built in.

_
Pete Freitag
CTO, CFDEV.COM
ColdFusion Tags, Products, and Free Resources
http://www.cfdev.com/

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:34 PM
To: CF-Talk
Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)


Crap! Thanks Ben...On my way over to the suggestion box...


-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:20 PM
To: CF-Talk
Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

Stacy,

I tried that one, it is not exposed to the ServiceFactory and I checked
with the developer and he said there were no exposed API's for that one
at all. Sorry.

--- Ben


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:17 PM
To: CF-Talk
Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)


Better yet, are there Javadocs available? :)


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?

In one of Ben Forta's UDFs I see his getting into some Java
functionality to access query data. I'm wondering if anyone can lead me
onto a way of accessing what queries are currently cached in the app
server? I've always wanted to be able to actively monitor/adjust
querying caching based on what's in memory already and what not...



Thanks in advance!





Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com 

(p) 514-380-2700 ext: 3234

(f) 514-380-2760





AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces
jointes sont strictement confidentielles et reservees a l'usage de la
(des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
soyez avise que toute divulgation, distribution, copie, ou autre
utilisation de ces informations est strictement prohibee.  Si vous avez
recu ce document par erreur, veuillez s'il vous plait communiquer
immediatement avec l'expediteur et detruire ce document sans en faire de
copie sous quelque forme.

WARNING:
---
The information contained in this document and attachments is
confidential and intended only for the person(s) named above.  If you
are not the intended recipient you are hereby notified that any
disclosure, copying, distribution, or any other use of the information
is strictly prohibited. If you have received this document by mistake,
please notify the sender immediately and destroy this document and
attachments without making any copy of any kind.






__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[Jon Hall]

MSXML is quite proper imho, and I prefer DOM based parsing. Lets not get
into which features it has that CF doesn't either. :)

The Allaire reference was just because it was a programmer working at
Allaire that implemented for-in and cfloop and decided that they should be
implemented differently, even though if the cfloop code was written well, it
should have been a fairly easy to write for-in to use the same methods as
cfloop-collection., or maybe they decided not to do that for some other
reason...like they were trying to get CF5 out the door as quickly as
possible so they could work on Neo, which would be entirely acceptable to
me. I just was wondering if I for-in worked like cfloop :)

jon
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 4:51 PM
Subject: Re: cfscript for in vs cfloop collection...


> What is transDOM then?  I'm gathering that's an XML object?  Have you
> looked into the proper xml functions?  What does Allaire have to do with
> your code below btw?
>
> ~Todd
>
>
> On Mon, 15 Jul 2002, Jon Hall wrote:
>
> > Tried it...wont work. It says it's not a valid CF structure, which it
> > isn't...but I was hoping that they were equivalets. Seems strange for CF
to
> > not use the same cfloop-collection code when implementing for-in. Maybe
> > Allaire wasn't into code reuse, or the code was really really nasty :)
> >
> > jon
> >
>
> --
> 
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
> Team Macromedia Volunteer for ColdFusion   |
> http://www.macromedia.com/support/forums/team_macromedia/  |
> http://www.flashCFM.com/   - webRat (Moderator)|
> http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
> 
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[Jon Hall]

No...it's a COM object. Which I am sure is the problem.

- Original Message - 
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 3:53 PM
Subject: RE: cfscript for in vs cfloop collection...


> Is transDOM.selectNodes("/TrackResponse/Activity") returning a
> structure? I mean a real CF structure?


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Joe Bastian]

Yea i didnt see the Syntax for For-In until like around 6 months ago.
for (key in MyStruct)
{
writeoutput(Key &" =" & MyStruct[key]);
}

Joe

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:00 PM
To: CF-Talk
Subject: RE: cfscript for in vs cfloop collection...


Yep... the for loop expects a counter (for (i = 1; i le Len(somevar); i = i
+ 1) ) There is no "in" key word for it.  sorry.  You will have to determine
the number of childnodes in /trackresponse/activity and use that as your
counter.

mark

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: cfscript for in vs cfloop collection...


Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.

This works fine:


This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {

Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?

jon



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[todd]

What is transDOM then?  I'm gathering that's an XML object?  Have you 
looked into the proper xml functions?  What does Allaire have to do with 
your code below btw?

~Todd


On Mon, 15 Jul 2002, Jon Hall wrote:

> Tried it...wont work. It says it's not a valid CF structure, which it
> isn't...but I was hoping that they were equivalets. Seems strange for CF to
> not use the same cfloop-collection code when implementing for-in. Maybe
> Allaire wasn't into code reuse, or the code was really really nasty :)
> 
> jon
> 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server Date Error

[Douglas Jordon]

Thanks for the answers... it turned out to be the field AFTER the date 
which had been a date but then was changed to a varchar. I hadn't 
changed the table design on the server... D'oh!

Joe Bastian wrote:
> Easy way.. if insert just use SQL Server GetDate() time stamp.
> 
> To your question.. CreateODBCDateTime doesnt always work well..
> read it in some docs..
> Do some like this if you still want to use it.
>  (y,m,d,h,m,s)
> 
> 
> Joe
> Certified Advanced ColdFusion Developer
> [EMAIL PROTECTED] 
> 
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 4:25 PM
> To: CF-Talk
> Subject: Re: SQL Server Date Error
> 
> 
> 
>>Al Everett wrote:
>>
I'm getting this when writing a date to a datetime len 8 in SQL Server
>>>
>>>
2000 in a hosted environment:

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
converting datetime from character string.

It returns the error on any valid dates in mm/dd/yy format. I have
several date fields in other places but they're OK. I've
tried with and without quotes.
>>>
>>>
>>>This may be a silly question, but did you put your string inside a
>>>CreateODBCDate() function?
>>
> 
>>I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell).
>>  I have CF code to validate the date. And it works on our development
>>server.
> 
> 
> FYI, No quotes around the CreateODBCWhatever() functions ...
> You might also try using  ...
> 
> Isaac Dealey
> www.turnkey.to
> 954-776-0046
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Raymond Camden]

Is transDOM.selectNodes("/TrackResponse/Activity") returning a
structure? I mean a real CF structure?

===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 4:48 PM
> To: CF-Talk
> Subject: Re: cfscript for in vs cfloop collection...
> 
> 
> Tried it...wont work. It says it's not a valid CF structure, 
> which it isn't...but I was hoping that they were equivalets. 
> Seems strange for CF to not use the same cfloop-collection 
> code when implementing for-in. Maybe Allaire wasn't into code 
> reuse, or the code was really really nasty :)
> 
> jon
> - Original Message -
> From: "S. Isaac Dealey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 15, 2002 4:30 PM
> Subject: Re: cfscript for in vs cfloop collection...
> 
> 
> > > This works fine:
> > >  > > collection="#transDOM.selectNodes("/TrackResponse/Activity")#"
> > > item="i">
> > >
> > > This throws an invalid parser construct error at the second 
> > > parentheses (yes I have tried both single and double 
> quotes): for ( 
> > > i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
> > >
> > > Am I wrong in assuming that cfloop-collection and cfscript for-in 
> > > loops are the same?
> >
> > You might try setting the pointer to the object above the loop...
> >
> > myxmlobject = objMXLCOM.selectNodes('/TrackResponse/Activity');
> > for (i in myxmlobject) {
> > ... whatever...
> > }
> >
> > it may just be that CF doesn't like that syntax for some 
> unspecified 
> > reason...
> >
> > Isaac Dealey
> >
> > www.turnkey.to
> > 954-776-0046
> > 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server Date Error

[Joe Bastian]

Easy way.. if insert just use SQL Server GetDate() time stamp.

To your question.. CreateODBCDateTime doesnt always work well..
read it in some docs..
Do some like this if you still want to use it.
 (y,m,d,h,m,s)


Joe
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED] 

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:25 PM
To: CF-Talk
Subject: Re: SQL Server Date Error


> Al Everett wrote:
>>>I'm getting this when writing a date to a datetime len 8 in SQL Server
>>
>>
>>>2000 in a hosted environment:
>>>
>>>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
>>>converting datetime from character string.
>>>
>>>It returns the error on any valid dates in mm/dd/yy format. I have
>>>several date fields in other places but they're OK. I've
>>>tried with and without quotes.
>>
>>
>> This may be a silly question, but did you put your string inside a
>> CreateODBCDate() function?

> I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell).
>   I have CF code to validate the date. And it works on our development
> server.

FYI, No quotes around the CreateODBCWhatever() functions ...
You might also try using  ...

Isaac Dealey
www.turnkey.to
954-776-0046

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[Jon Hall]

Tried it...wont work. It says it's not a valid CF structure, which it
isn't...but I was hoping that they were equivalets. Seems strange for CF to
not use the same cfloop-collection code when implementing for-in. Maybe
Allaire wasn't into code reuse, or the code was really really nasty :)

jon
- Original Message -
From: "S. Isaac Dealey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 4:30 PM
Subject: Re: cfscript for in vs cfloop collection...


> > This works fine:
> >  > item="i">
> >
> > This throws an invalid parser construct error at the second
> > parentheses (yes I have tried both single and double quotes):
> > for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
> >
> > Am I wrong in assuming that cfloop-collection and cfscript
> > for-in loops are the same?
>
> You might try setting the pointer to the object above the loop...
>
> myxmlobject = objMXLCOM.selectNodes('/TrackResponse/Activity');
> for (i in myxmlobject) {
> ... whatever...
> }
>
> it may just be that CF doesn't like that syntax for some unspecified
> reason...
>
> Isaac Dealey
>
> www.turnkey.to
> 954-776-0046
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: coldfusion.server.ServiceFactory ?

[Ryan Kime]

I can get the query count and the names of the datasources, but not Cached
queries.

   
  
   
  
  

  
  
  
  
  
  
ERROR!!! - #cfcatch.Message#
  
   
   


#getCache()#


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 3:24 PM
To: CF-Talk
Subject: RE: coldfusion.server.ServiceFactory ?


Thanks Ryan...Ya I noticed the following:

getCachedQuery (returns java.lang.Object)
setCachedQuery (returns void)
purgeQueryCache (returns void)

I've tried invoking them but to no avail...






also tried



Anyway thanks!

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[S . Isaac Dealey]

> No kidding?  Where is that documented?

Yea, I don't remember the for-in syntax being documented in the Developing
Web Applications with ColdFusion pdf either... but it does work... it's
standard C/C++/Java/JavaScript syntax which is what they were trying to
emulate with cfscript -- which is also why switch(x) functions differently
than 


Isaac Dealey

www.turnkey.to
954-776-0046
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[Stacy Young]

Prob just folks caching in overtime from the MX initiative! Have a good one
folks...


-Original Message-
From: Vernon Viehe [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 4:30 PM
To: CF-Talk
Subject: RE: I'll be offline for a couple weeks

Uhm, unless the occurance of summer vacations is now considered "fishy"
(which I suppose, depending on your vacation venue, that could be
appropriate), it's nothing out of the ordinary!

-V

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 12:21 PM
> To: CF-Talk
> Subject: RE: I'll be offline for a couple weeks
> 
> 
> Me thinks there's something fishy going on!
> 
> On Mon, 15 Jul 2002, Raymond Camden wrote:
> 
> > Not that I think people will miss me (grin), but I'll be 
> out next week
> > as well.
> > 
> > 
> ==
> =
> > Raymond Camden, ColdFusion Jedi Master for Macromedia
> > > 
> > > 
> > > Where the heck are all these macromedia folks going anyways? 
> > > :)  JD is out 
> > > too.
> 
> -- 
> 
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
> Team Macromedia Volunteer for ColdFusion   |
> http://www.macromedia.com/support/forums/team_macromedia/  |
> http://www.flashCFM.com/   - webRat (Moderator)|
> http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
> 
> 
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[S . Isaac Dealey]

> This works fine:
>  item="i">
>
> This throws an invalid parser construct error at the second
> parentheses (yes I have tried both single and double quotes):
> for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
>
> Am I wrong in assuming that cfloop-collection and cfscript
> for-in loops are the same?

You might try setting the pointer to the object above the loop...

myxmlobject = objMXLCOM.selectNodes('/TrackResponse/Activity');
for (i in myxmlobject) {
... whatever...
}

it may just be that CF doesn't like that syntax for some unspecified
reason...

Isaac Dealey

www.turnkey.to
954-776-0046
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[Vernon Viehe]

Uhm, unless the occurance of summer vacations is now considered "fishy" (which I 
suppose, depending on your vacation venue, that could be appropriate), it's nothing 
out of the ordinary!

-V

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 12:21 PM
> To: CF-Talk
> Subject: RE: I'll be offline for a couple weeks
> 
> 
> Me thinks there's something fishy going on!
> 
> On Mon, 15 Jul 2002, Raymond Camden wrote:
> 
> > Not that I think people will miss me (grin), but I'll be 
> out next week
> > as well.
> > 
> > 
> ==
> =
> > Raymond Camden, ColdFusion Jedi Master for Macromedia
> > > 
> > > 
> > > Where the heck are all these macromedia folks going anyways? 
> > > :)  JD is out 
> > > too.
> 
> -- 
> 
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
> Team Macromedia Volunteer for ColdFusion   |
> http://www.macromedia.com/support/forums/team_macromedia/  |
> http://www.flashCFM.com/   - webRat (Moderator)|
> http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[todd]

I found it in my CFStudio:

E:\Development\CFStudio5\Help\Developing_ColdFusion_Applications\CFScript3.html#1106683

(replace e:\Development\ with the proper install path of your own)

~Todd

On Mon, 15 Jul 2002, Mark A. Kruger - CFG wrote:

> Man... I see it in the docs online. I have never seen the for-in loop in the
> help section of cf studio - nor have I run into it elswhere.  that could
> have saved me a lot of counter code .  Live and learn.
> 
> -mk
> 
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:08 PM
> To: CF-Talk
> Subject: RE: cfscript for in vs cfloop collection...
> 
> 
> Incorrect. for(x in foo) normally works just fine.
> 
> 
> x = structNew();
> x.alpha = "ray";
> x.gamma = "camden";
> 
> for(i in x) {
>   writeOutput("key=#i#, val is #x[i]#");
> }
> 
> 
> ===
> Raymond Camden, ColdFusion Jedi Master for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda
> 
> > -Original Message-
> > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 4:00 PM
> > To: CF-Talk
> > Subject: RE: cfscript for in vs cfloop collection...
> >
> >
> > Yep... the for loop expects a counter (for (i = 1; i le
> > Len(somevar); i = i
> > + 1) ) There is no "in" key word for it.  sorry.  You will have to
> > + determine
> > the number of childnodes in /trackresponse/activity and use
> > that as your counter.
> >
> > mark
> >
> > -Original Message-
> > From: Jon Hall [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 2:56 PM
> > To: CF-Talk
> > Subject: cfscript for in vs cfloop collection...
> >
> >
> > Perhaps someone else can see what I am doing wrong here
> > (cf5). I've had this problem in the past, and just included
> > the code inline with a cfloop around my cfscript, but now I
> > want to convert the code to a UDF... Here is the code.
> >
> > This works fine:
> >  > item="i">
> >
> > This throws an invalid parser construct error at the second
> > parentheses (yes I have tried both single and double quotes):
> > for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
> >
> > Am I wrong in assuming that cfloop-collection and cfscript
> > for-in loops are the same?
> >
> > jon
> >
> >
> >
> 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server Date Error

[S . Isaac Dealey]

> Al Everett wrote:
>>>I'm getting this when writing a date to a datetime len 8 in SQL Server
>>
>>
>>>2000 in a hosted environment:
>>>
>>>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error
>>>converting datetime from character string.
>>>
>>>It returns the error on any valid dates in mm/dd/yy format. I have
>>>several date fields in other places but they're OK. I've
>>>tried with and without quotes.
>>
>>
>> This may be a silly question, but did you put your string inside a
>> CreateODBCDate() function?

> I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell).
>   I have CF code to validate the date. And it works on our development
> server.

FYI, No quotes around the CreateODBCWhatever() functions ...
You might also try using  ...

Isaac Dealey
www.turnkey.to
954-776-0046
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: coldfusion.server.ServiceFactory ?

[Stacy Young]

Thanks Ryan...Ya I noticed the following:

getCachedQuery (returns java.lang.Object)
setCachedQuery (returns void)
purgeQueryCache (returns void)

I've tried invoking them but to no avail...






also tried



Anyway thanks!


-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 3:16 PM
To: CF-Talk
Subject: RE: coldfusion.server.ServiceFactory ?

Whoops! getCacheQuery() should be getCachedQuery()

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:02 PM
To: CF-Talk
Subject: RE: coldfusion.server.ServiceFactory ?


Stacy,

Try this little chunk of code, looks like there's a getCacheQuery() function
in coldfusion.sql.Executive:




-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 1:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?


In one of Ben Forta's UDFs I see his getting into some Java functionality to
access query data. I'm wondering if anyone can lead me onto a way of
accessing what queries are currently cached in the app server? I've always
wanted to be able to actively monitor/adjust querying caching based on
what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.

WARNING:  
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited. If
you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.





__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Christopher Olive]

try removing the # signs from around the collection name, and if that
doesn't work, double your ""'s inside the outside ""s...

examples:





-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:56 PM
To: CF-Talk
Subject: cfscript for in vs cfloop collection...


Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.

This works fine:


This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {

Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?

jon


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Mark A. Kruger - CFG]

Man... I see it in the docs online. I have never seen the for-in loop in the
help section of cf studio - nor have I run into it elswhere.  that could
have saved me a lot of counter code .  Live and learn.

-mk

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:08 PM
To: CF-Talk
Subject: RE: cfscript for in vs cfloop collection...


Incorrect. for(x in foo) normally works just fine.


x = structNew();
x.alpha = "ray";
x.gamma = "camden";

for(i in x) {
writeOutput("key=#i#, val is #x[i]#");
}


===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 4:00 PM
> To: CF-Talk
> Subject: RE: cfscript for in vs cfloop collection...
>
>
> Yep... the for loop expects a counter (for (i = 1; i le
> Len(somevar); i = i
> + 1) ) There is no "in" key word for it.  sorry.  You will have to
> + determine
> the number of childnodes in /trackresponse/activity and use
> that as your counter.
>
> mark
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:56 PM
> To: CF-Talk
> Subject: cfscript for in vs cfloop collection...
>
>
> Perhaps someone else can see what I am doing wrong here
> (cf5). I've had this problem in the past, and just included
> the code inline with a cfloop around my cfscript, but now I
> want to convert the code to a UDF... Here is the code.
>
> This works fine:
>  item="i">
>
> This throws an invalid parser construct error at the second
> parentheses (yes I have tried both single and double quotes):
> for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
>
> Am I wrong in assuming that cfloop-collection and cfscript
> for-in loops are the same?
>
> jon
>
>
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Mark A. Kruger - CFG]

No kidding?  Where is that documented?

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:08 PM
To: CF-Talk
Subject: RE: cfscript for in vs cfloop collection...


Incorrect. for(x in foo) normally works just fine.


x = structNew();
x.alpha = "ray";
x.gamma = "camden";

for(i in x) {
writeOutput("key=#i#, val is #x[i]#");
}


===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 4:00 PM
> To: CF-Talk
> Subject: RE: cfscript for in vs cfloop collection...
>
>
> Yep... the for loop expects a counter (for (i = 1; i le
> Len(somevar); i = i
> + 1) ) There is no "in" key word for it.  sorry.  You will have to
> + determine
> the number of childnodes in /trackresponse/activity and use
> that as your counter.
>
> mark
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:56 PM
> To: CF-Talk
> Subject: cfscript for in vs cfloop collection...
>
>
> Perhaps someone else can see what I am doing wrong here
> (cf5). I've had this problem in the past, and just included
> the code inline with a cfloop around my cfscript, but now I
> want to convert the code to a UDF... Here is the code.
>
> This works fine:
>  item="i">
>
> This throws an invalid parser construct error at the second
> parentheses (yes I have tried both single and double quotes):
> for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
>
> Am I wrong in assuming that cfloop-collection and cfscript
> for-in loops are the same?
>
> jon
>
>
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript for in vs cfloop collection...

[Jon Hall]

"for-in loop: for (variable in collection) statement ;
Note that variable can be any ColdFusion identifier, and collection must be
the name of an existing ColdFusion structure.
for (x in mystruct) mystruct[x]=0;"

http://www.macromedia.com/v1/cfdocs/Advanced_ColdFusion_Development/08_Using
_CFML_Scripting/adv08_2.htm

Although I can do what you suggest, I'd prefer not to in this case. It's
really looking like for-in loops are limited to CF structures only unlike
cfloop. Anyone know for sure?

jon
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 4:00 PM
Subject: RE: cfscript for in vs cfloop collection...


> Yep... the for loop expects a counter (for (i = 1; i le Len(somevar); i =
i
> + 1) ) There is no "in" key word for it.  sorry.  You will have to
determine
> the number of childnodes in /trackresponse/activity and use that as your
> counter.
>
> mark
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:56 PM
> To: CF-Talk
> Subject: cfscript for in vs cfloop collection...
>
>
> Perhaps someone else can see what I am doing wrong here (cf5). I've had
this
> problem in the past, and just included the code inline with a cfloop
around
> my cfscript, but now I want to convert the code to a UDF...
> Here is the code.
>
> This works fine:
>  item="i">
>
> This throws an invalid parser construct error at the second parentheses
(yes
> I have tried both single and double quotes):
> for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
>
> Am I wrong in assuming that cfloop-collection and cfscript for-in loops
are
> the same?
>
> jon
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Get rid of session variables when browser closes

[Chris Norloff]

I don't think you CAN kill session variables just when a browser closes, since that's 
a client action and session variables live on the CF server.  Once CF serves up a 
page, it has no idea what's happening in the browser until another request comes from 
the browser.

Now you CAN kill all session vars by deleting their structure (see below) then 
deleting the cookies that contain the CFID/CFTOKEN that identify those session vars. 
The session vars you can kill after timing out; the cookies won't be deleted until the 
browser makes another request of the server.

And if you use non-persistent cookies (also called session cookies) then when ALL 
instances of the browser close then all the cookies are deleted.

Chris Norloff










-- Original Message --
from: "Haggerty, Mike" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 15 Jul 2002 14:39:17 -0400

>I am working on a project where it is essential all session variables are
>killed when the browser closes. 
>
>What starategies are others using to make this happen? what I am considering
>is a javascript solution that loads a new page when the window closes.
>Obviously, this is not bulletproof...
>
>M
>
>
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

a moment of your time please?

[Eric]

  I have something I've been struggling with for a little while now, and 
while after exhaustive research I think I'm on the right path I'm not sure 
I understand quite what the actual solution is.

  I have a members only website. I use session variables to allow users to 
move around within the site once they have logged in.

  It has come to light that AOL users get a much slower response time than 
people using "normal" ISP's (no offense intended to AOL users!)

  In all the reading I've now done, my thinking is that the progressive 
proxy servers they use at AOL may be hindering my client variables... am I 
on the right track here?

  has anyone run into this and found a solution for this?
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Raymond Camden]

Incorrect. for(x in foo) normally works just fine. 


x = structNew();
x.alpha = "ray";
x.gamma = "camden";

for(i in x) {
writeOutput("key=#i#, val is #x[i]#");
}


===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 4:00 PM
> To: CF-Talk
> Subject: RE: cfscript for in vs cfloop collection...
> 
> 
> Yep... the for loop expects a counter (for (i = 1; i le 
> Len(somevar); i = i
> + 1) ) There is no "in" key word for it.  sorry.  You will have to 
> + determine
> the number of childnodes in /trackresponse/activity and use 
> that as your counter.
> 
> mark
> 
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:56 PM
> To: CF-Talk
> Subject: cfscript for in vs cfloop collection...
> 
> 
> Perhaps someone else can see what I am doing wrong here 
> (cf5). I've had this problem in the past, and just included 
> the code inline with a cfloop around my cfscript, but now I 
> want to convert the code to a UDF... Here is the code.
> 
> This works fine:
>  item="i">
> 
> This throws an invalid parser construct error at the second 
> parentheses (yes I have tried both single and double quotes): 
> for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
> 
> Am I wrong in assuming that cfloop-collection and cfscript 
> for-in loops are the same?
> 
> jon
> 
> 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Oracle service name

[Chris Norloff]

Oracle Service Names are also called Database Aliases. They're in the tnsnames.ora 
file. (CF 4.5.2, Solaris 8, Oracle 8i)

Here's a typical example. PONE6.WORLD is what you'd enter as a host string when 
configuring CF to talk to Oracle. If sqlnet.ora has "names.default_domain = world" 
then you can leave off the .WORLD (in this example), I think.

PONE6.WORLD = 
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA = 
  (SID = PONE6)
)
  )

More info "Connecting to Oracle 7.3/8.0 Databases" in the Administering CF 
documentation.


Chris Norloff

-- Original Message --
from: "Kris Pilles" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 15 Jul 2002 12:19:56 -0400

>Can anyone tell me where I can find the oracle service name's
>location???
>
>Thanks
>
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Get rid of session variables when browser closes

[Haggerty, Mike]

The point is that it is setting each cookie to expire when the browser
closes. In this way, the CFID and CFTOKEN values go away and all the old
session variables are... well, inaccessable.

At least, that is how it is supposed to work! Probably is working for
everyone except me, the CF gods seem to be angered with me today.

(Mr. Forta, please put in a good word for me with your Father).

M

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:58 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Mike,

I'm not sure why this would work? Isn't it simply setting the values of
cookie.cfid  and cookie.token to themselves?

Mark

-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:48 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Am I doing something wrong?

I put the following code in my CFAPPLICATION tag but am still able to close
the browser, reopen the browser, and see the values of my session variables
as they were set prior to closing the browser:









M

-Original Message-
From: Stover, John [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Thanks, Hal!








?


--
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:39:17 PM, you wrote:

HM> I am working on a project where it is essential all session
variables are
HM> killed when the browser closes.

HM> What starategies are others using to make this happen? what I am
considering
HM> is a javascript solution that loads a new page when the window
closes.
HM> Obviously, this is not bulletproof...

HM> M





__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfscript for in vs cfloop collection...

[Mark A. Kruger - CFG]

Yep... the for loop expects a counter (for (i = 1; i le Len(somevar); i = i
+ 1) ) There is no "in" key word for it.  sorry.  You will have to determine
the number of childnodes in /trackresponse/activity and use that as your
counter.

mark

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: cfscript for in vs cfloop collection...


Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.

This works fine:


This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {

Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?

jon


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Get rid of session variables when browser closes

[Mark A. Kruger - CFG]

Mike,

I'm not sure why this would work? Isn't it simply setting the values of
cookie.cfid  and cookie.token to themselves?

Mark

-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:48 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Am I doing something wrong?

I put the following code in my CFAPPLICATION tag but am still able to close
the browser, reopen the browser, and see the values of my session variables
as they were set prior to closing the browser:









M

-Original Message-
From: Stover, John [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Thanks, Hal!








?


--
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:39:17 PM, you wrote:

HM> I am working on a project where it is essential all session
variables are
HM> killed when the browser closes.

HM> What starategies are others using to make this happen? what I am
considering
HM> is a javascript solution that loads a new page when the window
closes.
HM> Obviously, this is not bulletproof...

HM> M




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfscript for in vs cfloop collection...

[Jon Hall]

Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.

This works fine:


This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {

Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?

jon

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Get rid of session variables when browser closes

[Haggerty, Mike]

Am I doing something wrong?

I put the following code in my CFAPPLICATION tag but am still able to close
the browser, reopen the browser, and see the values of my session variables
as they were set prior to closing the browser:









M

-Original Message-
From: Stover, John [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: RE: Get rid of session variables when browser closes


Thanks, Hal!








?


-- 
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:39:17 PM, you wrote:

HM> I am working on a project where it is essential all session
variables are
HM> killed when the browser closes. 

HM> What starategies are others using to make this happen? what I am
considering
HM> is a javascript solution that loads a new page when the window
closes.
HM> Obviously, this is not bulletproof...

HM> M



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server Date Error

[Douglas Jordon]

Al Everett wrote:
>>I'm getting this when writing a date to a datetime len 8 in SQL Server
> 
> 
>>2000 in a hosted environment:
>>
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error 
>>converting datetime from character string.
>>
>>It returns the error on any valid dates in mm/dd/yy format. I have 
>>several date fields in other places but they're OK. I've 
>>tried with and without quotes.
> 
> 
> This may be a silly question, but did you put your string inside a
> CreateODBCDate() function?

I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell). 
  I have CF code to validate the date. And it works on our development 
server.

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[Ryan Kime]

speculation: They are all going to Macromedia's house in the Hamptons to
film "The Hamptons part 2".

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:14 PM
To: CF-Talk
Subject: Re: I'll be offline for a couple weeks


Where the heck are all these macromedia folks going anyways? :)  JD is out 
too.

On Mon, 15 Jul 2002, Vernon Viehe wrote:

> Hi all,
> 
> I'll be offline for the next 2 weeks. I'll return to the office around 
> July 30th.
> 
> During this time, I'll be unsubscribed from the e-mail lists which I 
> normally monitor/participate in, however, the other usual Macromedia 
> folks will be around.
> 
> See you all in a couple weeks!
> 
> Thanks,
> 
> Vernon Viehe
> ColdFusion Community Manager
> Developer Relations
> Macromedia, Inc.
> Online diary: http://vvmx.blogspot.com/

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[todd]

Me thinks there's something fishy going on!

On Mon, 15 Jul 2002, Raymond Camden wrote:

> Not that I think people will miss me (grin), but I'll be out next week
> as well.
> 
> ===
> Raymond Camden, ColdFusion Jedi Master for Macromedia
> > 
> > 
> > Where the heck are all these macromedia folks going anyways? 
> > :)  JD is out 
> > too.

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[Ben Forta]

Well, you slackers go have your fun ... some of us will be hard at work
here. :-)




-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:23 PM
To: CF-Talk
Subject: RE: I'll be offline for a couple weeks


Not that I think people will miss me (grin), but I'll be out next week
as well.

===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 3:14 PM
> To: CF-Talk
> Subject: Re: I'll be offline for a couple weeks
> 
> 
> Where the heck are all these macromedia folks going anyways?
> :)  JD is out 
> too.


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server Date Error

[Al Everett]

> I'm getting this when writing a date to a datetime len 8 in SQL Server

> 2000 in a hosted environment:
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error 
> converting datetime from character string.
> 
> It returns the error on any valid dates in mm/dd/yy format. I have 
> several date fields in other places but they're OK. I've 
> tried with and without quotes.

This may be a silly question, but did you put your string inside a
CreateODBCDate() function?

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I'll be offline for a couple weeks

[Raymond Camden]

Not that I think people will miss me (grin), but I'll be out next week
as well.

===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 3:14 PM
> To: CF-Talk
> Subject: Re: I'll be offline for a couple weeks
> 
> 
> Where the heck are all these macromedia folks going anyways? 
> :)  JD is out 
> too.

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: I'll be offline for a couple weeks

[todd]

Where the heck are all these macromedia folks going anyways? :)  JD is out 
too.

On Mon, 15 Jul 2002, Vernon Viehe wrote:

> Hi all,
> 
> I'll be offline for the next 2 weeks. I'll return to the office around July 30th.
> 
> During this time, I'll be unsubscribed from the e-mail lists which I normally 
>monitor/participate in, however, the other usual Macromedia folks will be around.
> 
> See you all in a couple weeks!
> 
> Thanks,
> 
> Vernon Viehe
> ColdFusion Community Manager
> Developer Relations
> Macromedia, Inc.
> Online diary: http://vvmx.blogspot.com/ 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: coldfusion.server.ServiceFactory ?

[Ryan Kime]

Whoops! getCacheQuery() should be getCachedQuery()

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:02 PM
To: CF-Talk
Subject: RE: coldfusion.server.ServiceFactory ?


Stacy,

Try this little chunk of code, looks like there's a getCacheQuery() function
in coldfusion.sql.Executive:




-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 1:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?


In one of Ben Forta's UDFs I see his getting into some Java functionality to
access query data. I'm wondering if anyone can lead me onto a way of
accessing what queries are currently cached in the app server? I've always
wanted to be able to actively monitor/adjust querying caching based on
what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.

WARNING:  
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited. If
you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

I'll be offline for a couple weeks

[Vernon Viehe]

Hi all,

I'll be offline for the next 2 weeks. I'll return to the office around July 30th.

During this time, I'll be unsubscribed from the e-mail lists which I normally 
monitor/participate in, however, the other usual Macromedia folks will be around.

See you all in a couple weeks!

Thanks,

Vernon Viehe
ColdFusion Community Manager
Developer Relations
Macromedia, Inc.
Online diary: http://vvmx.blogspot.com/ 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re[2]: Get rid of session variables when browser closes

[Critter]

oi John!!

si


-- 
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:56:20 PM, you wrote:

SJ> Thanks, Hal!

SJ> 
SJ> 
SJ> 
SJ> 
SJ> 
SJ> 

SJ> ?

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL Server Date Error

[Douglas Jordon]

I'm getting this when writing a date to a datetime len 8 in SQL Server 
2000 in a hosted environment:

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting 
datetime from character string.

It returns the error on any valid dates in mm/dd/yy format. I have 
several date fields in other places but they're OK. I've tried with and 
without quotes.

Thanks,

Doug Jordon

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: coldfusion.server.ServiceFactory ?

[Ryan Kime]

Stacy,

Try this little chunk of code, looks like there's a getCacheQuery() function
in coldfusion.sql.Executive:




-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 1:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?


In one of Ben Forta's UDFs I see his getting into some Java functionality to
access query data. I'm wondering if anyone can lead me onto a way of
accessing what queries are currently cached in the app server? I've always
wanted to be able to actively monitor/adjust querying caching based on
what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.

WARNING:  
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Get rid of session variables when browser closes

[Stover, John]

Thanks, Hal!








?


-- 
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:39:17 PM, you wrote:

HM> I am working on a project where it is essential all session
variables are
HM> killed when the browser closes. 

HM> What starategies are others using to make this happen? what I am
considering
HM> is a javascript solution that loads a new page when the window
closes.
HM> Obviously, this is not bulletproof...

HM> M


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Get rid of session variables when browser closes

[Critter]

oi Mike!!








?


-- 
Critz
Certified Advanced Bald White Barefoot ColdFusion Developer

Crit[s2k] - 

Monday, July 15, 2002, 2:39:17 PM, you wrote:

HM> I am working on a project where it is essential all session variables are
HM> killed when the browser closes. 

HM> What starategies are others using to make this happen? what I am considering
HM> is a javascript solution that loads a new page when the window closes.
HM> Obviously, this is not bulletproof...

HM> M



HM> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Get rid of session variables when browser closes

[Tangorre, Michael]

http://www.halhelms.com/index.cfm?fuseaction=tutorials.detail

Right above "Non Animated Tutorials"

Hal does a nice job of explaining how this is done.

Mike



-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:39 PM
To: CF-Talk
Subject: Get rid of session variables when browser closes


I am working on a project where it is essential all session variables are
killed when the browser closes. 

What starategies are others using to make this happen? what I am considering
is a javascript solution that loads a new page when the window closes.
Obviously, this is not bulletproof...

M




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Get rid of session variables when browser closes

[Haggerty, Mike]

I am working on a project where it is essential all session variables are
killed when the browser closes. 

What starategies are others using to make this happen? what I am considering
is a javascript solution that loads a new page when the window closes.
Obviously, this is not bulletproof...

M



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Stacy Young]

Crap! Thanks Ben...On my way over to the suggestion box...


-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:20 PM
To: CF-Talk
Subject: RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

Stacy,

I tried that one, it is not exposed to the ServiceFactory and I checked
with the developer and he said there were no exposed API's for that one
at all. Sorry.

--- Ben


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:17 PM
To: CF-Talk
Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)


Better yet, are there Javadocs available? :)


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?

In one of Ben Forta's UDFs I see his getting into some Java
functionality to access query data. I'm wondering if anyone can lead me
onto a way of accessing what queries are currently cached in the app
server? I've always wanted to be able to actively monitor/adjust
querying caching based on what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces
jointes sont strictement confidentielles et reservees a l'usage de la
(des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
soyez avise que toute divulgation, distribution, copie, ou autre
utilisation de ces informations est strictement prohibee.  Si vous avez
recu ce document par erreur, veuillez s'il vous plait communiquer
immediatement avec l'expediteur et detruire ce document sans en faire de
copie sous quelque forme.

WARNING:  
---
The information contained in this document and attachments is
confidential and intended only for the person(s) named above.  If you
are not the intended recipient you are hereby notified that any
disclosure, copying, distribution, or any other use of the information
is strictly prohibited. If you have received this document by mistake,
please notify the sender immediately and destroy this document and
attachments without making any copy of any kind.





__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Ben Forta]

Stacy,

I tried that one, it is not exposed to the ServiceFactory and I checked
with the developer and he said there were no exposed API's for that one
at all. Sorry.

--- Ben


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:17 PM
To: CF-Talk
Subject: JAVADOCS (RE: coldfusion.server.ServiceFactory ?)


Better yet, are there Javadocs available? :)


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?

In one of Ben Forta's UDFs I see his getting into some Java
functionality to access query data. I'm wondering if anyone can lead me
onto a way of accessing what queries are currently cached in the app
server? I've always wanted to be able to actively monitor/adjust
querying caching based on what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces
jointes sont strictement confidentielles et reservees a l'usage de la
(des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
soyez avise que toute divulgation, distribution, copie, ou autre
utilisation de ces informations est strictement prohibee.  Si vous avez
recu ce document par erreur, veuillez s'il vous plait communiquer
immediatement avec l'expediteur et detruire ce document sans en faire de
copie sous quelque forme.

WARNING:  
---
The information contained in this document and attachments is
confidential and intended only for the person(s) named above.  If you
are not the intended recipient you are hereby notified that any
disclosure, copying, distribution, or any other use of the information
is strictly prohibited. If you have received this document by mistake,
please notify the sender immediately and destroy this document and
attachments without making any copy of any kind.




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMX beta volunteers needed

[Margaret Waters]

We're about to launch the beta program for CFMX for J2EE servers. We're looking for 
beta volunteers to test the new ColdFusion MX for J2EE release on JRun 4. The existing 
release of CFMX runs on an integrated version of JRun. This beta release is for a 
ColdFusion MX server that sits on top of JRun 4, IBM WebSphere, or Sun ONE(iPlanet web 
server).   

We're looking for developers with experience running both CF and these app servers. 
Please send me an email if you're interested in participating, and note which beta 
program you'd like to join: IBM WebSphere, JRun 4, or Sun ONE.

thanks,

Margaret Waters 


Margaret M. Waters
Product Manager
Macromedia, Inc.
617-219-2138
[EMAIL PROTECTED]

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JAVADOCS (RE: coldfusion.server.ServiceFactory ?)

[Stacy Young]

Better yet, are there Javadocs available? :)


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 2:06 PM
To: CF-Talk
Subject: coldfusion.server.ServiceFactory ?

In one of Ben Forta's UDFs I see his getting into some Java functionality to
access query data. I'm wondering if anyone can lead me onto a way of
accessing what queries are currently cached in the app server? I've always
wanted to be able to actively monitor/adjust querying caching based on
what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.

WARNING:  
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

coldfusion.server.ServiceFactory ?

[Stacy Young]

In one of Ben Forta's UDFs I see his getting into some Java functionality to
access query data. I'm wondering if anyone can lead me onto a way of
accessing what queries are currently cached in the app server? I've always
wanted to be able to actively monitor/adjust querying caching based on
what's in memory already and what not...

 

Thanks in advance!

 

 

Stacy Young

System Integration Specialist, Architecture

Surefire Commerce

http://www.sfcommerce.com  

(p) 514-380-2700 ext: 3234

(f) 514-380-2760

 



AVIS IMPORTANT: 
---
Les informations contenues dans le present document et ses pieces jointes sont 
strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il 
est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, 
distribution, copie, ou autre utilisation de ces informations est strictement 
prohibee.  Si vous avez recu ce document par erreur, veuillez s'il vous plait 
communiquer immediatement avec l'expediteur et detruire ce document sans en faire de 
copie sous quelque forme.

WARNING:  
---
The information contained in this document and attachments is confidential and 
intended only for the person(s) named above.  If you are not the intended recipient 
you are hereby notified that any disclosure, copying, distribution, or any other use 
of the information is strictly prohibited.  If you have received this document by 
mistake, please notify the sender immediately and destroy this document and 
attachments without making any copy of any kind.


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Best way to resend undelvr

[Al Everett]

> Gnarly.  So, I could just make a scheduled task to a little 
> cffile functionality to do this automagically, eh?

You could, and this would be fine for mail not delivered because of
transient connection problems. Mail that's not sent because of a bad
address et. al. will just get dropped in the Undeliverable directory
again. (Doing nothing but filling up your mail log.)

Note: There are several tags on the Developer exchange to do this for
you, but only work on 5.0 or earlier. The file formats and file naming
convention CFMX uses for the mail spool files is quite different than
earlier versions.

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Best way to resend undelvr

[Alex]

move what's in the undelivr folder to the spool folder. A scheduled DOS
batch file could do it in a couple lines.

On Mon, 15 Jul 2002, Willy Ray wrote:

> What's the best way to check my undeliverable mail folder and the
> automatically RESEND the mail?
>
> Willy Ray
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Best way to resend undelvr

[Willy Ray]

Gnarly.  So, I could just make a scheduled task to a little cffile
functionality to do this automagically, eh?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 07/15/02 10:36AM >>>
What OS?

On Solaris you would cd to /usr/coldfusion/mail/undelivr.  Then you
would mv
* ../spool.

You would want to check and see if they have any bad data first, so
cat
*|more them and check for to and from addresses.

On windows it should be a simple copy and paste job.

Tim Heald
ACP/CCFD :)

Application Development
http://www.schoollink.net 

Fusebox Advisory Committee Member
http://www.fusebox.org 

Manager Fayetteville ColdFusion User Group
http://www.fcfug.org 


> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 12:31 PM
> To: CF-Talk
> Subject: Best way to resend undelvr
>
>
> What's the best way to check my undeliverable mail folder and the
> automatically RESEND the mail?
>
> Willy Ray
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Best way to resend undelvr

[Timothy Heald]

What OS?

On Solaris you would cd to /usr/coldfusion/mail/undelivr.  Then you would mv
* ../spool.

You would want to check and see if they have any bad data first, so cat
*|more them and check for to and from addresses.

On windows it should be a simple copy and paste job.

Tim Heald
ACP/CCFD :)

Application Development
http://www.schoollink.net

Fusebox Advisory Committee Member
http://www.fusebox.org

Manager Fayetteville ColdFusion User Group
http://www.fcfug.org


> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 12:31 PM
> To: CF-Talk
> Subject: Best way to resend undelvr
>
>
> What's the best way to check my undeliverable mail folder and the
> automatically RESEND the mail?
>
> Willy Ray
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oracle service name

[Douglas Brown]

should be  sqlnet.ora




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message - 
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:19 AM
Subject: OT: Oracle service name


> Can anyone tell me where I can find the oracle service name's
> location???
> 
> Thanks
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Best way to resend undelvr

[Willy Ray]

What's the best way to check my undeliverable mail folder and the
automatically RESEND the mail?

Willy Ray




-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Oracle service name

[Kris Pilles]

Can anyone tell me where I can find the oracle service name's
location???

Thanks
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Where does CF store information about itself?

[Al Everett]

> I'm writing an application that will be deployed across a 
> variety of servers. I don't want my application to make any 
> assumptions about where CFMX has been installed or even what 
> OS is running. Where does CF store, for instance, the e-mail 
> spool directory?

In prior versions, it used to be in the Registry:



Of course, that doesn't help in non-Windows environments and is no help
with MX in any case.

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: The drive wars - was hardware question.

[Matt Robertson]

Samcfug wrote:
> As for performance - there will not be a noticeable difference.  

Had an interesting experience with this on a recent project.  A client's
image server houses about 300,000 imaged documents.  A lot of data
pumped down the pipe on every request as users view 200k-1mb images in
rapid succession.  

Formerly the thing ran on a 70gb RAID1 u3w scsi.  Now it's a Snap 480gb
ATA.

After keeping mum about performance to rank-and-file staff, then polling
them, I heard reports that there was no slowdown, and some reported a
speed increase (which of course is incorrect).  *I* can see it running
more slowly if I perform bulk administrative tasks, but no real-world
users know the difference.  

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Slightly OT: DB Object Naming Conventions

[S . Isaac Dealey]

> Does anyone here follow the following naming convention in SQL Server?

> Tables:  tbl_tablename
> Views: vw_viewname
> Stored Procedures: sp_procedurename

> I'm just tyring to get a quick poll as to who might follow this way of
> naming..

> Thanks. You can reply off list to me..

I use some variations... I don't tend to use this naming convention with
tables, usually opting for something like bcpa_user where "bcpa" is the
abbreviation for the client's name. With views I usually use vViewName and
with stored procedures I vary ... when I'm working on a project for a client
I usually use sp_procedurename , though in some of my own projects i've used
variations like tap_procedurename where "tap" is an abbreviation for the
project I'm working on and the prefix is intended primarily to keep my
procedures in a contiguous area in the enterprise manager view... I probably
use vViewName with views because I usually have fewer of them than I have
tables and stored procedures...

Isaac Dealey
www.turnkey.to
954-776-0046
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Where does CF store information about itself?

[Al Everett]

I'm writing an application that will be deployed across a variety of
servers. I don't want my application to make any assumptions about where
CFMX has been installed or even what OS is running. Where does CF store,
for instance, the e-mail spool directory?

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Slightly OT: DB Object Naming Conventions

[Mark A. Kruger - CFG]

Mike,

I append "vw" to views and "inx" to tables.  You should NOT append "SP_" to
a stored procedure.  MSSQL will assume this is a system stored proc and
check system tables for it first - before checking user tables.  That's
additional overhead.  I usually use spProcedureName (no underscore).  As for
tables I try to use a dbname abbrivietion combined with a descriptive table
name.  For example, if the db is "NewProducts" and I had a table called for
inventory, I would probably name it npInventory or np_Inventory.  I do not
use tbl_ or tb_ because MOST of the objects you work with are tables, so if
you specify everything else (inx_ or vw_) then you can think of tb_ as the
"default" object.  Kind of like scoping all variables EXCEPT the variables
scope (which is the first scope assumed).

Mark

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:10 AM
To: CF-Talk
Subject: Slightly OT: DB Object Naming Conventions


Does anyone here follow the following naming convention in SQL Server?

Tables:  tbl_tablename
Views: vw_viewname
Stored Procedures: sp_procedurename

I'm just tyring to get a quick poll as to who might follow this way of
naming..

Thanks. You can reply off list to me..

Mike

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Slightly OT: DB Object Naming Conventions

[ksuh]

You shouldn't use sp_ to preface your stored procs.  System stored 
procedures in SQL Server start with sp_.  You may end up with a 
collision one day...  Also, any SP that start with sp_, SQL Server will 
first search the master database for that stored procedure.

- Original Message -
From: "Tangorre, Michael" <[EMAIL PROTECTED]>
Date: Monday, July 15, 2002 9:09 am
Subject: Slightly OT: DB Object Naming Conventions

> Does anyone here follow the following naming convention in SQL Server?
> 
> Tables:  tbl_tablename
> Views: vw_viewname
> Stored Procedures: sp_procedurename
> 
> I'm just tyring to get a quick poll as to who might follow this 
> way of naming..
> 
> Thanks. You can reply off list to me.. 
> 
> Mike
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Slightly OT: DB Object Naming Conventions

[Dave Watts]

> Does anyone here follow the following naming convention 
> in SQL Server?
> 
> Tables:  tbl_tablename
> Views: vw_viewname
> Stored Procedures: sp_procedurename

I'd recommend against using the "sp_" prefix for stored procedure names, as
that prefix is used by system stored procedures, and I think that SQL Server
looks for procedures with that prefix in the master database before looking
in the specific database that you're using.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Slightly OT: DB Object Naming Conventions

[Tangorre, Michael]

Does anyone here follow the following naming convention in SQL Server?

Tables:  tbl_tablename
Views: vw_viewname
Stored Procedures: sp_procedurename

I'm just tyring to get a quick poll as to who might follow this way of naming..

Thanks. You can reply off list to me.. 

Mike
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFC and Scope

[Raymond Camden]

In general, you should always have the CFC just return the data. Let the
caller worry about placing the data in the request scope. 



===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 11:02 AM
> To: CF-Talk
> Subject: CFC and Scope
> 
> 
> What is the best practice for the following situation.
> 
> I have a CFC in which I run a few queries and build a 
> "UserInfo" structure... This CFC is invoked as soon as the 
> user is authenticated into the application.
> 
> I need this structure and all its' keys available in the 
> request scope. Is it best to scope it in the CFC, or scope 
> the return variable into the return scope inside the cfinvoke tag?
> 
> I assume the issue of pointing to the variable and actually 
> copying it come into play here...
> 
> TIA,
> 
> Michael Tangorre
> 
> MillenniuM Information Systems
> 1101 Wilson Blvd, Suite 1200
> Arlington, Virginia 22209
> (703) 341-1438
> 
> 
> This email contains MillenniuM Information 
> Systems, LLC. privileged information. 
>  
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Turn on Internal Web afterwards? (Solved)

[Boardworks Interactive]

Here is an excerpt a Macromedia DesDev article about running CFMX in
Distributed Mode:



10. On the application server computer, open the
cf_root\runtime\servers\default\SERVER-INF\jrun.xml file and locate
the following code:

...

8500
*
false
...

11. Change the value of the deactivated attribute from false to
true. 
The built-in web server is disabled on the application server
computer.



So just try changing the deactivated back to false in order to enable
the jrun.servlet.http.WebService (internal CF web server).

Best!


SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, July 13, 2002 2:53 PM
To: CF-Talk
Subject: RE: Turn on Internal Web afterwards?

Sorry Mike I wasn't very clear on the original message. I want to
startup
the cfmx internal web server evne though I've installed for IIS...I'm
figuring it must be a config file somewhere...



-Original Message-
From: Mike Brunt [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, July 13, 2002 5:53 PM
To: CF-Talk
Subject: RE: Turn on Internal Web afterwards?


Stacy, I probably don't fully understand what you are asking here so if
this
answer is lame that is why.  If you mean how do you start the WorldWide
Web
Publishing Service after installing it the default setting is usually
Automatic Start, you can see this in NT or Win2K services.  If you are
talking of starting individual web sites inside the IIS MMC.  Open the
IIS
MMC you can get there via Start Programs Option Pack 4 if NT or Start
Control Panel Admin Tools Internet Services Manager in Win 2k.  Once in
look
for Default Web Site if this or any others there show "Stopped" right
click
and chose "Start".

Hth and is not way OT for you.

Kind Regards - Mike Brunt, CTO
Webapper
http://www.webapper.com
Downey CA Office
562.243.6255
AIM - webappermb

"Webapper - Making the NET work"


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 2:25 PM
To: CF-Talk
Subject: Turn on Internal Web afterwards?


Anyone know how to turn on the Internal web server after u have
installed
for IIS?


Stacy Young
System Integration Specialist, Architecture
Surefire Commerce
http://www.sfcommerce.com 
(p) 514-380-2700 ext: 3234
(f) 514-380-2760



AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces
jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire,
soyez
avise que toute divulgation, distribution, copie, ou autre utilisation
de
ces informations est strictement prohibee.  Si vous avez recu ce
document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.

WARNING:
---
The information contained in this document and attachments is
confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly
prohibited. If
you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.





__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFC and Scope

[Tangorre, Michael]

What is the best practice for the following situation.

I have a CFC in which I run a few queries and build a "UserInfo" structure...
This CFC is invoked as soon as the user is authenticated into the application.

I need this structure and all its' keys available in the request scope.
Is it best to scope it in the CFC, or scope the return variable into the return scope 
inside the cfinvoke tag?

I assume the issue of pointing to the variable and actually copying it come into play 
here...

TIA,

Michael Tangorre

MillenniuM Information Systems
1101 Wilson Blvd, Suite 1200
Arlington, Virginia 22209
(703) 341-1438


This email contains MillenniuM Information 
Systems, LLC. privileged information.

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: RE: Printing

[todd]

I don't think it's possible unless you're connected to said client via VPN 
or they open up their print server to you. ;)  That'd be fun, push a 
button everyday that spooled out 500 copies of Skull's butt 
(http://www.pvponline.com/archive.php3?archive=20020712) .. hee!  Oops, 
crap, I just went OT. ;)

~Todd

On Mon, 15 Jul 2002, Dan O'Keefe wrote:

> It looks like this will only print to the local network, whereas I need to
> print to the printer connected to the clients local machine over the
> internet.
> 
> Dan

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: RE: Printing

[Shawn McKee]

Load the file in the browser and point you user at the print button.
Obviously assumes an interactive session and not a scheduled task.

Shawn McKee

-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 9:52 AM
To: CF-Talk
Subject: RE: RE: Printing


It looks like this will only print to the local network, whereas I need to
print to the printer connected to the clients local machine over the
internet.

Dan

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 11:35 PM
To: CF-Talk
Subject: RE: RE: Printing


Sorry, here's the link:



It was 'printserver'. Someday they'll put a real search engine up there...

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 8:06 PM
To: CF-Talk
Subject: RE: RE: Printing


No good searching by print server...

Regards,

Eric J Hoffman
Head Tech Geek
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 9:07 PM
To: CF-Talk
Subject: RE: RE: Printing


There's an excellent print server product in the Dev Exchange on
Macromedia. We just used it to print to remote, networked printers at a
big event and it worked like a dream.

Search for print server and you should find it.

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 4:08 PM
To: CF-Talk
Subject: RE: RE: Printing


Hi Dan,

Unfortunately afaik the closest JavaScript will let you get to actually
printing a file is opening the print dialog box and then the user would
have to hit the okay button to actually print the document...

I believe Flash MX may have a way to go directly to the printer, so you
should be able to create a very simple flash movie with a single text
area which you could populate with data from the flashVars param ( up to
64k ) and then go directly to the printer. You can probably even get the
Flash movie to fit 100% height and 100% width so the text would expand
to fill the browser window... :)

Isaac

www.turnkey.to
954-776-0046

Original Message ---
You know what though, I need to print to a clients printer, so I assume
I will be talking JavaScript and the window.print method. I will need to
print a number of letters with the dynamic name and address, similar to
a mail merge.

Dan

-Original Message-
From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:01 PM
To: CF-Talk
Subject: RE: Printing


copy file.txt > lpt1 is it is local or if you have captured the printer
in dos to lpt1 if it is networked.  I do that exact thing using cffile
then exexecute.  It sends it through the server to a printer that
everyone works on.

Joshua Tipton

-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 2:58 PM
To: CF-Talk
Subject: Printing


What is the easiest way to send a text document to a printer from CFML.
I would imagine writing the file out with CFFILE and somehow initiating
a DOS command such as:

copy file.txt > PRN

Dan

-
Dan O'Keefe
TriPoint Technologies
954.501.3115










__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: RE: Printing

[Dan O'Keefe]

It looks like this will only print to the local network, whereas I need to
print to the printer connected to the clients local machine over the
internet.

Dan

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 11:35 PM
To: CF-Talk
Subject: RE: RE: Printing


Sorry, here's the link:



It was 'printserver'. Someday they'll put a real search engine up there...

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 8:06 PM
To: CF-Talk
Subject: RE: RE: Printing


No good searching by print server...

Regards,

Eric J Hoffman
Head Tech Geek
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 9:07 PM
To: CF-Talk
Subject: RE: RE: Printing


There's an excellent print server product in the Dev Exchange on
Macromedia. We just used it to print to remote, networked printers at a
big event and it worked like a dream.

Search for print server and you should find it.

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 4:08 PM
To: CF-Talk
Subject: RE: RE: Printing


Hi Dan,

Unfortunately afaik the closest JavaScript will let you get to actually
printing a file is opening the print dialog box and then the user would
have to hit the okay button to actually print the document...

I believe Flash MX may have a way to go directly to the printer, so you
should be able to create a very simple flash movie with a single text
area which you could populate with data from the flashVars param ( up to
64k ) and then go directly to the printer. You can probably even get the
Flash movie to fit 100% height and 100% width so the text would expand
to fill the browser window... :)

Isaac

www.turnkey.to
954-776-0046

Original Message ---
You know what though, I need to print to a clients printer, so I assume
I will be talking JavaScript and the window.print method. I will need to
print a number of letters with the dynamic name and address, similar to
a mail merge.

Dan

-Original Message-
From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:01 PM
To: CF-Talk
Subject: RE: Printing


copy file.txt > lpt1 is it is local or if you have captured the printer
in dos to lpt1 if it is networked.  I do that exact thing using cffile
then exexecute.  It sends it through the server to a printer that
everyone works on.

Joshua Tipton

-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 2:58 PM
To: CF-Talk
Subject: Printing


What is the easiest way to send a text document to a printer from CFML.
I would imagine writing the file out with CFFILE and somehow initiating
a DOS command such as:

copy file.txt > PRN

Dan

-
Dan O'Keefe
TriPoint Technologies
954.501.3115









__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: The drive wars - was hardware question

[Jochem van Dieten]

samcfug wrote:
> 
> But, I wonder just how many database servers host VLS (very large scale)
> databases?  I imagine the vast majority are much smaller.

Is 20 GB very large scale? In that case, I know quite a few (although 
all on a dedicated server [1]).


> Getting into databases that large, brings one into the arena of fiber
> channel connections, and other technology to increase speed and processing
> power.  (Thinking of the terradata.microsoft.com deal)

I think that is more something for the TB range. Would be cool to play 
with :)


> Then again, queries that are sloppily written can also place loads on a
> system that will bottleneck the data retrieval process on any system,
> regardless of configuration, right?

Yes. Sloppy architecture, writing and maintenance are usually the most 
important problems.

[1] Once I made a typo in a query which resulted in 1200 times half a 
million affected record instead of 1200 times 1 affected record, which 
if left alone would have gotten at least 60 GB +  transaction log. Would 
that qualify as over 20 GB on a non-dedicated server?

Jochem

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Using target in CFLOCATION

[S . Isaac Dealey]

> I have a http://www.newsite.com"; ADDTOKEN="No">

> Is there a way to set a target in CFLOCATION, such as  URL="http://www.newsite.com"; TARGET="_blank" ADDTOKEN="No"> ?  I've
> tried a number of ways with and without single and double quotes without
> success.

> Or do I need to use META Refresh? But I run into the same problem of
> naming a target so that the target fires.

I'm not aware that there's any way to target a meta refresh either ... I
know there's no way to target a cflocation. If you need a new window (
_blank ) your best bet is going to be window.open() ... If you need to
relocate a different frame in the same frameset, I'd go with either
top.frames.myframe.location.href='url'; or
top.frames.myframe.location.replace('url'); if you want to replace the given
frame in the browser's history stack the way cflocation does in order to
reduce problems with the back button. IIRC location.replace() is available
as of Netscape 3 and IE 4.

Isaac Dealey
www.turnkey.to
954-776-0046
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Using target in CFLOCATION

[todd]

Meta-refresh or javascript.  There's no way to target a cflocation.

On Mon, 15 Jul 2002, Mark Leder wrote:

> I have a http://www.newsite.com"; ADDTOKEN="No">
> 
> Is there a way to set a target in CFLOCATION, such as  URL="http://www.newsite.com"; TARGET="_blank" ADDTOKEN="No"> ?  I've
> tried a number of ways with and without single and double quotes without
> success.
> 
> Or do I need to use META Refresh? But I run into the same problem of
> naming a target so that the target fires.
> 
> Thanks,
> Mark
> 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Using target in CFLOCATION

[Mark Leder]

I have a http://www.newsite.com"; ADDTOKEN="No">

Is there a way to set a target in CFLOCATION, such as http://www.newsite.com"; TARGET="_blank" ADDTOKEN="No"> ?  I've
tried a number of ways with and without single and double quotes without
success.

Or do I need to use META Refresh? But I run into the same problem of
naming a target so that the target fires.

Thanks,
Mark

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: The drive wars - was hardware question.

[Bill Wheatley]

Agreed :)

Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 10:10 AM
Subject: RE: The drive wars - was hardware question.


> Bill,
>
> While I generally agree with you regarding SCSI when it comes to datbase
> servers, I would disagree in regard to web servers.  We have multiple CF
web
> servers in a cluster.  the "file access" mostly hits the template cache.
> Once they are booted the disks do relatively little other than system
> tasks - assuming you have adequate memory and your template cache is large
> enough. We baselined it very carefully and came to the conclusion that for
> THIS specicific purpose, IDE was sufficient.  The number concurrent users
> seems to make no appreciable impact (we serve as many as 5 million
requests
> on a  typical business day) on the performance of the disk.  The chief
> factor in the decision should be the amount of disk activity.  Note, since
> they are NOT hot swappable, I would not try this arrangement outside of a
> cluster as it would result in down-time.  We use Raid 1 for redundacy and
> keep spares handy - but we have needed them no more frequently than the
scsi
> spares.
>
> As far as the enterprise goes - buy the best hardware you can afford for
> your Datbase server, have hot spares on board and a good backup db server
> (that you keep current with log shipping or replication or whatever).
That's
> where the critical data lives.  IMO, I'd rather have a cluster of 4
> inexpensive web servers running through a hardward load balancer than 1
> expensive web server.
>
> -Mark
>
> -Original Message-
> From: Bill Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 8:48 AM
> To: CF-Talk
> Subject: Re: The drive wars - was hardware question.
>
>
> Bah IDE just doesn't function as well when you have concurrent users doing
> things on the drive.
> IDE ATA100 is nice for when its just me or a few people banging out stuff
on
> the drives. But if you have
> a good load of processes having to read and write to the drive you need to
> have SCSI. I have ATA133 at home it rocks
> but we also have 15k SCSI drives at work and I couldn't even think to put
> our stuff on IDE drives. IDE is not their yet for enterprise level
business,
> it will work but its like towing a boat with a Economy class ford escort.
:)
>
> But then again what do I know.
>
>
> Bill Wheatley
> Senior Database Developer
> Macromedia Certified Advanced Coldfusion Developer
> EDIETS.COM
> 954.360.9022 X159
> ICQ 417645
> - Original Message -
> From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 15, 2002 8:30 AM
> Subject: RE: The drive wars - was hardware question.
>
>
> > We have both IDE and SCSI (some are hot swap and some are no) in a large
> > data center with many different kinds of systems.  We see BOTH kinds of
> > drives fail infrequently.  IMO, if you have a server without a hot
backup
> > server, or one that's not in a cluster, using a hot-swappable SCSI setup
> is
> > something you should seriously consider - especially for a DB server.
> > However, we use IDE quite successfully in several situations.
> >
> > -mk
> >
> >
> >
> >
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: The drive wars - was hardware question.

[Mark A. Kruger - CFG]

Bill,

While I generally agree with you regarding SCSI when it comes to datbase
servers, I would disagree in regard to web servers.  We have multiple CF web
servers in a cluster.  the "file access" mostly hits the template cache.
Once they are booted the disks do relatively little other than system
tasks - assuming you have adequate memory and your template cache is large
enough. We baselined it very carefully and came to the conclusion that for
THIS specicific purpose, IDE was sufficient.  The number concurrent users
seems to make no appreciable impact (we serve as many as 5 million requests
on a  typical business day) on the performance of the disk.  The chief
factor in the decision should be the amount of disk activity.  Note, since
they are NOT hot swappable, I would not try this arrangement outside of a
cluster as it would result in down-time.  We use Raid 1 for redundacy and
keep spares handy - but we have needed them no more frequently than the scsi
spares.

As far as the enterprise goes - buy the best hardware you can afford for
your Datbase server, have hot spares on board and a good backup db server
(that you keep current with log shipping or replication or whatever). That's
where the critical data lives.  IMO, I'd rather have a cluster of 4
inexpensive web servers running through a hardward load balancer than 1
expensive web server.

-Mark

-Original Message-
From: Bill Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 8:48 AM
To: CF-Talk
Subject: Re: The drive wars - was hardware question.


Bah IDE just doesn't function as well when you have concurrent users doing
things on the drive.
IDE ATA100 is nice for when its just me or a few people banging out stuff on
the drives. But if you have
a good load of processes having to read and write to the drive you need to
have SCSI. I have ATA133 at home it rocks
but we also have 15k SCSI drives at work and I couldn't even think to put
our stuff on IDE drives. IDE is not their yet for enterprise level business,
it will work but its like towing a boat with a Economy class ford escort. :)

But then again what do I know.


Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:30 AM
Subject: RE: The drive wars - was hardware question.


> We have both IDE and SCSI (some are hot swap and some are no) in a large
> data center with many different kinds of systems.  We see BOTH kinds of
> drives fail infrequently.  IMO, if you have a server without a hot backup
> server, or one that's not in a cluster, using a hot-swappable SCSI setup
is
> something you should seriously consider - especially for a DB server.
> However, we use IDE quite successfully in several situations.
>
> -mk
>
>
>
>

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Strange Time problem

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> Is the CFServer on the same server is the smtp server?  Is it possible 
> that the smtp server is ahead of the cfserver? (system time wise).

I doubt that. If you grab a file from the mail spool I bet you will see 
that the timestamp is off there already. Could this be an issue with DST?

Else, as suggested, upgrade. There is a kb article on the "no previous 
version found" issue (don't know the number).

Jochem

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Issue: How to Create a CSV file from a CF QUERY

[BEN MORRIS]

This method of creating a CSV really works out well.  You could also do a nested loop 
and loop through rows of a 'normal' query, then loop through the cols for each row.  
What you find with this is that when the query gets to be any size of significance 
(even just a thousand records), the performance hit becomes huge.  I had code that was 
taking over a minute to run.  Lesson learned: nested loop bad, efficient SQL and 
ValueList() good.

I have also found the MS-SQL COALESCE function to be critical, because in the example 
below if fieldB is null, it won't return that row at all.  My example below is dumping 
varchar fields.  

To do dates you will have to do 
COALESCE(CONVERT(varchar(10), Start_DT, 101), '')

To show a numeric field:
CAST(TranID AS varchar(30))


  SELECT COALESCE(CHANGE, '') + ', ' + 
 COALESCE(SSN, '') + ', ' + 
 COALESCE(MEMBERNO, '') + ', ' + 
 COALESCE(LASTNAME, '') + ', ' + 
 COALESCE(FIRSTNAME, '') + ', ' + 
 COALESCE(I, '') + ', ' + 
 COALESCE(SUFFIX, '') + ', ' + 
 COALESCE(ADDRESS1, '') + ', ' + 
 COALESCE(ADDRESS2, '') + ', ' + 
 COALESCE(CITY , '') + ', ' + 
 COALESCE(STATE, '') + ', ' + 
 COALESCE(ZIP, '') + ', ' + 
 COALESCE(COUNTRY_CO, '') + ', ' + 
 COALESCE(A, '') + ', ' + 
 COALESCE(M, '') + ', ' + 
 COALESCE(SEX, '') + ', ' + 
 COALESCE(INS, '') + ', ' + 
 COALESCE(ID_MEMBER, '') + ', ' + 
 COALESCE(CONGR_DIST, '') + ', ' + 
 COALESCE(START_DT, '') + ', ' + 
 COALESCE(EMPLOYER, '') + ', ' + 
 COALESCE(BIRTH_DT, '') + ', ' + 
 COALESCE(PAY_GROUP, '') + ', ' + 
 COALESCE(COUNCIL, '') + ', ' + 
 COALESCE(HEALTH_CODE, '') + ', ' + 
 COALESCE(ACCIDENT_INSUR, '') + ', ' + 
 COALESCE(DENTAL_INSUR, '') + ', ' + 
 COALESCE(POS_CODE, '')  
 AS Row
FROM Membership 
   WHERE Local = '#session.LocalRoster.Local#' 
 AND District = '#session.LocalRoster.District#'
   ORDER BY LastName, FirstName










#l_Output#



>>> "Joseph Thompson" <[EMAIL PROTECTED]> 07/14/02 12:18PM >>>
This script adds the ' and , right in the SQL.  It concatenates all the
fields you need into a single comma seperated column called "line".
ValueList() creates a list from a query object; in this case we set the
delimiters to the windows "newline/carriage return" sequence.  This makes it
very easy to insert the whole query into a file with a sing CFFILE call.

(note that you may need to use CFFILE action="write" if the file does not
allready exist)

> >
> >
> >  SELECT
> >'"' + RTRIM(FieldA) + '"' + ',' +
> >'"' + RTRIM(FieldB) + '"' + ',' +
> >'"' + RTRIM(FieldC) + '"'
> >   AS line
> >
> >  FROM
> >table
> >
> >
> >
> >
> >
> >
> >
> >
> >
> 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Strange Time problem

[Frank Mamone]

Thanks Deb. I'll check it out.


- Original Message -
From: "Debbie Dickerson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:27 AM
Subject: RE: Strange Time problem


> It's pretty definite it's from the bug I referred to. From the SP1 release
notes: "CFMAIL now correctly handles Daylight Savings Time [16598]."
>
> Deb
>
>
> -Original Message-
> From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 9:01 AM
> To: CF-Talk
> Subject: Re: Strange Time problem
>
>
> I'm running 4.5.1. We tried several times to apply the 4.52 SP but the
> install always bombs saying there's no previously installed CF on it.
>
> Could it really be the BIOS time?
>
>
> - Original Message -
> From: "Bill Wheatley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 15, 2002 8:51 AM
> Subject: Re: Strange Time problem
>
>
> > or that :)
> >
> >
> > Bill Wheatley
> > Senior Database Developer
> > Macromedia Certified Advanced Coldfusion Developer
> > EDIETS.COM
> > 954.360.9022 X159
> > ICQ 417645
> > - Original Message -
> > From: "Debbie Dickerson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, July 15, 2002 8:49 AM
> > Subject: RE: Strange Time problem
> >
> >
> > > There were timestamp issues with mail in 4.5.0 and 4.5.1. What version
> > specifically are you running? I'd suggest at applying the service pack
if
> > you haven't already done so.
> > >
> > > -Original Message-
> > > From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, July 15, 2002 8:46 AM
> > > To: CF-Talk
> > > Subject: Strange Time problem
> > >
> > >
> > > There's a strange time problem on our CF 4.5 servers. Mail sent to our
> > SMTP server via CFMAIL shows a Sent timestamp of 1 hour ahead of the
> system
> > time.
> > >
> > > Anyone seen this before?
> > >
> > > Frank Mamone
> > >
> > >
> > >
> >
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: The drive wars - was hardware question.

[Bill Wheatley]

Bah IDE just doesn't function as well when you have concurrent users doing
things on the drive.
IDE ATA100 is nice for when its just me or a few people banging out stuff on
the drives. But if you have
a good load of processes having to read and write to the drive you need to
have SCSI. I have ATA133 at home it rocks
but we also have 15k SCSI drives at work and I couldn't even think to put
our stuff on IDE drives. IDE is not their yet for enterprise level business,
it will work but its like towing a boat with a Economy class ford escort. :)

But then again what do I know.


Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:30 AM
Subject: RE: The drive wars - was hardware question.


> We have both IDE and SCSI (some are hot swap and some are no) in a large
> data center with many different kinds of systems.  We see BOTH kinds of
> drives fail infrequently.  IMO, if you have a server without a hot backup
> server, or one that's not in a cluster, using a hot-swappable SCSI setup
is
> something you should seriously consider - especially for a DB server.
> However, we use IDE quite successfully in several situations.
>
> -mk
>
>
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Issue: How to Create a CSV file from a CF QUERY

[Justin Hansen]

There is a User Defined Function on cflib.org that will to the trick too...

http://www.cflib.org/udf.cfm?ID=404

CSVFormat, it works like a charm. Check it out!


Justin Hansen
--
Uhlig Communications
Web Developer / Programmer
--
[EMAIL PROTECTED]
913-754-4273
--

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 4:54 AM
To: CF-Talk
Subject: Issue: How to Create a CSV file from a CF QUERY


Hello All:

Could someone please send me some example code or a custom tag for 
creating a CSV file from a CF QUERY? I need to be able to have a user be 
able to download or email information to him or her on a request. I need 
to have a page that will allow a user to extract information from a SQL7 
table in CSV format and they should either be able to download this live 
data when they click a link or be able to enter there email address and 
the cfm will query the live information in the table produce a csv file 
and then email the user the information as an attachment. That latter 
would be preferred.

Thanks in advance,
James Blaha



FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: The drive wars - was hardware question

[samcfug]

Good comments.  And of course, each to his own.

But, I wonder just how many database servers host VLS (very large scale)
databases?  I imagine the vast majority are much smaller.

Getting into databases that large, brings one into the arena of fiber
channel connections, and other technology to increase speed and processing
power.  (Thinking of the terradata.microsoft.com deal)

Then again, queries that are sloppily written can also place loads on a
system that will bottleneck the data retrieval process on any system,
regardless of configuration, right?



>
> Date: Mon, 15 Jul 2002 10:33:57 +0200
> From: Jochem van Dieten <[EMAIL PROTECTED]>
> Subject: Re: The drive wars - was hardware question.
> Message-ID: <[EMAIL PROTECTED]>
>
> samcfug wrote:
> > The arguments of SCSI vs. IDE ATA 100 are like a religion, similar to
> > Windows vs. *nix.
> >
> > The dual processor, and all that RAM will out perform your network
> > connection by a large margin.  Therefore the drive(s) will have
redundant
> > capacity and ability.
>
> He hasn't told us what network connection he has yet.
>
>
> > As for performance - there will not be a noticeable difference.
>
> Not always. If you do a SELECT * FROM table WHERE categoryID = 7 on a 20
> GB table and the query-tree is an indexscan that gets 2000 different
> blocks from all over the harddisk you will notice the difference.
>
>
> > My own experience with IDE drives is that they will either fail within
30
> > days or so or last as long as 5 years.
>
> I have never had a dead SCSI disk (that I didn't shortcut with 220V
> myself). And 2 dead IDE disks so far this year.
>
>
> > There are, of course server owners with SCSI arrays, and server owners
with
> > IDE arrays. Each can be expected to swear by their own setup.
>
> I swear by my setup for my *problem*. I still don't know enough about
> Bud's load pattern to say something except for the obligatory remarks
> about seek time and serialization that might not even be relevant for
> his case.
>
> Jochem
>


FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Strange Time problem

[Debbie Dickerson]

It's pretty definite it's from the bug I referred to. From the SP1 release notes: 
"CFMAIL now correctly handles Daylight Savings Time [16598]."

Deb


-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 9:01 AM
To: CF-Talk
Subject: Re: Strange Time problem


I'm running 4.5.1. We tried several times to apply the 4.52 SP but the
install always bombs saying there's no previously installed CF on it.

Could it really be the BIOS time?


- Original Message -
From: "Bill Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:51 AM
Subject: Re: Strange Time problem


> or that :)
>
>
> Bill Wheatley
> Senior Database Developer
> Macromedia Certified Advanced Coldfusion Developer
> EDIETS.COM
> 954.360.9022 X159
> ICQ 417645
> - Original Message -
> From: "Debbie Dickerson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 15, 2002 8:49 AM
> Subject: RE: Strange Time problem
>
>
> > There were timestamp issues with mail in 4.5.0 and 4.5.1. What version
> specifically are you running? I'd suggest at applying the service pack if
> you haven't already done so.
> >
> > -Original Message-
> > From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 8:46 AM
> > To: CF-Talk
> > Subject: Strange Time problem
> >
> >
> > There's a strange time problem on our CF 4.5 servers. Mail sent to our
> SMTP server via CFMAIL shows a Sent timestamp of 1 hour ahead of the
system
> time.
> >
> > Anyone seen this before?
> >
> > Frank Mamone
> >
> >
> >
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF5/linux problem

[Bill Wheatley]

:) I used to have the same problem I tried running CF in debug mode with GDB
attached to see the dumps but it just wasn't working right. We never did
figure out what was wrong completely but I did have to do the cron restarts
as well as you. Hopefully on CF-LINUX list Jesse n. can help you out a bit
more then I can.



Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
- Original Message -
From: "Terry Ford" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:11 AM
Subject: CF5/linux problem


> Hey folks,
>
> I'm encountering a strange problem that maybe some of you have run into
before.
>
> Config: CF5, linux 7.2, Apache/CF5 EAPI module, mysql
>
> I have one template that runs many times a minute.  However, under cfstat,
a thread running this
> template seems to hang somewhat randomly -- every few hours or so. Under
cfstat it is listed as a
> running request.  What happens is that 10 such requests over time end up
running and CF
> grinds to a halt.  The template timeout of 45 seconds is ignored.  My
current solution is to
> cron-restart httpd every 12 hours -- not a pretty solution.
>
> The strange part: the template does NOT seem to be caught in a loop.  If I
restart Apache,
> these infinitely-running threads disappear, and I get server.log entries:
>
> "Warning","TID=11275","07/15/02","07:42:05","Template: /template.cfm, Ran:
5258 seconds."
> "Error","TID=8200","07/15/02","07:42:06","Unable to write reply -- client
browser stopped waiting for request. "
>
> If I create a new template with an intentional loop and run it, restarting
Apache does not remove the thread
> from the running list.
>
> So, it SEEMS to me that CF is done with the template but that Apache is
doing something weird.
> Maybe?
>
> Does anyone have any experience or ideas?  I'm not entirely sure how to
debug this one.
>
> Thanks,
> Terry
>
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF5/linux problem

[Terry Ford]

Hey folks,

I'm encountering a strange problem that maybe some of you have run into before.

Config: CF5, linux 7.2, Apache/CF5 EAPI module, mysql

I have one template that runs many times a minute.  However, under cfstat, a thread 
running this 
template seems to hang somewhat randomly -- every few hours or so. Under cfstat it is 
listed as a
running request.  What happens is that 10 such requests over time end up running and CF
grinds to a halt.  The template timeout of 45 seconds is ignored.  My current solution 
is to
cron-restart httpd every 12 hours -- not a pretty solution.

The strange part: the template does NOT seem to be caught in a loop.  If I restart 
Apache,
these infinitely-running threads disappear, and I get server.log entries:

"Warning","TID=11275","07/15/02","07:42:05","Template: /template.cfm, Ran: 5258 
seconds."
"Error","TID=8200","07/15/02","07:42:06","Unable to write reply -- client browser 
stopped waiting for request. "

If I create a new template with an intentional loop and run it, restarting Apache does 
not remove the thread
from the running list.

So, it SEEMS to me that CF is done with the template but that Apache is doing 
something weird.
Maybe?  

Does anyone have any experience or ideas?  I'm not entirely sure how to debug this one.

Thanks,
Terry


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Strange Time problem

[Frank Mamone]

I'm running 4.5.1. We tried several times to apply the 4.52 SP but the
install always bombs saying there's no previously installed CF on it.

Could it really be the BIOS time?


- Original Message -
From: "Bill Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:51 AM
Subject: Re: Strange Time problem


> or that :)
>
>
> Bill Wheatley
> Senior Database Developer
> Macromedia Certified Advanced Coldfusion Developer
> EDIETS.COM
> 954.360.9022 X159
> ICQ 417645
> - Original Message -
> From: "Debbie Dickerson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, July 15, 2002 8:49 AM
> Subject: RE: Strange Time problem
>
>
> > There were timestamp issues with mail in 4.5.0 and 4.5.1. What version
> specifically are you running? I'd suggest at applying the service pack if
> you haven't already done so.
> >
> > -Original Message-
> > From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 15, 2002 8:46 AM
> > To: CF-Talk
> > Subject: Strange Time problem
> >
> >
> > There's a strange time problem on our CF 4.5 servers. Mail sent to our
> SMTP server via CFMAIL shows a Sent timestamp of 1 hour ahead of the
system
> time.
> >
> > Anyone seen this before?
> >
> > Frank Mamone
> >
> >
> >
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Strange Time problem

[todd]

Is the CFServer on the same server is the smtp server?  Is it possible 
that the smtp server is ahead of the cfserver? (system time wise).

~Todd


On Mon, 15 Jul 2002, Debbie Dickerson wrote:

> There were timestamp issues with mail in 4.5.0 and 4.5.1. What version specifically 
>are you running? I'd suggest at applying the service pack if you haven't already done 
>so.
> 
> -Original Message-
> From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 8:46 AM
> To: CF-Talk
> Subject: Strange Time problem
> 
> 
> There's a strange time problem on our CF 4.5 servers. Mail sent to our SMTP server 
>via CFMAIL shows a Sent timestamp of 1 hour ahead of the system time.
> 
> Anyone seen this before?
> 
> Frank Mamone
> 
> 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists