Re: ColdFusion 6.1 installer?

[Willy Ray]

Dave, you're the bomb.  Thanks.

/w

On Mon, Jun 2, 2008 at 4:17 PM, Dave Watts <[EMAIL PROTECTED]> wrote:
>> I need to find the CF6.1 installer.  I don't need a license,
>> or a serial, or media or anything like that, just need to DL
>> and install developer edition.  Anybody got any leads as to
>> where I'm going to find that?
>
> Fig Leaf Software has received permission from Adobe to redistribute these
> installers.
>
> CF 6.1 installer for Windows:
> http://www.figleaf.com/download/coldfusion-61-win.exe
>
> CF 7.0.2 installer for Windows:
> http://www.figleaf.com/download/coldfusion-702-win.exe
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306655
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

ColdFusion 6.1 installer?

[Willy Ray]

Hey All,

I need to find the CF6.1 installer.  I don't need a license, or a serial, or 
media or anything like that, just need to DL and install developer edition.  
Anybody got any leads as to where I'm going to find that?

Willy 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306648
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cf_encrypt()

[Willy Ray]

Rob, you rock.  :)

>>> [EMAIL PROTECTED] 8/19/2004 2:01:26 PM >>>
Well its not AES thats for sure ;-)

On Thu, 19 Aug 2004 13:10:55 -0600, Willy Ray
<[EMAIL PROTECTED]> wrote:
> Does anybody know what kind of encryption cf_encrypt() is using?
> 
> Willy
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: cf_encrypt()

[Willy Ray]

Yeah, that's what I'm curious about. What algorithm?  Thanks for
clarifying my question! :~)

Willy

>>> [EMAIL PROTECTED] 8/19/2004 1:12:14 PM >>>
VERY basic. It only returns a string with letters and numbers. Nothing
"special" about it not sure if it's any particular algorithm, or
just
something MM came up with... Would be nice to know, so if anyone has
any
details please post to list :)

ERJ
  -Original Message-
  From: Willy Ray [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, August 19, 2004 3:11 PM
  To: CF-Talk
  Subject: cf_encrypt()

  Does anybody know what kind of encryption cf_encrypt() is using?

  Willy

  -
  Willy Ray
  Web Applications Developer
  Certified Advanced ColdFusion Developer
  Westminster College
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

cf_encrypt()

[Willy Ray]

Does anybody know what kind of encryption cf_encrypt() is using?

Willy

-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Rijndael Encryption in CF?

[Willy Ray]

Maybe I should have been more clear.  I'm on a linux server, so I can't
run most of the cfx tags that are listed in the Google search, and I'm
not real interested in spending hundreds of dollars to encrypt one
stinkin' string.  What I'm hoping for is someone who's maybe used some
of the rijndael java classes to roll their own.

Thanks,

Willy

>>> [EMAIL PROTECTED] 8/2/2004 9:25:04 AM >>>
http://www.google.com/search?q=Rijndael+encryption+in+ColdFusion ???

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED] 
> Sent: 02 August 2004 17:16
> To: CF-Talk
> Subject: Rijndael Encryption in CF?
> 
> Anybody have any advice on implementing Rijndael encryption in
> ColdFusion?  All I need to do is encrypt one string, and stick it on
the
> url.  I've been looking for some java to do this, but I'm either not
> finding what I need, or I have no idea how to use it.
> 
> Any help would be greatly appreciated!
> 
> Willy
> 
> 
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Rijndael Encryption in CF?

[Willy Ray]

Anybody have any advice on implementing Rijndael encryption in
ColdFusion?  All I need to do is encrypt one string, and stick it on the
url.  I've been looking for some java to do this, but I'm either not
finding what I need, or I have no idea how to use it.

Any help would be greatly appreciated!

Willy

-----
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: MAX registration?

[Willy Ray]

This is from the hotels page on macr website:

"We offer several MAX 2004 conference hotels to give you the
opportunity to select the hotel that best fit your needs. All hotels
offer discounted rates for MAX attendees, and are centrally located to
the Ernest N. Morial Convention Center, the historic French Quarter, and
the Central Business District. 

A shuttle will also run from the three conference hotels to the
Convention Center."

This, to me, indicates that it'll be at the Ernest N. Morial Convention
Center, though, if so, this is the only spot on their website that I'm
seeing they're making any mention.

Willy

>>> [EMAIL PROTECTED] 6/23/2004 2:30:26 PM >>>
I'm not taking the bait :-)

  _  

From: simeon [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 23, 2004 4:24 PM
To: CF-Talk
Subject: Re: MAX registration?

This is one of those moments where I expect Ben Forta to chime in and 
say "Maybe.." or "Soon..."  Which seems to be the way, when asked about

details that have not yet been released.

he he he
sim

Ian Skinner wrote:

> I guess there where a few ways to interpret my question.  
>
> I was wondering at what facility in New Orleans the conference was 
> going to be at.  There have been some intelligent guesses.  But, I
was 
> a bit surprised that it was no mentioned in the MAX 2004 details on 
> the MM website [http://www.macromedia.com/macromedia/events/max/].  I

> can't imagine that the location is not settled on, since it is my 
> understanding that something this big would need at least nine to 
> twelve months advanced booking, wouldn't it?
>
> Ian
>
> --
>
> >From the homepage, Company -> Events -> Max 2004 -> Hotel works for
> me...unless I'm misunderstanding the question.
>
> Ken
>
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
> 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

multiple cferror type=exception tags

[Willy Ray]

Hey, I'm trying to have custom error types, but I'm having some trouble.
 I have in my Application.cfm file the following code.


exception="db_error">

exception="my_custom_error">

The problem is, even if I 



I get the error_templates/custom.cfm file as the error handler.  If I
switch the order of the two lines in the Application.cfm file, I get the
*other* error handling template regardless of what kind of exception I
throw.  

I had thought that cold fusion allowed multiple developer-designated
error types... What am I doing wrong?

Willy

-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFMX Easter egg (I think)

[Willy Ray]

I have MX.  I'm logging in first.  I'm seeing an error about not having permission to 
write the some serialize_license.tmp file.  What gives?

>>> [EMAIL PROTECTED] 03/14/03 02:07PM >>>
lol, that baby is scary looking

Thanks!
Robert Bailey
Famous for nothing


-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 14, 2003 4:19 PM
To: CF-Talk
Subject: RE: CFMX Easter egg (I think)


Log into the administrator first, then replace the URL with the one Zac
provided, that'll do the trick.

- Jim

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 14, 2003 2:59 PM
To: CF-Talk
Subject: RE: CFMX Easter egg (I think)


When i run that on my server, I just get the CF Admin login

Thanks!
Robert Bailey
Famous for nothing


-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 14, 2003 4:07 PM
To: CF-Talk
Subject: RE: CFMX Easter egg (I think)


If this is an Easter Egg, I'd hate to see what they do for Halloween.

/nightmares

Thanks, this'll be a hit amongst my cadre of ColdFusion goons :)

- Jim

-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 14, 2003 2:45 PM
To: CF-Talk
Subject: CFMX Easter egg (I think)


I certainly can't recommend anyone try this.  It didn't hurt my server any,
but my head still hurts a little.

This is somewhat disturbing  Kind of reminds me of some of the SciFi
channel's logo spots lately.

http:///cfide/administrator/settings/_licensedata.cfm?seri
alize

You'll need the Flash player installed.

Best regards,
Zac Bedell






~|
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: CFCs - any way to reload other than cycle CF service?

[Willy Ray]

Bingo.  That's exactly what's going on.  Duh.  Thanks!

Willy

>>> [EMAIL PROTECTED] 03/09/03 01:41PM >>>
>I overlooked that fact
>that I was putting the cfc in the session scope, and it wasn't
>recompiling :) Doh...



~|
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: CFCs - any way to reload other than cycle CF service?

[Willy Ray]

Alrighty, Trusted Cache is not on.  These aren't web services.  They're public-access 
CFCs.  I make a little change, and my pages that are using the CFC can't see new 
methods, or new code within old methods until I've cycled the server.

Willy

>>> [EMAIL PROTECTED] 03/09/03 12:42PM >>>
Actually, I develop and somebody else manages the server.  I know, I know.  ;)  I'll 
check that Trusted Cache setting.  Thanks.

Willy


>>> [EMAIL PROTECTED] 03/09/03 12:26PM >>>
Anyway, the problems I've run into are not consistent, which makes me
think you are referring to the fact that ColdFusion MX does not
automatically refresh Web services. Either that, or you have Trusted
Cache turned on. But if you turned that on, you'd probably know it, and
wouldn't be posting to the mailing list. :)




Benjamin S. Rogers
http://www.c4.net/ 
v.508.240.0051
f.508.240.0057

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 09, 2003 1:39 PM
To: CF-Talk
Subject: CFCs - any way to reload other than cycle CF service?


It's really bugging me to have to restart CFMX every time I make a
trivial little change to the component I'm developing.  Is there another
way to get the server to recognize the changes I've made to the CFC?

Willy




~|
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: CFCs - any way to reload other than cycle CF service?

[Willy Ray]

Actually, I develop and somebody else manages the server.  I know, I know.  ;)  I'll 
check that Trusted Cache setting.  Thanks.

Willy


>>> [EMAIL PROTECTED] 03/09/03 12:26PM >>>
Anyway, the problems I've run into are not consistent, which makes me
think you are referring to the fact that ColdFusion MX does not
automatically refresh Web services. Either that, or you have Trusted
Cache turned on. But if you turned that on, you'd probably know it, and
wouldn't be posting to the mailing list. :)




Benjamin S. Rogers
http://www.c4.net/ 
v.508.240.0051
f.508.240.0057

-----Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 09, 2003 1:39 PM
To: CF-Talk
Subject: CFCs - any way to reload other than cycle CF service?


It's really bugging me to have to restart CFMX every time I make a
trivial little change to the component I'm developing.  Is there another
way to get the server to recognize the changes I've made to the CFC?

Willy



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

CFCs - any way to reload other than cycle CF service?

[Willy Ray]

It's really bugging me to have to restart CFMX every time I make a trivial little 
change to the component I'm developing.  Is there another way to get the server to 
recognize the changes I've made to the CFC?

Willy

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

Day 3 Opera works! Re: The New Macromedia Website

[Willy Ray]

Except for the Download page that tells Opera users to "Please Use a
Supported Browser".  Baby steps, I guess.  Hopefully they'll get that
working at some point soon.

The home page is working great.  So, as a developer who's doing some
remoting, some RIAs (regardless of how *that* thread pans out), I'm
intensly curious:  What *exactly* was the problem, and will it effect
me, as I build RIAs?

Willy



>>> [EMAIL PROTECTED] 03/07/03 05:18AM >>>
Ahh good I am quite happy now that it was finally fixed so I can see
the
site.
That song on the front page is nice for all of 2 seconds and then it
burns
into your skull lol.

But looks like its not quite as laggy as it was in ie other 2 days.

Kudos MM for at least letting those people who like a good browser :)
(Opera) to use your site.





- Original Message -
From: "Sean A Corfield" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 4:31 AM
Subject: Re: The New Macromedia Website


On Thursday, Mar 6, 2003, at 14:08 US/Pacific, Adrocknaphobia Jones
wrote:
> For the last few years I've been telling upper management that I can
> cut
> costs, raise quality, and employ less developers. Cold Fusion is the
> solution for us. Am I supposed to go to them and say, I need 3 times
> the
> budget per project and quadruple my department size

I'm not sure why you think you need to do this? No one is forcing you
to abandon CF nor forcing you to use Flash - you can continue to sell
your "CF is cheap" position and continue building great sites,
quickly.
CF is great for that.

> But last month I
> noticed a large part of this community actively learning .NET.

I'd hope large parts of this community would be constantly learning
about technology. That's what makes everyone a better programmer.
That's why people take courses, for example.

> My underlying issue is that Macromedia is very fickle. I can't tell
you
> where they are going to be in a year. Which mean I don't know where
I,
> a
> MM developer will be in a year either.

Well, I don't think anyone can realistically argue the new site hasn't
been fully sign-posted. Anyone who is surprised by our RIA deployment
has, frankly, been living under a stone :)

And it is purely evolution. It's CF on the back end, several of the
apps are pure CF. Nothing shocking there. We have just four RIAs on
the
new site - there are five pure CF applications. People have been using
Flash UIs on CF apps for quite some time, certainly prior to the MX
launches.

Macromedia has been roundly criticized for not using our own
technology
and for being a few releases behind the leading edge. Now we're up to
date. You can't really criticize us for pushing the envelope...

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 

Announcing Macromedia DevNet Subscriptions
Maximize your power with our new premium software subscription
Find out more: http://www.macromedia.com/go/devnetsubs 



~|
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: New MM.com

[Willy Ray]

I hear you, Mike, and I'm sorry you're getting your lunch pissed on
today. 

Know this: I'm a developer for a small college using ColdFusion MX,
Flash MX, DWMX, and Homesite.  We've been a ColdFusion campus since
version 3.  I *love* your products.  I *love* your support folks.  I
would like to see Macromedia continue to do well.  I'm a loyal customer.
 

Here's how I read your .04%:

Macromedia's marketing info says the site gets a million customers a
day.

That article is here:
http://www.macromedia.com/devnet/mmwebsite/articles/devnet_experience.html

four tenths of one percent of one million (1,000,000 * .004) = 4,000
customers hitting your site per day using Opera. 

So, is this significant to you or not? Maybe it isn't.  I can see the
corporate attitude being, "The amount of customers we have, those 4k can
hang."  What do you think?  Is that the case?

Willy

>>> [EMAIL PROTECTED] 03/05/03 05:07PM >>>
.4% of users who visit our site use Opera.

Regardless, we are working with Opera to resolve the issue.

mike chambers

[EMAIL PROTECTED] 

- Original Message -
From: "Willy Ray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 11:52 AM
Subject: Re: New MM.com


> I appreciate that you guys are getting hammered here.  I should have
> thought you'd have expected it.  I also hear you getting defensive,
and
> I can really understand that, too.  I've been there.
>
> That not withstanding, what you've essentially said here is this:
> Whatever percentage the Opera market is, we're comfortable
abandoning
> them, or forcing them to launch a Microsoft product that they'd
really
> rather not.
>
> My guess is that your typical Opera user is a developer.  Is this
> really an audience you're comfortable with orphaning?  For my part,
when
> I develop a site, I'm constantly testing it in several versions of
> Explorer, Communicator and Opera.  Who QA-ed your new site, anyway?
>
> Willy
>
> >>> [EMAIL PROTECTED] 03/05/03 09:31AM >>>
> One thing to keep in mind is that while Opera may have 10% of the
> market
> (does it?), that does not mean that 10% of people who visit the
> Macromedia
> site have it. It may be a much smaller percentage.
>
> mike chambers
>
> [EMAIL PROTECTED] 
>
> - Original Message -
> From: "Bill Wheatley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 05, 2003 10:00 AM
> Subject: Re: New MM.com
>
>
> > AHHH nobody seems to have mentioned the fact the site looks like
> horses*it
> > to me ;)
> > The stupid flash just loops loading over and over.
> > I cant even see it with opera, and if they don't have a QA Dept
then
> i'm a
> > little worried.
> > If they also don't care about 10% and growing portion of the
browser
> market
> > well then that fine too i guess i wont be visiting their site
> anymore
> > unfortunately until they fix the problem.
> >
>
>
> 

~|
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: New MM.com

[Willy Ray]

A problem with Opera?  What about the flash player?  Isn't it supposed
to be a virtual machine?  Compile once, run anywhere?  What, problem
with Opera?



>>> [EMAIL PROTECTED] 03/05/03 11:22AM >>>
- Original Message -
From: "Stephen Moretti" <[EMAIL PROTECTED]>

> It also begs the question, why does it not work in Opera?  I've got
the
site
> working in IE5.5, Mozilla 1.1a and Nutscrape 4.7 crashed, but then
that
> hardly surprising given how bad it was at pretty much everything!
>

Apparently the issue with Opera actually existing on our previous site,
but
it manifests itself a little more on the new site. It is an issue with
Opera
(although I don't have the details yet), and we are working with the
Opera
team to resolve it.

mike chambers

[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
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: New MM.com

[Willy Ray]

So, the problem is with Opera. But it looks like you didn't QA with
Opera... Who's problem is that?

>>> [EMAIL PROTECTED] 03/05/03 11:22AM >>>
- Original Message -
From: "Stephen Moretti" <[EMAIL PROTECTED]>

> It also begs the question, why does it not work in Opera?  I've got
the
site
> working in IE5.5, Mozilla 1.1a and Nutscrape 4.7 crashed, but then
that
> hardly surprising given how bad it was at pretty much everything!
>

Apparently the issue with Opera actually existing on our previous site,
but
it manifests itself a little more on the new site. It is an issue with
Opera
(although I don't have the details yet), and we are working with the
Opera
team to resolve it.

mike chambers

[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
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: New Macromedia.com launched!

[Willy Ray]

Sweet, so you're saying we get to stop QA-ing our development projects
in browsers other than IE.  Excellent.  You've just saved us all quite a
bit of time! 

It doesn't matter what the market share is.  It has to work, or at
least decay properly in ANY BROWSER MM's QA can get they're hands on. 
Yes?  

Support guy: "Hey, some customers have complained they can't see the
site."
Web Developer: "Well, it works on my machine.  Tell the idiots to get a
better browser."

Great PR, guys.  

>>> [EMAIL PROTECTED] 03/05/03 10:49AM >>>
Please, stop the debate about Opera and its "10%" Opera marketshare.

I don't know where did you get those 10%.
In most browser statistics, Opera is below 1%.

Example :
"WebSideStory's figures were compiled independently based on a random
daily
sample of 20 million visitors to thousands of Web sites that use its
HitBox
visitor analysis service. According to data from Monday, 3.4 percent of
the
visitors were using a Netscape browser, 96 percent using IE and less
than
one percent were using the Opera browser from Opera Software ASA. From
day
to day the sample shows some fluctuation, but over the past several
weeks
Netscape usage hasn't been higher than 4 percent, Johnston said."

Benoit Hediard
www.benorama.com 


> -Message d'origine-
> De : Scott Wilhelm [mailto:[EMAIL PROTECTED] 
> EnvoyT : mercredi 5 mars 2003 18:21
> + : CF-Talk
> Objet : RE: New Macromedia.com launched!
>
>
> That's about the dumbest thing I've heard in the conversations
today.
>
> If 10% of the market uses Opera, it's an established browser...Why
> shouldn't a site test for it?  Especially a company such as
Macromedia.
>
> They screwed up big time.  They designed a site that looks good,
tries
> to do some fancy stuff, but falls short on the big picture, and now
> needs to work on damage control.
>
> Scott
>
> -Original Message-
> From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, March 05, 2003 12:02 PM
> To: CF-Talk
> Subject: Re: New Macromedia.com launched!
>
>
> You know that MM is not the only site that does not work well with
> Opera.
> Wells Fargo Bank's On-Line banking does not work well either. There
are
> a
> few others that do not work with Opera, so MM is not the only one
out
> there
> that is not checking for that browser. Why not apply yourself to the
QA
> department if Opera compatibility is such an issue?
> Personally I do not have any problems loading the new site in IE. I
am
> viewing it on a Dell Inspiron, 1.5 GHZ Pentium 4 processor with a
half a
> gig
> of RAM, and it is running just fine. Maybe Opera needs to get on
board
> and
> make their browser work with other companies sites?
>
>
> - Original Message -
> From: "Bill Wheatley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 05, 2003 10:43 AM
> Subject: Re: New Macromedia.com launched!
>
>
> > That is the biggest load of BS i've heard all day. Its a website!
> > Test the crap before you upload it, if you dont have a QA deptment
get
> one.
> > If you do have one fire the people because they obviously don't
know
> what
> > they are doing.
> > You can't release a site that doesn't even let you see the front
page
> with
> a
> > browser like Opera.
> >
> > I run it on IE and its slow as anything. Its like macromedia never
> stops
> to
> > think before it releases things lol.
> >
> > Hopefully they fix the opera thing quickly. I mean its only a
browser
> with
> > 10%, and growing, of the market.
> >
> >
> >
> >
> > - Original Message -
> > From: "Christian Cantrell" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 05, 2003 11:12 AM
> > Subject: Re: New Macromedia.com launched!
> >
> >
> > The new macromedia.com is certainly a "next generation" site, and
> > unfortunately, there are going to be issues like the ones you
mention
> > below.  I hope people can take the time to let us know when they
find
> > things like this by going to the following URL:
> >
> > http://www.macromedia.com/macromedia/mm_feedback.html 
> >
> > I remember when I first used OS X (also a complete re-write and
"next
> > generation" project) it was VERY rough at first, and had issue
ranging
> > from performance to compatibility.  Over time, however, it has
really
> > been refined into an excellent and extremely advanced OS.  To some
> > extent, these types of issues are the price you pay when you take
big
> > steps forward.  Someone has to be pushing the envelope, though,
and
> I'm
> > glad it's Macromedia.
> >
> > Christian
> >
> > On Wednesday, March 5, 2003, at 10:50 AM, Jillian Carroll wrote:
> >
> > > I'm surprised MM would launch this site given:
> > >
> > > - Jakob Neilson (and other usability professionals) are going to
> > > be watching
> > > - They are trying to 'sell sell sell' the idea that Flash has
> > > matured and is now faster, friendlier, etc.
> > >
> > > For my own interest, I checked out the site in several browsers:
> > >
> > > - NS 6.2.3 

RE: New Macromedia.com launched!

[Willy Ray]

Yeah, but Google News works...  Sorry.

>>> [EMAIL PROTECTED] 03/05/03 09:40AM >>>
> If it's a beta version, why is it public then?

Sometimes when you are trying to experiment new things, you don't have
any
choices than to experiment "live".

Look at Google News (http://news.google.com/), it has been launch to
the
public several months ago (nearly a year) and it is still Google News
"Beta".

Benoit Hediard
www.benorama.com 

> -Message d'origine-
> De : Scott Wilhelm [mailto:[EMAIL PROTECTED] 
> EnvoyT : mercredi 5 mars 2003 17:21
> + : CF-Talk
> Objet : RE: New Macromedia.com launched!
>
>
> If it's a beta version, why is it public then?
>
> I mean, I wouldn't think that it's a good practice to put your
beta's
> directly out to the public.
>
> Just my 2 cents.
>
> Scott
>
> -Original Message-
> From: Benoit Hediard [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, March 05, 2003 11:00 AM
> To: CF-Talk
> Subject: RE: New Macromedia.com launched!
>
>
> Come on guys... it is a Beta version.
> Is there only "never happy" people on this list?
>
> > Marcromedia needs to stop it with all their flash everywhere...
> > it's bad design, slow and confusing in many regards...
>
> I disagree about the "bad design" and "confusing things" arguments
(...
> agree about the "slow" one).
> The organisation of the site seems to be much clear than the
previous
> one.
>
> The home page is not intended to ColdFusion Developers... but any
kind
> of
> audience, that's why it requires a "flashy" brand/corporate
look&feel.
> If you don't like it, just go directly to
> http://www.macromedia.com/devnet/mx/coldfusion/, you don't have to
go
> through it.
> (there was already a big marketing flash movie in the previous home
> page)
>
> > They keep changing the groupings of things as well ... quite a
> > pain this morning to find the Exchanges... had to use the site
map
>
> Not very hard...
> Select "Product > ColdFusion MX" on the home page, and then you'll
get a
> direct access to the exchange.
> (and it will remember this setting)
>
> > That corner loading/initiaing thing is annoying and doesn't make
> > me feel the site is any more responsive...
> >
> > Hopefully they revise this...
> >
> > Oh and the Exchange by default shows some goofy collection of
> > files initially... you have to go to a right side of screen block
> > to select show newest...  a change from how it historically has
> worked...
>
> Once you have selected "Newest", it will also remember this settings
for
> your next visit (no changes to your historical habits).
>
> Come on guys, move forward...
>
>
> Benoit Hediard
> www.benorama.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: New MM.com

[Willy Ray]

I appreciate that you guys are getting hammered here.  I should have
thought you'd have expected it.  I also hear you getting defensive, and
I can really understand that, too.  I've been there.  

That not withstanding, what you've essentially said here is this: 
Whatever percentage the Opera market is, we're comfortable abandoning
them, or forcing them to launch a Microsoft product that they'd really
rather not.  

My guess is that your typical Opera user is a developer.  Is this
really an audience you're comfortable with orphaning?  For my part, when
I develop a site, I'm constantly testing it in several versions of
Explorer, Communicator and Opera.  Who QA-ed your new site, anyway?

Willy

>>> [EMAIL PROTECTED] 03/05/03 09:31AM >>>
One thing to keep in mind is that while Opera may have 10% of the
market
(does it?), that does not mean that 10% of people who visit the
Macromedia
site have it. It may be a much smaller percentage.

mike chambers

[EMAIL PROTECTED] 

- Original Message -
From: "Bill Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 10:00 AM
Subject: Re: New MM.com


> AHHH nobody seems to have mentioned the fact the site looks like
horses*it
> to me ;)
> The stupid flash just loops loading over and over.
> I cant even see it with opera, and if they don't have a QA Dept then
i'm a
> little worried.
> If they also don't care about 10% and growing portion of the browser
market
> well then that fine too i guess i wont be visiting their site
anymore
> unfortunately until they fix the problem.
>


~|
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: New Macromedia.com launched!

[Willy Ray]

Well, yeah, but shouldn't it decay properly, and let me know I don't
have the latest plugin?  Instead, I get a blank page.  I'd get fired for
deploying a page that didn't properly detect my plugin version.  I
develop in ColdFusion *and Flash*!  My plugin is pretty current.

Willy

>>> [EMAIL PROTECTED] 03/05/03 08:57AM >>>
I suspect the browsers which are failing such as Netscape is due to the
fact
the Flash Player is out of date (I think we are up to 6,0,79,0  or
something?!)

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: 05 March 2003 15:50
To: CF-Talk
Subject: RE: New Macromedia.com launched!


I'm surprised MM would launch this site given:

-   Jakob Neilson (and other usability professionals) are going to
be watching
-   They are trying to 'sell sell sell' the idea that Flash has
matured and is now faster, friendlier, etc.

For my own interest, I checked out the site in several browsers:

-   NS 6.2.3 and 7.1 (seems to work nearly as I imagine is
intended)
-   NS 4.79 (very little of the site can be seen)
-   NS 4.78 (much like 4.79, very little can be seen, and the links
that are visible, aren't functional)

-   Mozilla 1.1 (depricates nicely w/o Flash in this browser)

-   IE 6 (the links in the main 'top' bar don't work properly)

It's unfortunate.

--
Jillian

> -Original Message-
> From: Robertson-Ravo, Neil (RX) 
> [mailto:[EMAIL PROTECTED] 
> Sent: March 5, 2003 9:21 AM
> To: CF-Talk
> Subject: RE: New Macromedia.com launched!
> 
> 
> I can't say I am too happy with the new site (it was nice to 
> look at first off and in all honesty: It seems a gimmick), 
> but I cant see how you could have failed to find the 
> exchanges : www.macromedia.com/exchange 
> 
> -Original Message-
> From: paris lundis [mailto:[EMAIL PROTECTED] 
> Sent: 05 March 2003 15:11
> To: CF-Talk
> Subject: RE: New Macromedia.com launched!
> 
> 
> Marcromedia needs to stop it with all their flash 
> everywhere... it's bad design, slow and confusing in many regards...
> 
> They keep changing the groupings of things as well ... quite 
> a pain this morning to find the Exchanges... had to use the 
> site map  
> 
> That corner loading/initiaing thing is annoying and doesn't 
> make me feel the site is any more responsive...
> 
> Hopefully they revise this...
> 
> Oh and the Exchange by default shows some goofy collection of 
> files initially... you have to go to a right side of screen 
> block to select show newest...  a change from how it 
> historically has worked...
> 
> But hey it's pretty. (Isn't that all that matters) :)
> 
> -p
> 
> -- Original Message --
> From: "Robertson-Ravo, Neil (RX)" 
> <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED] 
> Date:  Wed, 5 Mar 2003 11:06:59 - 
> 
> >I like the new design, but it still suffers from the old back
button
> problem
> >which is a real usability issue; I preferred the old site : much 
> >cleaner.
> >
> >-Original Message-
> >From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
> >Sent: 05 March 2003 10:59
> >To: CF-Talk
> >Subject: RE: New Macromedia.com launched!
> >
> >
> >Pity the top toolbar on the home page doesn't work how it's 
> supposed to
> >:)
> >
> >Other than that, looks great. I wouldn't like to load it 
> over a modem 
> >though!
> >
> >-Original Message-
> >From: Oliver Cookson [mailto:[EMAIL PROTECTED] 
> >Sent: 05 March 2003 09:45
> >To: CF-Talk
> >Subject: New Macromedia.com launched!
> >
> >Maybe there has already been a post, if not there is now! :)
> >
> >The new Macromedia.com has been launched and its looks 
> excellent (if a
> >little slow in places).
> >
> >Well done MM.
> >
> >
> >
> >
> 
> 


~|
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: New MM.com

[Willy Ray]

Yeah, not to add fuel to the fire, but I can't see it at all in Opera 7.
 

>>> [EMAIL PROTECTED] 03/05/03 08:00AM >>>
AHHH nobody seems to have mentioned the fact the site looks like
horses*it
to me ;)
The stupid flash just loops loading over and over.
I cant even see it with opera, and if they don't have a QA Dept then
i'm a
little worried.
If they also don't care about 10% and growing portion of the browser
market
well then that fine too i guess i wont be visiting their site anymore
unfortunately until they fix the problem.



--
Bill Wheatley
Senior Database Developer
Macromedia Advanced Coldfusion 5 Developer
Ediets.com
ICQ - 417645
Aim - Bill Ediets
954-360-9022 x159


- Original Message -
From: "Benoit Hediard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 9:46 AM
Subject: RE: New MM.com


Congratulations to Sean and all the team.
The new site is great.

I like very much the new design and the way the site and the
information are
organized.

One little simple detail that I enjoy, it remembers your latest
selection in
the home page.
For example, if you have choosen "Products > ColdFusion MX" and
"Solutions >
Developers", the next time you come, the home page will have them
already
selected (I suppose this is based on new Shared Objects capabilities).
Very simple but efficient personalization...

Ok, it is a little bit slow on my PIII 500... but I'm sure it will get
better.

As for the back/forward buttons in Flash, it seems to be pretty well
handled
by the 4 RIAs (home, exchange, membership and download).

For the moment, it seems to be stable... I haven't seen any error
pages...
ColdFusionMX+FlashMX unleashed upon the masses!

Bravo!

Benoit Hediard
www.benorama.com 

> -Message d'origine-
> De : Jochem van Dieten [mailto:[EMAIL PROTECTED] 
> EnvoyT : mercredi 5 mars 2003 14:02
> + : CF-Talk
> Objet : Re: New MM.com
>
>
> Paul Hastings wrote:
> > i come from a rather bandwidth poor part of the world & was
prepared for
> > p*ss-poor performance. i was surprised at how well bandwidth
> was used, even
> > the slower portions didn't seem that slow.
>
> Overall, I find the site rather slow when using the Flash version. I
> don't know if there is some traffic shaping that allows only a
limited
> number of connections/limited speed or if Flash gets all the
components
> sequentially or something, but there are very few sites that take 4
> seconds to load (yes, I am spoiled). CPU and the connection never
max
> out on my end.
> As a result, I switched to the HTML version.
>
> 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
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: Form.Fieldnames and MX

[Willy Ray]

Hate to ask this one:  You're not invoking the action page directly
without hitting submit off the form page, are you?  (*cringe*).

>>> [EMAIL PROTECTED] 02/13/03 08:40AM >>>
Yes, method="post"

Cutter

Willy Ray wrote:

>You sure your method attribute is set to 'POST'? 
>
>  
>
>>>>[EMAIL PROTECTED] 02/13/03 08:26AM >>>
>>>>
>>>>
>Though Form is selected for Display, nothing for Form is coming up on

>the action page in the debugging info. (Maybe because no data is
being
>
>passed?)
>
>Cutter
>
>Andy Ousterhout wrote:
>
>  
>
>>Turn on Display Variables in CF Admin and see what is getting
>>
>>
>passed
>  
>
>>-Original Message-
>>From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] 
>>Sent: Thursday, February 13, 2003 8:29 AM
>>To: CF-Talk
>>Subject: Form.Fieldnames and MX
>>
>>
>>Ok, what happened? I used to be able to loop through form.fieldnames
>>
>>
>to
>  
>
>>create a list of all of the fields and then I could write my
>>
>>
>processor
>  
>
>>script. CFMX, on the other hand, gives me the following:
>>
>>Element FIELDNAMES is undefined in FORM.
>>
>>Anybody have any ideas?
>>
>>Cutter
>>
>>
>>
>>
>>
>
>

~|
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: Form.Fieldnames and MX

[Willy Ray]

You sure your method attribute is set to 'POST'? 

>>> [EMAIL PROTECTED] 02/13/03 08:26AM >>>
Though Form is selected for Display, nothing for Form is coming up on 
the action page in the debugging info. (Maybe because no data is being

passed?)

Cutter

Andy Ousterhout wrote:

>Turn on Display Variables in CF Admin and see what is getting
passed
>
>-Original Message-
>From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] 
>Sent: Thursday, February 13, 2003 8:29 AM
>To: CF-Talk
>Subject: Form.Fieldnames and MX
>
>
>Ok, what happened? I used to be able to loop through form.fieldnames
to
>create a list of all of the fields and then I could write my
processor
>script. CFMX, on the other hand, gives me the following:
>
>Element FIELDNAMES is undefined in FORM.
>
>Anybody have any ideas?
>
>Cutter
>
>
>

~|
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: CFC vs. Customtag Surprise: Recursion

[Willy Ray]

Ok, that's good, but here's a thought:  My function was essentially done
before it called the recursion.  Calling itself was essentially the last
thing it had to do before it waited for flow to return to it from all
it's children, and close itself.  Seems to me like it shouldn't have
caused me this problem if I was overwriting variables that were no
lonber being used...

Your thoughts?

>>> [EMAIL PROTECTED] 02/12/03 02:41PM >>>
Exactly. Same applies to UDFs as well. Simply declare your variables.
Example:






===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc

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

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

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, February 12, 2003 3:26 PM
> To: CF-Talk
> Subject: RE: CFC vs. Customtag Surprise: Recursion
> 
> 
> Oh really?  So any variables that I set within the function 
> were being overwritten at every iteration by the next 
> instance of the function?
> 
> >>> [EMAIL PROTECTED] 02/12/03 10:15AM >>>
> I bet you forgot to var scope your variables in the CFC. 
> Custom tags variables are protected by default - values in a 
> CFC method must be protected explicitely(sp) using the var 
> scope declaration.
> 
> ==
> =
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> 
> Email: [EMAIL PROTECTED] 
> WWW  : www.camdenfamily.com/morpheus 
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -Original Message-
> > From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> > Sent: Wednesday, February 12, 2003 11:03 AM
> > To: CF-Talk
> > Subject: CFC vs. Customtag Surprise: Recursion
> > 
> > 
> > Ok,
> > 
> > my database table for storing my content is a big tree, set
> > up like this id - label - parentid 1   'myweb' 
> >  0 2 -- 'links' ---1 3 - 'portfolio' ---1 4 
> > - 'firstlink'  2
> > 
> > Make sense?  Every row has it's own Id, and the ID of its
> > parent, and from this I get a big branching tree structure to 
> > hold the data.  I'm presented with this problem where I have 
> > to take a branch of the tree and make an exact copy of it 
> > within the database.  The relationships have to be all the 
> > same, but all new ids. A copy of the 'myweb' node from the 
> > example above looks like this:
> > 
> > id - label - parentid
> > 1   'myweb'  0
> > 2 -- 'links' ---1
> > 3 - 'portfolio' ---1
> > 4 - 'firstlink'  2
> > 5   'myweb'  0
> > 6 -- 'links' ---5
> > 7 - 'portfolio' ---5
> > 8 - 'firstlink'  6
> > 
> >  I'm thinking, excellent opportunity to go nuts with CFCs,
> > and write some recursion, right?  Wrong.  Here's what 
> > happened (pseudo-code):
> > 
> > 1.Create a function named replicate:
> > 
> > 2.Takes two arguments:  NodeToDuplicate, and ParentOfNewNode.
> > 
> > 3.Selects everything from the table where id = nodeToDuplicate
> > 
> > 4.Inserts the data from previous query with parentid =
> > arguments.ParentOfNewNode (this re-creates the node, with a 
> > parent that
> > *I've* specified when I invoke the function)
> > 
> > 5.Selects the MAX(id) from the table WHERE label =
> > 'thelabelIGotFromTheFirstQuery', sets that to NewNodeId
> > 
> > 6.Selects all the ids WHERE parentid = NodeToDuplicate (this
> > gets all children of the current node) call it qGetChildren
> > 
> > 7.Loop over qGetChildren
> >  Re-invoke the replicate function from within itself for
> > every child of the current node.
> >  NodeToDuplicate = qGetChildren.id
> >  ParentOfNewNode = NewNodeId (the id of the newly 
> > replicated node in step 4)
> >  /loop
> > 
> > Ok.  let that soak in.  Should work, right?  Right.  I
> > thought so too. 
> > It fails hard.  Gets off-track fast.  I go through the logs 
> > of what it did (after I reboot the web AND database server) 
> > and it's getting down to the first node that has no 
> > children... Then looping 

RE: CFC vs. Customtag Surprise: Recursion

[Willy Ray]

Oh really?  So any variables that I set within the function were being
overwritten at every iteration by the next instance of the function?

>>> [EMAIL PROTECTED] 02/12/03 10:15AM >>>
I bet you forgot to var scope your variables in the CFC. Custom tags
variables are protected by default - values in a CFC method must be
protected explicitely(sp) using the var scope declaration.

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc

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

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

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, February 12, 2003 11:03 AM
> To: CF-Talk
> Subject: CFC vs. Customtag Surprise: Recursion
> 
> 
> Ok, 
> 
> my database table for storing my content is a big tree, set 
> up like this id - label - parentid 1   'myweb' 
>  0 2 -- 'links' ---1 3 - 'portfolio' ---1 4 
> - 'firstlink'  2
> 
> Make sense?  Every row has it's own Id, and the ID of its 
> parent, and from this I get a big branching tree structure to 
> hold the data.  I'm presented with this problem where I have 
> to take a branch of the tree and make an exact copy of it 
> within the database.  The relationships have to be all the 
> same, but all new ids. A copy of the 'myweb' node from the 
> example above looks like this:
> 
> id - label - parentid
> 1   'myweb'  0
> 2 -- 'links' ---1
> 3 - 'portfolio' ---1
> 4 - 'firstlink'  2
> 5   'myweb'  0
> 6 -- 'links' ---5
> 7 - 'portfolio' ---5
> 8 - 'firstlink'  6
> 
>  I'm thinking, excellent opportunity to go nuts with CFCs, 
> and write some recursion, right?  Wrong.  Here's what 
> happened (pseudo-code):
> 
> 1.Create a function named replicate:
> 
> 2.Takes two arguments:  NodeToDuplicate, and ParentOfNewNode.
> 
> 3.Selects everything from the table where id = nodeToDuplicate
> 
> 4.Inserts the data from previous query with parentid = 
> arguments.ParentOfNewNode (this re-creates the node, with a 
> parent that
> *I've* specified when I invoke the function)
> 
> 5.Selects the MAX(id) from the table WHERE label = 
> 'thelabelIGotFromTheFirstQuery', sets that to NewNodeId
> 
> 6.Selects all the ids WHERE parentid = NodeToDuplicate (this 
> gets all children of the current node) call it qGetChildren
> 
> 7.Loop over qGetChildren
>  Re-invoke the replicate function from within itself for 
> every child of the current node.
>  NodeToDuplicate = qGetChildren.id
>  ParentOfNewNode = NewNodeId (the id of the newly 
> replicated node in step 4)
>  /loop
> 
> Ok.  let that soak in.  Should work, right?  Right.  I 
> thought so too. 
> It fails hard.  Gets off-track fast.  I go through the logs 
> of what it did (after I reboot the web AND database server) 
> and it's getting down to the first node that has no 
> children... Then looping back to the top of the whole 
> structure, and looping trying to duplicate nodes that have no 
> relationship to the node I'm trying to duplicate, then it 
> gets into a loop where it's running down the left-hand side 
> of the tree from top to bottom over and over until the 
> house-of-cards comes crashing down, and I've killed the server.  
> 
> I'm thinking, 'It's in the logic.  My recursion is bad'.  
> Spend about a week on the above 7 points.  On a whim, 
> re-encapsulate THE EXACT SAME LOGIC as above into a Custom 
> Tag.  Works like a freakin' charm.  
> 
> So, what's the difference?  The CFCs are creating multiple 
> threads, and getting out of sync with the database returns?  
> Trying to process the next iteration before it's gotten the 
> return from the database, whereas the custom tag is running 
> more procedurally?  Or what? 
> 
> Any thoughts?  I'm happy to supply the actual code to anybody 
> who's interested.
> 
> Willy
> 
> 
> 
> 
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College 
> 

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

CFC vs. Customtag Surprise: Recursion

[Willy Ray]

Ok, 

my database table for storing my content is a big tree, set up like
this
id - label - parentid
1   'myweb'  0
2 -- 'links' ---1
3 - 'portfolio' ---1
4 - 'firstlink'  2

Make sense?  Every row has it's own Id, and the ID of its parent, and
from this I get a big branching tree structure to hold the data.  I'm
presented with this problem where I have to take a branch of the tree
and make an exact copy of it within the database.  The relationships
have to be all the same, but all new ids. A copy of the 'myweb' node
from the example above looks like this:

id - label - parentid
1   'myweb'  0
2 -- 'links' ---1
3 - 'portfolio' ---1
4 - 'firstlink'  2
5   'myweb'  0
6 -- 'links' ---5
7 - 'portfolio' ---5
8 - 'firstlink'  6

 I'm thinking, excellent opportunity to go nuts with CFCs, and write
some recursion, right?  Wrong.  Here's what happened (pseudo-code):

1.Create a function named replicate:

2.Takes two arguments:  NodeToDuplicate, and ParentOfNewNode.

3.Selects everything from the table where id = nodeToDuplicate

4.Inserts the data from previous query with parentid =
arguments.ParentOfNewNode (this re-creates the node, with a parent that
*I've* specified when I invoke the function)

5.Selects the MAX(id) from the table WHERE label =
'thelabelIGotFromTheFirstQuery', sets that to NewNodeId

6.Selects all the ids WHERE parentid = NodeToDuplicate (this gets all
children of the current node) call it qGetChildren

7.Loop over qGetChildren
 Re-invoke the replicate function from within itself for every
child of the current node.
 NodeToDuplicate = qGetChildren.id
 ParentOfNewNode = NewNodeId (the id of the newly replicated node
in step 4)
 /loop

Ok.  let that soak in.  Should work, right?  Right.  I thought so too. 
It fails hard.  Gets off-track fast.  I go through the logs of what it
did (after I reboot the web AND database server) and it's getting down
to the first node that has no children... Then looping back to the top
of the whole structure, and looping trying to duplicate nodes that have
no relationship to the node I'm trying to duplicate, then it gets into a
loop where it's running down the left-hand side of the tree from top to
bottom over and over until the house-of-cards comes crashing down, and
I've killed the server.  

I'm thinking, 'It's in the logic.  My recursion is bad'.  Spend about a
week on the above 7 points.  On a whim, re-encapsulate THE EXACT SAME
LOGIC as above into a Custom Tag.  Works like a freakin' charm.  

So, what's the difference?  The CFCs are creating multiple threads, and
getting out of sync with the database returns?  Trying to process the
next iteration before it's gotten the return from the database, whereas
the custom tag is running more procedurally?  Or what? 

Any thoughts?  I'm happy to supply the actual code to anybody who's
interested.

Willy





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
~|
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

Obscure Dateformat Question

[Willy Ray]

Ok, This is true: dateformat("1092117600") = 04-Jun-16

What I need to do is take 04-Jun-16 and turn it into 1092117600.  I can
go one direction, but I'm not sure how to go back... Some special mask
for Dateformat that I don't know, or what?  If I could get the
algorythm, I'd make a UDF for it...

Thanks in advance,

Willy





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
~|
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

Highly Flammable Topic? BlueDragon, anyone?

[Willy Ray]

Is anybody using BlueDragon to process their CFML?  Took me about an
afternoon to get it configged and running my CF applications with
datasources and everything, without a macromedia product on the server! 
Seems pretty good.  How's stability?  Anybody have any experience with
this?  What platforms?  How's it working?

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

RE: Query Trouble

[Willy Ray]

Love this list!  Thanks.  That's the ticket.

>>> [EMAIL PROTECTED] 12/04/02 04:01PM >>>
You need to do a left outer join - 


 SELECT vendors.vendorid,
vendors.vendor_name,products.product_name
 FROM vendors LEFT OUTER JOIN products ON vendors.id =
products.vendorid
 ORDER BY vendorid


Give that a shot.

Adam.



> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, December 04, 2002 4:50 PM
> To: CF-Talk
> Subject: SOT: Query Trouble
> 
> 
> Ok, say I have a table of vendors and a table of products, 
> and I want to
> list out all the vendors and their products:
> 
> 
>  SELECT vendors.vendor_name,products.product_name
>  FROM vendors, products
>  WHERE vendors.id = products.vendorid
>  ORDER BY vendorid
> 
> 
> 
> Then:
> 
> 
> 
>  #qGetData.vendor_name#:
>  
>   #qGetData.product_name#,
>  
>  
> 
> 
> 
> This gives me a good list of all my vendors, with a somewhat sloppy
> comma delimited list of their products after.  But what if I have
> vendors who don't currently have products in the product table, and
I
> want to list them anyway?  It's like a, where-are-the-vendors and
BTW,
> here-are-their-products kind of deal.
> 
> Another way to put it.  I have three vendors and the second one has
no
> products, I need my list to look like this:
> 
> Vendor A: mouse traps, cat food,
> Vendor B: 
> Vendor C: applesauce, condensed milk,
> 
> But the above query doesn't do that.  Any help?
> 
> Willy
> 
> 
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

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

SOT: Query Trouble

[Willy Ray]

Ok, say I have a table of vendors and a table of products, and I want to
list out all the vendors and their products:


 SELECT vendors.vendor_name,products.product_name
 FROM vendors, products
 WHERE vendors.id = products.vendorid
 ORDER BY vendorid



Then:



 #qGetData.vendor_name#:
 
  #qGetData.product_name#,
 
 



This gives me a good list of all my vendors, with a somewhat sloppy
comma delimited list of their products after.  But what if I have
vendors who don't currently have products in the product table, and I
want to list them anyway?  It's like a, where-are-the-vendors and BTW,
here-are-their-products kind of deal.

Another way to put it.  I have three vendors and the second one has no
products, I need my list to look like this:

Vendor A: mouse traps, cat food,
Vendor B: 
Vendor C: applesauce, condensed milk,

But the above query doesn't do that.  Any help?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
~|
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

RE: CF administrator MX System probes

[Willy Ray]

Ah ha... Ok, then.  Thanks!

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 11/21/02 12:20PM >>>
The probes are definitely an Enterprise feature.

Deb

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF administrator MX System probes


Could be Enterprise version only? Not sure...


-Original Message-----
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 2:02 PM
To: CF-Talk
Subject: RE: CF administrator MX System probes

Yeah.  I'm looking in the book, and I see "System Probes" listed under
Debugging and Logging.  But I don't have it in mine.  

Debugging & Logging 
Debugging Settings
Debugging IP Addresses
Logging Settings
Scheduled Tasks
Code Analyzer

I must have not installed something...



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 11/21/02 11:57AM >>>
I believe that was true in CF5, in MX It's "System Probes"  :-)

Stace

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 12:37 PM
To: CF-Talk
Subject: SOT: CF administrator MX System probes

Ok, The Forta book says "Click on system probes under the tools menu."

I can't find a "Tools" menu in cfadmin.  Did I fail to install
something?  What's my boggle, here?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College





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

RE: CF administrator MX System probes

[Willy Ray]

Yeah.  I'm looking in the book, and I see "System Probes" listed under
Debugging and Logging.  But I don't have it in mine.  

Debugging & Logging 
Debugging Settings
Debugging IP Addresses
Logging Settings
Scheduled Tasks
Code Analyzer

I must have not installed something...



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 11/21/02 11:57AM >>>
I believe that was true in CF5, in MX It's "System Probes"  :-)

Stace

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 12:37 PM
To: CF-Talk
Subject: SOT: CF administrator MX System probes

Ok, The Forta book says "Click on system probes under the tools menu."

I can't find a "Tools" menu in cfadmin.  Did I fail to install
something?  What's my boggle, here?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College


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

SOT: CF administrator MX System probes

[Willy Ray]

Ok, The Forta book says "Click on system probes under the tools menu." 
I can't find a "Tools" menu in cfadmin.  Did I fail to install
something?  What's my boggle, here?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
~|
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

Re: WDDX and large recordsets

[Willy Ray]

How large?

>>> [EMAIL PROTECTED] 11/19/02 04:34PM >>>
Can anyone share there experience using WDDX and large record sets? Any

caveats?

Brook



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

RE: RegEx

[Willy Ray]

CF-RegEx list!  Woo-hoo!  I didn't even know there was such a thing!  I'm all over it. 

Thanks!





-----
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 10/10/02 12:03PM >>>
: /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01
:   
:
: And this:
:
:   

I'm assuming you're using CFMX, or the style you're trying to employ won't
work.

IIRC, in CFMX, you almost had it with the first refind, but you need to use
backslashes instead of forward slashes.  You could also do this:

size = rereplace(mystring, ".*(\d+x\d+).*", "\1")

If you are using CF5, you need to do something like

start = refind("[0-9]+x[0-9]+", mystring)
or
size = rereplace(mystring, ".*([0-9]+x[0-9]+).*", "\1")

HTH.

As always, a plug for the CF-RexEx list.  If you like to use them, are
interested about learning more about them, or just want to know what the
heck all this "regular expression" junk is, check out the archives, post, or
join at:
http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21 



  --Ben Doom
Programmer & General Lackey
Moonbow Software


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

Solved: RE: SOT: RegEx

[Willy Ray]

Linux.  No spaces (at least, not on *this* server, baby).  Plus, I really wanted to 
use Regular Expressions (my inner masochist) Anyway, I figured it out.  I was using 
this:



and needed to be using this:



I was using wrong slashes, and the +'s were in the wrong place, relative to the 
brackets.

Thanks for the help!






-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 10/10/02 10:15AM >>>
I thought of that too, but what if there's a space in the file path?

> -Original Message-
> From: Patric Stumpe [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, October 10, 2002 12:04 PM
> To: CF-Talk
> Subject: Re: SOT: RegEx
> 
> 
> Hi Willy,
> 
> if it's always the same structure you could get use
> ListGet(myString, 3, ' ') With space as delimiter.
> 
> Just a thought...
> 
> Patric
> 
> 
> WR> Ok, I have a string that looks like this:
> 
> WR> /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 
> 95kb 0.3u 0:01
> 
> WR> It's an imagemagic identification of a file that my user 
> is uploading.  myfile.jpg is CFFILE.clientfile.
> 
> WR> I need to go through this thing and get the 1280x1024 
> out.  I could come up with a way to do this w/o regular 
> expressions, but it wouldn't be as flexible as I'd like it to be.
> 
> WR> I've tried this:
> 
> 
> WR> 
> 
> WR> And this:
> 
> WR> 
> 
> WR> Doesn't seem to work.  Any ideas?
> 
> 
> 
> 
> 
> WR> -
> WR> Willy Ray
> WR> Web Applications Developer
> WR> Certified Advanced ColdFusion Developer
> WR> Westminster College
> 
> WR> 
> 

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

SOT: RegEx

[Willy Ray]

Ok, I have a string that looks like this:

/web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01

It's an imagemagic identification of a file that my user is uploading.  myfile.jpg is 
CFFILE.clientfile.

I need to go through this thing and get the 1280x1024 out.  I could come up with a way 
to do this w/o regular expressions, but it wouldn't be as flexible as I'd like it to 
be.

I've tried this:




And this:



Doesn't seem to work.  Any ideas?





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

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

Solved: RE: CF encrypt() and SQL

[Willy Ray]

Hey thanks.  That seems to have worked.


this is the best list-serv ever!




-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 09/10/02 11:38AM >>>
Have you tried using CFQUERYPARAM?


UPDATE mytable
SET myvalue= 
WHERE id = 


> -Original Message-----
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, September 10, 2002 1:26 PM
> To: CF-Talk
> Subject: CF encrypt() and SQL
> 
> 
> Ok here's what's going on:
> 
> I'm using the encrypt() function to encrypt data as it goes into my
> database.
> 
> Like this:
> 
> 
> UPDATE mytable
> SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#'
> WHERE id = #FORM.id"
> 
> 
> Some of you probably already know what my problem is.  Sometimes
this
> works fine.  Other times the encrypted values have characters in
them
> that (like single-quote) that break my query.  Anybody been through
> this?  Solutions?
> 
> Thanks in advance
> 
> Willy
> 
> 
> 
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF encrypt() and SQL

[Willy Ray]

Does that work the same for inserts?

insert into mytable(myvalue)
values()

?

Thanks again.

Willy



>>> [EMAIL PROTECTED] 09/10/02 11:38AM >>>
Have you tried using CFQUERYPARAM?


UPDATE mytable
SET myvalue= 
WHERE id = 


> -Original Message-----
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, September 10, 2002 1:26 PM
> To: CF-Talk
> Subject: CF encrypt() and SQL
> 
> 
> Ok here's what's going on:
> 
> I'm using the encrypt() function to encrypt data as it goes into my
> database.
> 
> Like this:
> 
> 
> UPDATE mytable
> SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#'
> WHERE id = #FORM.id"
> 
> 
> Some of you probably already know what my problem is.  Sometimes
this
> works fine.  Other times the encrypted values have characters in
them
> that (like single-quote) that break my query.  Anybody been through
> this?  Solutions?
> 
> Thanks in advance
> 
> Willy
> 
> 
> 
> 
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF encrypt() and SQL

[Willy Ray]

I'm on MySQL.  I'm not sure I can do that... Can I?

Willy

>>> [EMAIL PROTECTED] 09/10/02 11:34AM >>>
 did you try with cfstoredproc and cfprocparam ???

Gerald

-Original Message-
From: Willy Ray
To: CF-Talk
Sent: 10/09/02 19:26
Subject: CF encrypt() and SQL

Ok here's what's going on:

I'm using the encrypt() function to encrypt data as it goes into my
database.

Like this:


UPDATE mytable
SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#'
WHERE id = #FORM.id"


Some of you probably already know what my problem is.  Sometimes this
works fine.  Other times the encrypted values have characters in them
that (like single-quote) that break my query.  Anybody been through
this?  Solutions?

Thanks in advance

Willy




-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF encrypt() and SQL

[Willy Ray]

Ok here's what's going on:

I'm using the encrypt() function to encrypt data as it goes into my
database.

Like this:


UPDATE mytable
SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#'
WHERE id = #FORM.id"


Some of you probably already know what my problem is.  Sometimes this
works fine.  Other times the encrypted values have characters in them
that (like single-quote) that break my query.  Anybody been through
this?  Solutions?

Thanks in advance

Willy




-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Best way to resend undelvr

[Willy Ray]

Gnarly.  So, I could just make a scheduled task to a little cffile
functionality to do this automagically, eh?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 07/15/02 10:36AM >>>
What OS?

On Solaris you would cd to /usr/coldfusion/mail/undelivr.  Then you
would mv
* ../spool.

You would want to check and see if they have any bad data first, so
cat
*|more them and check for to and from addresses.

On windows it should be a simple copy and paste job.

Tim Heald
ACP/CCFD :)

Application Development
http://www.schoollink.net 

Fusebox Advisory Committee Member
http://www.fusebox.org 

Manager Fayetteville ColdFusion User Group
http://www.fcfug.org 


> -Original Message-----
> From: Willy Ray [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, July 15, 2002 12:31 PM
> To: CF-Talk
> Subject: Best way to resend undelvr
>
>
> What's the best way to check my undeliverable mail folder and the
> automatically RESEND the mail?
>
> Willy Ray
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Best way to resend undelvr

[Willy Ray]

What's the best way to check my undeliverable mail folder and the
automatically RESEND the mail?

Willy Ray




-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Flashin my CF!!!!

[Willy Ray]

Hey Critter.

Are you using FlashMX?  CFMX?  If so definately use the remoting.  Over
the last two days I've made a chat client and an email client, in *my
spare time*.

Others may disagree with this but:

The trick to laying out tabular data is the flash function
duplicateMovieClip().  Essentially, what you're going to do is create a
blank movie clip, with dynamic text fields in it, spaced how you want
them, then loop through your recordset and duplicate a movie clip with a
dynamic name (based on the index of your loop) and passing in the
variables from the recordset as you go.  You'll then set the _y value of
the new clip and reiterate the loop.  Make any sense?  You can do all
sorts of stuff this way; you can pass in urls to link to, all sorts of
stuff.  Alternatively, you can make one big text field that's HTML
enabled, and use string parsing to lay things out.  Up to you.

Feel free to mail me if you want more specifics.

Other Business (at the risk of incuring flame):

Now, as for 'read the cf maual' [sic].  A) you've obviously
mis-understood the question.  B) Don't you think that, as a response to
a (seemingly) newbie question, RTFM is a sentiment more fitting of the
ASP community?  Come on now.  The ColdFusion development community
shouldn't be eating it's young, here.  We're smarter than that.

Willy Ray
Certified Advanced ColdFusion Developer



>>> [EMAIL PROTECTED] 06/20/02 07:40AM >>>
read the cf maual.


On Thu, 20 Jun 2002, Critz wrote:

> Good mornin CF(Mx)'ers
>
>  as I begin my journey down the path of a Rich Internet Application,
I
>  have come upon a small obstacle.
>
>  Displaying the results of a recordset in a "html table" type
>  format...
>
>  anybody have any suggestions???
>
>
> --
> Best regards,
>
> Critter, MMCP
> Certified ColdFusion Developer
>
> Crit[s2k] - 
>
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

More: CFMX Upgrade Woes: CFLDAP

[Willy Ray]

Alright, here's another one.  This one seems a little more real.

Anybody using CFLDAP on MX?  We use it to authenticate against our
Novell Network.  It seems like it doesn't like the DN attribute. 
Doesn't Like DN.  I need DN.  How do you do an LDAP operation w/o DN? 
The documentation includes DN as a valid attribute...  Here's the
error...

Attribute validation error for tag CFLDAP.  
The tag does not allow the attribute(s) DN. The valid attribute(s) are
ACTION,ATTRIBUTES,DELIMITER,FILTER,FILTERFILE,MAXROWS,NAME,PASSWORD,PORT,REBIND,REFERRAL,SCOPE,SECURE,SEPARATOR,SERVER,SORT,SORTCONTROL,START,STARTROW,TIMEOUT,USERNAME.
 
  
The Error Occurred in /web/customtags/ndsauth.cfm: line 23
 

22 : 
23 : http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX Upgrade Woes!

[Willy Ray]

OH!  I should really try to figure stuff out on my own first... Well...
it's early.

Here's the story:  We're using MySQL and we happen to be storing this
column as a BLOB.  Binary object.  If I set it to medium text, it works
fine...

I'm sure I'll be running into some more stuff!

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

>>> [EMAIL PROTECTED] 06/18/02 08:08AM >>>
Ok, we just moved our development platform from 5.0 to MX.  This will
probably be a first-of-many kind of post.  First error we come across
is
this:  

ByteArray objects cannot be converted to strings.  
 
  
The Error Occurred in /web/live/faculty_staff/index.cfm: line 13
 
11 : WHERE articleID = #variables.article#
12 : 
13 : 
14 : 
15 : 

 
I'm trying to truncate what *used to be* a text string out of my
database.  Is there now some .toString() function I need to use, or
something?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMX Upgrade Woes!

[Willy Ray]

Ok, we just moved our development platform from 5.0 to MX.  This will
probably be a first-of-many kind of post.  First error we come across is
this:  

ByteArray objects cannot be converted to strings.  
 
  
The Error Occurred in /web/live/faculty_staff/index.cfm: line 13
 
11 : WHERE articleID = #variables.article#
12 : 
13 : 
14 : 
15 : 

 
I'm trying to truncate what *used to be* a text string out of my
database.  Is there now some .toString() function I need to use, or
something?

Willy



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Multiple CFMail Problem

[Willy Ray]

What do you think would be the best way to add a delay?  Just loop through some math a 
couple thousand times?

Willy

>>> [EMAIL PROTECTED] 04/08/02 11:38AM >>>
Hi,

Thanks for shedding some light on this subject.  Just for the record it is 
not fixed in CF5 as we experience this same behavior you described and have 
solved it somewhat by adding in a delay.

Thanks

Chuck Rodgers

At 12:30 PM 4/8/02 -0500, you wrote:
>We experienced this problem with all versions of 4.5.  Allaire never did
>'fix' the error.  They claimed it was fixed in 4.5.1, however it still
>existed, just wasn't as persistent as earlier versions.
>
>Our own diagnosis determined that the cause of the error was the
>cfmail.dll(I forget the actual name of the DLL) was trying to write two
>files at the same time. Or perhaps more correctly, it would attempt to
>write the second file before the first was closed.  We would typically
>end up with 0k files in the undeliverable section.
>
>Anyway, adding some pause between the cfmails may solve your problem
>provided the site isn't terribly active and there aren't too many
>simultaneous requests to these cfmail calls. We found the size of the
>emails also greatly affected how often this error would occur.  For
>example, if you have a page that sends 4 different emails to 4 different
>contacts at one company and each email contains a 10k attachment, you
>can start to duplicate this bug with some regularity.  Now imagine that
>page being hit every 5 seconds... Now, the speed of your server and file
>system are also going to affect how often this happens.  So, adding
>pauses and using smaller emails MAY solve your problem depends on how
>active your site is.
>
>Ultimately, our solution was to switch to an alternate means of
>generating email.  We switched to an ASP product that is actually
>multi-threaded unlike Allaire/Macromedias solution.
>
>For years, I have been suggesting that CF Enterprise be bundled with a
>robust multi-threaded smtp spooler that should be directly tied to the
>application engine.  Enterprise sites that deal with high mail loads
>would benefit from this.  Also, it would add more product disparity
>between pro and ent, something I personally feel is lacking.
>
>I have not tested these same errors (bugs?) in CF 5.  Perhaps it has
>been corrected, but honestly, if past performance of eliminating mail
>bugs between revisions is any indication, I would suspect they only
>added new and more exciting problems ;)
>
>Trey Rouse
>Internet Project Coordinator
>Web Services - Rice University
>MS 119 - 713.348.4799
>
>PS - I love CFM, I just loath CFMAIL.
>
>-Original Message-
>From: Willy Ray [mailto:[EMAIL PROTECTED]] 
>Sent: Monday, April 08, 2002 10:43 AM
>To: CF-Talk
>Subject: Multiple CFMail Problem
>
>Hey All,
>
>Here's my situation.  I have an application that generates 3 total
>emails.  User clicks submit, it generates one email, then they're taken
>to another page on which they can submit additional info.  If they do
>this, two more emails are created, one to the person who is gathering
>the info, and another back to the user thanking them for sending
>additional info.
>
>My problem is, the middle email doesn't always get sent.  I click the
>first submit button, I always get the email, I do the additional info,
>hit submit, and I always get the "thanks for the more info" message, but
>I only get the "additional info" message if I then hit the back button,
>and re-click submit!
>
>It seems like the time between messages is to short, and I'm getting
>these additional info messages in my undelivrable folder.  How long do I
>need to wait between messages, and what's the best way to accomplish the
>waiting?  two separate templates?
>
>Help!
>
>Willy Ray
>
>
>
>-
>Willy Ray
>Web Applications Developer
>Certified Advanced ColdFusion Developer
>Westminster College
>
>
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Multiple CFMail Problem

[Willy Ray]

Hey All,

Here's my situation.  I have an application that generates 3 total emails.  User 
clicks submit, it generates one email, then they're taken to another page on which 
they can submit additional info.  If they do this, two more emails are created, one to 
the person who is gathering the info, and another back to the user thanking them for 
sending additional info.  

My problem is, the middle email doesn't always get sent.  I click the first submit 
button, I always get the email, I do the additional info, hit submit, and I always get 
the "thanks for the more info" message, but I only get the "additional info" message 
if I then hit the back button, and re-click submit!  

It seems like the time between messages is to short, and I'm getting these additional 
info messages in my undelivrable folder.  How long do I need to wait between messages, 
and what's the best way to accomplish the waiting?  two separate templates? 

Help!

Willy Ray



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: MySQL Cold Fusion Question?

[Willy Ray]

Brian,

We're using ColdFusion 5 on LINUX and a MySQL database server.  It's 
wicked.  We had previously been using Access and NT.  Everything is better 
on MySQL except GUI access to your data, though you can pick up freeware 
apps to do this.  It seems to be faster, cleaner, less likely to freeze up 
on you.  We're using MyODBC for the driver.  Works good.  We really like 
it.

Willy

>>> [EMAIL PROTECTED] 2/13/02 2:35:57 PM >>>
I'm new to this list, so far it's great.

We run NT4, WebSitePro, Cold Fusion 5, and so far all our customer data 
bases are in Microsoft Access. We have 20 - 30 customers use MS Access 
database with CF on our Server.

We have not used MySQL as of yet.

I have a potential customer that has a small amount of data (500 - 600 
records) in a MySQL database.

How hard is it to get MySQL working on NT?

How hard is it to get CF working with MySQL? I can't seem to find 
anything 
on the CF website about this.

Is it possible to convert a MySQL database to MS Access? Would I want to 
do 
this?

Is MySQL any better than MS Access?

Brian

Off list if you want at: [EMAIL PROTECTED] 


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

Write flat files based on HUGE query

[Willy Ray]

I have a huge query that takes about 15 minutes to run.  I'm a small 
college, and I'm pulling data on my faculty and their class schedules, 
office hours for posting on the web site.  My legacy administrative 
database was never designed for servicing the web, and it is just a 
terribly long request to get all of this data.  Currently, I'm caching the 
query for a week, and that seems to work pretty well.  However, I'm 
getting requests for changes to this application, and I'm considering a 
re-write.  

One of the ways I'm thinking about doing this is to run my mongo-query, 
and then loop through the results writing html, or cfm, files as I go.  It 
would probably be about 300 pages.  Is it like this:

SQL question grouping, ordering, sorting

[Willy Ray]

Ok, I have a database of search strings with which users of the site have 
hit my search engine.  I want to build a viewer so I can go in and see 
what people are doing without actually cracking into the database.  My 
database isn't doing anything fancy.  It's one table, consisting, 
essentially, of id, searchstring, casesensitive...

What I want is to be able to query the database, and display the 10 or 15 
most searched strings.  I'm just not sure how to go about it.

I can

GROUP BY searchstring

that get's me close, and culls out duplicate strings, but I don't know how 
I'd get from there to 

top 5 strings:

1. Happy and Go and Lucky (16 searches)
2. "Moo Cow" (10 searches)
3. etc.
4. etc.

Any thoughts?

Willy Ray
~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

XML parsing for UNIX

[Willy Ray]

The article in CFDJ has us instantiating a COM object in order to parse 
the XML, but COM is not supported on UNIX.  How do we do this on UNIX?

Willy
~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Browser client for upload files?

[Willy Ray]

Alright, the client needs to upload a PDF file.  How do I let the user browse their 
machine for the file to upload? I'd like to use CFTREE, right?  I'm fuddled.

Willy


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

I'm an idiot...

[Willy Ray]

Say, hypothetically, I had lost the password to the Cold Fusion Administrator for 
cf4.5 on my win2k machine.  Anybody have any ideas where, *hypothetically* I might 
find the password in the registry or something?




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Verity and Dynamic Pages

[Willy Ray]

Can I use Verity to index the content on dynamic pages?  What I mean is, if I put .cfm 
extension in my CFINDEX tag, will the cfm templates be processed by the coldfusion 
server before they're indexed?

Willy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Sort by 1st three letters of month?

[Willy Ray]

Ok, I'm an idiot.  I have my users putting in text strings for months.

I need 

Jan. 12

to be ordered ahead of 

Aug. 9

These are text records.  Is there any way to do this?  I guess I could parse out the 
first three characters of whatever my user entered, run it through a big cfswitch to 
assign numerical values to the months, add a leading zero to the day part...

Is there any easier way?

Willy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Sorry. MySQL ODBC driver for Solaris?

[Willy Ray]

I have apache, MySQL and Coldfusion 4.5 running on a Solaris 8 machine.  Can I 
configure MySQL datasources without an ODBC driver installed on the machine?  I've 
assumed I can't, and been bashing my head up against MyODBC, but with no avail.  I can 
set up the datasource, but it always fails.  Any ideas?  Anybody using this 
configuration?  Anybody using some other ODBC driver for MySQL on Solaris?

Willy Ray


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Crazy Dynamic Update/FORM Structure question

[Willy Ray]

Wait, I think I got it.  There's a apostrophe (A.K.A. single quote) in my text string. 
 That would do it, eh?  What's the function I use to fix that?  PreserveSingleQuote?

Willy

>>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>>
what's the data type of the field objectcontent and exactly how long is your
string?

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: 01 June 2001 15:40
To: CF-Talk
Subject: Re: Crazy Dynamic Update/FORM Structure question


Ok, I tried plugging the content into a test update statement that I knew
was working.  Bombed out.  Same error.  There's either something in my text
string that's causing a failure, or access/ODBC won't accept that big of a
string.  Any thoughts on making it do this?

Willy

>>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>>

Ok, I'm having some trouble here.  I don't know what the form looks like, as
it's being generated dynamically.  So, I figure, I'll have to loop through
the FORM structure, and run a seperate update for each form element.

Here's what I'm doing:




 UPDATE contentitems
 SET objectcontent='#form["#i#"]#'
 WHERE objectname='#i#'
 AND page='#FORM.page#'
 



Now the first element of the loop it will hit will be a field from the form
called "Body."  It's the first possibility, alphabetically.  And value is
going to be a really long string of text.  I've set "page" on the form
earlier on.

It should come out like this:

UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'

And it does, but I get an error:

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression  "great big long string of text running out to a point at
which it gets truncat'

Then it shows my sql, and it really does look like I had hope it would...Am
I just missing something in my update statement?

Willy
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Crazy Dynamic Update/FORM Structure question

[Willy Ray]

Good questions.  The data type of the field is (MS Access) Memo.  The string is about 
1400 characters.  But I've been doodling around this morning with it, and I've gotten 
it to take strings up to 2500 characters.  The problem seems to be that I'm passing 
some sort of carriage return that's mucking up my statement.  If I could just find and 
replace it, but I can't even figure out what the character is...



>>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>>
what's the data type of the field objectcontent and exactly how long is your
string?

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: 01 June 2001 15:40
To: CF-Talk
Subject: Re: Crazy Dynamic Update/FORM Structure question


Ok, I tried plugging the content into a test update statement that I knew
was working.  Bombed out.  Same error.  There's either something in my text
string that's causing a failure, or access/ODBC won't accept that big of a
string.  Any thoughts on making it do this?

Willy

>>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>>

Ok, I'm having some trouble here.  I don't know what the form looks like, as
it's being generated dynamically.  So, I figure, I'll have to loop through
the FORM structure, and run a seperate update for each form element.

Here's what I'm doing:




 UPDATE contentitems
 SET objectcontent='#form["#i#"]#'
 WHERE objectname='#i#'
 AND page='#FORM.page#'
 



Now the first element of the loop it will hit will be a field from the form
called "Body."  It's the first possibility, alphabetically.  And value is
going to be a really long string of text.  I've set "page" on the form
earlier on.

It should come out like this:

UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'

And it does, but I get an error:

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression  "great big long string of text running out to a point at
which it gets truncat'

Then it shows my sql, and it really does look like I had hope it would...Am
I just missing something in my update statement?

Willy
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Crazy Dynamic Update/FORM Structure question

[Willy Ray]

Ok, I tried plugging the content into a test update statement that I knew was working. 
 Bombed out.  Same error.  There's either something in my text string that's causing a 
failure, or access/ODBC won't accept that big of a string.  Any thoughts on making it 
do this?

Willy

>>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>>

Ok, I'm having some trouble here.  I don't know what the form looks like, as it's 
being generated dynamically.  So, I figure, I'll have to loop through the FORM 
structure, and run a seperate update for each form element.

Here's what I'm doing:




 UPDATE contentitems
 SET objectcontent='#form["#i#"]#'
 WHERE objectname='#i#'
 AND page='#FORM.page#'
 



Now the first element of the loop it will hit will be a field from the form called 
"Body."  It's the first possibility, alphabetically.  And value is going to be a 
really long string of text.  I've set "page" on the form earlier on.

It should come out like this:

UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'

And it does, but I get an error:

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query 
expression  "great big long string of text running out to a point at which it gets 
truncat'

Then it shows my sql, and it really does look like I had hope it would...Am I just 
missing something in my update statement?

Willy
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Crazy Dynamic Update/FORM Structure question

[Willy Ray]

Ok, I'm having some trouble here.  I don't know what the form looks like, as it's 
being generated dynamically.  So, I figure, I'll have to loop through the FORM 
structure, and run a seperate update for each form element.

Here's what I'm doing:




 UPDATE contentitems
 SET objectcontent='#form["#i#"]#'
 WHERE objectname='#i#'
 AND page='#FORM.page#'
 



Now the first element of the loop it will hit will be a field from the form called 
"Body."  It's the first possibility, alphabetically.  And value is going to be a 
really long string of text.  I've set "page" on the form earlier on.

It should come out like this:

UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'

And it does, but I get an error:

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query 
expression  "great big long string of text running out to a point at which it gets 
truncat'

Then it shows my sql, and it really does look like I had hope it would...Am I just 
missing something in my update statement?

Willy



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Bizarre Error: Server/Studio Duplicating Carriage Returns

[Willy Ray]

Thanks.  That did it.

Willy

>>> [EMAIL PROTECTED] 5/21/01 1:34:58 PM >>>
In ColdFusion Studio, under Options\Settings\File Settings tab there is a
Format when saving selection.
Select Unix format.

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: "Willy Ray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 1:17 PM
Subject: Bizarre Error: Server/Studio Duplicating Carriage Returns


> I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1.
When I save a template through RDS, for every carriage return I enter as I
code, I get two carriage returns on the saved document.  Example:
>
> I write:
>
> 
>  
>  Hello
>  
>
>
> When I re-open the file it looks like this:
>
> 
>
>  
>
>  Hello
>
>  
>
> What's worse, If I make a little change, like, change the "Hello" to
"Hello, World" and re-save the template, the next time I open it, it looks
like this:
>
> 
>
>
>  
>
>
>
>   hello, world
>
>
>
>
>  
>
>
> Big problem.  I've got a template with only about 20 lines of actual code
on it, but it's up to about 14000 lines, due to this problem.  I have studio
on two different machines, and it doesn't seem to matter which I use.  Also,
this is not happening from the same two workstations if I write to an NT
machine through RDS, or through windows networking.
>
> Any ideas?
>
>
> Willy
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Bizarre Error: Server/Studio Duplicating Carriage Returns

[Willy Ray]

I'm running the eval of Cold Fusion Server 4.5 Enterprise on Redhat 7.1.  When I save 
a template through RDS, for every carriage return I enter as I code, I get two 
carriage returns on the saved document.  Example:

I write:


 
 Hello
 


When I re-open the file it looks like this:



 

 Hello

 

What's worse, If I make a little change, like, change the "Hello" to "Hello, World" 
and re-save the template, the next time I open it, it looks like this:




 



  hello, world




 


Big problem.  I've got a template with only about 20 lines of actual code on it, but 
it's up to about 14000 lines, due to this problem.  I have studio on two different 
machines, and it doesn't seem to matter which I use.  Also, this is not happening from 
the same two workstations if I write to an NT machine through RDS, or through windows 
networking.  

Any ideas?  


Willy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Send Cookie in custom tag?

[Willy Ray]

I know I can't use CFCOOKIE above CFLOCATION on a template, but what if I had a custom 
tag that dropped a cookie above a CFLOCATION?  Like this:





Would the cookie go?

Willy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

NT/2000 Vs. Solaris

[Willy Ray]

Anybody have any strong feelings about which is better?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anybody seen this before?

[Willy Ray]

WellI rebooted several times.  Every time, I'm getting the same result within a 
few minutes.

>>> [EMAIL PROTECTED] 3/21/01 7:21:45 PM >>>
It means you're out of resources...maybe a reboot is in order?

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com 
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

----- Original Message -
From: "Willy Ray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 7:12 PM
Subject: Anybody seen this before?


> Error attempting to get the client (Client ID = '168975').
> A problem was encountered trying to access the system registry. Error
number 1450 occurred.
>
>
> The error occurred while processing an element with a general identifier
of (CFAPPLICATION), occupying document position (4:1) to (8:31).
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Anybody seen this before?

[Willy Ray]

Error attempting to get the client (Client ID = '168975').
A problem was encountered trying to access the system registry. Error number 1450 
occurred.


The error occurred while processing an element with a general identifier of 
(CFAPPLICATION), occupying document position (4:1) to (8:31).



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Somewhat OT: Differences Between JRUN and CF

[Willy Ray]

If I'm already using Coldfusion, would there be any compelling reason that I would 
want to use JRUN as well?  What are the differences?  Pros?  Cons?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Client Caching of Web Pages

[Willy Ray]

Is there any way I can force a client to reload a page, and not pull from their cache?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Cached Query! Was Working Yesterday!

[Willy Ray]

CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of (CFQUERY), 
occupying document position (39:1) to (40:43).


This is the entire message.  Why would it do this?  It was working yesterday, I went 
live with it, now it's failing.  I'm going insane!


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Attribute set validation Error. Why?

[Willy Ray]

Yeah, I'm an idiot.  I guess I'll need a group attribute

>>> [EMAIL PROTECTED] 2/26/01 1:50:53 PM >>>
This is the error I'm getting:
Attribute set validation error in tag CFOUTPUT

The tag has an invalid attribute combination: the most likely attribute combination is

Required attributes: 'GROUP,QUERY'. Optional attributes: 
'GROUPCASESENSITIVE,MAXROWS,STARTROW'.


Here's the tag I'm using:



Why the hell am I getting this error? It's like the error says, "Do exactly what 
you're doing." I've been getting the same thing on some cfmail tags. I have all the 
right attributes, but it gives me this attribute set validation error. Why!?

Willy Ray
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Encoding URL Variables

[Willy Ray]

How do I encode URL variables so that I can pass semi-sensitive info over URL?

Willy Ray



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Case Sensitivity in SQL Queries

[Willy Ray]

I'm pulling a great big list of faculty names from our mammoth admisitrative database. 
 The query is alphabetizing Lowercase names after Uppercase names, so I've got a guy 
with a last name of van Oosterhout, and that's coming in after a guy named Zimmer.  Is 
there some way for me to specify to the query that I don't want it to alphabetize 
sensitive to case?  How about when I output it?  What I just read regarding the 
groupcasesensitive attribute of cfoutput is that you set it to "no", and it will 
preserve the case insensitivity of an already case-insensitive query.  I just wish I 
*had* a case-insensitive query to preserve!

Willy Ray


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Attribute set validation Error. Why?

[Willy Ray]

This is the error I'm getting:
Attribute set validation error in tag CFOUTPUT

The tag has an invalid attribute combination: the most likely attribute combination is

Required attributes: 'GROUP,QUERY'. Optional attributes: 
'GROUPCASESENSITIVE,MAXROWS,STARTROW'.


Here's the tag I'm using:



Why the hell am I getting this error?  It's like the error says, "Do exactly what 
you're doing."  I've been getting the same thing on some cfmail tags.  I have all the 
right attributes, but it gives me this attribute set validation error.  Why!?

Willy Ray






~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

IsCachedQuery?

[Willy Ray]

Is there any way to check to see if a Query is cached or not, before I call it?  I 
have some big'uns, and I'd like to be able to handle the caching like this:

The data you have requested is currently being reloaded from the main database.  
Please check back in 5 minutes.

How would I do this?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Sub-query a cached query?

[Willy Ray]

Can I make an enormous cached query, and then query those results?  Say, for example, 
I wanted to query all customers and all invoices at once, then display a list of 
customers with unpayed invoices, linked with URL variables to a detail page that would 
show the invoice details.  Could I do this with one big query, cached at the 
beginning, and never hit my database again until the cache expired?  

Willy Ray
Web Designer
Westminster College
Salt Lake City, UT


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: connection limit has been reached?

[Willy Ray]

I'm having the same problem.  I'm on a winNT server to which I'm the only
real connection.  Does the 10 connection limit apply to web hits?  I was
also wondering if it might be cfhttp bogarting all of my threads on failed
connections.  Like a dope, I haven't written them with timeout attributes.

-Original Message-
From: JayB [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 5:24 PM
To: CF-Talk
Subject: RE: connection limit has been reached?


Or in win2k a maximum of 10 connections to anyone machine are allowed on a
peer to peer network.

>don't forget to check in cfadmin -> odbc ->cfsettings for a maximum # of
>connections allowed..
>
>
>If you are using Winders NT use the Lisence Manager to verify that you have
>the correct number of SQL and NT lisences for the servers.  If necessary,
>purchase a few more.
>
> > can anyone help me with this error or atleast give me an idea of
> > what to do about it? i get it when i try to log onto the client
> > section of the site im working on and ive never seen this before
> >
> > Error Diagnostic Information
> > ODBC Error Code = ()
> >
> > Timed-out trying to get a connection to MYDATASOURCENAME. The
> > connection limit has
> > been reached.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Schedule Tasks in CFADMIN

[Willy Ray]

I have a template I want to run monthly.  Here's what it does:

1.  Deletes all records flagged for deletion.
2.  Checks for records that are a year old
3.  Flags those for deletion
4.  CFmails the email addresses in the year-old records, "Hey, your record is flagged 
for deletion.  Will be deleted in a month."

So every month, it would delete the records it flagged the month before, and flag some 
more records to be deleted the next month.  

Runs great when I just call the sucker in my browser.  But it doesn't work when I use 
the administrator to schedule it.  What's happening here?  Why shouldn't it work out 
of the task scheduler?

Willy










~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

I'm too dumb to set a cookie!

[Willy Ray]

Isn't it just

 

?

I can't make it set!  My debugging data continues to show just cftoken and cfid for 
cookies!

YEEARRRGH!

Are there any special settings in administrator that inhibit cookies?  Something like 
that?

Willy

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts

RE:Dave: Kooky Form Field/List question.

[Willy Ray]

Dave,
The solution looping over list is working, but I'm not getting what you're saying 
about looping over the structure.  I cant seem to access the form as a structure.  I'm 
on CFServer 4.0.  Could that be the problem?  Special feature of 4.5?
Thanks
Willy


>>> Dave Watts <[EMAIL PROTECTED]> 11/20/00 9:42:16 AM >>>
> So, here's the problem. I can use the automatically-created 
> FORM.fieldnames list to get the field names onto the email 
> like this:
>
>
> #test# :
>
>
> This code puts the names of the form field onto the email.
> Easy. I can also test them for whether or not they're one of 
> my required fields, and not print them if they are. What I 
> can't do is print the VALUE of the form fields. Make sense?
> I was hoping I could do something like this:
>
>
> #test# : #FORM.#test##
>
>
> Yeah, but I can't. Any thoughts?

Use the Evaluate function to determine the value of a variable whose name
you don't know until runtime:

#test#: #Evaluate("Form." & test)#

In addition, rather than looping over the FIELDNAMES string, you might be
better served by looping over the Form structure itself:



#i#: #Evaluate("Form." & i)#



This way, if you have any duplicate field names, such as you'd get with
checkbox arrays, you'll output the fieldname once, followed by a
comma-delimited list of selected values.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts

Kooky Form Field/List question.

[Willy Ray]

I work on a college campus, and frequently I'm asked by faculty/staff/students, why 
they can't just make a form in front page express and have it send them an email (and 
we don't have the server extensions).  I have the hardest time explaining what a form 
handler is, and how frontpage just can't do it.

So, I decided to make a generic Coldfusion form handler.  Something that, provided it 
was passed an email address, subject line, and a redirect URL (for the success 
message), it would make an email to the address.  Ok, this is the easy part.  I have 
it already.  The problem is, I need also to pass *any form fields* other than the ones 
required for the email in the body of the email.  Biology is going to need different 
things on their form than accounting, see, so I want to make this thing totally 
generic.  

So, here's the problem.  I can use the automatically-created FORM.fieldnames list to 
get the field names onto the email like this:


#test# :   


This code puts the names of the form field onto the email.  Easy.  I can also test 
them for whether or not they're one of my required fields, and not print them if they 
are.   What I can't do is print the VALUE of the form fields.  Make sense?  I was 
hoping I could do something like this:


#test# : #FORM.#test##  


Yeah, but I can't.  Any thoughts?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts

OT: Allaire Advanced Fusion Developement Class

[Willy Ray]

I'm trying to get my superiors to send me to the Advanced Developement class.  Anybody 
been to this?  How did you like it?


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Date Manipulation?

[Willy Ray]

Ok, I have a date.  I need to add a day, or a number of days.  How the devil does one 
do this?


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

date comparisons

[Willy Ray]

One of the fields in my table is a datestamp.  I need to be able to pull only those 
records whose datestamps are between certain dates.  I would like to limit my query to 
only pull the records I need based on their dates, but frankly this app will be 
getting low enough usage that if I could pull all records and then evaluate whether or 
not to print them, that would be fine, too.  

Second question:  Is there a good simple sql book that I could get that would keep me 
from having to bug the smart people everytime I can't figure out some stupid syntax 
problem?

Willy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

OT? - Cold Fusion and Datatel?

[Willy Ray]

I'm a CF developer for a small college in Utah.  Our main administrative database 
system is called "Colleague" and it's produced by a company called Datatel.  Supposed 
to be ODBC compliant.  So far all of my applications have been written on Access, 
however, because we haven't been able to get any ODBC drivers that would actually hit 
the database from my CF server.  Anybody out there using Colleague and Cold Fusion 
together?  Anybody?  If so, how?  I'd love to get into contact with someone with some 
knowledge on this.  Access-based developement is starting to wear a little thin for me.

Willy Ray


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Hmm..Calculate Elapsed Time

[Willy Ray]

You know, I've been a newbie in a lot of communities, (Quake, Diablo, College).  
I've never felt as supported as I do in the CF community.  You guys rule.  Thanks for 
the help.

>>> [EMAIL PROTECTED] 10/25/00 9:56:40 AM >>>
if you're using SQL server, there's an SQL function called DateDiff.  it
will calculate the difference of two date/time fields in the DB.

there's also a CF function called DateDiff.  it will calculate the
difference of two date/time formatted strings (so you don't REALLY have to
use datetime if you don't want).  however, it's recommended, as the DB can
do a lot of that work for you.

chris olive, cio
cresco technologies
[EMAIL PROTECTED] 
http://www.crescotech.com 



-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 25, 2000 11:42 AM
To: CF-Talk
Subject: Hmm..Calculate Elapsed Time



   I'm timestamping logins and logouts, I want to be able to calculate the
time elapsed between the two.  My question is, what format should I be
writing these timestamps in, and I'm hoping that there's a function I can
use that is smart enough to just subtract time values?  Thoughts?

Willy



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

Hmm..Calculate Elapsed Time

[Willy Ray]

   I'm timestamping logins and logouts, I want to be able to calculate the time 
elapsed between the two.  My question is, what format should I be writing these 
timestamps in, and I'm hoping that there's a function I can use that is smart enough 
to just subtract time values?  Thoughts?

Willy


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Access question

[Willy Ray]

Now, I *had* heard of Access 2K having slight problems with simultanious requests.  
If, when you set up your ODBC source, you limit concurrent connections to 1, that will 
keep that problem from happening.  Liaible to slow you down, some, though.  All 
depends on how much traffic you're getting, I think.  

Willy

>>> [EMAIL PROTECTED] 10/12/00 8:57:04 AM >>>
Fair enoughbut it all depends on what many is.

If a client comes to me asking for a small, half a dozen page data driven
web site where there is very little dynamic content why would I suggest
using SQL.  The price of the DB software would probably be more than the
total development for the site!  There would be litte or no danger of Access
bringing down CF providing that traffic was monitoredsure if it runs
like a dog because of loads of hits then move to SQL

I developed a small site for a TV company which had thousands of hits a day
while the series was running.  They updated the content on the site by
changing the samll amount of data stored in an Access database.  Site worked
fine...no probs.  SQL would have been a coplete overkill

I disagree with your comment  "Access is NOT by strict definition a multi
user database. SQL is."  Access is a multiuser database.  Just that SQL is a
better one


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]] 
Sent: 12 October 2000 15:47
To: CF-Talk
Subject: RE: Access question


Hey Andy,

I refer you to his original question: "Can it handle simultaneous access
from  many users or is SQL better for this".

His "problem" was many users, not a small db.

Nonetheless, I agree with Bill's quote.  But ask yourself a question, why
would you ever propose or use a solution that MIGHT bring CF down?  I've
never heard of SQL Server bring CF down.  I've personally experienced Access
bringing CF down.  Access is NOT by strict definition a multi user database.
SQL is.

AJ



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 12, 2000 10:39 AM
To: CF-Talk
Subject: RE: Access question


Aaron - I refer you to Bill's excellent quote:

"Don't provide a Star Trek solution to a Babylon 5 problem"

There's no point forking out for a SQL internet license if you can use
Access for free and it does the job you need it too.  Don't get me wron - I
admit SQL is a thousand times better than Access but if you've only got a
tiny database, what's the point?

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]] 
Sent: 12 October 2000 15:33
To: CF-Talk
Subject: RE: Access question


Sure, it can "handle" simultaneous Access from many users.  A bunny might be
able to handle a wolf for about 2 seconds, then it dies.  Same with Access.
I've had sites crash every 2 minutes using Access, move it to SQL and it
works fine.

Use SQL.  Don't screw with Access.

AJ

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 12, 2000 10:27 AM
To: CF-Talk
Subject: RE: Access question


It can handle simultaneous Access.  Access is just a toned down version of
SQL (which it sounds like you already know).  You should base your decision
to upsize to SQL purely on the performance of your site and size that your
database grows to.  As far as simultaneous access is concerned, obviously
SQL will be better but may be overkill depending on the amount of traffic
that goes through the database.  In the words of someone else using this
usergroup (I think it was Bill!) - "Don't provide a Star Trek solution to a
Babylon 5 problem"

Apollogies Bill if I miss quoted you!

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]] 
Sent: 12 October 2000 16:05
To: CF-Talk
Subject: RE: Access question


Thanks for the quick reply.

At this point I am more concerned about simultaneous access. Can it handle
simultaneous access from  many users or is SQL better for this.

Thanks Andy.

Robert O.

>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
>Sent: Thursday, October 12, 2000 8:49 AM
>To: CF-Talk
>Subject: RE: Access question
>
>
>How much data is in the table?  I would be extremely surprised if this was
>due to there being too much data in the table.  I think the maximum size of
>an Access mdb is approx 2gb but I aint sure about this.  I know
>that you can
>have a whole load of records in a table though (millions) not that you'd
>want to of course for per

RE: Slightly Off-Topic: Credit Card Wackyness

[Willy Ray]

Well, I'm at a small college.  I'd like the students to be able to pay tuition, fees, 
etc. w/ their creditcards over the website.  The accounting office has a swiper unit 
that they use at the cashiers window.  Would that be a "Merchant Account?"  Do I need 
to figure out with them how that works, then talk to the people that they have that 
through?

>>> [EMAIL PROTECTED] 10/5/00 8:38:50 AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> Alright, so I got the SSL working, and I'm pleased with that, 
> now my head is spinning with the possibility of credit card 
> usage on my little higher-educational website (I'm tired of 
> doing job boards, admissions applications).  I have no idea 
> what I need in order to do this.  Do I need some credit card 
> hardware?  Some sort of networkable swiper box?  Can I do it 
> with just cold fusion and an I.P. address?  Babe in the 
> woods, here, people.

Oh boy... Here's a question w/ no easy answer...

There's about a million & one ways you can do credit card processing.

First question:  Do you have a merchant account with a bank, or do
you think you can get one easily (IE: established company w/ good
credit rating & in good standing w/ the bank)?

If the answer to that is NO, then you'll need to user one of the
various services that provide full credit card billing w/o the user
needing a merchant account.  I'm not sure whether you're selling site
access (or other intangibles) or if you're selling a product, but
that would affect your choice of processors.  This type of processor
will charge you a mint for their services, but they might be your
only choice if you can't get a merchant account.  They also usually
add additional fraud detection systems which are EXCEEDINGLY useful
for membership-type sales.  Some places to start looking:
www.ibill.com, www.ccbill.com, and a sh'load of others I can't think
of off the top of my head.  IBILL has been our best bet for a while
now.  We DO have a merchant account, but the reduction in fraud w/
IBILL's fraud detection and negative database has MORE than made up
for the 15% cut they take for their service.

If you do have or can get a merchant account, you'll likely want to
look at processing the cards through your own account.  That way,
you'll probably end up paying minimal fees (3-5%) and perhaps a small
per-transaction fee ($.10 - $.35 per charge).  

Now...  Simply having a merchant account doesn't magically get you
Internet CC billing (bummer...).  You'll need some software to pull
it off...  CyberCash seems to be a popular choice.  Depending on your
bank, the CyberCash transactions fees might be covered for you,
leaving you only the 3-5% bank cut.  Our bank covers the CyberCash
fees for us.

That said, I haven't been too thrilled w/ CyberCash personally.  I'm
especially displeased w/ the ColdFusion options for accessing the
CyberCash servers.  On CyberCash's side, Address Verification
Services (AVS) are frequently unavailable even for cards that I
*know* support AVS.  That makes it tougher to control fraud.

As for the ColdFusion software, it's kind of a mess...  CyberCash
doesn't actually supply CF tags or anything of the sort.  They give
you a COM object, but the amount of supporting code to drive the COM
is pretty heavy.  That code is available in Perl, C, or ASP, but not
CF.  Porting it would NOT be fun...  There are a number of CyberCash
tags available from third parties.  Allaire & ONCR both make tags. 
Allaire's only does authorizations, not batch settlements, and it's
not thread safe (CFLOCK is a MUST!).  Version 3 of the ONCR tag seems
to leak memory during auths, but it does handle batch decently.  It
WILL occasionally crash however.  That leaves your batch in an
unknown state & requires much manual intervention & cursing to
straighten things up.  That happens perhaps once every two months or
so.  ONCR does have a version 4 available of their tag which they
claim is much better.  I'd give it a try if not for the $ticker
$hock

Even with all those caveats against CyberCash, I feel it's the best
solution available if you have a merchant account.  I'd certainly be
interested in others' experiences with other processor software, tho!

Hope that was at least helpful.  I can provide more detailed
information about either IBILL or CyberCash when you decide which
route you're going to take.

Best regards,
Zac Bedell


-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOdySegraVoMWBwRBEQIllgCg2B+4utyhed9PcotSMtd/Vc1jJSMAn2CQ
VsZNko+pMHbaMUetIiGNiTeG
=5Pfl
-END PGP SIGNATURE-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---

Slightly Off-Topic: Credit Card Wackyness

[Willy Ray]

Alright, so I got the SSL working, and I'm pleased with that, now my head is spinning 
with the possibility of credit card usage on my little higher-educational website (I'm 
tired of doing job boards, admissions applications).  I have no idea what I need in 
order to do this.  Do I need some credit card hardware?  Some sort of networkable 
swiper box?  Can I do it with just cold fusion and an I.P. address?  Babe in the 
woods, here, people.

Willy Ray
Westminster College

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF and CFELSE

[Willy Ray]

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_2C7475F2.A6C7A9E6
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

There Must be something I don't know about CFIF.  I want to check if a URL =
variable exists.  If it does, I want to add the same variable to the URL =
of the action of a CFForm, basically so I can check for it on the action =
page, and use it to re-route a cflocation. =20

Here's the problem.  I have a CFIF that, if it's true, starts a CFFORM =
with the URL variable included in the action, then it has a CFELSE that =
starts the same form, just without the URL variable.  Problem is, it =
doesn't work.  Tells me that there's an extraneous  at the bottom =
of the template.  Basically, whether or not the criterion is met, it =
doesn't start the form. =20

I musta missed something about CFIF, CFELSE, or CFFORM.  Any Ideas?  =
Here's my logic:




   
  
   =

 


Whether myvariable exists or not it doesn't print either of the cfform =
lines.

--=_2C7475F2.A6C7A9E6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML






There Must be something I don't know about CFIF.  I =
want=20
to check if a URL variable exists.  If it does, I want to add =
the same=20
variable to the URL of the action of a CFForm, basically so I can check =
for it=20
on the action page, and use it to re-route a cflocation.  
 
Here's the problem.  I have a CFIF that, if it's true, starts a =
CFFORM=20
with the URL variable included in the action, then it has a CFELSE that =
starts=20
the same form, just without the URL variable.  Problem is, it =
doesn't=20
work.  Tells me that there's an extraneous  at the =
bottom of=20
the template.  Basically, whether or not the criterion is met, it =
doesn't=20
start the form.  
 
I musta missed something about CFIF, CFELSE, or CFFORM.  Any=20
Ideas?  Here's my logic:
 
 
 
        &l=
t;cfform=20
action=3D"emp_add_action.cfm" method=3D"POST"=20
enablecab=3D"Yes"> 
 
 
Whether myvariable exists or not it doesn't print either of the =
cfform=20
lines.

--=_2C7475F2.A6C7A9E6--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.