wot: has anyone scene this browser error before?

2003-03-03 Thread Dave Lyons
sorry for the wot post but i cant seem to find my answers anywhere.

i just reinstalled my op system again (good ole xp)
and now when i try to go onto a lot of sites i get this error

 Windows 3.1 (16-bit) Web browsers are not supported, even if they are running in 
Windows 95. Download the latest 32-bit version 

i installed the latest ie explore with sp1
new mdacs, active x's, everything
frickin pissin me off! lol
i also installed the latest vm and the newest mozzila, still with no luck

any thoughts?

thanks
dave

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Ian Vaughan
Hi

I am trying to add a workflow element into a news application, and would
just like to hear if anybody else on the list have been able to achieve
this? or best practices on how to achieve this?

I have an admin form that allows users to add news stories. At present when
the form is submitted the data is entered into the database table.

What I would like to achieve is when the user submits the form an e-mail is
sent to the relevant approver.  They view their e-mail and click on the link
which opens up their admin screen.

From here they can see they have content to approve.  The approver reads
through the story and if they are happy they approve the data and it is
entered into the database and goes live on the site.

If the approver declines the story it sends the user who created the content
an e-mail with why the data was not approved and the changes needed to be
made, and the story does not go live on the site.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Adam Reynolds
Ian,
This is relatively simple. As part of the submit page, have it save the
document away with a flag 'pending'.

Is there just one administrator? Do you want different admin for different
areas of the site? That is the real pain.

You could have a pending approval page that admin can go to to see any
pending pages. They could then view (AND edit) those pages before accepting
the content or rejecting the comment.

Adam

 -Original Message-
 From: Ian Vaughan [mailto:[EMAIL PROTECTED]
 Sent: 03 March 2003 09:38
 To: CF-Talk
 Subject: Is it possible to achieve workflow in Coldfusion ???


 Hi

 I am trying to add a workflow element into a news application, and would
 just like to hear if anybody else on the list have been able to achieve
 this? or best practices on how to achieve this?

 I have an admin form that allows users to add news stories. At
 present when
 the form is submitted the data is entered into the database table.

 What I would like to achieve is when the user submits the form an
 e-mail is
 sent to the relevant approver.  They view their e-mail and click
 on the link
 which opens up their admin screen.

 From here they can see they have content to approve.  The approver reads
 through the story and if they are happy they approve the data and it is
 entered into the database and goes live on the site.

 If the approver declines the story it sends the user who created
 the content
 an e-mail with why the data was not approved and the changes needed to be
 made, and the story does not go live on the site.



 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Ian Vaughan
Adam

There is only one administrator or approver.

How would you achieve this, do you have example code so I can see how it may
function, how do you stop the data entering the database  ??

As part of the submit page, have it save the document away with a flag
'pending'.




- Original Message -
From: Adam Reynolds [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:46 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,
 This is relatively simple. As part of the submit page, have it save the
 document away with a flag 'pending'.

 Is there just one administrator? Do you want different admin for different
 areas of the site? That is the real pain.

 You could have a pending approval page that admin can go to to see any
 pending pages. They could then view (AND edit) those pages before
accepting
 the content or rejecting the comment.

 Adam

  -Original Message-
  From: Ian Vaughan [mailto:[EMAIL PROTECTED]
  Sent: 03 March 2003 09:38
  To: CF-Talk
  Subject: Is it possible to achieve workflow in Coldfusion ???
 
 
  Hi
 
  I am trying to add a workflow element into a news application, and would
  just like to hear if anybody else on the list have been able to achieve
  this? or best practices on how to achieve this?
 
  I have an admin form that allows users to add news stories. At
  present when
  the form is submitted the data is entered into the database table.
 
  What I would like to achieve is when the user submits the form an
  e-mail is
  sent to the relevant approver.  They view their e-mail and click
  on the link
  which opens up their admin screen.
 
  From here they can see they have content to approve.  The approver
reads
  through the story and if they are happy they approve the data and it is
  entered into the database and goes live on the site.
 
  If the approver declines the story it sends the user who created
  the content
  an e-mail with why the data was not approved and the changes needed to
be
  made, and the story does not go live on the site.
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Adam Reynolds
You don't stop the data entering the database, you add a column to the db
table called status.

This determines what pages are visible, which ones are pending, and possibly
which ones are deleted but I would hard delete these on reject unless people
want to be able to contest the rejection.

The code is releatively simple and any CF book will give you examples of
what to do.


 -Original Message-
 From: Ian Vaughan [mailto:[EMAIL PROTECTED]
 Sent: 03 March 2003 11:02
 To: CF-Talk
 Subject: Re: Is it possible to achieve workflow in Coldfusion ???


 Adam

 There is only one administrator or approver.

 How would you achieve this, do you have example code so I can see
 how it may
 function, how do you stop the data entering the database  ??

 As part of the submit page, have it save the document away with a flag
 'pending'.




 - Original Message -
 From: Adam Reynolds [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 9:46 AM
 Subject: RE: Is it possible to achieve workflow in Coldfusion ???


  Ian,
  This is relatively simple. As part of the submit page, have it save the
  document away with a flag 'pending'.
 
  Is there just one administrator? Do you want different admin
 for different
  areas of the site? That is the real pain.
 
  You could have a pending approval page that admin can go to to see any
  pending pages. They could then view (AND edit) those pages before
 accepting
  the content or rejecting the comment.
 
  Adam
 
   -Original Message-
   From: Ian Vaughan [mailto:[EMAIL PROTECTED]
   Sent: 03 March 2003 09:38
   To: CF-Talk
   Subject: Is it possible to achieve workflow in Coldfusion ???
  
  
   Hi
  
   I am trying to add a workflow element into a news
 application, and would
   just like to hear if anybody else on the list have been able
 to achieve
   this? or best practices on how to achieve this?
  
   I have an admin form that allows users to add news stories. At
   present when
   the form is submitted the data is entered into the database table.
  
   What I would like to achieve is when the user submits the form an
   e-mail is
   sent to the relevant approver.  They view their e-mail and click
   on the link
   which opens up their admin screen.
  
   From here they can see they have content to approve.  The approver
 reads
   through the story and if they are happy they approve the data
 and it is
   entered into the database and goes live on the site.
  
   If the approver declines the story it sends the user who created
   the content
   an e-mail with why the data was not approved and the changes needed to
 be
   made, and the story does not go live on the site.
  
  
  
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Andre Mohamed
Ian,

Perhaps I can clarify/expand on what Adam suggested:

1) You do not stop the data entering the database when a story is
submitted. Instead, it is inserted as normal but you also set another
column probably in the same table, perhaps named status with a value
of P for pending when you perform the insert e.g.

insert into stories
(story_id, foo, bar, status)
values
(666,'Foo','Bar','P')

2) Only display stories on the website if the status column is not
P, perhaps only if the status column is A for approved e.g.

select foo, bar
from stories
where status = 'A'

3) When the approver approves a story to be published, the appropriate
row in the database gets updated and the status column is changed
appropriately.

e.g.

update stories
set status = 'A'
where story_id = 666


You could extend this model quite simply to allow for multi-level
approvals and multiple types of status.

It's important to note that this is not a ColdFusion specific problem.
It is merely a programming issue and there is more than one way to skin
a cat.

Thanks,

André


-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 11:02
To: CF-Talk
Subject: Re: Is it possible to achieve workflow in Coldfusion ???

Adam

There is only one administrator or approver.

How would you achieve this, do you have example code so I can see how it
may
function, how do you stop the data entering the database  ??

As part of the submit page, have it save the document away with a flag
'pending'.




- Original Message -
From: Adam Reynolds [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:46 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,
 This is relatively simple. As part of the submit page, have it save
the
 document away with a flag 'pending'.

 Is there just one administrator? Do you want different admin for
different
 areas of the site? That is the real pain.

 You could have a pending approval page that admin can go to to see any
 pending pages. They could then view (AND edit) those pages before
accepting
 the content or rejecting the comment.

 Adam

  -Original Message-
  From: Ian Vaughan [mailto:[EMAIL PROTECTED]
  Sent: 03 March 2003 09:38
  To: CF-Talk
  Subject: Is it possible to achieve workflow in Coldfusion ???
 
 
  Hi
 
  I am trying to add a workflow element into a news application, and
would
  just like to hear if anybody else on the list have been able to
achieve
  this? or best practices on how to achieve this?
 
  I have an admin form that allows users to add news stories. At
  present when
  the form is submitted the data is entered into the database table.
 
  What I would like to achieve is when the user submits the form an
  e-mail is
  sent to the relevant approver.  They view their e-mail and click
  on the link
  which opens up their admin screen.
 
  From here they can see they have content to approve.  The approver
reads
  through the story and if they are happy they approve the data and it
is
  entered into the database and goes live on the site.
 
  If the approver declines the story it sends the user who created
  the content
  an e-mail with why the data was not approved and the changes needed
to
be
  made, and the story does not go live on the site.
 
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Weird Error Message

2003-03-03 Thread Shahzad.Butt
Today, thinking of normal day I typed in my site address. Clicked on a
link and its giving following error. Does anyone knows what this error
is all about and how come its appearing without anything being changed.

Thanks in advance

Errors reported by Java compiler: Found 1 semantic error compiling
C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java:
1. public final class cfSelect2ecfm2055018563 extends
coldfusion.runtime.CFPage{ - *** Error: Cannot
write class file cfSelect2ecfm2055018563.class because that name
conflicts with the name of the class file
cfselect2ecfm2055018563.class in directory cfclasses. This is
illegal because file names are case-insensitive in this system. . 


Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Weird Error Message

2003-03-03 Thread Mike Townend
We had a similar problem but with cfdump after running an updater...

Goto your C:/CFusionMX/wwwroot/WEB-INF/cfclasses/ directory and delete the
.java and .class files relating to the cfselect and you should be alright...

HTH




Mikey

=
http://www.phonebin.com
From Phone to Web in minutes 


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 3, 2003 11:29
To: CF-Talk
Subject: Weird Error Message


Today, thinking of normal day I typed in my site address. Clicked on a link
and its giving following error. Does anyone knows what this error is all
about and how come its appearing without anything being changed.

Thanks in advance

Errors reported by Java compiler: Found 1 semantic error compiling
C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java:
1. public final class cfSelect2ecfm2055018563 extends
coldfusion.runtime.CFPage{ - *** Error: Cannot write
class file cfSelect2ecfm2055018563.class because that name conflicts with
the name of the class file cfselect2ecfm2055018563.class in directory
cfclasses. This is illegal because file names are case-insensitive in this
system. . 


Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Weird Error Message

2003-03-03 Thread Jesse Houwing
Citeren Shahzad.Butt [EMAIL PROTECTED]:

 Today, thinking of normal day I typed in my site address. Clicked on a
 link and its giving following error. Does anyone knows what this error
 is all about and how come its appearing without anything being changed.
 
 Thanks in advance
 
 Errors reported by Java compiler: Found 1 semantic error compiling
 C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java:
 1. public final class cfSelect2ecfm2055018563 extends
 coldfusion.runtime.CFPage{ - *** Error: Cannot
 write class file cfSelect2ecfm2055018563.class because that name
 conflicts with the name of the class file
 cfselect2ecfm2055018563.class in directory cfclasses. This is
 illegal because file names are case-insensitive in this system. . 

It probably means that you once had a file called

cfslect2e.cfm

It was opened and compiled a while back. The compiled page was saved to improve 
execution speed.

then you removed it and created a file called

cfSelect2e (note the case of the 's')

and when coldfusion tried to compile it it found that another file with an 
almost identical name existed, but as the cases differ it can't (won't) 
overwrite the original file.

To sole this you need to remove the cfselect2ecfm2055018563.class file from the 
cfroot\webroot\web-inf\cfclasses directory to sole this.

Jesse
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Weird Error Message

2003-03-03 Thread Shahzad.Butt
Thanks, it works after deleting both .class and .java files

-Original Message-
From: Jesse Houwing [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 11:45
To: CF-Talk
Subject: Re: Weird Error Message


Citeren Shahzad.Butt [EMAIL PROTECTED]:

 Today, thinking of normal day I typed in my site address. Clicked on a

 link and its giving following error. Does anyone knows what this error

 is all about and how come its appearing without anything being 
 changed.
 
 Thanks in advance
 
 Errors reported by Java compiler: Found 1 semantic error compiling
 C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java:
 1. public final class cfSelect2ecfm2055018563 extends 
 coldfusion.runtime.CFPage{ - *** Error: Cannot 
 write class file cfSelect2ecfm2055018563.class because that name 
 conflicts with the name of the class file 
 cfselect2ecfm2055018563.class in directory cfclasses. This is 
 illegal because file names are case-insensitive in this system. .

It probably means that you once had a file called

cfslect2e.cfm

It was opened and compiled a while back. The compiled page was saved to
improve 
execution speed.

then you removed it and created a file called

cfSelect2e (note the case of the 's')

and when coldfusion tried to compile it it found that another file with
an 
almost identical name existed, but as the cases differ it can't (won't) 
overwrite the original file.

To sole this you need to remove the cfselect2ecfm2055018563.class file
from the 
cfroot\webroot\web-inf\cfclasses directory to sole this.

Jesse

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Ian Vaughan
Andre

Thanks for the explanation!!

Ok I understand how it is working -

A user fills in the fields and clicks submit the data in entered into the db
with a 'status' field set to a default of 'Pending'

Ok

Then when the form is submitted I use CFMail to send an e-mail to the
approver informing them they have a story to approve. (Is this process
correct ?)

The approver clicks on the link in the e-mail and they are taken to the
'Pending Jobs' Screen.

The approver opens the relevant pending job.

At the bottom of this page there are two buttons 'Approve' and 'Decline'

If the aprrover clicks approve the 'status' field changes to 'approve'

However if the approver clicks decline then the 'status' field stays the
same and an e-mail is sent back to the content owner informing them that the
content has been declined.

Does this make sense logically ??

Or would you add more features and or more advanced settings??


- Original Message -
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 11:24 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,

 Perhaps I can clarify/expand on what Adam suggested:

 1) You do not stop the data entering the database when a story is
 submitted. Instead, it is inserted as normal but you also set another
 column probably in the same table, perhaps named status with a value
 of P for pending when you perform the insert e.g.

 insert into stories
 (story_id, foo, bar, status)
 values
 (666,'Foo','Bar','P')

 2) Only display stories on the website if the status column is not
 P, perhaps only if the status column is A for approved e.g.

 select foo, bar
 from stories
 where status = 'A'

 3) When the approver approves a story to be published, the appropriate
 row in the database gets updated and the status column is changed
 appropriately.

 e.g.

 update stories
 set status = 'A'
 where story_id = 666


 You could extend this model quite simply to allow for multi-level
 approvals and multiple types of status.

 It's important to note that this is not a ColdFusion specific problem.
 It is merely a programming issue and there is more than one way to skin
 a cat.

 Thanks,

 André


 -Original Message-
 From: Ian Vaughan [mailto:[EMAIL PROTECTED]
 Sent: 03 March 2003 11:02
 To: CF-Talk
 Subject: Re: Is it possible to achieve workflow in Coldfusion ???

 Adam

 There is only one administrator or approver.

 How would you achieve this, do you have example code so I can see how it
 may
 function, how do you stop the data entering the database  ??

 As part of the submit page, have it save the document away with a flag
 'pending'.




 - Original Message -
 From: Adam Reynolds [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 9:46 AM
 Subject: RE: Is it possible to achieve workflow in Coldfusion ???


  Ian,
  This is relatively simple. As part of the submit page, have it save
 the
  document away with a flag 'pending'.
 
  Is there just one administrator? Do you want different admin for
 different
  areas of the site? That is the real pain.
 
  You could have a pending approval page that admin can go to to see any
  pending pages. They could then view (AND edit) those pages before
 accepting
  the content or rejecting the comment.
 
  Adam
 
   -Original Message-
   From: Ian Vaughan [mailto:[EMAIL PROTECTED]
   Sent: 03 March 2003 09:38
   To: CF-Talk
   Subject: Is it possible to achieve workflow in Coldfusion ???
  
  
   Hi
  
   I am trying to add a workflow element into a news application, and
 would
   just like to hear if anybody else on the list have been able to
 achieve
   this? or best practices on how to achieve this?
  
   I have an admin form that allows users to add news stories. At
   present when
   the form is submitted the data is entered into the database table.
  
   What I would like to achieve is when the user submits the form an
   e-mail is
   sent to the relevant approver.  They view their e-mail and click
   on the link
   which opens up their admin screen.
  
   From here they can see they have content to approve.  The approver
 reads
   through the story and if they are happy they approve the data and it
 is
   entered into the database and goes live on the site.
  
   If the approver declines the story it sends the user who created
   the content
   an e-mail with why the data was not approved and the changes needed
 to
 be
   made, and the story does not go live on the site.
  
  
  
  
 

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

   

RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Andre Mohamed
Ian,

I see no flaws the logic you outlined; seems perfectly acceptable to me.
As for adding more features and or more advanced settings, that is
entirely dependent on whether they are justified, required or are likely
to be required - something which only you are in a position to judge at
present. If what you outlined is all that you need then I see no reason
to expand.

It is conceivable, as in other workflow systems, that you may in the
future need more than one level of approval i.e. the article/story may
go through a whole chain of people before it is finally ready to be
published e.g. author - editor - creative/formatting - publisher etc.
however, I don't know if that is appropriate for your circumstances but
it might be worth bearing in mind.

Hope you are successful in your endeavors.

Thanks,

André

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 11:54
To: CF-Talk
Subject: Re: Is it possible to achieve workflow in Coldfusion ???

Andre

Thanks for the explanation!!

Ok I understand how it is working -

A user fills in the fields and clicks submit the data in entered into
the db
with a 'status' field set to a default of 'Pending'

Ok

Then when the form is submitted I use CFMail to send an e-mail to the
approver informing them they have a story to approve. (Is this process
correct ?)

The approver clicks on the link in the e-mail and they are taken to the
'Pending Jobs' Screen.

The approver opens the relevant pending job.

At the bottom of this page there are two buttons 'Approve' and 'Decline'

If the aprrover clicks approve the 'status' field changes to 'approve'

However if the approver clicks decline then the 'status' field stays the
same and an e-mail is sent back to the content owner informing them that
the
content has been declined.

Does this make sense logically ??

Or would you add more features and or more advanced settings??


- Original Message -
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 11:24 AM
Subject: RE: Is it possible to achieve workflow in Coldfusion ???


 Ian,

 Perhaps I can clarify/expand on what Adam suggested:

 1) You do not stop the data entering the database when a story is
 submitted. Instead, it is inserted as normal but you also set another
 column probably in the same table, perhaps named status with a value
 of P for pending when you perform the insert e.g.

 insert into stories
 (story_id, foo, bar, status)
 values
 (666,'Foo','Bar','P')

 2) Only display stories on the website if the status column is not
 P, perhaps only if the status column is A for approved e.g.

 select foo, bar
 from stories
 where status = 'A'

 3) When the approver approves a story to be published, the appropriate
 row in the database gets updated and the status column is changed
 appropriately.

 e.g.

 update stories
 set status = 'A'
 where story_id = 666


 You could extend this model quite simply to allow for multi-level
 approvals and multiple types of status.

 It's important to note that this is not a ColdFusion specific problem.
 It is merely a programming issue and there is more than one way to
skin
 a cat.

 Thanks,

 André


 -Original Message-
 From: Ian Vaughan [mailto:[EMAIL PROTECTED]
 Sent: 03 March 2003 11:02
 To: CF-Talk
 Subject: Re: Is it possible to achieve workflow in Coldfusion ???

 Adam

 There is only one administrator or approver.

 How would you achieve this, do you have example code so I can see how
it
 may
 function, how do you stop the data entering the database  ??

 As part of the submit page, have it save the document away with a
flag
 'pending'.




 - Original Message -
 From: Adam Reynolds [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 9:46 AM
 Subject: RE: Is it possible to achieve workflow in Coldfusion ???


  Ian,
  This is relatively simple. As part of the submit page, have it save
 the
  document away with a flag 'pending'.
 
  Is there just one administrator? Do you want different admin for
 different
  areas of the site? That is the real pain.
 
  You could have a pending approval page that admin can go to to see
any
  pending pages. They could then view (AND edit) those pages before
 accepting
  the content or rejecting the comment.
 
  Adam
 
   -Original Message-
   From: Ian Vaughan [mailto:[EMAIL PROTECTED]
   Sent: 03 March 2003 09:38
   To: CF-Talk
   Subject: Is it possible to achieve workflow in Coldfusion ???
  
  
   Hi
  
   I am trying to add a workflow element into a news application, and
 would
   just like to hear if anybody else on the list have been able to
 achieve
   this? or best practices on how to achieve this?
  
   I have an admin form that allows users to add news stories. At
   present when
   the form is submitted the data is entered into the database table.
  
   What I would like to achieve is when the user submits the form an
   e-mail is
   sent to 

Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3

2003-03-03 Thread Peter Mayer
Hello!

I load a text/plain document via cfHTTP and the size is about one 
MegaByte.

Now I have the following problem:

cfset a_str_content = cfhttp.FileContent
cfset a_str_content = ReplaceNoCase(a_str_content, !-- RESULT ITEM END -
-
, chr(9), ALL)

If the http content is smaller (f.e. only 300kb) this works well, but if 
the file is bigger I receive the following error message:

java.lang.StringIndexOutOfBoundsException: String index out of range: -
3

Is this a bug or limitation? Any workarounds?

Updater 2 is installed.

Best regards,

Peter 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3

2003-03-03 Thread webguy
looks like a bug to me. Break up the string into chucks and check each chunk
at a time. Horrible.

WG


-Original Message-
From: Peter Mayer [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 13:20
To: CF-Talk
Subject: Bug? java.lang.StringIndexOutOfBoundsException: String index
out of range: -3


Hello!

I load a text/plain document via cfHTTP and the size is about one
MegaByte.

Now I have the following problem:

cfset a_str_content = cfhttp.FileContent
cfset a_str_content = ReplaceNoCase(a_str_content, !-- RESULT ITEM END -
-
, chr(9), ALL)

If the http content is smaller (f.e. only 300kb) this works well, but if
the file is bigger I receive the following error message:

java.lang.StringIndexOutOfBoundsException: String index out of range: -
3

Is this a bug or limitation? Any workarounds?

Updater 2 is installed.

Best regards,

Peter

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: calculating date recurrence

2003-03-03 Thread Everett, Al
Looks like this will break on a leap year, though.

Try 

calDays=DaysInYear(Now());

 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 28, 2003 4:54 PM
 To: CF-Talk
 Subject: RE: calculating date recurrence
 
 
 Matthew, thanks ... I modified what you showed me to the code 
 below, and it
 works perfectly.
 
 cfscript
   calDays = 365;
   interval = form.TIME_INTERVAL;
   numEvents = calDays \ interval;
 
   variables.myDate = ArrayNew(1);
   variables.myDate[1] =  #form.month#/#form.day#/#form.year#;
   
   for(i=1; i LTE numEvents; i=i+1) {
   arrayAppend(variables.myDate, dateAdd('d', i *
 interval, variables.myDate[1]));
   }
   variables.recurrence_type = Daily;
 /cfscript
 
  -Original Message-
  From:   Matthew Walker [SMTP:[EMAIL PROTECTED]
  Sent:   Thursday, February 27, 2003 5:53 PM
  To: CF-Talk
  Subject:RE: calculating date recurrence
  
  What are you trying to do? Create an array of dates for 
 your recurring
  event? How about this...?
  
  cfset showEventsnDaysInAdvance = 365
  cfset interval = 7
  cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval
  cfset myDates = arrayNew(1)
  
  cfloop from=1 to=#numberOfEventsToShow# index=i
  cfset arrayAppend(myDates, dateAdd(d, i * interval, now()))
  /cfloop
  
  
  -Original Message-
  From: Owens, Howard [mailto:[EMAIL PROTECTED] 
  Sent: Friday, 28 February 2003 1:36 p.m.
  To: CF-Talk
  Subject: calculating date recurrence
  
  OK, I'm working on building my own calendar application.
  
  I'm trying to come up with a way of dealing with recurrence.
  
  The first step is to calculate -- event occures every n 
 days apart, i.e.,
  event occures every 3 days.
  
  Here's one way I've tried so far (but this is like chewing 
 up all the
  processor time)
  
  variables.date = ArrayNew(1);
  variables.date[1] =  #form.month#/#form.day#/#form.year#;
  for(i=1; i LTE 30; i=i+1) {
  x=1;
  while (i  mod form.TIME_INTERVAL){
  variables.date[x] = DateAdd(d, 
 (form.TIME_INTERVAL-1)+x,
  variables.date[1]);
  x=x+1;
  }
  }
  
  Something else I tried, but it creates too many empty array 
 elements:
  
  variables.date = ArrayNew(1);
  variables.date[1] =  #form.month#/#form.day#/#form.year#;
  for(i=1; i LTE 30; i=i+1) {
  if (i  mod TIME_INTERVAL){
   
  }
  else {
  variables.date[i] = DateAdd(d,
  (TIME_INTERVAL-1)+i, variables.date[1]);
  }
  }
  
  I'm open to suggestions.
  
  H.
  
  
  ~~
  Howard Owens
  Internet Operations Coordinator
  InsideVC.com/Ventura County Star
  [EMAIL PROTECTED]
  AIM: GoCatGo1956
  ~~
  
  
  
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



MM : No Cookies = No Updater

2003-03-03 Thread Robertson-Ravo, Neil (RX)
Annoying : We have a machine which has cookies entirely disabled.  We were
installing CF and needed to upgrade; we tried to goto the MM site to get the
second updater but with no cookies it is impossible via normal hyperlink /
login means

The updater should be available for all machines regardless of config!
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Subscription billing management

2003-03-03 Thread Dowdell, Jason G
Hi all,

I have looked into building a subscription management application and have
all of the basics covered.  Payment Type, Subscription Length, Subscription
Amount,
Invoice, Invoice Items, Customer Info, Customer Billing Info, etc...

I was wondering if anyone has something like this out there already.  I've
seen
the application from 2simplifi.com but that's the only one I've seen.  I'm
looking
for an open source app and will purchase it if necessary.

Any help in this area would be much appreciated.

Thanks,
Jason

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



OT SQL Question

2003-03-03 Thread Tangorre, Michael
Can someone assist me with a quick SQL statement.
 
I have a table with 3 columns:  A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C and vice versa.
 
TIA,
 
Mike
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT SQL Question

2003-03-03 Thread webguy
SQL server ? use a format like this..

INSERT author_sales
EXECUTE
('
SELECT ''EXEC STRING'', authors.au_id, authors.au_lname,
   SUM(titles.price * sales.qty)
   FROM authors INNER JOIN titleauthor
  ON authors.au_id = titleauthor.au_id INNER JOIN titles
  ON titleauthor.title_id = titles.title_id INNER JOIN sales
  ON titles.title_id = sales.title_id
   WHERE authors.au_id like ''8%''
   GROUP BY authors.au_id, authors.au_lname
')

wg

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 14:36
To: CF-Talk
Subject: OT SQL Question


Can someone assist me with a quick SQL statement.

I have a table with 3 columns:  A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C and vice
versa.

TIA,

Mike




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT SQL Question

2003-03-03 Thread Tangorre, Michael
SQL 7

does this still apply?


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:42 AM
To: CF-Talk
Subject: RE: OT SQL Question


SQL server ? use a format like this..

INSERT author_sales
EXECUTE
('
SELECT ''EXEC STRING'', authors.au_id, authors.au_lname,
   SUM(titles.price * sales.qty)
   FROM authors INNER JOIN titleauthor
  ON authors.au_id = titleauthor.au_id INNER JOIN titles
  ON titleauthor.title_id = titles.title_id INNER JOIN sales
  ON titles.title_id = sales.title_id
   WHERE authors.au_id like ''8%''
   GROUP BY authors.au_id, authors.au_lname
')

wg

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 14:36
To: CF-Talk
Subject: OT SQL Question


Can someone assist me with a quick SQL statement.

I have a table with 3 columns:  A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C and vice
versa.

TIA,

Mike





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT SQL Question

2003-03-03 Thread webguy
yeap actually simplier...

INSERT t1
SELECT a as a , b as c ,c as b
FROM t1

TEST b4 you do it

WG

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 14:44
To: CF-Talk
Subject: RE: OT SQL Question


SQL 7

does this still apply?


-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:42 AM
To: CF-Talk
Subject: RE: OT SQL Question


SQL server ? use a format like this..

INSERT author_sales
EXECUTE
('
SELECT ''EXEC STRING'', authors.au_id, authors.au_lname,
   SUM(titles.price * sales.qty)
   FROM authors INNER JOIN titleauthor
  ON authors.au_id = titleauthor.au_id INNER JOIN titles
  ON titleauthor.title_id = titles.title_id INNER JOIN sales
  ON titles.title_id = sales.title_id
   WHERE authors.au_id like ''8%''
   GROUP BY authors.au_id, authors.au_lname
')

wg

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 14:36
To: CF-Talk
Subject: OT SQL Question


Can someone assist me with a quick SQL statement.

I have a table with 3 columns:  A, B, C (A would be the primary key)
I need to swap the values in column B with the values in column C and vice
versa.

TIA,

Mike






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT SQL Question

2003-03-03 Thread Cantrell, Adam
Are you talking about a one time query to change the values stored in the
DB?


UPDATE tableName
SET 
tableName.B = tableName.C,
tableName.C = tableName.B
WHERE tableName.A = tableName.A

Adam.




 -Original Message-
 From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 8:36 AM
 To: CF-Talk
 Subject: OT SQL Question
 
 
 Can someone assist me with a quick SQL statement.
  
 I have a table with 3 columns:  A, B, C (A would be the primary key)
 I need to swap the values in column B with the values in 
 column C and vice versa.
  
 TIA,
  
 Mike
  
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF5/CFMX/NT/UNIX ??

2003-03-03 Thread Jerry Johnson
Before scrapping these machines, what kind of Suns are they?

What models/# procs/specs?

In my experience, a Sun e250 can handle similar traffic to a cluster of NT boxes.
Sparc stations about 2 to 1 advantage on NT boxes.

Does the AS400 connection need to be real time, or is it more for batch processing and 
periodic inventory database syncing? Last I used them, the AS400 odbc drivers were 
stable but slow from Cold Fusion 5.

But if you've got Websphere running, it seems like CFMX might be a good addition to 
Websphere, rather than a replacement.

So, no help from here, just more questions,
Jerry Johnson

 [EMAIL PROTECTED] 02/28/03 05:11PM 
Hello Folks,

Who out there has experience running CF in an NT environment and also a Unix 
environment on a LARGE scale?  We were previously CF (4.5), and moved to Java 
(Websphere).  Now there is question of going back to CF which is great.  There are 24 
Sun Solaris Machines onsite each with a license of CF5.  

1) should they stick with CF5
2) should they move to CFMX
3) Should they scrap machines and move to NT?!?

Also, the need to connect to an AS400 to get product information is critical 
(possible?)

We do not have to get into this on the list if you would like to email me privately ...

[EMAIL PROTECTED] 

Thank you
Paul Giesenhagen
QuillDesign


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT SQL Question

2003-03-03 Thread Stephen Hait
 Can someone assist me with a quick SQL statement.
 
 I have a table with 3 columns:  A, B, C (A would be the primary key)
 I need to swap the values in column B with the values in column C
 and vice versa.

This should work with MS SQL assuming columns b and c are 
the same data type:
UPDATE t1
SET b=c, c=b

Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



App Suggestions

2003-03-03 Thread Luis Lebron
The company I work for is looking for an application that will let us create
a document online based on an outline. The author should be able to modify
the outline (move, delete and add sections) and the document would follow
the changes in the outline. The outline would be shown as a tree menu on
the left and the document would be on the right. The application should let
us search a database of boilerplate text and select sections to be added to
the document. We should also be able to manage the documents online. 

I have searched Macromedia's Developer Exchange and cfextras but I haven't
found anything that meets all the requirements.

thanks, 

Luis R. Lebron
Project Manager
Sigmatech, Inc

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: App Suggestions

2003-03-03 Thread Paul Giesenhagen
Though SiteDirector is considered a Commerce application, it may fit your
needs below.  Our heirarchy is very flexible allowing multiple depths
(unlimited) of a tree structure.

So instead of thinking in Departments, content and products, you could think
of the departments as steps in your outline

Note the outline below  this could be either an outline or a department
structure.
A. Men's Clothing
1 Shirts
a) long sleeve
1a) button down
2b) henley
b) short sleeve
2 Pants
a) pleated
b) non-pleated

Each of the departments or outline points could have content associated with
it ...  Since SiteDirector is open source, you can modify the templates to
provide the look and feel you are looking for.

Just a suggestion ... let us know if you have any questions (off-list).

Thank you
Paul Giesenhagen
QuillDesign



- Original Message -
From: Luis Lebron [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:16 AM
Subject: App Suggestions


 The company I work for is looking for an application that will let us
create
 a document online based on an outline. The author should be able to modify
 the outline (move, delete and add sections) and the document would follow
 the changes in the outline. The outline would be shown as a tree menu on
 the left and the document would be on the right. The application should
let
 us search a database of boilerplate text and select sections to be added
to
 the document. We should also be able to manage the documents online.

 I have searched Macromedia's Developer Exchange and cfextras but I haven't
 found anything that meets all the requirements.

 thanks,

 Luis R. Lebron
 Project Manager
 Sigmatech, Inc

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX DSN woes

2003-03-03 Thread Pete Ruckelshaus
I cannot for the life of me configure a DSN in the CF MX Administrator.  I have tried 
to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 
DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to 
connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool 
while attempting to connect, please check your username, password, URL, and other 
connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. 
 I have updated the JET and MDAC, and have run Updater 2.  I am running MX Enterprise 
on localhost running the built-in web server on port 8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me this error 
whether I have the database set up for no security or for a DB User with appropriate 
rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with SQL Server auth 
set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String Format 
checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX DSN woes

2003-03-03 Thread Mike Townend
CFMX will only connect to SQLServer databases setup for SQL Server logins...
What happens if you try to set the DB up through the sa account?



-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 3, 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes


I cannot for the life of me configure a DSN in the CF MX Administrator.  I
have tried to configure both an Oracle Native DSN (on a remote server) and
an MS SQL Server 2000 DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info. The root cause was that: java.sql.SQLException:
SQLException occurred in JDBCPool while attempting to connect, please check
your username, password, URL, and other connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS SQL
Server DSN.  I have updated the JET and MDAC, and have run Updater 2.  I am
running MX Enterprise on localhost running the built-in web server on port
8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me
this error whether I have the database set up for no security or for a DB
User with appropriate rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with SQL
Server auth set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String
Format checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Ann: Cost Effective Content Management Free Seminar

2003-03-03 Thread Steve Drucker
Cost: FREE

March 6th: Atlanta GA
March 18th: Washington, DC

More info and registration at
http://training.figleaf.com/figleaftraining/Courses/freecms.cfm

For all you CMS vendors out there who would like me to review your products
for future inclusion in this seminar, please contact me off-list.



Course Objectives  
-Review the capabilities you should be looking for in a content management
system 
-Compare and contrast the functionality and price points of four
industry-leading content management systems 
-Build awareness of common pitfalls that may occur during CMS
implementations and deployments 
 
 
Course Outline  
-What is content management? 
-Content management principals 
-Content management pitfalls 
-Comparing and contrasting four CM Solutions 
   Macromedia Contribute 
   Ektron CMS 100/200/300 
   Paperthin CommonSpot 3.2 
   Microsoft Content Management Server 2002 
 
---

Quotes from prior attendees:

The seminar format was useful too. Started out with a broad introduction,
then demos of Macromedia Contribute with a little DreamWeaver thrown in,
Ektron (with details of the gotchas in the 3 different products),
CommonSpot, and MS CMS 2002 (which I knew would bore me to tears, so I left
before that demo started). All in all, it was a useful seminar.

 
I sat through Fig Leaf's free CMS seminar. It was extremely informative for
me and my team, focusing on the evaluation criteria as much as anything
else. More importantly, the presenter (Steve Drucker) was without preference
for a single solution. I'd highly recommend that if you are just getting
started in your CMS journey, you should consider sitting through Steve's
session.


Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
1-877-FIG-LEAF

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX DSN woes

2003-03-03 Thread Dave Watts
 I am using the following settings:
 DSN: cm
 database: cm (this is a database in my 
 local instance of SQL Server)
 server: (local)

Try the IP address or FQDN - I don't think JDBC recognizes (local).

 port: 1433
 username: system OR cm (system with only windows 
 security set, cm with SQL Server auth set)
 password: [none] or password

You can't use Windows security, only SQL Server logins. You might want to
test the account from the ODBC control panel, by setting up an ODBC
datasource for testing.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFMX DSN woes

2003-03-03 Thread Pete Ruckelshaus
That, and changing the server name to my machine name in all caps did the
trick.  Thanks!

The Oracle issue persists, but I would prefer to prototype with SQL Server
anyway...

Pete
- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:38 AM
Subject: RE: CFMX DSN woes


 CFMX will only connect to SQLServer databases setup for SQL Server
logins...
 What happens if you try to set the DB up through the sa account?



 -Original Message-
 From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 3, 2003 15:36
 To: CF-Talk
 Subject: CFMX DSN woes


 I cannot for the life of me configure a DSN in the CF MX Administrator.  I
 have tried to configure both an Oracle Native DSN (on a remote server) and
 an MS SQL Server 2000 DSN (on localhost) and get this error:

 Connection verification failed for data source: cm
 []java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
 to connect, please check your username, password, URL, and other
 connectivity info. The root cause was that: java.sql.SQLException:
 SQLException occurred in JDBCPool while attempting to connect, please
check
 your username, password, URL, and other connectivity info.

 Interestingly, I get the same error for both the Oracle DSN and the MS SQL
 Server DSN.  I have updated the JET and MDAC, and have run Updater 2.  I
am
 running MX Enterprise on localhost running the built-in web server on port
 8500.

 Right now, I need to get the SQL Server DSN up and running.  It gives me
 this error whether I have the database set up for no security or for a DB
 User with appropriate rights, and a userid/password assigned.

 I am using the following settings:
 DSN: cm
 database: cm (this is a database in my local instance of SQL Server)
 server: (local)
 port: 1433
 username: system OR cm (system with only windows security set, cm with SQL
 Server auth set)
 password: [none] or password

 Everything else is default except I have Unicode enabled in the String
 Format checkbox and I have CLOB enabled.

 Can someone help me?  Oddly, Access DSN's work fine.

 Thanks,

 Pete
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFMX DSN woes

2003-03-03 Thread Jeff Garza
Actually, you can use trusted connections (Windows Authentication) with SQL
Server, however CFMX will only connect using the account that it is running
as.  We have Domain level service accounts for all our CFMX installations.
If you want to use a Trusted Connection you have to run CFMX as a named
user.  System (which is the Default for CFMX) cannot participate in a domain
or any network sharing for that matter...

Otherwise Mike is correct.  You have to enable SQL Server logins.  As for
Oracle... ??? Don't work with it.

Jeff

- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 8:38 AM
Subject: RE: CFMX DSN woes


CFMX will only connect to SQLServer databases setup for SQL Server logins...
What happens if you try to set the DB up through the sa account?



-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Monday, March 3, 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes


I cannot for the life of me configure a DSN in the CF MX Administrator.  I
have tried to configure both an Oracle Native DSN (on a remote server) and
an MS SQL Server 2000 DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info. The root cause was that: java.sql.SQLException:
SQLException occurred in JDBCPool while attempting to connect, please check
your username, password, URL, and other connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS SQL
Server DSN.  I have updated the JET and MDAC, and have run Updater 2.  I am
running MX Enterprise on localhost running the built-in web server on port
8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me
this error whether I have the database set up for no security or for a DB
User with appropriate rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with SQL
Server auth set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String
Format checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFMX DSN woes

2003-03-03 Thread Jeff Garza
ACK... my bad, the only way to do Trusted connections is by using the
JDBC:ODBC Bridge in CFMX.  (You have to set up a SQL Server ODBC connection
on the server).

Sorry for the confusion... need more coffee...

Jeff
- Original Message -
From: Jeff Garza [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 8:54 AM
Subject: Re: CFMX DSN woes


Actually, you can use trusted connections (Windows Authentication) with SQL
Server, however CFMX will only connect using the account that it is running
as.  We have Domain level service accounts for all our CFMX installations.
If you want to use a Trusted Connection you have to run CFMX as a named
user.  System (which is the Default for CFMX) cannot participate in a domain
or any network sharing for that matter...

Otherwise Mike is correct.  You have to enable SQL Server logins.  As for
Oracle... ??? Don't work with it.

Jeff

- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 8:38 AM
Subject: RE: CFMX DSN woes


CFMX will only connect to SQLServer databases setup for SQL Server logins...
What happens if you try to set the DB up through the sa account?



-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Monday, March 3, 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes


I cannot for the life of me configure a DSN in the CF MX Administrator.  I
have tried to configure both an Oracle Native DSN (on a remote server) and
an MS SQL Server 2000 DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info. The root cause was that: java.sql.SQLException:
SQLException occurred in JDBCPool while attempting to connect, please check
your username, password, URL, and other connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS SQL
Server DSN.  I have updated the JET and MDAC, and have run Updater 2.  I am
running MX Enterprise on localhost running the built-in web server on port
8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me
this error whether I have the database set up for no security or for a DB
User with appropriate rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with SQL
Server auth set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String
Format checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX DSN woes

2003-03-03 Thread Andre Mohamed
Pete,

There is a patch floating around somewhere for CF's administrator which
gives you more meaningful error messages when connecting to data sources
other than the generic JDBC pool error. Search macromedia.com

For SQL Server:

1) Make sure you are using Mixed Mode Authentication (not Windows only).
2) Make sure your password is not more than 16 chars.
3) Do not use (local) as the server.

Hope this helps. Setting up a SQL data source should be a snap.

Thanks,

André

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 15:36
To: CF-Talk
Subject: CFMX DSN woes

I cannot for the life of me configure a DSN in the CF MX Administrator.
I have tried to configure both an Oracle Native DSN (on a remote server)
and an MS SQL Server 2000 DSN (on localhost) and get this error:

Connection verification failed for data source: cm
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

Interestingly, I get the same error for both the Oracle DSN and the MS
SQL Server DSN.  I have updated the JET and MDAC, and have run Updater
2.  I am running MX Enterprise on localhost running the built-in web
server on port 8500.

Right now, I need to get the SQL Server DSN up and running.  It gives me
this error whether I have the database set up for no security or for a
DB User with appropriate rights, and a userid/password assigned.

I am using the following settings:
DSN: cm
database: cm (this is a database in my local instance of SQL Server)
server: (local)
port: 1433
username: system OR cm (system with only windows security set, cm with
SQL Server auth set)
password: [none] or password

Everything else is default except I have Unicode enabled in the String
Format checkbox and I have CLOB enabled.

Can someone help me?  Oddly, Access DSN's work fine.

Thanks,

Pete

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFMX for J2EE on JRun 4

2003-03-03 Thread Roman Krutyakov
Hello,

i didnt understand some things about CFMX for J2EE:
 - how to use it without context_root?
 - does it works with subdirs in URL?

Sincerely,
Roman Krutyakov
mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFINPUT required=yes fails in MX?

2003-03-03 Thread Ricq Pattay
It appears that the required=yes option no longer works in cfinput on MX...? I 
haven't used cfinput in over a year, but a co-worker just noticed this behaviour on 
our new MX development box.

cfform name=myForm action=blank.cfm
cfinput name=test  required=Yes  message=Enter something, dumbo
input type=submit name=submit value=submit
/cfform

The above form is submitted even when test is blank.



Ricq Pattay
Senior Analyst/Programmer
College of Veterinary Medicine
University of Minnesota - Twin Cities

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFINPUT required=yes fails in MX?

2003-03-03 Thread Ricq Pattay
Never mind, our server guy fixed it. The file form.js was not in the
expected place because of a virtual server issue. Adding a
/CFIDE/ alias to the apache conf file fixed the problem.


- Original Message -
From: Ricq Pattay [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:38 AM
Subject: CFINPUT required=yes fails in MX?


 It appears that the required=yes option no longer works in cfinput on
MX...? I haven't used cfinput in over a year, but a co-worker just noticed
this behaviour on our new MX development box.

 cfform name=myForm action=blank.cfm
 cfinput name=test  required=Yes  message=Enter something,
dumbo
 input type=submit name=submit value=submit
 /cfform

 The above form is submitted even when test is blank.



 Ricq Pattay
 Senior Analyst/Programmer
 College of Veterinary Medicine
 University of Minnesota - Twin Cities

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CF 5.0 Admin switched to CF 4.5 Express Admin - how can I get bac k CF 5.0 Admin?

2003-03-03 Thread Earl, George
Our CF 5.0 development server was hit with nimda. We are running CF 5.0 SP2.
Since our server guys ran the nimda fix, instead of getting the CF 5.0
Administrator we get the CF 4.5 Express Administrator! If I go to the
Version Info page in the CF 4.5 Express Admin it shows the version as 5.0,
Service Pack 2, Build 2195 and the serial number is correct.

How should I fix this? Is there a way I can replace the CF 4.5 Express Admin
with the original CF 5.0 Admin without having to reinstall CF 5.0? Or should
I be suspect of the CF 5.0 install and reinstall it anyway? If the latter,
where can I find SP2 for CF 5.0? I went to the download pages for CF and all
I see is individual Hot Fixes, no SP2 . . .

Thanks!

George
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Question about Datasources and connections

2003-03-03 Thread Ciliotta, Mario
Hi,

I was wondering if anyone might be able to assist me.  I have been having problems 
lately with my CF server returning the following error messages:

Unable to instantiate environment for 'ORACLE80.'
Unable to instantiate environment for 'ODBC.'

It seems to be happening more and more lately and I have been unable to find a 
solution.  I am currently running Cf 4.5 on Windows NT.  I use either or Oracle or 
SqlServer depending on the application.  I can send more information if needed (like 
timeout request and such as soon as get an admin to look into the setting).  I am just 
wondering what might be causing these errors.

I was told to use the Native Drivers for Oracle and OLE-DB for my SQLServer 
connections.  Is this correct or should I be using ODBC for SqlServer.  My DBA's will 
not let me use ODBC for Oracle - only native Drivers.

Thanks in advance,

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX Updater 2 to blame?

2003-03-03 Thread Bryan Stevenson
Hey All,

I saw a few threads in Google Groups on this, but not enough to solve my
problem (Jochem if you're out thereyou helped someone else with the same
problem).

I'm able to setup SQL2K datasources using Windows Datasource utility just
fine, but they don't show in CF Admin.  If I try and add them through CF
Admin I get this:


Connection verification failed for data source: RightStuffDatingDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.
-

The thread I saw referenced a file called jrpatch.jar, but doesn't say
where to get it or what to do with it (although I know it's installed with
CFMX).

So any help would be great because not being able to add datasources is a
tad limiting ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



What CF version are the CF server behaviors in DWMX?

2003-03-03 Thread Earl, George
Are the CF server behaviors that come with Dreamweaver MX written
specifically for CFMX? If we are still using CF 5.0 should we avoid using
these server behaviors? (I'm sure some think we should avoid using the
behaviors regardless of version considerations . . . but I have to ask the
question.)  Thanks!

George
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF 5.0 Admin switched to CF 4.5 Express Admin - how can I get bac k CF 5.0 Admin?

2003-03-03 Thread Dave Watts
 Our CF 5.0 development server was hit with 
 nimda. We are running CF 5.0 SP2. Since our 
 server guys ran the nimda fix, instead of 
 getting the CF 5.0 Administrator we get the 
 CF 4.5 Express Administrator! If I go to the
 Version Info page in the CF 4.5 Express Admin 
 it shows the version as 5.0, Service Pack 2, 
 Build 2195 and the serial number is correct.
 
 How should I fix this? Is there a way I can 
 replace the CF 4.5 Express Admin with the 
 original CF 5.0 Admin without having to reinstall 
 CF 5.0? Or should I be suspect of the CF 5.0 
 install and reinstall it anyway? If the latter,
 where can I find SP2 for CF 5.0? I went to the 
 download pages for CF and all I see is individual 
 Hot Fixes, no SP2 . . .

First, the CF Administrator is just a web application, so as long as you can
find the CF 5 version of it floating around, just put it in the right place
and it'll work.

Second, those version and SP numbers refer to Windows, I think, not CF.
You're running Win2K SP2. I don't think there is an SP2 for CF5.

Let me know offlist if you need any assistance.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX Updater 2 to blame?

2003-03-03 Thread Andre Mohamed
Bryan,

Did you try the usual:

1) Make sure you're using mixed mode authentication on SQL server.
2) Make sure your passwords are not more than 16 chars.
3) Make sure you aren't using (local) as the server etc.

Thanks,

André

PS

Good luck with the dating web app!

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: 03 March 2003 17:59
To: CF-Talk
Subject: CFMX Updater 2 to blame?

Hey All,

I saw a few threads in Google Groups on this, but not enough to solve my
problem (Jochem if you're out thereyou helped someone else with the
same
problem).

I'm able to setup SQL2K datasources using Windows Datasource utility
just
fine, but they don't show in CF Admin.  If I try and add them through CF
Admin I get this:


Connection verification failed for data source: RightStuffDatingDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password,
URL, and other connectivity info.
-

The thread I saw referenced a file called jrpatch.jar, but doesn't say
where to get it or what to do with it (although I know it's installed
with
CFMX).

So any help would be great because not being able to add datasources is
a
tad limiting ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX Updater 2 to blame?

2003-03-03 Thread Dave Watts
 I'm able to setup SQL2K datasources using Windows 
 Datasource utility just fine, but they don't show 
 in CF Admin.

Are you using SQL Server logins, or Windows Authentication? You have to use
SQL Server logins.

Are you using default or named SQL Server instances? If you're using named
instances, they'll be listening at non-default ports, and you'll have to
have installed SQL Server SP2 or higher.

Did you specify the IP address and port of the server in the CF
Administrator? You can't use Windows machine names, unless they also resolve
via DNS.

If you post your datasource information, it might help. The jrpatch.jar file
just gives you more verbose error information, but you can probably solve
your problem without it.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX Updater 2 to blame?

2003-03-03 Thread Chris Kief
The diagnostic jar file can be found here:

http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full

chris


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:59 AM
To: CF-Talk
Subject: CFMX Updater 2 to blame?

Hey All,

I saw a few threads in Google Groups on this, but not enough to solve my
problem (Jochem if you're out thereyou helped someone else with the
same
problem).

I'm able to setup SQL2K datasources using Windows Datasource utility just
fine, but they don't show in CF Admin.  If I try and add them through CF
Admin I get this:


Connection verification failed for data source: RightStuffDatingDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.
-

The thread I saw referenced a file called jrpatch.jar, but doesn't say
where to get it or what to do with it (although I know it's installed with
CFMX).

So any help would be great because not being able to add datasources is a
tad limiting ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cookie expiration date seems incorrect

2003-03-03 Thread E. Keith Dodd
From last week:

Tested the cookie-setting page with the Httpanalyzer. It (header info) does
show the cookie being set as I wanted it, and I can see the correct
expiration date. I reverted back to original code to simply set the expires
attribute (on cfcookie) as 30 (for 30 days). All looked fine.

I guess I can only see the cookie information in the header of the template
where the cookie is actually being set. There isn't a *cookie reader* that
can give expiration date, etc.?

Thanks for help, Dave. Helped me clarify what was going on and with a tool
to gather information.

E. Keith Dodd
Wings of Eagles Services
www.wingserv.com


 First, when you set the expiration date, that information is sent to the
 browser, but not returned when the browser sends the cookie back to the
 server. It's only used by the browser to determine when it should get rid
of
 the cookie. So, you won't see that information anywhere in your CF
 variables, using CFDUMP.

 Second, when you set a cookie, the browser sees something like this:

 Set-Cookie: CFID=251232; expires=Sun, 27-Sep-2037 00:00:00 GMT;
 path=/;

 This HTTP header contains all the information for the cookie, including
the
 expiration date. When you use EXPIRES=NEVER, as in the above example,
the
 cookie is actually set to expire in the relatively distant future, many
 years from now.

 Now, when I used CFCOOKIE like so:

 cfcookie name=foo value=bar expires=2/27/2002

 it generated this:

 Set-Cookie: FOO=bar;expires=Wed, 27-Feb-2002 22:22:05 GMT;path=/

 You might find it useful to look at these HTTP headers. One easy way to do
 that is with HTTP Analyzer:

 http://ftp.coolfusion.com/pub/ods/httpanalyzer/httpanalyzer.zip

 You may also want to play around with different date formats; I seem to
 recall just generating a valid GMT date myself in the past, and using
that,
 but it's been a while.

 Finally, if you want the cookie to expire in 30 days, why not just say so?

 cfcookie name=foo value=bar expires=30

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




-
[This E-mail scanned for viruses by declude AntiVirus Software]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF5/CFMX/NT/UNIX ??

2003-03-03 Thread Sean A Corfield
On Monday, Mar 3, 2003, at 06:55 US/Pacific, Jerry Johnson wrote:
 But if you've got Websphere running, it seems like CFMX might be a 
 good addition to Websphere, rather than a replacement.

I'd second that. CFMX for J2EE WebSphere edition. Protects the 
investment in hardware and software already made and provides all the 
benefits of both J2EE and CFMX.

 [EMAIL PROTECTED] 02/28/03 05:11PM 
 Who out there has experience running CF in an NT environment and also 
 a Unix environment on a LARGE scale?

Out of curiosity, define LARGE.

 There are 24 Sun Solaris Machines onsite each with a license of CF5.

It would be interesting to know what sort of spec these are?

 1) should they stick with CF5

So you're running both CF5 *and* WebSphere? You mentioned you were 
running CF4.5 before.

 2) should they move to CFMX

See above. CFMX on WebSphere would seem a good choice.

 3) Should they scrap machines and move to NT?!?

What are they running WebSphere on? Unix or NT? Buying enough NT iron 
to match the compute power of those Sun boxes could prove pretty 
expensive.

Macromedia is pretty much all Solaris in production and Allaire was all 
Windows so one of the questions after the merger was whether to move to 
Windows. In order to support our traffic levels on Windows, we would 
have spent a lot of money buying additional hardware. Furthermore, the 
majority of our IT staff are more familiar with Unix than Windows, from 
a development and production point of view, so there would have needed 
to be quite a bit of training involved. Windows would have been a very 
expensive change for us. The systems that we inherited from Allaire 
still run on Windows but as we introduce new systems to replace those, 
they will most likely be deployed on our Solaris infrastructure.

Note: in case it needs saying, I'm talking about Macromedia IT who 
build and support the website, as opposed to Macromedia product teams 
who develop CF, JRun etc.

 Also, the need to connect to an AS400 to get product information is 
 critical (possible?)

At least one person on this list has CFMX talking to an AS400 so 
hopefully they'll chime in.

 We do not have to get into this on the list if you would like to email 
 me privately

I think it will be interesting to hear people's experiences.

Sean A Corfield -- http://www.corfield.org/blog/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: What CF version are the CF server behaviors in DWMX?

2003-03-03 Thread Dave Watts
 Are the CF server behaviors that come with 
 Dreamweaver MX written specifically for CFMX? 
 If we are still using CF 5.0 should we avoid 
 using these server behaviors? (I'm sure some 
 think we should avoid using the behaviors 
 regardless of version considerations . . . 
 but I have to ask the question.)  Thanks!

So far, all the ones I've looked at work fine with CF 5. I thought that the
authentication ones might use CFLOGIN, which is new to CFMX, but they
apparently don't.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



SOLVED: Re: CFMX Updater 2 to blame?

2003-03-03 Thread Bryan Stevenson
Dave helped me offlist...

I had to use SQL Server Authentication when setting up the datasource in
Windows ODBC.

Thanks Dave and all that replied

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:04 AM
Subject: RE: CFMX Updater 2 to blame?


  I'm able to setup SQL2K datasources using Windows
  Datasource utility just fine, but they don't show
  in CF Admin.

 Are you using SQL Server logins, or Windows Authentication? You have to
use
 SQL Server logins.

 Are you using default or named SQL Server instances? If you're using named
 instances, they'll be listening at non-default ports, and you'll have to
 have installed SQL Server SP2 or higher.

 Did you specify the IP address and port of the server in the CF
 Administrator? You can't use Windows machine names, unless they also
resolve
 via DNS.

 If you post your datasource information, it might help. The jrpatch.jar
file
 just gives you more verbose error information, but you can probably solve
 your problem without it.

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



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF5/CFMX/NT/UNIX ??

2003-03-03 Thread Paul Giesenhagen
Sean,

Please read below!

- Original Message -
From: Sean A Corfield [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 11:18 AM
Subject: Re: CF5/CFMX/NT/UNIX ??


 On Monday, Mar 3, 2003, at 06:55 US/Pacific, Jerry Johnson wrote:
  But if you've got Websphere running, it seems like CFMX might be a
  good addition to Websphere, rather than a replacement.

 I'd second that. CFMX for J2EE WebSphere edition. Protects the
 investment in hardware and software already made and provides all the
 benefits of both J2EE and CFMX.

We are running WebSphere on an AS400 -- So we need to have our CFMX machines
talk to the DB2 DB

  [EMAIL PROTECTED] 02/28/03 05:11PM 
  Who out there has experience running CF in an NT environment and also
  a Unix environment on a LARGE scale?

 Out of curiosity, define LARGE.

50,000 uniques and above per day.  30,000 product sku's


  There are 24 Sun Solaris Machines onsite each with a license of CF5.

 It would be interesting to know what sort of spec these are?

The are Sun 450's -  4 processor machines


  1) should they stick with CF5

 So you're running both CF5 *and* WebSphere? You mentioned you were
 running CF4.5 before.

We are running CF5 ...for some applications and WebSphere powers the
commerce site


  2) should they move to CFMX

 See above. CFMX on WebSphere would seem a good choice.

  3) Should they scrap machines and move to NT?!?

 What are they running WebSphere on? Unix or NT? Buying enough NT iron
 to match the compute power of those Sun boxes could prove pretty
 expensive.

 Macromedia is pretty much all Solaris in production and Allaire was all
 Windows so one of the questions after the merger was whether to move to
 Windows. In order to support our traffic levels on Windows, we would
 have spent a lot of money buying additional hardware. Furthermore, the
 majority of our IT staff are more familiar with Unix than Windows, from
 a development and production point of view, so there would have needed
 to be quite a bit of training involved. Windows would have been a very
 expensive change for us. The systems that we inherited from Allaire
 still run on Windows but as we introduce new systems to replace those,
 they will most likely be deployed on our Solaris infrastructure.

 Note: in case it needs saying, I'm talking about Macromedia IT who
 build and support the website, as opposed to Macromedia product teams
 who develop CF, JRun etc.


The problem today is that our 5 different Sun machines are rebooted
automatically ever 20 minutes.  If they don't about every 30 minutes all the
memory leaks out and the machines lock up.  My comment about this is that
there are so many people running cf5 in the same environment, why can't we
keep our systems running.  The group is pretty stuborn about being wrong ..
it's easier to blame MM ... becauase Allaire CF 4.0 ran pretty bad on the
Suns.


  Also, the need to connect to an AS400 to get product information is
  critical (possible?)

 At least one person on this list has CFMX talking to an AS400 so
 hopefully they'll chime in.

I would love to hear from them.


  We do not have to get into this on the list if you would like to email
  me privately

 I think it will be interesting to hear people's experiences.

We shall see

Paul Giesenhagen
QuillDesign

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: blue dragon and coolfusion iMS

2003-03-03 Thread Pete Freitag
Yes with ActivMail you can use a ColdFusion query to supply the email
addresses, or a list. You can also personalize the content in the message
using the query columns. Is that what you mean by Does it handle mailing
lists?

_
Pete Freitag
CTO, CFDEV.COM
http://www.cfdev.com/


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 7:30 PM
To: CF-Talk
Subject: RE: blue dragon and coolfusion iMS


Does it handle mailing lists?

H.


 -Original Message-
 From: Pete Freitag [SMTP:[EMAIL PROTECTED]
 Sent: Friday, February 28, 2003 4:37 PM
 To:   CF-Talk
 Subject:  RE: blue dragon and coolfusion iMS

  Is anybody running iMS on a Blue Dragon server?  How's the performance?
 Do
  they work well and play well together? Have they been tested together?

 If you need a high end email solution for Blue Dragon ActivMail works
 great
 on it. It's written in Java, so it should work on all but the free
 versions
 of BD.

 _
 Pete Freitag
 CTO, CFDEV.COM
 http://www.cfdev.com/



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: blue dragon and coolfusion iMS

2003-03-03 Thread Owens, Howard
I mean a CF-Talk type of mailing list ... a discussion list.

H.


 -Original Message-
 From: Pete Freitag [SMTP:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 10:46 AM
 To:   CF-Talk
 Subject:  RE: blue dragon and coolfusion iMS
 
 Yes with ActivMail you can use a ColdFusion query to supply the email
 addresses, or a list. You can also personalize the content in the message
 using the query columns. Is that what you mean by Does it handle mailing
 lists?
 
 _
 Pete Freitag
 CTO, CFDEV.COM
 http://www.cfdev.com/
 
 
 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 28, 2003 7:30 PM
 To: CF-Talk
 Subject: RE: blue dragon and coolfusion iMS
 
 
 Does it handle mailing lists?
 
 H.
 
 
  -Original Message-
  From:   Pete Freitag [SMTP:[EMAIL PROTECTED]
  Sent:   Friday, February 28, 2003 4:37 PM
  To: CF-Talk
  Subject:RE: blue dragon and coolfusion iMS
 
   Is anybody running iMS on a Blue Dragon server?  How's the
 performance?
  Do
   they work well and play well together? Have they been tested together?
 
  If you need a high end email solution for Blue Dragon ActivMail works
  great
  on it. It's written in Java, so it should work on all but the free
  versions
  of BD.
 
  _
  Pete Freitag
  CTO, CFDEV.COM
  http://www.cfdev.com/
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: blue dragon and coolfusion iMS

2003-03-03 Thread Pete Freitag
Oh, you could certainly send the messages with it, but there is nothing
built-in to receive the messages. So to answer your question: no, not out of
the box.

_
Pete Freitag
CTO, CFDEV.COM
http://www.cfdev.com/

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 1:26 PM
To: CF-Talk
Subject: RE: blue dragon and coolfusion iMS


I mean a CF-Talk type of mailing list ... a discussion list.

H.


 -Original Message-
 From: Pete Freitag [SMTP:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 10:46 AM
 To:   CF-Talk
 Subject:  RE: blue dragon and coolfusion iMS

 Yes with ActivMail you can use a ColdFusion query to supply the email
 addresses, or a list. You can also personalize the content in the message
 using the query columns. Is that what you mean by Does it handle mailing
 lists?

 _
 Pete Freitag
 CTO, CFDEV.COM
 http://www.cfdev.com/


 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 28, 2003 7:30 PM
 To: CF-Talk
 Subject: RE: blue dragon and coolfusion iMS


 Does it handle mailing lists?

 H.


  -Original Message-
  From:   Pete Freitag [SMTP:[EMAIL PROTECTED]
  Sent:   Friday, February 28, 2003 4:37 PM
  To: CF-Talk
  Subject:RE: blue dragon and coolfusion iMS
 
   Is anybody running iMS on a Blue Dragon server?  How's the
 performance?
  Do
   they work well and play well together? Have they been tested together?
 
  If you need a high end email solution for Blue Dragon ActivMail works
  great
  on it. It's written in Java, so it should work on all but the free
  versions
  of BD.
 
  _
  Pete Freitag
  CTO, CFDEV.COM
  http://www.cfdev.com/
 
 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX and debug output

2003-03-03 Thread Bryan Stevenson
Hey All,

I haven't been using my local box for development for a while (working off
client machines).  Anyways, I was happily cleaning up my local dev
environment and found that debugging doesn't seem to be working in MX!!
Anybody run across this one?

I'm on Win2K/IIS/CFMX w/ updater 2
I've got these addresses in for debugging:
-localhost
-127.0.0.1
-the internal IP and the external IP of the server
-debugging is turned on

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



dynamically created session variables

2003-03-03 Thread Ali Daniali
I'm trying to load form variables into session variables in an
application...but I'm having problems with the creating dynamically created
session variable names. Any help is appreciated.

CFLOOP index=FieldName list=#Form.FieldNames#
CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
SCOPE=SESSION
CFSET Session.#FieldName# = #Evaluate(FieldName)#
/CFLOCK
/CFLOOP

Thanks,
Ali

---
This message (including any attachments) may contain 
confidential and privileged information.  If you are 
not the intended recipient, please notify the sender 
and delete all copies of the original message without 
using or disclosing it.  Thank you.
---



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Question about Datasources and connections

2003-03-03 Thread LI, Chunshen .Don.
Mario,

I'll be happy to assist offline if you send me more
detailed problem description.

Don Li

--- Ciliotta, Mario [EMAIL PROTECTED] wrote:
 Hi,
 
 I was wondering if anyone might be able to assist
 me.  I have been having problems lately with my CF
 server returning the following error messages:
 
 Unable to instantiate environment for 'ORACLE80.'
 Unable to instantiate environment for 'ODBC.'
 
 It seems to be happening more and more lately and I
 have been unable to find a solution.  I am currently
 running Cf 4.5 on Windows NT.  I use either or
 Oracle or SqlServer depending on the application.  I
 can send more information if needed (like timeout
 request and such as soon as get an admin to look
 into the setting).  I am just wondering what might
 be causing these errors.
 
 I was told to use the Native Drivers for Oracle and
 OLE-DB for my SQLServer connections.  Is this
 correct or should I be using ODBC for SqlServer.  My
 DBA's will not let me use ODBC for Oracle - only
 native Drivers.
 
 Thanks in advance,
 
 Mario
 
 This message is for the named person's use only. It
 may contain sensitive and private proprietary or
 legally privileged information. No confidentiality
 or privilege is waived or lost by any
 mistransmission. If you are not the intended
 recipient, please immediately delete it and all
 copies of it from your system, destroy any hard
 copies of it and notify the sender. You must not,
 directly or indirectly, use, disclose, distribute,
 print, or copy any part of this message if you are
 not the intended recipient. CREDIT SUISSE GROUP and
 each legal entity in the CREDIT SUISSE FIRST BOSTON
 or CREDIT SUISSE ASSET MANAGEMENT business units of
 CREDIT SUISSE FIRST BOSTON reserve the right to
 monitor all e-mail communications through its
 networks. Any views expressed in this message are
 those of the individual sender, except where the
 message states otherwise and the sender is
 authorized to state them to be the views of any such
 entity.
 Unless otherwise stated, any pricing information
 given in this message is indicative  only, is
 subject to change and does not constitute an offer
 to deal at any price quoted. Any reference to the
 terms of executed transactions should be treated as 
 preliminary only and subject to our formal written
 confirmation.
 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Everett, Al
 -Original Message-
 From: Ali Daniali [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 1:48 PM
 To: CF-Talk
 Subject: dynamically created session variables
 
 
 I'm trying to load form variables into session variables in an
 application...but I'm having problems with the creating 
 dynamically created
 session variable names. Any help is appreciated.
 
 CFLOOP index=FieldName list=#Form.FieldNames#
   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 SCOPE=SESSION
   CFSET Session.#FieldName# = #Evaluate(FieldName)#
   /CFLOCK
 /CFLOOP
 
 Thanks,
 Ali
 
 ---
 This message (including any attachments) may contain 
 confidential and privileged information.  If you are 
 not the intended recipient, please notify the sender 
 and delete all copies of the original message without 
 using or disclosing it.  Thank you.
 ---
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Everett, Al
Try this:

CFSET Session.#FieldName# = Evaluate(FieldName)

 -Original Message-
 From: Ali Daniali [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 1:48 PM
 To: CF-Talk
 Subject: dynamically created session variables
 
 
 I'm trying to load form variables into session variables in an
 application...but I'm having problems with the creating 
 dynamically created
 session variable names. Any help is appreciated.
 
 CFLOOP index=FieldName list=#Form.FieldNames#
   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 SCOPE=SESSION
   CFSET Session.#FieldName# = #Evaluate(FieldName)#
   /CFLOCK
 /CFLOOP
 
 Thanks,
 Ali
 
 ---
 This message (including any attachments) may contain 
 confidential and privileged information.  If you are 
 not the intended recipient, please notify the sender 
 and delete all copies of the original message without 
 using or disclosing it.  Thank you.
 ---
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



verity and PDF's

2003-03-03 Thread Cantrell, Adam
Has anyone ever had a PDF with 'selectable text' that verity will show as
being indexed, but won't return in the results when searched for? When I say
selectable text, I mean that I can open it up in acrobat reader, click on
the text cursor button 'T', and then swipe blocks of text - there may be an
official term for this.

When I dump the results of a blank search, it's showing up but the summary
field is blank. I'm assuming this has something to do with it? Is there
anything special I should look for in the PDF that would prevent its text
from being exposed to verity - I've got about 300 others that are working
just fine.

Any help would be appreciated. Adam.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



dynamically created session variables

2003-03-03 Thread ali daniali
When I make this change I get the following error:

A CFML variable name cannot end with a . character.  
The variable Session. ends with a . character. You must supply an additional 
structure key or delete the . character.
The CFML compiler was processing:

a CFSET tag beginning on line 3, column 18.
a CFSET tag beginning on line 3, column 18.
 
  
The Error Occurred in : line 3
 
1 : CFLOOP index=FieldName list=#Form.FieldNames#
2 : CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION 
3 : CFSET Session.#FieldName# = #Evaluate(FieldName)#
4 : /CFLOCK
5 : /CFLOOP

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



dynamically created session variables

2003-03-03 Thread ali daniali
I see my mistake I need to have double quotes around Session.#FieldName# ...now it 
works.

Thanks,
Ali
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Need help configuring web server CF

2003-03-03 Thread Robert Shaw
I'm a newbie to server admin, I configured cf to use a new webserver per the 
docs. I have a webserver whose webroot is /soft/www/test. The new webserver 
has a webroot of /soft/www/mytest. I created a mapping /new/  
/soft/www/mytest; but that did not work. What else do I need to do for this 
new webserver to be able to see the cfm pages.

Let give you more details

ORIGINAL --site = http://workarea.senecac.on.ca
NEW SITE -site  =http://saturn.senecac.on.ca:85/testing --click on
JavaCFXMacromediaDemo+

Both are iplanet webservers. cfm pages displays perfectly on
http://workarea.senecac.on.ca.

TIA,
Ron







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Ben Doom
IIRC, you need to do

cfset session[#fieldname#] = evaluate(fieldname)


--  Ben Doom
Programmer  General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Ali Daniali [mailto:[EMAIL PROTECTED]
: Sent: Monday, March 03, 2003 1:48 PM
: To: CF-Talk
: Subject: dynamically created session variables
:
:
: I'm trying to load form variables into session variables in an
: application...but I'm having problems with the creating
: dynamically created
: session variable names. Any help is appreciated.
:
: CFLOOP index=FieldName list=#Form.FieldNames#
:   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
: SCOPE=SESSION
:   CFSET Session.#FieldName# = #Evaluate(FieldName)#
:   /CFLOCK
: /CFLOOP
:
: Thanks,
: Ali
:
: ---
: This message (including any attachments) may contain
: confidential and privileged information.  If you are
: not the intended recipient, please notify the sender
: and delete all copies of the original message without
: using or disclosing it.  Thank you.
: ---
:
:
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: calculating date recurrence

2003-03-03 Thread Matthew Walker
Actually that variable is just the number of days to look ahead, so it won't
break it.

- Original Message -
From: Everett, Al [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 2:37 AM
Subject: RE: calculating date recurrence


 Looks like this will break on a leap year, though.

 Try

 calDays=DaysInYear(Now());

  -Original Message-
  From: Owens, Howard [mailto:[EMAIL PROTECTED]
  Sent: Friday, February 28, 2003 4:54 PM
  To: CF-Talk
  Subject: RE: calculating date recurrence
 
 
  Matthew, thanks ... I modified what you showed me to the code
  below, and it
  works perfectly.
 
  cfscript
  calDays = 365;
  interval = form.TIME_INTERVAL;
  numEvents = calDays \ interval;
 
  variables.myDate = ArrayNew(1);
  variables.myDate[1] =  #form.month#/#form.day#/#form.year#;
 
  for(i=1; i LTE numEvents; i=i+1) {
  arrayAppend(variables.myDate, dateAdd('d', i *
  interval, variables.myDate[1]));
  }
  variables.recurrence_type = Daily;
  /cfscript
 
   -Original Message-
   From: Matthew Walker [SMTP:[EMAIL PROTECTED]
   Sent: Thursday, February 27, 2003 5:53 PM
   To: CF-Talk
   Subject: RE: calculating date recurrence
  
   What are you trying to do? Create an array of dates for
  your recurring
   event? How about this...?
  
   cfset showEventsnDaysInAdvance = 365
   cfset interval = 7
   cfset numberOfEventsToShow = showEventsnDaysInAdvance \ interval
   cfset myDates = arrayNew(1)
  
   cfloop from=1 to=#numberOfEventsToShow# index=i
   cfset arrayAppend(myDates, dateAdd(d, i * interval, now()))
   /cfloop
  
  
   -Original Message-
   From: Owens, Howard [mailto:[EMAIL PROTECTED]
   Sent: Friday, 28 February 2003 1:36 p.m.
   To: CF-Talk
   Subject: calculating date recurrence
  
   OK, I'm working on building my own calendar application.
  
   I'm trying to come up with a way of dealing with recurrence.
  
   The first step is to calculate -- event occures every n
  days apart, i.e.,
   event occures every 3 days.
  
   Here's one way I've tried so far (but this is like chewing
  up all the
   processor time)
  
   variables.date = ArrayNew(1);
   variables.date[1] =  #form.month#/#form.day#/#form.year#;
   for(i=1; i LTE 30; i=i+1) {
   x=1;
   while (i  mod form.TIME_INTERVAL){
   variables.date[x] = DateAdd(d,
  (form.TIME_INTERVAL-1)+x,
   variables.date[1]);
   x=x+1;
   }
   }
  
   Something else I tried, but it creates too many empty array
  elements:
  
   variables.date = ArrayNew(1);
   variables.date[1] =  #form.month#/#form.day#/#form.year#;
   for(i=1; i LTE 30; i=i+1) {
   if (i  mod TIME_INTERVAL){
  
   }
   else {
   variables.date[i] = DateAdd(d,
   (TIME_INTERVAL-1)+i, variables.date[1]);
   }
   }
  
   I'm open to suggestions.
  
   H.
  
  
   ~~
   Howard Owens
   Internet Operations Coordinator
   InsideVC.com/Ventura County Star
   [EMAIL PROTECTED]
   AIM: GoCatGo1956
   ~~
  
  
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



recurrence engine

2003-03-03 Thread Owens, Howard
Thanks to all who helped figure some of this stuff out.

FWIW:  Here's the calendar recurrence engine I built:


cfscript

// events may or may not have an end_date
if (Len(form.day_end)) {
end_date = #form.month_end#/#form.day_end#/#form.year_end#;   }
else {
end_date = 'NULL';
}


// run through case statements for which kind of recurrance this is 
switch (#form.RECURRENCE_TYPE#) {
// if onetime date entry, create a single element array
case OneTime: {
mydate = ArrayNew(1);
mydate[1] = #form.month#/#form.day#/#form.year#;

// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}

case Daily: {
calDays = 365;
interval = form.TIME_INTERVAL_daily;
numEvents = calDays \ interval;

myDate = ArrayNew(1);
myDate[1] =  #form.month#/#form.day#/#form.year#;

for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('d', i *
interval,myDate[1]));
}
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}

case Weekly: {
calDays = 365;
interval = form.TIME_INTERVAL_weekly;
numEvents = calDays \ interval;
numEvents = numEvents \ 7;

myDate = ArrayNew(1);
myDate[1] =  #form.month#/#form.day#/#form.year#;

for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('d', (i * 7) *
interval,myDate[1]));
}
// get the final date of the array
finalDate=myDate[arrayLen(myDate)];
break;
}

case Monthly: {
// calculate month recurrence 
// udf can be found here: http://www.cflib.org/udf.cfm?ID=179
// udf modified to loop over 12 months past a change of year ... 

calMonths = 12;
interval = form.TIME_INTERVAL_monthly;
numEvents = calMonths \ interval;
firstDate =
DayOfWeek('#form.month#/#form.day#/#form.year#');

/* check to see if pattern is specific date of each month, 
 * or Nth occurance of each day of the month */
if (form.PATTERN is specificdate){
// create array and seed with first date
myDate = ArrayNew(1);
myDate[1] =  '#form.month#/#form.day#/#form.year#';

// loop over number of events for the year and create
date-specific array
for(i=1; i LTE numEvents; i=i+1) {
arrayAppend(myDate, dateAdd('m', i *
interval,myDate[1]));
}
}
Else {
// or use UDF to get the Nth day of the month for each month
for a year out
startDate = GetNthOccOfDayInMonth(form.EVERY_N, firstDate,
form.Month, form.Year);

// create array and seed with first date
myDate = ArrayNew(1);
myDate[1] =  #form.month#/#startDate#/#form.year#;

/* loop over UDF
 * new month is each new month integer for 12 months through
the loop
 * calcMonth contains the incremental integer so we can loop
over 
 * 12 months and recognize that we're dealing with a new
year
 * when that happens, we calculate what month starting in
Jan. we're dealing with
*/
for(i=1; i LTE 12; i=i+1) {
newMonth=form.Month+i;
calcMonth=form.Month+i;
if (calcMonth GTE 13) {
useYear=form.Year+1;
newMonth=i-(12-form.month); }
else {useYear=form.Year;}
newDate =
GetNthOccOfDayInMonth(form.EVERY_N, firstDate, newMonth, useYear);
arrayAppend(myDate,
'#newMonth#/#newDate#/#useYear#');
}

}

// get the final date of the array
finalDate=myDate[arrayLen(myDate)];

break;
}

case Yearly: {

break;
}

default: {

break;
}

}
/cfscript



~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


RE: dynamically created session variables

2003-03-03 Thread Barney Boisvert
Kill that evaluate() too:

cfset session[fieldname] = form[fieldname] /

 -Original Message-
 From: Ben Doom [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 11:03 AM
 To: CF-Talk
 Subject: RE: dynamically created session variables


 IIRC, you need to do

 cfset session[#fieldname#] = evaluate(fieldname)


 --  Ben Doom
 Programmer  General Lackey
 Moonbow Software, Inc

 : -Original Message-
 : From: Ali Daniali [mailto:[EMAIL PROTECTED]
 : Sent: Monday, March 03, 2003 1:48 PM
 : To: CF-Talk
 : Subject: dynamically created session variables
 :
 :
 : I'm trying to load form variables into session variables in an
 : application...but I'm having problems with the creating
 : dynamically created
 : session variable names. Any help is appreciated.
 :
 : CFLOOP index=FieldName list=#Form.FieldNames#
 : CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 : SCOPE=SESSION
 : CFSET Session.#FieldName# = #Evaluate(FieldName)#
 : /CFLOCK
 : /CFLOOP
 :
 : Thanks,
 : Ali
 :
 : ---
 : This message (including any attachments) may contain
 : confidential and privileged information.  If you are
 : not the intended recipient, please notify the sender
 : and delete all copies of the original message without
 : using or disclosing it.  Thank you.
 : ---
 :
 :
 :
 :
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Raymond Camden
Or even better:

cfset session[fieldname] = form[fieldname]

No need for evaluate, or all those #s and s.

You can also do:

cfset structAppend(session,form)

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Ben Doom [mailto:[EMAIL PROTECTED] 
 Sent: Monday, March 03, 2003 1:03 PM
 To: CF-Talk
 Subject: RE: dynamically created session variables
 
 
 IIRC, you need to do
 
 cfset session[#fieldname#] = evaluate(fieldname)
 
 
 --  Ben Doom
 Programmer  General Lackey
 Moonbow Software, Inc
 
 : -Original Message-
 : From: Ali Daniali [mailto:[EMAIL PROTECTED]
 : Sent: Monday, March 03, 2003 1:48 PM
 : To: CF-Talk
 : Subject: dynamically created session variables
 :
 :
 : I'm trying to load form variables into session variables in an
 : application...but I'm having problems with the creating
 : dynamically created
 : session variable names. Any help is appreciated.
 :
 : CFLOOP index=FieldName list=#Form.FieldNames#
 : CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 : SCOPE=SESSION
 : CFSET Session.#FieldName# = #Evaluate(FieldName)#
 : /CFLOCK
 : /CFLOOP
 :
 : Thanks,
 : Ali
 :
 : ---
 : This message (including any attachments) may contain
 : confidential and privileged information.  If you are
 : not the intended recipient, please notify the sender
 : and delete all copies of the original message without
 : using or disclosing it.  Thank you.
 : ---
 :
 :
 :
 : 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: What CF version are the CF server behaviors in DWMX?

2003-03-03 Thread Massimo, Tiziana e Federica
 Are the CF server behaviors that come with Dreamweaver MX written
 specifically for CFMX? If we are still using CF 5.0 should we avoid using
 these server behaviors?

You are safe with CF 5.0 and maybe even with CF 4.5



 (I'm sure some think we should avoid using the
 behaviors regardless of version considerations . . . but I have to ask the
 question.)  Thanks!

Sure, people think that in order to be professional you don't use that sort
of tools; of course, images are also best done in any hex editor... Okay it
takes a while but it's very professional, Photoshop or Fireworks are just
girlie tools  :-)))

BTW One of the most powerful and unsung feature in DW is the ability to
create your own Server Behaviors using a GUI; basically you can teach DW MX
to write the code the way you prefer.

For additional details, check the docs for Server Behaviors Builder.


Massimo Foti
Team Macromedia Volunteer for Dreamweaver
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.macromedia.com/go/team








~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Barney Boisvert
Make sure you add a third parameter to structAppend() for whether or not you
want to overwrite values.  And note that it'll add EVERYTHING in the FORM
scope, which may or may not be what you want.

 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 11:18 AM
 To: CF-Talk
 Subject: RE: dynamically created session variables


 Or even better:

 cfset session[fieldname] = form[fieldname]

 No need for evaluate, or all those #s and s.

 You can also do:

 cfset structAppend(session,form)

 ===
 Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
 Member of Team Macromedia

 Email: [EMAIL PROTECTED]
 Blog : www.camdenfamily.com/morpheus/blog
 Yahoo IM : morpheus

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

  -Original Message-
  From: Ben Doom [mailto:[EMAIL PROTECTED]
  Sent: Monday, March 03, 2003 1:03 PM
  To: CF-Talk
  Subject: RE: dynamically created session variables
 
 
  IIRC, you need to do
 
  cfset session[#fieldname#] = evaluate(fieldname)
 
 
  --  Ben Doom
  Programmer  General Lackey
  Moonbow Software, Inc
 
  : -Original Message-
  : From: Ali Daniali [mailto:[EMAIL PROTECTED]
  : Sent: Monday, March 03, 2003 1:48 PM
  : To: CF-Talk
  : Subject: dynamically created session variables
  :
  :
  : I'm trying to load form variables into session variables in an
  : application...but I'm having problems with the creating
  : dynamically created
  : session variable names. Any help is appreciated.
  :
  : CFLOOP index=FieldName list=#Form.FieldNames#
  :   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
  : SCOPE=SESSION
  :   CFSET Session.#FieldName# = #Evaluate(FieldName)#
  :   /CFLOCK
  : /CFLOOP
  :
  : Thanks,
  : Ali
  :
  : ---
  : This message (including any attachments) may contain
  : confidential and privileged information.  If you are
  : not the intended recipient, please notify the sender
  : and delete all copies of the original message without
  : using or disclosing it.  Thank you.
  : ---
  :
  :
  :
  :
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: recurrence engine

2003-03-03 Thread Everett, Al
   calDays = 365;

What about leap years?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: calculating date recurrence

2003-03-03 Thread Everett, Al
Ah. Nevermind then.

 -Original Message-
 From: Matthew Walker [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 2:10 PM
 To: CF-Talk
 Subject: Re: calculating date recurrence
 
 
 Actually that variable is just the number of days to look 
 ahead, so it won't
 break it.
 
 - Original Message -
 From: Everett, Al [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, March 04, 2003 2:37 AM
 Subject: RE: calculating date recurrence
 
 
  Looks like this will break on a leap year, though.
 
  Try
 
  calDays=DaysInYear(Now());
 
   -Original Message-
   From: Owens, Howard [mailto:[EMAIL PROTECTED]
   Sent: Friday, February 28, 2003 4:54 PM
   To: CF-Talk
   Subject: RE: calculating date recurrence
  
  
   Matthew, thanks ... I modified what you showed me to the code
   below, and it
   works perfectly.
  
   cfscript
   calDays = 365;
   interval = form.TIME_INTERVAL;
   numEvents = calDays \ interval;
  
   variables.myDate = ArrayNew(1);
   variables.myDate[1] =  #form.month#/#form.day#/#form.year#;
  
   for(i=1; i LTE numEvents; i=i+1) {
   arrayAppend(variables.myDate, dateAdd('d', i *
   interval, variables.myDate[1]));
   }
   variables.recurrence_type = Daily;
   /cfscript
  
-Original Message-
From: Matthew Walker [SMTP:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 5:53 PM
To: CF-Talk
Subject: RE: calculating date recurrence
   
What are you trying to do? Create an array of dates for
   your recurring
event? How about this...?
   
cfset showEventsnDaysInAdvance = 365
cfset interval = 7
cfset numberOfEventsToShow = showEventsnDaysInAdvance 
 \ interval
cfset myDates = arrayNew(1)
   
cfloop from=1 to=#numberOfEventsToShow# index=i
cfset arrayAppend(myDates, dateAdd(d, i * interval, now()))
/cfloop
   
   
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, 28 February 2003 1:36 p.m.
To: CF-Talk
Subject: calculating date recurrence
   
OK, I'm working on building my own calendar application.
   
I'm trying to come up with a way of dealing with recurrence.
   
The first step is to calculate -- event occures every n
   days apart, i.e.,
event occures every 3 days.
   
Here's one way I've tried so far (but this is like chewing
   up all the
processor time)
   
variables.date = ArrayNew(1);
variables.date[1] =  #form.month#/#form.day#/#form.year#;
for(i=1; i LTE 30; i=i+1) {
x=1;
while (i  mod form.TIME_INTERVAL){
variables.date[x] = DateAdd(d,
   (form.TIME_INTERVAL-1)+x,
variables.date[1]);
x=x+1;
}
}
   
Something else I tried, but it creates too many empty array
   elements:
   
variables.date = ArrayNew(1);
variables.date[1] =  #form.month#/#form.day#/#form.year#;
for(i=1; i LTE 30; i=i+1) {
if (i  mod TIME_INTERVAL){
   
}
else {
variables.date[i] = DateAdd(d,
(TIME_INTERVAL-1)+i, variables.date[1]);
}
}
   
I'm open to suggestions.
   
H.
   
   
~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~
   
   
   
  
  
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Java2 Issues (CFTREE) on a Mac

2003-03-03 Thread phil e hebenstreit
Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message
where its supposed to appear that this browser does not support Java2.

Are there any known workarounds to accomplish this (the ability to view a
CFTREE tag control through a Mac browser) ?

Thanks in advance,
phil

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: recurrence engine

2003-03-03 Thread Matthew Walker
It's an arbitrary number. It could be set to 30 or 1000. However, you could
do something like this:

!--- if this is a leap year and the date is before 1 March, or if next year
is a leap year and the date is 1 March or later then look ahead 366
days. ---
cfif (isleapyear(year(now())) and month(now()) lte 2) or
(isleapyear(year(now())+1) and month(now()) gt 2)
cfset calDays = 366
cfelse
cfset calDays = 365
/cfif

Matthew Walker
Electric Sheep Web
http://www.electricsheep.co.nz/

- Original Message -
From: Everett, Al [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 8:22 AM
Subject: RE: recurrence engine


  calDays = 365;

 What about leap years?
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Java2 Issues (CFTREE) on a Mac

2003-03-03 Thread Barney Boisvert
You probably just have to install the Java2 JRE, although I don't know that
for sure.  Most browsers come with Java1 support, not Java2, although that's
probably changing.

 -Original Message-
 From: phil e hebenstreit [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 11:32 AM
 To: CF-Talk
 Subject: Java2 Issues (CFTREE) on a Mac


 Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message
 where its supposed to appear that this browser does not support Java2.

 Are there any known workarounds to accomplish this (the ability to view a
 CFTREE tag control through a Mac browser) ?

 Thanks in advance,
 phil

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Ali Daniali
So with this option I drop the CFLOOP all together, correct?

Thank you all for your help!

-AD

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 11:18 AM
To: CF-Talk
Subject: RE: dynamically created session variables

Or even better:

cfset session[fieldname] = form[fieldname]

No need for evaluate, or all those #s and s.

You can also do:

cfset structAppend(session,form)

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Ben Doom [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 1:03 PM
 To: CF-Talk
 Subject: RE: dynamically created session variables


 IIRC, you need to do

 cfset session[#fieldname#] = evaluate(fieldname)


 --  Ben Doom
 Programmer  General Lackey
 Moonbow Software, Inc

 : -Original Message-
 : From: Ali Daniali [mailto:[EMAIL PROTECTED]
 : Sent: Monday, March 03, 2003 1:48 PM
 : To: CF-Talk
 : Subject: dynamically created session variables
 :
 :
 : I'm trying to load form variables into session variables in an
 : application...but I'm having problems with the creating
 : dynamically created
 : session variable names. Any help is appreciated.
 :
 : CFLOOP index=FieldName list=#Form.FieldNames#
 : CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 : SCOPE=SESSION
 : CFSET Session.#FieldName# = #Evaluate(FieldName)#
 : /CFLOCK
 : /CFLOOP
 :
 : Thanks,
 : Ali
 :
 : ---
 : This message (including any attachments) may contain
 : confidential and privileged information.  If you are
 : not the intended recipient, please notify the sender
 : and delete all copies of the original message without
 : using or disclosing it.  Thank you.
 : ---
 :
 :
 :
 :


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Java2 Issues (CFTREE) on a Mac

2003-03-03 Thread Matthew Small
Try this site:

http://java.sun.com/getjava/download1.html



Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: phil e hebenstreit [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 03, 2003 2:32 PM
To: CF-Talk
Subject: Java2 Issues (CFTREE) on a Mac

Attempting to use CFTREE (CF5) on a Mac (IE 5.22) and getting a message
where its supposed to appear that this browser does not support Java2.

Are there any known workarounds to accomplish this (the ability to view
a
CFTREE tag control through a Mac browser) ?

Thanks in advance,
phil


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Raymond Camden
But it defaults to yes - so if he wants to just copy them over, he can
leave it off. :)

Of course, there is something to be said about including optional args
just as a helpful reminder about what's going on. :)

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
 Sent: Monday, March 03, 2003 1:22 PM
 To: CF-Talk
 Subject: RE: dynamically created session variables
 
 
 Make sure you add a third parameter to structAppend() for 
 whether or not you want to overwrite values.  And note that 
 it'll add EVERYTHING in the FORM scope, which may or may not 
 be what you want.
 
  -Original Message-
  From: Raymond Camden [mailto:[EMAIL PROTECTED]
  Sent: Monday, March 03, 2003 11:18 AM
  To: CF-Talk
  Subject: RE: dynamically created session variables
 
 
  Or even better:
 
  cfset session[fieldname] = form[fieldname]
 
  No need for evaluate, or all those #s and s.
 
  You can also do:
 
  cfset structAppend(session,form)
 
  
 ==
  =
  Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
  Member of Team Macromedia
 
  Email: [EMAIL PROTECTED]
  Blog : www.camdenfamily.com/morpheus/blog
  Yahoo IM : morpheus
 
  My ally is the Force, and a powerful ally it is. - Yoda
 
   -Original Message-
   From: Ben Doom [mailto:[EMAIL PROTECTED]
   Sent: Monday, March 03, 2003 1:03 PM
   To: CF-Talk
   Subject: RE: dynamically created session variables
  
  
   IIRC, you need to do
  
   cfset session[#fieldname#] = evaluate(fieldname)
  
  
   --  Ben Doom
   Programmer  General Lackey
   Moonbow Software, Inc
  
   : -Original Message-
   : From: Ali Daniali [mailto:[EMAIL PROTECTED]
   : Sent: Monday, March 03, 2003 1:48 PM
   : To: CF-Talk
   : Subject: dynamically created session variables
   :
   :
   : I'm trying to load form variables into session variables in an
   : application...but I'm having problems with the creating
   : dynamically created
   : session variable names. Any help is appreciated.
   :
   : CFLOOP index=FieldName list=#Form.FieldNames#
   : CFLOCK TIMEOUT=30  THROWONTIMEOUT=No 
 TYPE=EXCLUSIVE
   : SCOPE=SESSION
   : CFSET Session.#FieldName# = 
 #Evaluate(FieldName)#
   : /CFLOCK
   : /CFLOOP
   :
   : Thanks,
   : Ali
   :
   : ---
   : This message (including any attachments) may contain
   : confidential and privileged information.  If you are
   : not the intended recipient, please notify the sender
   : and delete all copies of the original message without
   : using or disclosing it.  Thank you.
   : ---
   :
   :
   :
   :
  
  
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Raymond Camden
Yes - if you want to copy EVERYTHING over. You will get at least one
'crap' field, fieldnames, which is the list of all the form fields. If
this bugs you, just follow the structAppend with a structDelete.

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

 -Original Message-
 From: Ali Daniali [mailto:[EMAIL PROTECTED] 
 Sent: Monday, March 03, 2003 1:38 PM
 To: CF-Talk
 Subject: RE: dynamically created session variables
 
 
 So with this option I drop the CFLOOP all together, correct?
 
 Thank you all for your help!
 
 -AD
 
 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 11:18 AM
 To: CF-Talk
 Subject: RE: dynamically created session variables
 
 Or even better:
 
 cfset session[fieldname] = form[fieldname]
 
 No need for evaluate, or all those #s and s.
 
 You can also do:
 
 cfset structAppend(session,form)
 
 ==
 =
 Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
 Member of Team Macromedia
 
 Email: [EMAIL PROTECTED]
 Blog : www.camdenfamily.com/morpheus/blog
 Yahoo IM : morpheus
 
 My ally is the Force, and a powerful ally it is. - Yoda
 
  -Original Message-
  From: Ben Doom [mailto:[EMAIL PROTECTED]
  Sent: Monday, March 03, 2003 1:03 PM
  To: CF-Talk
  Subject: RE: dynamically created session variables
 
 
  IIRC, you need to do
 
  cfset session[#fieldname#] = evaluate(fieldname)
 
 
  --  Ben Doom
  Programmer  General Lackey
  Moonbow Software, Inc
 
  : -Original Message-
  : From: Ali Daniali [mailto:[EMAIL PROTECTED]
  : Sent: Monday, March 03, 2003 1:48 PM
  : To: CF-Talk
  : Subject: dynamically created session variables
  :
  :
  : I'm trying to load form variables into session variables in an
  : application...but I'm having problems with the creating
  : dynamically created
  : session variable names. Any help is appreciated.
  :
  : CFLOOP index=FieldName list=#Form.FieldNames#
  :   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
  : SCOPE=SESSION
  :   CFSET Session.#FieldName# = #Evaluate(FieldName)#
  :   /CFLOCK
  : /CFLOOP
  :
  : Thanks,
  : Ali
  :
  : ---
  : This message (including any attachments) may contain
  : confidential and privileged information.  If you are
  : not the intended recipient, please notify the sender
  : and delete all copies of the original message without
  : using or disclosing it.  Thank you.
  : ---
  :
  :
  :
  :
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: anybody ever done: every n day of the month for a year ...

2003-03-03 Thread Ian Skinner
Don't know what you found in the UDF, probably better then what I got, but
this is something I created a couple of years ago, that automatically
calculates the 2nd Tuesday of the Month for our CFUG meetings.  I'll have to
look into the UDF at cflib.

cfset Month = Month(Now())
cfswitch expression=#DayOfWeek(CreateDate(Year(Now ()), Month, 1))#
cfcase value=3cfset dayoffset = 1/cfcase
cfcase value=2cfset dayoffset = 2/cfcase
cfcase value=1cfset dayoffset = 3/cfcase
cfcase value=7cfset dayoffset = 4/cfcase
cfcase value=6cfset dayoffset = 5/cfcase
cfcase value=5cfset dayoffset = 6/cfcase
cfcase value=4cfset dayoffset = 7/cfcase
/cfswitch

cfif CreateDateTime(Year(Now ()), Month, 7 + dayoffset, 18, 30, 59) LTE
Now()
cfset Month = Month + 1
cfif Month EQ 13
cfset Month = 1
/cfif
cfswitch expression=#DayOfWeek(CreateDate(Year(Now ()), Month,
1))#
cfcase value=3cfset dayoffset = 1/cfcase
cfcase value=2cfset dayoffset = 2/cfcase
cfcase value=1cfset dayoffset = 3/cfcase
cfcase value=7cfset dayoffset = 4/cfcase
cfcase value=6cfset dayoffset = 5/cfcase
cfcase value=5cfset dayoffset = 6/cfcase
cfcase value=4cfset dayoffset = 7/cfcase
/cfswitch
/cfif

cfset Next Meeting = CreateDateTime(Year(Now ()), Month, 7 + dayoffset, 18,
30, 59)

Ian


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:22 PM
To: CF-Talk
Subject: anybody ever done: every n day of the month for a year ... 


Just to save me spending too much time trying to figure this out ...

Anybody already have a code snippet for calculating every N day of the
Month, for a year ... 

Such as, Every 3rd Tuesday of the month?

That's where I'm at on building my little recurrance engine.  I'll spit the
whole code back out the list when it's done, if anybody wants it.

H.


~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: dynamically created session variables

2003-03-03 Thread Joe Eugene
 CFSET Session.#FieldName# = #Evaluate(FieldName)#

You have a few choices

1. cfset session['#myFieldName#'] = form.someField
2. structAppend(session, form); // simple struct copy
3. session.frmStruct = duplicate(form); // deep copy

Hope this helps.
Joe Eugene



 -Original Message-
 From: Ali Daniali [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 1:48 PM
 To: CF-Talk
 Subject: dynamically created session variables


 I'm trying to load form variables into session variables in an
 application...but I'm having problems with the creating
 dynamically created
 session variable names. Any help is appreciated.

 CFLOOP index=FieldName list=#Form.FieldNames#
   CFLOCK TIMEOUT=30  THROWONTIMEOUT=No TYPE=EXCLUSIVE
 SCOPE=SESSION
   CFSET Session.#FieldName# = #Evaluate(FieldName)#
   /CFLOCK
 /CFLOOP

 Thanks,
 Ali

 ---
 This message (including any attachments) may contain
 confidential and privileged information.  If you are
 not the intended recipient, please notify the sender
 and delete all copies of the original message without
 using or disclosing it.  Thank you.
 ---



 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Help porting ASP to CF

2003-03-03 Thread Andres
Hello Everyone,
I am in the process of porting some code from ASP to CF. The code interfaces with a 
COM object which requires an array as input variables and then returns several other 
arrays as response variables. I am having difficulties writing the CF code that will 
allow me to call and pass these variables and receive the right info accordingly.

This is the ASP code that generates the Address info array the COM function needs:
'***
  Dim asSearch, i
  ReDim asSearch (Request(SearchInput).Count - 1)
  for i = 1 to Request(SearchInput).Count
asSearch(i - 1) = Request(SearchInput)(i)
  next
'***

This is the cf code i wrote to do the same thing
!--- * ---
cfset addressArray = arraynew(1)  !--- 
create address info array ---
cfset counter = 0
cfloop collection=#form# item=pointer !--- populate 
array with collection elements ---
cfset counter = counter + 1
cfoutput#pointer#=#evaluate(pointer)#/cfoutput
cfset addressArray[counter] = #evaluate(pointer)#
/cfloop
!--- * ---

The ASP code that actually executes the COM function is as follows:
'***
Dim QuickAddress
  Set QuickAddress = Server.CreateObject(QAS.QAProWeb)

Dim iPotential, asPreviews, asTags, aiFlags, aiScores
QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch, iPotential, asPreviews, 
asTags, aiFlags, aiScores
'***

I don't really know how to call that function in the same was ASP does in CF. The 
resulting variables (asPreviews, asTags, aiFlags, aiScores) contain arrays of data 
each. How can i tell CF to run this function and put the right info in the right 
variables?

thanks!

andres
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



JRun Config to Hotload Objects?

2003-03-03 Thread Joe Eugene
I think myself or someone else asked this question a while ago...
Can remember now. 

Where is the xml config to Hotload Objects? What *.xml and
element/Attribute?

Thanks
Joe Eugene




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Help porting ASP to CF

2003-03-03 Thread Matthew Small
What kind of data is request(searchinut)? 

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Andres [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 03, 2003 3:24 PM
To: CF-Talk
Subject: Help porting ASP to CF

Hello Everyone,
I am in the process of porting some code from ASP to CF. The code
interfaces with a COM object which requires an array as input variables
and then returns several other arrays as response variables. I am having
difficulties writing the CF code that will allow me to call and pass
these variables and receive the right info accordingly.

This is the ASP code that generates the Address info array the COM
function needs:
'***
  Dim asSearch, i
  ReDim asSearch (Request(SearchInput).Count - 1)
  for i = 1 to Request(SearchInput).Count
asSearch(i - 1) = Request(SearchInput)(i)
  next
'***

This is the cf code i wrote to do the same thing
!--- * ---
cfset addressArray = arraynew(1)
!--- create address info array ---
cfset counter = 0
cfloop collection=#form# item=pointer
!--- populate array with collection elements ---
cfset counter = counter + 1
cfoutput#pointer#=#evaluate(pointer)#/cfoutput
cfset addressArray[counter] = #evaluate(pointer)#
/cfloop
!--- * ---

The ASP code that actually executes the COM function is as follows:
'***
Dim QuickAddress
  Set QuickAddress = Server.CreateObject(QAS.QAProWeb)

Dim iPotential, asPreviews, asTags, aiFlags, aiScores
QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch,
iPotential, asPreviews, asTags, aiFlags, aiScores
'***

I don't really know how to call that function in the same was ASP does
in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores)
contain arrays of data each. How can i tell CF to run this function and
put the right info in the right variables?

thanks!

andres

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Help porting ASP to CF

2003-03-03 Thread Andres
It's a form, the loop goes through all the items in a form that was passed from the 
prior page.

andres

-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 3:32 PM
To: CF-Talk
Subject: RE: Help porting ASP to CF


What kind of data is request(searchinut)? 

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Andres [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 03, 2003 3:24 PM
To: CF-Talk
Subject: Help porting ASP to CF

Hello Everyone,
I am in the process of porting some code from ASP to CF. The code
interfaces with a COM object which requires an array as input variables
and then returns several other arrays as response variables. I am having
difficulties writing the CF code that will allow me to call and pass
these variables and receive the right info accordingly.

This is the ASP code that generates the Address info array the COM
function needs:
'***
  Dim asSearch, i
  ReDim asSearch (Request(SearchInput).Count - 1)
  for i = 1 to Request(SearchInput).Count
asSearch(i - 1) = Request(SearchInput)(i)
  next
'***

This is the cf code i wrote to do the same thing
!--- * ---
cfset addressArray = arraynew(1)
!--- create address info array ---
cfset counter = 0
cfloop collection=#form# item=pointer
!--- populate array with collection elements ---
cfset counter = counter + 1
cfoutput#pointer#=#evaluate(pointer)#/cfoutput
cfset addressArray[counter] = #evaluate(pointer)#
/cfloop
!--- * ---

The ASP code that actually executes the COM function is as follows:
'***
Dim QuickAddress
  Set QuickAddress = Server.CreateObject(QAS.QAProWeb)

Dim iPotential, asPreviews, asTags, aiFlags, aiScores
QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch,
iPotential, asPreviews, asTags, aiFlags, aiScores
'***

I don't really know how to call that function in the same was ASP does
in CF. The resulting variables (asPreviews, asTags, aiFlags, aiScores)
contain arrays of data each. How can i tell CF to run this function and
put the right info in the right variables?

thanks!

andres


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Renaming a DSN bug in MX?

2003-03-03 Thread jon hall
  Ok, here is what I am seeing...can anyone tell me if this is just me
  or a bug? If it's just me, anyone know how to fix it?
  
  - Create an Access DSN called test.
  - Rename DSN to test.renamed.
  - Create SQL Server DSN called test.

  The DSN gets created, but above the list of DSN's I see this error:

  Connection verification failed for data source: test
  []java.sql.SQLException: No datasource named test is configured in 
jrun-resources.xml
  The root cause was that: java.sql.SQLException: No datasource named test is 
configured in jrun-resources.xml

  - Rename the test DSN to test2.
  
  The test2 DSN should now validate and work, renaming it back to test
  will throw the above error again. I have recreated this with
  multiple databases. Whatever is happening it's definitely not
  database specific.

  Are DSN's in MX one time use only? Seems silly, but that's what it
  looks like to me.
  
-- 
 jon
  mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT - Fusebox for Flash?

2003-03-03 Thread Ryan Kime
I was thinking about your email this weekend and happen to run across this
book at the local Barnes  Noble:

Object-Oriented Macromedia Flash MX - William Drol
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=53CY3FBL
DYisbn=1590590147itm=1


HTH,

Ryan Kime

-Original Message-
From: dwayne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 27, 2003 3:43 AM
To: CF-Talk
Subject: OT - Fusebox for Flash?


Is this possible?  I've been looking for a structured development
methodology for rich-applications using Flash.  To me, Fusebox offers a
solid framework for organizing and maintaing code. Is there such a framework
for Flash?  

I've been tinkering with Flash-Remoting and ColdFusion Components for the
past 6 months now but I just can't get with the all over the place coding.



Dwayne Cole, MS in MIS, MBA
Florida AM University
Certified Advanced ColdFusion Developer

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How can I see incoming http request data

2003-03-03 Thread Eric Homa
Hi,

How can I capture and/or view the entire http request.  Have a post that is being 
submitted and it seems that the form.variables are not making it.  I'd like to 
actually see the string coming in.  Any help?

Thanks,

Eric Homa



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Help porting ASP to CF

2003-03-03 Thread Joe Eugene
What is Request(SearchInput).Count?

You are creating an addressArray with the entire form variables,
Are you sure.. these are the parameters to the COM Object?

Look at the COM Object Function.. and check exactly what it requires
as parameters.

Joe Eugene



 -Original Message-
 From: Andres [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 3:24 PM
 To: CF-Talk
 Subject: Help porting ASP to CF


 Hello Everyone,
 I am in the process of porting some code from ASP to CF. The code
 interfaces with a COM object which requires an array as input
 variables and then returns several other arrays as response
 variables. I am having difficulties writing the CF code that will
 allow me to call and pass these variables and receive the right
 info accordingly.

 This is the ASP code that generates the Address info array the
 COM function needs:
 '***
   Dim asSearch, i
   ReDim asSearch (Request(SearchInput).Count - 1)
   for i = 1 to Request(SearchInput).Count
 asSearch(i - 1) = Request(SearchInput)(i)
   next
 '***

 This is the cf code i wrote to do the same thing
 !--- * ---
 cfset addressArray = arraynew(1)
   !--- create address info array ---
 cfset counter = 0
 cfloop collection=#form# item=pointer
 !--- populate array with collection elements ---
   cfset counter = counter + 1
   cfoutput#pointer#=#evaluate(pointer)#/cfoutput
   cfset addressArray[counter] = #evaluate(pointer)#
   /cfloop
 !--- * ---

 The ASP code that actually executes the COM function is as follows:
 '***
 Dim QuickAddress
   Set QuickAddress = Server.CreateObject(QAS.QAProWeb)

 Dim iPotential, asPreviews, asTags, aiFlags, aiScores
 QuickAddress.Search 0, sCountryCode, iPromptSet, asSearch,
 iPotential, asPreviews, asTags, aiFlags, aiScores
 '***

 I don't really know how to call that function in the same was ASP
 does in CF. The resulting variables (asPreviews, asTags, aiFlags,
 aiScores) contain arrays of data each. How can i tell CF to run
 this function and put the right info in the right variables?

 thanks!

 andres
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: How can I see incoming http request data

2003-03-03 Thread jon hall
CF5+ you can use getHTTPRequestData(), or simply start up you favorite
sniffer to watch what is actually going across the wire.

-- 
 jon
 mailto:[EMAIL PROTECTED]

Monday, March 3, 2003, 4:00:25 PM, you wrote:
EH Hi,

EH How can I capture and/or view the entire http request.  Have a post that is being 
submitted and it seems that the form.variables are not making it.  I'd like to 
actually see the string coming in.
EH  Any help?

EH Thanks,

EH Eric Homa

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Renaming a DSN bug in MX?

2003-03-03 Thread jon hall
Just to follow up, restarting the server will allow the SQL Server
test DSN to verify...

-- 
 jon
 mailto:[EMAIL PROTECTED]

Monday, March 3, 2003, 3:42:31 PM, you wrote:
jh   Ok, here is what I am seeing...can anyone tell me if this is just me
jh   or a bug? If it's just me, anyone know how to fix it?
  
jh   - Create an Access DSN called test.
jh   - Rename DSN to test.renamed.
jh   - Create SQL Server DSN called test.

jh   The DSN gets created, but above the list of DSN's I see this error:

jh   Connection verification failed for data source: test
jh   []java.sql.SQLException: No datasource named test is configured in 
jrun-resources.xml
jh   The root cause was that: java.sql.SQLException: No datasource named test is 
configured in jrun-resources.xml

jh   - Rename the test DSN to test2.
  
jh   The test2 DSN should now validate and work, renaming it back to test
jh   will throw the above error again. I have recreated this with
jh   multiple databases. Whatever is happening it's definitely not
jh   database specific.

jh   Are DSN's in MX one time use only? Seems silly, but that's what it
jh   looks like to me.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Query of Queries in CF5 with Subquery

2003-03-03 Thread Edwards Robert (air0rae)
I am using ColdFusion 5 Enterprise Edition.  I have 2 separate oracle
databases that cannot communicate to each other, but the web server can
communicate to them individually.  I am pulling back data from to queries as
such.

Query 1:

Machine1 null   Loc1 
Machine2 null   Loc2
Machine3 null   Loc3 
Machine4 null   Loc4



Query2
null   Machine1 Loc1 
null   Machine3 Loc3 
null   Machine4 Loc4
null   Machine5 Loc5

I am trying to get a union query with nested selects to work as such

Select * from Query1 where Q1MachineName not in (Select Q2MachineName from
Query2)
UNION
Select * from Query2 where Q2MachineName not in (Select Q1MachineName from
Query1)

So I end up with 

Machine2 null   Loc2
null   Machine5 Loc5

The problem is, when I run the union query above, I get the error
Query Manipulation Error Code = 0 
Can't find symbol: select

Any suggestions as to what I am doing wrong?

Thanks,
Rob Edwards


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



XML Transformations using CF 5.0 and below

2003-03-03 Thread ksuh
Here's some code that'll use Xalan to transform an XML document with an XSLT 
stylesheet, for all of us that don't want to use the gawd-awful MSXML COM object and 
don't yet have CFMX.

cfscript
// Create the transformer factory.
transformerFactory = createObject(java, javax.xml.transform.TransformerFactory);
factory = transformerFactory.newInstance();

// XML document
xmlDoc = createObject(java, javax.xml.transform.stream.StreamSource);
// Set the path to the XML document
xmlDoc.setSystemId(c:\inetpub\wwwroot\msol\msol\projecttracker\layout\list.xml);

// XSLT document
xsltDoc = createObject(java, javax.xml.transform.stream.StreamSource);
// Set the path to the XSLT document
xsltDoc.setSystemId(c:\inetpub\wwwroot\msol\msol\projecttracker\layout\menu.xsl);

// Create the transformer.
transformer = factory.newTransformer(xsltDoc);

// Output string
result = createObject(java, java.io.StringWriter);
// We need to do this so that the StringWriter object is actually created.
result.write();

// Create the StreamResult
streamResult = createObject(java, javax.xml.transform.stream.StreamResult);
// Pass the StringWriter to the StreamResult
streamResult.setWriter(result);

// Transform the XML document.
transformer.transform(xmlDoc, streamResult);

// Write it to the screen.  You can do this anytime.
writeOutput(result.toString());
/cfscript

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



ODBC Problems?

2003-03-03 Thread Botts, Tom
I'm getting errors with my MX box trying to connect to an AS/400.  After
about an hour the MX server hangs.  Stopping and starting the ODBC services
generally clears it up.  Just wondering if anyone has any ideas or if anyone
is experiencing similar problems ?  Here is one of the error messages I am
receiving.

:[MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][Client Access Express
ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure.

Thanks.
~~~
 Tom Botts
 Gilbarco Inc.
 336-547-5911 phone
 336-547-5163 fax
 [EMAIL PROTECTED]
 www.gilbarco.com
~~~
 ...OLE_Obj... 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Looping over struct refresher

2003-03-03 Thread webmaster
Brain dead.  

I have an xml file, parsed into a cfstructure.  So now we have
node.node.[number].item  with each node.node.[number] having many items.

How do I loop over this to access the variables?  Set it to an array
somehow?  Any quick pointers would so appreciated as I cannot for the life
of me get my head on straight today.

Regards,

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




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: ODBC Problems?

2003-03-03 Thread Joe Eugene
Sounds like the CFMX ODBC Connection Polling Framework, whatever it
uses might be acting up.
Question is...Has anybody seen problems with CFMX ODBC connections being
dropped?
Either SQL-Server ODBC or any other ODBC configured with CFMX.

Joe Eugene

 -Original Message-
 From: Botts, Tom [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 5:35 PM
 To: CF-Talk
 Subject: ODBC Problems?


 I'm getting errors with my MX box trying to connect to an AS/400.  After
 about an hour the MX server hangs.  Stopping and starting the
 ODBC services
 generally clears it up.  Just wondering if anyone has any ideas
 or if anyone
 is experiencing similar problems ?  Here is one of the error messages I am
 receiving.

 :[MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][Client Access Express
 ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure.

 Thanks.
 ~~~
  Tom Botts
  Gilbarco Inc.
  336-547-5911 phone
  336-547-5163 fax
  [EMAIL PROTECTED]
  www.gilbarco.com
 ~~~
  ...OLE_Obj...


 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: ODBC Problems?

2003-03-03 Thread Matt Robertson
Joe wrote:
Question is...Has anybody seen problems with CFMX ODBC 
connections being dropped?

In MX, I sure have.  I couldn't get reliable performance on dev or live boxes, using 
both Pro and Developer (running as Enterprise before its 30 days were up), unless I 
used the native drivers.  Got the error you described exactly, if I recall correctly.  
Was trying to use SQL Server (latest MSDE), Oracle (9i, I think), mySQL and Access via 
odbc and couldn't get it to work.  In fairness this was in a pre-update initial 
release of cfmx.

---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX and RSS

2003-03-03 Thread Russ
Hi,

I'm trying to find a decent tutorial on bringing down RSS feeds into
CFMX--something that's supposed to be relatively easy, and I don't
dispute that it is, however I need a starting point and my searches
aren't getting me much beyond Full As A Goog.

Can anyone direct me to a good tutorial starting point?

Thanks in advance,

Russ

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Is it possible to achieve workflow in Coldfusion ???

2003-03-03 Thread Owens, Howard
You might want to think about whether there is a required publication date.

For example, if a story is entered, but is embargoed until next week, you
might want to store that publication date and it won't show up on the site
until that date arrives.

H.


 -Original Message-
 From: Ian Vaughan [SMTP:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 3:54 AM
 To:   CF-Talk
 Subject:  Re: Is it possible to achieve workflow in Coldfusion ???
 
 Andre
 
 Thanks for the explanation!!
 
 Ok I understand how it is working -
 
 A user fills in the fields and clicks submit the data in entered into the
 db
 with a 'status' field set to a default of 'Pending'
 
 Ok
 
 Then when the form is submitted I use CFMail to send an e-mail to the
 approver informing them they have a story to approve. (Is this process
 correct ?)
 
 The approver clicks on the link in the e-mail and they are taken to the
 'Pending Jobs' Screen.
 
 The approver opens the relevant pending job.
 
 At the bottom of this page there are two buttons 'Approve' and 'Decline'
 
 If the aprrover clicks approve the 'status' field changes to 'approve'
 
 However if the approver clicks decline then the 'status' field stays the
 same and an e-mail is sent back to the content owner informing them that
 the
 content has been declined.
 
 Does this make sense logically ??
 
 Or would you add more features and or more advanced settings??
 
 
 - Original Message -
 From: Andre Mohamed [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 11:24 AM
 Subject: RE: Is it possible to achieve workflow in Coldfusion ???
 
 
  Ian,
 
  Perhaps I can clarify/expand on what Adam suggested:
 
  1) You do not stop the data entering the database when a story is
  submitted. Instead, it is inserted as normal but you also set another
  column probably in the same table, perhaps named status with a value
  of P for pending when you perform the insert e.g.
 
  insert into stories
  (story_id, foo, bar, status)
  values
  (666,'Foo','Bar','P')
 
  2) Only display stories on the website if the status column is not
  P, perhaps only if the status column is A for approved e.g.
 
  select foo, bar
  from stories
  where status = 'A'
 
  3) When the approver approves a story to be published, the appropriate
  row in the database gets updated and the status column is changed
  appropriately.
 
  e.g.
 
  update stories
  set status = 'A'
  where story_id = 666
 
 
  You could extend this model quite simply to allow for multi-level
  approvals and multiple types of status.
 
  It's important to note that this is not a ColdFusion specific problem.
  It is merely a programming issue and there is more than one way to skin
  a cat.
 
  Thanks,
 
  André
 
 
  -Original Message-
  From: Ian Vaughan [mailto:[EMAIL PROTECTED]
  Sent: 03 March 2003 11:02
  To: CF-Talk
  Subject: Re: Is it possible to achieve workflow in Coldfusion ???
 
  Adam
 
  There is only one administrator or approver.
 
  How would you achieve this, do you have example code so I can see how it
  may
  function, how do you stop the data entering the database  ??
 
  As part of the submit page, have it save the document away with a flag
  'pending'.
 
 
 
 
  - Original Message -
  From: Adam Reynolds [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, March 03, 2003 9:46 AM
  Subject: RE: Is it possible to achieve workflow in Coldfusion ???
 
 
   Ian,
   This is relatively simple. As part of the submit page, have it save
  the
   document away with a flag 'pending'.
  
   Is there just one administrator? Do you want different admin for
  different
   areas of the site? That is the real pain.
  
   You could have a pending approval page that admin can go to to see any
   pending pages. They could then view (AND edit) those pages before
  accepting
   the content or rejecting the comment.
  
   Adam
  
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 09:38
To: CF-Talk
Subject: Is it possible to achieve workflow in Coldfusion ???
   
   
Hi
   
I am trying to add a workflow element into a news application, and
  would
just like to hear if anybody else on the list have been able to
  achieve
this? or best practices on how to achieve this?
   
I have an admin form that allows users to add news stories. At
present when
the form is submitted the data is entered into the database table.
   
What I would like to achieve is when the user submits the form an
e-mail is
sent to the relevant approver.  They view their e-mail and click
on the link
which opens up their admin screen.
   
From here they can see they have content to approve.  The approver
  reads
through the story and if they are happy they approve the data and it
  is
entered into the database and goes live on the site.
   
If the approver declines the story it sends the user who 

RE: ODBC Problems?

2003-03-03 Thread Joe Eugene
if I recall
 correctly.  Was trying to use SQL Server (latest MSDE), Oracle
 (9i, I think), mySQL and Access via odbc and couldn't get it to
 work.

Interesting, Thanks Matt.

Ok, looks like we have a problem with the CFMX ODBC Sever Engine.
Can someone from MM Product Team clarify whats happening?
Is this an MM aware issue, any patches available?

Thanks
Joe Eugene



 -Original Message-
 From: Matt Robertson [mailto:[EMAIL PROTECTED]
 Sent: Monday, March 03, 2003 7:04 PM
 To: CF-Talk
 Subject: RE: ODBC Problems?


 Joe wrote:
 Question is...Has anybody seen problems with CFMX ODBC
 connections being dropped?

 In MX, I sure have.  I couldn't get reliable performance on dev
 or live boxes, using both Pro and Developer (running as
 Enterprise before its 30 days were up), unless I used the native
 drivers.  Got the error you described exactly, if I recall
 correctly.  Was trying to use SQL Server (latest MSDE), Oracle
 (9i, I think), mySQL and Access via odbc and couldn't get it to
 work.  In fairness this was in a pre-update initial release of cfmx.

 ---
  Matt Robertson, [EMAIL PROTECTED]
  MSB Designs, Inc. http://mysecretbase.com
 ---



 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



debug output not working in CFMX

2003-03-03 Thread Bryan Stevenson
Hey All,

I can't get debugging to fly in CFMX.  The second updater is installed, and
I've tried every possible IP.  Debugging is turned on in classic mode, but
nothing shows when CFM pages are run.

Man I hate it when the simple things blow up like this ;-)

TIA for any insight

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



  1   2   >