Re: Scheduled Tasks Error
[crickets] :-) -- John Bliss - http://www.linkedin.com/in/jbliss I am experiencing the same issue on CF 11, neo-cron.xml all the scedheuled task vanished. and its an empty file. Did you manage to resolve this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Session lost on iPad... sometimes.
One suggestion may be to check in the users ipad Safari settings option, that cookies are accepted. Bas. No we're not using a load balancer so that can't be it. Also the user ip is the same when they return from Paypal as when they left for Paypal. Do you have a load balancer? We have seen this were a sticky session ( ip based ) is lost due to ipaddress changes on some mobile devices causing the balancer to send a request to a different server causing cf to loose the session Paul On 04/07/2012, at 9:00 PM, David Wilson dbutto...@hotmail.com wrote: We are experiencing an unusual error after launching our site. We have two options of payment for our app, Credit Card (using Paypal to process the payment) and Paypal Express Checkout (which for anyone who doesn't know, involves redirecting the user to Paypal and then back to your site to confirm the purchase). My problem is happening with the Express Checkout method. I'll try and break down what is happening is steps. !I SHOULD NOTE THIS IS ALL PROCESSED OVER HTTPS! 1. User fills out sign up form on our site, then selects Paypal as payment option, then submits form. 2. Session variables are set based on the data the user entered. A call is made to to Paypal using the API to get a Token for the transaction. 3. Once the token is received, we apprend it to a paypal url and redirect the user to that url (the Paypal site) 4. The user logs in, agree's to the transaction and is redirected back to our site (Where their session should be waiting for them). This is really where the problem is. Since launching we have had a few random (seemingly) errors from someone who's session has been lost. I noted the user_agent of the user was an iPad. Now, we have an iPad in the office but we are able to sign up fine on it. As we can't replicate the error we are finding it incredibly difficult to fix. I'm happy to provide any additional info anyone may think is useful, I'm just a bit stumped as to what's going on and could use some advice. Here are the relevant parts on my Application.cfc file. cfscript this.name = Example; this.setclientcookies=yes; this.sessionmanagement=yes; this.sessiontimeout= CreateTimeSpan(0,0,15,0); this.setdomaincookies=yes; /cfscript !--- : --- cffunction name=onSessionStart returnType=void output=false !--- I have a feeling this could be the culprit but I'm not sure how. This is legacy code from a previous developer. --- cfcookie name=CFID value=#Session.CFID# domain=.example.com httponly=true cfcookie name=CFTOKEN value=#Session. CFTOKEN# domain=.example.com httponly=true /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfcatch DB connection failure - for failover
Hi a bit stuck at the moment, I am trying to implement a DB fail over to a slave database through CF 9. I am using MYSQL as a DB. I have setup datasource in the application.cfc to point to the main db. When i trigger a stop service on the main db - which causes a failed db connection, i'm trying to get CF to change the datasource to the failover database. All that happens is the site keeps trying to connect to the main db without updating the db datasource in the cfcatch. Note: this code below works if i have a syntax error in the query, but not for a DB connection failure. See my code below, which i am putting in the onRequestStart and i have unchecked Maintain Connections in the datasource settings. cftry !--- Test whether the DB this application uses is accessible by getting some data. --- cfquery name=testDB dataSource=#application.primary_datasource# maxrows=2 SELECT id FROM user /cfquery cfcatch type=database cfset application.primary_datasource = failoverdb /cfcatch /cftry I welcome any thoughts and assistance thanks in advance. Bas. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Sessions and Citrix
Hi, I have a CF9 application where the user login process is managed through J2EE session variables. Problem, users on citrix have been able to see other users pages/session variables when logged in. Has anyone experienced this? Any suggestions for a solution or why this might be happening - currently thinking solution may be moving the session environment to be stored in client variables and in the database. Each citrix user has own unique login. Thanks, Seb. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 Standard Load Bal Sticky Sessions
Hi, I am trying to setup a failover environment for my web application. We are using CF9 standard and LVS (Linux Virtual Server) as the load balancer (LB). My web application uses session variables to remember form values posted in a process (eg would work like a session web shopping cart). The issue is the session values are lost when the LB processes the request as it flips between the different servers between each request. Is it possible to setup sticky sessions so that the session variables are retained across the web session? I'm concerned the only way to do this is to update the application to client variables and store in the database etc. Any thoughts or recommendations appreciated. Thanks, Sebastian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Standard and Load balancing env
Hi, We currently run coldfusion 9 Standard on a single server, our site has grown and we are looking at adding an additional box and setup a load balancing environment for the site. Here are my questions: * Is Coldfusion Standard sufficient for this environment or will i require enterprise? * If so would anyone know of any good information sources in relation to configuring coldfusion standard for this environment - anything i need to watch out for? Thanks, Sebastian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Standard and Load balancing env
Thanks great information. * I gather too application variables are unique to the server to where the session request is being called. Sebastian Hi, We currently run coldfusion 9 Standard on a single server, our site has grown and we are looking at adding an additional box and setup a load balancing environment for the site. Here are my questions: * Is Coldfusion Standard sufficient for this environment or will i require enterprise? * If so would anyone know of any good information sources in relation to configuring coldfusion standard for this environment - anything i need to watch out for? Thanks, Sebastian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Site not load - only show HTTP header
Hi, I have a user who cannot view my coldfusion website, we have large number of users on the site that are not experiencing the issue and i can't replicate the issue. When this particular user browses the site they just see the following message (seems to be HTTP header) and the site does not load. HTTP/1.1 200 OK Connection: close Date: Sat, 09 Oct 2010 13:31:33 GMT Content-Type: text/html; charset=UTF-8 Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Content-Encoding: gzip Vary: Accept-Encoding Transfer-Encoding: chunked Any ideas what may be causing this issue? or how i can debug? I am leaning towards a web server issue rather than coldfusion, but not sure. any thoughts are appreciated. Note: have advised user do the following so far: * check site on different browsers - same issue * tried clearing browser cache - same issue Bas. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Site not load - only show HTTP header
We are using Coldfusion 9 Thank you all for the suggtestions, I will try each of them and let you know if can resolve the issue I have a user who cannot view my coldfusion website, we have large number of users on the site that are not experiencing the issue and i can't replicate the issue. When this particular user browses the site they just see the following message (seems to be HTTP header) and the site does not load. HTTP/1.1 200 OK Connection: close Date: Sat, 09 Oct 2010 13:31:33 GMT Content-Type: text/html; charset=UTF-8 Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Content-Encoding: gzip Vary: Accept-Encoding Transfer-Encoding: chunked Any ideas what may be causing this issue? or how i can debug? I am leaning towards a web server issue rather than coldfusion, but not sure. any thoughts are appreciated. Note: have advised user do the following so far: * check site on different browsers - same issue * tried clearing browser cache - same issue What version of CF are you running? That used to be a fairly common problem under high load with CF 5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfssetting showdebugoutput
You want cfsetting showdebugoutput=No not false. It will stop any debug output, just as if you removed your IP address from the list in cf admin. It will not have any effect on error output, etc. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFML broadcasting app
Here is what I've learned over the past week on this topic (talk about a timely posting). I have a simple app that I use to send email blasts to my neighbors about neighborhood events, etc. There is a database with the emails (about 150 records), and I just loop over it and do a CFMAIL to send each address the message. This has been working for years, and got around all the problems usually associated with sending a message directly from a desktop client to a long list of addressees (looks like spam to both the sending SMTP server and to the receiving server, etc.). Until last week. I sent out a blast, and about an hour later my outgoing SMTP connection for Outlook (which is the same SMTP server that I have CF configured for), stopped working - it was getting a login failure when it tried to send out my desktop messages. I called the ISP tech support, they couldn't find any problem, reset my password, and everything started working again. Until yesterday. I sent out another blast, and the same thing happened. The proverbial light when on above my head. I called tech support, but this time their resetting of the password didn't work, and I also noticed that the error message from Outlook was not the login failure, but a domain has been blacklisted message. The tech support guy looked into it, and sure enough, those split-second blasts of 150 emails from the CF app triggered the ISP's spam-bot detection. Nothing to do but to wait for it to time-out and decide I'm a good guy after all (unless I run that CF app again!), or until Monday morning when the security guys get to work and manually fix it. Good news is that after about 12 hours it seems to have de-blacklisted me. So the moral of the story is that you definitely need to be careful about throttling this kind of activity. Like I said, this worked for me for years (with the same ISP), and I didn't recently add any new addresses to the database. The ISP isn't going to be very forthcoming with details on something like this, but they obviously lowered the threshold on their end of how much outbound SMTP traffic can take place in a short timespan. I need to modify my emailer app to not send them all at once. That needs to be coordinated with the CF Admin MAIL settings. The delay interval between executing a batch of CFMAIL tags has to be a multiple of the mail polling interval set in CF Admin. I'm running on my own box, so I know what that interval is, but if you're using a shared hosting service then you're going to have to experiment to deduce what they have their polling interval set to - the default is 15 seconds (or you could call them and ask). The CF shared hosting configs that I've worked with always had it set to something higher, like 5 or 10 minutes. I ran into this with just 150 addresses, so you should be able to see what level of complexity you're going to run into with the massive quantity you're talking about. Good luck! -reed ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Adwords API Question..
The process you described is that of the V13 release of the AdWords API. They have recently released the V2010 Beta of the reporting service, and life is much simpler, although they have not yet moved all of the V13 reporting functionality to V2010 (and some of the old functionality is probably going to be left to die on the vine). In V2010, there are only 2 required steps (3 if you do the validate, but that was an optional step in V13 as well): 1. Define the report job - this is a SOAP call where you specify the account, type of report, date range, and data items desired. This just defines the report, it doesn't run the report 2. Request the report, using the job# returned from step 1. This is a REST call and has to be for the same client account for which the report was defined. It will return the actual file data of the report. The format (CSV, XML, ...) and compression (ZIP) would have been specified in the report definition in Step 1. The wait time that we used to have to deal with in V13 is now implicit in how long the REST call in Step 2 takes to complete, since that is when it generates the report and returns the report data. From the looks of things, and discussions on the adWords API forum/blog, you really only have to define the report once for each client, so long as you aren't using hard-coded date ranges, and then pull that same report's JOB # each day. I haven't tried that approach yet. FYI, they have not yet set a price for doing the report pull in step 2. Hopefully it will be at least as cheap as it was in V13. There is an associated API call added in V2010 to return the names of the fields that you can specify in the report definitions for each type of report. Those names are no longer in the docs, so you need to do the API call to get the data values to use on subsequent API calls. Good luck, yell if you need more help, there are a couple of CF adWords API people on this list. -reed ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Adwords API Question..
It for a SaS, so it would have to run reports continuously for x number of clients on the system. You think that would still be something that would work if I had multiple tasks setup for each client on the system? You ever run into reliability issues with the Reports coming back empty or generating an error etc? I kept reading on old threads that it wasn't very reliable, but that was from a thread in 2006 or something. This is a constant problem with the adWords API - if you are trying to get the prior day's data, then you have to decide when you want to try and pull the data, and then hope for the best. There are no API calls in adWords (like there are in Yahoo's API) to find out when the data is ready to pull. What we do for the daily performance numbers is to setup a scheduled report on the AdWords GUI, and have it emailed to us. We have a CF task that monitor's the inbox used for the purpose, and unloads the incoming files for processing. That way Google is in control of determining when to send the data. You also need to take into account the fact that the performance data for a specific date can change anytime during the 30 days that follow, as changes are made for click-fraud corrections. 99% of the time those changes are only made within a day or two after the date. -reed Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe ColdFusion Anthology released
Mike: 2 copies just arrived to give out at my next UG meeting - from leafing through it looks great! I got an email a few minutes ago from the publisher telling me that 2 reprinted copies are on their way because of some printing error in the first ones. Any concrete info available on just what was changed? Is it so bad I shouldn't give away those copies? thanks, -reed ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Old CF doc needs to learn new Java tricks
I've put this for too long, and now there is real need for me to interface my CF code to vendor-provided class libraries written in Java. Have been coding CF apps for a long time; it's the Java side that I'm petty weak on. Documentation on the Java libraries (mostly Google AdWords at this point) isn't too bad, and there are Java examples of using them in a 100% Java application. I've found blog posting here and there that have tidbits of info on doing this sort of thing, but I'm sure that there's a lot more out there that would be helpful to me. The problem is that with search terms like ColdFusion and Java, given that CF is build on Java and that Java is popular in it's own right, the results of Googling have been pretty useless. Any points to resources to get this project kick-started? thanks everyone, Reed ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Old CF doc needs to learn new Java tricks
Thanks for the note John - I didn't meant to imply that I was new to the AdWords API. I have been programming against it from CF for a long time, mostly using CFXML and CFHTTP (since CFINVOKE etc weren't around when we started writing this stuff). But with the total rewrite/rearchitecture for V2009 of the AdCenter API I'm weighing rewriting all of my stuff from scratch, or just interfacing to their Java client library and letting it do the heavy lifting in talking to their webservice. Especially since they haven't done a lot in the way of documenting what the actual SOAP requests look like. Have you upgraded your code to V2009? There's only 5 weeks left until V13 sunsets, so I gotta get rocking and rolling on this. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Apache AXIS version in CF9 and CF8?
Anyone know for sure what versions of Axis are in CF8 and CF9? Or how to get Cf to expose that info? Am having parsing problems with a third party XML file, and they're curious as to what version is having the problems. They're putting a line like this after the first line of the file (ie, after the ?XML line): ?bulk application=mr_xml? which is supposed to indicate that the code is machine readable (not sure exactly what that really means, but that's what the third part says. If I remove that line from the file, then it parses ok via CF's xmlParse() function thanks, -reed ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache AXIS version in CF9 and CF8?
Right Dave, I got my wires crossed there. I remember reading something a few years ago about being to replace the xml parser that comes with CF with one of a couple of others - do you know which parse is the one the comes with CF9 (or Cf8, I doubt that it has changed)? thanks -reed Anyone know for sure what versions of Axis are in CF8 and CF9? Or how to get Cf to expose that info? Am having parsing problems with a third party XML file, and they're curious as to what version is having the problems. They're putting a line like this after the first line of the file (ie, after the ?XML line): According to /META-INF/MANIFEST.MF within the axis.jar file on CF 9: Manifest-Version: 1.0 Ant-Version: Apache Ant 1.5.3 Created-By: 1.4.2_05-b04 (Sun Microsystems Inc.) Name: org/apache/axis Implementation-Title: Apache Axis Implementation-Version: 1.2.1 2243 June 14 2005 Implementation-Vendor: Apache Web Services ?bulk application=mr_xml? which is supposed to indicate that the code is machine readable (not sure exactly what that really means, but that's what the third part says. If I remove that line from the file, then it parses ok via CF's xmlParse() function I don't think CF uses Axis to parse XML generally, it's a web service library. The line in question is a directive that specific applications could use to do something particular with that XML file, but other applications should ignore the directive. I don't know why CF isn't ignoring it, but I hope that helps a bit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsi ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache AXIS version in CF9 and CF8?
Thanks for all the info Pete. I'm running CF9, so that's Java 1.6, and it uses Xerces 2.9.1, which seems to be the latest. Interesting that you were able to parse the xml using java 1.5 - maybe I'll give this a try on a CF8 box. I'll probably end up doing the stripping of that line, but it's a pain to do that because some of the files are big (400MB+) and don't have any line breaks in them, so first I need to make a pass over the file just to get line breaks before each XML tag, so that I can then use CFLOOP to go through it a second time on a line by line basis. If I try to read that whole file in at once CF (JVM actually) will roll over. thanks again for all the info, still digesting it, -reed ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Clients Can't Login - IE8 Caching?
I have had a similar problem with my site recently, could i ask whether you use session variables as the structure for your login process and also whether you have J2EE session variables enabled or just using regular session variables (cookie based) in your CF admin settings. Not sure if your issue is the same and i am also not sure if I have fully solved my issue but the instances have reduced. I am restricted by the hosting company config, they don't allow j2ee session variables and I had an issue with the regular session variables not clearing and users could not login. This can be an issue with cflocation if you have a redirect post vaildating the user credentials and you would also check that you are clearing the session variables upon logout. If you can enable j2ee it should solve the issue or in my case I have a bunch of cfide cookie expiries and structdelete's to clear the CFIDE tokens onSessionEnd in my app.cfc I found these posts useful, may not be your issue but interesting the same: http://www.jensbits.com/2009/07/29/coldfusion-dropping-losing-or-resetting-session-variables-and-cfidcftoken/ http://www.mail-archive.com/cf-talk@houseoffusion.com/msg35466.html Cheers, Bas. On Sat, Jan 30, 2010 at 6:11 AM, Randy Zeitman stonerosedesigndot...@yahoo.com wrote: Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfwindow parent refresh
Hi, I have a cfwindow that does the following: 1) receives some url variables 2) user can input a comment or text in a form within the cfwindow 3) on submit in the cfwindow it updates the comment in the database 4) confirmation message that submitted and option to close the cfwindow Issue: I am trying to show the updated comment on the parent page once the cfwindow has closed, thinking either I refresh the parent page on close or update a form variable on the parent page with the posted comment. would anyone have an example of how i may do the above? Thanks, Sebastian. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onclick refresh cfdiv
Anyone done this before? I want to refresh a cfdiv when a anchor tag link is clicked? thanks. Sebastian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with consuming .NET complex datatype webservice
I am trying to consume a .NET webservice from coldfusion. When I cfinvoke the
webservice it returns a complex object which has the get_any() method. I am
trying to access the data but am not sure where it is located or how to consume
the returned object.
I have run the wsdl2java and got the following java response file code and been
using cfdump on the methods returned to try an find where the xml data is
contained within the object, but no luck.
Hoping for some guidance on where the find the data, or what i should try for
next steps.
Thanks,
Bas.
/**
* MeetingSummaryResponseMeetingSummaryResult.java
*
* This file was auto-generated from WSDL
* by the Apache Axis 1.2.1 Jun 14, 2005 (09:15:57 EDT) WSDL2Java emitter.
*/
public class MeetingSummaryResponseMeetingSummaryResult implements
java.io.Serializable, org.apache.axis.encoding.AnyContentType {
private org.apache.axis.message.MessageElement [] _any;
public MeetingSummaryResponseMeetingSummaryResult() {
}
public MeetingSummaryResponseMeetingSummaryResult(
org.apache.axis.message.MessageElement [] _any) {
this._any = _any;
}
/**
* Gets the _any value for this MeetingSummaryResponseMeetingSummaryResult.
*
* @return _any
*/
public org.apache.axis.message.MessageElement [] get_any() {
return _any;
}
/**
* Sets the _any value for this MeetingSummaryResponseMeetingSummaryResult.
*
* @param _any
*/
public void set_any(org.apache.axis.message.MessageElement [] _any) {
this._any = _any;
}
private java.lang.Object __equalsCalc = null;
public synchronized boolean equals(java.lang.Object obj) {
if (!(obj instanceof MeetingSummaryResponseMeetingSummaryResult))
return false;
MeetingSummaryResponseMeetingSummaryResult other =
(MeetingSummaryResponseMeetingSummaryResult) obj;
if (obj == null) return false;
if (this == obj) return true;
if (__equalsCalc != null) {
return (__equalsCalc == obj);
}
__equalsCalc = obj;
boolean _equals;
_equals = true
((this._any==null other.get_any()==null) ||
(this._any!=null
java.util.Arrays.equals(this._any, other.get_any(;
__equalsCalc = null;
return _equals;
}
private boolean __hashCodeCalc = false;
public synchronized int hashCode() {
if (__hashCodeCalc) {
return 0;
}
__hashCodeCalc = true;
int _hashCode = 1;
if (get_any() != null) {
for (int i=0;
ijava.lang.reflect.Array.getLength(get_any());
i++) {
java.lang.Object obj = java.lang.reflect.Array.get(get_any(),
i);
if (obj != null
!obj.getClass().isArray()) {
_hashCode += obj.hashCode();
}
}
}
__hashCodeCalc = false;
return _hashCode;
}
// Type metadata
private static org.apache.axis.description.TypeDesc typeDesc =
new
org.apache.axis.description.TypeDesc(MeetingSummaryResponseMeetingSummaryResult.class,
true);
static {
typeDesc.setXmlType(new
javax.xml.namespace.QName(http://direct.tab.com.au/LiveOdds/;,
MeetingSummaryResponseMeetingSummaryResult));
}
/**
* Return type metadata object
*/
public static org.apache.axis.description.TypeDesc getTypeDesc() {
return typeDesc;
}
/**
* Get Custom Serializer
*/
public static org.apache.axis.encoding.Serializer getSerializer(
java.lang.String mechType,
java.lang.Class _javaType,
javax.xml.namespace.QName _xmlType) {
return
new org.apache.axis.encoding.ser.BeanSerializer(
_javaType, _xmlType, typeDesc);
}
/**
* Get Custom Deserializer
*/
public static org.apache.axis.encoding.Deserializer getDeserializer(
java.lang.String mechType,
java.lang.Class _javaType,
javax.xml.namespace.QName _xmlType) {
return
new org.apache.axis.encoding.ser.BeanDeserializer(
_javaType, _xmlType, typeDesc);
}
}
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfchart Flash chart not showing
Looking at the page in the browser there is a warning in the status bar which says: Line:204 Char:1 Error:Object Expected Code 0 Thanks, Bas. I have developed a few charts of format type flash using cfchart on a development version of CF8 and they can be viewed no problems in the browser. When I deploy the code on CF8 standard, the charts do not show. When changing the chart to format type jpg they do appear, so seems to suggest an issue with the chart format type flash. Am i missing a plugin or is it the version? Flash player is installed and I have also ensure CF8 standard hot fix is up-to-date (hot fix 3). Any ideas why this might be occurring? Thanks, Bas. Heres the code: cfchart format=flash font=Arial fontsize=12 show3d=true cfchartseries type=pie query=session.qTotResp itemcolumn=Status valuecolumn=PScore/ /cfchart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchart Flash chart not showing
I have developed a few charts of format type flash using cfchart on a development version of CF8 and they can be viewed no problems in the browser. When I deploy the code on CF8 standard, the charts do not show. When changing the chart to format type jpg they do appear, so seems to suggest an issue with the chart format type flash. Am i missing a plugin or is it the version? Flash player is installed and I have also ensure CF8 standard hot fix is up-to-date (hot fix 3). Any ideas why this might be occurring? Thanks, Bas. Heres the code: cfchart format=flash font=Arial fontsize=12 show3d=true cfchartseries type=pie query=session.qTotResp itemcolumn=Status valuecolumn=PScore/ /cfchart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
conditional cfchartseries
Hi, I am trying to conditionally color a single bar chart series in cfchart, depending on a value returned from a source query. As an example of logically what i am trying to achieve : cfchartseries type=bar query=myQuery valueColumn =count itemColumn = region paintstyle = plain cfif #myquery.count# gt 5 seriesColor = red cfelse seriesColor=blue /cfif / Thanks Bas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xml populated pdf forms and livecycle designer?? [FIXED]
This forum is not full of Acrobat experts that reply to messages. I have yet to figure out how to populate the barcode field. I think the basic approach would be to extract the data (to get the structure) now use this as a template. Fill in your data and add it back to the PDF. cfpdfform source=c:\employeeid123.pdf result=c:\ formdata.xml overwrite=yes action=read/ cfpdfform source=c:\payslipTemplate.pdf action=populate XMLdata=c:\formdata.xml/ alternatively you can use structs instead of XML. -aP ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quantum Gateway CDG Commerce
Take a look at http://www.quantumgateway.com/view_developer.php?Cat1=3 Are you using cfhttpparam? cfhttpparam name=gwlogin type=FormField value=your_value... Does anyone know if the cfhttpparam tag is better than URL variables? I suppose either way this request would originate from the server and not be available to the end user. I believe then you could just append the vars to your URL string as the HTTPS should keep this secure. The example PHP is messy http://www.quantumgateway.com/php_examples.php (aren't you glad you use CF?) -aP Hi, Having a difficult time integrating to CDG Commerce's Quantum Gateway with CF 8. Making a CFHTTP call to their gateway URL https://secure. quantumgateway.com/cgi/tqgwdbe.php but CF returns peer not authenticated. Have gone through and imported the root certificate with keytool, both the certificate saved using IE, and when that didn't work, a download of the root cert from entrust.net. I can't figure out why the heck this doesn't work. A basic example: cfhttp url=https://secure.quantumgateway.com/cgi/tqgwdbe.php; resolveurl=no /cfhttp cfdump var=#cfhttp# ... just doesn't work. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Scheduled Jobs monitoring
There are multiple approaches that could be taken. You could simply have the jobs email you when they complete or fail and if you don't get an email then something is up. You could have the jobs write to a table (time-stamp, success fail). You could have a second server (server could be your desktop) check the tables and notify you or even the second and the primary upon failure (or if record is missing). So you will get two emails on failure but that is your redundancy. You could have a few fields in your log to specify when the email was sent. etc. Just a few ideas. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How Do I treat this Changing Variable?
You are not pinging the 230 machines, they will be submitting their results to the main computer? It would then seem that each call will have its own session. So the next level up is the Application though my preference would be to use database tables. Then I don't just have live results but historical results as well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Module for Pay-Pal integration
Its easy enough just to use .net or com objects with ColdFusion cfobject tag. Have you tried this approach yet? -Andrew JHello everyone, I have several organizations wyho want to enable their Web sites to process transactions via Pay-Pal. I downloaded the Pay-Pal module which allows one to seemlessly integrate their PHP sites with Pay-Pal allowing visitors to remain on the native Web site while Pay-Pal works in the background. I found the PHP Asp.net and Classic ASP components for accomplishing this, but didn't find one for ColdFusion integration. Does anyone know where I can download the required component, or tell me where there are instructions for doing this using ColdFusion? Your assistance will be greatly. Happy new year from my wife and I. Peter Donahue ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting an image in a PDF?
We've been using watermark for this cfpdf action=addwatermark source=PDFdoc copyfrom=#getFiles.ImagesPDF# foreground=no opacity=10 pages=1 position = 0,0 showonprint=yes name=PDFdoc You can set the position. Place it in front or back and set the opacity :) Yes, I meant an existing PDF. Specifically, one I'm already cfpdfformparam to populate. I was hoping there was a way to also insert an image into a defined area. Though your solution of creating a seperate PDF and then merging the two would likely work as a 2nd best option for what I need. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adobe Acrobat PDF with Barcode Field and ColdFusion?
We are using Acrobat Pro to add form fields to our PDFs that we then fill out and print from ColdFusion. One type of form field in Acrobat is the BarCode. When we use cfpdfformparam with this field the field actually shows the text and not the barcode lines. The natural way to use the field appears to be with validation. You set the field to be tied with another field on the page or it can contain the whole form. This is done with the properties box or you can edit the script directly. This code does not execute unless an event is triggered (ie when you open the form and make a change). I found the on print event and added the validation there. This works when a person prints the PDF. It would appear that validation is not run when ColdFusion manipulates or prints PDFs. The barcode remains blank. The barcode also does not seem to be part of the XML structure so that method is also a dead end. Everything I have found online seems to describe how to add barcodes, draw them on or use some library. Will I have to wait for CF9? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with CFX
You might consider developing the C++ into a CFX tag. http://livedocs.adobe.com/coldfusion/8/htmldocs/CFXTags_1.html If the third party app has a commandline interface you could just use that with cfexecute http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_d-e_18.html Though I perfer the Java method for CLI http://stannard.net.au/blog/index.cfm/2007/9/21/executing-system-commands-with-coldfusion -Andrew Hi all - I'm working on a Coldfusion application that needs to interface with a 3rd party API that is written in C++. I cannot register their .dll with windows so I cannot access the API using cfobject. It is my understanding that I need to wrap this is into a COM object. My question is: Does this mean that I need to write a C++ procedure that calls the C++ in their API and then compile and register my C++ procedure and then access it as a CFX tag? Any insight would be helpful. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion 8 Standard Edition multiple sites
I'm new to coldfusion and have a few developed sites which I plan to host on a dedicated server. In process of working out which version of CF I need. Wanted to know if Standard edition can handle multiple sites and what the impact performance wise would be? or anything else I should consider? As context the sites utilise the following services: SMS gateway Webservices Scheduled Tasks Logging multiple databases Thanks, Bas. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Get time zone for address?
As far as I know, there is a shapefile that defines timezones which will work with ESRI's ArcMAP. So this, along with ArcGIS, lets you get the lat/lon from the address then get the tz from the shapefile. There is no guaranteed easy way (or cheap way) to do this. ap On Feb 22, 2008, at 12:33 AM, Mike Kear wrote: You bet time zones arent universal. The famous Indian Pacific train, which goes between Perth in Western Australia and the Australian east coast has its own time zone. There's even a group of tiny towns near the border of South Australia and Western Australia that have their own time zone, called Central WA time. It's set between Adelaide's Australian Central Time and Perth's Australian Western Time. Towns following this zone include Madura, Mundrabilla, Eucla and Border Village in South Australia. The total population of the area is estimated at 200 people. They are all living a LONG way from anyone, and got hacked off with having to have their clocks set in Adelaide time, which didnt suit their situation are so far from Adelaide, yet at the same time even further from Perth - the Nullabor Plain is just hundreds of miles of nothing for as far as the eye can see. Add to the fact that whether or not to have Daylight Savings was a debate that raged back and forth for years in WA, they just got jack of the whole thing and decided to go their own way. Then add in the to-ing and fro-ing over daylight savings and you'll have an almost impossible task to program it. For example, only for the sake of the 200 Olympics and the desires of NBC to get better shots on the tv, the NSW government brought forward the change to summer time by a couple of months. Other states have changed the date of switching for other reasons for longer or shorter periods. If you persist with trying to make sense of time zones and relative times, you'll hurt your brain. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 2/22/08, Paul Hastings [EMAIL PROTECTED] wrote: On Thu, 21 Feb 2008 16:03:52 -, Adrian Lynch [EMAIL PROTECTED] wrote: The address has a longitude of 28 so you know it's in time zone 3. tz rules aren't universal, they depend on countries (ie politicians), even states/regions within a country (even more politicians). a list of cities/locations w/tz IDs a simple proximity search might be more accurate. if you're into GIS, here's a free global tz dataset: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Ant Script help
Are you talking about merging files or replacing files? If you're replacing: delete file=fullPathToFileB/ copy file=fullPathToFileA toFile=fullPathToFileB/ Andy On Feb 13, 2008, at 10:40 AM, jonese wrote: Anyone here ever create an ant script which will take the contents for file A and put them into file b? i'm trying to find a workaround for an issue i'm having and this is currently the only solution. thanks in advance jonese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Ant Script help
I don't know of any core ANT tasks (i.e. default) that will read and merge files. However, there are a number of external tools that you can use that may do what you're looking to achieve. Most of the ones I've seen simply work with XML though. If you're not merging XML, then you may need to write your own ANT task, which is fun in and of itself. :) External ANT tasks: http://ant.apache.org/external.html Andy http://www.infoaccelerator.net On Feb 13, 2008, at 10:50 AM, jonese wrote: i basically have a file which is generated by another program (File A). I need to take the contents of this file and place it into a NEW File B then move File B to File A. I have to do this because for some reason some of my ANT tasks cannot read File A. But if i manually copy the contents from File A to File B and then rename File B to File A it works.So i'm trying to do this using ANT. jonese On Feb 13, 2008 10:45 AM, Andrew Powell [EMAIL PROTECTED] wrote: Are you talking about merging files or replacing files? If you're replacing: delete file=fullPathToFileB/ copy file=fullPathToFileA toFile=fullPathToFileB/ Andy On Feb 13, 2008, at 10:40 AM, jonese wrote: Anyone here ever create an ant script which will take the contents for file A and put them into file b? i'm trying to find a workaround for an issue i'm having and this is currently the only solution. thanks in advance jonese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Driven Spry Menu
CSS is the key. On Jan 17, 2008, at 11:19 AM, [EMAIL PROTECTED] wrote: I am looking into it now. I believe I can do what I want this way. I am curious however how you change the look of the menu? I guess that is all css?? Thanks Ray Jay Raymond Camden [EMAIL PROTECTED] 01/17/2008 09:49 AM Please respond to cf-talk@houseoffusion.com To CF-Talk cf-talk@houseoffusion.com cc Subject Re: Database Driven Spry Menu Jay, Spry's UI widgets just take normal HTML and then converts it to your fancy crap. If you look at the docs for menu: http://labs.adobe.com/technologies/spry/articles/menu_bar/index.html You will notice they use simple ulli tags. That should be trivial to push out from CF. On Jan 17, 2008 9:04 AM, Jay McConathy [EMAIL PROTECTED] wrote: I am wanting to create a database driven menu, most likely useing spry, and I am hoping to get a good example of this or any CF database driven menu thans for your help Jay McConathy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajax cfchart
This is what you're trying to do: http://www.infoaccelerator.net/index.cfm?event=showEntryentryId=2BE38F46-1372-FA49-99088CD1819F9BA3 CFCHART is static at create time; it can't change it's backing data. My FlexChart utility (http://www.barneyb.com/flexchart/) can change not just the data, but also the entire structure (5-series line chart, to a pie chart, to a 3 series column chart). It's all XML driven, which makes it a snap to use with whatever technology. cheers, barneyb On Jan 9, 2008 9:19 AM, Dustin Snell [Network Automation] [EMAIL PROTECTED] wrote: Is there a way via Ajax to automatically update CFCHART with new data without refreshing the page? If not with CFCHART are there any other technologies out there that can do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Enterprise and FLEX Setup Question
It run as a web app under the context root you setup for the whole app at install. Lcds is avalable at startup as part of cf. Andy On 1/9/08, James Blaha [EMAIL PROTECTED] wrote: Folks, When you peform a developer install of CF8 is there a way to test LCDS? I dont see any extra Windows services for it runnning. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Enterprise and FLEX Setup Question
You should not need lcds unless you plan on doing java remote object, data management svcs, or messaging. On 1/9/08, Andy Powell [EMAIL PROTECTED] wrote: It run as a web app under the context root you setup for the whole app at install. Lcds is avalable at startup as part of cf. Andy On 1/9/08, James Blaha [EMAIL PROTECTED] wrote: Folks, When you peform a developer install of CF8 is there a way to test LCDS? I dont see any extra Windows services for it runnning. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Performance re: multiple CPUs, Cores, Servers, Virtualization
We're looking at throwing more hardware (both upgrades to existing servers as well as new or replacement servers) at our mix of applications to improve performance. I'm looking for insights from personal experiences on a couple of approaches. Our application mix that needs the performance runs mostly between midnight and mid-morning, and is a suite of CF scripts that interact with webservices from the major search engines. Lots of XML parsing and processing with lots of database activity to store the data. Some of the XML files are large, and therefore use up a lot of JVM when being processed (since at some point in time there needs to be a copy of both the CFHTTP data returned from the webservice as well as the structure being created by the xmlParse function). We have a pretty well configured SQL 2000 server, although the production could admitedly use some tuning. These are Windows servers, so we have the inherrent limitation of ~1.8gb address space, which boils down to around ~1.4gb available for the CF apps running in the JVM. From a processor perspective, what are people's experiences on the topic of multiple processors versus dual-core/quad-core processors? Some of what I've seen with our mix of servers is that the multiple-core processors are not always a big win over multiple processors. I would still have the limiation on Java/CF memory space. What about just running a stack of multiple servers? This helps solve the Java/CF memory space problem. What about just running a stack of multiple (cheap) workstations, possibly with dual-core processors, instead of a big honking (expensive) server (we'll call this the Google approach)? What about virtualization? Any experiences using either Microsoft's software or VMware on a server with an instance of CF on each of them? That also solves the memory problem (presuming sufficient physical memory), but would seem to be highly sensitive to the number and effectiveness of the processors/cores. It seems like it might have an administrative advantage over simply running multiple instances of CF on the same server since I wouldn't have to worry about port numbers and such on the same server, because each would be running on port 80 on its own IP address within the virtualized server. Any other alternatives? I can definitely find additional work for these systems to do during the daytime, but the real crunch is to get all of that XML data processed by CF during the nighttime before people show up in the morning. TIA, Reed ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Performance re: multiple CPUs, Cores, Servers, Virtualizat ion
Dave - thanks for the comments re doing the XML processing in CF. Do you have any pointers to alternative products/facilities that I could use to handle that part of the tasks, and somehow integrate back into the overall CF app? I've done research on this in the past, but XML is such a wide topic that any searches I do seem to come up with irrelevant topics. There seem to be a ton of libraries for use in writing XML applications, but not much info on comparing them. Thanks! Reed Our application mix that needs the performance runs mostly Why are you doing this XML parsing from CF at all? I'm sure there are more efficient alternatives for that sort of thing. You could offload it from your web servers entirely. Alternatively, you could simply install CF on other machines solely for this task, although that might not be cost-effective. From a processor perspective, what are people's experiences on the topic of multiple processors versus dual-core/quad-core processors? Some of what I've seen with our mix of servers is that the multiple-core processors are not always a big win over multiple processors. I would still have the limiation on Java/CF memory space. I think that generally, multiple processors (which may have multiple cores themselves) will provide better multithreading than a single processor with multiple cores, but I don't think this makes that much difference in the long run. What about just running a stack of multiple servers? This helps solve the Java/CF memory space problem. What about just running a stack of multiple (cheap) workstations, possibly with dual-core processors, instead of a big honking (expensive) server (we'll call this the Google approach)? In the Google approach, machines fail regularly and get replaced regularly. It requires certain economies of scale you probably don't have. Virtualization is certainly a viable option, and you can run your virtual environment on as big an x86 box as you can get (or multiple boxes, via VMware Infrastructure). Each VM will require more resources than an individual CF/JRun instance would require, though. If your only goal is maximization of resource usage, using VMs doesn't buy you anything here, unless different VMs would have different resource allocation requirements. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Executing Code in a CFINCLUDE within CFMAIL
That's what I've always done - much cleaner. But - it does in fact work on V5, so that's what I'd say is the solution. I've had funny things happen with tag processing inside of CFMAIL. -reed Am not sure about an include inside the cfmail, never done it. But theory says it should, but practical who knows. I have always done cfsavecontent variable=test include template=include.cfm/ /cfsavecontent But as he said Coldfusion V5.0, that is way out of the question. On 7/10/07, Tom Chiverton [EMAIL PROTECTED] wrote: ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JReport anyone?
Anyone using JReport (www.JInfonet.com) for ColdFusion reporting? It looks like a nice product that can be easily integrated into CF apps. I downloaded an eval copy 3 weeks ago, and have yet to get anyone at Jinfonet to return my call to give me the license key (and pricing information). Should I be worried about that?! I'd love to know what this beastie costs (I usually figure that if a company doesn't post pricing info on their website, then it's too expensive for me). Any comments on this product, or good alternatives (more capable than CFReport) for a nice reporting tool that provides ad-hoc ability, would be really helpful. Thanks all, Reed ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
More TZUPDATER problems
I must be missing something, this should be sooo simple. I downloaded tzupdater from Sun, and extracted it from the archive file. I opened a DOS window and went to C:\CFusionMX7\runtime\jre and issued this command: java -jar c:\temp\tzupdater.jar -v -f It comes back and tell me that javahome is that of the JRE installed in my c:\ProgramFiles\java\ folder. Am I not in the right place to have it find the JRE that goes with ColdFusion? The update had no effect on the time coming out of CF - it's still 1 hour earlier than reality. I need to use the tzupdater instead of the full install because one of my servers has always had a problem with java updates (never runs after any of them - something that must have been done before I came on board here is causing the problem), and so cannot be brought up to the latest supported jre/CF version. The servers are all running 1.4.2_09. What the heck am I doing wrong? thanks! Reed ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: More TZUPDATER problems
Thanks Steve - it turns out that I needed to be in c:\cfusionmx7\runtime\jre\bin so that the copy of java.exe from the CF installation ran, instead of the copy of java.exe in the ProgramFiles directory. thanks Reed Reed: Set you JAVA_HOME environment variable to C:\CFusionMX7\runtime\jre and try again. Steve Brownlee http://www.fusioncube.net/ java -jar c:\temp\tzupdater.jar -v -f ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Random errors from CFHTTP sending XML documents
I have a couple of CF scripts that send out an XML doc to various webservices (Google AdWords, for example). Usually they all run just fine, but from time to time I get the following error: You may only use ONE cfhttpparam of type XML or BODY. It happened again last night on the simples of scripts: One that loops over about 9000 entries in my database, and on each iteration sends the same XML document (created via CFXML) to the same webservice - the only difference between any of them is the login and account data that is stuffed into the document. The structure of the document is identical each time - there is no conditional logic at all within the CFXML block of code. Is this a known problem with the underlying Apache Axis code that CFMX7 uses for webservices? Is there a fix? On a related topic, is there a way to parse an XML document other than the CFMX xmlParse() function? It returns a structure, and in the case of the XML docs returned by Google AdWords (and similar docs from Yahoo! and MSN) they are a bit complex in terms of the number of levels and the nesting of structures within arrays which are themselves elements of the overall document structure. For small docs this is not a problem, but the processing time for CF to go through the info in the structure does not seem to be linear with respect to it's size. When I get back docs that have more than 3000 or so elements in the nested array, the processing time skyrockets. Any hints or pointers to alternative strategies? Thanks all! Reed ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Pittsburgh Area CFUG is coming back to life!
I'm happy to announce the restart of the Pittsburgh Area ColdFusion Users Group. It was pretty active a few years ago, but gradually died out. I know that we have a number of CF shops in the area, and am trying to get the word out to them announcing our next meeting on March 20th at 6:00pm; The details and directions are on our website at www.PITCFUG.org. If you want to be added to our email list, just drop me a note at [EMAIL PROTECTED] If you know of CF people or companies that might not be seeing this message, please pass along whatever contact info you have and I'll get in touch with them. Advice on building up the membership from any others that have recently started a CFUG is appreciated, since user group startup support from Adobe does not seem to be what it was from MacroMedia or Allaire. We're hoping to get trinkets, etc., from Adobe, but ... Thanks Reed ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Developer Edition - changing IP addresses
[I tried Googling/searching this but the terms are just too generic] The CFMX7 Developer's Edition allows external access from 2 IP addresses, as well as local access. I've never been able to find where it gets those IPs from, and searches on the NEO*.xml files never seem to produce a hit. We've moving the office next week, and taking that opportunity to rearchitect the LAN - which means that IP addresses are going to be changing. So now I really do care about where those IPs are stored and how to change them. Any pointers are appreciated! TIA, Reed ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Google Adwords API
There really shouldn't be much concern over using ColdFusion. We have a number of scripts that run daily, hourly, etc., using the Google API, and have found it easiest to just create the SOAP document in the CFXML tag and then use CFHTTP to talk to Google. Here is an example of code using the ReportService to pull back a previously requested report (with keys removed!). cfxml variable=variables.getreport casesensitive=true SOAP-ENV:Envelope xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; SOAP-ENV:Header m:email xmlns:m=https://adwords.google.com/api/adwords/v6;#q.login#/m:email m:password xmlns:m=https://adwords.google.com/api/adwords/v6;#q.password#/m:password m:useragent xmlns:m=https://adwords.google.com/api/adwords/v6;xxx/m:useragent m:token xmlns:m=https://adwords.google.com/api/adwords/v6;xxx/m:token m:developerToken xmlns:m=https://adwords.google.com/api/adwords/v6;xxx/m:developerToken m:applicationToken xmlns:m=https://adwords.google.com/api/adwords/v6;xxx/m:applicationToken /SOAP-ENV:Header SOAP-ENV:Body m:getGzipReportDownloadUrl xmlns:m=https://adwords.google.com/api/adwords/v6; m:reportJobId#q.report_id#/m:reportJobId /m:getGzipReportDownloadUrl /SOAP-ENV:Body /SOAP-ENV:Envelope /cfxml cfhttp url=https://adwords.google.com/api/adwords/v6/ReportService; method=post cfhttpparam name=SOAPAction type=header value=/ cfhttpparam type=xml value=#ToString(variables.getreport)#/ /cfhttp After this is when the fun begins. Google will return HTTP error 500 for a number of problems, including bad login information. When they do send back a 200 response, you can still get XML documents that can be parsed with XMLparse(), but which might not have all of the XML elements you are expecting, depending on whether or not there is data on their end to download. Rather than tell you we don't have any data they will just send back a skeleton XML doc, and leave the rest blank. You end up using StructKeyExists() quite a bit. I've also ended up putting TRY/CATCH around the block of code that tries to access the individual data elements, just to be safe. Oh yea, sometimes they will just send you a 200 HTTP code, with a blank document. They are not big into error codes: Sometimes they will send back in text (literally) an error message string. My favorite is one that basically says dude, I'm a little busy now, and don't know how to keep track of my backlogged work, so just come back later with your request and I'll see what I can do about it. This makes parsing and handling the errors just a whole lot of fun. The same is true using code such as the above example - after sending in the request for report creation, you have to wait for it to be ready. If you try to get the report too soon, they tell you that with a text string (rather than an error code). Also, if you wait too long, the report will expire and you have to reissue the report request. Otherwise it's a breeze. Oh yea, I noticed in your example that you were using the V2 API. I'm surprised that you got any response at all. They stopped responding to my V4-formatted SOAP requests about a week or two ago. Right now it's V5 or V6 only. Here is the link to their documentation, in case you don't already have it: http://www.google.com/apis/adwords/developer/Keyword.html Good luck! Reed Does anyone have any experience with Google Adwords API service? I trying to figure out some of the sample code provided on the Goggle Groups and in the Documentation, so far I have not been able to get any of the examples to work. I can make the connection to the service but beyond that, like modifying ad settings or adding keywords I can't seem to get anything working. If anyone here has any working examples or could provide some info that would be great. So far all I have that kind of works but generates an error is this: --- cfset myEMail = [EMAIL PROTECTED] cfset myPassword = cfset myToken = _xx cfset myClient = [EMAIL PROTECTED] cfscript getGoogleWSDL = CreateObject(webservice,https://adwords.google.com/api/adwords/v2/Criteri onService?wsdl); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,email,myEMail); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,password,myPassword); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,token,myToken); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,useragent,ColdFusion AdWords); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,clientEmail,myClient); aKeywordRequest = structnew();
Re: Google Adwords API
Does anyone have any experience with Google Adwords API service? I trying to figure out some of the sample code provided on the Goggle Groups and in the Documentation, so far I have not been able to get any of the examples to work. I can make the connection to the service but beyond that, like modifying ad settings or adding keywords I can't seem to get anything working. If anyone here has any working examples or could provide some info that would be great. So far all I have that kind of works but generates an error is this: --- cfset myEMail = [EMAIL PROTECTED] cfset myPassword = cfset myToken = _xx cfset myClient = [EMAIL PROTECTED] cfscript getGoogleWSDL = CreateObject(webservice,https://adwords.google.com/api/adwords/v2/Criteri onService?wsdl); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,email,myEMail); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,password,myPassword); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,token,myToken); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,useragent,ColdFusion AdWords); addSOAPRequestHeader(getGoogleWSDL,https://adwords.google.com/api/adwords/v 2,clientEmail,myClient); aKeywordRequest = structnew(); aKeywordRequest.adGroupId=-- AD_ID goes here --; aKeywordRequest.type=broad; aKeywordRequest.text=music; xmloutput = getGoogleWSDL.addCriteria(aKeywordRequest); /cfscript cfdump var=#xmloutput# -- Neal Bailey ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[OT] Managed DNS Services - recommendations/feedback?
We had yet another ATT T1 line failure yesterday. Even though we have a Verizon DSL as backup, that only helps for outbound traffic, since all of the DNS entries at ATT resolve to the IP address that they have assigned to the T1 line. We're looking at managed DSN services so that in the future we can have the most critical of the incoming traffic failover to the other IP address (associated with the DSL line). Ditto for inbound email messages. Anyone have recommendations (or de-recommendations)? They all see to be pretty inexpensive, so I'm a bit concerned that some of them might be living on the edge in terms of redundancy, etc. tia Reed ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and HTTPS/SSL and good/bad certs
I deleted the two certs that I had downloaded from the adCenter.Microsoft.com pages, restarted CF, and gave ti a try. I would have expected to see solid failures, but really didn't see any change. It seems to succeed more often than it did yesterday, but I cannot say that there is a cause-relationship there because I've had other occasions where one day it fails all the time, and the next day it works sometimes. Question: How do the root level certs in cacerts get updated? I noticed that some of them, including the GTE cert that a lot of others are based on, expires in early 2007. re: my original posting, can anyone provide insight into why there were two attempts at finding the CERT in the example in the first (successful request) example, and 3 in the second (unsuccesful request)? Thanks Reed Try deleting the certs form your keyfile then re-adding, which should get rid of any dupes. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 October 2006 20:22 To: CF-Talk ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHTTP and HTTPS/SSL and good/bad certs
Hopefully there is an SSL guru out there that can shed some light on what I'm dealing with. I'm trying to use CFHTTP to send and receive XML/SOAP with a Microsoft adCenter API webservice. This all used to work before they switched from HTTP to HTTPS URLs for their API. Even after the initial switch to HTTPS, most of the app still worked - until a more recent change from the adCenter.msn.com domain URLs to newer ones based on the domain of adCenter.microsoft.com. Even now it works on some requests one minute, and fails on the exact same request the next. Sometimes it makes it through a couple of requests and then fails, sometimes it never succeeeds. Today I took the debugging approach of looking at my CF server's JVM logs by turning on the SSL tracing option. Since it's my testing server, I can stop the service, rename the log, turn it on, run a test of a single CFHTTP request, turn it back off and rename the log file. That way I know that everything in the log file is related to that request. What I see is both interesting and confusing. All of the certs are imported as soon as I do the CFHTTP, which is how it is supposed to work. I then trace through it's attempt to use a chained (3 levels) cert whose domain matches what I am trying to access, and see it fail with certificate_unknown. It then starts to unwind and does a closeSocket(), IOexception, etc. THEN IT GETS WEIRD. The very next line in the log is another ClientHELLO to the server, followed by the returned ServerHELLO, and a repeat of the attempt to use the 3-level cert, which this time succeeds! Back on my IE screen where the CF script is running, I see the results of a successful webservice call. My first question here is What's up with the 2 calls to the remote server? I only did one CFHTTP - does the code for CFHTTP do an automatic retry? The next question is this: Is it possible that I might have multiple certs loaded into the keystore for the same sites/domains? The most recent certs for the API URLs were loaded in manually with keytool, using the certs obtained from IE when browsing the API URLs. I ask that because when I look at the log, even though the identifying information for the certs are the same in both attempts, the actual keys are different - the dates are different and the modulus info is different. Could it be that my keystore has dupes in it and that some of them are actually bad? I tried to use the help info from keytool to see if there was a way, in the case that my cacerts file has multiple certs, to clean it up, but if the answer was there I didn't catch it. OK, now for the second try - I run the same script again (just hitting F5), and this time it fails with a connection error from CFHTTP. I go and look at the log file, and sure enough there is no found trusted certificate message in it this time. However, when I look for where it sends the ALERT message with the certificate_unknown description, I find it THREE times. Guys, I really to buy a vowel on this one. Maybe all of them. Thanks, Reed BTW - anyone out there using CF or Java to communicate with the adCenter API?! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Debugging SOAP/CFHTTP problems
I'm working on a new app that uses SOAP to communicate with an external site's API. I'm using CFHTTP to send the HTTPS SOAP requests, and am wondering what tools/techniques are our there to do tracing of what HTTP traffic is actually going out and coming into the server, because I'm getting sporadic errors (mostly connection failures and 500 errors) back from CFHTTP. I thought that using IE's Fiddler tool would do the trick and let me see what is going on (am using my desktop PC for the CF testing), but it doesn't show any of the traffic from CF Server. I've tracked down a number of postings on CFHTTP problems, and have used the fixes that they suggest to handle problems with compression, etc., but none fix my problems. What's the best way to get a handle on this? thanks Reed ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CFPOP to pull Microsoft Exchange message attachments?
I'm stuck trying to make this happen. I've used CFPOP a thousand times, but never before on Exchange mailboxes. I can get the message headers information with no problems (so that means that I have the correct servername, username and password), but when I go to pull the attachment on a message that clearly has a filename in the Attachments column of the query returned from ACTION=GETALL, nothing comes back. No file appears in the specified directory, and nothing is in the ATTACHMENTFILES column of the query. Is there something about dealing with Exchange's mailboxes using POP that I need to take into account? Here is the code that is trying to pull the attachment: cfpop action=GETALL name=UploadMessage messagenumber=#emailtest.messagenumber# attachmentpath=D: generateuniquefilenames=Yes server=#url.servername# username=#url.POPusername# password=#url.POPpassword# Ideas, anyone? Thanks, Reed ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Memory problems?
As ar as creating the XML that gets sent out to the webservice, I'm simply using a cfxml variable=mstring blah blah blah /cfxml followed by a call to TOSTRING I ripped out all of the code that created the intermediate query, and so far memory usage is staying under 100mb, as opposed to 1200+ MB that it was doing previously. So I guess it was all of those calls to set the contents of each cell in the query. Which might also point to having debugging enabled. BUT, I thought that I read/heard when CF MX7 came out that the overhead of having debugging enabled was drastically reduced from what it had been in previous versions - that CF was now checking the debugging IP list before storing debugging information during execution, rather than the old method of always storing the info and only checking the IP list at the end of the request to see if it needed to be displayed. Am I imagining that? thanks, Reed Hmm... How are you building the xml doc? If you are appending to it 10 times and not using Java, I believe it creates a new variable every time you append (and most likely it won't be GC'ed until your script has finished running). Calling the GC directly will not always have an effect, as it's not a command but more of a suggesting to the GC to do garbage collection. There are certain flags you can turn on in your config file for the jdk, something like ++AggressiveGC I believe, but I'm not sure if that will help you out. If you are building the string inefficiently, try optimizing that. You also might want to put in a few sleep calls to allow the GC to run. (I've never tried this, but it just might work). Russ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Memory problems?
I have a CFMX script that continually comes close (and sometimes succeeds) in eating up all of the CFMX sever's memory. I've put tracking code in various places to watch the memory stats (using calls to CreateObject(java,java.lang.Runtime).getRuntime() ). I've also tried running (while this script is executing) another page that uses the runtime.gc() call to force a garbage collect, which only has a negligable effect on the memory usage. I can run this on a testing server, to be sure that some other script isn't the real culprit, but see the same results. Here is what the script does: Run a query to determine which accounts need processing Loop over that query (usually about 300 records): 1. Build a 10 line XML doc. Use the same var name for this doc everytime 2. CFHTTP that doc to a website/service, get another XML doc back. 3. XMLParse the returned doc 4. Create a Query var, using the same var name everytime 5. Loop over the parsed XML doc, creating a row in the Query var with about 20 calls to QuerySetCell for each pass over the XML doc. 6. Loop over the Query structure created in step 5, and do 3 CFQUERY INSERTs to a various tables That's it! Note that for each iteration through the main loop I already know how many records will be returned from the website I'm HTTPing to, and I throttle it to only return 200 at a time (ie, I might make multiple passes through steps 1-5 whenever I know that there are more than 200 records to be returned. Note also that I'm still trying to figure out why this was written to even create the intermediate query to begin with (instead of just looping over the XML doc to do the database inserts). Are there any known problems with creating the same query var over and over? Or creating the same XML doc over and over? I've seen this problem with memory being eaten up when I execute a QoQ with the same name over and over (around 1000 times or more), and got around that by using array and list functions instead QoQ table lookups. If this were a normal memory problem then I'd expect the periodic calls for a garbage collection to help out, but like I said, those calls are having just about 0 effect. I'm running the latest CFMX update, and have upped the maxmem for JVM to 1200. I'm going juts on this one, since the script is pretty simple and straightforward - just a lot of looping! I'm looking at trying to break it up, but that's going to take some time. TIA! Reed ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Finding Server IP
I would help us to understand your app if you can give more information on how the remote code is calling back to your site. Are they using some variety of webservices? Reed No, I do not have access to the code in all places .. the code is calling back to me and I want to know what server it's on. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com SiteDirector Shopping Cart Software - Original Message - From: Ryan, Terrence [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, August 18, 2006 9:01 AM Subject: RE: OT: Finding Server IP ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Performance problem
You can easily eliminate the evaluate() as a factor by replacing cfset field = evaluate(resultSet.#ThisColumn#) with cfset field=resultSet[ThisColumn][resultSet.currentRow] but it doesn't look like you're executing that line enough times to account for the performance problem. Reed I have some code that dynamically generates CSV, TAB, and EXCEL (HTML tables) from a query, and it is running pretty slowly. A lot slower than I'd like it to. Essentially, I set a bunch of variables like START_PAGE, END_PAGE, START_ROW, END_ROW, START_FIELD, and END_FIELD that allow me to loop through the query and loop through the list of fields and output the data in the appropriate format. I added some debugging code and generating 124 rows took 19 seconds. Generating 1416 rows took 309 seconds. Which means if someone wants to generate a drop with 5,000 rows, it's gonna take a long freakin' time! It seems like it shouldn't be that slow. It's only writing every 100 rows to disk (the 124 record file was 445KB). And a couple of cflog statements indicate that the file write takes less than a second. Here's the query loop that outputs the rows of data. cfloop query=resultSet cfset fileOutput = fileOutput START_ROW cfloop list=#fields# index=ThisColumn cfset field = evaluate(resultSet.#ThisColumn#) cfif field eq and format eq EXCELcfset field=nbsp;/cfif cfset fileOutput = fileOutput START_FIELD cfif format eq CSV cfset fileOutput = fileOutput csvFormat(field) cfelse cfset fileOutput = fileOutput FIELD /cfif /cfloop cfset fileOutput = fileOutput END_ROW cfif currentRow MOD 100 is 0 cflog text=writing file #now()# cffile action=APPEND file=#application.udf.ROOT_DIR#\tools\entityLookup3\drops\#filename# output=#fileOutput# addnewline=No cflog text=done writing file #now()# cfset fileOutput = /cfif /cfloop I suspect that it's the Evaluate() that's running slowly. Any ideas on how to speed this code up? Thanks! Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using CFQUERY to access DBCC output?
I'm trying to automate some of an application's database maintentance tasks via
a CF script that will check to see if it's time for a defrag, index rebuild,
etc. I know that I can put a DBCC statement in a CFQUERY, but what's got me
scrambling is how to retrieve any output that the DBCC might generate. If I
feed CFQUERY something like
DBCC SHOWCONTIG ('activitylog')
I'd like to be able to get at the 10 or so lines of of output that it would
normally generate interactively. But no result set is even created by such a
query, and I cannot see how to get to the data. I've tried variations of
EXECUTE and subqueries, all with no luck. Is this an impossible dream?
thanks
Reed
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250011
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: i don't want cookie.jsessionid...
Any new news on this topic? I'm running into the same thing - my app serves up content to a customer's webpage, and they don't want to see cookie's being set on their visitor's machines. I've turned off (in app.cfm) sessionmanagent, clientmanagement, and set clientcookies to NO. I've made sure that the J2EE session var option is not checked in CF admin. I can watch the http traffic with Fiddler and see the JSESSIONID cookie being set (but no CF cookies). Any way to stop this from happening? thanks -reed On my local machine CF sets the cookie.jsessionid, but it doesn't on the test or live boxes. The first time i request a page the cookie doesn't show up in the debug output, but i can read it using javascript. On subsequent requests it does appear in cf debug output. I have the Use J2EE session variables checkbox unchecked. Is there anything else i need to do? Version: 6,1,0,63958 Edition Enterprise (DevNet) Operating System: Windows XP OS Version: 5.1 Cheers Bert ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247529 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Statistical computations in CF?
I'm working on an app that pulls together a client's data for a given period of time, and produces a forecast for what future data might look like. I've been using the CFLIB forecast() function written by James Stevenson, but am interested in hearing about any other tools that are either CF-based or could be easily integrated into a CF app. The CFLIB forecast() function does a least-squares analysis, but doesn't seem to do a great job on data which has a definite pattern but is not very straight-line. tia, Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
7.0.1 Updater Exits After 2 seconds
I *know* that I saw a discussion on this about 6 weeks ago, and have does searches till I'm blue in the face with no luck, so pardon this re-asking of the same question (whose answer didn't matter much to me then but does now): I just finished rebuilding my laptop, with XP PRO and SP2, and then installed the CF MX7 CD, all with no problems.When I ran the 7.0.1 updater, it ran for about 2 seconds and the exited, with no error messages. Rebooting doesn't help. I turned off the SP2 firewall, that didn't change things. I remember reading about this, and that the answer was one of those oh yea, of course type of things. thanks Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 7.0.1 Updater Exits After 2 seconds
Thanks Dave - but before making the original posting I looked at the index for every day back to May 1, and didn't find anything that even remotely seemed to apply, and just did it again back to June 1 and still don't see anything. Searches for various combinations of 7.0.1 updated installation problems failure came up lots of hits, but none with what I'm looking for. So, that time I need to buy a vowel in order to figure out the answer, because it's probably deep inside some other discussion that was going on under an unrelated topic heading. Thanks! Reed was 3-4 days ago, shouldnt be hard to find ~Dave - formerly known as the disruptor~ From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Monday, June 19, 2006 7:51 PM To: CF-Talk cf-talk@houseoffusion.com Subject: 7.0.1 Updater Exits After 2 seconds I *know* that I saw a discussion on this about 6 weeks ago, and have does searches till I'm blue in the face with no luck, so pardon this re-asking of the same question (whose answer didn't matter much to me then but does now): I just finished rebuilding my laptop, with XP PRO and SP2, and then installed the CF MX7 CD, all with no problems. When I ran the 7.0.1 updater, it ran for about 2 seconds and the exited, with no error messages. Rebooting doesn't help. I turned off the SP2 firewall, that didn't change things. I remember reading about this, and that the answer was one of those oh yea, of course type of things. thanks Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 7.0.1 Updater Exits After 2 seconds
Well, I guess it was the Win2003 in the subject that was avoiding my searches. Thanks for the pointer Dave. But there's still a glitch - the XP window to tell DEP to keep it's fingers off requires that you give it the filename of the app - but the only filename available is for the Install Anywhere extractor, not for the CFMXInstaller, which is what is really tripping the DEP. I tried pointing it to the updater exe, but that doesn't solve the problem. Typing in CFMX7installer just causes it to try and find a file with that name. Reed on the 15th http://www.houseoffusion.com/cf_lists/messages. cfm/forumid:4/threadid:46374 ~Dave - formerly known as the disruptor~ From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Monday, June 19, 2006 8:15 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: 7.0.1 Updater Exits After 2 seconds Thanks Dave - but before making the original posting I looked at the index for every day back to May 1, and didn't find anything that even remotely seemed to apply, and just did it again back to June 1 and still don't see anything. Searches for various combinations of 7.0.1 updated installation problems failure came up lots of hits, but none with what I'm looking for. So, that time I need to buy a vowel in order to figure out the answer, because it's probably deep inside some other discussion that was going on under an unrelated topic heading. Thanks! Reed was 3-4 days ago, shouldnt be hard to find ~Dave - formerly known as the disruptor~ From: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Monday, June 19, 2006 7:51 PM To: CF-Talk Subject: 7.0.1 Updater Exits After 2 seconds I *know* that I saw a discussion on this about 6 weeks ago, and have does searches till I'm blue in the face with no luck, so pardon this re-asking of the same question (whose answer didn't matter much to me then but does now): I just finished rebuilding my laptop, with XP PRO and SP2, and then installed the CF MX7 CD, all with no problems. When I ran the 7.0.1 updater, it ran for about 2 seconds and the exited, with no error messages. Rebooting doesn't help. I turned off the SP2 firewall, that didn't change things. I remember reading about this, and that the answer was one of those oh yea, of course type of things. thanks Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What determines session inactivity timeouts?
OK, I did what I should have done before starting this thread, which was to rig up a test case to see what happens. Pretty interesting results. It appears that CF keeps the session vars alive during page processing, even if there is no activity with those vars. Here is what I did: In Application.cfm: cfapplication name=test clientmanagement=no sessionmanagement=yes setclientcookies=yes setdomaincookies=yes sessiontimeout=#createtimespan(0,0,1,0)# applicationtimeout=#createtimespan(0,1,0,0)# loginstorage=session In Test.cfm: cfobject type=JAVA name=obj class=java.lang.Thread action=CREATE cfdump var=#session# cfset session.x=1 cfdump var=#session# #timeformat(now(),HH:MM:SS)# cfset obj.sleep(7) BRBR #timeformat(now(),HH:MM:SS)# cfdump var=#session# HERE IS WHAT HAPPENED: First time I executed test.cfm, I got three CFDUMPS of the session scope: dump 1 had no vars in it, dumps 2 and 3 showed the var I set in my code. Since there was a 70 second pause between 2 and 3, and the session var timeout was set to 1 minute, that tells me that CF kept the session vars alive. I waited 2-3 minutes and reran, with the same output - which shows that CF did in fact destroy the session vars after the 60 second timeout occured between the two page requests. Then I ran another variation: I ran the script again, and then when it finished I reran it immediately, and guess what - the session var was gone! That makes it look like CF kept the session var alive during the script's execution, even though the timeout was reached, but deferred destroying the var until the request completed. So I did another scenario: ran the same test in 1 browser, but with the pause set to 2 minutes, and immediately in another browser window ran a script that simply did 2 CFDUMPs of the session scope with a 60 second pause between them. The second window (which began and ended during the first window's 2 minute pause period), showed the session var to be alive on both dumps. I refreshed it's screen immediately, and when it finished the session var was gone. This tells me that when CF deferred destroying the session var during the first script's execution, it kept the var alive for all other requests, not just for the currently executing one. Final test - I changed the second script's pause to be 2 minutes, and waited about 10 seconds after running the first script before starting the second, to see what happens to the session vars for the second script when it it still running after the first script ends. The session vars for the second script were still there on both dumps, which is pretty interesting because it said that when CF saw that the second script was running it kept the session vars alive, even though it never touched any of them. But the immediate rerun of the second script showed that the vars were gone as soon as it had finished. Bottom line is that session vars don't dissapear out from under you during script execution, but when the lifeguard blows the whistle the session vars are gone as soon as the last guy is out of the pool - unless someone new jumps into the pool and actually touches a session var. Whew Reed It is possible that the delay could occur while processing a single CF tag, therefore, you would have no way of touching a session variable. For example, the session timeout is 5 minutes. On the page, you have a CFFILE tag that save a huge amount of data to a text file. It could take 7 minutes to save the file. By the time the CFFILE tag completes, the session has expired. There is no way to hook into the CFFILE tag and have it restart the session timer. I just wonder if the session timer is reset after EVERY session variables read/write or only once when the page is requested/completed. There is probably an easy way of testing this by setting a session variable, sleeping the thread for several minutes (to let the session timeout), then trying to read the same session variable and see if it still exists. M!ke -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 9:00 AM To: CF-Talk Subject: RE: What determines session inactivity timeouts? As developers do we have access to these session variables? If so why not just update them manually every so often during page processing? You could also over ride the system time out with a cfsetting tag for these specific pages since you know they may run long. Shawn McKee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
What determines session inactivity timeouts?
What started out as a simple exercise has gone crazy. All I wanted to do was to give my users a warning of impending session timouts and give them the opportunity to refresh the session. I tried using the CF_SessionWatch tag but it's a bit too simplistic - I used it to setup a JS call to set a timer for a few minutes less than the session timeout value, but if the user takes longer to respond (maybe they walked away from their PC) than the remaining session timeout, then when the user comes back and clicks on the yea I want to keep working option, the resulting attempt to touch a page in the app (to reset the session timeout) ends up causing the login page to come up (since by then the session vars have timed out), so now the user is real confused (because he has his original page, as well as a login page in the pop-up window). So, I added a bit more JS so that when the warning pop-up comes up, it first sets a timer for about a minute less than the amount of remaining session var time, and if *that* timer fires, then I log the user off and force the opener page to go back to the home page, and do a window.close() to get rid of the pop-up window. Sounds fine, right? Here's my concern - what if the page that is executing takes longer to execute than the session timeout value? Our server is set for 1 hour max timeout, and some of the data loading screens can take longer than that to run, especially when the CF or SQL server is loaded. I don't want to have it whacked in the middle of it's work by the session timeout checker. So this leads to my initial question, which I've never thought about before even though I've been using session vars for years and years - what exactly constitutes inactivity in CF's perspective? What if a long running page doesn't touch any session vars for a period of time greater than the session var timeout? Is session activity defined by a request being active, or by the actual touching of a session-scoped var? Do I need to have potential long-running pages periodically touch a session var? I thought about moving the code for setting up the JS timers from the application.cfm file to orequestend.cfm, which wouldn't start up the timers until the page actually completes, but then that has a bunch of problems with respect to errors and CFABORT. Am I making this harder than I need to? thanks Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238735 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Page Won't Stop Executing
Am I in the middle of a brain-burp, or is it not in fact the case that CF used to stop executing the current page if the user hit their stop button and opened a new CF page? I have pages that continue to execute even after the user hits STOP and REFRESH - so now I have a couple of copies of the same killer page executing at the same time! Am I remembering things wrong, or is this how it is supposed to be? If the latter, then what actually stops a page from executing before it finishes on its own? That sound you hear in the background is the the heap memory on my server slowly being eaten away. My 6th sense sees out of memory and ringing phones in my future. thanks Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238078 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Page Won't Stop Executing
Thanks, I was afraid that I was working with old recollections. I've been looking at both FusionReactor and SeeFusion, so now it's time to move forward. I like FusionReactor better because it handle all of the installation itself. SeeFusion is nice because it shows more info on queries, but their installation process is crap - virtually nothing is automated. So I guess the bottom line is that with any of the CFMX versions there is no protection from users getting impatient waiting for a page that legitimately takes a few seconds to process, and repeatedly hit REFRESH? Reed I'm not sure about that either. As for stopping a long running request, use the CF Admin option to stop a page running longer than x seconds. There's also Fusion Reactor or SeeFusion, which can both selectively terminate running CF requests. On 4/19/06, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 19 April 2006 14:43, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Am I in the middle of a brain-burp, or is it not in fact the case that CF used to stop executing the current page if the user hit their stop button Don't recall CF6 ever being able to do that. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238090 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Page Won't Stop Executing
I realize that the STOP alone doesn't have an effect on the currently executing page - but didn't CF (pre-MX I guess) used to stop the current request when it saw a new request from the same browser? I'm pretty sure that I used to be able to stop runnaway pages by hitting STOP and then browsing to another CF page - but maybe I'm just halucinating. Reed, Am I in the middle of a brain-burp, or is it not in fact the case that CF used to stop executing the current page if the user hit their stop button and opened a new CF page? I have pages that continue to execute even after the user hits STOP and REFRESH - so now I have a couple of copies of the same killer page executing at the same time! Am I remembering things wrong, or is this how it is supposed to be? If the latter, then what actually stops a page from executing before it finishes on its own? Clicking Stop in a web browser has never stop the server processing a request, all it does is tells the browser to stop listening for a response. In order to actually kill that process, you'd need access to the Java threads--or use a tool like SeeFusion (http://www.seefusion.com/) which will allow you to kill a running process. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: adobe certification site
Well I'm having a different problem with them - I got the email notification from Adobe, and went to their site and filled out the account activation form - and the next thing it did was to tell me to log in with my new username and password. Problem is, it never asked for this info to be specified, and the info from my Macromedia certification access doesn't seem to work. What are you guys using for access info on the Adobe site? Maybe it's just one of those days, Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading JVM to 1.4.2_09
Just to be sure (and safe - we live and die on XML here) - as long as I stick with upgrading to 1.4.2_09 the only known gray area is LDAP, right? XML is OK? I'll try to get a statement out of the Adobe/MM support person about official support for LDAP with 1.4.2_09, since it sounds like others have seen problems with the _06 through _08 versions. Aaaand I'm late to another thread. Sorry, didn't see your question earlier. Scott, Java 5 is incompatible with the Apache Axis stuff that's built into CF. Basically, you can kiss your web services goodbye if you upgrade past 1.4. That fact is pretty well confirmed. I heard (but have no proof) that people were having trouble with XML and LDAP as well. I did it to my test server a while ago, and it was fine. Everything was running great, but I wasn't doing anything with XML, web services, LDAP or anything special, really. -nathan strutz http://www.dopefly.com/ On 4/5/06, Scott Stewart [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Upgrading JVM to 1.4.2_09
We've been having a rash of JVM crashes (1 per day usually) for the past 7-10 days. That's better than what it was before then (4-5 per day). We opened a ticket with Adobe/MM and made some jvm.config changes they suggested for heap memory handling (and also moved the client var database from Access to SQL Server), and that changed the frequency and nature of the crashes. The JVM crashes we're seeing now have the JVM apparently running out of memory (NT memory, not heap memory) and stopping in it's tracks. The latest suggestion from Adobe/MM is to upgrade to version 1.4.2_09 of the JVM, since this could in fact be a JVM bug. Anyone out there done this and know of any gotchas before I do this? TIA, Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236993 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WOT: graphical representations of passcodes
Sorry for this WOT question - I was getting ready to Google for sources of code (hopefully CF or CF-friendy) to produce the graphics that are used to ensure that a human is at the other end of an http connection (you know, the one's that require you to enter the number or character sequence being displayed next to the text input box) - and realized that I have no idea as to what the h*** they are called! Some kind of a glyph I thought, but my feeble attempts at the googling were too generic and produced way too many search hits. But I'M SURE that a few weeks (months?) ago I saw someone on this list make mention of some CF code for doing just this. Anyway, TIA for the answer! Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Host recommendations
Try www.IXwebhosting.com - they have good prices, good service - in fact the only thing I've found lacking was that they don't plan to move from CF5 anytime soon! -reed We need cf server 5, crytaltech does not offer it. Has anyone dealt with hosttone.com or have a cf 5 server recommendation. Thanks everyone Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: HomeSite+ 5.5 and access violations
It looks like this problem stems from not having write-privs to the HomeSite+ folder in Program Files. Once I had write access (so that I could try turning off tag completion as someone had suggested doing), the problem went away (even before I had a chance to give that idea a try). Hopefully it will stay fixed. Thanks for the ideas, they were a big help, -reed Thought I was losing it, but this seems reproducible. I don't find any mentions in the archives, or anywhere via Google, so here goes: Anytime I start typeing a CFIF block where there is a function call whose argument is in quotes, I get an error Access Violation at address 00403A33 in module Homesite+.exe at address as soon as I try to space past the closing double-quote in the argument, but only when it is typed on the same line. Example (I'm using len() for the function, but it doesn't matter what the function is): CFIF A IS B works CFIF len(a) IS B works cfif len(a gets the error as soon as I enter the space following a But this works, ugly as it is: cfif len(a IS B Note that in that last example, I can get the error when I hit the space after the a, and also after typing IS I did more checking, and it's not really a function of being in the middle of entering a CFIF block. The same thing happens, for instance, if I'm in the middle of trying to type cfset a=len(b) This all happens whether I am typing the text in from scratch, or editing existing text. Sure looks to me like it's falling apart trying to parse the structure of the statement I'm in the process of typing, but I've not run into this one before. Thanks everyone, -reed Any ideas out there? I don't see any fixes out there from MM. I just installed this copy of HomeSite+ a couple a week or two on this PC (Windows XP-PRO), using the version that was on the Dreamweaver MX2004 Devnet CD). It was installed under the admin account on this PC, since at this site I don't run with admin privs. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230114 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
HomeSite+ 5.5 and access violations
Thought I was losing it, but this seems reproducible. I don't find any mentions in the archives, or anywhere via Google, so here goes: Anytime I start typeing a CFIF block where there is a function call whose argument is in quotes, I get an error Access Violation at address 00403A33 in module Homesite+.exe at address as soon as I try to space past the closing double-quote in the argument, but only when it is typed on the same line. Example (I'm using len() for the function, but it doesn't matter what the function is): CFIF A IS B works CFIF len(a) IS B works cfif len(a gets the error as soon as I enter the space following a But this works, ugly as it is: cfif len(a IS B Note that in that last example, I can get the error when I hit the space after the a, and also after typing IS I did more checking, and it's not really a function of being in the middle of entering a CFIF block. The same thing happens, for instance, if I'm in the middle of trying to type cfset a=len(b) This all happens whether I am typing the text in from scratch, or editing existing text. Sure looks to me like it's falling apart trying to parse the structure of the statement I'm in the process of typing, but I've not run into this one before. Thanks everyone, -reed Any ideas out there? I don't see any fixes out there from MM. I just installed this copy of HomeSite+ a couple a week or two on this PC (Windows XP-PRO), using the version that was on the Dreamweaver MX2004 Devnet CD). It was installed under the admin account on this PC, since at this site I don't run with admin privs. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230010 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF performance tuning: CFTRY/CFCATCH vs CFERROR? What about excessive CFOUTPUTs?
Hello all - I've googled the heck out of this topic, and there are more opinions than I can count! Is there any definitive info on whether it is more efficient to put a CFTRY around an entire page's contents, with a CFCATCH at the end to trap errors, or to simply have a CFERROR page specified in application.cfm (and only use CFTRY/CFCATCH in specific pieces of code that might need special error handling procedures)? In other words, what is the performance cost for code that is executing within a CFTRY block? I'm interested in this because the CF server that I've just recently started working with seems to be having periodic performance problems (still trying to determine what periodic actually means), and noticed that a lot of the application's pages have a single CFTRY around them. I've also noticed excessive use of CFOUTPUT tags. Is it worth consolidating these to help performance? I've seen as many as 5 in a block of code that's only 30 lines long, where only 1 was needed. What about excessive # marks? It makes me crazy to see code like cfif #somevariable# eq yes ... But does that also make CF crazy? I'd think that this goofiness would not actually filter down to the Jrun code that actually executes, right? Any good MX7 performance/tuning papers running around? I checked on the macromedia website, and with google, but only found info on older versions. TIA for any hints! Reed ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227949 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] Credit card processing companies
I'm hoping that the collective brainpower out there can come to the rescue! We've been running into problems with our current processor (Suntrust) with terminal-based processing. We have a terminal on a dedicated analog line that works fine, and pulled our spare out of the close to test it out prior to taking our bookstore on the road (where we would need both machines in operation). Life has been He** since then. The actual processing seems to be done by First Data. Their tech support guys have repeatedly downloaded the wrong code into both machines, changed our account settings (for a while we couldn't process Discover cards, and for a while neither machine worked). They've sold us a new machine because they said that our standby machine was busted, and now they're saying that we need new phone lines. We've started looking at finding another company to replace SunTrust, but it seems like everyone we talk to is using FirstData. We used to use PaymentTech, and were very happy with them, but changed to SunTrust at the recommendation of a software vendor that said (prior to my being here) it was necessary to make such a change so that their on-line processing software would work (it never did). We checked back with PaymentTech this morning, and found out they are now using FirstData as well. Any advice out there, either on dealing with FirstData (maybe some good contact info) or another card processor? Like I had nothing else to do with my time that fight another fire! Thanks everyone, -reed ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Print to index cards
Check out the CF_AveryRTF tag, it will generate RTF docs formatted for specific Avery layouts, which would include their index card stock. You can also do your own custom layouts. -reed -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Saturday, January 08, 2005 7:27 AM To: CF-Talk Subject: Print to Index Cards Hi folks... need a little help I'm trying to take database output of varying length and print out on 3x5 index cards on a web page. The issue is knowing when the output needs to flow to the next index card so that titles can be repeated... Any thoughts ??? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMAIL and Crystal Tech webhosting?
Hi everyone - this one has me stumped. I'm hosting a CF site on Crystal Tech, and added a simple page that allowed a visitor to send a hey look at this page email to a friend. I already had a contact us page that sent me an email via CFMAIL which worked fine. The new page only works when the destination email is in the same domain as the website. I've tried all combinations that I can think of in terms of SMTP server name, username, password in the CFMAIL tag, with no luck. I checked their knowledgebase and modeled my CFMAIL tag info after the PHP example, still no luck. I've forced the FROM address to be a legal address on my domain, still no luck. I've posted a ticket with Crystal Tech but am still waiting for a response, and was really hoping to get this simple little page up quickly! Any Idea? Thanks, -reed ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SP to find all triggers in a database?
Howdy - I've inherited the database (SQL Server 2000) from ^*^*, and it has about a zillion tables in it. I need to make some changes to the app that goes with it, but want to find out if there are any triggers out there that are going to do things behind my back. Is there an easy way to do this without going through each and every table one at a time? I cannot find any SP_ procedures to do this. thanks everyone, -reed ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182854 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SP to find all triggers in a database?
Thanks for the postings, taht works great - narrows things down to about a dozen tables that I need to look at. Is there a way to programatically get the actual trigger code for a given trigter? I've followed the various links from sysobjects for the triggers, but none lead to the actual code. thanks for the help, -reed This should tell you if you have any: SELECT * FROM sysobjects WHERE (xtype = 'tr') Rey - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 1:42 PM Subject: SP to find all triggers in a database? Howdy - I've inherited the database (SQL Server 2000) from ^*^*, and it has about a zillion tables in it. I need to make some changes to the app that goes with it, but want to find out if there are any triggers out there that are going to do things behind my back. Is there an easy way to do this without going through each and every table one at a time? I cannot find any SP_ procedures to do this. thanks everyone, -reed ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182872 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity indexes - excluding files/directories?
I thought that I once read that when you setup the index for a collection (via CF tags, not the administrator, since this is a hosted account and I don't have access to CFADMIN) you could tell it to exclude specific directories from being searched.Now that I'm trying to do it, I cannot find anything like that - is it possible?I have some files on the site that are not ready for public consumption and so I don't them showing up in search hits. What I'd like to do is to just put them in a testing directory so that people that are reviewing them can access them.As for specific pages that are no longer part of the site and that I no longer want searched, I could just change their extension by adding an X at the end (CFMX etc) and that would keep them out of harm's way until I decided for sure that they were not going to come back to life, but it's the exclusion of entire folders (where I have to use the correct extensions so that they can be processed correctly and reviewed by people) that has me baffled. Thanks for the help, -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Handling common access to pages and images for both http/https pages?
Before I go off in the wrong direction on this, I figured I'd see what others are doing...I'm building a couple of simple secure (https) pages on my site using the shared certificate provided by the hosting service (Crystal Tech).The URL that they provide point back to the same root that the rest of the website uses.I haven't had to do much in the past with https pages, and what I have done was the result of a lot of fumbling around. My pages all use a couple of common INCLUDE files for the top and left nav areas, and onrequestend.cfm for the bottom nav area, which include references to images and (obviously) other pages on the site. When I render the pages that are being called via https, I need for all external references on that page to be https, right?Otherwise the user will get warnings from the browser about mixed pages.What I'm thinking of doing is having the application.cfm look at the current url to see if it begins with http or https and then save that in a variable, and change all of the references in the INLCUDE files to use that reference. The kicker is that I don't want to have to use full http://www.mysite.com/page.cfm or img src="" references to the rest of the site, because that makes it a royal pain when I want to copy the files to/from a testing area, because they would have those hard coded references to the production site in them. What about references to external pages that reside on other sites?Can I do that from a page that was called via https?I don't think I can use a link like https://www.weather.com on my https page!Does that mean that all references from my page have to remain within my site? All advice and hints appreciated! Thanks, reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Losing Form Scope
From your code segment it looks like you didn't define an enctype, so its probably defaulting to using URL variables instead of FORM fields. Try dumping the URL scope cfdump var=#url# And see if your fields show up. To fix, try putting enctype=multipart/form-data into the FORM tag and see what happens. -reed _ From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 9:35 PM To: CF-Talk Subject: Losing Form Scope I have a form that is submitting to an action page, but for some reason when the action page loads the form scope is gone, so when I look at the debugging information under Scope Variables the entire Form Fields: section is not even listed. This happens on the live CF5 server and my local CFMX development server. form action="" method=post input type=hidden name=CorpOK value=true input type=hidden . input type=submit value=YES - Extend the Ad Account class=button /form Has anyone seen anything like this before? Thank you, Stan Winchester _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
server-side forwarding in CFMS
Maybe I've imagined this, but I thought for sure that when MM went over the features that were to be in CFMX a while back, ASP style server forwarding was included.This would be a replacement/alternative to CFLOCATION which would not make use of client-side redirection, but would do the actual forwarding on the server.I've searched the docs and cannot find any reference to this, and how I need it.Anyone know anything about this?If I write an ASP script that the CF script would CFLOCATION to, but that kind of defeats the whole purpose of not making the additional trip to the client, and also the need to make it impossible for a user to highjack the access information that I'm passing along from the CF script that is executing to the site that it needs to transfer control to. thanks! -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: get refering url
The other problem is that using the referer URL is becoming less and less useful because software firewalls such as NIS block this information unless the user specifically configures NIS to let information be passed for your site's URL.I'm going through this right now with a subscription site that validates access based upon the referer URL, and some of my users cannot get to it because NIS on their PCis blocking that information unless the people configure NIS to allow it, which is a real pain since most people will get the failure and start sending me emails instead of clicking on the link that says having problems? click here.What a mess.If you want the write-up I have on configuring NIS, let me know. -reed cgi.HTTP_REFERER does not seem to pick up domain names outside of the web site it runs from. I.E. if somone comes from google.com to my web site i cannot use cgi. HTTP_REFERER to find out where they came from.The variable is blank. I was hoping is would be google.com. Anyone know of a way to get the domain name of where the user is coming from? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: session var problems with Mac uses?
OK, I found the problem - turns out that IE on the Mac put a trailing space in one of the form fields: input type=hidden name=command value=LOGIN results in form.command being LOGIN and so I needed to change cfif form.command IS LOGIN to be cfif trim(form.command) IS LOGIN for things to work.What a pain! thanks for all the ideas along the way, -reed Here's the scoop:I just put a logon page on one of the sites that I manage, so that they can have a members only area.Simple logon based on member id- no password or anything that complex (they cannot figure out how to tell people their passwords at the moment, and it's just a gateway to keep the general public out). Session var tracks whether the user is logged in and what the member ID is. Works fine from a PC Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, which is that after entering their member ID, they get the logon screen again, which means that the session var with the member id isn't there.I gave them each a page to use that would dump out all the url/session/cookie/application/cgi vars, and told them to hit it twice in a row (so that I could see if the cf tokens stayed the same, so I could see if cookies were being set).What I see is that cookies are in fact being set, because for any of the users, all of their info has the same CF token info. It doesn't look like the session vars are keeping their values.The form processing page stored the member id and name in 2 session vars, and the CFLOCATIONs back to the members-only home page.That page always checks to see if the user is logged in by checking for a non-zero member ID, and if the user is not logged in then puts up the logon screen.For some reason when Mac users do this, the session var values being set on the form processing page are not there when the home page CF script is processed. Stumped.Any ideas? Thanks, -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session-Based CFC Usage Across Clusters
Barney, >From reading your post, your solution sounds more like a global UDF whose methods are called with the data stored in the client scope than a true flyweight pattern (e.g., a shared, type-specific object for all users). But after reading this thread we were testing some ideas. All of our CFCs use private variables (variables. not this.) and support two related methods: setFromStruct and getAsStruct.setFromStruct takes a structure, examines its key names, looks for any similarly named setters (e.g., key is name maps to setName) and calls the appropriate methods.getFromStruct simply returns variables. We wddx'd getAsStruct and saved the result to the client scope. On the next page hit, we retrieved the client variable we had just saved. We have an application scoped object called ObjFactory, which has the method getObject(typeName, struct).getObject basically creates an object of the specified typeName, initializes it and calls its setfromStruct(). The calling template sets a request scope variable to the object returned from ObjFactory.getObject(). (e.g., cfset request.myObject = objectFactory(com.myObject, client.wddxifiedData) /) At that point, we have completely recreated the state of the user-specific object and can treat it as a proper object. Some adjustment would need to be made to handle public object variables (this. scope), but it's not a big deal.Develoeprs need to use the Bean-style convention of getVariableName/setVariableName.And some consideration needs to be given to non default constructors (we always use an init() method that returns this). What do the forum members think of this approach? Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up
Simon, It might help to cfset queryName = / at the point in the page where you no longer need the query named queryName. But I've been using CF since version 2 and never had that error.You have a REALLY big query (maybe the selection criteria could be more specific) or a really small JVM memory space (increasing mem space might help). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: searching similar words
MSSQL, and some other SQL databases, provide the SOUNDEX function, which would help you to do matches against words that have a similar pronunciation. Hi all, I have a question for you. I'm building an online dictionary with CFMX and Access 2000. I'd like to do what Webster's (http://www.m-w.com) does, which is: if you search for kaflooey, the results page tells you there's no such entry in the dictionary, and they gives you a list of 10 possible alternatives, similar in spelling (e.g., kerflooey). How could that be achieved in CFMX? Any code, tag, or ready-made module that would do something like that, which could be added to a dictionary search? Or, any ideas/pointers/suggestions on how that functionality could be achieved? Thanks in advance, Roberto Perez [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Urgent help needed Please
If you can see the CFxxx markup tags when you view source, then that means that CF is not running on the server, or that it has associated .CFM file types with something other than CF.Here's a quick test: In your CF action page, enter this code before the CFQUERY tag: Hello! cfabort Hello Again! What is rendered on the screen?If you see the Hello Again then you know for sure CF is not running.If you dont' see the first Hello! then I don't think that your form is pointing to the action page that you think it is! Hope this helps, -reed Your method should be post. What's your action? The action should be a page address. _ From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED] Sent: Friday, 23 July 2004 3:45 p.m. To: CF-Talk Subject: Re: Urgent help needed Please Hi Matthew, Thanks for responding. I can see the cf markup when I submit it to the action page. Action page does come up but instead of submitting the data to the database, it shows like a normal html with all the queries. My form action atribute is post. Regards Sangeeta _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: session var problems with Mac uses?
Thanks for the ideas, here are some answers to them: Session vars are already created before getting to the form processing page (where the CFLOCATION is used).They are created on the FORM page itself (actually the application.cfm will get them created via CFPARM). The versions of software on the Mac seems to vary.I think that one of the Mac users said that they tried Safari and it worked fine, so this may be an IE/Mac problem, but I cannot think of anything for them to check, since the usual suspect (cookies being disabled) is not the case, since the CF tokens being reported from the browser are the same from one page to the next, that would mean that cookies are ok. Server is running CFMX. I'm not doing anything with the headers. Thanks, need more ideas! -reed At 09:26 PM 7/22/2004, you wrote: Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, I would be surprised if this was a Mac issue. Rather, it is probably IE on Mac, or Safari, or Firefox. The Mac OS itself does not have any typical settings which would affect a browser's ability to handle cookies. It doesn't look like the session vars are keeping their values.The form processing page stored the member id and name in 2 session vars, and the CFLOCATIONs back to the members-only home page.That page always checks to see if the user is logged in by checking for a non-zero member ID, and if the user is not logged in then puts up the logon screen.For some reason when Mac users do this, the session var values being set on the form processing page are not there when the home page CF script is processed. It helps to know versions of things. CF5 behaves differently than CFMX, and IE on Mac OS 9 behaves differently than IE under Mac OS X. I assume you are running CF5. Be careful using cflocation on pages that set cookies, because the cookies will not be set under CF5. Creating a session variable for the first time is the same as setting a cookie. So if you have a cflocation on the same page that sets the session variable for the first time, the session variable will not be retained to the next page because the cookie will not make it back to the browser. I belive this behavior was changed (fixed) under CFMX. So, experiment with the use of cflocation to see if that helps. The other tags to check are cfhtmlhead and cfheader. Using cfheader on the same page as cflocation can lead to problems. Most people do not use either of these tags. Good luck, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
session var problems with Mac uses?
Here's the scoop:I just put a logon page on one of the sites that I manage, so that they can have a members only area.Simple logon based on member id- no password or anything that complex (they cannot figure out how to tell people their passwords at the moment, and it's just a gateway to keep the general public out). Session var tracks whether the user is logged in and what the member ID is. Works fine from a PC Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, which is that after entering their member ID, they get the logon screen again, which means that the session var with the member id isn't there.I gave them each a page to use that would dump out all the url/session/cookie/application/cgi vars, and told them to hit it twice in a row (so that I could see if the cf tokens stayed the same, so I could see if cookies were being set).What I see is that cookies are in fact being set, because for any of the users, all of their info has the same CF token info. It doesn't look like the session vars are keeping their values.The form processing page stored the member id and name in 2 session vars, and the CFLOCATIONs back to the members-only home page.That page always checks to see if the user is logged in by checking for a non-zero member ID, and if the user is not logged in then puts up the logon screen.For some reason when Mac users do this, the session var values being set on the form processing page are not there when the home page CF script is processed. Stumped.Any ideas? Thanks, -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server Errors - CPU spike swsoc.exe
...i've had similar issues, and eventually narrowed it down to ODBC connections with Access databases (two in particular are connected with queries)... ...from what i can ascertain, the connection reset by peer error occurs when the access database doesn't respond in a timely fashion... ...and in my case, it usually happens when the CF Server attempts to automatically verify the existence of the databases every night... ...when i repair all the Access databases on a regular maintenance cycle, the error disappears for an undetermined period of time, and then reappears... ...i had given up trying to find a solution, and was hoping that a planned transition to new hardware would eliminate the problem... ...if you're not running Access DBs i'd love to hear the details of your setup... thanks... ...dave - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Date: Wed, 7 Jul 2004 13:48:53 +0100 Subject: RE: Server Errors - CPU spike swsoc.exe To: CF-Talk [EMAIL PROTECTED] Hmmm...well some of these errors are false positives and can be safely ignored...have you tried upgrading to the latest version of the JVM/JRE? Also is this server fully patched - especially with the Database driver updates. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 13:45 To: CF-Talk Subject: Server Errors - CPU spike swsoc.exe I normally wouldn't post this, but I'm having some crashing server issues. I've optimized the CF settings, but it seems that the ColdFusion MX ODBC Server is eating up resources on our server until it crashes. (Windows Task Manager - Processes)Here's an error I got in the event viewer. I've also done a stack trace dump when starting the server and got the attached results. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Control over HTTP_REFERER?
I've waited to the last minute on something that I thought was going to be simple. I'm working with a local genealogy society to allow their members to access a research facility that the society subscribes to.The rules of the game are that the society has to authenticate the users and limit the access to just their members - they cannot open it up to the world.The research facility uses the http_referer variable to determine if the request is coming from the society's website. Well, as far as I can tell, any means I use of sending the logged-in and properly authenticated user to the research facility's site (HREF, CFLOCATION, response.redirect) is going to have an http_referer value of the user, not the website.Since the users can come from anywhere (home, work, library, Aunt Matilda's, etc etc), there's no way I can see to send a list of all possible user IPs to the research facility. Any ideas on how to get out of this pickle?I don't think that CFHTTP is an answer, since there is going to be a lot of cookie, _javascript_ and image traffic between the user and the research site.I'm supposed to have this up and running on 1-July! Thanks -reed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
