log file in cflogin
Hi, I am trying to pass an entry into log file while authentication the user. I am using cflogin tag for this But only few times it records the entry. My code in application.cfm is like this, cfapplication name=appname setclientcookies=yes cflock scope=application timeout=10 type=exclusive cfset application.physicalPath = C:\CFusionMX\wwwroot\test\ cfset application.url = ""> /cflock cfif IsDefined(action) and action EQ logout cflogout cfset message = You have logged out /cfif cflogin cfif NOT IsDefined(cflogin) cfinclude template=login.cfm cfabort cfelse cfif cflogin.name IS OR cflogin.password IS cfset message = There was a problem with either your Login Name or Password.brPlease try again cfinclude template=login.cfm cfabort cfelse cfquery name=getlogin datasource=test SELECT login, admin , sor FROM members WHERE login = '#cflogin.name#' AND password = '#cflogin.password#' /cfquery cfif #getlogin.RecordCount# GT 0 CFQUERY NAME=putlog DATASOURCE=test INSERT INTO log (login, tdate, ttime, type, referrer, ip, partno) VALUES ('#getlogin.login#', '#dateformat(now())#', '#timeformat(now())#', 'L', '#HTTP_REFERER#', '#REMOTE_ADDR#', ' ') /CFQUERY cfif getlogin.admin EQ Y cfset userRoles = user,admin cfelse cfset userRoles = user /cfif cfloginuser name=#cflogin.name# password=#cflogin.password# roles=#userRoles#/ cfelse cfinclude template=login.cfm cfabort /cfif /cfif /cfif /cflogin Thanks in advance [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Entire keyboard-based CF application
Ugh? Why ugh? .. it doesn't bite ... Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
100% CPU
Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
hi jrun.xml Jrun.xml file can be found in Jrun\server\server_instance_name\server-inf\jrun.xml in the SchedulerService section overwrite this code service class=jrunx.scheduler.SchedulerService name=SchedulerService attribute name=bindToJNDItrue/attribute attribute name=activeHandlerThreads25/attribute attribute name=maxHandlerThreads1000/attribute attribute name=minHandlerThreads20/attribute attribute name=threadWaitTimeout180/attribute attribute name=timeout600/attribute /service [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: redirect after cfheader/cfcontent
CFDEV wrote: I have a code on a page that pop up a save/open for downloading a page : cfheader name=Content-Disposition value=attachment;filename=#getfilefrompath(cas.fichier)# cfcontent file=#nom_fichier2# type=application/pdf deletefile=No / And I want to redirect the page to another page after this.. how could I do this? You can not do that in one response. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: redirect after cfheader/cfcontent
And the reason is both tags rewrite the header. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: log file in cflogin
Maybe it is too early for me, but _nowhere_ in your code do I see cffile or cflog. Did you forget to add it? I also noted - cfif #getlogin.RecordCount# GT 0 - in this code you do not need the # marks. On Tue, 31 Aug 2004 02:27:29 -0400, simmyana a [EMAIL PROTECTED] wrote: Hi, I am trying to pass an entry into log file while authentication the user. I am using cflogin tag for this But only few times it records the entry. My code in application.cfm is like this, cfapplication name=appname setclientcookies=yes cflock scope=application timeout=10 type=exclusive -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT - Mac OS X roaming profile problem
Dear all I'm having a great deal of difficulty with a CF5 driven intranet which has worked just fine on PC's and Mac OS9 for two years now.They have introduced some OS X boxes using roaming profiles from an OS X server. It seems that cookie storage (MSIE and Safari) is kept in the profile (rather than the box itself) which in principle is a good thing - but -sometimes- it seems to be delivering up the wrong cookies (ie CFID CFTOKEN), specifically the pair belonging to the previous person to log in to the Server.It seems to all work fine if roaming profiles are disabled, but we are talking about several dozen boxes here and my client would rather not do this for other administrative reasons. As you can imagine, this is a bit of a problem as people are logging in to the Intranet as themselves but being shown as logged in as someone else (with all their site permissions Etc.).If they immediately log out and log in again then they usually are themselves as they have now been given the 'previous person's' cookies which are actually theirs. Some sort of CFLOCATION logout / login-again kludge might alleviate the problem but I don't think would be a true fix as it would all depend on the timing of when people logged in... As far as I can see, this is not a CF problem, rather, an OSX server / roaming profile problem.As a non-mac person myself, does anyone have any suggestions and/or know of any good forums where I might find an answer or a fix? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX server locks up about every 2 weeks.
We have CFMX standard version 6.1 installed and the service seems to be hanging up about every 2 weeks. Once we restart the cf services everything is back to normal. Any ideas of what may causing this? Does this happen to anyone else out there? Could it be conflicting with other software? Hardware configuration? I know the question is a little vague but... Thanks, Dave HTC Disclaimer:The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX server locks up about every 2 weeks.
I assume you've checked/compared all your logs ... *CFAdmin *cfmxroot/runtime/logs *Web Server Anything in those at the time of crashing that raises an eyebrow? Andy Quoting Bosky, Dave [EMAIL PROTECTED]: We have CFMX standard version 6.1 installed and the service seems to be hanging up about every 2 weeks. Once we restart the cf services everything is back to normal. Any ideas of what may causing this? Does this happen to anyone else out there? Could it be conflicting with other software? Hardware configuration? I know the question is a little vague but... Thanks, Dave -- [EMAIL PROTECTED] www.creative-restraint.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Entire keyboard-based CF application
Thanx Jim With XForms I can do that? How? Sorry but WHAT's XForms? On Mon, 30 Aug 2004 19:39:40 -0400, Jim Davis [EMAIL PROTECTED] wrote: In pure HTML you would use the accesskey and tabindex attributes of form elements to allow simplistic keyboard management of forms.I'm not sure what's available in XFORMs yet, but I have to assume it's more advanced. Using script you can take things to the next level.The event bubbling model in IE makes a lot of this stuff insanely simple. I'm not sure sure why you would want to kill mouse applications, but again using the event bubbling model (IE only, I beleive) you can assign all of the mouse action handlers at the body level to return void or somesuch - the event taking place anywhere on the page will bubble up to the body and get handled there. Jim Davis From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 1:23 PM To: CF-Talk Subject: Entire keyboard-based CF application Hi I'm looking for how to develop an entire CF application keyboard-based. Gmail haves funcionalities like that. What's the secret? JS? Any example? How to kill mouse applications??? ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Web service method with an argument of type Base64
Hi! I'm trying to consume a webservice which has a method with a base64 argument, but it's giving an error: Could not perform web service invocation test1 because java.lang.IllegalArgumentException: argument type mismatch This is the web service: cfcomponent cffunction name=test1 returntype=string access=remote output=false cfargument name=ATemp required=true type=binary cfreturn a /cffunction /cfcomponent And this is the test file: cfset WebService = CreateObject(webservice, http://internal_networkl/ws_base64.cfc?wsdl) cfset WebService.test1( ToBase64('a') ) Am I missing something really obvious here ? -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF Admin on JRun Cluster
I like this idea... but I'm not sure how to implement it. When I run the wsconfig, it only shows the cluster under JRun Server, not the individual JRun instance so now I'm back to the same problem as I had using CF Admin through the primary virtual host... Jonathan From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 9:33 PM To: CF-Talk Subject: Re: CF Admin on JRun Cluster We run a separate virtual host on our web servers for each app server. Those vhosts aren't load balanced, SSL-only, and they're access-restricted to specific IPs (the office and my house).So we've got our main vhost and app running at x.x.x.1, and then x.x.x.2-n are the extra vhosts that go to each server directly. I like this setup because I can still access my CF Admin from anywhere with a normal web browser.At the most, I'll need an SSH client to go in an add an allowed IP address to the Apache conf, but that's a 300k download, so hardly an issue. cheers, barneyb On Mon, 30 Aug 2004 20:22:04 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello all... Does anyone have any suggestions/best practices for running the CFMX Administrator when ColdFusion is running as part of a cluster? Obviously if I run it through IIS I never know which of the two servers (instances) I'm making a change to.Can I leave the built-in JRun web server running if I lock it down so it's only accessable at localhost? Thanks, Jonathan -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi vishnu, Thanks for the reply. Just to understand what this does Am I right in thinking this controls the cf scheduler? I'm fairly confident that our load problems are not related to scheduled requests as these occur overnight. Or does the scheduler have other implications? Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: RandRange ain't so Random
Graphing this to indulge morbid curiosity I used the following code and came up with a pretty even distribution after 1,000,000 iterations. cfset Iterations = 100 cfset MaxNumber = 100 cfloop from=1 to=#MaxNumber# index=i cfset Count[i] = 0 /cfloop cfloop from=1 to=#Iterations# index=i cfset temp = randRange(1,MaxNumber) cfset Count[temp] = Count[temp] + 1 /cfloop cfchart chartwidth=600 chartheight=350 format=flash showlegend=no show3d=no scalefrom=0 xaxistitle=Week Of Year yaxistitle=Number of Items cfchartseries type=bar seriescolor=##FF markerstyle=none cfloop from=1 to=#MaxNumber# index=i cfchartdata item=#i# value=#count[i]# /cfloop /cfchartseries /cfchart -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: 23 August 2004 20:42 To: CF-Talk Subject: Re: RandRange ain't so Random Waiting for a phone call, I ran a test pulling a random number between 1 and 26 inclusive 100,000 times, and the distribution across the range was very near even.Here's code: cfset size = 26 / cfset count = ArrayNew(1) / cfloop from=1 to=#size# index=i cfset count[i] = 0 / /cfloop cfloop from=1 to=10 index=i cfset foo = randRange(1, size) / cfset count[foo] = count[foo] + 1 / /cfloop cfoutput Even distribution: cfoutput#10 / size#/cfoutputbr / cfloop from=1 to=#size# index=i #i# - #count[i]#br / /cfloop /cfoutput -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
You would think they would be the same. Try these in ASP and CFMX and tell me if you get the same thing. 140 91 2 245 151 183 41 75 106 55 64 96 I'm running an RC4 function in CF and in ASP and they return the same numbers to change to CHR but when you do that they become different values and breaks the encryption across different languages. Bob What characters are you trying to use? These look to be the same thing . cfoutput#chr(13)##chr(10)#/cfoutput %= chr(13) chr(10) % or %= VBCrLf % VB also has a lot of constants for these Like VBCrLf is the same as Chr(13) Chr(10) VBCR is the same as Chr(13) VBFormFeed is the same as Chr(12) They can be referenced either way. Maybe what you are looking for is already there as a constant? _ From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 4:55 PM To: CF-Talk Subject: CHR in ASP and CFMX When I do a CHR() in ASP and a CHR() in CFMX they come up with 2 different values. Is there any way to match the values up? Bob _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:176427This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=36 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? You can try and get a stack trace to see what's happenning with CF when the problem occurs. http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
You would think they would be the same. Try these in ASP and CFMX and tell me if you get the same thing. 140 91 2 245 151 183 41 75 106 55 64 96 I'm running an RC4 function in CF and in ASP and they return the same numbers to change to CHR but when you do that they become different values and breaks the encryption across different languages. Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Entire keyboard-based CF application
XForms is the replacement for current HTML forms - basically it's a separate W3C standard just for forms to go with XHTML 2.0. Hit www.W3C.org http://www.w3c.org/or google xforms for more information. I believe that that enhanced forms processing in Blackstone (CF 7) is partially XForms-based. Jim Davis _ From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:16 AM To: CF-Talk Subject: Re: Entire keyboard-based CF application Thanx Jim With XForms I can do that? How? Sorry but WHAT's XForms? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Ian, We have seen this behavior as well.When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this fixes the problem.Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfmail
Is there anyway to get cfmail to not include the white space to the left of what is between the tags? For instance, we have some cfmail tags that are indented 2 or 3 tabs in and this results in the content of the email being that way too. Just curious... Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmail
Tangorre, Michael wrote: Is there anyway to get cfmail to not include the white space to the left of what is between the tags? No. (Unless you start messing with cfsavecontent.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmail
Is there anyway to get cfmail to not include the white space to the left of what is between the tags? No. (Unless you start messing with cfsavecontent.) That sucks. :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Hi Ian. We have had this problem as well, on both Windows 2003 and Redhat Linux servers. There doesn't seems to be any logic cause of the problem and therefore no fix. The only way to work around the problem is to restart the server regularly. We have a scheduled task on both Windows and Linux to restart the service once a day, which seems in the most part to have fixed the problem, but it still happens from time to time. Best Regards Andrew. _ From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 10:00 To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 and cisco load balance
We use Cisco load balancing to our web servers, then WebSphere clustering to load balance across our application servers (CFMX running on WebSphere). The Cisco is really invisible to our application - it handles everything in its own hardware/software. I don't have any experience specifically with Cluster Cats. Chris Norloff -- Original Message -- From: Douglas Knudsen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 30 Aug 2004 15:43:02 -0400 Ok, anyone got some pointers for setting this up?I've been googling around and looking at macr for abit.So much is about CF5 and clustercats.ClusterCats still around?Should it be used?Have 2 webservers going to sit them behind one of those fance cisco load balancers. -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web service method with an argument of type Base64
take it one step further and put that in tobinary() Adam H On Tue, 31 Aug 2004 15:18:47 +0300, Neculai Macarie [EMAIL PROTECTED] wrote: Hi! I'm trying to consume a webservice which has a method with a base64 argument, but it's giving an error: Could not perform web service invocation test1 because java.lang.IllegalArgumentException: argument type mismatch This is the web service: cfcomponent cffunction name=test1 returntype=string access=remote output=false cfargument name=ATemp required=true type=binary cfreturn a /cffunction /cfcomponent And this is the test file: cfset WebService = CreateObject(webservice, http://internal_networkl/ws_base64.cfc?wsdl) cfset WebService.test1( ToBase64('a') ) Am I missing something really obvious here ? -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi Mack, You can try and get a stack trace to see what's happenning with CF when the problem occurs. http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Good info - I'll check this out. Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmail
Simply don't indent the content of the email or change the type to HTML. Best Regards Andrew. _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 14:16 To: CF-Talk Subject: cfmail Is there anyway to get cfmail to not include the white space to the left of what is between the tags? For instance, we have some cfmail tags that are indented 2 or 3 tabs in and this results in the content of the email being that way too. Just curious... Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi Andrew, Bill, We've been running ServersAlive for the last couple of years, which has been cycling the service automatically everytime the system slows and like you say, this has worked well as a backup. Trouble is, it was doing this about every 10 minutes when we had our recent problems - not really acceptable! I've been doing my sums - 7000 requests per hour is on average 2 requests per second. I guess in real life this could increase to say 4 requests per second for a few minutes at a time. Maybe this is as much as a single processor can handle? What other loads are people getting out of a single processor machine? Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs.If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect.Create a separate datasource for these, restrict the number of connections and deselect the maintain db connections for that db resource in cf admin. 4.Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve.Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use 127.0.0.1 or any other IP address.use sql.mydomain.com type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request.JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request.Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:11 AM To: CF-Talk Subject: RE: 100% CPU Ian, We have seen this behavior as well.When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this fixes the problem.Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmail
But, if the end user can't accept html emails (i know this is a very small percentage of people these days), then that won't work. Ray At 09:33 AM 8/31/2004, you wrote: Simply don't indent the content of the email or change the type to HTML. Best Regards Andrew. _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 14:16 To: CF-Talk Subject: cfmail Is there anyway to get cfmail to not include the white space to the left of what is between the tags? For instance, we have some cfmail tags that are indented 2 or 3 tabs in and this results in the content of the email being that way too. Just curious... Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
One more I forgot We have noted that the docs say the the simultaneous requests number in CF admin should be roughly 2x the number of procs. While this number works well on a busy cf 5 machine. It seems to be quite low for a cfmx platform. We've increased this number to between 8 and 13 on a dual proc machine and seen significant results. On a single proc machine I would try 6 and see what you get. -Mark -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:21 AM To: CF-Talk Subject: RE: 100% CPU Hi Ian. We have had this problem as well, on both Windows 2003 and Redhat Linux servers. There doesn't seems to be any logic cause of the problem and therefore no fix. The only way to work around the problem is to restart the server regularly. We have a scheduled task on both Windows and Linux to restart the service once a day, which seems in the most part to have fixed the problem, but it still happens from time to time. Best Regards Andrew. _ From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 10:00 To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmail
But, if the end user can't accept html emails (i know this is a very small percentage of people these days), then that won't work. Luckily, I work on our Corp Intrnaet apps where HTML email is a standard and must be enabled for company mail communications internally so I'm in luck :-) Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Great info Mark, Didn;t knwo the ahile don't use IP for database bit. I want to stress on he one Mark almost forgot. At the machine in question's current proc speed I'd say 6 MAX and since you figure 4 max request ever I would lower it to 5. Even if you get 10 requests if the average load time is 1/2 second the longest wait would be about maybe 1 second Adam H -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:21 AM To: CF-Talk Subject: RE: 100% CPU Hi Ian. We have had this problem as well, on both Windows 2003 and Redhat Linux servers. There doesn't seems to be any logic cause of the problem and therefore no fix. The only way to work around the problem is to restart the server regularly. We have a scheduled task on both Windows and Linux to restart the service once a day, which seems in the most part to have fixed the problem, but it still happens from time to time. Best Regards Andrew. _ From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 10:00 To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cftry/cfcatch error handling
Thanks Spike, I got it working now ! Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web service method with an argument of type Base64
take it one step further and put that in tobinary() Adam H Thanks Adam, that worked... kinda. The stream of bytes that is saved is not the same as the one transmitted.I think that the ToBase64 function in ColdFusion is buggy (CFMX 6.1) because I get different strings when calling the base64_encode function from PHP and ToBase64 from ColdFusion. -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
I have found that some chr() in CF give some funcky output for #s 128-160 or so don't know why. Heres a list and the ASCII value and what CF outputs as the ascii value then what chr returns for both numbers: 128 = 8364 : = ¬ 130 = 8218 : = 131 = 402 : = 132 = 8222 : = 133 = 8230 : = ¦ 134 = 8224 : = 135 = 8225 : = ¡ 136 = 710 : = 137 = 8240 : = ° 138 = 352 : = 139 = 8249 : = ¹ 140 = 338 : = 142 = 381 : = ½ 145 = 8216 : ' = ' 146 = 8217 : ' = ' 147 = 8220 : = 148 = 8221 : = 149 = 8226 : = ¢ 150 = 8211 : = 151 = 8212 : = 152 = 732 : = 153 = 8482 : = ¢ 154 = 353 : = ¡ 155 = 8250 : = º 156 = 339 : = 158 = 382 : = ¾ 159 = 376 : = ¸ On Tue, 31 Aug 2004 08:45:36 -0400, Robert Everland III [EMAIL PROTECTED] wrote: You would think they would be the same. Try these in ASP and CFMX and tell me if you get the same thing. 140 91 2 245 151 183 41 75 106 55 64 96 I'm running an RC4 function in CF and in ASP and they return the same numbers to change to CHR but when you do that they become different values and breaks the encryption across different languages. Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the response.I'll work on this list and see if it doesn't help.Here is some responses to a few of your points. 1. On the server in question we don't have any access.Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server.Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either.We just use the server name (sql-server).I'll play with the host file. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs.If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect.Create a separate datasource for these, restrict the number of connections and deselect the maintain db connections for that db resource in cf admin. 4.Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve.Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use 127.0.0.1 or any other IP address.use sql.mydomain.com type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request.JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request.Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:11 AM To: CF-Talk Subject: RE: 100% CPU Ian, We have seen this behavior as well.When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this fixes the problem.Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM.The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no
RE: 100% CPU
We have noted that the docs say the the simultaneous requests number in CF admin should be roughly 2x the number of procs. While this number works well on a busy cf 5 machine. It seems to be quite low for a cfmx platform. We've increased this number to between 8 and 13 on a dual proc machine and seen significant results. On a single proc machine I would try 6 and see what you get. Unfortunately, finding the optimal value for this parameter really requires load testing. I do agree that the optimal value for CFMX is usually higher than it was for CF 5, based on the load tests I've seen. 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] [Donations and Support]
RE: 100% CPU
Thanks for the response.I'll work on this list and see if it doesn't help.Here is some responses to a few of your points. 1. On the server in question we don't have any access.Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server.Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either.We just use the server name (sql-server).I'll play with the host file. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs.If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect.Create a separate datasource for these, restrict the number of connections and deselect the maintain db connections for that db resource in cf admin. 4.Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve.Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use 127.0.0.1 or any other IP address.use sql.mydomain.com type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request.JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request.Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT - Mac OS X roaming profile problem
I'm having a great deal of difficulty with a CF5 driven intranet which has worked just fine on PC's and Mac OS9 for two years now.They have introduced some OS X boxes using roaming profiles from an OS X server. It seems that cookie storage (MSIE and Safari) is kept in the profile (rather than the box itself) which in principle is a good thing - but -sometimes- it seems to be delivering up the wrong cookies (ie CFID CFTOKEN), specifically the pair belonging to the previous person to log in to the Server.It seems to all work fine if roaming profiles are disabled, but we are talking about several dozen boxes here and my client would rather not do this for other administrative reasons. ... As far as I can see, this is not a CF problem, rather, an OSX server / roaming profile problem.As a non-mac person myself, does anyone have any suggestions and/or know of any good forums where I might find an answer or a fix? I don't know anything about OS X roaming profiles, but from a CF perspective you should be able to fix the problem by using URL tokens instead of cookies, if you can't resolve the problem from the other end. 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] [Donations and Support]
RE: CF Admin on JRun Cluster
I like this idea... but I'm not sure how to implement it. When I run the wsconfig, it only shows the cluster under JRun Server, not the individual JRun instance so now I'm back to the same problem as I had using CF Admin through the primary virtual host... You can either configure each instance to connect to a specific virtual server before creating the cluster, or you can enable the built-in web server solely to run the CF Admin for each CFMX instance. I generally prefer the latter. Can I leave the built-in JRun web server running if I lock it down so it's only accessable at localhost? Yes, you can, although this will cause some occasional odd problems by default, as the IIS web server root will be in one place while the CFMX web server root will be somewhere else. You might want to edit the CFMX web server root so that it points to the right place, while ensuring that the CFIDE directory is only available through the CFMX web server. 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] [Donations and Support]
RE: redirect after cfheader/cfcontent
And the reason is both tags rewrite the header. Well, not exactly. You can use multiple tags that rewrite the header in the same page, as long as those tags don't tell the browser to do two things at once that can't be done in one request. For example, you can use CFCOOKIE and CFLOCATION in CFMX within the same page request, because you can use Set-Cookie and Location headers simultaneously within a single HTTP response. 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] [Donations and Support]
Re: Web service method with an argument of type Base64
humm well you could always use java. and bypass the base64 and see if that solves it. cfset stuff = a cfset WebService.test1(stuff.getbytes()) Adam On Tue, 31 Aug 2004 17:20:18 +0300, Neculai Macarie [EMAIL PROTECTED] wrote: take it one step further and put that in tobinary() Adam H Thanks Adam, that worked... kinda. The stream of bytes that is saved is not the same as the one transmitted.I think that the ToBase64 function in ColdFusion is buggy (CFMX 6.1) because I get different strings when calling the base64_encode function from PHP and ToBase64 from ColdFusion. -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: redirect after cfheader/cfcontent
Ahh thanks Matt -- I'd forgotten about that -- yea, some folks use cfheader themselves to accomplish the redirect, which is similar to using cflocation. The difference is that with a cfheader tag (I think it's status with a value of 302 but that's not really my forte) won't also terminate the request, so the request would then continue on to deliver the file in theory. Though I don't personally know if the cfcontent tag will also change the status header that's required for the relocation or if there might be other complications owing to the standard or implementation of HTTP, since the cflocation tag officially creates a these aren't the files you're looking for message and sends the browser on to another place to get them -- so the webserver and/or browser may (or may not) interpret the cfcontent'ed file as being not the file you're looking for and not download the file. When you use CFCONTENT to deliver a file, it doesn't set a Location header. It simply delivers the content specified by the tag. 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] [Donations and Support]
Re: Web service method with an argument of type Base64
humm well you could always use java. and bypass the base64 and see if that solves it. cfset stuff = a cfset WebService.test1(stuff.getbytes()) Adam Unfortunately it doens't help. Seems that I will have to report this as a bug and write my own toBase64 function. -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web service method with an argument of type Base64
You sure its not a problem on the other side? I use the getbytes function regularly as well as other function that return btye arrays like Gzip. This infommation is used with external applications and Amazon. If it was buggy I wouldn't imagine it would be working. Adam H On Tue, 31 Aug 2004 17:50:31 +0300, Neculai Macarie [EMAIL PROTECTED] wrote: humm well you could always use java. and bypass the base64 and see if that solves it. cfset stuff = a cfset WebService.test1(stuff.getbytes()) Adam Unfortunately it doens't help. Seems that I will have to report this as a bug and write my own toBase64 function. -- mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFQUERYPARAM in CFSET
This may not be possible but... Doesn anyone know of a way to get this or something similar to work? cfset strSQL = select ColumnName from TableName where ColumnName=cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Variable# cfquery #preserveSingleQuotes(strSQL)# /cfquery Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFX_Image oddity
on a side note how can you tell the file size of the image before uploading to the server. With the caveat that this will only work on Windows Clients and the client must agree to an ActiveX install: script language=_javascript_ function A() { var oas = new ActiveXObject(Scripting.FileSystemObject); var d = document.a.b.value; var e = oas.getFile(d); var f = e.size; alert(f + bytes); } /script /head body form name=a input type=file name=b input type=button name=c value=SIZE > /form Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716 tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Bill, FYI In regard to point 9 below. When you use a regular server name instead of a FLQN name you cause the JDBC server system to do the following: First it uses the unc service... check the host file for that string to resolve (no dice) check dns (also no dice) .move to rnc service (windows locator - basically a handoff to windows) check lmhosts file (if enabled and configured to do so)... check active directory created flqn on the nearest dc if you are on a domain ([EMAIL PROTECTED]) check Active dir on the master domain controller if nearest dc fails.. try to resolve the name using windows locator broadcasting It's a lot of hoops just for a friendlier naming scheme.Mostly, you just don't want windows to have to do this work for you. Windows networking is more dns based, but it still has a locator service with a fairly complicated heirarchy of resolution attempts. Instead, you want the JDBC service to bypass the application layer and get that name resolved prior to it arriving at the windows locator service. Simply ask yourself - how is the server going to resolve this name. Mark Minasi's mastering windows server 200x books have some great information on how windows goes about this process. Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:34 AM To: CF-Talk Subject: RE: 100% CPU Thanks for the response.I'll work on this list and see if it doesn't help.Here is some responses to a few of your points. 1. On the server in question we don't have any access.Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server.Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either.We just use the server name (sql-server).I'll play with the host file. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: galleon
Ray, It wouldn't be that hard to add a switch in the application settings that would indicate the Db being used.In the places where last id is need, just put in a switch/case block for the DB specific query to get last id.I use MySQL a whole ton and I'm willing to go through and supply code to get the last id. .Peter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Credit card page processing before error check
Ok Without reading that whole page. How are you running these _javascript_s? On form submit or with a button's onclick event? If you are running them onsubmit you are not returning false from what I could gather [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Second Pair Of Eyes
Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFQuery
I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Second Pair Of Eyes
in CF5 arguments is an array: try: IsDefined(FORM.#ARGUMENTS[1]#) I think that will work on MX too. HTH Bert - Original Message - From: Adrian Lynch [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 16:22:29 +0100 Subject: Second Pair Of Eyes To: CF-Talk [EMAIL PROTECTED] Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Second Pair Of Eyes
You don't need the #'s inthe isDefined - just the FORM.whatever variable. I don't have a means to test this right now, but this jumped out at me. Rau At 11:22 AM 8/31/2004, you wrote: Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Credit card page processing before error check
I'm running it from ... input type=Submit value=Submit Order > Ok Without reading that whole page. How are you running these _javascript_s? On form submit or with a button's onclick event? If you are running them onsubmit you are not returning false from what I could gather [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Second Pair Of Eyes
Have you tried usinge structkeyexits() instead of isDefined() - Original Message - From: Adrian Lynch [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 16:22:29 +0100 Subject: Second Pair Of Eyes To: CF-Talk [EMAIL PROTECTED] Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
This works on CF5 cfset form.test = david cfscript function formValue(formName, defaultValue) { if (structKeyExists(FORM, formName) ) { return HTMLEditFormat(FORM[formName]); } else { return HTMLEditFormat(defaultValue); } } /cfscript cfdump var=#formValue(test,jimmy)#br / cfdump var=#formValue(test2,jimmy)# Arguments is an array rather than a structure -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
Thanks Rau, the # are to evaluate ARGUMENTS.formName so it becomes IsDefined(FORM.aNamePassedIn). Thanks Bert, I thought it might be something like that. Cheers Ade -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 16:31 To: CF-Talk Subject: Re: Second Pair Of Eyes You don't need the #'s inthe isDefined - just the FORM.whatever variable. I don't have a means to test this right now, but this jumped out at me. Rau At 11:22 AM 8/31/2004, you wrote: Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - Mac OS X roaming profile problem
Dave I'm not sure this would work because it is on 'the first hit' when the wrong CFID CFTOKEN are being issued, (or actually probably when the browser is opened), and there's no way of knowing what the right ones are.I don't believe my setup is unusual in that I have the variable client.loggedin, person A logs in correctly against a match in the DB and client.loggedin is set to true.Person B goes to the site shortly after on a different box and somehow gets given the same CFID CFTOKEN (I think by the roaming profile thing) so comes in directly as client.loggedin=true as person A. Unfortunately I can't test it here on my dev setup as I've only got one mac (which works perfectly - of course..), but I got all the OSX users to wipe their cookies on the live intranet so virgin CFID CFTOKEN's would be issued by CF, but it still happens. I haven't tried emptying the CDATA and CGLOBAL tables (they're not very big) but I suspect this wouldn't fix it either. Dave Watts wrote: I'm having a great deal of difficulty with a CF5 driven intranet which has worked just fine on PC's and Mac OS9 for two years now.They have introduced some OS X boxes using roaming profiles from an OS X server. It seems that cookie storage (MSIE and Safari) is kept in the profile (rather than the box itself) which in principle is a good thing - but -sometimes- it seems to be delivering up the wrong cookies (ie CFID CFTOKEN), specifically the pair belonging to the previous person to log in to the Server.It seems to all work fine if roaming profiles are disabled, but we are talking about several dozen boxes here and my client would rather not do this for other administrative reasons. ... As far as I can see, this is not a CF problem, rather, an OSX server / roaming profile problem.As a non-mac person myself, does anyone have any suggestions and/or know of any good forums where I might find an answer or a fix? I don't know anything about OS X roaming profiles, but from a CF perspective you should be able to fix the problem by using URL tokens instead of cookies, if you can't resolve the problem from the other end. 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] [Donations and Support]
Re: CFQUERYPARAM in CFSET
This may not be possible but... Doesn anyone know of a way to get this or something similar to work? cfset strSQL = select ColumnName from TableName where ColumnName=cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Variable# cfquery #preserveSingleQuotes(strSQL)# /cfquery No, unfortunately there's no way to store a queryparam in a string -- I'm sure largely because a query that uses cfqueryparam actually places the queryparam information as two separate strings in different locations in the sql syntax... imo uses of preservesinglequotes are also usually a bad idea... The ontap framework has a fairly involved API for generating most common query syntax and allows you to build joins and where clauses prior to executing the qeury, but the query itself is executed in a handful of custom tags which manage the cfquery tag for you. This or something like it would allow you to pre-build the sql syntax, and at the same time continue to use cfqueryparam as the tags which call the cfquery tag ensure its use. Some examples of my own code: // create a local pointer to the sql library sql = request.tapi.sql; // get all columns from a single record in a table rsUser = sql.select(*,usertable, ,sql.filter(userid,variables.userid)); // get two columns from all records in a table rsOptions = sql.select(optlabel,optvalue,optiontable); // delete a single record from a table sql.delete(fromtable, sql.filter(tableid,variables.filterid)); // update the user table with data from the form scope sql.update(usertable,form); s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: redirect after cfheader/cfcontent
Dave Watts wrote: When you use CFCONTENT to deliver a file, it doesn't set a Location header. It simply delivers the content specified by the tag. I've been meaning to ask for awhile, but how much overhead does CFCONTENT create if you are serving a 1MB file? Howabout a 10MB file? Does the CF server actually handle the file, or does it just provide a pointer to the local file? Tyler --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 8/19/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
database connections
Here is the deal. I have CFMX on my laptop with dev apps that connect to the mssql server. I use an app that hits 3 different data sources which would create 3 processes on the sql server. Lets say I shut down and restart my laptop and run the app again. I now have 6 processes running on the sql server. In CF Admin I have maintain connections checked. If I uncheck it, will that help or fix the problem? Also, is there a way to time out connections on the sql server? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Second Pair Of Eyes
He does if the the form element he's looking for is named by an argument in his function, i.e. getFormElement(myform) - if this function does anything with the value of form.myform, then he does need the #'s. Although I tend to use structkeyexists() for this. In which case there wouldn't be #'s... structkeyexists(form,arguments[1]) -- although in CF5 it does have to be a number, since it's an array, not an object which sometimes but not always behaves like a structure and an array. This was a peeve with MX for me -- it actually eliminated some functionality that had existed before. You don't need the #'s inthe isDefined - just the FORM.whatever variable. I don't have a means to test this right now, but this jumped out at me. Rau At 11:22 AM 8/31/2004, you wrote: Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.fo rmName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
It also works fine on MX. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 16:46 To: CF-Talk Subject: RE: Second Pair Of Eyes This works on CF5 cfset form.test = david cfscript function formValue(formName, defaultValue) { if (structKeyExists(FORM, formName) ) { return HTMLEditFormat(FORM[formName]); } else { return HTMLEditFormat(defaultValue); } } /cfscript cfdump var=#formValue(test,jimmy)#br / cfdump var=#formValue(test2,jimmy)# Arguments is an array rather than a structure -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
Adam Haskell wrote: I have found that some chr() in CF give some funcky output for #s 128-160 or so don't know why. Probably because they are illegal characters in the charset you are using. Heres a list and the ASCII value and what CF outputs as the ascii value then what chr returns for both numbers: 128 = 8364 : = ¬ This is not ASCII but probably some braindead Microsoft charset. ASCII is much older as the euro sign, so it is impossible that the euro sign is in ASCII. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Recommendations for a good site monitoring service?
Thanks everyone. I'll have some fun this weekend breaking the server to see what happens. :-] - Original Message - From: Matt Robertson [EMAIL PROTECTED] Date: Mon, 30 Aug 2004 17:00:20 -0700 Subject: Re: Recommendations for a good site monitoring service? To: CF-Talk [EMAIL PROTECTED] Sitepeeker's license begins and ends with: Use and distribute freely. No warranties express or implied.Althought I think I'll redo that to the Lesser GNU if I get around to it.The code is unencrypted. The intrafoundation stuff looks pretty neat.Add that to SP or the code of your choice and you can pretty much do anything, and all it'd cost you is a hosting account or a wee bit of space on your broadband-connected hard drive. It was just pointed out to me that the activityreport.cfm in the admin area -- which is a GridMonger config file -- is out of date.The GridMonger specification isn't tough to follow and anyone can download the thing and figure it out in 20 minutes or so, but I still need to get out an update to cover that.Should have a revised file set tomorrow or the next day. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT : Keeping JS Count
How do those websites like Dell keep track of price.. IE Say you have 2 radio inputs one with a value of 0, the other with a value of 1. And you have five of these.. a_1 = 0 a_2 = 1 a_3 = 0 a_4 = 0 a_5 = 1 how would you keep track of the totals? Initially you could just do a sum of the values but what if the user changed an option? it wouldnt subtract the 1? Any ideas would be appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
Robert Everland III wrote: When I do a CHR() in ASP and a CHR() in CFMX they come up with 2 different values. Is there any way to match the values up? Use the same charset in ASP and CF MX. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk [EMAIL PROTECTED] I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Email Download link
I have emails going out with a link in them that points to a page that serves the documents via cfheader/cfcontent. When the link is clicked the standard open/save/cancel box appears. When I click open, the window closes and the document opens. If I click cancel, same thing. If I click save and save the document, the underlying window will not close. Any ideas on how to get this to close? Email Link Clicking the Link opens the serveDocument.cfm page. Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT : Keeping JS Count
i would do a full total count on every refresh so you never need to subtract. remember and do server side validation tho :) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT : Keeping JS Count
I can use an onclick to add the count however you can keep clicking on the radio button to increment it. onchange only takes effect when you click off of something. I suppose I could reverse the values.. give the 1 a value of -1 and the 0 a value of 1. Or is it best to loop through the form fields and get a sum each time something changes? On Tue, 31 Aug 2004 10:56:52 -0500, Greg Morphis [EMAIL PROTECTED] wrote: How do those websites like Dell keep track of price.. IE Say you have 2 radio inputs one with a value of 0, the other with a value of 1. And you have five of these.. a_1 = 0 a_2 = 1 a_3 = 0 a_4 = 0 a_5 = 1 how would you keep track of the totals? Initially you could just do a sum of the values but what if the user changed an option? it wouldnt subtract the 1? Any ideas would be appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT : Keeping JS Count
so you'd loop through the form fields each time? On Tue, 31 Aug 2004 11:14:11 -0500, Greg Morphis [EMAIL PROTECTED] wrote: I can use an onclick to add the count however you can keep clicking on the radio button to increment it. onchange only takes effect when you click off of something. I suppose I could reverse the values.. give the 1 a value of -1 and the 0 a value of 1. Or is it best to loop through the form fields and get a sum each time something changes? On Tue, 31 Aug 2004 10:56:52 -0500, Greg Morphis [EMAIL PROTECTED] wrote: How do those websites like Dell keep track of price.. IE Say you have 2 radio inputs one with a value of 0, the other with a value of 1. And you have five of these.. a_1 = 0 a_2 = 1 a_3 = 0 a_4 = 0 a_5 = 1 how would you keep track of the totals? Initially you could just do a sum of the values but what if the user changed an option? it wouldnt subtract the 1? Any ideas would be appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Template Encryption
I need to distribute source code to clients and want to encrypt some of the source. I know utilities exist to break ColdFusion encryption and display source code. Are there any methods to encrypt ColdFusion source that are not breakable using these utilities or other methods (within reason)? I am running ColdFusion 5 for this project. Josen Ruiseco GoMotorBids.com Thanks to everyone for the help... Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT : Keeping JS Count
If you want the price displayed on the page and updated every time a new option is selected w/o the page being reloaded you need to use _javascript_, otherwise i would imagine the radio button's value would be associated with a price from the database. (optionid 12 = $50) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP and replace() on Multiple Lines
I am calling a document via cfhttp. I am replacing numerous lines of text within the called document. There is a snippet in the document that I cannot seem to grab: td width=1 /td Spacing is as it is in the doc... I can grab the td width=1 with no problem. But I cannot grab the /td because I will screw up the entire document. I tried control characters to get the whole thing - chr(), etc. (replace(document,td width=1#chr(13)#.../td, )) but it seems that I could not grab them that way. Any ideas? Regards, Josen GoMotorBids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: regexp help
:) well that regex didn't produce a match unfortunately.. however i was just looking at this thinking man this is screwey.. maybe the \r isnt required for some odd reason. so i revised the regex to read: ([[:alnum:]]+)\r?\s*([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+) and got a match! but it was on: item1 0344437 1 03/12/2004 USD 335.75 so the next important thing is to add a space to the :alnum: list and bam! i got the full match. so with the regex revised to: ([[:alnum:] ]+)\r?\s*([0-9]+)[ ]+([0-9]+)[ ]+([^ ]+)[ ]+([A-Z]{3})[ ]+([0-9.]+) i get the match i needed wich is: description of some item1 0344437 1 03/12/2004 USD 335.75 its still not quite perfect, but hey, its matching thats the important part!! Thanks for your help!! -chris heh after talk'n out of my but this should work for you ([[:alnum:] ]+)\r \s*([0-9]{7})\s*([0-9]+)\s*([0-3][0-9]/[0-1][0-9]/[0-9]{4})\s*([A-Z]{2, 3})\s*([0-9]+\.[0-9]{2}) You have to add some of your own business logic to not parse the this is just a confirmation email emails. I do not know all the codes that you are using with the USD codes so I left it like this: [A-Z]{2,3} I just hope that I have helped somewhere. Ian - Original Message - From: chris porter [EMAIL PROTECTED] Date: Mon, 30 Aug 2004 21:40:53 -0400 Subject: Re: regexp help To: CF-Talk [EMAIL PROTECTED] that was an option i explored, however these emails arent coming from just one source, in fact there are hundreds of different company emails coming in, so my options were, either 1) define the data i need, and specify a regex to grab it, then database the expressions, or 2) write a custom script in code that can identify each one of those possibly by regex. personally i opted for option a cause i can always fine tune an _expression_, but changing code gets tedious. on another note, what distinguishes the item description line during a line by line scan from something like this is just a confirmation email. get my drift? -chris I understand that, what I meant was, wouldn't it be easier to parse each line separately? This way you do not need to have such a highly complicated RegEx. You can make it much more simple and a little bit more flexible. Not to mention easier to maintain. (i.e. two separate regular expressions or more) cfscript email = emailFromServer; // focused down to the body content only n = listlen(email,chr(13) chr(32)); output = arraynew(1); output[1] = structnew(); a = arraynew(2); a[1][1] = RegEx; a[1][2] = description; a[2][1] = RegEx; a[2][2] = productnumber; nn = arraylen(a); // regex count nnn = 1; // record count c = 0; // field count for (i=1:i LTE n;i=i+1) { currentitem = listgetat(email,i,chr(13) chr(32)); for (ii=1;ii LTE nn;ii=ii+1) { if (refind(a[i][1],currentitem)) { output[nnn]['#a[i][2]#'] = trim(currentitem); if (c GT 5) { c = 0; nnn = nnn + 1; output[nnn] = structnew(); } else { c = c +1; } } } } /cfscript heh I went a little crazy here but I pretty sure this would work. Any future changes on what each feild would hold would be easy to change. (beware I did not test it) Ian - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] Date: Mon, 30 Aug 2004 18:23:04 -0400 Subject: RE: regexp help To: CF-Talk [EMAIL PROTECTED] You can get the first and second lines based on a new line delimited list and you can get the items in the second line using a space delimited list. I just like to be specific when parsing data from a source like email. My preference is to pop 2 messages, save the first in a DB (raw) and use the second as a flag to rerun the page. Once all the mail is down and stored in the DB (one at a time, there's a reason), I have a second process parse each message in the tightest way possible. I'm paranoid (as all programmers should be) about data from outside sources and I want to be 100% sure of what I'm getting and how. If there's a problem, then I want to know exactly what's up. _ Why don;t you just go through the text as a list with CR as the delimiter? This way you can have much more focused regular expressions. Just a thought, Ian - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] Date: Mon, 30 Aug 2004 16:49:48 -0400 Subject: RE: regexp help To: CF-Talk [EMAIL PROTECTED] Really fast (Using the multi-line move of CFMX) ^([^#ch r(13)#]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]+)[[:space:]]+([0-9]{2 }/[0-9]{2}/[0-9]{4})[[:space:]]+(USD)?[[:space:]]*([0-9.]+)$ _ From: chris porter [mailto:[EMAIL PROTECTED]
Re: cfmail
you could use html emails, too [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT : Keeping JS Count
Yeah, count from zero by looping thro the form and totalling every time that there is an onclick.Then just write that total out in the apprpriate place. Means that you don't need to bother about keeping track of the state of the form, means that you are only worried about the current state of the form when the click happens (as long as that fits into your application) You'd pretty much worked that out in your second email :) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT : Keeping JS Count
this is what I have function showValues(theForm) { currVal = document.getElementById(ptotal); sum = 0; for(i=0;itheForm.elements.length - 1;i++) { sum +=parseInt(theForm.elements[i].value); } alert(sum); } Unfortunately the radios have a value of 0 and a value of 1. So this adds up 0 + 1 per radio and returns 1. How do I make it add up only whats selected, not both values? Maybe a radio isnt the right way of doing this? I'm open to any suggestions. On Tue, 31 Aug 2004 12:27:23 -0400, joe velez [EMAIL PROTECTED] wrote: If you want the price displayed on the page and updated every time a new option is selected w/o the page being reloaded you need to use _javascript_, otherwise i would imagine the radio button's value would be associated with a price from the database. (optionid 12 = $50) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP and replace() on Multiple Lines
it appears that there are more than 1 carriage returns in your document, and you're only trying to replace 1.. actually only: td /td when maybe you should be replacing td#chr(13)##chr(13)##chr(13)#/td for td /td how bout instead of chr(13) just use a physical cr ... line = replace(document, ' ', '', 'ALL')# you could also run the above through the whole document. this would essentially out all the html on 1 line, then go through and replace close tags with a close tag and a line feed. i think you could also use mid or a regex to get the data between td and /td and trim it. just some ideas. joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP and replace() on Multiple Lines
Where a single search doesn't work, I usually revert to finding the start index 'start = find(td width=1, myStr)' and then the end index 'end = find(/td, myStr, start) + 4' and then do a mid(myStr, start, end) call to pull it out.You may have to tweak that a little, but that's the idea. cheers, barneyb On Tue, 31 Aug 2004 12:27:46 -0400, Josen Ruiseco [EMAIL PROTECTED] wrote: I am calling a document via cfhttp. I am replacing numerous lines of text within the called document. There is a snippet in the document that I cannot seem to grab: td width=1 /td Spacing is as it is in the doc... I can grab the td width=1 with no problem. But I cannot grab the /td because I will screw up the entire document. I tried control characters to get the whole thing - chr(), etc. (replace(document,td width=1#chr(13)#.../td, )) but it seems that I could not grab them that way. Any ideas? Regards, Josen GoMotorBids.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
Now that you mention that I remeber why I knew about this in the first place. Our content team made pages that used the trade mark symbol using windows they made it into the HTML version 153 which works great in IE, not so much in other browsers. I had to write a function that converted a bunch of them. Can't beleive I forgot about that Adam On Tue, 31 Aug 2004 17:53:59 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: This is not ASCII but probably some braindead Microsoft charset. ASCII is much older as the euro sign, so it is impossible that the euro sign is in ASCII. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT : Keeping JS Count
I did away with the damn radios and went with select boxes.. that solved the headache! thanks! On Tue, 31 Aug 2004 17:39:51 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yeah, count from zero by looping thro the form and totalling every time that there is an onclick.Then just write that total out in the apprpriate place. Means that you don't need to bother about keeping track of the state of the form, means that you are only worried about the current state of the form when the click happens (as long as that fits into your application) You'd pretty much worked that out in your second email :) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ADD System?
Thanks for the replies, guys, but I know about as much as you do about the platform, etc.The company won't give out details about the system to ppl like me who are trying to 'steal their business'.I know that the DB is Sybase from the little that I could get. From meeting with the company and them showing me the system, it is a command line interface (some sort of unix flavor, I think), with 'modules' that are GUI. The sheer size and the things that this system can do and does would make it a yearlong project for us to recode, and I KNOW that the Oil company would not pay for that.It wouldn't be impossible, and actually would be pretty cool, but you know how clients are, and I ain't taking this on pro-bono.It also doesn't help that almost all (they claim) oil companies use this as an 'industry standard'.They aren't going anywhere soon http://www.addsys.com/ is the company's site. But, all this is neither here nor there at this point, as we had a meeting with them today, and they are purchasing a version upgrade which will let them do exactly what I need.Right now they have a way of exporting print reports based on what they want output (customer account, del'y address, next del'y date, last pmt amount, etc etc), but not in any form that I can use, as the data is all over the place.The 'version upgrade' addresses this issue and more, so once that is purchased, I will be fine. Thanks for all your help though guys.I owe everyone on this list a beer if I ever get to one of these conferences! Ray At 09:36 PM 8/27/2004, you wrote: Yeah, me too! I googled the only thing close I found was a dead link for: http://www.addsys.com/ If this app is priced like I think it is, they could pay someone (Ray) to completely recode the app in CF, buy the box and CF for less than ADD annual maintenance costs. And the client would own the code and not be held ransom by some company that's gonna' proprietary price itself right outta' business Maybe this could be the first annual CF is better application hacking contest. Dick On Aug 27, 2004, at 6:18 PM, Eric Dawson wrote: Well you got me curious. can you send more information on the system, platforms, websites etc Do they have any addon reporting or analysis packages? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mail in Undeliverable Folder
Due to an IP change on our server and an application that didn't get updated I have quite a number of emails in the undeliverable folder that I would like to send out.Has anyone converted these and drop them in the spool so they get sent? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
In cf5, arguments is an array. Just use formName and defaultValue without a prefix (or arguments[1] and arguments[2]). Pascal -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 17:22 To: CF-Talk Subject: [Spam?] Second Pair Of Eyes Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mail in Undeliverable Folder
iff all you need to do is change the IP just doa search and replace on the folder for the IP and move them back to the spool folder. ADam H On Tue, 31 Aug 2004 11:42:05 -0500, B G [EMAIL PROTECTED] wrote: Due to an IP change on our server and an application that didn't get updated I have quite a number of emails in the undeliverable folder that I would like to send out.Has anyone converted these and drop them in the spool so they get sent? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT : Keeping JS Count
IS this what you want?? function showValues(theForm) { var currVal = document.getElementById(ptotal); var sum = 0; for(var i=0;itheForm.elements.length;i++) { if(theForm.elements[i].checked) sum +=parseInt(theForm.elements[i].value); } alert(sum); } Pascal -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 18:34 To: CF-Talk Subject: Re: SOT : Keeping JS Count this is what I have function showValues(theForm) { currVal = document.getElementById(ptotal); sum = 0; for(i=0;itheForm.elements.length - 1;i++) { sum +=parseInt(theForm.elements[i].value); } alert(sum); } Unfortunately the radios have a value of 0 and a value of 1. So this adds up 0 + 1 per radio and returns 1. How do I make it add up only whats selected, not both values? Maybe a radio isnt the right way of doing this? I'm open to any suggestions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Reply, not quite, this only works when an error has occurred.I would like to do this even if an error has not occurred. cfquery name=somequery Select * from table /cfquery #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk [EMAIL PROTECTED] I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP and replace() on Multiple Lines
Use regexp? REReplaceNoCase(str,td width=1\s+/td,,all) Pascal -Original Message- From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 18:28 To: CF-Talk Subject: CFHTTP and replace() on Multiple Lines I am calling a document via cfhttp. I am replacing numerous lines of text within the called document. There is a snippet in the document that I cannot seem to grab: td width=1 /td Spacing is as it is in the doc... I can grab the td width=1 with no problem. But I cannot grab the /td because I will screw up the entire document. I tried control characters to get the whole thing - chr(), etc. (replace(document,td width=1#chr(13)#.../td, )) but it seems that I could not grab them that way. Any ideas? Regards, Josen GoMotorBids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Alternative to cgi.http_referer - single signon
At the office, we've run into a bit of a snag with a script that a consultant did for us that authenticates from the URL of a referring page hosted on a third party site to auto-generate single signon authentication, so that an account from their site is automatically generates an account on our system and doesn't require the user to sign into our system.This feature is a requirement to our application by the third party (our client). In this case, the consultant's code tries to authenticate from cgi.http_referer.The problem we're getting is that we're not getting back a value. I have looked around the web, on this list and elsewhere, and know that this is a potential problem both with firewalls and certain browsers, but I haven't been able to find an alternative.We NEED an alternative, and we need it ASAP. Any suggestions? -- Sincerely, Brian Meloche http://www.brianmeloche.com http://www.clevelandmmug.org (currently partially down) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk [EMAIL PROTECTED] Reply, not quite, this only works when an error has occurred.I would like to do this even if an error has not occurred. cfquery name=somequery Select * from table /cfquery #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk [EMAIL PROTECTED] I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Alternative to cgi.http_referer - single signon
Brian Meloche wrote: At the office, we've run into a bit of a snag with a script that a consultant did for us that authenticates from the URL of a referring page hosted on a third party site to auto-generate single signon authentication, so that an account from their site is automatically generates an account on our system and doesn't require the user to sign into our system.This feature is a requirement to our application by the third party (our client). In this case, the consultant's code tries to authenticate from cgi.http_referer.The problem we're getting is that we're not getting back a value. I have looked around the web, on this list and elsewhere, and know that this is a potential problem both with firewalls and certain browsers, but I haven't been able to find an alternative.We NEED an alternative, and we need it ASAP. HTTP Digest Authentication can be set up to authenticate for multiple domains / servers, see RFC 2617. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQUERYPARAM in CFSET
This may not be possible but... Doesn anyone know of a way to get this or something similar to work? cfset strSQL = select ColumnName from TableName where ColumnName=cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Variable# cfquery #preserveSingleQuotes(strSQL)# /cfquery I'm pretty sure that idea, or any variations on it, won't work. 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] [Donations and Support]
RE: Second Pair Of Eyes
Arguments is an array rather than a structure If I recall correctly, the Arguments object is exposed as both an array and a structure. 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] [Donations and Support]
RE: SOT : Keeping JS Count
Say you have 2 radio inputs one with a value of 0, the other with a value of 1. And you have five of these.. a_1 = 0 a_2 = 1 a_3 = 0 a_4 = 0 a_5 = 1 how would you keep track of the totals? Initially you could just do a sum of the values but what if the user changed an option? it wouldnt subtract the 1? Any ideas would be appreciated. You can assign an event handler to any form field, so that when an event occurs a _javascript_ function is called. For example, if you had an array of checkboxes, you could loop over them to see which ones were checked. You could do this whenever any of them were checked or unchecked. script function calcTotal() { var total = 0; for (var i = 0; i document.forms[0].items.length; i++) { if (document.forms[0].items[i].checked) { total += document.forms[0].items[i].value; } } document.forms[0].total.value = total; } /script form ... input type=checkbox name=items value=1 1br input type=checkbox name=items value=4 4br input type=text name=total /form 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] [Donations and Support]
RE: Alternative to cgi.http_referer - single signon
Brian, I'm not sure you will get consistency from anything in cgi.I'd say you are going to have to pass something else - a shared key of somekind between you and the host.This could be done with _javascript_ point to a page on your server (src="" that appends a url string to the link or hidden variable. -Mark -Original Message- From: Brian Meloche [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 11:54 AM To: CF-Talk Subject: Alternative to cgi.http_referer - single signon At the office, we've run into a bit of a snag with a script that a consultant did for us that authenticates from the URL of a referring page hosted on a third party site to auto-generate single signon authentication, so that an account from their site is automatically generates an account on our system and doesn't require the user to sign into our system.This feature is a requirement to our application by the third party (our client). In this case, the consultant's code tries to authenticate from cgi.http_referer.The problem we're getting is that we're not getting back a value. I have looked around the web, on this list and elsewhere, and know that this is a potential problem both with firewalls and certain browsers, but I haven't been able to find an alternative.We NEED an alternative, and we need it ASAP. Any suggestions? -- Sincerely, Brian Meloche http://www.brianmeloche.com http://www.clevelandmmug.org (currently partially down) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]