Cybercash / Barclays in the UK

2002-01-04 Thread [EMAIL PROTECTED]

Hi all,

I have heard from some sources that the demise of cybercash has no effect on
e-commerce sites that are/were running the cfx tags to connect to that
system. Whereas Barclays EPDQ told me that they no longer accept connections
from CF sites at all.

Can anyone shed any light on this for me ?

Many thanks

Pete Dray

__
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: Cfcontent

2002-01-04 Thread [EMAIL PROTECTED]

I want to use cfcontent to serve up audio clips, problem is that the files
are not on the same machine as the cf server. It seems that cfcontent does
not like the use of shares or unc's to pick up the files. Can anyone confirm
that tihs does or does not work? I set up cd with an account and it can
browse the directories just fien and verifies the files with fileexists, but
it does not serve them through cfcontent.
__
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: Cybercash / Barclays in the UK

2002-01-04 Thread [EMAIL PROTECTED]

Peter if its any help try the uk cfug list or forums those guys should know
a lot more about this.

http://www.ukcfug.org/

For some reason the active mailing list is at
cfdeveloper.co.uk

HTH

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray

 
__
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: Cybercash / Barclays in the UK

2002-01-04 Thread Rich Wild

[EMAIL PROTECTED] 

may be more helpful. :)

 -Original Message-
 From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 10:06
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK
 
 
 Peter if its any help try the uk cfug list or forums those 
 guys should know
 a lot more about this.
 
 http://www.ukcfug.org/
 
 For some reason the active mailing list is at
 cfdeveloper.co.uk
 
 HTH
 
 Kola Oyedeji |Web Developer |ekeda
 elthorne gate |64 high street |pinner |middx |ha55qa
 t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
  -Original Message-
  From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 09:50
  To: CF-Talk
  Subject: Cybercash / Barclays in the UK
 
 
  Hi all,
 
  I have heard from some sources that the demise of cybercash
  has no effect on
  e-commerce sites that are/were running the cfx tags to 
 connect to that
  system. Whereas Barclays EPDQ told me that they no longer
  accept connections
  from CF sites at all.
 
  Can anyone shed any light on this for me ?
 
  Many thanks
 
  Pete Dray
 
  
 

__
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



Load Balancing a server??

2002-01-04 Thread [EMAIL PROTECTED]

Hi,
I have developed a large scale web site with SQL Server back end on a 
Windows platform.  I have suggested clustering two servers for the app.  
 What is the best practice for achieving this (Clustercats/load balancer 
etc etc)?  (all session vars etc are stored in a database).

TIA

Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:06
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


Peter if its any help try the uk cfug list or forums those guys should 
know
a lot more about this.

http://www.ukcfug.org/

For some reason the active mailing list is at
cfdeveloper.co.uk

HTH

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray

 

__
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: Cybercash / Barclays in the UK

2002-01-04 Thread [EMAIL PROTECTED]

thats the one ;-)

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 04 January 2002 10:08
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK


 [EMAIL PROTECTED]

 may be more helpful. :)

  -Original Message-
  From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 10:06
  To: CF-Talk
  Subject: RE: Cybercash / Barclays in the UK
 
 
  Peter if its any help try the uk cfug list or forums those
  guys should know
  a lot more about this.
 
  http://www.ukcfug.org/
 
  For some reason the active mailing list is at
  cfdeveloper.co.uk
 
  HTH
 
  Kola Oyedeji |Web Developer |ekeda
  elthorne gate |64 high street |pinner |middx |ha55qa
  t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
   -Original Message-
   From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
   [EMAIL PROTECTED]]
   Sent: 04 January 2002 09:50
   To: CF-Talk
   Subject: Cybercash / Barclays in the UK
  
  
   Hi all,
  
   I have heard from some sources that the demise of cybercash
   has no effect on
   e-commerce sites that are/were running the cfx tags to
  connect to that
   system. Whereas Barclays EPDQ told me that they no longer
   accept connections
   from CF sites at all.
  
   Can anyone shed any light on this for me ?
  
   Many thanks
  
   Pete Dray
  
  
 

 
__
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



System Design/Analysis

2002-01-04 Thread [EMAIL PROTECTED]

Hi, What is the standard for designing systems on the web?  I am 
thinking of UML techniques etc?  Software packages used?

TIA
Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:23
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


thats the one ;-)

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 04 January 2002 10:08
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK


 [EMAIL PROTECTED]

 may be more helpful. :)

  -Original Message-
  From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 10:06
  To: CF-Talk
  Subject: RE: Cybercash / Barclays in the UK
 
 
  Peter if its any help try the uk cfug list or forums those
  guys should know
  a lot more about this.
 
  http://www.ukcfug.org/
 
  For some reason the active mailing list is at
  cfdeveloper.co.uk
 
  HTH
 
  Kola Oyedeji |Web Developer |ekeda
  elthorne gate |64 high street |pinner |middx |ha55qa
  t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
   -Original Message-
   From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
   [EMAIL PROTECTED]]
   Sent: 04 January 2002 09:50
   To: CF-Talk
   Subject: Cybercash / Barclays in the UK
  
  
   Hi all,
  
   I have heard from some sources that the demise of cybercash
   has no effect on
   e-commerce sites that are/were running the cfx tags to
  connect to that
   system. Whereas Barclays EPDQ told me that they no longer
   accept connections
   from CF sites at all.
  
   Can anyone shed any light on this for me ?
  
   Many thanks
  
   Pete Dray
  
  
 

 

__
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: System Design/Analysis

2002-01-04 Thread Mike Connolly

I can highly recommend the Fusebox approach.

Hal Helms Wire Frame Manager and Dev Notes applications really help 
with the
development process.

Development Process at a glance.

* Produce detailed text-based specification (wire-frame) using Wire 
Frame
Manager
* Flesh-out wire-frame (prototype) with flat HTML to represent user
interfaces.
* Seek prototype final approval (prototype freeze)
* Build application using the fusebox infrastructure.

Visit www.fusebox.org or www.halhelms.com for more info.

-Original Message-
From: Nick Betts [EMAIL PROTECTED] [mailto:Nick Betts
[EMAIL PROTECTED]]
Sent: 04 January 2002 11:02
To: CF-Talk
Subject: System Design/Analysis


Hi, What is the standard for designing systems on the web?  I am 
thinking of UML techniques etc?  Software packages used?

TIA
Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:23
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


thats the one ;-)

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 04 January 2002 10:08
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK


 [EMAIL PROTECTED]

 may be more helpful. :)

  -Original Message-
  From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 10:06
  To: CF-Talk
  Subject: RE: Cybercash / Barclays in the UK
 
 
  Peter if its any help try the uk cfug list or forums those
  guys should know
  a lot more about this.
 
  http://www.ukcfug.org/
 
  For some reason the active mailing list is at
  cfdeveloper.co.uk
 
  HTH
 
  Kola Oyedeji |Web Developer |ekeda
  elthorne gate |64 high street |pinner |middx |ha55qa
  t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
   -Original Message-
   From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
   [EMAIL PROTECTED]]
   Sent: 04 January 2002 09:50
   To: CF-Talk
   Subject: Cybercash / Barclays in the UK
  
  
   Hi all,
  
   I have heard from some sources that the demise of cybercash
   has no effect on
   e-commerce sites that are/were running the cfx tags to
  connect to that
   system. Whereas Barclays EPDQ told me that they no longer
   accept connections
   from CF sites at all.
  
   Can anyone shed any light on this for me ?
  
   Many thanks
  
   Pete Dray
  
  
 

 


__
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 DB enquiries...

2002-01-04 Thread Jochem van Dieten

han peng wrote:

 Hi ppl, does anyone know wat kind of odbc/jdbc whatever etc, connection 
 does CF supports?
 
 Does CF works well with PostgreSQL? or MYSQL?
 
 i have used CF w/ oracle and mssql.. but due to budget contraints.. we r 
 looking into something cheaper..
 
 wat i know abt this 2 software..
 
 MySQL (fast but not very feature-complete, beta support for transactions 
 etc)
 
 PostgreSQL (slightly better cause got more features)
 
 so anyone hav any experience to share?

CF works very well with both PostgreSQL and MySQL. I would tend to 
recommend PostgreSQL because it is indeed more feature complete. But if 
you need to run it under Windows performance is not as fast as on *nix 
(due to the inability of Windows to handle process forking with decent 
overhead).
Connect through ODBC and it works just fine.

Jochem

__
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: Cfcontent performance issues?

2002-01-04 Thread Jochem van Dieten

Kay Smoljak wrote:

 Hi all,
 
 I was looking through the list archives at recommedations for protecting
 images - ie, not allowing images files to be called directly from the
 browser. The main recommendations seem to involve CFCONTENT. The site I
 will be working on will require this, and will also potentially be quite
 high traffic. I was wondering how well cfcontent works under load in
 situations like this.


In my experience: bad.



 Also, the other recommendation was to get the web server to handle this.
 I will be on IIS5 on Win2K, on shared hosting, but my host is usually
 quite accomodating when it comes to setting things up for me. How would
 you restrict calling images through IIS?


I wouldn't know how to get this to work, but if you can, go for it.

Jochem
__
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

2002-01-04 Thread Jochem van Dieten

Admin  wrote:

 I want to use cfcontent to serve up audio clips, problem is that the files
 are not on the same machine as the cf server. It seems that cfcontent does
 not like the use of shares or unc's to pick up the files. Can anyone confirm
 that tihs does or does not work? I set up cd with an account and it can
 browse the directories just fien and verifies the files with fileexists, but
 it does not serve them through cfcontent.


I recently came accross some information that indicates that cfcontent 
does not work from the main CF Application Service, but from inside the 
stub that is attached to the webserver. You might need to make sure that 
that one is having proper permissions on the share.

Jochem
__
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



CFGraphData

2002-01-04 Thread Shahzad Butt

Hi
 
In CFGraph is there anyway that we can avoid overlapping of Value in
CFGraphData. It happens if two values are at same level. I am using
valueLocation = overbar If i use onbar still it will not help me. I've
reduced the font as much as i can.
Highly appreciate any suggetion.
 
Regards
Shahzad Butt

__
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: Load Balancing a server - ADVICE REQUIRED

2002-01-04 Thread [EMAIL PROTECTED]

Hi,
I have developed a large scale web site with SQL Server back end on a 
Windows platform.  I have suggested clustering two servers for the app.  

 What is the best practice for achieving this (Clustercats/load balancer 

etc etc)?  (all session vars etc are stored in a database).

TIA

Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:06
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


Peter if its any help try the uk cfug list or forums those guys should 
know
a lot more about this.

http://www.ukcfug.org/

For some reason the active mailing list is at
cfdeveloper.co.uk

HTH

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray

 


__
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: Cybercash / Barclays in the UK

2002-01-04 Thread [EMAIL PROTECTED]

Peter

When they say they no longer accept connections from cf sites did they say
why is it for technical reasons?

Judging from some text on their site:

using the HTTP POST protocol from a known fixed URL to the server using
128 bit SSL. The storefront must also be capable of handling data returned
from ePDQ via the HTTP POST protocol.

You just need to securely post the details to one of their servers. Do they
actually check to determine if it was posted from a cf site? Perhaps they
have had problems receiving posts from cf sites using cfhttp?

Kola

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray

 
__
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: Jrun?

2002-01-04 Thread Kris Pilles

We are trying to decide if Jrun/Cf combo is an acceptable frontend
replacement for oracle's deveoper 2000.

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 03, 2002 5:49 PM
To: CF-Talk
Subject: Re: Jrun?


Yes, the ones that come with jrun are good. What kind of examples?
jsp,servlets,jms,ejb,technocrap

On Thu, 3 Jan 2002, Kris Pilles wrote:

 Anyone have any solid Jrun exmaples we can look at?  Not exactly sure 
 of
its
 capabilities...
 
 Kris Pilles
 Website Manager
 Western Suffolk BOCES
 507 Deer Park Rd., Building C
 Phone: 631-549-4900 x 267
 E-mail: [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



CFHTTP? was RE: Cybercash / Barclays in the UK

2002-01-04 Thread [EMAIL PROTECTED]

Thanks for the mails.

I talked to Barclays EPDQ and they said that yes, you can use Coldfusion but
they won't support it as nobody there knows anything about it. In fact
nobody there knows anything apart from Perl or ASP so that's handy!

Anyhow, they gave me the following code and said 'if you can translate that
to CF then you can use that'.

%
Const Request_POST = 1
Const Request_GET = 2
Set objTear = CreateObject(SOFTWING.ASPtear)
On Error Resume Next
Response.ContentType = text/html
Dim strEPDQ

strEPDQ = objTear.Retrieve( _
 http://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdqEncTool.e;, Request_POST,
_
 clientid=3password=pdchargetype=Authcurrencycode=826total=1.23, ,
)

If Err.Number  0 Then
   Response.Write b
   If Err.Number = 400 Then
  Response.Write Server returned error:   Err.Number
   Else
  Response.Write Component/WinInet error:   Err.Description
   End If
   Response.Write /b
   Response.End
End If
%

FORM action=https://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdq.e;
method=POST
%= strEPDQ %
INPUT type=hidden name=returnurl value=http://www.store.co.uk/;
INPUT type=hidden name=merchantdisplayname value=My Store
INPUT TYPE=submit VALUE=purchase
/FORM



Now, I'm not an ASP person whatsoever but to my layman eye this looks like a
job for a simple CFHTTP tag.

Am I right?

Pete



-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 12:51
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


Peter

When they say they no longer accept connections from cf sites did they say
why is it for technical reasons?

Judging from some text on their site:

using the HTTP POST protocol from a known fixed URL to the server using
128 bit SSL. The storefront must also be capable of handling data returned
from ePDQ via the HTTP POST protocol.

You just need to securely post the details to one of their servers. Do they
actually check to determine if it was posted from a cf site? Perhaps they
have had problems receiving posts from cf sites using cfhttp?

Kola

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray



__
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: CFHTTP? was RE: Cybercash / Barclays in the UK

2002-01-04 Thread Robert Everland

You are correct, it doesn't look too hard either.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 8:44 AM
To: CF-Talk
Subject: CFHTTP? was RE: Cybercash / Barclays in the UK


Thanks for the mails.

I talked to Barclays EPDQ and they said that yes, you can use Coldfusion but
they won't support it as nobody there knows anything about it. In fact
nobody there knows anything apart from Perl or ASP so that's handy!

Anyhow, they gave me the following code and said 'if you can translate that
to CF then you can use that'.

%
Const Request_POST = 1
Const Request_GET = 2
Set objTear = CreateObject(SOFTWING.ASPtear)
On Error Resume Next
Response.ContentType = text/html
Dim strEPDQ

strEPDQ = objTear.Retrieve( _
 http://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdqEncTool.e;, Request_POST,
_
 clientid=3password=pdchargetype=Authcurrencycode=826total=1.23, ,
)

If Err.Number  0 Then
   Response.Write b
   If Err.Number = 400 Then
  Response.Write Server returned error:   Err.Number
   Else
  Response.Write Component/WinInet error:   Err.Description
   End If
   Response.Write /b
   Response.End
End If
%

FORM action=https://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdq.e;
method=POST
%= strEPDQ %
INPUT type=hidden name=returnurl value=http://www.store.co.uk/;
INPUT type=hidden name=merchantdisplayname value=My Store
INPUT TYPE=submit VALUE=purchase
/FORM



Now, I'm not an ASP person whatsoever but to my layman eye this looks like a
job for a simple CFHTTP tag.

Am I right?

Pete



-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 12:51
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


Peter

When they say they no longer accept connections from cf sites did they say
why is it for technical reasons?

Judging from some text on their site:

using the HTTP POST protocol from a known fixed URL to the server using
128 bit SSL. The storefront must also be capable of handling data returned
from ePDQ via the HTTP POST protocol.

You just need to securely post the details to one of their servers. Do they
actually check to determine if it was posted from a cf site? Perhaps they
have had problems receiving posts from cf sites using cfhttp?

Kola

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 09:50
 To: CF-Talk
 Subject: Cybercash / Barclays in the UK


 Hi all,

 I have heard from some sources that the demise of cybercash
 has no effect on
 e-commerce sites that are/were running the cfx tags to connect to that
 system. Whereas Barclays EPDQ told me that they no longer
 accept connections
 from CF sites at all.

 Can anyone shed any light on this for me ?

 Many thanks

 Pete Dray




__
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 DB enquiries...

2002-01-04 Thread [EMAIL PROTECTED]

We use both SQL Server 2K and MySQL. I've found that there are slight
differences in syntax between the two and as you've already stated,
MySQL doesn't have the features that SQL Server has. The biggest one,
imo, is that MySQL doesn't support stored procedures, triggers, etc.
MySQL is probably a better alternative to MS Access with small sites.
But if you working on a large site with the potential of quite a bit of
traffic, I would stick with SQL Server or Oracle.

I understand budget constraints and the need to save wherever you can.
But... It's been my experience that when you try to go cheap where you
shouldn't, you'll end up spending more money in the long run when you
figure out that a cheap product just didn't scale and wasn't flexible
enough when you needed it to be. Not to mention the additional
development time to figure out work-arounds and fixes when the clients
are pissed off.

Mark



-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 10:29 PM
To: CF-Talk
Subject: CF DB enquiries...


Hi ppl, does anyone know wat kind of odbc/jdbc whatever etc, connection 
does CF supports?

Does CF works well with PostgreSQL? or MYSQL?

i have used CF w/ oracle and mssql.. but due to budget contraints.. we r

looking into something cheaper..

wat i know abt this 2 software..

MySQL (fast but not very feature-complete, beta support for transactions

etc)

PostgreSQL (slightly better cause got more features)

so anyone hav any experience to share?



thanx,

han



__
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 DB enquiries...

2002-01-04 Thread [EMAIL PROTECTED]

I've used CF with PostGres, MySql, Interbase and DB2 (as well as Access,
SQL7 - 2000 and Oracle of course).  The limitations are really specific to
the driver and the database platform - not CF, so whatever limitations your
DB or ODBC driver have naturally carry over.  Each of the DB platforms has
it's place - but I'd stick with MSSQL or Oracle if you can afford it.

Mark

-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 7:29 PM
To: CF-Talk
Subject: CF DB enquiries...


Hi ppl, does anyone know wat kind of odbc/jdbc whatever etc, connection
does CF supports?

Does CF works well with PostgreSQL? or MYSQL?

i have used CF w/ oracle and mssql.. but due to budget contraints.. we r
looking into something cheaper..

wat i know abt this 2 software..

MySQL (fast but not very feature-complete, beta support for transactions
etc)

PostgreSQL (slightly better cause got more features)

so anyone hav any experience to share?



thanx,

han


_
_

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
__
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: System Design/Analysis

2002-01-04 Thread [EMAIL PROTECTED]

I double Mike's suggestion. Although geared more toward the OO world,
the UML is very good to use. It's like flow-charting on steroids. Also,
if you follow the links that Mike provided, you'll find a link to the
Fusebox book which has a chapter on fuseML which is an abstract of the
UML.

Visio and a plain 'ol white board are very helpful also.

Mark



-Original Message-
From: Mike Connolly [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 6:09 AM
To: CF-Talk
Subject: RE: System Design/Analysis


I can highly recommend the Fusebox approach.

Hal Helms Wire Frame Manager and Dev Notes applications really help 
with the
development process.

Development Process at a glance.

* Produce detailed text-based specification (wire-frame) using Wire 
Frame
Manager
* Flesh-out wire-frame (prototype) with flat HTML to represent user
interfaces.
* Seek prototype final approval (prototype freeze)
* Build application using the fusebox infrastructure.

Visit www.fusebox.org or www.halhelms.com for more info.

-Original Message-
From: Nick Betts [EMAIL PROTECTED] [mailto:Nick Betts
[EMAIL PROTECTED]]
Sent: 04 January 2002 11:02
To: CF-Talk
Subject: System Design/Analysis


Hi, What is the standard for designing systems on the web?  I am 
thinking of UML techniques etc?  Software packages used?

TIA
Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:23
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


thats the one ;-)

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 04 January 2002 10:08
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK


 [EMAIL PROTECTED]

 may be more helpful. :)

  -Original Message-
  From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 10:06
  To: CF-Talk
  Subject: RE: Cybercash / Barclays in the UK
 
 
  Peter if its any help try the uk cfug list or forums those
  guys should know
  a lot more about this.
 
  http://www.ukcfug.org/
 
  For some reason the active mailing list is at
  cfdeveloper.co.uk
 
  HTH
 
  Kola Oyedeji |Web Developer |ekeda
  elthorne gate |64 high street |pinner |middx |ha55qa
  t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
   -Original Message-
   From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
   [EMAIL PROTECTED]]
   Sent: 04 January 2002 09:50
   To: CF-Talk
   Subject: Cybercash / Barclays in the UK
  
  
   Hi all,
  
   I have heard from some sources that the demise of cybercash
   has no effect on
   e-commerce sites that are/were running the cfx tags to
  connect to that
   system. Whereas Barclays EPDQ told me that they no longer
   accept connections
   from CF sites at all.
  
   Can anyone shed any light on this for me ?
  
   Many thanks
  
   Pete Dray
  
  
 

 



__
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: CFGraphData

2002-01-04 Thread [EMAIL PROTECTED]

Have you tried different values for the barspacing attribute of cfgraph?
Try that and see what you get.

Mark



-Original Message-
From: Shahzad Butt [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 6:43 AM
To: CF-Talk
Subject: CFGraphData


Hi
 
In CFGraph is there anyway that we can avoid overlapping of Value in
CFGraphData. It happens if two values are at same level. I am using
valueLocation = overbar If i use onbar still it will not help me. 
I've
reduced the font as much as i can.
Highly appreciate any suggetion.
 
Regards
Shahzad Butt


__
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: Lost ODBC/Native Driver Connectivity

2002-01-04 Thread [EMAIL PROTECTED]

you may want to try rebooting in MS-DOS mode; when you get the prompt, 
enter 'scanreg / restore' to restore the system registry to the last 
successful reboot.
  - Original Message - 
  From: David Hannum (Ohio University) 
  To: CF-Talk 
  Sent: Thursday, January 03, 2002 8:28 PM
  Subject: Lost ODBC/Native Driver Connectivity


  OK - a strange one here.  We have CF 5.0 on NT 4.0 SP6 running with 
JRun 2x
  and Netscape Enterprise 3.6.  The first of each quarter, the box gets
  hammered for students searching the Course Offerings.  Today, the 
first day
  of classes for winter, was no exception.  About noon, the box seemed 
to hang
  up.  Now, course offerings is a Java application on JRun.  However, we 
have
  a login through DCE using a home brewed proxy that feeds through a CF
  Process for the authentication and login on the box.  Now - when the 
server
  hung up, the system administrator had to reboot it.  From that time 
forth, I
  no longer have ODBC or Native Drivers for working for my Oracle 8 
database.
  I've rebooted the machine time and time again, I've checked and double
  checked everything.  We changed nothing, but still no connectivity 
through
  CF.  The Oracle SQL Workshop works, so I know the ODBC on the box is 
OK.
  The course offerings work through JDBC, so I know the TNSNames.ora 
file is
  OK.  CF runs, but can't find any of my datasources.  Does anybody have 
a
  clue what to check.  If nothing comes up, I'm going to have to 
reinstall CF
  first thing in the morning.

  Thanks,
  Dave

  
__
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



CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

Anyone have a tool in ColdFusion that will import a text file in to a
database?  Already looked on the Developer's Exchange (sure is slow lately)
and didn't find anything that will work.  Just looking for something that
will parse and import a text file of comma seperated values in to a SQL
database.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
__
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



remote ACCESS manipulation

2002-01-04 Thread [EMAIL PROTECTED]

looking for any existing script/tool anyone can recommend that allows form
based creation/manipulation/editing of access databases... Cold Fusion based
of course..

Anyone have such a tool available?

-paris

__
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: CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

Can't you just set it up as an obdc source in CF5?

Do a dynamic link to the file and bingo.

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, January 04, 2002 2:26 PM
To: CF-Talk
Subject:CSV File Importer

Anyone have a tool in ColdFusion that will import a text file in to a
database?  Already looked on the Developer's Exchange (sure is slow lately)
and didn't find anything that will work.  Just looking for something that
will parse and import a text file of comma seperated values in to a SQL
database.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer

__
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: CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

Have you checked out CFComet.com?
If not this will give you information on how to setup a datasource for 
an Excel file.

Regards,
Declan

-Original Message-
From:  [mailto:Adam Reynolds [EMAIL PROTECTED]]
Sent: 04 January 2002 14:31
To: CF-Talk
Subject: RE: CSV File Importer


Can't you just set it up as an obdc source in CF5?

Do a dynamic link to the file and bingo.

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, January 04, 2002 2:26 PM
To: CF-Talk
Subject:CSV File Importer

Anyone have a tool in ColdFusion that will import a text file in to a
database?  Already looked on the Developer's Exchange (sure is slow 
lately)
and didn't find anything that will work.  Just looking for something 
that
will parse and import a text file of comma seperated values in to a SQL
database.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer


__
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: CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

I usually do it with some code, using the new connectstring attribute in CF
5 to create a connection to the text file on the fly:

CFQUERY NAME=rs
 DBTYPE=dynamic
 CONNECTSTRING=Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=C:\myfolder;Extensions=asc,csv,tab,txt;Persist Security
Info=False;
SELECT myfield1, myfield2 from myfile.csv
/CFQUERY

cfloop query=rs
CFQUERY NAME=TEST2
 DATASOURCE=mydsn
INSERT INTO mytable(myfield1, myfield2) VALUES
('#rs.myfield1#','#rs.myfield2#')
/CFQUERY
/cfloop

tom
www.basic-ultradev.com

Bernd VanSkiver [EMAIL PROTECTED] wrote in message
001901c1952b$b37ab3e0$[EMAIL PROTECTED]">news:001901c1952b$b37ab3e0$[EMAIL PROTECTED]...
 Anyone have a tool in ColdFusion that will import a text file in to a
 database?  Already looked on the Developer's Exchange (sure is slow
lately)
 and didn't find anything that will work.  Just looking for something that
 will parse and import a text file of comma seperated values in to a SQL
 database.

 Bernd VanSkiver
 [EMAIL PROTECTED]
 ColdFusion Developer
 
__
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: CSV File Importer

2002-01-04 Thread dave fauth

use bcp built into ms-sql

At 08:25 AM 1/4/2002 -0600, you wrote:
Anyone have a tool in ColdFusion that will import a text file in to a
database?  Already looked on the Developer's Exchange (sure is slow lately)
and didn't find anything that will work.  Just looking for something that
will parse and import a text file of comma seperated values in to a SQL
database.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer

__
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: CSV File Importer

2002-01-04 Thread Scott Mulholland

There is a csvtoquery custom tag that you can read the file with that 
puts
it into a query result set.  You can than easily insert the results 
into a
db.

-Original Message-
From: Declan Maher [EMAIL PROTECTED] [mailto:Declan
Maher [EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 9:32 AM
To: CF-Talk
Subject: RE: CSV File Importer


Have you checked out CFComet.com?
If not this will give you information on how to setup a datasource for 
an Excel file.

Regards,
Declan

-Original Message-
From:  [mailto:Adam Reynolds [EMAIL PROTECTED]]
Sent: 04 January 2002 14:31
To: CF-Talk
Subject: RE: CSV File Importer


Can't you just set it up as an obdc source in CF5?

Do a dynamic link to the file and bingo.

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, January 04, 2002 2:26 PM
To: CF-Talk
Subject:CSV File Importer

Anyone have a tool in ColdFusion that will import a text file in to a
database?  Already looked on the Developer's Exchange (sure is slow 
lately)
and didn't find anything that will work.  Just looking for something 
that
will parse and import a text file of comma seperated values in to a SQL
database.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer



__
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: System Design/Analysis

2002-01-04 Thread [EMAIL PROTECTED]

 Hi, What is the standard for designing systems on the web?  I am
 thinking of UML techniques etc?  Software packages used?

I think the most time-honoured answer is not ;-)

Seriously though, UML is definitely the standard these days, and if you
want software tools for it then I can recommend ArgoUML - it's a little
buggy and incomplete but it has one *big* advantage over the market
leader, Rational Rose - the price is right.

But if you're working with relational databases like most CF people, then
in my opinion the single most valuable technique at your disposal is
entity modelling (logical data modelling, E-R modelling). Like another
comparatively old-fashioned technique, dataflow modelling, it helps you
turn requirements into software by imposing a discipline on your thought
process. UML doesn't do that so much, it's more of a blank slate.

Personally, fwiw, I only find UML useful for documenting Java/C++
programs. For website analysis and design I use entity modelling combined
with a homegrown HTTP-oriented variant of dataflow modelling.

Nick





__
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: System Design/Analysis

2002-01-04 Thread [EMAIL PROTECTED]

cheers nick.

-Original Message-
From: Nick de Voil [EMAIL PROTECTED] [mailto:Nick de Voil
[EMAIL PROTECTED]]
Sent: 04 January 2002 14:58
To: CF-Talk
Subject: Re: System Design/Analysis


 Hi, What is the standard for designing systems on the web?  I am
 thinking of UML techniques etc?  Software packages used?

I think the most time-honoured answer is not ;-)

Seriously though, UML is definitely the standard these days, and if you
want software tools for it then I can recommend ArgoUML - it's a little
buggy and incomplete but it has one *big* advantage over the market
leader, Rational Rose - the price is right.

But if you're working with relational databases like most CF people, 
then
in my opinion the single most valuable technique at your disposal is
entity modelling (logical data modelling, E-R modelling). Like another
comparatively old-fashioned technique, dataflow modelling, it helps you
turn requirements into software by imposing a discipline on your thought
process. UML doesn't do that so much, it's more of a blank slate.

Personally, fwiw, I only find UML useful for documenting Java/C++
programs. For website analysis and design I use entity modelling 
combined
with a homegrown HTTP-oriented variant of dataflow modelling.

Nick






__
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: CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

Is the syntax correct on that ConnectString?  It is not working for me,
tells me the datasource is not found.

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
- Original Message -
From: Thomas Muck [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:36 AM
Subject: Re: CSV File Importer


 I usually do it with some code, using the new connectstring attribute in
CF
 5 to create a connection to the text file on the fly:

 CFQUERY NAME=rs
  DBTYPE=dynamic
  CONNECTSTRING=Driver={Microsoft Text Driver (*.txt;
 *.csv)};Dbq=C:\myfolder;Extensions=asc,csv,tab,txt;Persist Security
 Info=False;
 SELECT myfield1, myfield2 from myfile.csv
 /CFQUERY

 cfloop query=rs
 CFQUERY NAME=TEST2
  DATASOURCE=mydsn
 INSERT INTO mytable(myfield1, myfield2) VALUES
 ('#rs.myfield1#','#rs.myfield2#')
 /CFQUERY
 /cfloop

 tom
 www.basic-ultradev.com

 Bernd VanSkiver [EMAIL PROTECTED] wrote in message
 001901c1952b$b37ab3e0$[EMAIL PROTECTED]">news:001901c1952b$b37ab3e0$[EMAIL PROTECTED]...
  Anyone have a tool in ColdFusion that will import a text file in to a
  database?  Already looked on the Developer's Exchange (sure is slow
 lately)
  and didn't find anything that will work.  Just looking for something
that
  will parse and import a text file of comma seperated values in to a SQL
  database.
 
  Bernd VanSkiver
  [EMAIL PROTECTED]
  ColdFusion Developer
 
 
__
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



cf frames question

2002-01-04 Thread [EMAIL PROTECTED]

Hello,
sorry haven't had enough coffee this morning yet so I can't think of 
what to use to do this.

I'm trying to detect frames which I figure javascript for that part 
unless theres away with cold fusion but the problem is I need cold 
fusion to know if there is frames and to set a global varible if there 
is.

give you my situation maybe someone can give me an easyier solution.

we have a website that sells coins but also can have dealers that sell 
coins and because of IE6 not excepting 3rd party cookies by default it 
doesn't set the dealer var and defaults to main site which is bad cause 
then the viewer is at the main site now and not the dealer site.

so I figue if I can detect the frames then set a dealer var every page 
instead of passing it to every link a person can click on.

but problem I'm having is CF runs before javascript so I need to figure 
out a way to detect the frames so I can set the dealer ID to know which 
dealer this is.

Thanks in advance
Troy Montour

__
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



CF Prorating Based Date Expression

2002-01-04 Thread [EMAIL PROTECTED]

Hello,

I am looking to calculate based on the HireDate vs. the YearBegin Date.

Ex: employee was hired 1/1/2002 which is YearBegin Date and shall therefore 
be calculated at 12/12 or 100%.

Ex2: employee was hired on 2/1/2002 versus YearBegin of 1/1/2002 and 
therefore calculations should be based on 11/12 or 91.6%

Example 3 (where it gets hairy or at least hairier): is where employee was 
hired on 2/2/2002 and therefore should calculate at 10/12 since he wasn't 
there for the 1st.

I was trying to use DateCompare() and then saw DateDiff() but they don's 
seem to differentiate between another month based on the day not being the 
first, ie. DateDiff is saying that 2/1/2002 is 1 month past 1/1/2002 and it 
also says that 2/2/2002 is also 1 month past, instead of 2.

Any ideas on to how I should proceed with this would be greatly appreciated.

Thanks,

Dave

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
__
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: System Design/Analysis

2002-01-04 Thread Tim Stadinski

Rational Rose for UML.  MVC design approach.  You can think of boundary
classes as web pages (forms), controllers as CFM templates or CF custom
tags, and entity classes as stored procedures/cf templates with 
cfquery.
that way you seperate display, biz logic, and storage.  as for your
framework to use, that depends on the level of your team.  i think once 
you
have laid out your plans and architecture for your site, the framework 
will
fall into place.

let me know your questions.

cheers,

Timothy Stadinski
Senior Software Engineer
Afternic.com
[EMAIL PROTECTED]


-Original Message-
From: Nick Betts [EMAIL PROTECTED] [mailto:Nick Betts
[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 6:02 AM
To: CF-Talk
Subject: System Design/Analysis


Hi, What is the standard for designing systems on the web?  I am 
thinking of UML techniques etc?  Software packages used?

TIA
Nick

-Original Message-
From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
[EMAIL PROTECTED]]
Sent: 04 January 2002 10:23
To: CF-Talk
Subject: RE: Cybercash / Barclays in the UK


thats the one ;-)

Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk


 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 04 January 2002 10:08
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK


 [EMAIL PROTECTED]

 may be more helpful. :)

  -Original Message-
  From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 10:06
  To: CF-Talk
  Subject: RE: Cybercash / Barclays in the UK
 
 
  Peter if its any help try the uk cfug list or forums those
  guys should know
  a lot more about this.
 
  http://www.ukcfug.org/
 
  For some reason the active mailing list is at
  cfdeveloper.co.uk
 
  HTH
 
  Kola Oyedeji |Web Developer |ekeda
  elthorne gate |64 high street |pinner |middx |ha55qa
  t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
   -Original Message-
   From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
   [EMAIL PROTECTED]]
   Sent: 04 January 2002 09:50
   To: CF-Talk
   Subject: Cybercash / Barclays in the UK
  
  
   Hi all,
  
   I have heard from some sources that the demise of cybercash
   has no effect on
   e-commerce sites that are/were running the cfx tags to
  connect to that
   system. Whereas Barclays EPDQ told me that they no longer
   accept connections
   from CF sites at all.
  
   Can anyone shed any light on this for me ?
  
   Many thanks
  
   Pete Dray
  
  
 

 


__
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 frames question

2002-01-04 Thread [EMAIL PROTECTED]

I would do something like this.

Have a form with a hidden field that defaults a form variable (framesEnabled
= false)
Use Javascript to set framesEnabled = true if (self != top)
Submit the form using Javascript and voila, form.framesenabled will let you
know.

This is of course assuming that the user has Javascript turned on.



-Original Message-
From: Troy Montour [EMAIL PROTECTED] [mailto:Troy Montour
[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 10:27 AM
To: CF-Talk
Subject: cf frames question


Hello,
sorry haven't had enough coffee this morning yet so I can't think of
what to use to do this.

I'm trying to detect frames which I figure javascript for that part
unless theres away with cold fusion but the problem is I need cold
fusion to know if there is frames and to set a global varible if there
is.

give you my situation maybe someone can give me an easyier solution.

we have a website that sells coins but also can have dealers that sell
coins and because of IE6 not excepting 3rd party cookies by default it
doesn't set the dealer var and defaults to main site which is bad cause
then the viewer is at the main site now and not the dealer site.

so I figue if I can detect the frames then set a dealer var every page
instead of passing it to every link a person can click on.

but problem I'm having is CF runs before javascript so I need to figure
out a way to detect the frames so I can set the dealer ID to know which
dealer this is.

Thanks in advance
Troy Montour


__
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 frames question

2002-01-04 Thread [EMAIL PROTECTED]

Sandy,
That wouldn't work since this needs to load every page after the first
or it gets reset to the default dealer which is the main site.

so I need away to pull the frame url out so I can parse the url and set it
for CF to use.

Thanks though
Troy

- Original Message -
From: Sandy Clark [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 9:56 AM
Subject: RE: cf frames question


 I would do something like this.

 Have a form with a hidden field that defaults a form variable
(framesEnabled
 = false)
 Use Javascript to set framesEnabled = true if (self != top)
 Submit the form using Javascript and voila, form.framesenabled will let
you
 know.

 This is of course assuming that the user has Javascript turned on.



 -Original Message-
 From: Troy Montour [EMAIL PROTECTED] [mailto:Troy Montour
 [EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 10:27 AM
 To: CF-Talk
 Subject: cf frames question


 Hello,
 sorry haven't had enough coffee this morning yet so I can't think of
 what to use to do this.

 I'm trying to detect frames which I figure javascript for that part
 unless theres away with cold fusion but the problem is I need cold
 fusion to know if there is frames and to set a global varible if there
 is.

 give you my situation maybe someone can give me an easyier solution.

 we have a website that sells coins but also can have dealers that sell
 coins and because of IE6 not excepting 3rd party cookies by default it
 doesn't set the dealer var and defaults to main site which is bad cause
 then the viewer is at the main site now and not the dealer site.

 so I figue if I can detect the frames then set a dealer var every page
 instead of passing it to every link a person can click on.

 but problem I'm having is CF runs before javascript so I need to figure
 out a way to detect the frames so I can set the dealer ID to know which
 dealer this is.

 Thanks in advance
 Troy Montour


 
__
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: Developers Edition Coming

2002-01-04 Thread Matt Brown

I am really glad you all are happy about this rumor, there are a lot of us 
here that worked on this. I think Macromedia in general has to take any 
compliments and not any one in particular.

I would like to add though that the fact that people posted this when 
before there was an announcement is a little disheartening and an 
illustration of why we are getting closer with our information. If someone 
sends you an announcement with a date of availability some time in the 
future, rather than post that mail, please ask if it is OK to talk about. 
In this case it was *not* OK to post. There are loose ends that are not 
tied up and now there are a lot of questions that we are not going to be 
able to answer till the official announce date and that is just going to 
frustrate people.

We are working to get you what you want and the information you need. If 
you are one of our partners and are privy to information before the general 
public, please work with us and not independently of us.
_

Matt Brown   Community Manager
Macromedia  (650) 481-4525   [EMAIL PROTECTED]

FAQ: http://www.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 performance issues?

2002-01-04 Thread Dave Watts

 I was looking through the list archives at recommedations 
 for protecting images - ie, not allowing images files to 
 be called directly from the browser. The main recommendations 
 seem to involve CFCONTENT. The site I will be working on 
 will require this, and will also potentially be quite high 
 traffic. I was wondering how well cfcontent works under load 
 in situations like this.

It's going to run every request through CF, which is going to significantly
increase the amount of work CF has to do. The same issue comes up with
regular HTML pages - if you want to force authorization using CF, you might
map .html to be processed by CF, but there's a serious performance penalty.

You can address this by either finding an alternative that doesn't require
runtime processing (with CF or any other CGI tool), or by ensuring that your
CF servers can handle the load by getting more and/or bigger ones.

 Also, the other recommendation was to get the web server to handle 
 this. I will be on IIS5 on Win2K, on shared hosting, but my host is 
 usually quite accomodating when it comes to setting things up for me. 
 How would you restrict calling images through IIS? Does it involve 
 setting the image file types to be handled by the CF server, so 
 Application.cfm is called before each? Is this better (in terms of 
 performance) than using CFCONTENT for the same purpose?

To the best of my knowledge, the only way to get IIS to handle this for you
is to set the appropriate permissions on each image file, and have IIS force
authentication against requests for those files. There's very little
overhead in that, but it would require that you have a Windows account for
the user to use, and it wouldn't directly integrate with your application,
in the sense that the user would get a browser authentication popup window.

You might be able to do something better by writing an ISAPI extension (or
looking for an existing ISAPI extension) which checks for the existence of
some token (a cookie or URL variable, for example) before allowing the
request to be processed. I haven't written any ISAPI extensions myself, and
suspect it's a bit more complicated than most CF programming, but I'd guess
that it would perform better for this specific task.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
__
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



Problems with ArrayNew()

2002-01-04 Thread Nicholas_A . _Valentino

Morning all,

I am currently having a problem with ArrayNew(), and I was wondering if
anyone has seen something similar.  Currently, I have a ColdFusion page
that verifies a large amount of data pulled from a database.  To initialize
the arrays that will be used for this validation, a CFSCRIPT statement is
used.  Within this script, approximately 1,500 arrays are created to
support the validation (just wait, it gets better... ;-) ).  Now, this work
99% of the time.  However, whenever it does not work, it returns a 13 page
error to the user which displays the following message:


An error occurred while evaluating the expression:
insert 13 pages of array declaration here
Error near line 436, column 45.

Parameter 1 of function ArrayNew which is now 1 must be an integer.


The line where the error occurs changes every time this occurs.  This leads
me to believe that ColdFusion is having a problem either processing the
file, or it can not allocate enough memory to complete the request and
defaults to this error message.  Additionally, the code executed within
this file has not been changed for this release, it just started to occur.
As for the ColdFusion server configuration, it is maintained by another
contractor so we have no idea what is configured and how.

Now obviously, declaring 1,500 individual arrays is probably not the best
method to perform this task, however this is an inherited piece of code and
re-development would take too long at this point in my current release
cycle.  I was just curious if someone had seen something like this in the
past, and if so, how did you get around it.  As always, any creative and
positive ideas on the subject are appreciated.

Thanks for your time,
Nick
__
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



ArcIMS

2002-01-04 Thread [EMAIL PROTECTED]

Anyone here using ArcIMS for mapping?

Here is the situation:

2 Servers.

Server 1 - App Server (just needed to process the map requests)

Server 2 - Web Server (Cold Fusion etc)



The install documentation leaves me with quite a few questions. Based on 
the above server layout, I am unsure of which components need to be 
installed where.

Also, 

I know that on of the components requires a Servlet engine. Does CF 
support Servlets? In other words when i specify a directory path to my 
servlet engine will CFusion\Jrun\servlets suffice?

any and all help would be greatly appreciated!

If you would like to get in contact with me directly please do so on MSN 
Messenger ([EMAIL PROTECTED])

Thanks,

-chris.alvarado
[application developer]
4|Guys Interactive, Inc.

http://www.4guys.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: CFGraphData

2002-01-04 Thread Shahzad Butt

Yeah I did, but its not helping me. Cos my values are quite long 4343434.43
so max barspacing will not work either.

-Original Message-
From: Mark.Stewart [EMAIL PROTECTED]@shanks.nildram.co.uk
[mailto:Mark.Stewart; [EMAIL PROTECTED]@shanks.nildram.co.uk] 
Sent: 04 January 2002 14:06
To: CF-Talk
Subject: RE: CFGraphData


Have you tried different values for the barspacing attribute of cfgraph? Try
that and see what you get.

Mark



-Original Message-
From: Shahzad Butt [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 6:43 AM
To: CF-Talk
Subject: CFGraphData


Hi
 
In CFGraph is there anyway that we can avoid overlapping of Value in
CFGraphData. It happens if two values are at same level. I am using
valueLocation = overbar If i use onbar still it will not help me. 
I've
reduced the font as much as i can.
Highly appreciate any suggetion.
 
Regards
Shahzad Butt



__
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: CSV File Importer

2002-01-04 Thread [EMAIL PROTECTED]

Yes.  I have an article on the subject of connection strings at
http://www.basic-ultradev.com/articles/dsnlesscoldfusion

Only works in CF5 though.

tom

Bernd VanSkiver [EMAIL PROTECTED] wrote in message
003f01c19530$6d90a790$[EMAIL PROTECTED]">news:003f01c19530$6d90a790$[EMAIL PROTECTED]...
 Is the syntax correct on that ConnectString?  It is not working for me,
 tells me the datasource is not found.



__
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 frames question

2002-01-04 Thread [EMAIL PROTECTED]

Depending on how you set up your dealers, a simple URL variable is all you
need
www.whatever.com/index.cfm?id=1234  Your dealers can set this up in their
link to the main website. Do all of your checking of who the dealer is by
the ID url variable.. You could even set a session variable based on a
referer url as well. There are many ways to do it and without specifically
knowing how your dealers are getting to the site, there is no set way of
doing things...

Jeff


- Original Message -
From: Troy Montour [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:27 AM
Subject: cf frames question


 Hello,
 sorry haven't had enough coffee this morning yet so I can't think of
 what to use to do this.

 I'm trying to detect frames which I figure javascript for that part
 unless theres away with cold fusion but the problem is I need cold
 fusion to know if there is frames and to set a global varible if there
 is.

 give you my situation maybe someone can give me an easyier solution.

 we have a website that sells coins but also can have dealers that sell
 coins and because of IE6 not excepting 3rd party cookies by default it
 doesn't set the dealer var and defaults to main site which is bad cause
 then the viewer is at the main site now and not the dealer site.

 so I figue if I can detect the frames then set a dealer var every page
 instead of passing it to every link a person can click on.

 but problem I'm having is CF runs before javascript so I need to figure
 out a way to detect the frames so I can set the dealer ID to know which
 dealer this is.

 Thanks in advance
 Troy Montour

 
__
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: Developers Edition Coming

2002-01-04 Thread [EMAIL PROTECTED]

Matt Brown wrote:

 I would like to add though that the fact that people posted this when
 before there was an announcement is a little disheartening and an
 illustration of why we are getting closer with our information.

Not realizing it was a rumor or not officially announced yet (seeing it come
from a Macromedia Partner certainly seemed official), then let me be the
first to apologize for posting that on another webdev mailing list after it
came through on this one.

I guess the fact that I hadn't received it from any of the Macromedia lists
should have been a clue . . . .

Sorry about that.

Scott
--
Scott Brady
http://www.scottbrady.net/

__
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: ArcIMS

2002-01-04 Thread [EMAIL PROTECTED]

Chris:

ColdFusion 5 uses JRun internally for various features (mostly
administrative in nature, e.g., the CF Management Service) but that copy 
of
JRun is a license-limited version and (haven't really tried to test this,
though) is not available for use by external apps, i.e., you couldn't dro
p
your own servlets in and expect them to run.  You'd need either to instal
l a
separate copy of JRun or to install another servlet engine as needed (e.g
,
Tomcat/Catalina from the Apache group).

ColdFusion can run servlets directly on a JRun engine (Don't know if it's
limited to JRun or would work with any servlet, though) using the
CFSERVLET and CFSERVLETPARAM tags, with JRun running on either the lo
cal
(CF) host or on a remote host.  You could also call a servlet using the
CFHTTP tag if you wanted to.

Regards,
Joel Parramore


 -Original Message-
 From: chris.alvarado [mailto:; [EMAIL PROTECTED]@homes.com]
 Sent: Friday, January 04, 2002 11:13 AM
 To: CF-Talk
 Subject: ArcIMS


 Anyone here using ArcIMS for mapping?

 Here is the situation:

 2 Servers.

 Server 1 - App Server (just needed to process the map requests)

 Server 2 - Web Server (Cold Fusion etc)

 

 The install documentation leaves me with quite a few questions. Based o
n
 the above server layout, I am unsure of which components need to be
 installed where.

 Also,

 I know that on of the components requires a Servlet engine. Does CF
 support Servlets? In other words when i specify a directory path to my
 servlet engine will CFusion\Jrun\servlets suffice?

 any and all help would be greatly appreciated!

 If you would like to get in contact with me directly please do so on MS
N
 Messenger ([EMAIL PROTECTED])

 Thanks,

 -chris.alvarado
 [application developer]
 4|Guys Interactive, Inc.
 
 http://www.4guys.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: cf frames question

2002-01-04 Thread [EMAIL PROTECTED]

Jeff,
yes this would be great if that was possible..  because what happens is
a cookie gets set to set your session so we don't have to pass information
from page to page so after the first page you lose the url ID and since IE6
is harder on cookies it never gets set so our code sets a default if it
can't find your session cause it thinks this is the first time you have came
to the site.

which is fine if you are at the default site but at a dealer site this will
not work and since I no longer have the url settings after the first page I
can't pull it from there any longer.

but since it seems I can't find an easyier way to detect this information I
will have to go to every page and set the url settings for every link
somebody can click on. which is going to take me awhile to do.

Thanks though
Troy

- Original Message -
From: Development Team [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:20 AM
Subject: Re: cf frames question


 Depending on how you set up your dealers, a simple URL variable is all you
 need
 www.whatever.com/index.cfm?id=1234  Your dealers can set this up in their
 link to the main website. Do all of your checking of who the dealer is by
 the ID url variable.. You could even set a session variable based on a
 referer url as well. There are many ways to do it and without specifically
 knowing how your dealers are getting to the site, there is no set way of
 doing things...

 Jeff


 - Original Message -
 From: Troy Montour [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:27 AM
 Subject: cf frames question


  Hello,
  sorry haven't had enough coffee this morning yet so I can't think of
  what to use to do this.
 
  I'm trying to detect frames which I figure javascript for that part
  unless theres away with cold fusion but the problem is I need cold
  fusion to know if there is frames and to set a global varible if there
  is.
 
  give you my situation maybe someone can give me an easyier solution.
 
  we have a website that sells coins but also can have dealers that sell
  coins and because of IE6 not excepting 3rd party cookies by default it
  doesn't set the dealer var and defaults to main site which is bad cause
  then the viewer is at the main site now and not the dealer site.
 
  so I figue if I can detect the frames then set a dealer var every page
  instead of passing it to every link a person can click on.
 
  but problem I'm having is CF runs before javascript so I need to figure
  out a way to detect the frames so I can set the dealer ID to know which
  dealer this is.
 
  Thanks in advance
  Troy Montour
 
 
 
__
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: vspider --- help please

2002-01-04 Thread [EMAIL PROTECTED]

Ok... I've made some serious with this crazy spider, but I'm still a bit
stuck.

1) What the hell is up with remapping the style guide?
http://www.daemon.com.au/navitron/display.cfm?objectid=5B7F8B4D-4260-4C46-A5
431EC7DDC5A06E

I mean, it works... but that's just weird.

2) Sometimes, when I run a query, it finds the right # of items but returns
them as empty sets. So, let's say I run a search for Blah -- it'll find 4
instances of it on the site, but when it displays the results, I'll see 4
items that are devoid of any of the expected info (title, URL, summary,
etc...)

Anyone have any insight?


Thanks,
-- jon

---
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 4:13 PM
To: CF-Talk
Subject: RE: vspider --- help please


Your site must use relative links _and_ be addressable using the Localhost
address.

1) Configure your website so that the below address works...

http://localhost/index.cfm (using IIS just add the 127.0.0.1 IP and use the
Host Header of Localhost)  Localhost is the only address I've been able to
get the spider to recognize.

2) ensure that all links from that page are relative ala:

a href=myotherpage.cfm or a href=mysubfolder/index.cfm

Anylink with a FQDN (like www.mysite.com) in it will fail.

I must admit that this limitation makes using the spider a bear...

I'm currently investigating the purchase of the full spider from Verity as
what is included can't do very much...  We also run multiple sites and I'm
currently rotating which address responds to localhost manually when I
spider it (usually weekly), but this gets tedious...

Anyone else have other input???

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.


-Original Message-
From: jon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 1:50 PM
To: CF-Talk
Subject: RE: vspider --- help please


Ok... the spider is driving me friggin' insane.

The spectrum astro docs were good enough to get me started, but I'll be
darned if I can get it to spider my site.

Here's the issue -- we've got multiple IP addresses on a single machine. I
was able to create the collection alright, but I can't get it to spider the
site itself, as it thinks that it's going off site when I try to make it
spider the site by either IP address or URL.

Any tips? Can I make it start at my index.cfm and work from there somehow?

Thanks,
-- jon

-
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:25 AM
To: CF-Talk
Subject: RE: vspider --- help please


Ben,

Try going to the online docs at the old allaire site...

http://www.allaire.com/developer/documentation/coldfusion.cfm

Download the Advanced ColdFusion Administration manual in .pdf format.
It
should have a complete section on the advanced Verity stuff (K2 Server
documentation, VSpider, etc...  It can be a bit cryptic but is for the
most
part complete.)

Also for a somewhat complete presentation about setting up the K2
Server and
VSpider, check out http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ben Whalley
To: CF-Talk
Sent: 1/2/02 4:19 AM
Subject: RE: vspider --- help please

Can someone point me to some info on using vspider - does it come
bundled
with the CF? Sounds just like what I've been looking for.

Ben

 --
 From: Garza, Jeff
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, December 28, 2001 10:59 PM
 To:   CF-Talk
 Subject:  RE: vspider --- help please

 From what I've been able to find, it will only spider the localhost
 address
 space.  You'll have to set the site in question to respond to
localhost
 _and_ make sure that you are using only relative links...

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



 -Original Message-
 From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, December 28, 2001 2:51 PM
 To: CF-Talk
 Subject: RE: vspider --- help please


 Thank you.
 One more question, for the moment, has anyone had sucess using the
verity
 spider with multiple sites with different IP's on the same server?
Is
 this
 going to be possible or will it only allow the localhost, servername,

or
 127.0.0.1.

 Thanks

 Sean

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]]
 Sent: Friday, December 28, 2001 4:37 PM
 To: '[EMAIL PROTECTED]'
 Cc: Sean McCarthy
 Subject: RE: vspider --- help please


  I thought I had it all working was I wrong.  The vspider
  is great but... I have multiple sites on the same box with
  different IP's. Technically in my eyes they are all local
  but I cannot find a way to get the spider to go through the
  site.  I even tried the same IP with different port 

RE: CF Prorating Based Date Expression

2002-01-04 Thread [EMAIL PROTECTED]

Do you only want to prorate by month?  If I understand your question, you
can do it pretty easy down to the day.  Look at the DayofYear() function.
Something like this should work:

CFSCRIPT

if(IsLeapYear(Year(HireDate))) {
daysInYear = 366;
}else{
daysInYear = 365;
}

YearPartEmployed = (daysInYear-DayofYear(HireDate))/daysInYear;

/CFSCRIPT

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software





 -Original Message-
 From: David D [EMAIL PROTECTED] [mailto:David D
 [EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 10:33 AM
 To: CF-Talk
 Subject: CF Prorating Based Date Expression


 Hello,

 I am looking to calculate based on the HireDate vs. the YearBegin Date.

 Ex: employee was hired 1/1/2002 which is YearBegin Date and shall
 therefore
 be calculated at 12/12 or 100%.

 Ex2: employee was hired on 2/1/2002 versus YearBegin of 1/1/2002 and
 therefore calculations should be based on 11/12 or 91.6%

 Example 3 (where it gets hairy or at least hairier): is where
 employee was
 hired on 2/2/2002 and therefore should calculate at 10/12 since he wasn't
 there for the 1st.

 I was trying to use DateCompare() and then saw DateDiff() but they don's
 seem to differentiate between another month based on the day not
 being the
 first, ie. DateDiff is saying that 2/1/2002 is 1 month past
 1/1/2002 and it
 also says that 2/2/2002 is also 1 month past, instead of 2.

 Any ideas on to how I should proceed with this would be greatly
 appreciated.

 Thanks,

 Dave

 _
 Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.

__
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: Developers Edition Coming

2002-01-04 Thread [EMAIL PROTECTED]

Not official If it is posted on your website, I would say that is pre
tty
official, wouldnt you.




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



Doug Brown
- Original Message -
From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:21 AM
Subject: Re: Developers Edition Coming


 Matt Brown wrote:

  I would like to add though that the fact that people posted this when
  before there was an announcement is a little disheartening and an
  illustration of why we are getting closer with our information.

 Not realizing it was a rumor or not officially announced yet (seeing it
come
 from a Macromedia Partner certainly seemed official), then let me be th
e
 first to apologize for posting that on another webdev mailing list afte
r
it
 came through on this one.

 I guess the fact that I hadn't received it from any of the Macromedia
lists
 should have been a clue . . . .

 Sorry about that.

 Scott
 --
 Scott Brady
 http://www.scottbrady.net/

 
__
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: Developers Edition Coming

2002-01-04 Thread Michael Dinowitz

But was it posted to a public part of the website or a private part. We 
know from past experience that anything on the beta site is private and 
should not be talked about. We also know that anything you can get to on 
the public site without needing a password or breaking in is 'public'.  The
 
first I heard of this was a post to this list. I didn't see it on their 
site anywhere so I didn't add it in as a FA news item (yet). If you saw it
 
on their site could you send me the link? Thanks

At 12:08 PM 1/4/02, you wrote:
Not official If it is posted on your website, I would say that is pre
tty
official, wouldnt you.




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



Doug Brown
- Original Message -
From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:21 AM
Subject: Re: Developers Edition Coming


  Matt Brown wrote:
 
   I would like to add though that the fact that people posted this when
   before there was an announcement is a little disheartening and an
   illustration of why we are getting closer with our information.
 
  Not realizing it was a rumor or not officially announced yet (seeing it
come
  from a Macromedia Partner certainly seemed official), then let me be th
e
  first to apologize for posting that on another webdev mailing list afte
r
it
  came through on this one.
 
  I guess the fact that I hadn't received it from any of the Macromedia
lists
  should have been a clue . . . .
 
  Sorry about that.
 
  Scott
  --
  Scott Brady
  http://www.scottbrady.net/
 
 

__
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: Developers Edition Coming

2002-01-04 Thread [EMAIL PROTECTED]

Quite public.

http://www.macromedia.com/software/coldfusion/trial/faq/





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



Doug Brown
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:57 AM
Subject: Re: Developers Edition Coming


 But was it posted to a public part of the website or a private part. We
 know from past experience that anything on the beta site is private and
 should not be talked about. We also know that anything you can get to o
n
 the public site without needing a password or breaking in is 'public'.
The

 first I heard of this was a post to this list. I didn't see it on their
 site anywhere so I didn't add it in as a FA news item (yet). If you saw
 it

 on their site could you send me the link? Thanks

 At 12:08 PM 1/4/02, you wrote:
 Not official If it is posted on your website, I would say that is 
pre
 tty
 official, wouldnt you.
 
 
 
 
 There are two major products that come out of Berkeley: LSD and [Unix]
 BS
 D.
 We don't believe this to be a coincidence.
 
 
 
 Doug Brown
 - Original Message -
 From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 8:21 AM
 Subject: Re: Developers Edition Coming
 
 
   Matt Brown wrote:
  
I would like to add though that the fact that people posted this
when
before there was an announcement is a little disheartening and an
illustration of why we are getting closer with our information.
  
   Not realizing it was a rumor or not officially announced yet (seein
g
it
 come
   from a Macromedia Partner certainly seemed official), then let me b
e
th
 e
   first to apologize for posting that on another webdev mailing list
afte
 r
 it
   came through on this one.
  
   I guess the fact that I hadn't received it from any of the Macromed
ia
 lists
   should have been a clue . . . .
  
   Sorry about that.
  
   Scott
   --
   Scott Brady
   http://www.scottbrady.net/
  
  
 
 
__
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: remote ACCESS manipulation

2002-01-04 Thread [EMAIL PROTECTED]

Paris,

All I can tell you is that there is such a tool.  Some marketing for it
passed through my mailbox about a year ago.  Unfortunately that's all I can
remember (geesh I'm helpful). ;-)

Just wanted to at least let you know that someone has already gone through
the trouble to create it ;-)

I think there is at least 1 site out there that lets users create and
manipulate simple DBs (now it may be Access and it may be some proprietary
stuff).  So a trip to Google may be in order.

Good luck

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: Paris Lundis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 6:28 AM
Subject: remote ACCESS manipulation


 looking for any existing script/tool anyone can recommend that allows form
 based creation/manipulation/editing of access databases... Cold Fusion
based
 of course..

 Anyone have such a tool available?

 -paris

 
__
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 Prorating Based Date Expression

2002-01-04 Thread [EMAIL PROTECTED]

I did it like this and was able to get it to work, now I am just curious as 
to whether this is the most efficient(or just efficient) way
to do it.

!---Begin ProRated Calculation Code---
!---Variable Initialization---
cfset Month=#DatePart('m',GetDate.HireDate)#
hrCFSwitch Expression=Month::#Month#hr
!---IF Day is 1 determine Month then set Multiplier---
cfif GetDate.HireDate is not  and DatePart('d',GetDate.HireDate) is 1
CFSwitch expression=#Month#
cfcase value=1
cfset Multiplier=12/12
#Multiplier#
/cfcase
cfcase value=2
cfset Multiplier=11/12
#Multiplier#
/cfcasecfcase value=3
cfset Multiplier=10/12
#Multiplier#
/cfcasecfcase value=4
cfset Multiplier=9/12
#Multiplier#
/cfcasecfcase value=5
cfset Multiplier=8/12
#Multiplier#
/cfcasecfcase value=6
cfset Multiplier=7/12
#Multiplier#
/cfcasecfcase value=7
cfset Multiplier=6/12
#Multiplier#
/cfcasecfcase value=8
cfset Multiplier=5/12
#Multiplier#
/cfcasecfcase value=9
cfset Multiplier=4/12
#Multiplier#
/cfcasecfcase value=10
cfset Multiplier=3/12
#Multiplier#
/cfcasecfcase value=11
cfset Multiplier=2/12
#Multiplier#
/cfcasecfcase value=12
cfset Multiplier=1/12
#Multiplier#
/cfcase
/cfswitch
!---IF Day is 2 or Greater determine Month then set Multiplier---
cfelse
CFSwitch expression=#Month#
cfcase value=1
cfset Multiplier=11/12
#Multiplier#
/cfcase
cfcase value=2
cfset Multiplier=10/12
#Multiplier#
/cfcasecfcase value=3
cfset Multiplier=9/12
#Multiplier#
/cfcasecfcase value=4
cfset Multiplier=8/12
#Multiplier#
/cfcasecfcase value=5
cfset Multiplier=7/12
#Multiplier#
/cfcasecfcase value=6
cfset Multiplier=6/12
#Multiplier#
/cfcasecfcase value=7
cfset Multiplier=5/12
#Multiplier#
/cfcasecfcase value=8
cfset Multiplier=4/12
#Multiplier#
/cfcasecfcase value=9
cfset Multiplier=3/12
#Multiplier#
/cfcasecfcase value=10
cfset Multiplier=2/12
#Multiplier#
/cfcasecfcase value=11
cfset Multiplier=1/12
#Multiplier#
/cfcase
/cfswitch
/cfif
/cfoutput
!---End ProRated Calculation Code---


From: Cameron Childress [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: CF Prorating Based Date Expression
Date: Fri, 4 Jan 2002 11:41:48 -0500

Do you only want to prorate by month?  If I understand your question, you
can do it pretty easy down to the day.  Look at the DayofYear() function.
Something like this should work:

CFSCRIPT

if(IsLeapYear(Year(HireDate))) {
   daysInYear = 366;
}else{
   daysInYear = 365;
}

YearPartEmployed = (daysInYear-DayofYear(HireDate))/daysInYear;

/CFSCRIPT

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software





  -Original Message-
  From: David D [EMAIL PROTECTED] [mailto:David D
  [EMAIL PROTECTED]]
  Sent: Friday, January 04, 2002 10:33 AM
  To: CF-Talk
  Subject: CF Prorating Based Date Expression
 
 
  Hello,
 
  I am looking to calculate based on the HireDate vs. the YearBegin Date.
 
  Ex: employee was hired 1/1/2002 which is YearBegin Date and shall
  therefore
  be calculated at 12/12 or 100%.
 
  Ex2: employee was hired on 2/1/2002 versus YearBegin of 1/1/2002 and
  therefore calculations should be based on 11/12 or 91.6%
 
  Example 3 (where it gets hairy or at least hairier): is where
  employee was
  hired on 2/2/2002 and therefore should calculate at 10/12 since he 
wasn't
  there for the 1st.
 
  I was trying to use DateCompare() and then saw DateDiff() but they don's
  seem to differentiate between another month based on the day not
  being the
  first, ie. DateDiff is saying that 2/1/2002 is 1 month past
  1/1/2002 and it
  also says that 2/2/2002 is also 1 month past, instead of 2.
 
  Any ideas on to how I should proceed with this would be greatly
  appreciated.
 
  Thanks,
 
  Dave
 
  _
  Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.


__
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: remote ACCESS manipulation

2002-01-04 Thread [EMAIL PROTECTED]

Check thisout Paris:
http://devex.allaire.com/developer/gallery/info.cfm?ID=17292760-8E39-11D4
-83E100508B94F85Amethod=Full

watch for wrapping...

HTH
Clint

-- Original Message --
from: Paris Lundis [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 4 Jan 2002 09:28:15 -0500

looking for any existing script/tool anyone can recommend that allows form
based creation/manipulation/editing of access databases... Cold Fusion base
d
of course..

Anyone have such a tool available?

-paris


__
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: Developers Edition Coming

2002-01-04 Thread [EMAIL PROTECTED]

Seems there is a bit of a miscommunication within Macromedia.  The left hand
doesn't seem to know what the right hand is doing.  H.

Anthony

 -Original Message-
 From: Douglas Brown [EMAIL PROTECTED] [mailto:Douglas Brown
 [EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 12:16 PM
 To: CF-Talk
 Subject: Re: Developers Edition Coming


 Quite public.

 http://www.macromedia.com/software/coldfusion/trial/faq/





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



 Doug Brown
 - Original Message -
 From: Michael Dinowitz [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 8:57 AM
 Subject: Re: Developers Edition Coming


  But was it posted to a public part of the website or a private part. We
  know from past experience that anything on the beta site is private and
  should not be talked about. We also know that anything you can get to o
 n
  the public site without needing a password or breaking in is 'public'.
 The
 
  first I heard of this was a post to this list. I didn't see it on their
  site anywhere so I didn't add it in as a FA news item (yet). If you saw
  it
 
  on their site could you send me the link? Thanks
 
  At 12:08 PM 1/4/02, you wrote:
  Not official If it is posted on your website, I would say that is
 pre
  tty
  official, wouldnt you.
  
  
  
  
  There are two major products that come out of Berkeley: LSD and [Unix]
  BS
  D.
  We don't believe this to be a coincidence.
  
  
  
  Doug Brown
  - Original Message -
  From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 8:21 AM
  Subject: Re: Developers Edition Coming
  
  
Matt Brown wrote:
   
 I would like to add though that the fact that people posted this
 when
 before there was an announcement is a little disheartening and an
 illustration of why we are getting closer with our information.
   
Not realizing it was a rumor or not officially announced yet (seein
 g
 it
  come
from a Macromedia Partner certainly seemed official), then let me b
 e
 th
  e
first to apologize for posting that on another webdev mailing list
 afte
  r
  it
came through on this one.
   
I guess the fact that I hadn't received it from any of the Macromed
 ia
  lists
should have been a clue . . . .
   
Sorry about that.
   
Scott
--
Scott Brady
http://www.scottbrady.net/
   
   
  
 
 
__
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: Developers Edition Coming

2002-01-04 Thread Michael Dinowitz

I believe that the only change is in the language of the license. As stated
 
in the FAQ, the developer edition is not licensed for deployment. I don't 
know the exacts of the announcement but I'm sure there's something 
different, probably a change there. Until it happens, anything I say is 
speculation.

 The Developer Edition is a free version of ColdFusion Server 5 
that you may use indefinitely. It has all the features
 of ColdFusion 5 Enterprise Edition, except that it is not licensed
 
for deployment and can be accessed by a single IP
 address only.
At 12:16 PM 1/4/02, you wrote:
Quite public.

http://www.macromedia.com/software/coldfusion/trial/faq/





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



Doug Brown
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 8:57 AM
Subject: Re: Developers Edition Coming


  But was it posted to a public part of the website or a private part. We
  know from past experience that anything on the beta site is private and
  should not be talked about. We also know that anything you can get to o
n
  the public site without needing a password or breaking in is 'public'.
The
 
  first I heard of this was a post to this list. I didn't see it on their
  site anywhere so I didn't add it in as a FA news item (yet). If you saw
  it
 
  on their site could you send me the link? Thanks
 
  At 12:08 PM 1/4/02, you wrote:
  Not official If it is posted on your website, I would say that is
pre
  tty
  official, wouldnt you.
  
  
  
  
  There are two major products that come out of Berkeley: LSD and [Unix]
  BS
  D.
  We don't believe this to be a coincidence.
  
  
  
  Doug Brown
  - Original Message -
  From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 8:21 AM
  Subject: Re: Developers Edition Coming
  
  
Matt Brown wrote:
   
 I would like to add though that the fact that people posted this
when
 before there was an announcement is a little disheartening and an
 illustration of why we are getting closer with our information.
   
Not realizing it was a rumor or not officially announced yet (seein
g
it
  come
from a Macromedia Partner certainly seemed official), then let me b
e
th
  e
first to apologize for posting that on another webdev mailing list
afte
  r
  it
came through on this one.
   
I guess the fact that I hadn't received it from any of the Macromed
ia
  lists
should have been a clue . . . .
   
Sorry about that.
   
Scott
--
Scott Brady
http://www.scottbrady.net/
   
   
  
 

__
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: vspider --- help please

2002-01-04 Thread Sean McCarthy

2. Is this only happening after you have refreshed a index?  Are you using
K2?  If so I have found that you must restart the k2 service to get it to
properly output results.  After a update of the index it does not seem to
be necessary to restart the service.

Any luck with more than one IP or are you still mapping the site over to the
base ip of the box?

Thanks

Sean

-Original Message-
From: jon [EMAIL PROTECTED] [mailto:jon; [EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 11:43 AM
To: CF-Talk
Subject: RE: vspider --- help please


Ok... I've made some serious with this crazy spider, but I'm still a bit
stuck.

1) What the hell is up with remapping the style guide?
http://www.daemon.com.au/navitron/display.cfm?objectid=5B7F8B4D-4260-4C46-A5
431EC7DDC5A06E

I mean, it works... but that's just weird.

2) Sometimes, when I run a query, it finds the right # of items but returns
them as empty sets. So, let's say I run a search for Blah -- it'll find 4
instances of it on the site, but when it displays the results, I'll see 4
items that are devoid of any of the expected info (title, URL, summary,
etc...)

Anyone have any insight?


Thanks,
-- jon

---
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 4:13 PM
To: CF-Talk
Subject: RE: vspider --- help please


Your site must use relative links _and_ be addressable using the Localhost
address.

1) Configure your website so that the below address works...

http://localhost/index.cfm (using IIS just add the 127.0.0.1 IP and use the
Host Header of Localhost)  Localhost is the only address I've been able to
get the spider to recognize.

2) ensure that all links from that page are relative ala:

a href=myotherpage.cfm or a href=mysubfolder/index.cfm

Anylink with a FQDN (like www.mysite.com) in it will fail.

I must admit that this limitation makes using the spider a bear...

I'm currently investigating the purchase of the full spider from Verity as
what is included can't do very much...  We also run multiple sites and I'm
currently rotating which address responds to localhost manually when I
spider it (usually weekly), but this gets tedious...

Anyone else have other input???

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.


-Original Message-
From: jon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 1:50 PM
To: CF-Talk
Subject: RE: vspider --- help please


Ok... the spider is driving me friggin' insane.

The spectrum astro docs were good enough to get me started, but I'll be
darned if I can get it to spider my site.

Here's the issue -- we've got multiple IP addresses on a single machine. I
was able to create the collection alright, but I can't get it to spider the
site itself, as it thinks that it's going off site when I try to make it
spider the site by either IP address or URL.

Any tips? Can I make it start at my index.cfm and work from there somehow?

Thanks,
-- jon

-
jon roig
epilepsyfoundation.org



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:25 AM
To: CF-Talk
Subject: RE: vspider --- help please


Ben,

Try going to the online docs at the old allaire site...

http://www.allaire.com/developer/documentation/coldfusion.cfm

Download the Advanced ColdFusion Administration manual in .pdf format.
It
should have a complete section on the advanced Verity stuff (K2 Server
documentation, VSpider, etc...  It can be a bit cryptic but is for the
most
part complete.)

Also for a somewhat complete presentation about setting up the K2
Server and
VSpider, check out http://www.spectrumastro.com/veritydemo/index.cfm

Good Luck,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]

-Original Message-
From: Ben Whalley
To: CF-Talk
Sent: 1/2/02 4:19 AM
Subject: RE: vspider --- help please

Can someone point me to some info on using vspider - does it come
bundled
with the CF? Sounds just like what I've been looking for.

Ben

 --
 From: Garza, Jeff
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, December 28, 2001 10:59 PM
 To:   CF-Talk
 Subject:  RE: vspider --- help please

 From what I've been able to find, it will only spider the localhost
 address
 space.  You'll have to set the site in question to respond to
localhost
 _and_ make sure that you are using only relative links...

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



 -Original Message-
 From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, December 28, 2001 2:51 PM
 To: CF-Talk
 Subject: RE: vspider --- help please


 Thank you.
 One more question, for the moment, has anyone had sucess using the
verity
 spider with multiple sites with different IP's on the same server?
Is
 this
 going to be possible or will it only allow the 

Re: Developers Edition Coming

2002-01-04 Thread [EMAIL PROTECTED]

Yeah I suspect that the higher ups are not communicating to the lower dow
ns.
Either that or their developer that is in charge of website updating deci
ded
to go it on his/her own and inform the public.




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



Doug Brown
- Original Message -
From: Anthony.Abby  [EMAIL PROTECTED]@lamx01.mgw.rr.com
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 9:08 AM
Subject: RE: Developers Edition Coming


 Seems there is a bit of a miscommunication within Macromedia.  The left
hand
 doesn't seem to know what the right hand is doing.  H.

 Anthony

  -Original Message-
  From: Douglas Brown [EMAIL PROTECTED] [mailto:Douglas Brown
  [EMAIL PROTECTED]]
  Sent: Friday, January 04, 2002 12:16 PM
  To: CF-Talk
  Subject: Re: Developers Edition Coming
 
 
  Quite public.
 
  http://www.macromedia.com/software/coldfusion/trial/faq/
 
 
 
 
 
  There are two major products that come out of Berkeley: LSD and [Unix
]
BS
  D.
  We don't believe this to be a coincidence.
 
 
 
  Doug Brown
  - Original Message -
  From: Michael Dinowitz [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 8:57 AM
  Subject: Re: Developers Edition Coming
 
 
   But was it posted to a public part of the website or a private part.
We
   know from past experience that anything on the beta site is private
and
   should not be talked about. We also know that anything you can get 
to
o
  n
   the public site without needing a password or breaking in is 'publi
c'.
  The
  
   first I heard of this was a post to this list. I didn't see it on
their
   site anywhere so I didn't add it in as a FA news item (yet). If you
saw
   it
  
   on their site could you send me the link? Thanks
  
   At 12:08 PM 1/4/02, you wrote:
   Not official If it is posted on your website, I would say that
 is
  pre
   tty
   official, wouldnt you.
   
   
   
   
   There are two major products that come out of Berkeley: LSD and
[Unix]
   BS
   D.
   We don't believe this to be a coincidence.
   
   
   
   Doug Brown
   - Original Message -
   From: Scott.Brady  [EMAIL PROTECTED]@lamx01.mgw.rr.com

   To: CF-Talk [EMAIL PROTECTED]
   Sent: Friday, January 04, 2002 8:21 AM
   Subject: Re: Developers Edition Coming
   
   
 Matt Brown wrote:

  I would like to add though that the fact that people posted t
his
  when
  before there was an announcement is a little disheartening an
d
an
  illustration of why we are getting closer with our informatio
n.

 Not realizing it was a rumor or not officially announced yet
(seein
  g
  it
   come
 from a Macromedia Partner certainly seemed official), then let 
me
b
  e
  th
   e
 first to apologize for posting that on another webdev mailing l
ist
  afte
   r
   it
 came through on this one.

 I guess the fact that I hadn't received it from any of the
Macromed
  ia
   lists
 should have been a clue . . . .

 Sorry about that.

 Scott
 --
 Scott Brady
 http://www.scottbrady.net/


   
  
 
 
__
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 frames question

2002-01-04 Thread [EMAIL PROTECTED]

This limits your options but you can eliminate the cookie and keep session
state.

Set this on your all your links and you can keep session..

myinternallink.cfm?CFID=#CFID#CFToken=#CFToken#

That will keep session... Use this
cflocation url=myinternallink.cfm addtoken=yes

Pain in the butt, but you should be able to keep session state like this

HTH
Jeff

- Original Message -
From: Troy Montour [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 11:34 AM
Subject: Re: cf frames question


 Jeff,
 yes this would be great if that was possible..  because what happens
is
 a cookie gets set to set your session so we don't have to pass information
 from page to page so after the first page you lose the url ID and since
IE6
 is harder on cookies it never gets set so our code sets a default if it
 can't find your session cause it thinks this is the first time you have
came
 to the site.

 which is fine if you are at the default site but at a dealer site this
will
 not work and since I no longer have the url settings after the first page
I
 can't pull it from there any longer.

 but since it seems I can't find an easyier way to detect this information
I
 will have to go to every page and set the url settings for every link
 somebody can click on. which is going to take me awhile to do.

 Thanks though
 Troy

 - Original Message -
 From: Development Team [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:20 AM
 Subject: Re: cf frames question


  Depending on how you set up your dealers, a simple URL variable is all
you
  need
  www.whatever.com/index.cfm?id=1234  Your dealers can set this up in
their
  link to the main website. Do all of your checking of who the dealer is
by
  the ID url variable.. You could even set a session variable based on a
  referer url as well. There are many ways to do it and without
specifically
  knowing how your dealers are getting to the site, there is no set way of
  doing things...
 
  Jeff
 
 
  - Original Message -
  From: Troy Montour [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 10:27 AM
  Subject: cf frames question
 
 
   Hello,
   sorry haven't had enough coffee this morning yet so I can't think
of
   what to use to do this.
  
   I'm trying to detect frames which I figure javascript for that part
   unless theres away with cold fusion but the problem is I need cold
   fusion to know if there is frames and to set a global varible if there
   is.
  
   give you my situation maybe someone can give me an easyier solution.
  
   we have a website that sells coins but also can have dealers that sell
   coins and because of IE6 not excepting 3rd party cookies by default it
   doesn't set the dealer var and defaults to main site which is bad
cause
   then the viewer is at the main site now and not the dealer site.
  
   so I figue if I can detect the frames then set a dealer var every page
   instead of passing it to every link a person can click on.
  
   but problem I'm having is CF runs before javascript so I need to
figure
   out a way to detect the frames so I can set the dealer ID to know
which
   dealer this is.
  
   Thanks in advance
   Troy Montour
  
  
 
 
__
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: Cfcontent performance issues?

2002-01-04 Thread Rick Osborne [Mojo]

Kay Smoljak asked:

 Also, the other recommendation was to get the web server
 to handle this. I will be on IIS5 on Win2K, on shared
 hosting, but my host is usually quite accomodating when
 it comes to setting things up for me.

To which Dave Watts replied:

 You might be able to do something better by writing an ISAPI
 extension (or looking for an existing ISAPI extension) which
 checks for the existence of some token (a cookie or URL
 variable, for example) before allowing the request to be
 processed. I haven't written any ISAPI extensions myself, and
 suspect it's a bit more complicated than most CF programming,
 but I'd guess that it would perform better for this specific
 task.

Other than a moderate initial learning curve (learning the API), ISAPI
extensions really aren't that hard to write.  (Assuming, of course, you know
C/C++.)  I wrote one for authenticating against Netware and it only took 2.5
days to both learn everything I needed to know (about Netware and ISAPI) and
actually write and debug the code.  Other than the Netware part, it may
actually be pretty close to what Kay is asking for.  It's completely free,
including source code, and available here:

  http://www.rixsoft.com/NWAuth/

It includes a (configurable) caching feature to speed things up, as well as
the ability to configure which files it gets called for.  It's been in a
production environment for over a year and a half now and I haven't heard
any complaints.  It's loosely based on sample code provided in Steve
Genusa's Using ISAPI book from a few years ago:

  http://www.amazon.com/exec/obidos/ASIN/0789709139
  http://www.genusa.com/isapi/
  http://www.genusa.com/isapi/isapisrc.html

The example code was actually code for validating users against an ODBC
datasource, so you may prefer to use that code to base your own off of.
Assuming, of course, you decide to go the ISAPI route.  I highly recommend
it, actually, as ISAPI extensions are blindingly fast and don't take up much
of your resources.

Feel free to contact me off-list for more info or help.

-R

__
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: Developers Edition Coming

2002-01-04 Thread Thomas Muck

In the FAQs it says this:
The Developer Edition becomes available on January 7, 2002. If you
downloaded and installed the ColdFusion Trial Edition before then, you must
download the free Trial Edition again on or after January 7, 2002 to get the
Developer Edition. The Trial Edition you downloaded before January 7, 2002
will not automatically convert to the Developer Edition.

That's a pretty official announcement.  ;-)

tom

Michael Dinowitz [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I believe that the only change is in the language of the license. As
stated

 in the FAQ, the developer edition is not licensed for deployment. I don't
 know the exacts of the announcement but I'm sure there's something
 different, probably a change there. Until it happens, anything I say is
 speculation.


__
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 Language reference

2002-01-04 Thread Richard Meredith-Hardy

copied straight from www.amazon.co.uk

ColdFusion 5 Language Reference  
Ben Forta 
 List Price: £14.50
Our Price: £11.60 
You Save: £2.90 (20%) 

Availability: Usually dispatched within 2-3 days
Category(ies): Children's Books , Computers  Internet  

--
Regards;

Richard Meredith-Hardy
-
[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: Developers Edition Coming

2002-01-04 Thread Michael Dinowitz

Looks official to me.

At 12:37 PM 1/4/02, you wrote:
In the FAQs it says this:
The Developer Edition becomes available on January 7, 2002. If you
downloaded and installed the ColdFusion Trial Edition before then, you must
download the free Trial Edition again on or after January 7, 2002 to get
 the
Developer Edition. The Trial Edition you downloaded before January 7, 2002
will not automatically convert to the Developer Edition.

That's a pretty official announcement.  ;-)

tom

Michael Dinowitz [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  I believe that the only change is in the language of the license. As
stated
 
  in the FAQ, the developer edition is not licensed for deployment. I
 don't
  know the exacts of the announcement but I'm sure there's something
  different, probably a change there. Until it happens, anything I say is
  speculation.



__
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



testing

2002-01-04 Thread Douglas Brown

aaa bb cc dd e fff 
ggg hh  j 
k  mm nn





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: testing

2002-01-04 Thread Michael Dinowitz

Please send all test messages to [EMAIL PROTECTED] or 
[EMAIL PROTECTED] They make fun of them on the community list.
 :)

At 01:02 PM 1/4/02, you wrote:
aaa bb cc dd e fff
ggg hh  j
k  mm nn





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: testing

2002-01-04 Thread Douglas Brown

aaa bb cc dd e fff 
ggg hh  j 
k  mm nn.





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: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:02 AM
Subject: testing


 aaa bb cc dd e fff 

 ggg hh  j 
 k  mm nn
 
 
 
 
 
 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
 
 
__
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: testing

2002-01-04 Thread Douglas Brown

:)



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: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 9:49 AM
Subject: Re: testing


 Please send all test messages to [EMAIL PROTECTED] or
 [EMAIL PROTECTED] They make fun of them on the community
list.
  :)

 At 01:02 PM 1/4/02, you wrote:
 aaa bb cc dd e fff
 ggg hh  j
 k  mm nn
 
 
 
 
 
 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: testing

2002-01-04 Thread Douglas Brown

Just to let you know, you've got something funky going on with your
delivery for the CF-Talk list... it looks like your email client is
auto-wrapping at 73 characters and you are putting in a hard return at 75
characters.  The
end effect is pasted below:




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: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:04 AM
Subject: Re: testing


 aaa bb cc dd e fff
 ggg hh  j
 k  mm nn.





 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: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:02 AM
 Subject: testing


  aaa bb cc dd e
fff

  ggg hh  j
  k  mm nn
 
 
 
 
 
  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



cf_twoselectesrelated help!!!!

2002-01-04 Thread Amanda Stern

Hello,

thanks for the tips on thisI am trying to get the
cf_twoselectsrelated custom tag going but cant seem to
get it to work.I downloaded the Custom Tag into my
Custom Tag folder and the only changes/additions I
made were to the cfparam items where a default value
was not already assigned(the first 3 items).  Now I
get this error:  

An error occurred while evaluating the expression: 


 MyQuery = Evaluate(Caller.#Attributes.Query#)


An error has occurred while processing the expression:

   Caller.
---
do I need to update this custom tag in anyway...

also, my cf_twoselectsRelated code is as follows:

 CF_TwoSelectsRelated
QUERY=get_outcome
DISPLAY1=Master_Cat
DISPLAY2=vcodedecode
VALUE1=icodedecodetablenameid
VALUE2=icodedecodeid
FORCEWIDTH1=70
FORCEWIDTH2=70
SIZE1=1
SIZE2=1
HTMLBETWEEN=BR
AUTOSELECTFIRST=Yes
EMPTYTEXT1=(choose a category)
EMPTYTEXT2=(now choose a subcategory)
ONCHANGE=Submit!
FORMNAME=MyOtherForm

I am sure I am overlooking a few things here...any
ideas?

Thanks again!!!





--- Raymond Camden [EMAIL PROTECTED] wrote:
 You are correct. Form.method won't be set until the
 user picks it and
 submits the form. Now, you can default form.method
 to something so that
 the second drop down will have values in it
 initially. By the way, this
 is VERY bad:
 
  cfoutput
   cfif  #form.method1# IS 1
   /cfoutput
 
 This should be:
 
 cfif form.method is 1
 
 Notice, no cfoutput is needed. Remember, cfoutput is
 ONLY necessary when
 you want the user to see the value of a CF variable.
 By itself, CF
 doesn't need it. Ie, you DONT do this:
 
 cfset x = 1
 cfoutput
 cfset y = #x#
 /cfoutput
 (well, that works, but is unnecessary)
 
 
 This is fine...
 
 cfset x = 1
 cfset y = x
 

===
 Raymond Camden, Principal Spectra Compliance
 Engineer for Macromedia
 
 Email: [EMAIL PROTECTED]
 Yahoo IM : morpheus
 
 My ally is the Force, and a powerful ally it is. -
 Yoda 
 
  -Original Message-
  From: Amanda Stern [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 03, 2002 2:25 PM
  To: CF-Talk
  Subject: Simple FORM Variable ERROR?
  
  
  Hello,
  
  I am trying to create a simple form that depending
 on
  which item is selected in one dropdown will
 determine
  the contents of the next dropdown fieldit
 doesnt
  to recognize my form variable though
  
  here is my code:
  
  
  td width=300
  *Outreach Method:br
   select name=OutreachMethod1
   option value=--Select One--/option
   option value=1Telephone/option
   option value=2Home Visit/option
   /select 
  /td
  
 cfoutput
  input type=hidden 
 name=method1 
 value=Form.OutreachMethod1
 /cfoutput 
  
  
  cfoutput
   cfif  #form.method1# IS 1
   /cfoutput
  
  
  So depending on which value from the
 OutreachMethod1
  drop down they choose will determine the cfif code
  that follows...but it doesnt recognize
 #form.method1#
  ...do I need to have 2 forms and submit the first
  part?
  
  TIA
  
  
  
  __
  Do You Yahoo!?
  Send your FREE holiday greetings online!
  


__
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: testing

2002-01-04 Thread Michael Dinowitz

Actually, the list is obeying the character wrap used by your mail package.
 
Your probably using outlook which auto-wraps at 73. The 75th character 
thing on the other hand is interesting. I'm forwarding it to Howie. I just
 
put in a new CFX which may be causing it.

At 01:07 PM 1/4/02, you wrote:
Just to let you know, you've got something funky going on with your
delivery for the CF-Talk list... it looks like your email client is
auto-wrapping at 73 characters and you are putting in a hard return at 75
characters.  The
end effect is pasted below:




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: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:04 AM
Subject: Re: testing


  aaa bb cc dd e fff
  ggg hh  j
  k  mm nn.
 
 
 
 
 
  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: Douglas Brown [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 10:02 AM
  Subject: testing
 
 
   aaa bb cc dd e
fff
 
   ggg hh  j
   k  mm nn
  
  
  
  
  
   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: testing

2002-01-04 Thread Douglas Brown

Thanks alot, I have mine set at double quotable and do not have a specify
 return length.





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



Doug Brown
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 9:56 AM
Subject: Re: testing


 Actually, the list is obeying the character wrap used by your mail pack
age.

 Your probably using outlook which auto-wraps at 73. The 75th character
 thing on the other hand is interesting. I'm forwarding it to Howie. I j
ust

 put in a new CFX which may be causing it.

 At 01:07 PM 1/4/02, you wrote:
 Just to let you know, you've got something funky going on with your
 delivery for the CF-Talk list... it looks like your email client is
 auto-wrapping at 73 characters and you are putting in a hard return at
 75
 characters.  The
 end effect is pasted below:
 
 
 
 
 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: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:04 AM
 Subject: Re: testing
 
 
   aaa bb cc dd e 
fff
   ggg hh  jjj
jj
   k  mm n
n.
  
  
  
  
  
   There are two major products that come out of Berkeley: LSD and [Un
ix]
   BSD. We don't believe this to be a coincidence.
  
  
  
   Doug Brown
   - Original Message -
   From: Douglas Brown [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Friday, January 04, 2002 10:02 AM
   Subject: testing
  
  
aaa bb cc dd e
 fff
  
ggg hh  j

k  mm nnn
nnn
   
   
   
   
   
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: testing

2002-01-04 Thread C. Hatton Humphrey

I originally sent that email to Doug after seeing several messages from him
that were doing that.  I also captured headers from both a direct email from
him as well as one from him to the list for comparison.

Hatton


 -Original Message-
 From: Douglas Brown [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 1:08 PM
 To: CF-Talk
 Subject: Re: testing


 Just to let you know, you've got something funky going on with your
 delivery for the CF-Talk list... it looks like your email client is
 auto-wrapping at 73 characters and you are putting in a hard return at 75
 characters.  The
 end effect is pasted below:




 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: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:04 AM
 Subject: Re: testing


  aaa bb cc dd e fff
  ggg hh  j
  k  mm nn.
 
 
 
 
 
  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: Douglas Brown [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 10:02 AM
  Subject: testing
 
 
   aaa bb cc dd e
 fff
 
   ggg hh  j
   k  mm nn
  
  
  
  
  
   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: testing

2002-01-04 Thread Douglas Brown

Quoted printable I mean.



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: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:15 AM
Subject: Re: testing


 Thanks alot, I have mine set at double quotable and do not have a 
specify
  return length.
 
 
 
 
 
 There are two major products that come out of Berkeley: LSD and [Unix] 
BS
 D. We don't believe this to be a coincidence.
 
 
 
 Doug Brown
 - Original Message -
 From: Michael Dinowitz [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 9:56 AM
 Subject: Re: testing
 
 
  Actually, the list is obeying the character wrap used by your mail 
pack
 age.
 
  Your probably using outlook which auto-wraps at 73. The 75th 
character
  thing on the other hand is interesting. I'm forwarding it to Howie. 
I j
 ust
 
  put in a new CFX which may be causing it.
 
  At 01:07 PM 1/4/02, you wrote:
  Just to let you know, you've got something funky going on with your
  delivery for the CF-Talk list... it looks like your email client is
  auto-wrapping at 73 characters and you are putting in a hard return 
at
  75
  characters.  The
  end effect is pasted below:
  
  
  
  
  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: Douglas Brown [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Friday, January 04, 2002 10:04 AM
  Subject: Re: testing
  
  
aaa bb cc dd e 

 fff
ggg hh  
jjj
 jj
k  mm 
n
 n.
   
   
   
   
   
There are two major products that come out of Berkeley: LSD and 
[Un
 ix]
BSD. We don't believe this to be a coincidence.
   
   
   
Doug Brown
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 10:02 AM
Subject: testing
   
   
 aaa bb cc dd e
  fff
   
 ggg hh  
j
 
 k  mm 
nnn
 nnn





 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: Developers Edition Coming

2002-01-04 Thread Scott Brady

 In the FAQs it says this:
 The Developer Edition becomes available on January 7, 2002. If you
 downloaded and installed the ColdFusion Trial Edition before then, you
must
 download the free Trial Edition again on or after January 7, 2002 to get
the
 Developer Edition. The Trial Edition you downloaded before January 7, 2002
 will not automatically convert to the Developer Edition.

Hmmm . . . they must still be working on it (and posted an old version
yesterday).  When I read the FAQ yesterday, I am almost certain it said
something like Dec. 17th . . . .

I guess that's what happens when they post unfinished code on a production
server.

Scott
--
Scott Brady
http://www.scottbrady.net/

__
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: testing

2002-01-04 Thread Michael Dinowitz

the double quotable vs. plain text might be a reason (it was mentioned
 somewhere). I'm on it.

At 01:15 PM 1/4/02, you wrote:
Thanks alot, I have mine set at double quotable and do not have a specify
 return length.





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



Doug Brown
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 9:56 AM
Subject: Re: testing


 Actually, the list is obeying the character wrap used by your mail pack
age.

 Your probably using outlook which auto-wraps at 73. The 75th character
 thing on the other hand is interesting. I'm forwarding it to Howie. I j
ust

 put in a new CFX which may be causing it.

 At 01:07 PM 1/4/02, you wrote:
 Just to let you know, you've got something funky going on with your
 delivery for the CF-Talk list... it looks like your email client is
 auto-wrapping at 73 characters and you are putting in a hard return at
 75
 characters.  The
 end effect is pasted below:
 
 
 
 
 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: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, January 04, 2002 10:04 AM
 Subject: Re: testing
 
 
   aaa bb cc dd e 
fff
   ggg hh  jjj
jj
   k  mm n
n.
  
  
  
  
  
   There are two major products that come out of Berkeley: LSD and [Un
ix]
   BSD. We don't believe this to be a coincidence.
  
  
  
   Doug Brown
   - Original Message -
   From: Douglas Brown [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Friday, January 04, 2002 10:02 AM
   Subject: testing
  
  
aaa bb cc dd e
 fff
  
ggg hh  j

k  mm nnn
nnn
   
   
   
   
   
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: Problems with ArrayNew()

2002-01-04 Thread Dave Watts

 I am currently having a problem with ArrayNew(), and I was wondering 
 if anyone has seen something similar. Currently, I have a ColdFusion
 page that verifies a large amount of data pulled from a database. To
 initialize the arrays that will be used for this validation, a CFSCRIPT
 statement is used. Within this script, approximately 1,500 arrays are 
 created to support the validation (just wait, it gets better... ;-) ).
 Now, this work 99% of the time. However, whenever it does not work, it 
 returns a 13 page error to the user which displays the following 
 message:

 
 An error occurred while evaluating the expression:
 insert 13 pages of array declaration here
 Error near line 436, column 45.

 Parameter 1 of function ArrayNew which is now 1 must be an integer.
 

 The line where the error occurs changes every time this occurs. This
 leads me to believe that ColdFusion is having a problem either 
 processing the file, or it can not allocate enough memory to complete 
 the request and defaults to this error message. Additionally, the code
 executed within this file has not been changed for this release, it 
 just started to occur. As for the ColdFusion server configuration, it 
 is maintained by another contractor so we have no idea what is 
 configured and how.

 Now obviously, declaring 1,500 individual arrays is probably not the
 best method to perform this task, however this is an inherited piece of 
 code and re-development would take too long at this point in my current 
 release cycle. I was just curious if someone had seen something like 
 this in the past, and if so, how did you get around it. As always, any 
 creative and positive ideas on the subject are appreciated.

I don't know how creative or positive you'll find this, but that's up to
you. I've seen things like this in the past, and they've generally indicated
that you don't have enough memory on the server. The fact that it works most
of the time, and just started failing occasionally, indicates that there's
some new stuff going on on the server (surprise!) but doesn't really tell
you what that might be - increased traffic, another service or application
running, etc.

So, you might add more memory to the server, if that's an option. If you're
running CF 4.5.x, you might upgrade to CF 5, which appears to handle memory
better generally.

Alternatively, you might address the problem by rewriting the code. I know,
it's inherited. Well, sometimes, you have to disinherit - with really bad
code just like really bad relatives.

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

__
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: CSV File Importer

2002-01-04 Thread Alex

use the SQLServer import wizard

On Fri, 4 Jan 2002, it was written:

 Anyone have a tool in ColdFusion that will import a text file in to a
 database?  Already looked on the Developer's Exchange (sure is slow latel
y)
 and didn't find anything that will work.  Just looking for something that
 will parse and import a text file of comma seperated values in to a SQL
 database.
 
 Bernd VanSkiver
 [EMAIL PROTECTED]
 ColdFusion Developer
 
__
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: Load Balancing a server - ADVICE REQUIRED

2002-01-04 Thread Alex

Good coding
Stored procs
Good Coding
Caching
Good Coding
Good DB setup
Good hardware
Good coding
Kill all unneeded services



On Fri, 4 Jan 2002, it was written:

 Hi,
 I have developed a large scale web site with SQL Server back end on a 
 Windows platform.  I have suggested clustering two servers for the app. 
 
 
  What is the best practice for achieving this (Clustercats/load balancer
 
 
 etc etc)?  (all session vars etc are stored in a database).
 
 TIA
 
 Nick
 
 -Original Message-
 From: Kola Oyedeji [EMAIL PROTECTED] [mailto:Kola Oyedeji
 [EMAIL PROTECTED]]
 Sent: 04 January 2002 10:06
 To: CF-Talk
 Subject: RE: Cybercash / Barclays in the UK
 
 
 Peter if its any help try the uk cfug list or forums those guys should 
 know
 a lot more about this.
 
 http://www.ukcfug.org/
 
 For some reason the active mailing list is at
 cfdeveloper.co.uk
 
 HTH
 
 Kola Oyedeji |Web Developer |ekeda
 elthorne gate |64 high street |pinner |middx |ha55qa
 t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
 
 
  -Original Message-
  From: Peter Dray [EMAIL PROTECTED] [mailto:Peter Dray
  [EMAIL PROTECTED]]
  Sent: 04 January 2002 09:50
  To: CF-Talk
  Subject: Cybercash / Barclays in the UK
 
 
  Hi all,
 
  I have heard from some sources that the demise of cybercash
  has no effect on
  e-commerce sites that are/were running the cfx tags to connect to that
  system. Whereas Barclays EPDQ told me that they no longer
  accept connections
  from CF sites at all.
 
  Can anyone shed any light on this for me ?
 
  Many thanks
 
  Pete Dray
 
  
 
 
 
__
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: CSV File Importer

2002-01-04 Thread Blaine Boyland

Sure,

CSVtoQuery a cold fusion extension.

Used it many times works like a champ.

Blaine Boyland
Web Connectivity

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 1:09 PM
To: CF-Talk
Subject: Re: CSV File Importer


use the SQLServer import wizard

On Fri, 4 Jan 2002, it was written:

 Anyone have a tool in ColdFusion that will import a text file in to a
 database?  Already looked on the Developer's Exchange (sure is slow lat
el
y)
 and didn't find anything that will work.  Just looking for something th
at
 will parse and import a text file of comma seperated values in to a SQL
 database.

 Bernd VanSkiver
 [EMAIL PROTECTED]
 ColdFusion Developer


__
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



OT: Move off of windows

2002-01-04 Thread Robert Everland

I have always wanted to learn Linux and FreeBSD, but could never
find a good enough machine to do it, and then on top of that when it was
installed I just couldn't run from machine to machine. So I was reading
cnn.com and they were talking about Virtual PC for the Mac. So I figured
what the heck may as well check it out and I found out it can run Linux and
UNix and any other PC operating system you can think of. So now you don't
have an excuse as to why you can't learn another operating system. This
should keep me busy for the next life time. I am using the 45 day trial now,
but when I will purchase it, it's only $199. http://www.connectix.com

Robert Everland III
Dixon Ticonderoga
__
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



Graph Help

2002-01-04 Thread Shahzad Butt

Hi all
 
Is there any way that if we are having negative value in graph and graph
will go in other direction, towards 've y-axix leaving rest of lines are in
positive.
 
Regards
Shahzad Butt

__
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: Move off of windows

2002-01-04 Thread Zac Belado

   I have always wanted to learn Linux and FreeBSD, but could never
 find a good enough machine to do it, and then on top of that when it was
 installed I just couldn't run from machine to machine. So I was reading
 cnn.com and they were talking about Virtual PC for the Mac. So I figured
 what the heck may as well check it out and I found out it can run
 Linux and
 UNix and any other PC operating system you can think of. So now you don't
 have an excuse as to why you can't learn another operating system. This
 should keep me busy for the next life time. I am using the 45 day
 trial now,
 but when I will purchase it, it's only $199. http://www.connectix.com

You can also run OS X on your Mac (if its recent enough) and since it has a
full set of UNIX tools and runs a version of BSD you can get the same
training in UNIX tools and commands without having to go through the process
of installing another OS.

As well there is a package manager, fink, available for OS X that has most,
if not all, of the Debian packages recompiled for OS X.
__
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



SOT: DB2 table locking

2002-01-04 Thread Brian Fox

Is there a way to check for DB2 table locking via Cold Fusion?  Looking for
minimal impact on db design - preferrably using just an ODBC query.

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: OT: Move off of windows

2002-01-04 Thread Alex

actually bell labs has VNC
www.uk.research.att.com/vnc/ 
and there is www.vmware.com which is about $40
and there is qnx that is free from tucows.com
All these let you run a dual boot machine.
Oh yeah and there are alot of free unix shell accounts you can get and do
anything you want.

On Fri, 4 Jan 2002, Robert Everland wrote:

   I have always wanted to learn Linux and FreeBSD, but could never
 find a good enough machine to do it, and then on top of that when it was
 installed I just couldn't run from machine to machine. So I was reading
 cnn.com and they were talking about Virtual PC for the Mac. So I figured
 what the heck may as well check it out and I found out it can run Linux a
nd
 UNix and any other PC operating system you can think of. So now you don't
 have an excuse as to why you can't learn another operating system. This
 should keep me busy for the next life time. I am using the 45 day trial n
ow,
 but when I will purchase it, it's only $199. http://www.connectix.com
 
 Robert Everland III
 Dixon Ticonderoga
 
__
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_twoselectesrelated help!!!!

2002-01-04 Thread Steven Dworman

What does your query look like?

Also, shouldn't the onchange even be this.form.submit();?  Are you
submitting to the same form?  It seems like you're calling the query once
for the selectsrelated tag, submitting the form to itself but the query i
s
not called again.

-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 12:55 PM
To: CF-Talk
Subject: cf_twoselectesrelated help


Hello,

thanks for the tips on thisI am trying to get the
cf_twoselectsrelated custom tag going but cant seem to
get it to work.I downloaded the Custom Tag into my
Custom Tag folder and the only changes/additions I
made were to the cfparam items where a default value
was not already assigned(the first 3 items).  Now I
get this error:

An error occurred while evaluating the expression:


 MyQuery = Evaluate(Caller.#Attributes.Query#)


An error has occurred while processing the expression:

   Caller.
---
do I need to update this custom tag in anyway...

also, my cf_twoselectsRelated code is as follows:

 CF_TwoSelectsRelated
QUERY=get_outcome
DISPLAY1=Master_Cat
DISPLAY2=vcodedecode
VALUE1=icodedecodetablenameid
VALUE2=icodedecodeid
FORCEWIDTH1=70
FORCEWIDTH2=70
SIZE1=1
SIZE2=1
HTMLBETWEEN=BR
AUTOSELECTFIRST=Yes
EMPTYTEXT1=(choose a category)
EMPTYTEXT2=(now choose a subcategory)
ONCHANGE=Submit!
FORMNAME=MyOtherForm

I am sure I am overlooking a few things here...any
ideas?

Thanks again!!!





--- Raymond Camden [EMAIL PROTECTED] wrote:
 You are correct. Form.method won't be set until the
 user picks it and
 submits the form. Now, you can default form.method
 to something so that
 the second drop down will have values in it
 initially. By the way, this
 is VERY bad:

  cfoutput
   cfif  #form.method1# IS 1
   /cfoutput

 This should be:

 cfif form.method is 1

 Notice, no cfoutput is needed. Remember, cfoutput is
 ONLY necessary when
 you want the user to see the value of a CF variable.
 By itself, CF
 doesn't need it. Ie, you DONT do this:

 cfset x = 1
 cfoutput
 cfset y = #x#
 /cfoutput
 (well, that works, but is unnecessary)


 This is fine...

 cfset x = 1
 cfset y = x


 Raymond Camden, Principal Spectra Compliance
 Engineer for Macromedia

 Email: [EMAIL PROTECTED]
 Yahoo IM : morpheus

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

  -Original Message-
  From: Amanda Stern [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, January 03, 2002 2:25 PM
  To: CF-Talk
  Subject: Simple FORM Variable ERROR?
 
 
  Hello,
 
  I am trying to create a simple form that depending
 on
  which item is selected in one dropdown will
 determine
  the contents of the next dropdown fieldit
 doesnt
  to recognize my form variable though
 
  here is my code:
 
 
  td width=300
  *Outreach Method:br
   select name=OutreachMethod1
   option value=--Select One--/option
   option value=1Telephone/option
   option value=2Home Visit/option
   /select
  /td
 
 cfoutput
  input type=hidden
 name=method1
 value=Form.OutreachMethod1
 /cfoutput
 
 
  cfoutput
   cfif  #form.method1# IS 1
   /cfoutput
 
 
  So depending on which value from the
 OutreachMethod1
  drop down they choose will determine the cfif code
  that follows...but it doesnt recognize
 #form.method1#
  ...do I need to have 2 forms and submit the first
  part?
 
  TIA
 
 
 
  __
  Do You Yahoo!?
  Send your FREE holiday greetings online!
 



__
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



Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Julia Green

I just started a $90 a month ISP account with ColdFusion and a
database.
Help confirmed that I actually got my tables over, and that the error
is on my side.

This is the error I get and beneath it is the code: (Don't laugh -- I
have done ColdFusion at UPS for two years...)

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 28000 (Invalid authorization specification)


[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'jgrn123'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:64).


Date/Time: 01/04/02 14:28:08
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
Remote Address: 24.128.190.210
 

This is my coldfusion code:

CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

  SELECT *
  FROM ultra
 
/CFQUERY
html
head/head
body
cfoutput query=gilwaya
br
BR
FONT SIZE=-1
#Name#
/FONT
BR
/cfoutput
/body
/html

Thanks Julia Green, Julia Computer Consulting
Email:  [EMAIL PROTECTED]

--- Dave Watts [EMAIL PROTECTED] wrote:
  I was looking through the list archives at recommedations 
  for protecting images - ie, not allowing images files to 
  be called directly from the browser. The main recommendations 
  seem to involve CFCONTENT. The site I will be working on 
  will require this, and will also potentially be quite high 
  traffic. I was wondering how well cfcontent works under load 
  in situations like this.
 
 It's going to run every request through CF, which is going to
 significantly
 increase the amount of work CF has to do. The same issue comes up
 with
 regular HTML pages - if you want to force authorization using CF, you
 might
 map .html to be processed by CF, but there's a serious performance
 penalty.
 
 You can address this by either finding an alternative that doesn't
 require
 runtime processing (with CF or any other CGI tool), or by ensuring
 that your
 CF servers can handle the load by getting more and/or bigger ones.
 
  Also, the other recommendation was to get the web server to handle 
  this. I will be on IIS5 on Win2K, on shared hosting, but my host is
 
  usually quite accomodating when it comes to setting things up for
 me. 
  How would you restrict calling images through IIS? Does it involve 
  setting the image file types to be handled by the CF server, so 
  Application.cfm is called before each? Is this better (in terms of 
  performance) than using CFCONTENT for the same purpose?
 
 To the best of my knowledge, the only way to get IIS to handle this
 for you
 is to set the appropriate permissions on each image file, and have
 IIS force
 authentication against requests for those files. There's very little
 overhead in that, but it would require that you have a Windows
 account for
 the user to use, and it wouldn't directly integrate with your
 application,
 in the sense that the user would get a browser authentication popup
 window.
 
 You might be able to do something better by writing an ISAPI
 extension (or
 looking for an existing ISAPI extension) which checks for the
 existence of
 some token (a cookie or URL variable, for example) before allowing
 the
 request to be processed. I haven't written any ISAPI extensions
 myself, and
 suspect it's a bit more complicated than most CF programming, but I'd
 guess
 that it would perform better for this specific task.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444


__
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: OT: Move off of windows

2002-01-04 Thread Tyler M . Fitch

I just have to ask where you're getting VMware for $40.  I've always
seen it for $300 from their website.

If you're already into linux and you want to use Windows with no flair
I'd recommend Netraverse's Win4Lin program.  It's $80 and installs
windows for you with full netbios support, you can browse the network
neighborhood and all that stuff.  No directx support though :(  but it
can run studio and outlook for a person using linux but needing just a
couple of windows apps to standardize with the office.  The one app it
won't run is Enterprise Manager or my dev workstation would be totally
linux based.

Cheers,

t

**
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer

ISITE Design, Inc.
615 SW Broadway Ste. 200
Portland, OR 97205

503.221.9860 ext. 111
http://isitedesign.com
**



-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 04, 2002 11:02 AM
To: CF-Talk
Subject: Re: OT: Move off of windows


actually bell labs has VNC
www.uk.research.att.com/vnc/ 
and there is www.vmware.com which is about $40
and there is qnx that is free from tucows.com
All these let you run a dual boot machine.
Oh yeah and there are alot of free unix shell accounts you can get and
do anything you want.

On Fri, 4 Jan 2002, Robert Everland wrote:

   I have always wanted to learn Linux and FreeBSD, but could never
find 
 a good enough machine to do it, and then on top of that when it was 
 installed I just couldn't run from machine to machine. So I was 
 reading cnn.com and they were talking about Virtual PC for the Mac. So

 I figured what the heck may as well check it out and I found out it 
 can run Linux a
nd
 UNix and any other PC operating system you can think of. So now you 
 don't have an excuse as to why you can't learn another operating 
 system. This should keep me busy for the next life time. I am using 
 the 45 day trial n
ow,
 but when I will purchase it, it's only $199. http://www.connectix.com
 
 Robert Everland III
 Dixon Ticonderoga
 

__
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: Move off of windows

2002-01-04 Thread Joel Parramore

VNC is a remote access program, a la Symantec's PC-Anywhere and CA's
ControlIT products.  It'll let you connect to a machine (and work with it
 as
though you were sitting at a physical terminal) which has the VNC server
installed if you have the client, so you could work on a MAC while runnin
g a
VNS session with a Linux box (or a Windows box) window  It doesn't let yo
u
run a dual-booting system per se.

Regards,
Joel Parramore


 -Original Message-
 From: Alex [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 2:02 PM
 To: CF-Talk
 Subject: Re: OT: Move off of windows


 actually bell labs has VNC
 www.uk.research.att.com/vnc/
 and there is www.vmware.com which is about $40
 and there is qnx that is free from tucows.com
 All these let you run a dual boot machine.
 Oh yeah and there are alot of free unix shell accounts you can get and 
do
 anything you want.

 On Fri, 4 Jan 2002, Robert Everland wrote:

  I have always wanted to learn Linux and FreeBSD, but could never
  find a good enough machine to do it, and then on top of that when it 
was
  installed I just couldn't run from machine to machine. So I was readi
ng
  cnn.com and they were talking about Virtual PC for the Mac. So I figu
red
  what the heck may as well check it out and I found out it can
 run Linux a
 nd
  UNix and any other PC operating system you can think of. So now
 you don't
  have an excuse as to why you can't learn another operating system. Th
is
  should keep me busy for the next life time. I am using the 45
 day trial n
 ow,
  but when I will purchase it, it's only $199. http://www.connectix.com
 
  Robert Everland III
  Dixon Ticonderoga
 
 
__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Dave Watts

 I just started a $90 a month ISP account with ColdFusion and a
 database. Help confirmed that I actually got my tables over, and 
 that the error is on my side.

 This is the error I get and beneath it is the code: (Don't laugh -- 
 I have done ColdFusion at UPS for two years...)

 Error Occurred While Processing Request
 Error Diagnostic Information
 ODBC Error Code = 28000 (Invalid authorization specification)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for 
 user 'jgrn123'.

 ...
 
 This is my coldfusion code:

 CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

Don't you need to specify a PASSWORD attribute too?

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

__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread David Schmidt

It does not look like the password was entered into the cfquery statement.
But please, do NOT post it on the forum.

David Schmidt


-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 11:39 AM
To: CF-Talk
Subject: Dave or someone -- Help me with error msg!!!


I just started a $90 a month ISP account with ColdFusion and a
database.
Help confirmed that I actually got my tables over, and that the error
is on my side.

This is the error I get and beneath it is the code: (Don't laugh -- I
have done ColdFusion at UPS for two years...)

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 28000 (Invalid authorization specification)


[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'jgrn123'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:64).


Date/Time: 01/04/02 14:28:08
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
Remote Address: 24.128.190.210


This is my coldfusion code:

CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

  SELECT *
  FROM ultra

/CFQUERY
html
head/head
body
cfoutput query=gilwaya
br
BR
FONT SIZE=-1
#Name#
/FONT
BR
/cfoutput
/body
/html

Thanks Julia Green, Julia Computer Consulting
Email:  [EMAIL PROTECTED]

--- Dave Watts [EMAIL PROTECTED] wrote:
  I was looking through the list archives at recommedations
  for protecting images - ie, not allowing images files to
  be called directly from the browser. The main recommendations
  seem to involve CFCONTENT. The site I will be working on
  will require this, and will also potentially be quite high
  traffic. I was wondering how well cfcontent works under load
  in situations like this.

 It's going to run every request through CF, which is going to
 significantly
 increase the amount of work CF has to do. The same issue comes up
 with
 regular HTML pages - if you want to force authorization using CF, you
 might
 map .html to be processed by CF, but there's a serious performance
 penalty.

 You can address this by either finding an alternative that doesn't
 require
 runtime processing (with CF or any other CGI tool), or by ensuring
 that your
 CF servers can handle the load by getting more and/or bigger ones.

  Also, the other recommendation was to get the web server to handle
  this. I will be on IIS5 on Win2K, on shared hosting, but my host is

  usually quite accomodating when it comes to setting things up for
 me.
  How would you restrict calling images through IIS? Does it involve
  setting the image file types to be handled by the CF server, so
  Application.cfm is called before each? Is this better (in terms of
  performance) than using CFCONTENT for the same purpose?

 To the best of my knowledge, the only way to get IIS to handle this
 for you
 is to set the appropriate permissions on each image file, and have
 IIS force
 authentication against requests for those files. There's very little
 overhead in that, but it would require that you have a Windows
 account for
 the user to use, and it wouldn't directly integrate with your
 application,
 in the sense that the user would get a browser authentication popup
 window.

 You might be able to do something better by writing an ISAPI
 extension (or
 looking for an existing ISAPI extension) which checks for the
 existence of
 some token (a cookie or URL variable, for example) before allowing
 the
 request to be processed. I haven't written any ISAPI extensions
 myself, and
 suspect it's a bit more complicated than most CF programming, but I'd
 guess
 that it would perform better for this specific task.

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



__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Bryan Stevenson

I'd start by removing the USERNAME attribute from your CFQUERY tag and let the 
datasource do what
it's supposed to (i.e. pass any required user/pass info to SQL Server).  Chances are 
that username
is for you to connect to SQL Server via Enterprise Manager and the datasource itself 
uses a
different user/pass combo (i.e. system account).

HTH

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate
www.macromedia.com

- Original Message -
From: Julia Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 11:38 AM
Subject: Dave or someone -- Help me with error msg!!!


 I just started a $90 a month ISP account with ColdFusion and a
 database.
 Help confirmed that I actually got my tables over, and that the error
 is on my side.

 This is the error I get and beneath it is the code: (Don't laugh -- I
 have done ColdFusion at UPS for two years...)

 Error Occurred While Processing Request
 Error Diagnostic Information
 ODBC Error Code = 28000 (Invalid authorization specification)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
 'jgrn123'.



 The error occurred while processing an element with a general
 identifier of (CFQUERY), occupying document position (2:1) to (2:64).


 Date/Time: 01/04/02 14:28:08
 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
 Remote Address: 24.128.190.210


 This is my coldfusion code:

 CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

   SELECT *
   FROM ultra

 /CFQUERY
 html
 head/head
 body
 cfoutput query=gilwaya
 br
 BR
 FONT SIZE=-1
 #Name#
 /FONT
 BR
 /cfoutput
 /body
 /html

 Thanks Julia Green, Julia Computer Consulting
 Email:  [EMAIL PROTECTED]

 --- Dave Watts [EMAIL PROTECTED] wrote:
   I was looking through the list archives at recommedations
   for protecting images - ie, not allowing images files to
   be called directly from the browser. The main recommendations
   seem to involve CFCONTENT. The site I will be working on
   will require this, and will also potentially be quite high
   traffic. I was wondering how well cfcontent works under load
   in situations like this.
 
  It's going to run every request through CF, which is going to
  significantly
  increase the amount of work CF has to do. The same issue comes up
  with
  regular HTML pages - if you want to force authorization using CF, you
  might
  map .html to be processed by CF, but there's a serious performance
  penalty.
 
  You can address this by either finding an alternative that doesn't
  require
  runtime processing (with CF or any other CGI tool), or by ensuring
  that your
  CF servers can handle the load by getting more and/or bigger ones.
 
   Also, the other recommendation was to get the web server to handle
   this. I will be on IIS5 on Win2K, on shared hosting, but my host is
 
   usually quite accomodating when it comes to setting things up for
  me.
   How would you restrict calling images through IIS? Does it involve
   setting the image file types to be handled by the CF server, so
   Application.cfm is called before each? Is this better (in terms of
   performance) than using CFCONTENT for the same purpose?
 
  To the best of my knowledge, the only way to get IIS to handle this
  for you
  is to set the appropriate permissions on each image file, and have
  IIS force
  authentication against requests for those files. There's very little
  overhead in that, but it would require that you have a Windows
  account for
  the user to use, and it wouldn't directly integrate with your
  application,
  in the sense that the user would get a browser authentication popup
  window.
 
  You might be able to do something better by writing an ISAPI
  extension (or
  looking for an existing ISAPI extension) which checks for the
  existence of
  some token (a cookie or URL variable, for example) before allowing
  the
  request to be processed. I haven't written any ISAPI extensions
  myself, and
  suspect it's a bit more complicated than most CF programming, but I'd
  guess
  that it would perform better for this specific task.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  phone: 202-797-5496
  fax: 202-797-5444
 

 
__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Joel Parramore

Julia:

1)  Can you (or the help) connect to the database outside of ColdFusion w
ith
that login information, i.e., thru an ODBC administration tool?  Have the
y
verified access to the database in the CF administrator?

2)  Does your CF datasource specify the password for that datasource and
username?  Did you try putting in the password for that user in the
CFQUERY tag?

Just a couple of thoughts... hope it helps.

Regards,
Joel Parramore


 -Original Message-
 From: Julia Green [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 04, 2002 2:39 PM
 To: CF-Talk
 Subject: Dave or someone -- Help me with error msg!!!


 I just started a $90 a month ISP account with ColdFusion and a
 database.
 Help confirmed that I actually got my tables over, and that the error
 is on my side.

 This is the error I get and beneath it is the code: (Don't laugh -- I
 have done ColdFusion at UPS for two years...)

 Error Occurred While Processing Request
 Error Diagnostic Information
 ODBC Error Code = 28000 (Invalid authorization specification)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
 'jgrn123'.



 The error occurred while processing an element with a general
 identifier of (CFQUERY), occupying document position (2:1) to (2:64).


 Date/Time: 01/04/02 14:28:08
 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
 Remote Address: 24.128.190.210


 This is my coldfusion code:

 CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

   SELECT *
   FROM ultra

 /CFQUERY
 html
 head/head
 body
 cfoutput query=gilwaya
 br
 BR
 FONT SIZE=-1
 #Name#
 /FONT
 BR
 /cfoutput
 /body
 /html

 Thanks Julia Green, Julia Computer Consulting
 Email:  [EMAIL PROTECTED]

 --- Dave Watts [EMAIL PROTECTED] wrote:
   I was looking through the list archives at recommedations
   for protecting images - ie, not allowing images files to
   be called directly from the browser. The main recommendations
   seem to involve CFCONTENT. The site I will be working on
   will require this, and will also potentially be quite high
   traffic. I was wondering how well cfcontent works under load
   in situations like this.
 
  It's going to run every request through CF, which is going to
  significantly
  increase the amount of work CF has to do. The same issue comes up
  with
  regular HTML pages - if you want to force authorization using CF, you
  might
  map .html to be processed by CF, but there's a serious performance
  penalty.
 
  You can address this by either finding an alternative that doesn't
  require
  runtime processing (with CF or any other CGI tool), or by ensuring
  that your
  CF servers can handle the load by getting more and/or bigger ones.
 
   Also, the other recommendation was to get the web server to handle
   this. I will be on IIS5 on Win2K, on shared hosting, but my host is
 
   usually quite accomodating when it comes to setting things up for
  me.
   How would you restrict calling images through IIS? Does it involve
   setting the image file types to be handled by the CF server, so
   Application.cfm is called before each? Is this better (in terms of
   performance) than using CFCONTENT for the same purpose?
 
  To the best of my knowledge, the only way to get IIS to handle this
  for you
  is to set the appropriate permissions on each image file, and have
  IIS force
  authentication against requests for those files. There's very little
  overhead in that, but it would require that you have a Windows
  account for
  the user to use, and it wouldn't directly integrate with your
  application,
  in the sense that the user would get a browser authentication popup
  window.
 
  You might be able to do something better by writing an ISAPI
  extension (or
  looking for an existing ISAPI extension) which checks for the
  existence of
  some token (a cookie or URL variable, for example) before allowing
  the
  request to be processed. I haven't written any ISAPI extensions
  myself, and
  suspect it's a bit more complicated than most CF programming, but I'd
  guess
  that it would perform better for this specific task.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  phone: 202-797-5496
  fax: 202-797-5444
 

 
__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Steven Dworman

**snip**
CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

where's the password attribute?
CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123
PASSWORD=??

-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 2:39 PM
To: CF-Talk
Subject: Dave or someone -- Help me with error msg!!!


I just started a $90 a month ISP account with ColdFusion and a
database.
Help confirmed that I actually got my tables over, and that the error
is on my side.

This is the error I get and beneath it is the code: (Don't laugh -- I
have done ColdFusion at UPS for two years...)

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 28000 (Invalid authorization specification)


[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'jgrn123'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:64).


Date/Time: 01/04/02 14:28:08
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
Remote Address: 24.128.190.210


This is my coldfusion code:

CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

  SELECT *
  FROM ultra

/CFQUERY
html
head/head
body
cfoutput query=gilwaya
br
BR
FONT SIZE=-1
#Name#
/FONT
BR
/cfoutput
/body
/html

Thanks Julia Green, Julia Computer Consulting
Email:  [EMAIL PROTECTED]

--- Dave Watts [EMAIL PROTECTED] wrote:
  I was looking through the list archives at recommedations
  for protecting images - ie, not allowing images files to
  be called directly from the browser. The main recommendations
  seem to involve CFCONTENT. The site I will be working on
  will require this, and will also potentially be quite high
  traffic. I was wondering how well cfcontent works under load
  in situations like this.

 It's going to run every request through CF, which is going to
 significantly
 increase the amount of work CF has to do. The same issue comes up
 with
 regular HTML pages - if you want to force authorization using CF, you
 might
 map .html to be processed by CF, but there's a serious performance
 penalty.

 You can address this by either finding an alternative that doesn't
 require
 runtime processing (with CF or any other CGI tool), or by ensuring
 that your
 CF servers can handle the load by getting more and/or bigger ones.

  Also, the other recommendation was to get the web server to handle
  this. I will be on IIS5 on Win2K, on shared hosting, but my host is

  usually quite accomodating when it comes to setting things up for
 me.
  How would you restrict calling images through IIS? Does it involve
  setting the image file types to be handled by the CF server, so
  Application.cfm is called before each? Is this better (in terms of
  performance) than using CFCONTENT for the same purpose?

 To the best of my knowledge, the only way to get IIS to handle this
 for you
 is to set the appropriate permissions on each image file, and have
 IIS force
 authentication against requests for those files. There's very little
 overhead in that, but it would require that you have a Windows
 account for
 the user to use, and it wouldn't directly integrate with your
 application,
 in the sense that the user would get a browser authentication popup
 window.

 You might be able to do something better by writing an ISAPI
 extension (or
 looking for an existing ISAPI extension) which checks for the
 existence of
 some token (a cookie or URL variable, for example) before allowing
 the
 request to be processed. I haven't written any ISAPI extensions
 myself, and
 suspect it's a bit more complicated than most CF programming, but I'd
 guess
 that it would perform better for this specific task.

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



__
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: Simple FORM Variable ERROR?????

2002-01-04 Thread Amanda Stern

Jeff,

I have been trying, with no success, to get the
cf_twoselectsrelated tag to workcan I take a look
at your javascript code and see if that will better do
the trickthanks again


--- Garza, Jeff [EMAIL PROTECTED] wrote:
 I don't think CF is what you want to use here...
 Since it is run server
 side, what you are attempting to do would require a
 round trip to the
 server.
 Try checking out the TwoSelectsRelated tag at the
 Allaire Developers
 Exchange.  This should do what you want.
 
 Alternately you can roll your own using javascript. 
 I think I have a script
 from one of my sites that I can send to you if you'd
 like.
 
 Jeff Garza
 Lead Developer/Webmaster
 Spectrum Astro, Inc.
 [EMAIL PROTECTED]
 http://www.spectrumastro.com
 
 
 
 -Original Message-
 From: Amanda Stern [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, January 03, 2002 12:25 PM
 To: CF-Talk
 Subject: Simple FORM Variable ERROR?
 
 
 Hello,
 
 I am trying to create a simple form that depending
 on
 which item is selected in one dropdown will
 determine
 the contents of the next dropdown fieldit doesnt
 to recognize my form variable though
 
 here is my code:
 
 
 td width=300
   *Outreach Method:br
select name=OutreachMethod1
option value=--Select One--/option
option value=1Telephone/option
option value=2Home Visit/option
/select 
 /td
 
cfoutput
 input type=hidden 
  name=method1 
  value=Form.OutreachMethod1
/cfoutput 
 
 
 cfoutput
  cfif  #form.method1# IS 1
  /cfoutput
 
 
 So depending on which value from the OutreachMethod1
 drop down they choose will determine the cfif code
 that follows...but it doesnt recognize
 #form.method1#
 ..do I need to have 2 forms and submit the first
 part?
 
 TIA
 
 
 
 __
 Do You Yahoo!?
 Send your FREE holiday greetings online!
 


__
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: Dave or someone -- Help me with error msg!!!

2002-01-04 Thread Randy Adkins

You may need to supply a password with the query for it to authenicate to
the SQL server.

Basically it stats that the user account you entered is invalid.



- Original Message -
From: Julia Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 2:38 PM
Subject: Dave or someone -- Help me with error msg!!!


 I just started a $90 a month ISP account with ColdFusion and a
 database.
 Help confirmed that I actually got my tables over, and that the error
 is on my side.

 This is the error I get and beneath it is the code: (Don't laugh -- I
 have done ColdFusion at UPS for two years...)

 Error Occurred While Processing Request
 Error Diagnostic Information
 ODBC Error Code = 28000 (Invalid authorization specification)


 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
 'jgrn123'.



 The error occurred while processing an element with a general
 identifier of (CFQUERY), occupying document position (2:1) to (2:64).


 Date/Time: 01/04/02 14:28:08
 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
 Remote Address: 24.128.190.210


 This is my coldfusion code:

 CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123

   SELECT *
   FROM ultra

 /CFQUERY
 html
 head/head
 body
 cfoutput query=gilwaya
 br
 BR
 FONT SIZE=-1
 #Name#
 /FONT
 BR
 /cfoutput
 /body
 /html

 Thanks Julia Green, Julia Computer Consulting
 Email:  [EMAIL PROTECTED]

 --- Dave Watts [EMAIL PROTECTED] wrote:
   I was looking through the list archives at recommedations
   for protecting images - ie, not allowing images files to
   be called directly from the browser. The main recommendations
   seem to involve CFCONTENT. The site I will be working on
   will require this, and will also potentially be quite high
   traffic. I was wondering how well cfcontent works under load
   in situations like this.
 
  It's going to run every request through CF, which is going to
  significantly
  increase the amount of work CF has to do. The same issue comes up
  with
  regular HTML pages - if you want to force authorization using CF, you
  might
  map .html to be processed by CF, but there's a serious performance
  penalty.
 
  You can address this by either finding an alternative that doesn't
  require
  runtime processing (with CF or any other CGI tool), or by ensuring
  that your
  CF servers can handle the load by getting more and/or bigger ones.
 
   Also, the other recommendation was to get the web server to handle
   this. I will be on IIS5 on Win2K, on shared hosting, but my host is
 
   usually quite accomodating when it comes to setting things up for
  me.
   How would you restrict calling images through IIS? Does it involve
   setting the image file types to be handled by the CF server, so
   Application.cfm is called before each? Is this better (in terms of
   performance) than using CFCONTENT for the same purpose?
 
  To the best of my knowledge, the only way to get IIS to handle this
  for you
  is to set the appropriate permissions on each image file, and have
  IIS force
  authentication against requests for those files. There's very little
  overhead in that, but it would require that you have a Windows
  account for
  the user to use, and it wouldn't directly integrate with your
  application,
  in the sense that the user would get a browser authentication popup
  window.
 
  You might be able to do something better by writing an ISAPI
  extension (or
  looking for an existing ISAPI extension) which checks for the
  existence of
  some token (a cookie or URL variable, for example) before allowing
  the
  request to be processed. I haven't written any ISAPI extensions
  myself, and
  suspect it's a bit more complicated than most CF programming, but I'd
  guess
  that it would perform better for this specific task.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  phone: 202-797-5496
  fax: 202-797-5444
 

 
__
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



CMemoryException: unknown cause (( HELP!! ))

2002-01-04 Thread Jay Callaghan

I am using the Microsoft Jet Engine to connect to the database and I get
this error.:

CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag


I had this before and I re-created the database and it worked fine. I have
since re-created this database 5 times and still no luck. There is one table
that is not working, no matter how many times I start from scratch.

Any ideas?

__
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: DB2 table locking

2002-01-04 Thread Mark A . Kruger - CFG

I don't know how to do it with CF, but DB2 includes monitors that are
basically like traces in SQL.  You should be able to run a test and examine
the trace.

Mark

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 10:59 AM
To: CF-Talk
Subject: SOT: DB2 table locking


Is there a way to check for DB2 table locking via Cold Fusion?  Looking for
minimal impact on db design - preferrably using just an ODBC query.

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
__
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_CFLOOP_2nd_pair_of_eyes

2002-01-04 Thread coldfusion . developer

Hi,

I'm trying to interate through all the records in a 
table and add two weeks to a new date column based on 
and existing date value(srf_date_created). When I run 
the code below, I get the same date instead of an entry 
based on (srf_date_created + 2 weeks) And yes the date 
valuefor srf_date_created is different for each record.

srf_date_created is an exist date value 
srf_date_fu is a newly added date column

CFQUERY name=loop_date_sr datasource=#source1#
SELECT srf_date_created
FROM   samprequest
/cfquery

CFoutput query=loop_date_sr 
CFQUERY NAME=update_sampler datasource=#source1#
UPDATE samprequest
SET srf_date_fu = #DateAdd('ww', 2, (srf_date_created))#
/cfquery
/CFoutput

__
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_CFLOOP_2nd_pair_of_eyes

2002-01-04 Thread BEN MORRIS

You will need a WHERE clause in the update query.

 [EMAIL PROTECTED] 01/04/02 04:07PM 
Hi,

I'm trying to interate through all the records in a 
table and add two weeks to a new date column based on 
and existing date value(srf_date_created). When I run 
the code below, I get the same date instead of an entry 
based on (srf_date_created + 2 weeks) And yes the date 
valuefor srf_date_created is different for each record.

srf_date_created is an exist date value 
srf_date_fu is a newly added date column

CFQUERY name=loop_date_sr datasource=#source1#
SELECT srf_date_created
FROM   samprequest
/cfquery

CFoutput query=loop_date_sr 
CFQUERY NAME=update_sampler datasource=#source1#
UPDATE samprequest
SET srf_date_fu = #DateAdd('ww', 2, (srf_date_created))#
/cfquery
/CFoutput


__
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



  1   2   >