Re: CF MailServer On-Line Check?
Howie, You Rock! Thanks! I was just getting ready to decrypt the admin modules to try and find it... Now I don't have to. Once again, Thanks! At 09:22 PM 5/9/02 -0400, you wrote: It's an undocumented function: cfusion_verifymail(server,port,timeout) If it connects properly, the result is an empty string. If it cannot connect it is: Unable to connect to mail server. Example: cfusion_verifymail(mail.domain.com,25,10) HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 6:51 PM Subject: CF MailServer On-Line Check? I seem to recall there was a way to get CF to check if a mailserver is up and responding... but searching the forums I can't seem to find anything. Would someone please direct me? thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session cookies to expire immediately on browser close
This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- !--- At times developers are frustrated that the session does not end when the user closes their browserthat they must wait for the session to time out. If youve found yourself wishing for this behavior in session variables, youll be happy to know that you can implement this very easily: --- cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif !--- Place this code right beneath your cfapplication tag. This code first checks to see if the cookies CFID and CFTOKEN exist. Remember that ColdFusion will try to set these as cookie variables in the cfapplication tag. If they are there, set by cfapplication (and due to the peculiar way cookies operate, they will appear to be present even if the user has their cookies turned off), the value of these cookies will be read into two local variables. Then the pair of cookies will be overwritten, using the same values they had previously, but this time deliberately omitting the expires property of the cfcookie tag. Leaving off the expires property causes the cookie to remain in the browser memory, but not to be written to the users disk. When the browser is closed, the cookie information goes with it and, by inference, so goes the session. --- At 02:04 PM 5/10/02 +0800, you wrote: hihi.. where am i suppose to put this.. if i want to set cookie to expire when browser close.?? cfcookie expires=NOW name=CFID value=#cookie.cfid# is it at application.cfm? cheers han __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session cookies to expire immediately on browser close
Brian, this is a great snippet!!! Thanks. I have been wondering how to force the session to die without an explicit logout. This will definately do the trick. Cheers, Jeff Garza - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 11:39 PM Subject: Re: session cookies to expire immediately on browser close This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- !--- At times developers are frustrated that the session does not end when the user closes their browser-that they must wait for the session to time out. If you've found yourself wishing for this behavior in session variables, you'll be happy to know that you can implement this very easily: --- cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif !--- Place this code right beneath your cfapplication tag. This code first checks to see if the cookies CFID and CFTOKEN exist. Remember that ColdFusion will try to set these as cookie variables in the cfapplication tag. If they are there, set by cfapplication (and due to the peculiar way cookies operate, they will appear to be present even if the user has their cookies turned off), the value of these cookies will be read into two local variables. Then the pair of cookies will be overwritten, using the same values they had previously, but this time deliberately omitting the expires property of the cfcookie tag. Leaving off the expires property causes the cookie to remain in the browser memory, but not to be written to the user's disk. When the browser is closed, the cookie information goes with it and, by inference, so goes the session. --- At 02:04 PM 5/10/02 +0800, you wrote: hihi.. where am i suppose to put this.. if i want to set cookie to expire when browser close.?? cfcookie expires=NOW name=CFID value=#cookie.cfid# is it at application.cfm? cheers han __ 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: session cookies to expire immediately on browser close
hmm.. funnies... plugged yr codes into my application.cfm but doesnt seem to work... is there some other setting need to be configured at browser setting.. or Server side.? cheers han - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 3:14 PM Subject: Re: session cookies to expire immediately on browser close Brian, this is a great snippet!!! Thanks. I have been wondering how to force the session to die without an explicit logout. This will definately do the trick. Cheers, Jeff Garza - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 11:39 PM Subject: Re: session cookies to expire immediately on browser close This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- !--- At times developers are frustrated that the session does not end when the user closes their browser-that they must wait for the session to time out. If you've found yourself wishing for this behavior in session variables, you'll be happy to know that you can implement this very easily: --- cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif !--- Place this code right beneath your cfapplication tag. This code first checks to see if the cookies CFID and CFTOKEN exist. Remember that ColdFusion will try to set these as cookie variables in the cfapplication tag. If they are there, set by cfapplication (and due to the peculiar way cookies operate, they will appear to be present even if the user has their cookies turned off), the value of these cookies will be read into two local variables. Then the pair of cookies will be overwritten, using the same values they had previously, but this time deliberately omitting the expires property of the cfcookie tag. Leaving off the expires property causes the cookie to remain in the browser memory, but not to be written to the user's disk. When the browser is closed, the cookie information goes with it and, by inference, so goes the session. --- At 02:04 PM 5/10/02 +0800, you wrote: hihi.. where am i suppose to put this.. if i want to set cookie to expire when browser close.?? cfcookie expires=NOW name=CFID value=#cookie.cfid# is it at application.cfm? cheers han __ 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: cffile and locking
The OS will raise an exception if two processes try to access a file at the same time, which in turn will cause CF to throw an error. As a general rule, always use error handling when accessing files from any computer language. cftry cffile ... cfcatchCouldn't access file.../cfcatch /cftry jon Webmaster wrote: Do you need to lock a cffile append. I have a site that logs to a file every time a order is placed. Has anyone run into a problem if two threads try to write at the same time? __ 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: Looping in a Query
cfquery name=getnews datasource=#request.MainDSN# debug SELECT n.createdby, n.id, n.category, n.createdon, n.killdate, n.body, n.viewby FROM news n WHERE n.category = 3 AND n.killdate = #attributes.currenttime# AND ( cfloop list=#session.curruser.offices.list# index=e #ListContains(n.viewby, e)# 0 OR /cfloop n.id = 1 ) /cfquery OK, first of all you've got to realise how CF talks to SQL It builds the whole SQL Query, then sends it to the SQL Engine... Since SQL doesn't run ColdFusion, you can't use CF tags within SQL statements You'd have to deal with it as a list of ORs; cfloop list=#session.curruser.offices.list# index=e ',' + n.viewby + ',' like '%,#e#,%' OR /cfloop Now, the reason I put the ',' + n.viewby + ',' rather than just n.viewby is because it probably doesn't have commas on either end, so you've got to check for these And you can't do N.viewby like '#e#' As if e is 1, then 1, 10, 11, 12, 21, etc. etc. are all like it... Try to Normalize though, it'll save you heart-ache in the future Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: John Kivus [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 03:37 To: CF-Talk Subject: Looping in a Query I'm having a mental block trying to write a query. I have a list of numbers (which are in no particular order) and I need to see if just one of those numbers is in a field in the database which also has a list of numbers. I figured I'd use a cfloop inside my query by I'm having a little trouble. When I try it cannot resolve n.viewby. Am I really missing the boat on this one? Or I do I have a minor mistake? For some reason I think there just must be a better way. Sincerely, John Kivus 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 __ 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: List of File extensions
To state the next obvious: Internet Explorer Google Press Enter Search Read file types Sorry, couldn't resist :OP -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: 09 May 2002 23:35 To: CF-Talk Subject: RE: List of File extensions To state the obvious: Explorer tools options file types Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: UXB Internet [mailto:[EMAIL PROTECTED]] Sent: Friday, 10 May 2002 10:21 a.m. To: CF-Talk Subject: OT:List of File extensions Does anyone know where I can find a fairly comprehensive list of commonly used Windows based file extensions? We are building a file archive application and would like to present an Icon and description for each of the various file types the users will upload. Example: PDF = (Portable Document Format) Adobe DOC = Microsoft Word Document XLS = Microsoft Excel Workbook tif = Tagged Image Format File ZIP = PKZip Archive/WinZip Archive ..and so on. I have a list of about 20 or so of the more common office type extensions but would like to be a bit more comprehensive. Any assistance is appreciated. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ __ 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: List of File extensions
Hi all, I got a question from a colleague a few mins ago and thought someone here might be able to shed some light on it as it is CF5 related (I'm still developing on 4.5.1). Basically, my colleague has noticed that error templates are delivered with the http 500 Internal Server Error header as opposed to the normal http 200 OK header being returned with previous versions of CF. He wants to know how to enforce the 200 OK header instead so as to take advantage of IE's in built show friendly error messages function that some of his users may have set in their browsers. So far he has tried creating a site-wide error handler template and tried to set the 200 OK response header using CFHeader. Is there anything else he should try? I realise that it is actually best practice to return errors with an http 500 response, however he wishes to take advantage of the IE feature mentioned earlier. TIA, Dave __ 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
modifying the http response header in the cf5 error handler
Hi all, Sorry that previous message had wrong subject line. I got a question from a colleague a few mins ago and thought someone here might be able to shed some light on it as it is CF5 related (I'm still developing on 4.5.1). Basically, my colleague has noticed that error templates are delivered with the http 500 Internal Server Error header as opposed to the normal http 200 OK header being returned with previous versions of CF. He wants to know how to enforce the 200 OK header instead so as to take advantage of IE's in built show friendly error messages function that some of his users may have set in their browsers. So far he has tried creating a site-wide error handler template and tried to set the 200 OK response header using CFHeader. Is there anything else he should try? I realise that it is actually best practice to return errors with an http 500 response, however he wishes to take advantage of the IE feature mentioned earlier. TIA, Dave __ 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: Certified CF Developer? (my experience)
I just took the test yesterday (at Figleaf in DC no less), passed w/ Advanced. The test is $150 with 15% off if you buy the MM study guide book, which makes it roughly pay for itself. I didn't take any course, just studied out of the 4.5 study guide (for v5 __ 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: Certified CF Developer? (my experience)
Where can I get this MM study guide book? -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 8:29 AM To: CF-Talk Subject: RE: Certified CF Developer? (my experience) I just took the test yesterday (at Figleaf in DC no less), passed w/ Advanced. The test is $150 with 15% off if you buy the MM study guide book, which makes it roughly pay for itself. I didn't take any course, just studied out of the 4.5 study guide (for v5 __ 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: Certified CF Developer? (my experience)
http://www.amazon.com/exec/obidos/ASIN/0789726963/qid=1021034121/sr=1-6/ref=sr_1_6/103-1794365-1138237 Certified ColdFusion 5 Developer Study Guide by Ben Forta, Emily Kim (Contributor), Matthew Reider (Contributor) Publisher: Macromedia Press; ISBN: 0789726963; 1st edition (January 15, 2002) Ryan Pieszak [EMAIL PROTECTED] 05/10/02 08:31AM Where can I get this MM study guide book? -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 8:29 AM To: CF-Talk Subject: RE: Certified CF Developer? (my experience) I just took the test yesterday (at Figleaf in DC no less), passed w/ Advanced. The test is $150 with 15% off if you buy the MM study guide book, which makes it roughly pay for itself. I didn't take any course, just studied out of the 4.5 study guide (for v5 __ 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
Can cfoutput group= be nested?
I have a query with columns like this like this CategorySubCategory SubSubcategory Name And I'm trying to accomplish an output similar to this. Category SubCategory SubSubCategory Name Name Name Category SubCategory SubSubCategory Name Name Name etc... Can I nest cfoutput groups like this? cfoutput query=myQuery group=category #category# cfoutput query=myQuery group=subcategory #subcategory# cfoutput query=myQuery group=subsubcategory #subsubcategory# cfoutput#name#/cfoutput /cfoutput /cfoutput /cfoutput Thanks :) Eric __ 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
THANK YOU Re: Data From The Mainframe Line Ending Codes
CF-Pros: I'd like to publicly acknowledge, and thank, Jim Curran and Ben Johnson for their assistance on this problem. Jim, you nailed it -- I'd reversed the codes #chr(10)##chr(13)# instead of #chr(13)##chr(10)# ! I feel like such a dope: I examined two other programs that worked for previous projects and never saw that in this particular program I had reversed the codes. Talk about not seeing the forest for the trees ! Again, thank you, your assistance was much appreciated. Have a great day. -Gerry Gerard T. Pauline Mgr, Internet/DB Applications Computer Systems, DoIT Pace University Jim Curran wrote: CFLOOP INDEX=row LIST=#variables.WP_UPDATES# DELIMITERS=#chr(13)##chr(10)# 13 is CR 10 is LF See if that helps. - j -Original Message- From: Gerry Pauline [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:45 PM To: CF-Talk Subject: Data From The Mainframe Line Ending Codes CF-Pros: I'm trying to deal with a file generated on our mainframe with CFFILE. I'm using CFFILE to read the contents into a variable and then parse out the contents; CFFILE seems to be working fine. The code is pretty standard: CFFILE ACTION=Read FILE=C:\InetPub\WWWroot\WhitePages\UpdateFiles\INTUPD.txt VARIABLE=WP_UPDATES The problem occurs when I try to parse out the records. I'm using the following code, which is also pretty standard: CFOUTPUT CFLOOP INDEX=row LIST=#variables.WP_UPDATES# DELIMITERS=#chr(10)##chr(13)# #row# P /CFLOOP /CFOUTPUT A record looks like this: 01;003307198;LORE,IRENE SUSAN ;A;6;2907;2907;;;[EMAIL PROTECTED] ; ; ;A;;3601245 ;MANAGEMENT; This is only one record, and most likely will wrap around on your screen (the record length is 216 characters). It seems I don't have the correct codes to indicate the end of the records. I've tried chr(10) and chr(13) separately, and in unison, as in the above example. Does anyone out there in CFExpertLand know what the correct line ending code would be ? Thank you. -Gerry Gerard T. Pauline Mgr, Internet/DB Applications Computer Systems, DoIT Pace University __ 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: Can cfoutput group= be nested?
Yes, you can nest grouped cfoutput's, not sure you need to query attribute beyond the first cfoutput though? MiKEY C! -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 13:43 To: CF-Talk Subject: Can cfoutput group= be nested? I have a query with columns like this like this CategorySubCategory SubSubcategory Name And I'm trying to accomplish an output similar to this. Category SubCategory SubSubCategory Name Name Name Category SubCategory SubSubCategory Name Name Name etc... Can I nest cfoutput groups like this? cfoutput query=myQuery group=category #category# cfoutput query=myQuery group=subcategory #subcategory# cfoutput query=myQuery group=subsubcategory #subsubcategory# cfoutput#name#/cfoutput /cfoutput /cfoutput /cfoutput Thanks :) Eric __ 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
refreshing CFID + CFTOKEN with client-side JavaScript?
I'm looking for a way of refreshing a user's session (i.e. setting the timeout back to 20 minutes or whatever) from the client-side - so users can click a button to refresh their session without the page they're on changing at all. How does CF manage session timeouts? I assume it's through the expire value of the CFID and/or CFTOKEN cookies. In which case, could I use client-side JavaScript to reset the expire value of these cookies? I've never used JS to manipulate cookies before: any ideas? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Can cfoutput group= be nested?
Thank you :) -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 8:44 AM To: CF-Talk Subject: RE: Can cfoutput group= be nested? Yes, you can nest grouped cfoutput's, not sure you need to query attribute beyond the first cfoutput though? MiKEY C! -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 13:43 To: CF-Talk Subject: Can cfoutput group= be nested? I have a query with columns like this like this CategorySubCategory SubSubcategory Name And I'm trying to accomplish an output similar to this. Category SubCategory SubSubCategory Name Name Name Category SubCategory SubSubCategory Name Name Name etc... Can I nest cfoutput groups like this? cfoutput query=myQuery group=category #category# cfoutput query=myQuery group=subcategory #subcategory# cfoutput query=myQuery group=subsubcategory #subsubcategory# cfoutput#name#/cfoutput /cfoutput /cfoutput /cfoutput Thanks :) Eric __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
Q. How does CF manage session timeouts? A. CF session variables timeout is primarily controlled by setting the maximum and minimum timeout in your CF Administrator. However, the values controlled by the CF Server can be overridden by setting your own timeout in the CFAPPLCATION tag SESSIONTIMEOUT attribute. e.g. CFAPPLICATION NAME=ETurtle SESSIONTIMEOUT=#CreateTimeSpan(0, 0, 0, 60)# SESSIONMANAGEMENT=Yes Session variables are stored as cookies on the client machine by default, hence the cookie containing the CFID and CFToken. Hope this sheds a bit of light of session variable timeouts? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 13:48 To: CF-Talk Subject: refreshing CFID + CFTOKEN with client-side JavaScript? I'm looking for a way of refreshing a user's session (i.e. setting the timeout back to 20 minutes or whatever) from the client-side - so users can click a button to refresh their session without the page they're on changing at all. How does CF manage session timeouts? I assume it's through the expire value of the CFID and/or CFTOKEN cookies. In which case, could I use client-side JavaScript to reset the expire value of these cookies? I've never used JS to manipulate cookies before: any ideas? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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
CFObject - creating an instance on the workstation
Is there a way to create an instance of excel on the user's machine using CFObject so that I can use the objExcel object even if the server doesn't have Excel installed? T __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
hi gyrus, i'm reading between the lines here, but if i'm understanding you correctly, you want to make sure the session closes when the browser closes--then and only then. if that's the case, i don't think you need js. take a look at the state management tutorials at hal helms' site (http://www.halhelms.com). the viewlet builder that runs them is a pain because it won't resize to 800x600 (in my case), but the information is worth the nuisance. ~ dina - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 7:48 AM Subject: refreshing CFID + CFTOKEN with client-side JavaScript? I'm looking for a way of refreshing a user's session (i.e. setting the timeout back to 20 minutes or whatever) from the client-side - so users can click a button to refresh their session without the page they're on changing at all. How does CF manage session timeouts? I assume it's through the expire value of the CFID and/or CFTOKEN cookies. In which case, could I use client-side JavaScript to reset the expire value of these cookies? I've never used JS to manipulate cookies before: any ideas? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Form.FIELDNAME - error!!!!
Well when I see your code I can see right off the bat that becuase there are quotes that you're setting it to a string. I think the pounds are an extra step, it's easier for to read, for me it's just as easy to read the quotes. To each his own. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:54 PM To: CF-Talk Subject: Re: Form.FIELDNAME - error I understand your point, but it is like saying periods clutter up pages in a book. If you have: cfset variables.my_var = #query.column# That tells me that there is a variable being set and it is a string cfset variables.my_var = query.column Am I setting my variable to the two words seperated by a period, query.column? or to a variable query.column? To each his own, but it makes more sense to me to see those pounds on the right hand side .. Plus reading a book with periods is easier too :) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder I think that the # on the right side of the set operand is redundant. CFSET my_var = #another_var# or CFSET my_var = another_var There is only one thing for *another_var* to be: a variable. If you wanted my_var to hold the string another_var you should quote the right hand side: CFSET my_var = another_var So my .02 is that pounds just clutter up your statement. Reuben Poon -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:35 PM To: CF-Talk Subject: Re: Form.FIELDNAME - error Importance: Low Tim, I wouldn't call that bad practice, It should actually be called good practice (at least in my book). You are setting a variable and the ## around the variable show that it is a variable, makes for easier reading. Now, ## on the set side would be considered bad practice. my .02 Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder Not sure if this is an error or just a bad practice, but you don't need the # signs in your variable declaration (cfset) CFSET var = ListGetAt(Form.FIELDNAMES, i) works just fine. Also you don't need to generate that var at all you can just do a list loop like this: CFLOOP list=#form.fieldnames# index=formField #formField# = #evaluate(formField)# CFLOOP Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:16 PM To: CF-Talk Subject: Form.FIELDNAME - error Hi, Can any one tell me what is the mistake in CFLOOP FROM=1 TO=#ListLen(FORM.FIELDNAMES)# STEP=1 INDEX=i CFSET var = #ListGetAt(Form.FIELDNAMES, i)# #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)# BR /CFLOOP I am getting the following error: An error occurred while evaluating the expression: #ListLen(FORM.FIELDNAMES)# Any help on this is appreciated. thanks, Sudheer Chakka. __ 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
Regex problems again...
Hi, Can anyone advise me with this Regex problem I'm having? I need to convert all instances of an HTML string into a bracketed number (taking the number from the URL string pid=n). At the moment, the following is converting the first instance perfectly.but no other ones after that, despite me telling it to! Here's the code: CFSET bodytext = REReplaceNoCase(bodytext, a href=viewphoto.cfm\?pid=([^]*).*/a, [\1], ALL) The HTML to strip would look like: a href=viewphoto.cfm?pid=100img border=0 src=imagebin/photolink.gif/a And this would turn it into [100] Any clues why it's not picking up all instances? Thanks Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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: CFObject - creating an instance on the workstation
No. ColdFusion can only use COM objects installed on the server. You can, however, format your data as a CSV file. If the user has Excel installed, it should be associated with the .csv extension. Not good for complicated Excel needs, but you're limited without the proper COM objects on the server. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 9:04 AM To: CF-Talk Subject: CFObject - creating an instance on the workstation Is there a way to create an instance of excel on the user's machine using CFObject so that I can use the objExcel object even if the server doesn't have Excel installed? T __ 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: Regex problems again...
Just a guess, but... Idea 1: I believe the regex in Cold Fusion is greedy. This means it will take the largest chunk of data that matches a particular expressions. If this is true, then the part of your expression that follows is going to stretch from the first anchor to the close of the LAST anchor. .*/a You might want to change to [^]*/a Idea 2: escape the quotes with \, just in case. I don;t think you need to, but you might. FWIW Jerry Johnson [EMAIL PROTECTED] 05/10/02 09:22AM Hi, Can anyone advise me with this Regex problem I'm having? I need to convert all instances of an HTML string into a bracketed number (taking the number from the URL string pid=n). At the moment, the following is converting the first instance perfectly.but no other ones after that, despite me telling it to! Here's the code: CFSET bodytext = REReplaceNoCase(bodytext, a href=viewphoto.cfm\?pid=([^]*).*/a, [\1], ALL) The HTML to strip would look like: a href=viewphoto.cfm?pid=100img border=0 src=imagebin/photolink.gif/a And this would turn it into [100] Any clues why it's not picking up all instances? Thanks Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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
CF and Teradata
Has anyone used CF with Teradata at all? Any experiences to relay? -Robyn __ 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: COM :: CF :: Wolfenstein Q3
well... if any one want to help me with this i would appreciate it. would give access to rcon while we work on it Private password, so when the server fills to 22-28 you can have one of the reserved private slots! ?? : ] ?? just something goofy to play with i know the gaming community would use.. -paul __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFObject - creating an instance on the workstation
At 09:31 AM 10/05/02 -0400, Carlisle, Eric wrote: No. ColdFusion can only use COM objects installed on the server. What do I need installed on the server to do this? Office Extensions? T __ 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
executing sql server dts package from cf
I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.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
That's the way the cookie crumbles
I am running CF 4.5.1 on WIN NT IIS 4.0..., intranet application There is a .cfm module that writes a cookie using; CFCOOKIE name=item#ID# value=#Last_Updated# expires=30 that has been working fine. Suddenly 99% of the clients now get; Page Cannot be displayed . but some people still have no problem viewing the page. When the line above that writes the cookie is removed all is well. Just wondering if anyone has experienced a similar problem and has any advice. Thanks __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFContent problem
I'm running the following test code: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body CFQUERY name=test datasource=#datasource# SELECT * FROMCompanies /CFQUERY cfset tab=chr(9) cfset carriage=chr(13) CFHEADER NAME=Content-Disposition VALUE=inline; filename=Yourfilename.xls CFCONTENT TYPE=application/msexcel Company Name CFOUTPUT QUERY=test #CompanyName##carriage# /CFOUTPUT /CFCONTENT /body /html And I'm getting this error: Error Diagnostic Information Context validation error in tag CFCONTENT The tag is not correctly positioned relative to other tags in the template: tag CFCONTENT must have empty content. This means that there can be no tags or text or even whitespace characters between the CFCONTENT and /CFCONTENT markers. What am I doing wrong? T __ 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: executing sql server dts package from cf
Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows. CFSET sArg = /S servername /U username /P password /N packagename CFEXECUTE name=c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe arguments=#sArg# outputfile=c:\MyExportLog.txt timeout=1800/ HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
- Original Message - From: Dina Hess [EMAIL PROTECTED] i'm reading between the lines here, but if i'm understanding you correctly, you want to make sure the session closes when the browser closes--then and only then. No - and I know about how to control the session variable to timeout from CF Admin or CFAPPLICATION, thanks Mike! :-) I thought I was pretty specific, but here it is again: How can I refresh the session on the client-side using JavaScript? I want the user to be able to press a button on a page which will have the same effect of any request to the server, i.e. CFID and CFTOKEN get reset to expire in 20 (or whatever) minutes. I just wanted to know: - Are CFID and CFTOKEN values within one cookie or separate cookies? - If separate, do both have their expire value set to the session timeout - meaning both would need to be refreshed to refresh the session - or is it just one of them? Which one? - Does anyone know how I would reset the expire value of the necessary cookie to 20 (or whatever) minutes using client-side JavaScript? Any help on this appreciated, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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
I take it NOBODY uses CLOBS...
Does anyone know how to insert into a CLOB more than 4000 characters? I am getting an error String to long Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 __ 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
Odd RDS/FTP options menu
This is odd...in Windows, right click (and hold down) on a web file in a folder that is considered a www folder and drag it a little bit and let go. You get right click options of Add RDS Server..., Add FTP Server... and Remove Macromedia FTP RDS If you do the same thing in Studio's file browser pane, you only get the first two options Has anyone else seen this before and can anyone replicate it? Is it supposed to be like that? FYI, I have CF Studio 5 and Dreamweaver MX Preview Release running on XP Pro. __ 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: I take it NOBODY uses CLOBS...
Yager, Brian T Contractor/NCCIM wrote: Does anyone know how to insert into a CLOB more than 4000 characters? I am getting an error String to long Use cfqueryparam to insert into clobs. Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing sql server dts package from cf
I use this code all of the time. I have changed some of the documentation on this code so that you will know what is going on. CFOBJECT TYPE=COM NAME=objDTS CLASS=DTS.Package ACTION=CREATE There are 3 primary locations DTS packages are generally loaded from: From SQL Server, from Storage File, or from repository. There are 3 different primary methods that can be executed, one for each of these DTS locations. LoadFromSQLServer Syntax: ObjectName.LoadFromSQLServer(ServerName, ServerUserName, ServerPassword, Flags, PackagePassword, PackageGuid, PackageVersionGuid, PackageName, pVarPersistStgOfHost) NOTE: If you want to retrieve the PackageGuid, PackageVersionGuid, PackageName from the database, run the sp_enum_dtspackages system stored procedure. It returns the following variables: name, id, versionid, description, createdate, owner, size, packagedata, isowner LoadFromStorageFile Syntax: ObjectName.LoadFromStorageFile(UNCFile, Password, PackageID, VersionID, Name, pVarPersistStgOfHost) LoadFromRepository Syntax: ObjectName.LoadFromRepository(RepositoryServerName, RepositoryDatabaseName, RepositoryUserName, RepositoryUserPassword, PackageID, VersionID, PackageName, Flags, pVarPersistStgOfHost) This is sample code to execute a (SQLServer) DTS from ColdFusion (objDTS is the Object I created, server is shorwith, username is sa with no password, test is the name of the DTS): CFTRY CFOBJECT TYPE=COM NAME=objDTS CLASS=DTS.Package ACTION=CREATE CFCATCH TYPE = Object CFSET error_message = The DTS Package Object Could Not Be Created. /CFCATCH /CFTRY CFTRY CFSET r = objDTS.LoadfromSQLServer(SHORWITH,sa,,0test,) CFCATCH CFSET error_message = The DTS Package Could Not Be Loaded From the SQL Server at this time. /CFCATCH /CFTRY CFIF IsDefined(error_message) CFOUTPUT#error_message#/CFOUTPUT /CFIF CFSET p = objDTS.Execute() -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:07 AM To: CF-Talk Subject: RE: executing sql server dts package from cf Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows. CFSET sArg = /S servername /U username /P password /N packagename CFEXECUTE name=c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe arguments=#sArg# outputfile=c:\MyExportLog.txt timeout=1800/ HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
restarting a service
Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards Mario __ 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: Regex problems again...
Mr Johnson does it again...thanks Jerry, works nicely. Will - Original Message - From: Jerry Johnson [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Friday, May 10, 2002 2:38 PM Subject: Re: Regex problems again... Just a guess, but... Idea 1: I believe the regex in Cold Fusion is greedy. This means it will take the largest chunk of data that matches a particular expressions. If this is true, then the part of your expression that follows is going to stretch from the first anchor to the close of the LAST anchor. .*/a You might want to change to [^]*/a Idea 2: escape the quotes with \, just in case. I don;t think you need to, but you might. FWIW Jerry Johnson [EMAIL PROTECTED] 05/10/02 09:22AM Hi, Can anyone advise me with this Regex problem I'm having? I need to convert all instances of an HTML string into a bracketed number (taking the number from the URL string pid=n). At the moment, the following is converting the first instance perfectly.but no other ones after that, despite me telling it to! Here's the code: CFSET bodytext = REReplaceNoCase(bodytext, a href=viewphoto.cfm\?pid=([^]*).*/a, [\1], ALL) The HTML to strip would look like: a href=viewphoto.cfm?pid=100img border=0 src=imagebin/photolink.gif/a And this would turn it into [100] Any clues why it's not picking up all instances? Thanks Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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: restarting a service
Couldn't you use CFEXECUTE and call a bat file that does a NET STOP and NET START ? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards 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
[no subject]
Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: table border=1 cellspacing=0 cellpadding=1 bgcolor=#ee bordercolor=Red tr bgcolor=#ee td valign=topDIVISION/td td valign=topPROGRAM_NAME/td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Bear Street /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Clipboard Solutions /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Emerson Associates /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Lake Avenue /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Smithfield road /td /tr tr td valign=top bgcolor=#ff Cambridge Health Alliance /td td valign=top bgcolor=#ff The Beck Ward /td /tr tr td valign=top bgcolor=#ff North East /td td valign=top bgcolor=#ff The Oliver Street House /td /tr /table into something like this: TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 BGCOLOR=#EE BORDERCOLOR=Red TR ALIGN=center TD COLSPAN=5Team/TD TD COLSPAN=1Cambridge Health Alliance/TD TD COLSPAN=1North East/TD /TR TR ALIGN=center BGCOLOR=#FF TD COLSPAN=1Bear Street/TD TD COLSPAN=1Clipboard Solutions/TD TD COLSPAN=1Emerson Associates/TD TD COLSPAN=1Lake Avenue/TD TD COLSPAN=1Smithfield road/TD TD COLSPAN=1The Beck Ward/TD TD COLSPAN=1The Oliver Street House/TD /TR /TABLE I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ 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
How Do I Flip A Table?
Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: table border=1 cellspacing=0 cellpadding=1 bgcolor=#ee bordercolor=Red tr bgcolor=#ee td valign=topDIVISION/td td valign=topPROGRAM_NAME/td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Bear Street /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Clipboard Solutions /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Emerson Associates /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Lake Avenue /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Smithfield road /td /tr tr td valign=top bgcolor=#ff Cambridge Health Alliance /td td valign=top bgcolor=#ff The Beck Ward /td /tr tr td valign=top bgcolor=#ff North East /td td valign=top bgcolor=#ff The Oliver Street House /td /tr /table into something like this: TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 BGCOLOR=#EE BORDERCOLOR=Red TR ALIGN=center TD COLSPAN=5Team/TD TD COLSPAN=1Cambridge Health Alliance/TD TD COLSPAN=1North East/TD /TR TR ALIGN=center BGCOLOR=#FF TD COLSPAN=1Bear Street/TD TD COLSPAN=1Clipboard Solutions/TD TD COLSPAN=1Emerson Associates/TD TD COLSPAN=1Lake Avenue/TD TD COLSPAN=1Smithfield road/TD TD COLSPAN=1The Beck Ward/TD TD COLSPAN=1The Oliver Street House/TD /TR /TABLE I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ 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: restarting a service
Or you could schedule the .bat file in Win 2000 scheduler = = = Original message = = = Couldn't you use CFEXECUTE and call a bat file that does a NET STOP and NET START ? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards Mario __ 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: restarting a service
If you're looking to schedule it I wouldn't even bring CF into the equation. Just create a batch file with net stop and a net start command for your service, and then use the NT scheduler to have it run at your desired times. Unless you need to be able to execute this via the web, there's no need to use CF at all. /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards Mario __ 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: restarting a service
We have a free cfx that you can use to query services and stop/start them. You can download it from: ftp://ftp.coolfusion.com/pub/ods/cfx_servicecontrol/cfx_servicecontrol.zip HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Mario Martinez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 10:13 AM Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards Mario __ 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: CFPOP Question
Thanks, but I think my real problem is the often-complained-about CFPOP attachments loop. I was hoping to find an easier way to send attachments through. I can make them viewable online with a hyperlink, but I can't seem to get cfmail to loop through the list. We are running CF 4.5.1 on Win2k. Here is the code I am using: (Everything works except the attachment thing). !--- CFMAIL FROM=#form.from# TO=#session.email# CC=#amessage.cc# SUBJECT=#amessage.Subject# SERVER=smtp.server.com TYPE=html Mailerid=Control Center Mimeattach=CFLOOP FROM=1 TO=#ListLen(amessage.Attachments, chr(9) #INDEX=i#amessage.attachments#/cfloop #Body#/CFMAIL --- - Original Message - From: Chris Lofback [EMAIL PROTECTED] Subject: RE: CFPOP Question Sarah: I assume the mail client is totally web-based? If so, I suppose you could have the download template copy the attachment file to a temp directory on the web server and then put an image link in the message that points to the image. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Sarah Skiba [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 11:37 AM To: CF-Talk Subject: CFPOP Question I'm developing a cfpop application and am nearly finished but have hit a rut... Is there any way to make an attachment, ie a .jpg file someone sent to grandma, appear in-line in the message so it gets downloaded with the attachment? I was able to make it embed as garbled text, and I am able to make it show up as an attachment, but is there anyway to display it the way OE or Eudora do? Thanks. Sarah Skiba __ 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 Do I Flip A Table?
You can do something like this: tabletr cfoutput query=MyQuery td#Division#/td /cfoutput /trtr cfoutput query=MyQuery td#Program_Name#td /cfoutput /tr/table But, it doesn't give you the column span values. In your query you could add Count(Division) as colspan to get the colspan numbers, but then you'll have trouble with duplicates. I can get it down to one database query and one query of a query: cfquery name=Loop2 select Division, Program_Name from table /cfquery cfquery dbtype=query name=Loop1 select Distinct Program_Name, Count(Division) as colspan from Loop2 /cfquery Then look similar to the way I Set up the above table: tabletr cfoutput query=Loop1 td colspan=#loop1.colspan##loop1.Division#/td /cfoutput /trtr cfoutput query=Loop2 td#loop2.Program_Name#td /cfoutput /tr/table At 10:33 AM 5/10/2002 -0400, you wrote: Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: table border=1 cellspacing=0 cellpadding=1 bgcolor=#ee bordercolor=Red tr bgcolor=#ee td valign=topDIVISION/td td valign=topPROGRAM_NAME/td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Bear Street /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Clipboard Solutions /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Emerson Associates /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Lake Avenue /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Smithfield road /td /tr tr td valign=top bgcolor=#ff Cambridge Health Alliance /td td valign=top bgcolor=#ff The Beck Ward /td /tr tr td valign=top bgcolor=#ff North East /td td valign=top bgcolor=#ff The Oliver Street House /td /tr /table into something like this: TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 BGCOLOR=#EE BORDERCOLOR=Red TR ALIGN=center TD COLSPAN=5Team/TD TD COLSPAN=1Cambridge Health Alliance/TD TD COLSPAN=1North East/TD /TR TR ALIGN=center BGCOLOR=#FF TD COLSPAN=1Bear Street/TD TD COLSPAN=1Clipboard Solutions/TD TD COLSPAN=1Emerson Associates/TD TD COLSPAN=1Lake Avenue/TD TD COLSPAN=1Smithfield road/TD TD COLSPAN=1The Beck Ward/TD TD COLSPAN=1The Oliver Street House/TD /TR /TABLE I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ 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: COM :: CF :: Wolfenstein Q3
No luck at all with UDPClient ? Worked perfectly for me using a win2k server with CF5 enterprise. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 2:43 PM To: CF-Talk Subject: RE: COM :: CF :: Wolfenstein Q3 well... if any one want to help me with this i would appreciate it. would give access to rcon while we work on it Private password, so when the server fills to 22-28 you can have one of the reserved private slots! ?? : ] ?? just something goofy to play with i know the gaming community would use.. -paul __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: restarting a service
Another option if you've got SQL, is to schedule a SQL job and use xp_cmdshell and a cmd file. You can do error checking based on errorlevels and send mail, write to error log etc etc. Ian -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:28 To: CF-Talk Subject: RE: restarting a service Couldn't you use CFEXECUTE and call a bat file that does a NET STOP and NET START ? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards 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: How Do I Flip A Table?
oi Dave!! any extra leverage from on side alone should do it :) baahahahahahh it's friday. whatcha spect from me (i thought it was funny anyway) -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Friday, May 10, 2002, 10:33:01 AM, you wrote: DB Hi Guys! DB How do I turn a CFQUERY record set that CFDUMPs like this: DB table border=1 cellspacing=0 cellpadding=1 bgcolor=#ee bordercolor=Red DB tr bgcolor=#ee DB td valign=topDIVISION/td DB td valign=topPROGRAM_NAME/td DB /tr DB tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Bear Street DB /td /tr tr td valign=top bgcolor=#ff Team /td td DB valign=top bgcolor=#ff DB Clipboard Solutions /td /tr tr td valign=top bgcolor=#ff DB Team /td td valign=top bgcolor=#ff Emerson Associates /td /tr tr td valign=top bgcolor=#ff Team /td DB td valign=top bgcolor=#ff Lake Avenue /td /tr tr td DB valign=top bgcolor=#ff DB Team /td td valign=top bgcolor=#ff Smithfield road /td /tr DB tr td valign=top bgcolor=#ff DB Cambridge Health Alliance /td td valign=top bgcolor=#ff The Beck DB Ward /td /tr tr td DB valign=top bgcolor=#ff North East /td td valign=top bgcolor=#ff The Oliver Street DB House /td /tr DB /table DB into something like this: DB TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 BGCOLOR=#EE BORDERCOLOR=Red DB TR ALIGN=center DB TD COLSPAN=5Team/TD DB TD COLSPAN=1Cambridge Health Alliance/TD DB TD COLSPAN=1North East/TD DB /TR DB TR ALIGN=center BGCOLOR=#FF DB TD COLSPAN=1Bear Street/TD DB TD COLSPAN=1Clipboard Solutions/TD DB TD COLSPAN=1Emerson Associates/TD DB TD COLSPAN=1Lake Avenue/TD DB TD COLSPAN=1Smithfield road/TD DB TD COLSPAN=1The Beck Ward/TD DB TD COLSPAN=1The Oliver Street House/TD DB /TR DB /TABLE DB I left the COLSPANs in there as a possible help to solving the general DB problem. I suspect there is a more eloquent solution than performing two or DB three subqueries, though. :-) DB Thanx DB Dave DB __ 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: restarting a service
Thanks to all of you that have clarified my way . I have now many options . thanks for the cfx info too. thanks again , you are all great regards Mario Another option if you've got SQL, is to schedule a SQL job and use xp_cmdshell and a cmd file. You can do error checking based on errorlevels and send mail, write to error log etc etc. Ian -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:28 To: CF-Talk Subject: RE: restarting a service Couldn't you use CFEXECUTE and call a bat file that does a NET STOP and NET START ? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards Mario __ 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: SSL accelerators
you could consider using less than 128 bit encryption. Jason CFDynamics.com -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 7:17 PM To: CF-Talk Subject: RE: SSL accelerators We're using Website Pro, actually. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:54 PM To: CF-Talk Subject: Re: SSL accelerators Never used an accelerator, but assuming you are using IIS. IIS6 will speed up SSL connections quite a bit. Now if they would stop delaying it... jon - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 7:32 PM Subject: OT: SSL accelerators Hi all, We've got a number of dial-up customers complaining of slow response times, but only on SSL pages. We only process about 500 transactions per day, but I'm wondering if an SSL accelerator would alleviate the problem. Anyone out there have any experience with SSL accelerator cards and the like? Is it over kill? Ian __ 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
AS400 Driver to Unix and or NT Resource Problem
Does anyone have ColdFusion on Unix connected to the AS400 doing Major SQL or Stored Procedures? or NT? with one connection we are using 26% or the resources on the AS400 from Unix, DB2 driver, Unix, Merant Driver, and NT, Client Access Driver. Can someone help give me a clue as to what the answer is to fix this or... tell me it can not be done? Thanks, Nathan __ 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: executing sql server dts package from cf
you can also create an SP that executes your DTS package, then call the SP from CF with CFQUERY. that's what we do here, since i've had mixed results instantiating a COM object as CFCOMET recommends. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:07 AM To: CF-Talk Subject: RE: executing sql server dts package from cf Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows. CFSET sArg = /S servername /U username /P password /N packagename CFEXECUTE name=c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe arguments=#sArg# outputfile=c:\MyExportLog.txt timeout=1800/ HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ 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
ANNOUNCEMENT: Northern Alberta Macromedia User's Group
Northern Alberta Macromedia User's Group Who: Anyone is free to attend... Time: Monday, May 13 at 7:00 p.m. (our group meets on the second Monday of every month at 7:00 p.m.) Location: VintaCOM Media Group (New Location) Downstairs (In glass doors and to the left) #210, 10335 - 178 Street Agenda: 7:00 Introduction 7:10 Flash in a Pan (Philip Chung, Certified Flash Instructor, NAIT) 7:30 Working with ColdFusion Structures (Don Riep) 7:50 Break 8:00 Working with ColdFusion Queries (Brad Hogg) 8:20 ColdFusion Custom Tags/Modules 8:40 Discussions More information can be found on our website at: http://edmonton.cfug.ca/ Thanks Mark Zukiwsky __ 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: SSL accelerators
accelerators will help.. but only if your servers are running at peak... check CPU utilization... SSL traffic is mainly troublesome only at the point of initiation.. probably 80-90% of all mass calculation and delay is attributable to this period. Beyond this handoff, SSL is only a very slight bit of overhead beyond normal traffic... some easy strategies to handle this issue would be to move SSL traffic to special servers just for SSL traffic... Alternatively, you can buy an in-line appliance...Nokia makes/made some pricey IP series ones... Sonicwall makes a line as does Symantec/Norton/Netland ... The inlines are fine.. work just like a load balancer or switch essentially.. in the case of the Nokia they can be had/made to do other things liek load balancing Don't forget F5's product line.. worth reviewing.. solid staple .. a modified PC with nice software All can be had affordably these days on Ebay... so find a product and see if aftermarket has one for you... -paris -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:27 AM To: CF-Talk Subject: RE: SSL accelerators you could consider using less than 128 bit encryption. Jason CFDynamics.com -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 7:17 PM To: CF-Talk Subject: RE: SSL accelerators We're using Website Pro, actually. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 4:54 PM To: CF-Talk Subject: Re: SSL accelerators Never used an accelerator, but assuming you are using IIS. IIS6 will speed up SSL connections quite a bit. Now if they would stop delaying it... jon - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 7:32 PM Subject: OT: SSL accelerators Hi all, We've got a number of dial-up customers complaining of slow response times, but only on SSL pages. We only process about 500 transactions per day, but I'm wondering if an SSL accelerator would alleviate the problem. Anyone out there have any experience with SSL accelerator cards and the like? Is it over kill? Ian __ 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: restarting a service
The Syntax: c:\NET STOP Cold Fusion Application Server c:\NET START Cold Fusion Application Server The service names are in a services registry key under HKLM, or you can look in the services control panel and use the item under name as a string in double quotes (as in cold fusion application server above). -mk -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 9:28 AM To: CF-Talk Subject: RE: restarting a service Couldn't you use CFEXECUTE and call a bat file that does a NET STOP and NET START ? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help. regards 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
CFAuthorize tag / authorize.net
Hi - We're forging into e-commerce for the first time - accepting student fee payments online. We're almost certainly going to pick authorize.net as the credit card company. Athorize.net endorses a custom tag CFAuthorize pretty heavily. But from reading the description, it sounds like it's just a simple wrapper around an http post. Is it worth the cost? Thanks, Brian __ 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 Hosting For Adult Sites
Does anyone know of the company that will offer dedicated hosting services that include CF for adult sites? TIA HB __ 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: CFAuthorize tag / authorize.net
There is a free one on the devex, check it out, we use it here, works great. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:03 PM To: CF-Talk Subject: CFAuthorize tag / authorize.net Hi - We're forging into e-commerce for the first time - accepting student fee payments online. We're almost certainly going to pick authorize.net as the credit card company. Athorize.net endorses a custom tag CFAuthorize pretty heavily. But from reading the description, it sounds like it's just a simple wrapper around an http post. Is it worth the cost? Thanks, Brian __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
On Fri, 10 May 2002 15:08:48 +0100, in cf-talk you wrote: How can I refresh the session on the client-side using JavaScript? Use a hidden frame or iframe that does a document.location via Javascript when your button is clicked. Fiddling with cookies won't get you anywhere... CF has to receive a new request before the timeout period. -- Roger __ 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: CFAuthorize tag / authorize.net
Brian, You are correct - it's a simple wrapper - but it's also pretty cheap at 125$. Can you build one at your billable rate in less time? If so, then you don't need it. All you need is to use the A-Net API to make ssl posts request to the gateway with the proper form element - then parse through the list that get's returned. It IS an easy process, but again, cf_authorize is awfully cheap. Mark -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:03 AM To: CF-Talk Subject: CFAuthorize tag / authorize.net Hi - We're forging into e-commerce for the first time - accepting student fee payments online. We're almost certainly going to pick authorize.net as the credit card company. Athorize.net endorses a custom tag CFAuthorize pretty heavily. But from reading the description, it sounds like it's just a simple wrapper around an http post. Is it worth the cost? Thanks, Brian __ 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: CF Hosting For Adult Sites
Mine does; contact me offlist if interested. -matt -Original Message- From: Double Down [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 9:09 AM To: CF-Talk Subject: CF Hosting For Adult Sites Does anyone know of the company that will offer dedicated hosting services that include CF for adult sites? TIA HB __ 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: CFContent problem
I'm running the following test code: html ... CFHEADER NAME=Content-Disposition VALUE=inline; filename=Yourfilename.xls CFCONTENT TYPE=application/msexcel Company Name CFOUTPUT QUERY=test #CompanyName##carriage# /CFOUTPUT /CFCONTENT ... And I'm getting this error: Error Diagnostic Information Context validation error in tag CFCONTENT The CFCONTENT tag isn't a block tag - you should only have a start tag, and no end tag. In addition, you don't want to have any extraneous HTML or other text in your document - this won't cause a CF error, but may keep you from achieving the desired result. Here are some simple CFCONTENT examples: http://www.figleaf.com/demo/mimetest/ 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: That's the way the cookie crumbles
I am running CF 4.5.1 on WIN NT IIS 4.0..., intranet application There is a .cfm module that writes a cookie using; CFCOOKIE name=item#ID# value=#Last_Updated# expires=30 that has been working fine. Suddenly 99% of the clients now get; Page Cannot be displayed . but some people still have no problem viewing the page. When the line above that writes the cookie is removed all is well. My guess is that you're generating an error with one of those two variables in some cases, and that error is screwing up your output big-time. Try looking at the generated HTTP response directly, if you can, using either a recording proxy or an HTTP client like HTTPAnalyzer: http://www.coolfusion.com/Downloads.cfm 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: CFAuthorize tag / authorize.net
This is correct. I use this free version and it has worked well. Kevin Cundick Webmaster Flying J Inc -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:05 AM To: CF-Talk Subject: RE: CFAuthorize tag / authorize.net There is a free one on the devex, check it out, we use it here, works great. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:03 PM To: CF-Talk Subject: CFAuthorize tag / authorize.net Hi - We're forging into e-commerce for the first time - accepting student fee payments online. We're almost certainly going to pick authorize.net as the credit card company. Athorize.net endorses a custom tag CFAuthorize pretty heavily. But from reading the description, it sounds like it's just a simple wrapper around an http post. Is it worth the cost? Thanks, Brian __ 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
Ben Forta to Speak at CFUG CNY MAY 15
Just wanted to let anyone within earshot of Syracuse, NY know that Ben Forta will be speaking at our monthly CFUG meeting on Wed May 15th. Admission is free and Ben will be discussing the new MX line of products. For more info visit http://www.CFUGCNY.org Hope to see you there, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ 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
Excel Web Queries
I'm setting up web queries to pull data from pages created with CF, but my problem is that I can't create dynamic queries (I can pass the URL with URL variables, but I have no way to allow the user to enter different variables.) Anyone know how to do this? T __ 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
CFObject - Excel hosting
Can someone suggest to me a good host that offers the ability to use CFObject with Excel? T __ 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: ANNOUNCEMENT: Northern Alberta Macromedia User's Group
Anyone know if there is a user group in Calgary? Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 9:53 AM To: CF-Talk Subject: ANNOUNCEMENT: Northern Alberta Macromedia User's Group Northern Alberta Macromedia User's Group Who: Anyone is free to attend... Time: Monday, May 13 at 7:00 p.m. (our group meets on the second Monday of every month at 7:00 p.m.) Location: VintaCOM Media Group (New Location) Downstairs (In glass doors and to the left) #210, 10335 - 178 Street Agenda: 7:00 Introduction 7:10 Flash in a Pan (Philip Chung, Certified Flash Instructor, NAIT) 7:30 Working with ColdFusion Structures (Don Riep) 7:50 Break 8:00 Working with ColdFusion Queries (Brad Hogg) 8:20 ColdFusion Custom Tags/Modules 8:40 Discussions More information can be found on our website at: http://edmonton.cfug.ca/ Thanks Mark Zukiwsky __ 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: ANNOUNCEMENT: Northern Alberta Macromedia User's Group
Calgary? Talk about Cold Fusion! g - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:46 PM Subject: RE: ANNOUNCEMENT: Northern Alberta Macromedia User's Group Anyone know if there is a user group in Calgary? Shawn Grover __ 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: CFAuthorize tag / authorize.net
Ditto here. We use the free version. No problems. -Original Message- From: Kevin Cundick [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:26 PM To: CF-Talk Subject: RE: CFAuthorize tag / authorize.net This is correct. I use this free version and it has worked well. Kevin Cundick Webmaster Flying J Inc -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:05 AM To: CF-Talk Subject: RE: CFAuthorize tag / authorize.net There is a free one on the devex, check it out, we use it here, works great. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:03 PM To: CF-Talk Subject: CFAuthorize tag / authorize.net Hi - We're forging into e-commerce for the first time - accepting student fee payments online. We're almost certainly going to pick authorize.net as the credit card company. Athorize.net endorses a custom tag CFAuthorize pretty heavily. But from reading the description, it sounds like it's just a simple wrapper around an http post. Is it worth the cost? Thanks, Brian __ 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 Do I Flip A Table?
So what was the solution that actually worked? Nathan -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 9:33 AM To: CF-Talk Subject: How Do I Flip A Table? Hi Guys! How do I turn a CFQUERY record set that CFDUMPs like this: table border=1 cellspacing=0 cellpadding=1 bgcolor=#ee bordercolor=Red tr bgcolor=#ee td valign=topDIVISION/td td valign=topPROGRAM_NAME/td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Bear Street /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Clipboard Solutions /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Emerson Associates /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Lake Avenue /td /tr tr td valign=top bgcolor=#ff Team /td td valign=top bgcolor=#ff Smithfield road /td /tr tr td valign=top bgcolor=#ff Cambridge Health Alliance /td td valign=top bgcolor=#ff The Beck Ward /td /tr tr td valign=top bgcolor=#ff North East /td td valign=top bgcolor=#ff The Oliver Street House /td /tr /table into something like this: TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 BGCOLOR=#EE BORDERCOLOR=Red TR ALIGN=center TD COLSPAN=5Team/TD TD COLSPAN=1Cambridge Health Alliance/TD TD COLSPAN=1North East/TD /TR TR ALIGN=center BGCOLOR=#FF TD COLSPAN=1Bear Street/TD TD COLSPAN=1Clipboard Solutions/TD TD COLSPAN=1Emerson Associates/TD TD COLSPAN=1Lake Avenue/TD TD COLSPAN=1Smithfield road/TD TD COLSPAN=1The Beck Ward/TD TD COLSPAN=1The Oliver Street House/TD /TR /TABLE I left the COLSPANs in there as a possible help to solving the general problem. I suspect there is a more eloquent solution than performing two or three subqueries, though. :-) Thanx Dave __ 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
Excel Web Queries
I'm setting up web queries to pull data from pages created with CF, but my problem is that I can't create dynamic queries (I can pass the URL with URL variables, but I have no way to allow the user to enter different variables.) Anyone know how to do this? T __ 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
CFObject - Excel hosting
Can someone suggest to me a good host that offers the ability to use CFObject with Excel? T __ 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
Is this right?
Hi, How do i insert one '' into a html file. Should be I using some ASCII value for that.If so can any one tell me the ascii value of that Any help on this is apprecited!!! Sudheer Chakka __ 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: Is this right?
quot; -Original Message- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:59 AM To: CF-Talk Subject: Is this right? Hi, How do i insert one '' into a html file. Should be I using some ASCII value for that.If so can any one tell me the ascii value of that Any help on this is apprecited!!! Sudheer Chakka __ 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: session cookies to expire immediately on browser close
Wow, this looks great! I was just curious, would it be difficult to do the same implementation without the use of cookies for the session? I have a few applications where I append the CFID and CFTOKEN to the URL and pass it through as such.. I was thinking something like this might do the trick? (I define the session.variable once the session is created): cfif IsDefined( session.CFID ) AND IsDefined( session.CFTOKEN ) cfset localCFID = session.CFID cfset localCFTOKEN = session.CFTOKEN cfset session.CFID=#localCFID# cfset session.cftoken=#localCFTOKEN# /cfif Thanks in Advance, Jas - - - ORIGINAL CODE - - - !--- At times developers are frustrated that the session does not end when the user closes their browser#8212;that they must wait for the session to time out. If you#8217;ve found yourself wishing for this behavior in session variables, you#8217;ll be happy to know that you can implement this very easily: --- cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif !--- Place this code right beneath your cfapplication tag. This code first checks to see if the cookies CFID and CFTOKEN exist. Remember that ColdFusion will try to set these as cookie variables in the cfapplication tag. If they are there, set by cfapplication (and due to the peculiar way cookies operate, they will appear to be present even if the user has their cookies turned off), the value of these cookies will be read into two local variables. Then the pair of cookies will be overwritten, using the same values they had previously, but this time deliberately omitting the expires property of the cfcookie tag. Leaving off the expires property causes the cookie to remain in the browser memory, but not to be written to the user#8217;s disk. When the browser is closed, the cookie information goes with it and, by inference, so goes the session. --- 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 can I do this???
Hi, CFSET target= ' target=new' CFSET new='uploads/'TRIM(Y)target ... As soon as I execute this CFApplicationServer processor usage % is shooting upto 90 and 100. The last '' is till in blue color, making the next lines as part of target string and screwing from not executing my next part of code. Any help on this appreciated. Thanks, Sudheer Chakka. __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
- Are CFID and CFTOKEN values within one cookie or separate cookies? the cfid and cftoken cookies (variables) are stored within one file on the client browser. - If separate, do both have their expire value set to the session timeout - meaning both would need to be refreshed to refresh the session - or is it just one of them? Which one? expire values are not set in client cookies. from forta: SESSION variables use cookies to store copies of the CFID and CFTOKEN in order to track the user to one particular browser. However, no other information is stored in cookies. - Does anyone know how I would reset the expire value of the necessary cookie to 20 (or whatever) minutes using client-side JavaScript? session timeout information is not stored with cfid and cftoken in client cookies. in your cfapplication tag, you can setclientcookies='no', then set cookie-scoped cfid and cftoken variables equal to the session-scoped cfid and cftoken variables. since cookie scope does not persist, your cookies will remain intact only until the browser is closed. this technique eliminates two problems: 1) clients with cookies disabled and, 2) session variables persisting after the user has closed his browser. ~ dina __ 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: refreshing CFID + CFTOKEN with client-side JavaScript?
in your cfapplication tag, you can setclientcookies='no', then set cookie-scoped cfid and cftoken variables equal to the session-scoped cfid and cftoken variables. since cookie scope does not persist, your cookies will remain intact only until the browser is closed. this technique eliminates two problems: 1) clients with cookies disabled and, 2) session variables persisting after the user has closed his browser. There are two issues with what you've stated. First, the cookie scope can very well persist; it doesn't persist if you omit the EXPIRES attribute in your CFCOOKIE tag, which will create what is often called a session cookie. Second, if the client has cookies completely disabled, this will include session cookies, so you'd then have to pass the CFID and CFTOKEN values from the browser to the server on each subsequent request, either via URL or Form variables. 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: ANNOUNCEMENT: Northern Alberta Macromedia User's Group
HEHE, Alberta. I used to live in Grand Center, and in Cold Lake :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:53 AM To: CF-Talk Subject: ANNOUNCEMENT: Northern Alberta Macromedia User's Group Northern Alberta Macromedia User's Group Who: Anyone is free to attend... Time: Monday, May 13 at 7:00 p.m. (our group meets on the second Monday of every month at 7:00 p.m.) Location: VintaCOM Media Group (New Location) Downstairs (In glass doors and to the left) #210, 10335 - 178 Street Agenda: 7:00 Introduction 7:10 Flash in a Pan (Philip Chung, Certified Flash Instructor, NAIT) 7:30 Working with ColdFusion Structures (Don Riep) 7:50 Break 8:00 Working with ColdFusion Queries (Brad Hogg) 8:20 ColdFusion Custom Tags/Modules 8:40 Discussions More information can be found on our website at: http://edmonton.cfug.ca/ Thanks Mark Zukiwsky __ 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: ANNOUNCEMENT: Northern Alberta Macromedia User's Group
Only last week... we're above freezing again... LOL -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:48 AM To: CF-Talk Subject: Re: ANNOUNCEMENT: Northern Alberta Macromedia User's Group Calgary? Talk about Cold Fusion! g - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:46 PM Subject: RE: ANNOUNCEMENT: Northern Alberta Macromedia User's Group Anyone know if there is a user group in Calgary? Shawn Grover __ 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: getting NAME attribute of a CFFORM ancestor
any body know if it's possible to get, programmatically, the value of the Name attribute of an ancestor CFFORM tag... that is something like this pseudocode (simplified use), CFFORM NAME=Blah ACTION=Foo.cfm CFSET formName = getAncestorAttribute(CFFORM, Name) /CFFORM I tried using getBaseTagData(CFFORM) but apparently (in CF's words...) The parameter combination of function GetBaseTagData does not specify a base tag that exposes any data. If you're wondering, it's for use in a custom tag that writes some augmented form fields for use in a CFFORM, sure I could pass the custom tag a FormName attribute, but I figure that seeing as you don't have to do CFINPUT FORMNAME=Blah TYPE=TEXT that you shouldn't have to do CF_INPUT FORMNAME=Blah Type=IMAGE either. I don't think you can do what you're trying to do from CF directly. If you look at the code generated by CFFORM and CFINPUT, the generated INPUT tag doesn't require the form name in any meaningful sense in any case. However, my guess is that you're trying to generate useful client-side code, so why bother trying to get the form name from CF anyway? Just use JavaScript to determine the form name as required. 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: clustering Cold Fusion
Anyone have any good links or resources for building a clustered Cold Fusion environment? Have a potential project coming up where I can see the need to do something more enterprise level - db/email/storage/www all on separate boxes... Fortunately, there's very little that's CF-specific when it comes to clustering. However, from my reading of your email, it looks like you may be talking about something other than clustering. What do you mean by db/email/storage/www all on separate boxes exactly? 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: Create Thumb from IMG upload
I need a CF Tag that creates a thumb of an image I upload. Then saves the thumb in folder thumb and image in folder image. Do you know of any. Btw, I was planning on putting out of a free (special edition) of INMaL anyway soon just to beta test the file read/write code. What file formats were you needing to read/write? --min __ 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: Form.FIELDNAME - error!!!!
I wouldn't call that bad practice, It should actually be called good practice (at least in my book). You are setting a variable and the ## around the variable show that it is a variable, makes for easier reading. Now, ## on the set side would be considered bad practice. The use of pound signs (or hashes, or whatever you like to call them) is only required when you want to output the value of a variable or an expression to a string, and in my opinion should only be used in that specific case. If you're using them for something else, it's unnecessary and may confuse developers who understand what exactly pound signs do in CF. 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: How can I do this???
Not sure exactly what your trying to do, but I took a guess CFSET target = new CFSET new = uploads/ TRIM(Y) / target Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Chakka, Sudheer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 10:31 AM Subject: How can I do this??? Hi, CFSET target= ' target=new' CFSET new='uploads/'TRIM(Y)target ... As soon as I execute this CFApplicationServer processor usage % is shooting upto 90 and 100. The last '' is till in blue color, making the next lines as part of target string and screwing from not executing my next part of code. Any help on this appreciated. Thanks, Sudheer Chakka. __ 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 can I do this???
double quotes must be escaped... CFSET target= ' target=new' CFSET new='uploads/'TRIM(Y)target OR, if you use double quoted strings... CFSET target= target=new CFSET new=uploads/TRIM(Y)target +---+ 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: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:32 AM To: CF-Talk Subject: How can I do this??? Hi, CFSET target= ' target=new' CFSET new='uploads/'TRIM(Y)target ... As soon as I execute this CFApplicationServer processor usage % is shooting upto 90 and 100. The last '' is till in blue color, making the next lines as part of target string and screwing from not executing my next part of code. Any help on this appreciated. Thanks, Sudheer Chakka. __ 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
AS400 does anyone use it? RE: AS400 Driver to Unix and or NT Re source Problem
AS400 does anyone use it? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:39 AM To: CF-Talk Subject: AS400 Driver to Unix and or NT Resource Problem Does anyone have ColdFusion on Unix connected to the AS400 doing Major SQL or Stored Procedures? or NT? with one connection we are using 26% or the resources on the AS400 from Unix, DB2 driver, Unix, Merant Driver, and NT, Client Access Driver. Can someone help give me a clue as to what the answer is to fix this or... tell me it can not be done? Thanks, Nathan __ 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: Form.FIELDNAME - error!!!!
The speed issue? About the same difference as cfif vs. cfswitch... The main reason I would use switch over if is to make it easer to read, and easier to maintain. That it is faster is just a bonus. This implies that CFSWITCH is always easier to read and maintain, and always faster. I wouldn't agree to either of those. There are cases in which it's easier to read, and other cases in which it isn't. There are cases in which it's faster, I suppose, and other cases in which it's not. I'd guess that the key in both cases is the size of your potential case table. Thats like saying: CFSET var1 = this CFSET var2 = that CFSET var3 = foo CFSET var4 = bar is better than: CFSCRIPT var1 = this; var2 = that; var3 = foo; var4 = bar; /CFSCRIPT or that in this case it wouldn't make the most sense to use: CFSCRIPT var = arrayNew(4); var[1] = this; var[2] = that; var[3] = foo; var[4] = bar; /CFSCRIPT The third is both faster and easier to read as far as I am concerned. While I agree that, in this case, the last example is probably more sensible (using an array makes a concrete statement about the relationships between the values) and thus easier to read, I have no reason to believe it's faster. Do you have such a reason? Now I hear people say that the amount of time you save is so small that it's not even worth worrying about, well the way I see it is if you use ALL the fastest and most optimized code you can, then it will add up, and be noticeable. Even if it is not noticeable to a single user, it can also help reduce your processor load on heavy hit sites. When requests are over quicker, more requests can be processed faster and so on. The problem with this statement is that you can never use ALL the fastest and most optimized code, and there are places where your optimization bang for the buck is almost certainly better spent. In the above example, for instance, again I have no evidence that it's any faster, or what threshold is needed to make it faster (for example, it may be faster to declare five separate variables than an array with five members, but not so for fifty separate variables vs fifty members, or vice-versa). Very often, when you see these which is faster debates, there just aren't any meaningful numbers used to back up these sorts of statements. There's a very good reason for this - it's hard to determine what those numbers are! On the other hand, most CF developers would find their time very well spent if they focused more on optimizing database interactions and limited the amount of runtime work - the two biggest things that will make a meaningful difference in application performance. Most developers, even those who think they have, have not done this. There's a very good reason for this as well - it's harder than focusing on CF code minutia! Also we shouldn't cater coding standards to the beginner, we should train and assist the beginner to the standard. Standards are nice. The best thing about them is there are so many from which to choose! 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: SQL Question
Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?) it's my understanding that the *= syntax is legacy syntax; i believe you'll want ansi syntax to effect compatibility with a most dbms's: SELECT h.id, h.header, l.link, l.link_title FROM headers h LEFT JOIN links l ON h.id = l.headerid While you're correct to point out that the *= syntax is not ANSI SQL, I suspect that it's supported by more databases than the ANSI JOIN syntax! We typically use ANSI joins, but I remember an unpleasant occurance porting something from MS T-SQL to Sybase T-SQL, and that version of Sybase didn't support ANSI join syntax. 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: Read Data from Buffer
Is there a handy way to read data from the buffer in CF on a form submit? I'm not sure what buffer you're referring to. 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: AS400 does anyone use it? RE: AS400 Driver to Unix and or N T Re source Problem
I use it, but I don't have the problem you're having. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 2:19 PM To: CF-Talk Subject: AS400 does anyone use it? RE: AS400 Driver to Unix and or NT Re source Problem AS400 does anyone use it? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:39 AM To: CF-Talk Subject: AS400 Driver to Unix and or NT Resource Problem Does anyone have ColdFusion on Unix connected to the AS400 doing Major SQL or Stored Procedures? or NT? with one connection we are using 26% or the resources on the AS400 from Unix, DB2 driver, Unix, Merant Driver, and NT, Client Access Driver. Can someone help give me a clue as to what the answer is to fix this or... tell me it can not be done? Thanks, Nathan __ 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: SQL Question
so are you saying that even though you use ansi joins, you should probably be using *= for portability? ~ dina - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 1:32 PM Subject: RE: SQL Question Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?) it's my understanding that the *= syntax is legacy syntax; i believe you'll want ansi syntax to effect compatibility with a most dbms's: SELECT h.id, h.header, l.link, l.link_title FROM headers h LEFT JOIN links l ON h.id = l.headerid While you're correct to point out that the *= syntax is not ANSI SQL, I suspect that it's supported by more databases than the ANSI JOIN syntax! We typically use ANSI joins, but I remember an unpleasant occurance porting something from MS T-SQL to Sybase T-SQL, and that version of Sybase didn't support ANSI join syntax. 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: Read Data from Buffer
The binary stream from a form submit on a fdf file... An easy way to do it in ASP is to use the Request.BinaryRead(Request.TotalBytes) function. Can not find a coldfusion function to do this outside writing a cfx tag *** REPLY SEPARATOR *** On 5/10/2002 at 2:41 PM Dave Watts wrote: Is there a handy way to read data from the buffer in CF on a form submit? I'm not sure what buffer you're referring to. 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: Fw: Oh man, no more HomeSite/CFStudio, for real :-(
As the list has influenced me not to look at DWMX right now ... I'd argue that you're making a mistake here. Take a look at it; form your own opinions; see whether it works for you and if not, let MM know why not. I'd largely felt the same way about it - I just wasn't that interested in it, since I'm happy with what I've got. However, after seeing some of the things that other people are doing with it, here in our office, I've got to say it's worth taking a look at. 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
Conditional Query loop
Is it possible to loop over a query until a condition is met? Specifically, I am returning search results, if a certain category exists i want to display a title, if no records for that category exist I do not want to display the title. However I only want to display the title one time if the records exist. Looping over the query will display the title the number of times that the condition exists in the recordset, but a conditional query doesn't appear to allow a query to loop over. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) 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: Read Data from Buffer
I don't think this can be done, but you could use the GetHTTPRequestData( ) function. It returns a structure with headers and content. If you are trying to figure out the size (like the file length for an uploaded file), you could check the length of Content key. -mk -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 1:48 PM To: CF-Talk Subject: RE: Read Data from Buffer The binary stream from a form submit on a fdf file... An easy way to do it in ASP is to use the Request.BinaryRead(Request.TotalBytes) function. Can not find a coldfusion function to do this outside writing a cfx tag *** REPLY SEPARATOR *** On 5/10/2002 at 2:41 PM Dave Watts wrote: Is there a handy way to read data from the buffer in CF on a form submit? I'm not sure what buffer you're referring to. 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: Which Is Faster, multiple CFQuery or Multiple Query of a Quer y?
In theory the use of query or query should perform better - the actual difference you see will be influenced by amount of data actually being returned, network traffic and so onyou can always test it to see the actual difference. One big advantage that CFSQL offers is that you only having to hit the database once. In theory, you're right. Someday, I want to move to Theory; everything sounds so nice there. In my experience, your mileage with query-a-query will certainly vary. I've tried using it in this way, and found it faster in several cases (significantly faster, under load testing) to just query the database. It seems that the advantage of being able to pull from local memory is often outweighed by other factors. 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: refreshing CFID + CFTOKEN with client-side JavaScript?
yes, those are both good points to consider. thank you for the clarification. :) ~ dina - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 12:49 PM Subject: RE: refreshing CFID + CFTOKEN with client-side JavaScript? in your cfapplication tag, you can setclientcookies='no', then set cookie-scoped cfid and cftoken variables equal to the session-scoped cfid and cftoken variables. since cookie scope does not persist, your cookies will remain intact only until the browser is closed. this technique eliminates two problems: 1) clients with cookies disabled and, 2) session variables persisting after the user has closed his browser. There are two issues with what you've stated. First, the cookie scope can very well persist; it doesn't persist if you omit the EXPIRES attribute in your CFCOOKIE tag, which will create what is often called a session cookie. Second, if the client has cookies completely disabled, this will include session cookies, so you'd then have to pass the CFID and CFTOKEN values from the browser to the server on each subsequent request, either via URL or Form variables. 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