RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source..
I'll keep the replies to the list so that everyone can learn. The first error in your log goes: Starting Macromedia JRun 4 (Build 47304), default server Unable get IP addresses from a local host, defaulting to 127.0.0.1. 07/25 17:02:17 error Exception thrown in operation init [1]java.net.UnknownHostException: dlappserver3 at java.net.InetAddress.getAllByName0(InetAddress.java:566) at java.net.InetAddress.getAllByName0(InetAddress.java:535) at java.net.InetAddress.getAllByName(InetAddress.java:528) at java.net.InetAddress.getLocalHost(InetAddress.java:718) at jrunx.util.NetUtil.resolveIP(NetUtil.java:28) at jrunx.cluster.ClusterManager.init(ClusterManager.java:66) at java.lang.reflect.Method.invoke(Native Method) Blam. JRun is dead. This means your local host information does not match the DNS name information for that IP address. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:09 AM To: CF-Talk Subject: RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. k.. attached is my cfserver.log It contains TONS of errors trying to start JRUN none of them make sense to me.. The mandrake install has a whole bunch of errors too but it runs.. I posted this problem on the cf-linux list and for some reason i did not receive a reply.. On Fri, 2002-07-26 at 07:55, Jesse Noller wrote: What's the error logs say? Especially the cfusion.log in the logs directory? More than likely it's a hostname/firewall issue :( By the way, for Linux/Unix questions, there is the CF-Linux list. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:52 AM To: CF-Talk Subject: Re: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. Yes the install works perfect.. Jrun just does not want to start.. I've tried to start it manually and didn't work.. Im gonna have to install another distribution on the server.. AGAIN? it seems easier than trying to find out what went wrong in Red Hat.. and the CFMX starter does not give you any hints at all on what went wrong.. lame.. On Thu, 2002-07-25 at 17:53, Sean A Corfield wrote: On Thursday, July 25, 2002, at 02:43 , Alexis Maldonado wrote: for some reason i've always had problems installing CF on Red Hat..!! I just tried installing CFMX on Mandrake 8.2 and it worked flawlessly.. I had early betas of CFMX running perfectly on RH7.2 but the Final release has rev'd the JVM and so I can't install it until I upgrade libc etc. Although that was actually a problem at install time - sounds like you're a bit further along than that. Have you confirmed that you can hit the CFMX web server directly at http://127.0.0.1:8500/ ? After successfully running: /home/coldfusionmx/bin/coldfusion start Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Query
I have a query that I am trying to get all my descriptions from my choiceTable that
are not found in my productChoiceTable that have a productid of a url.product value.
Basically if a choice id is found in the productChoiceTable that also has the
url.productid in the productid column, it is discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
!--- Current query that is returning 0 records (which is not the case). ---
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Favourite Web Services so far?
Hi, I'm not yet into MX, but hopefully will be later this summer. I was just wondering what everyone's favourite or most useful Web Services are currently - or whether you've written one / made one available that you like. Thanks Will -- GPRS Forums: http://GPRSCommunity.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source..
1. What ports other than 80 do i need to open in order for CFMX to work properly 2. I think i fixed the domain problem On Fri, 2002-07-26 at 08:01, Jesse Noller wrote: You won't have an /opt/coldfusionmx/runtime/wsconfig directory unless the connector wizard (wsconfig.jar) runs successfully, which, by all reports, it does not. This means that wsconfig.jar is unable to contact the local JRun server. This can be caused by: 1: Not changing the redhat installer defaults for firewalling rules, by default RH blocks all. This break CFMX in a bad way. 2: Invalid Hostname. Your hostname MUST match your machine's IP reverse lookup in DNS in order to have JRun startup (JRun does a reverse lookup on start). Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 4:57 PM To: CF-Talk Subject: Re: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. well i guess the installer did not install it because I see no jrun directory and i dont have the /opt/coldfusionmx/runtime/wsconfig directory do i have to manually install jrun somewhere? has anyone gotten apache 2.0.39 to run under Red Hat? On Thu, 2002-07-25 at 15:56, [EMAIL PROTECTED] wrote: Yes, CFMX runs on a lite version of jrun. On 25 Jul 2002, Alexis Maldonado wrote: tried the hotfix.. still nothing.. does the MX need Jrun in order to run? when i start CFMX it says... Jrun not started, will retry connector 12 more time(s) until it reaches 0 and then it says Coldfusion MX has been started. i go to http://localhost/cfide/administrator/index.cfm and i get source code.. On Thu, 2002-07-25 at 14:53, [EMAIL PROTECTED] wrote: You did grab the Apache 2.0.39 hotfix from macromedia's website and apply it? http://www.macromedia.com/v1/handlers/index.cfm?ID=23162 ~Todd On 25 Jul 2002, Alexis Maldonado wrote: I have tried everything. Apache 1.39 ect.. The only one that works is CF 5.0 with the EAPI module.. I thought that if i compiled 2.0.39 it would work but no. I Apache keeps displaying the code. What can i do? should i switch distributions? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: Web Services not working... look at this error.
It looks as if the service did not either start up or had errors while starting up. Some of the things you could try are: 1) Recycle CFMX 2) Verify that there are no errors while the server starts up (check the server.log) 3) Try consuming a CFC web service. HTH -kumaran -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:16 AM To: CF-Talk Subject: Help: Web Services not working... look at this error. Error Occurred While Processing Request The XML-RPC service is not available. This exception is usually caused by service startup failure. Please check your server configuration. The Error Occurred in C:\Inetpub\wwwroot\jontest.cfm: line 3 1 : cfscript 2 : ws = CreateObject(webservice, 3 : http://www.xmethods.net/sd/2001/BabelFishService.wsdl;); 4 : xlatstring = ws.BabelFish(en_es, Hello world, friend); 5 : writeoutput(xlatstring); Please Try The Following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.3705) Remote Address 127.0.0.1 Referer Date/Time 25-Jul-02 09:13 PM Stack Trace (click to expand) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) coldfusion.server.ServiceFactory$ServiceNotAvailableException: The XML-RPC service is not available. at coldfusion.server.ServiceFactory.getXmlRpcService(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Table Locking Problems
I'd suggest changing your approach as I doubt the problem is CF-related. Consult your DBA and figure out why it's locking -- which query does the table lock belong to, and why is it locking it? It may be poorly written SQL that's the culprit, or some DB design flaw The above assumes you're not using Access as your DB. If you're using Access, then the lock is because someone has your database open in Design Mode. In that case, either ask that person to get off the DB or upgrade to a real DB. Well, they're replicating their sql servers for load-balancing purposes, so I'm sure it's not Access ... I was guessing it was MS SQL Server, but I didn't want to make the assumption. :) There are occasions on which poorly written CF can cause things like this -- at one of my previous jobs we had a problem with SQL Server deadlocking as a result of a situation where aggregate data was not being properly updated in the database when data was entered ( or removed ) and the end result was that rather than actually fixing the problem they decided to update the aggregated data on every page view with a query like: UPDATE tClass SET StudentCount = (SELECT COUNT(studentid) FROM tStudentEnroll WHERE classid = tClass.ClassID) WHERE tClass.ScheduleID = #scheduleid# This was on a page displaying all the classes during a day for all the rooms in the school. Because the query was so broad it wound up affecting most of the table and locking the entire table on every view of that CF page -- and because similar related pages also wanted to know the student count, the same was done on those related pages, accept that they usually didn't include the WHERE clause, so it would blanket update the _ENTIRE_ table, regardless of whether or not a given record needed to be viewed... The original intention had been to try and reduce load on the sql server by keeping track of the student count without having to select(count) every time they needed to know or compare to determine if there was an empty seat in a given class... The end result was both _increased_ sql server load and frequent sql server deadlocks thanks to poor CF design. I'm betting the problem here isn't as serious. :) Isaac Dealey www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source..
I dont know how but it got fixed.. I just restarted the machine and when it came up jrun started.. yeeesh.. weird.. Thanks everyone for their help !! On Fri, 2002-07-26 at 08:09, Jesse Noller wrote: The mailing lists strip attachments. Send it to me, [EMAIL PROTECTED] Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:09 AM To: CF-Talk Subject: RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. k.. attached is my cfserver.log It contains TONS of errors trying to start JRUN none of them make sense to me.. The mandrake install has a whole bunch of errors too but it runs.. I posted this problem on the cf-linux list and for some reason i did not receive a reply.. On Fri, 2002-07-26 at 07:55, Jesse Noller wrote: What's the error logs say? Especially the cfusion.log in the logs directory? More than likely it's a hostname/firewall issue :( By the way, for Linux/Unix questions, there is the CF-Linux list. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:52 AM To: CF-Talk Subject: Re: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. Yes the install works perfect.. Jrun just does not want to start.. I've tried to start it manually and didn't work.. Im gonna have to install another distribution on the server.. AGAIN? it seems easier than trying to find out what went wrong in Red Hat.. and the CFMX starter does not give you any hints at all on what went wrong.. lame.. On Thu, 2002-07-25 at 17:53, Sean A Corfield wrote: On Thursday, July 25, 2002, at 02:43 , Alexis Maldonado wrote: for some reason i've always had problems installing CF on Red Hat..!! I just tried installing CFMX on Mandrake 8.2 and it worked flawlessly.. I had early betas of CFMX running perfectly on RH7.2 but the Final release has rev'd the JVM and so I can't install it until I upgrade libc etc. Although that was actually a problem at install time - sounds like you're a bit further along than that. Have you confirmed that you can hit the CFMX web server directly at http://127.0.0.1:8500/ ? After successfully running: /home/coldfusionmx/bin/coldfusion start Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
I think the Amazon webservice is making a pretty big splash. ~Todd On Fri, 26 Jul 2002, W Luke wrote: Hi, I'm not yet into MX, but hopefully will be later this summer. I was just wondering what everyone's favourite or most useful Web Services are currently - or whether you've written one / made one available that you like. Thanks Will -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error stack trace not as good in CF5??
Hi Folks In CF4.5 I could get a really nice, detailed stack trace when errors occurred. If there is a trick to getting them back easily in CF5, I'd love to hear it. We have a site-wide error handler installed and it dumps things from the error object (including error.diagnostics, which is where I used to see the trace). I see the original template name in error.template, but now, with CF5, I only get what looks like a partial trace, after the first cfcatch. (look below) I have the Enable CFML Stack Trace option turned on in the Debugging Options, but I noticed the wording below it says: In case of a CFML structured exception, fills in CFCATCH.TAGCONTEXT with information about the tags that were executing when ColdFusion detected the exception. I don't know if that is what it use to say, but it sounds different. (It turns out that this setting can be used for a work-around.) Below is an example ERROR.DIAGNOSTICS message for a case where a wddx error was cfcatch'ed and rethrown. It does have a bit of a stack track (basically, the cfcatch itself) but does not show the original page template name and calling line number, not to mention the 2 or three layers of custom tags in between. unknown element encountered The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (61:3) to (61:113) in the template file d:\inetpub\cf_CustomTags\WddxCapture.cfm. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (77:4) to (77:14) in the template file d:\inetpub\cf_CustomTags\WddxCapture.cfm. I did find a work-around... in the cfcatch I stuff CFCATCH.TAGCONTEXT into a REQUEST variable, and then use the code below to report it in the site-wide error handler. The code produces a slimmed down version of the full stack trace up to the cfcatch. (You can use cfdump to look at the whole thing). !--- dump the stack trace, but only one entry per template --- cfloop index=i from=1 to=#ArrayLen(request.error_stack)# cfif (i eq ArrayLen(request.error_stack)) OR (request.error_stack[i].TEMPLATE NEQ request.error_stack[i+1].TEMPLATE) LILine #request.error_stack[i].Line#, #request.error_stack[i].TEMPLATE# (#request.error_stack[i].ID#) /cfif /cfloop This works ok but it requires that the REQUEST variable be set in every single CFCATCH, and that sucks. Maybe I'm supposed to use some new mechanism in CF5?? I also discovered that there is zero documentation on macromedia's site about TAGCONTEXT, and error handling in general. Oh well. Thanks Mark __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
I see this as an opportunity to reinforce the need for better application architecture and code planning, reducing what we call here, in Portuguese, programação por atrito (friction programming??). Marcello Frutig. -- Astrolabio /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Application for monitoring webpages/services
I have a couple of mapping applications running on PHP. Since these applications are expected to be accessed quite heavily and the applications is quite complex, i would like to have a CF application that hit the urls to make sure the applications are running rather accessing on them manually everyday. right now, i don't have much ideas on writing the scripts. My idea is to 'hit' the urls every hour using the scheduler functions in CF. Be grateful for any pointers. YC Nyon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
The distance from a zipcode is useful. On Fri, 26 Jul 2002, W Luke wrote: Hi, I'm not yet into MX, but hopefully will be later this summer. I was just wondering what everyone's favourite or most useful Web Services are currently - or whether you've written one / made one available that you like. Thanks Will -- GPRS Forums: http://GPRSCommunity.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Setting and evaluating session variables
cfQuestion type=Rookie I'm trying to write my first web app in CFMX, and am having some trouble figuring out how session variables work. I'm basically just trying a few things to test setting them and testing for their values, stuff like that. So, what I've done, is I've added a section in my Application.cfm file to establish my needed session variables, and initialize them to nothing (). One of those session variables is called SESSION.initialized, and it's value, again, gets set to . The very first line of the splash page of my app has the line cfSet SESSION.initialized = True which is intended to initialize a users session in the application. I do this ONLY on that first splash page for the app. Now, at the bottom of my Application.cfm file, I have the following statement: cfif SESSION.initialized is not True cfLocation URL=mySplashPage.cfm addToken=No /cfif Now, if I understand the way this works correctly, what I'm expecting, is that if I open a new browser window, and I try to circumvent that splash page by typing something like http://www.mysite.com/mySecondPage.cfm http://www.mysite.com/mySecondPage.cfm into the address line of the browser, the line above that checks that session variable should get executed at the beginning of the request for that page. Now, at this point, since during this browser session I have *not* navigated to mySplashPage.cfm yet, that the SESSION.initialized variable has not been set to True yet, so this condition would evaluate to FALSE, and should execute the cfLocation tag to redirect the browser to the mySplashPage.cfm document, so that it *will* set that variable to True. Am I correct in that thinking? If not, how does this work? I thought I had this working properly the other day, but it doesn't seem to be working right today, because I'm not getting redirected like I would expect. And, on a side note to that, has anyone had any problems with this cfLocation tag with a Mozilla browser? The other day when I was trying this, I kept getting an error from Mozilla that said something like Redirection limit exceeded for this URL. Has anyone else experienced this? If so, is it a browser problem that Mozilla can't be redirected? Is there a workaround for it? Thanks in advance for your help. /cfQuestion ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
looping over lists and queries in cfscript
has anyone found a good way to loop over lists and queries in cfscript? any ideas would be well appreciated! --Josh __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Transport port
If you type in http://servername:9080/, and the web server is listening on that port, then on that server, CGI.SERVER_PORT will be 9080. I don't understand what you mean by transport port. When I request a page from the server, the port 80 answers from the HTTP_Server. But in reality the plugin comunicate with the Application server trough the port 9080. I want to know if is possible to know this transport port. No, there's no CGI variable containing the port used by CF Server to listen to requests from your web server, to the best of my knowledge. Out of curiosity, why would you want that information within your application? Conceivably, if you wanted it badly enough, in CF MX you could use CFFILE to open the appropriate configuration file, and read it from there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Query
More than likely something like so...
SELECT c.id, c.description
FROM choiceTable c,productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN
( SELECT productid
FROM productChoiceTable
WHERE productid = '#url.productid#' )
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 26, 2002 7:22 AM
Subject: OT: SQL Query
I have a query that I am trying to get all my descriptions from my
choiceTable that are not found in my productChoiceTable that have a productid
of a url.product value. Basically if a choice id is found in the
productChoiceTable that also has the url.productid in the productid column, it
is discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
!--- Current query that is returning 0 records (which is not the
case). ---
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Outlook and Cfmail
Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recommendations other than Verity
Does anyone have any recommendations for an indexing solution other than verity that integrates failry easily with Cold Fusion 4.5. We are indexing email and not only does verity not recognize the files as email, but it cannot index the attachments (because it does not recognize the file as email). Additionally a 250MB mailbox generates a 4GB-6GB collection and verity does not appear have a way to trim that. I do not need a way to index queries, just files. TIA, Justin -- Justin Greene ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service P: 212-242-0258 x 101 http://www.clicvu.com http://www.spamex.com Spamex - Protect your real email address forever __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SQL Query
SELECT c.id, c.description
FROM choiceTable c
WHERE c.id = '#url.productid#'
AND NOT EXISTS (
SELECT pc.id
FROM ProductChoiceTable pc
WHERE pc.productid='#url.productid#'
)
--- Paul Giesenhagen [EMAIL PROTECTED] wrote:
I have a query that I am trying to get all my
descriptions from my choiceTable that are not found
in my productChoiceTable that have a productid of a
url.product value. Basically if a choice id is
found in the productChoiceTable that also has the
url.productid in the productid column, it is
discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
!--- Current query that is returning 0 records
(which is not the case). ---
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
XML Problem Check out the code
I have a XML array that I appended and it says it was successful but no data is in the XML struct. Any ideas? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN HTML HEAD TITLEXML TEST/TITLE META http-equiv=Content-Type content=text/html; charset=iso-8859-1 /HEAD BODY cfset myXML1 = XmlNew(no) cfset myXML1.xmlRoot = XmlElemNew(myXML1, MyRoot) cfset myXML1.MyRoot.XmlChildren[1] = XmlElemNew(myXML1, childNode1) cfset myXML1.MyRoot.XmlChildren[1].XmlText = This is Child node. cfdump var=#myXML1# cfset myXML2 = XmlNew(no) cfset myXML2.xmlRoot = XmlElemNew(myXML2, MyRoot) cfdump var=#myXML2# cfset xmlelement = duplicate(myXML1.MyRoot.XmlChildren[1]) cfdump var=#xmlelement# cfset xmlElement.XmlText = 'hi' cfset xmlElement.XmlComment = 'Raymond' cfdump var=#myXML1# cfdump var=#xmlelement# cfset myXML2.MyRoot.XmlChildren[1] = XmlElemNew(myXML2, childNode1) cfset a = StructAppend(myXML2.MyRoot.XmlChildren[1], xmlelement) cfdump var=#myXML2# cfoutputSuccess = #a#/cfoutput cfset myXML2.MyRoot.XmlChildren[1] = xmlelement textarea cols=120 rows=10 cfoutput#toString(myXML1)#/cfoutput /textarea /BODY /HTML __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Table Locking Problems
Thanks for your help. I think I will dig out the SQL books and write a couple of stored procedures todo this. Colin - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 2:01 PM Subject: Re: Table Locking Problems HELP! I am having problems with table locks in one of my databases. These table locks result in the cfm pages failing becuase they either can't access the database or they get a serialization failure. I have tried using cflock to stop multiple queries accessing the same table but the problem is the site is running over more than 1 server and I can't think of anyway to prevent all of the code on all the servers from accessing the tables at the same time. It also runs on 2 SQL servers which are replicating to each other. Does anyone have any suggestions on how I could solve these problems? The sites run on coldfusion 4.5. With some fairly advanced SQL knowledge / work you might be able to design a stored procedure which would check for the lock on the given table until it is released, then perform the action... Or there might be someone else here who could offer a better solution -- what database system are you using? SQL Server , Oracle, something else? I'd be willing to bet the final solution will hinge on the db server in use... There is a much more crude solution tho I don't know that I'd want to go this route: Put this in a custom tag and use it to run your sql query... cfif thistag.executionmode is end cftry cfquery ... #thistag.generatedcontent# /cfquery cfcatch type=ODBC cfmodule template=#getfilefrompath(getcurrenttemplatepath())# attributecollection=#attributes# #thistag.generatedcontent# /cfmodule /cfcatch /cftry cfset thistag.generatedcontent = /cfif This will just brute-force repeatedly attempt to access the db until either it's successful in performing its task or it chokes the cf server to death, whichever comes first. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MX Uniqueidentifier In Query
Hi I've just migrated my code to CFMX Server. For some reason its giving error when I am trying to use Variable(PK_User_ID) From Query(GetUser). Only problem is that PK_User_ID is Uniqueidentifier. I mean in same Query if I use CFOUTPUT#GetUser.FirstName#/CFOUTPUT it does work but CFOUTPUT#GetUser.PK_User_ID#/CFOUTPUT doesn't work. Well query is pretty basic SELECT * From tb_User Where FirstName='Shahzad'. I can output any column from query except the ones which are of type Uniqueidentifier. Any Reason Behind It??? I've analysed my code in CFMX Server and it doesn't give any error. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query
try...
SELECT c.id, c.description
FROM
choicetable c
WHERE
c.productid = '#URL.productid#'
AND c.id NOT IN (
SELECT
pc.choiceid
FROM
productchoicetable pc
WHERE
pc.productid = '#URL.productid#'
)
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 10:22 AM
To: CF-Talk
Subject: OT: SQL Query
I have a query that I am trying to get all my descriptions from my
choiceTable that are not found in my productChoiceTable that have a
productid of a url.product value. Basically if a choice id is found in the
productChoiceTable that also has the url.productid in the productid column,
it is discarded in the result.
Here is my table layout:
choiceTable
id, choice, description
productChoiceTable
id,choiceid,productid
!--- Current query that is returning 0 records (which is not the
case). ---
SELECT c.id, c.description
FROM choiceTable c, productChoiceTable pc
WHERE c.id = pc.choiceid
AND pc.productid NOT IN ('#url.productid#')
Any suggestions apreciated!
Paul Giesenhagen
QuillDesign
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion and Netscape Headers
oi CF-Talk,!! is this a known gig that outputs the header info in Nutscape 6.x ? is there any fix for it? -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
site wide missing template handler not working in MX
Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. At 11:29 AM 26/07/02 -0300, you wrote: Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: looping over lists and queries in cfscript
www.houseoffusion.com/docs/cfscript.htm 8.7 loops over a query and 8.8 loops over a list. has anyone found a good way to loop over lists and queries in cfscript? any ideas would be well appreciated! --Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
where is that located? The distance from a zipcode is useful. On Fri, 26 Jul 2002, W Luke wrote: Hi, I'm not yet into MX, but hopefully will be later this summer. I was just wondering what everyone's favourite or most useful Web Services are currently - or whether you've written one / made one available that you like. Thanks Will -- GPRS Forums: http://GPRSCommunity.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 Availability
Bud, I've downgraded one of my CFMX copies with MM. They gave me autorization to use CF5 as long as I whish and move to my original CFMX version when I feel ready for that. This is great, thanks MM. Make contact with MM regarding it. []'s Alex -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 25/07/2002 10:47 PM To: CF-Talk Subject: CF 5 Availability Can CF 5 upgrade from 4.5 still be had? Thanks! -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outlook and Cfmail
Try this: cfset recipient=[EMAIL PROTECTED] cfset from =Bob Dole [EMAIL PROTECTED] cfset subject=Email Test cfset textbody=mytextmessage cfset htmlbody=h2myhtmlmessage/h2 cfset crlf = chr(13)chr(10) CFSET MIMEBOUNDARY = MIME-BOUNDARY CFSET contenttype = multipart/alternative;boundary=MIMEBOUNDARY CFSET myHeaders = X-Mailer: My Mailer, MIME-Version: 1.0 CFSET myPlainMsgTop = --#MIMEboundary##crlf#Content-Type: text/plain; charset=us-ascii#crlf#Content-Transfer-Encoding: 7bit#crlf##crlf# CFSET myHTMLMsgTop = --#MIMEboundary##crlf#Content-Type: text/html; charset=us-ascii#crlf#Content-Transfer-Encoding: 7bit#crlf##crlf# !--- Send the messages --- CFMAIL To=#recipient# From=#from# Subject=#subject# !--- Sean: cfmailparam --- cfmailparam name=Content-type value=#contenttype# cfmailparam name=MIME-Version value=1.0 #myPlainMsgTop# !--- begin plain text version --- #textbody# #myHTMLMsgTop# !--- begin html version --- #htmlbody# /cfmail At 09:52 AM 26/07/02 -0400, you wrote: Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: multiple copies of list mail?
Check your filters. Did you add a new one? One of the most common reasons that people receive duplicate messages is that they've got 2 filters filtering the same message and the message gets copied at that point. (the other most common one is being subscribed more than once) sorry if its my mail server effing up, but are many of you getting duplicate postings from the list tonight? odd?? ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outlook and Cfmail
Josh - Try something like this (code below). You will need to make an html version of the email (FriendConfirmation.htm) and a text version (FriendConfirmation.txt) -- which I also use for AOL mail readers. Best regards, David cfset mimeBoundary = World=_WatchDaily cfmail to=#Attributes.friendEmail# from=World Watch Daily[EMAIL PROTECTED] subject=Personal recommendation from #Attributes.senderName# server=#request.mailserver# port=25 CFMAILPARAM name=X-mailer value=#chr(34)##mimeBoundary##chr(34)#multipart mailer v1.0 cfmailparam name=MIME-Version value=1.0 cfmailparam name=Content-Type value=multipart/alternative;boundary=#chr(34)##mimeBoundary##chr(34)# This is a Multipart MIME message. --#mimeBoundary# Content-Type:text/plain; charset=us-ascii cfinclude template=FriendConfirmation.txt --#mimeBoundary# Content-Type:text/x-aol; charset=us-ascii cfinclude template=FriendConfirmation.txt --#mimeBoundary# Content-Type:text/html; charset=us-ascii cfinclude template=FriendConfirmation.htm --#mimeBoundary#-- /cfmail David Grabbe News Editor World Watch Daily [EMAIL PROTECTED] http://worldwatchdaily.org -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:53 AM To: CF-Talk Subject: Outlook and Cfmail Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Table Locking Problems
You could try using query locking hints in your SQL, I have to do it on some very large tables that get a lot of updates. The only problem being that sometimes you won't get data that's 100% up to date as it could be updated while the select is running. E.g. select field1,field2 from tblOne (nolock) where field1 = #param# Other than that, have a good look at the database design, there may be too many indexes, or poorly performing indexes that are slowing inserts and updates down, tbh it could be any number of things. Although it is highly probable that the problem is the database and or some slow SQL that's causing the issues, not CF. Hope you get it sorted, Craig. -Original Message- From: Colin Murphy [mailto:[EMAIL PROTECTED]] Sent: 26 July 2002 13:44 To: CF-Talk Subject: Table Locking Problems HELP! I am having problems with table locks in one of my databases. These table locks result in the cfm pages failing becuase they either can't access the database or they get a serialization failure. I have tried using cflock to stop multiple queries accessing the same table but the problem is the site is running over more than 1 server and I can't think of anyway to prevent all of the code on all the servers from accessing the tables at the same time. It also runs on 2 SQL servers which are replicating to each other. Does anyone have any suggestions on how I could solve these problems? The sites run on coldfusion 4.5. Colin __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
The reason why you don't run into this with PHP, ASP, and JSP (actually, I avoid JSP) is that they are interpreted languages, like the current CFML is sort of, and the old CF was. You do get this with Perl. Perl requires compilation time. Actually, some of the advanced CPAN/Perl/PHP stuff I've done lately does require an App compilation. The fact of the matter is that while we provide you with CFML, a RAD development language, which is then interpreted into Java bytecode, we have not left the RAD ideal, in my mind, RAD is a style of language that allows you rapid development, NOT taking into account the deployment of application, rather, I don't believe that we left RAD behind due to JIT time. While it would be optimal to have all the benefits that we've garnered with CFMX without the compile time, I believe the benefits we have gained outweigh the extra 10-20 seconds it takes to view a source page. You'd get the same thing with Perl. The CFML language is maturing, that's a fact of life. One of the biggest limitations facing RAD languages such as PHP, or ASP even is the fact that there is a barrier in their efficiency when trying to stick to the interpreted schema. PHP has even realized this. That's why you have about 10 trillion PHP modules to bypass (or expand) on the limitations found in an interpreted language. By moving more towards a traditional compile approach, we garner assets in regards to language expansion and integration, and scalability. The performance increase *is* noticeable in a production environment. Scalability is the key. As a general rule, compiled and tuned binaries will almost ALWAYS outrun and outperform interpreted command-driven applications of the same ilk. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:29 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment
RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source..
Note: resent at M.Dinowitz request I'll keep the replies to the list so that everyone can learn. The first error in your log goes: Starting Macromedia JRun 4 (Build 47304), default server Unable get IP addresses from a local host, defaulting to 127.0.0.1. 07/25 17:02:17 error Exception thrown in operation init [1]java.net.UnknownHostException: dlappserver3 at java.net.InetAddress.getAllByName0(InetAddress.java:566) at java.net.InetAddress.getAllByName0(InetAddress.java:535) at java.net.InetAddress.getAllByName(InetAddress.java:528) at java.net.InetAddress.getLocalHost(InetAddress.java:718) at jrunx.util.NetUtil.resolveIP(NetUtil.java:28) at jrunx.cluster.ClusterManager.init(ClusterManager.java:66) at java.lang.reflect.Method.invoke(Native Method) Blam. JRun is dead. This means your local host information does not match the DNS name information for that IP address. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:09 AM To: CF-Talk Subject: RE: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. k.. attached is my cfserver.log It contains TONS of errors trying to start JRUN none of them make sense to me.. The mandrake install has a whole bunch of errors too but it runs.. I posted this problem on the cf-linux list and for some reason i did not receive a reply.. On Fri, 2002-07-26 at 07:55, Jesse Noller wrote: What's the error logs say? Especially the cfusion.log in the logs directory? More than likely it's a hostname/firewall issue :( By the way, for Linux/Unix questions, there is the CF-Linux list. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alexis Maldonado [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:52 AM To: CF-Talk Subject: Re: CFMX + Red Hat 7.3 + Apache 2.0.39 displays source.. Yes the install works perfect.. Jrun just does not want to start.. I've tried to start it manually and didn't work.. Im gonna have to install another distribution on the server.. AGAIN? it seems easier than trying to find out what went wrong in Red Hat.. and the CFMX starter does not give you any hints at all on what went wrong.. lame.. On Thu, 2002-07-25 at 17:53, Sean A Corfield wrote: On Thursday, July 25, 2002, at 02:43 , Alexis Maldonado wrote: for some reason i've always had problems installing CF on Red Hat..!! I just tried installing CFMX on Mandrake 8.2 and it worked flawlessly.. I had early betas of CFMX running perfectly on RH7.2 but the Final release has rev'd the JVM and so I can't install it until I upgrade libc etc. Although that was actually a problem at install time - sounds like you're a bit further along than that. Have you confirmed that you can hit the CFMX web server directly at http://127.0.0.1:8500/ ? After successfully running: /home/coldfusionmx/bin/coldfusion start Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FAQs for CF-Talk was (Admin) Behavior
No, it's not normally like this -- at least for the three months I've been here. This newbie has never been flamed (though he's been teased when his answers to questions weren't quite right :-) I think that the name calling and OT arguments about what is and isn't a portal have gone past the point of reason, but good things look like they will come out of this. As a newbie, I'm /really/ looking forward to an updated FAQ, and I would like to see pointers to primers and articles as Mattieu suggested. So far, I've found this list helpful and informative. With a good mail filter, I'm sure it still is. :-) --Ben Doom Programmer General Lackey Moonbow Software PS -- Please note that that last statement was a joke. It was intended to be amusing. I apologize if I offend anyone. Please insert your favorite anti-flame statement here. : -Original Message- : From: Buddy [mailto:[EMAIL PROTECTED]] : Sent: Thursday, July 25, 2002 7:47 PM : To: CF-Talk : Subject: RE: FAQs for CF-Talk was (Admin) Behavior : : : I was a member of this email list a while back, and I found it to be a : valuable resource in helping with problems, and it also helped me to : feel like I was a member of a growing Cold Fusion community. I dropped : out when a job switch took me out of cold fusion and into java. Another : job switch has brought me back into cold fusion this month and so I joined : back up hoping to encounter the same helpful bunch of folks and sense of : community, but instead I found a list where newbies get flamed and people : with overblown egos waste bandwidth arguing about nothing. : Seriously, in the : 2 days that I have been back on the list look at what has actually been : useful and what has been ego stroking and flaming. It seems pretty bad, I : hope that everyone has just been in a really bad mood, and that it's not : normally like this. : Buddy : : __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
Yes, this is true. Seens to me that bad code runs faster on CF5 and good code runs faster on CFMX... The question is: what is bad code and good code in this new CFML horizon? I'm not a hardcore programmer but even form me, CFML is not a programming language status quo. Pure CF programmers are now being forced to know a little of Java, to take care of a lot of new things (such as text encoding, data types and stuff) that is suppressed by the easy of CF5 and previous versions. Well, this can be a good thing (at least I agree myself) but it also is a bad thing because CFML becames more complicated and loose it's most important feature: simplicity. Maybe, in a future, the price for maintaining this easy can turn into a barrier to the performance and other things that are not present in other server-side languages, such as JSP and ASP. Is Java ready for CFMX and CFMX is ready for Java? Huh... To be or not to be. I think, for now, we should keep talking about it and share observations in terms of coding and application, not only architecture and server features... To start with it I can say that I'm 99% convinced that FuseBox applications (a very high acceptable concept in making good CF code) runs pretty much slower under CFMX than in CF5. Maybe it's time to forget about FuseBox architeture and jump into CFC's, maybe not? Helms, Fusebox will survive CFMX? Well, lots of things but it's been nice walk through this unexplored field. Marcello, em tempo: parabéns pelo CFUG-Rio! Nós aqui de São Paulo estamos nos borrando de inveja :o). De verdade, parabéns! []'s Alex -Original Message- From: Marcello Frutig [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 10:22 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 I see this as an opportunity to reinforce the need for better application architecture and code planning, reducing what we call here, in Portuguese, programação por atrito (friction programming??). Marcello Frutig. -- Astrolabio /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Favourite Web Services so far?
here we go.. everyone loves the geographic search functions... :)greatly underused... -p -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:59 PM To: CF-Talk Subject: Re: Favourite Web Services so far? The distance from a zipcode is useful. On Fri, 26 Jul 2002, W Luke wrote: Hi, I'm not yet into MX, but hopefully will be later this summer. I was just wondering what everyone's favourite or most useful Web Services are currently - or whether you've written one / made one available that you like. Thanks Will -- GPRS Forums: http://GPRSCommunity.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
record linking prob
Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults. RecordID)##searchResults.Title#/a .. no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outlook and Cfmail
You need to check out mime standards for e-mail. There's a lot to cover, but basically it's pretty simple. Here's a simple CFMail setup that should work: cfset mimeboundary=-=_NextPart_000__ABCDEF01 cfmail to=#attributes.to# from=#attributes.from# subject=#attributes.subject# mailerid=Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) server=X.X.X.X cfmailparam name=reply-to value=#attributes.replyto# cfmailparam name=X-msg-id value=#message_id# cfmailparam name=X-mailing-id value=#attributes.mailing_id# cfmailparam name=MIME-Version value=1.0 cfmailparam name=Content-Type value=multipart/alternative; boundary=#chr(34)##mimeBoundary##chr(34)# This is a Multipart MIME message. --#mimeBoundary# Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cfinclude template=#attributes.text_file# --#mimeBoundary# Content-Type: text/html Content-Transfer-Encoding: 8bit cfinclude template=#attributes.media_file# --#mimeBoundary#-- /cfmail -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:53 AM To: CF-Talk Subject: Outlook and Cfmail Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX Scheduler Work Around
Because of the apparent bug in the CFMX scheduler (CFMX, IIS, Win2k), I'm looking for a work around that will allow me to run a scheduled task without using CFMX. All I need to do is hit a cfm page at a predetermined time once per day. For those unfamiliar with the bug, all scheduled tasks execute once correctly on the day they are first scheduled. CFMX then reschedules the task for 12:00am regardless of the time specified in the admin panel. (For more info see: http://www.cfbughunt.org/index.cfm?fuseaction=view_bugBugID=1152Row=11 ) TIA, chris __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: site wide missing template handler not working in MX
AFAIK, this path in MX is now relative to the web root directory. Did you try this? Regards, Marcello Frutig. -- Astrolábio Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. At 11:29 AM 26/07/02 -0300, you wrote: Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML Problem Check out the code
Yup, I would first remove all HTML tags when you're messing with CFMXL or XMLNEW() ~Todd On Fri, 26 Jul 2002, BT THornton wrote: I have a XML array that I appended and it says it was successful but no data is in the XML struct. Any ideas? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN HTML HEAD TITLEXML TEST/TITLE META http-equiv=Content-Type content=text/html; charset=iso-8859-1 /HEAD BODY cfset myXML1 = XmlNew(no) cfset myXML1.xmlRoot = XmlElemNew(myXML1, MyRoot) cfset myXML1.MyRoot.XmlChildren[1] = XmlElemNew(myXML1, childNode1) cfset myXML1.MyRoot.XmlChildren[1].XmlText = This is Child node. cfdump var=#myXML1# cfset myXML2 = XmlNew(no) cfset myXML2.xmlRoot = XmlElemNew(myXML2, MyRoot) cfdump var=#myXML2# cfset xmlelement = duplicate(myXML1.MyRoot.XmlChildren[1]) cfdump var=#xmlelement# cfset xmlElement.XmlText = 'hi' cfset xmlElement.XmlComment = 'Raymond' cfdump var=#myXML1# cfdump var=#xmlelement# cfset myXML2.MyRoot.XmlChildren[1] = XmlElemNew(myXML2, childNode1) cfset a = StructAppend(myXML2.MyRoot.XmlChildren[1], xmlelement) cfdump var=#myXML2# cfoutputSuccess = #a#/cfoutput cfset myXML2.MyRoot.XmlChildren[1] = xmlelement textarea cols=120 rows=10 cfoutput#toString(myXML1)#/cfoutput /textarea /BODY /HTML __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outlook and Cfmail
Check out cf_advanced mail in the devex. It makes up for a lot of the shortcomings of cfmail. -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 6:53 AM To: CF-Talk Subject: Outlook and Cfmail Is there anyway to send an email so that if the user has html it shows up html formatted and if they are setup as plain text then it will only show the plain text email? Josh __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting and evaluating session variables
Hi. I think that I see the problem that you are having. My explanation may seem overly simple at first, but bear with me. Session variables are stored on the CF server. A given set of session variables is tied to a given user by two key values: CFID, and CFTOKEN. These values are sent to your machine as cookies when you access any page on the server. Now, as long as you are accessing the server from that machine, and as long as you have cookies enabled and don't replace them, the session variables will stay set for the default expiration time (which is probably set to something like 2 hours in your CF Administrator). So, the reason that you're getting weird behavior is that session.initialized is staying set for at least 2 hours from the time you first hit that page during a given day. This makes testing really hard, right? I think that your application is set up properly, but you are having trouble testing it. I recommend this: Create a page called wipeout.cfm or something that erases all the cookies and session variables that you don't want to keep. I keep a link to this on the link bar in IE, so that I can return to regular user state whenever I need to. The statements you'll need are: CFCOOKIE expires=NOW name=COOKIENAME value=invalid CFLOCK scope=SESSION timeout=30 type=EXCLUSIVE CFSET dummy=StructClear(session) /CFLOCK Repeat the CFCOOKIE line for as many cookies as you need to erase. The CFSET statement will wipe out all session variables in one shot. Also, your test for the value of Session.Initialized should not be for it's value, but for its existence: CFIF not IsDefined(Session.Initialized) CFLOCATION... This should let you test your system without pulling your hair out at what seems like completely inconsistent behavior. Now, however, I want to make sure that you aren't going for something different than what I think. I want to map out a path of use and how it would work under your current layout (assuming a two-hour expiration time for session variables): July 27th 10:15 AM User opens www.yahoo.com 10:17 AM User opens your site (www.yoursite.com/mySecondPage.cfm) She gets bounced to the splash page, since session.initialized wasn't set yet. still 10:17 AM(later in that minute) User returns to www.yoursite.com/mySecondPage.cfm, which now is allowed to completely load, since session.initialized is now set. 10:18 AM After looking at www.yoursite.com/mySecondPage.com, user is so wowed that she goes for a stroll to contemplate the meaning of life. Since the work is super-duper high security, though, she immediately closes the browser and shuts down her computer. 12:17 PM User has returned from her walk, ready to surge forward with her work. She has already turned on her machine, logged in, and launched IE. She promptly goes to the page that inspired this (nearly!) two-hour sojourn: www.yoursite.com/mySecondPage.com. That page will load WITHOUT going to the splash page. Why? Because session.initialized has still not expired (although it's one minute away from doing so), and the CF server knows to look for it under the CFID and CFTOKEN values stored on your user's machine. 12:18 PM User decides that she is no longer so wowed by your page, and immediately browses to www.someothersite.com. She stays away from your site until 4:01 PM. 4:01 PM User once again types in www.yoursite.com/mySecondPage.com. This time, she gets bounced to the splash page. Why? Because the two-hour session variable has expired. If this is the behavior you want, then you're all set. I just wanted to make sure that you weren't under operating under any misconceptions about how it would work. Hope this is helpful, Matthieu -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:28 AM To: CF-Talk Subject: Setting and evaluating session variables cfQuestion type=Rookie I'm trying to write my first web app in CFMX, and am having some trouble figuring out how session variables work. I'm basically just trying a few things to test setting them and testing for their values, stuff like that. So, what I've done, is I've added a section in my Application.cfm file to establish my needed session variables, and initialize them to nothing (). One of those session variables is called SESSION.initialized, and it's value, again, gets set to . The very first line of the splash page of my app has the line cfSet SESSION.initialized = True which is intended to initialize a users session in the application. I do this ONLY on that first splash page for the app. Now, at the bottom of my Application.cfm file, I have the following statement: cfif SESSION.initialized is not True cfLocation URL=mySplashPage.cfm addToken=No /cfif Now, if I understand the way this works correctly, what I'm expecting, is that if I open a new browser window, and I try to circumvent that splash page by typing something like
Re: MX Uniqueidentifier In Query
The column name is actually called PK_USER_ID? What happens when you do: cfdump var=#getuser# ...? ~Todd On Fri, 26 Jul 2002, Shahzad.Butt wrote: Hi I've just migrated my code to CFMX Server. For some reason its giving error when I am trying to use Variable(PK_User_ID) From Query(GetUser). Only problem is that PK_User_ID is Uniqueidentifier. I mean in same Query if I use CFOUTPUT#GetUser.FirstName#/CFOUTPUT it does work but CFOUTPUT#GetUser.PK_User_ID#/CFOUTPUT doesn't work. Well query is pretty basic SELECT * From tb_User Where FirstName='Shahzad'. I can output any column from query except the ones which are of type Uniqueidentifier. Any Reason Behind It??? I've analysed my code in CFMX Server and it doesn't give any error. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Table Locking Problems
Write your select statements like this: SELECT * FROM table1(nolock) inner join table2 (nolock) on table1.id = table2.id The nolock keeps the locking from occurring and forces dirty reads on the data. With Update statements, write them like this: UPDATE Table1 WITH (ROWLOCK) SET Field1 = 'value' FROM Table1 inner join table2 (nolock) on table1.id = table2.id The WITH(ROWLOCK) statement keeps sql server from escelating the lock to a full table lock. It will only lock the records it needs. -Original Message- From: Colin Murphy [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 7:13 AM To: CF-Talk Subject: Re: Table Locking Problems Thanks for your help. I think I will dig out the SQL books and write a couple of stored procedures todo this. Colin - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 2:01 PM Subject: Re: Table Locking Problems HELP! I am having problems with table locks in one of my databases. These table locks result in the cfm pages failing becuase they either can't access the database or they get a serialization failure. I have tried using cflock to stop multiple queries accessing the same table but the problem is the site is running over more than 1 server and I can't think of anyway to prevent all of the code on all the servers from accessing the tables at the same time. It also runs on 2 SQL servers which are replicating to each other. Does anyone have any suggestions on how I could solve these problems? The sites run on coldfusion 4.5. With some fairly advanced SQL knowledge / work you might be able to design a stored procedure which would check for the lock on the given table until it is released, then perform the action... Or there might be someone else here who could offer a better solution -- what database system are you using? SQL Server , Oracle, something else? I'd be willing to bet the final solution will hinge on the db server in use... There is a much more crude solution tho I don't know that I'd want to go this route: Put this in a custom tag and use it to run your sql query... cfif thistag.executionmode is end cftry cfquery ... #thistag.generatedcontent# /cfquery cfcatch type=ODBC cfmodule template=#getfilefrompath(getcurrenttemplatepath())# attributecollection=#attributes# #thistag.generatedcontent# /cfmodule /cfcatch /cftry cfset thistag.generatedcontent = /cfif This will just brute-force repeatedly attempt to access the db until either it's successful in performing its task or it chokes the cf server to death, whichever comes first. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: record linking prob
Does anyone have a script to automate the compilation of cf templates. I tried this one from Robert Everland, but it does not work on my system. setlocal set NEO_INSTALL=f:\cfusionMX set PATH=%NEO_INSTALL%\runtime\bin;%PATH% java -classpath %NEO_INSTALL%\lib\cfusion.jar coldfusion.tools.Compiler -webroot %NEO_INSTALL%\wwwroot %* endlocal __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DWMX is breaking my code HELP!
I just installed DWMX and setup a few test sites. After saving a few files DreamWeaver added a whole bunch of code to all my tags. For example, what was once: cfif left(cgi.remote_host,9) is not 206.18.98 Is now cfif mmTranslatedValueOutline=OUTLINE=%22%3Ccfif%3E%22 mmTranslatedValueOutlineID=OUTLINEID=1 left(cgi.remote_host,9) is not 206.18.98 And this now breaks in a browser! What is going on here? I am using a custom file extenstion (*.nat), and I am guessing this is part of the problem. But now I have a bunch of broken code. Does anybody know of a regular expression I code us to findreplace all of the mmTranslatedValue***=*** to fix my now broken code? And also, can some one tell me what all this code is and how to avoid this? Brook Davies __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
Btw: http://www.xmethods.com/ All kinds of stuff here... ~Todd On Fri, 26 Jul 2002, Michael Dinowitz wrote: where is that located? -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
so is MX at the core Java? I keep hear that's the gradual plan, migrate away from C... If that is true, how is macromedia addressing Java's great slowness and the infamous memory management/cleanup randomness that stops things? -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:26 PM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 The reason why you don't run into this with PHP, ASP, and JSP (actually, I avoid JSP) is that they are interpreted languages, like the current CFML is sort of, and the old CF was. You do get this with Perl. Perl requires compilation time. Actually, some of the advanced CPAN/Perl/PHP stuff I've done lately does require an App compilation. The fact of the matter is that while we provide you with CFML, a RAD development language, which is then interpreted into Java bytecode, we have not left the RAD ideal, in my mind, RAD is a style of language that allows you rapid development, NOT taking into account the deployment of application, rather, I don't believe that we left RAD behind due to JIT time. While it would be optimal to have all the benefits that we've garnered with CFMX without the compile time, I believe the benefits we have gained outweigh the extra 10-20 seconds it takes to view a source page. You'd get the same thing with Perl. The CFML language is maturing, that's a fact of life. One of the biggest limitations facing RAD languages such as PHP, or ASP even is the fact that there is a barrier in their efficiency when trying to stick to the interpreted schema. PHP has even realized this. That's why you have about 10 trillion PHP modules to bypass (or expand) on the limitations found in an interpreted language. By moving more towards a traditional compile approach, we garner assets in regards to language expansion and integration, and scalability. The performance increase *is* noticeable in a production environment. Scalability is the key. As a general rule, compiled and tuned binaries will almost ALWAYS outrun and outperform interpreted command-driven applications of the same ilk. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:29 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo
RE: It's official: CFMX is 10% faster than CF5
I'm actually wondering if some of the complaint about the 'speed' issue is what people are noticing when in development. Let's face it, the debugger application is a hog for whatever it's doing. Every now and then I turn off the debugger so I can get the real speed of what the end user is going to see and I think people are forgetting about that. In a production environment, debugging shouldn't be turned on (in a perfect world, with the perfect qa environment, etc.). Not all of us are disappointed with CFMX, but then... I dunno, not all of us is writing brand new code either. ~Todd On Fri, 26 Jul 2002, Jesse Noller wrote: The reason why you don't run into this with PHP, ASP, and JSP (actually, I avoid JSP) is that they are interpreted languages, like the current CFML is sort of, and the old CF was. You do get this with Perl. Perl requires compilation time. Actually, some of the advanced CPAN/Perl/PHP stuff I've done lately does require an App compilation. The fact of the matter is that while we provide you with CFML, a RAD development language, which is then interpreted into Java bytecode, we have not left the RAD ideal, in my mind, RAD is a style of language that allows you rapid development, NOT taking into account the deployment of application, rather, I don't believe that we left RAD behind due to JIT time. While it would be optimal to have all the benefits that we've garnered with CFMX without the compile time, I believe the benefits we have gained outweigh the extra 10-20 seconds it takes to view a source page. You'd get the same thing with Perl. The CFML language is maturing, that's a fact of life. One of the biggest limitations facing RAD languages such as PHP, or ASP even is the fact that there is a barrier in their efficiency when trying to stick to the interpreted schema. PHP has even realized this. That's why you have about 10 trillion PHP modules to bypass (or expand) on the limitations found in an interpreted language. By moving more towards a traditional compile approach, we garner assets in regards to language expansion and integration, and scalability. The performance increase *is* noticeable in a production environment. Scalability is the key. As a general rule, compiled and tuned binaries will almost ALWAYS outrun and outperform interpreted command-driven applications of the same ilk. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query
try... SELECT c.id, c.description FROM choicetable c WHERE c.productid = '#URL.productid#' AND c.id NOT IN ( SELECT pc.choiceid FROM productchoicetable pc WHERE pc.productid = '#URL.productid#' ) or use not exists SELECT c.id, c.description FROM choicetable c WHERE NOT EXISTS ( SELECT pc.productid FROM productChoiceTable WHERE pc.productid = #url.productid# ) Might be faster -- not sure... You'd have to either compare the plans for the two queries in enterprise manager or just run them several times and compare the execution times... This assumes you're using SQL Server Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX Scheduler Work Around
I would guess that you could use some combination of CFExecute and/or CFREgistry to create a scheduled task within windows which could execute an http request, likely using the built-in components of Internet Explorer ... I've never worked with the Windows task scheduler myself ( unless indirectly it's used by the cf task scheduler ), so unfortunately I can't give you more than a suggestion of a direction to seek solutions. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: record linking prob
Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResult s. RecordID)##searchResults.Title#/a .. no matter when I click on it I always get record one ... any suggestions would be appreciated. In all likelyhood, you're missing the query attribute in your cfoutput or cfloop tag, i.e. cfoutput query=searchResults just as an FYI, if you know that the searchResults.recordid is a numeric value ( which it usually is, since most of those turn out to be auto-incremented numbers ) you don't need to specify urlencodedformat() around the value. Hope that saves you some typing. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting and evaluating session variables
Well he is saying that if he opens a new window and types in a URL that does not go to his splash screen that it is not redirecting. If he opens a new window, it should be a different session with different CFID CFTOKEN values. Basically... In application.cfm CFAPPLICATION NAME=myApp CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes SESSIONTIMEOUT=#createTimeSpan(1, 0, 0, 0)# cfparam name=session.initialized default=false cfif session.initalized eq false cflocation url=splash1.cfm addtoken=no /cfif splash1.cfm cfif not(isDefined(session.initialized)) cfset session.initialized = true /cfif splash2 You wont need anything, because application.cfm will handle it... Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 10:51 AM Subject: RE: Setting and evaluating session variables Hi. I think that I see the problem that you are having. My explanation may seem overly simple at first, but bear with me. Session variables are stored on the CF server. A given set of session variables is tied to a given user by two key values: CFID, and CFTOKEN. These values are sent to your machine as cookies when you access any page on the server. Now, as long as you are accessing the server from that machine, and as long as you have cookies enabled and don't replace them, the session variables will stay set for the default expiration time (which is probably set to something like 2 hours in your CF Administrator). So, the reason that you're getting weird behavior is that session.initialized is staying set for at least 2 hours from the time you first hit that page during a given day. This makes testing really hard, right? I think that your application is set up properly, but you are having trouble testing it. I recommend this: Create a page called wipeout.cfm or something that erases all the cookies and session variables that you don't want to keep. I keep a link to this on the link bar in IE, so that I can return to regular user state whenever I need to. The statements you'll need are: CFCOOKIE expires=NOW name=COOKIENAME value=invalid CFLOCK scope=SESSION timeout=30 type=EXCLUSIVE CFSET dummy=StructClear(session) /CFLOCK Repeat the CFCOOKIE line for as many cookies as you need to erase. The CFSET statement will wipe out all session variables in one shot. Also, your test for the value of Session.Initialized should not be for it's value, but for its existence: CFIF not IsDefined(Session.Initialized) CFLOCATION... This should let you test your system without pulling your hair out at what seems like completely inconsistent behavior. Now, however, I want to make sure that you aren't going for something different than what I think. I want to map out a path of use and how it would work under your current layout (assuming a two-hour expiration time for session variables): July 27th 10:15 AM User opens www.yahoo.com 10:17 AM User opens your site (www.yoursite.com/mySecondPage.cfm) She gets bounced to the splash page, since session.initialized wasn't set yet. still 10:17 AM(later in that minute) User returns to www.yoursite.com/mySecondPage.cfm, which now is allowed to completely load, since session.initialized is now set. 10:18 AM After looking at www.yoursite.com/mySecondPage.com, user is so wowed that she goes for a stroll to contemplate the meaning of life. Since the work is super-duper high security, though, she immediately closes the browser and shuts down her computer. 12:17 PM User has returned from her walk, ready to surge forward with her work. She has already turned on her machine, logged in, and launched IE. She promptly goes to the page that inspired this (nearly!) two-hour sojourn: www.yoursite.com/mySecondPage.com. That page will load WITHOUT going to the splash page. Why? Because session.initialized has still not expired (although it's one minute away from doing so), and the CF server knows to look for it under the CFID and CFTOKEN values stored on your user's machine. 12:18 PM User decides that she is no longer so wowed by your page, and immediately browses to www.someothersite.com. She stays away from your site until 4:01 PM. 4:01 PM User once again types in www.yoursite.com/mySecondPage.com. This time, she gets bounced to the splash page. Why? Because the two-hour session variable has expired. If this is the behavior you want, then you're all set. I just wanted to make sure that you weren't under operating under any misconceptions about how it would work. Hope this is helpful, Matthieu -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:28 AM To: CF-Talk Subject: Setting and evaluating session variables cfQuestion type=Rookie I'm trying to write my first web app in CFMX, and am having some
RE: record linking prob
could you post the remaining code around it? i'm assuming that you're using CFLOOP or CFOUTPUT. just those parts would be helpful. and as a checkbrain exerercise, IS there more than one record? -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:35 PM To: CF-Talk Subject: record linking prob Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults. RecordID)##searchResults.Title#/a . no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: record linking prob
It's a silly detail, but are you sure you're within a functioning loop when the href url is generated? Sounds like it is just showing the first searchResults.RecordID from your description. -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:35 AM To: CF-Talk Subject: record linking prob Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults. RecordID)##searchResults.Title#/a . no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting and evaluating session variables
Douglas, Is that right? Maybe I misunderstood your message, but it doesn't seem correct to me that opening a new window would open a new session with new CFID and CFTOKEN values. This is a big point of confusion in my office, where some folks think of a session as an uninterrupted series of page hits to a single site from a single browser window on a single computer. In CF terms, though, any hit from a single computer will get the same session vars until they expire. Please correct me if I'm wrong. Matthieu -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 2:33 PM To: CF-Talk Subject: Re: Setting and evaluating session variables Well he is saying that if he opens a new window and types in a URL that does not go to his splash screen that it is not redirecting. If he opens a new window, it should be a different session with different CFID CFTOKEN values. Basically... In application.cfm CFAPPLICATION NAME=myApp CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes SESSIONTIMEOUT=#createTimeSpan(1, 0, 0, 0)# cfparam name=session.initialized default=false cfif session.initalized eq false cflocation url=splash1.cfm addtoken=no /cfif splash1.cfm cfif not(isDefined(session.initialized)) cfset session.initialized = true /cfif splash2 You wont need anything, because application.cfm will handle it... Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 10:51 AM Subject: RE: Setting and evaluating session variables Hi. I think that I see the problem that you are having. My explanation may seem overly simple at first, but bear with me. Session variables are stored on the CF server. A given set of session variables is tied to a given user by two key values: CFID, and CFTOKEN. These values are sent to your machine as cookies when you access any page on the server. Now, as long as you are accessing the server from that machine, and as long as you have cookies enabled and don't replace them, the session variables will stay set for the default expiration time (which is probably set to something like 2 hours in your CF Administrator). So, the reason that you're getting weird behavior is that session.initialized is staying set for at least 2 hours from the time you first hit that page during a given day. This makes testing really hard, right? I think that your application is set up properly, but you are having trouble testing it. I recommend this: Create a page called wipeout.cfm or something that erases all the cookies and session variables that you don't want to keep. I keep a link to this on the link bar in IE, so that I can return to regular user state whenever I need to. The statements you'll need are: CFCOOKIE expires=NOW name=COOKIENAME value=invalid CFLOCK scope=SESSION timeout=30 type=EXCLUSIVE CFSET dummy=StructClear(session) /CFLOCK Repeat the CFCOOKIE line for as many cookies as you need to erase. The CFSET statement will wipe out all session variables in one shot. Also, your test for the value of Session.Initialized should not be for it's value, but for its existence: CFIF not IsDefined(Session.Initialized) CFLOCATION... This should let you test your system without pulling your hair out at what seems like completely inconsistent behavior. Now, however, I want to make sure that you aren't going for something different than what I think. I want to map out a path of use and how it would work under your current layout (assuming a two-hour expiration time for session variables): July 27th 10:15 AM User opens www.yahoo.com 10:17 AM User opens your site (www.yoursite.com/mySecondPage.cfm) She gets bounced to the splash page, since session.initialized wasn't set yet. still 10:17 AM(later in that minute) User returns to www.yoursite.com/mySecondPage.cfm, which now is allowed to completely load, since session.initialized is now set. 10:18 AM After looking at www.yoursite.com/mySecondPage.com, user is so wowed that she goes for a stroll to contemplate the meaning of life. Since the work is super-duper high security, though, she immediately closes the browser and shuts down her computer. 12:17 PM User has returned from her walk, ready to surge forward with her work. She has already turned on her machine, logged in, and launched IE. She promptly goes to the page that inspired this (nearly!) two-hour sojourn: www.yoursite.com/mySecondPage.com. That page will load WITHOUT going to the splash page. Why? Because session.initialized has still not expired (although it's one minute away from doing so), and the CF server knows to look for it under the CFID and CFTOKEN values stored on your user's machine. 12:18 PM User decides that she is no longer so wowed by your page, and immediately browses to www.someothersite.com. She stays away from your site
Re: site wide missing template handler not working in MX
Yeah, I tried that. Has anyone got this working? Can someone running CFMX confirm that this is a bug please? Or just me.. At 02:44 PM 26/07/02 -0300, you wrote: AFAIK, this path in MX is now relative to the web root directory. Did you try this? Regards, Marcello Frutig. -- Astrolábio Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. At 11:29 AM 26/07/02 -0300, you wrote: Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java for you what do you expect ;) See java has its bad points. :P Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex Hubner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 4:31 PM Subject: It's official: CFMX is 10% faster than CF5 CFMX Performance Brief: CFMX is only 10% faster than CF5 under Win2k boxes: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf Well, almost everybody knows it in it's day-by-day tests/usages... I disagree with the tests. CFMX is not 10% faster than CF5... It looks that MM doesn't take in consideration the time (very long, specially on templates that calls lots of includes, such as fusebox ones), to the just-in-time compiler finish it's job (which takes 100% of my CPU)... I've told once and I'm gonna say it again: it's a pain in the ass wait CFMX compiles my templates everytime I modify it. In a production environment this is acceptable but in a development environment is realy bad! It becames painless if you use 1Gb processors or faster but... Well, does anybody has the same complain? []'s Alex __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT JS Question
Any idea why this isn't working??? Tells me opener.document is not
defined
function setForm() {
opener.document.Form1.name.value = document.name2.employees.value;
self.close();
return false;
}
//--/script
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
Yes, at it's core, CFMX is java, plain and simple. Nearly 0 C code. (Verity, few other things). As for slowness, it's faster than CF5. as for memory management, this, along with the speed issues, is a common complaint about the OLD versions of java, which have been addressed in the current revisions. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 2:17 PM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 so is MX at the core Java? I keep hear that's the gradual plan, migrate away from C... If that is true, how is macromedia addressing Java's great slowness and the infamous memory management/cleanup randomness that stops things? -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:26 PM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 The reason why you don't run into this with PHP, ASP, and JSP (actually, I avoid JSP) is that they are interpreted languages, like the current CFML is sort of, and the old CF was. You do get this with Perl. Perl requires compilation time. Actually, some of the advanced CPAN/Perl/PHP stuff I've done lately does require an App compilation. The fact of the matter is that while we provide you with CFML, a RAD development language, which is then interpreted into Java bytecode, we have not left the RAD ideal, in my mind, RAD is a style of language that allows you rapid development, NOT taking into account the deployment of application, rather, I don't believe that we left RAD behind due to JIT time. While it would be optimal to have all the benefits that we've garnered with CFMX without the compile time, I believe the benefits we have gained outweigh the extra 10-20 seconds it takes to view a source page. You'd get the same thing with Perl. The CFML language is maturing, that's a fact of life. One of the biggest limitations facing RAD languages such as PHP, or ASP even is the fact that there is a barrier in their efficiency when trying to stick to the interpreted schema. PHP has even realized this. That's why you have about 10 trillion PHP modules to bypass (or expand) on the limitations found in an interpreted language. By moving more towards a traditional compile approach, we garner assets in regards to language expansion and integration, and scalability. The performance increase *is* noticeable in a production environment. Scalability is the key. As a general rule, compiled and tuned binaries will almost ALWAYS outrun and outperform interpreted command-driven applications of the same ilk. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:29 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject:
Re: Setting and evaluating session variables
Well, it depends on if they are opening a new window from inside the current application, or if they are opening a new browser window alltogether...If it is a new browser window, then a new CFID and CFTOKEN pair will be generated. Otherwise, it is working off the same session. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 11:41 AM Subject: RE: Setting and evaluating session variables Douglas, Is that right? Maybe I misunderstood your message, but it doesn't seem correct to me that opening a new window would open a new session with new CFID and CFTOKEN values. This is a big point of confusion in my office, where some folks think of a session as an uninterrupted series of page hits to a single site from a single browser window on a single computer. In CF terms, though, any hit from a single computer will get the same session vars until they expire. Please correct me if I'm wrong. Matthieu -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 2:33 PM To: CF-Talk Subject: Re: Setting and evaluating session variables Well he is saying that if he opens a new window and types in a URL that does not go to his splash screen that it is not redirecting. If he opens a new window, it should be a different session with different CFID CFTOKEN values. Basically... In application.cfm CFAPPLICATION NAME=myApp CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes SESSIONTIMEOUT=#createTimeSpan(1, 0, 0, 0)# cfparam name=session.initialized default=false cfif session.initalized eq false cflocation url=splash1.cfm addtoken=no /cfif splash1.cfm cfif not(isDefined(session.initialized)) cfset session.initialized = true /cfif splash2 You wont need anything, because application.cfm will handle it... Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 10:51 AM Subject: RE: Setting and evaluating session variables Hi. I think that I see the problem that you are having. My explanation may seem overly simple at first, but bear with me. Session variables are stored on the CF server. A given set of session variables is tied to a given user by two key values: CFID, and CFTOKEN. These values are sent to your machine as cookies when you access any page on the server. Now, as long as you are accessing the server from that machine, and as long as you have cookies enabled and don't replace them, the session variables will stay set for the default expiration time (which is probably set to something like 2 hours in your CF Administrator). So, the reason that you're getting weird behavior is that session.initialized is staying set for at least 2 hours from the time you first hit that page during a given day. This makes testing really hard, right? I think that your application is set up properly, but you are having trouble testing it. I recommend this: Create a page called wipeout.cfm or something that erases all the cookies and session variables that you don't want to keep. I keep a link to this on the link bar in IE, so that I can return to regular user state whenever I need to. The statements you'll need are: CFCOOKIE expires=NOW name=COOKIENAME value=invalid CFLOCK scope=SESSION timeout=30 type=EXCLUSIVE CFSET dummy=StructClear(session) /CFLOCK Repeat the CFCOOKIE line for as many cookies as you need to erase. The CFSET statement will wipe out all session variables in one shot. Also, your test for the value of Session.Initialized should not be for it's value, but for its existence: CFIF not IsDefined(Session.Initialized) CFLOCATION... This should let you test your system without pulling your hair out at what seems like completely inconsistent behavior. Now, however, I want to make sure that you aren't going for something different than what I think. I want to map out a path of use and how it would work under your current layout (assuming a two-hour expiration time for session variables): July 27th 10:15 AM User opens www.yahoo.com 10:17 AM User opens your site (www.yoursite.com/mySecondPage.cfm) She gets bounced to the splash page, since session.initialized wasn't set yet. still 10:17 AM(later in that minute) User returns to www.yoursite.com/mySecondPage.cfm, which now is allowed to completely load, since session.initialized is now set. 10:18 AM After looking at www.yoursite.com/mySecondPage.com, user is so wowed that she goes for a stroll to contemplate the meaning of life. Since the work is super-duper high security, though, she immediately closes the browser and shuts down her computer. 12:17 PM User has returned from her walk, ready
RE: looping over lists and queries in cfscript
That's exactly what I needed! Thanks! -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 11:19 AM To: CF-Talk Subject: Re: looping over lists and queries in cfscript www.houseoffusion.com/docs/cfscript.htm 8.7 loops over a query and 8.8 loops over a list. has anyone found a good way to loop over lists and queries in cfscript? any ideas would be well appreciated! --Josh __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: It's official: CFMX is 10% faster than CF5
In two of my major apps that I've been able to test, both have seen about a 100% increase in page execution with a single user. Even with debugging on. I'm quite happy with the speed. My main beef with MX is the broken COM support, which means that I can't use MSXML, which I use all the time since cfhttp is a pos. So we can't upgrade any servers, and have to wait for a new server to come online to install MX on. -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 2:18:39 PM, you wrote: twrc I'm actually wondering if some of the complaint about the 'speed' issue is twrc what people are noticing when in development. Let's face it, the debugger twrc application is a hog for whatever it's doing. Every now and then I turn twrc off the debugger so I can get the real speed of what the end user is going twrc to see and I think people are forgetting about that. twrc In a production environment, debugging shouldn't be turned on (in a twrc perfect world, with the perfect qa environment, etc.). Not all of us are twrc disappointed with CFMX, but then... I dunno, not all of us is writing twrc brand new code either. twrc ~Todd twrc On Fri, 26 Jul 2002, Jesse Noller wrote: The reason why you don't run into this with PHP, ASP, and JSP (actually, I avoid JSP) is that they are interpreted languages, like the current CFML is sort of, and the old CF was. You do get this with Perl. Perl requires compilation time. Actually, some of the advanced CPAN/Perl/PHP stuff I've done lately does require an App compilation. The fact of the matter is that while we provide you with CFML, a RAD development language, which is then interpreted into Java bytecode, we have not left the RAD ideal, in my mind, RAD is a style of language that allows you rapid development, NOT taking into account the deployment of application, rather, I don't believe that we left RAD behind due to JIT time. While it would be optimal to have all the benefits that we've garnered with CFMX without the compile time, I believe the benefits we have gained outweigh the extra 10-20 seconds it takes to view a source page. You'd get the same thing with Perl. The CFML language is maturing, that's a fact of life. One of the biggest limitations facing RAD languages such as PHP, or ASP even is the fact that there is a barrier in their efficiency when trying to stick to the interpreted schema. PHP has even realized this. That's why you have about 10 trillion PHP modules to bypass (or expand) on the limitations found in an interpreted language. By moving more towards a traditional compile approach, we garner assets in regards to language expansion and integration, and scalability. The performance increase *is* noticeable in a production environment. Scalability is the key. As a general rule, compiled and tuned binaries will almost ALWAYS outrun and outperform interpreted command-driven applications of the same ilk. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: It's official: CFMX is 10% faster than CF5
On Friday, July 26, 2002, at 11:16 , Paris Lundis wrote: so is MX at the core Java? I keep hear that's the gradual plan, migrate away from C... CFMX is pretty much pure Java. That's why several folks have it running on Mac OSX. I don't know whether it was C or C++ in its earlier guise. If that is true, how is macromedia addressing Java's great slowness and the infamous memory management/cleanup randomness that stops things? Those are pretty much myths about Java. CFMX is (almost) pure Java but outperforms CF5 which was written in C/C++. Java's memory management is much better these days - you're really only talking about garbage collection and time-distributed sweeps are pretty much the norm now to avoid the sudden... stop that used to be so characteristic of that sort of technology. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: record linking prob
Sean, Some things to check: 1. Is your a href... tag below is outside of the looping CFOUTPUT statement that generates your list of results? 2. Are you sure that RecordID is not set to one for all records? 3. What query are you using? 4. On the detail page, how are you referring to the URL variable? (By the way, I would change the name of the variable in the query string: it seems too complicated to me. Try matdetails.cfm?srRecID=#URLEncoded...) If you want, post the code that handles these points and I and others can take a look. But you can probably find the error somewhere in there. I hope this is helpful. Matthieu -Original Message- From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:35 PM To: CF-Talk Subject: record linking prob Hey I am a newbie here and am having abit of troubles ... i am trying to link together a brief results page to a full details page. i am able to create the link, but when I click on it, it always brings me to the same record ... here is my source: a href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults. RecordID)##searchResults.Title#/a . no matter when I click on it I always get record one ... any suggestions would be appreciated. thanks __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion and Netscape Headers
Critter wrote: oi CF-Talk,!! is this a known gig that outputs the header info in Nutscape 6.x ? is there any fix for it? It's a bug in netscape. PHP, ASP and others have it too... I hope they fix it soon... Jesse __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: It's official: CFMX is 10% faster than CF5
My main beef with MX is the broken COM support, which means that I can't use MSXML, which I use all the time since cfhttp is a pos. If you're able to rewrite a little code, you might just use a Java alternative to CFHTTP instead; try the Jakarta io JSP tag library: http://jakarta.apache.org/taglibs/doc/io-doc/intro.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX: ServletContext
Hi! Is it possible to access the javax.servlet.ServletContext interface and its methods from within a CFMX/CFML page? How? It'd be nice to define application-wide parameters in web.xml and read them via getInitParameter and getInitParameterNames methods. Thanks in advance, Marcello Frutig. -- Astrolabio __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: multiple copies of list mail?
thank you! i knew i wasnt going crazy! tony -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 5:14 PM To: CF-Talk Subject: RE: multiple copies of list mail? I'm getting 4 posts of every listing. My filters, rules haven't changed for weeks. Mikey D, HELP Fix this! I'm getting snowed under with dupes! -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:21 PM To: CF-Talk Subject: Re: multiple copies of list mail? Check your filters. Did you add a new one? One of the most common reasons that people receive duplicate messages is that they've got 2 filters filtering the same message and the message gets copied at that point. (the other most common one is being subscribed more than once) sorry if its my mail server effing up, but are many of you getting duplicate postings from the list tonight? odd?? ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Questions (newbie)
Its similar I think, wonder if we're not dinking with the same thing?? :-) Contact me offlist if you like. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 6:43 PM To: CF-Talk Subject: RE: XML Questions (newbie) eric. im glad you have started this thread, kinda ironic. i have an app that i am starting tonight, that seems to be very close in concept, almost exactly what you are trying to do. what i have to do is: 1. gather user data from a form posting (i have this part done) 2. format that data in a specified xml format (i have this part done) 3. send that xml to a remote webservice 4. query that webservice until it sends me back an xml formatted response. 5. take that response, right and left a portion of it, reformat to another xml schema 6. send that xml to a batch file on the local server 7. take the response that the batch file returns, and dump that to a web page for a user to view the response in an html format. is this similar to yours? let me know, maybe we can get down this road with some help from each other! tony -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 5:03 PM To: CF-Talk Subject: RE: XML Questions (newbie) We are on CF 5. We know it's a valid XML file, so great, we use cfsavecontent dump it to a xml variable. Now the receiving server we figured we would send to via CFHTTP...and we will get a response code(s) in XML format, yes, so that's where we are wondering how that handles...its actually a wonderful back and forth 3 times before approval. Argh. Thanks for helping clear up 67% of the battle...we have been on the right track...so CFHTTP the file...your thoughts? Thanks a million! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 3:55 PM To: CF-Talk Subject: Re: XML Questions (newbie) I'll assume that your xml code or packet is valid xml that the other side can understand it. After that it is fairly simple to send it along. You need to get the entire xml packet string into a variable. For examples sake: cfsavecontent var=xmlPacket foo cfoutput query=bars bar#bars.picklejuice#/bar /cfoutput /foo /cfsavecontent So the xmlPacket variable now contains your xml. All you have to do is send it somewhere. Note, the above xml is not valid...just an example. Sending it to the right place is one thing, but has the other end specified _how_ you are supposed to send it? You may simply be able to use cfhttp, let me know, and I shall point in the right direction :). Also the other side of this is that you will be getting back a response xml packet from the other end I presume? That's is where you may want to use SoXML, to get the packet into a CF native datatype (a structure). If you are using MX, you can use it's built in XML functions for this. There are some nice, a cheap Java based, xml parsers for CF as well. FYI: SoXML is just a CF wrapper for MsXML, so it isn't going to work in MX yet, and I don't believe it has the capability to uses msxml to trasmit the packet. -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 4:18:51 PM, you wrote: EH Okay, we are new to the XML game and using CF with it; argh, and EH have one or two general questions I think that after reading up are EH still a bit fuzzy on and would love if someone that has been down EH this road to drop us a quick line offlist. EH Basically, the questions are: we've made up the XML sheet that needs EH to be transmitted to the remote server...with Cfvariables in it, and EH now we think we need to use SOXML to convert the cf template with EH the xml code in it...to a true finished xml document which then EH somehow is transmitted. It's the conversion transmitting process EH that has us a bit befuddled. The coding we've got down. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Questions (newbie)
It is all to a web address, http post required to do the data transfer. And finally, each of the steps is to a separate server (or web address) following through so we are not worried with consecutive requests and the line being open. Okay, maybe we were overthinking ourselves on this one? Thanks for the pointers! Now, when we get that gif image back in our final requesthow do we deal with extracting that? Hahah We'll figure that out I think. Thanks again, Jon. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 5:11 PM To: CF-Talk Subject: Re: XML Questions (newbie) Usually the receiving end is very specific on how they want the xml given to them. If you are using cfhttp there are two ways, either do a http get, which means the xml packet will be sent as a url variable, or an http post, which means the xml packet will be sent as a form variable. You may want to read over my post titled, Re: It's official: CFMX is 10% faster than CF5 if you plan on using cfhttp to send xml. There are issues that may rule out cfhttp. If you can do an http get, life is wonderful, otherwise, you are probably going to need an external component to send the xml, like Lewis Sellers tcpclient (unless you need ssl), or msxml, or depending on what they specify, any one of the other zillion ways to send information across the wire. Now that I think about it, the back and forth three times, is not a big deal, but it may rule out cfhttp, as it is serial only. Meaning it will not reuse the same connection to reply back to the server, on the second go around. It depends on how the other end wants it. Personally I use msxml for all my xml stuff from CF, Dave Watt's will tell you to try TCPClient, and the Lewis Sellers will pop in and say that ssl support is coming as soon as the government gets off it's butt... :) Checking the archives, once you get everything you need to down, the code for the different ways has been posted before. Of course both these ways presume you are on a Windows machine. That doesn't mean I won't post it again, just that you may glean more varied info from the archives :) -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 5:03:12 PM, you wrote: EH We are on CF 5. EH We know it's a valid XML file, so great, we use cfsavecontent dump EH it to a xml variable. Now the receiving server we figured we would EH send to via CFHTTP...and we will get a response code(s) in XML EH format, yes, so that's where we are wondering how that handles...its EH actually a wonderful back and forth 3 times before approval. Argh. EH Thanks for helping clear up 67% of the battle...we have been on the EH right track...so CFHTTP the file...your thoughts? EH Thanks a million! EH Regards, EH Eric J Hoffman EH DataStream Connexion EH www.datastreamconnexion.com EH Delivering Creative Data Solutions EH -Original Message- EH From: Jon Hall [mailto:[EMAIL PROTECTED]] EH Sent: Friday, July 26, 2002 3:55 PM EH To: CF-Talk EH Subject: Re: XML Questions (newbie) EH I'll assume that your xml code or packet is valid xml that the other EH side can understand it. After that it is fairly simple to send it along. EH You need to get the entire xml packet string into a variable. For EH examples sake: cfsavecontent var=xmlPacket foo EH cfoutput query=bars EHbar#bars.picklejuice#/bar EH /cfoutput EH /foo EH /cfsavecontent EH So the xmlPacket variable now contains your xml. All you have to do is EH send it somewhere. Note, the above xml is not valid...just an example. EH Sending it to the right place is one thing, but has the other end EH specified _how_ you are supposed to send it? You may simply be able to EH use cfhttp, let me know, and I shall point in the right direction :). EH Also the other side of this is that you will be getting back a response EH xml packet from the other end I presume? That's is where you may want to EH use SoXML, to get the packet into a CF native datatype (a structure). If EH you are using MX, you can use it's built in XML functions for this. EH There are some nice, a cheap Java based, xml parsers for CF as well. EH FYI: SoXML is just a CF wrapper for MsXML, so it isn't going to work in EH MX yet, and I don't believe it has the capability to uses msxml to EH trasmit the packet. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Questions (newbie)
eric. im glad you have started this thread, kinda ironic. i have an app that i am starting tonight, that seems to be very close in concept, almost exactly what you are trying to do. what i have to do is: 1. gather user data from a form posting (i have this part done) 2. format that data in a specified xml format (i have this part done) 3. send that xml to a remote webservice 4. query that webservice until it sends me back an xml formatted response. 5. take that response, right and left a portion of it, reformat to another xml schema 6. send that xml to a batch file on the local server 7. take the response that the batch file returns, and dump that to a web page for a user to view the response in an html format. is this similar to yours? let me know, maybe we can get down this road with some help from each other! tony -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 5:03 PM To: CF-Talk Subject: RE: XML Questions (newbie) We are on CF 5. We know it's a valid XML file, so great, we use cfsavecontent dump it to a xml variable. Now the receiving server we figured we would send to via CFHTTP...and we will get a response code(s) in XML format, yes, so that's where we are wondering how that handles...its actually a wonderful back and forth 3 times before approval. Argh. Thanks for helping clear up 67% of the battle...we have been on the right track...so CFHTTP the file...your thoughts? Thanks a million! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 3:55 PM To: CF-Talk Subject: Re: XML Questions (newbie) I'll assume that your xml code or packet is valid xml that the other side can understand it. After that it is fairly simple to send it along. You need to get the entire xml packet string into a variable. For examples sake: cfsavecontent var=xmlPacket foo cfoutput query=bars bar#bars.picklejuice#/bar /cfoutput /foo /cfsavecontent So the xmlPacket variable now contains your xml. All you have to do is send it somewhere. Note, the above xml is not valid...just an example. Sending it to the right place is one thing, but has the other end specified _how_ you are supposed to send it? You may simply be able to use cfhttp, let me know, and I shall point in the right direction :). Also the other side of this is that you will be getting back a response xml packet from the other end I presume? That's is where you may want to use SoXML, to get the packet into a CF native datatype (a structure). If you are using MX, you can use it's built in XML functions for this. There are some nice, a cheap Java based, xml parsers for CF as well. FYI: SoXML is just a CF wrapper for MsXML, so it isn't going to work in MX yet, and I don't believe it has the capability to uses msxml to trasmit the packet. -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 4:18:51 PM, you wrote: EH Okay, we are new to the XML game and using CF with it; argh, and EH have one or two general questions I think that after reading up are EH still a bit fuzzy on and would love if someone that has been down EH this road to drop us a quick line offlist. EH Basically, the questions are: we've made up the XML sheet that needs EH to be transmitted to the remote server...with Cfvariables in it, and EH now we think we need to use SOXML to convert the cf template with EH the xml code in it...to a true finished xml document which then EH somehow is transmitted. It's the conversion transmitting process EH that has us a bit befuddled. The coding we've got down. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using Text lists variable in SQL IN operator
Used QuotedValueList along with PreserveSingleQuotes... and it worked! Thanks all! cfset manager_direct_staff = quotedValuelist(get_manager_staff.userid) cfquery name=get_category_avg datasource=byofocal SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROMdbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email in (#preservesingleQuotes(manager_direct_staff)#)) AND (dbo.answer_rating.self = 'n') /cfquery At 07:27 PM 7/26/2002 -0400, Jon Hall wrote: manager_direct_staff is just a list of the records that come back in the get_manager_staff.userid query column right? So get rid of that loop, and just change the second query to this: cfquery name=get_category_avg datasource=emp_review SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROM dbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email IN (#quotedValueList(#get_manager_staff.userid#)) AND (dbo.answer_rating.self = 'n') /cfquery The quotedValueList() function was created exactly for what you are doing, I imagine the format of the list is what is causing your problems. If this doesn't work, can you send the error you are getting? -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 7:05:28 PM, you wrote: MEC I'm having difficulty using the IN operator condition on a text list MEC dynamically generated from previous query. Any suggestions? MEC Cfquery name=get_manager_staff datasource=emp_records MEC SELECT userid MEC FROM emp MEC WHERE status='A' MEC AND level = 2 MEC start with userid='#ATTRIBUTES.manager#' MEC connect by sup_emp_no=prior emp_no MEC and emp_no sup_emp_no MEC /CFQUERY MEC cfparam name=get_manager_staff default= MEC cfparam name=name_here default= MEC cfloop query=get_manager_staff MEC cfset name_here = ' get_manager_staff.userid ' MEC cfset manager_direct_staff = MEC listappend(manager_direct_staff,name_here) MEC /cfloop MEC cfquery name=get_category_avg datasource=emp_review MEC SELECT AVG(dbo.answer_rating.answer_value) as category_avg MEC FROMdbo.answer_rating MEC WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND MEC (dbo.answer_rating.question_id IN MEC (#category_qid#)) AND MEC (dbo.answer_rating.eval_email IN MEC (#manager_direct_staff#)) AND MEC (dbo.answer_rating.self = 'n') MEC /cfquery MEC In this case, I am having some problems using the manager_direct_staff MEC list variable. MEC Thanks SQL experts! __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using Text lists variable in SQL IN operator
Have you mailed the query to yourself (or some other way of looking at the actual query that is being thrown against your dbase)? You may need to use the infamous preservesinglequotes(). -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 7:05 PM To: CF-Talk Subject: Using Text lists variable in SQL IN operator I'm having difficulty using the IN operator condition on a text list dynamically generated from previous query. Any suggestions? cfquery name=get_category_avg datasource=emp_review SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROMdbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email IN (#manager_direct_staff#)) AND (dbo.answer_rating.self = 'n') /cfquery __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using Text lists variable in SQL IN operator
I'm having difficulty using the IN operator condition on a text list dynamically generated from previous query. Any suggestions? Cfquery name=get_manager_staff datasource=emp_records SELECT userid FROM emp WHERE status='A' AND level = 2 start with userid='#ATTRIBUTES.manager#' connect by sup_emp_no=prior emp_no and emp_no sup_emp_no /CFQUERY cfparam name=get_manager_staff default= cfparam name=name_here default= cfloop query=get_manager_staff cfset name_here = ' get_manager_staff.userid ' cfset manager_direct_staff = listappend(manager_direct_staff,name_here) /cfloop cfquery name=get_category_avg datasource=emp_review SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROMdbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email IN (#manager_direct_staff#)) AND (dbo.answer_rating.self = 'n') /cfquery In this case, I am having some problems using the manager_direct_staff list variable. Thanks SQL experts! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX Taking all CPU Resources?
Joe Eugene wrote: None of the below have IMPROVED Performance. 1. Trusted Cache (Enabled) 2. Increased Template Cache Size (decrease Cache pops) 3. Decreased Consecutive Request to 5 4. Restarted CF APP Service serveral times after setting changes. NONE of these have done any good so far. That's weird. Are you using COM objects? Those have had a severe slowdown in MX. If you are using COM, try replacing them with java or cfc's if possible. Otherwise generate stub's for them (that should speedup COM objects quite a bit). Jesse __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: site wide missing template handler not working in MX
On Friday, July 26, 2002, at 02:25 , Brook Davies wrote: I've tried that. And I have moved the file from directory to directory to no avail. Well, it works just fine here (with a .cfm extension). Have you tried just a very simple CF file (e.g., error.cfm containing just one line Error!) and specifying /error.cfm exactly like I suggested? (with error.cfm in your standard CF docroot) Have you looked in the logs to see if any errors are generated when you actually click Submit changes? Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML Questions (newbie)
Usually the receiving end is very specific on how they want the xml given to them. If you are using cfhttp there are two ways, either do a http get, which means the xml packet will be sent as a url variable, or an http post, which means the xml packet will be sent as a form variable. You may want to read over my post titled, Re: It's official: CFMX is 10% faster than CF5 if you plan on using cfhttp to send xml. There are issues that may rule out cfhttp. If you can do an http get, life is wonderful, otherwise, you are probably going to need an external component to send the xml, like Lewis Sellers tcpclient (unless you need ssl), or msxml, or depending on what they specify, any one of the other zillion ways to send information across the wire. Now that I think about it, the back and forth three times, is not a big deal, but it may rule out cfhttp, as it is serial only. Meaning it will not reuse the same connection to reply back to the server, on the second go around. It depends on how the other end wants it. Personally I use msxml for all my xml stuff from CF, Dave Watt's will tell you to try TCPClient, and the Lewis Sellers will pop in and say that ssl support is coming as soon as the government gets off it's butt... :) Checking the archives, once you get everything you need to down, the code for the different ways has been posted before. Of course both these ways presume you are on a Windows machine. That doesn't mean I won't post it again, just that you may glean more varied info from the archives :) -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 5:03:12 PM, you wrote: EH We are on CF 5. EH We know it's a valid XML file, so great, we use cfsavecontent dump it to EH a xml variable. Now the receiving server we figured we would send to EH via CFHTTP...and we will get a response code(s) in XML format, yes, so EH that's where we are wondering how that handles...its actually a EH wonderful back and forth 3 times before approval. Argh. Thanks for EH helping clear up 67% of the battle...we have been on the right EH track...so CFHTTP the file...your thoughts? EH Thanks a million! EH Regards, EH Eric J Hoffman EH DataStream Connexion EH www.datastreamconnexion.com EH Delivering Creative Data Solutions EH -Original Message- EH From: Jon Hall [mailto:[EMAIL PROTECTED]] EH Sent: Friday, July 26, 2002 3:55 PM EH To: CF-Talk EH Subject: Re: XML Questions (newbie) EH I'll assume that your xml code or packet is valid xml that the other EH side can understand it. After that it is fairly simple to send it along. EH You need to get the entire xml packet string into a variable. For EH examples sake: cfsavecontent var=xmlPacket foo EH cfoutput query=bars EHbar#bars.picklejuice#/bar EH /cfoutput EH /foo EH /cfsavecontent EH So the xmlPacket variable now contains your xml. All you have to do is EH send it somewhere. Note, the above xml is not valid...just an example. EH Sending it to the right place is one thing, but has the other end EH specified _how_ you are supposed to send it? You may simply be able to EH use cfhttp, let me know, and I shall point in the right direction :). EH Also the other side of this is that you will be getting back a response EH xml packet from the other end I presume? That's is where you may want to EH use SoXML, to get the packet into a CF native datatype (a structure). If EH you are using MX, you can use it's built in XML functions for this. EH There are some nice, a cheap Java based, xml parsers for CF as well. EH FYI: SoXML is just a CF wrapper for MsXML, so it isn't going to work in EH MX yet, and I don't believe it has the capability to uses msxml to EH trasmit the packet. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ListSort() - SOLVED
Nope. cf_blush It turns out to be caused by low blood sugar. /cf_blush (I figured it out while on the train home) There was a . (period) at the end of each line, stripped off at display time. The text evaluates less than ., so all the ones that ended got bumped below the ones that didn't. Working just as expected, when not an idiot. Thanks for trying anyway. Jerry Johnson [EMAIL PROTECTED] 7/26 5:27p Seems just plain wrong to me... a bug? At 02:15 PM 7/26/02, you wrote: Well, it appears to be putting them in that order on purpose. My previous example was the AFTER sort list. PRE sort was completely jumbled. I would have figured that it would sort like so (first and shortest): A AB AC ACE B But it is always doing AB ACE AC A B I was just wondering if there was a reason that I was completely missing. Jerry Johnson [EMAIL PROTECTED] 07/26/02 04:51PM oi Jerry!! wouldn't it sort on the first letters then keep going down the list till it finds one different then sorts on those? - Critz Macromedia Certified Advanced ColdFusion Developer CFX_ChannelOP Network=Efnet Channel=ColdFusion Friday, July 26, 2002, 4:11:28 PM, you wrote: JJ I just noticed an odd feature of ListSort. JJ When sorting a list of text, using the Text asc sort mode, longer objects appear before shorter objects, if they are otherwise equal. JJ Motor Vehicles - Mild Brain Injury JJ Motor Vehicles - Negligence - Leg Injuries JJ Motor Vehicles - Negligence - No Cause Of Action JJ Motor Vehicles - Negligence - No Cause Of Action JJ Motor Vehicles - Negligence - PTSD JJ Motor Vehicles - Negligence JJ Is this the way you would expect it to behave? JJ A little suprised, JJ Jerry Johnson JJ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
And Canada ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 2:48 PM Subject: Re: Favourite Web Services so far? Alex said on cf-talk: The distance from a zipcode is useful. Wish there was a similar one for the UK Postal Code system. Will __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: It's official: CFMX is 10% faster than CF5
On Friday, July 26, 2002, at 12:36 , Paris Lundis wrote: Well the myths are fairly valid No, the myths are still fairly widely believed :) In fact, there are good Java compilers and VMs that can get very close to native compiled C++ speeds - certainly within 10% last I read. ideally, though it is heading in the better direction due to intelligence and not just faster processors... Yes, hopefully people will find the benefits of the new features outweigh any perceived 'issues' with Java. CF succeeded on its ease of use and simple syntax... other 'real' programming fails for its complexity, cost to implement, longer debugging, etc. There's somewhere around 300,000 ColdFusion developers. Java and C++ both boast much, much larger development communities. I don't think you can say they have 'failed'. CF is also attainable so of course a good number of newbies and such... And CF remains attainable - and hopefully will stay that way for the foreseeable future as well. So being a dummy about the issues with MX and the strategy, what exactly is proving cumbersome or radically different? is compiled code optional or mandatory? CFMX compiles pages to Java bytecode (via Java) and then the JVM interprets that. Previously CF5 'compiled' pages to an intermediate representation and then interpreted that. Where CFMX scores is that the bytecode representation remains on disk to be loaded and interpreted without compilation on subsequent accesses - CF5 had to 'recompile' the page each time. Can users still get that easy to use out of box experience, or is there the Java installation, third party torture and new syntax just to get started? Try downloading the CFMX trial and see for yourself. For the vast majority of people, it installs just as easily as previous CF versions and everything 'just works'. I'm sitting here with a Windows 2K laptop, a Linux laptop and a Mac G4 laptop. Each of them is happily running CFMX and I've had no need to mess with Java installation, third party torture or new syntax to get started... Since getting started, I've downloaded the Oracle 9i Thin Client drivers for Mac and installed those so I can create a suitable data source on my main laptop (easy, not torture). If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Favourite Web Services so far?
Alex said on cf-talk: The distance from a zipcode is useful. Wish there was a similar one for the UK Postal Code system. Will __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OLAP
Has anyone out there connected to MSSQL2000 OLAP cubes using CF? If you have, any suggestions? I'm tearing out my already thinning hair just trying to figure out if it's possible. Ideally, I'd like to be able to analyze a cube the same way folks do it using Excel or Access... Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: Web Services not working... look at this error.
Kumaran, I've tried each of those things. I'm not able to use or register other peoples web services or my own web services. I am trying each of the tutorials and i get the XML RPC error without fail each time. There are no errors in the logs. Grr any other ideas? -Original Message- From: Kumaran Nallore [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:03 AM To: CF-Talk Subject: RE: Help: Web Services not working... look at this error. It looks as if the service did not either start up or had errors while starting up. Some of the things you could try are: 1) Recycle CFMX 2) Verify that there are no errors while the server starts up (check the server.log) 3) Try consuming a CFC web service. HTH -kumaran -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:16 AM To: CF-Talk Subject: Help: Web Services not working... look at this error. Error Occurred While Processing Request The XML-RPC service is not available. This exception is usually caused by service startup failure. Please check your server configuration. The Error Occurred in C:\Inetpub\wwwroot\jontest.cfm: line 3 1 : cfscript 2 : ws = CreateObject(webservice, 3 : http://www.xmethods.net/sd/2001/BabelFishService.wsdl;); 4 : xlatstring = ws.BabelFish(en_es, Hello world, friend); 5 : writeoutput(xlatstring); Please Try The Following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.3705) Remote Address 127.0.0.1 Referer Date/Time 25-Jul-02 09:13 PM Stack Trace (click to expand) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) coldfusion.server.ServiceFactory$ServiceNotAvailableException: The XML-RPC service is not available. at coldfusion.server.ServiceFactory.getXmlRpcService(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: Web Services not working... look at this error.
Can you get any webservice to work anywhere? On Fri, 26 Jul 2002, Jon wrote: Kumaran, I've tried each of those things. I'm not able to use or register other peoples web services or my own web services. I am trying each of the tutorials and i get the XML RPC error without fail each time. There are no errors in the logs. Grr any other ideas? -Original Message- From: Kumaran Nallore [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 10:03 AM To: CF-Talk Subject: RE: Help: Web Services not working... look at this error. It looks as if the service did not either start up or had errors while starting up. Some of the things you could try are: 1) Recycle CFMX 2) Verify that there are no errors while the server starts up (check the server.log) 3) Try consuming a CFC web service. HTH -kumaran -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 12:16 AM To: CF-Talk Subject: Help: Web Services not working... look at this error. Error Occurred While Processing Request The XML-RPC service is not available. This exception is usually caused by service startup failure. Please check your server configuration. The Error Occurred in C:\Inetpub\wwwroot\jontest.cfm: line 3 1 : cfscript 2 : ws = CreateObject(webservice, 3 : http://www.xmethods.net/sd/2001/BabelFishService.wsdl;); 4 : xlatstring = ws.BabelFish(en_es, Hello world, friend); 5 : writeoutput(xlatstring); Please Try The Following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.3705) Remote Address 127.0.0.1 Referer Date/Time 25-Jul-02 09:13 PM Stack Trace (click to expand) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) coldfusion.server.ServiceFactory$ServiceNotAvailableException: The XML-RPC service is not available. at coldfusion.server.ServiceFactory.getXmlRpcService(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at coldfusion.runtime.CFPage.CreateObject(Unknown Source) at cfjontest2ecfm2096548685.runPage(C:\Inetpub\wwwroot\jontest.cfm:3) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX Taking all CPU Resources?
None of the below have IMPROVED Performance. 1. Trusted Cache (Enabled) 2. Increased Template Cache Size (decrease Cache pops) 3. Decreased Consecutive Request to 5 4. Restarted CF APP Service serveral times after setting changes. NONE of these have done any good so far. Joe - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 4:59 PM Subject: Re: CFMX Taking all CPU Resources? Joe Eugene wrote: Trusted Cache was NOT turned on either of the servers (CFMX or CF 5.0) Try a run with trusted cache, this should make MX much faster and more responsive. Have you also tried lowering the number of consecutive requests? This may prove helpful too. MX needs less than 5 with better result (see the mx performance test). Jesse __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DWMX is breaking my code HELP!
On Friday, July 26, 2002, at 11:10 , Brook Davies wrote: I just installed DWMX and setup a few test sites. After saving a few files DreamWeaver added a whole bunch of code to all my tags. For example, what was once: ... And this now breaks in a browser! What is going on here? I am using a custom file extenstion (*.nat), and I am guessing this is part of the problem. But now I have a bunch of broken code. Yes, you need to tell DWMX that .nat is really a ColdFusion file. You need to edit Extensions.txt (in your local user's DW configuration folder) and you also need to edit Configuration/DocumentTypes/MMDocumentTypes.xml in the main DWMX install directory. For Extensions.txt, add NAT to the list of valid extensions and to the list of ColdFusion extensions lower down the file. For MMDocumentTypes.xml, find the line that specifies winfileextension=cfm,cfml and change it to winfileextension=cfm,cfml,nat. Start up DWMX and it should now know that .nat files should be treated the same as .cfm files. Also make sure you have the preferences set to never rewrite code (Preferences... | Code Rewriting : add .nat to the list of file types to never rewrite and turn off any other code rewriting options you don't want) . If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Make CF Server process a new extension .NAP like it does .cfm
Sorry, forgot attachments do not go through here.. take 2 Setting up mappings in IIS and CFMX You need to make changes in two locations: IIS Website Properties HomeDirectory Configuration \CFusionMX\wwwroot\WEB-INF\web.xml Changes to \CFusionMX\wwwroot\WEB-INF\web.xml These changes may have to be made to each site. Additions should be made that resemble those below: - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm/*/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.html/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.html/*/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.cfm/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.cfm/*/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.cfml/url-pattern /servlet-mapping - servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.cfml/*/url-pattern /servlet-mapping You may also have to delete cached classes after applying these changes. Only do this if you still experience problems. I had to as it was not refreshing the page properly. \CFusionMX\wwwroot\WEB-INF\cfclasses Changes to IIS Open the properties in IIS for the website that you are wanting to map. Click on the Home Directory Tab. Click the Configuration... button. Click on the mapping for cfm. Click the edit button. Copy the highlighted text in the Executable text box. Click Cancel. Click Add. Paste the highlighted text in the Executable text box. Type .htm in the Extension text box. (You may use different extensions, but they have to be mapped in both places.) Click OK. Click Add. Paste the highlighted text in the Executable text box. Type .html in the Extension text box. (You may use different extensions, but they have to be mapped in both places.) Click OK. (You may use different extensions, but they have to be mapped in both places.) Restart CF service and Stop and Start the web site. -Original Message- From: Mike Byers [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 4:36 PM To: CF-Talk Subject: RE: Make CF Server process a new extension .NAP like it does .cfm Try this.. See attached. In place of HTML or HTM use NAP -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 2:56 PM To: CF-Talk Subject: RE: Make CF Server process a new extension .NAP like it does .cfm Sean Corfield explained how to do this in his blog, see http://www.corfield.org/blog/. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:06 PM To: CF-Talk Subject: Re: Make CF Server process a new extension .NAP like it does .cfm Has anyone got this working? I tried simply updating the IIS settings (mappings) to reference the same jrun.dll file as the other cf mappings but this did not work for me. Did it work for you? At 06:12 PM 22/07/02 -0400, you wrote: if you are using iis then you can go to the home directory tab of the web site properties and click configuration. ther you can add a mapping, go ahead and look at the cfm mapping and mimic it, except with your .nap extension. - Original Message - From: Steven A. del Sol [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 22, 2002 5:48 PM Subject: Re: Make CF Server process a new extension .NAP like it does .cfm Does anyone know how to make the CF SERVER process pages with and uncommon extension? A long time ago Ben Forta told me how to do this well now I have an application for it.. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: site wide missing template handler not working in MX
I've tried that. And I have moved the file from directory to directory to no avail. At 02:05 PM 26/07/02 -0700, you wrote: On Friday, July 26, 2002, at 10:29 , Brook Davies wrote: Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. If your handler is called error.cfm and it's in the wwwroot (CFMX web root) directory, then the path is /error.cfm (root-relative). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_Image docs
On Fri, 26 Jul 2002 13:32:00 -0700, in cf-talk you wrote: Hey All, Does anybody have the docs for CFX_Image (current version 1.4.5 or older)?? I was under the impression that Jukka's most recent version don't have documents included because he was reworking them, thus you have to make do with the older ones. As he is Finnish I suppose writting the English docs might be a bit of a chore for him. I could be completely wrong however. --min __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: site wide missing template handler not working in MX
On Friday, July 26, 2002, at 10:29 , Brook Davies wrote: Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. If your handler is called error.cfm and it's in the wwwroot (CFMX web root) directory, then the path is /error.cfm (root-relative). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Questions (newbie)
We are on CF 5. We know it's a valid XML file, so great, we use cfsavecontent dump it to a xml variable. Now the receiving server we figured we would send to via CFHTTP...and we will get a response code(s) in XML format, yes, so that's where we are wondering how that handles...its actually a wonderful back and forth 3 times before approval. Argh. Thanks for helping clear up 67% of the battle...we have been on the right track...so CFHTTP the file...your thoughts? Thanks a million! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 3:55 PM To: CF-Talk Subject: Re: XML Questions (newbie) I'll assume that your xml code or packet is valid xml that the other side can understand it. After that it is fairly simple to send it along. You need to get the entire xml packet string into a variable. For examples sake: cfsavecontent var=xmlPacket foo cfoutput query=bars bar#bars.picklejuice#/bar /cfoutput /foo /cfsavecontent So the xmlPacket variable now contains your xml. All you have to do is send it somewhere. Note, the above xml is not valid...just an example. Sending it to the right place is one thing, but has the other end specified _how_ you are supposed to send it? You may simply be able to use cfhttp, let me know, and I shall point in the right direction :). Also the other side of this is that you will be getting back a response xml packet from the other end I presume? That's is where you may want to use SoXML, to get the packet into a CF native datatype (a structure). If you are using MX, you can use it's built in XML functions for this. There are some nice, a cheap Java based, xml parsers for CF as well. FYI: SoXML is just a CF wrapper for MsXML, so it isn't going to work in MX yet, and I don't believe it has the capability to uses msxml to trasmit the packet. -- Jon mailto:[EMAIL PROTECTED] Friday, July 26, 2002, 4:18:51 PM, you wrote: EH Okay, we are new to the XML game and using CF with it; argh, and EH have one or two general questions I think that after reading up are EH still a bit fuzzy on and would love if someone that has been down EH this road to drop us a quick line offlist. EH Basically, the questions are: we've made up the XML sheet that needs EH to be transmitted to the remote server...with Cfvariables in it, and EH now we think we need to use SOXML to convert the cf template with EH the xml code in it...to a true finished xml document which then EH somehow is transmitted. It's the conversion transmitting process EH that has us a bit befuddled. The coding we've got down. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX Taking all CPU Resources?
Joe Eugene wrote: Trusted Cache was NOT turned on either of the servers (CFMX or CF 5.0) Try a run with trusted cache, this should make MX much faster and more responsive. Have you also tried lowering the number of consecutive requests? This may prove helpful too. MX needs less than 5 with better result (see the mx performance test). Jesse __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dynamic body #DynamicContent#
Sorry, I was too terse with my question... I'll be a bit more verbose here. cfheader is used to put dynamic info into the head/head section of the html returned by CF to a browser making a request. I use it all the time to put in clientside javascript. My issue is how to do this to a body tag from deep inside a lot of coldfusion code. I am using the FuseBox technique of running all requests through a toplevel index.cfm file and having that toplevel cfm routine pass control to sublevels. The toplevel index.cfm is what has all the typical opening stuff... like the opening html tag, the head tags, the title tags, etc... it is not until later after the index.cfm has called the sub routines, (or fuses in fusedoc terminology) does the code even know that it would need a specific entry in the body tag. I know cfheader takes care of the head tags how about the body? I'm running CFMX now. Thanks again, Brian At 01:40 PM 7/26/02, you wrote: First, you must set DynamicContentVariable to some value cfset DynamicContentVariable=loademup(); Then you must output the variable using cold fusion body onload=cfoutput#DynamicContentVariable#/cfoutput Finally, it must be saved as a .cfm file (or a file type handled by the Cold Fusion Server) (Hope this is what you were asking) Jerry Johnson [EMAIL PROTECTED] 07/26/02 04:17PM How does one go about putting dynamic content into the body tag? you know... perhaps something like: body onload=#DynamicContentVariable# thanks Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting and evaluating session variables
Douglas, Is that right? Maybe I misunderstood your message, but it doesn't seem correct to me that opening a new window would open a new session with new CFID and CFTOKEN values. This is a big point of confusion in my office, where some folks think of a session as an uninterrupted series of page hits to a single site from a single browser window on a single computer. In CF terms, though, any hit from a single computer will get the same session vars until they expire. Please correct me if I'm wrong. There's an interresting thing that happens with at least Internet Explorer for Windows ( I'm not sure if it's browser, OS or version specific ) where you get a new session ( new cfid and cftoken ) if you open a new window from the desktop or launch bar, instead of using ctrl+n or the file menu to spawn a new window. Not sure exactly why it works this way, but I know it happens, 'cause I do it frequently. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Flash/XML emergency
Hey Jeff, Sorry to hear about your dilema. Fortunately, I think I can help. How are you getting the data? Is it through a web service, or just and XML feed? What format is the date in (eg. 7/26/2002, etc.)? What version of Flash, 5 or MX? Can I see the XML Schema? After I know these things, I can help you plan out this thingy. Best, Scott Van Vliet Ps. Send replies to [EMAIL PROTECTED] -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:32 PM To: CF-Talk Subject: OT: Flash/XML emergency Sorry for the off topic post - I'm in a real jam. I need to pull an XML file into flash and build URLS with the data. In one instance, it needs to be sorted by date. I can not figure out how to sort the data by date in flash/XML. In fact, I don't know Flash at all! It's a learning experience :) Could someone who knows this contact me off-list? Thanks - this got dropped in my lap this afternoon and it's frustrating :) Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic body #DynamicContent#
What I have done in the past is create a Request variable to store
information about my main HTML tags in an action, and then output them in my
display file (Fusebox):
!--- app_globals.cfm ---
cfscript
function initHTML() {
Request.HTML = StructNew();
Request.HTML.head = StructNew();
Request.HTML.body = StructNew();
Request.HTML.body.attributes = StructNew();
}
function getHTMLAttributes(tag) {
var output = ;
var tagStruct = Request.HTML[tag];
for (attrib in tagStruct.attributes) {
output = output lcase(attrib) =
tagStruct.attributes[attrib] ;
}
return output;
}
/cfscript
!--- action/act_header.cfm ---
cfscript
initHTML();
Request.HTML.head.title = This is the HTML Title;
Request.HTML.body.attributes.bgcolor = ##ff;
Request.HTML.body.attributes.topmargin = 0;
Request.HTML.body.attributes.leftmargin = 0;
Request.HTML.body.attributes.onload = doOnLoad();
/cfscript
!--- display/dsp_header.cfm ---
html
head
titlecfoutput#Request.HTML.head.title#/cfoutput/title
script language=Javascript type=text/javascript
!--
function doOnLoad() {
alert(The page has loaded);
}
//--
/script
/head
cfoutput
body#getHTMLAttributes(body)#
/cfoutput
/body
/html
Hope this helps!
--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
Tel 213.244.5205
Email [EMAIL PROTECTED]
Hello Stupid, and welcome to your crappy computer.
- Strong Bad, HomestarRunner.com
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 1:18 PM
To: CF-Talk
Subject: dynamic body #DynamicContent#
How does one go about putting dynamic content into the body tag?
you know... perhaps something like:
body onload=#DynamicContentVariable#
thanks
Brian
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Flash/XML emergency
Sorry for the off topic post - I'm in a real jam. I need to pull an XML file into flash and build URLS with the data. In one instance, it needs to be sorted by date. I can not figure out how to sort the data by date in flash/XML. In fact, I don't know Flash at all! It's a learning experience :) Could someone who knows this contact me off-list? Thanks - this got dropped in my lap this afternoon and it's frustrating :) Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
