RE: help with string manipulation (Find,Replace)
cfscript stTmp = REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true); info = Mid(str,stTmp.pos[2],stTmp.len(2); /cfscript cfoutputspan class=time#info#/span/cfoutput -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: vrijdag 14 mei 2004 17:07 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) Pascal or anybody who can help! I'm in a similar problem again and need your help. I'm currently using the code provided by Pascal. The solution to which is mentioned above. I am pulling the data from the 'comments' column in a database table. The data in the comments column looks like this. *** User1 10/28/2003 2:53:52 *** THIS IS A TEST *** User 2 04/06/200313:41:47 *** blah, blah I want to read everything that's between the *** ie *** User 1 10/28/2003 2:53:52 *** and display it like this: span class=timeUser 1 | 14/4/2004 15:58:15/span THIS IS A TEST Can somebody please show me how to do this using regular expressions? Many thanks cf coder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFmail and Spam
Hi, Hotmail keeps marking emails sent by the server as junk mail. These mails are sent out to players in a game to tell them to take their turn. Is there anything that can be done to make it look like the mail came from say Outlook? Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Hey Pascal, hope you're doing well buddy! I'm getting an error. The selected method len was not found. Either there are no methods with the specified method name and argument types, or the method len is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. Any idea why? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to secure email with CFMAIL
Brant Winter wrote: Hi - Maybe I should be addressing this question to the CF-Newbies list, but I will try here anyway! I need to create a form to submit patient data to another health company be email. I was thinking I could easily write the app in CF to do this, but I want to secure the actual email with a digital cert. Can this be done ??? In my experience, the only good way to send encrypted email is to use PGP or GnuPG ... the client who reads the mail uses PGP or GnuPG to generate a public/private key, then you use CFEXECUTE on the server to encrypt the email text with PGP or GnuPG using the public key before sending it.Then the email can only be read when decrypted with the private key. This is not a user friendly method though. An alternative would be store the data in the database, and simply email the user a link to the data that they can view over an SSL connection after entering their username and password. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmx admin question
yes (cfstart) , but i think it produce some errors...how does one interprete them. Pat -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Saturday, May 15, 2004 7:56 PM To: CF-Talk Subject: Re: cfmx admin question DO you have a web server running on your system? JIm Louis Hi All, After I install the cfmx dev copy on my win98 (yes, it is an old PC), I try to goto cfadmin with no success. I get a 'page can't be displayed'. I do have cfstart.bat running. Is there some xml file which I need to change. I did this before, but no success today. TIA, Patrick Whittingham _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
I figured that out.. thanks cfscript stTmp = REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true); info = Mid(str,stTmp.pos[2],stTmp.len[2]); /cfscript span class=timestamp#info#/span the above code works however I was wondering if you could do me another favour. At the minute you are searching for the ***. Would it be possible to come up with a pattern that finds the three stars, username, date and time? ex: *** User1 10/28/2003 2:53:52 *** Its just so its fool proof. My concern is if the column contains three stars somewhere else in the comments then this code would fail. Are you with me? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need to have a javascript that selectively validates
Jim, i presume session1 is a field name within your form and you want the validation at on submit eventremember _javascript_ is a case-sensitive language unlike CF. The _javascript_ Bible, by Dan Goodman is an excellent book Pat script !-- function valid() { if (document.forms[0].session.value == 'yes' ) (document.forms[0].field2.value != '' or document.forms[0].field3.value != '') { alert(field 2 and field3 are required); return false; } return true; } /script form name=x valid(); .. /form -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Saturday, May 15, 2004 7:55 PM To: CF-Talk Subject: OT: Need to have a _javascript_ that selectively validates I have a web form that I need _javascript_ validation for if Session1 is yes then field2 and field3 are required. If session 1 is no then field 2 and field3 are not required. Can someone point me in the right direction.I want to use javascipt because the rest of the form validation is using it. Jim Louis _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
sorry for being such a pest... I forgot to add in my earlier post that the timestamp for all existing comments is in the format: *** 10/28/2003 2:53:52 User1 *** and the timestamp for new comments is: *** User1 10/28/2003 2:53:52 *** Can you also show me how to display all existing timestamps in the above format Many many thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
cfscript stTmp = REFind([*]{3}([^*]+)([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space:]]+([0-9]{ 1,2}:[0-9]{1,2}:[0-9]{1,2})([^*]+)[*]{3},str,1,true); user1 = Mid(str,stTmp.pos[2],stTmp.len[2]); date = Mid(str,stTmp.pos[3],stTmp.len[3]); time = Mid(str,stTmp.pos[4],stTmp.len[4]); user2 = Mid(str,stTmp.pos[5],stTmp.len[5]); if(len(trim(user1))) user = trim(user1); else if(len(trim(user2))) user = trim(user2); else user = ; /cfscript span class=timestamp#user# #date# #time#/span It's not full proof, but it should work. -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 13:11 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) sorry for being such a pest... I forgot to add in my earlier post that the timestamp for all existing comments is in the format: *** 10/28/2003 2:53:52 User1 *** and the timestamp for new comments is: *** User1 10/28/2003 2:53:52 *** Can you also show me how to display all existing timestamps in the above format Many many thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The never-ending windows
How about doing something like this: MAIN Window tons of stuff event trigger: pop2(); pop2 data loader msgWin = window.open( 'pop1.htm', 'msg', '' ); msgWin.focus(); do tons of stuff; msgWin.close(); self.close(); pop1 message document.write('Please wait, loading...'); -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:36 AM To: CF-Talk Subject: The never-ending windows Hello, I've spent at least one hour on figuring out how to work out this oo thing.Here's the scoop, I have one Main window, which contain form and elements, upon certain action, triggers a popup window, which does two things of 1) query a database to pull certain data out; 2) write the data to (populate) the Main window, then, close itself. However, since, query/data retrieval and population may take a while, so, I'd like to add msg like, Please wait ... upon loading, and yet, it causes double buffer, the single popup window won't do, which leaves me with no choice but to add another little named popup window to say Please wait These two popup windows are loaded in the sequence of pop msg and pop data loader.Problem, pop data loader, closes itself upon job completion, fine, but the pop msg window won't close. Here's the relevant code: MAIN Window tons of stuff event trigger: pop1(); pop2(); pop1 about msg msgWin = (window.open('pop1.htm','msg',''); msgWin.focus(); pop2 about data loader do tons of stuff; // close pop1 window msgWin.close(); // also tried, msg.close() to no avail self.close(); TIA _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
thanks Pascal! It doesn't quite work how I would like it to. EX: *** 08/12/200320:33:31EDWARI31 *** You code displays the above timestamp like this: 0 8/12/2003 20:33:31 Where as I would like it to be displayed like this: EDWARI31 08/12/2003 20:33:31 I dumped stTmp cfdump var=#stTmp#. This is what it returns struct LEN array 1 38 2 2 3 9 4 8 5 11 POS array 1 1 2 4 3 6 4 17 5 25 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Pascal, sorry again for being such a PEST. I really do apprecaite your help. There can be more than one occurance of the timestamp in the comment column. Ex: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Can you please add code in your script to handle this and display all timestamps correctly Many thanks again cfcoder thanks Pascal! It doesn't quite work how I would like it to. EX: *** 08/12/200320:33:31EDWARI31 *** You code displays the above timestamp like this: 0 8/12/2003 20:33:31 Where as I would like it to be displayed like this: EDWARI31 08/12/2003 20:33:31 I dumped stTmp cfdump var=#stTmp#. This is what it returns struct LEN array 1 38 2 2 3 9 4 8 5 11 POS array 1 1 2 4 3 6 4 17 5 25 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FW: How do you concatanate two table fields in CFQUERY with MS Access
The first thing I see is you need a comma after 'tblJobSeekers.jsphone1'. Doug Angel Stewart wrote: Well Sandy...I tried that initially but it just didn't work. So I thought I was doing something totally wrong and that Access SQL uses something beside the +. But! Good news! I tried that code in an SQL Statement with nothing else but Select atfname + ' ' + atlname AS Agentname FROM tblagent And it worked fine. So there must be something else in the syntax of SELECT tblusers.username, tblJobSeekers.jsfname, tblJobSeekers.jslname,tblJobSeekers.jsemail, tblJobSeekers.jscountry, tblJobSeekers.pverify,tblJobSeekers.jsphone1 [atfname] + + [atlname] AS AgentName FROM tblAgent INNER JOIN (tblusers INNER JOIN tblJobSeekers ON tblusers.userid = tblJobSeekers.userid) ON tblAgent.atid = tblJobSeekers.agentid ORDER BY tblJobSeekers.jslname; That's causing it to fail. *sigh* I hate syntax errors. And I don't understand why the MSACcess SQL string failed to work. Could someone explain that? Thanks for the help :) -Gel -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Saturday, May 15, 2004 3:01 AM To: CF-Talk Subject: CF-Talk: Digest every 2 hours Subject: How do you concatanate two table fields in CFQUERY with MS Access From: Sandy Clark Date: Fri, 14 May 2004 22:18:07 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =32529forumid=4#163293 Sql uses + is the CF concatenation. Silly gel. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Thanks, Ryan, to me, your suggestion is 100% logical, and I tried that before except I used plain HTML without js for the msgWin, however, still to no avail. What do you think of launching a frame page with two frames (top and bottom), the top one display the msg and the bottom one do data loading and size set to 0 to hide it, once the loader completes its job close the top and bottom frames).Since I don't use frames that often, just to check to see if anyone has done something similar and that works before I spend the time. Many thanks. Don How about doing something like this: MAIN Window tons of stuff event trigger: pop2(); pop2 data loader msgWin = window.open( 'pop1.htm', 'msg', '' ); msgWin.focus(); do tons of stuff; msgWin.close(); self.close(); pop1 message document.write('Please wait, loading...'); -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:36 AM To: CF-Talk Subject: The never-ending windows Hello, I've spent at least one hour on figuring out how to work out this oo thing.Here's the scoop, I have one Main window, which contain form and elements, upon certain action, triggers a popup window, which does two things of 1) query a database to pull certain data out; 2) write the data to (populate) the Main window, then, close itself. However, since, query/data retrieval and population may take a while, so, I'd like to add msg like, Please wait ... upon loading, and yet, it causes double buffer, the single popup window won't do, which leaves me with no choice but to add another little named popup window to say Please wait These two popup windows are loaded in the sequence of pop msg and pop data loader.Problem, pop data loader, closes itself upon job completion, fine, but the pop msg window won't close. Here's the relevant code: MAIN Window tons of stuff event trigger: pop1(); pop2(); pop1 about msg msgWin = (window.open('pop1.htm','msg',''); msgWin.focus(); pop2 about data loader do tons of stuff; // close pop1 window msgWin.close(); // also tried, msg.close() to no avail self.close(); TIA _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
New at Structures
I'm new at Structures...I wanted to addvariables to the items structure. The variables increment as they go thru a loop. The variable is called qty and as it goes thru the loop it would increment as qty1, qty2, etc thru a form. Here's the code. I'm having an obvious problem with the CFSET items.qty#countlist#=qty(#countlist#) which I know is not the right syntax... Any thoughts please? Thanks as always. Robert at HWW CFIF isDefined(form.more.x) cfset countList = countList + 1 /cfif cfloop index=record from=1 to=#countList# step=1 form action="" method=POST input type=hidden name=qty value CFOUTPUT tr td width=25% bgcolor=##FFEEB3 align=center input type=text name=qty size=4/td /tr /CFOUTPUT CFSET items=StructNew() CFIF IsDefined(qty#countlist#) CFSET items.qty#countlist#=qty(#countlist#) /cfif cfoutput #items.qty#countlist#br /cfoutput /CFLOOP [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New at Structures
I'm new at Structures...I wanted to add variables to the items structure. The variables increment as they go thru a loop. The variable is called qty and as it goes thru the loop it would increment as qty1, qty2, etc thru a form. Here's the code. I'm having an obvious problem with the CFSET items.qty#countlist#=qty(#countlist#) which I know is not the right syntax... You can use array syntax to reference your structure keys: cfset items[qty#countlist#] = ... But I'm not sure exactly what you're trying to do with the rest of your code. Currently, you have two places where you're creating hidden form fields named qty within the same page, which probably won't give you the result you want. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: The never-ending windows
Original Message: From: Chunshen (Don) Li I've spent at least one hour on figuring out how to work out this oo thing.Here's the scoop, I have one Main window, which contain form and elements, upon certain action, triggers a popup window, which does two things of 1) query a database to pull certain data out; 2) write the data to (populate) the Main window, then, close itself. However, since, query/data retrieval and population may take a while, so, I'd like to add msg like, Please wait ... upon loading, and yet, it causes double buffer, the single popup window won't do, which leaves me with no choice but to add another little named popup window to say Please wait These two popup windows are loaded in the sequence of pop msg and pop data loader.Problem, pop data loader, closes itself upon job completion, fine, but the pop msg window won't close. If all the first popup window does is perform a query and populate the main window, have you considered using an iframe instead? Basically, here's what I'm thinking: Your main window will have a hidden iframe. Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame.And, if you want, you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done. That would seem a bit more user-friendly, because your users won't have to see the unnecessary pop-ups (not to mention that if they have pop-ups disabled, this code will still work). Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
cfscript start = 1; aLog = ArrayNew(1); while(true){ stTmp = REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space :]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star t,true); if(stTmp.pos[1]){ stLog = StructNew(); stLog = StructNew(); user1 = Mid(str,stTmp.pos[2],stTmp.len[2]); stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]); stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]); user2 = Mid(str,stTmp.pos[5],stTmp.len[5]); if(len(trim(user1))) stLog.user = trim(user1); else if(len(trim(user2))) stLog.user = trim(user2); else stLog.user = ; stLog.text = ; if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Mid(str,start,stTmp.pos[1]-start); } ArrayAppend(aLog,stLog); start = stTmp.pos[1]+stTmp.len[1]; } else{ if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str)-start)); } break; } } /cfscript cfoutput cfloop from=1 to=#ArrayLen(aLog)# index=i div class=timestamp#aLog[i].user# #aLog[i].date# #aLog[i].time#/div pre#aLog[i].text#/pre /cfloop /cfoutput -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 14:32 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) Pascal, sorry again for being such a PEST. I really do apprecaite your help. There can be more than one occurance of the timestamp in the comment column. Ex: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Can you please add code in your script to handle this and display all timestamps correctly Many thanks again cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
whats this error?
05/17 10:30:17 error Connection reset java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) at java.io.BufferedInputStream.read(BufferedInputStream.java:277) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:530) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:522) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:540) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:229) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:144) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:32 0) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:433) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:280) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) thanks! my cfmx server is crashing every half hour or so. HELP! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmx not picking up spooled messages
All of the sudden on our production server (running CFMX 6.1) has stopped picking up spooled mail messages. There are no errors in the logs related to cfmail and no new entries in the mail log. In addition, new messages are being added to the spool folder and they are never moved into the undelivr folder, they just never send out. No settings have changed via the CF Administrator and everything is configured properly. Any ideas? Thanks. Mike We had the same problem: the spool dir got more and more messages, and no spooler seemed to pick up any of them. Restart the CFMX service. Our spooler worked normally after this, and the spool dir was empty in a minute. I guess CFMX 6.1 had reached an inconsistent state without reporting any errors: I also found that after restarting the service we got a new logfile scheduled tasks, although I had defined several scheduled tasks the day before. Without restarting the service they never would have been started by CFMX. Dieter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
Pascal, I may have missed the answer to this question, but is the content that we are looking at a query record set (multiple records), or is it from like a flat file, where the content is just appended? It seems like all of these solutions are overly complex.It seems like such a simple problem to resolve. Thanks, Robert -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 10:15 A To: CF-Talk Subject: RE: help with string manipulation (Find,Replace) cfscript start = 1; aLog = ArrayNew(1); while(true){ stTmp = REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space :]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star t,true); if(stTmp.pos[1]){ stLog = StructNew(); stLog = StructNew(); user1 = Mid(str,stTmp.pos[2],stTmp.len[2]); stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]); stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]); user2 = Mid(str,stTmp.pos[5],stTmp.len[5]); if(len(trim(user1))) stLog.user = trim(user1); else if(len(trim(user2))) stLog.user = trim(user2); else stLog.user = ; stLog.text = ; if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Mid(str,start,stTmp.pos[1]-start); } ArrayAppend(aLog,stLog); start = stTmp.pos[1]+stTmp.len[1]; } else{ if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str)-start)); } break; } } /cfscript cfoutput cfloop from=1 to=#ArrayLen(aLog)# index=i div class=timestamp#aLog[i].user# #aLog[i].date# #aLog[i].time#/div pre#aLog[i].text#/pre /cfloop /cfoutput -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 14:32 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) Pascal, sorry again for being such a PEST. I really do apprecaite your help. There can be more than one occurance of the timestamp in the comment column. Ex: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Can you please add code in your script to handle this and display all timestamps correctly Many thanks again cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Thanks, Scott, this is a step forward from my last update.Did quick srch on iframe got little thing but not satisfactory. OK, I need some clarification.For consistency sake, let's stick with the naming convention for now. Main Window contains a hidden iframe (pop2), Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame Now, does the Main Window have to constructed as some sort of frame? the definition of iframe does not seem to suggest that. The way to construct the iframe piece is like? div id=loader style=visibility:hidden iframe src="" width=0 height=0 /div How to trigger the iframe to load (should be different from display, right?) you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done. Elaborate please.main frame refers to Main Window? Many thanks. Don Original Message: From: Chunshen (Don) Li I've spent at least one hour on figuring out how to work out this oo thing.Here's the scoop, I have one Main window, which contain form and elements, upon certain action, triggers a popup window, which does two things of 1) query a database to pull certain data out; 2) write the data to (populate) the Main window, then, close itself. However, since, query/data retrieval and population may take a while, so, I'd like to add msg like, Please wait ... upon loading, and yet, it causes double buffer, the single popup window won't do, which leaves me with no choice but to add another little named popup window to say Please wait These two popup windows are loaded in the sequence of pop msg and pop data loader.Problem, pop data loader, closes itself upon job completion, fine, but the pop msg window won't close. If all the first popup window does is perform a query and populate the main window, have you considered using an iframe instead? Basically, here's what I'm thinking: Your main window will have a hidden iframe. Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame.And, if you want, you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done. That would seem a bit more user-friendly, because your users won't have to see the unnecessary pop-ups (not to mention that if they have pop-ups disabled, this code will still work). Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
FW: Mihai Bazon ( mishoo ) website gone
-Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 9:40 AM To: CF-TALK Subject: Mihai Bazon ( mishoo ) website gone Does anyone know what's happened to http://dynarch.com? I was going to purchase his htmlarea code and the site's been down since Thursday night. Is he still there? Gil Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmx not picking up spooled messages
Sometimes the spool will get a zero byte message stuck at the top of the queue, and nothing behind it will send.Restarting may help, but you may have to go in and manually delete the junk message. At 10:39 AM 5/17/04, you wrote: All of the sudden on our production server (running CFMX 6.1) has stopped picking up spooled mail messages. There are no errors in the logs related to cfmail and no new entries in the mail log. In addition, new messages are being added to the spool folder and they are never moved into the undelivr folder, they just never send out. No settings have changed via the CF Administrator and everything is configured properly. Any ideas? Thanks. Mike We had the same problem: the spool dir got more and more messages, and no spooler seemed to pick up any of them. Restart the CFMX service. Our spooler worked normally after this, and the spool dir was empty in a minute. I guess CFMX 6.1 had reached an inconsistent state without reporting any errors: I also found that after restarting the service we got a new logfile scheduled tasks, although I had defined several scheduled tasks the day before. Without restarting the service they never would have been started by CFMX. Dieter -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:163343This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1523.1443.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=351d12e09.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
It's like a flat file. (a huge comment field in the DB). Storing the comments in a related table would have made his life easier, but I don't think he can change the way the data is stored. -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 16:37 To: CF-Talk Subject: RE: help with string manipulation (Find,Replace) Pascal, I may have missed the answer to this question, but is the content that we are looking at a query record set (multiple records), or is it from like a flat file, where the content is just appended? It seems like all of these solutions are overly complex.It seems like such a simple problem to resolve. Thanks, Robert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
My bad, I responded to Pascal earlier... Sorry about that. CFCODER: You have shown your data two ways, and this impacts any solution that is presented: Latest: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Originally: *** User1 10/28/2003 2:53:52 *** THIS IS A TEST *** User 2 04/06/200313:41:47 *** blah, blah So which is it? Also, I may have missed this answer, but it seems to me that the solution is to drop the separate data elements into their own fields in the database IN THE FIRST PLACE.That way they can be queried out, or barring that solution, change the code that writes each entry to include delimiters e.g. *** User 2|04/06/2003|13:41:47***blah, blah And use CR/LF between fields to separate records... I'm sorry if this doesn't help, but the fact is you are dealing with output that sorely needs to be reformatted to make it easier to process. You shouldn't need anything major to pull it apart. Thanks, Robert P.S. What are the rules for the data that you are pulling apart now? e.g. 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf etc... -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 8:32 A To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) Pascal, sorry again for being such a PEST. I really do apprecaite your help. There can be more than one occurance of the timestamp in the comment column. Ex: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Can you please add code in your script to handle this and display all timestamps correctly Many thanks again cfcoder thanks Pascal! It doesn't quite work how I would like it to. EX: *** 08/12/200320:33:31EDWARI31 *** You code displays the above timestamp like this: 0 8/12/2003 20:33:31 Where as I would like it to be displayed like this: EDWARI31 08/12/2003 20:33:31 I dumped stTmp cfdump var=#stTmp#. This is what it returns struct LEN array 1 38 2 2 3 9 4 8 5 11 POS array 1 1 2 4 3 6 4 17 5 25 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
You are a GENIUS man! That code rocks, I wouldn't know how to do this without your help. You are a star. Just one small problem, the comments column sometimes doesn't store the timestamp. I went through your code. The while condition in the above mentioned situation would be false so the code in the else part would be executed. if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); } The above condition would be false. I added a 'else' condition and want to assign 'str' to aLog[ArrayLen(aLog)].text. something like this: if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); } else { 'What should I be doing here?' } break; Many thanks again! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Original Message: From: Chunshen (Don) Li Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame Now, does the Main Window have to constructed as some sort of frame? the definition of iframe does not seem to suggest that. The way to construct the iframe piece is like? div id=loader style=visibility:hidden iframe src="" width=0 height=0 /div You don't need the div around it in order to hide it.You can just apply the style to the iframe.Assuming you're not going to load anything in that iframe when the page loads, here's one option: iframe name=loadFrame id=loadFrame style=display:none; src=""> How to trigger the iframe to load (should be different from display, right?) Using _javascript_, you can treat it just like a frame.Meaning something like this should work in whatever function you use to trigger the load: document.frames['loadFrame'].src = ''; you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done. Elaborate please.main frame refers to Main Window? Err, yeah. Main window that contains your hidden iframe.Basically, that main window also has a hidden div something like this: div id=waitDiv style=position:absolute;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden; Loading. Please wait... /div Now, in the _javascript_ above where you load the iframe's loader, you can do this: document.getElementById('waitDiv').style.visibility = 'visible'; In dataLoader.cfm, you can do an onload (or just after where you populate the main window's data) that does this: parent.document.getElementById('waitDiv').style.visibility = 'hidden'; All of that SHOULD work, but I'm typing this on the fly so haven' t tested it completely. If it doesn't work, let me know. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
If your format isn't always the same (*** user timestamp *** OR *** timestamp user ***) you can't use my code. You need to do it in a different way. I can help if you want, but if you keep changing the specs it's not very easy. Also, remind me what version you are on. I'm writing CF5 regexp for the moment, but this is easier in CFMX. Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 16:55 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) You are a GENIUS man! That code rocks, I wouldn't know how to do this without your help. You are a star. Just one small problem, the comments column sometimes doesn't store the timestamp. I went through your code. The while condition in the above mentioned situation would be false so the code in the else part would be executed. if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); } The above condition would be false. I added a 'else' condition and want to assign 'str' to aLog[ArrayLen(aLog)].text. something like this: if(ArrayLen(aLog)){ aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); } else { 'What should I be doing here?' } break; Many thanks again! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Hi Robert, apologies for causing any confusion. I was asked to present the data stored in the database table column in a certain way. Historically data stored in this column is as under: timestamp comments EX: *** 05/12/2003 09:52:10 USER1 *** closing if fixed - awaitng response from User2 I was asked to get rid of the stars and reorder the timestamp to something like this: USER1 05/12/2003 09:52:10 (Username, Date, Time) All comments (timestamps) added henceforth will be added in this fashion. I hope this gives you a better understanding. The solution Pascal provided does just that and it does the job for me. Best Regards, cfcoder My bad, I responded to Pascal earlier... Sorry about that. CFCODER: You have shown your data two ways, and this impacts any solution that is presented: Latest: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Originally: *** User1 10/28/2003 2:53:52 *** THIS IS A TEST *** User 2 04/06/200313:41:47 *** blah, blah So which is it? Also, I may have missed this answer, but it seems to me that the solution is to drop the separate data elements into their own fields in the database IN THE FIRST PLACE.That way they can be queried out, or barring that solution, change the code that writes each entry to include delimiters e.g. *** User 2|04/06/2003|13:41:47***blah, blah And use CR/LF between fields to separate records... I'm sorry if this doesn't help, but the fact is you are dealing with output that sorely needs to be reformatted to make it easier to process. You shouldn't need anything major to pull it apart. Thanks, Robert P.S. What are the rules for the data that you are pulling apart now? e.g. 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf 3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf etc... -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 8:32 A To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) Pascal, sorry again for being such a PEST. I really do apprecaite your help. There can be more than one occurance of the timestamp in the comment column. Ex: *** 05/12/200309:52:10USER1 *** closing if fixed - awaitng response from User2 *** 04/12/200318:55:18USER2 *** Have been there, however user was on air shortly after, will try again in a bit. *** 04/12/200318:13:22USER3 *** Roger that *** 04/12/200318:05:01USER4 *** closed Can you please add code in your script to handle this and display all timestamps correctly Many thanks again cfcoder thanks Pascal! It doesn't quite work how I would like it to. EX: *** 08/12/200320:33:31EDWARI31 *** You code displays the above timestamp like this: 0 8/12/2003 20:33:31 Where as I would like it to be displayed like this: EDWARI31 08/12/2003 20:33:31 I dumped stTmp cfdump var=#stTmp#. This is what it returns struct LEN array 1 38 2 2 3 9 4 8 5 11 POS array 1 1 2 4 3 6 4 17 5 25 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
sorry Pascal, my bad. The format is not always the same, there may be few comments in the database without the timestamp. All comments added when I build the functionality will not have the *** user timestamp ***. I have CFMX installed on the server. Best regards, cfcoder If your format isn't always the same (*** user timestamp *** OR *** timestamp user ***) you can't use my code. You need to do it in a different way. I can help if you want, but if you keep changing the specs it's not very easy. Also, remind me what version you are on. I'm writing CF5 regexp for the moment, but this is easier in CFMX. Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Deleted records being returned
I am using Visual Fox Pro8 to create my dbf tables. I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked. When I retrieve the records, all records are return including the deleted ones. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help with string manipulation (Find,Replace)
I'm off to home right now, but I'll send you the code in the morning (for me GMT+2) -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: maandag 17 mei 2004 17:15 To: CF-Talk Subject: Re: help with string manipulation (Find,Replace) sorry Pascal, my bad. The format is not always the same, there may be few comments in the database without the timestamp. All comments added when I build the functionality will not have the *** user timestamp ***. I have CFMX installed on the server. Best regards, cfcoder If your format isn't always the same (*** user timestamp *** OR *** timestamp user ***) you can't use my code. You need to do it in a different way. I can help if you want, but if you keep changing the specs it's not very easy. Also, remind me what version you are on. I'm writing CF5 regexp for the moment, but this is easier in CFMX. Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help with string manipulation (Find,Replace)
Thanks Pascal. Sorry again for any inconvenience caused. Best regards cfcoder I'm off to home right now, but I'll send you the code in the morning (for me GMT+2) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Your trigger will load a page in that hidden iframe which runs the query and then populates the data in the main visible frame Now, does the Main Window have to constructed as some sort of frame? the definition of iframe does not seem to suggest that. The way to construct the iframe piece is like? div id=loader style=visibility:hidden iframe src="" width=0 height=0 /div How to trigger the iframe to load (should be different from display, right?) you can have a hidden div in the main frame that says Please wait... that will become visible while that iframe code is doing its work and invisible when the iframe code is done. Thanks, Scott, not there yet, maybe I'm missing something. Here's more details: MAIN WINDOW js function xyz(obj,el,p1,p2,p3) document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3; bla bla tons of stuff div id=waitDiv style=position:absolute;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden; Loading. Please wait... /div iframe name=loadFrame id=loadFrame style=display:none; src="" content of dataloader.cfm: top: script parent.document.getElementById('waitDiv').style.display = 'block'; /script main js: pull data and populate the MAIN window // now close the please wait .. frame parent.document.getElementById('waitDiv').style.visibility = 'hidden'; msg win does not show up, data not loaded, what am i missing?many thanks. Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFmail and Spam
On Monday 17 May 2004 09:47 am, Adam Reynolds wrote: Is there anything that can be done to make it look like the mail came from say Outlook? You can change the ID of the sending mail program using cfmailparam. Check the archives. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmx admin question
On Monday 17 May 2004 11:53 am, Whittingham, P wrote: yes (cfstart) , but i think it produce some errors...how does one interprete them. Look in the logs sub. dir. of the CF install. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Please Help! XML Webservice Question
On Friday 14 May 2004 21:57 pm, Shawn Contreras wrote: HOW do I write code that says: If there is no data, skip to the next field and so on cfif isDefined('nameOfVar') -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: grabbing only a part of a string
On Thursday 13 May 2004 20:46 pm, Steve Nelson wrote: That looks like a short list to me. You could just use #listlast(custom|98,|)# If it's really more complex than that, check out the functions: findnocase() and mid() If it's really more complex than that, check our reFind() and friends. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Original Message: From: Chunshen (Don) Li msg win does not show up, data not loaded, what am i missing?many thanks. It could be any number of things. (It all looks right, but I may be missing something) Do you have a link where this is in action? If not, here are some things to try: 1) If you're using a Mozilla-based browser [or some other browser that doesn't popup JS error messages], make sure you're not getting any JS errors by using the _javascript_ Console 2) If you're not getting any JS errors, make sure the page knows the iframe exists.In your xyz function before setting the iframe's source, do an alert: alert(document.frames['loadFrame'].src); [you should get something like about:blank] (and do it again after you set the source and you should get the url you passed in) 3) If you see that the dataloader.cfm is being called in the iframe, go to that page and do another alert: alert(parent.document.getElementById('waitDiv'); [you should get something like object:object] If that still doesn't work, try to put it on a server somewhere so we can take a look. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Sorry, I missed one thing from your last post, here's the revised version, please see below.Thanks. Thanks, Scott, not there yet, maybe I'm missing something. Here's more details: MAIN WINDOW js function xyz(obj,el,p1,p2,p3) { ... // load the wait msg document.getElementById('waitDiv').style.visibility = 'visible'; // works // retrieve data and populate MAIN WINDOW document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3; /* this part seems problem, not loading tried variant document.frames['loadFrame'].src = ""> cfm?obj='+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3+; to no avail either */ } bla bla tons of stuff div id=waitDiv style=position:absolut e;top:100;left:100;height:200;width:200;z-index:2;visibility:hidden; Loading. Please wait... /div iframe name=loadFrame id=loadFrame style=display:none; src="" content of dataloader.cfm: top: script parent.document.getElementById('waitDiv').style.display = 'block'; /script ABOVE REMOVED. main js: pull data and populate the MAIN window // now close the please wait .. frame parent.document.getElementById('waitDiv').style.visibility = 'hidden'; msg win does not show up, data not loaded, what am i missing?many thanks. Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Maxing out running requests then server hanging -- Help
Everyone, We put out a new release of our web-application and have been having server problems problems ever since.All will run fine and then all of a sudden running requests will start creeping up and then CFMX hangs -- about every 4/6ish hours.Before the new release the most problems we would ever have was database locks and we could either wait for the database lock to finish or kill it -- none of this has been database locks.Majority of the time both boxes (2 web servers hardware loadbalanced) will be using up about 700ish meg of ram (both have 1 gig of ram) when they are hung.We tried even running CFMX from a command line to get a java stack trace when it hangs, but it never would create a dump of the stack trace for us even -- t hung I am assuming. Then this past week for a solid hour the running requests would keep running up to the max (25/box) and then would hang -- all we could do was continually restart the service which we did about 20 times on both boxes -- we tried rebooting in the middle of all this as well which didn't help either.The weird thing was after about an hour it all went back to the 4/6ish hour hand routine. Any ideas on what could be causing the hangs?Since the new release used CFC's heavily could this be causing any of the issues?Any ideas on better ways to trace/debug it? Here are the details on our setup (all software is fully patched): 2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with an Apache webserver (2.046) Seperate box running MS SQL Server Approximate traffic is 12K to 15K unique visitors/day Thanks, Jeremy -- Jeremy Bruck ManufacturingQuote [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Advanced session mgt?
Can someone please advise if there is anything I should know about this process? It seems that whenever I enable a Who's online or homegrown advanced session information features on my site, the server eventually degrades etc...Other than a CFLOCK which I know I need to add in (and will) is there any other red flags about doing something like this which I should be aware of? I am trying to determine if there are any known issues with CFMX 6.1 with doing something like that. Here's (in cf-nevercompiled-pseudocode) what I'm doing: (names of files are made up for this email...) !--- Act_OnLoginSuccessful.cfm --- Cfset session.state = structnew() Cfset session.username = SomeLoginQuery.username Cfset structinsert(session.username,session.state) !--- App_globals.cfm or application.cfm --- Cfparam name=application.states default=structnew() Cfif isdefined(session.state) Cfset session.state.last=now() /cfif !--- Dsp_WhosOnline.cfm --- cfset MyStruct=StructCopy(Application.states) Cfloop list=structkeylist(mystruct) index=key Cfif datediff(n,structfind(structfind(mystruct,key),last),now()) gt 30 CFset structdelete(application.states,key) /cfif Cfelse Display something here about #key# and #structfind(structfind(mystruct,key),last)# /cfif /cfloop NOTICE: If received in error, please destroy and notify sender.Sender does not waive confidentiality or privilege, and use is prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Maxing out running requests then server hanging -- Help
Well the only thing I've seen on our boxes that is similar is if a parsing error occurs (likea cfset missing an opening or closing bracket).What happens when that page is run, JRun starts eating RAM until the server grinds to a halt. This happens fairly quickly though and I would suspect that that you've got something else going on...because that kind of traffic with the issue we've seen would toast your servers much faster than they seem to be dying. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jeremy Bruck To: CF-Talk Sent: Monday, May 17, 2004 9:18 AM Subject: Maxing out running requests then server hanging -- Help Everyone, We put out a new release of our web-application and have been having server problems problems ever since.All will run fine and then all of a sudden running requests will start creeping up and then CFMX hangs -- about every 4/6ish hours.Before the new release the most problems we would ever have was database locks and we could either wait for the database lock to finish or kill it -- none of this has been database locks.Majority of the time both boxes (2 web servers hardware loadbalanced) will be using up about 700ish meg of ram (both have 1 gig of ram) when they are hung.We tried even running CFMX from a command line to get a java stack trace when it hangs, but it never would create a dump of the stack trace for us even -- t hung I am assuming. Then this past week for a solid hour the running requests would keep running up to the max (25/box) and then would hang -- all we could do was continually restart the service which we did about 20 times on both boxes -- we tried rebooting in the middle of all this as well which didn't help either.The weird thing was after about an hour it all went back to the 4/6ish hour hand routine. Any ideas on what could be causing the hangs?Since the new release used CFC's heavily could this be causing any of the issues?Any ideas on better ways to trace/debug it? Here are the details on our setup (all software is fully patched): 2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with an Apache webserver (2.046) Seperate box running MS SQL Server Approximate traffic is 12K to 15K unique visitors/day Thanks, Jeremy -- Jeremy Bruck ManufacturingQuote [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Original Message: From: Chunshen (Don) Li // retrieve data and populate MAIN WINDOW document.frames['loadFrame'].src = ''+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3; /* this part seems problem, not loading tried variant document.frames['loadFrame'].src = ""> cfm?obj='+obj+'col='+jcol+'pop1='+p1+'pop2='+p2+'pop3='+p3+; to no avail either */ } I'd say try the JS alerts I suggested in my last reply and make sure that the iframe's src is being set. There's also a possibility that the .cfm file is throwing an error (one problem with invisible iframes:you don't see the error messages).So, you can try doing a try/catch block around it and alert a message if there's a CF error occurring. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Maxing out running requests then server hanging -- Help
We put out a new release of our web-application and have been having server problems problems ever since.All will run fine and then all of a sudden running requests will start creeping up and then CFMX hangs -- about every 4/6ish hours.Before the new release the most problems we would ever have was database locks and we could either wait for the database lock to finish or kill it -- none of this has been database locks.Majority of the time both boxes (2 web servers hardware loadbalanced) will be using up about 700ish meg of ram (both have 1 gig of ram) when they are hung.We tried even running CFMX from a command line to get a java stack trace when it hangs, but it never would create a dump of the stack trace for us even -- t hung I am assuming. Then this past week for a solid hour the running requests would keep running up to the max (25/box) and then would hang -- all we could do was continually restart the service which we did about 20 times on both boxes -- we tried rebooting in the middle of all this as well which didn't help either.The weird thing was after about an hour it all went back to the 4/6ish hour hand routine. Any ideas on what could be causing the hangs?Since the new release used CFC's heavily could this be causing any of the issues?Any ideas on better ways to trace/debug it? Here are the details on our setup (all software is fully patched): 2 hardware loadbalanced webservers running Win2K with CFMX 6.1 with an Apache webserver (2.046) Seperate box running MS SQL Server Approximate traffic is 12K to 15K unique visitors/day We had similar problems that were resolved by reverting the 6.1 database drivers to the 6.0+ version available at the related TechNote (http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_cpu.htm). Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have luck with those, but we continued to have problems, so we're still on the 6.0+ drivers. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Losing Sessions Variable
Experts, I am reposting this question. Please bear with me. Application.cfm isfollows .. .. cfparam name=Session.LogState default=OUT cfif IsDefined(url.uCmpyID) cfinclude template=set_session.cfm /cfif .. .. In set_session.cfm,after our authentication session variable is set as follows, cfset session.LogState = IN Authentication All pages looks for this session, otherwise it kicks you out. Home page works fine and we can see the session variable in debug statement. But, here is mystery, if we click any link in home page, session variable gets disappeared and hence that page kicks you out. All links are cfmx templates in same server and directory. Also (1) We have enabled session management in Application.cfm (2) We have given ample time in CFMX admin for session timeout. Have you come across this issue of losing sessions. Any ideas how to retain session, between pages? Venky [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Losing Sessions Variable
Make sure you don't have more than one CFAPPLICATION tag in your code... and that the name is the always the same: cfparam name=request.app.internal_name default = TEST_DEV cfparam name=request.app.timespan default = #createTimeSpan(0,4,0,0)# cfapplication name=#request.app.internal_name#_10 clientmanagement=Yes sessionmanagement=Yes sessiontimeout=#request.app.timespan# clientstorage=test_DSN loginstorage=session If you have another CFAPPLICATION tag anywhere else, you lose the original cfapplication data. Robert -Original Message- From: ANNAMANAIDU, VENKATESH (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:47 P To: CF-Talk Subject: Losing Sessions Variable Experts, I am reposting this question. Please bear with me. Application.cfm isfollows .. .. cfparam name=Session.LogState default=OUT cfif IsDefined(url.uCmpyID) cfinclude template=set_session.cfm /cfif .. .. In set_session.cfm,after our authentication session variable is set as follows, cfset session.LogState = IN Authentication All pages looks for this session, otherwise it kicks you out. Home page works fine and we can see the session variable in debug statement. But, here is mystery, if we click any link in home page, session variable gets disappeared and hence that page kicks you out. All links are cfmx templates in same server and directory. Also (1) We have enabled session management in Application.cfm (2) We have given ample time in CFMX admin for session timeout. Have you come across this issue of losing sessions. Any ideas how to retain session, between pages? Venky [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Scott, Please see my comments below.Thanks. Don Original Message: I'd say try the JS alerts I suggested in my last reply and make sure that the iframe's src is being set. Right on.err msg undefined. There's also a possibility that the .cfm file is throwing an error (one problem with invisible iframes:you don't see the error messages).So, you can try doing a try/catch block around it and alert a message if there's a CF error occurring. CF error extremly unlikely for the dataloader.As for the try/catch, yes, I use it. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Original Message: Do you have a link where this is in action? Scott, I've just sent an email to [EMAIL PROTECTED] with a URL. Thanks. Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Maxing out running requests then server hanging -- Help
We had similar problems that were resolved by reverting the 6.1 database drivers to the 6.0+ version available at the related TechNote (http://www.macromedia.com/support/coldfusion/ts/documents/cfm x61_sqlserver_cpu.htm). Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have luck with those, but we continued to have problems, so we're still on the 6.0+ drivers. Out of curiosity, are you having the same problems with the 3.3 drivers that you were with the 3.2 drivers? What database server are you using? For our SQL Server clients, we've successfully deployed the MS JDBC drivers in some cases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: JavaScript RegEx bug in NS6?
I think I've found a bug in the _javascript_ RegEx implementation in Netscape 6 (for Windows, anyway).Below is a RegEx pattern for a non-IP email address.The first alert shows zero, which is a match beginning with the first character, but the second alert shows '-1', indicating no match.The only difference is using $ for an end-of-line anchor.This code works correctly in NS4(!), NS7 and IE6.Any JS gurus out there have any ideas for a workaround for this? Thanks, Chris SCRIPT LANGUAGE=_javascript_ var s = '[EMAIL PROTECTED]'; alert(s.search(/^['_a-z0-9-]+(\.[_a-z0-9-]+)*@([a-z0-9-]+\.)+([a-z]{2,3}|aero|coop|info|museum|name)/i)); alert(s.search(/^['_a-z0-9-]+(\.[_a-z0-9-]+)*@([a-z0-9-]+\.)+([a-z]{2,3}|aero|coop|info|museum|name)$/i)); /SCRIPT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF_Web_services preparation for consumption
All, We're writing CFCs tht will become Web services.These Web services are going to be data exchanges from a few of our database tables.We want the Web Services to be used to access our database information and import the data to their own database.To sign up for access to these Web Services, Affiliates will have to log in via a username and password which drops them into their own subdirectory below the webroot. My three questions are ... 1) How can I prevent these Affiliates from using these Web services as live data feeds to populate their Web pages?Can I somehow restrict the number of hits/bytes to these Web services? 2) What's the best way to present example code for the various application development laungauges? I want to give users of our Web Service sample code based on their application launguage. I was going to see what code was developed within DreamWeaver's component panel and edit the Proxy Generator from Cold Fusion MX to what's available. (.NET C#, .NET VB, APACHE SOAP 3.0) 3) When I click on new Proxy Generator and then Get more proxy generators, it takes me to the Macromedia site, but i can't find any downloadables that look like proxy generators.I'd like to find generators for JSP, PHP and a PERL generator is there is one. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JavaScript RegEx bug in NS6?
It works fine on Mozilla 1.6 NN 6 was based on a beta version of Mozilla and was very buggy. You should at least try NN 7 Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue
Re-Post I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then installed CFMX 6.1.I am not using Active Directory. After going through the install chores, the installer notifies you that the installation was successful and that CFMX administrator will then open in the browser to complete the installation.The install log file shows no errors. This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE All files seem to be in the right place, and the ISAPI configuration appears to be set up by the installer correctly.all the settings shown in the exhibit of Dave Watts paper on the Macromedia site appear to be in place. Anyone have a clue as what I need to do to get this installation completed? Thanks Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFmail and Spam
Actually, don't use CFMAILPARAM for this.Using CFMAILPARAM this way causes there to be 2 X-Mailer headers.Instead, use the MAILERID attribute of the CFMAIL tag to set the X-Mailer header like the following: CFMAIL TO=.. MAILERID=Microsoft Outlook, Build 10.0.3416 ... /CFMAIL -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 11:44 AM To: CF-Talk Subject: Re: CFmail and Spam On Monday 17 May 2004 09:47 am, Adam Reynolds wrote: Is there anything that can be done to make it look like the mail came from say Outlook? You can change the ID of the sending mail program using cfmailparam. Check the archives. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion installation issue
for some reason the CF Application Service was not restarted on mine, I had to restart it and all was fine. -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 2:20 PM To: CF-Talk Subject: Re: ColdFusion installation issue Re-Post I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then installed CFMX 6.1.I am not using Active Directory. After going through the install chores, the installer notifies you that the installation was successful and that CFMX administrator will then open in the browser to complete the installation.The install log file shows no errors. This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE All files seem to be in the right place, and the ISAPI configuration appears to be set up by the installer correctly.all the settings shown in the exhibit of Dave Watts paper on the Macromedia site appear to be in place. Anyone have a clue as what I need to do to get this installation completed? Thanks Doug _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Deleted records being returned
Can someone please help??? I am using Visual Fox Pro8 to create my dbf tables. I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked. When I retrieve the records, all records are return including the deleted ones. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleted records being returned
John, It's been a long time since I've seen a foxpro .dbf, but I'm sure I can help if you post some code. When you say refer to it with ColdFusion, do you mean you created a datasource pointing to it? Did you query the table in a CF template? Post the code in question. Greg -Original Message- From: John Croney [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 2:34 PM To: CF-Talk Subject: Re: Deleted records being returned Can someone please help??? I am using Visual Fox Pro8 to create my dbf tables. I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked. When I retrieve the records, all records are return including the deleted ones. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JavaScript RegEx bug in NS6?
Thanks for the feedback on Mozilla--good to know.I'd heard that NN6 was buggy but my goal is to support users who have NN6 if at all possible rather than ask them to upgrade. Chris -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 2:00 PM To: CF-Talk Subject: Re: _javascript_ RegEx bug in NS6? It works fine on Mozilla 1.6 NN 6 was based on a beta version of Mozilla and was very buggy. You should at least try NN 7 Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFChart and the Y-Axis
Hi all, Got one for you all.(and yes I did search the list history before asking!) :) I have a cfchart that has a minimum value of 0 (zero) and a maximum of 100. No matter whether I put in only integers or decimals (the data that will be in the final chart) the Y-Axis always shows up in decimals. Example: 100 88.89 77.78 66.67 55.56 44.44 33.33 22.22 11.11 0 but what I need is for all of them to be in integers (the data will still be in decimals). 100 90 80 70 60 50 40 30 20 10 0 Anyone know how to make this happen? Extra information: Line chart with 3 series. CFMX6.1 Enterprise Win2K IIS5 Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to validate form variables with this method including Encoding: multi-part/form-data
Hi, all... I know the subject is unclear, but here's the situation. I'm using CF 4.5... I validate formfields by submitting a form back to the page containing the form and using CFTRY / CFCATCH, then, if everything passes validation, setting the form variables to session variables and then using CFLOCATION to pass them to an action page for processing. I haven't, to this point, used this method, with a from that contains a file upload field. Typically, with a form that contains a file upload field, I just don't validate the fields. I would, however, like to start validating all form submissions, even those that contain file upload fields. The main question is...how would I pass on the Encoding type: multipart/form-date specification through the form page itself during verification then send that encoding info along with the session variables to the processing page using my typical CFLOCATION URL="" ? Here's the code I've set up so far to validate the form entries... CFIF IsDefined(Form.Submit) CFTRY CFIF Form.Newsletter_Title is CFTHROW Type=AddError Message=Please enter a title for the newsletter. /CFIF CFIF Form.Newsletter_Upload is CFTHROW Type=AddError Message=Please use the Browse button below to locate the newsletter file. /CFIF CFLOCK Scope=Session Type=Exclusive Timeout=10 CFSET Session.Newsletter.Newsletter_Title = Form.Newsletter_Title CFSET Session.Newsletter.Newsletter_Upload = Form.Newsletter_Upload /CFLOCK CFLOCATION URL = "" AddToken=No CFCATCH Type=AddError Error Message... /CFCATCH /CFTRY /CFIF Thanks, Rick Rick Faircloth -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.241 / Virus Database: 262.10.1 - Release Date: 5/16/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The never-ending windows
Original Message: From: Chunshen (Don) Li I'd say try the JS alerts I suggested in my last reply and make sure that the iframe's src is being set. Right on.err msg undefined. I always make this mistake. Instead of doing the .src of the iframe, try the location.href of the iframe. (I never remember if it's the document.location.href or the .src) i.e.:document.frames['loadFrame'].location.href = ''; (or whatever your frame's name is) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_IMAP with TLS support beta programme. Anyone interested?
Hi all, I've just completed my alpha tests on a new version of CFX_IMAP4 that should now support TLS based connections as well as the standard authentication methods of CRAM-MD5, LOGIN and PLAIN. My access to IMAP servers supporting TLS is limited and so I am looking for people that would be interested in helping beta test. If anyone is interested in joining a beta test programme for this tag then please mail me off list and I can sort out distribution for a limited number of people. For those that may be interested, the tag is Windows only, Delphi (C++ style) CFX. I would like to know what IMAP server you would be testing against so that I can test the tag against as wider number of servers as possible. Thanks in advance Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue
Been there done that - all services running - install log files show no errors and still no joy but thanks for the reply. Doug for some reason the CF Application Service was not restarted on mine, I had to restart it and all was fine. -Original Message- To: CF-Talk Subject: Re: ColdFusion installation issue Re-Post I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then installed CFMX 6.1.I am not using Active Directory. After going through the install chores, the installer notifies you that the installation was successful and that CFMX administrator will then open in the browser to complete the installation.The install log file shows no errors. This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE All files seem to be in the right place, and the ISAPI configuration appears to be set up by the installer correctly.all the settings shown in the exhibit of Dave Watts paper on the Macromedia site appear to be in place. Anyone have a clue as what I need to do to get this installation completed? Thanks Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Deleted records being returned
In VFP look at the commands Set deleted() on(to filter deleted records) PACK(this command will remove the deleted records permanently) These commands only work within the VFP environment.If you do it via SQL, then you must copy the records to another table (temp will do) with a Where not deleted.Then delete the original table and rename the temp table to the same name as the original. == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == Can someone please help??? I am using Visual Fox Pro8 to create my dbf tables. I have created a connection on the server ODBC and referred to it in Coldfusion. The option for Deleted in the ODBC for VFP is not checked. When I retrieve the records, all records are return including the deleted ones. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion installation issue
Have you tried re-starting the World-wide web services from the IIS module? Not from the services, but the IIS module? -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:17 PM To: CF-Talk Subject: Re: ColdFusion installation issue Been there done that - all services running - install log files show no errors and still no joy but thanks for the reply. Doug for some reason the CF Application Service was not restarted on mine, I had to restart it and all was fine. -Original Message- To: CF-Talk Subject: Re: ColdFusion installation issue Re-Post I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then installed CFMX 6.1.I am not using Active Directory. After going through the install chores, the installer notifies you that the installation was successful and that CFMX administrator will then open in the browser to complete the installation.The install log file shows no errors. This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE All files seem to be in the right place, and the ISAPI configuration appears to be set up by the installer correctly.all the settings shown in the exhibit of Dave Watts paper on the Macromedia site appear to be in place. Anyone have a clue as what I need to do to get this installation completed? Thanks Doug _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
2 OnRequestEnd files
Hello all, I have an application residing in a subdirectory of my web root. Inside the application subdirectory I have my Application.cfm and OnRequestEnd.cfm files; my web root contains both files as well. As far as I can tell the webroot/Application.cfm is not processed (as I expect). But the webroot/OnRequestEnd.cfm is processed then my application/OnRequestEnd.cfm is processed, I thought that CFMX was only supposed to process my application/OnRequestEnd.cfm and then stop. Processing steps (as I can determine) 1. application/Application.cfm 2. application code 3. webroot/OnRequestEnd.cfm 4. application/OnRequestEnd.cfm Can someone please explain this to me or am I overlooking something plain and simple? Thanks! Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion installation issue
This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE Is this all the page says? Did you install CFMX as a standalone server, or on top of JRun? What happens if you just try to run your own CFM page? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Array question
Why can't I get a display of the fields I'm entering with this array? When I cfoutput the #arraylen(session.item)#its always 0 (zero). CFIF Not IsDefined(Session.item) CFSET session.item = arraynew(2) /CFIF CFIF isDefined(form.more.x) CFSET itemcount = arraylen(session.item) #arraylen(session.item)# CFLOOP from=1 to=#arraylen(session.item)# index=i step=1 CFSET Session.item[itemcount+1][1]=form.qty CFSET Session.item[itemcount+1][2]=form.item CFSET Session.item[itemcount+1][3]=form.priceeach #session.item[i][1]#br #session.item[i][2]#br #session.item[i][3]#br /cfloop /cfif /CFOUTPUT Robert Orlini HW Wilson 718-588-8400 x2656 ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weird CFHTTP Error....
Talk about a WEIRD error. I need some help getting to the bottom of this. I have a custom tag being called to from a CFHTTP call with cfhttpparam form variables.The server I am working on is CFMX 6.0. One way I call the tag it throws an error, but not out to the screen. Looking at my logs this is what it is... Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by error-handling template: Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm Error,jrpp-236,05/17/04,14:27:35,,Data source HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:41333 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,trucated (this goes on for about 30 lines).application/x-www-form-urlencoded ,app could not be found. The specific sequence of files included or processed is: I:\CFusionMX\CustomTags\Interface\GetHistory.cfm Has anyone ever run into anything even remotely close to this??? Any help would be greatly appreciated. Thanks! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue
Yes I have - several times in fact - plus complete re-boots, still no joy - Have you tried re-starting the World-wide web services from the IIS module? Not from the services, but the IIS module? Been there done that - all services running - install log files show no errors and still no joy but thanks for the reply. Doug for some reason the CF Application Service was not restarted on mine, I had to restart it and all was fine. -Original Message- To: CF-Talk Subject: Re: ColdFusion installation issue Re-Post I set up a new installation of Windows 2003 Enterprise, [ IIS 6.0 ]and then installed CFMX 6.1.I am not using Active Directory. After going through the install chores, the installer notifies you that the installation was successful and that CFMX administrator will then open in the browser to complete the installation.The install log file shows no errors. This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE All files seem to be in the right place, and the ISAPI configuration appears to be set up by the installer correctly.all the settings shown in the exhibit of Dave Watts paper on the Macromedia site appear to be in place. Anyone have a clue as what I need to do to get this installation completed? Thanks Doug _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue
Hi Dave; That is all the page says.Since Admin will not run, the scripts required to complete the install have also not yet run.Consequently CFM pages will not run either The install log shows no errors - all stopped services are restarted as they should be. The install was NOT a standalone but on IIS/JRUN This is where I ran into a problemWhen IE opens up and tries to open the CFMX administrator page, it reports SERVICE NOT AVAILABLE Is this all the page says? Did you install CFMX as a standalone server, or on top of JRun? What happens if you just try to run your own CFM page? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Array question
Because arrayLen(session.item) is 0 and your looping from 1-arrayLen(session.item). If your just trying to add an item to the array from a form post just use the following. cfif not isDefined('session.item') cfset session.item=arrayNew(2) /cfif cfset arrayLength=arrayLen(session.item) cfset session.item[variables.arrayLength+1][1]='qty' cfset session.item[variables.arrayLength+1][2]='item' cfset session.item[variables.arrayLength+1][3]='price' cfoutput#arrayLen(session.item)#/cfoutput cfdump var=#session.item# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to validate form variables with this method including Encoding: multi-part/form-data
Well, one thing to remember is that with CFFILE, you don't get physical access to the upload, other than the fact that you know info about it (filename, size, etc). So, you could pass that info in a field on to the next page, for example. The fact the cffile handles the upload for you is all you care about; once you have the name of the file, and size (for example), you really don't need anything else at that point. If you need to validate the file itself, you can do that, by doing your compare against the cffile variables (you might wanna only allow certain filetypes for example). I would recommend you working some client side validated into the process.It would save the user some time if the process was never allowed to happen server side at all if they hadn't done everything they needed to submit (e.g. use REQUIRED, or _javascript_). Another thing is that you don't need to do any cflocation either, or use the session scope if after the validation, you just included your data posting, and thus you'd be able to eleviate a hassle (in passing that info around). Robert -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:42 P To: CF-Talk Subject: How to validate form variables with this method including Encoding: multi-part/form-data Hi, all... I know the subject is unclear, but here's the situation. I'm using CF 4.5... I validate formfields by submitting a form back to the page containing the form and using CFTRY / CFCATCH, then, if everything passes validation, setting the form variables to session variables and then using CFLOCATION to pass them to an action page for processing. I haven't, to this point, used this method, with a from that contains a file upload field. Typically, with a form that contains a file upload field, I just don't validate the fields. I would, however, like to start validating all form submissions, even those that contain file upload fields. The main question is...how would I pass on the Encoding type: multipart/form-date specification through the form page itself during verification then send that encoding info along with the session variables to the processing page using my typical CFLOCATION URL="" ? Here's the code I've set up so far to validate the form entries... CFIF IsDefined(Form.Submit) CFTRY CFIF Form.Newsletter_Title is CFTHROW Type=AddError Message=Please enter a title for the newsletter. /CFIF CFIF Form.Newsletter_Upload is CFTHROW Type=AddError Message=Please use the Browse button below to locate the newsletter file. /CFIF CFLOCK Scope=Session Type=Exclusive Timeout=10 CFSET Session.Newsletter.Newsletter_Title = Form.Newsletter_Title CFSET Session.Newsletter.Newsletter_Upload = Form.Newsletter_Upload /CFLOCK CFLOCATION URL = "" AddToken=No CFCATCH Type=AddError Error Message... /CFCATCH /CFTRY /CFIF Thanks, Rick Rick Faircloth -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.241 / Virus Database: 262.10.1 - Release Date: 5/16/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 2 OnRequestEnd files
Do you have a cfinclude template=../OnRequestEnd.cfm / in your approot's OnRequestEnd.cfm to chain them together? OnRequestEnd.cfm should only be processed for the directory that contains Application.cfm.There isn't a directory tree parse for OnRequestEnd.cfm, it uses the one that was performed for Application.cfm. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:33 PM To: CF-Talk Subject: 2 OnRequestEnd files Hello all, I have an application residing in a subdirectory of my web root. Inside the application subdirectory I have my Application.cfm and OnRequestEnd.cfm files; my web root contains both files as well. As far as I can tell the webroot/Application.cfm is not processed (as I expect). But the webroot/OnRequestEnd.cfm is processed then my application/OnRequestEnd.cfm is processed, I thought that CFMX was only supposed to process my application/OnRequestEnd.cfm and then stop. Processing steps (as I can determine) 1. application/Application.cfm 2. application code 3. webroot/OnRequestEnd.cfm 4. application/OnRequestEnd.cfm Can someone please explain this to me or am I overlooking something plain and simple? Thanks! Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to validate form variables with this method including Encoding: multi-part/form-data
I'm not entirely sure why you feel you can't validate that encoding type; the only difference is that it allows UPLOADING.So you can't validate that one field; you can still do the same thing (validate) with all of your other fields. One thing to remember is that with CFFILE, you don't get physical access to the upload, other than the fact that you know info about it (filename, size, etc). So, you could pass that info in a field on to the next page, for example. The fact the cffile handles the upload for you is all you care about; once you have the name of the file, and size (for example), you really don't need anything else at that point. If you need to validate data about the file upload itself, you can do that by doing your compare against the cffile variables (you might wanna only allow certain filetypes for example). I would recommend you working some client side validation into the process.It would save the user some time if the process was never allowed to happen server side at all if they hadn't done everything they needed to submit (e.g. use REQUIRED, or _javascript_). Another thing is that you don't need to do any cflocation either, or use the session scope if after the validation, you just included your data posting, and thus you'd be able to alleviate a hassle (in passing that info around). Robert -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:42 P To: CF-Talk Subject: How to validate form variables with this method including Encoding: multi-part/form-data Hi, all... I know the subject is unclear, but here's the situation. I'm using CF 4.5... I validate formfields by submitting a form back to the page containing the form and using CFTRY / CFCATCH, then, if everything passes validation, setting the form variables to session variables and then using CFLOCATION to pass them to an action page for processing. I haven't, to this point, used this method, with a from that contains a file upload field. Typically, with a form that contains a file upload field, I just don't validate the fields. I would, however, like to start validating all form submissions, even those that contain file upload fields. The main question is...how would I pass on the Encoding type: multipart/form-date specification through the form page itself during verification then send that encoding info along with the session variables to the processing page using my typical CFLOCATION URL="" ? Here's the code I've set up so far to validate the form entries... CFIF IsDefined(Form.Submit) CFTRY CFIF Form.Newsletter_Title is CFTHROW Type=AddError Message=Please enter a title for the newsletter. /CFIF CFIF Form.Newsletter_Upload is CFTHROW Type=AddError Message=Please use the Browse button below to locate the newsletter file. /CFIF CFLOCK Scope=Session Type=Exclusive Timeout=10 CFSET Session.Newsletter.Newsletter_Title = Form.Newsletter_Title CFSET Session.Newsletter.Newsletter_Upload = Form.Newsletter_Upload /CFLOCK CFLOCATION URL = "" AddToken=No CFCATCH Type=AddError Error Message... /CFCATCH /CFTRY /CFIF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array question
Thank you. One more ?: How do I clear the array to start over? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:50 PM To: CF-Talk Subject: Re: Array question Because arrayLen(session.item) is 0 and your looping from 1-arrayLen(session.item). If your just trying to add an item to the array from a form post just use the following. cfif not isDefined('session.item') cfset session.item=arrayNew(2) /cfif cfset arrayLength=arrayLen(session.item) cfset session.item[variables.arrayLength+1][1]='qty' cfset session.item[variables.arrayLength+1][2]='item' cfset session.item[variables.arrayLength+1][3]='price' cfoutput#arrayLen(session.item)#/cfoutput cfdump var=#session.item# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using recursion with query results
I'm trying to build a recursive routine that will go through my query results and display them in a tree structure.There are four fields in each row of my results.Is it possible for me to pass an entire row of my query results to a custom tag?If so, when I come back out of my recursive routine, will CF know that that row has been processed?Or is it best for me to throw all my query results into a structure then run the recursive routine? I've done this in ASP, but I'm at a loss in ColdFusion.I know this should be easy, but Nancy P. Tracy Electrical Design and Web Development GE Global Controls Services 3800 N. Wilson Ave. Loveland, CO 80538 970.461.5273 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
This is in the exception log if it helps anyone answer the question. at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source) at cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR BGetHistory.cfm:22) at cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB GetHistory.cfm:272) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. at coldfusion.runtime.DotResolver.resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source) at cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep tion\coldfusion\runtime\DatabaseException.cfm:13) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.CfincludeFilter.include(Unknown Source) at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source) at coldfusion.filter.ExceptionFilter.handleException(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jeff -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:21 PM To: CF-Talk Subject: Weird CFHTTP Error Talk about a WEIRD error. I need some help getting to the bottom of this. I have a custom tag being called to from a CFHTTP call with cfhttpparam form variables.The server I am working on is CFMX 6.0. One way I call the tag it throws an error, but not out to the screen. Looking at my logs this is what it is... Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by error-handling template: Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm Error,jrpp-236,05/17/04,14:27:35,,Data source HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:41333 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded,application/x-www-form-u rlencoded,trucated (this goes on for about 30 lines).application/x-www-form-urlencoded ,app could not be found. The specific sequence of files
RE: Using recursion with query results
If you're tree-ing the recordset, I assume that you have a itemID/parentID field coupling?Here's the basic algorithm that I use to perform such a convertion: cffunction name=makeTree cfargument name=rs / cfargument name=parentID default= / cfargument name=level default=0 / cfloop query=rs cfif rs.parentID EQ parentID cfoutput#repeatString(nbsp; , level)##rs.name#br //cfoutput cfset makeTree(rs, itemID, level + 1) / /cfif /cfloop /cffunction Keep in mind that this isn't particularly efficient (even with optimization) and that you should try to cache the generated tree in some form or another, rather than regenerating it every request.If you need to generate it every request, then you're probably better of using a different storage mechanism (the Nested Set Model, is one). Cheers, barneyb Cheers barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 1:12 PM To: CF-Talk Subject: Using recursion with query results I'm trying to build a recursive routine that will go through my query results and display them in a tree structure.There are four fields in each row of my results.Is it possible for me to pass an entire row of my query results to a custom tag?If so, when I come back out of my recursive routine, will CF know that that row has been processed?Or is it best for me to throw all my query results into a structure then run the recursive routine? I've done this in ASP, but I'm at a loss in ColdFusion.I know this should be easy, but Nancy P. Tracy Electrical Design and Web Development GE Global Controls Services 3800 N. Wilson Ave. Loveland, CO 80538 970.461.5273 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
I can't say for sure, but it looks like your Error handler is throwing an error. -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:58 P To: CF-Talk Subject: RE: Weird CFHTTP Error This is in the exception log if it helps anyone answer the question. at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source) at cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR BGetHistory.cfm:22) at cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB GetHistory.cfm:272) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. at coldfusion.runtime.DotResolver.resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source) at cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep tion\coldfusion\runtime\DatabaseException.cfm:13) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.CfincludeFilter.include(Unknown Source) at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source) at coldfusion.filter.ExceptionFilter.handleException(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jeff -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:21 PM To: CF-Talk Subject: Weird CFHTTP Error Talk about a WEIRD error. I need some help getting to the bottom of this. I have a custom tag being called to from a CFHTTP call with cfhttpparam form variables.The server I am working on is CFMX 6.0. One way I call the tag it throws an error, but not out to the screen. Looking at my logs this is what it is... Error,jrpp-237,05/17/04,14:27:35,,Exception thrown by error-handling template: Error,jrpp-237,05/17/04,14:27:35,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm Error,jrpp-236,05/17/04,14:27:35,,Data source HTTP_ACCEPT:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2 HTTP_CONNECTION:keep-alive HTTP_HOST:127.0.0.1 HTTP_USER_AGENT:Java1.3.1_03 HTTP_CONTENT_LENGTH:41333
Re: Array question
Use arrayClear(session.item) or just reset the array cfset session.item=arrayNew(2) Robert Orlini wrote: Thank you. One more ?: How do I clear the array to start over? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using recursion with query results
I think your friend may be the array notion for a ColdFusion record set.Try playing with these and see if this doesn't lead somewhere. The following forms are perfectly legal ways to reference record sets. query.columnName[row] query[columnName][row] Also if you are using a cfoutput query= or a cfloop query= #currentRow# is a system variable of the current row (duh) that the loop is in. Hopefully these will get you on the right track. Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
At 03:58 PM 5/17/04, Jeff wrote: This is in the exception log if it helps anyone answer the question. Looks like the query being called by the CFHTTP tagisn't finding a valid data source, or the data source isn't finding the database, or the query in question isn't a valid SQL query. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: 2 OnRequestEnd files
Thank you, Barney! I knew it was something so plain and simple. Right before my eyes and I did not see it, my wife would roll her eyes if she knew. Thanks again. Doug Barney Boisvert wrote: Do you have a cfinclude template=../OnRequestEnd.cfm / in your approot's OnRequestEnd.cfm to chain them together? OnRequestEnd.cfm should only be processed for the directory that contains Application.cfm.There isn't a directory tree parse for OnRequestEnd.cfm, it uses the one that was performed for Application.cfm. -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:33 PM To: CF-Talk Subject: 2 OnRequestEnd files Hello all, I have an application residing in a subdirectory of my web root. Inside the application subdirectory I have my Application.cfm and OnRequestEnd.cfm files; my web root contains both files as well. As far as I can tell the webroot/Application.cfm is not processed (as I expect). But the webroot/OnRequestEnd.cfm is processed then my application/OnRequestEnd.cfm is processed, I thought that CFMX was only supposed to process my application/OnRequestEnd.cfm and then stop. Processing steps (as I can determine) 1. application/Application.cfm 2. application code 3. webroot/OnRequestEnd.cfm 4. application/OnRequestEnd.cfm Can someone please explain this to me or am I overlooking something plain and simple? Thanks! Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 Sent: Monday, May 17, 2004 4:19 P To: CF-Talk Subject: RE: Weird CFHTTP Error I can't say for sure, but it looks like your Error handler is throwing an error. -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:58 P To: CF-Talk Subject: RE: Weird CFHTTP Error This is in the exception log if it helps anyone answer the question. at coldfusion.tagext.sql.QueryTag.doStartTag(Unknown Source) at cfIRBGetHistory2ecfm1907956765._factor0(I:\CFusionMX\CustomTags\Interface\IR BGetHistory.cfm:22) at cfIRBGetHistory2ecfm1907956765.runPage(I:\CFusionMX\CustomTags\Interface\IRB GetHistory.cfm:272) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. at coldfusion.runtime.DotResolver.resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolve(Unknown Source) at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(Unknown Source) at cfDatabaseException2ecfm813111904.runPage(I:\CFusionMX\wwwroot\WEB-INF\excep tion\coldfusion\runtime\DatabaseException.cfm:13) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.CfincludeFilter.include(Unknown Source) at coldfusion.filter.ExceptionFilter.runBuiltInHandler(Unknown Source) at coldfusion.filter.ExceptionFilter.handleException(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Jeff -Original Message- From: Jeff Waris [mailto:[EMAIL
RE: 2 OnRequestEnd files
check out http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/appfra11.htm Doug -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:33 PM To: CF-Talk Subject: 2 OnRequestEnd files Hello all, I have an application residing in a subdirectory of my web root. Inside the application subdirectory I have my Application.cfm and OnRequestEnd.cfm files; my web root contains both files as well. As far as I can tell the webroot/Application.cfm is not processed (as I expect). But the webroot/OnRequestEnd.cfm is processed then my application/OnRequestEnd.cfm is processed, I thought that CFMX was only supposed to process my application/OnRequestEnd.cfm and then stop. Processing steps (as I can determine) 1. application/Application.cfm 2. application code 3. webroot/OnRequestEnd.cfm 4. application/OnRequestEnd.cfm Can someone please explain this to me or am I overlooking something plain and simple? Thanks! Doug _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird CFHTTP Error....
Sorry, I meant to post more, and hit send accidentally! Looks like: 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Error,jrpp-237,05/17/04,14:28:08,,Element SQL is undefined in ERROR. The specific sequence of files included or processed is: I:\CFusionMX\wwwroot\WEB-INF\exception\coldfusion\runtime\DatabaseException. cfm coldfusion.runtime.UndefinedElementException: Element SQL is undefined in ERROR. Indicates that perhaps your CFERROR page is making a reference to a variable SQL in the ERROR scope, like perhaps: #ERROR.SQL# or something like it. Without code to look at, its hard to say. If that is the case, thats not valid, since in the ERROR scope that variable isn't present. TRY/CATCH the error page (!), and CFMAIL the CFDUMP of the CFERROR to yourself. Robert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to validate form variables with this method including Encoding: multi-part/form-data
Rick, Why are you doing that cflocation to finish processing?Why not do your form processing right then and there on the current template? Not that everyone has to do it this way, but I typically build a form where it submits to itself and, 1)validates 2)processes and 3)proceeds (i.e. [b]thanks for filling out the form.We love you.[/b]. If I had form processing code that needed to be shared with something else (maybe thats why you're doing the cflocation?) I would use an include or a cfmodule call. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Maxing out running requests then server hanging -- Help
We had similar problems that were resolved by reverting the 6.1 database drivers to the 6.0+ version available at the related TechNote (http://www.macromedia.com/support/coldfusion/ts/documents/cfm x61_sqlserver_cpu.htm). Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have luck with those, but we continued to have problems, so we're still on the 6.0+ drivers. Out of curiosity, are you having the same problems with the 3.3 drivers that you were with the 3.2 drivers? What database server are you using? No, it was a different problem. We started getting loads of this message in our log files: removeOnExceptions is true for XXX, closed the physical Connection where XXX is the datasource name defined in the MX Administrator (MX for J2EE for JRun on Solaris with Oracle 8i/9i). After a period of a few hours, the JRun process would send the system load through the roof (95-99% CPU usage) and the only way to stop it was by doing a kill -9 (jrun stop servername would just time out). For our SQL Server clients, we've successfully deployed the MS JDBC drivers in some cases. We're an Oracle shop (8i/9i), so I unfortunately can't test againt SQL Server. All this being said, I haven't had much time to go back and do research into what was causing my problems. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Regular Expression Help
I'm trying to parse a string and pluck a bit of text, but my regex isn't working :( Here's a sample string: (msg:My Message Here; content:My Content Here;) I want to return My Message Here. And here's my regex: refindnocase(msg:[[:print:]]+;, mystring) I'm using print as mystring may contain any printable characters. This returns 0 as the position. Any ideas? Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion installation issue
That is all the page says.Since Admin will not run, the scripts required to complete the install have also not yet run.Consequently CFM pages will not run either The install log shows no errors - all stopped services are restarted as they should be. The install was NOT a standalone but on IIS/JRUN I would recommend that you enable the JRun web server, then finish the installation process using that. Then, run the web server configuration tool, remove the existing configuration, and recreate it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to validate form variables with this method including Encoding: multi-part/form-data
Hi, Robert, and thanks for the reply... It's not so much a matter of validating the encoding type, but including the multi-part/form-data as part of the Form specifications when the form data is passed for processing... I'll give your ideas some thought... Thanks, Rick -Original Message- From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:10 PM To: CF-Talk Subject: RE: How to validate form variables with this method including Encoding: multi-part/form-data I'm not entirely sure why you feel you can't validate that encoding type; the only difference is that it allows UPLOADING.So you can't validate that one field; you can still do the same thing (validate) with all of your other fields. One thing to remember is that with CFFILE, you don't get physical access to the upload, other than the fact that you know info about it (filename, size, etc). So, you could pass that info in a field on to the next page, for example. The fact the cffile handles the upload for you is all you care about; once you have the name of the file, and size (for example), you really don't need anything else at that point. If you need to validate data about the file upload itself, you can do that by doing your compare against the cffile variables (you might wanna only allow certain filetypes for example). I would recommend you working some client side validation into the process.It would save the user some time if the process was never allowed to happen server side at all if they hadn't done everything they needed to submit (e.g. use REQUIRED, or _javascript_). Another thing is that you don't need to do any cflocation either, or use the session scope if after the validation, you just included your data posting, and thus you'd be able to alleviate a hassle (in passing that info around). Robert -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 12:42 P To: CF-Talk Subject: How to validate form variables with this method including Encoding: multi-part/form-data Hi, all... I know the subject is unclear, but here's the situation. I'm using CF 4.5... I validate formfields by submitting a form back to the page containing the form and using CFTRY / CFCATCH, then, if everything passes validation, setting the form variables to session variables and then using CFLOCATION to pass them to an action page for processing. I haven't, to this point, used this method, with a from that contains a file upload field. Typically, with a form that contains a file upload field, I just don't validate the fields. I would, however, like to start validating all form submissions, even those that contain file upload fields. The main question is...how would I pass on the Encoding type: multipart/form-date specification through the form page itself during verification then send that encoding info along with the session variables to the processing page using my typical CFLOCATION URL="" ? Here's the code I've set up so far to validate the form entries... CFIF IsDefined(Form.Submit) CFTRY CFIF Form.Newsletter_Title is CFTHROW Type=AddError Message=Please enter a title for the newsletter. /CFIF CFIF Form.Newsletter_Upload is CFTHROW Type=AddError Message=Please use the Browse button below to locate the newsletter file. /CFIF CFLOCK Scope=Session Type=Exclusive Timeout=10 CFSET Session.Newsletter.Newsletter_Title = Form.Newsletter_Title CFSET Session.Newsletter.Newsletter_Upload = Form.Newsletter_Upload /CFLOCK CFLOCATION URL = "" AddToken=No CFCATCH Type=AddError Error Message... /CFCATCH /CFTRY /CFIF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regular Expression Help
This should work. cfset test = (msg:My Message Here; content:My Content Here;) cfset temp = refindnocase(msg:([^;]*),test,1,yes) cfloop from=1 to=#arraylen(temp.pos)# index=i cfoutput#mid(test,temp.pos[i],temp.len[i])#br/cfoutput /cfloop -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Ian [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:39 PM To: CF-Talk Subject: Regular _expression_ Help I'm trying to parse a string and pluck a bit of text, but my regex isn't working :( Here's a sample string: (msg:My Message Here; content:My Content Here;) I want to return My Message Here. And here's my regex: refindnocase(msg:[[:print:]]+;, mystring) I'm using print as mystring may contain any printable characters. This returns 0 as the position. Any ideas? Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Importing Outlook exports
I am writing a simple contact management app and one specific request is to be able to map files from Outlook export( csv or tab) to our internal data fields. Conceptually, this is very simple, but I running into some nasty Outlook formatting issues. Has anyone successfully done something like this in CF? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to validate form variables with this method including Encoding: multi-part/form-data
Hi, Matt, and thanks for the reply... This was a technique that I read about on this list that someone was using.Since I'm not a _javascript_er it allowed validation without CFFORM or CFINPUT's and not having the user leave the form entry page. The form does submit back to the same page, then runs through the cftry's and then, if everything passes validation, I convert the form variables to session variables and send them via cflocation to an action page for processing.I could have the processing (inserting, updating, etc.) happen on the same page as the validation and then send the user to a Submission Successful page that doesn't process anything, but just let's the user know that everything went through without a problem. That way I could avoid using the session variables, which is not a problem, but more coding, and could also solve the problem of specifying the multipart/form-data specification for the submission, since it would be submitted to the processing page. Sounds like your idea of keeping the processing on the same page as the submission is much simpler... Any other thoughts? Thanks for your help... Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 4:35 PM To: CF-Talk Subject: Re: How to validate form variables with this method including Encoding: multi-part/form-data Rick, Why are you doing that cflocation to finish processing?Why not do your form processing right then and there on the current template? Not that everyone has to do it this way, but I typically build a form where it submits to itself and, 1)validates 2)processes and 3)proceeds (i.e. [b]thanks for filling out the form.We love you.[/b]. If I had form processing code that needed to be shared with something else (maybe thats why you're doing the cflocation?) I would use an include or a cfmodule call. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion installation issue
I know how to do the WSCONFIG but how do I enable the Jrun server? That is all the page says.Since Admin will not run, the scripts required to complete the install have also not yet run.Consequently CFM pages will not run either The install log shows no errors - all stopped services are restarted as they should be. The install was NOT a standalone but on IIS/JRUN I would recommend that you enable the JRun web server, then finish the installation process using that. Then, run the web server configuration tool, remove the existing configuration, and recreate it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DataDirect 3.3 bug with Oracle? (was RE: Maxing out running requests...)
We had similar problems that were resolved by reverting the 6.1 database drivers to the 6.0+ version available at the related TechNote (http://www.macromedia.com/support/coldfusion/ts/documents/cfm x61_sqlserver_cpu.htm). Unfortunately, MM has removed the 6.0+ drivers in that TechNote and replaced the download to point to the new DataDirect 3.3 drivers. Perhaps you'll have luck with those, but we continued to have problems, so we're still on the 6.0+ drivers. Out of curiosity, are you having the same problems with the 3.3 drivers that you were with the 3.2 drivers? What database server are you using? For our SQL Server clients, we've successfully deployed the MS JDBC drivers in some cases. Just as a quick follow-up, I have isolated down the scenario that creates the removeOnExceptions warning. If I use the cftransaction tag around my queries, the warning is thrown. If I don't, no warning appears. Any idea what the issue might be? Is this a bug I need to follow up with Macromedia? As a test with Oracle 8i/9i: cftransaction action=""> cfquery name=get datasource=myDSN SELECT sysdate FROM dual /cfquery cfquery name=get2 datasource=myDSN SELECT sysdate FROM dual /cfquery /cftransaction cfdump var=#get# expand=Yes / cfdump var=#get2# expand=Yes / This will throw the following warning to my log file: removeOnExceptions is true for myDSN, closed the physical Connection If I comment out the cftransaction tags, nothing is thrown. As I said, over time and under load this eventually brings the instance to a grind. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion installation issue
I know how to do the WSCONFIG but how do I enable the Jrun server? http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]