Re: CFTicket
Michael, If you are installing the trial, it doesn't work on CF8 as-is. The reason is that it was compiled under CF7, and it seems as though CF7 compiled files don't play well with CF8. A few other customers also had this issue, and we have a special CF8 trial version at: http://www.cornfeed.com/index.cfm/go/download/file/cfticket_209_trial_cf8 The full version, since it's not encrypted, doesn't have this issue and works across CF6-CF8. Cedric > Does CFTicket work with ColdFusion 8? I tried installing 2 times and > get the following error: > > > 500 > ROOT CAUSE: > java.lang.NoSuchMethodError: coldfusion.runtime.CFPage. XmlSearch(Lcol> dfusion/xml/XmlNodeList;Ljava/lang/String;)Lcoldfusion/runtime/Array; > at cfAppInit2ecfc1414867942$funcINIT. > runFunction(C:\CFusionMX7\wwwroot\trial\AppInit.cfc:11) > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) > at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) > at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter. > invoke(UDFMethod.java:324) > at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter. > java:56) > at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) > at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) > at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) > at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) > at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) > at cfApplication2ecfm1312025504. > runPage(C:\CFusionMX7\wwwroot\trial\Application.cfm:31) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) > at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) > at coldfusion.filter.CfincludeFilter.include(CfincludeFilter. > java:33) > at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter. > java:214) > at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter. > java:40) > at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) > at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) > at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter. > java:74) > at coldfusion.filter.ClientScopePersistenceFilter. > invoke(ClientScopePersistenceFilter.java:28) > at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) > at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) > at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) > at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter. > java:22) > at coldfusion.CfmServlet.service(CfmServlet.java:175) > at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet. > java:89) > at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) > at coldfusion.monitor.event.MonitoringServletFilter. > doFilter(MonitoringServletFilter.java:42) > at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter. > java:46) > at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) > at jrun.servlet.FilterChain.service(FilterChain.java:101) > at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) > at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain. > java:42) > at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher. > java:284) > at jrun.servlet.ServletEngineService.dispatch(ServletEngineService. > java:543) > at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService. > java:203) > at jrunx.scheduler.ThreadPool$DownstreamMetrics. > invokeRunnable(ThreadPool.java:320) > at jrunx.scheduler.ThreadPool$ThreadThrottle. > invokeRunnable(ThreadPool.java:428) > at jrunx.scheduler.ThreadPool$UpstreamMetrics. > invokeRunnable(ThreadPool.java:266) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > > > > javax.servlet.ServletException: ROOT CAUSE: > java.lang.NoSuchMethodError: coldfusion.runtime.CFPage. XmlSearch(Lcol> dfusion/xml/XmlNodeList;Ljava/lang/String;)Lcoldfusion/runtime/Array; > at cfAppInit2ecfc1414867942$funcINIT. > runFunction(C:\CFusionMX7\wwwroot\trial\AppInit.cfc:11) > at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) > at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) > at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter. > invoke(UDFMethod.java:324) > at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter. > java
OT: Application Layout/design
Sorry for the OT topic, but I'm looking for someone who can do css-based web application layout/design. This is just a small contract job. I'm looking for something a bit Web2.0'ish (I know that is very generic). If you can help, or have someone you can recommend, please email off-list. Cedric ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HOF digests not working?
I haven't gotten any of the CF-Talk digests for the past 2 days or so. Michael, any changes you made to HOF that would affect the digests going out? Anyone else seeing this issue, or are others still receiving the digests? Cedric ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail message-id
Russ, Check out the following thread: http://www.coldfusionjedi.com/forums/messages.cfm?threadid=59AD010D-0ABA-C3A1-C2B63D5FCB8E3077 Seems there is a workaround. I have not tried it myself though. Cedric >I'm trying to set the message-id for the mail that I'm sending out from our >cf server, but this code doesn't seem to be working. This is the sample >code that I've found while googling > > > >to="[EMAIL PROTECTED] subject="test" server="x.x.x.x" >mailerID="Thunderbird 1.5.0.12 (Windows/20070509)"> > >value="<#createUUID()[EMAIL PROTECTED]>"> > >test > > > > > > > >When the emails come in, this is the message-id: > >Message-ID: [EMAIL PROTECTED] > > > >What am I doing wrong? > > > >Russ > > > > > > > >: ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Desk / Trouble Ticket recommendation?
Rob, Looks like something hit our server Saturday or so, and caused it to become very slow. Anyway, we are working on it and hopefully it'll be back up later today or tomorrow. You can email me off-list if you want another link to the demo which you can try. Cedric >The www.cornfeed.com seems to have been down for the past 3 or 4 days. > >I'm also in the market for a ticket system and would be keen to take a look >around this, I did look into building a custom system a while back but it's >quite a hefty project for what will essentially be a low traffic section of >my application. > >Rob > >-Original Message- >From: Doug Bezona [mailto:[EMAIL PROTECTED] >Sent: 19 March 2007 12:32 >To: CF-Talk >Subject: Re: Help Desk / Trouble Ticket recommendation? > >I'll second this as one worth looking at. I used CFTicket in a previous job, >and liked it a great deal. I had to do some fairly extensive modifications >(primarily adding Oracle support, and also some other business-specific >features). > >I found the code to be well organized and easy to work with, which is rather >important if you actually intend to make modifications. > >Also Andrew, I think that CFTicket would work well for you based on your >privacy requirements. At it's core it's e-mail driven - each "queue" in the >system has a corresponding POP mail box. All e-mail correspondence is >between the requester and the system, and you can set fairly granular >permissions for each queue, so if it's a sensitive issue, you could put the >ticket into a restricted queue to limit who can see the requesters personal >info, and none of the people managing tickets ever has to have their >personal info involved (since the messages come from the queue address, not >an employee address). > > > > >On 3/17/07, Cedric Villat <[EMAIL PROTECTED]> wrote: ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Desk / Trouble Ticket recommendation?
Andrew, We make CFTicket, which is written in ColdFusion and is open source (not free, but affordable). You can see it at www.cornfeed.com. It sounds like it does what you want, but you can check it out as there is an online demo you can play with. Cedric > >Why would it have to be ColdFusion based? Do you want to extend it > etc? Ray > >Camden has one, I can't remember the name though... Lighthouse I > think. > > Yeah, Ray's Lighthouse Pro is great, but when I looked at it last (>1 > year ago) it didn't have what we needed unless I missed it. We need to > track email back and forth from customers, and I need to be able to > protect the identity of some of those responding. I work in the part > of the government that sometimes has to deal with check withholdings, > child support, etc. And sometimes people wanna make it personal :-(. > Right now our solution is to have the webmaster (i.e. ME) forward the > message on on their behalf, so *my* info is exposed! What is up with > that? :-) Uh, don't blame the messenger? And so I want it cf based and > open source so I can learn from the code and possibly modify it. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Fusion Reactor interfering with web services?
Thanks Ryan. The webservices are cfc's. I've got them working on dev environment, cfmx 6.1 updater. The only difference right now between dev and prod environments is a couple of extra hotfixes in production that I haven't yet put in place in dev. They were in dev, but I've since done a complete reinstall. I don't think FusionReactor is the culprit, but the behavior I've been seeing is pretty nutty. At this point, I'm looking at a complete reinstall in production environment to further troubleshoot the issue. They are .class files in my directory, but I'm not running mx 7. Thanks cedric -Original Message- From: Ryan Duckworth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 21, 2006 2:38 PM To: CF-Talk Subject: Re: Fusion Reactor interfering with web services? Are these web services created by CFC's or not? Are you getting a compiler error like this? coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler Can you post the stack trace of the error message that you get? Also, in your WS directories under "\CFusionMX7\stubs" are there .java files or .class files? If there are .java files then there is a java compiler issue. Thanks, Ryan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fusion Reactor interfering with web services?
Hi everyone, My application has several web services that have been working just fine for the last year or so. Due to other server issues that were popping up, ( Jrun memory useage, mice in the server, etc...) I recently went through and installed all the CFMX 6.1 updater hotfixes that appeared to perhaps be involved in the issues I was having. I also installed Fusion-Reactor to help in debugging the issue. Since that time, my web services have all stopped working. I get the following error message: Could not generate stub objects for web service invocation. I've tried deleting the class files, reloading the webservices, and another fix that that refreshes web services http://etc...";)> At this point I'm out of ideas, as the error still exists. There have been no changes to the code in the webservices so I'm confident that this is more of a server config issue. Thanks in advance cedric ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: multiple email addresses in cfmail TO attribute.
Andy, I've always used semi-colons, but I think comma's are the proper way. The reason I use semi-colons is because email addresses can be in the form of: "Blow, Joe" <[EMAIL PROTECTED]> Outlook does this all the time, and if you used a comma, I think things may not work correctly if you use a comma as a delimiter. I suppose the same problem would apply for semi-colons, but I've never seen an email address (or name) with a semi-colon. Cedric >I've never gotten a straight answer on how you can send one email to >multiple recipients. > >subject="New Order Submitted"> > >Do I separate the emails with a comma or with a semicolon? Something else? > >andy matthews >web developer >certified advanced coldfusion programmer >ICGLink, Inc. >[EMAIL PROTECTED] >615.370.1530 x737 >--//-> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Digests?
I haven't gotten the hourly digest of CF-Talk in the past day or two. Are other people getting the digest on schedule? Cedric ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247946 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Changes to files not taking effect
So after a lot of googling and testing on my computer, I figured out the problem. It was my copy of ZoneAlarm which was updated and had a bug: http://download.zonelabs.com/bin/free/information/zap/releaseHistory.html#6.5.722.000 Apparently, it was preventing the Date Modified from being updated properly, which was exactly my issue. If anyone is using ZoneAlarm, I really recommend updating to the latest version so you don't get caught by this bug like I did. Not only does it affect the files I update, but also all AV programs won't work well, since they rely on files changing to know when to scan them. Cedric > I tried using the mapped drive and the path. Same thing. It isn't a > novell network, just a good ol' Windows 2000 server. I'm using Windows > XP as my local machine. I do use versioning, but I end up checking out > the code into a web accessible path on the server, which is where I > then edit the files. > > Still no luck :( Any other ideas? > > Cedric > > >Arg. Have you tried switching the way you map the drive? Using a > "path" vs. > >the mapped drive? > > > >It should work anywayze though, so that's kinda a weenie workaround, > if it > >works. > > > >The mapped drive isn't on novell by any chance? Bleh. Can't think of > a > >scenario where it would work from one app and not two others... > anyone else > >working with the same tools on the same mapped drive? > > > >It doesn't solve the problem, but I'd recommend using some sort of > version > >control instead of working on a mapped drive, as an aside. > > > >Welp, if anything springs to mind, I'll holler, nutt'n so far really > though. > > > >Force be with you, > >:DeN > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244888 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Changes to files not taking effect
I tried using the mapped drive and the path. Same thing. It isn't a novell network, just a good ol' Windows 2000 server. I'm using Windows XP as my local machine. I do use versioning, but I end up checking out the code into a web accessible path on the server, which is where I then edit the files. Still no luck :( Any other ideas? Cedric >Arg. Have you tried switching the way you map the drive? Using a "path" vs. >the mapped drive? > >It should work anywayze though, so that's kinda a weenie workaround, if it >works. > >The mapped drive isn't on novell by any chance? Bleh. Can't think of a >scenario where it would work from one app and not two others... anyone else >working with the same tools on the same mapped drive? > >It doesn't solve the problem, but I'd recommend using some sort of version >control instead of working on a mapped drive, as an aside. > >Welp, if anything springs to mind, I'll holler, nutt'n so far really though. > >Force be with you, >:DeN > >On 6/26/06, Cedric Villat <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Changes to files not taking effect
Well, I've had some luck in figuring this out. It seems that when I update the file on the mapped drive from my local computer with either Homesite or Eclipse, the actual timestamp for the file does not get updated, but the file contents are updated. I assume this is not triggering a File Change Notification on the server, and thus CF doesn't pick up the new version. The odd thing is that if I use Notepad on my local machine to save the file, instead of using Eclipse or Homesite, the file gets correctly updated and the timestamp is also updated. So it only seems to occur with certain apps on my local machine. Does anyone know of any DLL's that control this? Or any apps that might be causing a conflict? I would appreciate it if anyone had any ideas. Cedric > Anyone? I've narrowed the problem down a bit. It is very similar to > this thread from a couple weeks ago: http://www.houseoffusion. > com/cf_lists/messages.cfm/forumid:4/threadid:46408#243849 . > > Basically, if I edit the file remotely from my machine and save it on > the server (via a mapped drive), the changes do not take effect when I > refresh my browser. If I open the file on the dev server and make a > change there, the changes are reflected when I refresh the browser. > Looks like the same sort of Dreamweaver issue from the above post, > except I am using Homesite/Eclipse and not Dreamweaver. > > Can anyone point me in the right direction? Is there an OS issue or > maybe an issue when using mapped drives? > > Thanks, > Cedric > > >Hey everyone. > > > > > > > >On my development server, all of a sudden when I make a change to a > file and > >save it, the changes are not reflected unless I stop and restart the > >ColdFusion service. I don't have trusted cache enabled, nor do I have > Save > >Class files checked. I have tried different web browsers, different > >machines, and cleared the cache on the browsers and still my changes > are not > >seen. This is a CFMX 6.1 server if it helps. > > > > > > > >Has anyone seen anything like this before, or what I can do to solve > it? > > > > > > > >Thanks, > > >Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Changes to files not taking effect
Anyone? I've narrowed the problem down a bit. It is very similar to this thread from a couple weeks ago: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:46408#243849 . Basically, if I edit the file remotely from my machine and save it on the server (via a mapped drive), the changes do not take effect when I refresh my browser. If I open the file on the dev server and make a change there, the changes are reflected when I refresh the browser. Looks like the same sort of Dreamweaver issue from the above post, except I am using Homesite/Eclipse and not Dreamweaver. Can anyone point me in the right direction? Is there an OS issue or maybe an issue when using mapped drives? Thanks, Cedric >Hey everyone. > > > >On my development server, all of a sudden when I make a change to a file and >save it, the changes are not reflected unless I stop and restart the >ColdFusion service. I don't have trusted cache enabled, nor do I have Save >Class files checked. I have tried different web browsers, different >machines, and cleared the cache on the browsers and still my changes are not >seen. This is a CFMX 6.1 server if it helps. > > > >Has anyone seen anything like this before, or what I can do to solve it? > > > >Thanks, > >Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Changes to files not taking effect
Hey everyone. On my development server, all of a sudden when I make a change to a file and save it, the changes are not reflected unless I stop and restart the ColdFusion service. I don't have trusted cache enabled, nor do I have Save Class files checked. I have tried different web browsers, different machines, and cleared the cache on the browsers and still my changes are not seen. This is a CFMX 6.1 server if it helps. Has anyone seen anything like this before, or what I can do to solve it? Thanks, Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Timeout attempting lock
I am getting an error in my application all of a sudden related to a cflock. Here is the error I am seeing: A timeout occurred while attempting to lock checkmail. The timeout is set to 60 seconds, which is plenty long. No matter what I try or how long I wait, the error persists. Restarting the CF server seems to fix the issue, but what is causing this? Thanks, Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Regular Expressions - Strip HTML tags. Please help!!!
CFLib.org is your friend :) Check out the function called StripTags. It does exactly what you want. http://www.cflib.org/udf.cfm?ID=774 Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: StripHtml function that allows some tags
Go look for a function called StripTags. It will do exactly what you want. You can either pass it a list of tags you want to keep, or to strip. It works great! Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234135 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfchart problem
So it looks like the problem was because I had the rotated="true" attribute in the chart, and this was removed in CFMX7. Since the height was my previous width, the chart didn't show up. Does anyone know how I can get my bar chart to rotate 90% in CFMX7? I'm looking for a solution that works in both CFMX6 and 7.1. Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfchart problem
I am seeing some problems with on CFMX7. I have a bar chart that shows up fine in CFMX6.1, but doesn't work in CFMX7. Here is my code: The Queues query looks like: QueueName TicketCount TestQueue8 The chart just doesn't show up in CFMX7.1. The correct flash code is embedded in the page, it just appears blank. Can anyone try the above code on the 2 CFMX's and see if they have the same issue? Or is there a known bug related to this? Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [OT] Future CF Features
Adrian, I made a custom tag called cf_param that does exactly this. If the type of the variable does not match, such as your case, the default value is used. You can get the custom tag at http://www.cornfeed.com. It is a couple years old, but works just fine, as I use it all over the place. Cedric >I had a similar idea ages ago except I think that the setting of the var >should still happen if the type check fails. > > > > > > > >Adrian > >P.S. Did you get my last few emails Mike? I sent the files and a follow-up >email but no reply. > >-Original Message- >From: Michael Dinowitz [mailto:[EMAIL PROTECTED] >Sent: 14 February 2006 20:12 >To: CF-Talk >Subject: [OT] Future CF Features > > >This is a follow up from another post about what happens when someone >removes the ?wsdl from a web service CFC. I'd like to have my first request >be either an admin setting or something else to redirect or choose where to >go when a .cfc is loaded directly in an url without any passed variables. > >The second request deals with CFPARAM with the type attribute set. If this >fails, an error is thrown. In order to deal with the error, the CFPARAM tag >has to be within a try/catch. If we know an error may be thrown from this >tag, why not give the tag the ability to deal with the error. >My suggestion is to keep the tag as is but add the ability to put a closing >CFPARAM tag. What will be placed between the start and end CFPARAM tags is >the code that will be run if there is an error. > >error processing code here to deal with the the id not existing or not being >numeric > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Strip HTML and display
My desired output didn't show up quite right. Anyway, I'm not trying to get rid of CR's after tags. Basically, this text has already been wrapped at some length (65 chars). The problem is it was wrapped text was wrapped while taking into account the HTML. I'm trying to "unwrap" the text, then remove the HTML, then re-wrap it so that the text displays properly. Cedric >Not quite sure what you are trying to accomplish, but I'll give it a whack. > >Are you saying that any CR that happens right after a tag should not >happen, then: > > >[#chr(10)##chr(13)#]+",">","ALL")> > >]*>","","ALL")> > > >On 1/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Strip HTML and display
I'm having trouble displaying a large chunk of text properly. Basically, the text looks something like: This is a test with some test that will wrap around the different lines. I want more text here Essentially, I want to take out all of the HTML tags and redisplay the text. Problem is that just removing the HTML results in the following being displayed: this is a test with some text that will wrap around the different lines. I more text here. This doesn't look so hot. How can I get the "some text..." to appear on the previous line, and also the "more text here" to appear on the previous line. I'm trying to make this look like seamless text, but right now it looks like broken chunks with obvious data removed. Ideally, I'd like all the text on 1 line, that I can then wrap later myself. My initial attemps of removing carriage returns first, stripping HTML, then re-adding CR's didn't work as the real CR's were lost. Any ideas? Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Losing session vars
Thanks for the tip. I ended up using the Web Developer extension to just delete the session/domain cookies, then retried everything and it worked as expected. Thanks! Cedric >Tha should do it. > Any yes, you should be able to just dump the cookies, or if you have >firefox installed you can get a really great extension set for it called the >Web Developer extension set 0.9.4. It allows you to view the cookies you >have set on your browser and it will show you the exact domain they are set >for. > I am assuming that before you set your app to set domain cookies, your >session cookies domain was > www.mysite.com <http://www.mysite.com> > Now it should look like this > mydomain.com <http://mydomain.com> > =] > > >-- >Alan Rother >Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224135 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Losing session vars
Alan, I have the setdomaincookies set to Yes, and even restarted the server in hopes it would take affect. Do I need to set this in conjunction with something else? I suppose I can dump the cookie for both www.mysite.com and secure.mysite.com and make sure that the cfid/cftoken are the same. Any other ideas? Cedric >Cedric, > Make sure you are setting domain level cookies. > setdomaincookies="Yes"> > That is the part of the cfapplication tag setdomaincookies="Yes" > If you do not do this then your sessions are only available to the exact >domain you specify. > HTH > =] >-- >Alan Rother >Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224110 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Losing session vars
Tom, How would I go about checking that? Cedric >On Monday 14 November 2005 01:20, Cedric Villat wrote: >> their cart, etc. Short of adding the CFID and CFTOKEN to every link on the >> site, is there a way around this? I already have setDomainCookies set in my >> cfapplication, hoping that would fix it, but no. > >What is the contents of the actual cookie's being set's host/domain >parameter ? > >-- > >Tom Chiverton >Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Losing session vars
Hey all. I'm having an issue where visitors to my site are losing their session variables when I transfer them from www.mysite.com <http://www.mysite.com/> to secure.mysite.com. Basically, all of the session vars are lost, including the fact that they are logged in, items in their cart, etc. Short of adding the CFID and CFTOKEN to every link on the site, is there a way around this? I already have setDomainCookies set in my cfapplication, hoping that would fix it, but no. Anyone have any ideas how to solve this issue of losing session vars? Thanks! Cedric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: text editor that allow a tab
How about inserting some code behind the scenes yourself? For example, when they hit the tab key (you can use javascript to catch the tab key), insert the code and then afterwards replacing each span with the tab id with a real tab? I assume these people are submitting the form to make sure the query works, and then if so, they are given the actual code? Just an idea. Cedric >Well im looking for an actual tab character. > >See im working on a tool im wanting to release to the community, its a >query browser that lets you test out queries in a page. I developed >it for a company I am consulting for and they have found it pretty >useful. It basically just has textarea, and most of the time people >seem to be copying their sql code into it which will retain their >tabs, but there is no way to insert a tab in while writing directly >into it. Its just a much asked for feature that I dont think is >possible, but just wanted to check. But I dont want it to insert code >of course behind the scenes, I need it to be an actual tab. > > >On 11/11/05, Matt Robertson <[EMAIL PROTECTED]> wrote: >> ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Trouble Ticket Application
Chris, While not free, we sell CFTicket. It's a trouble ticket/help desk program. We offer a discount for non-profit organizations too. It is completely written in CF and is open-source. You can see a list of features and try out a demo if you want at www.cornfeed.com. Feel free to email me off list if you have any questions. Cedric > I've been working on building a system for logging help request calls > for our nonprofit organization. It dawned on me that I'm reinventing > the wheel and that what we need is a help desk/ticket tracking system > that could be adapted to our specific needs. Since this will come out > of my hide (time), I'm wondering if there are any free / open source > help desk/ticket systems already out there. One that is developed in > CF would be better than some other language, but I'm going to be > practical and open-minded about it. > > Thanks in advance if you know of any such apps that exist. > > -- > Chris Montgomery > Airtight Web Services http://www.airtightweb.com > Web Development, Web Project Management, Software Sales > 210-490-2415 (office), 210-232-2790 (mobile) ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222150 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Credit Card processing
John, You are paying less than that for both a gateway as well as a merchant account? If so, I'd be really interested in that deal, as that is by far the best I have seen so far. Cedric >That's very high. I'm at Max right now so I don't have it in front of me but >I can email exact pricing when I get back to the office. We are resellers of >Authorize.net <http://Authorize.net>'s services (fresh, so I don't remember >the entire price sheet) so I can pull the docs when I get back. > >On 10/17/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: >> ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Credit Card processing
Wow, that is a bit much. Is there no one that does both the CC processing and has a merchant account? Or is 2 separate companies required for this sort of thing? Cedric >Same here with verisign and pay flow pro (CF) but I believe the last numbers >I saw were something in the range of 700-800 a year > >.:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > > >-Original Message- >From: Dawson, Michael [mailto:[EMAIL PROTECTED] >Sent: Monday, October 17, 2005 6:53 PM >To: CF-Talk >Subject: RE: Credit Card processing > >We use Verisign Pay Flow Pro. I'm not sure how much it costs, per month >or transaction, but it can't be too much or we wouldn't use it. > >It was setup, in Active Server Pages, by a previous web developer that >is no longer here. We are getting ready to rebuild this part of our web >site and the processing will be done with ColdFusion. > >M!ke > >-Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: Monday, October 17, 2005 5:18 PM >To: CF-Talk >Subject: Credit Card processing > >I'm looking for a credit card processing company. I know many of you >have different companies, so I want to know what you use. > >The volume of sales for the site is fairly low (2-3 transactions per >month). Anyone out there just charge a % of each transaction, vs. paying >a monthly service fee + % of each transaction? > >PayPal is not an option at this point, as I have been burned by them in >the past. I know there are some people on this list that work for CC >processing companies, so please speak up. > >Thanks, >Cedric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Credit Card processing
I'm looking for a credit card processing company. I know many of you have different companies, so I want to know what you use. The volume of sales for the site is fairly low (2-3 transactions per month). Anyone out there just charge a % of each transaction, vs. paying a monthly service fee + % of each transaction? PayPal is not an option at this point, as I have been burned by them in the past. I know there are some people on this list that work for CC processing companies, so please speak up. Thanks, Cedric ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP errors
Paul, I thought I was locking, but I just checked and it was commented out. Doh. I'll see if adding it back makes the RemovedException error go away. Any ideas on the encoding issue? Is there something to test with or debug on this one? Cedric >Are you using CFLOCK to make each account access single threaded? > >Something like > > > > > > > > > > > >That way if a user requests the page twice, the getheaders and delete calls >won't tread on each others toes... That should fix your issue with the >MessageRemovedException errors you're getting. > >Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFPOP errors
I am getting some errors when using CFPOP to retrieve email. The errors seem to happen even when I only get the headers. The errors are like: javax.mail.MessageRemovedException. or sun.io.ByteToCharBig5.getIndex1()[S I tried wrapping the CFPOP in a try/catch block in an attempt to find which email is causing the problem and delete it, but I just get the regular ColdFusion error instead of my cfcatch executing. Anyone else every have these errors? They are occuring very frequently, and are usually because of a malformed auto-response, or some strange Chinese encodings/emails. Anyone have any ideas, other than using something other than CFPOP? Yes, I have the latest JDK installed to, as I followed the instructions from http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42282 to no avail. Cedric ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Mail server
I'm using Windows, because it's the only machine I have here to play with :) Cedric >Personally, I kind of dislike smartermail... granted I'm not using the >latest version, but we've switched over from smartermail to sendmail (on >linux). There are just too many issues in the implementation of Sendmail. >For one thing, the administrator can go and view everyone's passwords. Not >sure if this was fixed in a later version, but this is a no-no in my book. >Also the way it handles aliases made it create thousands upon thousands of >folders on our windows server, and we all know how well windows handles >thousands of folders. > >I know it doesn't help if you have to host on windows, but u never know, it >might be an option for you. Sendmail has been the standard for mail on >linux for a long, long time, and its' not that hard to set up if you're >using webmin or something. You can always throw up something like >SquirelMail for webmail, and you're set. And you won't have the >performance/security issues of smartermail. > >Why are you looking to host it on windows in the first place? > >Russ > >-Original Message- >From: Alan Rother [mailto:[EMAIL PROTECTED] >Sent: Monday, September 19, 2005 7:29 PM >To: CF-Talk >Subject: Re: OT: Mail server > >Smartermail. > http://www.smartertools.com/Products/SmarterMail/Default.aspx > It's not free, but it is pretty cheap and it works really well. > > On 9/19/05, Cedric Villat <[EMAIL PROTECTED]> wrote: >> >> What do you guys recommend as a good Windows-based mail server? Preferably > >> open-source, but paid solution will work too. I checked on sourceforge, >but >> really didn't have much luck finding a Windows server. I just need a basic > >> mail server, that allows for multiple users and webmail, at a minimum. Any > >> ideas? >> >> Cedric >> >> ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Mail server
What do you guys recommend as a good Windows-based mail server? Preferably open-source, but paid solution will work too. I checked on sourceforge, but really didn't have much luck finding a Windows server. I just need a basic mail server, that allows for multiple users and webmail, at a minimum. Any ideas? Cedric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Mail Management Program
Rey, This sounds very similar to our product CFTicket. It has threading, keeps history of customer contacts, allows you to reply/delete/forward all emails from the server, etc. You can take a look at it at http://www.cornfeed.com. There is an online demo that you can try, as well as a trial version (if you have CFMX 7+). The only problem you may have is that the subjects have some identifying string in it, which you may/may not like. Cedric >Hi Guys, > >We're interested in purchasing a mail management application that will >allow us to handle our mail-based customer service needs. > >The system would need to be able to read in mail from our mail server, >store it into a database and allow us to reply, forward, delete, and >maintain a conversation history of our replies to our clients with >proper date/time stamping on all events. It would also have to provide >user based security so that we could limit the type of functionality >that specific customer service reps could see. > >We'd prefer for this solution to: > >1) Include modifiable and easy to understand source code (not interested >in Fusebox-based solutions at this moment) > >2) Preferably be CF based. > >Anyone know of a solution like this? > >Rey... > >-- >http://www.ReyBango.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217960 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfmail not sending messages
My server is acting strangely today. Whenever I use cfmail to send out some mail, it goes to the spool folder, but sits there for about 1 minutes and then goes to the undeliverable folder. I looked at the CF mail logs, and it showed that an error occured, but the reason for the error was blank. No nothing, nada. That doesn't help me. There were some mail server changes recently, but I have no idea how to go about debugging this issue since there is no error. Anyone have any ideas? Cedric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Paging through records
Isaac, This won't work either, because it is possible that some of the ID's between 2 and 52 did not match your original WHERE clause in the first query. Say qry1.id[1] was 2 and qry1.id[50] was 10,000. Then in your second query, you are pulling almost 10,000 records, instead of the 50 that you wanted! Again, this is why my original post used the ID IN () to only get the records you wanted. I went through this discussion by myself about a year ago when I came up with this :) Funny to see everyone has sort of the same though process. Also, this solution works independent of the DB, whether it be Access, MySQL, etc, since no sub-queries are needed. Cedric > > select id from mytable where ... > > >^ gets all id's for applicable records in the table -- we knew this > > > > >^ this does rather assume that you're using either autonumbers or >another sequential numeric identifier for id's in that table, however, >at this point, you now know the first and last ID of the first 50 >records... so for instance if the table started with id 1 and you >deleted 1 and 5, you would have > >startid = 2 >endid = 52 > > > select * from mytable > where id between #stardid# and #endid# > > >^ (no queryparam's I know) ... at this point, since startid is 2 and >end-id is 52, you're actually getting the first 50 records (52-1 = 51 >then subtract the one from the middle, record 5 which was also >deleted, gives you 50 records) > >hth > >> Dave, > > >> Unless I missed your point completely :) > >> Cedric > > >s. isaac dealey 954.522.6080 >new epoch : isn't it time for a change? > >add features without fixtures with >the onTap open source framework > >http://www.fusiontap.com >http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217072 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Paging through records
Dave, This approach doesn't work if you have gaps in your keys, such as after you delete a row. For example, in my case, if your ID's were 1, 51, 101, etc. It would return the first 50 entries, regardless of what their ID's were. In your case, the COUNT doesn't tell you the ID's of the records you are looking for. So if your first query returned 100, and you then queried for records with ID > 50 and ID < 100, you would only get 1 row, instead of the 50. Unless I missed your point completely :) Cedric > I agree with Isaac. The first query could even be: > > > select count(id) as TheCount > > > Wouldn't this make the first query even faster as it's not returning x > records, it's only returning ONE record and then you can reference > TotalCount.TheCount instead of .recordcount the other way? It seems > this would make it even more efficient. > > Yes, it's true that if your table is small, that this could end up > taking more time, but the whole idea is to handle tables that are > large, not small, so this to me seems the most efficient. > > Dave > > -Original Message- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 31, 2005 1:27 PM > To: CF-Talk > Subject: RE: Paging through records > > > > Not in this scenario. > > You have to select ALL records to extract or output the > > ones you want. > > > So my original example was > > > 1. query all the required records > > 2. output the ones you want > > > The one your saying is better > > > 1. query all the required records > > 2. query a subset of those records > > 3. output the records. > > > Thus an extra step to produce the same output. Of course > > querying the > > database a second time is going to take up more memory for > > the 2nd query and > > take longer to process. If you don't believe me, just try > > it for yourself. > > That's gonna depend on the indexing... the first query returns only > the primary key column (which cuts down on time to execute) and the > 2nd query has only the one primary key column filter in the where > clause, which is presumably faster than searching on other columns > (at > least, it definately will be if the db's indexing is done properly). > So it's possible the 2 query approach in this case could actually be > faster... Consider that in the alternative single-query approach, > you're returning x number of columns on y number of records that > won't > be used, which will create drag just like the additional query does > -- > but this 2 query approach also has advantages which reduce the time > to > complete each query, so... the end result will vary. > > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm *> * > The information contained in this message, including attachments, may > contain > privileged or confidential information that is intended to be > delivered only to the > person identified above. If you are not the intended recipient, or the > person > responsible for delivering this message to the intended recipient, > ALLTEL requests > that you immediately notify the sender and asks that you do not read > the message or its > attachments, and that you delete them without copying or sending them > to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Paging through records
What I do, and it seems to scale pretty well, is to run 2 queries. The first query simply pulls the ID's of the matching rows, and the second query pulls all of the data only for the ID's that were queried in the first query. Example: You want to get results 51-100 of your query: SELECT ID FROM myTable WHERE a < 5 and b LIKE '%test%' SELECT * FROM myTable WHERE ID IN (#ArrayToList(toGet)#) Yes, you do 2 trips to the DB, but the first query is quick and will match all of your search parameters. Then you just get the ID's that you are interested in (where in the results the user is). The second query is more time consuming, but gets only the records you want. This seems to scale well into the hundreds of thousands of rows, as long your first query doesn't return too many results. You can obviously make the CF code more efficient, but I just threw this together. Cedric >Like pretty much everyone else, I have always used the following method for >paging through result sets, > > > >And altering those variables to allow 200 records per page or whatever, > >But this means querying ALL records form the database each time, which can >be very excessive when your dealing with a very large database. >Has anyone come up with a good solution of only querying the records you >actually need (rows 40 -59 for example). > > >Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Announce: Blogs onTap 2.0 Beta Released
Isaac, The actual download link returns a 404 error. Cedric >Hi all, > >After slightly more than a week of work I've published the first >release of Blogs onTap 2.0 Beta and would be grateful for any feedback >anyone would like to offer. I would like to get some comparison with >the other free blog applications available for CF recently, although I >haven't had time to install any of them yet myself. > >More information: http://www.fusiontap.com/docs/index/forum/?netaction >=messages/linear&forumthreadid=thr_20050817050021_FBxUvE4ztyZK2QEn > >Download: http://www.fusiontap.com/download > >Requirements: Latest versions of onTap framework and Members onTap >plugin plus Plugin Manager > >Features: > >- Multiple multi-user blogs >- WYSIWYG interface for editing > articles and comments >- Easy skinning (browser-driven > interface uses XSL transformations > and framework XHTML tools) >- Internationalized with > easy translation of articles >- Categories customizable by language/locale >- Search interface >- RSS 2.0 syndication >- Article and comment author images >- Content caching for improved performance >- Browser-driven access rules > allow fine control of users' > ability to access each blog > - read, publish, comment, > moderate and admin > > >s. isaac dealey 954.522.6080 >new epoch : isn't it time for a change? > >add features without fixtures with >the onTap open source framework > >http://www.fusiontap.com >http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC's and limiting DB queries
Barney, This is pretty much what I was wanting to do. I think your first post was the most helpful. I suppose I will implement it right now so that all Person objects are initialized when the getTeamMembers method is called. If/when the bottleneck arises, it shouldn't be much more difficult to implement the lazy loading scheme in the Person object itself. Thanks for the suggestions, just wondering what other people did. Cedric >That is definitely true. But Cedric didn't say he was passing the >result of getTeamMembers to a display page. What if he was just >needed to invoke some method on all the members of the team (like >giving them a "point" for playing in a game last weekend). Then you >definitely need the actual Player objects. > >Not that that's what he's doing, but he didn't specify one way or the other. > >cheers, >barneyb > >On 6/9/05, Jeremy Adams <[EMAIL PROTECTED]> wrote: >> I think something similar was addressed in an earlier thread...this is >> a quote from the thread (think it was by sean corfield): >> >> "Use the query result - it's already an OO abstraction. Do not convert >> your query to an array of objects - aggregate display pages do not >> need objects." > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209151 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFC's and limiting DB queries
There was a post last week about limiting db queries when using CFC's that return array's of objects, or something to that affect. My question is, how feasible is this? For example, if I have a Team CFC, which has a method of getTeamMembers(). I want this method to return of Person objects. I can then loop through this array and do whatever it is I want to do. The problem is if the getTeamMembers() method has to initialize each Person CFC, and the initialize function makes 1 DB call to get that users information, I could potentially be making 10-20 DB calls just to create my TeamMembers array. This invariably gets worse if the Person CFC has another method which runs the init() method of some other CFC. Is there a better way to do this? Like only initializing the data when it gets accessed? Or running a specific query which will populate an array of Person CFC's so it is only 1 DB hit? Any ideas? Thanks, Cedric ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209143 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Tag for Next and Previous searching (like Google)
I made one quite a while back called CF_PageList. It behaves in much the same way as google by moving through the records and pages. You can see it in action and download it at http://www.cornfeed.com. Cedric > Subject: CF Tag for Next and Previous searching (like Google) > From: Stuart Kidd <[EMAIL PROTECTED]> > Date: Mon, 23 May 2005 11:33:34 +0100 > Thread: > http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=40329&forumid=4#207406 > > Hi guys, > > I remember in the past seeing a next/previous CFTag which would create > NEXT > and PREV buttons like Google does as well as other search engines. > > Does anyone know what it is called off hand? > > Thanks, > > Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Case-sensitive Struct keys
Dave, Any ideas on how to do this? The reason I originally did it in a struct, was I could simply find the properties of a word, since it was the key. If I organize the data as an array of structs and have the word value be a key in my struct, wouldn't that require more overhead when searching for that word? Do you have any code that would quickly find a word if this was the case? Cedric >> The probabilities the words "free" and "FREE" would be >> different. But when I stick them in a structure, the >> values get overwritten. > >Perhaps you should use a different model for your data. As you say, "free" >and "FREE" are values. I would recommend organizing your data in such a way >that you use them as values rather than as variable names. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Case-sensitive Struct keys
Michael, The reason for this is because I am implementing a Bayesian filter CFC. In doing so, I create a hash-table of words and their probability of spam. The probabilities the words "free" and "FREE" would be different. But when I stick them in a structure, the values get overwritten. Vince's hashtable is really what I'm after. I guess either I can use the java hashtable as the solution, or do as Issac suggested and hash() the key names myself. Cedric >> From: Cedric Villat [mailto:[EMAIL PROTECTED] > >Why would you want to do this? Keys/Variables with varying names only by >case is NOT a good idea regardless of language. Even though CF doesn't mind, >other languages do, especially Java! Build good habits now to avoid problems >down the road should you venture into other languages. Also, varying case >variables makes code cumbersome to read! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195873 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Case-sensitive Struct keys
So I guess CF doesn't support case-sensitive keys in a structure. For example, given the following code: test = StructNew(); test.a = 5; test.A = 10; I would have hoped that 2 keys would have been made, "a" and "A", but instead only 1 key is made, and has a value of 10. Is there anyway to have CF use case-sensitive keys so that I could do something like the above to get 2 keys? Thanks, Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RegEx help - Solved
Ben, I got it working with: REReplace(text, "((.)\.([^0-9]))|([^0-9]\.(.))", "\2 \3", "all"); Cedric > Ben, > > That makes sense. I get an error though, as it complains about the ?. > What are they for? I thought the ? was the "0 or 1 occurances" > operator. > > Also, would this cover things like: > > 12.2.12.12 ? > > I noticed that my current regex of > m = REReplace(m, "([0-9])\.([0-9])", "\1|\2", "ALL"); > > generate 12|2.12|12. I assume this is because the pointer after the > first replace has passed the single "2". Is there a way around that > too? > > Thanks! > Cedric > > > Assuming CFMX: > > > > rereplace(text,"(?(.)\.([^0-9]))|(?([^0-9])\.(.))", "\1\2", "all"); > > > > Not tested, YMMV, there are a lot of parens and it wouldn't surprise > > > me > > if I'm off somewhere, etc. But the basic idea is to check for > either > > a > > non-number before or after the dot. > > > > --Ben > > > > Cedric Villat wrote: > > > Pete, > > > > > > Thanks, that was the way I thought I would have to go. Just was > > hoping there was an easier way :) I'd still like to see if it can be > > > done in 1 *line* :) Thanks. > > > > > > Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RegEx help
Ben, That makes sense. I get an error though, as it complains about the ?. What are they for? I thought the ? was the "0 or 1 occurances" operator. Also, would this cover things like: 12.2.12.12 ? I noticed that my current regex of m = REReplace(m, "([0-9])\.([0-9])", "\1|\2", "ALL"); generate 12|2.12|12. I assume this is because the pointer after the first replace has passed the single "2". Is there a way around that too? Thanks! Cedric > Assuming CFMX: > > rereplace(text,"(?(.)\.([^0-9]))|(?([^0-9])\.(.))", "\1\2", "all"); > > Not tested, YMMV, there are a lot of parens and it wouldn't surprise > me > if I'm off somewhere, etc. But the basic idea is to check for either > a > non-number before or after the dot. > > --Ben > > Cedric Villat wrote: > > Pete, > > > > Thanks, that was the way I thought I would have to go. Just was > hoping there was an easier way :) I'd still like to see if it can be > done in 1 *line* :) Thanks. > > > > Cedric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RegEx help
Pete, Thanks, that was the way I thought I would have to go. Just was hoping there was an easier way :) I'd still like to see if it can be done in 1 *line* :) Thanks. Cedric >Cedric Villat wrote: > > >I don't think there's any sane way to do this with a single POSIX regexp >(I think I could do it in one with a Perl RE, but it would be ugly); I'd >love to be proved wrong though. . > >bar=rereplace(foo, "([^0-9])\.([^0-9])", "\1 \2", "ALL") > >would be safe, but would miss (say) "a.5"; you don't say what you want >to do with multiple periods either... > >My inclination would be to do it in three bites: replace the periods you >*want* to keep with a character guaranteed not to be in your string, say >SOH, (you can always do a zero'th pass to strip such out), replace all >remaining periods with spaces and finally restore the periods you want: > >temp=rereplace(foo, "([0-9])\.([0-9])", "\1#chr(1)#\2", "ALL"); >temp=replace(temp, ".", " ", "ALL"); >bar=replace(temp, chr(1), ".", "ALL"); > >It's not what you asked for, but it *is* only one regexp :) > >-- >Pete Jordan ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RegEx help
Ade, No, 10.24 is ok and the period should stay. The only time the period should be removed is when it does not appear between 2 numbers. These are examples of where the period should stay: 5.5 50.50 5.50 50.5 a5.6 5.6a But the following should be removed: a.1 1.a a.a Anything beyong the immediate characters around the period are not important. Thanks, Cedric >What about 10.24? Would that have the full stop(period) removed? > >Ade > >-Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: 21 February 2005 01:15 >To: CF-Talk >Subject: RegEx help > > >I'm trying to create a regex that does the following, with little luck so >far. > >I want to remove all periods ( . ) that do not appear between 2 numbers. For >instance, I would want to keep this period: > >5.5 > >But not these: > >www.domain.com > >I want the periods to be replaces with a space in the second example. >Anyone? > >Cheers, >Cedric >-- >No virus found in this outgoing message. >Checked by AVG Anti-Virus. >Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RegEx help
I'm trying to create a regex that does the following, with little luck so far. I want to remove all periods ( . ) that do not appear between 2 numbers. For instance, I would want to keep this period: 5.5 But not these: www.domain.com I want the periods to be replaces with a space in the second example. Anyone? Cheers, Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form action to CFC problems
I tried that originally, but then the CFC complained about not being able to find the other form fields. Strange but true :-/ Cedric >I would switch it back to post and just add ?method=methodName to the action >url. > >Example: > >CFC: bookstore >Method: getBook() > > > > >Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form action to CFC problems
Michael, I changed the form method from "post" to "get" so that it passed the form fields via the URL and magically it started working. What is interesting is that I am still running this site on 6.1, but CFMX7 is installed on that machine on the built-in webserver. Does it make sense that the behavior of my form/cfc would change when running on the same CFMX 6.1 instance, just because I installed CFMX7 on that machine? Cedric >> From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > >> Did you confirm your mappings and locations to the CFCs? Nothing else >> changed? You have the hidden form field "method"? > >I overlooked something in CFMX 7. Seems as though the method name is >required in the URL on the action of the form now... >http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/ >wwhelp.htm > >I did not notice this in CFMX 6.1... but then again, I never called a CFC >method this way either. > >Anyway, not sure if that's your problem, but it may be. > >Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
form action to CFC problems
Something strange has just happened. I have a form where the action points directly to a CFC. This was working great until today. Now when I submit the form, the page gets redirected to the Component Browser Login page. The only thing I can think of is that I installed CFMX7. Has anyone seen this? Anyone have any idea why this started happening or how to stop it so my CFC responds normally? Thanks, Cedric ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFTicket?
Rick, Sorry about our site being down. It should (hopefully) be up by the end of the week. If you have any questions or want me to setup a personal demo for you until the real demo comes back online, just let me know. Also, you should be able to log support calls by creating tickets manually from within CFTicket. Like I said, shoot me an email offline if you have questions. Cedric >Whatever happened to CFTicket? Are they still around? Is the application >worthwhile for low-medium volumes of customer support? > >If not, can anyone recommend another CF (or other) web-based customer >support tracking application? > >TNX. > >Rick Colman ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SQL - LIKE vs. =
Ok, so I'm seeing something interesting. I have a field in my MSSQL which is of type TEXT. I have a query that looks like: SELECT ThreadID FROM Threads WHERE Header LIKE This query will return 0 results. Now if I change the field in the DB to be of type VARCHAR and do something like: SELECT ThreadID FROM Threads WHERE Header = This returns 1 record. The #emails.header# contains some carriage returns. That is the only thing I can think of that is causing the second query to work and the first query to fail. Anyone know for sure if this is the reason, or is there something I'm missing? In the first query I tried placing the %'s around the var, but that didn't change anything. How can I compare these values if I want to keep the field as a TEXT type? Thanks, Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sourceless deployment = EAR/WAR?
Adam, Perfect, just what I was looking for. Thanks for the heads up. Cedric > You can do it that weay but you can also just distribute sourcless > bytecode. > > http://livedocs.macromedia. > com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. > htm?context=ColdFusion_Documentation&file=1762.htm#117147 > > > On Sat, 12 Feb 2005 17:03:31 -0800, Cedric Villat <[EMAIL PROTECTED] > com> wrote: > > Am I right to assume that when I hear abour sourceless deployment in > CFMX7, > > that that really means creating a EAR/WAR package? The thing is I > find it > > overkill to distribute an application with basically a fully > functional > > CFAdmin, etc. Is there just a way to create a sourceless package > that people > > can use on CFMX7? Something like the old encrypt method for files, > but > > obviously more secure? I haven't seen any details on if this is > possible, > > and if it is, how to do it. > > > > Anyone know if this is do-able? > > > > Cheers, > > Cedric > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194451 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Sourceless deployment = EAR/WAR?
Am I right to assume that when I hear abour sourceless deployment in CFMX7, that that really means creating a EAR/WAR package? The thing is I find it overkill to distribute an application with basically a fully functional CFAdmin, etc. Is there just a way to create a sourceless package that people can use on CFMX7? Something like the old encrypt method for files, but obviously more secure? I haven't seen any details on if this is possible, and if it is, how to do it. Anyone know if this is do-able? Cheers, Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194448 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Admin - Digest messages
Michael, I haven't gotten any digest posts since yesterday. Anyone else not getting the digest posts? Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query paging UDF or CFC
I made one called CF_PageList which creates the Next/Previous links and the pages very much like Google. It'll move the page range as you go through the links. Check out www.cornfeed.com for a demo and the download. Thanks, Cedric >Hi, > >I usually add my custom code to CFML templates that return a lot of >records from a db query to add the paging functionality (next/previous >page buttons). > >Is there any UDF or CFC that can be easily plugged into any CFML >template that requires paging functionality? > >I checked the cflib.org and cfczone.org web sites, but no luck. > >Any hint to write my own code to achieve maximum re-use? > >Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Not getting digest - Admin help
Anyone else not getting the Digest messages? I haven't gotten any of the digest posts today or yesterday. I logged in earlier and tried to update my subscription and it saved, but I still haven't gotten anything. I need my CF-Talk fix :) Thanks. Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Directory where Application.cfm resides
Wow, that was too easy. I could have sworn I tried that function :) Thanks Sean.
Cedric
>On Sun, 28 Nov 2004 18:33:11 -0800, Cedric Villat <[EMAIL PROTECTED]> wrote:
>> In my Application.cfm file, before the cfapplication tag is defined, I'm
>> trying to get the absolute path of where the Application.cfm file sits. So
>> far I've tried GetBaseTemplatePath, ExpandPath("."), and a few other tags to
>> get the directory path.
>
>getCurrentTemplatePath()
>--
>Sean A Corfield -- http://www.corfield.org/
>Team Fusebox -- http://www.fusebox.org/
>Breeze Me! -- http://www.corfield.org/breezeme
>Got Gmail? -- I have 1 invite
>
>"If you're not annoying somebody, you're not really alive."
>-- Margaret Atwood
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185487
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Directory where Application.cfm resides
In my Application.cfm file, before the cfapplication tag is defined, I'm
trying to get the absolute path of where the Application.cfm file sits. So
far I've tried GetBaseTemplatePath, ExpandPath("."), and a few other tags to
get the directory path. I can seem to get the right directory if the calling
page is in the same directory as the Application.cfm. If it is in any
subdirectory, that is where I am getting the problem.
If the structure looks like:
c:\inetpub\wwwroot\Application.cfm
c:\inetpub\wwwroot\file1.cfm
c:\inetpub\wwwroot\directory\file2.cfm
Basically, I want to get c:\inetpub\wwwroot\ BEFORE the cfapplication tag is
defined. This needs to happen to matter what template is called, whether
it's file1.cfm or file2.cfm. Like I said beofre, GetBaseTemplate for
file2.cfm would return c:\inetpub\wwwroot\directory\ not c:\inetpub\wwwroot\
.
Any ideas?
Cedric
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185473
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Name can't be empty error?
Bingo, that was it. Now to figure out *why* it became blank. Thanks Raymond. Cedric >It normally means the value you are using for datasource is empty. Ie, > >cfquery name="foo" datasource="#dsn#" > >and dsn is an empty string. > > >On Thu, 07 Oct 2004 12:16:57 -0400, Cedric Villat <[EMAIL PROTECTED]> wrote: >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Name can't be empty error?
Here is the function that the error is thrown in: <--- ERROR HAPPENS HERE EVEN IF I PUT A HERE. SELECT UserID AS ID, FirstName, LastName FROM #_application.config.TABLEPREFIX#SecurityUsers WHERE Username = AND Password = another query here. Only Username and a Password arguments as you can see. Like I said, if I abort immediately within the function, I still get an error. Cedric > Without seeing the code I would say that the function in your CFC > requires an argument named "name" and it can't be empty. > > HTH > > Cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Name can't be empty error?
This error has just popped up on a clients machine. They rebooted, and now when logging into their app, they get the following error: name can't be empty The error points to a query inside of a CFC. Though I noticed that if I put a right AFTER the arguments are defined but before the query, the error still occurs. If I put a right before the function is called, no problem. What does this error mean? I assume the problem occurs somewhere between when I call my function, and when the function starts executing. They have tried restarting the CF server and no luck. Anyone seen this before? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Changing text in undelivrable .cfmail file and resending
The reason this wasn't working is because you are not writing the file back out. After you ReplaceNoCase the mail server, you need to use cffile to write the file back into the undeliverable folder. Though your solution of creating a new cfmail would be just as easy, if not easier, to implement. Cedric Villat http://www.cornfeed.com >Hello all, > >About 1000 emails (.cfmail) are sitting in my Undelivr folder because >I've got the wrong mail server set. With a simple change on the 2nd line >of every .CFMail file, these email files would be OK. Using code from >evolt, I've managed to replace the offending line with the correct mail >server and set it as a variable, but writing it to the .cfmail file is a >different story. Or is it? If I could write this change to the file, I'd >be good to go. Is this possible using CF or any other program? >Hopefully, I'm missing something simple. (I'm using CF 5). > >The code below does everything I want it to except modify the file >before moving it to the Spool folder. Thanks in advance for any >assistance. > > >DEFAULT="C:\CFUSION\MAIL\UNDELIVR\"> > > >NAME="qryDir" SORT="Name" FILTER="*.cfmail"> > > > >VARIABLE="tmpTxt"> > READING #QRYDIR.Name#... > > >Trim(ReplaceNoCase(tmpEmailContents[2],"mail.ioc.state.il.us","ioc-web-n >av"))> > >DESTINATION="#tmpSpoolDefaultPath##qryDir.Name#"> > > > >Sincerely, > >Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion Helpdesk
Brant, We make a ColdFusion help desk called CFTicket. You can find out more about it at www.cornfeed.com. This is the second version we have released and should support most features you can think of. There is a demo on there too so you can play with it and see if it suits your needs. If you have any questions, feel free to email me directly. Cedric > Subject: Coldfusion Helpdesk > From: "Brant Winter" <[EMAIL PROTECTED]> > Date: Thu, 16 Sep 2004 12:13:25 +1000 > Thread: > http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=35406&forumid=4#178572 > > Hi - does anyone know of a coldfusion helpdesk app in existence. I need to > be able to track IT issues in a database, have people log jobs for > helpdesk > staff etc ? I have used a php app called Perldesk in the past, but I would > like to get things across onto a coldfusion box. > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. It is the responsibility of the recipient to ensure that the > onward transmission, opening or use of this message and any attachments > will not adversely affect its systems or data. Please carry out such virus > and other checks, as you consider appropriate. To the fullest extent > allowed by law, no responsibility is accepted by Haematology & Oncology > Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFPOP streamlining
One thing that I came upon when using CFPOP and deciding which method to use, is that if you are using CFMX there is a nasty bug that deals with encoding. Check out http://www.mail-archive.com/[EMAIL PROTECTED]/msg149313.html for some information. I know Raymond Camden also wrote about this bug on his blog. See it here: http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entry&entry=437EFED9-B15B-8957-860C45AFE6E30A4D . Basically, if an email comes in with he unsupported encoding type, anytime you try to do a GETALL with CFPOP, it will break. The only way to recover is to delete the offending email some other way. Due to this bug, all of our CFPOP apps now describe your method of retrieving the headers, and then downloading each piece of email one at a time. Cedric Villat http://www.cornfeed.com Creators of CFTicket - A customer support, trouble ticket application > Subject: CFPOP streamlining > From: "James Smith" <[EMAIL PROTECTED]> > Date: Mon, 21 Jun 2004 11:06:12 +0100 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=33372&forumid=4#167433 > > I have a template that retrieves mail and processes it to extract order > information using cfpop. At any one time it can be retrieving up to 300 > emails of which around 200 will be orders, the rest will be a mixture of > junk and correspondence aimed at the human who reads the account. > > I am currently doing a cfpop to retrieve the headers only, then looping over > these doing another cfpop for each to get the message body resulting in 200+ > pop connections in total. > > Would it be better to just do one connection, retrieve everything, and > simply ignore to 100 message bodies I am not interested in? > > -- > James Smith > [EMAIL PROTECTED] > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Difficult SQL Question
Thanks Pascal, I'll give these a shot. Cedric > Subject: Difficult SQL Question > From: "Pascal Peters" <[EMAIL PROTECTED]> > Date: Wed, 2 Jun 2004 10:31:02 +0200 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=32925&forumid=4#165218 > > If your db supports it, you can use INTERSECT > > SELECT TicketID > FROM fields > WHERE FieldID = 1 > AND Value = '5' > INTERSECT > SELECT TicketID > FROM fields > WHERE FieldID = 2 > AND Value = 'Hello' > > Alternatively you could use group by (supposing (TicketID, FieldID) is > unique) > > SELECT TicketID > FROM fields > WHERE 0 = 1 > OR (FieldID = 1 AND Value = '5') > OR (FieldID = 2 AND Value = 'Hello') > GROUP BY TicketID > HAVING COUNT(TicketID) = 2 > > You can also use subqueries > SELECT * > FROM tickets > WHERE 0 = 0 > AND TicketID IN ( > SELECT TicketID > FROM fields > WHERE FieldID = 1 > AND Value = '5' > ) > AND TicketID IN ( > SELECT TicketID > FROM fields > WHERE FieldID = 2 > AND Value = 'Hello' > ) > > I didn't want to type to much, so there are some modifications you > should make to the code: > - Use everywhere > - Don't use SELECT * but specify the columns you want > - In the group by example COUNT() has to be the number of fields you > want to search on > > > -Original Message- > > From: Cedric Villat [mailto:[EMAIL PROTECTED] > > Sent: woensdag 2 juni 2004 2:01 > > To: CF-Talk > > Subject: Difficult SQL Question > > > > Ok, I have a bit of a problem with some SQL I'm trying to > > build. I have a table of Tickets, and then a table with a > > list of "fields" that are associated with tickets. Here are > > some values for the "fields" table: > > > What I want to do is select the TicketID's that have a > > "(FieldID = 1 AND Value LIKE 'Hello') AND (FieldID = 2 AND > > Value = 5)". In this case I would want Ticket #1 returned. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Difficult SQL Question
Ok, I have a bit of a problem with some SQL I'm trying to build. I have a table of Tickets, and then a table with a list of "fields" that are associated with tickets. Here are some values for the "fields" table: TicketID FieldID Value 1 1 Hello 1 2 5 2 1 Hello 2 3 Boo 3 2 5 What I want to do is select the TicketID's that have a "(FieldID = 1 AND Value LIKE 'Hello') AND (FieldID = 2 AND Value = 5)". In this case I would want Ticket #1 returned. But obviously, this string does not work in the WHERE clause of my query. What I'm wanting to create is a search where people can search different FieldID's and their values, and ONLY those TicketID's matching ALL of the specified fields/values will be returned. I'm having no luck doing this as each value/field pair is its own row. Besides using CF to manipulate the data, can I do this in SQL? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Remove multiple carriage returns
I have some text that I need to remove multiple line breaks from. For example, if my original text is like this: > Hello > My text > goes here I want the text to be replaced with > Hello > My text > goes here Basically I want to clean it up so there are no blank lines. Is there a simple regex or something else to do this? I'm not sure that there will always be a > in the front, I just want to remove the blank lines. Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help Desk Software
Jeff, As Bruce said, CFTicket may fit your needs. You can see a demo of our new version at http://www.cornfeed.com. The demo should be fully functional for you to try. If you have any questions about the demo or the program itself, feel free to email me directly. Cedric Villat > Subject: OT: Help Desk Software. > From: Jeff Waris <[EMAIL PROTECTED]> > Date: Tue, 11 May 2004 15:09:42 -0400 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=32442&forumid=4#162906 > > What does everyone use/recommend? Doesn't have to be CF specific, commercial > or opensource is fine as well. > > We are thinking of implementing one at our company for our clients and I'm > just starting some prelim research and figured I would ask here first. > > Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFTicket 2 released
Just wanted to let everyone know that we have released CFTicket 2. I want to thank everyone on the list who helped us out in the beta testing. Because of all the great people, I am giving 20% off the current price as a thank you to everyone here. You can get more details at http://www.cornfeed.com or email me off-list if you have any questions. Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Softball/Baseball db app? (Maybe OT)
Chris, I actually just finished doing something like this. It allows for different divisions (age groups) and then teams in every division. You can create divisions, teams, and then create games for those teams. You can re-schedule games, have field information, etc. It will also calculate standings based upon the results of the game you entered. There was also a bit more for this site as they wanted it, but the game information could be taken out. If you want a demo or have questions, email me offlist and I'll do my best. Cedric - Original Message - > Subject: Softball/Baseball db app? (Maybe OT) > From: Chris Terrebonne <[EMAIL PROTECTED]> > Date: Tue, 20 Apr 2004 12:24:50 -0400 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=32022&forumid=4#160623 > > Hmmm... I guess the whole mess. Calendar, win/loss, basic game stats, roster, etc. If I can find/create a simple interface, then some of the other parents/volunteers can enter the stats info. > > Since I'm just throwing the idea around, I don't have a clue as to what would be too much info. Dunno. Thoughts? > > Thanks, > Chris > > >How much team information - the whole statsball mess or. .. > > > >Just about any CMS could display team information wins/losses next practice. > > > >I'm certainly interested in what you find out and I might be interested in > >helping you write something for our firm intranet for our firm team. > > > >-Nate > > > > > >-Original Message- > >From: Chris Terrebonne [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, April 20, 2004 10:29 AM > >To: CF-Talk > >Subject: Softball/Baseball db app? (Maybe OT) > > > > > >Morning Everyone, > > > >I was thinking of putting together a db app that tracks the team information > >and game schedule/results for my daughter's softball team. Before I started > >hacking this out, I wanted to see if there was anything pre-rolled for this > >purpose. Anyone done this before? > > > >Thanks in advance, and my apologies if this is OT. > > > >Chris > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF-Talk: Digest every hour
Chris, I actually just finished doing something like this. It allows for different divisions (age groups) and then teams in every division. You can create divisions, teams, and then create games for those teams. You can re-schedule games, have field information, etc. It will also calculate standings based upon the results of the game you entered. There was also a bit more for this site as they wanted it, but the game information could be taken out. If you want a demo or have questions, email me offlist and I'll do my best. Cedric - Original Message - > Subject: Softball/Baseball db app? (Maybe OT) > From: Chris Terrebonne <[EMAIL PROTECTED]> > Date: Tue, 20 Apr 2004 12:24:50 -0400 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=32022&forumid=4#160623 > > Hmmm... I guess the whole mess. Calendar, win/loss, basic game stats, roster, etc. If I can find/create a simple interface, then some of the other parents/volunteers can enter the stats info. > > Since I'm just throwing the idea around, I don't have a clue as to what would be too much info. Dunno. Thoughts? > > Thanks, > Chris > > >How much team information - the whole statsball mess or. .. > > > >Just about any CMS could display team information wins/losses next practice. > > > >I'm certainly interested in what you find out and I might be interested in > >helping you write something for our firm intranet for our firm team. > > > >-Nate > > > > > >-Original Message- > >From: Chris Terrebonne [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, April 20, 2004 10:29 AM > >To: CF-Talk > >Subject: Softball/Baseball db app? (Maybe OT) > > > > > >Morning Everyone, > > > >I was thinking of putting together a db app that tracks the team information > >and game schedule/results for my daughter's softball team. Before I started > >hacking this out, I wanted to see if there was anything pre-rolled for this > >purpose. Anyone done this before? > > > >Thanks in advance, and my apologies if this is OT. > > > >Chris > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Loops in Loops (let's go loopy)
Stuart, I made a custom tag a while back that did just this. Check out http://www.cornfeed.com/index.cfm?p=products&n=cfpagelist for a quick demo and a free download. Cedric Villat > Subject: Loops in Loops (let's go loopy) > From: "Stuart Kidd" <[EMAIL PROTECTED]> > Date: Thu, 11 Mar 2004 06:44:51 -0500 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=31145&forumid=4#156073 > > Hi guys, > > is it possible to put a cfloop inside a cfloop? > > Maybe there's a easier way to do this but basically, like on Google you can see the linked numbers 1,2,3,4,5,6,7,8, etc the amount of pages which have records on. You can click on them instead of having to keep clicking on 'next' throughout the search. > > I have the following code i made: > > > prevresults = url.startresults - 10> > href=""> class="MessageAlert">previous 10 > (url.startresults + 9)> > href=""> ut>" class="MessageAlert">next 10 > step="10"> > class="MessageAlert">#i# > > > > It basically shows the records in groups of 10, and displays a 'next' link and 'previous' if applicable depending on whether there are that many records to show. > > In this case there are about 54 records so my CFLOOP displays links in steps of 10: > > 1 11 21 31 41 51 > > But i would instead prefer them to be page numbers like 1 2 3 4 5. > > Can i make a CFLOOP inside that CFLOOP to count the page numbers or is there an easier way? > > Thanks, > > Stuart > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Parsing HTML Email
So I'm using CFPOP to retrieve email messages and I'm storing the HTML version of the emails in the database. I'm then parsing the email on display, but I want to remove any sort of HTML formatting. I've tried 2 methods, and neither seem bulletproof. First try, I remove all HTML tags from the message using the StripTags udf. Then I converte all Chr(10)&Chr(13) to for display. This seems ok, but the StripTags tag seems to remove things BETWEEN tags, so Hello would actually be removed from the message. Not ideal. So my second try was to use a RegEx to remove everything contained in a < and > and also change the carriage returns to 's. Again, this seems ok, but the output doesn't always come out as desired or the way it *should* look in plain text. Is there an easier way to get the plain text version of my stored message? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: CFTicket 2.0 Beta Test
Hey Folks, We just released the first beta of CFTicket 2.0. For those who don't know, CFTicket is a customer support, trouble ticket application. This new version uses CFC's and therefore requires CFMX. We are having an open beta test for anyone who wishes to test. Just download, install, and presto. We are looking for feedback on features and any bugs that people find. You can find more information at http://www.cornfeed.com/beta/ . If anyone has any other questions or has trouble installing CFTicket 2.0, feel free to contact me directly off-list. Thanks, Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Getting rid of subquery
I could have sworn I tried this myself and it didn't work! Thanks Steve, this worked like a champ. Cedric >Try: > >select StatusName, count(t.status) >from ticketstatus s >left outer join tickets as t > on s.statusid = t.status > and t.owner = 2 >group by statusName > >Steve > > >-Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: Friday, January 30, 2004 3:58 PM >To: CF-Talk >Subject: Getting rid of subquery > > >Can anyone help me with getting rid of this subquery? > > >SELECT Count(t.Status) AS Count, StatusName >FROM TicketStatus s LEFT OUTER JOIN > (SELECT Status > FROM Tickets t > WHERE t.Owner = 2) t > ON t.Status = s.StatusID >GROUP BY StatusName > > >Right now, all of the StatusNames are shown, even if their count is 0. I've >tried just about every join I can think of and it always returns the >StatusNames that have a count greater than 0. I want ALL the StatusNames, >even ones with a count of 0. Anyone? > >Cedric > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Getting rid of subquery
Can anyone help me with getting rid of this subquery? SELECT Count(t.Status) AS Count, StatusName FROM TicketStatus s LEFT OUTER JOIN (SELECT Status FROM Tickets t WHERE t.Owner = 2) t ON t.Status = s.StatusID GROUP BY StatusName Right now, all of the StatusNames are shown, even if their count is 0. I've tried just about every join I can think of and it always returns the StatusNames that have a count greater than 0. I want ALL the StatusNames, even ones with a count of 0. Anyone? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Odd cffile behavior
I'm using cfpop to check mail and download attachments. I'm saving the attachments cfpop gives me to the GetTempDirectory() value. I'm then trying to use cffile to move the file where I need it to be. The problem is that I keep getting this error: Attribute validation error for tag CFFILE. The value of the attribute source, which is currently "C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\flow3.txt" , is invalid. I know the file is there because I can see it, and I also use FileExists on the same variable that I'm passing to cffile and FileExists says the file is really there. Has anyone seen this or have any suggestions? This is a local drive to the server. Anyone? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Session Variables Erroneously Timing Out
I had the same problem with disappearing session vars. Not sure if this applies to you or not, but I had this same thing happen to me when I had an tag with a blank src. Like: As soon as I put something in the src, my disappearing session variables went away. This may have been 6.0 only, not sure though. Cedric > Subject: Session Variables Erroneously Timing Out > From: "Shannon Rhodes" <[EMAIL PROTECTED]> > Date: Fri, 2 Jan 2004 19:55:33 -0500 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=29580&forumid=4#148439 > > I'm stumped and I hope someone can help me. I have a user login application set up which has been working fine. Now, out of the blue, the session variable I use to test whether the user is logged in seems to be either resetting itself or timing out rapidly. The result is that I can log in and see the main menu, but then when I click any other link I'm getting redirected back to the login page. This used to work fine, so I would assume that maybe it's just me...I did just download a new firewall so who knows. But, I had the same problem about a month ago on another site---same user login code I've been using forever, and testing was infuriating because sometimes it would work and sometimes it wouldn't, or it would work fine for me but not for someone else; in that case, I thought maybe it was an MX thing since I had just upgraded, but the site causing me my current problems is still on 5.0. I did a Google search and I see other people posting similar problems with session variables sometimes timing out for no apparent reason, but no one seemed to post a solution. Any ideas? Thanks! > Shannon Rhodes > [EMAIL PROTECTED] > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Select Multiple and GET forms
Charlie, Thanks. There was actually a small bug in my code. You are correct though, that outputting the var actually does give you a comma-delimited list, even though there are 2 values in the URL. Something in your post made me realize my problem. Brainfart on a Monday :) Thanks. Cedric > Cedric: > > on the form's action page, you can loop over the #cgi.query_string# > variable, using the & character as a delimiter: > > > > > > does return a comma delimited list...so #URL. > foods# would give you the list you expected (just in case > you were looking for that *one more* reason to upgrade) : ) > > charlie > > - Original Message - > From: Cedric Villat > To: CF-Talk > Sent: Monday, December 22, 2003 3:06 PM > Subject: Re: Select Multiple and GET forms > > > Peter, > > Yes, I have to use GET since I want the variables in the URL. I know > #form.foods# gives me the comma-delimited list, but why doesn't #url. > foods#? Any more ideas? > > Cedric > > > Any reason why you are using GET an not POST? > > > > Using post you would reference #Form.Foods# for a comma delimited > list > > of > > selections. > > > > Peter Tilbrook > > Transitional Services - Enterprise eSolutions > > Centrelink (http://www.centrelink.gov.au) > > 2 Faulding Street > > Symonston ACT 2609 > > > > Tel: (02) 62115927 > > > > > > > > > > > > "Cedric Villat" > > > > > > <[EMAIL PROTECTED]To: CF-Talk <[EMAIL PROTECTED] > com> > > > > > com> cc: > > > > > > Subject: Select Multiple and GET forms > > > > > > 23/12/2003 09:39 > > > > > > Please respond to > > > > > > cf-talk > | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Select Multiple and GET forms
Peter, Yes, I have to use GET since I want the variables in the URL. I know #form.foods# gives me the comma-delimited list, but why doesn't #url.foods#? Any more ideas? Cedric > Any reason why you are using GET an not POST? > > Using post you would reference #Form.Foods# for a comma delimited list > of > selections. > > Peter Tilbrook > Transitional Services - Enterprise eSolutions > Centrelink (http://www.centrelink.gov.au) > 2 Faulding Street > Symonston ACT 2609 > > Tel: (02) 62115927 > > > > > "Cedric Villat" > > <[EMAIL PROTECTED]To: CF-Talk <[EMAIL PROTECTED]> > > com> cc: > > Subject: Select Multiple and GET forms > > 23/12/2003 09:39 > > Please respond to > > cf-talk | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Select Multiple and GET forms
Peter, Yes, I have to use GET since I want the variables in the URL. I know #form.foods# gives me the comma-delimited list, but why doesn't #url.foods#? Any more ideas? Cedric > Any reason why you are using GET an not POST? > > Using post you would reference #Form.Foods# for a comma delimited list > of > selections. > > Peter Tilbrook > Transitional Services - Enterprise eSolutions > Centrelink (http://www.centrelink.gov.au) > 2 Faulding Street > Symonston ACT 2609 > > Tel: (02) 62115927 > > > > > "Cedric Villat" > > <[EMAIL PROTECTED]To: CF-Talk <[EMAIL PROTECTED]> > > com> cc: > > Subject: Select Multiple and GET forms > > 23/12/2003 09:39 > > Please respond to > > cf-talk | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Select Multiple and GET forms
I have a form with a select box that can have multiple selected. The form method is GET. What is happening is if my select box looks like this: Pizza Burger Salad If I select Pizza and Burger and submit the form, the url has the following: foods=Pizza&foods=Burger If I try and then use #url.foods# all that is returned is 'Burger'. How can I get these values comma separated, such as foods=Pizza,Burger. I know this is possible with checkboxes, but what about with a multiple select? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Server 2000 and Pagination
Calvin, I use a combination of 2 queries, which are VERY fast. SELECT t.TicketID FROM Tickets t WHERE 1 = 1 AND whateverelse then SELECT t.TicketID, etc. FROM Tickets t WHERE 1=1 AND same whatever else from above AND t.TicketID > #ID["TicketID"][Start]# AND t.TicketID < #ID["TicketID"][End]# Basically, this gets ALL the primary keys from the table I'm grabbing from. Then the second query grabs only the page you are on. So if you wanted to grab rows 50-75, the first query would return all rows (can be a lot, but should be fast), and then the second query would only select the ones where the ID was greater than the 50th entry of ID's and smaller than the 75th entry of ID's. This seems to work great for us, and executes in under 1 second for even large queries. Cedric > Subject: SQL Server 2000 and Pagination > From: "Calvin Ward" <[EMAIL PROTECTED]> > Date: Mon, 22 Dec 2003 08:29:43 -0500 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=29454&forumid=4#147856 > > Happy Holidays! > > I'm curious how folks are implementing pagination using SQL Server 2000 and avoiding returning entire recordsets to CF. > > In other words, if I have a search result set of 1,000 rows, and the user will be walking through that recordset 25 rows at a time using methods, how are folks limiting the result set to only the current 25 rows needed to display. > > Thanks, > Calvin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Selecting consecutive records
In MySQL there is a LIMIT function when selecting records. This allows for an beginning row and then to select the next N rows. Is there an equivalent function for MSSQL or Access? It LIMIT a standard SQL function? If not, what is the best way to select, say 10 rows from the middle of a set of records? Obviously I don't want to select 1,000,000 records if I only want records 100-200. Any ideas? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFTicket
Stas, To address Tom's comments, CFTicket does not support attachments. We are working on version 2.0 right now which will allow both the sending and receiving of attachments. If you have any questions or concerns, feel free to contact me off-list. Cedric >I am looking for a trouble-ticket/customer service type of application and >found CFTicket on the Exchange; the developer is at http://www.cornfeed.com/ > >Has anyone implemented this solution and have good/bad comments about it? > >Thank you, > >Stas > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JOIN help
Jochem, Thanks, that worked like a champ. I had a solution using 2 queries, but that wasn't really elegant. This should be much better. Thanks! Cedric > Subject: JOIN help > From: Jochem van Dieten <[EMAIL PROTECTED]> > Date: Sun, 16 Nov 2003 13:53:17 +0100 > Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=28709&forumid=4#144210 > > Pascal Peters wrote: > > SELECT Q.QueueID, XUQ.AccessID, Q.QueueName > > FROM Queues Q > > JOIN SecurityXrefUserQueues XUQ > > ON XUQ.QueueID = Q.QueueID > > WHERE XUQ.UserID = value="#url.uid#"> > > UNION > > SELECT Q.QueueID, NULL AS AccessID, Q.QueueName > > FROM Queues Q > > WHERE Q.QueueID NOT IN ( > > SELECT XUQ.QueueID > > FROM SecurityXrefUserQueues XUQ > > WHERE XUQ.UserID = value="#url.uid#"> > > ) > > How about: > SELECT > q.ID, > uq.AccessID, > AS > userID > FROM > queues q LEFT OUTER JOIN ( > SELECT uq.userID, uq.AccessID, uq.queueID > FROM userqueues uq > WHERE userID = > value="#url.uid#"> > ) uq ON q.ID = uq.queueID; > > Jochem > > -- > Who needs virtual reality > if you can just dream? > - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:JOIN help
No such luck. I had tried that earlier, but tried again just to make sure. A left and right join just return 1 row: UserID QueueID AccessID 2 1 0 I never get the NULL row. Any more ideas? Cedric >A left outer join? > > -Oorspronkelijk bericht- > Van: Cedric Villat [mailto:[EMAIL PROTECTED] > Verzonden: za 15/11/2003 2:52 > Aan: CF-Talk > CC: > Onderwerp: JOIN help > > > Here is my query now, but all it returns are rows in which there are entries > in the UserQueues table. > > SELECT Q.QueueID, AccessID, Q.QueueName > FROM Queues Q > RIGHT JOIN SecurityXrefUserQueues XUQ > ON XUQ.QueueID = Q.QueueID > WHERE XUQ.UserID = #url.uid# > > Anyone have any idea how I can get the above result that I need? > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
JOIN help
Ok, I need some help with a join. I'm close to what I need, but its not exactly there. I have some a table called Queues which is basically an account. Then I have a Users table with my users. I then have a third table which allows for Users and Queues to be linked together. Here are sample tables: Queues IDName 1 Queue1 2 Queue2 Users IDUsername 1 User1 2 User2 UserQueues UserIDQueueID AccessID 1 2 0 2 1 2 2 2 1 As you can see, in the UserQueues table, user 1 is only linked to Queue2. He may not have a link to Queue 1. What I need is to select User 1 and ALL Queues so I get a result like this: UserID QueueID AccessID 1 2 0 1 1 NULL Here is my query now, but all it returns are rows in which there are entries in the UserQueues table. SELECT Q.QueueID, AccessID, Q.QueueName FROM Queues Q RIGHT JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = #url.uid# Anyone have any idea how I can get the above result that I need? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Help
I have a database where the day, month, and year are stored as ints. When I select these 3 columns, I want to make them into a date. Something along these lines: SELECT (m_day, m_month, m_year) AS m_date FROM myTable Obviously that doesn't work, but is there a way to concatenate the 3 ints to create a date in the select statement like that? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Legal?
Well, the domain name HE owns. He has since transferred it to a different host. The website I designed was actually online for a while, but he didn't pay the host so he was canceled. So all that I did was design the site, for free, provided I run the site. He is now threatening to sue me, but who knows. Any ideas? Should I contact a lawyer? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Legal?
Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not paid for. Now, there is no written contract saying that I would do it for him free-of-charge, so I guess he has me there. But at the same time, since there is no contract saying I would do it free-of-charge, since he hasn't paid me, he is not entitled to the site. I told him if he wanted to pay me for the work, I would give it to him, but he keeps threatening me of legal action. Am I wrong here or is he really entitled to the site? Anyone know anything about the law in this case? Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Multilingual site?
Paul, What is a resource bundle? I'm not familiar with them. Also, what is the best way to store all the strings needed to display for a particular language? Should I use a separate table for each language, or just flat text files (I would assume no, since accents and whatnot may not work)? Any ideas? Cedric >1) use mx (redsky). >2) if you even dream about using non latin-1, use unicode encoding from the >start >3) use a db that supports unicode (and is supported by mx). >4) use a resourceBundle for your strings, cache these as appropriate > >> Ok, so I need to make a site that supports multiple languages. This means >> that the db information can be entered in English or French in my case. >What >> do I need to do so that accents and whatnot are stored and displayed >> correctly? Also, I want to keep all the strings used to describe things on >> the site in a separate file so that if a person choosed French, then all >the >> text changes to French. How do people currently do this? If there is some >> documentation or something that outlines how to do this, I would >appreciate >> it. > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138195 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Multilingual site?
Ok, so I need to make a site that supports multiple languages. This means that the db information can be entered in English or French in my case. What do I need to do so that accents and whatnot are stored and displayed correctly? Also, I want to keep all the strings used to describe things on the site in a separate file so that if a person choosed French, then all the text changes to French. How do people currently do this? If there is some documentation or something that outlines how to do this, I would appreciate it. Cedric ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138149 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
