Starting JRun and CFMX for J2EE at boot on Mac OS X

2003-01-11 Thread Dick Applebaum
A question was asked in an earlier thread - How to start JRun and CFMX 
for J2EE at boot on Mac OS X.

I just posted a procedure at the O'Reilly site:

http://www.oreillynet.com/cs/user/view/cs_msg/13216

The Tomcat install outlined at the O'Reilly site:

http://www.macdevcenter.com/pub/a/mac/2002/06/18/tomcat.html

includes a startup procedure and Tomcat will start CFMX for J2EE.

Note: the O'Reilly site (above) does not include installing CFMX for 
J2EE under Tomcat -- use the instructions that come with the CFMX for 
J2EE Mac package.

Dick


~|
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: CDATA Insert problem

2003-01-11 Thread Jesse Houwing
Webmaster wrote:

Hi,
 Can anyone explain how this happened?  I use Client vars and it looks like
CF got confused and try to insert a duplicate record into the CDATA table.
Has anyone else seen this?

[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key
row in object 'CDATA' with unique index 'id1'.

  

hey... I just got taht error too, and have no idea why it happened.

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




URL Scope

2003-01-11 Thread Yves Arsenault
Hello,
 
I was just wondering (because I have never come across any such
information) if there is a limit to the number of URL variables one can
pass to another CF template.
 
TIA,
 
Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
 


~|
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: URL Scope

2003-01-11 Thread Dick Applebaum
AFAIK, the official limit (total size of the URL) is 2k.

However, many browsers  web servers will handle more.

Best to use post method, which is theoretically unlimited.

Also, as a personal preference, I hate to see/copy/paste/read/click  
long URLs -- yeech!

Dick

On Saturday, January 11, 2003, at 04:03 PM, Yves Arsenault wrote:

 Hello,

 I was just wondering (because I have never come across any such
 information) if there is a limit to the number of URL variables one can
 pass to another CF template.

 TIA,

 Yves Arsenault
 Carrefour Infotech
 5, Acadian Dr.
 Charlottetown, PEI
 C1C 1M2
 [EMAIL PROTECTED]
 (902)368-1895 ext.242



 
~|
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: URL Scope

2003-01-11 Thread Jann VanOver
On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote:

 AFAIK, the official limit (total size of the URL) is 2k.
 
 However, many browsers  web servers will handle more.
 
 Best to use post method, which is theoretically unlimited.
 
 Also, as a personal preference, I hate to see/copy/paste/read/click
 long URLs -- yeech!

But URLS are SO NICE if you want details kept with a bookmark!  And when you
WANT to expose parameters (like a scrolling starting point or number of
items displayed per page)

~|
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




OT: Is there an IIS5/MSFTP guru in the house?

2003-01-11 Thread Lee Fuller
Have what will amount to, most likely, a REALLY silly question.  But need to
talk to someone who's dealt with MSFTP service on IIS5.

Can someone email me off-list?  lee @prime dna. Net (sorry.. spam/collector
killing)

TTAIA


~|
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




Design Pattern Question

2003-01-11 Thread Cutter (CF_Talk)
Has anyone here taken a detailed look at the CFMX (semi) OOP design 
pattern put forth at http://www.benorama.com? Is anyone here using it? 
Formed some opinions? Have anything to add (or subtract)? Know who put 
this together in the first place?

As one of my former commanders used to ask Questions? Comments? War 
Stories?

Cutter

~|
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: Design Pattern Question

2003-01-11 Thread Peter Bagnato
I think that this is a very healthy design methodology for CF.

Ben Forta has been harping for ages about the importance of separating the
display, application, and data layers from the CF applications. 

The methodology outlined in that page presents this to the CF environment.

It actually follows many of the well known and widely used J2EE
methodologies out there. That was something that always bugged me about
FuseBox and other methodologies presented for CF.

Those are just my thoughts:
Peter Bagnato


-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 11:59 PM
To: CF-Talk
Subject: Design Pattern Question

Has anyone here taken a detailed look at the CFMX (semi) OOP design 
pattern put forth at http://www.benorama.com? Is anyone here using it? 
Formed some opinions? Have anything to add (or subtract)? Know who put 
this together in the first place?

As one of my former commanders used to ask Questions? Comments? War 
Stories?

Cutter


~|
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: URL Scope

2003-01-11 Thread Tony Weeg
yves,

i ran into that issue, when i was sending color
variations, in hex to various pages for lines
of reports, i simply store them in client variables
and now hardly even have to use url variables, storing
client vars in a db, and referencing them through cfid
calls to match the values in the db, makes life sooo much
easier, check them out!

later.
tony

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:17 PM
To: CF-Talk
Subject: RE: URL Scope


Thanks!

I had never come across any limit.
I don't think I've ever seen the question posted either.

The list (that's all you people of course) is an awesome resource!!

:-)

Give yourselves a round of applause!!

Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242


-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]] 
Sent: January 11, 2003 9:01 PM
To: CF-Talk
Subject: Re: URL Scope

On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote:

 AFAIK, the official limit (total size of the URL) is 2k.
 
 However, many browsers  web servers will handle more.
 
 Best to use post method, which is theoretically unlimited.
 
 Also, as a personal preference, I hate to see/copy/paste/read/click
 long URLs -- yeech!

But URLS are SO NICE if you want details kept with a bookmark!  And when
you
WANT to expose parameters (like a scrolling starting point or number of
items displayed per page)



~|
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: URL Scope

2003-01-11 Thread Yves Arsenault
Thanks!

I had never come across any limit.
I don't think I've ever seen the question posted either.

The list (that's all you people of course) is an awesome resource!!

:-)

Give yourselves a round of applause!!

Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242


-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]] 
Sent: January 11, 2003 9:01 PM
To: CF-Talk
Subject: Re: URL Scope

On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote:

 AFAIK, the official limit (total size of the URL) is 2k.
 
 However, many browsers  web servers will handle more.
 
 Best to use post method, which is theoretically unlimited.
 
 Also, as a personal preference, I hate to see/copy/paste/read/click
 long URLs -- yeech!

But URLS are SO NICE if you want details kept with a bookmark!  And when
you
WANT to expose parameters (like a scrolling starting point or number of
items displayed per page)


~|
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: URL Scope

2003-01-11 Thread Yves Arsenault
Cool, thanks.

The reason I posted was this:

I have a form which is created dynamically, I want to fill the form with all
of the information that the user has correctly filled in if any errors
occur.
The form basically contains attributes for files that have been submitted to
the admin. The admin then has some options to fill in (who to send file
too...).
There can be 1 file, 10 files, 20 files described in this form. The admin
can fill in information for 1 file at a time if he wishes, so form
validation like required=yes cannot be used.

So on the template that recieves the form information, I check for errors,
if there are any I had thought of sending all of the information back
through URL.
Sometimes, there could be much. I thought there might be a problem.

Would you suggest client variables for this?

TIA,

Yves
- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 11:14 PM
Subject: RE: URL Scope


 yves,

 i ran into that issue, when i was sending color
 variations, in hex to various pages for lines
 of reports, i simply store them in client variables
 and now hardly even have to use url variables, storing
 client vars in a db, and referencing them through cfid
 calls to match the values in the db, makes life sooo much
 easier, check them out!

 later.
 tony

 -Original Message-
 From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, January 11, 2003 8:17 PM
 To: CF-Talk
 Subject: RE: URL Scope


 Thanks!

 I had never come across any limit.
 I don't think I've ever seen the question posted either.

 The list (that's all you people of course) is an awesome resource!!

 :-)

 Give yourselves a round of applause!!

 Yves Arsenault
 Carrefour Infotech
 5, Acadian Dr.
 Charlottetown, PEI
 C1C 1M2
 [EMAIL PROTECTED]
 (902)368-1895 ext.242


 -Original Message-
 From: Jann VanOver [mailto:[EMAIL PROTECTED]]
 Sent: January 11, 2003 9:01 PM
 To: CF-Talk
 Subject: Re: URL Scope

 On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote:

  AFAIK, the official limit (total size of the URL) is 2k.
 
  However, many browsers  web servers will handle more.
 
  Best to use post method, which is theoretically unlimited.
 
  Also, as a personal preference, I hate to see/copy/paste/read/click
  long URLs -- yeech!

 But URLS are SO NICE if you want details kept with a bookmark!  And when
 you
 WANT to expose parameters (like a scrolling starting point or number of
 items displayed per page)



 
~|
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: Detecting Flash for use in CFGraph

2003-01-11 Thread Robert Bailey
Here ya go

http://www.xs4all.nl/~ppk/js/flash.html



 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 


-Original Message-
From: Antony Sideropoulos [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:16 PM
To: CF-Talk
Subject: Detecting Flash for use in CFGraph


Hi all

Does anyone know of an easy way to detect if the client browser has a
flash 
plug-in installed?

I am hoping to detect it on the home page, pass a variable back to the 
server and then serve up a jpg or flash graph, depending on the
variable.  
(I know how to do Steps 2 and 3).

If it helps, i am designing for MSIE 5+

Thanks






~|
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 do I pick out part of the string?

2003-01-11 Thread Robert Bailey
Is announcements.cfm going to change? Or just looking for it in the
path?

You can use Find() and FindNoCase()

Not sure what you are trying to do. Will the string change? Will it be a
different document every time? Like maybe
/cfdocs/lifemoves/html/blah.cfm?

 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:32 PM
To: CF-Talk
Subject: How do I pick out part of the string?


Hi, all.

How do I pick out announcements.cfm
from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

Thanks,

Rick



~|
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: How do I pick out part of the string?

2003-01-11 Thread Marius Milosav
listLast (/cfdocs/lifemoves/html/announcements.cfm  , /)

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message -
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 11:32 PM
Subject: How do I pick out part of the string?


 Hi, all.

 How do I pick out announcements.cfm
 from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

 Thanks,

 Rick


 
~|
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: CDATA Insert problem

2003-01-11 Thread cf-talk
I should have been more clear...

They had configured the CFMX Administrator to delete inactive records after
3 days.  When we looked at the CDATA and CGLOBAL tables there were records
going back to June of 2001!

The site is an extranet site, not a public web server... and no, they're not
THAT busy. ;-)

Nothing was being deleted... and nothing ever had been deleted from those
tables.

I've experienced this same thing on some of my own systems as well.

-Novak

- Original Message -
From: Kwang Suh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 9:00 PM
Subject: Re: CDATA Insert problem


  You might want to check your CDATA and CGLOBAL tables and make sure you
  don't have a ton of records in there.  It has been my experience that
the
  CDATA and CGLOBAL tables DO NOT get purged like they're supposed to.
For
  example, if you tell the CF Administrator to clear records older than 3
 days
  it simply doesn't happen.  I've experienced this problem in CF5 and
CFMX.
  In fact, just the other day a client of mine (who had it set to clear
  records older than 3 days) discovered over 2.8 million records in each
  table!

 Perhaps his site is very busy?  Also, CF only deletes inactive records
after
 X days.

 
~|
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: CDATA Insert problem

2003-01-11 Thread Kwang Suh
Yeah, I've had the same problem as well.

We ended up creating a SQL Server job that nuked old records instead.

- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 10:10 PM
Subject: Re: CDATA Insert problem


 I should have been more clear...

 They had configured the CFMX Administrator to delete inactive records
after
 3 days.  When we looked at the CDATA and CGLOBAL tables there were records
 going back to June of 2001!

 The site is an extranet site, not a public web server... and no, they're
not
 THAT busy. ;-)

 Nothing was being deleted... and nothing ever had been deleted from those
 tables.

 I've experienced this same thing on some of my own systems as well.

 -Novak

 - Original Message -
 From: Kwang Suh [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Saturday, January 11, 2003 9:00 PM
 Subject: Re: CDATA Insert problem


   You might want to check your CDATA and CGLOBAL tables and make sure
you
   don't have a ton of records in there.  It has been my experience that
 the
   CDATA and CGLOBAL tables DO NOT get purged like they're supposed to.
 For
   example, if you tell the CF Administrator to clear records older than
3
  days
   it simply doesn't happen.  I've experienced this problem in CF5 and
 CFMX.
   In fact, just the other day a client of mine (who had it set to clear
   records older than 3 days) discovered over 2.8 million records in each
   table!
 
  Perhaps his site is very busy?  Also, CF only deletes inactive records
 after
  X days.
 
 
 
~|
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 do I pick out part of the string?

2003-01-11 Thread Larry Juncker
ListLast(string,/)

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 10:32 PM
To: CF-Talk
Subject: How do I pick out part of the string?


Hi, all.

How do I pick out announcements.cfm
from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

Thanks,

Rick



~|
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 do I pick out part of the string?

2003-01-11 Thread Rick Faircloth
Hi, Robert.

Yes, the string I'm looking for will change.

I'm setting up a stats log for page hits and
wanted to display just the page name, such as announcements.cfm
or index.cfm instead of the entire path.

So it does need to be dynamic...

I'd be asking CF to find the string after the last / in a path...

Rick



-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 11:37 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Is announcements.cfm going to change? Or just looking for it in the
path?

You can use Find() and FindNoCase()

Not sure what you are trying to do. Will the string change? Will it be a
different document every time? Like maybe
/cfdocs/lifemoves/html/blah.cfm?


Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com




-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 8:32 PM
To: CF-Talk
Subject: How do I pick out part of the string?


Hi, all.

How do I pick out announcements.cfm
from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

Thanks,

Rick




~|
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: CDATA Insert problem

2003-01-11 Thread cf-talk
You might want to check your CDATA and CGLOBAL tables and make sure you
don't have a ton of records in there.  It has been my experience that the
CDATA and CGLOBAL tables DO NOT get purged like they're supposed to.  For
example, if you tell the CF Administrator to clear records older than 3 days
it simply doesn't happen.  I've experienced this problem in CF5 and CFMX.
In fact, just the other day a client of mine (who had it set to clear
records older than 3 days) discovered over 2.8 million records in each
table!

Anyway... long story short... I think what happened is that you get too many
records in there, and CFMX goes to assign a CFID and CFTOKEN to a new
user... but unfortunately picks a number that's already in the database.
That's why you get the error you describe below.

The way to fix this problem is to write your own template to purge the
records from the CDATA and CGLOBAL table and then set it up in CFSCHEDULER.
Also, as a side note... it's A LOT easier to do a TRUNCATE TABLE CDATA and
TRUNCATE TABLE CGLOBAL at about 3am every night.

Truncating the table every night will solve your problem... but it will also
wipe your CDATA and CGLOBAL tables out every night.  Something to keep in
mind depending on how you're using your client variables.

-Novak

- Original Message -
From: Webmaster [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 8:13 AM
Subject: CDATA Insert problem


 Hi,
  Can anyone explain how this happened?  I use Client vars and it looks
like
 CF got confused and try to insert a duplicate record into the CDATA table.
 Has anyone else seen this?

 [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate
key
 row in object 'CDATA' with unique index 'id1'.

 Regards,
  Joe Hansen


 
~|
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: How do I pick out part of the string?

2003-01-11 Thread Robert Bailey
Then you can use listLast (/cfdocs/lifemoves/html/announcements.cfm  ,
/) and will get the last one, as Marius said before, lol. Sorry, just
one to ask more questions then jump, was not sure if you were looking at
where it started in the string or just wanted the value. My bad :)

 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:47 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Hi, Robert.

Yes, the string I'm looking for will change.

I'm setting up a stats log for page hits and
wanted to display just the page name, such as announcements.cfm or
index.cfm instead of the entire path.

So it does need to be dynamic...

I'd be asking CF to find the string after the last / in a path...

Rick



-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 11:37 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Is announcements.cfm going to change? Or just looking for it in the
path?

You can use Find() and FindNoCase()

Not sure what you are trying to do. Will the string change? Will it be a
different document every time? Like maybe
/cfdocs/lifemoves/html/blah.cfm?


Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com




-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 8:32 PM
To: CF-Talk
Subject: How do I pick out part of the string?


Hi, all.

How do I pick out announcements.cfm
from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

Thanks,

Rick





~|
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 do I pick out part of the string?

2003-01-11 Thread Rick Faircloth
Thanks, Marius (and Larry and Robert)

I knew it would be something simple like that,
but I just wasn't able to hit upon it, even though I did
search through some documentation on string functions.

Guess it's just too late at night to be doing this...

Rick



-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 11:32 PM
To: CF-Talk
Subject: Re: How do I pick out part of the string?


listLast (/cfdocs/lifemoves/html/announcements.cfm  , /)

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message -
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, January 11, 2003 11:32 PM
Subject: How do I pick out part of the string?


 Hi, all.

 How do I pick out announcements.cfm
 from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

 Thanks,

 Rick




~|
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: How do I pick out part of the string?

2003-01-11 Thread Robert Bailey
Just put the variable where /cfdocs/lifemoves/html/announcements.cfm
is, without the quotes BTW

 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:50 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Then you can use listLast (/cfdocs/lifemoves/html/announcements.cfm  ,
/) and will get the last one, as Marius said before, lol. Sorry, just
one to ask more questions then jump, was not sure if you were looking at
where it started in the string or just wanted the value. My bad :)

 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 11, 2003 8:47 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Hi, Robert.

Yes, the string I'm looking for will change.

I'm setting up a stats log for page hits and
wanted to display just the page name, such as announcements.cfm or
index.cfm instead of the entire path.

So it does need to be dynamic...

I'd be asking CF to find the string after the last / in a path...

Rick



-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 11:37 PM
To: CF-Talk
Subject: RE: How do I pick out part of the string?


Is announcements.cfm going to change? Or just looking for it in the
path?

You can use Find() and FindNoCase()

Not sure what you are trying to do. Will the string change? Will it be a
different document every time? Like maybe
/cfdocs/lifemoves/html/blah.cfm?


Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com




-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 8:32 PM
To: CF-Talk
Subject: How do I pick out part of the string?


Hi, all.

How do I pick out announcements.cfm
from this string:  /cfdocs/lifemoves/html/announcements.cfm  ???

Thanks,

Rick






~|
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: Unix database syntactically similar to SQL Server?

2003-01-11 Thread Dave Watts
 It all comes down to the complexity of the SQL -- 
 specifically how much server-specific stuff you need 
 to do. Obscure (or obsfucated) functions (e.g. MySQL 
 password hash function), crazy things like code pages 
 and collation orders, queries with linked servers, etc. 
 All that stuff will burn you. Run-of-the-mill DML, no 
 biggie.

There's a broad middle ground between run-of-the-mill DML and queries with
linked servers; my point was simply that you can feasibly develop against
Sybase for MS SQL Server deployment, or vice versa. Not that it's ideal,
again, but you can use the vast majority of T-SQL commands (as opposed to
run-of-the-mill ANSI SQL) and get identical results since Sybase and MS
SQL Server are a lot closer than any other two enterprise database
platforms.

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
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: How do I pick out part of the string?

2003-01-11 Thread S . Isaac Dealey
Hey Rick -- If you're looking to get the file name from a file path string,
I'd use getfilefrompath() instead of listlast() -- getfilefrompath() works
independant of the path delimiter, which may sometimes not be / it may be \
-- you could also add \ to the delimiters of listlast, but I also prefer
getfilefrompath() simply because it's more descriptive of what you're doing
and so it's somewhat self-documenting when someone else is reading the
code.

 Yep, that did it precisely...

 Thanks, all.

 Rick


 -Original Message-
 From: Larry Juncker [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, January 11, 2003 11:44 PM
 To: CF-Talk
 Subject: RE: How do I pick out part of the string?


 ListLast(string,/)

 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, January 11, 2003 10:32 PM
 To: CF-Talk
 Subject: How do I pick out part of the string?


 Hi, all.

 How do I pick out announcements.cfm
 from this string:
 /cfdocs/lifemoves/html/announcements.cfm  ???

 Thanks,

 Rick




 ~~
 ~~~|
 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/uns
   ubscribe.cfm?user=633.558.4



s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

~|
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




Client variable problems on MX

2003-01-11 Thread Josh Trefethen
I have a server running CFMX that seems to give out a new client
variables on each click...never keeping state.

Anyone seen this?

--
Josh Trefethen

.:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
.::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.

~|
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: CDATA Insert problem

2003-01-11 Thread Webmaster
Hi Guys,
  The records are being deleted as scheduled.  I installed the fix for this.
Take a look at
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22730Method=Full
This fixed that problem for me.

  However, I still get the CDATA insert failure about once every two weeks.
I am using the long version of the cftoken so I really don't understand why
CF is getting a duplicate problem.  I might open a ticket, but I hate their
policy of needing a CC number.  A stupid policy...
Another question comes to mind..  I am running about 100 datasources on one
machine.  Each holds cdata and cglobal data for its application.  Is it
better to use one source for cdata and cglobal per machine/CF instance, or
is it better to hold this data in each applications own database?  What are
your thoughts on this
Thanks,
 Joe



- Original Message -
From: Kwang Suh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, January 12, 2003 12:39 AM
Subject: Re: CDATA Insert problem


 Yeah, I've had the same problem as well.

 We ended up creating a SQL Server job that nuked old records instead.

 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Saturday, January 11, 2003 10:10 PM
 Subject: Re: CDATA Insert problem


  I should have been more clear...
 
  They had configured the CFMX Administrator to delete inactive records
 after
  3 days.  When we looked at the CDATA and CGLOBAL tables there were
records
  going back to June of 2001!
 
  The site is an extranet site, not a public web server... and no, they're
 not
  THAT busy. ;-)
 
  Nothing was being deleted... and nothing ever had been deleted from
those
  tables.
 
  I've experienced this same thing on some of my own systems as well.
 
  -Novak
 
  - Original Message -
  From: Kwang Suh [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, January 11, 2003 9:00 PM
  Subject: Re: CDATA Insert problem
 
 
You might want to check your CDATA and CGLOBAL tables and make sure
 you
don't have a ton of records in there.  It has been my experience
that
  the
CDATA and CGLOBAL tables DO NOT get purged like they're supposed to.
  For
example, if you tell the CF Administrator to clear records older
than
 3
   days
it simply doesn't happen.  I've experienced this problem in CF5 and
  CFMX.
In fact, just the other day a client of mine (who had it set to
clear
records older than 3 days) discovered over 2.8 million records in
each
table!
  
   Perhaps his site is very busy?  Also, CF only deletes inactive records
  after
   X days.
  
  
 
 
~|
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