RE: Problem with Studio 4.5.2 help

[Kelly Matthews]

I was having the same problem, that did the trick. Thanks!
Kelly

-Original Message-
From: Christopher Cortes [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:48 PM
To: CF-Talk
Subject: RE: Problem with Studio 4.5.2 help


Hubert,

Studio has its own Verity collection that stores the ColdFusion indices.
Renaming the directory where it is stored will trick Studio into recreating
the collections.

First close studio and then go to your ColdFusion Studio installation
directory, maybe:

"c:/program files/allaire/ColdFusion Studio 4x/Verity/Collections/Searchable
Help"

Rename the "Searchable help" directory to anything else, now launch studio
and try to use your help search again. It should prompt you to regenerate
the collection. Hope that does the trick for you, good luck.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:06 PM
To: CF-Talk
Subject: Problem with Studio 4.5.2 help


Hi,

While Studio 4.5.2 was indexing its help files for the first time, as a
result of a search I was trying to do, my computer froze.  Now, whatever I
try to search for, I get the reply "No matches found" (even for words like
"form" and "template", which I tried to be absolutely sure about the
situation).  What can I do to rectify the situation?

Sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Oh what a feeling

[Parker, Kevin]

This is purely conceptual.

We've developed a little bit of an interest in tactile response mice. We
think it might have some use in some training and education sections on web
pages currently under development.

I use a tactile response mouse at home and find it most interesting. Check
out www.immersion.com

It seems to me that it is not beyond the realms of possibility to change
tactile responses dynamically using CF( please no flaming, or other
scripting languages) based on user input or some other variables.

What do people think?




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFTRY / CFCATCH questions

[Christopher Olive, CIO]

that's incorrect, actually.  it will catch them in the order defined.  so if
there is an "ALL" first, there will never be any other.  basically, it
starts at the first CATCH, compares exception types.  if it is a match, that
handler occurs, if not, it examines the next one in order, ad nauseum, until
the last catch (which should probably be an "ALL" JIC)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:00 PM
To: CF-Talk
Subject: Re: CFTRY / CFCATCH questions


There are no requirements on the order of cfcatch statements that I'm aware
of.

- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:45 PM
Subject: CFTRY / CFCATCH questions


>
>I know that at least one CFCATCH must be put inside a CFTRY block.  How
> picky is CF on the order of the tags, though?  for example:
>
> 
>Some code
>
>
>
>
>
>
>
>
>
> 
>
>
>  First off, can you use an 'all' catch with other specialized catches
> defined?  Would a database exception catch at 'all' or would it catch at
> 'database'?  If I changed the code around to look like this:
>
>
> 
>Some code
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
> Then, where would a database exception catch?  At 'all' or at 'database'?
>
>
> If I put the code after the CFCATCHs, would an error catch?  Like this:
>
> 
>
>
>
>
>
>
>
>
>
>
>Some code
> 
>
>
>Thoughts, comments?  Much thanks!
>
>
>
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> Due out June 2001
> --
> DotComIt, LLC
> database driven web data using ColdFusion, Lotus Notes/Domino
> --
> Half of the Alternative Folk Duo called Far Cry Fly
> http://www.farcryfly.com | http://www.mp3.com/FarCryFly
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access/SQL/hosting question

[Mike Brunt]

Vernon, how many complaints are you getting from your current clients
regarding poor performance (if any)?  Also, are you able to check the CF
Logs to see if there are indications of problem issues with Access or
anything else for that matter.

Kind Regards - Mike Brunt
Macromedia Consulting
Tel 562.243.6255
Fax 401.696.4335
http://www.macromedia.com


-Original Message-
From: Christopher Cortes [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:04 PM
To: CF-Talk
Subject: RE: Access/SQL/hosting question


Vernon,

I would suggest trying out the dedicated machine prior to jumping into SQL
Server unless you can get a good deal on a server package. It sounds like
you understand your needs. There are also a few tweaks that you can do with
access database to improve performance. You won't see SQL Server numbers
though. I am curious, how many database hits per second are you seeing on
average throughout the day? This would probably be a good indicator as to
how much headroom if any you have left in your access database.(I am
assuming you can get this data from CFSTAT, bet I am wrong) One last thing,
I don't know that you can necessarily assume you will see better Db
performance on a dedicated server; you don't really know how many database
hits other users on that server are making. Your provider might give you
some numbers.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | 'Optimizing ColdFusion'
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Vernon Horn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:46 AM
To: CF-Talk
Subject: Access/SQL/hosting question



I'd appreciate any and all advice and comments on the following situation.

I work for a non-profit membership association (translation, not a huge
budget, but web stuff is getting to an important means of communication
with the membership.)  We've been running our web site on a shared server
set up, but for a variety of reasons are pretty sure that we want to move
to a dedicated server.

Currently we are serving 20-40,000 pages on a good day, around half involve
database queries, and there are a couple of hundred credit card
transactions per day also. Most of our traffic is concentrated during
standard business hours.

So, here is the question, one consultant has recommended that we not only
move to a dedicated server, but also upsize the databases to SQL, and get a
dedicated database server as well. This seems like a fairly drastic leap,
and I'm wondering if our relatively low volume really demands this? I know
Access gets a lot of flack, but is it reasonable to expect it to perform
better on a dedicated server?

Any recommendations for what the most cost effective solution for us would
be greatly appreciated.

Thanks in advance,
Vernon Horn



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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access/SQL/hosting question

[Christopher Cortes]

Vernon,

I would suggest trying out the dedicated machine prior to jumping into SQL
Server unless you can get a good deal on a server package. It sounds like
you understand your needs. There are also a few tweaks that you can do with
access database to improve performance. You won't see SQL Server numbers
though. I am curious, how many database hits per second are you seeing on
average throughout the day? This would probably be a good indicator as to
how much headroom if any you have left in your access database.(I am
assuming you can get this data from CFSTAT, bet I am wrong) One last thing,
I don't know that you can necessarily assume you will see better Db
performance on a dedicated server; you don't really know how many database
hits other users on that server are making. Your provider might give you
some numbers.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Vernon Horn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:46 AM
To: CF-Talk
Subject: Access/SQL/hosting question



I'd appreciate any and all advice and comments on the following situation.

I work for a non-profit membership association (translation, not a huge
budget, but web stuff is getting to an important means of communication
with the membership.)  We've been running our web site on a shared server
set up, but for a variety of reasons are pretty sure that we want to move
to a dedicated server.

Currently we are serving 20-40,000 pages on a good day, around half involve
database queries, and there are a couple of hundred credit card
transactions per day also. Most of our traffic is concentrated during
standard business hours.

So, here is the question, one consultant has recommended that we not only
move to a dedicated server, but also upsize the databases to SQL, and get a
dedicated database server as well. This seems like a fairly drastic leap,
and I'm wondering if our relatively low volume really demands this? I know
Access gets a lot of flack, but is it reasonable to expect it to perform
better on a dedicated server?

Any recommendations for what the most cost effective solution for us would
be greatly appreciated.

Thanks in advance,
Vernon Horn



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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Access/SQL/hosting question

[Vernon Horn]

I'd appreciate any and all advice and comments on the following situation.

I work for a non-profit membership association (translation, not a huge 
budget, but web stuff is getting to an important means of communication 
with the membership.)  We've been running our web site on a shared server 
set up, but for a variety of reasons are pretty sure that we want to move 
to a dedicated server.

Currently we are serving 20-40,000 pages on a good day, around half involve 
database queries, and there are a couple of hundred credit card 
transactions per day also. Most of our traffic is concentrated during 
standard business hours.

So, here is the question, one consultant has recommended that we not only 
move to a dedicated server, but also upsize the databases to SQL, and get a 
dedicated database server as well. This seems like a fairly drastic leap, 
and I'm wondering if our relatively low volume really demands this? I know 
Access gets a lot of flack, but is it reasonable to expect it to perform 
better on a dedicated server?

Any recommendations for what the most cost effective solution for us would 
be greatly appreciated.

Thanks in advance,
Vernon Horn



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem with Studio 4.5.2 help

[Christopher Cortes]

Hubert,

Studio has its own Verity collection that stores the ColdFusion indices.
Renaming the directory where it is stored will trick Studio into recreating
the collections.

First close studio and then go to your ColdFusion Studio installation
directory, maybe:

"c:/program files/allaire/ColdFusion Studio 4x/Verity/Collections/Searchable
Help"

Rename the "Searchable help" directory to anything else, now launch studio
and try to use your help search again. It should prompt you to regenerate
the collection. Hope that does the trick for you, good luck.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:06 PM
To: CF-Talk
Subject: Problem with Studio 4.5.2 help


Hi,

While Studio 4.5.2 was indexing its help files for the first time, as a
result of a search I was trying to do, my computer froze.  Now, whatever I
try to search for, I get the reply "No matches found" (even for words like
"form" and "template", which I tried to be absolutely sure about the
situation).  What can I do to rectify the situation?

Sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFTRY / CFCATCH questions

[Christopher Cortes]

Jeffry,

Your last statement prior to the closing try needs to be a catch. If you are
running multiple catches and you also want to catch all, the all statement
needs to come last.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 6:46 PM
To: CF-Talk
Subject: CFTRY / CFCATCH questions



   I know that at least one CFCATCH must be put inside a CFTRY block.  How
picky is CF on the order of the tags, though?  for example:


   Some code
   
   

   
   

   
   




 First off, can you use an 'all' catch with other specialized catches
defined?  Would a database exception catch at 'all' or would it catch at
'database'?  If I changed the code around to look like this:



   Some code

   
   

   
   

   
   





Then, where would a database exception catch?  At 'all' or at 'database'?


If I put the code after the CFCATCHs, would an error catch?  Like this:



   
   

   
   

   
   

   Some code



   Thoughts, comments?  Much thanks!



Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: value of field not appear

[Bryan LaPlante]

try




- Original Message -
From: "Haryono ..." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:04 PM
Subject: value of field not appear


> Hallo,
>
> Source code:
> 
>  value="#getdosen.image#">
> 
>
> When i excute source code above in browser, value of
> field image is not appear. why?
>
> If I use:
> 
> #getdosen.image#
> 
>
> value of "getdosen.image" is appear
>
> can you help me?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Search Engine

[Christopher Cortes]

Derek,

I have just recently begun working with Inktomi's Web Search. I am very
pleased with it, look at 3com's implementation. We are tying it into a
Spectra Site.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Derek Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 5:08 PM
To: CF-Talk
Subject: OT: Search Engine


I was wondering if anyone has had a good experience with any search engine
software for the Win2000 environment.  We currently run Phantom on a MAC but
that is dying a very quick death.

TIA,

Derek Hamilton
Systems Developer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Problem with Studio 4.5.2 help

[Jennifer]

At 08:06 PM 4/23/2001 -0400, you wrote:
>Hi,
>
>While Studio 4.5.2 was indexing its help files for the first time, as a 
>result of a search I was trying to do, my computer froze.  Now, whatever I 
>try to search for, I get the reply "No matches found" (even for words like 
>"form" and "template", which I tried to be absolutely sure about the 
>situation).  What can I do to rectify the situation?

Me too! Plus I can't get it to maintain an FTP connection while idle. I 
searched all documents for cfparam.

I am so not appreciating 4.5.2!


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

value of field not appear

[Haryono ...]

Hallo,

Source code:




When i excute source code above in browser, value of
field image is not appear. why?

If I use:

#getdosen.image#


value of "getdosen.image" is appear

can you help me?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL INSERTS - return ID

[Costas Piliotis]

Uhm No.

That's the easiest way, but you won't always get the last one inserted.  If
your page gets enough traffic, most inserts will work, but on occasion one
person might see the other's work...  If you use sql server, write a sproc
with @@Identity returning to a variable...


-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 23, 2001 5:57 PM
To: CF-Talk
Subject: Re: SQL INSERTS - return ID


select max(id) as maxID from tablename

- Original Message -
From: "Matt Eschenbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:36 PM
Subject: SQL INSERTS - return ID


> Anyone know a trick to return the ID of a record just Inserted into a
table?
>
> Sincerely,
>
> Matthew M. Eschenbaum
> Allaire Certified Professional
> DevTech Inc.
> [EMAIL PROTECTED]
> 206.956.0888
> www.dev-tech.com
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL INSERTS - return ID

[Tony Schreiber]

I think that if you do the query within a stored procedure, you'll be able
to get the ID back out...

> select max(id) as maxID from tablename
> 
> - Original Message -
> From: "Matt Eschenbaum" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 6:36 PM
> Subject: SQL INSERTS - return ID
> 
> 
> > Anyone know a trick to return the ID of a record just Inserted into a
> table?
> >
> > Sincerely,
> >
> > Matthew M. Eschenbaum
> > Allaire Certified Professional
> > DevTech Inc.
> > [EMAIL PROTECTED]
> > 206.956.0888
> > www.dev-tech.com
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Problem with Studio 4.5.2 help

[Hubert Earl]

Hi,

While Studio 4.5.2 was indexing its help files for the first time, as a result of a 
search I was trying to do, my computer froze.  Now, whatever I try to search for, I 
get the reply "No matches found" (even for words like "form" and "template", which I 
tried to be absolutely sure about the situation).  What can I do to rectify the 
situation?

Sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFTRY / CFCATCH questions

[Bryan LaPlante]

There are no requirements on the order of cfcatch statements that I'm aware
of.

- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:45 PM
Subject: CFTRY / CFCATCH questions


>
>I know that at least one CFCATCH must be put inside a CFTRY block.  How
> picky is CF on the order of the tags, though?  for example:
>
> 
>Some code
>
>
>
>
>
>
>
>
>
> 
>
>
>  First off, can you use an 'all' catch with other specialized catches
> defined?  Would a database exception catch at 'all' or would it catch at
> 'database'?  If I changed the code around to look like this:
>
>
> 
>Some code
>
>
>
>
>
>
>
>
>
>
>
> 
>
>
> Then, where would a database exception catch?  At 'all' or at 'database'?
>
>
> If I put the code after the CFCATCHs, would an error catch?  Like this:
>
> 
>
>
>
>
>
>
>
>
>
>
>Some code
> 
>
>
>Thoughts, comments?  Much thanks!
>
>
>
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> Due out June 2001
> --
> DotComIt, LLC
> database driven web data using ColdFusion, Lotus Notes/Domino
> --
> Half of the Alternative Folk Duo called Far Cry Fly
> http://www.farcryfly.com | http://www.mp3.com/FarCryFly
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL INSERTS - return ID

[Bryan LaPlante]

select max(id) as maxID from tablename

- Original Message -
From: "Matt Eschenbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 6:36 PM
Subject: SQL INSERTS - return ID


> Anyone know a trick to return the ID of a record just Inserted into a
table?
>
> Sincerely,
>
> Matthew M. Eschenbaum
> Allaire Certified Professional
> DevTech Inc.
> [EMAIL PROTECTED]
> 206.956.0888
> www.dev-tech.com
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL INSERTS - return ID

[Erik Yowell]

Well, there's always the good old:

SELECT MAX(ID) from MyTableName

right after your insert... though there maybe a more efficient way of doing
things, that I'm un-aware of... though, the above has worked for me on many
occasions...

Erik Yowell

-Original Message-
From: Matt Eschenbaum [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:36 PM
To: CF-Talk
Subject: SQL INSERTS - return ID


Anyone know a trick to return the ID of a record just Inserted into a table?

Sincerely,

Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: can't use PreserveSingleQuotes() with arrays? bug?

[Kym Kovan]

Hi Mike,

>can anyone else confirm this?

Yes we have seen it as well.

>Below is the code to replicate. Is there a problem with my code or is
>this a bug in ColdFusion?
>
>---start
>
>
>
> INSERT INTO temp_dammit
> (str) VALUES('#PreserveSingleQuotes(testArray[1])#')
>
>--- end-

We found that you have to grab the array item you want and put it in a 
simple variable then present that to the query:



   INSERT INTO temp_dammit
   (str) VALUES('#PreserveSingleQuotes(tempvar)#')


It seems that PreserveSingleQuotes() can only handle a simple text string 
directly. Maybe its a pointers thing?

--

Yours,

Kym


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL INSERTS - return ID

[Matt Eschenbaum]

Anyone know a trick to return the ID of a record just Inserted into a table?

Sincerely,

Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do i set up a Java CFX tag.

[Jon Hall]

Nope, Java is Java, it needs an interpreter to do anything. All Java
programs are compiled into bytecode, that's why theorhetically you can take
that cfx that you have and install it on a *nix machine as long as the jvm
is installed.

jon
- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 8:35 PM
Subject: Re: How do i set up a Java CFX tag.


>
>Well, by definition a CFX tag is a DLL, correct?  (I thought CFXs were
> binaries)  You should only need a JVM to run a Java Applet.  Java
> Applications are compiled down to assembler (or whatever) for the
> underlying operating system, not bit code for a Java Virtual Machine.
>
>When you have a CFX it doesn't matter what language it was coded in,
> unless you want to change the source code.
>
>
> At 03:44 PM 04/23/2001 -0400, you wrote:
> >Go here and download the jvm. Install is painless.
> >
> >http://java.sun.com/j2se/1.3/jre/download-windows.html
> >
> >jon
> >- Original Message -
> >From: "Rick Lamb" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Monday, April 23, 2001 1:11 PM
> >Subject: How do i set up a Java CFX tag.
> >
> >
> > > I need to use a cfx tag written in java and am not sure how to set it
up.
> >Do
> > > I need to install a Java Virtual Machine on the server? Any thing else
> > > required? The error I get now is asking me to set up a JVM on the
server.
> > > How do I do this. Can someone help me get started?
> > >
> > > Thanks,
> > >
> > > Rick
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

what does this mean...

[Jay Patton]

Error Diagnostic Information
Just in time compilation error 

unknown parser error 

The last successfully parsed CFML construct was the CFML template beginning occupying 
document position (1:1) to (1:1). 

The specific sequence of files included or processed is:
D:\64.224.42.213\PHOTOGRAPHS\INDEX.CFM  
  D:\64.224.42.213\PHOTOGRAPHS\..\INCLUDES\FOOTER.CFM  CFInclude



Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Search Engine

[Derek Hamilton]

I was wondering if anyone has had a good experience with any search engine software 
for the Win2000 environment.  We currently run Phantom on a MAC but that is dying a 
very quick death.  

TIA,

Derek Hamilton
Systems Developer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: problem with list box update

[Marc Garrett]

Thanks for your help Steven. Unless I misunderstand you, your code makes
more sense for an insert page than an update page. What I want to do is
populate the dropdown list on the update page with the value from the
database. If the user updates other fields of the record but doesn't want
the category to change my code doesn't work.

Any other suggestions?

Regards,

Marc Garrett

- Original Message -
From: "Semrau, Steven L Mr SRA" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 4:42 PM
Subject: RE: problem with list box update


> Make your first selection blank 
>


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Update on the Status of Harpoon & Private Beta 4 - 4/23/01

[Gauri Gavankar]

> All,
> 
> Since many of you have been asking about the latest status of the Harpoon project, 
>here is a quick update from Macromedia.
> 
> We are now completing final testing and documentation for the Harpoon project, now 
>named the Macromedia Flash Component Kit for Coldfusion.  It will be made available 
>to the public very soon as a free download from the Macromedia Developer's Exchange.
> 
> The Component Kit lets ColdFusion developers easily take advantage of Macromedia 
>Flash 5 sample components for enhancing Web applications without having to learn a 
>new authoring product.  It also includes documentation for more advanced developers 
>on how to create custom Macromedia Flash-based components based on the Component Kit 
>model.
> 
> If you have immediate comments about the Macromedia Flash Component Kit for 
>ColdFusion, please send email to:
> [EMAIL PROTECTED]
> 
> Thank you,
> The Macromedia Component Kit team
> 
> p.s. Please note--the public Beta for this release has now ended.  If you have 
>specific questions about accessing the Beta site, please send email to: 
>[EMAIL PROTECTED]
> 
> 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do i set up a Java CFX tag.

[Jeffry Houser]

   Well, by definition a CFX tag is a DLL, correct?  (I thought CFXs were 
binaries)  You should only need a JVM to run a Java Applet.  Java 
Applications are compiled down to assembler (or whatever) for the 
underlying operating system, not bit code for a Java Virtual Machine.

   When you have a CFX it doesn't matter what language it was coded in, 
unless you want to change the source code.


At 03:44 PM 04/23/2001 -0400, you wrote:
>Go here and download the jvm. Install is painless.
>
>http://java.sun.com/j2se/1.3/jre/download-windows.html
>
>jon
>- Original Message -
>From: "Rick Lamb" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, April 23, 2001 1:11 PM
>Subject: How do i set up a Java CFX tag.
>
>
> > I need to use a cfx tag written in java and am not sure how to set it up.
>Do
> > I need to install a Java Virtual Machine on the server? Any thing else
> > required? The error I get now is asking me to set up a JVM on the server.
> > How do I do this. Can someone help me get started?
> >
> > Thanks,
> >
> > Rick
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Kevin Gilchrist]

If performance is paramount and assuming that enough memory is available and
depending on how much client var data an app would create, why not create a
memory-resident database and use it to store client vars?  You would have to
flush regularly to disk but it might help performance if that's most
important.

Oracle can pretty much do that anyway though right but could a "poor man's"
work-around be to create a RAM Disk (if you can, I haven't seen this in a
long time, can you do it on Win2k?) and copy the database data files to it.
The only advantage of this over file-system caching would be that you are
reserving RAM for that data and so it wouldn't be cleared out of cache.

At a low OS level you could programmatically create memory-mapped files but
that's would be a whole development effort in and of itself.

Another .02 cents to the pile
Kev

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 3:36 PM
To: CF-Talk
Subject: RE: Session VS Client


> As Dave points out, most people are aware of how important query caching
is,
> but many of those same people use client variables, without a need for
> storing information from session to session or supporting a clustered
> environment, thereby creating a tremendous amount of database traffic.

Although I agree with this point, there are several other very valid reasons
for using Session variables. Someone has already brought up the point that
restarting the service doesn't necessarily cripple the user's session if the
application is using client variables.

In addition, on the user's side of things, Client variables generally act
more like real "session" than do Session variables since Client variables
are not arbitrarily expired every so many minutes. Of course, you can set
Session variables to expire after a hours or days, but in most applications,
that would take up an untenable amount or RAM: generally, your database
server has more disk space than your Web server has RAM.

And of course, my old sounding board is that even a very careful use of
Session variables generally affects server stability in a manner that Client
variables do not. I know many people will claim that they experience no
problems with properly locked Session variables. Either we are cursed or we
just read our log files more thoroughly, because we have seen all manner of
intermittent errors and unusually application behavior stemming from Session
variables. These slowly disappear as we phase out of developing and
maintaining applications with Session variables in favor of Client
variables.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

Bob

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 1:32 PM
To: CF-Talk
Subject: RE: Session VS Client


> the problem with session vars is if CF server restarts itself
> (which can, sometimes, be a good thing) you lose the session.
> i use client vars exclusively over session vars now (and cookies
> too) and store them in a DB. not as fast as memory in *theory*,
> but in practice it's more reliable and there's no difference in
> the performance of my applications.

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower. This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

can't use PreserveSingleQuotes() with arrays? bug?

[Mike Amburn]

can anyone else confirm this?

When I attempt to use the PreserveSingleQuotes() with an Array, i get
the following error:

Just in time compilation error Invalid parser construct found on 
ColdFusion was looking at the following text:
[
Invalid expression format. The usual cause is an error in the expression
structure.

Below is the code to replicate. Is there a problem with my code or is
this a bug in ColdFusion?

---start



INSERT INTO temp_dammit
(str) VALUES('#PreserveSingleQuotes(testArray[1])#')

--- end-


-mike

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Oh that's just great.

[Matt Rodosky]

Go to fortas site. He has cf_debug there last I checked.
http://www.forta.com/cf/tags/
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 1:50 PM
To: CF-Talk
Subject: Re: Oh that's just great.


dude, go and get cf_avartree, it rocks

- Original Message -
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:56 PM
Subject: Oh that's just great.


> I just downloaded a tag from the Tag Gallery called CF_Debugthat I
> wanted to throw up on one of my hosted sites so that I could get some
quick
> debugging info...
>
> Of course I unzipped it and it doesn't contain the Debugging tag, it's got
> some silly find and replace JS function.
>
> HELP! Does anybody out there have a debugging tag? Or let me know what the
> quick method is of outputting all the wonderful things we see at the
bottom
> of the pages when we have debugging turned on?
>
> *** mumbles to herself, while she goes and loads up on caffeine laced with
> arsenic that may put her out of her misery. 
>
> Erika
>
> "You can talk a great philosophy, but if you can't be kind to people
> everyday then it doesn't mean that much to me." - unknown
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: UD+Harpoon

[Massimo Foti]

Never heard about it, I also just saw Harpoon at an Allaire seminar, but UD
is totally extensible, a real open platform, so you don't need to wait for
Macromedia to integrate almost any kind of technology into it.


Massimo Foti
[EMAIL PROTECTED]


My own Corner of the web
http://www.massimocorner.com
Dreamweaver, Ultradev and Fireworks goodies

It should be this hole in the ozone layer
But I am not the coder I use to be...


<[EMAIL PROTECTED]> wrote in message news:OFF4E9352A.AE380FDF-
> have any of you macromedia heads heard anything about a new UltraDev or DW
> slated to come out w/harpoon it in?




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Crystal Reports - which version

[Jeffry Houser]

   I believe the CFREPORT tag in ColdFusion 4.5 does not support any 
version of Crystal Reports newer than 7.  (CF 5, does support CR 8, though)

At 11:10 AM 04/23/2001 -0700, you wrote:
>Planning on installing Crystal Reports to work with CF 4.5x. What is the
>consensus on the best version - 8.5 or earlier? TNX for any advice.
>
>Richard Colman
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFTRY / CFCATCH questions

[Jeffry Houser]

   I know that at least one CFCATCH must be put inside a CFTRY block.  How 
picky is CF on the order of the tags, though?  for example:


   Some code
   
   

   
   

   
   




 First off, can you use an 'all' catch with other specialized catches 
defined?  Would a database exception catch at 'all' or would it catch at 
'database'?  If I changed the code around to look like this:



   Some code

   
   

   
   

   
   





Then, where would a database exception catch?  At 'all' or at 'database'?


If I put the code after the CFCATCHs, would an error catch?  Like this:



   
   

   
   

   
   

   Some code



   Thoughts, comments?  Much thanks!



Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: problem with list box update

[Semrau, Steven L Mr SRA]

Make your first selection blank 

You can then put any validation code you want (cfform validation,
javascript, or what-have-ya) to ensure the user selects an option other then
the first one, otherwise don't allow submission of the form.

Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Marc Garrett [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 3:18 PM
To: CF-Talk
Subject: problem with list box update


I have an update page on which I need to show "user friendly" terms in a
select box, even though the information in the table is actually a code
number (e.g., the info is saved as "010-000" but the user should see
"services.") The value from the select is then passed to a CFUPDATE on the
following page. I can get the update to work properly if the user changes
the value in the select box, but if she leaves the value unchanged the field
gets updated to the "friendly" word instead of leaving the code value
unchanged. 

Thanks for any assistance. I have included code below my sig.

Regards,

Marc Garrett

Here's the code that populates the select list:


#fldCategory#

#fldCategory#
  


Here's query category_1:


SELECT
 tblContacts.fldContactID,
 tblContacts.fldCategory1,
 tblCategories.fldCategory,
 tblCategories.fldCategoryID
FROM
 tblContacts, tblCategories
WHERE
 tblContacts.fldContactID LIKE '#id#'
 AND tblCategories.fldCategoryID = tblContacts.fldCategory1


The update on the next page is simply:

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL2000 server not recognized by CF 4.5

[Dave Watts]

> Have you reinstalled the MDAC since installing CF 4.5? If not, 
> pop the windows 2K CD in and run the upgrade and this will fix 
> the MDAC that gets broken when you install CF 4.5.

If he's running SQL 2000, which requires MDAC 2.6, that's not a good idea,
since the one on the Win2K CD is 2.5. You can download and install MDAC 2.6
separately from http://www.microsoft.com/data/.

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dave Watts]

> > Session variables are more robust, certainly (when stored in a
> > database), but they're definitely quite a bit slower.
>
> I didn't know session vars were stored in a DB, I thought they were
> only stored in memory.

You're right, of course. I'm a bit woozy today. Sorry about that. I meant
that Client variables are more robust (which is, of course, why you're using
them!).

> Ok, I'm not debating whether *anything* should be stored in memory. 
> My query caching works nicely. My *specific* problem was CF restarting
> itself and dropping session vars I was using to keep people "logged 
> into" my application. I was using them to "maintain state". I found 
> that session vars were therefore unreliable so I switched to client 
> vars.

And, of course, for your app you're doing the right thing.

That's one of the problems with email lists. Very often, a discussion
revolves around "which is better", when it's often the case, as it is now,
that neither is better. It completely depends on the needs and circumstances
of your application. If you're having stability problems with memory
variables, as you and many others are, you'd be a fool to use them because
they're more efficient - who cares how efficient your app is if it's always
crashing?

I'd be the first to say that each has an appropriate place for use.

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oh that's just great.

[G]

I assume you currently have debugging turned off.  Why not turn debugging
on, and set your IP as the only IP that will receive the debugging
information.

HTH
Brian
- Original Message -
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:56 PM
Subject: Oh that's just great.


> I just downloaded a tag from the Tag Gallery called CF_Debugthat I
> wanted to throw up on one of my hosted sites so that I could get some
quick
> debugging info...
>
> Of course I unzipped it and it doesn't contain the Debugging tag, it's got
> some silly find and replace JS function.
>
> HELP! Does anybody out there have a debugging tag? Or let me know what the
> quick method is of outputting all the wonderful things we see at the
bottom
> of the pages when we have debugging turned on?
>
> *** mumbles to herself, while she goes and loads up on caffeine laced with
> arsenic that may put her out of her misery. 
>
> Erika
>
> "You can talk a great philosophy, but if you can't be kind to people
> everyday then it doesn't mean that much to me." - unknown
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: UD+Harpoon

[Dave Watts]

> have any of you macromedia heads heard anything about a new 
> UltraDev or DW slated to come out w/harpoon it in?

Harpoon doesn't have anything to do with Dreamweaver or UltraDev, really,
although there's no reason that extensions for both can't be added to allow
easier use of the Harpoon components from within the visual editor.

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dave Watts]

> :hmm: I did not know that. Does anyone know for a fact? I thought
> CFID / CFTOKEN were typically stored as cookies?  Although, I know 
> the values are doubled in the session scope along with a few others.\

Well, since they're used as a matching key, they have to be stored somewhere
other than cookies.

If you think about it, all Client variables must be stored in memory.
They're just not persistent, so they're essentially destroyed and recreated
for each page request just like local and Request variables. But to be able
to use them, CF has to look them up, which pulls them into memory for the
duration of the page request.

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oh that's just great.

[pan]

From: "Erika L Walker" <[EMAIL PROTECTED]>
..
>
> HELP! Does anybody out there have a debugging tag? Or let me know what the
> quick method is of outputting all the wonderful things we see at the
bottom
> of the pages when we have debugging turned on?
>
>

This may not be anything more than a slight stimulus to your thinking, but
I have used the below appended code to answer certain debugging needs.

cfinclude this at the top of a template and at the bottom and it will
show the state of some vars before page execution and also after page
execution.

You should be able to modify it quite a bit.

hope this is of some help

Pan



 
   APPLICATION VARS
   
   
#item# = #application[item]#
   
  
   application struct is empty
 


 
   SESSION VARS
   
   

  #item# = not
simple
 
  #item# = #session[item]#

   
  
   session struct is empty
 

CLIENT VARS
 
 
  
  #item# = #htmleditformat(this)#
 
COOKIE VARS
 
#cgi.http_cookie#
  
   cookie is empty
 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Oh that's just great.

[Howarth, Craig (IBK-NY)]

Someone posted this a while back.  So useful that it is now a permanent CF Studio 
snippet.

It doesn't lock, so it should only be used while debugging.



#ucase(struct)#:



#var#:
 
#structFind(evaluate(struct),var)#
 
Structure

Array

Query

#structFind(evaluate(struct),var)#






 




> -Original Message-
> From: Erika L Walker [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 2:57 PM
> To:   CF-Talk
> Subject:  Oh that's just great.
> 
> I just downloaded a tag from the Tag Gallery called CF_Debugthat I
> wanted to throw up on one of my hosted sites so that I could get some quick
> debugging info...
> 
> Of course I unzipped it and it doesn't contain the Debugging tag, it's got
> some silly find and replace JS function.
> 
> HELP! Does anybody out there have a debugging tag? Or let me know what the
> quick method is of outputting all the wonderful things we see at the bottom
> of the pages when we have debugging turned on?
> 
> *** mumbles to herself, while she goes and loads up on caffeine laced with
> arsenic that may put her out of her misery. 
> 
> Erika
> 
> "You can talk a great philosophy, but if you can't be kind to people
> everyday then it doesn't mean that much to me." - unknown
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Session variables

[Joshua Meekhof]

I would like to figure out the deep dark implementation details of cold
fusion sessions.

Is there any way I can "back into" it? i.e. Can you reference a session
variable as a hidden application variable?

I am trying to do something to an Application variable, based upon the
expiration of a session variable.  If I knew the inner workings of
session variables, I might be able to do this.


Josh Meekhof

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Oh that's just great.

[Semrau, Steven L Mr SRA]

If you are looking for just the query debug output, add the word debug as
the last item in the cfquery tag.  



Depending on the Administrator settings for debug, you could just add to the
top of the CF template page:





Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 2:57 PM
To: CF-Talk
Subject: Oh that's just great.


I just downloaded a tag from the Tag Gallery called CF_Debugthat I
wanted to throw up on one of my hosted sites so that I could get some quick
debugging info...

Of course I unzipped it and it doesn't contain the Debugging tag, it's got
some silly find and replace JS function.

HELP! Does anybody out there have a debugging tag? Or let me know what the
quick method is of outputting all the wonderful things we see at the bottom
of the pages when we have debugging turned on?

*** mumbles to herself, while she goes and loads up on caffeine laced with
arsenic that may put her out of her misery. 

Erika

"You can talk a great philosophy, but if you can't be kind to people
everyday then it doesn't mean that much to me." - unknown
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: populating the query result to IFRAME

[paul .]

 well I do get an error saying " style is not an object"
guys please help
-paul
--

On Mon, 23 Apr 2001 17:29:59  
 Darren Adams wrote:
>One really obvious point but there is a ")"  missing.
>
>-Original Message-
>From: paul . [mailto:[EMAIL PROTECTED]]
>Sent: 23 April 2001 17:11
>To: CF-Talk
>Subject: Re: populating the query result to IFRAME
>
>
> well by doing that am getting this error"Object expectd"
>please help me out cos am not javascript savvy
>-paul
>--
>
>On Mon, 23 Apr 2001 10:30:47  
> Bryan LaPlante wrote:
>>Not sure if this is what you mean, but try this.
>>
>>eval("document." + secNum + ".style.display = ''";
>>
>>don't forget to alternate your single and double quotes.
>>
>>- Original Message -
>>From: "paul ." <[EMAIL PROTECTED]>
>>To: "CF-Talk" <[EMAIL PROTECTED]>
>>Sent: Monday, April 23, 2001 10:12 AM
>>Subject: populating the query result to IFRAME
>>
>>
>>> HI Guys am trying to populate the query result to the IRAME , so
>>> that i can give the user to view result in the same page
>>> please check my code and suggest me. the seeror i get is "style is not an
>>object"
>>> thanks
>>> -paul . Below is my code
>>> ---
>>> >size="4"> Training
>>> 
>>> 
>>> function doSection(secNum)
>>>   {
>>> /*
>>> if(secNum.style.display == "none") {secNum.style.display = ""; }
>>>  else {secNum.style.display = "none"; }
>>> */
>>> secNum.style.display = "";
>>>   }
>>>
>>> function noSection (secNum)
>>>   {
>>>  if(secNum.style.display == "") {secNum.style.display = "none";}
>>>   }
>>>
>>> 
>>>
>>>
>>>
>>> >align="center" width="750">
>>>   
>>> >> face="Arial, Helvetica, sans-serif">Course
>>>   Name 
>>> >size="2">>> face="Arial, Helvetica, sans-serif">Scheduled
>>>   Date 
>>> >size="2">>> face="Arial, Helvetica, sans-serif">Occurance
>>>   Date 
>>> >size="2">>> face="Arial, Helvetica,
>>sans-serif">Non-Participants
>>>  
>>>   
>>>   
>>> 
>>> 
>>> 
>>> >")#">
>>> 
>>> 
>>> 
>>> 
>>> >")#">
>>> 
>>> 
>>>   
>>> 
>>> >to=#qry_get_training_courses.recordcount#>
>>>   >qry_get_training_courses.rec_id[loopcount]>
>>>   #qry_get_training_courses.session_name[loopcount]#
>>>   
>>> 
>>> 
>>> 
>>>   >> size="1">#current_training_date#
>>>   >> size="1">#current_completion_date#
>>>   >> size="1">>href="index.cfm?fuseaction=event_nonparticipants_v&event_idx=#rec_id#&am
>>p;traini
>>> ng_course_idx=#training_crse_idx#">Non-participants
>>>   >> size="1">>href="javascript:doSection(thesection)">participants
>>> 
>>>   
>>> 
>>> >STYLE="display:none">
>>>
>>> >SRC="http://10.158.20.123/careadv/test/index.cfm?fuseaction=event_participa
>n
>>ts_v&event_idx=3&training_course_idx=645
>>> " WIDTH=800 HEIGHT=200>
>>> 
>>> 
>>>  Close
>>> 
>>> 
>>>
>>> 
>>>
>>>   
>>> 
>>>
>>> 
>>> >value="#attributes.quarter_idx#">
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>> Get 250 color business cards for FREE!
>>> http://businesscards.lycos.com/vp/fastpath/
>>>
>>>
>
>>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oh that's just great.

[Bryan LaPlante]

dude, go and get cf_avartree, it rocks

- Original Message -
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:56 PM
Subject: Oh that's just great.


> I just downloaded a tag from the Tag Gallery called CF_Debugthat I
> wanted to throw up on one of my hosted sites so that I could get some
quick
> debugging info...
>
> Of course I unzipped it and it doesn't contain the Debugging tag, it's got
> some silly find and replace JS function.
>
> HELP! Does anybody out there have a debugging tag? Or let me know what the
> quick method is of outputting all the wonderful things we see at the
bottom
> of the pages when we have debugging turned on?
>
> *** mumbles to herself, while she goes and loads up on caffeine laced with
> arsenic that may put her out of her misery. 
>
> Erika
>
> "You can talk a great philosophy, but if you can't be kind to people
> everyday then it doesn't mean that much to me." - unknown
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do i set up a Java CFX tag.

[Jon Hall]

Go here and download the jvm. Install is painless.

http://java.sun.com/j2se/1.3/jre/download-windows.html

jon
- Original Message -
From: "Rick Lamb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:11 PM
Subject: How do i set up a Java CFX tag.


> I need to use a cfx tag written in java and am not sure how to set it up.
Do
> I need to install a Java Virtual Machine on the server? Any thing else
> required? The error I get now is asking me to set up a JVM on the server.
> How do I do this. Can someone help me get started?
>
> Thanks,
>
> Rick
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Benjamin S. Rogers]

> As Dave points out, most people are aware of how important query caching
is,
> but many of those same people use client variables, without a need for
> storing information from session to session or supporting a clustered
> environment, thereby creating a tremendous amount of database traffic.

Although I agree with this point, there are several other very valid reasons
for using Session variables. Someone has already brought up the point that
restarting the service doesn't necessarily cripple the user's session if the
application is using client variables.

In addition, on the user's side of things, Client variables generally act
more like real "session" than do Session variables since Client variables
are not arbitrarily expired every so many minutes. Of course, you can set
Session variables to expire after a hours or days, but in most applications,
that would take up an untenable amount or RAM: generally, your database
server has more disk space than your Web server has RAM.

And of course, my old sounding board is that even a very careful use of
Session variables generally affects server stability in a manner that Client
variables do not. I know many people will claim that they experience no
problems with properly locked Session variables. Either we are cursed or we
just read our log files more thoroughly, because we have seen all manner of
intermittent errors and unusually application behavior stemming from Session
variables. These slowly disappear as we phase out of developing and
maintaining applications with Session variables in favor of Client
variables.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

Bob

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 1:32 PM
To: CF-Talk
Subject: RE: Session VS Client


> the problem with session vars is if CF server restarts itself
> (which can, sometimes, be a good thing) you lose the session.
> i use client vars exclusively over session vars now (and cookies
> too) and store them in a DB. not as fast as memory in *theory*,
> but in practice it's more reliable and there's no difference in
> the performance of my applications.

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower. This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: statement help...

[Dave f]

Not too sure of format off the top of my head, but you it looks like you
need something like


To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:45 PM
Subject: Re: statement help...


> I know there is more than one because i am looking in that specific table
> and see 12 (at least) records that should be returned.
> 
>   datasource="#datasource#"
>  dbtype="ODBC"
>  username="#username#"
>  password="#password#">
> SELECT *
> FROM RodeoManager
> WHERE CircuitID = #url.CircuitID#
> 
> 
>   datasource="#datasource#"
>  dbtype="ODBC"
>  username="#username#"
>  password="#password#">
> SELECT SUM(AdjPoints) as totalPoints, ContestantID
> FROM ResultsManager
> WHERE RodeoID = #getRodeos.RodeoID#
> GROUP BY ContestantID
> ORDER BY SUM(AdjPoints) DESC
> 
>
> 
> 
> 
>   
>  size="1">#currentRow#
> 
>datasource="#datasource#"
>  dbtype="ODBC"
>  username="#username#"
>  password="#password#">
> SELECT *
> FROM ContestantManager
> WHERE ContestantID = #resultsP.ContestantID#
>  size="1">#contestants.LastName#, #contestants.FirstName#
> (#contestants.City#, #contestants.State#)
>  size="1">#totalPoints#
>   
>   
> 
>
> Thanks,
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> - Original Message -
> From: "Dave f" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 11:06 AM
> Subject: Re: statement help...
>
>
> > How do you know there are 12-ish if you only see 1??
> >
> > Are you saying that  getRodeos.RecordCount = 1, or have you maybe
> forgotten
> > to specify queryname in cfoutput loop?
> >
> > Dave
> >
> > - Original Message -
> > From: "Jay Patton" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 23, 2001 12:16 PM
> > Subject: Re: statement help...
> >
> >
> > > i tried this also, and it still didnt work
> > > since then i have switched everything to be id specific now however,
it
> > > still only returns the first record w/ that id, now. any ideas
this
> is
> > > my query now
> > >
> > >  > >  datasource="#datasource#"
> > >  dbtype="ODBC"
> > >  username="#username#"
> > >  password="#password#">
> > > SELECT *
> > > FROM RodeoManager
> > > WHERE CircuitID = #url.CircuitID#
> > > 
> > >
> > > thanks,
> > >
> > > Jay Patton
> > > Web Design / Application Design
> > > Web Pro USA
> > > p. 406.549.3337 ext. 203
> > > p. 1.888.5WEBPRO ext. 203
> > > e. [EMAIL PROTECTED]
> > > url. www.webpro-usa.com
> > > - Original Message -
> > > From: "Mike Sprague" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Monday, April 23, 2001 9:48 AM
> > > Subject: Re: statement help...
> > >
> > >
> > > > Try the following as your where clause:
> > > >
> > > > WHERE trim(Circuit) = '#trim(url.CircuitName)#'
> > > >
> > > > *** REPLY SEPARATOR  ***
> > > > On 4/23/2001 at 9:31 AM Jay Patton wrote:
> > > >
> > > > |Why would this only select one record from the db?(there are about
12
> > it
> > > > |should return but it only returns one (which is the first one)
> > > > |
> > > > | > > > | datasource="#datasource#"
> > > > | dbtype="ODBC"
> > > > | username="#username#"
> > > > | password="#password#">
> > > > |SELECT *
> > > > |FROM RodeoManager
> > > > |WHERE Circuit = '#url.CircuitName#'
> > > > |
> > > > |
> > > > |
> > > > |Thanks,
> > > > |
> > > > |Jay Patton
> > > > |Web Design / Application Design
> > > > |Web Pro USA
> > > > |p. 406.549.3337 ext. 203
> > > > |p. 1.888.5WEBPRO ext. 203
> > > > |e. [EMAIL PROTECTED]
> > > > |url. www.webpro-usa.com
> > > > |
> > > > | |
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do i set up a Java CFX tag.

[dave fauth]

Download the JRE (Java Runtime Environment) or you can download JDK (java
development kit) from sun (java.sun.com).   http://java.sun.com/j2se/1.3/jre/
Install on the server.

In CF administrator, Under Server/Java, put in path the jvm.dll.  Check
load JVM when starting CF.

Under CFX Jar path, put path to CFUSION\Java\Classes

dave
At 12:11 PM 4/23/2001 -0500, you wrote:
>I need to use a cfx tag written in java and am not sure how to set it up. Do
>I need to install a Java Virtual Machine on the server? Any thing else
>required? The error I get now is asking me to set up a JVM on the server.
>How do I do this. Can someone help me get started?
>
>Thanks,
>
>Rick
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How do i set up a Java CFX tag.

[Dylan Bromby]

go to www.sun.com and download the Java SDK or JRE. install it.


-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 10:11 AM
To: CF-Talk
Subject: How do i set up a Java CFX tag.


I need to use a cfx tag written in java and am not sure how to set it up. Do
I need to install a Java Virtual Machine on the server? Any thing else
required? The error I get now is asking me to set up a JVM on the server.
How do I do this. Can someone help me get started?

Thanks,

Rick
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL2000 server not recognized by CF 4.5

[Sean Daniels]

On 4/23/01 1:52 PM David Baskin wrote:

> I'm hoping someone can help with a problem i cannot figure out. i have a new
> box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend
> without problems, but now i cannot get SQL and CF to play together. i try to
> set up the ODBC and my connection fails every time. the base SQL server that
> shows up as default on the ODBC admin does not connect, nor does the one
> that i create. not sure how to trouble shoot this problem at all. any help
> is greatly appreciated.

Have you reinstalled the MDAC since installing CF 4.5? If not, pop the
windows 2K CD in and run the upgrade and this will fix the MDAC that gets
broken when you install CF 4.5.

- Sean
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dylan Bromby]

as i replied to dave, i use database caching and it's great.

i use client vars to maintain state when users connect to certain
applications because if CF restarts itself, it will kill any open session
vars. if CF had a way of maintaining this better, i would love to store them
in memory (sessions vs. client) since i have 1GB to use.

ironically, it's CFPOP that causes CF to restart itself...don't even get me
started on that :).

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:18 AM
To: CF-Talk
Subject: RE: Session VS Client


I couldn't agree more.  Did you know that if you have client variables
turned on CF will generate two select statements for every single page hit?
And, if you don't turn off global client variable updates (which are turned
on by default), you also generate an INSERT/UPDATE statement for every page,
even if you aren't accessing any client variables on that page.  To me
that's a whole lot of unnecessary database calls, which will seriously
impede performance.

As Dave points out, most people are aware of how important query caching is,
but many of those same people use client variables, without a need for
storing information from session to session or supporting a clustered
environment, thereby creating a tremendous amount of database traffic.

Bob

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 1:32 PM
To: CF-Talk
Subject: RE: Session VS Client


> the problem with session vars is if CF server restarts itself
> (which can, sometimes, be a good thing) you lose the session.
> i use client vars exclusively over session vars now (and cookies
> too) and store them in a DB. not as fast as memory in *theory*,
> but in practice it's more reliable and there's no difference in
> the performance of my applications.

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower. This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form Field OnChange Problem with Cf

[Larry Juncker]

Thanks Don;

That was what I was afraid of.

I did come up with a fix though, so I have it working now.  Good ol' CFMAIL
and JS

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:57 PM
To: CF-Talk
Subject: Re: Form Field OnChange Problem with Cf


Your onChange function operates clientside after coldfusion is done with the
page. You can't set a coldfusion variable because cf is not in the picture
at this point.

- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 12:26 PM
Subject: Form Field OnChange Problem with Cf


> I have a form that the action for it goes to sendmail.exe
>
> I have an onChange function written that checks the value of
> document.formName.Full_Name.value
>
> If I set an to say ("Full Name =" + FullName);
>
> I get the alert telling me that the field has changed.
>
> What I would like to do is set a Cold Fusion variable on this change, but
I
> keep getting errors.
>
> I have tried:
>  document.write("")
> however, when I try and run the template again, I get locked up.
>
> I need to know what this variable has been changed to so that I can send
it
> with my returnurl variable such as this:
>
>
http://www.mydomain.com/prtDsp.cfm?Machine_No=#Machine_No#&FullName=#FullNam
> e#
>
> Everything is working except my FullName variable
>
> Can someone tell me if this is possible.
>
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

UD+Harpoon

[savan . thongvanh]

have any of you macromedia heads heard anything about a new UltraDev or DW
slated to come out w/harpoon it in?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Offline forms

[Jim McAtee]

What's the target audience and target platform?  You could write a dedicated
application in C++ or VB for Windows that could do this.  Depends on whether
the folks filling out the forms will trust you and trust downloading an EXE
to their PC.  Also depends on whether covering only the PC/Win platform is
sufficient.

Jim

- Original Message -
From: "Eric V. Hodge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 8:16 AM
Subject: Offline forms


> I have an application that has a series of long multi-page forms so that a
user can construct a lengthy document.
>
> What are some of my options to allow them to save their work offline and
come back to it later and continue where they left off.
>
> Thanks,
> Eric


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Stats pkg for Win2K IIS

[Tony Schreiber]

Webalizer is free and is very fast. Needs to be scheduled to run though,
but works incrementally.

http://www.mrunix.net/webalizer/

Here's a binary for Win32, though I've never used it:

http://www.medasys-lille.com/webalizer/

> We use Statistics Server as well.  If we were only analyzing our own site
> traffic and had the $$$ we'd switch to Urchin (http://www.urchin.com).  It's
> a bit expensive for a small web host with a few dozen sites.
> 
> A sample of their report interface:
> http://www.hollywoodweb.com/report/english/
> 
> Jim
> 
> 
> - Original Message -
> From: "WebMaster" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 11:17 AM
> Subject: Re: [OT] Stats pkg for Win2K IIS
> 
> 
> >
> > We use Statistics Server by Mediahouse (http://www.mediahouse.com) which
> > has real-time access, so there's no need to schedule anything. You can set
> > different user-level access to certain reports and schedule reports to be
> > emailed on a daily, weekly or monthly basis.
> >
> > Overall, we've been very happy with it. The Admin functionality can get a
> > little tedious, but it isn't that bad.
> >
> > Mike
> >
> >
> >
> > At 11:04 PM 4/22/2001 -0600, you wrote:
> > >I'm looking for a low cost of free stats package to run on Win2K, that
> will
> > >do automatic nightly reporting.
> > >
> > >I know that's a general question, but I'm looking for opinions as much as
> a
> > >list of software that does that.
> > >
> > >Thanks,
> > >
> > >Peter Janett
> > >
> > >New Media One Web Services
> > >
> > >WEB HOSTING FOR WEB DEVELOPERS
> > >
> > >Sun, IRIX, Windows 2000, Linux;
> > >PHP, MySQL, Perl, Cold Fusion,
> > >MS SQL, ASP, SSI, SSL
> > >http://www.newmediaone.net
> > >[EMAIL PROTECTED]
> > >(303)828-9882
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

problem with list box update

[Marc Garrett]

I have an update page on which I need to show "user friendly" terms in a select box, 
even though the information in the table is actually a code number (e.g., the info is 
saved as "010-000" but the user should see "services.") The value from the select is 
then passed to a CFUPDATE on the following page. I can get the update to work properly 
if the user changes the value in the select box, but if she leaves the value unchanged 
the field gets updated to the "friendly" word instead of leaving the code value 
unchanged. 

Thanks for any assistance. I have included code below my sig.

Regards,

Marc Garrett

Here's the code that populates the select list:


#fldCategory#

#fldCategory#
  


Here's query category_1:


SELECT
 tblContacts.fldContactID,
 tblContacts.fldCategory1,
 tblCategories.fldCategory,
 tblCategories.fldCategoryID
FROM
 tblContacts, tblCategories
WHERE
 tblContacts.fldContactID LIKE '#id#'
 AND tblCategories.fldCategoryID = tblContacts.fldCategory1


The update on the next page is simply:



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Search Engines

[Russ Conway]

Check out selfpromotion.com. It's a good starting point and free to use at
first. If you like it, I think they ask for $10 to continue using the
service.

Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on

> -Original Message-
> From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 1:52 PM
> To: CF-Talk
> Subject: Search Engines
>
>
> Out of curiosity, what program is most popular when
> submitting website information to search engines?
>
> I have come across a few, or does anyone know any such animal
> which is free to use or a very minimal charge?
>
> Thanks in advance!
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Jeffry Houser]

  :hmm:  I did not know that.  Does anyone know for a fact?  I thought CFID 
/ CFTOKEN were typically stored as cookies?  Although, I know the values 
are doubled in the session scope along with a few others.


At 01:39 PM 04/23/2001 -0400, you wrote:
>actually, I believe the cfid and cftoken are stored in memory, even with
>client variables.
>
>~Simon
>
>Simon Horwith
>Macromedia Certified Instructor
>Certified ColdFusion Developer
>Fig Leaf Software
>1400 16th St NW, # 500
>Washington DC 20036
>202.797.6570 (direct line)
>www.figleaf.com
>
>
>
>-Original Message-
>From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 23, 2001 4:09 PM
>To: CF-Talk
>Subject: Re: Session VS Client
>
>
>
>Client variables are stored in:
>
>The Registry (not recommended)
>A Datasource
>as cookies
>
>Therefore, they use 0 RAM, zilch, nada, nothing.
>
>Session variables are stored in RAM.  Since any amount of RAM is bigger
>than no amount of RAM, I would say that session variables must take up more
>RAM.  I'm sure we'll see hundreds of post to this affect.
>
>At 04:55 PM 04/23/2001 +0100, you wrote:
> >OK guys and gals..
> >
> >Do Client vars take up more server RAM than session Vars.  My colleague
> >reckons they do wheras I reckon it's the t'other way round
> >
> >A
> >
> >--
> >Andrew Ewings
> >Project Manager
> >Thoughtbubble Ltd
> >http://www.thoughtbubble.net
> >--
> >United Kingdom
> >http://www.thoughtbubble.co.uk/
> >Tel: +44 (0) 20 7387 8890
> >--
> >New Zealand
> >http://www.thoughtbubble.co.nz/
> >Tel: +64 (0) 9 488 9131
> >--
> >The information in this email and in any attachments is confidential and
> >intended solely for the attention and use of the named addressee(s). Any
> >views or opinions presented are solely those of the author and do not
> >necessarily represent those of Thoughtbubble. This information may be
> >subject to legal, professional or other privilege and further distribution
> >of it is strictly prohibited without our authority. If you are not the
> >intended recipient, you are not authorised to disclose, copy, distribute,
>or
> >retain this message. Please notify us on +44 (0)207 387 8890.
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL2000 server not recognized by CF 4.5

[Jose Alberto Guerra Ugalde]

Sometimes the default client configuration for the connection to the SQL
Server is set to use NTBEUI instead TCPIP and you cannot establish the
connection, go to Start/Programs/SQL Server/Client Configuration and there
you can change this

Regards

- Original Message -
From: "David Baskin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 10:52 AM
Subject: SQL2000 server not recognized by CF 4.5


> I'm hoping someone can help with a problem i cannot figure out. i have a
new
> box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend
> without problems, but now i cannot get SQL and CF to play together. i try
to
> set up the ODBC and my connection fails every time. the base SQL server
that
> shows up as default on the ODBC admin does not connect, nor does the one
> that i create. not sure how to trouble shoot this problem at all. any help
> is greatly appreciated.
>
> d
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL2000 server not recognized by CF 4.5

[Bob Silverberg]

Under the SQL Server menu, look at both the Server Network Utility and
Client Network Utility.  These both need to be configured to use the same
protocol(s), so the CF client can talk to the SQL Server.  We configure ours
to used TCP/IP only for both client and server.

Bob

-Original Message-
From: David Baskin [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 1:53 PM
To: CF-Talk
Subject: SQL2000 server not recognized by CF 4.5


I'm hoping someone can help with a problem i cannot figure out. i have a new
box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend
without problems, but now i cannot get SQL and CF to play together. i try to
set up the ODBC and my connection fails every time. the base SQL server that
shows up as default on the ODBC admin does not connect, nor does the one
that i create. not sure how to trouble shoot this problem at all. any help
is greatly appreciated.

d
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Oh that's just great.

[Erika L Walker]

I just downloaded a tag from the Tag Gallery called CF_Debugthat I
wanted to throw up on one of my hosted sites so that I could get some quick
debugging info...

Of course I unzipped it and it doesn't contain the Debugging tag, it's got
some silly find and replace JS function.

HELP! Does anybody out there have a debugging tag? Or let me know what the
quick method is of outputting all the wonderful things we see at the bottom
of the pages when we have debugging turned on?

*** mumbles to herself, while she goes and loads up on caffeine laced with
arsenic that may put her out of her misery. 

Erika

"You can talk a great philosophy, but if you can't be kind to people
everyday then it doesn't mean that much to me." - unknown


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFML not being executed

[Daniel H]

Duane:

I am not sure if you found your reason why email was not working.. but this
may help.

I was dumbfounded as to why some but not all of my client's  tags
were not working. I checked and modified the time out - verified the mail
server properties... Checked to be sure all the IIS setting were proper.

I couldn't understand it until this weekend... (seems like 90% of my
solutions for work come off of work hours :D)

It basically came down to the point that to prevent spam our mail server
allowed mail only from a short list of domains in addition to specific IPs.
The IP list had *not* been updated with the new IP address our new
coldfusion server was using! Whpse! The mail server thought our new
server was attempting a relay spam after checking and finding out that the
email account was not a local hosted one nor on the select list of IPs}!

hahaha ;o

I added the new block of authorized IP addresses that exist on the new
server and voila!! They went through this time..

A good start to a new week..

I wish you well in your search for your problem,

Dan

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:29 PM
To: CF-Talk
Subject: RE: CFML not being executed


Sure the template is being called via the webserver?
You got IIS log entries?

Does cf administrator work

Justin

>>-Original Message-
>>From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, April 18, 2001 6:24 PM
>>To: CF-Talk
>>Subject: CFML not being executed
>>
>>
>>Just had a box put together with Win2k, IIS, CF 4.5.1 sp2 and for some
>>reason it is not executing the CFML code. When I view the source the CFML
>>code is still in the contained in the returned html. I've tried everything
>>even reinstalling both CF and the OS. I checked the ISAPI
>>filters, execute,
>>everything I can think of, but nothing works.
>>
>>Any ideas
>>
>>TIA,
>>Duane
>>
>>
>>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Search Engines

[Mark W. Breneman]

One site I have found is www.addme.com they have a lot of free info about
how to get better standings and they submit to lots of engines.

>From what I understand, some search engines may demerit you if you use a
program or site.  Don't know of any proof of this Anyone?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:52 PM
To: CF-Talk
Subject: Search Engines


Out of curiosity, what program is most popular when
submitting website information to search engines?

I have come across a few, or does anyone know any such animal
which is free to use or a very minimal charge?

Thanks in advance!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Search Engines

[John Lucas]

www.jimtools.com

 -Original Message-
From:   Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent:   Monday, April 23, 2001 12:52 PM
To: CF-Talk
Subject:Search Engines

Out of curiosity, what program is most popular when
submitting website information to search engines?

I have come across a few, or does anyone know any such animal
which is free to use or a very minimal charge?

Thanks in advance!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Benjamin S. Rogers]

> > Session variables are more robust, certainly (when stored in a
database),
> > but they're definitely quite a bit slower.

> I didn't know session vars were stored in a DB, I thought they were only
> stored in memory.

I think Dave slipped up here. :) Client variables are generally more robust
and can be stored in the database. Session variables are generally faster as
they are stored in RAM.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Bob Silverberg]

I couldn't agree more.  Did you know that if you have client variables
turned on CF will generate two select statements for every single page hit?
And, if you don't turn off global client variable updates (which are turned
on by default), you also generate an INSERT/UPDATE statement for every page,
even if you aren't accessing any client variables on that page.  To me
that's a whole lot of unnecessary database calls, which will seriously
impede performance.

As Dave points out, most people are aware of how important query caching is,
but many of those same people use client variables, without a need for
storing information from session to session or supporting a clustered
environment, thereby creating a tremendous amount of database traffic.

Bob

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 1:32 PM
To: CF-Talk
Subject: RE: Session VS Client


> the problem with session vars is if CF server restarts itself
> (which can, sometimes, be a good thing) you lose the session.
> i use client vars exclusively over session vars now (and cookies
> too) and store them in a DB. not as fast as memory in *theory*,
> but in practice it's more reliable and there's no difference in
> the performance of my applications.

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower. This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Crystal Reports - which version

[Richard Colman]

Planning on installing Crystal Reports to work with CF 4.5x. What is the
consensus on the best version - 8.5 or earlier? TNX for any advice.

Richard Colman


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Stats pkg for Win2K IIS

[Jim McAtee]

We use Statistics Server as well.  If we were only analyzing our own site
traffic and had the $$$ we'd switch to Urchin (http://www.urchin.com).  It's
a bit expensive for a small web host with a few dozen sites.

A sample of their report interface:
http://www.hollywoodweb.com/report/english/

Jim


- Original Message -
From: "WebMaster" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 11:17 AM
Subject: Re: [OT] Stats pkg for Win2K IIS


>
> We use Statistics Server by Mediahouse (http://www.mediahouse.com) which
> has real-time access, so there's no need to schedule anything. You can set
> different user-level access to certain reports and schedule reports to be
> emailed on a daily, weekly or monthly basis.
>
> Overall, we've been very happy with it. The Admin functionality can get a
> little tedious, but it isn't that bad.
>
> Mike
>
>
>
> At 11:04 PM 4/22/2001 -0600, you wrote:
> >I'm looking for a low cost of free stats package to run on Win2K, that
will
> >do automatic nightly reporting.
> >
> >I know that's a general question, but I'm looking for opinions as much as
a
> >list of software that does that.
> >
> >Thanks,
> >
> >Peter Janett
> >
> >New Media One Web Services
> >
> >WEB HOSTING FOR WEB DEVELOPERS
> >
> >Sun, IRIX, Windows 2000, Linux;
> >PHP, MySQL, Perl, Cold Fusion,
> >MS SQL, ASP, SSI, SSL
> >http://www.newmediaone.net
> >[EMAIL PROTECTED]
> >(303)828-9882
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How do i set up a Java CFX tag.

[Rick Lamb]

I need to use a cfx tag written in java and am not sure how to set it up. Do
I need to install a Java Virtual Machine on the server? Any thing else
required? The error I get now is asking me to set up a JVM on the server.
How do I do this. Can someone help me get started?

Thanks,

Rick


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: session vs client

[Benjamin S. Rogers]

We've been switching all of our applications from Session to Client
variables even though most of our applications do not run in clustered
environments. We've just had too many problems with the way in which
ColdFusion handles data stored in shared resources such as memory.

Although religious use of the CFLOCK tag eliminates most of these issues, we
still experience the occasional "Cannot Synchronize Object" errors, or some
equivalently obscure and inexplicable message. Repeated posts to lists and
searches throughout the Web, Allaire Forums, and the Allaire Knowledge base
always proved fruitless.

Though client variables take more overhead (not memory but CPU, Network
Traffic, Database Resources, etc.) and complex datatypes cannot be stored in
a Client variable without first serializing the data into a WDDX structure,
these are relatively minor concerns when compared to the inevitable server
instability or just plain application unreliability brought about by Session
variables.

Of course, my opinion is a little biased. :) I've often been seen ranting on
this list about problems with Session variables and the way ColdFusion
threads handle access to data stored in shared resources. Unfortunately, it
doesn't look like ColdFusion 5 will address any of these issues. So unless
we hear different, we will continue to change all of our application from
Session variables to Client variables.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057


-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:57 PM
To: CF-Talk
Subject: re: session vs client


hi

They appears to be differing opinions to this? I have heard many people
recommend the use of client variables over session variables, regardless of
whether they are hosted in a clustered envoironment.

Are there specific times when session variables are better to use than
client variables, and visa versa?

I'm fairly new to coldfusion and this is a subject which confuses most new
comers

Regards

Mark

Mark Smyth
Developer
Systems Union eBusiness Solutions
01865 880800
[EMAIL PROTECTED] 
www.systemsunion.com 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Form Field OnChange Problem with Cf

[Don Vawter]

Your onChange function operates clientside after coldfusion is done with the
page. You can't set a coldfusion variable because cf is not in the picture
at this point.

- Original Message -
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 12:26 PM
Subject: Form Field OnChange Problem with Cf


> I have a form that the action for it goes to sendmail.exe
>
> I have an onChange function written that checks the value of
> document.formName.Full_Name.value
>
> If I set an to say ("Full Name =" + FullName);
>
> I get the alert telling me that the field has changed.
>
> What I would like to do is set a Cold Fusion variable on this change, but
I
> keep getting errors.
>
> I have tried:
>  document.write("")
> however, when I try and run the template again, I get locked up.
>
> I need to know what this variable has been changed to so that I can send
it
> with my returnurl variable such as this:
>
>
http://www.mydomain.com/prtDsp.cfm?Machine_No=#Machine_No#&FullName=#FullNam
> e#
>
> Everything is working except my FullName variable
>
> Can someone tell me if this is possible.
>
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dylan Bromby]

i have one table with 3.2 million rows that gets accessed approximately
6,000-7,000 times a day. i should put that in the registry?

your comment VERY MUCH depends on the kind of "app" you're talking about. ok
so IIS stores info there. ms office stores info there. but we're talking
about web-based applications which could create LARGE amounts of data. why
would you EVER purposefully tax your registry (which is used by many other
VERY critical processes) with READ/WRITE/DELETE operations when databases
are designed to handle that?

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:49 AM
To: CF-Talk
Subject: RE: Session VS Client


I disagree.  The registry has replaced .ini files.  The registry is a
perfect repositry to store data for your app like DSN'S etc as ini files
used to.

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 17:30
To: CF-Talk
Subject: RE: Session VS Client


i don't think I'd classify the windows registry as a database.  Yes, it
stores data, but so do text files...I wouldn't refer to a text file as a
database.  The registry isn't designed to be read from and written to,
frequently... it's designed for "access - as - needed" use.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:11 PM
To: CF-Talk
Subject: RE: Session VS Client


Wouldn't haver thought it makes a difference.  You either have to put them
in a db or the registrywhich is a db in itself!

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 17:05
To: CF-Talk
Subject: RE: Session VS Client


I suppose that depends on what you are putting in them ;)

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:55 AM
To: CF-Talk
Subject: Session VS Client


OK guys and gals..

Do Client vars take up more server RAM than session Vars.  My colleague
reckons they do wheras I reckon it's the t'other way round

A

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131

RE: Offline forms

[Eric Dawson]

pdf form maybe. post to web server for processing.


From: Terry Bader <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Offline forms
Date: Mon, 23 Apr 2001 10:41:06 -0400

that wont work because the person is working offline, thusly no CF server to
process the request...  I would recommend using a Office template that could
be uploaded when done and processed by the server...


Terry Bader
IT/Web Specialist
Macromedia Certified Coldfusion Developer
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader





 > -Original Message-
 > From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
 > Sent: Monday, April 23, 2001 10:21 AM
 > To: CF-Talk
 > Subject: Re: Offline forms
 >
 >
 > Try saving all the form vars as client vars.
 >
 > HTH,
 >
 > Howie Hamlin - inFusion Project Manager
 > On-Line Data Solutions, Inc.
 > www.CoolFusion.com
 > 631-737-4668 x101
 > inFusion Mail Server (iMS) - the World's most configurable mail server
 >
 > - Original Message -
 > From: "Eric V. Hodge" <[EMAIL PROTECTED]>
 > To: "CF-Talk" <[EMAIL PROTECTED]>
 > Sent: Monday, April 23, 2001 10:16 AM
 > Subject: Offline forms
 >
 >
 > > I have an application that has a series of long multi-page
 > forms so that a
 > user can construct a lengthy document.
 > >
 > > What are some of my options to allow them to save their
 > work offline and
 > come back to it later and continue where they left off.
 > >
 > > Thanks,
 > > Eric
 > >
 > >
 > >
 > >
 >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session VS Client

[Gregory Harris]

My 2 cents worth (gawd it's been awhile since I've posted to this list)

Client Variables:

When set: Stored to Registry after briefly being held in RAM
When got: Gotten from Registry and (briefly) stored to RAM before sent to
user

Anything before going to the Hard Drive would have at least a brief stay in
RAM

Session Variables:

When set: Put in RAM
When got: Retrieved from RAM

You figure on this

Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535


- Original Message -
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:50 AM
Subject: RE: Session VS Client


> >Client variables are probably a better choice if you think you're going
to
> >cluster your application on multiple servers, but on a single server,
> >session variables will perform much better, assuming that there's enough
> >emory to hold them.
>
> Yup agreebut I think you have answered my initial question - in that
> session vars are more intensive when it comes to Server RAM
>
> --
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> --
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: 23 April 2001 17:31
> To: CF-Talk
> Subject: RE: Session VS Client
>
>
> > the general opinion is that client vars are more efficient
> > than session variable, as long as the administrator is configured
> > to store client variables in a database, otherwise it stores client
> > variables in the registry which is less efficient that using session
> > vars.
>
> Either you've got the general opinion wrong, or the general opinion is
> itself wrong (or at least oversimplified).
>
> All other things being equal, it's more efficient to store something that
> will be reused in memory than it is to retrieve it from a database each
time
> it's needed. When you use session variables, you're storing something in
the
> local memory of the CF server. When you use client variables, CF has to
> continually go get them whenever they're needed, if they're stored in a
> database or in the registry.
>
> Client variables are probably a better choice if you think you're going to
> cluster your application on multiple servers, but on a single server,
> session variables will perform much better, assuming that there's enough
> memory to hold them.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Search Engines

[Adkins, Randy]

Out of curiosity, what program is most popular when
submitting website information to search engines?

I have come across a few, or does anyone know any such animal
which is free to use or a very minimal charge?

Thanks in advance!

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL2000 server not recognized by CF 4.5

[David Baskin]

I'm hoping someone can help with a problem i cannot figure out. i have a new
box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend
without problems, but now i cannot get SQL and CF to play together. i try to
set up the ODBC and my connection fails every time. the base SQL server that
shows up as default on the ODBC admin does not connect, nor does the one
that i create. not sure how to trouble shoot this problem at all. any help
is greatly appreciated.

d


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RSVP reminder

[Bryan LaPlante]

Just a quick reminder. If you haven't already registered for the Ben Forta
meeting this Wednesday in Kansas City, go to http://www.kcfusion.org/ and
RSVP for the meeting. All of the information for the meeting is there.

Thanks

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dylan Bromby]

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

> For my applications in question, there was no difference.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower.

> I didn't know session vars were stored in a DB, I thought they were only
stored in memory.

This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

> Ok, I'm not debating whether *anything* should be stored in memory. My
query caching works nicely. My *specific* problem was CF restarting itself
and dropping session vars I was using to keep people "logged into" my
application. I was using them to "maintain state". I found that session vars
were therefore unreliable so I switched to client vars.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: statement help...

[Jay Patton]

I know there is more than one because i am looking in that specific table
and see 12 (at least) records that should be returned.


SELECT *
FROM RodeoManager
WHERE CircuitID = #url.CircuitID#



SELECT SUM(AdjPoints) as totalPoints, ContestantID
FROM ResultsManager
WHERE RodeoID = #getRodeos.RodeoID#
GROUP BY ContestantID
ORDER BY SUM(AdjPoints) DESC





  
#currentRow#

 
SELECT *
FROM ContestantManager
WHERE ContestantID = #resultsP.ContestantID#
#contestants.LastName#, #contestants.FirstName#
(#contestants.City#, #contestants.State#)
#totalPoints#
  
  


Thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Dave f" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 11:06 AM
Subject: Re: statement help...


> How do you know there are 12-ish if you only see 1??
>
> Are you saying that  getRodeos.RecordCount = 1, or have you maybe
forgotten
> to specify queryname in cfoutput loop?
>
> Dave
>
> - Original Message -
> From: "Jay Patton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 12:16 PM
> Subject: Re: statement help...
>
>
> > i tried this also, and it still didnt work
> > since then i have switched everything to be id specific now however, it
> > still only returns the first record w/ that id, now. any ideas this
is
> > my query now
> >
> >  >  datasource="#datasource#"
> >  dbtype="ODBC"
> >  username="#username#"
> >  password="#password#">
> > SELECT *
> > FROM RodeoManager
> > WHERE CircuitID = #url.CircuitID#
> > 
> >
> > thanks,
> >
> > Jay Patton
> > Web Design / Application Design
> > Web Pro USA
> > p. 406.549.3337 ext. 203
> > p. 1.888.5WEBPRO ext. 203
> > e. [EMAIL PROTECTED]
> > url. www.webpro-usa.com
> > - Original Message -
> > From: "Mike Sprague" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 23, 2001 9:48 AM
> > Subject: Re: statement help...
> >
> >
> > > Try the following as your where clause:
> > >
> > > WHERE trim(Circuit) = '#trim(url.CircuitName)#'
> > >
> > > *** REPLY SEPARATOR  ***
> > > On 4/23/2001 at 9:31 AM Jay Patton wrote:
> > >
> > > |Why would this only select one record from the db?(there are about 12
> it
> > > |should return but it only returns one (which is the first one)
> > > |
> > > | > > | datasource="#datasource#"
> > > | dbtype="ODBC"
> > > | username="#username#"
> > > | password="#password#">
> > > |SELECT *
> > > |FROM RodeoManager
> > > |WHERE Circuit = '#url.CircuitName#'
> > > |
> > > |
> > > |
> > > |Thanks,
> > > |
> > > |Jay Patton
> > > |Web Design / Application Design
> > > |Web Pro USA
> > > |p. 406.549.3337 ext. 203
> > > |p. 1.888.5WEBPRO ext. 203
> > > |e. [EMAIL PROTECTED]
> > > |url. www.webpro-usa.com
> > > |
> > > | |
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Simon Horwith]

actually, I believe the cfid and cftoken are stored in memory, even with
client variables.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 4:09 PM
To: CF-Talk
Subject: Re: Session VS Client



   Client variables are stored in:

   The Registry (not recommended)
   A Datasource
   as cookies

   Therefore, they use 0 RAM, zilch, nada, nothing.

   Session variables are stored in RAM.  Since any amount of RAM is bigger 
than no amount of RAM, I would say that session variables must take up more 
RAM.  I'm sure we'll see hundreds of post to this affect.

At 04:55 PM 04/23/2001 +0100, you wrote:
>OK guys and gals..
>
>Do Client vars take up more server RAM than session Vars.  My colleague
>reckons they do wheras I reckon it's the t'other way round
>
>A
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute,
or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dave Watts]

> Can you explain why storing Client vars in the registry is less
> efficient than storing session vars in RAM?

Storing Client variables in anything but cookies is less efficient than
storing session variables in RAM. It's simply faster to get something out of
the memory owned by a process than it is to read a file or query a database.
That's why you cache things in memory.

Keep in mind that efficiency and robustness are often antagonistic goals.
Increasing performance often involves losing stability. Storing Client
variables in the registry, however, is neither efficient nor robust.

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: statement help...

[Christopher Olive, CIO]

are you only outputting one?  as in, do you have QUERY specified in the
CFOUTPUT tag?  or does your debug show only one returned?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:17 PM
To: CF-Talk
Subject: Re: statement help...


i tried this also, and it still didnt work
since then i have switched everything to be id specific now however, it
still only returns the first record w/ that id, now. any ideas this is
my query now


SELECT *
FROM RodeoManager
WHERE CircuitID = #url.CircuitID#


thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:48 AM
Subject: Re: statement help...


> Try the following as your where clause:
>
> WHERE trim(Circuit) = '#trim(url.CircuitName)#'
>
> *** REPLY SEPARATOR  ***
> On 4/23/2001 at 9:31 AM Jay Patton wrote:
>
> |Why would this only select one record from the db?(there are about 12 it
> |should return but it only returns one (which is the first one)
> |
> | | datasource="#datasource#"
> | dbtype="ODBC"
> | username="#username#"
> | password="#password#">
> |SELECT *
> |FROM RodeoManager
> |WHERE Circuit = '#url.CircuitName#'
> |
> |
> |
> |Thanks,
> |
> |Jay Patton
> |Web Design / Application Design
> |Web Pro USA
> |p. 406.549.3337 ext. 203
> |p. 1.888.5WEBPRO ext. 203
> |e. [EMAIL PROTECTED]
> |url. www.webpro-usa.com
> |
> | |
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS-question-> transferring text from one template to another

[Christopher Olive, CIO]

take a look at irt.org and thier JS faq.  there are TONS of code snippets
there.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:31 PM
To: CF-Talk
Subject: OT: JS-question-> transferring text from one template to
another


Hi, I want to do the following:

I have an Input-template with five text-fields.
On on text field (memory-field, text area) I want to call a small browser
window via
JS (wiht a hyperlink). So far so good. I know how I can do that. In the
called template I have another
Input-field which gets filled by the user. What I want to do is transferring
the text in this text-area back to the calling page and reloading, but the
text
already filled in the four ohter input-boxes shouldn't be touched/changed.
How can I do this.
Does s.o. has his code available ?

Thank you.

Uwe
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Dave Watts]

> Wouldn't haver thought it makes a difference. You either have 
> to put them in a db or the registrywhich is a db in itself!

Calling the registry a database is technically accurate in the same way that
you might call an LDAP server a database, but it's conversationally
inaccurate. Typically, when people say "database", they're thinking
"relational database", which the registry isn't. You sure don't want to
treat the registry as a database. It's a hierarchical data store, designed
for frequent reads and infrequent writes.

When used with CF Client variables, you end up with very frequent writes,
causing the registry to grow (sometimes making the machine crash).

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Jeffry Houser]

   I would classify DSNs as system data, not app data.  I think what Simon 
was trying to get at was, the registry is not designed (or optimized) for 
RDBMS functionality.  You do not want to use it to store excessive (or in 
my opinion, any) application data.


At 05:48 PM 04/23/2001 +0100, you wrote:
>I disagree.  The registry has replaced .ini files.  The registry is a
>perfect repositry to store data for your app like DSN'S etc as ini files
>used to.
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>-Original Message-
>From: Simon Horwith [mailto:[EMAIL PROTECTED]]
>Sent: 23 April 2001 17:30
>To: CF-Talk
>Subject: RE: Session VS Client
>
>
>i don't think I'd classify the windows registry as a database.  Yes, it
>stores data, but so do text files...I wouldn't refer to a text file as a
>database.  The registry isn't designed to be read from and written to,
>frequently... it's designed for "access - as - needed" use.
>
>~Simon
>
>Simon Horwith
>Macromedia Certified Instructor
>Certified ColdFusion Developer
>Fig Leaf Software
>1400 16th St NW, # 500
>Washington DC 20036
>202.797.6570 (direct line)
>www.figleaf.com
>
>
>
>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 23, 2001 12:11 PM
>To: CF-Talk
>Subject: RE: Session VS Client
>
>
>Wouldn't haver thought it makes a difference.  You either have to put them
>in a db or the registrywhich is a db in itself!
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>-Original Message-
>From: Simon Horwith [mailto:[EMAIL PROTECTED]]
>Sent: 23 April 2001 17:05
>To: CF-Talk
>Subject: RE: Session VS Client
>
>
>I suppose that depends on what you are putting in them ;)
>
>~Simon
>
>Simon Horwith
>Macromedia Certified Instructor
>Certified ColdFusion Developer
>Fig Leaf Software
>1400 16th St NW, # 500
>Washington DC 20036
>202.797.6570 (direct line)
>www.figleaf.com
>
>
>
>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 23, 2001 11:55 AM
>To: CF-Talk
>Subject: Session VS Client
>
>
>OK guys and gals..
>
>Do Client vars take up more server RAM than session Vars.  My colleague
>reckons they do wheras I reckon it's the t'other way round
>
>A
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely thos

RE: Session VS Client

[Dave Watts]

> the problem with session vars is if CF server restarts itself 
> (which can, sometimes, be a good thing) you lose the session. 
> i use client vars exclusively over session vars now (and cookies 
> too) and store them in a DB. not as fast as memory in *theory*, 
> but in practice it's more reliable and there's no difference in 
> the performance of my applications.

Maybe there's no difference in the performance of your applications, but
I've often seen the move from session to client variables (usually in
preparation for clustering) slow down applications significantly. If you
store enough data in the Session scope, it's not practical to just move that
data to the Client scope, as you'll end up with quite long strings.

Session variables are more robust, certainly (when stored in a database),
but they're definitely quite a bit slower. This makes sense - otherwise, why
would we bother caching queries and output to make applications faster,
rather than just returning to the database for every data view?

Dave Watts, CTO, Fig Leaf Software 
http://www.figleaf.com/ 
voice: (202) 797-5496 
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Jeffry Houser]

   Accessing RAM is quicker than accessing the hard drive.  The registry is 
located on the hard drive.


At 05:32 PM 04/23/2001 +0100, you wrote:
>Can you explain why storing Client vars in the registry is less efficient
>thatn storing session vars in RAM?
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>-Original Message-
>From: Mark Smyth [mailto:[EMAIL PROTECTED]]
>Sent: 23 April 2001 17:12
>To: CF-Talk
>Subject: RE: Session VS Client
>
>
>hi
>
>the general opinion is that client vars are more efficient than session
>variable, as long as the administrator is configured to store client
>variables in a database, otherwise it stores client variables in the
>registry which is less efficient that using session vars.
>
>so in a way you're both right :)
>
>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: 23 April 2001 16:55
>To: CF-Talk
>Subject: Session VS Client
>
>
>OK guys and gals..
>
>Do Client vars take up more server RAM than session Vars.  My colleague
>reckons they do wheras I reckon it's the t'other way round
>
>A
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: statement help...

[Andy Ewings]

Have you tried running this code directly at the db?...i.e. if SQL run in
query analyser.  One thing you could try is put trim statements around the
fied (or LTRIM and RTRIM if you are using SQL). i.e:

SELECT * FROM RodeoManager WHERE TRIM(CircuitID) = #TRIM(url.CircuitID)# 

OR:

SELECT * FROM RodeoManager WHERE LTRIM(RTRIM(CircuitID)) =
#TRIM(url.CircuitID)# 

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Dave f [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 18:07
To: CF-Talk
Subject: Re: statement help...


How do you know there are 12-ish if you only see 1??

Are you saying that  getRodeos.RecordCount = 1, or have you maybe forgotten
to specify queryname in cfoutput loop?

Dave

- Original Message -
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 12:16 PM
Subject: Re: statement help...


> i tried this also, and it still didnt work
> since then i have switched everything to be id specific now however, it
> still only returns the first record w/ that id, now. any ideas this is
> my query now
>
>   datasource="#datasource#"
>  dbtype="ODBC"
>  username="#username#"
>  password="#password#">
> SELECT *
> FROM RodeoManager
> WHERE CircuitID = #url.CircuitID#
> 
>
> thanks,
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> - Original Message -
> From: "Mike Sprague" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 9:48 AM
> Subject: Re: statement help...
>
>
> > Try the following as your where clause:
> >
> > WHERE trim(Circuit) = '#trim(url.CircuitName)#'
> >
> > *** REPLY SEPARATOR  ***
> > On 4/23/2001 at 9:31 AM Jay Patton wrote:
> >
> > |Why would this only select one record from the db?(there are about 12
it
> > |should return but it only returns one (which is the first one)
> > |
> > | > | datasource="#datasource#"
> > | dbtype="ODBC"
> > | username="#username#"
> > | password="#password#">
> > |SELECT *
> > |FROM RodeoManager
> > |WHERE Circuit = '#url.CircuitName#'
> > |
> > |
> > |
> > |Thanks,
> > |
> > |Jay Patton
> > |Web Design / Application Design
> > |Web Pro USA
> > |p. 406.549.3337 ext. 203
> > |p. 1.888.5WEBPRO ext. 203
> > |e. [EMAIL PROTECTED]
> > |url. www.webpro-usa.com
> > |
> > | |
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: session vs client

[Andy Ewings]

I agree, this seems to be a hazy area.  I tend to use client vars even if it
isn't a clustered environment.  IMO I think that the only disadvantage of
Client vars is you can't expire them as easy as you can with sesison vars,
you have to go to the DB and clear the entry.  However the fact that you can
let the db handle locking by using client vars is a godsend!...I find it an
absolute pain having to lock every time I read or write to a session var.
>From what Dave said earlier it seems that it is quicker to use Session Vars
via server RAM rather than client vars via a db providing you have enough
server RAM.  I guess it's a trade off - the more session vars you need to
store (no of session vars you declare * number of active sessions) then the
more there is a case to move to client vars.  Either that or upgrade your
server ram!

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 17:57
To: CF-Talk
Subject: re: session vs client


hi

They appears to be differing opinions to this? I have heard many people
recommend the use of client variables over session variables, regardless of
whether they are hosted in a clustered envoironment.

Are there specific times when session variables are better to use than
client variables, and visa versa?

I'm fairly new to coldfusion and this is a subject which confuses most new
comers

Regards

Mark

Mark Smyth 
Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED]  
www.systemsunion.com 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session VS Client

[Simon Horwith]

I've written plenty of applications, many of which store a wddx packet in a
client variable.  Can you imagine how large the registry would become, and
how quickly, if I were to write wddx packets to it.  The registry is
designed to store windows system settings, not data of this type.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:49 PM
To: CF-Talk
Subject: RE: Session VS Client


I disagree.  The registry has replaced .ini files.  The registry is a
perfect repositry to store data for your app like DSN'S etc as ini files
used to.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 17:30
To: CF-Talk
Subject: RE: Session VS Client


i don't think I'd classify the windows registry as a database.  Yes, it
stores data, but so do text files...I wouldn't refer to a text file as a
database.  The registry isn't designed to be read from and written to,
frequently... it's designed for "access - as - needed" use.

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:11 PM
To: CF-Talk
Subject: RE: Session VS Client


Wouldn't haver thought it makes a difference.  You either have to put them
in a db or the registrywhich is a db in itself!

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 17:05
To: CF-Talk
Subject: RE: Session VS Client


I suppose that depends on what you are putting in them ;)

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:55 AM
To: CF-Talk
Subject: Session VS Client


OK guys and gals..

Do Client vars take up more server RAM than session Vars.  My colleague
reckons they do wheras I reckon it's the t'other way round

A

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
---

Re: Session VS Client

[zac]

Andy Ewings wrote:

> I disagree.  The registry has replaced .ini files.  The registry is a
> perfect repositry to store data for your app like DSN'S etc as ini files
> used to.

The key word here is "store".

Yes it replaces .ini files  but that doesn't mean that it is suited for
multiple and frequent access of that data.



-- 

Every cloud has its silver lining, and lightning kills hundreds of
people each year who are trying to find it.



email: [EMAIL PROTECTED]
web: http://www.pixelgeek.com/


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Form Field OnChange Problem with Cf

[Larry Juncker]

I have a form that the action for it goes to sendmail.exe

I have an onChange function written that checks the value of
document.formName.Full_Name.value

If I set an to say ("Full Name =" + FullName);

I get the alert telling me that the field has changed.

What I would like to do is set a Cold Fusion variable on this change, but I
keep getting errors.

I have tried:
 document.write("")
however, when I try and run the template again, I get locked up.

I need to know what this variable has been changed to so that I can send it
with my returnurl variable such as this:

http://www.mydomain.com/prtDsp.cfm?Machine_No=#Machine_No#&FullName=#FullNam
e#

Everything is working except my FullName variable

Can someone tell me if this is possible.

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Stats pkg for Win2K IIS

[WebMaster]

We use Statistics Server by Mediahouse (http://www.mediahouse.com) which 
has real-time access, so there's no need to schedule anything. You can set 
different user-level access to certain reports and schedule reports to be 
emailed on a daily, weekly or monthly basis.

Overall, we've been very happy with it. The Admin functionality can get a 
little tedious, but it isn't that bad.

Mike



At 11:04 PM 4/22/2001 -0600, you wrote:
>I'm looking for a low cost of free stats package to run on Win2K, that will
>do automatic nightly reporting.
>
>I know that's a general question, but I'm looking for opinions as much as a
>list of software that does that.
>
>Thanks,
>
>Peter Janett
>
>New Media One Web Services
>
>WEB HOSTING FOR WEB DEVELOPERS
>
>Sun, IRIX, Windows 2000, Linux;
>PHP, MySQL, Perl, Cold Fusion,
>MS SQL, ASP, SSI, SSL
>http://www.newmediaone.net
>[EMAIL PROTECTED]
>(303)828-9882
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: JS-question-> transferring text from one template to another

[Terry Bader]

something like:

opener.parent_form.inputfield.value = document.child_form.inputfield.value;

but if you reload the data is not submitted and thusly it comes back as a
reset form...  so you will need to submit it...

opener.parent_form.submit();

//this will reload the parent page: opener.location.reload(true);

then...

self.close()



Terry Bader
IT/Web Specialist
Macromedia Certified Coldfusion Developer
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 12:31 PM
> To: CF-Talk
> Subject: OT: JS-question-> transferring text from one template to
> another
> 
> 
> Hi, I want to do the following:
> 
> I have an Input-template with five text-fields.
> On on text field (memory-field, text area) I want to call a 
> small browser
> window via
> JS (wiht a hyperlink). So far so good. I know how I can do 
> that. In the
> called template I have another
> Input-field which gets filled by the user. What I want to do 
> is transferring
> the text in this text-area back to the calling page and 
> reloading, but the
> text
> already filled in the four ohter input-boxes shouldn't be 
> touched/changed.
> How can I do this.
> Does s.o. has his code available ?
> 
> Thank you.
> 
> Uwe
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session VS Client

[Jeffry Houser]

   Client variables are stored in:

   The Registry (not recommended)
   A Datasource
   as cookies

   Therefore, they use 0 RAM, zilch, nada, nothing.

   Session variables are stored in RAM.  Since any amount of RAM is bigger 
than no amount of RAM, I would say that session variables must take up more 
RAM.  I'm sure we'll see hundreds of post to this affect.

At 04:55 PM 04/23/2001 +0100, you wrote:
>OK guys and gals..
>
>Do Client vars take up more server RAM than session Vars.  My colleague
>reckons they do wheras I reckon it's the t'other way round
>
>A
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFSCRIPT Challenged ??

[Gerry Pauline]

David / All:

Thank you David, that certainity cured the array offset problem -- I
should be a little more careful when cutting & pasting code, would also
help if I proofed it better (but for the life of me, I just didn't see
the increment).

The CFSCRIPT code executes without error now, but I still must be
addressing the array of structures incorrectly in CFSCRIPT "talk", since
all 100 records output are the same (the first structure in the array).
Could someone please provide the correct interpretation of this CFML
code:





   #Student[T].ID#
   #Student[T].LN#
   #Student[T].FN#





This is the CFSCRIPT code:

WriteOutput("") ;

for (T = 1 ; T LTE #ArrayLen(Student)# ; T = T + 1)
{
  WriteOutput("
   #Student[T].ID#
   #Student[T].LN#
   #Student[T].FN#
   ") ;
}

WriteOutput("") ;

Although this code executes without error, only the first set of
elements are outputted for all 100 records; the CFML code executes as
desired.

Thank You !

-Gerry (CFSCRIPT Humbled !)

Gerard T. Pauline
Mgr, Internet/DB Applications
Computer Systems, DoIT
Pace University

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: statement help...

[Dave f]

How do you know there are 12-ish if you only see 1??

Are you saying that  getRodeos.RecordCount = 1, or have you maybe forgotten
to specify queryname in cfoutput loop?

Dave

- Original Message -
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 12:16 PM
Subject: Re: statement help...


> i tried this also, and it still didnt work
> since then i have switched everything to be id specific now however, it
> still only returns the first record w/ that id, now. any ideas this is
> my query now
>
>   datasource="#datasource#"
>  dbtype="ODBC"
>  username="#username#"
>  password="#password#">
> SELECT *
> FROM RodeoManager
> WHERE CircuitID = #url.CircuitID#
> 
>
> thanks,
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> - Original Message -
> From: "Mike Sprague" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 9:48 AM
> Subject: Re: statement help...
>
>
> > Try the following as your where clause:
> >
> > WHERE trim(Circuit) = '#trim(url.CircuitName)#'
> >
> > *** REPLY SEPARATOR  ***
> > On 4/23/2001 at 9:31 AM Jay Patton wrote:
> >
> > |Why would this only select one record from the db?(there are about 12
it
> > |should return but it only returns one (which is the first one)
> > |
> > | > | datasource="#datasource#"
> > | dbtype="ODBC"
> > | username="#username#"
> > | password="#password#">
> > |SELECT *
> > |FROM RodeoManager
> > |WHERE Circuit = '#url.CircuitName#'
> > |
> > |
> > |
> > |Thanks,
> > |
> > |Jay Patton
> > |Web Design / Application Design
> > |Web Pro USA
> > |p. 406.549.3337 ext. 203
> > |p. 1.888.5WEBPRO ext. 203
> > |e. [EMAIL PROTECTED]
> > |url. www.webpro-usa.com
> > |
> > | |
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: statement help...

[Diana Nichols]

Perhaps the problem lies in the outputwhat does that code look like?

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:17 PM
To: CF-Talk
Subject: Re: statement help...


i tried this also, and it still didnt work
since then i have switched everything to be id specific now however, it
still only returns the first record w/ that id, now. any ideas this is
my query now


SELECT *
FROM RodeoManager
WHERE CircuitID = #url.CircuitID#


thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:48 AM
Subject: Re: statement help...


> Try the following as your where clause:
>
> WHERE trim(Circuit) = '#trim(url.CircuitName)#'
>
> *** REPLY SEPARATOR  ***
> On 4/23/2001 at 9:31 AM Jay Patton wrote:
>
> |Why would this only select one record from the db?(there are about 12 it
> |should return but it only returns one (which is the first one)
> |
> | | datasource="#datasource#"
> | dbtype="ODBC"
> | username="#username#"
> | password="#password#">
> |SELECT *
> |FROM RodeoManager
> |WHERE Circuit = '#url.CircuitName#'
> |
> |
> |
> |Thanks,
> |
> |Jay Patton
> |Web Design / Application Design
> |Web Pro USA
> |p. 406.549.3337 ext. 203
> |p. 1.888.5WEBPRO ext. 203
> |e. [EMAIL PROTECTED]
> |url. www.webpro-usa.com
> |
> | |
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Is CF still relevant?

[Jeffry Houser]

   It's been a while since I've done any Java programming and I don't claim 
to be an expert, but the most common browsers (IE / Navigator) have a Java 
Virtual Machine in them.  An applet runs in the browser and has nothing to 
do with CF, ASP, JSP, or PHP.  You don't need any of those technologies to 
use a Java applet.

At 09:45 AM 04/23/2001 -0500, you wrote:
>Joe said:
> > If you're calling the better-suited things in as a CF object (e.g. Java,
>COM,
> > MSXML) to do things, then why not just use those technologies (or
>families
> > of technologies) and skip the CF entirely?
>
>I'm not sure I follow this. To use JAVA, COM, or any of these other
>"techologies" on a web site, you have to call them from another technology
>that actually communicates with the browser. This is part of what CF, ASP,
>JSP, and PHP do. Where is the distinction?
>
>--John
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

re: session vs client

[Mark Smyth]

hi

They appears to be differing opinions to this? I have heard many people
recommend the use of client variables over session variables, regardless of
whether they are hosted in a clustered envoironment.

Are there specific times when session variables are better to use than
client variables, and visa versa?

I'm fairly new to coldfusion and this is a subject which confuses most new
comers

Regards

Mark

Mark Smyth 
Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED]  
www.systemsunion.com  

 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists