RE: Connecting multiple JRun (CFMX) servers to Apache

[Dave Watts]

> > But, you confirmed what finally dawned on me -- 
> > make your own manual backup first, then perform 
> > the update.
> 
> Welcome to Unix :)

That's hardly specific to Unix - you should do the same thing on any server
platform!

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=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 20:34 US/Pacific, Joe Eugene wrote:
> Talking about Apache, i have the Oracle 9iAS WebServer Running
> on a Win2k box. Obviously 9iAS uses an Apache WebServer.
> I have no clue where to start. Can you point me to some
> good documentation...Atleast to the point that i can port
> some JSP/Servlets and Java Beans.
> BTW:9iAS looks quite confusing to me:)

http://www.apache.org/ is a wealth of information. Everything I know 
about Apache, I've learned from that site (and the online documentation 
installed with Apache).

I've no experience with Oracle AS but I expect Oracle's website has 
good documentation for it - Oracle Tech Net has all the Oracle 
documentation with examples and a great search facility. As with 
Apache, everything I know about Oracle's database, I've learned from 
OTN (and a DBA course that Macromedia sent me on a couple of years ago).

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim/iChat: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.macromedia.com/go/arch_blog

ColdFusion MX and JRun 4 now available for Mac OS X!
http://www.macromedia.com/go/cfmxosx

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 20:28 US/Pacific, Dick Applebaum wrote:
> Point taken -- mod_rendezvous caused me a lot of grief & never did get
> it working.

The apxs installer puts the LoadModule directive in the wrong place. If 
you move that one line to the end of the main block of LoadModule 
directives, it works just fine. Disappointingly, I still seem to be the 
only Macromedian (on my subnet) with mod_rendezvous installed and 
Apache running all the time! :)

> But, you confirmed what finally dawned on me -- make your own manual
> backup first, then perform the update.

Welcome to Unix :)

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim/iChat: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.macromedia.com/go/arch_blog

ColdFusion MX and JRun 4 now available for Mac OS X!
http://www.macromedia.com/go/cfmxosx

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Retrieving email error on CFMX...

[Christian Cantrell]

It's defiantly the cfpop tag throwing the error.  I think it's  
happening in CFMX (and not in CF 5) because CFMX uses JavaMail, which  
is where I believe the bug actually is.  I have tried dropping in  
different versions of JavaMail, but I still get the same (or only  
slightly different) errors.

I was able to reproduce the problem by using cfpop to retrieve an HTML  
email sent by Apple Mail.  I have come across 5 other people who have  
encountered the same problem caused by attachments, but nobody has yet  
offered a solution.

Last October, Jochem posted the following:

"I believe this is caused by some sort of charset incompatibility,
possibly in the underlying Java layer. I am receiving the same error
every now and then, but I have not yet been able to reproduce it at
will. So far, it appears that the error only occurs when the message is
send using some UTF-x charset and from Exchange. But that might just be
the people that send me email."

Paul Hastings responded with the following:

"hotmail utf-7 if i recall correctly. underlying java issue thats been  
there
2-3 years now. go to sun's bug parade & complain along with the rest of
us... "

I will let you know what I find out.

Christian

On Tuesday, January 28, 2003, at 04:17 PM, Tyler Silcox wrote:

> I'm receiving an error when I try to retrieve POP mail on a CFMX  
> server using cfpop.  Here's my message:
>
> An exception occurred when retrieving mails.
> The cause of this exception was that:  
> java.security.PrivilegedActionException  
> < is: java.io.UnsupportedEncodingException: unicode-1-1-utf-7>>.
>
> Now, this worked fine when the site was running on old CF5, so I  
> figure it has to do with the new ways CFMX handles encoding...which I  
> know absolutely nothing about.  I've hit my books and I have no idea  
> how to change the encoding of a cfpop query if the cfpop tag is what  
> is throwing the error...any ideas?
>
> Tyler
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: MM Using SilkTest to QA Rich Apps?

[Adam Churvis]

> Flash is interesting to load test. Tools like Silk Performer (and many
> others) can record all browser/server interactions and play them back.
> That's good for load testing (which is what my team has been doing).
>
> Regression testing UI is always hard and often labor intensive.

Flash has some special testing problems.  With V6.0 of e-TEST Suite you had
to make sure your browser window was always in the same location and sized
exactly the same during testing as it was during test creation, or test
mouse events with respect to Flash movies would miss their marks because
they were recorded as browser x,y coordinates.  V6.5 is supposedly better at
working with Flash, though.

Respectfully,

Adam Phillip Churvis
Advanced Intensive ColdFusion MX Training
http://www.ColdFusionTraining.com
E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: MM Using SilkTest to QA Rich Apps?

[Christian Cantrell]

Stacy,

I asked around internally and found that the Macromedia QA team did use  
SilkTest to some extent, but ended up having the best luck with some  
custom tools.

Christian

On Tuesday, January 28, 2003, at 05:35 PM, Stacy Young wrote:

> Just pinging this question one last time in case folks missed it :-)
>
>
> Stace
>
> -Original Message-
> From: Stacy Young
> Sent: Monday, January 27, 2003 4:47 PM
> To: CF-Talk
> Subject: MM Using SilkTest to QA Rich Apps?
>
> I'm researching how we can test the rich apps we're rolling
> out...(regression testing mostly)  I've tried out a product from  
> Mercury
>
> Interactive that seems capable of automatic quite a bit in regards to
> interacting with a Flash UI...but I read in the pet market app that MM
> used SilkTest.
>
> Of course Segue's doc's are unbelievably horrible (we're a customer)  
> and
> I haven't found a single mention of testing flash movies!
>
> Can anyone at MM point me to any resources?
>
> Thanks!
>
> Stace
>
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present document et ses pieces
> jointes sont strictement confidentielles et reservees a l'usage de la
> (des) personne(s) a qui il est adresse. Si vous n'etes pas le
> destinataire, soyez avise que toute divulgation, distribution, copie,  
> ou
> autre utilisation de ces informations est strictement prohibee. Si vous
> avez recu ce document par erreur, veuillez s'il vous plait communiquer
> immediatement avec l'expediteur et detruire ce document sans en faire  
> de
> copie sous quelque forme.
>
> WARNING:
> ---
> The information contained in this document and attachments is
> confidential and intended only for the person(s) named above. If you  
> are
> not the intended recipient you are hereby notified that any disclosure,
> copying, distribution, or any other use of the information is strictly
> prohibited. If you have received this document by mistake, please  
> notify
> the sender immediately and destroy this document and attachments  
> without
> making any copy of any kind.
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: sean corfield a ? for u or anyone who has done the pet store app

[Dave Lyons]

yeah, that's where I was at but after looking through a few of the articles
it seems like I didn't get all the files.
Which I kinda thought when I installed it as what I received didn't fit the
installation instructions at all.
I'll re down load.
Thanks for taking the time

Dave
- Original Message -
From: "Sean A Corfield" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 11:33 PM
Subject: Re: sean corfield a ? for u or anyone who has done the pet store
app


> On Tuesday, Jan 28, 2003, at 20:08 US/Pacific, Dave Lyons wrote:
> > I finally got around to looking at the pet sore deal on MM.
> > As I am new to cfm (moving from  asp) I was very impressed by how that
> > all works. So I down loaded it but for the life of me I cant find
> > anything else. Meaning, all I got was the files, is there a walk
> > through, instructions, anything about how the front end flash was
> > done, anything?
> > I looked but I didnt seem to see anything. I'm sure this is an
> > overlook on my part but was hoping you could point me to them.
>
> There are a number of articles on the Macromedia Designer & Developer
> Center about it:
>
> http://www.macromedia.com/desdev/mx/blueprint/
>
> (I typed in "pet market" in the DesDev search box)
>
> Sean A Corfield -- Director, Architecture
> Web Technology Group -- Macromedia, Inc.
> tel: (415) 252-2287 -- cell: (415) 717-8473
> aim/iChat: seancorfield -- http://www.macromedia.com
> An Architect's View -- http://www.macromedia.com/go/arch_blog
>
> ColdFusion MX and JRun 4 now available for Mac OS X!
> http://www.macromedia.com/go/cfmxosx
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Why is my CGI.HTTP_HOST an empty string now?

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 15:30 US/Pacific, Ben Doom wrote:
> What browser/os?  Works fine for me on Mozilla 1.2.1 on Win2k.

Works fine on Safari on Mac OS X too.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Joe Eugene]

Sean,
Talking about Apache, i have the Oracle 9iAS WebServer Running
on a Win2k box. Obviously 9iAS uses an Apache WebServer.
I have no clue where to start. Can you point me to some
good documentation...Atleast to the point that i can port
some JSP/Servlets and Java Beans.
BTW:9iAS looks quite confusing to me:)

Appreciate it.
Thanks
Joe Eugene

> -Original Message-
> From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 10:35 PM
> To: CF-Talk
> Subject: Re: Connecting multiple JRun (CFMX) servers to Apache
>
>
> On Tuesday, Jan 28, 2003, at 13:41 US/Pacific, Dick Applebaum wrote:
> > I am just experimenting with some hosting options -- hoping that one
> > day I will be able to use them.
>
> Ah.
>
> > Further I only need expend CPU resources (startup the server instance)
> > if I am actually developing or testing the specific client's site.
> >
> > This appears to be a major advantage to running CFMX on JRun, No?
>
> Correct.
>
> > i can do this now, except I must use an ugly port number in the URL --
> > I am very sensitive about "Ugly Ports" :)
>
> I have a number of VirtualHosts on my laptop, listening on different
> ports and mapping to different systems. I use mod_proxy, mod_rewrite as
> needed. On a Mac - like on Unix - you can almost certainly configure
> multiple IPs and bind Apache to each using VirtualHost. Apache can then
> proxy each IP to either a port or a context root as needed.
>
> >   Also, is there is an easier way than mucking around in the httpd.conf
> > file?
>
> With power comes responsibility :)
>
> > If, not, this would be a good item for an addition to wsconfig (wish
> > list request), no?
>
> Apache is a very flexible, configurable beast. I don't think it's
> reasonable to expect a CFMX/JRun tool to be able to do that sort of
> configuration. More to the point, no Apache webmaster worth her salt
> would allow any automated tool to mess with the httpd.conf file! A good
> example of this is apxs - used by mod_rendezvous to install its
> settings. apxs gets easily confused. So, you back up httpd.conf, run
> it, use diff to figure out what damage it did and then manually make
> similar tweaks. We keep all our httpd.conf files under version control
> - they're so key to our web system!
>
> 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=subscribe&forumid=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: sean corfield a ? for u or anyone who has done the pet store app

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 20:08 US/Pacific, Dave Lyons wrote:
> I finally got around to looking at the pet sore deal on MM.
> As I am new to cfm (moving from  asp) I was very impressed by how that 
> all works. So I down loaded it but for the life of me I cant find 
> anything else. Meaning, all I got was the files, is there a walk 
> through, instructions, anything about how the front end flash was 
> done, anything?
> I looked but I didnt seem to see anything. I'm sure this is an 
> overlook on my part but was hoping you could point me to them.

There are a number of articles on the Macromedia Designer & Developer 
Center about it:

http://www.macromedia.com/desdev/mx/blueprint/

(I typed in "pet market" in the DesDev search box)

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim/iChat: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.macromedia.com/go/arch_blog

ColdFusion MX and JRun 4 now available for Mac OS X!
http://www.macromedia.com/go/cfmxosx

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Dick Applebaum]

On Tuesday, January 28, 2003, at 07:35 PM, Sean A Corfield wrote:

>
>>   Also, is there is an easier way than mucking around in the  
>> httpd.conf
>> file?
>
> With power comes responsibility :)

I am beginning to appreciate that fact!

>
>> If, not, this would be a good item for an addition to wsconfig (wish
>> list request), no?
>
> Apache is a very flexible, configurable beast. I don't think it's
> reasonable to expect a CFMX/JRun tool to be able to do that sort of
> configuration. More to the point, no Apache webmaster worth her salt
> would allow any automated tool to mess with the httpd.conf file! A good
> example of this is apxs - used by mod_rendezvous to install its
> settings. apxs gets easily confused. So, you back up httpd.conf, run
> it, use diff to figure out what damage it did and then manually make
> similar tweaks. We keep all our httpd.conf files under version control
> - they're so key to our web system!

Point taken -- mod_rendezvous caused me a lot of grief & never did get  
it working.

I guess the thing that surprises me is that programs (like wsconfig)  
that modify create a backup, but overwrite any prior bacup of  
httpd.conf.  seems like it would be fairly easy to create a  
heept.conf.bak.1... and leave an audit trail.

But, you confirmed what finally dawned on me -- make your own manual  
backup first, then perform the update.

Won't forget that!

Thanks!

I guess I'll manually make the changes outlined in the Macromedia  
article.

Dick


>
> 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=subscribe&forumid=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: Flasher

[Mike Miessen]

Great info thanks!


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Flasher

[Mike Miessen]

Thanks that's a good one :)




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

sean corfield a ? for u or anyone who has done the pet store app

[Dave Lyons]

I finally got around to looking at the pet sore deal on MM.
As I am new to cfm (moving from  asp) I was very impressed by how that all works. So I 
down loaded it but for the life of me I cant find anything else. Meaning, all I got 
was the files, is there a walk through, instructions, anything about how the front end 
flash was done, anything?
I looked but I didnt seem to see anything. I'm sure this is an overlook on my part but 
was hoping you could point me to them.

Thanks
Dave 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: passing parameters at time of cfc object creation

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 12:49 US/Pacific, Jon Gunnip wrote:
> Is there a way to pass arguments at the time of cfc object creation?

No, not with the current version of the language.

> My current process means two things that I don't want to do:
> 1) create the cfc object and then initialize it
> 2) check in each cfc function to ensure that the initialization 
> occurred

Yup, that's what you have to do today.

> I would like to:
> 1) pass in initialization parameters at the time of object creation, 
> whereby
> all objects will automatically be initialzed and each function will 
> not have
> to check for initialization.

That would be possible if CFCs had 'proper' constructors. Several 
people have suggested this would be a good enhancement for a future 
version of ColdFusion.

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=subscribe&forumid=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: MM Using SilkTest to QA Rich Apps?

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 14:35 US/Pacific, Stacy Young wrote:
> I'm researching how we can test the rich apps we're rolling
> out...(regression testing mostly)  I've tried out a product from 
> Mercury
> Interactive that seems capable of automatic quite a bit in regards to
> interacting with a Flash UI...but I read in the pet market app that MM
> used SilkTest.

Flash is interesting to load test. Tools like Silk Performer (and many 
others) can record all browser/server interactions and play them back. 
That's good for load testing (which is what my team has been doing).

Regression testing UI is always hard and often labor intensive.

> Can anyone at MM point me to any resources?

http://www.macromedia.com/resources/techniques/build/test.html

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=subscribe&forumid=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: DWMX question

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 17:01 US/Pacific, Tony Weeg wrote:
> they are essentially not necessary.

 is "correct" however.

> they really dont provide much impact
> on spacing

Nor should they.

> they will end any formatting
> you may have in the  tag

Only if you don't correctly close your tags!

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=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 13:41 US/Pacific, Dick Applebaum wrote:
> I am just experimenting with some hosting options -- hoping that one
> day I will be able to use them.

Ah.

> Further I only need expend CPU resources (startup the server instance)
> if I am actually developing or testing the specific client's site.
>
> This appears to be a major advantage to running CFMX on JRun, No?

Correct.

> i can do this now, except I must use an ugly port number in the URL --
> I am very sensitive about "Ugly Ports" :)

I have a number of VirtualHosts on my laptop, listening on different 
ports and mapping to different systems. I use mod_proxy, mod_rewrite as 
needed. On a Mac - like on Unix - you can almost certainly configure 
multiple IPs and bind Apache to each using VirtualHost. Apache can then 
proxy each IP to either a port or a context root as needed.

>   Also, is there is an easier way than mucking around in the httpd.conf
> file?

With power comes responsibility :)

> If, not, this would be a good item for an addition to wsconfig (wish
> list request), no?

Apache is a very flexible, configurable beast. I don't think it's 
reasonable to expect a CFMX/JRun tool to be able to do that sort of 
configuration. More to the point, no Apache webmaster worth her salt 
would allow any automated tool to mess with the httpd.conf file! A good 
example of this is apxs - used by mod_rendezvous to install its 
settings. apxs gets easily confused. So, you back up httpd.conf, run 
it, use diff to figure out what damage it did and then manually make 
similar tweaks. We keep all our httpd.conf files under version control 
- they're so key to our web system!

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=subscribe&forumid=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: XML settings files for CF apps

[Kreig Zimmerman]

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]]
>
> Got to look at the bigger picture. If you are using cf only
> and forever then a cfm settings file is fine. In fact its
> probably faster. But what if you start to move to java ? Or
> you want to create a VB app as a config editor...??
>
I would agree with this.  Although, to be honest, when I made this change to
the application I was working on last, there was also a bit of the "because
I can" and "it was possible" w/ CFMX.

> That's the real advantage of XML.
>
> As for speed, once you parse the XML you can stick the DOM
> into application scope. No need to read it ever time.

Agreed.  This would address said issue.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

coldfusion and access 2002

[Sangeeta Karmokar]

Hello this is for Peter,

I am trying to do the same. I wan to crerate a page with Username and password with 
Access database which has all username and password. How should I procees with the 
Coldfusion studio to create a cfquery? Can u please help me

Regards
Sangeeta 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Sangeeta Karmokar]

Hi there, I am new to CF and I want to create a page with login and password. Can any 
one help me with this. I will be very thankful. 
Sangeeta
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

argh.  I had begun to think it might be something like this.  i'll
keep playing but I fear you're right, the only way to rectify this is
have an older version of CF pull it out and post it to cfmx on another
server.  What a nightmare.

I wonder though whether it's a CF thing or a copy/paste thing - can
encoding elements from word be pasted into a plain textarea on a
website?  Or is it more likely that the earlier version of CF stored
things incorrectly and cfmx finally does it right?

cheers,
Toby



Wednesday, January 29, 2003, 1:35:36 PM, you wrote:

JvD> Toby Tremayne wrote:
>> ok I've tried this again and have some interesting results.  I used
>> pgAdmin's migration tool to try to move the data across - I created
>> the pg database as unicode, and used the unicode option for the
>> migration - and ended up with an error:
>> 
>> An error occured at: 29/01/2003 11:11:54 AM:
>> -2147467259: ERROR:  Invalid UNICODE character sequence found (0xee7472)

JvD> That is the typical error when inserting high ASCII in a PostgreSQL 
JvD> database.


>> Any ideas?  I can only assume that either there's some weird character
>> gone in through a copy and paste from msword to the website textbox
>> used for input, as Paul suggested, or CF4/5 has saved bad unicode in
>> there and now I'm stuck with it.  how does one go about correcting
>> something like this?

JvD> There is the hard way. You need to extract the data from the database 
JvD> using CF 4.5, then cfhttp it to CF MX, use setEncoding() to fix the 
JvD> charset there and then insert it into the database.
JvD> And there is the uncertain way. It should be possible to import the data 
JvD> correctly in some PostgreSQL database with encoding ISO-xxx. Then you 
JvD> should be able to use the built-in Convert() function to convert to 
JvD> unicode, which would eliminate the cfhttp step. Haven't tried that though.

JvD> Jochem

JvD> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Jochem van Dieten]

Toby Tremayne wrote:
> ok I've tried this again and have some interesting results.  I used
> pgAdmin's migration tool to try to move the data across - I created
> the pg database as unicode, and used the unicode option for the
> migration - and ended up with an error:
> 
> An error occured at: 29/01/2003 11:11:54 AM:
> -2147467259: ERROR:  Invalid UNICODE character sequence found (0xee7472)

That is the typical error when inserting high ASCII in a PostgreSQL 
database.


> Any ideas?  I can only assume that either there's some weird character
> gone in through a copy and paste from msword to the website textbox
> used for input, as Paul suggested, or CF4/5 has saved bad unicode in
> there and now I'm stuck with it.  how does one go about correcting
> something like this?

There is the hard way. You need to extract the data from the database 
using CF 4.5, then cfhttp it to CF MX, use setEncoding() to fix the 
charset there and then insert it into the database.
And there is the uncertain way. It should be possible to import the data 
correctly in some PostgreSQL database with encoding ISO-xxx. Then you 
should be able to use the built-in Convert() function to convert to 
unicode, which would eliminate the cfhttp step. Haven't tried that though.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: coldfusion and access 2002

[Peter.Tilbrook]

Password protect the database itself (Tools/Security) - you may need to open
the database in Exclusive mode to do this.

Do not hard code the username/password in your  code. Instead set
them in the Datasource.

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: (02) 6213 7287 


-Original Message-
From: Benjamin Rosenthal [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, 29 January 2003 1:24 PM
To: CF-Talk
Subject: coldfusion and access 2002


I'm trying to secure an Access 2002 database so that it requires a username
and password in the cfquery tag.  Right now my database is unprotected and I
want to change this.

I've been pulling my hair out going through the Access User-Level Security
Wizard all day trying to set this up.  Does anyone have quick tips or
suggestions on how to best do this (or secure an Access web database project
in general)?  I'm sure I'm missing something stupid but I can't figure out
what that is.  Resources or links?  Any help would be appreciated!

thanks,

Benjamin


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

coldfusion and access 2002

[Benjamin Rosenthal]

I'm trying to secure an Access 2002 database so that it requires a username
and password in the cfquery tag.  Right now my database is unprotected and I
want to change this.

I've been pulling my hair out going through the Access User-Level Security
Wizard all day trying to set this up.  Does anyone have quick tips or
suggestions on how to best do this (or secure an Access web database project
in general)?  I'm sure I'm missing something stupid but I can't figure out
what that is.  Resources or links?  Any help would be appreciated!

thanks,

Benjamin

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Flasher

[Steve Drucker]

http://chattyfig.figleaf.com

We've got an active FlashNewbies list and FlashCoders  list.

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


-Original Message-
From: Mike Miessen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 8:29 PM
To: CF-Talk
Subject: Flasher

Where would you guys recommend for receiving Flash MX help?  Flash in
general?  I notice there is a flash section here but nobody posts to it.
Any Suggestions?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Flasher

[Jason Miller]

http://groups.yahoo.com/group/FLASHmacromedia/

very active list - lots of talent -

moock.org - for advanced
check out figleaf's flash list - not as busy but advanced users

http://muinar.org/
for advanced actionscripting - very slow list - most questions posted 
are only pretty advanced -
sort of last resort.

enjoy

devmx.com and flashcfm.com good places to visit too.
oh - and
actionscript.org

all good
jay miller

Mike Miessen wrote:

>Where would you guys recommend for receiving Flash MX help?  Flash in
>general?  I notice there is a flash section here but nobody posts to it.
>Any Suggestions?
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: New DELL WinXP MSN User Loosing Session

[Jim Davis]

> -Original Message-
> From: Jann VanOver [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, January 27, 2003 11:53 PM
> To: CF-Talk
> Subject: Re: New DELL WinXP MSN User Loosing Session
> 
> 
> On 1/27/03 6:03 PM, "Jim Davis" <[EMAIL PROTECTED]> wrote:
> 
> > You didn't mention if you checked her cookie settings.  
> That could be 
> > a major cause of this kind of problem.
> > 
> I started by checking for cookie problems and found that the 
> site is well written with CFID & CFTOKEN passed on every URL 
> so that there is NO dependence on cookies.  The site works 
> when cookies are disabled.
> 
> > Also, less likely, we've seen some odd behavior on our site 
> if the IE 
> > add-in "HotBar" was installed.  We've got reports that "only on our 
> > site" users would crash when trying to view certain pages.
> > 
> > Not the same symptoms, but you may want to check for this kind of 
> > add-on anyway...
> > 
> 
> Thanks -- I'm trying anything reasonable.

I would focus on possible issues with other installed software.  If the
site truly doesn't require cookies then cookies obviously aren't the
problem.  ;^)

There's a lot of crap out there now: "Hotbar", "Bonzai Buddy" and others
play havoc with browsers and settings.  A lot of this software sets
itself up as a proxy server of a type - it may be mangling the URL
beyond CF's help.

You may also want to check her connection architecture.  Again proxy
servers (this time legitimate proxy servers) can also (although rarely
do) modify the URL.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Flasher

[Mike Miessen]

Where would you guys recommend for receiving Flash MX help?  Flash in
general?  I notice there is a flash section here but nobody posts to it.
Any Suggestions?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 server 2000 - total number of objects in a DB

[Jim Davis]

> -Original Message-
> From: Andres [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, January 28, 2003 9:28 AM
> To: CF-Talk
> Subject: OT - SQL server 2000 - total number of objects in a DB
> 
> 
> Hello Everyone,
> How can i get a count of all indexes a database has? I have a 
> SQL 2000 server and need to get a count of various objects 
> (tables, indexes, triggers, view, SPs) Does anyone know of a 
> way to get these counts WITHOUT having to do it manually?

You can use SP_HELP DatabaseName to get almost all of this.

There are other system procedures for everything else... But I don't
know them off the top of my head.

Look in the books online and they'll all be there.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: DWMX question

[Tony Weeg]

they are essentially not necessary.
they really dont provide much impact
on spacing, they will end any formatting
you may have in the  tag, but other
than that, they are really not necessary.

tony

-Original Message-
From: Mike Miessen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 6:59 PM
To: CF-Talk
Subject: RE: DWMX question


What is wrong with the  tags?

-Original Message-
From: <"Tilbrook>,Peter" [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 6:16 PM
To: CF-Talk
Subject: SOT: DWMX question

How do you stop DWMX placing  automatically? I only want the 
tags.





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF 5 and Unicode

[paul]

> CF 5 and SQL Server 2000
>
> I have Cyrllic Text in the DB and all is good.
>
> Final Assumption:
>
> ***There is no way to retrieve and display the Cyrllic Characters using
> CF 5***

if you turn your char data into utf-8 (not ucs-2) & never parse any strings,
etc. you can certainly use cf5 to pull & display your text. ala
http://www.tei.or.th/misc/unicode.cfm BUT no other app will be able to use
that data & you will certainly have to re-enter it when you move to mx. if
you would take my own experience as advice, upgrade to mx & use unicode
throughout your application.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF 5 and Unicode

[paul]

> CF5 shouldn't have any hand in displaying any characters - that's up to
the
> browser.  Your end-user needs to have unicode support or a Cyrillic
language
> pack to view the data.

if its pulled from the db, cf5 will certainly handle the chars prior to
passing to webserver

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

ok I've tried this again and have some interesting results.  I used
pgAdmin's migration tool to try to move the data across - I created
the pg database as unicode, and used the unicode option for the
migration - and ended up with an error:

An error occured at: 29/01/2003 11:11:54 AM:
-2147467259: ERROR:  Invalid UNICODE character sequence found (0xee7472)

I had actually forgotten, as it happened late at night but I got this
same error when I tried on the weekend after creating a unicode
database...

Any ideas?  I can only assume that either there's some weird character
gone in through a copy and paste from msword to the website textbox
used for input, as Paul suggested, or CF4/5 has saved bad unicode in
there and now I'm stuck with it.  how does one go about correcting
something like this?

Toby



Wednesday, January 29, 2003, 10:35:31 AM, you wrote:

TT> Hi Jochem,

jotn>> What charset is this data using?

TT> ach - just whatever the default is for cf 4.0 /4.5 (UTF-8?)  There
TT> were no processing directives or locale settings in the app at all.
TT> It's been running on a windows machine (NT) up to now.

jotn>> If the data in Access is visible correctly when using Access it self it is not a
jotn>> normal unicode issue.

TT> that's what I figured - I can view the data in access, and cf 4.5 /
TT> 5.0 seems to pull it out of access fine (I haven't had the chance to
TT> try it on windows with cfmx yet).  And over the weekend I tried
TT> postgres Manager which pulled the data out fine as well (from the
TT> postgres DB on the linux machine).


jotn>> Which CF version did you use to move the data? Which client_encoding did you set
jotn>> in PostgreSQL during the migration? Did you set up the PostgreSQL database to
jotn>> use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database
jotn>> migration wizard to move the data from Access to PostreSQL and then use built-in
jotn>> functionality to transform the data?


TT> initially I used cf 5 on windows to move the data to the postgres db
TT> on the linux machine.  The linux box is running cfmx, and that's where
TT> I'm seeing the dodgy characters.  On the weekend I tried doing the
TT> same transfer with cfmx on windows instead of cf5 and strangely enough
TT> it didn't fix it completely but it did end up with LESS dodgy
TT> characters in the display on the linux machine.

TT> I initially hadn't done anything special with character encoding for
TT> postgreSQL, but in the above test I recreated the postgreSQL database
TT> using WITH ENCODING = 'UNICODE' and nothing changed.

TT> I haven't tried the pgAdmin migration wizard actually, last time I
TT> used pgAdmin I don't think it had the migration wizard.  I've been
TT> using a script as I also needed to transform a lot of the data to new
TT> table stuctures (the old one is a complete mess).  I'll try with
TT> pgAdmin and see how I go.

TT> Thanks for the tips Jochem, I'll test your advice and post back.

TT> cheers,
TT> Toby


jotn>> Jochem
jotn>> 
TT> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: DWMX question

[Russ]

If you want to be well-formed, you're better off using both tags.  I
can't imagine why you'd NOT want to be.

> -Original Message-
> From: Mike Miessen [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, January 28, 2003 5:59 PM
> To: CF-Talk
> Subject: RE: DWMX question
> 
> 
> What is wrong with the  tags?
> 
> -Original Message-
> From: <"Tilbrook>,Peter" [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, January 28, 2003 6:16 PM
> To: CF-Talk
> Subject: SOT: DWMX question
> 
> How do you stop DWMX placing  automatically? I only 
> want the 
> tags.
> 
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 to build calendar?

[Russ]

That's spiffy...where were you when I ended up using the one at
www.webtricks.com ?

Of course, I'm battling that with a conversion from Access to MySQL
(which isn't my area of expertise by ANY stretch, thank you very
much--anyone got spare time and assist for free?)...

Russ

> -Original Message-
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, January 28, 2003 6:02 PM
> To: CF-Talk
> Subject: RE: how to build calendar?
> 
> 
> This is probably not exactly what you are looking for but...
> 
> http://www.cflib.org/udf.cfm?ID=540
> 
> The calendar is built in CFscript. It would not take too much 
> time to covert
> it to tag based if needed.
> 
> Mark W. Breneman
> -Macromedia Certified ColdFusion Developer
> -Network / Web Server Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
> 
> -Original Message-
> From: John Ho [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 4:48 PM
> To: CF-Talk
> Subject: how to build calendar?
> 
> 
> hi all
>Can someone show me how to buil or get a calendar
> in CFMX?.
> Thanks
> John
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: DWMX question

[Mike Miessen]

What is wrong with the  tags?

-Original Message-
From: <"Tilbrook>,Peter" [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 6:16 PM
To: CF-Talk
Subject: SOT: DWMX question

How do you stop DWMX placing  automatically? I only want the 
tags.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 to build calendar?

[Mark W. Breneman]

This is probably not exactly what you are looking for but...

http://www.cflib.org/udf.cfm?ID=540

The calendar is built in CFscript. It would not take too much time to covert
it to tag based if needed.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: John Ho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 4:48 PM
To: CF-Talk
Subject: how to build calendar?


hi all
   Can someone show me how to buil or get a calendar
in CFMX?.
Thanks
John

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

SOT: DWMX question

[Peter.Tilbrook]

How do you stop DWMX placing  automatically? I only want the 
tags.

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: (02) 6213 7287 


**
The information contained in this e-mail, and any attachments to it, is
intended for the use of addressee and is confidential.  If you are not 
the intended recipient, you must not use, disclose, read, forward, copy or
retain any of the information.  If you have received this e-mail in 
error, please delete it and notify the sender by return e-mail or telephone.  
The Commonwealth does not warrant that any attachments are free from 
viruses or any other defects.  You assume all liability for any loss, damage, or 
other consequences which may arise from opening or using the attachments.

**
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 to build calendar?

[John Ho]

hi all
   Can someone show me how to buil or get a calendar
in CFMX?. 
Thanks
John

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Why is my CGI.HTTP_HOST an empty string now?

[Ben Doom]

What browser/os?  Works fine for me on Mozilla 1.2.1 on Win2k.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Dave Babbitt [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, January 28, 2003 6:09 PM
: To: CF-Talk
: Subject: Why is my CGI.HTTP_HOST an empty string now?
:
:
: Hi Guys!
:
: Go to http://www.clipboardsolutions.net/RentACoder/test_cgi_http_host.cfm
: and push the submit button. Does the CGI.HTTP_HOST variable come up blank?
: It does for me and a few irate customers. Not only is the CGI.HTTP_HOST
: missing, but so are the CGI.HTTP_ACCEPT_ENCODING,
: CGI.HTTP_ACCEPT_LANGUAGE,
: CGI.HTTP_CACHE_CONTROL, CGI.HTTP_CONNECTION, CGI.HTTP_CONTENT_LENGTH,
: CGI.HTTP_CONTENT_TYPE, CGI.HTTP_COOKIE, CGI.HTTP_REFERER, and
: CGI.HTTP_USER_AGENT variables.
:
: This just started happening from templates that pass information via forms
: and I can't think of anything that could be causing it.
:
: Thanx
:
: Dave
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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[2]: migrate data stored by cf 4.5 to cfmx (unicode problem?)

[Toby Tremayne]

Hi Jochem,

jotn> What charset is this data using?

ach - just whatever the default is for cf 4.0 /4.5 (UTF-8?)  There
were no processing directives or locale settings in the app at all.
It's been running on a windows machine (NT) up to now.

jotn> If the data in Access is visible correctly when using Access it self it is not a
jotn> normal unicode issue.

that's what I figured - I can view the data in access, and cf 4.5 /
5.0 seems to pull it out of access fine (I haven't had the chance to
try it on windows with cfmx yet).  And over the weekend I tried
postgres Manager which pulled the data out fine as well (from the
postgres DB on the linux machine).


jotn> Which CF version did you use to move the data? Which client_encoding did you set
jotn> in PostgreSQL during the migration? Did you set up the PostgreSQL database to
jotn> use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database
jotn> migration wizard to move the data from Access to PostreSQL and then use built-in
jotn> functionality to transform the data?


initially I used cf 5 on windows to move the data to the postgres db
on the linux machine.  The linux box is running cfmx, and that's where
I'm seeing the dodgy characters.  On the weekend I tried doing the
same transfer with cfmx on windows instead of cf5 and strangely enough
it didn't fix it completely but it did end up with LESS dodgy
characters in the display on the linux machine.

I initially hadn't done anything special with character encoding for
postgreSQL, but in the above test I recreated the postgreSQL database
using WITH ENCODING = 'UNICODE' and nothing changed.

I haven't tried the pgAdmin migration wizard actually, last time I
used pgAdmin I don't think it had the migration wizard.  I've been
using a script as I also needed to transform a lot of the data to new
table stuctures (the old one is a complete mess).  I'll try with
pgAdmin and see how I go.

Thanks for the tips Jochem, I'll test your advice and post back.

cheers,
Toby


jotn> Jochem
jotn> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Possible quick way to configure two instances of CFMX Server

[David Adams]

To save messing around with config files, I have found a quick way to 
configure two instances of an IIS webserver running CFMX.  I am doing 
this for security where I put my public website on port 80 and then run 
my CF Admin on a second instance running on port 81.

My steps:

1. Install IIS.  This action will install the default web site on port 80
2. Add your second instance (ie. new>website>etc.)  with it's own directory.
3. Give the second instance it's own port number, say 81
4. Stop default web site on port 80 while leaving the other instance on 
port 81 running.
5. Install CFMX and let it detect the IIS web server and choose this 
instead of the onboard webserver on port 8500.
6. When complete restart server and verify that the two instances are 
servicing CFML pages.

What do you think of this approach?  Is it a good way or am I missing 
something critical?  

It was really hard finding documentation on how to change port numbers 
between instances.  It is such a simple requirement but no comprehensive 
document, only bits and pieces.

Hope this helps others,
Dave Adams
CFUG Ottawa





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Why is my CGI.HTTP_HOST an empty string now?

[Dave Babbitt]

Hi Guys!

Go to http://www.clipboardsolutions.net/RentACoder/test_cgi_http_host.cfm
and push the submit button. Does the CGI.HTTP_HOST variable come up blank?
It does for me and a few irate customers. Not only is the CGI.HTTP_HOST
missing, but so are the CGI.HTTP_ACCEPT_ENCODING, CGI.HTTP_ACCEPT_LANGUAGE,
CGI.HTTP_CACHE_CONTROL, CGI.HTTP_CONNECTION, CGI.HTTP_CONTENT_LENGTH,
CGI.HTTP_CONTENT_TYPE, CGI.HTTP_COOKIE, CGI.HTTP_REFERER, and
CGI.HTTP_USER_AGENT variables.

This just started happening from templates that pass information via forms
and I can't think of anything that could be causing it.

Thanx

Dave

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Joshua Miller]

I guess I could give that a shot. I've heard Jrockit is best for Windows
servers, is this true?

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Jesse Houwing [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 3:22 PM
To: CF-Talk
Subject: Re: CFMX Memory Issue


Joshua Miller wrote:

>I dug out the error message, here's what it is - likely NOT a Windows
>Error:
>
>Error occurred during initialization of VM
>Could not reserve enough space for object heap
>Error occurred during initialization of VM
>Could not reserve enough space for object heap listening on port 2901
>
>I started getting this error after installing the RAM and changing the 
>setting in CFMX ... Didn't error until I tried to change the JVM Max 
>Memory setting. I know this to be true because my server monitor didn't

>choke for the first 2 days the RAM was installed and the setting hadn't

>been changed. The day I changed the setting I started getting bombed 
>with messages from the Server Monitor that CFMX service was down.
>
>I know there is plenty of memory to allocate the 1664mb. If I change 
>the value back to 512 I still get the same problem. The other server 
>has only 384mb RAM (it's a development server that only I use) and it's

>set to 512mb but I only have 384mb in that server. I know there's not 
>enough RAM to support 512mb to the JVM on that box, so why doesn't it 
>choke when starting with the JVM setting higher than the amount of RAM 
>on that system?
>
>The server is at 3rd party host and as much as I would like to toy 
>around with removing memory, etc. they charge $65 an hour to do that 
>kind of thing - and it's a live server. I thought I'd ask some other 
>CF-ers before I went spending money on trying to fix something.
>
>As for the Macromedia Support - I have issues with paying $200+ to find

>out why the CFMX Service errors because I change a setting in 
>CFAdministrator that shouldn't cause an error in the first place. There

>is plenty of memory to support the change and the RAM is fine. I had 
>the hosting company verify that it was correctly installed and that 
>nothing else was failing as a result of the upgrade.
>
>One other item to note is that we also added a second processor to the 
>machine when upgrading the memory ... But it seems unlikely that would 
>affect the VM heap memory allocation.
>
>Anyone have any clues?
>
>Joshua Miller
>  
>
Have you tried a different JVM? Sun's JDK 1.4 or JRockit 7.0?

Maybe they won't error out with such an abundance of memory

Jesse


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

OT: XML Scheme for Region/Location (tds)

[Troy Simpson]

Does anyone know if there is any published information about
representing geographical location information in XML.  I want to
specify a location starting at a root level and drill down to the
smallest location unit.  For example, the following would be a full
location descriptor of where an artifact might be located.

Solar System, Earth, North America, United States, North Carolina, Wake
County, Raleigh, North Carolina State University, DH Hill Library, Room
216, Cubical A.

I would want the XML data to represent the Region's Name (Earth) and
Region's Type (Planet) among other things.

I would presume that this would normally be represented in a Tree like
structure.  I'm sure this has been addressed by the XML Gurus and maybe
a document does exist that describes a standard (DTD, Schema) that I can
reuse.

Does anyone know of anything or where I might be able to go to look?

I've searched the internet and only come up with GIS which is more
complicated that what I need.

Thanks for your help,
Troy
--
-
Troy Simpson
  Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

querySetCell - is there a max length of 255 chars?

[Paul Johnson]

I am using the following method to dynamically build a query











 


Question: Is there a limit to the length of values which can be assigned
using QuerySetCell(result, columnName,columnValue) since my MEMO fields
from access are being trimmed to 255 characters by this code.

 

  _  


Cabbage Tree Creative Ltd.
Paul Johnson | web programmer
Phone+64 3 377 7544
Email    [EMAIL PROTECTED]
Web www.cabbagetree.co.nz

manage your own web site with Thrive - contact us to learn how!

   

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Jochem van Dieten]

Joshua Miller wrote:
> Honestly I have no idea what port 2901 is doing in there. This is a
> default install of CFMX and I just assumed it was something that CF used
> internally.

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=12&threadid=430911
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=12&threadid=442570


> I DO have the CFMX ODBC service running - it's installed by default and
> I assumed it was required. We connect to a MS SQL Server 2000 server and
> 1 or 2 small Access databases, is the ODBC service not required when
> using these RDBMS?

Depends on which drivers you are using. If you are not using the 
JDBC-ODBC bridge you should be able to shut it down (disabling 
unnecessary services is always good).

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: MM Using SilkTest to QA Rich Apps?

[Stacy Young]

Just pinging this question one last time in case folks missed it :-)


Stace

-Original Message-
From: Stacy Young 
Sent: Monday, January 27, 2003 4:47 PM
To: CF-Talk
Subject: MM Using SilkTest to QA Rich Apps?

I'm researching how we can test the rich apps we're rolling
out...(regression testing mostly)  I've tried out a product from Mercury

Interactive that seems capable of automatic quite a bit in regards to
interacting with a Flash UI...but I read in the pet market app that MM
used SilkTest.

Of course Segue's doc's are unbelievably horrible (we're a customer) and
I haven't found a single mention of testing flash movies!

Can anyone at MM point me to any resources?

Thanks!

Stace

AVIS IMPORTANT:
--- 
Les informations contenues dans le present document et ses pieces
jointes sont strictement confidentielles et reservees a l'usage de la
(des) personne(s) a qui il est adresse. Si vous n'etes pas le
destinataire, soyez avise que toute divulgation, distribution, copie, ou
autre utilisation de ces informations est strictement prohibee. Si vous
avez recu ce document par erreur, veuillez s'il vous plait communiquer
immediatement avec l'expediteur et detruire ce document sans en faire de
copie sous quelque forme.

WARNING:
---
The information contained in this document and attachments is
confidential and intended only for the person(s) named above. If you are
not the intended recipient you are hereby notified that any disclosure,
copying, distribution, or any other use of the information is strictly
prohibited. If you have received this document by mistake, please notify
the sender immediately and destroy this document and attachments without
making any copy of any kind.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Debbie Dickerson]

ColdFusion MX: TCP/IP Ports Used
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23518&Method=Full

2901 is listed as the port for JNDI.

Deb

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 5:18 PM
To: CF-Talk
Subject: RE: CFMX Memory Issue


Honestly I have no idea what port 2901 is doing in there. This is a
default install of CFMX and I just assumed it was something that CF used
internally.

Port 2901 is something called ALLSTORCNS (http://keir.net/portlist.html)
and has TCP and UDP associations. A quick search on Google for
ALLSTORCNS returns nothing of much use, just confirmation that it's
typically on port 2901.

A quick Port Scan of my server shows it's open, same for my other
Windows2K Server, but not true for my WindowsXP Pro machine (not running
CFMX). It's also open on my RedHat 7.3 machine that has the Developer
Edition of CFMX installed. Scanning my Mac OSX machine with CFMX J2EE
shows the port is closed.

Thinking this may have something to do with CFMX I started port scanning
servers I know run CF - it's not open on all of the servers, so I'm not
sure if it's related to CFMX or not. Anyone @macromedia.com know if this
is something related to CFMX or is this something different altogether?

I DO have the CFMX ODBC service running - it's installed by default and
I assumed it was required. We connect to a MS SQL Server 2000 server and
1 or 2 small Access databases, is the ODBC service not required when
using these RDBMS?

All that's running on our server currently is:
CFMX with the latest updater
IIS 5
iMail 7
SQL Server 2000 - Running on the second processor for data backups only
- we use a separate SQL box for our live databases.

If I stop services for SQL Server and iMail I still get the same
results.

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 3:44 PM
To: CF-Talk
Subject: Re: CFMX Memory Issue


Joshua Miller wrote:
> I dug out the error message, here's what it is - likely NOT a Windows
> Error:
> 
> Error occurred during initialization of VM
> Could not reserve enough space for object heap
> Error occurred during initialization of VM
> Could not reserve enough space for object heap listening on port 2901

What is that port 2901 doing there? Can you dig out if any weird ports 
are used somewhere? Do you have the CF MX ODBC services running? Do you 
need them to run?

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF 5 and Unicode

[Jim Curran]

True... but the HTML source generated does not contain Cyrllic
Characters.  Only "?"

- j

-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 4:56 PM
To: CF-Talk
Subject: Re: CF 5 and Unicode


CF5 shouldn't have any hand in displaying any characters - that's up to
the browser.  Your end-user needs to have unicode support or a Cyrillic
language pack to view the data.

- Jim

- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 3:38 PM
Subject: CF 5 and Unicode


> Hello All,
>
> Just looking in all the archives and wanted to double check before I 
> close the door on my search.
>
> CF 5 and SQL Server 2000
>
> I have Cyrllic Text in the DB and all is good.
>
> Final Assumption:
>
> ***There is no way to retrieve and display the Cyrllic Characters 
> using CF 5***
>
> I hope I'm wrong, but is this the case?
>
> TIA
>
> - jim
>
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF 5 and Unicode

[Jim Campbell]

CF5 shouldn't have any hand in displaying any characters - that's up to the
browser.  Your end-user needs to have unicode support or a Cyrillic language
pack to view the data.

- Jim

- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 3:38 PM
Subject: CF 5 and Unicode


> Hello All,
>
> Just looking in all the archives and wanted to double check before I
> close the door on my search.
>
> CF 5 and SQL Server 2000
>
> I have Cyrllic Text in the DB and all is good.
>
> Final Assumption:
>
> ***There is no way to retrieve and display the Cyrllic Characters using
> CF 5***
>
> I hope I'm wrong, but is this the case?
>
> TIA
>
> - jim
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Dick Applebaum]

On Tuesday, January 28, 2003, at 09:12 AM, Sean A Corfield wrote:

> On Tuesday, Jan 28, 2003, at 04:40 US/Pacific, Dick Applebaum wrote:
>> I would like to setup multiple servers, named CFMX1, CFMX2 CFMXn,
>> and connect them to Apache.
>
> I'm not sure what you're trying to do here...

I am just experimenting with some hosting options -- hoping that one  
day I will be able to use them.

One thing I often use is shared-hosts for my clients.

Some shared-host providers give a different  (unique) IP address to  
each client.

Others have serveral clients' unique domain name resolve to the same IP  
address,

But in each case, multiple clients share a common web server, CFMX web  
app server, db server.

But, In my super-slick JRun/CFMXJ2EE world, I would like to set up my  
system where I have a separate JRun/CFMX
server instance for each client, and another server instance, or 2, for  
my own internal usage.

I can setup the each client's environment independently, possibly with  
"dangerous options" (cfobject, custom tags, etc) enabled, without  
compromising the other client's environments.  I am not concerned with  
conflicting application names, restarting the server, etc.

Further I only need expend CPU resources (startup the server instance)  
if I am actually developing or testing the specific client's site.

This appears to be a major advantage to running CFMX on JRun, No?

i can do this now, except I must use an ugly port number in the URL --  
I am very sensitive about "Ugly Ports" :)

There is an article on Macromedia on how to do this:

http://www.macromedia.com/v1/handlers/ 
index.cfm?ID=23558&Method=Full&PageCall=/support/index.cfm

and

http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/ 
connectors8.jsp#1124974


I wondered if anyone has tried this.

  Also, is there is an easier way than mucking around in the httpd.conf  
file?

If, not, this would be a good item for an addition to wsconfig (wish  
list request), no?

Finally, I would think that this would be an excellent way to deploy  
CFMX in a shared-host environment -- where each client has his own  
server instance, JVM, etc. and the minimum impact with other clients  
sharing the same box.


>
> If you want http://localhost/cfmx1/foo.cfm to go to the first server
> and http://localhost/cfmx2/foo.cfm to go to the second etc, then
> perhaps you need to look at context roots instead? Set up a single
> server but have multiple CFMX installs, each in a separate context
> root. That's how I run CFMX on Tomcat (three context roots).
>

Yeah, but all these share a single JVM -- so performance and server  
failure would be a consideration.  I don't know if separate contexts  
resolves the "dangerous tags" issue or the conflicting application  
names issue -- it appears that it does.

Dick

> I think you already know how to connect Apache to a cluster (of
> identical server instances)?
>
>> How? -- The wsconfig program refuses to setup a second connection, so  
>> I
>> suspect it requires manual editing of configuration files.
>
> mod_jrun does not work inside a VirtualHost (or at least it didn't the
> last time I tried it - in fact it crashed Apache!) so you can only
> really have one CFMX connection.
>
> Explain in more detail exactly what you're trying to do and we'll see
> whether it's possible...
>
> Sean A Corfield -- Director, Architecture
> Web Technology Group -- Macromedia, Inc.
> tel: (415) 252-2287 -- cell: (415) 717-8473
> aim/iChat: seancorfield -- http://www.macromedia.com
> An Architect's View -- http://www.macromedia.com/go/arch_blog
>
> ColdFusion MX and JRun 4 now available for Mac OS X!
> http://www.macromedia.com/go/cfmxosx
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

CF 5 and Unicode

[Jim Curran]

Hello All,

Just looking in all the archives and wanted to double check before I
close the door on my search.

CF 5 and SQL Server 2000

I have Cyrllic Text in the DB and all is good.

Final Assumption:  

***There is no way to retrieve and display the Cyrllic Characters using
CF 5***

I hope I'm wrong, but is this the case?

TIA

- jim


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Retrieving email error on CFMX...

[Tyler Silcox]

I'm receiving an error when I try to retrieve POP mail on a CFMX server using cfpop.  
Here's my message:

An exception occurred when retrieving mails.
The cause of this exception was that: java.security.PrivilegedActionException 
<>.

Now, this worked fine when the site was running on old CF5, so I figure it has to do 
with the new ways CFMX handles encoding...which I know absolutely nothing about.  I've 
hit my books and I have no idea how to change the encoding of a cfpop query if the 
cfpop tag is what is throwing the error...any ideas?

Tyler


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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:

[Ben Doom]

: -CFScript--
: This is only the relevent code to updating the array and copying the data
: from
: Array 1 to Array 2
: .
: if ((IsDefined("url.L")) and (IsDefined("url.A"))){
:
:   U = ArrayLen(Session.MyCat) +1;
:   V = url.l;
:   if (ArrayLen(Session.MyCat) eq 0){
:   Session.MyCat[1][1] = session.Show;
:   }

since U is always 1 more than the current arraylen, this will always add one
to the length of Session.MyCat.  Is that your problem?


:   for(T=2; T LTE 53; T=T+1){
:   Session.MyCat[U][T] = 1;//Session.QueryList[V][T];
:   }
:   }


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

passing parameters at time of cfc object creation

[Jon Gunnip]

Hello,

Is there a way to pass arguments at the time of cfc object creation?  All of 
the methods in my CFC require a particular parameter, say 'ID' that I would 
like to pass in at the time of object creation ('this.ID =
') and then all of the methods will know that 'this.ID' and can refer to it.

Otherwise, it seems like I have to have an 'Init' method in my CFC which 
sets the 'this.ID' variable and sets a 'this.IsInitialized' variable for the 
object.  Then, all object functions will have to check 'this.Initialized' at 
the top of their function.  If it is not there, they will have to do a 
.

My current process means two things that I don't want to do:
1) create the cfc object and then initialize it
2) check in each cfc function to ensure that the initialization occurred

I would like to:
1) pass in initialization parameters at the time of object creation, whereby 
all objects will automatically be initialzed and each function will not have 
to check for initialization.

I didn't see any solutions in the documentation or on the web.

Thanks!
Jon Gunnip




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Jochem van Dieten]

Joshua Miller wrote:
> I dug out the error message, here's what it is - likely NOT a Windows
> Error:
> 
> Error occurred during initialization of VM
> Could not reserve enough space for object heap
> Error occurred during initialization of VM
> Could not reserve enough space for object heap listening on port 2901

What is that port 2901 doing there? Can you dig out if any weird ports 
are used somewhere? Do you have the CF MX ODBC services running? Do you 
need them to run?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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:

[CWatt]

This is a fairly long message, but I think I included all of the relevent
code.  I wanted to make sure you all had everything you needed.
To get to the live example (65.26.8.241), click on either Video or Internet
Catalog, this gives you a list (The MyCat on the left is an arrayLen of the
MyCat Array, Then click on view, On the left click "add Lot ???" this adds
the lot to your personal catalog (this works fine), now click any of the
other views on the side or the list and watch MyCat increase by one.  As you
can see by the url parameters, this should not happen and I am printing the
ArrayLens at the top and bottom of the pages.  You will see that on the page
you add the Lot to MyCat, The top output (which is on the application page)
is one less than the Bottom (which is the last piece of code executed).
Once you click another link the value increases at the top of the
application already (This is where I am completely puzzled as to how this
can even happen):

-Called Page---


















   


CatList Length = #ArrayLen(Catlist)#
MyCat Length = #ArrayLen(Catlist)#

--Application-
Has not relevent information.
All it does is initiate the arrays when the session is created.
I did include the very top of the page where the application is set up, then
I show the arrayLens
(Notice that after you add to myCat then click any other link the array
increases size!)


CatList Length = #ArrayLen(Catlist)#
MyCat Length = #ArrayLen(Catlist)#


-CFScript--
This is only the relevent code to updating the array and copying the data
from
Array 1 to Array 2
.
if ((IsDefined("url.L")) and (IsDefined("url.A"))){

U = ArrayLen(Session.MyCat) +1;
V = url.l;  
if (ArrayLen(Session.MyCat) eq 0){
Session.MyCat[1][1] = session.Show;
}
for(T=2; T LTE 53; T=T+1){
Session.MyCat[U][T] = 1;//Session.QueryList[V][T];
}   
}
..
  

session.CurList = "MyCat";
session.Catlist = Duplicate(session.MyCat);
if (IsDefined("url.A")){
url.l = U;
}   
//session.MyCat = Duplicate(session.Catlist);

MyCat #ArrayLen(Session.MyCat)#CatList
#ArrayLen(Session.Catlist)#
 
...

CatSearch---
-
Only included The link to trigger the array entry.
.Add Lot
#Session.CatList[url.l][2]#
..

If there is anything you all need, just let me know


Thank You,
Christian Watt
Webmaster
SkillPath Seminars
[EMAIL PROTECTED] 

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:23 AM
To: CF-Talk
Subject: Re: 


  Give us some more information.

  What is the code you use to copy one array information into the 
other?  Where is the code located?  ( Application.cfm, presumably? )
  What scope are you storing the array in?
  What links are you clicking to move from page to page?
  Is there a reason you are using an Array to hold query data instead of a 
query object?

At 11:48 PM 1/27/2003 -0600, you wrote:

>Is anyone on right now???
>
>I have an issue with arrays that I CAN NOT EXPLAIN
>
>
>
>I have two arrays, one holds returned query data - Array1, the other a 
>personal selection from the first Array - Array2.
>
>When I add data from the first array to the second, no problem, I have 
>an ArrayLen and everything is great.
>
>The problem is that no matter what link I click next, the data gets 
>added again.  I have put ArrayLens from application to the very end.  
>The array length has already changed at the very top of the application 
>page, but is one less at the end of the previous page.  I am not a 
>newbie.  I have been coding CF for over 4 years now and I have never 
>seen anything like this.
>
>Please, if anyone is on, I have examples and live site to see CFMX
>W2K
>SQL2000
>
>Christian
>
>[EMAIL PROTECTED]
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfus

RE: CSV loop

[Andy Ousterhout]

Turn on display query in Admin Debug.  Check to see the result of the WHERE
clause.  Most likely, it is not turning out the way you think.

Andy
-Original Message-
From: [EMAIL PROTECTED] (Rafael Alan Bleiweiss)
[mailto:[EMAIL PROTECTED] (Rafael Alan Bleiweiss)]
Sent: Tuesday, January 28, 2003 1:17 PM
To: CF-Talk
Subject: CSV loop


I'm running a loop over a csv with five columns in order to update an
Access Table - when I run it, nothing appears to happen - it doesn't update
the table, but it doesnt give me an error message... as though it's not
finding any matches on the table even though they do exist...

What's wrong with this code?











   
  UPDATE  Products
  SET  Series = '#listgetAt('#line#',2, '#delims#')#"',
  SeriesDescription = '#listgetAt('#line#',3, '#delims#')#"',
  JPG = '#listgetAt('#line#',4, '#delims#')#"',
  PDF = '#listgetAt('#line#',5, '#delims#')#"'
  where (MFGPartNumber = '#listgetAt('#line#',1, '#delims#')#"')
   




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Jesse Houwing]

Joshua Miller wrote:

>I dug out the error message, here's what it is - likely NOT a Windows
>Error:
>
>Error occurred during initialization of VM
>Could not reserve enough space for object heap
>Error occurred during initialization of VM
>Could not reserve enough space for object heap listening on port 2901
>
>I started getting this error after installing the RAM and changing the
>setting in CFMX ... Didn't error until I tried to change the JVM Max
>Memory setting. I know this to be true because my server monitor didn't
>choke for the first 2 days the RAM was installed and the setting hadn't
>been changed. The day I changed the setting I started getting bombed
>with messages from the Server Monitor that CFMX service was down.
>
>I know there is plenty of memory to allocate the 1664mb. If I change the
>value back to 512 I still get the same problem. The other server has
>only 384mb RAM (it's a development server that only I use) and it's set
>to 512mb but I only have 384mb in that server. I know there's not enough
>RAM to support 512mb to the JVM on that box, so why doesn't it choke
>when starting with the JVM setting higher than the amount of RAM on that
>system?
>
>The server is at 3rd party host and as much as I would like to toy
>around with removing memory, etc. they charge $65 an hour to do that
>kind of thing - and it's a live server. I thought I'd ask some other
>CF-ers before I went spending money on trying to fix something. 
>
>As for the Macromedia Support - I have issues with paying $200+ to find
>out why the CFMX Service errors because I change a setting in
>CFAdministrator that shouldn't cause an error in the first place. There
>is plenty of memory to support the change and the RAM is fine. I had the
>hosting company verify that it was correctly installed and that nothing
>else was failing as a result of the upgrade.
>
>One other item to note is that we also added a second processor to the
>machine when upgrading the memory ... But it seems unlikely that would
>affect the VM heap memory allocation.
>
>Anyone have any clues?
>
>Joshua Miller
>  
>
Have you tried a different JVM? Sun's JDK 1.4 or JRockit 7.0?

Maybe they won't error out with such an abundance of memory

Jesse

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Joshua Miller]

I dug out the error message, here's what it is - likely NOT a Windows
Error:

Error occurred during initialization of VM
Could not reserve enough space for object heap
Error occurred during initialization of VM
Could not reserve enough space for object heap listening on port 2901

I started getting this error after installing the RAM and changing the
setting in CFMX ... Didn't error until I tried to change the JVM Max
Memory setting. I know this to be true because my server monitor didn't
choke for the first 2 days the RAM was installed and the setting hadn't
been changed. The day I changed the setting I started getting bombed
with messages from the Server Monitor that CFMX service was down.

I know there is plenty of memory to allocate the 1664mb. If I change the
value back to 512 I still get the same problem. The other server has
only 384mb RAM (it's a development server that only I use) and it's set
to 512mb but I only have 384mb in that server. I know there's not enough
RAM to support 512mb to the JVM on that box, so why doesn't it choke
when starting with the JVM setting higher than the amount of RAM on that
system?

The server is at 3rd party host and as much as I would like to toy
around with removing memory, etc. they charge $65 an hour to do that
kind of thing - and it's a live server. I thought I'd ask some other
CF-ers before I went spending money on trying to fix something. 

As for the Macromedia Support - I have issues with paying $200+ to find
out why the CFMX Service errors because I change a setting in
CFAdministrator that shouldn't cause an error in the first place. There
is plenty of memory to support the change and the RAM is fine. I had the
hosting company verify that it was correctly installed and that nothing
else was failing as a result of the upgrade.

One other item to note is that we also added a second processor to the
machine when upgrading the memory ... But it seems unlikely that would
affect the VM heap memory allocation.

Anyone have any clues?

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Brad Howerter [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 2:03 PM
To: CF-Talk
Subject: CFMX Memory Issue


I have a similar problem with our server running CFMX.  If I try to
specify a JVM Max Memory setting greater than 1700MB, the coldFusion
service will not start; it errors with WIndows Error 2.  The server has
4 Gigs of memory, so 1800MB should be okay.

On Tuesday, January 28, 2003, at 09:19 AM, Joshua Miller wrote:

> I posted this last week but no one seemed to have any ideas, or the 
> title wasn't interesting enough and I can't find any information 
> anywhere about this problem, so I thought I'd repost.
>
> We recently added 1.5gb of RAM to our application server bringing the 
> total to 2.5gb. I changed the JVM Max Memory setting in 
> CFAdministrator but now I'm getting a Windows error 2 when CFMX starts

> and it's reporting to my Server Monitor software that the ColdFusion 
> MX service is down. Everything works correctly (ie: can serve pages,
etc.) but
> CFMX
> isn't using the amount of memory I specified.
>
> I set the JVM Max Memory setting to 1664mb (we have plenty to afford
> this) and it tops out at around 600mb usage under heavy load and could

> use the additional memory that's been allocated.
>
> Even if I set the JVM Max Memory setting back to the default 512mb it 
> still gives this error.
>
> I've double-checked the settings against another instance of CFMX 
> running in another location and they're identical except for this 
> value but one starts and the other won't. The only difference is I've 
> never changed the setting on the other server.
>
> Anyone? Any Macromedians out there have a clue or know how I can get 
> Email support from Macromedia?
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254

***
The information in this e-mail is confidential and intended solely for
the individual or entity to whom it is addressed. If you have received
this e-mail in error 

CSV loop

[CFusion]

I'm running a loop over a csv with five columns in order to update an 
Access Table - when I run it, nothing appears to happen - it doesn't update 
the table, but it doesnt give me an error message... as though it's not 
finding any matches on the table even though they do exist...

What's wrong with this code?











   
  UPDATE  Products
  SET  Series = '#listgetAt('#line#',2, '#delims#')#"',
  SeriesDescription = '#listgetAt('#line#',3, '#delims#')#"',
  JPG = '#listgetAt('#line#',4, '#delims#')#"',
  PDF = '#listgetAt('#line#',5, '#delims#')#"'
  where (MFGPartNumber = '#listgetAt('#line#',1, '#delims#')#"')
   



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: XML settings files for CF apps

[Matthew Walker]

We have used multiple XML settings files for our CMS. We also use XML to
store data about each custom tag publicly available within the system. The
XML contains the name, description of how it works, and info about the
parameters. The data then gets used to generate error messages, help,
cfparams, and forms, i.e. it gets used in widely different ways that would
necessitate a great deal of duplication of information if we hadn't chosen
some generic middle ground. However, we found running xmlParse() several
times a page slowed things down considerably. Now we cache the parsed result
and everything runs much better.

I don't think converting parameters to XML in itself separates parameters
from code any better than if you simply had a settings file with a bunch of
cfsets. Also a .xml file is a security problem. How do you stop anybody
viewing it? The good news is you can call your file .cfm and it'll work just
as well.

- Original Message -
From: "webguy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 7:40 AM
Subject: RE: XML settings files for CF apps


> >
> > OK, I've not used XML much, and in revamping our basic CF template, I'm
> > wondering about storing application variables in an XML file, as per
Ben's
> > design pattern:
> >
> > http://www.benorama.com/coldfusion/patterns/part6.htm
>
> Great article.
>
> > What are the advantages of this? I accept the theoretical principle of
> > separating parameters from the application code so the
> > application itself is
> > totally portable. But in practice, when I do move an application around,
> > what's the difference between me opening an XML file and changing
> > stuff, and
> > me opening a CFM file and changing stuff?
>
> Got to look at the bigger picture. If you are using cf only and forever
then
> a cfm settings file is fine. In fact its probably faster. But what if you
> start to move to java ? Or you want to create a VB app as a config
> editor...??
>
> That's the real advantage of XML.
>
> As for speed, once you parse the XML you can stick the DOM into
application
> scope. No need to read it ever time.
>
> WG
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Brad Howerter]

I have a similar problem with our server running CFMX.  If I try to specify
a JVM Max Memory setting greater than 1700MB, the coldFusion service will
not start; it errors with WIndows Error 2.  The server has 4 Gigs of memory,
so 1800MB should be okay.

On Tuesday, January 28, 2003, at 09:19 AM, Joshua Miller wrote:

> I posted this last week but no one seemed to have any ideas, or the
> title wasn't interesting enough and I can't find any information
> anywhere about this problem, so I thought I'd repost.
>
> We recently added 1.5gb of RAM to our application server bringing the
> total to 2.5gb. I changed the JVM Max Memory setting in CFAdministrator
> but now I'm getting a Windows error 2 when CFMX starts and it's
> reporting to my Server Monitor software that the ColdFusion MX service
> is down. Everything works correctly (ie: can serve pages, etc.) but  
> CFMX
> isn't using the amount of memory I specified.
>
> I set the JVM Max Memory setting to 1664mb (we have plenty to afford
> this) and it tops out at around 600mb usage under heavy load and could
> use the additional memory that's been allocated.
>
> Even if I set the JVM Max Memory setting back to the default 512mb it
> still gives this error.
>
> I've double-checked the settings against another instance of CFMX
> running in another location and they're identical except for this value
> but one starts and the other won't. The only difference is I've never
> changed the setting on the other server.
>
> Anyone? Any Macromedians out there have a clue or know how I can get
> Email support from Macromedia?
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254

***
The information in this e-mail is confidential and intended solely for the
individual or entity to whom it is addressed. If you have received this
e-mail in error please notify the sender by return e-mail, delete this
e-mail, and refrain from any disclosure or action based on the information.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 Memory Issue

[Christian Cantrell]

You just started getting this error after installing the additional  
RAM?  Does this other server that you mention also have 2.5gb of RAM?   
If you take the RAM out of the server, does ColdFusion then behave as  
expected?  What does a "Windows error 2" generally indicate?

Sorry to answer questions with more questions, but I have no idea what  
might be going on here.  ColdFusion can defiantly run with the amount  
of RAM that you are allocating, however I am not familiar enough with  
Windows servers to know what might be going wrong.  It sounds to me  
like it could just as likely be a Windows or even a hardware issue as a  
ColdFusion issue.  You might try posing information about the error to  
a Windows group or list.

As for Macromedia support options, you can find them here:

http://www.macromedia.com/support/coldfusion/

Christian

On Tuesday, January 28, 2003, at 09:19 AM, Joshua Miller wrote:

> I posted this last week but no one seemed to have any ideas, or the
> title wasn't interesting enough and I can't find any information
> anywhere about this problem, so I thought I'd repost.
>
> We recently added 1.5gb of RAM to our application server bringing the
> total to 2.5gb. I changed the JVM Max Memory setting in CFAdministrator
> but now I'm getting a Windows error 2 when CFMX starts and it's
> reporting to my Server Monitor software that the ColdFusion MX service
> is down. Everything works correctly (ie: can serve pages, etc.) but  
> CFMX
> isn't using the amount of memory I specified.
>
> I set the JVM Max Memory setting to 1664mb (we have plenty to afford
> this) and it tops out at around 600mb usage under heavy load and could
> use the additional memory that's been allocated.
>
> Even if I set the JVM Max Memory setting back to the default 512mb it
> still gives this error.
>
> I've double-checked the settings against another instance of CFMX
> running in another location and they're identical except for this value
> but one starts and the other won't. The only difference is I've never
> changed the setting on the other server.
>
> Anyone? Any Macromedians out there have a clue or know how I can get
> Email support from Macromedia?
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> *** 
> *
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it  
> is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to
> 
> [EMAIL PROTECTED]
> *** 
> *
> *
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

CFFTP and zero byte files

[Stephenie Hamilton]

I have a client who is using a scheduled task to grad a db from another
server via cfftp. He claims that it doesn't work and only returns a 0 k
file. I verified it is behaving as he said and even tested it with a
different ftp server, still same results. I did see this kb article
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22302&Method=Full

but he is using CFMX, not CF5. I did verify the CF Service is running
under an account that has perms to the dir he is trying to ftp the file
into, the local file attribute is correct, but still no luck

Anyone seen this before on CFMX?


~~
Stephenie 




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CFQuery Retrieval of cached query failed

[jon hall]

Thanks for your replies, it's good to know I'm not alone at
least...I'm kind of tempted to call Macromedia Support, as there is no
mention of the error anywhere on the Macr site, or even on Google.
I'm a bit scared I will end up explaining the same thing 10 times
before I get to someone who tells me I'm SOL...

-- 
 jon
 mailto:[EMAIL PROTECTED]

Monday, January 27, 2003, 8:35:18 PM, you wrote:
ps> I've seen it, too.  On CF5.  Not as often as you are.

ps> best,  paul

ps> At 04:17 PM 1/27/03 -0500, you wrote:
>>   On CF5, I'm getting this error on random pages at random times. The
>>   queries have nothing in common other than they connect to the same
>>   datasource.
>>   However I am starting to get it fairly (1-2 times a day, and
>>   today 3 times) consistently now as load starts to climb on a new app.
>>
>>   Anyone seen this error, or know what could be causing it?
>>--
>>  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=subscribe&forumid=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

Using MS Access Queries as SP

[Rodney.Bruce]

Hi everybody

I am trying to use queries in access(2K) as SP.
I can get all to work but dates.

If I hard code dates in the query like:   #1/15/2003#  the correct records
are returned.
Just can't get it to work with:


  


This doesn't error, but also doesn't return any records.

I have tried placing the #s around the var in the query, but Access doesn't
like that.
I have tried


which gets me the error:
Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast
specification (null)

I have tried:



which sends the date as:  #1/15/2003# to the query, again no error, but no
records.

The format of the date field is Short Date mm/dd/.

Using:
CF5
WIN2K
Access 2K

Any help would be appreciated.
TIA
Rodney
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: XML settings files for CF apps

[webguy]

>
> OK, I've not used XML much, and in revamping our basic CF template, I'm
> wondering about storing application variables in an XML file, as per Ben's
> design pattern:
>
> http://www.benorama.com/coldfusion/patterns/part6.htm

Great article.

> What are the advantages of this? I accept the theoretical principle of
> separating parameters from the application code so the
> application itself is
> totally portable. But in practice, when I do move an application around,
> what's the difference between me opening an XML file and changing
> stuff, and
> me opening a CFM file and changing stuff?

Got to look at the bigger picture. If you are using cf only and forever then
a cfm settings file is fine. In fact its probably faster. But what if you
start to move to java ? Or you want to create a VB app as a config
editor...??

That's the real advantage of XML.

As for speed, once you parse the XML you can stick the DOM into application
scope. No need to read it ever time.

WG

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

XML settings files for CF apps

[Gyrus]

OK, I've not used XML much, and in revamping our basic CF template, I'm
wondering about storing application variables in an XML file, as per Ben's
design pattern:

http://www.benorama.com/coldfusion/patterns/part6.htm

What are the advantages of this? I accept the theoretical principle of
separating parameters from the application code so the application itself is
totally portable. But in practice, when I do move an application around,
what's the difference between me opening an XML file and changing stuff, and
me opening a CFM file and changing stuff?

There doesn't seem to be much difference between the two. To output the
application settings when set in a CF template, you need another bit of code
to display them, whereas with the XML file you've got a range of output
options straight away. But then with the XML file you need another CF
template to read the settings into the application scope.

Is it swings and roundabouts or am I really missing something with XML?

On a related note: does anyone know a way of outputting the CF Admin's
Setttings Summary page from somewhere else? I'm trying to convince our
hosts, who we resell through, to have some sort of output of the CF (MX)
server's settings when we log in to our reseller control panel. I don't know
if the control panel is on another box or not, but I guess the question
remains the same: how to grab this output page from somewhere other than the
CFIDE?

TIA,

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Connecting multiple JRun (CFMX) servers to Apache

[Sean A Corfield]

On Tuesday, Jan 28, 2003, at 04:40 US/Pacific, Dick Applebaum wrote:
> I would like to setup multiple servers, named CFMX1, CFMX2 CFMXn,
> and connect them to Apache.

I'm not sure what you're trying to do here...

If you want http://localhost/cfmx1/foo.cfm to go to the first server 
and http://localhost/cfmx2/foo.cfm to go to the second etc, then 
perhaps you need to look at context roots instead? Set up a single 
server but have multiple CFMX installs, each in a separate context 
root. That's how I run CFMX on Tomcat (three context roots).

I think you already know how to connect Apache to a cluster (of 
identical server instances)?

> How? -- The wsconfig program refuses to setup a second connection, so I
> suspect it requires manual editing of configuration files.

mod_jrun does not work inside a VirtualHost (or at least it didn't the 
last time I tried it - in fact it crashed Apache!) so you can only 
really have one CFMX connection.

Explain in more detail exactly what you're trying to do and we'll see 
whether it's possible...

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim/iChat: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.macromedia.com/go/arch_blog

ColdFusion MX and JRun 4 now available for Mac OS X!
http://www.macromedia.com/go/cfmxosx

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Oracle and CF5 - RESOLVED -

[Randell B Adkins]

Everyone has the same permissions, so I ruled that out as well.

However something HOSED CFADMIN cause I removed and re-installed
CF Application Server and then it was back in business with executing
the query as written.

Strange cause I was able to run other queries to other datasources
and everything was fine. Just with this particular one.

>>> [EMAIL PROTECTED] 01/28/03 12:35PM >>>
The Administrator just verifies it can connect to the datasource.  It's
not until you actually try querying something that the user tries to
access any schema.

So, if your CF user only has (I think) CREATE SESSION privileges, it
can connect to Oracle, but without permission to schema objects, it
can't do anything.

Verify the cfuser that you're connecting to the DB as has the
privileges it needs to do what you're attempting.  Conversely, using
username & password defined in the cfquery tag will override any DSN
settings, and connect as the user specified in the username attribute.

FWIW

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:58 AM
To: CF-Talk
Subject: RE: Oracle and CF5


If I add that it works. But that is not an option.
Other workstations are NOT using the parameters on
the queries. In CFADMIN, the paramters are on the
Datasource Connection and verifies without hesitation.

If CF login did not have access to the schema, why would
the ADMINISTRATOR be able to verify the connection? 

Suggestions ???

>>> [EMAIL PROTECTED] 01/28/03 10:56AM >>>
Are you sure the cf login has access to the schema?

Just to make sure add username="username here" and password="password
here"
to the cfquery.


-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:29 AM
To: CF-Talk
Subject: Oracle and CF5

I have on my localbox the oracle client and running pages locally.
In CFADMIN I have the Native Datasource set for a DSN of: MyDevData

Then it will verify w/o a problem. Yes in CFADMIN there is a username
and password to the datasource.

When I try to run a page in CF that has a query similar to the one
shown
below, I get the error:
[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied 


SELECT  Dev_Application_Name
FROMtblDev_Applications


Why does it verify perfectly in CFADMIN and not when it is ran on a 
normal CFM page?

Other users within my development team can run the same items
without a problem.

Suggestions?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Oracle and CF5

[Lincoln Milner]

The Administrator just verifies it can connect to the datasource.  It's not until you 
actually try querying something that the user tries to access any schema.

So, if your CF user only has (I think) CREATE SESSION privileges, it can connect to 
Oracle, but without permission to schema objects, it can't do anything.

Verify the cfuser that you're connecting to the DB as has the privileges it needs to 
do what you're attempting.  Conversely, using username & password defined in the 
cfquery tag will override any DSN settings, and connect as the user specified in the 
username attribute.

FWIW

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 10:58 AM
To: CF-Talk
Subject: RE: Oracle and CF5


If I add that it works. But that is not an option.
Other workstations are NOT using the parameters on
the queries. In CFADMIN, the paramters are on the
Datasource Connection and verifies without hesitation.

If CF login did not have access to the schema, why would
the ADMINISTRATOR be able to verify the connection? 

Suggestions ???

>>> [EMAIL PROTECTED] 01/28/03 10:56AM >>>
Are you sure the cf login has access to the schema?

Just to make sure add username="username here" and password="password
here"
to the cfquery.


-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:29 AM
To: CF-Talk
Subject: Oracle and CF5

I have on my localbox the oracle client and running pages locally.
In CFADMIN I have the Native Datasource set for a DSN of: MyDevData

Then it will verify w/o a problem. Yes in CFADMIN there is a username
and password to the datasource.

When I try to run a page in CF that has a query similar to the one
shown
below, I get the error:
[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied 


SELECT  Dev_Application_Name
FROMtblDev_Applications


Why does it verify perfectly in CFADMIN and not when it is ran on a 
normal CFM page?

Other users within my development team can run the same items
without a problem.

Suggestions?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Multiple Mail Attachments with CF 4.0

[Kamie Curfman]

The CFMAILPARAM tag didn't come out til 4.5.  With
4.0, you're supposed to use:



But the MIMEATTACH attribute only lets you upload one
file.  No comma-delimited lists, no setting of dummy
variables (that contain multiple items), nada. 
Furthermore, although the zipping idea was a great one
(I've used the CFX_Zip tag in the past and love it),
the low-budget plan selected (by the contractor/host)
doesn't allow for the registering of CFX tags.

On top of everything, this is on behalf of a
non-profit that doesn't want to shell out any more
money (and, in my opinion, shouldn't have to since the
contractor/host should have more recent software), so
I advised my contact (I'm a subcontractor) to upgrade
to at least a 5.0 box.  That's what they've done. 
Wahoo.

Thanks everyone.

Kamie

--- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote:
> I don't remember ever having any problems getting
> multiple attachments on CF
> 4.0 ... I'm pretty sure it was 3 that had that
> problem. I could be wrong,
> but afaik
> 
> 
>   mesage here
>   
>   
>   
> 
> 
> What have you been trying?
> 
> hth

=
Kamie Curfman, Web Developer, FGM Inc.
45245 Business Court, Suite 400
Dulles, VA 20166
http://www.fgm.com

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Coldfusion and Verity Results ???

[Ryan Kime]

Ian,

I am doing the same thing you are trying to get at. My results can be any
number of collections including text-based and db-based, just supply cfif
statements if the custom parameters are supplied for this particular record.
If you have set up the "return url" correctly in the collections, you will
be able to use the #url# parameter instead of static links such as
"/itdownloads/downloads/"



 
url: #custom1#">#url#
#custom1#



-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 5:59 AM
To: CF-Talk
Subject: Coldfusion and Verity Results ???


Hi

I would be grateful if somebody with an in depth experience of coldfusion
and verity can help moe achive my goal here please

>From the search form below the user has the option of searching all of the
site or just individual collections such as Links, Software Downloads...






Search for : 


All of the site
Links
Software Downloads
Document Knowledgebase
News/Area



In the search results page how can the results of the search be shown, as
the user may have chosen to search all the site (collections) if this is the
case then I have the following problem...

Because each link from each collection would be different for example (show
below), how could this functionality be achieved in the results??

#title#
#title#
#title#






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Multiple Mail Attachments with CF 4.0

[S . Isaac Dealey]

I don't remember ever having any problems getting multiple attachments on CF
4.0 ... I'm pretty sure it was 3 that had that problem. I could be wrong,
but afaik


mesage here





What have you been trying?

hth

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


> Is it in the budget to use the IMS-SE MailServer. I'm
> pretty sure your can
> do it with the CFX tag and the IMS post server (approx
> 250.00 bucks)

> See http://www.coolfusion.com if you are interested.

> Brook


> At 06:39 AM 1/28/2003 -0800, you wrote:
>>Oh, for the love of crap, I was afraid this was going
>>to be the answer.  I have three (and exactly three)
>>files I need to attach to every mail I send out.  Are
>>there any workarounds?  These people are not going to
>>want to receive three emails for every application
>>that gets entered.
>>
>>Kamie
>>
>>--- Bill Grover <[EMAIL PROTECTED]> wrote:
>> > In 4.0 you could only attach 1 file at a time.
>> >
>>__
>> >
>> > > -Original Message-
>> > > From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
>> > > Sent: Monday, January 27, 2003 11:30 PM
>> > > To: CF-Talk
>> > > Subject: Multiple Mail Attachments with CF 4.0
>> > >
>> > >
>> > > I'm freelancing for a client who still has CF 4.0
>> > on
>> > > their server (yes, I know).  I'm trying to send
>> > > multiple attachments with the CFMAIL tag.  I had
>> > > totally forgotten about the MIMEATTACH attribute
>> > > (tried doing CFMAILPARAM instead) and now can't
>> > figure
>> > > out how to send multiple files with it.  Can this
>> > not
>> > > be done?
>> > >
>> > > Thanks in advance.
>> > >
>> > > Kamie
>>
>>=
>>Kamie Curfman, Web Developer, FGM Inc.
>>45245 Business Court, Suite 400
>>Dulles, VA 20166
>>http://www.fgm.com
>>
>>__
>>Do you Yahoo!?
>>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>>http://mailplus.yahoo.com
>>
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=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/uns
>   ubscribe.cfm?user=633.558.4


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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:

[Jeffry Houser]

  Give us some more information.

  What is the code you use to copy one array information into the 
other?  Where is the code located?  ( Application.cfm, presumably? )
  What scope are you storing the array in?
  What links are you clicking to move from page to page?
  Is there a reason you are using an Array to hold query data instead of a 
query object?

At 11:48 PM 1/27/2003 -0600, you wrote:

>Is anyone on right now???
>
>I have an issue with arrays that I CAN NOT EXPLAIN
>
>
>
>I have two arrays, one holds returned query data - Array1, the other a
>personal selection from the first Array - Array2.
>
>When I add data from the first array to the second, no problem, I have an
>ArrayLen and everything is great.
>
>The problem is that no matter what link I click next, the data gets added
>again.  I have put ArrayLens from application to the very end.  The array
>length has already changed at the very top of the application page, but is
>one less at the end of the previous page.  I am not a newbie.  I have been
>coding CF for over 4 years now and I have never seen anything like this.
>
>Please, if anyone is on, I have examples and live site to see
>CFMX
>W2K
>SQL2000
>
>Christian
>
>[EMAIL PROTECTED]
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 grab this record??

[Acantrell]

ps. you'll still want to throw a trim in there if you have white space...

left(PrimaryIDSchoolIDSchoolYear, len(trim(PrimaryIDSchoolIDSchoolYear)) -
10)


> -Original Message-
> From: "Cantrell>,Adam" <[EMAIL PROTECTED] [mailto:"Cantrell>,Adam"
> <[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 10:38 AM
> To: CF-Talk
> Subject: RE: how do I grab this record??
> 
> 
> If the length of the schoolID and school year never change, 
> let's say they
> make up 10 characters, then just subtract that from the 
> overall length - 
> 
> 
> left(PrimaryIDSchoolIDSchoolYear, 
> len(PrimaryIDSchoolIDSchoolYear) - 10)
> 
> 
> 
> 
> 
> > -Original Message-
> > From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 28, 2003 10:24 AM
> > To: CF-Talk
> > Subject: how do I grab this record??
> > 
> > 
> > Ok- I know this is easy.
> > I have a PrimaryID that is varchar (it's imported from 
> > another database)
> > My program uses this unique identifier then concatenates 
> > other nesseary info
> > to make a new unique number for the student in other tables.
> > ie: PrimaryID + SchoolID + SchoolYear
> > Because it's a varchar I use the trim function to get rid 
> of the extra
> > spaces.
> > HOwever, to get demographics I need just the initial 
> > primaryID.  But now my
> > trim function is not allowing me to pull the info correctly.
> > For example before I decided to add trim I would do this to 
> > connect the
> > tables.
> > (LEFT(PrimaryIDSchoolIDSchoolYear, 16)
> > But because the spaces are now trimmed (the primaryids have 
> > anywhere from
> > 8-16 spaces used) this of course doesn't work because it is 
> > now pulling part
> > of the schoolid/schoolyear as part of the number
> > Any way around it??
> > Thanks,
> > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: how do I grab this record??

[Acantrell]

If the length of the schoolID and school year never change, let's say they
make up 10 characters, then just subtract that from the overall length - 


left(PrimaryIDSchoolIDSchoolYear, len(PrimaryIDSchoolIDSchoolYear) - 10)





> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 10:24 AM
> To: CF-Talk
> Subject: how do I grab this record??
> 
> 
> Ok- I know this is easy.
> I have a PrimaryID that is varchar (it's imported from 
> another database)
> My program uses this unique identifier then concatenates 
> other nesseary info
> to make a new unique number for the student in other tables.
> ie: PrimaryID + SchoolID + SchoolYear
> Because it's a varchar I use the trim function to get rid of the extra
> spaces.
> HOwever, to get demographics I need just the initial 
> primaryID.  But now my
> trim function is not allowing me to pull the info correctly.
> For example before I decided to add trim I would do this to 
> connect the
> tables.
> (LEFT(PrimaryIDSchoolIDSchoolYear, 16)
> But because the spaces are now trimmed (the primaryids have 
> anywhere from
> 8-16 spaces used) this of course doesn't work because it is 
> now pulling part
> of the schoolid/schoolyear as part of the number
> Any way around it??
> Thanks,
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Coldfusion and Verity Results ???

[Ian Vaughan]

whats the solution if you are using 4.5 


- Original Message -
From: "<"Robertson-Ravo>,Neil (RX)"" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 4:20 PM
Subject: RE: Coldfusion and Verity Results ???


> he means using the ColdFusion 5 + feature of using QueryOfQueries...
>
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> Sent: 28 January 2003 16:22
> To: CF-Talk
> Subject: Re: Coldfusion and Verity Results ???
>
>
> What do you mean by doing a query of queries ???
>
> Has anybody on the list ever done anything like I am trying to achieve
> before ?? there must be some example of how to achieve this search result
> functionality with your verity search results???
>
>
> If you look at what I have so far...
>
>  
>  
>
>  Search Results -
>
>  
>  
>
>
>   
>
>   
>  
>
>   
>  
>
> 
>
> name = "GetResults"
>   collection = "#SearchCollection#"
>   criteria = "#Form.Criteria#"
>   maxRows = "#Evaluate(Form.MaxRows + 1)#"
>   startRow = "#Form.StartRow#"
>   >
>   
> name = "GetAllResults"
>   collection = "#SearchCollection#"
>   criteria = "#Form.Criteria#"
>   >
>
>  
>  
>  
>
>  
>
>  
>
>  
>  
>   No files found for specified criteria
>
>   
>
>  
>   
>
>Your search for "#Form.Criteria#"found
> #GetAllResults.RecordCount# matches.
>Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount
>   + Form.StartRow -1)# of #GetAllResults.RecordCount# items
> found.
>
>
>   
>   
>
>   
>   
>   Your search for "#Form.Criteria#"
>   found #GetAllResults.RecordCount# matche(s).
>   Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount +
> Form.StartRow -2)# of #GetAllResults.RecordCount# items found.
>   
>  
>
>   
>
>
>  "all">
>  #title#
>
>  #summary#
>  
>  Search Relevance : #NumberFormat
>( Round ( Score * 100) )# %
> 
>
>
>
>   
>
>
>  "all">
>  
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itdownloads/downloa
> ds/#custom1#">#title#
>  #summary#
>  Search Relevance : #NumberFormat
>( Round ( Score * 100) )# %
> 
>
>
>
> 
>
> 
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itdocuments/documen
> ts/#custom1#">#title#
> #custom1#
> Search Relevance : #NumberFormat
>   ( Round ( Score * 100) )# %
>
> 
>
>
>   
>
>
>
href="http://intranet.neath-porttalbot.gov.uk/itintranet/itnews/articledetai
> l.cfm?id=#key#">#title#
>#custom1#
>Search Relevance : #NumberFormat
>  ( Round ( Score * 100) )# %
>
>
>
>   
>
>
>
>
>
> 
>  
action="http://intranet.neath-porttalbot.gov.uk/itintranet/home/searchresult
> s.cfm" method="post">
>   
> """, "'", "all")#">
>
>
>
>
>   
>  
> 
>
>
> 
> 
>
> - Original Message -
> From: "Adam Reynolds" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 28, 2003 1:46 PM
> Subject: RE: Coldfusion and Verity Results ???
>
>
> > The verity results are in a query structure. You can always do a query
of
> > queries.
> >
> > > -Original Message-
> > > From: A.Little [mailto:[EMAIL PROTECTED]]
> > > Sent: 28 January 2003 12:32
> > > To: CF-Talk
> > > Subject: RE: Coldfusion and Verity Results ???
> > >
> > >
> > > When you index each collection set custom2 to be some value, eg
> > > 'link','download' etc. Then when you come to output the results just
do
> a
> > > cfswitch/case to determine which link the key or title should go to
and
> > > display accordingly.
> > >
> > > Alex
> > >
> > > > -Original Message-
> > > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> > > > Sent: 28 January 2003 11:59
> > > > To: CF-Talk
> > > > Subject: Coldfusion and Verity Results ???
> > > >
> > > >
> > > > Hi
> > > >
> > > > I would be grateful if somebody with an in depth experience
> > > > of coldfusion
> > > > and verity can help moe achive my goal here please
> > > >
> > > > From the search form below the user has the option of
> > > > searching all of the
> > > > site or just individual collections such as Links, Software
> > > > Downloads...
> > > >
> > > > 
> > > >
> > > > 
> > > > 
> > > >
> > > > Search for : 
> > > >
> > > > 
> > > > All of the site
> > > > Links
> > > > Software Downloads
> > > > Document Knowledgebase
> > > > News/Area
> > > > 
> > > > 
> > > >
> > > > In the search results page how can the results of the search
> > > > be shown, as
> > > > the user may have chosen to search all the site (collections)
> > > > if this is the
> > > > case then I have the following problem...
> > > >
> > > > Because each link from each collection would be different for
> > > > example (show
> > > > below), how could this functionality be achieved in the results??
> > > >
> > > > #title#
> > >

how do I grab this record??

[Janine Jakim]

Ok- I know this is easy.
I have a PrimaryID that is varchar (it's imported from another database)
My program uses this unique identifier then concatenates other nesseary info
to make a new unique number for the student in other tables.
ie: PrimaryID + SchoolID + SchoolYear
Because it's a varchar I use the trim function to get rid of the extra
spaces.
HOwever, to get demographics I need just the initial primaryID.  But now my
trim function is not allowing me to pull the info correctly.
For example before I decided to add trim I would do this to connect the
tables.
(LEFT(PrimaryIDSchoolIDSchoolYear, 16)
But because the spaces are now trimmed (the primaryids have anywhere from
8-16 spaces used) this of course doesn't work because it is now pulling part
of the schoolid/schoolyear as part of the number
Any way around it??
Thanks,

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Coldfusion and Verity Results ???

[Neil.Robertson-Ravo]

he means using the ColdFusion 5 + feature of using QueryOfQueries...

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2003 16:22
To: CF-Talk
Subject: Re: Coldfusion and Verity Results ???


What do you mean by doing a query of queries ???

Has anybody on the list ever done anything like I am trying to achieve
before ?? there must be some example of how to achieve this search result
functionality with your verity search results???


If you look at what I have so far...

 
 

 Search Results -

 
 


  
   
  
 
   
  
 



 
  
 

 
 
 

 

 

 
 
  No files found for specified criteria

  

 
  
   
   Your search for "#Form.Criteria#"found
#GetAllResults.RecordCount# matches.
   Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount
  + Form.StartRow -1)# of #GetAllResults.RecordCount# items
found.
   
   
  
  

  
  
  Your search for "#Form.Criteria#"
  found #GetAllResults.RecordCount# matche(s).
  Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount +
Form.StartRow -2)# of #GetAllResults.RecordCount# items found.
  
 

  

   

 #title#

 #summary#
 
 Search Relevance : #NumberFormat
   ( Round ( Score * 100) )# %

   


  

   

 http://intranet.neath-porttalbot.gov.uk/itintranet/itdownloads/downloa
ds/#custom1#">#title#
 #summary#
 Search Relevance : #NumberFormat
   ( Round ( Score * 100) )# %

   

   


http://intranet.neath-porttalbot.gov.uk/itintranet/itdocuments/documen
ts/#custom1#">#title#
#custom1#
Search Relevance : #NumberFormat
  ( Round ( Score * 100) )# %


   

  
   

   http://intranet.neath-porttalbot.gov.uk/itintranet/itnews/articledetai
l.cfm?id=#key#">#title#
   #custom1#
   Search Relevance : #NumberFormat
 ( Round ( Score * 100) )# %

   
   
  
   


   


 http://intranet.neath-porttalbot.gov.uk/itintranet/home/searchresult
s.cfm" method="post">
  
   
   
   
   
   
  
 






- Original Message -
From: "Adam Reynolds" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 1:46 PM
Subject: RE: Coldfusion and Verity Results ???


> The verity results are in a query structure. You can always do a query of
> queries.
>
> > -Original Message-
> > From: A.Little [mailto:[EMAIL PROTECTED]]
> > Sent: 28 January 2003 12:32
> > To: CF-Talk
> > Subject: RE: Coldfusion and Verity Results ???
> >
> >
> > When you index each collection set custom2 to be some value, eg
> > 'link','download' etc. Then when you come to output the results just do
a
> > cfswitch/case to determine which link the key or title should go to and
> > display accordingly.
> >
> > Alex
> >
> > > -Original Message-
> > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> > > Sent: 28 January 2003 11:59
> > > To: CF-Talk
> > > Subject: Coldfusion and Verity Results ???
> > >
> > >
> > > Hi
> > >
> > > I would be grateful if somebody with an in depth experience
> > > of coldfusion
> > > and verity can help moe achive my goal here please
> > >
> > > From the search form below the user has the option of
> > > searching all of the
> > > site or just individual collections such as Links, Software
> > > Downloads...
> > >
> > > 
> > >
> > > 
> > > 
> > >
> > > Search for : 
> > >
> > > 
> > > All of the site
> > > Links
> > > Software Downloads
> > > Document Knowledgebase
> > > News/Area
> > > 
> > > 
> > >
> > > In the search results page how can the results of the search
> > > be shown, as
> > > the user may have chosen to search all the site (collections)
> > > if this is the
> > > case then I have the following problem...
> > >
> > > Because each link from each collection would be different for
> > > example (show
> > > below), how could this functionality be achieved in the results??
> > >
> > > #title#
> > > #title#
> > > #title#
> > >
> > >
> > >
> > >
> > >
> > >
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Coldfusion and Verity Results ???

[Ian Vaughan]

What do you mean by doing a query of queries ???

Has anybody on the list ever done anything like I am trying to achieve
before ?? there must be some example of how to achieve this search result
functionality with your verity search results???


If you look at what I have so far...

 
 

 Search Results -

 
 


  
   
  
 
   
  
 



 
  
 

 
 
 

 

 

 
 
  No files found for specified criteria

  

 
  
   
   Your search for "#Form.Criteria#"found
#GetAllResults.RecordCount# matches.
   Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount
  + Form.StartRow -1)# of #GetAllResults.RecordCount# items
found.
   
   
  
  

  
  
  Your search for "#Form.Criteria#"
  found #GetAllResults.RecordCount# matche(s).
  Viewing #Form.StartRow# to #Evaluate(GetResults.RecordCount +
Form.StartRow -2)# of #GetAllResults.RecordCount# items found.
  
 

  

   

 #title#

 #summary#
 
 Search Relevance : #NumberFormat
   ( Round ( Score * 100) )# %

   


  

   

 http://intranet.neath-porttalbot.gov.uk/itintranet/itdownloads/downloa
ds/#custom1#">#title#
 #summary#
 Search Relevance : #NumberFormat
   ( Round ( Score * 100) )# %

   

   


http://intranet.neath-porttalbot.gov.uk/itintranet/itdocuments/documen
ts/#custom1#">#title#
#custom1#
Search Relevance : #NumberFormat
  ( Round ( Score * 100) )# %


   

  
   

   http://intranet.neath-porttalbot.gov.uk/itintranet/itnews/articledetai
l.cfm?id=#key#">#title#
   #custom1#
   Search Relevance : #NumberFormat
 ( Round ( Score * 100) )# %

   
   
  
   


   


 http://intranet.neath-porttalbot.gov.uk/itintranet/home/searchresult
s.cfm" method="post">
  
   
   
   
   
   
  
 






- Original Message -
From: "Adam Reynolds" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 1:46 PM
Subject: RE: Coldfusion and Verity Results ???


> The verity results are in a query structure. You can always do a query of
> queries.
>
> > -Original Message-
> > From: A.Little [mailto:[EMAIL PROTECTED]]
> > Sent: 28 January 2003 12:32
> > To: CF-Talk
> > Subject: RE: Coldfusion and Verity Results ???
> >
> >
> > When you index each collection set custom2 to be some value, eg
> > 'link','download' etc. Then when you come to output the results just do
a
> > cfswitch/case to determine which link the key or title should go to and
> > display accordingly.
> >
> > Alex
> >
> > > -Original Message-
> > > From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> > > Sent: 28 January 2003 11:59
> > > To: CF-Talk
> > > Subject: Coldfusion and Verity Results ???
> > >
> > >
> > > Hi
> > >
> > > I would be grateful if somebody with an in depth experience
> > > of coldfusion
> > > and verity can help moe achive my goal here please
> > >
> > > From the search form below the user has the option of
> > > searching all of the
> > > site or just individual collections such as Links, Software
> > > Downloads...
> > >
> > > 
> > >
> > > 
> > > 
> > >
> > > Search for : 
> > >
> > > 
> > > All of the site
> > > Links
> > > Software Downloads
> > > Document Knowledgebase
> > > News/Area
> > > 
> > > 
> > >
> > > In the search results page how can the results of the search
> > > be shown, as
> > > the user may have chosen to search all the site (collections)
> > > if this is the
> > > case then I have the following problem...
> > >
> > > Because each link from each collection would be different for
> > > example (show
> > > below), how could this functionality be achieved in the results??
> > >
> > > #title#
> > > #title#
> > > #title#
> > >
> > >
> > >
> > >
> > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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:

[Andy Ousterhout]

It would help if you would send the code with the problem.  You will have to
insert into the email since the list removes all attachments.

Andy

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 11:49 PM
To: CF-Talk
Subject: 


Is anyone on right now???

I have an issue with arrays that I CAN NOT EXPLAIN



I have two arrays, one holds returned query data - Array1, the other a
personal selection from the first Array - Array2.

When I add data from the first array to the second, no problem, I have an
ArrayLen and everything is great.

The problem is that no matter what link I click next, the data gets added
again.  I have put ArrayLens from application to the very end.  The array
length has already changed at the very top of the application page, but is
one less at the end of the previous page.  I am not a newbie.  I have been
coding CF for over 4 years now and I have never seen anything like this.

Please, if anyone is on, I have examples and live site to see
CFMX
W2K
SQL2000

Christian

[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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:

[Adrocknaphobia Jones]

So you're just parsing rows from one array to another? What does your
code look like? If the first array is coming from a query, couldn't you
just QoQ to parse the results then convert?

Lets see what you got.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 12:49 AM
To: CF-Talk
Subject: 

Is anyone on right now???

I have an issue with arrays that I CAN NOT EXPLAIN

 

I have two arrays, one holds returned query data - Array1, the other a
personal selection from the first Array - Array2.

When I add data from the first array to the second, no problem, I have
an
ArrayLen and everything is great.

The problem is that no matter what link I click next, the data gets
added
again.  I have put ArrayLens from application to the very end.  The
array
length has already changed at the very top of the application page, but
is
one less at the end of the previous page.  I am not a newbie.  I have
been
coding CF for over 4 years now and I have never seen anything like this.


Please, if anyone is on, I have examples and live site to see
CFMX
W2K
SQL2000 

Christian

[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: session_OnStart(), application_OnStart() in CFMX

[webguy]

Really interesting post.


> events.. Long story short...I wrote up a couple classes that sort of
> implement that functionality using the HttpSessionListener ( sorta == cfmx
> session scope) and ServletContextListener (sorta == application scope in
> cfmx) of the javax.servlet package.  You can read up here on the
> background:
> http://cephas.net/blog/archives/000237.html#000237

Ben Fortas J2ee book implements something like this too, that saves
abandoned shopping carts.  You can see book details here
http://www.forta.com/books/0321129482/ You can also download the code


I'll have to get back to the rest of your post later, bit busy !

WG

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: SQLException occurred in JDBCPool" for Access DB with password

[E. Keith Dodd]

Gyrus

I had a very similar problem--hosting company had error, fine for me
locally. I had the database name and datasource with a MX at end to
distinguish between new and old versions: MyBaseMX.mdb and datasource of
Bi.MyBaseMX.
Strange as it may seem, I took off the X on each (MyBaseM.mdb and
Bi.MyBaseM) and all set up fine!
Maybe try a different name. Doesn't make any sense, but worked in my
situation! (Maybe MX didn't like any competition!)

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

- Original Message -
From: "Gyrus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 10:30 AM
Subject: SQLException occurred in JDBCPool" for Access DB with password


> My host is setting me up on a test MX server prior to porting a site over
to
> their main MX box. They keep getting this message when trying to set up
the
> datasource (Access 2000 DB):
>
> Connection verification failed for data source: norlonto
> []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.
>
> >From searching around, I gather other people have had this problem too.
One
> guy I found solved it by repairing his Win2K server installation and
> rebooting. So I was ready to get high and mighty with my host, but they
tell
> me they have 15 sites with datasources up and running fine already, it's
> only mine causing the problem.
>
> They're telling me to take the password of the DB, which I'm playing along
> with for want of anything better to do. Maybe that'll get it working - but
> surely something is wrong with their MX installation if it can't work with
> Access DB's with passwords? Is this an issue that the updaters resolved?
>
> FWIW the DB has always run without problem on my local MX dev server.
>
> Gyrus
> [EMAIL PROTECTED]
> work: http://www.tengai.co.uk
> play: http://norlonto.net
> PGP key available
>


-
[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=subscribe&forumid=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: SQLException occurred in JDBCPool" for Access DB with password

[Gyrus]

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
> http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full
>
> No fun restarting CF MX on a production server though.

Thanks, Jochem, I had zero luck finding a direct reference to it on the MM
site myself. I'm trying to get my host to run this procedure while we're
still on a test box to see what's actually going on.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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-talk@houseoffusion.com

[CWatt]

Is anyone on right now???

I have an issue with arrays that I CAN NOT EXPLAIN

 

I have two arrays, one holds returned query data - Array1, the other a
personal selection from the first Array - Array2.

When I add data from the first array to the second, no problem, I have an
ArrayLen and everything is great.

The problem is that no matter what link I click next, the data gets added
again.  I have put ArrayLens from application to the very end.  The array
length has already changed at the very top of the application page, but is
one less at the end of the previous page.  I am not a newbie.  I have been
coding CF for over 4 years now and I have never seen anything like this. 

Please, if anyone is on, I have examples and live site to see
CFMX
W2K
SQL2000 

Christian

[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: session_OnStart(), application_OnStart() in CFMX

[Adrocknaphobia Jones]

Really interesting post.

What are you doing to end the session in CFMX? Just dropping the
timeout? Is it possible there is just a delay between CFMX sessions
ending and j2ee? Have you checked the logs recently?

I have this odd feeling that CFMX doesn't invalidate j2ee sessions
properly. I hope some1 from MM can add a little more light to this post.

You code looks air tight, so I don't think you are doing NEthing wrong,
at least as far as the 1.3 API is concerned.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 27, 2003 6:36 PM
To: CF-Talk
Subject: session_OnStart(), application_OnStart() in CFMX

hi everyone,

Couple weeks back (developers at MINDSEYE) had some interesting
discussions
w/ Macromedia guys about what we'd like to see in upcoming CFMX
releases..
one of the features we wanted was application onstart, session onstart
type
events.. Long story short...I wrote up a couple classes that sort of
implement that functionality using the HttpSessionListener ( sorta ==
cfmx
session scope) and ServletContextListener (sorta == application scope in
cfmx) of the javax.servlet package.  You can read up here on the
background:
http://cephas.net/blog/archives/000237.html#000237

and get the Java code samples, results, and web.xml mods to make it work
here:
http://cephas.net/blog/archives/000238.html#000238

I'm interested specifically in:

a) why the sessionDestroyed method doesn't return in CFMX (or at least
doesn't appear too, did I do something wrong?)

and b) in how to best implement this (ie: can I have I a separate
listener
for each application I create by placing a WEB-INF directory w/ the
corresponding web.xml in each application's web root?)

Other questions...

1) I haven't seen any good documentation on WEB-INF specifically related
to
CFMX.  The other servlet containers (ie: Tomcat, JRUN... ) require a
WEB-INF
*per application*... I've not seen that recommended with CFMX.  Can you
do
that? What are the ramifications of doing so?  Anyone have any good
documentation or notes on the use of WEB-INF in CFMX?

2) You'll see in my notes on the above links that using the listeners
only
return sessionID's of J2EE based sessions.  Anyone know of a way to get
the
session information in CFMX (ie: not http://cephas.net/blog/
[EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Oracle and CF5

[Randell B Adkins]

If I add that it works. But that is not an option.
Other workstations are NOT using the parameters on
the queries. In CFADMIN, the paramters are on the
Datasource Connection and verifies without hesitation.

If CF login did not have access to the schema, why would
the ADMINISTRATOR be able to verify the connection? 

Suggestions ???

>>> [EMAIL PROTECTED] 01/28/03 10:56AM >>>
Are you sure the cf login has access to the schema?

Just to make sure add username="username here" and password="password
here"
to the cfquery.


-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:29 AM
To: CF-Talk
Subject: Oracle and CF5

I have on my localbox the oracle client and running pages locally.
In CFADMIN I have the Native Datasource set for a DSN of: MyDevData

Then it will verify w/o a problem. Yes in CFADMIN there is a username
and password to the datasource.

When I try to run a page in CF that has a query similar to the one
shown
below, I get the error:
[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied 


SELECT  Dev_Application_Name
FROMtblDev_Applications


Why does it verify perfectly in CFADMIN and not when it is ran on a 
normal CFM page?

Other users within my development team can run the same items
without a problem.

Suggestions?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Oracle and CF5

[Steve Dworman]

Are you sure the cf login has access to the schema?

Just to make sure add username="username here" and password="password here"
to the cfquery.


-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 10:29 AM
To: CF-Talk
Subject: Oracle and CF5

I have on my localbox the oracle client and running pages locally.
In CFADMIN I have the Native Datasource set for a DSN of: MyDevData

Then it will verify w/o a problem. Yes in CFADMIN there is a username
and password to the datasource.

When I try to run a page in CF that has a query similar to the one
shown
below, I get the error:
[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied 


SELECT  Dev_Application_Name
FROMtblDev_Applications


Why does it verify perfectly in CFADMIN and not when it is ran on a 
normal CFM page?

Other users within my development team can run the same items
without a problem.

Suggestions?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: SQLException occurred in JDBCPool" for Access DB with password

[Jochem van Dieten]

Gyrus wrote:
> My host is setting me up on a test MX server prior to porting a site over to
> their main MX box. They keep getting this message when trying to set up the
> datasource (Access 2000 DB):
> 
> Connection verification failed for data source: norlonto
> []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.

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

No fun restarting CF MX on a production server though.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

CGLOBAL and CDATA client variables

[Brad Howerter]

Here's the answer to the question posed in thread http://www.houseoffusion.com/cf_lists/index.cfm?method=reply&forumid=4&threadid=20897&messagecounter=105607";>Client
 Variable Problem on Oracle (aka CGLOBAL and CDATA client variables)

ColdFusion works differently for client variables on Oracle than client variables on 
mysql.  Regardless of whether your oracle data source is odbc, jdbc oci, or native, 
ColdFusion rpads the cfid and app columns with spaces, out to a 64 characters.  So the 
cfid and app columns have to be defined as either varchar2(64) or char(64).  The 
cglobal cfid column also has to be a length of 64.  This differs from most of the 
online help I could find where they usually recommend char(20) for CFID.  In addition, 
the DATA column cannot be a CLOB.  The data is not read parsed properly if it is.  The 
DATA column works if it is a VARCHAR2.  I made mine a length of 4000, the maximum.

Mysql has none of these restrictions.  The columns are not rpadded with spaces and the 
data column can be 'text' (large strings).

SQL> desc cdata
 Name  Null?Type
 -  
 CFID   VARCHAR2(64)
 APPVARCHAR2(64)
 DATA   VARCHAR2(4000)

SQL> desc cglobal
 Name  Null?Type
 -  
 CFID   VARCHAR2(64)
 DATA   VARCHAR2(2000)
 LVISIT DATE

This will also solve ORA-0001 problems people are having on Oracle.  I only didn't hit 
ORA-0001 because I didn't yet have any indexes defined.  It looks like it would make 
sense to create a unique index on CGLOBAL.CFID and on CDATA (CFID, APP), as these are 
the columns used in the where clauses.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

SQLException occurred in JDBCPool" for Access DB with password

[Gyrus]

My host is setting me up on a test MX server prior to porting a site over to
their main MX box. They keep getting this message when trying to set up the
datasource (Access 2000 DB):

Connection verification failed for data source: norlonto
[]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.

>From searching around, I gather other people have had this problem too. One
guy I found solved it by repairing his Win2K server installation and
rebooting. So I was ready to get high and mighty with my host, but they tell
me they have 15 sites with datasources up and running fine already, it's
only mine causing the problem.

They're telling me to take the password of the DB, which I'm playing along
with for want of anything better to do. Maybe that'll get it working - but
surely something is wrong with their MX installation if it can't work with
Access DB's with passwords? Is this an issue that the updaters resolved?

FWIW the DB has always run without problem on my local MX dev server.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Oracle and CF5

[Randell B Adkins]

I have on my localbox the oracle client and running pages locally.
In CFADMIN I have the Native Datasource set for a DSN of: MyDevData

Then it will verify w/o a problem. Yes in CFADMIN there is a username
and password to the datasource.

When I try to run a page in CF that has a query similar to the one
shown
below, I get the error:
[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied 


SELECT  Dev_Application_Name
FROMtblDev_Applications


Why does it verify perfectly in CFADMIN and not when it is ran on a 
normal CFM page?

Other users within my development team can run the same items
without a problem.

Suggestions?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Multiple Mail Attachments with CF 4.0

[Mosh Teitelbaum]

If you have access to custom tags (CFX), you can use CFX_Zip to zip the 3
files into a single zip file and attach *that* to the email.  A lot of
processing per email though.  Definitely not an ideal solution.

You might also consider looking into custom tags that duplicate (exceed)
CFMAIL's functionality.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 9:40 AM
> To: CF-Talk
> Subject: RE: Multiple Mail Attachments with CF 4.0
>
>
> Oh, for the love of crap, I was afraid this was going
> to be the answer.  I have three (and exactly three)
> files I need to attach to every mail I send out.  Are
> there any workarounds?  These people are not going to
> want to receive three emails for every application
> that gets entered.
>
> Kamie
>
> --- Bill Grover <[EMAIL PROTECTED]> wrote:
> > In 4.0 you could only attach 1 file at a time.
> >
> __
> >
> > > -Original Message-
> > > From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 27, 2003 11:30 PM
> > > To: CF-Talk
> > > Subject: Multiple Mail Attachments with CF 4.0
> > >
> > >
> > > I'm freelancing for a client who still has CF 4.0
> > on
> > > their server (yes, I know).  I'm trying to send
> > > multiple attachments with the CFMAIL tag.  I had
> > > totally forgotten about the MIMEATTACH attribute
> > > (tried doing CFMAILPARAM instead) and now can't
> > figure
> > > out how to send multiple files with it.  Can this
> > not
> > > be done?
> > >
> > > Thanks in advance.
> > >
> > > Kamie
>
> =
> Kamie Curfman, Web Developer, FGM Inc.
> 45245 Business Court, Suite 400
> Dulles, VA 20166
> http://www.fgm.com
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 server 2000 - total number of objects in a DB

[Acantrell]

You're supposed to use system functions or stored procedures to access this,
but check out the sysobjects table. You could write a count() query to get
what you need out of that. Otherwise look in the books-online under system
functions to do it the right way, I don't know if there's already a function
that will return the number of objects in a given DB.

Adam.



> -Original Message-
> From: Andres [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 8:28 AM
> To: CF-Talk
> Subject: OT - SQL server 2000 - total number of objects in a DB
> 
> 
> Hello Everyone,
> How can i get a count of all indexes a database has? I have a 
> SQL 2000 server and need to get a count of various objects 
> (tables, indexes, triggers, view, SPs) Does anyone know of a 
> way to get these counts WITHOUT having to do it manually?
> 
> Thank you!
> 
> Andres
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Multiple Mail Attachments with CF 4.0

[brook]

Is it in the budget to use the IMS-SE MailServer. I'm pretty sure your can 
do it with the CFX tag and the IMS post server (approx 250.00 bucks)

See http://www.coolfusion.com if you are interested.

Brook


At 06:39 AM 1/28/2003 -0800, you wrote:
>Oh, for the love of crap, I was afraid this was going
>to be the answer.  I have three (and exactly three)
>files I need to attach to every mail I send out.  Are
>there any workarounds?  These people are not going to
>want to receive three emails for every application
>that gets entered.
>
>Kamie
>
>--- Bill Grover <[EMAIL PROTECTED]> wrote:
> > In 4.0 you could only attach 1 file at a time.
> >
>__
> >
> > > -Original Message-
> > > From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 27, 2003 11:30 PM
> > > To: CF-Talk
> > > Subject: Multiple Mail Attachments with CF 4.0
> > >
> > >
> > > I'm freelancing for a client who still has CF 4.0
> > on
> > > their server (yes, I know).  I'm trying to send
> > > multiple attachments with the CFMAIL tag.  I had
> > > totally forgotten about the MIMEATTACH attribute
> > > (tried doing CFMAILPARAM instead) and now can't
> > figure
> > > out how to send multiple files with it.  Can this
> > not
> > > be done?
> > >
> > > Thanks in advance.
> > >
> > > Kamie
>
>=
>Kamie Curfman, Web Developer, FGM Inc.
>45245 Business Court, Suite 400
>Dulles, VA 20166
>http://www.fgm.com
>
>__
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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