Re: CFX_printmoney tag
Hello CF-Talk, Re: CFX_printmoney tag Micro$oft has one, but it only works on Opera for the Mac! :-) Macromedia has one, but it only prints the money on stress balls and water bottles. I have a CFX_GirlFriend tag that could help you forget all about Micro$oft !!! Kind Regards, Christopher Dawes Dawes International - CT> Date: Mon, 29 Oct 2001 22:08:38 -0800 CT> From: <[EMAIL PROTECTED]> CT> Subject: Re: CFX_printmoney tag CT> Message-ID: <004301c16109$51bee730$1fae0818@cx86637a> CT> Does anyone know where one can find the holy CFX_printmoney tag? CT> Just thought I'd lighten things up from all this Microsoft (referring to CT> Bill Gate's personal organ) vs. Macromedia:) CT> ~~ CT> 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
Re: printing
Hello CF-Talk, I haven't looked into this for quite some time, however we used an ActiveX control in IE4 about 1-2 years back that allowed us to print the page without the dilogue and we could temporarily over-ride all print settings including header, footer, orientation and alike. I wouldn't be able to help you start your search as I no longer have access to the project materials. You would have to ask the Gecko Boys at Mozilla Land regarding Navigator. I know that there is a Mozilla/Explorer ActiveX Library that Mozilla is pushing... perhaps if you could ask the developer of one of those ActiveX tags to rebuild??? Kind Regards, Christopher Dawes Dawes International - Tuesday, October 30, 2001, 4:43:06 PM, you wrote: CT> CF-Talk-list Tue, 30 Oct 2001 Volume 1 : Number 77 CT> In this issue: CT> Re: printing CT> -- CT> Date: Tue, 30 Oct 2001 10:45:48 +0530 CT> From: "nagraj" <[EMAIL PROTECTED]> CT> Subject: Re: printing CT> Message-ID: <002a01c16102$a714c670$630a@nagraj> CT> Hai Joshua >> Anyone know either through style sheets or some other way to make a CT> document >> print landscape? CT> When you say print() function,we get the window before printing where by we CT> can opt for Landscape CT> or normal prinitng, CT> Does it does'nt workout? CT> Regards CT> Nnagaraj >> CT> ~~ CT> Get the mailserver that powers this list at http://www.coolfusion.com CT> -- CT> End of CF-Talk-list V1 #77 CT> ** CT> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq CT> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ CT> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: difficulty in downloading Allaire/Macromedia software/patches/updates
I am still amazed that even service packs for Macromedia (nee Allaire) products like CF Studio require another massive download of around 20Mb. And that's for Studio. The servers (4.5x) were even larger. With CF 5 at around an 80Mb install archive I pray that this is rectified before the first inevitable service pack. Additionally - unless you live in the US of A it can be problematic downloading, say CF5 Studio Eval (20.8Mb) from the US. Why, with distributors worldwide, can we not download from a local mirror? Without the same page after page of forms just to get to the URL for the download (which I admit appears to be dynamic and not physical)? FTP is still the best way to download such large files and Macromedia/Allaire do not support it well enough. ~~ 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: CFX_printmoney tag
Does anyone know where one can find the holy CFX_printmoney tag? Just thought I'd lighten things up from all this Microsoft (referring to Bill Gate's personal organ) vs. Macromedia:) ~~ 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
Re: printing
Hai Joshua > Anyone know either through style sheets or some other way to make a document > print landscape? When you say print() function,we get the window before printing where by we can opt for Landscape or normal prinitng, Does it does'nt workout? Regards Nnagaraj > ~~ 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: Macromedia becoming another Microsoft
Can this thread please be moved over to CF-Community or CF-Partners? It's not CF tech and has no direct tech value. Also, as I'm trying to repair my relationship with MM, I wouln't be joining in on the thread other than to ask for the move. Thank you. > My objections are not against capitalism. I just think that it doesn't mean > destroying your opposition by any means. Microsoft is a big bully. Look what > it is doing to AOL Time Warner. It is slowly taking away all of the market > that AOL has. It uses its programs, such as the OS and browser to make it > difficult for users to select between it and the competitors. I am > refering to the > decision to drop JVM (which forces web applications developers to use MS' > products), refusing to agree to let AOL place its icon on the desktop of new > computers and etc.. > > At 07:16 PM 10/29/2001 -0800, you wrote: > >No business could survive without being interested in $$$. And no sensible > >business wouldn't be in it for the $$$. > > > >But to lump the souls of all members of a company into being interested in > >only $$$ is foolish. I take it you've never been to a Macromedia-sponsored > >event; met any of the amazing engineers, artists or designers that put these > >products together. I absolutely know for a fact that 99% of the people that > >work for Macromedia get up every morning wondering "what else can I do to > >make this a more kick-ass product", not "how else can we suck more dollars > >out of our customer's pockets without giving them something in return". > > > >I think you need to go read up on Capitalism a little more. It ain't that > >bad. > > > > Kevin > > > >- Original Message - > >From: "Stevens, Jason" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Monday, October 29, 2001 6:19 PM > >Subject: RE: Macromedia becoming another Microsoft > > > > > > > Big business with a conscience? HA! I believe that is an oxymoron. > > > > > > It's all about the $$$, if they weren't in it for that they wouldn't be > > > here. If they aren't in it for that, they won't be here for long. Believe > >it > > > or not, they don't try to make the best product out there and shove their > > > proprietary standards down your throat because they want to make the world > >a > > > better place. It's all done in the name of the all might dollar. Dress it > >up > > > however you like. > > > > > > -Original Message- > > > From: Thomas Smith [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, October 29, 2001 6:26 PM > > > To: CF-Talk > > > Subject: Re: Macromedia becoming another Microsoft > > > > > > > > > I just read what I wrote. I meant Don't insult Macromedia. Macromedia > > > would never > > > become as bad as Microsoft. They have a councious (sp). > > > > > > At 07:18 PM 10/25/2001 -0700, you wrote: > > > >Become another Microsoft? Don't insult Microsoft. > > > > > > > >This is hitting below the belt. > > > > > > > > > > > > > ~~ 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: Macromedia becoming another Microsoft
My objections are not against capitalism. I just think that it doesn't mean destroying your opposition by any means. Microsoft is a big bully. Look what it is doing to AOL Time Warner. It is slowly taking away all of the market that AOL has. It uses its programs, such as the OS and browser to make it difficult for users to select between it and the competitors. I am refering to the decision to drop JVM (which forces web applications developers to use MS' products), refusing to agree to let AOL place its icon on the desktop of new computers and etc.. At 07:16 PM 10/29/2001 -0800, you wrote: >No business could survive without being interested in $$$. And no sensible >business wouldn't be in it for the $$$. > >But to lump the souls of all members of a company into being interested in >only $$$ is foolish. I take it you've never been to a Macromedia-sponsored >event; met any of the amazing engineers, artists or designers that put these >products together. I absolutely know for a fact that 99% of the people that >work for Macromedia get up every morning wondering "what else can I do to >make this a more kick-ass product", not "how else can we suck more dollars >out of our customer's pockets without giving them something in return". > >I think you need to go read up on Capitalism a little more. It ain't that >bad. > > Kevin > >- Original Message - >From: "Stevens, Jason" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, October 29, 2001 6:19 PM >Subject: RE: Macromedia becoming another Microsoft > > > > Big business with a conscience? HA! I believe that is an oxymoron. > > > > It's all about the $$$, if they weren't in it for that they wouldn't be > > here. If they aren't in it for that, they won't be here for long. Believe >it > > or not, they don't try to make the best product out there and shove their > > proprietary standards down your throat because they want to make the world >a > > better place. It's all done in the name of the all might dollar. Dress it >up > > however you like. > > > > -Original Message- > > From: Thomas Smith [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 29, 2001 6:26 PM > > To: CF-Talk > > Subject: Re: Macromedia becoming another Microsoft > > > > > > I just read what I wrote. I meant Don't insult Macromedia. Macromedia > > would never > > become as bad as Microsoft. They have a councious (sp). > > > > At 07:18 PM 10/25/2001 -0700, you wrote: > > >Become another Microsoft? Don't insult Microsoft. > > > > > >This is hitting below the belt. > > > > > > > > ~~ 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
Re: Macromedia becoming another Microsoft
No business could survive without being interested in $$$. And no sensible business wouldn't be in it for the $$$. But to lump the souls of all members of a company into being interested in only $$$ is foolish. I take it you've never been to a Macromedia-sponsored event; met any of the amazing engineers, artists or designers that put these products together. I absolutely know for a fact that 99% of the people that work for Macromedia get up every morning wondering "what else can I do to make this a more kick-ass product", not "how else can we suck more dollars out of our customer's pockets without giving them something in return". I think you need to go read up on Capitalism a little more. It ain't that bad. Kevin - Original Message - From: "Stevens, Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 6:19 PM Subject: RE: Macromedia becoming another Microsoft > Big business with a conscience? HA! I believe that is an oxymoron. > > It's all about the $$$, if they weren't in it for that they wouldn't be > here. If they aren't in it for that, they won't be here for long. Believe it > or not, they don't try to make the best product out there and shove their > proprietary standards down your throat because they want to make the world a > better place. It's all done in the name of the all might dollar. Dress it up > however you like. > > -Original Message- > From: Thomas Smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 6:26 PM > To: CF-Talk > Subject: Re: Macromedia becoming another Microsoft > > > I just read what I wrote. I meant Don't insult Macromedia. Macromedia > would never > become as bad as Microsoft. They have a councious (sp). > > At 07:18 PM 10/25/2001 -0700, you wrote: > >Become another Microsoft? Don't insult Microsoft. > > > >This is hitting below the belt. > > > > ~~ 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
RE: Macromedia becoming another Microsoft
Big business with a conscience? HA! I believe that is an oxymoron. It's all about the $$$, if they weren't in it for that they wouldn't be here. If they aren't in it for that, they won't be here for long. Believe it or not, they don't try to make the best product out there and shove their proprietary standards down your throat because they want to make the world a better place. It's all done in the name of the all might dollar. Dress it up however you like. -Original Message- From: Thomas Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 6:26 PM To: CF-Talk Subject: Re: Macromedia becoming another Microsoft I just read what I wrote. I meant Don't insult Macromedia. Macromedia would never become as bad as Microsoft. They have a councious (sp). At 07:18 PM 10/25/2001 -0700, you wrote: >Become another Microsoft? Don't insult Microsoft. > >This is hitting below the belt. > ~~ 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: Macromedia becoming another Microsoft
I just read what I wrote. I meant Don't insult Macromedia. Macromedia would never become as bad as Microsoft. They have a councious (sp). At 07:18 PM 10/25/2001 -0700, you wrote: >Become another Microsoft? Don't insult Microsoft. > >This is hitting below the belt. > ~~ 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
Re: Setting field on form using Javascript
jsstringformat()
-Justin Scott, Lead Developer
Sceiron Internet Services, Inc.
http://www.sceiron.com
- Original Message -
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 7:45 PM
Subject: Setting field on form using Javascript
> Ok...I have a CF Form..and I'm opening a window which contains another
> CF Form.
>
> And I want to set a field on the first form to a value depending on what
> I select on the pop up.
>
> Now I can do this with ONE value, but I run into a problem.
>
> There is a descriptionf ield in the database which I also want to pass
> back to the main form. But this field has..well..descriptions. That
> include /, ",: and all sorts of other odd characters. So of course it is
> causing the Javascript to blow when I pass the values over.
>
> What can I do to get around this issue?
>
> "SelectThis(#SAP_IO_NBR#,'#SAP_IO_DESC#')">
>
> And the Javascript to set the field on the form is:
>
>
>
> function SelectThis(item,item2)
> {
>
> self.opener.document.Timeentry_billable.ordernum.value = item
> self.opener.document.Timeentry_billable.proj_desc.value = item2
> // close the window
> window.close();
>
> }
>
>
>
> Any ideas? :)
>
> -Gel
>
>
>
~~
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: Val :: IncrementValue by 01 NOT 1? how?
do something like
while (len(mynum) < 2) {
mynum = 0 & mynum;
}
basically prepend mynum with 0s until its 2 char long.
On
Mon, 29 Oct 2001, Paul Ihrig wrote:
> ok
> i can do this
>
>
>
>
>
>
>
>
> But how do i make it insert 01 instead of 1?
>
> -paul
>
~~
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: Subdomain of a domain
After all that it depends on what you want to do with the subdomain. A host record will only still point to an ip address. If you want the subdomain to resolve to a new webroot you will have to either use Host Header parsing via your web server settings or filter using CF on cgi.server_name and cflocation. Just an added thought. Thanks, Robert Filipovich - Original Message - From: "Lee Fuller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 3:20 PM Subject: RE: Subdomain of a domain > Larry, > > The "www" portion, as well as the "sales" portion, of the domain you > show in your question are called the "host" names. "Www.domain.com" > can, and often does, point to a different IP address from, for example, > "mail.domain.com". This allows traffic to be routed to different > programs or servers, so that the traffic can be handled appropriately. > > Basically, you CAN enter into your browser "http://mail.domain.com";. If > you did, you will, most likely, end up with an error, since that server > actually only handles email traffic, not web traffic. Different ports > (i.e., 80 for http traffic, 21 for FTP traffic, etc.) are being answered > by those different servers. Therefore, a port 80 request (i.e., > http://) will not be answered properly if sent to an email server (i.e., > mail.domain.com). > > You can name a host anything you like (within the boundaries of Internet > naming conventions.. i.e., no spaces or punctuation - save the hyphen > (-) or the underscore (_)). You could, for example, have > "this.is.my.server.at.my.domain.com". While this would turn into a > NIGHTMARE for DNS entry.. It could be done. The only requirement is > that you have all the information properly setup in the DNS server that > services "domain.com". > > Hope this helps. Is kinda lengthy, but thought it might help you > understand. Basically, in your exampe... "www.domain.com" could point > to "123.123.123.111", while "sales.domain.com" could point to > "123.123.123.222". They COULD both be web servers.. Or not. Just > depends on the type of traffic being sent to them... i.e., what they are > being used for. > > Take care... > > > Lee Fuller > Chief Technical Officer > PrimeDNA Corporation / AAA Web Hosting Corporation > "We ARE the net." > http://www.aaawebhosting.com > > > > > -Original Message- > > From: Larry Juncker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 29, 2001 12:04 PM > > To: CF-Talk > > Subject: OT: Subdomain of a domain > > > > > > Apologies for the OT but I am curious. > > > > I see a lot of times where someone has an address like > > www.mydomain.com and along with it, you see > reference to > > sales.mydomain.com > > > > My question is, do these people have two IP's associated with > > this domain or is this an entry in DNS that I am missing > > somewhere on how to set up? > > > > Just curious. > > > > Thanks and again apologies for the OT > > > > Larry Juncker > > Senior Cold Fusion Developer > > Heartland Communications Group, Inc. > > [EMAIL PROTECTED] > > > ~~ 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
Setting field on form using Javascript
Ok...I have a CF Form..and I'm opening a window which contains another
CF Form.
And I want to set a field on the first form to a value depending on what
I select on the pop up.
Now I can do this with ONE value, but I run into a problem.
There is a descriptionf ield in the database which I also want to pass
back to the main form. But this field has..well..descriptions. That
include /, ",: and all sorts of other odd characters. So of course it is
causing the Javascript to blow when I pass the values over.
What can I do to get around this issue?
And the Javascript to set the field on the form is:
function SelectThis(item,item2)
{
self.opener.document.Timeentry_billable.ordernum.value = item
self.opener.document.Timeentry_billable.proj_desc.value = item2
// close the window
window.close();
}
Any ideas? :)
-Gel
~~
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: Sort two-dimensional array
I didn't see all of the discussion on your problem, but there is a custom tag for sorting 2d arrays I got from the Allaire tag gallery. The tag was written by Andy Birchall and is titled ArrayTableSort.cfm. I had to do a little fixing for my use, but it's been great. Take a look on Allaire's site. === Tom Clark E-Commerce Application Developer Telect, Inc. Spokane, Washington I have plenty of talent and vision. I just don't care. The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. 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: Dynamically inserting text into Flash via Cold Fusion
You can easily pass in variables into a flash movie via the URL when you invoke the flash movie with the and tabs. You can also use the loadVariables method in actionScript. http://www.flashcfm.com/ has a number of tutorials that should help get you up and running. Cheers, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:04 PM To: CF-Talk Subject: Dynamically inserting text into Flash via Cold Fusion Does anyone know how to get a variable from CFSET or a query into a text box in Flash. Would like to be able to dynamically update the text in the Flash movie. Have looked around and found nothing so far that does a decent job on explaining this process. ~~ 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: Delaying template execution
> > > What would be the best way to dealy the execution of a cf > > > tamplate by x amount of seconds? > > > > Simplest way: > > > > > > > > > > > > > > > > > > > > > > > > > > Elapsed: #Elapsed#ms > > > > Of course, this will lock your entire session. Anything else > > trying to obtain a lock in that sessionwill also be delayed. > > That's not going to do anything. The TIMEOUT attribute of > CFLOCK doesn't specify the length that the lock will be held > open, just the length CF will wait before giving up when trying > to acquire the lock. D'oh! When I tested this with session management enabled, it did in fact take 5 seconds to execute, so I was clearly wrong on this one. I don't know that I'd want to use this to pause execution, but it does work as Rick advertised. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Delaying template execution
I have a free cfx if you want it. It simply call the windows sleep() function. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Brian Ferrigno" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 4:49 PM Subject: Delaying template execution > What would be the best way to dealy the execution of a cf tamplate by x > amount of seconds? > > I found CF_aSleep on the allaire dev exchange but would like to see what the > code looks like and hints in the right direction would be great. > > > > Brian Ferrigno > ~~ 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: Delaying template execution
I found the reason it wasn't working for me, on multiple servers. The application.cfm in my default test directory was set so that client and session management were both turned off. When I turned them on, the template worked just fine. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Brian Ferrigno <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 29 Oct 2001 17:44:35 -0500 Actually the code does work by creating a deadlock for the session and waits until a timeout occurs before page proscessing can begin again. At least that's what I think it's doing. I tested it out for what I needed and it appears to be functioning. But does this effect only this one user session? Will anyone other user trying to access this page be locked out of the protected section of the page? And does anyone know what the maximum TIMEOUT value can be for this cflock tag? or what is safe? Brian Ferrigno -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 5:37 PM To: CF-Talk Subject: RE: Delaying template execution > > What would be the best way to dealy the execution of a cf > > tamplate by x amount of seconds? > > Simplest way: > > > > > > > > > > > > > Elapsed: #Elapsed#ms > > Of course, this will lock your entire session. Anything else > trying to obtain a lock in that sessionwill also be delayed. That's not going to do anything. The TIMEOUT attribute of CFLOCK doesn't specify the length that the lock will be held open, just the length CF will wait before giving up when trying to acquire the lock. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Dynamically inserting text into Flash via Cold Fusion
I looked there, but none of the samples sufficiently explain the process or methodology behind how this process works. They offer ready made examples, but now the expo. on how it works. Any addl. pointers would be appreciated. Thanks, Pardeep. - Original Message - From: "Jim Priest" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 4:02 PM Subject: Re: Dynamically inserting text into Flash via Cold Fusion > Check out http://www.flashcfm.com > > Lots of tutorials and sample code. > > Jim > > On Monday, October 29, 2001, 6:03:46 PM, one wrote: > > olc> Does anyone know how to get a variable from CFSET or a query into a text box > olc> in Flash. > > olc> Would like to be able to dynamically update the text in the Flash movie. > ~~ 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: Dynamically inserting text into Flash via Cold Fusion
Check out http://www.flashcfm.com Lots of tutorials and sample code. Jim On Monday, October 29, 2001, 6:03:46 PM, one wrote: olc> Does anyone know how to get a variable from CFSET or a query into a text box olc> in Flash. olc> Would like to be able to dynamically update the text in the Flash movie. ~~ 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: CFPROCPARAM doesnt seem to work
Thanks Don! I dont need the single quotes, and I pass the '%' in the var and it works ;) My new stored proc: CREATE PROCEDURE sp_test @Company nvarchar(100) AS SELECT * FROM Clients WHERE Company LIKE @Company return My new cfprocparam: -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:32 PM To: CF-Talk Subject: Re: CFPROCPARAM doesnt seem to work A couple of things to try: 1. you don't need paren around @company in your stored proc declaration. 2. try taking the %'s out of the SQL statement and passing in @company='%whateverl%' In other words include the % with the variable you pass in. It may very well be interpretting @company as literal since it is in quotes. CREATE PROCEDURE sp_test @Company nvarchar(100) AS SELECT * FROM Clients WHERE Company LIKE '@Company' return - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 4:12 PM Subject: CFPROCPARAM doesnt seem to work > Hi all, > > Im working with stored procedures on MSSQL 7.0. I basically have everything > working right, but I cant get a string passed in to the stored proc > properly. > > My table (clients) has 2 records. I pass in the var @Company as a blank > string to return all recs, but I get nothing. I cant get it to return any > recs no matter what I assign @Company to. Its not breaking, its just not > getting any recs. > > The field "Company" in table "Clients" is data type of nvarchar(100), so I > made the stored proc var the same. By the way, I have successfully passed > in an int with no prob. > > Could the problem be cf is passing a varchar and not a nvarchar? > > Thanks for any help, > Jeff > > My stored proc: > > CREATE PROCEDURE sp_test > (@Company nvarchar(100)) > AS > SELECT * > FROM Clients > WHERE Company LIKE '%@Company%' > return > > > My code: > > returncode="Yes"> > value=""> > > > > > recordcount: #Companies.RecordCount# > > > > > ~~ 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: Determining Daylight Savings
He's referring to the one with his name on the cover. :-) -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 7:03 PM To: CF-Talk Subject: Re: Determining Daylight Savings > There would be no way to tell that just by the date - you would have to > have geographical data. in case you haven't bought ben's new advanced cf5 book *yet*, there's a decent (free) db for time zones at http://www.manifold.net/ which includes quite a large amount of spatial data... ~~ 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: Determining Daylight Savings
> There would be no way to tell that just by the date - you would have to > have geographical data. in case you haven't bought ben's new advanced cf5 book *yet*, there's a decent (free) db for time zones at http://www.manifold.net/ which includes quite a large amount of spatial data... ~~ 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
ODBC Errors
We have one NT server which intermittantly gets this error, after it times out after 30 seconds. Unable to instantiate environment for 'ODBC.' There are around 50 odbc links on the server and it can happen on any of them. The only solution seems to be to reboot the server. The MDAC is version 2.5 RTM. Has anyone seen this before? jon ~~ 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
Re: CFPROCPARAM doesnt seem to work
A couple of things to try: 1. you don't need paren around @company in your stored proc declaration. 2. try taking the %'s out of the SQL statement and passing in @company='%whateverl%' In other words include the % with the variable you pass in. It may very well be interpretting @company as literal since it is in quotes. CREATE PROCEDURE sp_test @Company nvarchar(100) AS SELECT * FROM Clients WHERE Company LIKE '@Company' return - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 4:12 PM Subject: CFPROCPARAM doesnt seem to work > Hi all, > > Im working with stored procedures on MSSQL 7.0. I basically have everything > working right, but I cant get a string passed in to the stored proc > properly. > > My table (clients) has 2 records. I pass in the var @Company as a blank > string to return all recs, but I get nothing. I cant get it to return any > recs no matter what I assign @Company to. Its not breaking, its just not > getting any recs. > > The field "Company" in table "Clients" is data type of nvarchar(100), so I > made the stored proc var the same. By the way, I have successfully passed > in an int with no prob. > > Could the problem be cf is passing a varchar and not a nvarchar? > > Thanks for any help, > Jeff > > My stored proc: > > CREATE PROCEDURE sp_test > (@Company nvarchar(100)) > AS > SELECT * > FROM Clients > WHERE Company LIKE '%@Company%' > return > > > My code: > > returncode="Yes"> > value=""> > > > > > recordcount: #Companies.RecordCount# > > > > > ~~ 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
CFPROCPARAM doesnt seem to work
Hi all, Im working with stored procedures on MSSQL 7.0. I basically have everything working right, but I cant get a string passed in to the stored proc properly. My table (clients) has 2 records. I pass in the var @Company as a blank string to return all recs, but I get nothing. I cant get it to return any recs no matter what I assign @Company to. Its not breaking, its just not getting any recs. The field "Company" in table "Clients" is data type of nvarchar(100), so I made the stored proc var the same. By the way, I have successfully passed in an int with no prob. Could the problem be cf is passing a varchar and not a nvarchar? Thanks for any help, Jeff My stored proc: CREATE PROCEDURE sp_test (@Company nvarchar(100)) AS SELECT * FROM Clients WHERE Company LIKE '%@Company%' return My code: recordcount: #Companies.RecordCount# ~~ 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: (sql) Getting Unique Max() Value
Here's a quick stabb at it: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, sum(auc_items.MAX_BID) as ItemMaxBid (SELECT Max(MAX_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS MaxBid, (SELECT Max(WINNING_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS CurrentBid FROMauc_bids, auc_items WHERE auc_bids.BIDDERS_ID = #session.BIDDERS_ID# AND auc_bids.ITEMS_ID = auc_items.ITEMS_ID GROUP BY auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, MaxBid Rick -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:49 PM To: CF-Talk Subject: (sql) Getting Unique Max() Value I'm working on a charity auction application. I have a page where I want to output all of a logged-in user's bids. The page needs to show the item bid on, the current bid, the user's max bid. Here's the SQL I've tried: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, (SELECT Max(MAX_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS MaxBid, (SELECT Max(WINNING_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS CurrentBid FROMauc_bids, auc_items WHERE auc_bids.BIDDERS_ID = #session.BIDDERS_ID# AND auc_bids.ITEMS_ID = auc_items.ITEMS_ID The problem is, the MaxBid, for example, all come out with the highest bid for all items bid on by this user. In other words, if the user bid $1,000 on Item A and $10 is his high bid on item B, Item B is still listed as having a high bid of $1,000. So I'm trying to figure out how to get a unique Max() value for each item as a separate item. H. ~~ 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
RE: Delaying template execution
Brian Ferrigno said: > the code does work by creating a deadlock for the session Deadlock, not race condition. Quite right. Too many Krispy Kremes for me. Point being, it blocks and *does not* spike your processor or anything lame like that. The only downside is that it blocks all other locks for that session. Of course, if you're using this for automated tasks, that's not really a problem. > But does this effect only this one user session? Yes. Session-level locking only affects that particular session. If you want to block everything to that page, you could use Application-level locking. (But that would block all the locks in the entire application!) > And does anyone know what the maximum TIMEOUT value can be > for this cflock tag? or what is safe? I've never read anything about maximum or safe values in relation to the tag. I would imagine that as long as you don't exceed your RequestTimeout parameter, you should be okay. I've attached code that illustrates the point. Both pages will lock for just about 5 seconds, even though only one of them has the deadlock code. The other blocks while trying to get a read-only lock. This works on my Intranet where the browser requests for the two sub-pages are essentially simultaneous, but if you're doing this over the Internet you may have to mess with it a bit. -R Elapsed: #Elapsed#ms Elapsed: #Elapsed#ms ~~ 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: delaying template execution
Hello Brian.
I briefly thought I wanted to accomplish something
along these lines recently and came up with the
following solution. I've left in some commented lines
that you can un-comment and output to see how many
times this loop'll run while it's hanging your
template execution. As the example reads, it'll hang
for 3 seconds. You could easily change that and/or set
it up as a custom tag to accept any number of seconds.
I wouldn't recommend using it too heavily. Hope this
helps.
x = 1;
// re-set the initial var to now() until it catches up
with the number of seconds to wait
while (DateCompare(started, finished, "s") LTE 0) {
started = now();
//writeoutput(x & "... still waiting ");
//x = IncrementValue(x);
}
-- Original Message
--
from: Brian Ferrigno <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 29 Oct 2001 16:49:47 -0500
What would be the best way to dealy the execution of a
cf tamplate by x
amount of seconds?
I found CF_aSleep on the allaire dev exchange but
would like to see
what the
code looks like and hints in the right direction would
be great.
Brian Ferrigno
~~
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: Sort two-dimensional array
What would you be sorting by?? In a two dimensional array each array element in the first level only contains a pointer to another array. I can only figure you want to sort by a specific item in the second dimension (i.e. an array of users where each array contains a sub-array of userinfo such as Fname, Lname, etc and you want to sort by Fname). In this case you should probably be using an array of structs, but no matter. If you need to sort then you should re-think the whole way this is structured. Perhaps using nested lists... Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] "What father would hesitate to say 'if there must be trouble let it be in my day, that my child may have peace'?" - Thomas Paine, An American Crisis -Original Message- From: Kevin Derby [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 20, 2001 10:37 PM To: CF-Talk Subject: Sort two-dimensional array Is it possible to sort a two-dimensional array, specifically by sorting on the first column while still retaining the second column's association with the first? There was something on Depressed Press, but I wasn't quite sure if/how it pertained to my predicament. Any help appreciated. TIA ~~ 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
(sql) Getting Unique Max() Value
I'm working on a charity auction application. I have a page where I want to output all of a logged-in user's bids. The page needs to show the item bid on, the current bid, the user's max bid. Here's the SQL I've tried: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, (SELECT Max(MAX_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS MaxBid, (SELECT Max(WINNING_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS CurrentBid FROMauc_bids, auc_items WHERE auc_bids.BIDDERS_ID = #session.BIDDERS_ID# AND auc_bids.ITEMS_ID = auc_items.ITEMS_ID The problem is, the MaxBid, for example, all come out with the highest bid for all items bid on by this user. In other words, if the user bid $1,000 on Item A and $10 is his high bid on item B, Item B is still listed as having a high bid of $1,000. So I'm trying to figure out how to get a unique Max() value for each item as a separate item. H. ~~ 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
Dynamically inserting text into Flash via Cold Fusion
Does anyone know how to get a variable from CFSET or a query into a text box in Flash. Would like to be able to dynamically update the text in the Flash movie. Have looked around and found nothing so far that does a decent job on explaining this process. ~~ 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: Delaying template execution
Actually the code does work by creating a deadlock for the session and waits until a timeout occurs before page proscessing can begin again. At least that's what I think it's doing. I tested it out for what I needed and it appears to be functioning. But does this effect only this one user session? Will anyone other user trying to access this page be locked out of the protected section of the page? And does anyone know what the maximum TIMEOUT value can be for this cflock tag? or what is safe? Brian Ferrigno -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 5:37 PM To: CF-Talk Subject: RE: Delaying template execution > > What would be the best way to dealy the execution of a cf > > tamplate by x amount of seconds? > > Simplest way: > > > > > > > > > > > > > Elapsed: #Elapsed#ms > > Of course, this will lock your entire session. Anything else > trying to obtain a lock in that sessionwill also be delayed. That's not going to do anything. The TIMEOUT attribute of CFLOCK doesn't specify the length that the lock will be held open, just the length CF will wait before giving up when trying to acquire the lock. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Val :: IncrementValue by 01 NOT 1? how?
Well this seems to work ~~ 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
RE: Delaying template execution
I tried this code and, on the first try, got an elapsed time of 30 ms. Subsequent fresh loads return 0 ms, and CF's debugging info tells me this: 0 ms C:\INETPUB\WWWROOT\TESTING\APPLICATION.CFM 0 ms C:\INETPUB\WWWROOT\TESTING\SLEEP.CFM 30 ms STARTUP, PARSING, & SHUTDOWN Changing the Sleep value yields no results. Its my understanding the CFLOCK timeout value is the amount of time the lock will be *attempted* before the lock attempt fails, not the amount of time it'll hold. Am I missing something? --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: "Rick Osborne [Mojo]" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 29 Oct 2001 17:08:57 -0500 Brian Ferrigno asked: > What would be the best way to dealy the execution of a cf > tamplate by x amount of seconds? Simplest way: Elapsed: #Elapsed#ms Of course, this will lock your entire session. Anything else trying to obtain a lock in that sessionwill also be delayed. -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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: Sort two-dimensional array
I don't think you can do it easily. My approach if using CF5 would probably be to convert the array into a query and then run a query-of-query on that query to re-order, then convert the query back into an array. If using CF4.5, I'd take a copy of the array, sort the copy of the array on the first column, then run through the sorted array filling the second column for each row by grabbing the correct value out of the first array indexed by the first column in the the sorted array. Clear as mud ? At 06:37 PM 10/21/2001, you wrote: >Is it possible to sort a two-dimensional array, specifically by sorting on >the first column while still retaining the second column's association with >the first? > >There was something on Depressed Press, but I wasn't quite sure if/how it >pertained to my predicament. > >Any help appreciated. -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ 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
RE: Delaying template execution
Brian Ferrigno asked: > What would be the best way to dealy the execution of a cf > tamplate by x amount of seconds? Simplest way: Elapsed: #Elapsed#ms Of course, this will lock your entire session. Anything else trying to obtain a lock in that sessionwill also be delayed. -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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: Val :: IncrementValue by 01 NOT 1? how?
Hi Paul, If all your project num is like you said:900166.11 900166.12 900168.00 900170.19 901007.02 901013.00 Not 900166.12.002.001 I would use: #valNum# This will get 90016612 #newNum# This will give you 90016613 Then insert the dot back . Otherwise as you have done you could continue with : #num# This will give 4 , then you can put it back to the lastNumber. HTH Sima -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:33 PM To: CF-Talk Subject: RE: Val :: IncrementValue by 01 NOT 1? how? Sima i grabed the last number after the "." apendad it by 1 then grabed the first set of numbers manualy added the periond, then the last 2 digits & re inswerted it into the table. i thought i was treating the last number as a string? if i use increment value it always put in 1 which = .1 not .01 most my numbers in my origional table are Project_Num_Number 900166.11 900166.12 900168.00 900170.19 901007.02 901013.00 so if it is .00 i need .01 if .19 then i need .20 to make it even funner sone project numbers have 900170.19.56 2 deciamal places. thank you -paul -Original Message- From: Sima Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:26 PM To: CF-Talk Subject: RE: Val :: IncrementValue by 01 NOT 1? how? Hi Paul, Can you treat the lastnumber as a string again and take the last number of the lastNumber and increase it? Or: Did you try to take off all the "." and treat it as a number increase it by 1, then insert the dot back. Of course you have to remember how many dots you have took off and the positions in the string. HTH Sima -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:27 PM To: CF-Talk Subject: Val :: IncrementValue by 01 NOT 1? how? ok i can do this But how do i make it insert 01 instead of 1? -paul ~~ 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
Delaying template execution
What would be the best way to dealy the execution of a cf tamplate by x amount of seconds? I found CF_aSleep on the allaire dev exchange but would like to see what the code looks like and hints in the right direction would be great. Brian Ferrigno ~~ 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
Creating Stored procedures on AS400
Forgive me if this is OT but I noticed there were some people using stored procs with the 400. I use 400 data and SQL Server, Most of my calls to the SQL Server are in stored procs, I would like to do the same with our AS400 which runs DB2. Could anyone point me to a stored procedure example from the 400 so that I could show it to my 400 programmer? Thanks for the help, Daron Smith 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: session cookies for CFID & CFTOKEN
I actually wrote a custom tag for this sort of thing. Keeps track of the client and also you can set it to not write a cookie to the client drive when they leave. You can get the tag from my site http://www.xcreation.com/apps.cfm Anthony Petruzzi http://www.xcreation.com/rip747 MSCE MCP+I [EMAIL PROTECTED] >From: "Pannkuk, Nathan S." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: session cookies for CFID & CFTOKEN >Date: Mon, 29 Oct 2001 10:53:41 -0900 > >Chris- >Someone please tell me if I'm wrong, but I don't believe you need to use >cfcookie at all. You should be able to use CFID and CFTOKEN as session >variables that will be stored in the server's RAM until you expire them. >CFID and CFTOKEN will be set automatically with sessionmanagement set to >"Yes". This should work even if the client has disabled cookies. >-Nathan > > >-Original Message- >From: Chris Norloff [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 29, 2001 10:45 AM >To: CF-Talk >Subject: session cookies for CFID & CFTOKEN > > >Our customer has discovered the CFID & CFTOKEN cookies, again, and gotten >upset, again. We're being gigged on "persistent cookies" and how there's >not supposed to be any tracking going on. > >Besides the obvious bit about CFID & CFTOKEN not being anti-privacy >tracking >information, I thought I'd try session cookies (expiring at the end of the >browser session). > >So I set setclientcookies to no, and used the client CFID & CFTOKEN vars to >set my own cookies that expire at the end of the session (see code below). > >This seems simple and robust - anyone have any comments or concerns? > >thanks, >Chris Norloff >Dangerous Persistent-Cookie-Setter > > > sessionmanagement="Yes" > sessiontimeout="#CreateTimeSpan(2,0,0,0)#" > applicationtimeout="#CreateTimeSpan(1,0,0,0)#" > setclientcookies="No" > clientmanagement="Yes" > > > > > ~~ 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: Val :: IncrementValue by 01 NOT 1? how?
Sima i grabed the last number after the "." apendad it by 1 then grabed the first set of numbers manualy added the periond, then the last 2 digits & re inswerted it into the table. i thought i was treating the last number as a string? if i use increment value it always put in 1 which = .1 not .01 most my numbers in my origional table are Project_Num_Number 900166.11 900166.12 900168.00 900170.19 901007.02 901013.00 so if it is .00 i need .01 if .19 then i need .20 to make it even funner sone project numbers have 900170.19.56 2 deciamal places. thank you -paul -Original Message- From: Sima Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:26 PM To: CF-Talk Subject: RE: Val :: IncrementValue by 01 NOT 1? how? Hi Paul, Can you treat the lastnumber as a string again and take the last number of the lastNumber and increase it? Or: Did you try to take off all the "." and treat it as a number increase it by 1, then insert the dot back. Of course you have to remember how many dots you have took off and the positions in the string. HTH Sima -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:27 PM To: CF-Talk Subject: Val :: IncrementValue by 01 NOT 1? how? ok i can do this But how do i make it insert 01 instead of 1? -paul ~~ 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
Re: CFmail Recount
> Actually, the system I described works on jobs of ~200,000 mails. I think > we run ~20,000 mails per hour, if memory serves. Yeah, that would take 20 > hours to process your list of 400,000, but then that's the price we pay for > using CF for bulk mail, eh? :) Sounds interesting. . .I'll look into it. Yes, that's the price we pay, but I also have sitting here email software that costs more than a luxury automobile and can deliver millions of messages that can't do the line-item billing the way that I can with ColdFusion and SQL Server. ;-) tom ~~ 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: Val :: IncrementValue by 01 NOT 1? how?
Hi Paul, Can you treat the lastnumber as a string again and take the last number of the lastNumber and increase it? Or: Did you try to take off all the "." and treat it as a number increase it by 1, then insert the dot back. Of course you have to remember how many dots you have took off and the positions in the string. HTH Sima -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:27 PM To: CF-Talk Subject: Val :: IncrementValue by 01 NOT 1? how? ok i can do this But how do i make it insert 01 instead of 1? -paul ~~ 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
RE: cflocation not working
I'd be willing to bet that something is simply broken in the logic, now that you've moved it. Unfortunately, the best way to solve this is to break the code into pieces, and see what part stops it from executing properly. Don't have a 'magic bullet' for ya.. Sorry. :( Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Douglas Jordon [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 12:46 PM > To: CF-Talk > Subject: Re: cflocation not working > > > Thanks. > > It works when I create a file like that with either an > absolute or relative url, but the original page that > processes a form will not work. I had thought it was a > separate issues, but besides the cflocation the queries > before aren't executing although they are being passed the > correct parameters. > > It worked on the old server. > > Lee Fuller wrote: > > > So if you create a new page on your server, and put in just this one > > line: > > > > http://www.aaawebhosting.com";> > > > > What happens? > ~~ 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: cflocation not working
Somehow a link to a .css file got in there and that's what was doing it. Thanks again. All's well. Lee Fuller wrote: > So if you create a new page on your server, and put in just this one > line: > > http://www.aaawebhosting.com";> > > What happens? > > Lee Fuller > Chief Technical Officer > PrimeDNA Corporation / AAA Web Hosting Corporation > "We ARE the net." > http://www.aaawebhosting.com > ~~ 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: CFmail Recount
Tom Muck said: > That would be good for small jobs, but I need to take jobs > of 400,000 Actually, the system I described works on jobs of ~200,000 mails. I think we run ~20,000 mails per hour, if memory serves. Yeah, that would take 20 hours to process your list of 400,000, but then that's the price we pay for using CF for bulk mail, eh? :) -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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: cf to excel formatting problem
thinking aloud. 1) export / import as a text field 2) single quote at the front of the field How are you importing / exporting? Eric Dawson From: Nathan Shaw <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: cf to excel formatting problem Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST) I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate = Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ~~ 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: CFmail Recount
> We had a similar problem and got around it by making our code smart enough > to only spool mail if there is less than 200 files in the spool directory. > Otherwise, it waits a minute and tries again. Sure, you may not be getting > optimal efficiency out of your mail spool, but you're also not crashing the > server. :) That would be good for small jobs, but I need to take jobs of 400,000 and break them into batches of 60,000 so that CF can work with it. We haven't had many problems other than the fact that we can only deliver 24,000 per hour to the mail server. I'm working on a method to deliver the emails directly to the mail server and bypass the CF spool directory entirely. tom ~~ 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
Re: Determining Daylight Savings
Here's a tag I did for myself that doesn't take into account the time of day. It takes as an argument a date and returns TRUE or FALSE. Taking into accont the time of day would be simple, just by adding to the begin date/time a time offset of 2:00am and then doing the same with the end date/time (on the last Sunday, rather than the last Saturday of October, i.e. remove the "- 1"). Jim - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 9:28 AM Subject: Determining Daylight Savings > Hello, > > I have an issue that others may be running into or have solved. I am > posting a series of events with their date, time, and time zone, i.e. > EST. Is there a custom tag or UDF that will return whether a > date/time is in Daylight Savings or not? It would need to work like > the parameter isDSTon from GetTimeZoneInfo() but allow a date to be > passed in. Any advice? > > Thank you, > ~~ 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: session cookies for CFID & CFTOKEN
> Our customer has discovered the CFID & CFTOKEN cookies, > again, and gotten upset, again. We're being gigged on > "persistent cookies" and how there's not supposed to be any > tracking going on. > > Besides the obvious bit about CFID & CFTOKEN not being > anti-privacy tracking information, I thought I'd try session > cookies (expiring at the end of the browser session). > > So I set setclientcookies to no, and used the client CFID & > CFTOKEN vars to set my own cookies that expire at the end of > the session (see code below). > > This seems simple and robust - anyone have any comments or concerns? Only one - your code will reset the cookie on each page request. For those who have their browsers set to warn them of each cookie being set, this may become annoying. You could simply wrap the CFCOOKIEs within a conditional test. > Chris Norloff > Dangerous Persistent-Cookie-Setter Now, that's a job title! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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
RE: *** Complicated SQL riddle
Actually, One person did the hard work so we don't have to :) http://www.codebits.com/ntm/ Also check here: http://www.intelligententerprise.com/001020/celko.shtml Dave Medinets has written a set of "proof of concept" stored procedures. They cover Inserting, Deleting, and yes even MOVING nodes around the tree. Moving properly handles moving all sub children to any place within an NTM tree. Another advantage that causes the tree to mimic your more traditional Ye old computer science text book N-Ary tree is that there is an implied ordering to all nodes in the tree, whereas with the old employee/boss trick there is no implied order. (I like calling the employee/boss relationship the Parent-Child model) I would bore you guys with stored procedures I have written but there is no need. I have also adapted the stored procedures found at the URL for a production environment. Take a look at them and you wont really need to figure out how it works unless your bored. The Celko book explains how it works in words infinitely easier to grasp than my own words. Not to sound like a parrot but the model really does work and while it may be a little tricky it is just a case of basic logic that a good afternoon of stored procedure coding and adapting can cure. For a fun thought of the day, try implementing N-Ary trees in JavaScript :) Thanks Jeremy Allen elliptIQ Inc. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:28 PM To: CF-Talk Subject: Re: *** Complicated SQL riddle Hey Jeremy, While pulling data out of the nested set model is easy, getting it in is not so easy. Care to throw out some examples of that? -D Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ 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: CFmail Recount
I said: >> We had a similar problem and got around it by making our code smart enough >> to only spool mail if there is less than 200 files in the spool directory. >> Otherwise, it waits a minute and tries again. Sure, you may not be getting >> optimal efficiency out of your mail spool, but you're also not crashing the >> server. :) Bryant Tyson asked: > Now that sounds like the perfect good fix. How easy was it to code and did > you use any custom tags? I'm wondering if it's something that's within my > coding capabilities. It was actually pretty simple. We have a script that uses CFSCHEDULE to enable/disable a job that runs once a minute. It calls a script that does the following things: 1. Check the mail spool. If the FileCount GT 250 (or some number) just CFABORT and wait for the next call. 2. Process the queue, which is just a db table full of the outgoing mail. If there are any entries, throw about 1000 into the spool. (You can write to the spool with CFFILE, or use CFMAIL. Both work.) Bail Out. 3. If the queue is empty, use CFSCHEDULE to delete the job. You may want to turn off HTTP logging for the directory that script is in. :) -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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
Re: cflocation not working
Thanks. It works when I create a file like that with either an absolute or relative url, but the original page that processes a form will not work. I had thought it was a separate issues, but besides the cflocation the queries before aren't executing although they are being passed the correct parameters. It worked on the old server. Lee Fuller wrote: > So if you create a new page on your server, and put in just this one > line: > > http://www.aaawebhosting.com";> > > What happens? ~~ 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: Subdomain of a domain
no one IP will do it... in your web server you can set each one up... the thing with DNS is most people handle it there if they have access to DNS... so they define separate A-Records for each... you could define one as *.domain.extension... then just use cold fusion to rip them to the right directory.. masking the real url by using a hidden frame technique... -paris -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 15:04 To: CF-Talk Subject: OT: Subdomain of a domain Apologies for the OT but I am curious. I see a lot of times where someone has an address like www.mydomain.com and along with it, you see reference to sales.mydomain.com My question is, do these people have two IP's associated with this domain or is this an entry in DNS that I am missing somewhere on how to set up? Just curious. Thanks and again apologies for the OT Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ 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
RE: session cookies for CFID & CFTOKEN
That would work for storing CFID & CFTOKEN somewhere, but how then is the client identified each time he comes back during the session? Is there a "hidden" cookie (session cookie) that CF uses to identify the browser if it doesn't set the regular cookies? thx Chris Norloff -- Original Message -- from: "Pannkuk, Nathan S." <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 29 Oct 2001 10:53:41 -0900 >Chris- >Someone please tell me if I'm wrong, but I don't believe you need to use >cfcookie at all. You should be able to use CFID and CFTOKEN as session >variables that will be stored in the server's RAM until you expire them. >CFID and CFTOKEN will be set automatically with sessionmanagement set to >"Yes". This should work even if the client has disabled cookies. >-Nathan > > >-Original Message- >From: Chris Norloff [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 29, 2001 10:45 AM >To: CF-Talk >Subject: session cookies for CFID & CFTOKEN > > >Our customer has discovered the CFID & CFTOKEN cookies, again, and gotten >upset, again. We're being gigged on "persistent cookies" and how there's >not supposed to be any tracking going on. > >Besides the obvious bit about CFID & CFTOKEN not being anti-privacy tracking >information, I thought I'd try session cookies (expiring at the end of the >browser session). > >So I set setclientcookies to no, and used the client CFID & CFTOKEN vars to >set my own cookies that expire at the end of the session (see code below). > >This seems simple and robust - anyone have any comments or concerns? > >thanks, >Chris Norloff >Dangerous Persistent-Cookie-Setter > > > sessionmanagement="Yes" > sessiontimeout="#CreateTimeSpan(2,0,0,0)#" > applicationtimeout="#CreateTimeSpan(1,0,0,0)#" > setclientcookies="No" > clientmanagement="Yes" >> > > > ~~ 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
Val :: IncrementValue by 01 NOT 1? how?
ok i can do this But how do i make it insert 01 instead of 1? -paul ~~ 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: Determining Daylight Savings
There would be no way to tell that just by the date - you would have to have geographical data. Note: Daylight Saving Time, for the U.S. and its territories, is NOT observed in Hawaii, American Samoa, Guam, Puerto Rico, the Virgin Islands, the Eastern Time Zone portion of the State of Indiana, and the state of Arizona. The Navajo Nation, which is mostly in Arizona, also participates in the Daylight Saving Time policy, due to its large size and location in three other states which DO observe it. I heard that Sonora, MX is now on DST, FWIW. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 11:29 AM To: CF-Talk Subject: Determining Daylight Savings Hello, I have an issue that others may be running into or have solved. I am posting a series of events with their date, time, and time zone, i.e. EST. Is there a custom tag or UDF that will return whether a date/time is in Daylight Savings or not? It would need to work like the parameter isDSTon from GetTimeZoneInfo() but allow a date to be passed in. Any advice? Thank you, ~~ 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: cflocation not working
So if you create a new page on your server, and put in just this one line: http://www.aaawebhosting.com";> What happens? Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Douglas Jordon [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 12:20 PM > To: CF-Talk > Subject: cflocation not working > > > We just migrated to a new server running CF 5 on Win 2000. > Now cflocation is not working, and I'm a dummy about server admin. > > Anyone ever encounter this? > > TIA, > > Doug JOrdon > ~~ 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: *** Complicated SQL riddle
Hey Jeremy, While pulling data out of the nested set model is easy, getting it in is not so easy. Care to throw out some examples of that? -D Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ 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
Character removal
I need to create a select form displaying street names that are queried from a database. I am able to remove the street number using the following in my SQL statement: substring ([a_PROPERTY_ADDRESS],7,50) AS street. However the street names have a lot of extra text after the name, making 1 street show up many times. SELECT substring([a_PROPERTY_ADDRESS],7,50) AS street FROM commercial ORDER BY substring([a_PROPERTY_ADDRESS],7,50) #street# The problem I am having is that most street names have extra data attached. Below is a list of the first 10 or so rows of data returned. Taking into consideration my data looks like this, is there a way to split the the string after ST, WAY, RD, DR, SE, etc..? ABBOTT ST NW AERIAL WAY DR SW W AIRPORT RD NW AIRPORT RDNW D NW AIRPORT RDNW NW AIRPORT RDNW V NW ALLEN RD SE KWY ALBEMARLE (15) AV SW ALBEMARLE 321 AV SW I need to display: ABBOTT ST AERIAL WAY DR AIRPORT RD ALLEN RD ALBEMARLE AV etc... I'm not sure how to remove the extra text after the street name since all strings have a different length. Thanks, W. Shannon Carr [EMAIL PROTECTED] ~~ 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
RE: CFmail Recount
On Mon, 29 Oct 2001, Rick Osborne [Mojo] wrote: > Tom muck said: > > > Unfortunately, ColdFusion doesn't give us the option to split the > > spool directory into mulitple directories, so the server will > > automatically write all the spool files out to that directory up to > > 65,535 files before crapping out. Then it only sifts through them at > > the rate of 400 per minute. > > We had a similar problem and got around it by making our code smart enough > to only spool mail if there is less than 200 files in the spool directory. > Otherwise, it waits a minute and tries again. Sure, you may not be getting > optimal efficiency out of your mail spool, but you're also not crashing the > server. :) Now that sounds like the perfect good fix. How easy was it to code and did you use any custom tags? I'm wondering if it's something that's within my coding capabilities. - Bryant > One caveat, tho. There is a known bug in CF4.x (fixed in CF5) that will > occasionally create a zero-byte file in the mail spool. Upon trying to read > this file, your cf server will go down *hard*. If you bring up the server > again without deleting the file, it will just crash again. I talked to > Allaire support about it last week at DevCon and they admitted that they > hadn't been able to even figure out what was causing it, much less provide a > permanent fix for it. They've worked around it in CF5 by doing a size test > against each file before it is read, but they are *not* planning on > retro-ing the fix back to 4.x. Their advice was to write a daemon in > something other than CF that periodically checked the spool file for > zero-byte files and deleted them. Also check to see if your CF server has > already crashed and restart it. That's a bit out of the range of the > majority of their customers, but that was their solution. > > -R > > Rick Osborne > Certified Advanced ColdFusion 5 Developer ~~ 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: Subdomain of a domain
Larry, The "www" portion, as well as the "sales" portion, of the domain you show in your question are called the "host" names. "Www.domain.com" can, and often does, point to a different IP address from, for example, "mail.domain.com". This allows traffic to be routed to different programs or servers, so that the traffic can be handled appropriately. Basically, you CAN enter into your browser "http://mail.domain.com";. If you did, you will, most likely, end up with an error, since that server actually only handles email traffic, not web traffic. Different ports (i.e., 80 for http traffic, 21 for FTP traffic, etc.) are being answered by those different servers. Therefore, a port 80 request (i.e., http://) will not be answered properly if sent to an email server (i.e., mail.domain.com). You can name a host anything you like (within the boundaries of Internet naming conventions.. i.e., no spaces or punctuation - save the hyphen (-) or the underscore (_)). You could, for example, have "this.is.my.server.at.my.domain.com". While this would turn into a NIGHTMARE for DNS entry.. It could be done. The only requirement is that you have all the information properly setup in the DNS server that services "domain.com". Hope this helps. Is kinda lengthy, but thought it might help you understand. Basically, in your exampe... "www.domain.com" could point to "123.123.123.111", while "sales.domain.com" could point to "123.123.123.222". They COULD both be web servers.. Or not. Just depends on the type of traffic being sent to them... i.e., what they are being used for. Take care... Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Larry Juncker [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 12:04 PM > To: CF-Talk > Subject: OT: Subdomain of a domain > > > Apologies for the OT but I am curious. > > I see a lot of times where someone has an address like > www.mydomain.com and along with it, you see > reference to > sales.mydomain.com > > My question is, do these people have two IP's associated with > this domain or is this an entry in DNS that I am missing > somewhere on how to set up? > > Just curious. > > Thanks and again apologies for the OT > > Larry Juncker > Senior Cold Fusion Developer > Heartland Communications Group, Inc. > [EMAIL PROTECTED] > ~~ 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
cflocation not working
We just migrated to a new server running CF 5 on Win 2000. Now cflocation is not working, and I'm a dummy about server admin. Anyone ever encounter this? TIA, Doug JOrdon ~~ 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
RE: Subdomain of a domain
You could have two IPs bound to it but it's not needed. All you have to do is create the record in DNS. Thank you, Dan Phillips Lead Support Technician\ColdFusion Administrator Express Technologies, Inc. dba Halfpricehosting.com dba CFXhosting.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:04 PM To: CF-Talk Subject: OT: Subdomain of a domain Apologies for the OT but I am curious. I see a lot of times where someone has an address like www.mydomain.com and along with it, you see reference to sales.mydomain.com My question is, do these people have two IP's associated with this domain or is this an entry in DNS that I am missing somewhere on how to set up? Just curious. Thanks and again apologies for the OT Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ 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: Subdomain of a domain
>> My question is, do these people have two IP's associated with this domain or >> is this an entry in DNS >> that I am missing somewhere on how to set up? You can do it either way, with or with out two IP's, but the easiest way is to just create a DNS record that points to the same IP address, and then just use your web server to do the mapping to the sub domain name. IIS uses host pointer records that you configure in the properties and makes it very, very easy to do. Bill K. ~~ 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
OT: Subdomain of a domain
Apologies for the OT but I am curious. I see a lot of times where someone has an address like www.mydomain.com and along with it, you see reference to sales.mydomain.com My question is, do these people have two IP's associated with this domain or is this an entry in DNS that I am missing somewhere on how to set up? Just curious. Thanks and again apologies for the OT Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ 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
threeselectsrelated
Does anyone have an updated version of the tag? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ~~ 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: CFSchedule
On 10/29/01, [EMAIL PROTECTED] penned: >Quick question for you, I ran into an interesting note when reading through > the documentation for this tag. > > Note You cannot use CFSCHEDULE and apply the Secure Sockets Layer > (SSL) to your application. > >Do I take this to mean I can not schedule my intranet application which >uses SSL to execute CF pages in the middle of the night? Are there ways >around this, such as a custom tag of some sort? I have templates running through https from my scheduler. Just make sure you enter 443 as the port. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: downloading images
Link the thumbnail to a page that opens with the large image, and in that page have some sort of CFFile/CFContent code perhaps? -Gel -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Hey, I'd like users to be able to download images from on my site. The images are pretty big, so i've made thumbnails for each. I can display each thumbnail, but how can i get it so that once the user clicks on the thumbnail, they get to download the whole image. I'd like it to work without having the user to right click and choose 'save image as'. Any ideas?! Thanks, Heidi = Heidi Belal ICQ# 32127109 ~~ 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: session cookies for CFID & CFTOKEN
Chris- Someone please tell me if I'm wrong, but I don't believe you need to use cfcookie at all. You should be able to use CFID and CFTOKEN as session variables that will be stored in the server's RAM until you expire them. CFID and CFTOKEN will be set automatically with sessionmanagement set to "Yes". This should work even if the client has disabled cookies. -Nathan -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:45 AM To: CF-Talk Subject: session cookies for CFID & CFTOKEN Our customer has discovered the CFID & CFTOKEN cookies, again, and gotten upset, again. We're being gigged on "persistent cookies" and how there's not supposed to be any tracking going on. Besides the obvious bit about CFID & CFTOKEN not being anti-privacy tracking information, I thought I'd try session cookies (expiring at the end of the browser session). So I set setclientcookies to no, and used the client CFID & CFTOKEN vars to set my own cookies that expire at the end of the session (see code below). This seems simple and robust - anyone have any comments or concerns? thanks, Chris Norloff Dangerous Persistent-Cookie-Setter ~~ 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
CFSchedule
Hello everyone - Quick question for you, I ran into an interesting note when reading through the documentation for this tag. Note You cannot use CFSCHEDULE and apply the Secure Sockets Layer (SSL) to your application. Do I take this to mean I can not schedule my intranet application which uses SSL to execute CF pages in the middle of the night? Are there ways around this, such as a custom tag of some sort? Thanks for your input, Casey Cook ~~ 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: Val :: manipulating strings as numbers
thanks Don. my problem is reinserting the number now.. #firstnumber#.#lastnumber# i need to re insert the . period i have tried '.', ".", #.# +.+ With no luck any ideas? thank you -paul -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 9:34 AM To: CF-Talk Subject: Re: Val :: manipulating strings as numbers Do you mean select the highest number before the first dot and increment the number after the last dot? If so treat the number as a list and have firstnumber=listfirst(project_Num_number,".") lastnumber=listlast(projet_num_number,".") you can then find the max firstnumber and increment the last number If you have to check more than the first number I would suggest using listtoarray with a delimitter of "." and manipulating that - Original Message - From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 6:51 AM Subject: Val :: manipulating strings as numbers > ok i am having some problems trying to figure out how to do this > > i have all these project numbers, but they are not real numbers, but text. > like > > Project_Num_Number > 50001.01 > 500020.07.01 > 500051.02.03 > 98.01 > 99.00 > > in each case i need to select the highest number > then add one 1 to insert as a new number for that field. > > the way it is right now, my where stament are not selecting the right range. > it did work prevously when i had the Project_Num_Number fieeld converted to > number field in access. > > WHERE Val(Project_Num_Number) < 1351103 > WHERE Val(Project_Num_Number) < 60 > WHERE Val(Project_Num_Number) < 98.00 > > right now they are only selecting 9 reange for all categories & it is > incrementing by 1 > but if the highest number for that section is > 98.02 i need it to do 98.03 NOT 99 > > > if you have any idea what i need to do i would appreciate the help. > > thank you > > -paul > > > > > > SELECT Project_Num_Number > FROM tbl_project_num_Link > WHERE Val(Project_Num_Number) < 1351103 > ORDER BY Project_Num_Number DESC > > > > > > > SELECT Project_Num_Number > FROM tbl_project_num_Link > WHERE Val(Project_Num_Number) < 60 > ORDER BY Project_Num_Number DESC > > > > > > > > SELECT Project_Num_Number > FROM tbl_project_num_Link > WHERE Val(Project_Num_Number) < 98.00 > ORDER BY Project_Num_Number DESC > > > > > ~~ 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
session cookies for CFID & CFTOKEN
Our customer has discovered the CFID & CFTOKEN cookies, again, and gotten upset, again. We're being gigged on "persistent cookies" and how there's not supposed to be any tracking going on. Besides the obvious bit about CFID & CFTOKEN not being anti-privacy tracking information, I thought I'd try session cookies (expiring at the end of the browser session). So I set setclientcookies to no, and used the client CFID & CFTOKEN vars to set my own cookies that expire at the end of the session (see code below). This seems simple and robust - anyone have any comments or concerns? thanks, Chris Norloff Dangerous Persistent-Cookie-Setter ~~ 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
RE: CFmail Recount
I just hope it is fixed in CF5. By applying file size check, does that prevent data loss. One of the big problems I've had with that bug is there is no way to recover the data the zero byte file was supposed to contain. Assuming that's an important message from a client, that data loss is unacceptable. Just placing some "if zero byte, then delete" logic dosn't really solve that problem. Besides, the spooler dosn't have any error correction on it. Malformatted e-mail will crash the spooler and spike the processor (contrary to the CF5 release notes). I'm glad you posted this. I spoke with MM support endlessly about this. Their suggestion -> upgrade to a zero release. No, thank you. EC -Original Message- From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 2:17 PM To: CF-Talk Subject: RE: CFmail Recount Tom muck said: > Unfortunately, ColdFusion doesn't give us the option to split the > spool directory into mulitple directories, so the server will > automatically write all the spool files out to that directory up to > 65,535 files before crapping out. Then it only sifts through them at > the rate of 400 per minute. We had a similar problem and got around it by making our code smart enough to only spool mail if there is less than 200 files in the spool directory. Otherwise, it waits a minute and tries again. Sure, you may not be getting optimal efficiency out of your mail spool, but you're also not crashing the server. :) One caveat, tho. There is a known bug in CF4.x (fixed in CF5) that will occasionally create a zero-byte file in the mail spool. Upon trying to read this file, your cf server will go down *hard*. If you bring up the server again without deleting the file, it will just crash again. I talked to Allaire support about it last week at DevCon and they admitted that they hadn't been able to even figure out what was causing it, much less provide a permanent fix for it. They've worked around it in CF5 by doing a size test against each file before it is read, but they are *not* planning on retro-ing the fix back to 4.x. Their advice was to write a daemon in something other than CF that periodically checked the spool file for zero-byte files and deleted them. Also check to see if your CF server has already crashed and restart it. That's a bit out of the range of the majority of their customers, but that was their solution. -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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
RE: downloading images
Here's a tag out of the developers exchange that might solve your problem cf_downloadit http://devex.allaire.com/developer/gallery/info.cfm?ID=B5C886CD-55FF-11D5-83 F000508B94F85A&method=Full Jason Larson [EMAIL PROTECTED] -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 11:47 AM To: CF-Talk Subject: downloading images Hey, I'd like users to be able to download images from on my site. The images are pretty big, so i've made thumbnails for each. I can display each thumbnail, but how can i get it so that once the user clicks on the thumbnail, they get to download the whole image. I'd like it to work without having the user to right click and choose 'save image as'. Any ideas?! Thanks, Heidi = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: downloading images
Why don't you just do something like this : ? Steve On Mon, 29 Oct 2001, Heidi Belal wrote: > Hey, > I'd like users to be able to download images from on > my site. The images are pretty big, so i've made > thumbnails for each. I can display each thumbnail, > but how can i get it so that once the user clicks on > the thumbnail, they get to download the whole image. > I'd like it to work without having the user to right > click and choose 'save image as'. > Any ideas?! > Thanks, > Heidi > > = > Heidi Belal > ICQ# 32127109 > > A bus stops at a bus station. > A train stops at a train station. On my desk > I have a work station... > > > ~~ 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: CFmail Recount
Tom muck said: > Unfortunately, ColdFusion doesn't give us the option to split the > spool directory into mulitple directories, so the server will > automatically write all the spool files out to that directory up to > 65,535 files before crapping out. Then it only sifts through them at > the rate of 400 per minute. We had a similar problem and got around it by making our code smart enough to only spool mail if there is less than 200 files in the spool directory. Otherwise, it waits a minute and tries again. Sure, you may not be getting optimal efficiency out of your mail spool, but you're also not crashing the server. :) One caveat, tho. There is a known bug in CF4.x (fixed in CF5) that will occasionally create a zero-byte file in the mail spool. Upon trying to read this file, your cf server will go down *hard*. If you bring up the server again without deleting the file, it will just crash again. I talked to Allaire support about it last week at DevCon and they admitted that they hadn't been able to even figure out what was causing it, much less provide a permanent fix for it. They've worked around it in CF5 by doing a size test against each file before it is read, but they are *not* planning on retro-ing the fix back to 4.x. Their advice was to write a daemon in something other than CF that periodically checked the spool file for zero-byte files and deleted them. Also check to see if your CF server has already crashed and restart it. That's a bit out of the range of the majority of their customers, but that was their solution. -R Rick Osborne Certified Advanced ColdFusion 5 Developer ~~ 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: Lots o help
Thanks for the info on atswebnet. I think I didn't clearly state the session info..yeah I know they are stored in memory.just take away the db stuff, thinking of something else. The DB is just to track where the session went and what they did Thanks mike >>> [EMAIL PROTECTED] 10/29/01 04:38PM >>> At 01:10 PM 10/29/2001 -0500, you wrote: >Okay,I am leaving my relatively boring intranet tools, and venturing out >to the commerce world. And I have a few questions. It might be to much >and I hope I am not asking to much. > >1) Looking for a good host with sql, SSL, and the ability to use >verisign's payflow pro. I am think atswebnet, but not sure about how the >SSL plays out and the payflow pro(because the tag needs installed). Atswebnet is cheap, and in my experience you get what you pay for. I think I still have an account with them, though. The question is: how much down-time can you deal with? If this app is going to be a "key component" type of app, you'd be better off going with a hosting provider with a better track record. CFXHosting has been great in the past. They had some slight problems with service as of late, but to my understanding those were temporary and have been addressed. >4) Session variables stored in a DB I am storing the sessions variables in >the DB, with the authorization takes place those sessions should stay right?... I think you want to look into client variables. Session variables are stored in memory, not in a database. Yes, you can copy session information into a DB, however at that point they cease to become session variables. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- DotComIt: Database Driven Web Data My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide due out next February -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I can't believe I just gave up a gig... And rehearsal ~~ 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: cf to excel formatting problem
If you open the file directly into excel, this happens. (I deal with a lot of UPC's with leading zeros). However, if you open excel, then import text file, you have the opportunity to tell it how to treat each column (selecting text for your zip column) and everything is then cool. All else fails, I put a single quote in front of the number. That's Excel's internal notation that something is text and sometimes it works, sometimes it leaves the quote there. I haven't figured out why. > I am exporting some data to Excel and one of the > fields is zip code. Excel is stripping all leading 0's > (zeros) off of the zip codes. I need it to leave the > zip code alone, i.e. treat it as text instead of a > number. Any ideas anyone? > > So far, I have tried: > 1) Using an obscure ASCII char in front of the zip. > RESULT: Excel puts in a box when it encounters an > ASCII char it does not understand > > 2) Enclosing the zip in both single quotes and double > quotes. > RESULT: Excel leaves the quotes in instead of treating > them as a text qualifier > > 3) Looked at the Allaire forums, where I saw the same > question asked but not answered. > > 4) Read up on Excel at cfcomet, but most things there > are a little overkill for what I am trying to do. > > TIA, > > Nate > > = > > Nathan Shaw > Senior Web Applications Developer > iaffect, Inc. > http://www.iaffectonline.com > > > > ~~ 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: CFmail Recount
Unfortunately, ColdFusion doesn't give us the option to split the spool directory into mulitple directories, so the server will automatically write all the spool files out to that directory up to 65,535 files before crapping out. Then it only sifts through them at the rate of 400 per minute. It would be so nice if we had the option in the CF Administrator to split the spool directory or speed up the process of delivering the mail to the mail server. tom "Dave Watts" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > It could also be that thousands of files in the same directory > > > > on a windows box kills the file system in some way. > > > > > > I don't think this'll "kill" the filesystem, but it will make > > > it extremely unresponsive. > > > > while it won't kill it, it certainly in any higher graphical > > sort of directory view (windows explorer, windows commander, etc.) > > will run the processor at 100% and drag everything else way > > down... you should try to keep directory entries to a minimum > > as a rule of thumb we see 400-500 files per directory being > > the high mark... ~~ 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
cf to excel formatting problem
I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate = Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ~~ 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
downloading images
Hey, I'd like users to be able to download images from on my site. The images are pretty big, so i've made thumbnails for each. I can display each thumbnail, but how can i get it so that once the user clicks on the thumbnail, they get to download the whole image. I'd like it to work without having the user to right click and choose 'save image as'. Any ideas?! Thanks, Heidi = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Lots o help
At 01:10 PM 10/29/2001 -0500, you wrote: >Okay,I am leaving my relatively boring intranet tools, and venturing out >to the commerce world. And I have a few questions. It might be to much >and I hope I am not asking to much. > >1) Looking for a good host with sql, SSL, and the ability to use >verisign's payflow pro. I am think atswebnet, but not sure about how the >SSL plays out and the payflow pro(because the tag needs installed). Atswebnet is cheap, and in my experience you get what you pay for. I think I still have an account with them, though. The question is: how much down-time can you deal with? If this app is going to be a "key component" type of app, you'd be better off going with a hosting provider with a better track record. CFXHosting has been great in the past. They had some slight problems with service as of late, but to my understanding those were temporary and have been addressed. >4) Session variables stored in a DB I am storing the sessions variables in >the DB, with the authorization takes place those sessions should stay right?... I think you want to look into client variables. Session variables are stored in memory, not in a database. Yes, you can copy session information into a DB, however at that point they cease to become session variables. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- DotComIt: Database Driven Web Data My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide due out next February -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I can't believe I just gave up a gig... And rehearsal ~~ 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
RE: *** Complicated SQL riddle
While this is an excellent approach to handling the
data using the Child-Parent method, and is fairly
scaleable, it is still kind of ugly.
The nested set model kind of takes the order field
a little bit further. Instead you simply have two fields
,integers, that give the entire hierarchical structure.
The fields are called left and right and are used
to establish the boundaries of tree nodes. All work
with the tree can easily be handled in the server. It
only requires a single self join to pull out the entire
tree structure.
Say for example you had the following tree:
A
-B
-C
--D
--E
-F
A - lft:1 rgt:12
B - lft:2 rgt:3
C - lft:4 rgt:9
D - lft:5 rgt:6
E - lft:7 rgt:8
F - lft:9 rgt:10
You could then pull this data out by simply doing:
SELECT Letter
FROM tbl Parent, tbl Child
WHERE Child.lft BETWEEN Parent.lft AND Parent.rgt
ORDER BY Child.lft
There are a ton of simple tricks to determine just
about anything you can imagine about the tree. It is
really nifty and I at least recommend checking it
out next time you have to work with trees. This is just
a quick and dirty explanation. I highly recommend SQL
for Smarties by Joe Celko. If you have ever had a
question about some SQL trick its probably in there.
Thanks
Jeremy Allen
elliptIQ Inc.
-Original Message-
From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 12:55 PM
To: CF-Talk
Subject: RE: *** Complicated SQL riddle
Jason asked:
>That's the problem - I need to keep it flexible to accommodate any
>number of levels because I want to output a tree illustrating the
>hierarchy:
>I think I've heard someone talking about "self-joins" but am not sure
>how they'd work and whether they'd be flexible enough - anyone have any
>ideas?
Ah, the classic tree table. I've run up against this one far too many
times. First, let me answer your question about self joins. You didn't
give me the name of your table, so I'm just going to assume that it is
"Employees". A typical self-join might look like this:
SELECT e1.Name AS BossName, e2.Name AS UnderlingName
FROM Employees AS e1 INNER JOIN Employees AS e2 ON (e1.ID = e2.Boss)
ORDER BY e1.Name, e2.Name
You would get the following result set:
BossName UnderlingName
John John
John Steve
Mary Mary
Mary Mike
Mary Max
Max Michelle
Steve Susan
If you wanted to make it so that everyone was featured in the BossName
column (for a complete listing) just change the INNER JOIN to a LEFT OUTER
JOIN. Also, I don't know your setup, but you probably don't want people to
be their own bosses. That'll just make things harder later. Instead, John
and Mary probably want to have Boss == NULL.
Now, having said all of that, I'm going to tell you to not do it this way.
:) See, the problem is this: you would have to know beforehand what the
maximum number of tiers to your tree was, so that you could do the
appropriate amount of joins. And then you run into issues with speed, not
to mention issues where you have seven tiers, but one branch only goes down
3 levels ... and it's just messy.
Instead, I advise that you denormalize your data a bit to look like this:
ID Name Boss Depth OrderID
1 John NULL 1 1
2 Mary NULL 1 2
3 Steve 1 2 3
4 Mike 2 2 4
5 Susan 3 3 5
6 Max 2 2 6
7 Michelle 6 3 7
This way, getting the data out in the right order is mindbogglingly simple:
SELECT ID, Name, Boss, Depth, Order
FROM Employee
ORDER BY OrderID
Printing out your table is also pretty simple:
-#RepeatString("--",DecrementValue(Depth))##Name#
Getting new entries in is a bit trickier. Given a new employee, whose boss
is Susan, you'd have to do something like the following. I'm going to
assume that you know Susan's ID (BossID) because you picked it from a select
list or something, and my name will be in NewName.
SELECT OrderID, Depth, Name
FROM Employees
WHERE (Boss = #BossID#)
ORDER BY OrderID
UPDATE Employees
SET OrderID = OrderID + 1
WHERE OrderID >= #NewOrderID#
SELECT ISNULL(MAX(ID),0) + 1 AS NewID
FROM Employees
INSERT INTO Employees (ID, Name, Boss, Depth, OrderID)
VALUES (#NewID.NewID#, '#NewName#', '#BossID#', #NewDepth#, #NewOrderID#)
Whew. That was fun. Deleteing a record is quite a bit easier:
DELETE FROM Employees
WHERE ID = #OldID#
UPDATE Employees
SET OrderID = OrderID - 1
WHERE OrderID > #OldOrderID#
Updating to move people to a new boss is tricky, though, as it's a combo
between the last two. (Especially if you are reorging a whole department!)
I'll leave it as an exercise to the reader. ;)
Point being, you want to do all the hard work on the INSERT/UPDATE/DELETE
st
RE: Words Docs & ColdFusion
> > You don't need to install Word on the production server > > unless you're using OLE Automation (COM) to create or > > manipulate Word docs. If you're just using CFCONTENT to > > return them, your problem is something else. > > Is there a component that can be installed on a server in > place on an entire MS-Word installation? I realize this would > be tricky with licencing. I just curious if OLE automation > with MS office products can happen without installing the > whole smash. To the best of my knowledge, no. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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
Lots o help
Okay,I am leaving my relatively boring intranet tools, and venturing out to the commerce world. And I have a few questions. It might be to much and I hope I am not asking to much. 1) Looking for a good host with sql, SSL, and the ability to use verisign's payflow pro. I am think atswebnet, but not sure about how the SSL plays out and the payflow pro(because the tag needs installed). 2) The whole merchant account thing. Why? how does it play out. 3) CC Storing info, I am 100% sure I will not store this info, unless someone comes up with a great argument, other than improving customer info. 4) Session variables stored in a DB I am storing the sessions variables in the DB, with the authorization takes place those sessions should stay right?... Not sure what else I should be worrying about, but I feel like I am missing something big.. Any tips on things to watch out for? thanks mike ~~ 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: Words Docs & ColdFusion
> You don't need to install Word on the production server unless you're using > OLE Automation (COM) to create or manipulate Word docs. If you're just using > CFCONTENT to return them, your problem is something else. Is there a component that can be installed on a server in place on an entire MS-Word installation? I realize this would be tricky with licencing. I just curious if OLE automation with MS office products can happen without installing the whole smash. Thanks, ~~ 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: Words Docs & ColdFusion
> I am using something similar viewing Word Docs from folder > where they are uploaded via submission form. My one question > is everything works great locally when wanting to view the > file, but bombs on production server. Does Word need to be > loaded on the production server? You don't need to install Word on the production server unless you're using OLE Automation (COM) to create or manipulate Word docs. If you're just using CFCONTENT to return them, your problem is something else. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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: Words Docs & ColdFusion
I am using something similar viewing Word Docs from folder where they are uploaded via submission form. My one question is everything works great locally when wanting to view the file, but bombs on production server. Does Word need to be loaded on the production server? -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 10:11 AM To: CF-Talk Subject: RE: Words Docs & Coldfusion Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 6:22 AM To: CF-Talk Subject: Words Docs & Coldfusion Hi I currently have MS Word docs stored in an Oracle database. I wish to display these in a web browser via Coldfusion. Is this possible using Coldfusion and what is the best method of achieving so ? ~~ 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
RE: weird msg on sql to access change
I've received that message on occasion as well. It has happened when I created a query through Enterprise Manager and then for whatever reason, ran it in Access. I can't remember what type of join it fails on. If you can, re-create the query in Access through the query design wizard and see how Access creates the same query. That might give you better insight on which types of joins Access doesn't like. Mark -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 11:04 AM To: CF-Talk Subject: OT: weird msg on sql to access change I have a development and production server. The only difference between them is the datasource- the production uses sql and the development has an access db. Well I have a query that works fine on the SQL server but conks out on the access oneI'm getting the message that the join expression not supported. Does this mean simply that the query is too complicated for ~~ 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: *** Complicated SQL riddle
Jason asked:
>That's the problem - I need to keep it flexible to accommodate any
>number of levels because I want to output a tree illustrating the
>hierarchy:
>I think I've heard someone talking about "self-joins" but am not sure
>how they'd work and whether they'd be flexible enough - anyone have any
>ideas?
Ah, the classic tree table. I've run up against this one far too many
times. First, let me answer your question about self joins. You didn't
give me the name of your table, so I'm just going to assume that it is
"Employees". A typical self-join might look like this:
SELECT e1.Name AS BossName, e2.Name AS UnderlingName
FROM Employees AS e1 INNER JOIN Employees AS e2 ON (e1.ID = e2.Boss)
ORDER BY e1.Name, e2.Name
You would get the following result set:
BossName UnderlingName
John John
John Steve
Mary Mary
Mary Mike
Mary Max
Max Michelle
Steve Susan
If you wanted to make it so that everyone was featured in the BossName
column (for a complete listing) just change the INNER JOIN to a LEFT OUTER
JOIN. Also, I don't know your setup, but you probably don't want people to
be their own bosses. That'll just make things harder later. Instead, John
and Mary probably want to have Boss == NULL.
Now, having said all of that, I'm going to tell you to not do it this way.
:) See, the problem is this: you would have to know beforehand what the
maximum number of tiers to your tree was, so that you could do the
appropriate amount of joins. And then you run into issues with speed, not
to mention issues where you have seven tiers, but one branch only goes down
3 levels ... and it's just messy.
Instead, I advise that you denormalize your data a bit to look like this:
ID Name Boss Depth OrderID
1 John NULL 1 1
2 Mary NULL 1 2
3 Steve 1 2 3
4 Mike 2 2 4
5 Susan 3 3 5
6 Max 2 2 6
7 Michelle 6 3 7
This way, getting the data out in the right order is mindbogglingly simple:
SELECT ID, Name, Boss, Depth, Order
FROM Employee
ORDER BY OrderID
Printing out your table is also pretty simple:
-#RepeatString("--",DecrementValue(Depth))##Name#
Getting new entries in is a bit trickier. Given a new employee, whose boss
is Susan, you'd have to do something like the following. I'm going to
assume that you know Susan's ID (BossID) because you picked it from a select
list or something, and my name will be in NewName.
SELECT OrderID, Depth, Name
FROM Employees
WHERE (Boss = #BossID#)
ORDER BY OrderID
UPDATE Employees
SET OrderID = OrderID + 1
WHERE OrderID >= #NewOrderID#
SELECT ISNULL(MAX(ID),0) + 1 AS NewID
FROM Employees
INSERT INTO Employees (ID, Name, Boss, Depth, OrderID)
VALUES (#NewID.NewID#, '#NewName#', '#BossID#', #NewDepth#, #NewOrderID#)
Whew. That was fun. Deleteing a record is quite a bit easier:
DELETE FROM Employees
WHERE ID = #OldID#
UPDATE Employees
SET OrderID = OrderID - 1
WHERE OrderID > #OldOrderID#
Updating to move people to a new boss is tricky, though, as it's a combo
between the last two. (Especially if you are reorging a whole department!)
I'll leave it as an exercise to the reader. ;)
Point being, you want to do all the hard work on the INSERT/UPDATE/DELETE
stages so that your SELECT stage (which I presume you will be doing *much*
more frequently) will be a simple as it can possibly be.
I hope that answered your question. :)
You know, enough people do this and have trouble with it that they ought to
make it a session at next year's DevCon.
Rick Osborne
Certified Advanced ColdFusion 5 Developer
~~
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
Re: Modifying underliverable mail headers
>>On our intranet I have a form set up so I can take a look at >>messages that end up in the CFUSION/MAIL/UNDELIVR. It uses CFFILE to >> > bring > >>the contents of a particular message into a textarea. Then I can modify a >>malformed e-mail address if I can, and re-write the file to the SPOOL >>directory to be resent. >> >>This works fine, but when the messages go through they appear not to have >> > a > >>subject or a to: field. Does anyone have any idea why? Below is an >> > example > >>of a message as read by CFFILE from the UNDELIVR folder: >> >>x-cf-version: 4.5.0 >>x-cf-server: 131.187.108.254 >>x-cf-port: 25 >>x-cf-timeout: 180 >>x-cf-from: "Owen Leonard" <[EMAIL PROTECTED]> >>x-cf-to: "Owen Leonard" <[EMAIL PROTECTED]> >> >> >>Content-type: text/plain >> >>Date: Tue, 23 Oct 2001 14:14:42 -0400 >> >>From: "Owen Leonard" <[EMAIL PROTECTED]> >> >>Subject: This is a subject >> >>To: "Owen Leonard" <[EMAIL PROTECTED]> If it really looks like this the reason is that the headers end when the first double CRLF is detected. So they should end up in the body of the email message. Make sure that the email looks something like below when you rewrite it to the spoolfolder (and beware of the addnewline attribute of CFILE): x-cf-version:#chr(32)#4.5.0#chr(13)##chr(10)#x-cf-server:#chr(32)#131.187.108.254#chr(13)##chr(10)#x-cf-port:#chr(32)#25#chr(13)##chr(10)#x-cf-timeout:#chr(32)#180#chr(13)##chr(10)#x-cf-from:#chr(32)#"Owen#chr(32)#Leonard"#chr(32)#<[EMAIL PROTECTED]>#chr(13)##chr(10)#x-cf-to:#chr(32)#"Owen#chr(32)#Leonard"#chr(32)#<[EMAIL PROTECTED]>#chr(13)##chr(10)##chr(13)##chr(10)#Content-type:#chr(32)#text/plain#chr(13)##chr(13)##chr(10)#Date:#chr(32)#Tue,#chr(32)#23#chr(32)#Oct#chr(32)#2001#chr(32)#14:14:42#chr(32)#-0400#chr(13)##chr(13)##chr(10)#From:#chr(32)#"Owen#chr(32)#Leonard"#chr(32)#<[EMAIL PROTECTED]>#chr(13)##chr(13)##chr(10)#Subject:#chr(32)#This#chr(32)#is#chr(32)#a#chr(32)#subject#chr(13)##chr(13)##chr(10)#To:#chr(32)#"Owen#chr(32)#Leonard"#chr(32)#<[EMAIL PROTECTED]>#chr(13) ##chr(13)##chr(10)##chr(13)##chr(13)##chr(10)#body#chr(32)#of#chr(32)#message [unwrap if wrapped] This is based on addnewline="No" and created using cfscript so CF does not insert any other linebreaks/whitespace. For an example download cf_advancedemail from http://jochem.vandieten.net/coldfusion/customtags/ (but don't actually use it untill version 2 is released, it has bugs in different areas). Jochem ~~ 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: CFmail Recount
no problem... I just figured I should say it.. :) many of times I have seen many of us living under GUI sit and wait for our interface :) parse 20k files into windows explorer then have it apply that custom sort before displaying them will leave you wondering why we even use GUIs... -paris -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 12:43 To: CF-Talk Subject: RE: CFmail Recount > > > It could also be that thousands of files in the same directory > > > on a windows box kills the file system in some way. > > > > I don't think this'll "kill" the filesystem, but it will make > > it extremely unresponsive. > > while it won't kill it, it certainly in any higher graphical > sort of directory view (windows explorer, windows commander, etc.) > will run the processor at 100% and drag everything else way > down... you should try to keep directory entries to a minimum > as a rule of thumb we see 400-500 files per directory being > the high mark... You're right about that. I didn't intend anyone to think that it was OK to put that many files within a single directory. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: CFmail Recount
> > > It could also be that thousands of files in the same directory > > > on a windows box kills the file system in some way. > > > > I don't think this'll "kill" the filesystem, but it will make > > it extremely unresponsive. > > while it won't kill it, it certainly in any higher graphical > sort of directory view (windows explorer, windows commander, etc.) > will run the processor at 100% and drag everything else way > down... you should try to keep directory entries to a minimum > as a rule of thumb we see 400-500 files per directory being > the high mark... You're right about that. I didn't intend anyone to think that it was OK to put that many files within a single directory. 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 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: Modifying underliverable mail headers
Why not catch malformed email addresses before you send them with CFMAIL? Wouldn't that be much easier? Jim - Original Message - From: "Owen Leonard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 10:24 AM Subject: Re: Modifying underliverable mail headers > No takers on this one? > > - Original Message - > Sent: Wednesday, October 24, 2001 2:41 PM > Subject: Modifying underliverable mail headers > > > > On our intranet I have a form set up so I can take a look at > > messages that end up in the CFUSION/MAIL/UNDELIVR. It uses CFFILE to > bring > > the contents of a particular message into a textarea. Then I can modify a > > malformed e-mail address if I can, and re-write the file to the SPOOL > > directory to be resent. ~~ 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: *** Complicated SQL riddle
One way is to write an SP and in it you create a temp table (#temp in this example) with one field called ID then.. -- Insert initial records INSERT INTO #Temp (ID) SELECT ID FROM table WHERE Boss = @ID --Insert all terms further down the heirarchy DECLARE @rowcount int , @rowcount1 int SELECT @rowcount = 1 SELECT @rowcount1 = 0 WHILE @rowcount <> @rowcount1 BEGIN SELECT @rowcount1 = @rowcount INSERT INTO #temp (ID) SELECT DISTINCT ID FROM table, #temp WHERE table.Boss = #temp.ID SELECT @rowcount = @@rowcount END Then select distinct ID from temp and you have your list. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Jason Blum [mailto:[EMAIL PROTECTED]] Sent: 29 October 2001 17:07 To: CF-Talk Subject: *** Complicated SQL riddle Howdy all! Here's a SQL problem that's been vexing me for a few weeks now: Say you have a table like this: ID NameBoss 1 John1 2 Mary2 3 Steve 1 4 Mike2 5 Susan 3 6 Max 2 7 Michelle6 So, John is his own boss, the big cheese, and everybody reports to him or to someone who reports to him, or to someone who reports to someone who reports to him, etc. That's the problem - I need to keep it flexible to accommodate any number of levels because I want to output a tree illustrating the hierarchy: -John ---Mary --Mike --Max -Michelle ---Steve --Susan I think I've heard someone talking about "self-joins" but am not sure how they'd work and whether they'd be flexible enough - anyone have any ideas? -Jason ~~ 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: CFmail Recount
while it won't kill it, it certainly in any higher graphical sort of directory view (windows explorer, windows commander, etc.) will run the processor at 100% and drag everything else way down... you should try to keep directory entries to a minimum as a rule of thumb we see 400-500 files per directory being the high mark... that is across different windows variations your mileage will vary.. but not so much... I have had 10k files in a directory spinning the listing out from a DOS prompt... in that mode it is fine... pure listing... any other way forget it... -paris -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 12:28 To: CF-Talk Subject: RE: CFmail Recount > It could also be that thousands of files in the same directory > on a windows box kills the file system in some way. I don't think this'll "kill" the filesystem, but it will make it extremely unresponsive. I've seen situations with 50k+ files in a single directory, and it just took a long time to retrieve a file within the directory, or perform any operation within that directory. This was on a laptop, of all places. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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
Re: *** Complicated SQL riddle
Jason, You've got the right idea, but I would recommend you make John's boss be 0, since he would be the top of the chain. Then all you have to do is make your query and group by ID and Boss. You can easily show all the data using cfoutput or you can use cftree. Richard - Original Message - From: "Jason Blum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 9:07 AM Subject: *** Complicated SQL riddle > Howdy all! > > Here's a SQL problem that's been vexing me for a few weeks now: > > Say you have a table like this: > > ID Name Boss > 1 John 1 > 2 Mary 2 > 3 Steve 1 > 4 Mike 2 > 5 Susan 3 > 6 Max 2 > 7 Michelle 6 > > So, John is his own boss, the big cheese, and everybody reports to him > or to someone who reports to him, or to someone who reports to someone > who reports to him, etc. > That's the problem - I need to keep it flexible to accommodate any > number of levels because I want to output a tree illustrating the > hierarchy: > > -John > ---Mary > --Mike > --Max > -Michelle > ---Steve > --Susan > > I think I've heard someone talking about "self-joins" but am not sure > how they'd work and whether they'd be flexible enough - anyone have any > ideas? > > -Jason > ~~ 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
