client cookies - strategy question

2002-04-15 Thread Richard Meredith-Hardy

I have this site which is pointed at by several URL's ie www.aaa.com,
www.bbb.com Etc.

I want to have users log in only once in any of the sites and then be
able to freely switch between sites in a logged-in state.  The
application name is the same for all.

The client can have access to the same client vars on the server if the
CFID  CFTOKEN in any URL's or forms which switch between sites (ie is
setting cookies pointing to the same CFID  CFTOKEN for each site)

Is this a really bad idea?

I can think of one serious inherent risk:  copying url's with CFID 
CFTOKEN in them and sending them to friends.

This can be alleviated with client vars like aaaVisitedOnce =
true/false, bbbVisitedOnce = true/false etc with the default false, but
once true (ie after first ever visit) the cookie is set for that site so
the CFID  CFTOKEN no longer needs to be passed in URL's (or forms) so
the risk is reduced to only when the user has never visited the other
site.

or perhaps a more solid approach would be if any of my
client.xxxVisitedOnce vars were false then I could include a hidden
frame in the page calling a very small page from that site with the CFID
 CFTOKEN so cookies get set on all false sites invisibly.

It's the principle of sharing one CFID  CFTOKEN  between many sites
which I am wondering about though


--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Mob: + 44 7771 526513
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Upgrade to CF 5.0 - yes or no ??

2002-04-15 Thread Harmony Jones

Presently running CF 4.5 SP2 on W2K, IIS5 with SQL2000 database.

Things generally seem OK, except for some users getting random errors about 
missing
parameters - either form data or url parameters (a problem we still have 
not been able to resolve but heard it goes away with CF 5.0)

We are contemplating upgrading to CF.5.0 but not sure about full backward 
compatability and the concern that it may end up creating new problems. The 
main attraction to upgrade is the alleged increased in performance, and the 
fact that with NEO coming along we want to remain somewhat current.

Does anyone have any input to share? Should we stay put or push forward. Is 
CF 5.0 worth it?





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



RE: Upgrade to CF 5.0 - yes or no ??

2002-04-15 Thread Craig Dudley

In a word, yes.

As with any upgrade in a live production environment, it's never quite that
cut and dried, but I've heard very few people complaining about problems
upgrading to Cf5, it certainly went very smoothly for us.



-Original Message-
From: Harmony Jones [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 11:27 AM
To: CF-Talk
Subject: Upgrade to CF 5.0 - yes or no ??

Presently running CF 4.5 SP2 on W2K, IIS5 with SQL2000 database.

Things generally seem OK, except for some users getting random errors about 
missing
parameters - either form data or url parameters (a problem we still have 
not been able to resolve but heard it goes away with CF 5.0)

We are contemplating upgrading to CF.5.0 but not sure about full backward 
compatability and the concern that it may end up creating new problems. The 
main attraction to upgrade is the alleged increased in performance, and the 
fact that with NEO coming along we want to remain somewhat current.

Does anyone have any input to share? Should we stay put or push forward. Is 
CF 5.0 worth it?






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



RE: Upgrade to CF 5.0 - yes or no ??

2002-04-15 Thread Neil Clark - =TMM=

Yep,

Failrly straighforward; there are a few bugs, but there are patches for
most 
things.


Neil

Neil Clark
Team Macromedia Spectra
http://www.macromedia.com/go/team


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



RE: How do you call a cfscript udf function and pass a query to it?

2002-04-15 Thread Raymond Camden

Bare in mind that almost any UDF could be rewritten as a custom tag, or
as a cfinclude.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

 -Original Message-
 From: lmarcus [mailto:[EMAIL PROTECTED]] 
 Sent: Monday, April 15, 2002 12:50 AM
 To: CF-Talk
 Subject: Re: How do you call a cfscript udf function and pass 
 a query to it?
 
 
 Thanks guys, my worst fears are confirmed! I guess I will 
 have to get an
 update.
 
 L Marcus
 - Original Message -
 From: Jon Hall [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, April 15, 2002 12:39 AM
 Subject: Re: How do you call a cfscript udf function and pass 
 a query to it?
 
 
  UDF's are not a feature of CF 4.5. 5+ only.
 
  lmarcus wrote:
   The error is that it doesnt know that CallQuery Exists. 
 This is done in
 CF
   4.5.
  
   Thanks
  
   L Marcus
  
   cfquery name=LarryRec datasource=db2 maxrows=100 
 dbtype=ODBC
 debug
   SELECT lastname, address FROM larry4
   /cfquery
  
   cfset temp= CallQuery(LarryRec, cyan, magenta)
  
 

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



RE: quotes

2002-04-15 Thread Adrian Lynch

I haven't checked too much to see if this is what you want, but this takes
out left, right and straight(?) double quotes and inserts the entity name
for double quotes in to the database instead

value=#trim(replacelist(form.var, ,,, quot;,quot;,quot;))#

But...

a problem I came across comes up when you have this in the DB.

quot;Helloquot;

and you try to display 14 characters, you end up with 

Helloqu

in a prefilled textbox for example.

A simpler way around this if you are only going to be pulling double qoutes
from the DB is to use single quotes in the html code, this is the way you
get around the problem using html.

Another way, would be to check to see if the string you get from the DB
contains a double qoute and change the value= to value='' in the html
code, or vice versa.

The problem with these is that if both single and double qoutes are being
pulled, then ya stuffed.

I hope that made sense

Ade

Anyone with any better more fool proof ways of doing it??

-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: 12 April 2002 23:07
To: CF-Talk
Subject: quotes


Dear All,
I'm facing a problem and can't figure out the solution
and would love anyones help.
the situation is this:
i have a form for users to fill, i take their entry
and enter it in the database, then i take it and
display it in a form so they can edit it.
the problem is this:
if uses enter double quotes my html gets mixed up and
considers the users quote to be the end of the output
value for the input field. 
Example:

form
   input type=text value=myvalue
/form
myvalue is a variable which is read from the DB and
contains a double quote now if 
myvalue = this is a double quote  like this.

the output html will look like this:
input type=text value=this is a double quote 
like this.

and the output like this:
this is a double quote

and that's it..cause it took the double quote as the
end of the value field.

now what do i do?  how can i prevent that from
happing?
Thanks,



=
Heidi Belal
www.code-corner.com
ICQ# 32127109

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

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



Re: Upgrade to CF 5.0 - yes or no ??

2002-04-15 Thread Valerie L. Criswell

Our upgrade went well with the exception of our cfgraph implementations.
I'm trying to remember, but it was something about a different Java version
being used in the newer version.  That was a mess.  5.0 did seem to smooth
out some problems, and run faster, but not so much in a way that I could
really cite examples.  In any event, it was a good investment.

We actually originally had ColdFusion Express, which we upgraded to 4.5
which we upgraded to 5.0.  I don't think we'll upgrade immediately to MX,
though.  We're tickled with 5.0, and it seems like we just bought it!  In
technology there's always something faster and better.  *sigh*  Maybe in
another year.

~Val

- Original Message -
From: Harmony Jones [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 6:27 AM
Subject: Upgrade to CF 5.0 - yes or no ??


 Presently running CF 4.5 SP2 on W2K, IIS5 with SQL2000 database.

 Things generally seem OK, except for some users getting random errors
about
 missing
 parameters - either form data or url parameters (a problem we still have
 not been able to resolve but heard it goes away with CF 5.0)

 We are contemplating upgrading to CF.5.0 but not sure about full backward
 compatability and the concern that it may end up creating new problems.
The
 main attraction to upgrade is the alleged increased in performance, and
the
 fact that with NEO coming along we want to remain somewhat current.

 Does anyone have any input to share? Should we stay put or push forward.
Is
 CF 5.0 worth it?


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



options for image resizing tags

2002-04-15 Thread Gyrus

I'm wanting to keep images uploaded within a certain size. I'm cursing
CF a bit because I'm aware that PHP has image manipulation functions
built-in (anyone know if there's similar stuff upcoming in CF Neo/MX?).

Well, the only solutions I can find are CFX tags. Are there any
recommendations for free tags that can resize images?

Also, whether or not I use a CFX tag obviously depends on whether I
*can* use it. We haven't settled on a host yet, so I've a more general
question as well: how common/uncommon is it for shared hosting setups to
allow CFX tags to be installed? Would I only be able to do this on a
dedicated server?

Any advice on this issue extremely welcome!

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


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



RE: options for image resizing tags

2002-04-15 Thread Craig Thomas

http://www.cfdev.com/products/productdetail.cfm?id=6

I have never used this, but thought it may help.

Craig

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 8:34 AM
To: CF-Talk
Subject: options for image resizing tags


I'm wanting to keep images uploaded within a certain size. I'm cursing
CF a bit because I'm aware that PHP has image manipulation functions
built-in (anyone know if there's similar stuff upcoming in CF Neo/MX?).

Well, the only solutions I can find are CFX tags. Are there any
recommendations for free tags that can resize images?

Also, whether or not I use a CFX tag obviously depends on whether I
*can* use it. We haven't settled on a host yet, so I've a more general
question as well: how common/uncommon is it for shared hosting setups to
allow CFX tags to be installed? Would I only be able to do this on a
dedicated server?

Any advice on this issue extremely welcome!

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available



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



Re: client cookies - strategy question

2002-04-15 Thread David Schmidt

I would just require that they have cookies on, and exclude putting cfid/cftoken in 
the url.  I guess they could share the
cfid/cftoken cookie, but you could do some ipaddress checking/monitoring to watch for 
people sharing cookies (not 100% accurate,
of course).  If too many different ip addresses (speaking of the first the octets - 
234.100.130.xxx) are used for the same login
in a set period of time, you could disable the account.

Other considerations include the data stored in the client variables.  If the only 
information stored is their login status,
then I think that there isn't a problem sharing client vars among apps.  However, if 
there is other information stored, you
should separate them.  One day, you will be coding on application 'A' and you will 
mistakingly use the same variable name that
application 'B' is using.  That could get ugly.

Dave



- Original Message -
From: Richard Meredith-Hardy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 11:37 PM
Subject: client cookies - strategy question


 I have this site which is pointed at by several URL's ie www.aaa.com,
 www.bbb.com Etc.

 I want to have users log in only once in any of the sites and then be
 able to freely switch between sites in a logged-in state.  The
 application name is the same for all.

 The client can have access to the same client vars on the server if the
 CFID  CFTOKEN in any URL's or forms which switch between sites (ie is
 setting cookies pointing to the same CFID  CFTOKEN for each site)

 Is this a really bad idea?

 I can think of one serious inherent risk:  copying url's with CFID 
 CFTOKEN in them and sending them to friends.

 This can be alleviated with client vars like aaaVisitedOnce =
 true/false, bbbVisitedOnce = true/false etc with the default false, but
 once true (ie after first ever visit) the cookie is set for that site so
 the CFID  CFTOKEN no longer needs to be passed in URL's (or forms) so
 the risk is reduced to only when the user has never visited the other
 site.

 or perhaps a more solid approach would be if any of my
 client.xxxVisitedOnce vars were false then I could include a hidden
 frame in the page calling a very small page from that site with the CFID
  CFTOKEN so cookies get set on all false sites invisibly.

 It's the principle of sharing one CFID  CFTOKEN  between many sites
 which I am wondering about though


 --
 Regards;

 Richard Meredith-Hardy
 -
 [EMAIL PROTECTED]
 Mob: + 44 7771 526513
 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: options for image resizing tags

2002-04-15 Thread Gyrus

 - Original Message -
 From: Craig Thomas [EMAIL PROTECTED]


 http://www.cfdev.com/products/productdetail.cfm?id=6

Thanks, this is the one (free) tag I'd found already. 500KB seems a bit
hefty - is this usual for this sort of tag?

Still caught in whether to build site using a CFX tag, not knowing
whether shared hosting usually allows CFX tags. Have scanned a few
places, some seem to allow it. How much would I be limiting my hosting
options by building with CFX tags?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


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



survey trouble

2002-04-15 Thread Craig Thomas

I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com

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



RE: quotes

2002-04-15 Thread Adrian Lynch

should have pointed out that in the code below,   ,,
 that is a left quote, right quote and an escaped double qoute, all
surrounded in qoutes. Just read my email and it didn't show up as I
intended, problems with the left and right qoutes come about through copying
and pasting from Word ect.

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 15 April 2002 13:09
To: CF-Talk
Subject: RE: quotes


I haven't checked too much to see if this is what you want, but this takes
out left, right and straight(?) double quotes and inserts the entity name
for double quotes in to the database instead

value=#trim(replacelist(form.var, ,,, quot;,quot;,quot;))#

But...

a problem I came across comes up when you have this in the DB.

quot;Helloquot;

and you try to display 14 characters, you end up with 

Helloqu

in a prefilled textbox for example.

A simpler way around this if you are only going to be pulling double qoutes
from the DB is to use single quotes in the html code, this is the way you
get around the problem using html.

Another way, would be to check to see if the string you get from the DB
contains a double qoute and change the value= to value='' in the html
code, or vice versa.

The problem with these is that if both single and double qoutes are being
pulled, then ya stuffed.

I hope that made sense

Ade

Anyone with any better more fool proof ways of doing it??

-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: 12 April 2002 23:07
To: CF-Talk
Subject: quotes


Dear All,
I'm facing a problem and can't figure out the solution
and would love anyones help.
the situation is this:
i have a form for users to fill, i take their entry
and enter it in the database, then i take it and
display it in a form so they can edit it.
the problem is this:
if uses enter double quotes my html gets mixed up and
considers the users quote to be the end of the output
value for the input field. 
Example:

form
   input type=text value=myvalue
/form
myvalue is a variable which is read from the DB and
contains a double quote now if 
myvalue = this is a double quote  like this.

the output html will look like this:
input type=text value=this is a double quote 
like this.

and the output like this:
this is a double quote

and that's it..cause it took the double quote as the
end of the value field.

now what do i do?  how can i prevent that from
happing?
Thanks,



=
Heidi Belal
www.code-corner.com
ICQ# 32127109

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/


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



Re: client cookies - strategy question

2002-04-15 Thread Justin Scott

 I have this site which is pointed at by several URL's ie www.aaa.com,
 www.bbb.com Etc.

 I want to have users log in only once in any of the sites and then be
 able to freely switch between sites in a logged-in state.  The
 application name is the same for all.

Here's how I would do this...

1. I use a two-cookie system for maintaining state, a member_id and a
session_id.  When someone logs into one of the sites, give them the
member_id cookies, generate a random session hash with CreateUUID(), put
that in the database, then set the session_id cookie with that value.

2. In your security code, check the cookies against the values in the
database (I set a cache on this query of 2-3 minutes).  If no records are
returned, or if the last_action value (below) is too out of date (15-20
mins) then they are NOT logged in and need to be directed to login page.  If
they ARE logged in, update the last_action column.

3. In any links to your other sites, include the current session_id on the
URL with a special variable name.  In the Application.cfm (or other global
file) check for this value.  If present, check the database for a user with
that ID and a recent last_action value.  If one is found, set the member_id
and session_id cookies just as if they had logged in directly to that site.



* You would not have to worry about someone copying a URL and getting access
at a later date.  The chances of someone having the exact same session hash
generated by CreateUUID() within your session timeout period is practically
non-existent.

* You won't need to worry about CF's session/client management.  If your
application scales to the point where it needs to run on clustered servers,
your authentication won't break.



If you have any questions, feel free to mail me off-list.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


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



RE: survey trouble

2002-04-15 Thread Clint Tredway

Use radio buttons for the display and give each answer a number.

That way you know how each question was answered.

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 8:04 AM
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com


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



RE: survey trouble

2002-04-15 Thread James Maltby

What about giving each a letter value = e.g.

Strong A = A
Agree = B
Neutral = C
Etc.

Then on landing page converting the val via a switch statement into a
value and inserting it into the database.

cfquery datasource= name=
UPDATE table  
cfswitch expression=#form.val#
cfcase value=A
SET Valcolumn_A = Valcolumn_A + 1
/cfcase
cfcase value=B
SET Valcolumn_B = Valcolumn_B + 1
/cfcase
cfcase value=C
SET Valcolumn_C = Valcolumn_C + 1
/cfcase
Etc.
/cfswitch
/cfquery

I think this should work, but it may be worth a try - mainly due to
cfswtich being a little flaky inside cfquery

J

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 14:04
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com


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



Re: survey trouble

2002-04-15 Thread Gyrus

How about creating a table with these fields:

answerID
answer (contains the texts you specified)

Make sure the IDs represent the answer's position in the scale (Strongly
Agree = 5, Strongly Disagree = 1). Then have a linking table between the
users, answers and questions:

userID
questionID
answerID

(I guess the Primary Key will be a combination of all three fields.)

To get people who agree with a question:

SELECT u.username
FROM users u, userAnswers ua
WHERE u.userID = ua.userID
AND ua.questionID = #questionID#
AND ua.answerID  3

etc.! If your answers are fixed, maybe the answers table wouldn't be
necessary. Just have a 'answer' field in userAnswers, set between 1 and
5 according to the answer.

HTH

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


- Original Message -
From: Craig Thomas [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 2:03 PM
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers
without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com


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



RE: survey trouble

2002-04-15 Thread James Maltby

Or, alternately - if you have 10 answers to collect, give each a
number/letter value

Q1. 1A, 1B, 1C, etc.
Q2. 2A, 2B, 2c, etc.

Then just insert them as usual

query
INSERT INTO tablename (col_Q1, col_Q2, col_Q3, etc.)
VALUES (#form.Q1#, #form.Q2#, etc)
/query

Then you can read the table and know how many users voted for each
question

J

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 14:17
To: CF-Talk
Subject: RE: survey trouble


What about giving each a letter value = e.g.

Strong A = A
Agree = B
Neutral = C
Etc.

Then on landing page converting the val via a switch statement into a
value and inserting it into the database.

cfquery datasource= name=
UPDATE table  
cfswitch expression=#form.val#
cfcase value=A
SET Valcolumn_A = Valcolumn_A + 1
/cfcase
cfcase value=B
SET Valcolumn_B = Valcolumn_B + 1
/cfcase
cfcase value=C
SET Valcolumn_C = Valcolumn_C + 1
/cfcase
Etc.
/cfswitch
/cfquery

I think this should work, but it may be worth a try - mainly due to
cfswtich being a little flaky inside cfquery

J

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 14:04
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com



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



RE: survey trouble

2002-04-15 Thread Adrian Lynch

'Strongly Agree'  2
'Agree' 1
'Neutral'  0
'Disagree' -1 
'Strongly Disagree' -2

Doing something like this makes it easier to know if they agree or disagree,
or if you then decide you want specific answers, you still have the exact
results. Positive number = agree, negative = disagree, 0 = Neutral.

Ade

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: 15 April 2002 14:04
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com


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



RE: options for image resizing tags

2002-04-15 Thread Brad Roberts

Do a search on google for cfx_image and hosting:

http://www.google.com/search?sourceid=navclientquerytime=89bpDq=cfx%5Fimag
e+hosting

It turned up around 4 or 5 companies.  I've been using the cfx_image tag
from gafware.com:

http://devex.macromedia.com/developer/gallery/info.cfm?ID=50E6377D-1C4A-11D6
-83FC00508B94F85Amethod=Full

It works great and has good documentation.

-Brad


 -Original Message-
 From: Gyrus [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 15, 2002 8:53 AM
 To: CF-Talk
 Subject: Re: options for image resizing tags


  - Original Message -
  From: Craig Thomas [EMAIL PROTECTED]
 

  http://www.cfdev.com/products/productdetail.cfm?id=6

 Thanks, this is the one (free) tag I'd found already. 500KB seems a bit
 hefty - is this usual for this sort of tag?

 Still caught in whether to build site using a CFX tag, not knowing
 whether shared hosting usually allows CFX tags. Have scanned a few
 places, some seem to allow it. How much would I be limiting my hosting
 options by building with CFX tags?

 - Gyrus

 
 - [EMAIL PROTECTED]
 work: http://www.tengai.co.uk
 play: http://www.norlonto.net
 - PGP key available
 

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



RE: survey trouble

2002-04-15 Thread Craig Thomas

wouldn't this mandate a table to store totals for each question?

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:17 AM
To: CF-Talk
Subject: RE: survey trouble


What about giving each a letter value = e.g.

Strong A = A
Agree = B
Neutral = C
Etc.

Then on landing page converting the val via a switch statement into a
value and inserting it into the database.

cfquery datasource= name=
UPDATE table
cfswitch expression=#form.val#
cfcase value=A
SET Valcolumn_A = Valcolumn_A + 1
/cfcase
cfcase value=B
SET Valcolumn_B = Valcolumn_B + 1
/cfcase
cfcase value=C
SET Valcolumn_C = Valcolumn_C + 1
/cfcase
Etc.
/cfswitch
/cfquery

I think this should work, but it may be worth a try - mainly due to
cfswtich being a little flaky inside cfquery

J

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 14:04
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com



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



RE: survey trouble

2002-04-15 Thread David DiPietro

We do it this way
Table for responses

ID
EventID
ParticipantID
EvaluationID
EvalQuestionID
Response

Then we query  total by EvaluationID and EvalQuestionID



-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:47 AM
To: CF-Talk
Subject: RE: survey trouble


wouldn't this mandate a table to store totals for each question?

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:17 AM
To: CF-Talk
Subject: RE: survey trouble


What about giving each a letter value = e.g.

Strong A = A
Agree = B
Neutral = C
Etc.

Then on landing page converting the val via a switch statement into a
value and inserting it into the database.

cfquery datasource= name=
UPDATE table
cfswitch expression=#form.val#
cfcase value=A
SET Valcolumn_A = Valcolumn_A + 1
/cfcase
cfcase value=B
SET Valcolumn_B = Valcolumn_B + 1
/cfcase
cfcase value=C
SET Valcolumn_C = Valcolumn_C + 1
/cfcase
Etc.
/cfswitch
/cfquery

I think this should work, but it may be worth a try - mainly due to
cfswtich being a little flaky inside cfquery

J

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 14:04
To: CF-Talk
Subject: survey trouble


I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com




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



Listing out departments (again)

2002-04-15 Thread Paul Giesenhagen

I have to ask this one again .. I asked this question late Friday and didn't get any 
answers that actually fit my situation.  I will try to have this question make sense.

I am trying to build an OUTPUT that would look like this:

Fishing
Fishing/Rods/Baitcast
Fishing/Rods/Baitcast/Special Bait Cast Rods/...
Fishing/Rods/Baitcast/Not so Special Rods/...
Fishing/Rods/Spinning
Fishing/Reels/BaitCast
Fishing/Reels/Spinning
Fishing/Line
Camping
Camping/Tents
Camping/Stoves/Big Stoves
Camping/Stoves/Little Stoves
Camping/Sleeping Bags
Marine/ ect...

Ok as you can see, we have 3 main departments (actually more, but for example we will 
go with whats above), and multiple departments (unlimited depth) that are below each 
department.

My table structure is this:
ID = Identifying id
OWNER = Parent
SUB_OBJECT = Child
(Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and SUB_OBJECT=BAITCAST)

As you can see, parents can be children and children can become parents.  I am 
inserting NAMES instead of ID values that are in the actual table (makes it more 
readable for this message).  Each Owner/Sub_object is an ID Value that relates to 
another table called departments.  As you can see, sub_objects end up becoming OWNERs 
with sub_objects below them.  So parents can be children and children can become 
parents.

Table Setup

ID|OWNER| SUB_OBJECT
1IndexFishing
2IndexCamping
3IndexMarine
4Fishing  Rods
5   Fishing  Reels
6   Fishing  Line
7RodsBaitcast
8BaitcastSpecial Baitcast Rods
9BiatcastNot so Special Rods
10RodsSpinning 
11ReelsBaitcast
12ReelsSpinning
13  CampingTents
14  CampingStoves
15  CampingSleeping Bags
16  StovesBig Stoves
17  StovesLittle Stoves
18

I know the INDEX value and each of my Index Sub_objects are my main catagories, and 
want wind down through all the departments and build a recursive list that starts with 
main catagory and build a catagory/sub_dept/sub_dept/sub_dept ect...

I know this is alittle loong and I appologize .. but I am dumbfounded and keep 
looping myself into nowhere, trying to get the output as it is above.

Anyhelp with the SQL and CF Syntax is greatly appreciated!

At this point, I am not looking for performance :) just a solution!

Comon' I know that there is a supermind that can help me!!

Thank you
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
   


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



RE: options for image resizing tags

2002-04-15 Thread Benjamin S. Rogers

For simple resizing, have a look at the cfx_Image tag mentioned in
another response. If you need anything more than that, have a look at
ImageMagick (http://www.imagemagick.org). It is free and extremely
powerful.

The downside is you have to invoke ImageMagick from the command line
using the CFEXECUTE tag. You'll probably find more hosts willing to
install a custom tag than who've enabled the CFEXECUTE tag.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 8:53 AM
To: CF-Talk
Subject: Re: options for image resizing tags


 - Original Message -
 From: Craig Thomas [EMAIL PROTECTED]


 http://www.cfdev.com/products/productdetail.cfm?id=6

Thanks, this is the one (free) tag I'd found already. 500KB seems a bit
hefty - is this usual for this sort of tag?

Still caught in whether to build site using a CFX tag, not knowing
whether shared hosting usually allows CFX tags. Have scanned a few
places, some seem to allow it. How much would I be limiting my hosting
options by building with CFX tags?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available



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



RE: Listing out departments (again)

2002-04-15 Thread Carlisle, Eric

If you're using Oracle, look up the CONNECT BY SQL+ feature.  You can
easily draw out trees of parent/child categories.
http://www.orafaq.com/faqsql.htm#TREE


If not, look into sql self joins.  That's a good way of denormalizing
parent/child data in the same table.
In fact, here's a good link for that.
http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html

Good luck!

EC



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 10:08 AM
To: CF-Talk
Subject: Listing out departments (again)


I have to ask this one again .. I asked this question late Friday and didn't
get any answers that actually fit my situation.  I will try to have this
question make sense.

I am trying to build an OUTPUT that would look like this:

Fishing
Fishing/Rods/Baitcast
Fishing/Rods/Baitcast/Special Bait Cast Rods/...
Fishing/Rods/Baitcast/Not so Special Rods/...
Fishing/Rods/Spinning
Fishing/Reels/BaitCast
Fishing/Reels/Spinning
Fishing/Line
Camping
Camping/Tents
Camping/Stoves/Big Stoves
Camping/Stoves/Little Stoves
Camping/Sleeping Bags
Marine/ ect...

Ok as you can see, we have 3 main departments (actually more, but for
example we will go with whats above), and multiple departments (unlimited
depth) that are below each department.

My table structure is this:
ID = Identifying id
OWNER = Parent
SUB_OBJECT = Child
(Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and
SUB_OBJECT=BAITCAST)

As you can see, parents can be children and children can become parents.  I
am inserting NAMES instead of ID values that are in the actual table (makes
it more readable for this message).  Each Owner/Sub_object is an ID Value
that relates to another table called departments.  As you can see,
sub_objects end up becoming OWNERs with sub_objects below them.  So parents
can be children and children can become parents.

Table Setup

ID|OWNER| SUB_OBJECT
1IndexFishing
2IndexCamping
3IndexMarine
4Fishing  Rods
5   Fishing  Reels
6   Fishing  Line
7RodsBaitcast
8BaitcastSpecial Baitcast Rods
9BiatcastNot so Special Rods
10RodsSpinning 
11ReelsBaitcast
12ReelsSpinning
13  CampingTents
14  CampingStoves
15  CampingSleeping Bags
16  StovesBig Stoves
17  StovesLittle Stoves
18

I know the INDEX value and each of my Index Sub_objects are my main
catagories, and want wind down through all the departments and build a
recursive list that starts with main catagory and build a
catagory/sub_dept/sub_dept/sub_dept ect...

I know this is alittle loong and I appologize .. but I am dumbfounded and
keep looping myself into nowhere, trying to get the output as it is above.

Anyhelp with the SQL and CF Syntax is greatly appreciated!

At this point, I am not looking for performance :) just a solution!

Comon' I know that there is a supermind that can help me!!

Thank you
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
   



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



Re: options for image resizing tags

2002-04-15 Thread Richard Meredith-Hardy

CFX_IMAGE  will do what you want, and a lot more.

not sure where you get it at the moment (look in this list's archive, it
will be there somewhere) but the latest version (1.4 I think) is thread
safe.

I have two very busy apps using it practically every page impression;
fast with no problems.

Note the help file - if you can call it that - is hopeless.  The earlier
version of it; CFX_GIFGD is not thread safe and has other problems but
has a much better help file to get you going and the basic syntax is the
same (CFX_IMAGE is much more versatile)


Gyrus wrote:
 
 I'm wanting to keep images uploaded within a certain size. I'm cursing
 CF a bit because I'm aware that PHP has image manipulation functions
 built-in (anyone know if there's similar stuff upcoming in CF Neo/MX?).
 
 Well, the only solutions I can find are CFX tags. Are there any
 recommendations for free tags that can resize images?
 
 Also, whether or not I use a CFX tag obviously depends on whether I
 *can* use it. We haven't settled on a host yet, so I've a more general
 question as well: how common/uncommon is it for shared hosting setups to
 allow CFX tags to be installed? Would I only be able to do this on a
 dedicated server?
 
 Any advice on this issue extremely welcome!
 
 - Gyrus
 
 
 - [EMAIL PROTECTED]
 work: http://www.tengai.co.uk
 play: http://www.norlonto.net
 - PGP key available
 
 
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Listing out departments (again)

2002-04-15 Thread Dave Watts

 I have to ask this one again .. I asked this question late 
 Friday and didn't get any answers that actually fit my 
 situation.  I will try to have this question make sense.

You might want to take a look at the Nested Tree Model. There's a good
implementation, with details, here:
http://www.codebits.com/ntm/

While it's a bit complex, it allows you to perform all kinds of nested set
operations.

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

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



cferror weirdness

2002-04-15 Thread Tony_Petruzzi

i need someone to give me the loaddown on how cferror looks for the
templates. here's the situation. i have a site the where i have a template
called settings.cfm that i put all of the settings for the site in. this
includes the cfapplication tag, a bunch of global variables, and the cferror
tags. now the reason i do this is because i use the application.cfm tag to
also include the header.cfm file, which is the header for that particular
section. This setup allows me to write the settings once and include them in
child directories while being able to change the header for each child
directory if i want. ok, enough with the setup, now onto the question. the
thing is, i usually make a blobal variable called request.serverroot which
is the root path of the website, usually this is set to /. so in my
settings.cfm, in the root directory of the website, i call the cferror tags.
the template path parameter of these tags, i set to
#request.serverroot#error.cfm. which equates to /error.cfm, which is
where the error.cfm is, in my root directory. the thing is when i include
the settings.cfm file in child directories and cause an error, i get a 404
error saying that it can't find the error.cfm template. yet if i change the
template path of the cferror tag to just error.cfm, the error page comes
up?!? so how does cferror look for the template? does it work the
application.cfm, where it will look up the directory structure for the
template. it's working now, i just would like some clearance on this. sorry
for the long post.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org

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



ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig

hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Hays, Duncan

We ran into this a couple of weeks ago. We would restart the server, this
thing would start up as a service and suck the life out of the machine. It
even started up 2 instances, the first got to about 200mb of ram before we
killed it. Then the second, which was at about 7mb, took off and started
eating up ram. We killed it, renamed the exe so that it would start up again
and everything has been fine since.

I don't know where this came from but we are running CF5.

Duncan Hays
Peace Corps

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 10:43 AM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources


hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul

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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Robert Everland

There are hotfixes for this. It's the management tools included in CF
Enterprise. Get the hotfixes, you'll be all good.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Hays, Duncan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 10:48 AM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


We ran into this a couple of weeks ago. We would restart the server, this
thing would start up as a service and suck the life out of the machine. It
even started up 2 instances, the first got to about 200mb of ram before we
killed it. Then the second, which was at about 7mb, took off and started
eating up ram. We killed it, renamed the exe so that it would start up again
and everything has been fine since.

I don't know where this came from but we are running CF5.

Duncan Hays
Peace Corps

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 10:43 AM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources


hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul


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



Re: survey trouble

2002-04-15 Thread Jeffry Houser

  I saw a bunch of responses, and I don't think I have much else to add 
except that one of the chapters of the Instant ColdFusion book discusses 
this. ( Yes, I wrote it, so that is self-promotion ) ..

  I believe that it goes something like this:

   Answers (AnswerID, Answer)

   Questions (QuestionID, Question)

   QuestionAnswers(QuestionID, AnswerID, total )

  When someone answers the question, with an answer, you just update the 
QuestionAnswers table.



At 09:03 AM 4/15/2002 -0400, you wrote:
I am having trouble creating a 'simple' survey with answers like the
following:

'Strongly Agree'
'Agree'
'Neutral'
'Disagree'
'Strongly Disagree'

I cannot conceptualize how to store and make sense of the answers without a
huge amount of code.  We do not care to record individual answers (but
will/can), but want to know how many people agree/disagree with each
question.  (There are 10 questions.)  All the questions have the same
possible answers.

Any help is greatly appreciated,

Craig Thomas
www.worldcupbicycles.com


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



Re: client cookies - strategy question

2002-04-15 Thread Richard Meredith-Hardy

Justin

Seems a bit complicated in that you seem to be effectively duplicating
the built in functionality of client variables.  I am not using session
variables on this [shared] server because the *?xx! thing is constantly
being restarted and you end up losing stuff.

From what you seem to be saying though, my scheme might be OK.

Justin Scott wrote:
 
  I have this site which is pointed at by several URL's ie www.aaa.com,
  www.bbb.com Etc.
 
  I want to have users log in only once in any of the sites and then be
  able to freely switch between sites in a logged-in state.  The
  application name is the same for all.
 
 Here's how I would do this...
 
 1. I use a two-cookie system for maintaining state, a member_id and a
 session_id.  When someone logs into one of the sites, give them the
 member_id cookies, generate a random session hash with CreateUUID(), put
 that in the database, then set the session_id cookie with that value.
 
 2. In your security code, check the cookies against the values in the
 database (I set a cache on this query of 2-3 minutes).  If no records are
 returned, or if the last_action value (below) is too out of date (15-20
 mins) then they are NOT logged in and need to be directed to login page.  If
 they ARE logged in, update the last_action column.
 
 3. In any links to your other sites, include the current session_id on the
 URL with a special variable name.  In the Application.cfm (or other global
 file) check for this value.  If present, check the database for a user with
 that ID and a recent last_action value.  If one is found, set the member_id
 and session_id cookies just as if they had logged in directly to that site.
 
 * You would not have to worry about someone copying a URL and getting access
 at a later date.  The chances of someone having the exact same session hash
 generated by CreateUUID() within your session timeout period is practically
 non-existent.
 
 * You won't need to worry about CF's session/client management.  If your
 application scales to the point where it needs to run on clustered servers,
 your authentication won't break.
 
 If you have any questions, feel free to mail me off-list.
 
 -Justin Scott, Lead Developer
  Sceiron Internet Services, Inc.
  http://www.sceiron.com
 
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Listing out departments (again)

2002-04-15 Thread Alex

you should have 3 tables
an owner table (owner and ownerID)
a sub object table (subobject and subobjectID)
a relationship table (ownwerID and subobjectID are complex primary key )



On Mon, 15 Apr 2002, Paul Giesenhagen wrote:

 I have to ask this one again .. I asked this question late Friday and didn't get any 
answers that actually fit my situation.  I will try to have this question make sense.
 
 I am trying to build an OUTPUT that would look like this:
 
 Fishing
 Fishing/Rods/Baitcast
 Fishing/Rods/Baitcast/Special Bait Cast Rods/...
 Fishing/Rods/Baitcast/Not so Special Rods/...
 Fishing/Rods/Spinning
 Fishing/Reels/BaitCast
 Fishing/Reels/Spinning
 Fishing/Line
 Camping
 Camping/Tents
 Camping/Stoves/Big Stoves
 Camping/Stoves/Little Stoves
 Camping/Sleeping Bags
 Marine/ ect...
 
 Ok as you can see, we have 3 main departments (actually more, but for example we 
will go with whats above), and multiple departments (unlimited depth) that are below 
each department.
 
 My table structure is this:
 ID = Identifying id
 OWNER = Parent
 SUB_OBJECT = Child
 (Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and 
SUB_OBJECT=BAITCAST)
 
 As you can see, parents can be children and children can become parents.  I am 
inserting NAMES instead of ID values that are in the actual table (makes it more 
readable for this message).  Each Owner/Sub_object is an ID Value that relates to 
another table called departments.  As you can see, sub_objects end up becoming OWNERs 
with sub_objects below them.  So parents can be children and children can become 
parents.
 
 Table Setup
 
 ID|OWNER| SUB_OBJECT
 1IndexFishing
 2IndexCamping
 3IndexMarine
 4Fishing  Rods
 5   Fishing  Reels
 6   Fishing  Line
 7RodsBaitcast
 8BaitcastSpecial Baitcast Rods
 9BiatcastNot so Special Rods
 10RodsSpinning 
 11ReelsBaitcast
 12ReelsSpinning
 13  CampingTents
 14  CampingStoves
 15  CampingSleeping Bags
 16  StovesBig Stoves
 17  StovesLittle Stoves
 18
 
 I know the INDEX value and each of my Index Sub_objects are my main catagories, and 
want wind down through all the departments and build a recursive list that starts 
with main catagory and build a catagory/sub_dept/sub_dept/sub_dept ect...
 
 I know this is alittle loong and I appologize .. but I am dumbfounded and keep 
looping myself into nowhere, trying to get the output as it is above.
 
 Anyhelp with the SQL and CF Syntax is greatly appreciated!
 
 At this point, I am not looking for performance :) just a solution!
 
 Comon' I know that there is a supermind that can help me!!
 
 Thank you
 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder

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



Re: cferror weirdness

2002-04-15 Thread Jeffry Houser

At 10:31 AM 4/15/2002 -0400, you wrote:
i need someone to give me the loaddown on how cferror looks for the
templates. here's the situation. i have a site the where i have a template
called settings.cfm that i put all of the settings for the site in. this
includes the cfapplication tag, a bunch of global variables, and the cferror
tags. now the reason i do this is because i use the application.cfm tag to
also include the header.cfm file, which is the header for that particular
section. This setup allows me to write the settings once and include them in
child directories while being able to change the header for each child
directory if i want.

  I see nothing wrong with that approach.


ok, enough with the setup, now onto the question. the
thing is, i usually make a blobal variable called request.serverroot which
is the root path of the website, usually this is set to /. so in my
settings.cfm, in the root directory of the website, i call the cferror tags.
the template path parameter of these tags, i set to
#request.serverroot#error.cfm. which equates to /error.cfm, which is
where the error.cfm is, in my root directory.

  : hmm:  As a point of reference, ColdFusion will not look at web 
mappings, just ColdFusion mappings.  My guess is that is your problem.
  In the ColdFusion administrator, do you have '/' pointing to your server 
root?

   What I like to do is set such a variable in a way relative to the root 
directory:
 Root directory:   /
 Subdirectory:   ../
 SubSubDirectory:  ../../

  Your application.cfm will be like this:

 set rootdirectory variable
 Include settings.cfm
 include header for files in this directory

  The next question is whether it is a good idea to map '/' to the 
directory root.  If you only have one application, or domain, on the 
server, then it probably won't be a big deal.  If you have more that might 
be confusing.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

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



Re: cferror weirdness

2002-04-15 Thread Richard Meredith-Hardy

CFINCLUDE always looks from where the including template is, not where
the base template is.  Therefore if you have a call to your error.cfm
from one of your child templates then likely the path in your CFINCLUDE
will need to be ../error.cfm

If you want to use paths always from your base template in CFINCLUDE's
then you need to set up a mapped path.

[EMAIL PROTECTED] wrote:
 
 i need someone to give me the loaddown on how cferror looks for the
 templates. here's the situation. i have a site the where i have a template
 called settings.cfm that i put all of the settings for the site in. this
 includes the cfapplication tag, a bunch of global variables, and the cferror
 tags. now the reason i do this is because i use the application.cfm tag to
 also include the header.cfm file, which is the header for that particular
 section. This setup allows me to write the settings once and include them in
 child directories while being able to change the header for each child
 directory if i want. ok, enough with the setup, now onto the question. the
 thing is, i usually make a blobal variable called request.serverroot which
 is the root path of the website, usually this is set to /. so in my
 settings.cfm, in the root directory of the website, i call the cferror tags.
 the template path parameter of these tags, i set to
 #request.serverroot#error.cfm. which equates to /error.cfm, which is
 where the error.cfm is, in my root directory. the thing is when i include
 the settings.cfm file in child directories and cause an error, i get a 404
 error saying that it can't find the error.cfm template. yet if i change the
 template path of the cferror tag to just error.cfm, the error page comes
 up?!? so how does cferror look for the template? does it work the
 application.cfm, where it will look up the directory structure for the
 template. it's working now, i just would like some clearance on this. sorry
 for the long post.
 
 Anthony Petruzzi
 Webmaster
 954-321-4703
 [EMAIL PROTECTED]
 http://www.sheriff.org
 
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: options for image resizing tags

2002-04-15 Thread cftalk

I have to recommend our tag ImageCR...
It's not free, but it is high quality.

http://efflare.com/products/cfx_imagecr

Also, a better than PHP image manipulation tag is in beta testing.

-- Monday, April 15, 2002, 7:33:33 AM, you wrote:

 I'm wanting to keep images uploaded within a certain size. I'm cursing
 CF a bit because I'm aware that PHP has image manipulation functions
 built-in (anyone know if there's similar stuff upcoming in CF Neo/MX?).

 Well, the only solutions I can find are CFX tags. Are there any
 recommendations for free tags that can resize images?

 Also, whether or not I use a CFX tag obviously depends on whether I
 *can* use it. We haven't settled on a host yet, so I've a more general
 question as well: how common/uncommon is it for shared hosting setups to
 allow CFX tags to be installed? Would I only be able to do this on a
 dedicated server?

 Any advice on this issue extremely welcome!

 - Gyrus

 
 - [EMAIL PROTECTED]
 work: http://www.tengai.co.uk
 play: http://www.norlonto.net
 - PGP key available
 

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



Re: Listing out departments (again)

2002-04-15 Thread Paul Giesenhagen

Hmm..  here is what I have:

department table
id | title | description .
(all departments go into here ..Fishing, Camping, Rods, Spinning ect..)

And

the table below from the original message

Why would I use the sub object table ..  So I would stick EVERY department
id in the OWNER table and EVERY department id in the SUB_OBJECT table.. and
then combine their ID's in the RELATIONSHIP TABLE?  Isn't it already doing
something similar by sticking the ID value from the DEPARMENTS table in the
relationship table?

I guess my question then would be why the owner and sub-object tables?  It
seems a bit redundant?

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



 you should have 3 tables
 an owner table (owner and ownerID)
 a sub object table (subobject and subobjectID)
 a relationship table (ownwerID and subobjectID are complex primary key )



 On Mon, 15 Apr 2002, Paul Giesenhagen wrote:

  I have to ask this one again .. I asked this question late Friday and
didn't get any answers that actually fit my situation.  I will try to have
this question make sense.
 
  I am trying to build an OUTPUT that would look like this:
 
  Fishing
  Fishing/Rods/Baitcast
  Fishing/Rods/Baitcast/Special Bait Cast Rods/...
  Fishing/Rods/Baitcast/Not so Special Rods/...
  Fishing/Rods/Spinning
  Fishing/Reels/BaitCast
  Fishing/Reels/Spinning
  Fishing/Line
  Camping
  Camping/Tents
  Camping/Stoves/Big Stoves
  Camping/Stoves/Little Stoves
  Camping/Sleeping Bags
  Marine/ ect...
 
  Ok as you can see, we have 3 main departments (actually more, but for
example we will go with whats above), and multiple departments (unlimited
depth) that are below each department.
 
  My table structure is this:
  ID = Identifying id
  OWNER = Parent
  SUB_OBJECT = Child
  (Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and
SUB_OBJECT=BAITCAST)
 
  As you can see, parents can be children and children can become parents.
I am inserting NAMES instead of ID values that are in the actual table
(makes it more readable for this message).  Each Owner/Sub_object is an ID
Value that relates to another table called departments.  As you can see,
sub_objects end up becoming OWNERs with sub_objects below them.  So parents
can be children and children can become parents.
 
  Table Setup
 
  ID|OWNER| SUB_OBJECT
  1IndexFishing
  2IndexCamping
  3IndexMarine
  4Fishing  Rods
  5   Fishing  Reels
  6   Fishing  Line
  7RodsBaitcast
  8BaitcastSpecial Baitcast Rods
  9BiatcastNot so Special Rods
  10RodsSpinning
  11ReelsBaitcast
  12ReelsSpinning
  13  CampingTents
  14  CampingStoves
  15  CampingSleeping Bags
  16  StovesBig Stoves
  17  StovesLittle Stoves
  18
 
  I know the INDEX value and each of my Index Sub_objects are my main
catagories, and want wind down through all the departments and build a
recursive list that starts with main catagory and build a
catagory/sub_dept/sub_dept/sub_dept ect...
 
  I know this is alittle loong and I appologize .. but I am dumbfounded
and keep looping myself into nowhere, trying to get the output as it is
above.
 
  Anyhelp with the SQL and CF Syntax is greatly appreciated!
 
  At this point, I am not looking for performance :) just a solution!
 
  Comon' I know that there is a supermind that can help me!!
 
  Thank you
  Paul Giesenhagen
  QuillDesign
  http://www.quilldesign.com
  SiteDirector v2.0 - Commerce Builder
 
 
 
 
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfset vs using cfscript

2002-04-15 Thread Clint Tredway

I have a question...

Lets say that I have about 10 variables being set locally on 20 or so cfm
pages..

How much faster is using cfscript over using cfset to set the values of
these local variables?

Clint Tredway


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



Re: cfset vs using cfscript

2002-04-15 Thread Critz

oi Clint!!

well  you could always do some tests, but i've heard rule o thumb is more than 3
cfscript is more efficient..


-- 
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion

Monday, April 15, 2002, 11:41:57 AM, you wrote:

CT I have a question...

CT Lets say that I have about 10 variables being set locally on 20 or so cfm
CT pages..

CT How much faster is using cfscript over using cfset to set the values of
CT these local variables?

CT Clint Tredway


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



Re: cfset vs using cfscript

2002-04-15 Thread Justin Scott

General rule of thumb is to set variables using cfscript if there are three
or more in a row.  I do not have exact statistics to back this up, but I
have found cfscript code to execute significantly faster than regular CFML.
It is also easier to read and follow, IMHO.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: Clint Tredway [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 11:41 AM
Subject: cfset vs using cfscript


 I have a question...

 Lets say that I have about 10 variables being set locally on 20 or so cfm
 pages..

 How much faster is using cfscript over using cfset to set the values of
 these local variables?

 Clint Tredway


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



Re: cfset vs using cfscript

2002-04-15 Thread Michael Dinowitz

a fraction of a second. How big a fraction is debatable. 

At 11:41 AM 4/15/02, you wrote:
I have a question...

Lets say that I have about 10 variables being set locally on 20 or so cfm
pages..

How much faster is using cfscript over using cfset to set the values of
these local variables?

Clint Tredway



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



cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Shawn McKee

While on this topic, how about efficiency with cfoutput?

It makes sense to me that this:

select name=fred
cfloop query=fredQ
option
value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
/cfloop
/select

is faster than this:

cfoutput
select name=fred
cfloop query=fredQ
option value=#val##valDesc#
/cfloop
/select
/cfouput

But what about these?

select name=fred
cfoutput query=fredQ
option value=#val##valDesc#
/cfoutput
/select

select name=fred
cfloop query=fredQ
option value=cfoutput#val##valDesc#/cfouput
/cfloop
/select

Shawn McKee
Manager, Web Development
NewsStand, Inc.
8620 Burnet Rd., Suite 100
Austin, TX 78757 USA
512-334-5100
Read newspapers and magazines from around the world in a whole new way.
NewsStand delivers them to your PC without paper and without delay!
Try: http://www.newsstand.com?NSEMC=EMNSI01



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



automatically submit form

2002-04-15 Thread Diana Nichols

I am generating a form to submit to a remote applicationand I need to
have the form submit automatically.

Here's the tricky partthis will be run as a scheduled event, so there
won't be a browser open to run JS.

Is there another way to have the form submit itself?

TIA!
D


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

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



Re: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Jochem van Dieten

Shawn McKee wrote:
 While on this topic, how about efficiency with cfoutput?
 
 It makes sense to me that this:
 
 select name=fred
   cfloop query=fredQ
   option
 value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
   /cfloop
 /select
 
 is faster than this:
 
 cfoutput
   select name=fred
   cfloop query=fredQ
   option value=#val##valDesc#
   /cfloop
   /select
 /cfouput

Please explain, because it doesn't make sense to me.


 But what about these?
 
 select name=fred
   cfoutput query=fredQ
   option value=#val##valDesc#
   /cfoutput
 /select
 
 select name=fred
   cfloop query=fredQ
   option value=cfoutput#val##valDesc#/cfouput
   /cfloop
 /select

GetTickCount() is your friend. Enlighten us :)

Jochem


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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Craig Dudley

It's the cut down jrun that's used for a few things including cfgraph
support, un-install cfgraph and see if it's still doing it. You can always
try installing it again later if t is, sometimes works.

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 3:43 PM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources

hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul

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



Re: cfset vs using cfscript

2002-04-15 Thread cf refactoring

I just optimized some templates which were written in
cf tag syntax by rewriting as cfscript. In my
experience, cfscript can be up to 2-3x as fast. But in
my opinion, the performance isn't worth rewriting
unless you're inside a loop. In my case, I rewrote all
the cfset statements inside a cfquery loop of 1000+
and achieved a whopping speed increase, but I didn't
bother with the tag statements outside.

In general, you'll get the most improvement for your
effort if you rewrite statements within loops.

--- Clint Tredway [EMAIL PROTECTED] wrote:
 I have a question...
 
 Lets say that I have about 10 variables being set
 locally on 20 or so cfm
 pages..
 
 How much faster is using cfscript over using cfset
 to set the values of
 these local variables?
 
 Clint Tredway


=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: automatically submit form

2002-04-15 Thread Douglas Brown

Boy I am dying to hear the replies on this. I would have to say impossible to
send form vars with no browser open. But then again, I have been wrong before
(several times ) :-D






Success is a journey, not a destination!!



Doug Brown
- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 8:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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

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



RE: Listing out departments (again)

2002-04-15 Thread Phillip Broussard

Paul,

I think you will want something like this. Dave Watts helped me with it
a long time ago.

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg06749.html

I can help you with it if you need but it is pretty sell spelled out.

Phillip


 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 15, 2002 9:08 AM
 To: CF-Talk
 Subject: Listing out departments (again)
 
 I have to ask this one again .. I asked this question late Friday and
 didn't get any answers that actually fit my situation.  I will try to
have
 this question make sense.
 
 I am trying to build an OUTPUT that would look like this:
 
 Fishing
 Fishing/Rods/Baitcast
 Fishing/Rods/Baitcast/Special Bait Cast Rods/...
 Fishing/Rods/Baitcast/Not so Special Rods/...
 Fishing/Rods/Spinning
 Fishing/Reels/BaitCast
 Fishing/Reels/Spinning
 Fishing/Line
 Camping
 Camping/Tents
 Camping/Stoves/Big Stoves
 Camping/Stoves/Little Stoves
 Camping/Sleeping Bags
 Marine/ ect...
 
 Ok as you can see, we have 3 main departments (actually more, but for
 example we will go with whats above), and multiple departments
(unlimited
 depth) that are below each department.
 
 My table structure is this:
 ID = Identifying id
 OWNER = Parent
 SUB_OBJECT = Child
 (Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and
 SUB_OBJECT=BAITCAST)
 
 As you can see, parents can be children and children can become
parents.
 I am inserting NAMES instead of ID values that are in the actual table
 (makes it more readable for this message).  Each Owner/Sub_object is
an ID
 Value that relates to another table called departments.  As you can
see,
 sub_objects end up becoming OWNERs with sub_objects below them.  So
 parents can be children and children can become parents.
 
 Table Setup
 
 ID|OWNER| SUB_OBJECT
 1IndexFishing
 2IndexCamping
 3IndexMarine
 4Fishing  Rods
 5   Fishing  Reels
 6   Fishing  Line
 7RodsBaitcast
 8BaitcastSpecial Baitcast Rods
 9BiatcastNot so Special Rods
 10RodsSpinning
 11ReelsBaitcast
 12ReelsSpinning
 13  CampingTents
 14  CampingStoves
 15  CampingSleeping Bags
 16  StovesBig Stoves
 17  StovesLittle Stoves
 18
 
 I know the INDEX value and each of my Index Sub_objects are my main
 catagories, and want wind down through all the departments and build a
 recursive list that starts with main catagory and build a
 catagory/sub_dept/sub_dept/sub_dept ect...
 
 I know this is alittle loong and I appologize .. but I am dumbfounded
and
 keep looping myself into nowhere, trying to get the output as it is
 above.
 
 Anyhelp with the SQL and CF Syntax is greatly appreciated!
 
 At this point, I am not looking for performance :) just a solution!
 
 Comon' I know that there is a supermind that can help me!!
 
 Thank you
 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder
 
 
 
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Listing out departments (again)

2002-04-15 Thread Alex

OK. I did not read your entire email. I assume you are trying to
recursively lookup items. As someone said oracle CONNECT BY can do this
otherwise you might need to to some nested queries. 

On Mon, 15 Apr 2002, Paul Giesenhagen wrote:

 Hmm..  here is what I have:
 
 department table
 id | title | description .
 (all departments go into here ..Fishing, Camping, Rods, Spinning ect..)
 
 And
 
 the table below from the original message
 
 Why would I use the sub object table ..  So I would stick EVERY department
 id in the OWNER table and EVERY department id in the SUB_OBJECT table.. and
 then combine their ID's in the RELATIONSHIP TABLE?  Isn't it already doing
 something similar by sticking the ID value from the DEPARMENTS table in the
 relationship table?
 
 I guess my question then would be why the owner and sub-object tables?  It
 seems a bit redundant?
 
 Paul Giesenhagen
 QuillDesign
 http://www.quilldesign.com
 SiteDirector v2.0 - Commerce Builder
 
 
 
  you should have 3 tables
  an owner table (owner and ownerID)
  a sub object table (subobject and subobjectID)
  a relationship table (ownwerID and subobjectID are complex primary key )
 
 
 
  On Mon, 15 Apr 2002, Paul Giesenhagen wrote:
 
   I have to ask this one again .. I asked this question late Friday and
 didn't get any answers that actually fit my situation.  I will try to have
 this question make sense.
  
   I am trying to build an OUTPUT that would look like this:
  
   Fishing
   Fishing/Rods/Baitcast
   Fishing/Rods/Baitcast/Special Bait Cast Rods/...
   Fishing/Rods/Baitcast/Not so Special Rods/...
   Fishing/Rods/Spinning
   Fishing/Reels/BaitCast
   Fishing/Reels/Spinning
   Fishing/Line
   Camping
   Camping/Tents
   Camping/Stoves/Big Stoves
   Camping/Stoves/Little Stoves
   Camping/Sleeping Bags
   Marine/ ect...
  
   Ok as you can see, we have 3 main departments (actually more, but for
 example we will go with whats above), and multiple departments (unlimited
 depth) that are below each department.
  
   My table structure is this:
   ID = Identifying id
   OWNER = Parent
   SUB_OBJECT = Child
   (Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and
 SUB_OBJECT=BAITCAST)
  
   As you can see, parents can be children and children can become parents.
 I am inserting NAMES instead of ID values that are in the actual table
 (makes it more readable for this message).  Each Owner/Sub_object is an ID
 Value that relates to another table called departments.  As you can see,
 sub_objects end up becoming OWNERs with sub_objects below them.  So parents
 can be children and children can become parents.
  
   Table Setup
  
   ID|OWNER| SUB_OBJECT
   1IndexFishing
   2IndexCamping
   3IndexMarine
   4Fishing  Rods
   5   Fishing  Reels
   6   Fishing  Line
   7RodsBaitcast
   8BaitcastSpecial Baitcast Rods
   9BiatcastNot so Special Rods
   10RodsSpinning
   11ReelsBaitcast
   12ReelsSpinning
   13  CampingTents
   14  CampingStoves
   15  CampingSleeping Bags
   16  StovesBig Stoves
   17  StovesLittle Stoves
   18
  
   I know the INDEX value and each of my Index Sub_objects are my main
 catagories, and want wind down through all the departments and build a
 recursive list that starts with main catagory and build a
 catagory/sub_dept/sub_dept/sub_dept ect...
  
   I know this is alittle loong and I appologize .. but I am dumbfounded
 and keep looping myself into nowhere, trying to get the output as it is
 above.
  
   Anyhelp with the SQL and CF Syntax is greatly appreciated!
  
   At this point, I am not looking for performance :) just a solution!
  
   Comon' I know that there is a supermind that can help me!!
  
   Thank you
   Paul Giesenhagen
   QuillDesign
   http://www.quilldesign.com
   SiteDirector v2.0 - Commerce Builder
  
  
  
  
  
 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfset vs using cfscript

2002-04-15 Thread Alex

I have read that cfscript is faster when you have a large block. 
I assume you do not have access to CF right now otherwise you would have
tested this yourself. Anyway, when I tested it I got the same execution
time back.


On Mon, 15 Apr 2002, Clint Tredway wrote:

 I have a question...
 
 Lets say that I have about 10 variables being set locally on 20 or so cfm
 pages..
 
 How much faster is using cfscript over using cfset to set the values of
 these local variables?
 
 Clint Tredway
 
 
 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cfset vs using cfscript

2002-04-15 Thread Craig Thomas

it will be faster...how much?  well, that would depend on your system.  You
could always set up some tests...

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:42 AM
To: CF-Talk
Subject: cfset vs using cfscript


I have a question...

Lets say that I have about 10 variables being set locally on 20 or so cfm
pages..

How much faster is using cfscript over using cfset to set the values of
these local variables?

Clint Tredway



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



CF5 on XP Home

2002-04-15 Thread Yves Arsenault

Last wednesday there was a post on the list about CF5 on XP Home.
Since then I've purchased a new PC and I'll be using for dev. purposes.

I've tried to install CF5 with Apache 2.0, but I got some errors after I had
followed the instructions from the macromedia site
One part of these instructions was non-existent in the new Apache 2.0 (add
module list).
And Apache 1.3 has issues with XP home (from what I've heard).

I remember someone had mentioned sambar.
Would anyone know where to get the configuration instructions(if there are
some)?

I suppose I should have gotten XP pro!

Thanks (in advance),

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823



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



Re: automatically submit form

2002-04-15 Thread Stephen Moretti

Diana,

 I am generating a form to submit to a remote applicationand I need to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?


Have a look at CFHTTP.  With cfhttpparam this should do exactly what you
need.

Regards

Stephen


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



RE: automatically submit form

2002-04-15 Thread Craig Thomas

have the scheduled event run a template with body onLoad=

Craig

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:59 AM
To: CF-Talk
Subject: automatically submit form


I am generating a form to submit to a remote applicationand I need to
have the form submit automatically.

Here's the tricky partthis will be run as a scheduled event, so there
won't be a browser open to run JS.

Is there another way to have the form submit itself?

TIA!
D


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


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



Re: cfset vs using cfscript

2002-04-15 Thread Justin Scott

A fraction of a second on a major application that gets millions of hits a
day can make or break a system.  Remember that when you do the big jobs g.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 11:51 AM
Subject: Re: cfset vs using cfscript


 a fraction of a second. How big a fraction is debatable.

 At 11:41 AM 4/15/02, you wrote:
 I have a question...
 
 Lets say that I have about 10 variables being set locally on 20 or so cfm
 pages..
 
 How much faster is using cfscript over using cfset to set the values of
 these local variables?
 
 Clint Tredway
 
 
 
 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: automatically submit form

2002-04-15 Thread Matthew R. Small

Yep, I think you're wrong.  You can use cfhttp to do exactly this. And
no need for javascript either.

- Matt Small

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 12:06 PM
To: CF-Talk
Subject: Re: automatically submit form

Boy I am dying to hear the replies on this. I would have to say
impossible to
send form vars with no browser open. But then again, I have been wrong
before
(several times ) :-D






Success is a journey, not a destination!!



Doug Brown
- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 8:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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

 

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



Re: automatically submit form

2002-04-15 Thread Justin Scott

How about CFHTTP with a method=post?

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 11:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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

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



Re: automatically submit form

2002-04-15 Thread Jim McAtee

cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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

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



Re: Listing out departments (again)

2002-04-15 Thread Paul Giesenhagen

Phillip,

Thanks, interesting post, but the problem is I don't know how many levels
there will be .. there could be 1 or there could be 20 sub levels (gawd I
hope not, but it needs that flexibility).

Your example is a set 1/2/3 .

I may need to re-think the whole setup of the database since this seems to
be causing me trouble in this one area ...

Thanks!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



 Paul,

 I think you will want something like this. Dave Watts helped me with it
 a long time ago.

 http://www.mail-archive.com/cf-talk@houseoffusion.com/msg06749.html

 I can help you with it if you need but it is pretty sell spelled out.

 Phillip


  -Original Message-
  From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
  Sent: Monday, April 15, 2002 9:08 AM
  To: CF-Talk
  Subject: Listing out departments (again)
 
  I have to ask this one again .. I asked this question late Friday and
  didn't get any answers that actually fit my situation.  I will try to
 have
  this question make sense.
 
  I am trying to build an OUTPUT that would look like this:
 
  Fishing
  Fishing/Rods/Baitcast
  Fishing/Rods/Baitcast/Special Bait Cast Rods/...
  Fishing/Rods/Baitcast/Not so Special Rods/...
  Fishing/Rods/Spinning
  Fishing/Reels/BaitCast
  Fishing/Reels/Spinning
  Fishing/Line
  Camping
  Camping/Tents
  Camping/Stoves/Big Stoves
  Camping/Stoves/Little Stoves
  Camping/Sleeping Bags
  Marine/ ect...
 
  Ok as you can see, we have 3 main departments (actually more, but for
  example we will go with whats above), and multiple departments
 (unlimited
  depth) that are below each department.
 
  My table structure is this:
  ID = Identifying id
  OWNER = Parent
  SUB_OBJECT = Child
  (Example: Owner=FISHING and SUB_OBJECT=RODS ..then OWNER=RODS and
  SUB_OBJECT=BAITCAST)
 
  As you can see, parents can be children and children can become
 parents.
  I am inserting NAMES instead of ID values that are in the actual table
  (makes it more readable for this message).  Each Owner/Sub_object is
 an ID
  Value that relates to another table called departments.  As you can
 see,
  sub_objects end up becoming OWNERs with sub_objects below them.  So
  parents can be children and children can become parents.
 
  Table Setup
 
  ID|OWNER| SUB_OBJECT
  1IndexFishing
  2IndexCamping
  3IndexMarine
  4Fishing  Rods
  5   Fishing  Reels
  6   Fishing  Line
  7RodsBaitcast
  8BaitcastSpecial Baitcast Rods
  9BiatcastNot so Special Rods
  10RodsSpinning
  11ReelsBaitcast
  12ReelsSpinning
  13  CampingTents
  14  CampingStoves
  15  CampingSleeping Bags
  16  StovesBig Stoves
  17  StovesLittle Stoves
  18
 
  I know the INDEX value and each of my Index Sub_objects are my main
  catagories, and want wind down through all the departments and build a
  recursive list that starts with main catagory and build a
  catagory/sub_dept/sub_dept/sub_dept ect...
 
  I know this is alittle loong and I appologize .. but I am dumbfounded
 and
  keep looping myself into nowhere, trying to get the output as it is
  above.
 
  Anyhelp with the SQL and CF Syntax is greatly appreciated!
 
  At this point, I am not looking for performance :) just a solution!
 
  Comon' I know that there is a supermind that can help me!!
 
  Thank you
  Paul Giesenhagen
  QuillDesign
  http://www.quilldesign.com
  SiteDirector v2.0 - Commerce Builder
 
 
 
 
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: automatically submit form

2002-04-15 Thread Craig Thomas

boy...I feel stupid.

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:13 PM
To: CF-Talk
Subject: RE: automatically submit form


have the scheduled event run a template with body onLoad=

Craig

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:59 AM
To: CF-Talk
Subject: automatically submit form


I am generating a form to submit to a remote applicationand I need to
have the form submit automatically.

Here's the tricky partthis will be run as a scheduled event, so there
won't be a browser open to run JS.

Is there another way to have the form submit itself?

TIA!
D


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



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



Re: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Jeffry Houser

At 10:55 AM 4/15/2002 -0500, you wrote:
While on this topic, how about efficiency with cfoutput?

It makes sense to me that this:

select name=fred
 cfloop query=fredQ
 option
value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
 /cfloop
/select

is faster than this:

cfoutput
 select name=fred
 cfloop query=fredQ
 option value=#val##valDesc#
 /cfloop
 /select
/cfouput

  Consider this..
   Every time that you use a ColdFusion tag, a C function is called.
   The second one has less ColdFusion tags, and therefore should run more 
efficiently.

  Two different people with two different 'intuitions' I would like to see 
numbers too.  ( wish I had time to do testing )


But what about these?

select name=fred
 cfoutput query=fredQ
 option value=#val##valDesc#
 /cfoutput
/select

select name=fred
 cfloop query=fredQ
 option value=cfoutput#val##valDesc#/cfouput
 /cfloop
/select

  In this case, my intuition would say that the first is quicker, based on 
the same Less CF Tag reasoning.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

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



Re: automatically submit form

2002-04-15 Thread Justin Scott

 have the scheduled event run a template with body onLoad=


You must have missed the part where he said...

...scheduled event, so there won't be a browser open to run JS

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


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



RE: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Venn, Matthew

RecordSet contained 1000 results...
Using Cfoutput to loop through query: 50 ms
Using Cfloop contained with cfoutput tags: 50 ms
Using Cfloop with cfoutput tag contained within the cfloop tags: 170 ms

Matt

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:01 AM
To: CF-Talk
Subject: Re: cfoutput - was RE: cfset vs using cfscript


Shawn McKee wrote:
 While on this topic, how about efficiency with cfoutput?
 
 It makes sense to me that this:
 
 select name=fred
   cfloop query=fredQ
   option
 value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
   /cfloop
 /select
 
 is faster than this:
 
 cfoutput
   select name=fred
   cfloop query=fredQ
   option value=#val##valDesc#
   /cfloop
   /select
 /cfouput

Please explain, because it doesn't make sense to me.


 But what about these?
 
 select name=fred
   cfoutput query=fredQ
   option value=#val##valDesc#
   /cfoutput
 /select
 
 select name=fred
   cfloop query=fredQ
   option value=cfoutput#val##valDesc#/cfouput
   /cfloop
 /select

GetTickCount() is your friend. Enlighten us :)

Jochem



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



RE: CF5 on XP Home

2002-04-15 Thread Steve Green

re: XP (home) has issues with Apache 1.3 ?

What 'issues' .. I've had none .. But i'd like to hear of some

SteG.

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: 15 April 2002 17:10
To: CF-Talk
Subject: CF5 on XP Home


Last wednesday there was a post on the list about CF5 on XP Home.
Since then I've purchased a new PC and I'll be using for dev. purposes.

I've tried to install CF5 with Apache 2.0, but I got some errors after I had
followed the instructions from the macromedia site
One part of these instructions was non-existent in the new Apache 2.0 (add
module list).
And Apache 1.3 has issues with XP home (from what I've heard).

I remember someone had mentioned sambar.
Would anyone know where to get the configuration instructions(if there are
some)?

I suppose I should have gotten XP pro!

Thanks (in advance),

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823




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



Re: automatically submit form

2002-04-15 Thread Ernie Pena

Dianna,

I agree with Stephen, I have an application that submits to two different
applications based on cfhttp and the cfhttppram, however I do not have it
scheduled. However that should not be an issue creating schedule to kick off
a cfm page is the easiest part of your problem.


Ernie Pena
Sr. CF Developer
M.D. ANDERSON


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 10:58 AM
Subject: automatically submit form


I am generating a form to submit to a remote applicationand I need to
have the form submit automatically.

Here's the tricky partthis will be run as a scheduled event, so there
won't be a browser open to run JS.

Is there another way to have the form submit itself?

TIA!
D


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


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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig

that's just it.
I NEED to be able to use cfgraph...

i have tried every thing to get cfgraph to run on my local laptop
win2k, cf5 ent, latest java...

i really want to work on my laptop, before pushing it to the production
server

Robert There are hot fixes for this. It's the management tools included in
CF
Enterprise. Get the hot fixes, you'll be all good.

where are these hot fixes?

-paul



-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:52 AM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


It's the cut down jrun that's used for a few things including cfgraph
support, un-install cfgraph and see if it's still doing it. You can always
try installing it again later if t is, sometimes works.

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 3:43 PM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources

hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul


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



RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols

Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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


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



RE: cferror weirdness

2002-04-15 Thread Tony_Petruzzi

so if the error.cfm is in the root and the settings.cfm is in the root. Then
that means that the CFERROR tag's template path should just be
template=error.cfm, correct?

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:17 AM
To: CF-Talk
Subject: Re: cferror weirdness


CFINCLUDE always looks from where the including template is, not where
the base template is.  Therefore if you have a call to your error.cfm
from one of your child templates then likely the path in your CFINCLUDE
will need to be ../error.cfm

If you want to use paths always from your base template in CFINCLUDE's
then you need to set up a mapped path.

[EMAIL PROTECTED] wrote:
 
 i need someone to give me the loaddown on how cferror looks for the
 templates. here's the situation. i have a site the where i have a template
 called settings.cfm that i put all of the settings for the site in. this
 includes the cfapplication tag, a bunch of global variables, and the
cferror
 tags. now the reason i do this is because i use the application.cfm tag to
 also include the header.cfm file, which is the header for that particular
 section. This setup allows me to write the settings once and include them
in
 child directories while being able to change the header for each child
 directory if i want. ok, enough with the setup, now onto the question. the
 thing is, i usually make a blobal variable called request.serverroot which
 is the root path of the website, usually this is set to /. so in my
 settings.cfm, in the root directory of the website, i call the cferror
tags.
 the template path parameter of these tags, i set to
 #request.serverroot#error.cfm. which equates to /error.cfm, which is
 where the error.cfm is, in my root directory. the thing is when i include
 the settings.cfm file in child directories and cause an error, i get a 404
 error saying that it can't find the error.cfm template. yet if i change
the
 template path of the cferror tag to just error.cfm, the error page comes
 up?!? so how does cferror look for the template? does it work the
 application.cfm, where it will look up the directory structure for the
 template. it's working now, i just would like some clearance on this.
sorry
 for the long post.
 
 Anthony Petruzzi
 Webmaster
 954-321-4703
 [EMAIL PROTECTED]
 http://www.sheriff.org
 
 

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



RE: automatically submit form - Sorry

2002-04-15 Thread Matthew R. Small

Can you explain that a little bit more in detail?  Does that mean that
you aren't allowed to use cfhttp because of the client's security, that
you use a server where it is not allowed, or because somebody said that
you couldn't?

- Matt Small

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry

Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that
idea
so long ago I'd forgotten about it - but the client has
challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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



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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig

i have done this hot fix
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22280Method=Full

but still no luck on getting cfgraph to work


-paul



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:31 PM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


that's just it.
I NEED to be able to use cfgraph...

i have tried every thing to get cfgraph to run on my local laptop
win2k, cf5 ent, latest java...

i really want to work on my laptop, before pushing it to the production
server

Robert There are hot fixes for this. It's the management tools included in
CF
Enterprise. Get the hot fixes, you'll be all good.

where are these hot fixes?

-paul



-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:52 AM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


It's the cut down jrun that's used for a few things including cfgraph
support, un-install cfgraph and see if it's still doing it. You can always
try installing it again later if t is, sometimes works.

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 15, 2002 3:43 PM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources

hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul



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



RE: automatically submit form - Sorry

2002-04-15 Thread Tony_Petruzzi

can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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



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



RE: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Shawn McKee

My testing agrees with this.  This flies in the face of what Chris Cortes
says in his book Optimizing ColdFusion 5.  Page 404.  Or am I reading it
wrong?  Does anyone else have any beefs with this book?

Jochem - thanks for pointing me at GetTickCount().

Shawn

-Original Message-
From: Venn, Matthew [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:20 AM
To: CF-Talk
Subject: RE: cfoutput - was RE: cfset vs using cfscript


RecordSet contained 1000 results...
Using Cfoutput to loop through query: 50 ms
Using Cfloop contained with cfoutput tags: 50 ms
Using Cfloop with cfoutput tag contained within the cfloop tags: 170 ms

Matt

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:01 AM
To: CF-Talk
Subject: Re: cfoutput - was RE: cfset vs using cfscript


Shawn McKee wrote:
 While on this topic, how about efficiency with cfoutput?
 
 It makes sense to me that this:
 
 select name=fred
   cfloop query=fredQ
   option
 value=cfoutput#val#/cfouputcfoutput#valDesc#/cfouput
   /cfloop
 /select
 
 is faster than this:
 
 cfoutput
   select name=fred
   cfloop query=fredQ
   option value=#val##valDesc#
   /cfloop
   /select
 /cfouput

Please explain, because it doesn't make sense to me.


 But what about these?
 
 select name=fred
   cfoutput query=fredQ
   option value=#val##valDesc#
   /cfoutput
 /select
 
 select name=fred
   cfloop query=fredQ
   option value=cfoutput#val##valDesc#/cfouput
   /cfloop
 /select

GetTickCount() is your friend. Enlighten us :)

Jochem




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



Re: automatically submit form - Sorry

2002-04-15 Thread Justin Scott

 Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that
idea
 so long ago I'd forgotten about it - but the client has challenge/response
 security on their serverso it doesn't work.

It looks like you have two options in this case:

1. Get the client to change the app to use SSL (does not have to be a cert
from a public CA if this is a private URL, just use openSSL or something to
generate a private one) and basic HTTP authentication that CFHTTP can
handle.

2. Have someone write you a custom CFX tag that performs the same duties to
CFHTTP but supports the type of authentication your client is using.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


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



RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols

CFHTTP doesn't work with challenge/response security. (At least the
ducumentation says it doesn't, and I haven't been able to figure out how to
make it do so.)

When posting as a form, this action works to satisfy the security:
https://username:[EMAIL PROTECTED]/script.asp. Unfortunately, not so with
CFHTTP. (Nor does using the username and password parameters of the tag.)


D


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


-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:48 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Can you explain that a little bit more in detail?  Does that mean that
you aren't allowed to use cfhttp because of the client's security, that
you use a server where it is not allowed, or because somebody said that
you couldn't?

- Matt Small

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry

Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that
idea
so long ago I'd forgotten about it - but the client has
challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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




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



RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols

Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:38 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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




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



RE: CF5 on XP Home

2002-04-15 Thread Yves Arsenault

I have tried to find the information that I had read up on, but I can't seem
to find it.
I'll keep looking a little, and if I find what I had read, I will post it.

If it works fine for you, I'll try to install it tonight.
2.0 didn't seem to work for me, I've got 1.3 (I downloaded).

Do you run CF5 Server on it as well?
I'll certainly try it.

Thanks for your reply!

Yves

-Original Message-
From: Steve Green [mailto:[EMAIL PROTECTED]]
Sent: April 15, 2002 1:26 PM
To: CF-Talk
Subject: RE: CF5 on XP Home


re: XP (home) has issues with Apache 1.3 ?

What 'issues' .. I've had none .. But i'd like to hear of some

SteG.

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: 15 April 2002 17:10
To: CF-Talk
Subject: CF5 on XP Home


Last wednesday there was a post on the list about CF5 on XP Home.
Since then I've purchased a new PC and I'll be using for dev. purposes.

I've tried to install CF5 with Apache 2.0, but I got some errors after I had
followed the instructions from the macromedia site
One part of these instructions was non-existent in the new Apache 2.0 (add
module list).
And Apache 1.3 has issues with XP home (from what I've heard).

I remember someone had mentioned sambar.
Would anyone know where to get the configuration instructions(if there are
some)?

I suppose I should have gotten XP pro!

Thanks (in advance),

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823





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



RE: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Jeffry Houser

At 11:46 AM 4/15/2002 -0500, you wrote:
My testing agrees with this.  This flies in the face of what Chris Cortes
says in his book Optimizing ColdFusion 5.  Page 404.  Or am I reading it
wrong?  Does anyone else have any beefs with this book?

  That was the only thing I read in the book that made me think That ain't 
right.  Otherwise, there is a lot of great info in the book.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

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



Re: cfoutput - was RE: cfset vs using cfscript

2002-04-15 Thread Justin Scott

 My testing agrees with this.  This flies in the face of what Chris Cortes
 says in his book Optimizing ColdFusion 5.  Page 404.  Or am I reading it
 wrong?  Does anyone else have any beefs with this book?

The book is referring to it being more efficient to wrap cfoutput tags
around individual variables instead of entire paragraphs that contain one or
two variables (or a populated form where the field values contain CF
variables, etc).  What he's saying is true in most circumstances.

The example you're talking about is by design, inefficient.  Of course using
a cfoutput tag within a loop that could be done with a cfoutput query=
will be slower.  Perhaps that is why Allaire chose to give cfoutput that
functionality?

As for the book itself, I did not find it particularly interesting, but it
could be very useful for someone just getting into CF.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


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



RE: automatically submit form - Sorry

2002-04-15 Thread Tony_Petruzzi

i can't exactly remember where i heard it (could of been here) but i think
as of iis4.0, there isn't a url character limit. this also could be the same
for apache. can someone clarify this?

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:53 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:38 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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





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



Re: cferror weirdness

2002-04-15 Thread Richard Meredith-Hardy

if they are in the same directory, yes.

[EMAIL PROTECTED] wrote:
 
 so if the error.cfm is in the root and the settings.cfm is in the root. Then
 that means that the CFERROR tag's template path should just be
 template=error.cfm, correct?
 
 Anthony Petruzzi
 Webmaster
 954-321-4703
 [EMAIL PROTECTED]
 http://www.sheriff.org
 
 -Original Message-
 From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 15, 2002 11:17 AM
 To: CF-Talk
 Subject: Re: cferror weirdness
 
 CFINCLUDE always looks from where the including template is, not where
 the base template is.  Therefore if you have a call to your error.cfm
 from one of your child templates then likely the path in your CFINCLUDE
 will need to be ../error.cfm
 
 If you want to use paths always from your base template in CFINCLUDE's
 then you need to set up a mapped path.
 
 [EMAIL PROTECTED] wrote:
 
  i need someone to give me the loaddown on how cferror looks for the
  templates. here's the situation. i have a site the where i have a template
  called settings.cfm that i put all of the settings for the site in. this
  includes the cfapplication tag, a bunch of global variables, and the
 cferror
  tags. now the reason i do this is because i use the application.cfm tag to
  also include the header.cfm file, which is the header for that particular
  section. This setup allows me to write the settings once and include them
 in
  child directories while being able to change the header for each child
  directory if i want. ok, enough with the setup, now onto the question. the
  thing is, i usually make a blobal variable called request.serverroot which
  is the root path of the website, usually this is set to /. so in my
  settings.cfm, in the root directory of the website, i call the cferror
 tags.
  the template path parameter of these tags, i set to
  #request.serverroot#error.cfm. which equates to /error.cfm, which is
  where the error.cfm is, in my root directory. the thing is when i include
  the settings.cfm file in child directories and cause an error, i get a 404
  error saying that it can't find the error.cfm template. yet if i change
 the
  template path of the cferror tag to just error.cfm, the error page comes
  up?!? so how does cferror look for the template? does it work the
  application.cfm, where it will look up the directory structure for the
  template. it's working now, i just would like some clearance on this.
 sorry
  for the long post.
 
  Anthony Petruzzi
  Webmaster
  954-321-4703
  [EMAIL PROTECTED]
  http://www.sheriff.org
 
 
 
 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: automatically submit form - Sorry

2002-04-15 Thread Craig Thomas

If there is no browser present, what determines the URL size limit? is there
one?

CT

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:53 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:38 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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





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



RE: automatically submit form

2002-04-15 Thread Craig Thomas

She

You must have missed the part where he said...

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:19 PM
To: CF-Talk
Subject: Re: automatically submit form


 have the scheduled event run a template with body onLoad=


You must have missed the part where he said...

...scheduled event, so there won't be a browser open to run JS

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com



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



RE: automatically submit form - Sorry

2002-04-15 Thread Tony_Petruzzi

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q260694

Found it! you can write a loop program real quick to see how many characters
all the values and variables would take. then you could request them to
increase their request buffer value to accomidate you. Good luck with that
though :P.

http://groups.google.com/groups?q=url+size+limit+iishl=enselm=XkiilP6wBHA.
2152%40cpmsftngxa09rnum=1


Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:53 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:38 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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





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



Re: automatically submit form

2002-04-15 Thread Alex

script onserver or something like that to get the javascript serverside

On Mon, 15 Apr 2002, Diana Nichols wrote:

 I am generating a form to submit to a remote applicationand I need to
 have the form submit automatically.
 
 Here's the tricky partthis will be run as a scheduled event, so there
 won't be a browser open to run JS.
 
 Is there another way to have the form submit itself?
 
 TIA!
 D
 
 
 Diana Nichols
 Webmistress
 http://www.lavenderthreads.com
 770.434.7374
 
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: automatically submit form

2002-04-15 Thread Alex

RUNAT=Server

On Mon, 15 Apr 2002, Justin Scott wrote:

 How about CFHTTP with a method=post?
 
 -Justin Scott, Lead Developer
  Sceiron Internet Services, Inc.
  http://www.sceiron.com
 
 
 - Original Message -
 From: Diana Nichols [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, April 15, 2002 11:58 AM
 Subject: automatically submit form
 
 
  I am generating a form to submit to a remote applicationand I need to
  have the form submit automatically.
 
  Here's the tricky partthis will be run as a scheduled event, so there
  won't be a browser open to run JS.
 
  Is there another way to have the form submit itself?
 
  TIA!
  D
 
  
  Diana Nichols
  Webmistress
  http://www.lavenderthreads.com
  770.434.7374
 
  
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: automatically submit form

2002-04-15 Thread Justin Scott

 You must have missed the part where he said...

 She

DOH!  Sorry about that.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


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



Null Values in MSSQL

2002-04-15 Thread Graham Pearson

Group:

This is the first time that I have to test for a NULL Value in MSSQL to 
retrieve a record set. However, at my present knowledge level, I am unable 
to retrieve this record set. Anyone have pointers on how I can do this?



---
Graham Pearson, System Administrator / Certified Webmaster
Northern Indiana Educational Services Center
Http://support.niesc.k12.in.us  Email: [EMAIL PROTECTED]

Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148


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



Re: Null Values in MSSQL

2002-04-15 Thread Paul Giesenhagen

NULL is not   check for NULL

Hope this helps

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



 Group:

 This is the first time that I have to test for a NULL Value in MSSQL to
 retrieve a record set. However, at my present knowledge level, I am unable
 to retrieve this record set. Anyone have pointers on how I can do this?



 --
-
 Graham Pearson, System Administrator / Certified Webmaster
 Northern Indiana Educational Services Center
 Http://support.niesc.k12.in.us  Email: [EMAIL PROTECTED]

 Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148
 --
--

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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Craig Thomas

is the ColdFusion Graphing Server running?

are the CF OEM versions of Jrun and Generator installed ?

CT

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:42 PM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


i have done this hot fix
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22280Method=Full

but still no luck on getting cfgraph to work


-paul



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:31 PM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


that's just it.
I NEED to be able to use cfgraph...

i have tried every thing to get cfgraph to run on my local laptop
win2k, cf5 ent, latest java...

i really want to work on my laptop, before pushing it to the production
server

Robert There are hot fixes for this. It's the management tools included in
CF
Enterprise. Get the hot fixes, you'll be all good.

where are these hot fixes?

-paul



-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:52 AM
To: CF-Talk
Subject: RE: ntConsoleJava 98% of sys resources


It's the cut down jrun that's used for a few things including cfgraph
support, un-install cfgraph and see if it's still doing it. You can always
try installing it again later if t is, sometimes works.

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 3:43 PM
To: CF-Talk
Subject: ntConsoleJava 98% of sys resources

hey guys

my laptop is crapping out
running win2k

is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin

it is taking up way to much resources.
if not what is it a part of?

thanks

-paul




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



Re: Null Values in MSSQL

2002-04-15 Thread Douglas Brown

Depends on what you want. If you are wanting all records where the value is not
NULL

Just do

selectwhatever
from  table
wherewhatever IS NOT NULL



Success is a journey, not a destination!!



Doug Brown
- Original Message -
From: Graham Pearson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 10:40 AM
Subject: Null Values in MSSQL


 Group:

 This is the first time that I have to test for a NULL Value in MSSQL to
 retrieve a record set. However, at my present knowledge level, I am unable
 to retrieve this record set. Anyone have pointers on how I can do this?



 --
-
 Graham Pearson, System Administrator / Certified Webmaster
 Northern Indiana Educational Services Center
 Http://support.niesc.k12.in.us  Email: [EMAIL PROTECTED]

 Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148
 --
--

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



RE: Null Values in MSSQL

2002-04-15 Thread Rob Baxter

you weren't too specific but try something like:

select ... where ColA is null

/rob

-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 1:41 PM
To: CF-Talk
Subject: Null Values in MSSQL


Group:

This is the first time that I have to test for a NULL Value in MSSQL to
retrieve a record set. However, at my present knowledge level, I am unable
to retrieve this record set. Anyone have pointers on how I can do this?




---
Graham Pearson, System Administrator / Certified Webmaster
Northern Indiana Educational Services Center
Http://support.niesc.k12.in.us  Email: [EMAIL PROTECTED]

Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148




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



RE: automatically submit form

2002-04-15 Thread Diana Nichols

No problem...I just assumed a typo :)
D


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


-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 1:33 PM
To: CF-Talk
Subject: Re: automatically submit form


 You must have missed the part where he said...

 She

DOH!  Sorry about that.

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com



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



RE: automatically submit form

2002-04-15 Thread Diana Nichols

??


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


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:57 PM
To: CF-Talk
Subject: Re: automatically submit form


RUNAT=Server

On Mon, 15 Apr 2002, Justin Scott wrote:

 How about CFHTTP with a method=post?

 -Justin Scott, Lead Developer
  Sceiron Internet Services, Inc.
  http://www.sceiron.com


 - Original Message -
 From: Diana Nichols [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, April 15, 2002 11:58 AM
 Subject: automatically submit form


  I am generating a form to submit to a remote applicationand I need
to
  have the form submit automatically.
 
  Here's the tricky partthis will be run as a scheduled event, so
there
  won't be a browser open to run JS.
 
  Is there another way to have the form submit itself?
 
  TIA!
  D
 
  
  Diana Nichols
  Webmistress
  http://www.lavenderthreads.com
  770.434.7374
 
 


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



RE: Null Values in MSSQL

2002-04-15 Thread Neil Clark - =TMM=

Are you checking for null re: a value? 

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



RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols

ahathat has possibilitiesif I can get my client to agree. (They
historically take 3-5 working days to make any decision above the level of
correcting spelling.)

Thanks, I'll look into this!

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 1:05 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


http://support.microsoft.com/default.aspx?scid=kb;EN-US;q260694

Found it! you can write a loop program real quick to see how many characters
all the values and variables would take. then you could request them to
increase their request buffer value to accomidate you. Good luck with that
though :P.

http://groups.google.com/groups?q=url+size+limit+iishl=enselm=XkiilP6wBHA.
2152%40cpmsftngxa09rnum=1


Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:53 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.

D


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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:38 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


can the form accept a get method. if so then what you can do is just pass
all the value through the url. without cfhttp, i don't think you can do a
post method.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:37 PM
To: CF-Talk
Subject: RE: automatically submit form - Sorry


Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.

D



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


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:12 PM
To: CF-Talk
Subject: Re: automatically submit form


cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post

  cfhttpparam ...

/cfhttp

Jim


- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form


 I am generating a form to submit to a remote applicationand I need
to
 have the form submit automatically.

 Here's the tricky partthis will be run as a scheduled event, so
there
 won't be a browser open to run JS.

 Is there another way to have the form submit itself?

 TIA!
 D

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






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



Re: Null Values in MSSQL

2002-04-15 Thread Alex

where field IS NULL

On Mon, 15 Apr 2002, Graham Pearson wrote:

 Group:
 
 This is the first time that I have to test for a NULL Value in MSSQL to 
 retrieve a record set. However, at my present knowledge level, I am unable 
 to retrieve this record set. Anyone have pointers on how I can do this?
 
 
 
 
---
 Graham Pearson, System Administrator / Certified Webmaster
 Northern Indiana Educational Services Center
 Http://support.niesc.k12.in.us  Email: [EMAIL PROTECTED]
 
 Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148
 

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



RE: CF5 on XP Home

2002-04-15 Thread Yves Arsenault

Here is what I had found earlier about XP and Apache.

http://www.apache.org/dist/httpd/binaries/win32/#xpbug

Thanks,

Yves

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: April 15, 2002 2:03 PM
To: CF-Talk
Subject: RE: CF5 on XP Home


I have tried to find the information that I had read up on, but I can't seem
to find it.
I'll keep looking a little, and if I find what I had read, I will post it.

If it works fine for you, I'll try to install it tonight.
2.0 didn't seem to work for me, I've got 1.3 (I downloaded).

Do you run CF5 Server on it as well?
I'll certainly try it.

Thanks for your reply!

Yves

-Original Message-
From: Steve Green [mailto:[EMAIL PROTECTED]]
Sent: April 15, 2002 1:26 PM
To: CF-Talk
Subject: RE: CF5 on XP Home


re: XP (home) has issues with Apache 1.3 ?

What 'issues' .. I've had none .. But i'd like to hear of some

SteG.

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: 15 April 2002 17:10
To: CF-Talk
Subject: CF5 on XP Home


Last wednesday there was a post on the list about CF5 on XP Home.
Since then I've purchased a new PC and I'll be using for dev. purposes.

I've tried to install CF5 with Apache 2.0, but I got some errors after I had
followed the instructions from the macromedia site
One part of these instructions was non-existent in the new Apache 2.0 (add
module list).
And Apache 1.3 has issues with XP home (from what I've heard).

I remember someone had mentioned sambar.
Would anyone know where to get the configuration instructions(if there are
some)?

I suppose I should have gotten XP pro!

Thanks (in advance),

Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823






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



RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Dave Watts

 There are hot fixes for this. It's the management tools 
 included in CF Enterprise. Get the hot fixes, you'll be 
 all good.
 
 where are these hot fixes?

http://www.macromedia.com/v1/handlers/index.cfm?ID=20371Method=Full

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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF5 on XP Home

2002-04-15 Thread Dave Watts

 Here is what I had found earlier about XP and Apache.
 
 http://www.apache.org/dist/httpd/binaries/win32/#xpbug

That looks like a pretty rare problem, and if it happens to you, get the
listed hotfix from MS.

 2.0 didn't seem to work for me, I've got 1.3 (I downloaded).

CF doesn't support Apache 2.0. It works very nicely on 1.3.x, though.

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

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



  1   2   >