RE: [KCFusion] Unexpected Loss of Session Variables
If you're using IIS on your server, take a look at the timeout on it. That has bit me before. Also make sure the time out on the cf server is what you want it to be. -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:11 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Unexpected Loss of Session Variables Hello. I'm the new webmaster for stfm.org. Our website uses ColdFusion5.0 as its web programming language. I'm originally a Java Programmer(JavaServerPages), so I've had to learn CFML quickly (thanks to BenForte's books).Our web site is hosted on a shared server (crystaltech.com).We are experiencing unexpected loss of some or all session variablesfor about 20% of our users. The session variables are lost well beforethe 20 minute timeout limit.We use session variables to maintain user input across approximately3-4 data entry pages (page numbers vary based upon specific category). Our session variables are set and read inside of cflock tags perColdFusion best practices.The problem appears to worsen when we have more users on our site, butthe number of users is not that significant (less than 20-30 per hour). This is a shared server, but I don't know the overall load on theserver.I've reseached your listserver but did not find any material on thissubject. From my research on Macromedia's forum, the loss of session variablesappears to be a problem with ColdFusion 5. We are considering changing our host plan to ColdFusion MX, though some of our applications will need recoding since they use attributes no longer supported in ColdFusion MX. I'd certainly appreciate any advice from more experienced ColdFusion developers who may have encountered and solved this problem. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] Unexpected Loss of Session Variables
I'm not sure if this will help you, but here's the way I use it. CFAPPLICATION NAME="xl"CLIENTMANAGEMENT="Yes"SESSIONMANAGEMENT="Yes"SESSIONTIMEOUT="#CREATETIMESPAN(0,0,20, 0)#" I also lock my variables with like this: cflock name="Session" type="Exclusive" timeout="30" throwontimeout="Yes" In each template I use this statement: cflock name="Session" type="ReadOnly" timeout="30" throwontimeout="Yes"CFPARAM Name="session."/cflock -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:53 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables cfapplication name="STFM-Presentation-Submission" sessionmanagement="Yes" Session variables are only lost by approximately 20% of users. Remaining users experience no problem. Thanks for the assistance. Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 01:42PM What does your cfapplication statement look like? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:36 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables Thanks for the quick reply. We are on a shared host. The hosting company has the timeout set to 20 minutes and we cannot adjust that. However, session variables are being lost before the 20 minute period (sometimes very quickly 1-2 minutes). bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 01:25PM If you're using IIS on your server, take a look at the timeout on it. That has bit me before. Also make sure the time out on the cf server is what you want it to be. -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:11 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Unexpected Loss of Session Variables Hello. I'm the new webmaster for stfm.org. Our website uses ColdFusion5.0 as its web programming language. I'm originally a Java Programmer(JavaServerPages), so I've had to learn CFML quickly (thanks to BenForte's books).Our web site is hosted on a shared server (crystaltech.com).We are experiencing unexpected loss of some or all session variablesfor about 20% of our users. The session variables are lost well beforethe 20 minute timeout limit.We use session variables to maintain user input across approximately3-4 data entry pages (page numbers vary based upon specific category). Our session variables are set and read inside of cflock tags perColdFusion best practices.The problem appears to worsen when we have more users on our site, butthe number of users is not that significant (less than 20-30 per hour). This is a shared server, but I don't know the overall load on theserver.I've reseached your listserver but did not find any material on thissubject. From my research on Macromedia's forum, the loss of session variablesappears to be a problem with ColdFusion 5. We are considering changing our host plan to ColdFusion MX, though some of our applications will need recoding since they use attributes no longer supported in ColdFusion MX. I'd certainly appreciate any advice from more experienced ColdFusion developers who may have encountered and solved this problem. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] Unexpected Loss of Session Variables
What does your cfapplication statement look like? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:36 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables Thanks for the quick reply. We are on a shared host. The hosting company has the timeout set to 20 minutes and we cannot adjust that. However, session variables are being lost before the 20 minute period (sometimes very quickly 1-2 minutes). bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 01:25PM If you're using IIS on your server, take a look at the timeout on it. That has bit me before. Also make sure the time out on the cf server is what you want it to be. -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:11 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Unexpected Loss of Session Variables Hello. I'm the new webmaster for stfm.org. Our website uses ColdFusion5.0 as its web programming language. I'm originally a Java Programmer(JavaServerPages), so I've had to learn CFML quickly (thanks to BenForte's books).Our web site is hosted on a shared server (crystaltech.com).We are experiencing unexpected loss of some or all session variablesfor about 20% of our users. The session variables are lost well beforethe 20 minute timeout limit.We use session variables to maintain user input across approximately3-4 data entry pages (page numbers vary based upon specific category). Our session variables are set and read inside of cflock tags perColdFusion best practices.The problem appears to worsen when we have more users on our site, butthe number of users is not that significant (less than 20-30 per hour). This is a shared server, but I don't know the overall load on theserver.I've reseached your listserver but did not find any material on thissubject. From my research on Macromedia's forum, the loss of session variablesappears to be a problem with ColdFusion 5. We are considering changing our host plan to ColdFusion MX, though some of our applications will need recoding since they use attributes no longer supported in ColdFusion MX. I'd certainly appreciate any advice from more experienced ColdFusion developers who may have encountered and solved this problem. Thank You, Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED]
RE: [KCFusion] Unexpected Loss of Session Variables
No, I'm not loading it into a local variable, just checking to make sure it exist. Throwontimeout produces an error that is trapped and deliver to the browser alerting the user. If you have a lot of activity on your web app and you do not lock your session variables it can produce errors that seem to be time outs, but in reality the session variables get crunched by another session. -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 2:50 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables Thanks for the infor I have some questions: 1. On each template are you loading all your session variables into local variables here: cflock name="Session" type="ReadOnly" timeout="30" throwontimeout="Yes"CFPARAM Name="session."/cflock 2. What effect does the attribute throwontimeout="Yes" have? Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 02:23PM I'm not sure if this will help you, but here's the way I use it. CFAPPLICATION NAME="xl"CLIENTMANAGEMENT="Yes"SESSIONMANAGEMENT="Yes"SESSIONTIMEOUT="#CREATETIMESPAN(0,0,20, 0)#" I also lock my variables with like this: cflock name="Session" type="Exclusive" timeout="30" throwontimeout="Yes" In each template I use this statement: cflock name="Session" type="ReadOnly" timeout="30" throwontimeout="Yes"CFPARAM Name="session."/cflock -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:53 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables cfapplication name="STFM-Presentation-Submission" sessionmanagement="Yes" Session variables are only lost by approximately 20% of users. Remaining users experience no problem. Thanks for the assistance. Bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 01:42PM What does your cfapplication statement look like? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:36 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Unexpected Loss of Session Variables Thanks for the quick reply. We are on a shared host. The hosting company has the timeout set to 20 minutes and we cannot adjust that. However, session variables are being lost before the 20 minute period (sometimes very quickly 1-2 minutes). bruce Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 ext 5405[EMAIL PROTECTED] [EMAIL PROTECTED] 06/17/03 01:25PM If you're using IIS on your server, take a look at the timeout on it. That has bit me before. Also make sure the time out on the cf server is what you want it to be. -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:11 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Unexpected Loss of Session Variables Hello. I'm the new webmaster for stfm.org. Our website uses ColdFusion5.0 as its web programming language. I'm originally a Java Programmer(JavaServerPages), so I've had to learn CFML quickly (thanks to BenForte's books).Our web site is hosted on a shared server (crystaltech.com).We are experiencing unexpected loss of some or all session variablesfor about 20% of our users. The session variables are lost well beforethe 20 minute timeout limit.We use session variables to maintain user input across approximately3-4 data entry pages (page numbers vary based upon specific category). Our session variables are set and read inside of cflock tags perColdFusion best practices.The problem appears to worsen when we have more users on our site, butthe number of users is not that significant (less than 20-30 per hour). This is a shared server, but I don't know the overall load on theserver.I've reseached your listserver but did not find any material on thissubject. From my research on Macromedia's forum, the loss of session variablesappears to be a problem with ColdFusion 5. We are considering changing our host plan to ColdFusion MX, though some of our applications will need recoding since they use attributes no longer supported in ColdFusion MX. I'd certainly appreciate any advice from more experienced ColdFusion developers who may have encountered and solved this problem. Thank You,
RE: [KCFusion] Numeric Check in PL/SQL
If you want to write a function to do it, here's an example. FUNCTION check_valid_zipcode (zipcode IN VARCHAR2 ) RETURN NUMBER IS tempnum number; my_sqlcode NUMBER; BEGIN BEGIN tempnum := TO_NUMBER(SUBSTR(zipcode,1,5),'9'); RETURN 0; EXCEPTION WHEN OTHERS THEN my_sqlcode := SQLCODE; --IF my_sqlcode -01800 AND my_sqlcode -01899 THEN RETURN -1; --END IF; END; END; -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 1:07 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Numeric Check in PL/SQL This doesnt work in a block of code. Here is what I am going for, FN_ISNUMERIC is a function I am working in now having not found a standard Numeric check type function.So if you know of something a little easier to work with I would greatly appreciate it BEGIN SELECT SF_INTRANSIT(TRIM(V_DEST), TRIM(V_ORIG), TRIM(V_SHIPPER), TRIM(V_TRACKNUMBER), TRIM(V_TICKETNUM), TRIM(V_CONTACT)) AS V_SYSTEM_RESULT FROM DUAL; IF FN_ISNUMERIC(LEFT(V_SYSTEM_RESULT, 2)) THEN -- IF NUMERIC THEN THERE IS AN ERROR CODE V_RETURN := V_SYSTEM_RESULT; GOTO RETURN_VALUE; ELSE -- GOOD TO GO AND GOT A SYSTEM BACK V_RETURN := 'Finally!' EXCEPTION END; -- Original Message -- From: Solution Hatch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 3 Sep 2002 12:16:27 -0500 LIKE Any single character within the specified range ([a-f]) or set ([abcdef]). WHERE foo LIKE '[abcdefghijklf]' Determines whether or not a given character string matches a specified pattern. A pattern can include regular characters and wildcard characters. During pattern matching, regular characters must exactly match the characters specified in the character string; wildcard characters, however, can be matched with arbitrary fragments of the character string. Using wildcard characters makes the LIKE operator more flexible than using the = and != string comparison operators. If any of the arguments are not of character string data type, Microsoft® SQL ServerT converts them to character string data type, if possible. Syntax match_expression [NOT] LIKE pattern [ESCAPE escape_character] Arguments match_expression Is any valid SQL Server expression of character string data type. pattern Is the pattern to search for in match_expression, and can include these valid SQL Server wildcard characters. \ Not sure if it will work within Oracle - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 12:06 PM Subject: [KCFusion] Numeric Check in PL/SQL Does anyone know of a function using PL/SQL that checks the value of a variable to see if it contains all numbers or number and alpha. I originally planned on doing this in CF with the IsNumeric check but just got shot down to do it the oracle Function Im writing. Thanks, Misty __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] help reading a text file...
It depends on what you want to do with it, but here's an idea. cfset loc_file_path=listdeleteat( getcurrenttemplatepath(), listlen( getcurrenttemplatepath(), \/ ), \/ ) /temp/ cffile action=UPLOAD filefield=fileupload destination=#loc_file_path#mydatafile.cvs nameconflict=Overwrite cfset end_of_line = Chr(10) cffile action=READ file=#loc_file_path#mydatafile.cvs variable=DataFile cfset clean_data_file = Replace(DataFile, ', ) cfset data_line_array = ListToArray(clean_data_file, end_of_line) cfset arraycount = #ArrayLen(data_line_array)# cfloop index =x from=1 to=#arraycount# cfset data_element_array = ListToArray(Data_Line_Array[x]) cfset elementarraycount = #ArrayLen(Data_Element_Array)# cfif #data_element_array[1]# is x cfset element_1 = cfelse cfset tmp_element_1 = '#data_element_array[1]#' cfset element_1 = '#preservesinglequotes(tmp_element_1)#' /cfif cfif #data_element_array[2]# is x cfset element_2 = cfelse cfset tmp_element_2 = '#data_element_array[2]#' cfset element_2 = '#preservesinglequotes(tmp_element_2)#' /cfif cfif #data_element_array[3]# is x cfset element_3 = cfelse cfset tmp_element_3 = '#data_element_array[3]#' cfset element_3 = '#preservesinglequotes(tmp_element_3)#' /cfif cfif #data_element_array[4]# is x cfset element_4 = cfelse cfset tmp_element_4 = '#data_element_array[4]#' cfset element_4 = '#preservesinglequotes(tmp_element_4)#' /cfif cfif #data_element_array[5]# is x cfset element_5 = cfelse cfset tmp_element_5 = '#data_element_array[5]#' cfset element_5 = '#preservesinglequotes(tmp_element_5)#' /cfif cfif #data_element_array[6]# is x cfset element_6 = cfelse cfset tmp_element_6 = '#data_element_array[6]#' cfset element_6 = '#preservesinglequotes(tmp_element_6)#' /cfif cfif #data_element_array[7]# is x cfset element_7 = cfelse cfset tmp_element_7 = '#data_element_array[7]#' cfset new_element_7 = RemoveChars(tmp_element_7,len(tmp_element_7),1) cfset element_7 = '#preservesinglequotes(tmp_element_7)#' /cfif cfif #data_element_array[1]# is not cfquery datasource=xxx insert into XXX(xxx, xxx, xxx, xxx, xxx, xxx, xxx) VALUES('#element_1#', '#element_2#', '#element_3#, '#element_4#', '#element_5#', '#element_6#', '#element_7#') /cfquery /cfif /cfloop -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] help reading a text file... The only method i'm aware of is to use cfhttp then you can execute a query off that. Looks like: cfhttp method=get url=http://www.yoursite.net/foo.txt (--should be quotes around that) name=grabTextFile delimiter=, Then you can output it just like a cfquery like so: cfouput query=grabTextFile#grabTextFile.columnName#/cfoutput Thats straight from the text book. I have not had opportunity to try this in real life so I can't comment reliably on performance. A. - Original
[KCFusion] CFMAILPARAM
Has anyone tried to put an image into a cfmail message? I have tried using cfmailparam, but I'm not getting anything with it. Any ideas? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFMAILPARAM
You are exactly right. I made a silly error that I did not catch before I ask you good folks. Thanks so much for your reply. I haven't used cfmail before and I was looking for the worst, instead of something simple. -Original Message- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:28 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] CFMAILPARAM Try using the TYPE=HTML attribute inside of CFMAIL. Example: CFMAIL FROM=fromname.emailserver.com TO=toname.emailserver.com SUBJECT=Place email subject here TYPE=HTML table TR TDTest Application/TD /TR TR TDIMG SRC=HTTP://www.servernamehere.com/Line.gif; ALT=Line/TD /TR /TABLE /CFMAIL -Original Message- From: Smith, Jim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: [KCFusion] CFMAILPARAM Has anyone tried to put an image into a cfmail message? I have tried using cfmailparam, but I'm not getting anything with it. Any ideas? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Storing Date/Time
I'm having trouble storing the date/time in an oracle table. I want to use am and pm on the time. CreateODBCDateTime complains about the am and pm. I can get it stored if I leave that off. What am I doing wrong? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]