COncurrent Users

[Nick Betts]

Hi,
Is there a way to test system performance based on differenet number of 
concurrent users?  Are there any guidelines from macroMedia on the 
maximum number of concurrent users CF server supports? I realise this is 
quite ballpacrk but basically need to presnet some figures to our 
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the cfquery


cfloop query=theQuery

   cfquery name=blah datasource=blah
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   /cfquery

/cfloop



At 05:15 PM 2/6/02 -0800, you wrote:
dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)

Thanks

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation


 Oh nevermind, your not looping over the columns of the query (long 
day
 as well)

 I think you need a semi-colon at the end of your query, since that 
will
 put multiple inserts in one cfquery.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Steve Oliver [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:02 PM
 To: CF-Talk
 Subject: RE: looping inside cfquery - brain on vacation


 Hmmm, well if one of your fields is numeric, then that wouldn't work,
 since numeric values don't need 's around them,  you could use the
 isNumeric() function for that.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:01 PM
 To: CF-Talk
 Subject: looping inside cfquery - brain on vacation


 OK..long day..CF whining about syntax...help!

 The situation:

 CF doesn't like my syntax for this bit of looping over a query to 
insert
 muliple records.  It's
 complaining about the final ) closing bracket for the insert.  Any
 ideas?  I'm sure I've done it
 beforejust saw it posted the other week too...geesh talk about
 timing ;-)

 cfquery name=blah datasource=blah
   cfloop query=theQuery
 INSERT INTO Table
 (
 Field
 )
VALUES
 (
 '#FieldValue#'
 )
   cfloop
 /cfquery

 TIA

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com



 


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

Weird whitespace issue ...

[Allan Pichler]

I have this minor issue with my code . for some reason i have 239 lines
of whitespace in the beginning of the html page, and i don't know how to get
rid of it

Basically my cf page looks like this

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html

...
...
/html

but prior to the !DOCTYPE ...

i get 239 lines of whitespace 


Can anyone help ???



Allan Pichler // Senior Software Developer // [EMAIL PROTECTED]

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Weird whitespace issue ...

[John McCosker]

instead of 

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

try

cfsilent
!--- Doing all my queries and user authentication here ---
/cfsilent

J

John McCosker (Senior Web Applications Developer)
Andronics Data Global Communications
Derry, Co.Londonderry
N.Ireland
Bt48 OLY

Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:39 AM
To: CF-Talk
Subject: Weird whitespace issue ...


I have this minor issue with my code . for some reason i have 239 
lines
of whitespace in the beginning of the html page, and i don't know how 
to get
rid of it

Basically my cf page looks like this

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
...
..
..
/html

but prior to the !DOCTYPE ...

i get 239 lines of whitespace 


Can anyone help ???



Allan Pichler // Senior Software Developer // [EMAIL PROTECTED]


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Linkpoint CF tag problem

[Joseph DeVore]

Pardeep,

I can help you with this, hit me up off list.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:37 PM
To: CF-Talk
Subject: Re: Linkpoint CF tag problem


Hi, does anyone here have any experience with the Linkpoint Cold Fusion tag.

Their documentation is really poor and I can't figure out:

1. Precisely how you define the total amount for a transaction that does not
have any shipping or tax info involved.

2. Which field provides the result of the transaction and

3. The variable codes of the transaction result, i.e. 0 = declined, 1 =
approved, 2 = customer sucks, etc, etc

Again, the documentation doesn't clarify any of these points and their
online staff aren't able to help out so far. Thanks in advance if anyone has
an idea on this.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weird whitespace issue ...

[Allan Pichler]

ok ... now i have played with it, and it's getting weirder by the 
minute...

my cf template is now down to the following

CFSILENT
CFSET test = 1
/CFSILENT
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
CFABORT

and the output still has 232 lines of whitespace in it 

What can be wrong ???

-Allan

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 7. februar 2002 10:36
To: CF-Talk
Subject: RE: Weird whitespace issue ...


instead of 

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

try

cfsilent
!--- Doing all my queries and user authentication here ---
/cfsilent

J

John McCosker (Senior Web Applications Developer)
Andronics Data Global Communications
Derry, Co.Londonderry
N.Ireland
Bt48 OLY

Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:39 AM
To: CF-Talk
Subject: Weird whitespace issue ...


I have this minor issue with my code . for some reason i have 239 
lines
of whitespace in the beginning of the html page, and i don't know how 
to get
rid of it

Basically my cf page looks like this

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
..
.
.
/html

but prior to the !DOCTYPE ...

i get 239 lines of whitespace 


Can anyone help ???



Allan Pichler // Senior Software Developer // [EMAIL PROTECTED]



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weird whitespace issue ...

[Jochem van Dieten]

Allan Pichler wrote:

 I have this minor issue with my code . for some reason i have 239 lines
 of whitespace in the beginning of the html page, and i don't know how to get
 rid of it
 
 Basically my cf page looks like this


Which page? Application.cfm?

Jochem
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weird whitespace issue ...

[Allan Pichler]

OF COURSE 

I'M STUPID!!

i forgot to put the CFSILENT in the application.cfm as well

Thanks for the help!

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 7. februar 2002 11:04
To: CF-Talk
Subject: Re: Weird whitespace issue ...


Allan Pichler wrote:

 I have this minor issue with my code . for some reason i have 239
lines
 of whitespace in the beginning of the html page, and i don't know how 
to
get
 rid of it
 
 Basically my cf page looks like this


Which page? Application.cfm?

Jochem

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weird whitespace issue ...

[John McCosker]

Check your application.cfm or appGlobals.cfm, is that wraped in 
cfsilent?
If you have got includes check them as well!

J

John McCosker (Senior Web Applications Developer)
Andronics Data Global Communications
Derry, Co.Londonderry
N.Ireland
Bt48 OLY

Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:10 AM
To: CF-Talk
Subject: RE: Weird whitespace issue ...


ok ... now i have played with it, and it's getting weirder by the 
minute...

my cf template is now down to the following

CFSILENT
CFSET test = 1
/CFSILENT
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
CFABORT

and the output still has 232 lines of whitespace in it 

What can be wrong ???

-Allan

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 7. februar 2002 10:36
To: CF-Talk
Subject: RE: Weird whitespace issue ...


instead of 

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

try

cfsilent
!--- Doing all my queries and user authentication here ---
/cfsilent

J

John McCosker (Senior Web Applications Developer)
Andronics Data Global Communications
Derry, Co.Londonderry
N.Ireland
Bt48 OLY

Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:39 AM
To: CF-Talk
Subject: Weird whitespace issue ...


I have this minor issue with my code . for some reason i have 239 
lines
of whitespace in the beginning of the html page, and i don't know how 
to get
rid of it

Basically my cf page looks like this

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
.
.
.
/html

but prior to the !DOCTYPE ...

i get 239 lines of whitespace 


Can anyone help ???



Allan Pichler // Senior Software Developer // [EMAIL PROTECTED]




__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weird whitespace issue ...

[Steve Green]

Hiya DC :)

Dont forget that your Application.cfm will also gen whitespace.

SteG.

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 10:10
To: CF-Talk
Subject: RE: Weird whitespace issue ...


ok ... now i have played with it, and it's getting weirder by the 
minute...

my cf template is now down to the following

CFSILENT
CFSET test = 1
/CFSILENT
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
CFABORT

and the output still has 232 lines of whitespace in it 

What can be wrong ???

-Allan

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 7. februar 2002 10:36
To: CF-Talk
Subject: RE: Weird whitespace issue ...


instead of 

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

try

cfsilent
!--- Doing all my queries and user authentication here ---
/cfsilent

J

John McCosker (Senior Web Applications Developer)
Andronics Data Global Communications
Derry, Co.Londonderry
N.Ireland
Bt48 OLY

Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:39 AM
To: CF-Talk
Subject: Weird whitespace issue ...


I have this minor issue with my code . for some reason i have 239 
lines
of whitespace in the beginning of the html page, and i don't know how 
to get
rid of it

Basically my cf page looks like this

CFSETTING enablecfoutputonly=Yes
CFPROCESSINGDIRECTIVE suppresswhitespace=Yes

!--- Doing all my queries and user authentication here ---

/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Help required on CF Performance....

[Nick Betts]

Hi,
Is there a way to test system performance based on differenet number of 
concurrent users?  Are there any guidelines from macroMedia on the 
maximum number of concurrent users CF server supports? I realise this is 

quite ballpacrk but basically need to presnet some figures to our 
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the cfquery


cfloop query=theQuery

   cfquery name=blah datasource=blah
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   /cfquery

/cfloop



At 05:15 PM 2/6/02 -0800, you wrote:
dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)

Thanks

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation


 Oh nevermind, your not looping over the columns of the query (long 
day
 as well)

 I think you need a semi-colon at the end of your query, since that 
will
 put multiple inserts in one cfquery.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Steve Oliver [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:02 PM
 To: CF-Talk
 Subject: RE: looping inside cfquery - brain on vacation


 Hmmm, well if one of your fields is numeric, then that wouldn't work,
 since numeric values don't need 's around them,  you could use the
 isNumeric() function for that.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:01 PM
 To: CF-Talk
 Subject: looping inside cfquery - brain on vacation


 OK..long day..CF whining about syntax...help!

 The situation:

 CF doesn't like my syntax for this bit of looping over a query to 
insert
 muliple records.  It's
 complaining about the final ) closing bracket for the insert.  Any
 ideas?  I'm sure I've done it
 beforejust saw it posted the other week too...geesh talk about
 timing ;-)

 cfquery name=blah datasource=blah
   cfloop query=theQuery
 INSERT INTO Table
 (
 Field
 )
VALUES
 (
 '#FieldValue#'
 )
   cfloop
 /cfquery

 TIA

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com



 



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Help required on CF Performance....

[John McCosker]

I'm not sure but I think this should be in the archives,
If I rember someone asked for the same sort of Stats not so long ago.

I didn't keep track of the thread I must admit.

Sorry not much help I know,

J

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:27 AM
To: CF-Talk
Subject: Help required on CF Performance


Hi,
Is there a way to test system performance based on differenet number of 
concurrent users?  Are there any guidelines from macroMedia on the 
maximum number of concurrent users CF server supports? I realise this is 

quite ballpacrk but basically need to presnet some figures to our 
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the cfquery


cfloop query=theQuery

   cfquery name=blah datasource=blah
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   /cfquery

/cfloop



At 05:15 PM 2/6/02 -0800, you wrote:
dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)

Thanks

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation


 Oh nevermind, your not looping over the columns of the query (long 
day
 as well)

 I think you need a semi-colon at the end of your query, since that 
will
 put multiple inserts in one cfquery.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Steve Oliver [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:02 PM
 To: CF-Talk
 Subject: RE: looping inside cfquery - brain on vacation


 Hmmm, well if one of your fields is numeric, then that wouldn't work,
 since numeric values don't need 's around them,  you could use the
 isNumeric() function for that.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:01 PM
 To: CF-Talk
 Subject: looping inside cfquery - brain on vacation


 OK..long day..CF whining about syntax...help!

 The situation:

 CF doesn't like my syntax for this bit of looping over a query to 
insert
 muliple records.  It's
 complaining about the final ) closing bracket for the insert.  Any
 ideas?  I'm sure I've done it
 beforejust saw it posted the other week too...geesh talk about
 timing ;-)

 cfquery name=blah datasource=blah
   cfloop query=theQuery
 INSERT INTO Table
 (
 Field
 )
VALUES
 (
 '#FieldValue#'
 )
   cfloop
 /cfquery

 TIA

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com



 




__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

CFMAIL missing messages

[Keane, John (WDS)]

I have two different websites that use CFMAIL to send order confirmations
and feedback messages to users and to internal mailboxes for reaction by
customer service personnel.

Ocassionally these messages are not getting through.  In a recent
application, 175 messages were sent in a 30 day timeframe.  An analysis of
these messages shows that only 130 were actually delivered.  All 175
messages were sent from the same cfm template page to the same email address
using the same code.

Our websites are hosted by a webhosting company.  Is this a common problem
with CFMAIL?  Can anybody give me any idea as to what could be causing these
messages to be lost?

Thanks for your assistance.

John Keane
EMAIL: [EMAIL PROTECTED] 

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Coldfusion UNIX Problem ???

[Ian Vaughan]

Hi Folks,

Just recently I have been receiving the following error message and the
Coldfusion server needs to be restarted to get rid of the error, have
anybody on the list come across this error ???  I am using CF 4.0

Error Occurred While Processing Request
  Error Diagnostic Information
  An error occurred while attempting to establish a connection to the
server.

  The most likely cause of this problem is that the server is not
currently running. Verify that the server is running and restart it if
necessary.

  Unix error number 146 occurred: Connection refused



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Vertical Text

[Ben Whalley]

We had a site which needed text running vertically (not letters stacked 
on
top of each other) and ended up loading strings into flash movies. May 
not
be useful for you in this case but easy to do.

Ben

 --
 From: Michael Corrigan
 Reply To: [EMAIL PROTECTED]
 Sent: Wednesday, February 6, 2002 10:25 PM
 To:   CF-Talk
 Subject:  Re: Vertical Text
 
 That's a good idea.  maybe if you play with it, you could get it to 
wrap 
 itself in a column by restricting the column width (i.e td width = 

 1...)
 
 Michael Corrigan
 Programmer
 Endora Digital Solutions
 1900 S. Highland Avenue, Suite 200
 Lombard, IL 60148
 630-627-5055 x-136
 630/627-5255 Fax
   - Original Message - 
   From: Lon Lentz 
   To: CF-Talk 
   Sent: Wednesday, February 06, 2002 4:28 PM
   Subject: RE: Vertical Text
 
 
 
 Can you use tables? You could create a single column of cells 
with a 
 
   letter in each.
 
-Original Message-
From: Jeff Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 4:00 PM
To: CF-Talk
Subject: Vertical Text



Any ideas on how I might display text vertically using either CF 
or 
   CSS?
Without stacking the letters using br's and without creating 
   graphics.
The text displayed vertically will be dynamic... it's looking 
like it might
not be possible...?  Thanks!
   
 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: looping inside cfquery - brain on vacation

[Gyrus]

 Maybe this?  Loop around the cfquery
 
 cfloop query=theQuery
cfquery name=blah datasource=blah
   INSERT INTO Table
   (Field)
   VALUES ('#theQuery.FieldValue#')
/cfquery
 /cfloop

Just out of interest, does anyone know the performance
issues between looping round inside cfquery to insert
multiple records, and looping round *outside*, running
the cfquery tag multiple times?

I didn't know you *could* stick one SQL statement
after another inside cfquery until seeing this thread.
Is this more efficient?

- Gyrus


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

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: looping inside cfquery - brain on vacation

[John McCosker]

Just tested it, 1000 INSERTS, SQL Server 7.0, both ways

2584 milliseconds as 

CFLOOP FROM=1 TO=1000 INDEX=i
CFQUERY NAME=q_addNewAttributeList
DATASOURCE=#request.DSN#
USERNAME=#x#
PASSWORD=#y#


INSERT INTO dbo.vehicleSelection

(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES  (13,
11,
'2',
'3',
30,
345678)


/CFQUERY
/CFLOOP

and 

991 milliseconds as 

CFQUERY NAME=q_addNewAttributeList
DATASOURCE=#request.DSN#
USERNAME=#x#
PASSWORD=#y#
CFLOOP FROM=1 TO=1000 INDEX=i

INSERT INTO dbo.vehicleSelection

(customerID,vehicleID,callsign,registration,cfid,cftoken)
VALUES  (13,
11,
'2',
'3',
30,
345678)
/CFLOOP

/CFQUERY

J





-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:42 PM
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


 Maybe this?  Loop around the cfquery
 
 cfloop query=theQuery
cfquery name=blah datasource=blah
   INSERT INTO Table
   (Field)
   VALUES ('#theQuery.FieldValue#')
/cfquery
 /cfloop

Just out of interest, does anyone know the performance
issues between looping round inside cfquery to insert
multiple records, and looping round *outside*, running
the cfquery tag multiple times?

I didn't know you *could* stick one SQL statement
after another inside cfquery until seeing this thread.
Is this more efficient?

- Gyrus


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


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: looping inside cfquery - brain on vacation

[Andrew Scott]

Those figures don't surprise me, because the cfquery is run once not
1000 times and is a valid query if separated with a ';'

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 8 February 2002 12:01 AM
To: CF-Talk
Subject: RE: looping inside cfquery - brain on vacation

Just tested it, 1000 INSERTS, SQL Server 7.0, both ways


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Need ideas for resource available calendar

[C. Hatton Humphrey]

Hey folks,

I'm working on a calendar module for our Project/Task/Time tracking system
and have hit a brain freeze... I know there's got to be code out there to
generate a monthly calendar, but either I'm not looking for the right thing
or I'm not seeing the right response.

Basically what I need to build is a monthly calendar view that shows bars
across dates that have task information in the date... sort of like what the
Outlook calendar looks like for multi-day events.

Right now we have something like this that works for a single week... they
want it expanded to offer month, quarter and day views.  Oh what fun!

Anyone have any suggestions of where to look?

TIA

Hatton
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

calendar

[Trusz, Andrew]

Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
designing a calendar. Since he contributes here maybe he'll have a few extra
tips for you.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: calendar

[C. Hatton Humphrey]

 Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
 designing a calendar. Since he contributes here maybe he'll have
 a few extra
 tips for you.

If only I had the time... I need a deliverable by this afternoon so it can
be demo'ed to a potential client tomorrow morning.

Hatton
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: calendar

[Thane Sherrington]

At 08:55 AM 02/07/2002 -0500, Trusz, Andrew wrote:
Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
designing a calendar. Since he contributes here maybe he'll have a few extra
tips for you.

Who publishes this?

T
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: calendar

[Trusz, Andrew]

Can he borrow it, Jeffry?

andy

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:02 AM
To: CF-Talk
Subject: RE: calendar


 Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter 
on
 designing a calendar. Since he contributes here maybe he'll have
 a few extra
 tips for you.

If only I had the time... I need a deliverable by this afternoon so it 
can
be demo'ed to a potential client tomorrow morning.

Hatton

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: calendar

[Trusz, Andrew]

Osborne. ISBN 0-07-213238-8; 2001

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:24 AM
To: CF-Talk
Subject: Re: calendar


At 08:55 AM 02/07/2002 -0500, Trusz, Andrew wrote:
Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
designing a calendar. Since he contributes here maybe he'll have a few
extra
tips for you.

Who publishes this?

T

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Vertical Text

[BEN MORRIS]

You could enclose each letter in a span and set the display to block.  
I'll admit it is needlessly complicated, you can just use br, but at 
least this way you could technicall have one word in one paragraph with 
the letters next to each other, and it would be a word in alternative 
browsers.

style
  .vert {display: block}
/style
pspan class=vertH/spanspan class=vertE/spanspan 
class=vertL/spanspan class=vertL/spanspan class=vertO
/span/p

 Michael Corrigan [EMAIL PROTECTED] 02/06/02 05:25PM 
That's a good idea.  maybe if you play with it, you could get it to 
wrap 
itself in a column by restricting the column width (i.e td width = 
1...)

Michael Corrigan
Programmer
Endora Digital Solutions
1900 S. Highland Avenue, Suite 200
Lombard, IL 60148
630-627-5055 x-136
630/627-5255 Fax
  - Original Message - 
  From: Lon Lentz 
  To: CF-Talk 
  Sent: Wednesday, February 06, 2002 4:28 PM
  Subject: RE: Vertical Text



Can you use tables? You could create a single column of cells with 
a 

  letter in each.

   -Original Message-
   From: Jeff Brown [mailto:[EMAIL PROTECTED]] 
   Sent: Wednesday, February 06, 2002 4:00 PM
   To: CF-Talk
   Subject: Vertical Text
   
   
   
   Any ideas on how I might display text vertically using either CF or 
  CSS?
   Without stacking the letters using br's and without creating 
  graphics.
   The text displayed vertically will be dynamic... it's looking 
   like it might
   not be possible...?  Thanks!
  

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CF-based DNS Manager software beta

[Christopher Olive]

does this work against 2000 or BIND servers?

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:39 PM
To: CF-Talk
Subject: CF-based DNS Manager software beta


Hello.  I mentioned a few days ago that we've been developing CF-based
DNS
management.  I am looking for a small group of beta program
participants.
If you are interested, read on, otherwise please disregard this message.

If you are interested:

Please fill out the following form:
http://www.brainbox.net/idnsm_beta/

(excuse the form, its not pretty...;)  )

Beta testers will be entitled to free 1.x software, and opt-in for
future
releases, and the likelihood of your feature requests being implemented
will
be much greater.

Thanks ya'll.

-Bill
brainbox

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

evil error

[Tyler Silcox]

I'm getting a very naughty error on a page that I have been running 25+ 
times a day for the last two months.  It's a page that is scheduled to 
run every hour and can also be initiated by a link.  It grabs all the 
user names and passwords from the db for some pop accounts, cfpops their 
mailboxes, and throws all their messages into our db, where they are 
filtered and marked as sorted.  All of a sudden I can't get past the 
first cfpop.  I keep getting the error below.  I even changed the amount 
of messages to download from 100 to 5 (while only hitting one mailbox), 
and it's still dying on me immediately after running without a hitch for 
2 months (while downloading up to 100 messages per mailbox).  I know 
y'all don't have all the specifics, but is this likely due to some other 
nasty server problem, or is it probably my page?  I've watched the 
server task manager as I've hit the page and the ColdFusion process 
never really rises above 15% or so in CPU time on the Processes tab, but 
it maxes out the CPU Usage History on the Performance tab.  In my cf 
logs, I get this error: 

Unknown error threshold reached. Restarting service.  

And then, this is the error I get returned to me on the page I'm trying 
to hit:
Error Diagnostic Information
Request canceled or ignored by serverServer busy or unable to fulfill 
request. The server is unable to fulfill your request due to extremely 
high traffic or an unexpected internal error. Please attempt your 
request again (if you are repeatedly unsuccessful you should notify the 
site administrator). (Location Code: 26)

Everything is still running pretty smoothly around here, except for our 
java-based cfx_activmail tag hasn't been completing it's duties.  I'm 
wondering if the jvm could be churning itself inside out, and affecting 
cfpop?  I'm running out of ideas...

What are my options here?  Reinstall the server, set up a Java mail 
popper, just go home and watch some oprah and pretend this never 
happened?

Thanks again for any help y'all can provide-

Tyler
email | [EMAIL PROTECTED]

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CF-based DNS Manager software beta

[Rick Eidson]

Can't get to the site. I have been talking with some others about 
building a
webbased DNS control panel to handle hosting and Colo clients. I would 
like
to see this.

Rick

-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 8:37 AM
To: CF-Talk
Subject: RE: CF-based DNS Manager software beta


does this work against 2000 or BIND servers?

christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:39 PM
To: CF-Talk
Subject: CF-based DNS Manager software beta


Hello.  I mentioned a few days ago that we've been developing CF-based
DNS
management.  I am looking for a small group of beta program
participants.
If you are interested, read on, otherwise please disregard this 
message.

If you are interested:

Please fill out the following form:
http://www.brainbox.net/idnsm_beta/

(excuse the form, its not pretty...;)  )

Beta testers will be entitled to free 1.x software, and opt-in for
future
releases, and the likelihood of your feature requests being implemented
will
be much greater.

Thanks ya'll.

-Bill
brainbox


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CF-based DNS Manager software beta

[Cantrell, Adam]

Can't get to the site.

That means he's probably testing the beta - ;



 -Original Message-
 From: Rick Eidson [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 8:44 AM
 To: CF-Talk
 Subject: RE: CF-based DNS Manager software beta
 
 
 Can't get to the site. I have been talking with some others about 
 building a
 webbased DNS control panel to handle hosting and Colo 
 clients. I would 
 like
 to see this.
 
 Rick
 
 -Original Message-
 From: Christopher Olive [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 8:37 AM
 To: CF-Talk
 Subject: RE: CF-based DNS Manager software beta
 
 
 does this work against 2000 or BIND servers?
 
 christopher olive, cto, vp of web development
 atnet solutions, inc.
 410.931.4092
 http://www.atnetsolutions.com
 
 
 -Original Message-
 From: Bill Davidson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 11:39 PM
 To: CF-Talk
 Subject: CF-based DNS Manager software beta
 
 
 Hello.  I mentioned a few days ago that we've been developing CF-based
 DNS
 management.  I am looking for a small group of beta program
 participants.
 If you are interested, read on, otherwise please disregard this 
 message.
 
 If you are interested:
 
 Please fill out the following form:
 http://www.brainbox.net/idnsm_beta/
 
 (excuse the form, its not pretty...;)  )
 
 Beta testers will be entitled to free 1.x software, and opt-in for
 future
 releases, and the likelihood of your feature requests being 
 implemented
 will
 be much greater.
 
 Thanks ya'll.
 
 -Bill
 brainbox
 
 
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

CF and Machine Names on Domain

[Tangorre, Michael T.]

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??

Thanks,
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: calendar

[Jeffry Houser]

  ( Thanks for the support Andrew )

  The code / database for the chapter in question is located here: 
http://www.instantcoldfusion.com/files/Chapter15icf.zip ( I just got them 
all up on the site this past week )

  However, without the chapter to read behind you... trying to decompile it
 
by this afternoon may be counter productive.


At 09:01 AM 02/07/2002 -0500, you wrote:
  Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
  designing a calendar. Since he contributes here maybe he'll have
  a few extra
  tips for you.

If only I had the time... I need a deliverable by this afternoon so it can
be demo'ed to a potential client tomorrow morning.

Hatton

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: calendar

[C. Hatton Humphrey]

Thanks for all the help... I found a snippet on the DevEx that got me
pointed in the right direction... brain hadn't fully started (only 3 cups of
coffe when I posted the message).  I think I know what direction I need to
move in.

Again, Thanks!

Hatton


 -Original Message-
 From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 10:21 AM
 To: CF-Talk
 Subject: RE: calendar


   ( Thanks for the support Andrew )

   The code / database for the chapter in question is located here:
 http://www.instantcoldfusion.com/files/Chapter15icf.zip ( I just got them
 all up on the site this past week )

   However, without the chapter to read behind you... trying to
 decompile it

 by this afternoon may be counter productive.


 At 09:01 AM 02/07/2002 -0500, you wrote:
   Get a copy of Jeffry Houser's Instant Cold Fusion 5. Nice chapter on
   designing a calendar. Since he contributes here maybe he'll have
   a few extra
   tips for you.
 
 If only I had the time... I need a deliverable by this afternoon
 so it can
 be demo'ed to a potential client tomorrow morning.
 
 Hatton
 
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Help required on CF Performance....

[Deanna Schneider]

The answer was www.opensta.org. You can set up a script to run with multiple
virtual users and see how performance degrades (or doesn't) with additional
users.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CF-based DNS Manager software beta

[James Curran]

Are you building your own DNS server too or are you just building the CF to
integrate with Windows 2k's built in DNS?

- j

-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:39 PM
To: CF-Talk
Subject: CF-based DNS Manager software beta


Hello.  I mentioned a few days ago that we've been developing CF-based DNS
management.  I am looking for a small group of beta program participants.
If you are interested, read on, otherwise please disregard this message.

If you are interested:

Please fill out the following form:
http://www.brainbox.net/idnsm_beta/

(excuse the form, its not pretty...;)  )

Beta testers will be entitled to free 1.x software, and opt-in for future
releases, and the likelihood of your feature requests being implemented will
be much greater.

Thanks ya'll.

-Bill
brainbox

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

CFABORT vs CFEXIT in CFCATCH TAG

[mark kecko]

Hello,

Whats the best way to stop the execution of a page after a error has been
caught using CFCATCH.  Can I put a CFABORT or CFEXIT tag within the CFCATCH?
Thanks in advance for any advice.

Mark Kecko
Technology Director
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309



-Original Message-
From: James Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:39 AM
To: CF-Talk
Subject: RE: CF-based DNS Manager software beta


Are you building your own DNS server too or are you just building the CF to
integrate with Windows 2k's built in DNS?

- j

-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:39 PM
To: CF-Talk
Subject: CF-based DNS Manager software beta


Hello.  I mentioned a few days ago that we've been developing CF-based DNS
management.  I am looking for a small group of beta program participants.
If you are interested, read on, otherwise please disregard this message.

If you are interested:

Please fill out the following form:
http://www.brainbox.net/idnsm_beta/

(excuse the form, its not pretty...;)  )

Beta testers will be entitled to free 1.x software, and opt-in for future
releases, and the likelihood of your feature requests being implemented will
be much greater.

Thanks ya'll.

-Bill
brainbox


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Earl, George]

Sorry for the length of this message. I'm frustrated.

I finally have time to upgrade my HomeSite from 4.5.2 to 5.0 and I'll follow
that with CF Studio 5.0 and UltraDev 4.0 (don't ask) and right at the top of
the release notes I find:

If you uninstall HomeSite 4.5.2 after having installed HomeSite 5, you must
reinstall HomeSite 5.

and:

JRun Studio 3.0.1 may be installed on the same computer as ColdFusion Studio
5 and/or HomeSite 5. The preferred sequence of installation is to install
JRun 3.0.1 and then ColdFusion Studio 5 and/or HomeSite 5. But, if you do
install JRun Studio 3.0.1 after installing ColdFusion Studio 5 and/or
HomeSite 5, you must reinstall ColdFusion Studio 5 and/or HomeSite 5. 

and:

If you uninstall HomeSite or ColdFusion Studio when you have more than one
version installed on the same computer, do not select to delete the shared
files during the uninstallation. For example, when HomeSite 4.5.2 and
HomeSite 5 are installed on the same computer and you uninstall HomeSite 5,
dialogs will appear during the uninstallation asking to delete shared files.
In those dialogs, you must select No (the default is Yes). If you do
inadvertently delete the files, you will need to reinstall. It is important
that earlier versions of HomeSite or ColdFusion Studio are installed before
later versions. So, you would reinstall HomeSite or ColdFusion Studio 4.5.2
first and then HomeSite or ColdFusion Studio 5. [29480] 

So,

1. I want HomeSite 5 to detect and bring in the settings I have with
HomeSite 4.5.2 and then I want to uninstall 4.5.2 but if I do that I then
have to reinstall 5 but my 4.5.2 will be gone, along with all it's settings,
so I won't be able to migrate over my settings again? Does this mean that to
migrate my settings I have to leave 4.5.2 on my PC after I install 5?
Forever? Same thing with CF Studio 4.5.2 and 5.0?

2. I don't want to install JRun Studio 3.0.1 (or JRun 3.0.1, I'm confused
about which one they mean, studio or the app server or both?). At least not
now. But I might want to later. If I do it later then I will have to
reinstall both HomeSite 5 and CF Studio 5 and I'll lose my settings again?

3. Does the shared files paragraph really mean that if I ever uninstall
HomeSite 5.0/CF Studio 5.0 and I want to reinstall them I first have to
reinstall versions 4.5.2 or make sure they are still on my PC? Are versions
4.5.2/5.0 of HomeSite/Studio forever joined at the hip if I want to retain
my settings?

I'm starting to think it makes sense just to uninstall the older versions
and manually reconfigure the new versions with my old settings.

What has everyone else done?

Thanks.

George
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFABORT vs CFEXIT in CFCATCH TAG

[Mark A. Kruger - CFG]

Yes you can...

-Original Message-
From: mark kecko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 7:58 AM
To: CF-Talk
Subject: CFABORT vs CFEXIT in CFCATCH TAG


Hello,

Whats the best way to stop the execution of a page after a error has been
caught using CFCATCH.  Can I put a CFABORT or CFEXIT tag within the CFCATCH?
Thanks in advance for any advice.

Mark Kecko
Technology Director
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309



-Original Message-
From: James Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:39 AM
To: CF-Talk
Subject: RE: CF-based DNS Manager software beta


Are you building your own DNS server too or are you just building the CF to
integrate with Windows 2k's built in DNS?

- j

-Original Message-
From: Bill Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:39 PM
To: CF-Talk
Subject: CF-based DNS Manager software beta


Hello.  I mentioned a few days ago that we've been developing CF-based DNS
management.  I am looking for a small group of beta program participants.
If you are interested, read on, otherwise please disregard this message.

If you are interested:

Please fill out the following form:
http://www.brainbox.net/idnsm_beta/

(excuse the form, its not pretty...;)  )

Beta testers will be entitled to free 1.x software, and opt-in for future
releases, and the likelihood of your feature requests being implemented will
be much greater.

Thanks ya'll.

-Bill
brainbox



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Oracle Error

[Debbie McDaniel]

Hi everyone,
I keep getting these weird errors with Oracle 8i that of course are being
blamed on ColdFusion. Here goes.
Our webserver sits in the DMZ and our database server is  inside the
firewall. All traffic going from the webserver goes through the firewall to
talk to the database.
I seem to be able to access the database through coldfusion 90% of the time,
but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to
connect to destination error, both of which result in massive errors in the
application and the eventual rebooting of the machine.
I am thinking it may be a network issue, but because coldfusion is new to
this company they want to blame it. If I log in with sql+ (an oracle client)
I can access the datasource w/o trouble, although cf can't even verify the
datasource. This usually happens after several moderate hits to the
datasource.
We are running CF 4.5.2 with all the appropriate patches applied on a Compaq
Windows 2000 machine with all the appropriate service packs applied to
Win2K. Our database is Oracle 8i - anyone have some suggestions? 
Greatly appreciated! 
Debbie M.
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

Cold Fusion and Networks

[Tangorre, Michael T.]

Sorry for the double post..I wasn't sure if the subject was descriptive
enough.  :-)

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFMAIL missing messages

[James Curran]

Did you try examining the unsent messages in c:\CFUSION\MAIL\UNDELIVR?

Compare those with the mail log in Cfadministrator.. Usually there are some
smtp restictions at play here, such as malformed email addys or relay
restrictions.  I usually get around this by running SMTP server on the
windows machine running CF and allowing relay only from that IP...

- j

jim.curran
technical.director
nylon.technology
six.west.fourteenth.street
new.york.ny.10011
212.691.1134
[EMAIL PROTECTED]


-Original Message-
From: Keane, John (WDS) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 6:23 AM
To: CF-Talk
Subject: CFMAIL missing messages


I have two different websites that use CFMAIL to send order confirmations
and feedback messages to users and to internal mailboxes for reaction by
customer service personnel.

Ocassionally these messages are not getting through.  In a recent
application, 175 messages were sent in a 30 day timeframe.  An analysis of
these messages shows that only 130 were actually delivered.  All 175
messages were sent from the same cfm template page to the same email address
using the same code.

Our websites are hosted by a webhosting company.  Is this a common problem
with CFMAIL?  Can anybody give me any idea as to what could be causing these
messages to be lost?

Thanks for your assistance.

John Keane
EMAIL: [EMAIL PROTECTED]


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFABORT vs CFEXIT in CFCATCH TAG

[Pascal Peters]

If you want to stop executing the page, use cfabort. If you are in a CT 
and want to stop executing the CT but continue the page, use cfexit. It 
doesn't matter that you use it in a CFCATCH, it will work anywhere

-Original Message-
From: mark kecko [mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 februari 2002 16:58
To: CF-Talk
Subject: CFABORT vs CFEXIT in CFCATCH TAG


Hello,

Whats the best way to stop the execution of a page after a error has 
been
caught using CFCATCH.  Can I put a CFABORT or CFEXIT tag within the 
CFCATCH?
Thanks in advance for any advice.

Mark Kecko
Technology Director
MediaPost Communications
[EMAIL PROTECTED]
http://www.mediapost.com
(203)222-0330 ext309

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Mark A. Kruger - CFG]

George,

I had to laugh at your email - I love installation instructions hehe.
What do the rest of us do?  Pop in the CD and click Next  next ... next
... next then we wonder what went wrong. In any case, I'd be interested
to know what Homesite gives you that CF studio does not?  I was under the
impression that Homesite was merely a scaled down version of CF Studio
(oriented to HTML only and not CF). Am I wrong?

Mark

-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 7:54 AM
To: CF-Talk
Subject: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC


Sorry for the length of this message. I'm frustrated.

I finally have time to upgrade my HomeSite from 4.5.2 to 5.0 and I'll follow
that with CF Studio 5.0 and UltraDev 4.0 (don't ask) and right at the top of
the release notes I find:

If you uninstall HomeSite 4.5.2 after having installed HomeSite 5, you must
reinstall HomeSite 5.

and:

JRun Studio 3.0.1 may be installed on the same computer as ColdFusion Studio
5 and/or HomeSite 5. The preferred sequence of installation is to install
JRun 3.0.1 and then ColdFusion Studio 5 and/or HomeSite 5. But, if you do
install JRun Studio 3.0.1 after installing ColdFusion Studio 5 and/or
HomeSite 5, you must reinstall ColdFusion Studio 5 and/or HomeSite 5.

and:

If you uninstall HomeSite or ColdFusion Studio when you have more than one
version installed on the same computer, do not select to delete the shared
files during the uninstallation. For example, when HomeSite 4.5.2 and
HomeSite 5 are installed on the same computer and you uninstall HomeSite 5,
dialogs will appear during the uninstallation asking to delete shared files.
In those dialogs, you must select No (the default is Yes). If you do
inadvertently delete the files, you will need to reinstall. It is important
that earlier versions of HomeSite or ColdFusion Studio are installed before
later versions. So, you would reinstall HomeSite or ColdFusion Studio 4.5.2
first and then HomeSite or ColdFusion Studio 5. [29480]

So,

1. I want HomeSite 5 to detect and bring in the settings I have with
HomeSite 4.5.2 and then I want to uninstall 4.5.2 but if I do that I then
have to reinstall 5 but my 4.5.2 will be gone, along with all it's settings,
so I won't be able to migrate over my settings again? Does this mean that to
migrate my settings I have to leave 4.5.2 on my PC after I install 5?
Forever? Same thing with CF Studio 4.5.2 and 5.0?

2. I don't want to install JRun Studio 3.0.1 (or JRun 3.0.1, I'm confused
about which one they mean, studio or the app server or both?). At least not
now. But I might want to later. If I do it later then I will have to
reinstall both HomeSite 5 and CF Studio 5 and I'll lose my settings again?

3. Does the shared files paragraph really mean that if I ever uninstall
HomeSite 5.0/CF Studio 5.0 and I want to reinstall them I first have to
reinstall versions 4.5.2 or make sure they are still on my PC? Are versions
4.5.2/5.0 of HomeSite/Studio forever joined at the hip if I want to retain
my settings?

I'm starting to think it makes sense just to uninstall the older versions
and manually reconfigure the new versions with my old settings.

What has everyone else done?

Thanks.

George

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFABORT vs CFEXIT in CFCATCH TAG

[Benjamin S. Rogers]

 Whats the best way to stop the execution of a page after a error 
 has been caught using CFCATCH.  Can I put a CFABORT or CFEXIT 
 tag within the CFCATCH? Thanks in advance for any advice.

It depends on what you want to do. If you want to end the request
unconditionally, then I recommend using CFABORT. If, however, you are
within an included file or a custom tag and you merely want to exit that
template but continue on with the rest of the request, then use the
CFEXIT tag with the appropriate Method attribute. Both tags will
work within a CFCATCH tag.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

IIS question

[Douglas Jordon]

Hi,

I've been given a site to work on that uses a site root reference in all
of it's links(a href=/etc.cfm). The links don't work on our
development server where there was only a default web site created. So I
created a website with the snap-on with the home directory as root, but
the links still don't work. Any suggestions about what I'm doing
wrong/not doing?

TIA,

Doug Jordon
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Jeffry Houser]

At 10:54 AM 02/07/2002 -0500, you wrote:
1. I want HomeSite 5 to detect and bring in the settings I have with
HomeSite 4.5.2 and then I want to uninstall 4.5.2 but if I do that I then
have to reinstall 5 but my 4.5.2 will be gone, along with all it's settings,
so I won't be able to migrate over my settings again? Does this mean that to
migrate my settings I have to leave 4.5.2 on my PC after I install 5?
Forever? Same thing with CF Studio 4.5.2 and 5.0?

  Well, you can check out the UserData folder in your installation 
directory.  For CF Studio, I believe it contains all your user 
settings.  Back it up and you should be able to restore your settings just 
by replacing the directory and re-loading home-site.
  Although, I can't say for certain, I'd also look for some sort of 
HomeSite.Ini file



2. I don't want to install JRun Studio 3.0.1 (or JRun 3.0.1, I'm confused
about which one they mean, studio or the app server or both?). At least not
now. But I might want to later. If I do it later then I will have to
reinstall both HomeSite 5 and CF Studio 5 and I'll lose my settings again?

  I'd guess they mean JRun studio, although I can't say for certain.


3. Does the shared files paragraph really mean that if I ever uninstall
HomeSite 5.0/CF Studio 5.0 and I want to reinstall them I first have to
reinstall versions 4.5.2 or make sure they are still on my PC? Are versions
4.5.2/5.0 of HomeSite/Studio forever joined at the hip if I want to retain
my settings?

  I bet they mean that HomeSite / Studio 4.5.2 uses old versions of a 
specific DLL.  HomeSite/ CF Studio 5 uses newer versions.  5 won't work on 
the older versions, but 4.5.2 will work on the newer versions.  If you 
re-install 4.5.2 then you over-write the new versions.

  Of course, this is all speculation.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
Need a Web Developer?  Contact me!
My Book: Instant ColdFusion 5  | http://www.instantcoldfusion.com
My New Book: ColdFusion: A Beginner's Guide February 2002
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: evil error

[Greg Alton]

We've had this error reported a couple of times with CF 5 users. Try
unchecking the Load JVM when ColdFuion starts option in the Administrator
under JVM settings.

You may need unregister the Java CFX tag, restart and register again.

This seems to occur only after a large number of calls to a Java CFX tag.

We have not been able to replicate the problem, but I wonder if it might 
be
related to this tech note:

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

This above concerns a problem when a user logs off and then logs back on
when the JVM is being used. It suggests updating to JRE 1.3.1_01 and
adding -Xrs to the implementation options.

Greg Alton
CFDev
- Original Message -
From: Tyler Silcox [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 9:48 AM
Subject: evil error


 I'm getting a very naughty error on a page that I have been running 25+
 times a day for the last two months.  It's a page that is scheduled to
 run every hour and can also be initiated by a link.  It grabs all the
 user names and passwords from the db for some pop accounts, cfpops thei
r
 mailboxes, and throws all their messages into our db, where they are
 filtered and marked as sorted.  All of a sudden I can't get past the
 first cfpop.  I keep getting the error below.  I even changed the amoun
t
 of messages to download from 100 to 5 (while only hitting one mailbox),
 and it's still dying on me immediately after running without a hitch fo
r
 2 months (while downloading up to 100 messages per mailbox).  I know
 y'all don't have all the specifics, but is this likely due to some othe
r
 nasty server problem, or is it probably my page?  I've watched the
 server task manager as I've hit the page and the ColdFusion process
 never really rises above 15% or so in CPU time on the Processes tab, bu
t
 it maxes out the CPU Usage History on the Performance tab.  In my cf
 logs, I get this error:

 Unknown error threshold reached. Restarting service.

 And then, this is the error I get returned to me on the page I'm trying
 to hit:
 Error Diagnostic Information
 Request canceled or ignored by serverServer busy or unable to fulfill
 request. The server is unable to fulfill your request due to extremely
 high traffic or an unexpected internal error. Please attempt your
 request again (if you are repeatedly unsuccessful you should notify the
 site administrator). (Location Code: 26)

 Everything is still running pretty smoothly around here, except for our
 java-based cfx_activmail tag hasn't been completing it's duties.  I'm
 wondering if the jvm could be churning itself inside out, and affecting
 cfpop?  I'm running out of ideas...

 What are my options here?  Reinstall the server, set up a Java mail
 popper, just go home and watch some oprah and pretend this never
 happened?

 Thanks again for any help y'all can provide-

 Tyler
 email | [EMAIL PROTECTED]

 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Help required on CF Performance....

[Nick Betts]

Thanks Deanna!
Nick

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 15:47
To: CF-Talk
Subject: Re: Help required on CF Performance


The answer was www.opensta.org. You can set up a script to run with 
multiple
virtual users and see how performance degrades (or doesn't) with 
additional
users.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

newgroup

[Won Lee]

Hi Everyone,

I was wondering if those that use the newgroup version of this great list 
have been able to find a solution for the incorrect dates.  I've tried 3 
different newsgroups [Forte Freeagent, Netscape, and Xnews].  All the 
readers have the wrong dates.  The exception seems to be if someone else 
posts to the through the newsgroup.  Those posts display the right date.

I know this is a real small problem...but somehow it really bugs.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

How to Find Hidden Characters -- maybe related to whitesp...

[Carol Bluestein]

Subject:
How to Find Hidden Characters -- maybe related to whitespace issue
-



Greetings all.

I'm having one !@#%$#$^$%^ of a time figuring this out.
Can anyone out there help?

The Task: Taking the information from the error/cferror variables
saving them in a log file which can then be displayed in EXCEL, with
one column per variable.

The Problem: everything works EXCEPT error.diagnostics, which
insists on placing itself in two columns.

The Analysis: The diagnostics  information is preformatted by
coldFusion and contains a hidden cr/lf or paragraph marker(s) that
I can not  seem read programmatically so that I can remove it.

The Question:  How do I do this... remove these hidden characters?

Testing so far has shown that I can remove the hidden marker by
removing a block of space in which it is contained, but it requires
that I have seen where it occurs and for which type of error and an
assumption that it will always look the same for each error.

If I try to remove just extra spaces in a loop, the hidden character
does not get caught and remains.

Anyone have any ideas I've been working on this for several days.
Any help would be very much appreciated.

Thanks,
Carol



Carol Bluestein
TAAD, Senior Programmer
NYS Office of Real Property Services
16 Sheridan Avenue
Albany, NY  12210
518-486-6335
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oracle Error

[erica . vitina]

Have you checked the limitations on your firewall?  We ran into a similar
situation (with a similar network configuration), and we discovered that it
was because our firewall (Raptor) only supported 30 concurrent Oracle
connections at a time, which essentially made all of our DMZ CF/Oracle sites
non-functional.  To alleviate the situation, we used Connection Manager to set
up the connections, and everything has been fine since.




   

Debbie McDaniel

debbie.mcdaniel@dataTo: CF-Talk 
[EMAIL PROTECTED]   
-line.com   cc:   

 Subject: Oracle Error 

02/07/2002 09:57 AM

Please respond to  

cf-talk

   

   





Hi everyone,
I keep getting these weird errors with Oracle 8i that of course are being
blamed on ColdFusion. Here goes.
Our webserver sits in the DMZ and our database server is  inside the
firewall. All traffic going from the webserver goes through the firewall to
talk to the database.
I seem to be able to access the database through coldfusion 90% of the time,
but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to
connect to destination error, both of which result in massive errors in the
application and the eventual rebooting of the machine.
I am thinking it may be a network issue, but because coldfusion is new to
this company they want to blame it. If I log in with sql+ (an oracle client)
I can access the datasource w/o trouble, although cf can't even verify the
datasource. This usually happens after several moderate hits to the
datasource.
We are running CF 4.5.2 with all the appropriate patches applied on a Compaq
Windows 2000 machine with all the appropriate service packs applied to
Win2K. Our database is Oracle 8i - anyone have some suggestions?
Greatly appreciated!
Debbie M.



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

Weight Loss CFGRAGPH

[Ann Harrell]

I'm in the thinking stage of a small project for a group of friends. I want
to keep it fairly simple. It would be in Access

Person1
WeightLost (bar graph)
WeightGoal

Person2
WeightLost
WeightGoal

and I would like to display this in cfgraph. Is this possible?

Ann Harrell, USA
Phone: 219.342.0618

A society that will trade a little liberty for a little order will lose
both, and deserve neither.
--- Thomas Jefferson, in a letter to Madison
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

porting cf

[Trusz, Andrew]

We're trying to port from NT4, CF4.0 to Sun Solaris 2.8 running CF 4.5. Case
has been checked, the datasource is verified.  The query referred to in the
error is: (about as basic as it can be)

CFQUERY name=sort datasource=dsel dbtype=ODBC
select * 
from dsel
/CFQUERY



The error message is:

Error Diagnostic Information
ODBC Error Code = S1000 (General error) 
[MERANT][ODBC SQL Server Driver]Unicode conversion failed 
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (13:1) to (13:53).
Date/Time: Wed Feb 06 11:00:42 2002
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461)


Can this be done or is the Unicode simply easier to deal with by rewriting
on the Solaris?

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Need ideas for resource available calendar

[Dave Wilson]

Hatton,

I'm presuming that you've already got a database developed which stores the
relevant info for resource availability etc and are basically looking to
create Gantt charts from the data.

With this presumption, you could download a 30 day trial copy of Popchart
Image Server from www.corda.com then use the stacked horizontal barchart
option to create your gantt charts as per your data.

This solution wouldn't quite give you the calendar effect as in Outlook.

HTH,
Dave


-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 13:45
To: CF-Talk
Subject: Need ideas for resource available calendar


Hey folks,

I'm working on a calendar module for our Project/Task/Time tracking system
and have hit a brain freeze... I know there's got to be code out there to
generate a monthly calendar, but either I'm not looking for the right thing
or I'm not seeing the right response.

Basically what I need to build is a monthly calendar view that shows bars
across dates that have task information in the date... sort of like what the
Outlook calendar looks like for multi-day events.

Right now we have something like this that works for a single week... they
want it expanded to offer month, quarter and day views.  Oh what fun!

Anyone have any suggestions of where to look?

TIA

Hatton

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Earl, George]

Mark,

You are right that HomeSite is a scaled down version of CF Studio, although
I like to think of it as CF Studio is a pumped up version of HomeSite . . .

I install HomeSite even though I have Studio because I am the point person
for the copies we distribute to our developers. I need to see what they see
when they have questions about HomeSite.

George
[EMAIL PROTECTED]

 ... snipped ...
  In any case, I'd be interested
 to know what Homesite gives you that CF studio does not?

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: CFQUERY

[phumes1]

Hi,

This is a continuation from yesterday. I have a file index.cfm with the 
below code in it:

table border=0 cellspacing=0 cellpadding=0
tr
cfform action=create-list.cfm name=checkboxform method=POST
cfquery name=GetFontFamily datasource=fontstyles
SELECT  sti, ID
FROMfontsti
ORDER BY sti
/cfquery

td class=dirlinks
cfoutput query=GetFontFamily
cfif #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Euro' OR
  #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'European-Pi' 
OR
  #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Garamond' OR
  #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# IS 'Helvetica' 
OR'
input type=Checkbox name=select 
value=#LCase(ListGetAt(GetFontFamily.sti,1,'.'))# checked=Yes 
required=Yes onclick=this.checked=true;
img src=../../images/blank.gif width=3 height=14 alt= 
border=0font 
color=rednbsp;#LCase(ListGetAt(GetFontFamily.sti,1,'.'))# 
[#GetFontFamily.ID#]/fontbr
cfelse
cfinput type=Checkbox name=select 
value=#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#
nbsp;#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#br
/cfif
/cfoutput
/td
/tr
tr
td class=navlinks
input class=navlinks type=submit name=Action value= Generate 
nbsp;input class=navlinks type=submit name=Action value=Close 
OnClick=window.close()
br

/td
/tr
/table


This gets submitted to create-list.cfm which creates a list of the following:

Euro
European-Pi
Garamond
Helvetica



table border=0 cellspacing=0 cellpadding=0
tr
td class=dirlinks
cfoutput
#REReplace(FORM.select,,,br,ALL)#
/cfoutput
/td
/tr
tr
td class=navlinks
nbsp;
/td
/tr
/table

How can I loop through the above results using a CFQUERY to display 
additional fields (corresponding .PFB files) of each font family from my 
database?
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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 to Find Hidden Characters -- maybe related to whitesp...

[James Curran]

Try Searching for the following:

chr(13)  chr(10)


or any combo of the two.

- j

.
jim.curran
technical.director
nylon.technology
six.west.fourteenth.street
new.york.ny.10011
212.691.1134
[EMAIL PROTECTED]
..

-Original Message-
From: Carol Bluestein [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:02 AM
To: CF-Talk
Subject: How to Find Hidden Characters -- maybe related to whitesp...


Subject:
How to Find Hidden Characters -- maybe related to whitespace issue
-



Greetings all.

I'm having one !@#%$#$^$%^ of a time figuring this out.
Can anyone out there help?

The Task: Taking the information from the error/cferror variables
saving them in a log file which can then be displayed in EXCEL, with
one column per variable.

The Problem: everything works EXCEPT error.diagnostics, which
insists on placing itself in two columns.

The Analysis: The diagnostics  information is preformatted by
coldFusion and contains a hidden cr/lf or paragraph marker(s) that
I can not  seem read programmatically so that I can remove it.

The Question:  How do I do this... remove these hidden characters?

Testing so far has shown that I can remove the hidden marker by
removing a block of space in which it is contained, but it requires
that I have seen where it occurs and for which type of error and an
assumption that it will always look the same for each error.

If I try to remove just extra spaces in a loop, the hidden character
does not get caught and remains.

Anyone have any ideas I've been working on this for several days.
Any help would be very much appreciated.

Thanks,
Carol



Carol Bluestein
TAAD, Senior Programmer
NYS Office of Real Property Services
16 Sheridan Avenue
Albany, NY  12210
518-486-6335

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Importing Uploaded Excel Data into DB

[Dave Douglas]

Hello,

I have searched past messages to the list and have seen some recommendations
for the csvtoquery custom tag
to put the spreadsheet data into a query.  What makes my situation unique (I
think) is that the spreadsheet has
commas in the data in some of the columns.  I tried CSVformat and am able to
print out the data on row at a time.  Where I am stuck now is how to get
this information into the DB and how to get it in the right fields as right
now it is printing all columns for each employee on one line each and it
blows up the query when I try to insert #item# as the Value.  Any Help is
GREATLY appreciated!

here is my code so far:

cffile action=READ
 file=#File.ServerDirectory#\#File.ServerFile#
 variable=excelList

 cfset NewList = Replace(excelList, #chr(13)#, ^, ALL)
 cfset NewList = Replace(excelList, #chr(10)#, ^, ALL)

 cfloop index=item
 list=#NewList#
 delimiters=^
   cfoutput#item#/cfoutputbr
 /cfloop

A working version, with csv and txt files available is at
http://www.high-techsolutions.net/development/UpLoad.cfm

TIA,

Dave
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Importing Uploaded Excel Data into DB

[C. Hatton Humphrey]

What kind of DB are you using?  One way we've accomplished this in the past
is to actually create a floating Excel data source.  We upload the file
and use CFFile to copy it into the right position and give it the right
name.  Once in place, we query the Excel data source and then insert into
the SQL Server one.

That was an old solution and we have a looping process in place as well that
limits the number of records dealt with to 100 per load.  If you're using
SQL Server there are DTS packages or Bulk Insert options available as well.

HTH
Hatton


 -Original Message-
 From: Dave Douglas [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 11:35 AM
 To: CF-Talk
 Subject: Importing Uploaded Excel Data into DB


 Hello,

 I have searched past messages to the list and have seen some
 recommendations
 for the csvtoquery custom tag
 to put the spreadsheet data into a query.  What makes my
 situation unique (I
 think) is that the spreadsheet has
 commas in the data in some of the columns.  I tried CSVformat and
 am able to
 print out the data on row at a time.  Where I am stuck now is how to get
 this information into the DB and how to get it in the right
 fields as right
 now it is printing all columns for each employee on one line each and it
 blows up the query when I try to insert #item# as the Value.  Any Help is
 GREATLY appreciated!

 here is my code so far:

 cffile action=READ
  file=#File.ServerDirectory#\#File.ServerFile#
  variable=excelList

  cfset NewList = Replace(excelList, #chr(13)#, ^, ALL)
  cfset NewList = Replace(excelList, #chr(10)#, ^, ALL)

  cfloop index=item
  list=#NewList#
  delimiters=^
cfoutput#item#/cfoutputbr
  /cfloop

 A working version, with csv and txt files available is at
 http://www.high-techsolutions.net/development/UpLoad.cfm

 TIA,

 Dave
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

CFContent Download Mime

[Paul Sizemore]

I've worked all morning on this, and can't figure this out. This is my 
first
time working with CFContent. 

When I load this page, the excel document loads in the browser (as 
text). I
would like to start a download, or just go ahead and load in IE as an 
Excel
document like a http://tflweb/managersinvites3.xls; call. What am I
missing?



Start Of Template 

cfheader name=Content-Disposition value=attachment;
filename='test.xls'

cfcontent type=application/vnd.ms-excel 
   deletefile=no 
   file=e:\Inetpub\wwwroot\intranet\managersinvites3.xls

End Of Template 


Start Display in Browser 
ÐÏࡱ
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: Importing Uploaded Excel Data into DB

[Dave Douglas]

Ok, right now I am finishing up development on the app with Access, b
ut it
will be SQL 7 in production.

- Original Message -
From: C. Hatton Humphrey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 11:40 AM
Subject: RE: Importing Uploaded Excel Data into DB


 What kind of DB are you using?  One way we've accomplished this in 
the
past
 is to actually create a floating Excel data source.  We upload th
e file
 and use CFFile to copy it into the right position and give it the r
ight
 name.  Once in place, we query the Excel data source and then inser
t into
 the SQL Server one.

 That was an old solution and we have a looping process in place as 
well
that
 limits the number of records dealt with to 100 per load.  If you're
 using
 SQL Server there are DTS packages or Bulk Insert options available 
as
well.

 HTH
 Hatton


  -Original Message-
  From: Dave Douglas [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, February 07, 2002 11:35 AM
  To: CF-Talk
  Subject: Importing Uploaded Excel Data into DB
 
 
  Hello,
 
  I have searched past messages to the list and have seen some
  recommendations
  for the csvtoquery custom tag
  to put the spreadsheet data into a query.  What makes my
  situation unique (I
  think) is that the spreadsheet has
  commas in the data in some of the columns.  I tried CSVformat and
  am able to
  print out the data on row at a time.  Where I am stuck now is how
 to get
  this information into the DB and how to get it in the right
  fields as right
  now it is printing all columns for each employee on one line each
 and it
  blows up the query when I try to insert #item# as the Value.  Any
 Help
is
  GREATLY appreciated!
 
  here is my code so far:
 
  cffile action=READ
   file=#File.ServerDirectory#\#File.ServerFile#
   variable=excelList
 
   cfset NewList = Replace(excelList, #chr(13)#, ^, ALL)
   cfset NewList = Replace(excelList, #chr(10)#, ^, ALL)
 
   cfloop index=item
   list=#NewList#
   delimiters=^
 cfoutput#item#/cfoutputbr
   /cfloop
 
  A working version, with csv and txt files available is at
  http://www.high-techsolutions.net/development/UpLoad.cfm
 
  TIA,
 
  Dave
 
 ___
___
 Get Your Own Dedicated Windows 2000 Server
   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
   Instant Activation · $99/Month · Free Setup
   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

CFSERVER and security

[Brian L. Wolfsohn]

At 12:48 PM 5/8/2001 -0400, you wrote:

Is this T: drive physically on your server, or is it on another server? If
it is on another server, the CF Service must be run in the context of a user
that would have access to that other server. Just because you can see the
drive share doesn't mean CF can.

This response was originally part of a discussion on accessing files using 
cffile, and the need to run cfserver under a user account as opposed to the 
system account.

I'm concerned with the ramifications of running cfserver as a user account 
as opposed to the system account.  Are there security issues that don't 
exist when it's run under the system account ?  We've got a pretty heavily 
used existing live box that has been running cfserver under the system 
account.  I'm concerned about A:breaking existing applications and 
B:creating security holes that didn't exist before.

Any advice would be appreciated.


Brian L. Wolfsohnhttp://www.cus.com
CUS Business Systems Ft.Lauderdale,FL
Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED]
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: CFSERVER and security

[Herbener, Martin - School Information Technology]

I currently run CF with a non-system account.

a) breaking current applications is certainly an issue.  I have figured 
out
how to set permissions that work for me (documented at
http://www.defusion.com/articles/index.cfm?ArticleID=89) but, 
depending on
what databases and other components you use you may have to experiment.

b) new security holes: I regard using a non-system account as an 
overall
security improvement, because someone who gets control of CF doesn't
necessarily get control of the box.  However, someone who gets control 
of CF
may, in a non-system account situation, get some sort of access to 
other
machines.  Exactly what access they obtain depends on how you set up 
the
account.

 -Original Message-
 From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 11:47 AM
 To: CF-Talk
 Subject: CFSERVER and security
 
 
 At 12:48 PM 5/8/2001 -0400, you wrote:
 
 Is this T: drive physically on your server, or is it on 
 another server? If
 it is on another server, the CF Service must be run in the 
 context of a user
 that would have access to that other server. Just because 
 you can see the
 drive share doesn't mean CF can.
 
 This response was originally part of a discussion on 
 accessing files using 
 cffile, and the need to run cfserver under a user account as 
 opposed to the 
 system account.
 
 I'm concerned with the ramifications of running cfserver as a 
 user account 
 as opposed to the system account.  Are there security issues 
 that don't 
 exist when it's run under the system account ?  We've got a 
 pretty heavily 
 used existing live box that has been running cfserver under 
 the system 
 account.  I'm concerned about A:breaking existing applications and 
 B:creating security holes that didn't exist before.
 
 Any advice would be appreciated.
 
 
 Brian L. Wolfsohnhttp://www.cus.com
 CUS Business Systems Ft.Lauderdale,FL
 Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED]
 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server on a separate machine

[Bryan Stevenson]

set username and password for the datasource in CF Admin

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 9:52 PM
Subject: SQL Server on a separate machine


 Hi all,

 Our development environment has CF4.5 and SQL Server 2K on an SBS2K
 machine on a LAN. Some of my clients are on CF5 hosting, and there are
 some features of CF5 I would like use for these clients. I have the
 Developers edition of CF5 on my Win2K machine, and I would like it to
 connect to databases on the SQL Server (over the LAN). I can set up a
 DSN on my machine, but when I try to run a CFQuery it errors out because
 I'm not using a trusted connection. How do I set the server up so it
 will allow my machine to connect? Can I even do this on SBS2K?

 Thanks,
 Kay.
 __
 Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd

 Level 9/105 St George's Terrace - Perth - Western Australia
 Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au

 http://developer.perthweb.com.au - Tools for Developers
 cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt




 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Fixed: finding hidden characters

[Deanna Schneider]

Hi Carol,
I used to struggle mightily with these issues, too. Then, I realized that  I
can do all my formatting in html, and excel will get it. In other words,
dump the whole error.diagnostics into one td/td and it will show up in
one column, regardless of whether or not there are weird characters. (You
may span rows, though.)

Make sense?
-d


Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: COncurrent Users

[Keen]

The best way to do this is with a load test tool.  Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users.  Compare the results to determine the best
setting for that application.  That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times.  Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/.  Ballpark figures seem to be between 5-10
per processor depending on who you speak with.  If you have more questions
feel free to contact me offline.

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users


Hi,
Is there a way to test system performance based on differenet number of
concurrent users?  Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the cfquery


cfloop query=theQuery

   cfquery name=blah datasource=blah
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   /cfquery

/cfloop



At 05:15 PM 2/6/02 -0800, you wrote:
dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)

Thanks

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation


 Oh nevermind, your not looping over the columns of the query (long
day
 as well)

 I think you need a semi-colon at the end of your query, since that
will
 put multiple inserts in one cfquery.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Steve Oliver [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:02 PM
 To: CF-Talk
 Subject: RE: looping inside cfquery - brain on vacation


 Hmmm, well if one of your fields is numeric, then that wouldn't work,
 since numeric values don't need 's around them,  you could use the
 isNumeric() function for that.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:01 PM
 To: CF-Talk
 Subject: looping inside cfquery - brain on vacation


 OK..long day..CF whining about syntax...help!

 The situation:

 CF doesn't like my syntax for this bit of looping over a query to
insert
 muliple records.  It's
 complaining about the final ) closing bracket for the insert.  Any
 ideas?  I'm sure I've done it
 beforejust saw it posted the other week too...geesh talk about
 timing ;-)

 cfquery name=blah datasource=blah
   cfloop query=theQuery
 INSERT INTO Table
 (
 Field
 )
VALUES
 (
 '#FieldValue#'
 )
   cfloop
 /cfquery

 TIA

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com







__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Possible bug in StructFindKey() in CF Ent 4.5.1 SP-2 on Win NT4/2000 Server?

[Colin Fyfe]

Hi Raymond,

Another quick update for you on my progress on this issue. I've knocked up a
recursive (eugh...) custom tag for our 4.5.1 installation which mirrors the
interface to StructFindKey in that in the first instance it takes in the top
level structure, the key name and the scope and then returns an array of
results showing the owner, the path and the value.

I think I have isolated the steps to reproduce/invoke the problem:

I tried altering the WDDX packet in a few ways - I cut the number of rows
down, reduced the number of columns and I replaced the nested structs with
one-layer structs but all to no avail. When there was only one row it worked
fine, but I know CF is capable of storing multiple query rows in a WDDX
packet and I need to store multiple rows anyway.

The only thing that seemed to improve the situation where multiple rows were
concerned was removing the WDDX packets contained in the WDDX file, i.e. the
content!

But, and this is a big BUT, I found that the problem vanished when the first
field in each nested structure was not empty. As the first field in the test
structs is always ALIGN, I popped left into the string/string pairs
in the WDDX packet and lo and behold it worked! My thinking here was that
the FILENAME (the key I was searching for) could not be empty but placing
values in there didn't fix the problem. Next I tried the first element and
that fixed it.

So, is this a bug in CFWDDX de-serialising nested WDDX packets or a bug in
StructKeyFind()?

Thanks again and hope this updated information helps you guys out,

Colin
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Cold Fusion and Networks

[Matthew R. Small]

I don't know of anybody who's done it, but I'm sure that it can be done
- write a custom tag in C++ or java that does the job.

- Matt Small

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 10:51 AM
To: CF-Talk
Subject: Cold Fusion and Networks

Sorry for the double post..I wasn't sure if the subject was descriptive
enough.  :-)

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of
names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Release Database

[Graham Lewis]

I find that I cannot overwrite a database file since it appears that CF
has it locked.  How can I release it so I can overwrite it?

Graham

Graham Lewis
Centre for Academic Practice
University of Warwick
CV4 7AL
Tel: 024 765 73109
Mobile: 07733450022
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: Release Database

[Douglas Brown]

What are you using for you DB? You can simply right click on the DB in 
SQL and choose take offline.



There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown
- Original Message - 
From: Graham Lewis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 9:56 AM
Subject: Release Database


 I find that I cannot overwrite a database file since it appears that 
CF
 has it locked.  How can I release it so I can overwrite it?
 
 Graham
 
 Graham Lewis
 Centre for Academic Practice
 University of Warwick
 CV4 7AL
 Tel: 024 765 73109
 Mobile: 07733450022
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Release Database

[James Maltby]

You need to do one of two things:

1) go the cfadmin and to the ODBC connection to your database (Access I am
guessing) then turn off the keep connections alive until you are ready to
go live with the whole thing.

2) copy the db, paste the copy and append a _a or whatever to the end -
then go to the cfadmin (as above) and append the _a to the end of the
path, wait for a while then work on the old version, then when you are
ready swap them back...

HTH

J

-Original Message-
From: Graham Lewis [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 17:56
To: CF-Talk
Subject: Release Database


I find that I cannot overwrite a database file since it appears that CF
has it locked.  How can I release it so I can overwrite it?

Graham

Graham Lewis
Centre for Academic Practice
University of Warwick
CV4 7AL
Tel: 024 765 73109
Mobile: 07733450022
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Cold Fusion and Networks

[Garza, Jeff]

Look for the Intranet Hosting Tool Kit on www.intrafoundation.com.  It's a
series of CFX custon tags that should be able to achieve what you are
looking for.  Lewis Sellars released this as freeware awhile back...

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 10:35 AM
To: CF-Talk
Subject: RE: Cold Fusion and Networks


I don't know of anybody who's done it, but I'm sure that it can be done
- write a custom tag in C++ or java that does the job.

- Matt Small

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 10:51 AM
To: CF-Talk
Subject: Cold Fusion and Networks

Sorry for the double post..I wasn't sure if the subject was descriptive
enough.  :-)

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of
names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??



__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Release Database

[Bryan Stevenson]

sounds like you are using Access? is there a .ldb file?

If so then all you have to do is run a bad query against the database (mabye a few 
times).  Create a
file with the bad query (SELECT Something FROM Nothing) and run it in a 
browser.that will kill
the lock file when it creates an error (if it doesn't work the first time...try 
again).  You could
also simply try restarting CF Server if you have access to it.

HTH

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Graham Lewis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 9:56 AM
Subject: Release Database


 I find that I cannot overwrite a database file since it appears that CF
 has it locked.  How can I release it so I can overwrite it?

 Graham

 Graham Lewis
 Centre for Academic Practice
 University of Warwick
 CV4 7AL
 Tel: 024 765 73109
 Mobile: 07733450022
 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
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Release Database

[Dave Carabetta]

If you're using an Access database, and that's the lock you're trying to 
release, just run a query that will definitely fail, and that will release 
the lock on the file.

Example:
SELECT badColumn
FROM badTable

Since that table (hopefully!) doesn't exist, the lock will be released on 
the database file and you will be able to overwrite it.

Hope this helps,
Dave.


Original Message Follows
From: Douglas Brown [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Release Database
Date: Thu, 7 Feb 2002 10:18:22 -0800

What are you using for you DB? You can simply right click on the DB in
SQL and choose take offline.



There are two major products that come out of Berkeley: LSD and [Unix]
BSD. We don't believe this to be a coincidence.



Doug Brown
- Original Message -
From: Graham Lewis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 9:56 AM
Subject: Release Database


  I find that I cannot overwrite a database file since it appears that
CF
  has it locked.  How can I release it so I can overwrite it?
 
  Graham
 
  Graham Lewis
  Centre for Academic Practice
  University of Warwick
  CV4 7AL
  Tel: 024 765 73109
  Mobile: 07733450022
  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
 

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Release Database

[Steve Oliver]

Just put this in a template and view it in your browser, it will unlock
your dbase connections.

cfset CFUSION_DBCONNECTIONS_FLUSH()

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Graham Lewis [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 12:56 PM
To: CF-Talk
Subject: Release Database


I find that I cannot overwrite a database file since it appears that CF
has it locked.  How can I release it so I can overwrite it?

Graham

Graham Lewis
Centre for Academic Practice
University of Warwick
CV4 7AL
Tel: 024 765 73109
Mobile: 07733450022
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: COncurrent Users

[Keen]

Sorry misread the question...thought you were trying to figure out the
setting for simultaneous request in the CF Admin.

-Original Message-
From: Keen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:26 AM
To: CF-Talk
Subject: RE: COncurrent Users


The best way to do this is with a load test tool.  Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users.  Compare the results to determine the best
setting for that application.  That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times.  Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/.  Ballpark figures seem to be between 5-10
per processor depending on who you speak with.  If you have more questions
feel free to contact me offline.

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users


Hi,
Is there a way to test system performance based on differenet number of
concurrent users?  Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the cfquery


cfloop query=theQuery

   cfquery name=blah datasource=blah
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   /cfquery

/cfloop



At 05:15 PM 2/6/02 -0800, you wrote:
dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)

Thanks

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 5:06 PM
Subject: RE: looping inside cfquery - brain on vacation


 Oh nevermind, your not looping over the columns of the query (long
day
 as well)

 I think you need a semi-colon at the end of your query, since that
will
 put multiple inserts in one cfquery.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Steve Oliver [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:02 PM
 To: CF-Talk
 Subject: RE: looping inside cfquery - brain on vacation


 Hmmm, well if one of your fields is numeric, then that wouldn't work,
 since numeric values don't need 's around them,  you could use the
 isNumeric() function for that.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 8:01 PM
 To: CF-Talk
 Subject: looping inside cfquery - brain on vacation


 OK..long day..CF whining about syntax...help!

 The situation:

 CF doesn't like my syntax for this bit of looping over a query to
insert
 muliple records.  It's
 complaining about the final ) closing bracket for the insert.  Any
 ideas?  I'm sure I've done it
 beforejust saw it posted the other week too...geesh talk about
 timing ;-)

 cfquery name=blah datasource=blah
   cfloop query=theQuery
 INSERT INTO Table
 (
 Field
 )
VALUES
 (
 '#FieldValue#'
 )
   cfloop
 /cfquery

 TIA

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com








__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: 

capture email address

[Robert Orlini]

Hello,

Is there a way to capture a user's email adress after tey submit a form?
Is there a CGI or other variable that can do this and then it can be
inserted into a variable field on the form? I.E. #cgi.REMOTE_ADDR#,
#cgi.HTTP_USER_AGENT#, #cgi.REMOTE_USER#

Our email server requires a valid email address to be in the FROM field
in a cfmail tag.

Thanks.

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Oracle Error

[Herbener, Martin - School Information Technology]

See if you can get the networking people to configure the firewall to log
all traffic, both allowed and disallowed, from the CF server to the Oracle
db, for a period of time that includes success and CF errors; that is likely
to show something interesting.  Without specific configuration, the Oracle
client on the CF server may try to use different ports on the server side,
which could confuse the firewall or be rejected.

 -Original Message-
 From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 10:58 AM
 To: CF-Talk
 Subject: Oracle Error
 
 
 Hi everyone,
 I keep getting these weird errors with Oracle 8i that of 
 course are being
 blamed on ColdFusion. Here goes.
 Our webserver sits in the DMZ and our database server is  inside the
 firewall. All traffic going from the webserver goes through 
 the firewall to
 talk to the database.
 I seem to be able to access the database through coldfusion 
 90% of the time,
 but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to
 connect to destination error, both of which result in massive 
 errors in the
 application and the eventual rebooting of the machine.
 I am thinking it may be a network issue, but because 
 coldfusion is new to
 this company they want to blame it. If I log in with sql+ (an 
 oracle client)
 I can access the datasource w/o trouble, although cf can't 
 even verify the
 datasource. This usually happens after several moderate hits to the
 datasource.
 We are running CF 4.5.2 with all the appropriate patches 
 applied on a Compaq
 Windows 2000 machine with all the appropriate service packs applied to
 Win2K. Our database is Oracle 8i - anyone have some suggestions? 
 Greatly appreciated! 
 Debbie M.
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[John B. White]

Okay...slightly off topic, but this sounds like I should seriously consider
purchasing CF Studio?  Right now I hand code everything (since I'm trying to
learn).  What advantages are there to using Studio?

Currently I use:

1st Page 2000 by EvrSoft 
- Which has some CF tags and the ability to add more...and is free!
Arachnophilia 
- Also free and a nice little interface for Tidy HTML
Netscape Composer
- Yes it writes crappy code but for initial page layout, its quick and simple.
And its free!

This is not a production environment.  I'm teaching myself CF so I can give my
informatics students a taste of dynamic page generation and the use of a web app
for patient information etc.  Suggestions on making this easier are welcome,
probably off list ([EMAIL PROTECTED]).

BTW, I've learned alot from watching this list and viewing the cfsnippits of
posts.  :)

--JW

Earl, George wrote:
 
 Mark,
 
 You are right that HomeSite is a scaled down version of CF Studio, although
 I like to think of it as CF Studio is a pumped up version of HomeSite . . .
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Weight Loss CFGRAGPH

[Bruce Sorge]

Although CFGRAPH is pretty cool and a welcome addition to ColdFusion, there
 are still quite a few limitations to that tag. This is one of them.

What you are wanting to do is to have two valuecolumns on the same chart, a
nd this is something that CFGRAPH does not do. What you can do is to create
 two graphs, one showing weight loss and the other weight goal. You would h
ave all the people in the database lumped into one chart for each category.
 The code example below gives you two charts, one on top of the other. If y
ou want to do some really cool things with charts and graphs, for now you w
ill need to get a third party charting application. The one we use here at 
Baylor is PopChart by Corda Technologies (www.corda.com). It is really good
 It is a JAVA application that runs on the web server (or any server for t
hat matter, you just have to point to it in your code). It works well with 
CFM, ASP, JSP and HTML.  It also comes with a cool builder tool that is als
o a JAVA application. You feed in the necessary parameters and it creates t
he necessary JavaScript for you.

Code example:

!--- Query the DB for the informaton ---
cfquery dataSource = SomeDSN Name = qSomeName
 Select *
 WeightLoss
 order By F_Name
 /cfquery

!--- Create the first graph ---
  cfgraph type=HORIZONTALBAR query=qSomeName valuecolumn=Weight
_Lost itemcolumn=F_Name showvaluelabel=Yes valuelabelfont=Arial
 valuelocation=ONBAR scaleto=300 itemlabelfont=Arial itemlabel
orientation=HORIZONTAL title=Weight Loss Progress Chart titlefont
=Arial fileformat=Flash depth=5 colorlist=red,green,blue,yel
low,orange
 /cfgraph
 
 !--- Create the second graph ---
 cfgraph type=HORIZONTALBAR query=qSomeName valuecolumn=Weight_
Goal itemcolumn=F_Name showvaluelabel=Yes valuelabelfont=Arial
 valuelocation=ONBAR scaleto=300 itemlabelfont=Arial itemlabelo
rientation=HORIZONTAL title=Weight Goal Progress Chart titlefont
=Arial fileformat=Flash depth=5 colorlist=red,green,blue,yel
low,orange
 /cfgraph

Another thing that you can do is to output the information into a table abo
ve the charts, and you can also make it a drill down chart, then you could 
pass in the User_ID parameter in the URL and create another chart for just 
the individual or a table with the necessary information.


--- Original Message --
From: Ann Harrell [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 7 Feb 2002 11:24:52 -0500

I'm in the thinking stage of a small project for a group of friends. I want

to keep it fairly simple. It would be in Access

Person1
WeightLost (bar graph)
WeightGoal

Person2
WeightLost
WeightGoal

and I would like to display this in cfgraph. Is this possible?

Ann Harrell, USA
Phone: 219.342.0618

A society that will trade a little liberty for a little order will lose
both, and deserve neither.
--- Thomas Jefferson, in a letter to Madison

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: capture email address

[Bryan Love]

the ONLY way to capture an email address is by having the use type it 
in...

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may 
have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:08 AM
To: CF-Talk
Subject: capture email address


Hello,

Is there a way to capture a user's email adress after tey submit a 
form?
Is there a CGI or other variable that can do this and then it can be
inserted into a variable field on the form? I.E. #cgi.REMOTE_ADDR#,
#cgi.HTTP_USER_AGENT#, #cgi.REMOTE_USER#

Our email server requires a valid email address to be in the FROM field
in a cfmail tag.

Thanks.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Mark A. Kruger - CFG]

John,

CF Studio is like going from a hand saw to a chain saw.  It's the best tool
for hand coding I've ever used.

Mark

-Original Message-
From: John B. White [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:19 AM
To: CF-Talk
Subject: Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC


Okay...slightly off topic, but this sounds like I should seriously consider
purchasing CF Studio?  Right now I hand code everything (since I'm trying to
learn).  What advantages are there to using Studio?

Currently I use:

1st Page 2000 by EvrSoft
- Which has some CF tags and the ability to add more...and is free!
Arachnophilia
- Also free and a nice little interface for Tidy HTML
Netscape Composer
- Yes it writes crappy code but for initial page layout, its quick and
simple.
And its free!

This is not a production environment.  I'm teaching myself CF so I can give
my
informatics students a taste of dynamic page generation and the use of a web
app
for patient information etc.  Suggestions on making this easier are welcome,
probably off list ([EMAIL PROTECTED]).

BTW, I've learned alot from watching this list and viewing the cfsnippits
of
posts.  :)

--JW

Earl, George wrote:

 Mark,

 You are right that HomeSite is a scaled down version of CF Studio,
although
 I like to think of it as CF Studio is a pumped up version of HomeSite . .
.

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

(ot) Talking JavaScript

[Owens, Howard]

I thought there was a list for CF programmers to get JavaScript help???

I was just looking on the HoF site and didn't see mention of it, so either
it isn't a HoF list or such list doesn't exist.

If there is a list, can sombody send me the subscribe info please --
[EMAIL PROTECTED]

H.



Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

Unwanted extraneous text being inserted by Studio 5?

[Lawrence B. Afrin, M.D.]

Howdy, folks --

A colleague of mine recently upgraded her CF Studio from 4.52 to 5 and
since then has noticed a couple of odd problems:

(1) On some File, Save operations, Studio 5 appears to have added in an
extraneous greater-than sign, changing a tdnbsp;/td sequence into
a tdnbsp;/td sequence.

(2) And on some other File, Save operations, Studio 5 appears to have
replaced a substantial chunk of the tail end of the file with an odd
string, tion/cfoutput23:09:13:13pm  02/06/20029:read only.  There's
really nowhere on her system that she could have accidentally picked up
this string via a copy-and-paste sort of operation.

If it makes a difference, she uses the Allaire FTP Service to move files
back and forth between the server and Studio.

I looked in the Studio section of the Forums, and though some folks have
made non-specific references to Studio 5 as being buggy, I haven't seen
this particular problem described.

Has anyone else encountered something like this yet with Studio 5?

-- Larry Afrin
   Med. Univ. of S.C.
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC

[Bryan Love]

I agree.  It simply can't be beat when it comes to speed and usability!

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may 
have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: CF-Talk
Subject: RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC


John,

CF Studio is like going from a hand saw to a chain saw.  It's the best 
tool
for hand coding I've ever used.

Mark

-Original Message-
From: John B. White [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:19 AM
To: CF-Talk
Subject: Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC


Okay...slightly off topic, but this sounds like I should seriously 
consider
purchasing CF Studio?  Right now I hand code everything (since I'm 
trying to
learn).  What advantages are there to using Studio?

Currently I use:

1st Page 2000 by EvrSoft
- Which has some CF tags and the ability to add more...and is free!
Arachnophilia
- Also free and a nice little interface for Tidy HTML
Netscape Composer
- Yes it writes crappy code but for initial page layout, its quick and
simple.
And its free!

This is not a production environment.  I'm teaching myself CF so I can 
give
my
informatics students a taste of dynamic page generation and the use of 
a web
app
for patient information etc.  Suggestions on making this easier are 
welcome,
probably off list ([EMAIL PROTECTED]).

BTW, I've learned alot from watching this list and viewing the 
cfsnippits
of
posts.  :)

--JW

Earl, George wrote:

 Mark,

 You are right that HomeSite is a scaled down version of CF Studio,
although
 I like to think of it as CF Studio is a pumped up version of HomeSite 
 .
.


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: (ot) Talking JavaScript

[Jeffry Houser]

  JS-Jive is listed on the House of Fusion site, but I believe it is a 
Yahoo list, not a HouseOfFusion one.
  I'm not actually on it, but I'm aware of it's existence.
  http://groups.yahoo.com/group/JS-Jive

  ( In my resolution, 1024 x 768 you do have to scroll to see the list on 
the house of fusion site with only the mailing lists menu item open )
  It looks a bit misleading because the line underneath NYCFUG is almost 
flush with the scroll bar on the bottom.


At 10:27 AM 02/07/2002 -0800, you wrote:
I thought there was a list for CF programmers to get JavaScript help???

I was just looking on the HoF site and didn't see mention of it, so either
it isn't a HoF list or such list doesn't exist.

If there is a list, can sombody send me the subscribe info please --
[EMAIL PROTECTED]

H.



Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: (ot) Talking JavaScript

[Joseph Thompson]

Try this one.. pretty good.

 You may unsubscribe anytime by sending a blank email to 
 [EMAIL PROTECTED] The message archives 
 are at http://groups.yahoo.com/group/JS-Jive/messages 


 I thought there was a list for CF programmers to get JavaScript help???

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Client Variables

[Shahzad.Butt]

Hi
 
I am using a DB for Clientvars. In cold fusion first I am setting 
CFSet Client.UserID = BlahBlah
 
Then after redirecting to certain pages I set
 
CFSet Client.Menuvar=Blah
 
But problem is that for same CFID in CGLOBAL table, coldfusion is
overriding previous data which is for UserID. So when I am using
Client.UserID afterwards it is getting Defaultone which i've set in root
circuit (Using CFParam) not the one I set it as it is being overridden.
I am using FB3. Can someone suggest me what exactly is going wrong with
it.
 
 
Thanks
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7763 114 328
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Client Variables

[Shahzad.Butt]

Hi
 
I am using a DB for Clientvars. In cold fusion first I am setting 
CFSet Client.UserID = BlahBlah
 
Then after redirecting to certain pages I set
 
CFSet Client.Menuvar=Blah
 
But problem is that for same CFID in CGLOBAL table, coldfusion is
overriding previous data which is for UserID. So when I am using
Client.UserID afterwards it is getting Defaultone which i've set in root
circuit (Using CFParam) not the one I set it as it is being overridden.
I am using FB3. Can someone suggest me what exactly is going wrong with
it.
 
 
Thanks
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7763 114 328
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Encrypting

[Douglas Brown]

What is the best way to encrypt a entire application?






There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Encrypting

[Steve Oliver]

Use cfencode with the /r flag, which means recursive, which will encrypt
all files in a folder, including subdirectories.

__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 2:28 PM
To: CF-Talk
Subject: Encrypting


What is the best way to encrypt a entire application?






There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: CF-based DNS Manager software beta

[Bill Davidson]

Hi James..  I am ONLY writing management software.  In the first release I
intend to support at LEAST MS's DNS Server.  I'll add others as needed.  I
would be surprised if we offer Bind support also in at least some version of
1.x.

Thanks for your interest.
-Bill
brainbox

- Original Message -
From: James Curran [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 10:39 AM
Subject: RE: CF-based DNS Manager software beta


 Are you building your own DNS server too or are you just building the CF
to
 integrate with Windows 2k's built in DNS?

 - j

 -Original Message-
 From: Bill Davidson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 11:39 PM
 To: CF-Talk
 Subject: CF-based DNS Manager software beta


 Hello.  I mentioned a few days ago that we've been developing CF-based DNS
 management.  I am looking for a small group of beta program participants.
 If you are interested, read on, otherwise please disregard this message.

 If you are interested:

 Please fill out the following form:
 http://www.brainbox.net/idnsm_beta/

 (excuse the form, its not pretty...;)  )

 Beta testers will be entitled to free 1.x software, and opt-in for future
 releases, and the likelihood of your feature requests being implemented
will
 be much greater.

 Thanks ya'll.

 -Bill
 brainbox

 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why?

[Gary Ashbaugh]

When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a
SmallDateTime SQL field, I get an error...why?


ERROR MESSAGE RECEIVED:

ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error,


COLDFUSION CODE:

   cfStoredProc datasource=#Source# Procedure=Add_FYSetup
cfprocparam  type=in cfsqltype=cf_sql_char dbvarname=@FY
value=#Session.CFY#
cfprocparam type=in  cfsqltype=cf_sql_Date dbvarname=@Due_Date
value=#DateFormat(NewDueDate, MM/DD/)#
cfprocparam type=in  cfsqltype=cf_sql_char
dbvarname=@Contact_Person value=#Contact_Person#
cfprocparam type=in  cfsqltype=cf_sql_char
dbvarname=@Contact_Phone value=#Contact_Phone#
cfprocparam type=Out  cfsqltype=cf_sql_integer dbvarname=@RetVal
variable=FYSetupRetVal
cfprocparam type=Out cfsqltype=cf_sql_char dbvarname=@RetMsg
variable=FYSetupRetMsg
cfprocresult name=SetupNewFY
   /cfstoredproc


SQL STORED PROCEDURE:

CREATE PROCEDURE [Add_FYSetup]
 (@FY nvarchar(4)=NULL,
 @Due_Date smalldatetime=NULL,
 @Contact_Person nvarchar(50)=NULL,
 @Contact_Phone nvarchar(14)=NULL,
 @RetVal int = NULL Output,
 @RetMsg nvarchar(100) = NULL Output)

AS...

Here is the database structure:

FY nvarchar(4)
Due_Date smalldatetime
Contact_Person nvarchar(50)
Contact_Phone nvarchar(14)



Gary

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: CF-based DNS Manager software beta

[Bill Davidson]

Odd.. Can you please try again and let me know if you can't get there?

Thanks.
-Bill
brainbox

- Original Message -
From: Rick Eidson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 9:44 AM
Subject: RE: CF-based DNS Manager software beta


 Can't get to the site. I have been talking with some others about
 building a
 webbased DNS control panel to handle hosting and Colo clients. I would
 like
 to see this.

 Rick

 -Original Message-
 From: Christopher Olive [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 8:37 AM
 To: CF-Talk
 Subject: RE: CF-based DNS Manager software beta


 does this work against 2000 or BIND servers?

 christopher olive, cto, vp of web development
 atnet solutions, inc.
 410.931.4092
 http://www.atnetsolutions.com


 -Original Message-
 From: Bill Davidson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 06, 2002 11:39 PM
 To: CF-Talk
 Subject: CF-based DNS Manager software beta


 Hello.  I mentioned a few days ago that we've been developing CF-based
 DNS
 management.  I am looking for a small group of beta program
 participants.
 If you are interested, read on, otherwise please disregard this
 message.

 If you are interested:

 Please fill out the following form:
 http://www.brainbox.net/idnsm_beta/

 (excuse the form, its not pretty...;)  )

 Beta testers will be entitled to free 1.x software, and opt-in for
 future
 releases, and the likelihood of your feature requests being implemented
 will
 be much greater.

 Thanks ya'll.

 -Bill
 brainbox


 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CF-based DNS Manager software beta

[Lee Fuller]

Bill,

Do take a look at SimpleDNS.  They're up and coming, and quite what
their name implies.  They are follow all RFC's that we could find, and
also use standard text files for entries/zones.

Just my .02 ...

 
Lee Fuller
Chief Technical Officer
PrimeDNA / AAA Web Hosting Corporations
 
 


| -Original Message-
| From: Bill Davidson [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, February 07, 2002 11:36 AM
| To: CF-Talk
| Subject: Re: CF-based DNS Manager software beta
| 
| 
| Hi James..  I am ONLY writing management software.  In the 
| first release I intend to support at LEAST MS's DNS Server.  
| I'll add others as needed.  I would be surprised if we offer 
| Bind support also in at least some version of 1.x.
| 
| Thanks for your interest.
| -Bill
| brainbox
| 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallD ateTime SQL Type...Why?

[Garza, Jeff]

Since you are using ODBC, try doing a CreateODBCDateTime(NewDueDate) and use
that as your date parameter.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 12:38 PM
To: CF-Talk
Subject: CFStoredProc cfsqltype=cf_sql_Date doesn't work with
SmallDateTime SQL Type...Why?


When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a
SmallDateTime SQL field, I get an error...why?


ERROR MESSAGE RECEIVED:

ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error,


COLDFUSION CODE:

   cfStoredProc datasource=#Source# Procedure=Add_FYSetup
cfprocparam  type=in cfsqltype=cf_sql_char dbvarname=@FY
value=#Session.CFY#
cfprocparam type=in  cfsqltype=cf_sql_Date dbvarname=@Due_Date
value=#DateFormat(NewDueDate, MM/DD/)#
cfprocparam type=in  cfsqltype=cf_sql_char
dbvarname=@Contact_Person value=#Contact_Person#
cfprocparam type=in  cfsqltype=cf_sql_char
dbvarname=@Contact_Phone value=#Contact_Phone#
cfprocparam type=Out  cfsqltype=cf_sql_integer dbvarname=@RetVal
variable=FYSetupRetVal
cfprocparam type=Out cfsqltype=cf_sql_char dbvarname=@RetMsg
variable=FYSetupRetMsg
cfprocresult name=SetupNewFY
   /cfstoredproc


SQL STORED PROCEDURE:

CREATE PROCEDURE [Add_FYSetup]
 (@FY nvarchar(4)=NULL,
 @Due_Date smalldatetime=NULL,
 @Contact_Person nvarchar(50)=NULL,
 @Contact_Phone nvarchar(14)=NULL,
 @RetVal int = NULL Output,
 @RetMsg nvarchar(100) = NULL Output)

AS...

Here is the database structure:

FY nvarchar(4)
Due_Date smalldatetime
Contact_Person nvarchar(50)
Contact_Phone nvarchar(14)



Gary


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Encrypting

[Douglas Brown]

I keep getting an invalid switch error.

I am doing this

C:\CFUSION\BINcfencode /r /2 c:\testfiles



There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown
- Original Message - 
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 11:22 AM
Subject: RE: Encrypting


 Use cfencode with the /r flag, which means recursive, which will 
encrypt
 all files in a folder, including subdirectories.
 
 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com
 
 
 -Original Message-
 From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, February 07, 2002 2:28 PM
 To: CF-Talk
 Subject: Encrypting
 
 
 What is the best way to encrypt a entire application?
 
 
 
 
 
 
 There are two major products that come out of Berkeley: LSD and [Unix] 

 BSD. We don't believe this to be a coincidence.
 
 
 
 Doug Brown
 
 
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

CF Studio Error: The Connection With The Server Was Reset

[E C list]

Hi Everyone,

I continue to have this problem with ColdFusion Studio
5 not being able to save to a particular server with
RDS.   When I try to save, I IMMEDIATELY get an error
message The Connection With The Server Was Reset.
Here are a few peculiar things about it:

1) I can open files and view databases on this server
with no trouble.

2) I have tried deleting and recreating the server
with a new name, same thing still happens.

3) A collegue of mine isn't having the same problem
with the same server.

4) The message comes up immediately and doesn't seem
to depend on what my RDS timeout settings are.

5) I've restarted my computer and the server.

Any ideas would be appreciated.

Thanks.

__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Encrypting

[Mark A. Kruger - CFG]

Doug - the /2 switch is not a valid switch.  If you are trying to do the
mandatory version switch its [ /v 2  ]

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:10 PM
To: CF-Talk
Subject: Re: Encrypting


I keep getting an invalid switch error.

I am doing this

C:\CFUSION\BINcfencode /r /2 c:\testfiles



There are two major products that come out of Berkeley: LSD and [Unix]
BSD. We don't believe this to be a coincidence.



Doug Brown
- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 11:22 AM
Subject: RE: Encrypting


 Use cfencode with the /r flag, which means recursive, which will
encrypt
 all files in a folder, including subdirectories.

 __
 steve oliver
 atnet solutions, inc.
 http://www.atnetsolutions.com


 -Original Message-
 From: Douglas Brown [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, February 07, 2002 2:28 PM
 To: CF-Talk
 Subject: Encrypting


 What is the best way to encrypt a entire application?






 There are two major products that come out of Berkeley: LSD and [Unix]

 BSD. We don't believe this to be a coincidence.



 Doug Brown




__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Looping...

[phumes1]

Below is a list of files which is generated from a database by selecting in 
input box from my index.cfm.

input type=Checkbox name=select value=[#GetFontFamily.ID#] 
#LCase(ListGetAt(GetFontFamily.sti,1,'.'))# checked=Yes required=Yes 
onclick=this.checked=true;font 
color=rednbsp;#LCase(ListGetAt(GetFontFamily.sti,1,'.'))#/fontbr
input type=hidden name=ID value=#GetFontFamily.ID#

  The results are then passed to another template with the below code:

 cfoutput
 #REReplace(FORM.select,,,br,ALL)#
 /cfoutput

Below are the results. My question is how can I use this listing to grab 
fields from my database that has the corresponding .pfb files
and display them based on matching the font name (Ex. century). I'm not 
sure how to go about this. Do I have to loop through the list?

[19] borderpi-15159
[22] bundesbahn-pi
[25] carta
[30] century
[197] custom
[196] euro
[58] european-pi
[69] garamond
[82] helvetica
[106] linotype-decoration-pi
[109] lucida-math-extension
[114] mathematical-pi
[127] old-style-seven
[178] symbol
[180] times
[181] times-serials
[192] wood-ornaments
[194] zapf-chancery-dingbats

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Weight Loss CFGRAGPH

[Robert Everland]

Does this app cost money. I don't see on the website where you can buy it,
just a free download. It looks nice, and would be cool to use, but I'll
stick with cfgraph for now if it costs anything.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:35 PM
To: CF-Talk
Subject: Re: Weight Loss CFGRAGPH


Although CFGRAPH is pretty cool and a welcome addition to ColdFusion, there
 are still quite a few limitations to that tag. This is one of them.

What you are wanting to do is to have two valuecolumns on the same chart, a
nd this is something that CFGRAPH does not do. What you can do is to create
 two graphs, one showing weight loss and the other weight goal. You would h
ave all the people in the database lumped into one chart for each category.
 The code example below gives you two charts, one on top of the other. If y
ou want to do some really cool things with charts and graphs, for now you w
ill need to get a third party charting application. The one we use here at 
Baylor is PopChart by Corda Technologies (www.corda.com). It is really good
 It is a JAVA application that runs on the web server (or any server for t
hat matter, you just have to point to it in your code). It works well with 
CFM, ASP, JSP and HTML.  It also comes with a cool builder tool that is als
o a JAVA application. You feed in the necessary parameters and it creates t
he necessary JavaScript for you.

Code example:

!--- Query the DB for the informaton ---
cfquery dataSource = SomeDSN Name = qSomeName
 Select *
 WeightLoss
 order By F_Name
 /cfquery

!--- Create the first graph ---
  cfgraph type=HORIZONTALBAR query=qSomeName valuecolumn=Weight
_Lost itemcolumn=F_Name showvaluelabel=Yes valuelabelfont=Arial
 valuelocation=ONBAR scaleto=300 itemlabelfont=Arial itemlabel
orientation=HORIZONTAL title=Weight Loss Progress Chart titlefont
=Arial fileformat=Flash depth=5 colorlist=red,green,blue,yel
low,orange
 /cfgraph
 
 !--- Create the second graph ---
 cfgraph type=HORIZONTALBAR query=qSomeName valuecolumn=Weight_
Goal itemcolumn=F_Name showvaluelabel=Yes valuelabelfont=Arial
 valuelocation=ONBAR scaleto=300 itemlabelfont=Arial itemlabelo
rientation=HORIZONTAL title=Weight Goal Progress Chart titlefont
=Arial fileformat=Flash depth=5 colorlist=red,green,blue,yel
low,orange
 /cfgraph

Another thing that you can do is to output the information into a table abo
ve the charts, and you can also make it a drill down chart, then you could 
pass in the User_ID parameter in the URL and create another chart for just 
the individual or a table with the necessary information.


--- Original Message --
From: Ann Harrell [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 7 Feb 2002 11:24:52 -0500

I'm in the thinking stage of a small project for a group of friends. I want

to keep it fairly simple. It would be in Access

Person1
WeightLost (bar graph)
WeightGoal

Person2
WeightLost
WeightGoal

and I would like to display this in cfgraph. Is this possible?

Ann Harrell, USA
Phone: 219.342.0618

A society that will trade a little liberty for a little order will lose
both, and deserve neither.
--- Thomas Jefferson, in a letter to Madison


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: CFContent Download Mime

[Steve Oliver]

I use the inline value, and it works fine for me, pops up a dialog to
open or save.

cfheader name=Content-Disposition 
 value=inline; filename='text.xls'

cfcontent type=application/msexcel
 file=e:\Inetpub\wwwroot\intranet\managersinvites.xls

If you don't use the cfheader, then the excel file will open in your
browser, but I still believe it will show the dialog box.

One problem I've run into, is if you reload the page that your trying to
display a new mime type on, it won't load right, just close your
browser, then open it back up, and type the URL in again.


__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com


-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 07, 2002 11:44 AM
To: CF-Talk
Subject: CFContent Download Mime


I've worked all morning on this, and can't figure this out. This is my 
first
time working with CFContent. 

When I load this page, the excel document loads in the browser (as 
text). I
would like to start a download, or just go ahead and load in IE as an 
Excel
document like a http://tflweb/managersinvites3.xls; call. What am I
missing?



Start Of Template 

cfheader name=Content-Disposition value=attachment;
filename='test.xls'

cfcontent type=application/vnd.ms-excel 
   deletefile=no 
   file=e:\Inetpub\wwwroot\intranet\managersinvites3.xls

End Of Template 


Start Display in Browser 
ÐÏࡱ
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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