What do you use to send out HTML NEWSLETTERS from your site
We're building an application to send out HTML email newsletters, the application needs to integrate with our SQL database for personalization and needs to support HTML templates for each newsletter, as the basic format and layout of each email stays the same and we just replace the content which consists of text. We've tried using the CF_HTMLAREA and CF_ActivEdit tags as WYSIWYG editors for entering the text into the templates but have found that this bloats up the HTML and it ends up large and clunky - not really good for email!!. We're also having problems getting the text to display properly, word wraps, line spacing etc. This effort is getting frustrating. There must be a ton of ways to effectively send out and manage hi quality HTML emails from our site (I get tons of well composed spam every day) and it seems like we're trying to reinvent the wheel when the garage is just next door!! Can anyone help in recommending a good product or service or source code or even just an idea or suggestion. Thanks for your time. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: Recommend a replacement for CFMAIL
That depends on what you want to do with it. If you just need to send loads of plaintext/html messages, just dump them right into the IIS SMTP spooler with CFFILE. It's much faster than any tag you'll find and you already have everything you need to make it happen (assuming you're on Windows running IIS of course). -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: John Innit [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:19 AM Subject: Recommend a replacement for CFMAIL Can anyone recommend a good replacement for CFMAIL, should able to handle bulk emails (~20k/day) reliably. Should not cost more than US$ 100. I'm aware of activmail and iMS. Anyone using anything else and happy with the peformance? Pls advise. Thanks. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: Conditional Query loop
Bryan Love wrote: arrayToList won't work on a query column. It's true query columns are arrays, but they are very special arrays and can ONLY be treated as arrays in order to access certain records (myQuery.columnName[i]) to make a list use valueList(myQuery.columnName), but I wouldn't recommend it to solve this particular problem Array functions do work on query columns, you just have to reference them the right way: ArrayToList(queryname[columnname]) Jochem __ 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: Recommend a replacement for CFMAIL
Just curious, but how would you construct the files that get dumped? At 06:53 AM 5/16/2002 -0400, you wrote: That depends on what you want to do with it. If you just need to send loads of plaintext/html messages, just dump them right into the IIS SMTP spooler with CFFILE. It's much faster than any tag you'll find and you already have everything you need to make it happen (assuming you're on Windows running IIS of course). -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: John Innit [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:19 AM Subject: Recommend a replacement for CFMAIL Can anyone recommend a good replacement for CFMAIL, should able to handle bulk emails (~20k/day) reliably. Should not cost more than US$ 100. I'm aware of activmail and iMS. Anyone using anything else and happy with the peformance? Pls advise. Thanks. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: Recommend a replacement for CFMAIL
Jim Gurfein wrote: Just curious, but how would you construct the files that get dumped? Just construct a standard RFC 2822 format email message or use http://jochem.vandieten.net/coldfusion/customtags/advancedemail/ Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Recommend a replacement for CFMAIL
Just curious, but how would you construct the files that get dumped? Here's a sample from one of my all-user mailings... --[ Begin Code ]-- cffile action=write file=c:\inetpub\mailroot\pickup\#createuuid()#.txt output=Content-type: text/plain Date: #dateformat(now(), ddd, d mmm )# #timeformat(now(), HH:mm:ss)# -0500 To: #userdata.Email# From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: DtDNS System Announcement Message for you sir! --[ End Code ]-- If you're going send HTML mail, I would suggest putting the contents into a variable instead of inline to avoid problems with the double quotes. The GMT offset needs to be adjusted to match your time zone. To use this, just make sure the IIS SMTP service is enabled and configured in a secure manner so others can't relay through it. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [admin] List status - A CHALLENGE
Here here. Australia... Too young for Florida deg a former Olympic Stadium to hold Michael's presentations in. It's not doing anything a few days of the year.About 360 days a year at last count. __ 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: [admin] List status - A CHALLENGE
and alligators, water moccasins and creepy guys that have been to one to many bar (For the natives: the ones (guys) in Central Florida that wear that ball cap like thing . . . think Palatka) I shudder. - Original Message - From: Jacob [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 4:27 PM Subject: RE: [admin] List status - A CHALLENGE ..and sharks At 11:20 AM 5/15/2002 -0700, you wrote: What are you afraid of: terrorists, hurricaines, train derailments, voting scandals, tourist taxes, water shortages, impossible traffic, lightning, speaking spanish, Jimmy Buffet, or sunburn? Certainly there's nothing wrong with Florida that Jeb Bush or Janet Reno can't fix. It helps if you say that over and over. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 02:07PM No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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
apache 2 - windows
I vaguely remember this being discussed a while back and can't find the thread in the archives but... Has anyone built a coldfusion module to load with the new apache windows version ? __ 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 dynamic pages on Netscape
Hi Mike, I don't have an answer for you - I don't think anybody does. I had almost the same question about a month ago. I don't know why netscape behaves this way, but I have seen it before in my programming. When it does this, nothing on the page works - not javascript, not forms... Sorry I couldn't be of more help. - Matt Small -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:34 PM To: CF-Talk Subject: Printing dynamic pages on Netscape I have seen this question asked from time to time but never seen a reply how can I let Netscape users print out a dynamic page? They get a message on the page saying Data missing: This document resulted from a POST operation and has expired from the cache, etc I have seen Print this page buttons before, but for the life of me I can't find one right now when I need it - how do they work? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: What do you use to send out HTML NEWSLETTERS from your site
talk a look at intergrating eWebEditPro from www.ektron.com we are having success sending HTML email newsletters - Original Message - From: John Innit [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 4:55 AM Subject: What do you use to send out HTML NEWSLETTERS from your site We're building an application to send out HTML email newsletters, the application needs to integrate with our SQL database for personalization and needs to support HTML templates for each newsletter, as the basic format and layout of each email stays the same and we just replace the content which consists of text. We've tried using the CF_HTMLAREA and CF_ActivEdit tags as WYSIWYG editors for entering the text into the templates but have found that this bloats up the HTML and it ends up large and clunky - not really good for email!!. We're also having problems getting the text to display properly, word wraps, line spacing etc. This effort is getting frustrating. There must be a ton of ways to effectively send out and manage hi quality HTML emails from our site (I get tons of well composed spam every day) and it seems like we're trying to reinvent the wheel when the garage is just next door!! Can anyone help in recommending a good product or service or source code or even just an idea or suggestion. Thanks for your time. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: Yo Macromedia: CFMX and UUID Issue!
Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! I believe it's the ODBC... errr... JDBC drivers that they use. They are definitely different. I myself noticed that if I have a field in an access database called userID, a query for the field UserID will fail. I know that's my problem, but still - the ODBC drivers from version 5 didn't really care. I can't bitch because I'm sure the JDBC driver does it the right way, so now all I have to do is make sure my code does it the right way. Adam. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:59 PM To: CF-Talk Subject: Yo Macromedia: CFMX and UUID Issue! Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. They didn't do that in CF5 or earlier. They are Uppercase in the database. This is creating issues for where I have had to hard code some UUIDs in JavaScript. Anybody else notice this? What gives? Is it too late to fix it before CFMX comes out? Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Frames
Hi, I have the following frames setup below. I have a refresh link in the top frame top.cfm which when clicked I want the bottom frame bottom.cfm to refresh. This is the code I have in my top frame. a href=javascript:history.go(0); target=_bottomRefresh/a What am I doing wrong.? It just hangs IE. -- | Refresh | --- | | |Content| | | --- +---+ Philip Humeniuk [EMAIL PROTECTED] [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: Yo Macromedia: CFMX and UUID Issue!
No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up your defined sources no probs. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:19 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! I believe it's the ODBC... errr... JDBC drivers that they use. They are definitely different. I myself noticed that if I have a field in an access database called userID, a query for the field UserID will fail. I know that's my problem, but still - the ODBC drivers from version 5 didn't really care. I can't bitch because I'm sure the JDBC driver does it the right way, so now all I have to do is make sure my code does it the right way. Adam. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:59 PM To: CF-Talk Subject: Yo Macromedia: CFMX and UUID Issue! Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. They didn't do that in CF5 or earlier. They are Uppercase in the database. This is creating issues for where I have had to hard code some UUIDs in JavaScript. Anybody else notice this? What gives? Is it too late to fix it before CFMX comes out? Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ 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: List, Quotes, Commas UGH
Thank you folks, that worked great! Paul Giesnehagen QuillDesign The key here of course is the RE - (Aren't there laws concerning coding RE's this late at night? eh? hehe) cfscript myList = '22,33.44,21.93,1,090.33,2,999.00'; myList = REReplace(myList, '()([0-9_]*)([,]*)([0-9_.]*)()', '\2\4', 'ALL'); /cfscript This should get ya rollin =) Nate Nielsen FusionScript DevTeam [EMAIL PROTECTED] [EMAIL PROTECTED] Develop CF apps that talk to the server without page reloads ! Create client functionality with CF syntax ! www.FusionScript.com - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:21 AM Subject: List, Quotes, Commas UGH I have a list with comma's and quotes, here is a sample: 22,33.44,21.93,1,090.33,2,999.00 I need to strip out the as well as take the comma out of the thousand number so 1,999 would be 1999 but still keep my list in tact NOTE: ,1,090.33,2,999.00 Those values are seperated by a comma If I replace with nothing, then my list gets out of wack because of the 1,999 comma .. I am sure there is a simple method to roll through these, but I am sure someone has a quick answer... Thanks in advance! Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Printing dynamic pages on Netscape
Just a thought on this topic: I think this happens because when Netscape does a view source or a print it reloads the page to ensure the latest version of the page. I know many people don't like the concept of splitting code based on broser, but have you thought of having a Printer version that uses a CFFile to create a temporary HTML page that you either CFLocation to or open in a pop-up window? That way NS isn't looking at a post generated page. Then when you're done, delete the temp file. Matthew R. Small wrote: Hi Mike, I don't have an answer for you - I don't think anybody does. I had almost the same question about a month ago. I don't know why netscape behaves this way, but I have seen it before in my programming. When it does this, nothing on the page works - not javascript, not forms... Sorry I couldn't be of more help. - Matt Small -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:34 PM To: CF-Talk Subject: Printing dynamic pages on Netscape I have seen this question asked from time to time but never seen a reply how can I let Netscape users print out a dynamic page? They get a message on the page saying Data missing: This document resulted from a POST operation and has expired from the cache, etc I have seen Print this page buttons before, but for the life of me I can't find one right now when I need it - how do they work? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Yo Macromedia: CFMX and UUID Issue!
Does having a bridge affect performance? Thanks Frank M - Original Message - From: Neil Clark - =TMM= [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 9:16 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up your defined sources no probs. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:19 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! I believe it's the ODBC... errr... JDBC drivers that they use. They are definitely different. I myself noticed that if I have a field in an access database called userID, a query for the field UserID will fail. I know that's my problem, but still - the ODBC drivers from version 5 didn't really care. I can't bitch because I'm sure the JDBC driver does it the right way, so now all I have to do is make sure my code does it the right way. Adam. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:59 PM To: CF-Talk Subject: Yo Macromedia: CFMX and UUID Issue! Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. They didn't do that in CF5 or earlier. They are Uppercase in the database. This is creating issues for where I have had to hard code some UUIDs in JavaScript. Anybody else notice this? What gives? Is it too late to fix it before CFMX comes out? Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ 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: What do you use to send out HTML NEWSLETTERS from your site
I create an html file called newsletter.html and a text file called newsletter.txt, then in the body of my CFMAIL I do this: CFMAILPARAM name=X-mailer value=[MAILER PARAM NAME] multipart mailer v1.0 CFMAILPARAM name=MIME-Version value=1.0 CFMAILPARAM name=Content-Type value=multipart/alternative; boundary=[MAILER PARAM NAME] --[MAILER PARAM NAME] Content-Type:text/plain; charset=us-ascii CFINCLUDE TEMPLATE=newsletter.txt --[MAILER PARAM NAME] Content-Type:text/x-aol; charset=us-ascii CFINCLUDE TEMPLATE=newsletter.txt --[MAILER PARAM NAME] Content-Type:text/html; charset=us-ascii cfinclude template=newsletter.htm --[MAILER PARAM NAME]-- /CFMAIL Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 3:56 AM To: CF-Talk Subject: What do you use to send out HTML NEWSLETTERS from your site We're building an application to send out HTML email newsletters, the application needs to integrate with our SQL database for personalization and needs to support HTML templates for each newsletter, as the basic format and layout of each email stays the same and we just replace the content which consists of text. We've tried using the CF_HTMLAREA and CF_ActivEdit tags as WYSIWYG editors for entering the text into the templates but have found that this bloats up the HTML and it ends up large and clunky - not really good for email!!. We're also having problems getting the text to display properly, word wraps, line spacing etc. This effort is getting frustrating. There must be a ton of ways to effectively send out and manage hi quality HTML emails from our site (I get tons of well composed spam every day) and it seems like we're trying to reinvent the wheel when the garage is just next door!! Can anyone help in recommending a good product or service or source code or even just an idea or suggestion. Thanks for your time. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: Yo Macromedia: CFMX and UUID Issue!
Not that I know of... peformance as far as serving pages is concerned is sweet with the new compilation architecture. I have heard that JDBC is faster than ODBC, but even with the bridge I dont think you will suffer any performance issues. If you have CFMX PR, then run a few tests against a CF5 install, thats your best bet though I doubt the idea was to release a product which was slower in performance than its predecessors. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:26 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Does having a bridge affect performance? Thanks Frank M - Original Message - From: Neil Clark - =TMM= [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 9:16 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up your defined sources no probs. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:19 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! I believe it's the ODBC... errr... JDBC drivers that they use. They are definitely different. I myself noticed that if I have a field in an access database called userID, a query for the field UserID will fail. I know that's my problem, but still - the ODBC drivers from version 5 didn't really care. I can't bitch because I'm sure the JDBC driver does it the right way, so now all I have to do is make sure my code does it the right way. Adam. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:59 PM To: CF-Talk Subject: Yo Macromedia: CFMX and UUID Issue! Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. They didn't do that in CF5 or earlier. They are Uppercase in the database. This is creating issues for where I have had to hard code some UUIDs in JavaScript. Anybody else notice this? What gives? Is it too late to fix it before CFMX comes out? Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ 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
Dependant selects solution?
There was a thread yesterday about dependant selects and someone posted some code. I have, unsuccessfully, tried to get it to work. Can someone give me some help? I need both selects to be populated by queries. Thanks, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.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
Trouble with Access and Single Numbers
I'm having some trouble with pulling some values out of Access. The field is defined as a number with a field size as single. The problem is CF is retrieving some decimal values all funny. 2.6 is retrieved as 2.599 1.7 is 1.7 1.9 is 1.9 2.9 is 2.901 9.99 is 9.988 Crazy stuff. They all look fine and as they with in Access but when I retrieve them with a straight Select in CF funny things happen. I can only guess that it something to do with single precision thing, but what to do. Any help Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [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
ie vs ns javascript issue
Hi all, I have the following javascript on a popup window. if (navigator.appName == Netscape) { function CloseForm(theForm) { theForm.submit(); setTimeout(window.close, 2000); } } else if (navigator.appName == Microsoft Internet Explorer) { function CloseForm(theForm) { window.close(); } } The popup window is a form that submits to a target frame. I had to put the settimeout in for ns because it would close the window before the submit action took place. But ie bombs on the settimeout so I had to take it out and just use the window.close(). I call this function with an onclick=javascript:CloseForm(this.form);. When I had the theForm.submit(); on the ie version of the function it would submit the form twice. So I took it off and now it submits the form and closes the window but the target frame never gets refreshed. Basically it's submitting the form but it's not sending the action to the target frame cause it's not reading it or something. Any ideas? Thanks, jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Trouble with Access and Single Numbers
Do you have the decimal places set to something other than Auto? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:41 AM To: CF-Talk Subject: Trouble with Access and Single Numbers I'm having some trouble with pulling some values out of Access. The field is defined as a number with a field size as single. The problem is CF is retrieving some decimal values all funny. 2.6 is retrieved as 2.599 1.7 is 1.7 1.9 is 1.9 2.9 is 2.901 9.99 is 9.988 Crazy stuff. They all look fine and as they with in Access but when I retrieve them with a straight Select in CF funny things happen. I can only guess that it something to do with single precision thing, but what to do. Any help Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [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: Yo Macromedia: CFMX and UUID Issue!
I have heard that JDBC is faster than ODBC, but even with the bridge I don't think you will suffer any performance issues. It doesn't make any sense to say JDBC is faster than ODBC. There are fast and slow JDBC clients, and fast and slow ODBC clients. I doubt that using the best Type 4 JDBC client against MS SQL Server will be as fast as using the standard ODBC client for it. Also, if by the bridge you mean the JDBC-ODBC bridge from Sun, if you use that you will certainly suffer performance issues. It's a Type 1 driver if I recall correctly, and designed more for demonstration purposes than anything else from my understanding. If you have CFMX PR, then run a few tests against a CF5 install, that's your best bet though I doubt the idea was to release a product which was slower in performance than its predecessors. I wouldn't be surprised if CF MX does turn out to be slower than CF 5 - it's more complex, it has to integrate with other products in a way that CF 5 doesn't, and so on. I hope that it's not much slower, though; that should be good enough. I think that the idea was to release a product that integrates fully with J2EE, more than it was to build something faster than CF 5. 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: What do you use to send out HTML NEWSLETTERS from your site
For those interested - here is the rest of my CFMAIL tag: CFMAIL query=getEmail SUBJECT=[Type an email subject here] FROM=[Common Name] [email address of sender] TO=#EMAIL# SERVER=[YOUR MAIL SERVER] PORT=25 MAILERID=[YOUR DOMAIN NAME] TYPE=HTML Hope this helps Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:39 AM To: CF-Talk Subject: RE: What do you use to send out HTML NEWSLETTERS from your site I create an html file called newsletter.html and a text file called newsletter.txt, then in the body of my CFMAIL I do this: CFMAILPARAM name=X-mailer value=[MAILER PARAM NAME] multipart mailer v1.0 CFMAILPARAM name=MIME-Version value=1.0 CFMAILPARAM name=Content-Type value=multipart/alternative; boundary=[MAILER PARAM NAME] --[MAILER PARAM NAME] Content-Type:text/plain; charset=us-ascii CFINCLUDE TEMPLATE=newsletter.txt --[MAILER PARAM NAME] Content-Type:text/x-aol; charset=us-ascii CFINCLUDE TEMPLATE=newsletter.txt --[MAILER PARAM NAME] Content-Type:text/html; charset=us-ascii cfinclude template=newsletter.htm --[MAILER PARAM NAME]-- /CFMAIL Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 3:56 AM To: CF-Talk Subject: What do you use to send out HTML NEWSLETTERS from your site We're building an application to send out HTML email newsletters, the application needs to integrate with our SQL database for personalization and needs to support HTML templates for each newsletter, as the basic format and layout of each email stays the same and we just replace the content which consists of text. We've tried using the CF_HTMLAREA and CF_ActivEdit tags as WYSIWYG editors for entering the text into the templates but have found that this bloats up the HTML and it ends up large and clunky - not really good for email!!. We're also having problems getting the text to display properly, word wraps, line spacing etc. This effort is getting frustrating. There must be a ton of ways to effectively send out and manage hi quality HTML emails from our site (I get tons of well composed spam every day) and it seems like we're trying to reinvent the wheel when the garage is just next door!! Can anyone help in recommending a good product or service or source code or even just an idea or suggestion. Thanks for your time. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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
Get date/time from browser?
Hello all, We have clients in many different time zones, and we would like to find an easy way to get the local time from the browser rather than querying a time_zone table every time or setting a session variable. Almost like a reverse cfheader where we get info from the browser instead of sending it. Any ideas? Thanks. Ryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: SOLVED! ie vs ns javascript issue
I hate it when this happens. I had another site open that uses frames and the results were being put in that frameset instead of my frameset. All is well with this script. ~Jason -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:41 AM To: CF-Talk Subject: ie vs ns javascript issue Hi all, I have the following javascript on a popup window. if (navigator.appName == Netscape) { function CloseForm(theForm) { theForm.submit(); setTimeout(window.close, 2000); } } else if (navigator.appName == Microsoft Internet Explorer) { function CloseForm(theForm) { window.close(); } } The popup window is a form that submits to a target frame. I had to put the settimeout in for ns because it would close the window before the submit action took place. But ie bombs on the settimeout so I had to take it out and just use the window.close(). I call this function with an onclick=javascript:CloseForm(this.form);. When I had the theForm.submit(); on the ie version of the function it would submit the form twice. So I took it off and now it submits the form and closes the window but the target frame never gets refreshed. Basically it's submitting the form but it's not sending the action to the target frame cause it's not reading it or something. Any ideas? Thanks, jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC datadources defined thru control panel? What about system DSNs? Yes, I'm pretty sure that CF MX uses JDBC for all datasources. This is why it won't support the dynamic connectstring stuff added in CF 5. During the install, if you have CF 5 already installed, it'll create JDBC datasources for all of the previously defined ODBC datasources, but you may have to go in and tweak these datasources to get them to work. Once this is done, CF MX won't use ODBC for anything, and if you subsequently create ODBC datasources in the Control Panel, they won't be created within CF MX. 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: Get date/time from browser?
I needed to do just that on a project a while back so I dug up this file for you. I haven't looked at it since I did it, so if you have problems or questions let me know and I'll take a closer look. DM * cfif isDefined('set') ~cfoutput ~Your Time: #TimeFormat(hour,h:mm tt)#br ~server Time: #TimeFormat(now(),h:mm tt)#br ~ ~cfset serverhour = now()!--- TimeFormat(now(),H) --- ~ ~cfset hourDiff = DateDiff(h, serverHour, hour ) ~Hour Difference: #hourDiff#br ~ ~cfcookie name=HourDiff value=#hourDiff# expires=NEVER ~set cookie: #cookie.hourDiff# hours /cfoutput cfelse !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head ~titleUntitled/title script function dohour(){ var mydate=new Date() var year=mydate.getYear() if (year 1000) year+=1900 var day=mydate.getDay() var month=mydate.getMonth()+1 var daym=mydate.getDate() if (daym10) daym=0+daym var hours=mydate.getHours() var minutes=mydate.getMinutes() var seconds=mydate.getSeconds() var cdate={ts '+year+-+month+-+daym+ +hours+:+minutes+:00'}; document.form.hour.value=cdate; document.form.submit() } /script /head body onLoad=dohour() form action=# method=post name=form ~input type=hidden value= name=hour ~input type=hidden name=set value=t /form ** = = = Original message = = = Hello all, We have clients in many different time zones, and we would like to find an easy way to get the local time from the browser rather than querying a time_zone table every time or setting a session variable. Almost like a reverse cfheader where we get info from the browser instead of sending it. Any ideas? Thanks. Ryan __ 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: Yo Macromedia: CFMX and UUID Issue!
I can confirm that. CFMX PR didn't pickup any ODBC datasources on the machine I installed it on. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 10:02 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC datadources defined thru control panel? What about system DSNs? Yes, I'm pretty sure that CF MX uses JDBC for all datasources. This is why it won't support the dynamic connectstring stuff added in CF 5. During the install, if you have CF 5 already installed, it'll create JDBC datasources for all of the previously defined ODBC datasources, but you may have to go in and tweak these datasources to get them to work. Once this is done, CF MX won't use ODBC for anything, and if you subsequently create ODBC datasources in the Control Panel, they won't be created within CF MX. 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
Subquery from the same table: Is it possible??
Is it possible to have a subquery from the same table to output data based on a certain condition? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Yo Macromedia: CFMX and UUID Issue!
Tighter integration is great but performance enhancments are always a good selling point. It's tougher to justify an upgrade to my higher ups if we'll be losing performance. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 9:51 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! I have heard that JDBC is faster than ODBC, but even with the bridge I don't think you will suffer any performance issues. It doesn't make any sense to say JDBC is faster than ODBC. There are fast and slow JDBC clients, and fast and slow ODBC clients. I doubt that using the best Type 4 JDBC client against MS SQL Server will be as fast as using the standard ODBC client for it. Also, if by the bridge you mean the JDBC-ODBC bridge from Sun, if you use that you will certainly suffer performance issues. It's a Type 1 driver if I recall correctly, and designed more for demonstration purposes than anything else from my understanding. If you have CFMX PR, then run a few tests against a CF5 install, that's your best bet though I doubt the idea was to release a product which was slower in performance than its predecessors. I wouldn't be surprised if CF MX does turn out to be slower than CF 5 - it's more complex, it has to integrate with other products in a way that CF 5 doesn't, and so on. I hope that it's not much slower, though; that should be good enough. I think that the idea was to release a product that integrates fully with J2EE, more than it was to build something faster than CF 5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Subquery from the same table: Is it possible??
Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but this value is a variable. It changes as Microsoft® SQL Server(tm) examines different rows of the authors table. 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
Coldfusion /MS Exchange
Hi, Has anyone worked with cf ms exchange server i.e accessing contacts, calenders etc. Can it be done? It would be much apreciated if it can be done for someone to show me the way or point me in the right direction. Thanks in Advance Chris Bohill WEB APPLICATIONS DEVELOPER Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ 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: Subquery from the same table: Is it possible??
Yes, but you may need to alias the table name on the external query to avoid conflicts. SELECT field1 FROM table AS exttable WHERE id IN (SELECT id FROM table WHERE field2 = exttable.field1) I know the example could be written without the subquery, but is just an example of the aliasing needed in this type of setup. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 10:10 AM Subject: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Yo Macromedia: CFMX and UUID Issue!
Tighter integration is great but performance enhancments are always a good selling point. It's tougher to justify an upgrade to my higher ups if we'll be losing performance. That may be true, but in my opinion, the potential loss of performance is easily offset by the ability to do more in your applications, without as much work as before. If you do that well, your applications may perform significantly better than they did in the past anyway. Like Neil said, you'll have to try it and see; that's what evaluation versions are all about. 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
WAY OT DTS PACKAGE
Does anyone know via DTS how to open a zip file so that I can attach to a dbf file that is in the zip file? Josh __ 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: Coldfusion /MS Exchange
http://www.cfcomet.com is your oyster. -Original Message- From: Chris Bohill [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:13 To: CF-Talk Subject: Coldfusion /MS Exchange Hi, Has anyone worked with cf ms exchange server i.e accessing contacts, calenders etc. Can it be done? It would be much apreciated if it can be done for someone to show me the way or point me in the right direction. Thanks in Advance Chris Bohill WEB APPLICATIONS DEVELOPER Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W biznet-solutions.com ** ** ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** ** ** __ 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: [admin] List status - A CHALLENGE
I'll second that Buffalo nomination! Jeff - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:07 PM Subject: RE: [admin] List status - A CHALLENGE No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: [admin] List status - A CHALLENGE
If you come to Seattle, we'll promise not to tear-gas ya! -Original Message- From: Development [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 7:21 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I'll second that Buffalo nomination! Jeff - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:07 PM Subject: RE: [admin] List status - A CHALLENGE No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: [admin] List status - A CHALLENGE
I'm going unilateral in my vote for Bournemouth, England. I'm confident that this one will be a winner, I really am. -Original Message- From: Development [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:21 To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I'll second that Buffalo nomination! Jeff - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:07 PM Subject: RE: [admin] List status - A CHALLENGE No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf_browser
Anybody have suggestions for a more robust browser trapper? This seems to fail when there is no user agent provided. I get this error message. Var = Mid(#Source#,ST+Eposition,(ET-(ST+Eposition))) If it could report search engines as well that would be really cool. Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ 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: [admin] List status - A CHALLENGE
Not terribly long.. Its a 400 or so mile trip... Quicker to take a plane Beleive it or not, Buffalo even has its own airport.. ;-) Jeff - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:14 PM Subject: RE: [admin] List status - A CHALLENGE How long does it take to get there by train from Manhatten? At 02:07 PM 5/15/02, you wrote: No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: Get date/time from browser?
Hello all, We have clients in many different time zones, and we would like to find an easy way to get the local time from the browser rather than querying a time_zone table every time or setting a session variable. Almost like a reverse cfheader where we get info from the browser instead of sending it. Any ideas? Thanks. Ryan Hi, maybe I am missing part of your requirements, but this seems like a perfect place for javascript, no? SCRIPT language=JavaScript document.write(Date()+.) /SCRIPT -Craig Thomas __ 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: Subquery from the same table: Is it possible??
ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but this value is a variable. It changes as Microsoft® SQL Server(tm) examines different rows of the authors table. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Subquery from the same table: Is it possible??
James, You wrote ** whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' *** Where WHAT ?you have to specify a column with the same data type for your sub select to use as IN: WHERE fullname IN (Select fullname) -mk -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but this value is a variable. It changes as Microsoft® SQL Server(tm) examines different rows of the authors table. 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: Get date/time from browser?
Yeah, this solves part of my problem, is there any way to format the output? Kina like a dateformat/timeformat for javascript? Or maybe a datepart? Thanks. -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:44 AM To: CF-Talk Subject: RE: Get date/time from browser? Hello all, We have clients in many different time zones, and we would like to find an easy way to get the local time from the browser rather than querying a time_zone table every time or setting a session variable. Almost like a reverse cfheader where we get info from the browser instead of sending it. Any ideas? Thanks. Ryan Hi, maybe I am missing part of your requirements, but this seems like a perfect place for javascript, no? SCRIPT language=JavaScript document.write(Date()+.) /SCRIPT -Craig Thomas __ 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: Subquery from the same table: Is it possible??
cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but this value is a variable. It changes as MicrosoftR SQL Server(tm) examines different rows of the authors table. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Subquery from the same table: Is it possible??
almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but this value is a variable. It changes as MicrosoftR SQL Server(tm) examines different rows of the authors table. 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: Subquery from the same table: Is it possible??
You have to join the two tables even if it is the same one. However, this particular query makes no sense. This type of technique is best with the key manager where they have a connected key so you do something like this: Select * from tbl_users where role = (select role from tbl_users a,tbl_users b where a.role_owner=b.role and a.username = '#session.username#') this would be a case where role_owner is the manager and the role_owner key is matched to the role key for the subordinates. Margaret cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users a where fullname IN (select fullname from tbl_users a,tbl_users b where a.username=b.username and username = '#session.username#') /cfquery -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:07 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo
RE: Subquery from the same table: Is it possible??
Ummm.. I don't quite understand how that code is returning two instances of the key_role unless you have it in the database twice. Am I missing something here? If it does produce two instances, are they both the same? If they are, use the distinct keyword: cfquery name=GetKeyUser datasource=lsar_beta select distinct fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:07 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo Innes Panteley Sylvia Ringer Albert (9 row(s) affected) Unlike most of the subqueries shown earlier, the subquery in this statement cannot be resolved independently of the main query. It needs a value for authors.au_id, but
GetTickCount()
Is the GetTickCount() accurate to use for processing time? It appears to be a little of from the debug process time you can turn on in cfserver admin debug information. Shawn Regan __ 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: Subquery from the same table: Is it possible??
nope, only one person is designated as key role, but there are about six different ones, one for each manager. -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:22 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Ummm.. I don't quite understand how that code is returning two instances of the key_role unless you have it in the database twice. Am I missing something here? If it does produce two instances, are they both the same? If they are, use the distinct keyword: cfquery name=GetKeyUser datasource=lsar_beta select distinct fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:07 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whereIN (select fullname from tbl_users where username = '#session.username#') AND role LIKE 'key_user%' /cfquery -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:18 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Is it possible to have a subquery from the same table to output data based on a certain condition? Yes. It's called a correlated subquery. It's described very well in the SQL Server Books Online: Many queries can be evaluated by executing the subquery once and substituting the resulting value or values into the WHERE clause of the outer query. In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the subquery is executed repeatedly, once for each row that might be selected by the outer query. This query finds the names of all authors who earn 100 percent of the shared royalty (royaltyper) on a book. USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper FROM titleauthor WHERE titleauthor.au_ID = authors.au_id) Here is the result set: au_lname au_fname WhiteJohnson GreenMarjorie Carson Cheryl Straight Dean Locksley Charlene Blotchet-Halls Reginald del Castillo
Re: [admin] List status - A CHALLENGE
ROTFLMAO! My niece lives in East Palatka. Fortunately she still has all her teeth. Sharon - Original Message - From: Shawnea Carter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 7:44 AM Subject: Re: [admin] List status - A CHALLENGE and alligators, water moccasins and creepy guys that have been to one to many bar (For the natives: the ones (guys) in Central Florida that wear that ball cap like thing . . . think Palatka) I shudder. __ 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: Get date/time from browser?
Kina like a dateformat/timeformat for javascript? Or maybe a datepart? a mask? like yourDate(yy,mm,dd,hh,mm,ss). take a look at this: http://developer.netscape.com/viewsource/goodman_dateobject.html for an explanation of the Date object in javascript. -Craig Thomas __ 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: GetTickCount()
As far as I know it is accurate. Enclosing code between two function calls will give you the time it took to execute the code. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: GetTickCount()
Is the GetTickCount() accurate to use for processing time? It appears to be a little of from the debug process time you can turn on in cfserver admin debug information. Yes, it's as accurate as the rest of CF's timekeeping. 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
How big a file can CFFILE work with
Does anyone have any rules of thumb for how big a file CFFILE READ can safely work with? Andy __ 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: Get date/time from browser?
Thanks for the help, this should do the trick, I'll do some reading and post again if I need help. Thx again. -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:30 AM To: CF-Talk Subject: RE: Get date/time from browser? Kina like a dateformat/timeformat for javascript? Or maybe a datepart? a mask? like yourDate(yy,mm,dd,hh,mm,ss). take a look at this: http://developer.netscape.com/viewsource/goodman_dateobject.html for an explanation of the Date object in javascript. -Craig Thomas __ 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: Subquery from the same table: Is it possible??
Mark, Perhaps I am confusing you. On my output i am using the same query at least that is what i was planning to do. There is also a query just for the role. I am not sure if I can delete it and use the other instead. cfquery name=GetRole datasource=lsar_beta select role fromtbl_users where username = '#session.username#' /cfquery -- OUTPUT FOR KEY USER cfif getrole.role IS user_self Sandy Crisafulli cfelseif getrole.role CONTAINS trimble cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelseif getrole.role IS user_miller cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelseif getrole.role CONTAINS reich_godd cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelseif getrole.role CONTAINS cooper cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelseif getrole.role CONTAINS feinroth cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelseif getrole.role CONTAINS edmounds cfoutputinput type=text name=receiver value=#getkeyuser.fullname# size=20 readonly/cfoutput cfelse /cfif -- OUTPUT FOR USER cfoutputinput type=Text name=sender value=#getkeyuser.fullname# size=20 readonly/cfoutput -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:21 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? nope, only one person is designated as key role, but there are about six different ones, one for each manager. -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:22 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? Ummm.. I don't quite understand how that code is returning two instances of the key_role unless you have it in the database twice. Am I missing something here? If it does produce two instances, are they both the same? If they are, use the distinct keyword: cfquery name=GetKeyUser datasource=lsar_beta select distinct fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:07 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? almost like the same output I got with this, but it produces the same name in both fields. My code prodcues two instances of USER and your code produces two instances of the KEY USER. Getting closer though... cfquery name=GetKeyUser datasource=lsar_beta select fullname, role fromtbl_users where fullname IN (select fullname from tbl_users where username = '#session.username#') /cfquery -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:06 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users whererole = ( select 'key_' role as keyrole from tbl_users where username = '#session.username#') /cfquery See if that works for you. It's an educated guess. - Matt Small -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:47 AM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? ok. Interesting. Here is my situation. I will try to explain it has best I can. I have a response form that inserts the user into one field via session variable. The other field needs another name based on the role of the first. ROLE is a field in my database. Here is an example: USERNAMEFULLNAMEROLE djohnsonDenise Johnson key_user_miller twendel Tom Wendel user_miller If Tom Wendel opens a response form, his name is inserted into a field called 'sender'. I want the 'receiver' to be Denise Johnson. This is but one possible scenario as I have one key user for a manager and several users that fall under the same manager. Total of about 6 managers each with one key user to manage the users. Is this possible to use a subquery based on the way the data is structued now or do I need to make a change? I tried something like this, but got an error which did not surprise me. cfquery name=GetKeyUser datasource=lsar_beta select fullname, role from tbl_users
FileDate from cfftp-listdir
Hi readers, i'm writing a little script for backing up a server to antoher via ftp. everything works except of on thing. i only want to do backup files where the date of the remote ftp-file is newer than the local one. but cfftp shows the correct date only on a few from hundred of files. almost every files LastModified property is 30.12.1899 (after formatting it with #DateFormat(CreateODBCDateTime(LastModified), 'dd.mm.')#). am i missing something??? when list the remote dir with my ftp-client it shows the correct dates... curious about this -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Yo Macromedia: CFMX and UUID Issue!
That may be true, but in my opinion, the potential loss of performance is easily offset by the ability to do more in your applications, without as plus you get to climb on the buzz word bandwagon for free. webservices, j2eee, xml, internationalization, remoting, gitchy-gitchy-ya-ya __ 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: Get date/time from browser?
Check out the documentation on the site for the date function library for FusionScript. All the functions are portable and can be used with or without FusionScript. You can just rip out any of the libraries or functions- they are under /fusionscript/api/functions/library/... in the D/L package. FusionScript has nearly 100 native CF functions that have been ported to JavaScript for use - for example, all of the list handling libraries are available. You can check out what functions are available by hitting the site : www.fusionscript.com -- hit online documentation - go toLanguage Reference -- Functions -- Date -- etc. Nate Nielsen FusionScript DevTeam [EMAIL PROTECTED] Develop CF apps that talk to the server without page reloads ! Create client functionality with CF syntax ! www.FusionScript.com A free, Open Source project by and for the CF web community ! - Original Message - From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:29 AM Subject: RE: Get date/time from browser? Kina like a dateformat/timeformat for javascript? Or maybe a datepart? a mask? like yourDate(yy,mm,dd,hh,mm,ss). take a look at this: http://developer.netscape.com/viewsource/goodman_dateobject.html for an explanation of the Date object in javascript. -Craig Thomas __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
dynamic select boxes in netscape don't work
I'm writing an app that will use dynamic select boxes. you know, the ones where you select something in one box and it populate the other select box with the appropiate choices. the problems is that I'm trying to get this to work in netscape 4.79 for windows and it isn't working. works fine in ie6 of course but netscape won't execute the javascript. I searched google groups and someone said that netscape option array is read-only. another person said that after you execute the javascript to populate the options array, you have to use history.go(0) in order to refresh the page. anyone gotten this to work in netscape? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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: GetTickCount()
Shawn, One caveat to gettickcount( ). It does NOT return any values below 10 miliseconds. I surmise that it is a limitation of the process that tracks execution (perhaps where it is first initialized in the execution thread). -mk -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:14 AM To: CF-Talk Subject: GetTickCount() Is the GetTickCount() accurate to use for processing time? It appears to be a little of from the debug process time you can turn on in cfserver admin debug information. Shawn Regan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How big a file can CFFILE work with
Depends on your web server. IIS implements HTTP file uploads by storing the file to memory. CFFile then uses the file from memory (and writes it to disk, if that is what you want it to do). So in this case, the maximum size depends directly on how much available memory you have. In our case, we have a IIS/CF server, with SQL2000 (small load) that has 512 Meg of RAM. In optimum condiditions, we have shown that it can handle a 67 meg file. This decreases over time though as SQL Server uses more memory. Hope that helps. Shawn Grover -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:30 AM To: CF-Talk Subject: How big a file can CFFILE work with Does anyone have any rules of thumb for how big a file CFFILE READ can safely work with? Andy __ 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: dynamic select boxes in netscape don't work
what exactly is the problem you are having? I have done this in javascript before and it works in netscape. How are you going about creating the options for the second box? If you could post your code I may be able to offer more help. Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Inserting into 2 tables with a relationship
I have a database with 2 tables one has a relationship with the other and when I do an insert I need to insert into table 1 and insert into table 2 with an var_id field that has not been generated until table 1 has been inserted into.. I am not sure what to do or how to do it.. I am using CF 5 and Access.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: GetTickCount()
I noticed when testing it last night. My call with getTickCount was different then the cfserver process time that I enabled in the cfserver admin. -Shawn Regan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:35 AM To: CF-Talk Subject: RE: GetTickCount() Is the GetTickCount() accurate to use for processing time? It appears to be a little of from the debug process time you can turn on in cfserver admin debug information. Yes, it's as accurate as the rest of CF's timekeeping. 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: [admin] List status - A CHALLENGE
A third vote for the Buffalo nomination - Original Message - From: Development [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 10:21 AM Subject: Re: [admin] List status - A CHALLENGE I'll second that Buffalo nomination! Jeff - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:07 PM Subject: RE: [admin] List status - A CHALLENGE No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: GetTickCount()
One caveat to gettickcount( ). It does NOT return any values below 10 miliseconds. I surmise that it is a limitation of the process that tracks execution (perhaps where it is first initialized in the execution thread). CF's timers apparently can't tell time in increments less than 10 milliseconds, whether you're using GetTickCount or just looking at execution times in debug output. So, any value you look at should be considered +/- 10 ms. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Inserting into 2 tables with a relationship
Use CFTRANSACTION so if the action fails you can rollback. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ 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: How big a file can CFFILE work with
Thanks. Yes it does help. I am using an ISP (Host Centric, the old Web 2010), so I don't know how much memory I have access to. The purpose of the upload is to add monthly sales/invoice data from a third party system such as Peachtree into a database that can be accessed from the web for sales forecasting. So far, an entire quarter of sales information is less than 500K. So if I understand you correctly, I should be ok from a memory perspective. Next question is what about processing time. Is there a limit on how long a single screen can run? Processing this file may take minutes (error checking plus file Insert and Update). -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:42 AM To: CF-Talk Subject: RE: How big a file can CFFILE work with Depends on your web server. IIS implements HTTP file uploads by storing the file to memory. CFFile then uses the file from memory (and writes it to disk, if that is what you want it to do). So in this case, the maximum size depends directly on how much available memory you have. In our case, we have a IIS/CF server, with SQL2000 (small load) that has 512 Meg of RAM. In optimum condiditions, we have shown that it can handle a 67 meg file. This decreases over time though as SQL Server uses more memory. Hope that helps. Shawn Grover -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:30 AM To: CF-Talk Subject: How big a file can CFFILE work with Does anyone have any rules of thumb for how big a file CFFILE READ can safely work with? Andy __ 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
MX, WebService, and XML - Help
Hi group, I'm trying to get a webservice to work with MX and it just won't behave. All I can get back is net.alethea.www.ArrayOfString@1283bf. IsXmlDoc returns NO. It should be, right? Below is the code and reference information needed to perform this action. Gez, Ben made it sound so easy. What is wrong with this picture? Thanks in advance. Xmethods service page: http://www.xmethods.net/ve2/ViewListing.po;jsessionid=QEWc8ECNga-JV_ZfW2JioH _c(QhxieSRM)?serviceid=7534 View the packet that should get returned: http://www.alethea.net/webservices/ZipCode.asmx/ZipCodeToAreaCode?ZipCode=64 114 The Code: cfinvoke webservice=http://www.alethea.net/webservices/ZipCode.asmx?WSDL; method=zipCodeToAreaCode returnvariable=AreaCodePacket cfinvokeargument name=zipCode value=64114/ /cfinvoke cfoutput AreaCodePacket : #AreaCodePacket#br isXmlDoc(AreaCodePacket) : #isXmlDoc(AreaCodePacket)#br /cfoutput Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to detect timeout session??
Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: MX, WebService, and XML - Help
if you do a cfdump on the variable you put the results into, you'll see the methods available to you from the result. call one of these for different result data: I used this: to get Beverly Hills, CA cfinvoke webservice=http://www.alethea.net/webservices/ZipCode.asmx?WSDL; method=ZipCodeToCityState returnvariable=res cfinvokeargument name=ZipCode value=90210 /cfinvoke cfdump var=#res# cfset this = res.getString() cfdump var=#this# -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 16:59 To: CF-Talk Subject: MX, WebService, and XML - Help Hi group, I'm trying to get a webservice to work with MX and it just won't behave. All I can get back is net.alethea.www.ArrayOfString@1283bf. IsXmlDoc returns NO. It should be, right? Below is the code and reference information needed to perform this action. Gez, Ben made it sound so easy. What is wrong with this picture? Thanks in advance. Xmethods service page: http://www.xmethods.net/ve2/ViewListing.po;jsessionid=QEWc8ECN ga-JV_ZfW2JioH _c(QhxieSRM)?serviceid=7534 View the packet that should get returned: http://www.alethea.net/webservices/ZipCode.asmx/ZipCodeToAreaC ode?ZipCode=64 114 The Code: cfinvoke webservice=http://www.alethea.net/webservices/ZipCode.asmx?WSDL; method=zipCodeToAreaCode returnvariable=AreaCodePacket cfinvokeargument name=zipCode value=64114/ /cfinvoke cfoutput AreaCodePacket : #AreaCodePacket#br isXmlDoc(AreaCodePacket) : #isXmlDoc(AreaCodePacket)#br /cfoutput Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: GetTickCount()
Dave, It must be able to tell values in increments of less then 10 - otherwise I would never see 35 or 16 or 18 mils. I would only see 30, 20 or 10 right? Isn't it just for processes that tick below 10 mils (like a query that runs for 8 mils) that it has a problem? I see variance in the numbers - just nothing below 10. Your take? -mk -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:57 AM To: CF-Talk Subject: RE: GetTickCount() One caveat to gettickcount( ). It does NOT return any values below 10 miliseconds. I surmise that it is a limitation of the process that tracks execution (perhaps where it is first initialized in the execution thread). CF's timers apparently can't tell time in increments less than 10 milliseconds, whether you're using GetTickCount or just looking at execution times in debug output. So, any value you look at should be considered +/- 10 ms. 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: GetTickCount()
Ok thanks, Dave! -Shawn Regan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:57 AM To: CF-Talk Subject: RE: GetTickCount() One caveat to gettickcount( ). It does NOT return any values below 10 miliseconds. I surmise that it is a limitation of the process that tracks execution (perhaps where it is first initialized in the execution thread). CF's timers apparently can't tell time in increments less than 10 milliseconds, whether you're using GetTickCount or just looking at execution times in debug output. So, any value you look at should be considered +/- 10 ms. 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: [SOT] CF on OS X... just venting
On Wednesday, March 20, 2002, at 12:15 PM, Dave Watts wrote: And again, while OS X can run all this nifty software, who's actually buying servers from Apple? http://www.wired.com/news/medtech/0,1286,50454,00.html Can you rack-mount those new iMacs? Yes, now you can... and quite nicely! http://www.apple.com/xserve/ http://www.terrasoftsolutions.com/products/gvs9000/ Macs pack serious power. Yes, but at a pretty poor price/performance point for general business computing. Floating-point math (using AltiVec on PPC) is one thing, relational database front-ends are another. I'm not a big fan of IDE-based RAID, either, which is what Terra Soft offers, I think. I am not up on server prices, but I imagine the latest from apple are competitive on p/p, no? 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: Yo Macromedia: CFMX and UUID Issue!
Is there like a certification program for gitchy-gitchy-ya-ya - it sounds pretty robust. How does it handle in B2B implementations? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:39 AM To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! That may be true, but in my opinion, the potential loss of performance is easily offset by the ability to do more in your applications, without as plus you get to climb on the buzz word bandwagon for free. webservices, j2eee, xml, internationalization, remoting, gitchy-gitchy-ya-ya __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [SOT] CF on OS X... just venting
Wow, those look freaking amazing. Yes, now you can... and quite nicely! http://www.apple.com/xserve/ Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: How to detect timeout session??
I do a similar check but at the top of the page so it also catches people who haven't logged in at all. If the session variables are not defined or don't have the correct values (clicking logout changes to invalid value) then it redirects to the login page. This is both security for direct calls to the individual page and manages session timeouts in one. Margaret -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:21 AM To: CF-Talk Subject: RE: How to detect timeout session?? put this in application.cfm cfif (logic to check timeout) cfset fuseAction = login // fusebox style OR cflocation url=login.cfm // be careful here that you don't end up in an endless loop since application.cfm will be called again when the location happens /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:50 AM To: CF-Talk Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: [SOT] CF on OS X... just venting
Wow, those look freaking amazing. Just wait until they start making them in five different fluorescent colors like their iMacs. g Look at me! I have the prettiest server rack in town! -- Joe Schmoe, Future XServe owner. Ben Johnson Hostworks, Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Yo Macromedia: CFMX and UUID Issue!
Is there like a certification program for gitchy-gitchy-ya-ya - it sounds pretty robust. How does it handle in B2B implementations? yeah but its requirements are a bit stiff, public singing, disrobing in public places liberal applications of makeup--i'll never pass __ 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
A Tip (maybe new, maybe not)
I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. If you send a bogus query (one with an error), CF or Access will 'unlock' the file for you... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT : js submit into new window...
Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
Is there any way to touch a file and update its dateLastModifie d?
Is there any way to touch a file and update its dateLastModified? I'm trying to archive files after 5 days that are moved over to the CF server for download but they are retaining their dateLastModified from their original location. I've checked the file properties in the OS and the date created is the value I want because it shows when they were copied into the folder. How do I access date created as opposed to dateLastModified? Thanks in advance, Margaret -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:43 AM To: CF-Talk Subject: OT : js submit into new window... Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: OT : js submit into new window...
This works in IE, but I haven't tested it in NN. snip html head titleUntitled/title SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- function subForm(obj) { window.open(,WinName,width=500,height=300); obj.submit(); } //-- /SCRIPT /head body form action=http://www.site.com/action.cfm; target=WinName input type=text name=txtSomething input type=button value=Click Me onclick=subForm(this.form); /form /body /html /snip Enjoy! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:43 AM To: CF-Talk Subject: OT : js submit into new window... Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [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: Trouble with Access and Single Numbers
It's set to auto. After hours of stumbling around try'n sql functions and CF formatting I finally tried the left function in the SELECT statement. cfquery name=CourseDetail datasource=OITracker dbtype=OLEDB SELECT CourseName, CourseDate, LEFT(CourseHours, 6) As CourseHours FROM Course WHERE Course.CourseID = #URL.CourseID# /cfquery For what ever reason this works and pulls in the decimals as I intended them to be. So this will serve as a work around for me, but I still don't understand what's going on. Thanks -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:35 AM To: CF-Talk Subject: RE: Trouble with Access and Single Numbers Do you have the decimal places set to something other than Auto? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:41 AM To: CF-Talk Subject: Trouble with Access and Single Numbers I'm having some trouble with pulling some values out of Access. The field is defined as a number with a field size as single. The problem is CF is retrieving some decimal values all funny. 2.6 is retrieved as 2.599 1.7 is 1.7 1.9 is 1.9 2.9 is 2.901 9.99 is 9.988 Crazy stuff. They all look fine and as they with in Access but when I retrieve them with a straight Select in CF funny things happen. I can only guess that it something to do with single precision thing, but what to do. Any help Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: [SOT] CF on OS X... just venting
Wow, those look freaking amazing. Just wait until they start making them in five different fluorescent colors like their iMacs. g But I love the brushed aluminum look, very nice. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ 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
Anybody have a nice CFERROR page for me?
Anybody have a really nice CFERROR page that mails the site administrator all of the error information plus a listing of the variables and database queries etc? Thanks... __ 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: GetTickCount()
It must be able to tell values in increments of less then 10 - otherwise I would never see 35 or 16 or 18 mils. I would only see 30, 20 or 10 right? Isn't it just for processes that tick below 10 mils (like a query that runs for 8 mils) that it has a problem? I see variance in the numbers - just nothing below 10. Your take? What I've been told is simply that the accuracy of CF's timers is +/- 10 milliseconds, so anytime you see a value, such as 18 ms, it could be in actuality anywhere between 8 or 28 ms. This manifests itself in the display of either 0 or 10 ms for any values low enough, again according to what I've been told. 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: Recommend a replacement for CFMAIL
http://www.gammadyne.com/mmail.htm Gammadyne mailer is the most awesome mail utility i've ever used. Amazingly the guy only wants about $100. Cheers, Jon -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:19 AM To: CF-Talk Subject: Recommend a replacement for CFMAIL Can anyone recommend a good replacement for CFMAIL, should able to handle bulk emails (~20k/day) reliably. Should not cost more than US$ 100. I'm aware of activmail and iMS. Anyone using anything else and happy with the peformance? Pls advise. Thanks. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What do you use to send out HTML NEWSLETTERS from your site
You want to use gammadyne mailer. It is the hands down best mail software I've ever used. The author wants a miniscule $100 for the license, and you'll get to send out TONS of email based on addresses in your database. It does all kinds of stuff. Really awesome software! A+++ Beats anything I've seen before. Don't even think about using CFMAIL its a joke. http://www.gammadyne.com/mmail.htm I wrote a custom tag that interfaces to gammadyne over the command line via CFEXECUTE and it starts the gammadyne process running in a non blocking mode from CF. You can use gammadyne's GUI interface too. Hope this helps. Cheers, Jon -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 4:56 AM To: CF-Talk Subject: What do you use to send out HTML NEWSLETTERS from your site We're building an application to send out HTML email newsletters, the application needs to integrate with our SQL database for personalization and needs to support HTML templates for each newsletter, as the basic format and layout of each email stays the same and we just replace the content which consists of text. We've tried using the CF_HTMLAREA and CF_ActivEdit tags as WYSIWYG editors for entering the text into the templates but have found that this bloats up the HTML and it ends up large and clunky - not really good for email!!. We're also having problems getting the text to display properly, word wraps, line spacing etc. This effort is getting frustrating. There must be a ton of ways to effectively send out and manage hi quality HTML emails from our site (I get tons of well composed spam every day) and it seems like we're trying to reinvent the wheel when the garage is just next door!! Can anyone help in recommending a good product or service or source code or even just an idea or suggestion. Thanks for your time. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ 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: OT : js submit into new window...
script language=JavaScript function PopUpWindow(TargetURL, WindowName, wWidth, wHeight) { var newPop = window.open(TargetURL, WindowName, width='+wWidth+', height='+wHeight+', menubar, scrollbars, resizable, status, toolbar, location'); } /script a href=javascript:PopUpWindow('yourFile.cfm','Pictures','600','450');font color=##00*Pictures/font/a of this rotation.br David DiPietro Systems Developer / Engineer OSU College of Medicine Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:43 PM To: CF-Talk Subject: OT : js submit into new window... Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [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: dynamic select boxes in netscape don't work
function ChangeSubCategories(obj){ cfloop query=GetCategories cfstoredproc procedure=WEBGetSubCategories datasource=#request.dsn# username=#request.username# password=#request.password# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@FK_tblCategories value=#GetCategories.FK_tblCategories# maxlength=20 null=No cfprocresult name=GetSubCategories /cfstoredproc if(obj.value == cfoutput#GetCategories.FK_tblCategories#/cfoutput){ document.form1.tblSubCategories_name.options.length = cfoutput#GetSubCategories.RecordCount#/cfoutput; cfoutput query=GetSubCategories cfset i = GetSubCategories.CurrentRow - 1 document.form1.tblSubCategories_name.options[#i#].text = #GetSubCategories.Name#; document.form1.tblSubCategories_name.options[#i#].value = #GetSubCategories.Name#; /cfoutput } /cfloop if(obj.value == ){ document.form1.tblSubCategories_name.options.length = 1; document.form1.tblSubCategories_name.options[0].text = Choose a category first; document.form1.tblSubCategories_name.options[0].value = ; } } Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:47 AM To: CF-Talk Subject: Re: dynamic select boxes in netscape don't work what exactly is the problem you are having? I have done this in javascript before and it works in netscape. How are you going about creating the options for the second box? If you could post your code I may be able to offer more help. Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT : js submit into new window...
you could always just use the attribute target=_blank inyour form tag. That is if your not trying to control the type of new window, size and tec.. -Shawn Regan -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:45 AM To: CF-Talk Subject: RE: OT : js submit into new window... This works in IE, but I haven't tested it in NN. snip html head titleUntitled/title SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- function subForm(obj) { window.open(,WinName,width=500,height=300); obj.submit(); } //-- /SCRIPT /head body form action=http://www.site.com/action.cfm; target=WinName input type=text name=txtSomething input type=button value=Click Me onclick=subForm(this.form); /form /body /html /snip Enjoy! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:43 AM To: CF-Talk Subject: OT : js submit into new window... Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA- Tyler Silcox email | [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to detect timeout session??
cfif Datediff(n, client.LastVisit, now()) GTE 40 cflocation url=#request.serverroot# addtoken=No /cfif put this in your application.cfm. make sure to client variables enabled. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:23 PM To: CF-Talk Subject: RE: How to detect timeout session?? I do a similar check but at the top of the page so it also catches people who haven't logged in at all. If the session variables are not defined or don't have the correct values (clicking logout changes to invalid value) then it redirects to the login page. This is both security for direct calls to the individual page and manages session timeouts in one. Margaret -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:21 AM To: CF-Talk Subject: RE: How to detect timeout session?? put this in application.cfm cfif (logic to check timeout) cfset fuseAction = login // fusebox style OR cflocation url=login.cfm // be careful here that you don't end up in an endless loop since application.cfm will be called again when the location happens /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:50 AM To: CF-Talk Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ 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: A Tip (maybe new, maybe not)
There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. If you send a bogus query (one with an error), CF or Access will 'unlock' the file for you... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ 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: Inserting into 2 tables with a relationship
The problem I am having is that it adds the variable to the field, but it won't update the var_id that has the relationship with the main table it adds a 0 in the field.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:53 AM To: CF-Talk Subject: Re: Inserting into 2 tables with a relationship Use CFTRANSACTION so if the action fails you can rollback. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists