Re: Another Disturbing MX Error
Sean A Corfield wrote: On Wednesday, Dec 18, 2002, at 12:11 US/Pacific, Mark Johnson wrote: I like the theory, but there is one part that doesn't make sense. This error continued to happen until i restarted the service and more explicitily killed jrun. There are about twenty of the errors listed below. While it Yes, I've seen that situation too. Typically, there will be several requests all getting out of memory errors at the same time (since nearly everything in Java makes requests to the allocator). was happening i looked at Task Manager and zeroed in on the jrun process and it was running well under the 512MB limit. Which seems to point to the fact that it was no longer taking up 512MB of memory. If that is true then what That is a little strange but I believe you (because you are not the only person to have monitored memory usage and observed that same behavior). I'm not entirely sure of a suitable explanation for what you are seeing but I'm having a conversation with some folks internally about this. My experience has been that if the system hits an out of memory error and then you stop accessing it for a while, it finishes garbage collecting and recovers fairly well (we've load tested CFMX to that point and had it recover properly several times). Mind you, watching the memory usage on Solaris we *have* seen it hit the high water mark at the point of error. If you run Coldfusion on the new JRockit JVM (7.0sp1 1.4 edition) your CFMX installation will use a different type of garbage collection, which makes it a lot less likely that you'll be running out of memory. And it'll be faster too :) Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: browser stats, mozilla rising
few interesting stories around the web today about mozilla's market share rising... this is the stats from heise.de a big german news site, where mozilla based browsers now accounting for 19.4% of users http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000/ found from a story on mozilazine http://www.mozillazine.org/talkback.html?article=2767 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFMX / JVM
What JVM do Macromedia recommend to use for performance etc...? Is there on? What does everyone else use? (that said, I still cannot get my ColdFusion MX server to start at boot time!) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How to do this without the subselect?
Break it into 2 queries. CFQUERY Name=GetWaivers1 Datasource=#DSN# Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY cfset filter = valuelist(getWaivers1,clientID) CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (#filter#) /CFQUERY -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:50 AM To: CF-Talk Subject: How to do this without the subselect? Hi, all. How can I get the same results as this query with using the subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY (I'll be s glad when they get subselects in mySQL 4.2!) Thanks, Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
MX Support # 44972
This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: How to do this without the subselect?
Rick Faircloth wrote: Hi, all. How can I get the same results as this query with using the subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY (I'll be s glad when they get subselects in mySQL 4.2!) do a left outer join on RentalWaivers in the query and then do a check that where UW.ClientID is null (if, this is standard perfomance improvement anyway as it uses a index...) not in is actually a real bad performance killer... this technique is found in most good oracle books... should work for mysql but i don't know z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Best Way To Integrate Separate Web Sites using CF
OK, It appears that you want to just be able to access another sites database records and files rather than to make sure that the databases/files of these sites are synchronized (contain each other's data). You can do this with a web service on each site that receives a request (from another site) and returns the data requested -- if the sites are CFMX. If you are using prior versions of CF, it's a little more work. You can write a CF stub that resides on each site. As above, the stub receives requests for database records/files from other sites and returns the results. You use WDDX to handle the passing of data, for example; Site a - requestor Site b - target === === -Compose db query -serialize into WDDX -cfhttp pass request -- -receive request -deserialize request -issue query to b's db -serialize results -receive results -- -return results -deserialize results -display results To site a, it appears as if you have local access to site b's database, etc. I have used the stub/WDDX approach to move entire databases from one remote site to another where I didn't have admin privileges to either site. The easiest way to return non-text images/files is to just pass the URL of the image/file to the requestor, which, in turn, passes it to the requesting browser. HTH Dick On Wednesday, December 18, 2002, at 10:15 PM, CounterCW wrote: The databases will be on separate servers. So, unfortunately, I won't be able to do SQL statements. Is there another method I can use? -- Mike At 04:24 PM 12/18/02 -0800, you wrote: Is the database on a separate server or servers? Does each site have a separate database, or do they sahre a common database with a column in each table that identifies the site. You can set up a shared database with each table having a layout such as: Create Table Customer ( CustomerID Integer Identity Primary Key, SiteID Char. * * * ) Then your queries could include site identifiers (or not) SELECT * From Customer WHERE SiteID = 'a' SELECT * From Customer WHERE SiteID IN ('a','c','d') So, you could easily integrate the db. I did a web site with 12 different magazines sharing a common set of programs and 1 common database using the above design. They also shared a common CF server. Based, on the URL accessed initially, a session variable was set which determined the look and feel of the site-- the common programs would work slightly differently depending on the site being accessed. As some others have mentioned, you could use CFMXJ2ee an something like Websphere, JRun or Tomcat and deploy a different CF Server instance for each site. HTH Dick On Wednesday, December 18, 2002, at 03:10 PM, CounterCW wrote: What is the best way to synchronize multiple web sites so that if one website wants to share information with others, they can? For example, if you had these web sites: (each on different servers) a.com b.com c.com d.com If each of these web sites had information in a database, how could Coldfusion retrieve this information so that the articles of data could be seen on their own web sites? Keep in mind that these articles could contain images or other objects. Anyone have ideas? Thanks, -- Mike. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Best Way To Integrate Separate Web Sites using CF
Sounds like you are using Access...if a better db server is not in the budget, you might want to investigate MySQL. That would allow you to make remote db connections. -- jon mailto:[EMAIL PROTECTED] Thursday, December 19, 2002, 1:15:56 AM, you wrote: C The databases will be on separate servers. C So, unfortunately, I won't be able to do SQL statements. C Is there another method I can use? C -- C Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
Rick... sorry I didn't respond sooner about your initial blank screen .. I think that was the same problemquestion -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 2:04 AM To: CF-Talk Subject: RE: cferror Thanks for the in-depth analysis, Mosh! Concerning this comment: This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler. I found that out when I followed your suggestion to CFINCLUDE the user display page from within the admin diagnostic page. I ended up putting this on the application.cfm: CFERROR Type=Exception Template=error_admin.cfm Exception=Any mailto=[EMAIL PROTECTED] Then, from within the error_admin.cfm page, I put: CFINCLUDE Template=error_user.cfm I could send my mail using a CF_Dump var=#Error# custom tag to send the error info to my email, and have the CFIncluded error_user.cfm page display the error info to the user. (After putting the CFOUTPUT's around message for error variables.) It's going to be great having these error messages show up in my email when a user has a problem. Now, I'll be able to call them right away, if needed, instead of waiting until they get frustrated and have to call me! Thanks again! Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:55 AM To: CF-Talk Subject: RE: cferror Mosh Teitelbaum wrote: ... there's no reason why you can't specify multiple CFERROR TYPE=Exception tags as in: CFERROR TYPE=Request TEMPLATE=request_error.cfm CFERROR TYPE=Exception EXCEPTION=Database TEMPLATE=db_exception.cfm CFERROR TYPE=Exception EXCEPTION=Application TEMPLATE=app_exception.cfm I don't know what would happen though if you did the above and also included an EXCEPTION=All. Would it catch everything, ignoring the other tags, or would it catch everything not specified in the other tags. Order might matter in this case (as it does when declaring CFCATCH blocks). Dunno... if I have some time tonight, I'll try to remember to test it out. So I did some testing and, for those that are interested, what follows is a summary of the findings and some items to note: ColdFusion lets you define multiple instances of the CFERROR tag. The two attributes we're concerned with here are TYPE and EXCEPTION. TYPE=Request is something of a catch all declaration that will catch all exceptions not handled by other CFERROR instances and exceptions caused by other error handlers. TYPE=Exception allows you to define handlers on a per exception basis using the EXCEPTION attribute which can specify the name of a single exception type or the word Any which, like TYPE=Request, catches all exceptions not handled by other instances of CFERROR. If you specify EXCEPTION=Any, than a TYPE=Request is used only when an exception is generated in an error handler. That is, the EXCEPTION=Any essentially relieves TYPE=Request of it's role as a catch-all. EXCEPTION=Any will only catch those exceptions not otherwise handled by other EXCEPTION= definitions. So, with the following code: CFERROR TYPE=EXCEPTION EXCEPTION=Any TEMPLATE=any.cfm CFERROR TYPE=EXCEPTION EXCEPTION=Expression TEMPLATE=expression.cfm CFERROR TYPE=EXCEPTION EXCEPTION=MissingInclude TEMPLATE=missingInclude.cfm An Expression exception will be handled by expression.cfm but any OTHER type of exception will be handled by any.cfm. Order of declaration does not matter. As I mentioned above, when you declare EXCEPTION=Any, TYPE=Request is only used to catch exceptions caused by an exception handler. Even if the type of exception thrown by the handler has a defined handler (for example, if the Expression handler in the above code causes a MissingInclude exception to be thrown) it will be handled by the Request handler, not the Exception handler. Finally, I had suggested earlier in the thread that, instead of maintaining multiple displays to inform the user that an error occurred, you can simply define it once -- in the Request handler -- and just include the request handler from your other handlers. This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler. All exception handlers (including Request) can access several variables from the ERROR scope. However, the request handler is limited in that it cannot make use of CFML so, to output the variables from the ERROR scope, you simply escape them with pound signs, no CFOUTPUT needed. But, if the request handler is executed by way of inclusion from another exception handler, it will be executing in the role of a non-request handler, i.e., it needs CFOUTPUT. Because the request handler simply ignores CFML syntax, you can wrap the variables with CFOUTPUT tags and everyone is happy. So that's it. I hope this is helpful. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL
RE: MX Support # 44972
I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: MX Support # 44972
Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Semi-OT: NASD Tech Regulations...
I have a possible job coming up to replace a clients god-forsaken Goldmine system. They are concerned about the NASD regulations and claim that Goldmine is a NASD approved software package. I have searched and come up empty handed and they didn't seem too sure of what regulations/compliance issues there would be. Aside from the e-mail monitoring regulations I have not been able to find any details about NASD tech. regulations. Has anyone else ever had to deal with this before and if so, any pointers to information? Please reply off list so as not to clutter this resource. TIA! Andrew Golden ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX Support # 44972
no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots restarts, no matter what, 2 servers and 3 dev machines, all work fine and the same, updater 2. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT: AOL?
How can I test to ensure that my RDNS is working??? Do I have to have an entry for every domain in reverse DNS??? -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:18 AM To: CF-Talk Subject: RE: OT: AOL? AOL has their own internal RBL and uses their own rules. If you are sending alot of email across their network you should speak with them about being whitelisted. They may be enforcing rDNS, some anti-spam efforts do this. They probably have other criteria as well. Most of the AOL delivery problems that we have had in the past were just related to a few really slow relays that held the mail for a few hours before spitting it back out. Oh, if they are rejecting based on a non-matching rDNS, they should be doing it at the connection and not even accepting the mail. I would be very surprised to hear that it was really being sent to /dev/null. Justin -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:37 PM To: CF-Talk Subject: Re: OT: AOL? Ah, excuse me, the validate sender is a separate selection on the mail server. Sorry = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Jason Burnett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:24 PM Subject: Re: OT: AOL? | I am not trying to start a flame war here, I just want to make sure | noone gets the wrong impression and confirm or disprove what I thought | SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH really | has nothing to do with checking reverse DNS, it is just an | authentication method. | | on Wed Dec 18 samcfug spoke forth with the blessed manuscript | I see your point, however, in my own case as a email hosting provider, I have | the settings set to enable SMTP AUTH, which is what you mean by doing the | reverse lookup. I also make it a point to create the in-addr-arpa record in | DNS that takes care of it. That is just another task in hosting email domains. | In fact I use a script that takes care of all this when adding a new domain. | If you were an ISP or hosting provider, you would be aware of the constant | attacks by others trying to spoof one of your hosted addresses, including virus | attacks such as the Klez Virus, which are all turned away at the server. | That is my story, and I am sticking to it! :-) | | = | Douglas White | group Manager | mailto:[EMAIL PROTECTED] | http://www.samcfug.org = | - Original Message - | From: Lee Fuller [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, December 18, 2002 1:12 PM | Subject: RE: OT: AOL? | | | | Ya know.. Don't let them hit you with that. | | | | The problem is, new sysadmins tend to think that making changes is part | | of their job. We had a MAJOR battle with HUD since one of our customers | | submits information to them via email regularly. Suddenly, they could | | not contact HUD, due to a policy change by a new admin who decided that | | if the email server didn't reverse to the same domain name, it was | | most-likely SPAM. The problem is (as you are most likely aware) that | | with 1000's of domain names on a single mail server, how could you | | POSSIBLY reverse to them? Even if you added all the reverse names to | | your DNS server manually, it would never answer with the right one | | first.. So it's not logical. | | | | We have to force them to understand that THEY are not the ONLY ISP on | | the planet... and that making willy-nilly admin decisions effects | | millions. If we fight back, they will change the policy. | | | | Just my .02... | | | | | | | | | -Original Message- | | | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 11:05 AM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | Aol says my reverse DNS is not up But everything on my | | | server appears to be working fine I guess its my fault | | | after all lol | | | | | | -Original Message- | | | From: Bud [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 1:44 PM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | On 12/18/02, Kris Pilles penned: | | | No good This sucks... MY clients are starting to notice this | | | too. Weird thing is the mail just disappears... No | | | bounce back or | | | anything like that... | | | | | | I occasionally have similar problems. I ALWAYS use them as an | | | opportunity to point out to my client that they are LIKELY losing | | | other e-mails, some which may be
Re: MX Support # 44972
Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX Support # 44972
Yep, as I said its obvisously not 100% across the board, but it is severe enough to be flagged to be fixed/researched. One question : Are your MX installs all on C:\ ? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 13:58 To: CF-Talk Subject: RE: MX Support # 44972 no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots restarts, no matter what, 2 servers and 3 dev machines, all work fine and the same, updater 2. .tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Page Breaks for Printing
Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MX Support # 44972
Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Page Breaks for Printing
CSS. Think it may be IE only. Look at these properties: page-break-after page-break-before page-break-inside You can then set up divs or p blocks that will throw a page break right where you want it. We did this with some success for printing out course certificates and stuff before. Tim -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:03 AM To: CF-Talk Subject: Page Breaks for Printing Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Page Breaks for Printing
We use page breaks, and its a simple tag extention of the classic paragraph Tag p STYLE=page-break-before: always The Complication is deciding on the location to place the Tag. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Page Breaks for Printing Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Page Breaks for Printing
CSS holds the answer. style type=text/css BR.pageEnd{page-break-after: always;} /style . . . This line should be above the break br class=pageEnd This line should be after the page break. This only works in CSS2 compliant browsers. Hope this helps, Pete - Original Message - From: Chad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 9:03 AM Subject: Page Breaks for Printing Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Page Breaks for Printing
Oh cool.. thanks... I have control of what browser the user has so this should work! -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:08 AM To: CF-Talk Subject: RE: Page Breaks for Printing CSS. Think it may be IE only. Look at these properties: page-break-after page-break-before page-break-inside You can then set up divs or p blocks that will throw a page break right where you want it. We did this with some success for printing out course certificates and stuff before. Tim -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:03 AM To: CF-Talk Subject: Page Breaks for Printing Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX Support # 44972
none of my mx installs are on c:\ they are all on other drives, I like to keep c:\ for the OS and let all apps/servers/programs run on d:\ e:\ etc... ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:00 AM To: CF-Talk Subject: RE: MX Support # 44972 Yep, as I said its obvisously not 100% across the board, but it is severe enough to be flagged to be fixed/researched. One question : Are your MX installs all on C:\ ? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 13:58 To: CF-Talk Subject: RE: MX Support # 44972 no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots restarts, no matter what, 2 servers and 3 dev machines, all work fine and the same, updater 2. tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MX Support # 44972
Hi Neil, It happens on my machine. I suspect it's been something that occurs with those of us who have done multiple installs - I could be wrong but I know you and I have! I posted a workaround that I'm using to the list a while ago: Set the cfmx service to be dependent on another service, so it starts later in the process. Add a string value named DependOnService with the value W3SVC under: HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\ This will cause CFMX to start after IIS. Hope that Helps! Christine -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:03 AM To: CF-Talk Subject: RE: MX Support # 44972 Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Page Breaks for Printing
This might be useful. http://www.cfconf.org/cfun-02/talks/DynamicallyGeneratingPDF_files/sld003.cfm Generating PDFs is also a valid option. I've heard that giving the HTML file with a .doc extension instead of html will open it in word, which will render the HTML as a document with page breaks, but I have never tried this on my own. At 09:03 AM 12/19/2002 -0500, you wrote: Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Requirements gathering for the full lifecycle development process
Hi, Wondering if anyone has any good resources for following the full lifecycle development process? Documents, forms things of that nature. I usually either fly by the seat of my pants, or follow FLiP procedures, but now that I am at State I am required to provide far more documentation for all applications. I am looking for things like functional requirements, requirements, gnatt information. Also opinions on processes and methodologies other than Fusebox (not allowed to do the FLiP thing, even though it's being written in FB3). Any help would be appreciated, as would opinions :) tia Timothy Heald Assistant Webmaster Overseas Security Advisory Council U.S. Department of State ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How to do this without the subselect?
Hi, Zac. I played around a bit with the left outer join before mailing to the list, but couldn't work out the syntax for this query. In the original message I did leave out a line which complicates the query. The original query with the subselect looked like the one below. The part about #MultipleWaivers[CurrentRow][1]# is there because I'm looping the query through the names of Utility Companies. I tried some left outer join solutions, but nothing was working. Can you show me how you would set up the code with a left outer join? Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Thanks for your help. Rick CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:46 AM To: CF-Talk Subject: Re: How to do this without the subselect? Rick Faircloth wrote: Hi, all. How can I get the same results as this query with using the subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY (I'll be s glad when they get subselects in mySQL 4.2!) do a left outer join on RentalWaivers in the query and then do a check that where UW.ClientID is null (if, this is standard perfomance improvement anyway as it uses a index...) not in is actually a real bad performance killer... this technique is found in most good oracle books... should work for mysql but i don't know z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX Support # 44972
:-) wahoo, I will have a look -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:16 To: CF-Talk Subject: RE: MX Support # 44972 Hi Neil, It happens on my machine. I suspect it's been something that occurs with those of us who have done multiple installs - I could be wrong but I know you and I have! I posted a workaround that I'm using to the list a while ago: Set the cfmx service to be dependent on another service, so it starts later in the process. Add a string value named DependOnService with the value W3SVC under: HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\ This will cause CFMX to start after IIS. Hope that Helps! Christine -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:03 AM To: CF-Talk Subject: RE: MX Support # 44972 Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Page Breaks for Printing
Quoting Chad [EMAIL PROTECTED]: Has anyone figured out how to make page breaks for printing? http://www.w3.org/TR/REC-CSS2/page.html Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How to do this without the subselect?
Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Updaters...Culmulitive?
Are they? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: AOL?
How can I test to ensure that my RDNS is working??? dig -x ip.ad.re.ss dig for win32 can be had at ftp.isc.org. or free registration to get to this page: http://preview.samspade.org/t/ or: http://www.dnsstuff.com/ Do I have to have an entry for every domain in reverse DNS??? The critical ones are any ip's that are SMTP clients sending mail to other mail servers. Each sending ip should have matching PTR and A records. Of course, the reverse zone delegation must be done and the delegated NS responding. For all CF or web apps that send mail: 1. the envelope @sender.domain must have A and/or MX records. 2. The MX for @sender.domain must accept mail for [EMAIL PROTECTED] That is, in your CF apps that send mail (and that you want to give the best chance of being delivered), just don't invent any old [EMAIL PROTECTED] You will have no success with MX's that do sender address verification or DNS validations of @sender.domain. Len ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Updaters...Culmulitive?
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Are they? Release notes :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Updaters...Culmulitive?
- Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:26 PM Subject: Updaters...Culmulitive? Are they? Yes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Please help me achieve this with CF and Javascrip please
Hi Neil I e-mailed a question to you at the start of December. What I was and still am trying to achieve was creating related selects generated from one database table and you provided me with some code. I am getting somewhere with this now and there is only one small part that needs to be resolved (javascript problem) before my deadline tommorrow for this to work correctly, and I am contacting you for your expert opinion with the hope of a possible solution please. Using the code below the first select box is being populated from the database as it should, however when I select an option from this list the second select does not list the related items and there is a javascript error 'ChapterArray1' is undefined. Can you see from my code where this may be going wrong?? Ian !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- CFQUERY name=query1 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where parent_level = 0 ORDER BY category /CFQUERY CFQUERY name=query2 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where catno = parent_level ORDER BY category /CFQUERY !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=query2 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#catno# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#catno#[#i#] = #category#; ChapterArrayVal#catno#[#i#] = #parent_level# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select Sub Category; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=# method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=query1 group=category option value=#catno##Category# #Category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Thomas Hoheneder To: Ian Vaughan Sent: Friday, November 01, 2002 6:27 PM Subject: Re: Advanced Javascript and Forms ??? Hello Ian, oh... I have seen that the link to earthweb.com was your own discovery ;-) so you might know the example ;-)) [LOL] The fine aspect of this algorithm is that the function bCascadeDrop() needs not to be updated any time (when just adding further selects and entries within them). Only a new select tag and the appropriate Array elements need to be added. Greetings from Thomas - Original Message - From: Ian Vaughan To: [EMAIL PROTECTED] Sent: Friday, November 01, 2002 3:58 PM Subject: Advanced Javascript and Forms ??? Hi Thomas I have been reading your postings on the javascript newsgroup and have been impressed with your knowledge with the language, and would be grateful if someone of your experience and caliber in javascript will be able to assist me in this problem I am having please. I just have a quick query for you please, I have been trying to get my head around this week, but am still having problems, I would be grateful if you could help me out please. In the script below I am trying to add another select box based on the value chosen from the second select box, so basically a third select box . I know I am going to perhaps need a new onchange value on the second select ? but where do the arrays need to be specified etc I would appreciate a lead on this please Thankyou Ian SCRIPT LANGUAGE=JavaScript !-- Begin var minutesArray = new Array(('Select Sub Category','',true,true), ('Management Team'), ('Information Technology Steering Group'),
RE: Updaters...Culmulitive?
what?! and read something without just clicking OK I think not my man... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:37 To: CF-Talk Subject: Re: Updaters...Culmulitive? Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Are they? Release notes :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Please help me achieve this with CF and Javascrip please
which Neil?! -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:42 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Hi Neil I e-mailed a question to you at the start of December. What I was and still am trying to achieve was creating related selects generated from one database table and you provided me with some code. I am getting somewhere with this now and there is only one small part that needs to be resolved (javascript problem) before my deadline tommorrow for this to work correctly, and I am contacting you for your expert opinion with the hope of a possible solution please. Using the code below the first select box is being populated from the database as it should, however when I select an option from this list the second select does not list the related items and there is a javascript error 'ChapterArray1' is undefined. Can you see from my code where this may be going wrong?? Ian !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- CFQUERY name=query1 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where parent_level = 0 ORDER BY category /CFQUERY CFQUERY name=query2 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where catno = parent_level ORDER BY category /CFQUERY !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=query2 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#catno# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#catno#[#i#] = #category#; ChapterArrayVal#catno#[#i#] = #parent_level# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select Sub Category; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=# method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=query1 group=category option value=#catno##Category# #Category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Thomas Hoheneder To: Ian Vaughan Sent: Friday, November 01, 2002 6:27 PM Subject: Re: Advanced Javascript and Forms ??? Hello Ian, oh... I have seen that the link to earthweb.com was your own discovery ;-) so you might know the example ;-)) [LOL] The fine aspect of this algorithm is that the function bCascadeDrop() needs not to be updated any time (when just adding further selects and entries within them). Only a new select tag and the appropriate Array elements need to be added. Greetings from Thomas - Original Message - From: Ian Vaughan To: [EMAIL PROTECTED] Sent: Friday, November 01, 2002 3:58 PM Subject: Advanced Javascript and Forms ??? Hi Thomas I have been reading your postings on the javascript newsgroup and have been impressed with your knowledge with the language, and would be grateful if someone of your experience and caliber in javascript will be able to assist me in this problem I am having please. I just have a quick query for you please, I have been trying to get my head around this week, but am still having problems, I would be grateful if you could help me out please. In the script below I am trying to add another select box based on the value chosen from the second select box, so basically a third select box . I know I am going to perhaps need a new onchange value on the second select ? but where do the arrays need to be specified etc I would appreciate a lead on this please Thankyou
Re: Please help me achieve this with CF and Javascrip please
Sorry guys Ignore that last post.. sent it to the wrong address ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: MX Support # 44972
All: Permanent fix would be to setup CFMX as a dependency on your web server service. I think someone just posting on this in regards to IIS. MX was such a headache we decided to stick with 5 for our production environment there are way to many little bugs out there in MX. Plus there are internal issues within JRUN but that's a whole another ball of wax. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143threadid=451892highlight_key=ykeyword1=MXkeyword2=SunONE Hope this help! Regards, James Blaha AKA: A almost converted MX enthusiast NOT The label on the box should say migrations may cause loss of hair. :-) Robertson-Ravo, Neil (RX) wrote: Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Please help me achieve this with CF and Javascrip please
Without digging too deeply, I notice you refer to ChapterArray#category# and later ChapterArray#catno# -- I'm betting that the category and catno aren't the same for a given row of your query, else you wouldn't have both columns. I bet that's giving you your error -- or at least would cause another later on. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Ian Vaughan [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 9:42 AM : To: CF-Talk : Subject: Re: Please help me achieve this with CF and Javascrip please : : : Hi Neil : : I e-mailed a question to you at the start of December. : : What I was and still am trying to achieve was creating related selects : generated from one database table and you provided me with some code. : : I am getting somewhere with this now and there is only one small part that : needs to be resolved (javascript problem) before my deadline tommorrow for : this to work correctly, and I am contacting you for your expert : opinion with : the hope of a possible solution please. : : Using the code below the first select box is being populated from the : database as it should, however when I select an option from this list the : second select does not list the related items and there is a javascript : error : : 'ChapterArray1' is undefined. : : Can you see from my code where this may be going wrong?? : : : Ian : : : !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN : : html : head : titleUntitled/title : /head : : body : : !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- : CFQUERY name=query1 datasource=intranetv8 : SELECT : catno, category, parent_level from category_menu : where parent_level = 0 : ORDER BY category : : /CFQUERY : : CFQUERY name=query2 datasource=intranetv8 : SELECT : catno, category, parent_level from category_menu : where catno = parent_level : ORDER BY category : : /CFQUERY : : !--- Select all the sub codes. --- : : script language = JavaScript : !-- : // For each chapter, create an array to hold the sections. : // Each chapter array will be identified by the ATA_Chapter : cfoutput query=query2 group=category : // Create the array : ChapterArray#category# = new Array(); : ChapterArrayVal#catno# = new Array(); : cfset i = 0 : // Populate the array : cfoutput : cfset i = i + 1 : ChapterArray#catno#[#i#] = #category#; : ChapterArrayVal#catno#[#i#] = #parent_level# #category#; : /cfoutput : /cfoutput : : : // Function to populate the ATA_Sub_Codes for the ATA_Code selected : function PopulateATASubCode() { : // Only process the function if the first item is not selected. : var indx = document.InsertForm.ATACode.selectedIndex; : if (indx != 0) { : // Find the Chapter : var ThisChapter = document.InsertForm.ATACode[indx].value; : // Set the length of the ATA_Sub_Codes drop down equal to the : length of the : Chapter's array : var len; : len = eval(ChapterArray + ThisChapter + .length); : document.InsertForm.ATA_SubCode.length = len; : // Put 'Select' as the first option in the SubCode drop-down : document.InsertForm.ATA_SubCode[0].value = ; : document.InsertForm.ATA_SubCode[0].text = Select Sub Category; : document.InsertForm.ATA_SubCode[0].selected = true; : // Loop through the chapter's array and populate the SubCode drop down. : for (i=1; ilen; i++) { : document.InsertForm.ATA_SubCode.value = eval(ChapterArray + : ThisChapter + : ); : document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + : ThisChapter : + ); : } : } : } : //-- : /script : : html : head : titleRequirements Database Add Requirement/title : meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 : /head : body : form action=# method=POST name=InsertForm id=InsertForm : table : tr : td select name=ATACode onChange=PopulateATASubCode(); : option value=0Select ATA Code cfoutput query=query1 : group=category : option value=#catno##Category# #Category# /cfoutput : /select : select name=ATA_SubCode size=1 : option value=0Select ATA Sub Code : /select/td : /tr : /table : : /body : /html : : - Original Message - : From: Thomas Hoheneder : To: Ian Vaughan : Sent: Friday, November 01, 2002 6:27 PM : Subject: Re: Advanced Javascript and Forms ??? : : : Hello Ian, : : oh... I have seen that the link to earthweb.com was your own : discovery ;-) : so you might know the example ;-)) [LOL] : : The fine aspect of this algorithm is that the function bCascadeDrop() : needs not to be updated any time (when just adding further selects and : entries within them). : Only a new select tag and the appropriate Array elements need to be : added. : : Greetings from : Thomas : - Original Message - : From: Ian Vaughan : To: [EMAIL PROTECTED] : Sent: Friday, November 01, 2002 3:58 PM : Subject: Advanced Javascript and Forms ??? : : : Hi Thomas : : I have been reading your postings on the javascript newsgroup and have : been impressed with your knowledge with
RE: Please help me achieve this with CF and Javascrip please
Do whichever Neil a favor and send the generated page source, makes it easier to debug dynamically generated JavaScript. ;-) -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:47 AM To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip please Sorry guys Ignore that last post.. sent it to the wrong address ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Please help me achieve this with CF and Javascrip please
Ian, Did you have a look at the twoselectsrelated custom tag? It might be a little out of date and may need tidying up a little, but that will do exactly what you're attempting. Hope this helps Regards Stephen - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:41 PM Subject: Re: Please help me achieve this with CF and Javascrip please Hi Neil I e-mailed a question to you at the start of December. What I was and still am trying to achieve was creating related selects generated from one database table and you provided me with some code. I am getting somewhere with this now and there is only one small part that needs to be resolved (javascript problem) before my deadline tommorrow for this to work correctly, and I am contacting you for your expert opinion with the hope of a possible solution please. Using the code below the first select box is being populated from the database as it should, however when I select an option from this list the second select does not list the related items and there is a javascript error 'ChapterArray1' is undefined. Can you see from my code where this may be going wrong?? Ian !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- CFQUERY name=query1 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where parent_level = 0 ORDER BY category /CFQUERY CFQUERY name=query2 datasource=intranetv8 SELECT catno, category, parent_level from category_menu where catno = parent_level ORDER BY category /CFQUERY !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=query2 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#catno# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#catno#[#i#] = #category#; ChapterArrayVal#catno#[#i#] = #parent_level# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select Sub Category; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=# method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=query1 group=category option value=#catno##Category# #Category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Thomas Hoheneder To: Ian Vaughan Sent: Friday, November 01, 2002 6:27 PM Subject: Re: Advanced Javascript and Forms ??? Hello Ian, oh... I have seen that the link to earthweb.com was your own discovery ;-) so you might know the example ;-)) [LOL] The fine aspect of this algorithm is that the function bCascadeDrop() needs not to be updated any time (when just adding further selects and entries within them). Only a new select tag and the appropriate Array elements need to be added. Greetings from Thomas - Original Message - From: Ian Vaughan To: [EMAIL PROTECTED] Sent: Friday, November 01, 2002 3:58 PM Subject: Advanced Javascript and Forms ??? Hi Thomas I have been reading your postings on the javascript newsgroup and have been impressed with your knowledge with the language, and would be grateful if someone of your experience and caliber in javascript will be able to assist me in this problem I am having please. I just have a quick query for you please, I have been trying to get my head around this week, but am still having problems, I would be grateful if you could help me
Re: CFMX / JVM
I don't think there is an official recommendation. I believe the IBM one is bundled with CFMX and many have reported problems with CFHTTP fixed only by installing a new JVM--the SUN one in particular. I've read reports that the BEA JVM, JRockit, is a lot faster than IBM SUN JVM. Also, CFMX for J2EE is much faster than standalone CFMX (even CFMX for JRUN is faster than CFMX Enterprise which uses JRun). At 09:19 AM 12/19/2002, you wrote: What JVM do Macromedia recommend to use for performance etc...? Is there on? What does everyone else use? (that said, I still cannot get my ColdFusion MX server to start at boot time!) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: MX Support # 44972
Christine, I believe this is an internal JRUN issue with the service startup. Macromedia told be at one time months back to just not log into the server right away upon reboot that fixed the issue about 40% of the time. I personally removed all registry keys and even reformatted a server I know its not due to multiple installs. Your recommendation was right on the money though! Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: :-) wahoo, I will have a look -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:16 To: CF-Talk Subject: RE: MX Support # 44972 Hi Neil, It happens on my machine. I suspect it's been something that occurs with those of us who have done multiple installs - I could be wrong but I know you and I have! I posted a workaround that I'm using to the list a while ago: Set the cfmx service to be dependent on another service, so it starts later in the process. Add a string value named DependOnService with the value W3SVC under: HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\ This will cause CFMX to start after IIS. Hope that Helps! Christine -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:03 AM To: CF-Talk Subject: RE: MX Support # 44972 Post it here, this is where it would benefit. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Re: MX Support # 44972 Ola All: There is a know bug with this and a work around configuration, search the Macromedia Online Forums it was posted about 4 months ago. If you cant find it email me personally I'll see if I can dig it up. Regards, James Blaha Robertson-Ravo, Neil (RX) wrote: Yep, I dont think its 100% across the board, buts obviously been flagged as an issue : I am experiencing the problem on XP Pro at the momemt. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 12:10 To: CF-Talk Subject: RE: MX Support # 44972 I have MX with Updater 2 on my server at home and it starts up after reboot. J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:32 AM To: CF-Talk Subject: MX Support # 44972 This one is really getting me down. Macromedia has identified issue #44972 : The ColdFusion MX Application Server service does not start automatically following a Windows startup or reboot. There seems to be no fix with it in Updater 1 or 2, and at present is preventing me installing it on a server due to it? Has anyone else had this problem? Has anyone got a workaround? It seems to work when you first install it, it just seems to fail when you reboot? even when there has been no configurations added/changed etc..? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: cferror
No problem, Tim. Sometimes it's hard to keep up with these mailing list conversations! Thanks for your help! Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 6:27 AM To: CF-Talk Subject: RE: cferror Rick... sorry I didn't respond sooner about your initial blank screen . I think that was the same problemquestion -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 2:04 AM To: CF-Talk Subject: RE: cferror Thanks for the in-depth analysis, Mosh! Concerning this comment: This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler. I found that out when I followed your suggestion to CFINCLUDE the user display page from within the admin diagnostic page. I ended up putting this on the application.cfm: CFERROR Type=Exception Template=error_admin.cfm Exception=Any mailto=[EMAIL PROTECTED] Then, from within the error_admin.cfm page, I put: CFINCLUDE Template=error_user.cfm I could send my mail using a CF_Dump var=#Error# custom tag to send the error info to my email, and have the CFIncluded error_user.cfm page display the error info to the user. (After putting the CFOUTPUT's around message for error variables.) It's going to be great having these error messages show up in my email when a user has a problem. Now, I'll be able to call them right away, if needed, instead of waiting until they get frustrated and have to call me! Thanks again! Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:55 AM To: CF-Talk Subject: RE: cferror Mosh Teitelbaum wrote: ... there's no reason why you can't specify multiple CFERROR TYPE=Exception tags as in: CFERROR TYPE=Request TEMPLATE=request_error.cfm CFERROR TYPE=Exception EXCEPTION=Database TEMPLATE=db_exception.cfm CFERROR TYPE=Exception EXCEPTION=Application TEMPLATE=app_exception.cfm I don't know what would happen though if you did the above and also included an EXCEPTION=All. Would it catch everything, ignoring the other tags, or would it catch everything not specified in the other tags. Order might matter in this case (as it does when declaring CFCATCH blocks). Dunno... if I have some time tonight, I'll try to remember to test it out. So I did some testing and, for those that are interested, what follows is a summary of the findings and some items to note: ColdFusion lets you define multiple instances of the CFERROR tag. The two attributes we're concerned with here are TYPE and EXCEPTION. TYPE=Request is something of a catch all declaration that will catch all exceptions not handled by other CFERROR instances and exceptions caused by other error handlers. TYPE=Exception allows you to define handlers on a per exception basis using the EXCEPTION attribute which can specify the name of a single exception type or the word Any which, like TYPE=Request, catches all exceptions not handled by other instances of CFERROR. If you specify EXCEPTION=Any, than a TYPE=Request is used only when an exception is generated in an error handler. That is, the EXCEPTION=Any essentially relieves TYPE=Request of it's role as a catch-all. EXCEPTION=Any will only catch those exceptions not otherwise handled by other EXCEPTION= definitions. So, with the following code: CFERROR TYPE=EXCEPTION EXCEPTION=Any TEMPLATE=any.cfm CFERROR TYPE=EXCEPTION EXCEPTION=Expression TEMPLATE=expression.cfm CFERROR TYPE=EXCEPTION EXCEPTION=MissingInclude TEMPLATE=missingInclude.cfm An Expression exception will be handled by expression.cfm but any OTHER type of exception will be handled by any.cfm. Order of declaration does not matter. As I mentioned above, when you declare EXCEPTION=Any, TYPE=Request is only used to catch exceptions caused by an exception handler. Even if the type of exception thrown by the handler has a defined handler (for example, if the Expression handler in the above code causes a MissingInclude exception to be thrown) it will be handled by the Request handler, not the Exception handler. Finally, I had suggested earlier in the thread that, instead of maintaining multiple displays to inform the user that an error occurred, you can simply define it once -- in the Request handler -- and just include the request handler from your other handlers. This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler. All exception handlers (including Request) can access several variables from the ERROR scope. However, the request handler is limited in that it cannot make use of CFML so, to output the variables from the ERROR scope, you simply escape them with pound signs, no CFOUTPUT needed. But, if the request handler is executed by way of inclusion from another exception handler, it will be executing in the role of a non-request handler, i.e., it
RE: How to do this without the subselect?
Hi, Jochem. Shouldn't it be RW.ClientID IS NULL Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. I don't know enough about the fine points of joinery to answer that. Suggestions on how to setup the code to accomplish what's below with a subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY Thanks, Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:29 AM To: CF-Talk Subject: RE: How to do this without the subselect? Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
MX and Apache 2.0.43
I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some long number#, please contact the vendor for the appropriate version. Anyone have MX running with Apache 2.0.43? M ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How to do this without the subselect?
Quoting Rick Faircloth [EMAIL PROTECTED]: Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. Then maybe MySQL isn't the database for you :) Select UW.UtilityWaiverID from utilitywaivers UW where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) I think it should be: SELECT UW.UtilityWaiverID FROM utilitywaivers UW LEFT JOIN RentalWaivers RW ON (UW.ClientID = RW.ClientID AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year# ) WHERE UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND RW.ClientID IS NULL Don't forget to add the appropriate cfqueryparam tags. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: How to do this without the subselect?
Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. You're probably right Two possibles... (Neither tested, so expect typo's etc.) One is : SELECT UW.UtilityWaiverID FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW ON UW.ClientID = RW.ClientID WHERE RW.ClientID IS NULL AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) The other is : SELECT UW.UtilityWaiverID FROM UtilityWaiver AS UW, RentalWaiver AS RW WHERE UW.ClientID RW.ClientID AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) I have a sneaky suspicious that the second query won't work, but give them a go and let us know Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
IIS or CFMX
Which is preferable to use with Coldfusion when running on Windoze box? I have ColdFusion MX installed as standalone, but judging from some comments I've seen over the last few days, others are using IIS to serve the pages. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: IIS or CFMX
Steve, If your going to run MX, IIS would be your best bet with all the bugs it has Macromedia seems to be catering to IIS fixes first. Are you talking production or test? If your testing and its your local machine we run a CF5 shop but we test for MX so I run IIS locally for CF5 and use the MX standalone, I'm running dual web servers on my local machine. Hope this helps, James Blaha Steve wrote: Which is preferable to use with Coldfusion when running on Windoze box? I have ColdFusion MX installed as standalone, but judging from some comments I've seen over the last few days, others are using IIS to serve the pages. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Updaters...Culmulitive?
what?! and read something without just clicking OK I think not my man... -- Yeah... actually just trying reading them online: http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater.html AJ -- Aaron Johnson http://cephas.net/blog/ [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: How can I modify this query so mySQL will be happy?
Yes, I didn't figure DayName() would do much good without some re-coding. Good that you found DayofMonth(). Didn't know about that one. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 9:02 PM To: CF-Talk Subject: RE: How can I modify this query so mySQL will be happy? Well that explains why the exact same query, minus the Day line, works fine. No Day() function... Only problem with the DayName function (assuming it returns the Day of the Week name and not a number) is that this function needs to return the day number in the month... 1 or 2... not Monday, etc. I found answer (after reading the docs!). It was DayofMonth. That function returns a number of the month, which is what I needed. Concerning your soapbox: I agree. The more versatile code is, the better. I'm sure there are cases when code that is completely optimized for a platform is required, but I'd rather take a small hit in performance to avoid having to rewrite a bunch of code. My current situation illustrates that. I'm having to tweak code on all 197 pages of this business app to get everything to work. :op Thanks, Matt, and Ben for your help. Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:36 PM To: CF-Talk Subject: RE: How can I modify this query so mySQL will be happy? http://www.mysql.com/doc/en/Date_and_time_functions.html They have a nice new web site, I see. I like the new format. mySQL has no DAY() function. You can try using DayName() instead. This assumes AccountCreationDate is a valid mySQL date field. And if you go there it also makes your code platform-specific. Again. soapbox This illustrates, IMHO, why you stay away from using anything that could be platform-specific in your SQL (and most especially in your field specs). I've always treated the db as a file cabinet only. Get files from it. Put files back; add new ones. Nothing fancy. Leave that to whatever it is you use to massage the data. /soapbox You will hear vehement and learned arguments to the contrary that state you should write code, SQL and db-level field constraints that are optimal to the platform you are currently using, and rewrite it to a new optimum if you change platforms. I'll say no more than that in the hopes of avoiding a jihad :). --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 7:41 PM To: CF-Talk Subject: How can I modify this query so mySQL will be happy? This worked with MS Access, but I'm getting an error with this now... CFQUERY Name=GetClients Datasource=#DSN# Select ClientID from clients C where Day(AccountCreationDate) = #Form.Day# and Month(AccountCreationDate) = #Form.Month# and Year(AccountCreationDate) = #Form.Year# /CFQUERY Here's the error: [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(AccountCreationDate) = 18 and Month(AccountCreationDa The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (34:218) to (34:263). Thanks! Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How can I modify this query so mySQL will be happy?
There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. ;) Yes, I didn't figure DayName() would do much good without some re-coding. Good that you found DayofMonth(). Didn't know about that one. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 9:02 PM To: CF-Talk Subject: RE: How can I modify this query so mySQL will be happy? Well that explains why the exact same query, minus the Day line, works fine. No Day() function... Only problem with the DayName function (assuming it returns the Day of the Week name and not a number) is that this function needs to return the day number in the month... 1 or 2... not Monday, etc. I found answer (after reading the docs!). It was DayofMonth. That function returns a number of the month, which is what I needed. Concerning your soapbox: I agree. The more versatile code is, the better. I'm sure there are cases when code that is completely optimized for a platform is required, but I'd rather take a small hit in performance to avoid having to rewrite a bunch of code. My current situation illustrates that. I'm having to tweak code on all 197 pages of this business app to get everything to work. :op Thanks, Matt, and Ben for your help. Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:36 PM To: CF-Talk Subject: RE: How can I modify this query so mySQL will be happy? http://www.mysql.com/doc/en/Date_and_time_functions.html They have a nice new web site, I see. I like the new format. mySQL has no DAY() function. You can try using DayName() instead. This assumes AccountCreationDate is a valid mySQL date field. And if you go there it also makes your code platform-specific. Again. soapbox This illustrates, IMHO, why you stay away from using anything that could be platform-specific in your SQL (and most especially in your field specs). I've always treated the db as a file cabinet only. Get files from it. Put files back; add new ones. Nothing fancy. Leave that to whatever it is you use to massage the data. /soapbox You will hear vehement and learned arguments to the contrary that state you should write code, SQL and db-level field constraints that are optimal to the platform you are currently using, and rewrite it to a new optimum if you change platforms. I'll say no more than that in the hopes of avoiding a jihad :). --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 7:41 PM To: CF-Talk Subject: How can I modify this query so mySQL will be happy? This worked with MS Access, but I'm getting an error with this now... CFQUERY Name=GetClients Datasource=#DSN# Select ClientID from clients C where Day(AccountCreationDate) = #Form.Day# and Month(AccountCreationDate) = #Form.Month# and Year(AccountCreationDate) = #Form.Year# /CFQUERY Here's the error: [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(AccountCreationDate) = 18 and Month(AccountCreationDa The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (34:218) to (34:263). Thanks! Rick ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: IIS or CFMX
Which is preferable to use with Coldfusion when running on Windoze box? I have ColdFusion MX installed as standalone, but judging from some comments I've seen over the last few days, others are using IIS to serve the pages. I believe the notes say somewhere that the web server that comes as a part of JRun and used for the standalone version of CFMX is not production strength. Nothing wrong with using the JRun server if all you're doing is developing and its not a production server you're talking about. Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Is there a Better Way to do this?
Ok here is what i am doing and I am just trying to find out if 1. there is a better way and 2. if it can be done on the SQL side (as a stored proc) instaed of the CF side. Just not all that familiar with looping outside of CF. ANyway I have one table that is a dictionary with about 1500 words. THen I have another table that has dreams people have entered. THe idea is to take the list of words and see if any of them show up in the dream and then display those words to the user. What I built works and it's actually pretty speedy, but the dictionary is very small right now and it may be closer to 1 by the time we are done which is a MUCH larger list of words to loop through. So right now I am doing a query to get the words CFQUERY name=wordS SELECT word from dictionary /CFQUERY THen we grab a dream CFQUERY name=dream SELECT dream from dreams where dream_id = 3 /CFQUERY Then I Loop through like so: CFLOOP list=#valuelist(words.word)# delimiters=, index=theword Then I check to see if the dream contains the word. CFIF dream.dream contains #theword# OR dream.dream contains #theword#s Then I grab the definition if it found that word. CFQUERY name=getdef SELECT definition from dictionary where word = '#theword#' /CFQUERY Then I display it #theword#BR#getdef.definition#P /CFIF /CFLOOP This words fine and with a dream thats a few thousand words it completes in a few seconds. I just wonder if there is a faster or better way to do this so down the road we don't run into problems as the word list grows. THoughts? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Setting the focus to form select box item.
SelectedIndex is a read-only property in all browsers except Navigator 3 (O'Reilly's JavaScript: The Definitive Guide). Yeah, well that's what I get for writing out the code without testing it . . . . Just change that line to: form.mySelect[0].selected = true; // Select the first index Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: How can I modify this query so mySQL will be happy?
S. Isaac Dealey wrote: There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. There is also an SQL standard EXTRACT function, that will work in other SQL compliant databases. Unless of course you prefer to have these problems every time you change databases. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: IIS or CFMX
On 12/19/2002 11:35 AM, Stephen Moretti pounded the keyboard with stubby fingers to type: I believe the notes say somewhere that the web server that comes as a part of JRun and used for the standalone version of CFMX is not production strength. Ah ok then. Nothing wrong with using the JRun server if all you're doing is developing and its not a production server you're talking about. Yes I'm simply using it for testing locally. Thanks to you and James for responding. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How to do this without the subselect?
These two didn't work out, Stephen. Looks like Jochem's solution did it. I think the two solutions you suggested didn't work because they both required that the RentalWaiverDate's had to match the Form dates. Because the only hits in the query would be those that did have matching RentalWaiver dates, that caused nothing to be returned even though there were 3 records that should have been returned for the test date. It would return the correct hits only when there was a RentalWaiver for the Form dates and the ClientID's didn't match. If there was not RentalWaiver for the Form dates, nothing was returned. I tried coding various scenarios within the query, i.e., UW.ClientID=RW.Client, but RW.WaiverIssueDate Form Dates or UW.ClientIDRW.Client, but RW.WaiverIssueDate = Form Dates, basically trying to cover all possibilities, but even then results weren't correct. *Unfortunately*, the totally *unintuitive* (for me), but *accurate* left join from Jochem worked. (Thanks, Jochem. :o) I've just always found the joins, especially left, outer, inner, etc., to be unintuitive when looking at the code. I guess I just haven't worked with them enough. I've always worked around them with subselects, which mySQL won't do. (Until 4.2) Or perhaps I'm too dense! :o) Thanks for your help. Rick -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:25 AM To: CF-Talk Subject: Re: How to do this without the subselect? Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. You're probably right Two possibles... (Neither tested, so expect typo's etc.) One is : SELECT UW.UtilityWaiverID FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW ON UW.ClientID = RW.ClientID WHERE RW.ClientID IS NULL AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) The other is : SELECT UW.UtilityWaiverID FROM UtilityWaiver AS UW, RentalWaiver AS RW WHERE UW.ClientID RW.ClientID AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) I have a sneaky suspicious that the second query won't work, but give them a go and let us know Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How to do this without the subselect?
Quoting Jochem.. Then maybe MySQL isn't the database for you :) You may be right...perhaps I should got back to Access... at least it was *advanced* enough to handle sub-selects... :o) Thanks for your help! You can pick up your tickets for your Hawaiian cruise at the front desk! Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:21 AM To: CF-Talk Subject: RE: How to do this without the subselect? Quoting Rick Faircloth [EMAIL PROTECTED]: Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. Then maybe MySQL isn't the database for you :) Select UW.UtilityWaiverID from utilitywaivers UW where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) I think it should be: SELECT UW.UtilityWaiverID FROM utilitywaivers UW LEFT JOIN RentalWaivers RW ON (UW.ClientID = RW.ClientID AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year# ) WHERE UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND RW.ClientID IS NULL Don't forget to add the appropriate cfqueryparam tags. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: How to do this without the subselect?
Still don't know why Stas' idea didn't work with the two queries and a valuelist. Ideas? Kept getting the error that CF couldn't define ClientID in the cfset statement... Rick CFQUERY Name=GetWaivers1 Datasource=#DSN# Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY cfset filter = valuelist(getWaivers1,clientID) CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (#filter#) /CFQUERY -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:54 AM To: CF-Talk Subject: RE: How to do this without the subselect? These two didn't work out, Stephen. Looks like Jochem's solution did it. I think the two solutions you suggested didn't work because they both required that the RentalWaiverDate's had to match the Form dates. Because the only hits in the query would be those that did have matching RentalWaiver dates, that caused nothing to be returned even though there were 3 records that should have been returned for the test date. It would return the correct hits only when there was a RentalWaiver for the Form dates and the ClientID's didn't match. If there was not RentalWaiver for the Form dates, nothing was returned. I tried coding various scenarios within the query, i.e., UW.ClientID=RW.Client, but RW.WaiverIssueDate Form Dates or UW.ClientIDRW.Client, but RW.WaiverIssueDate = Form Dates, basically trying to cover all possibilities, but even then results weren't correct. *Unfortunately*, the totally *unintuitive* (for me), but *accurate* left join from Jochem worked. (Thanks, Jochem. :o) I've just always found the joins, especially left, outer, inner, etc., to be unintuitive when looking at the code. I guess I just haven't worked with them enough. I've always worked around them with subselects, which mySQL won't do. (Until 4.2) Or perhaps I'm too dense! :o) Thanks for your help. Rick -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:25 AM To: CF-Talk Subject: Re: How to do this without the subselect? Quoting Rick Faircloth [EMAIL PROTECTED]: Since the where statement is taken by the #MultipleWaivers... line, it doesn't leave room for another where statement such as where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. You're probably right Two possibles... (Neither tested, so expect typo's etc.) One is : SELECT UW.UtilityWaiverID FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW ON UW.ClientID = RW.ClientID WHERE RW.ClientID IS NULL AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) The other is : SELECT UW.UtilityWaiverID FROM UtilityWaiver AS UW, RentalWaiver AS RW WHERE UW.ClientID RW.ClientID AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year#) I have a sneaky suspicious that the second query won't work, but give them a go and let us know Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: How can I modify this query so mySQL will be happy?
S. Isaac Dealey wrote: There's also DateFormat(mydate,d) which returns the same value, but DayOfMonth() makes a lot more sense when you're reading someone else's code. There is also an SQL standard EXTRACT function, that will work in other SQL compliant databases. Unless of course you prefer to have these problems every time you change databases. Jochem Yep, that probably makes a lot more sense. :) I sort of glazed over the thread actually... I should probably reserve participation for when I have time to actually read the thread. ;) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFEXECUTE aborting on Solaris
We have a really odd problem I hope somebody else has come across (and solved!). One of our applications allows users to upload a zip file and then does a CFEXECUTE to run the /usr/bin/unzip function. After a while it just stops working with the following error: The process /usr/bin/unzip caused the unix exec function to return abnormally, ... aborting this process. This seems to happen for no obvious reason and restarting ColdFusion (5.0) seems to clear up the problem temporarily. The unzip command continues to work just fine from the command line. Any ideas? Thanks! Cathy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Is there a Better Way to do this?
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 11:38 AM : To: CF-Talk : Subject: Is there a Better Way to do this? : : : Ok here is what i am doing and I am just trying to find out if 1. : there is a : better way and 2. if it can be done on the SQL side (as a stored proc) : instaed of the CF side. Just not all that familiar with looping : outside of : CF. : : ANyway I have one table that is a dictionary with about 1500 : words. THen I : have another table that has dreams people have entered. THe idea : is to take : the list of words and see if any of them show up in the dream and then : display those words to the user. What I built works and it's : actually pretty : speedy, but the dictionary is very small right now and it may be : closer to : 1 by the time we are done which is a MUCH larger list of : words to loop : through. : : So right now I am doing a query to get the words : CFQUERY name=wordS : SELECT word : from dictionary : /CFQUERY : : THen we grab a dream : CFQUERY name=dream : SELECT dream : from dreams : where dream_id = 3 : /CFQUERY : : Then I Loop through like so: : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword : Then I check to see if the dream contains the word. : CFIF dream.dream contains #theword# OR dream.dream contains : #theword#s : Then I grab the definition if it found that word. : CFQUERY name=getdef : SELECT definition from dictionary : where word = '#theword#' : /CFQUERY : Then I display it #theword#BR#getdef.definition#P : /CFIF : /CFLOOP : : This words fine and with a dream thats a few thousand words it : completes in : a few seconds. I just wonder if there is a faster or better way : to do this : so down the road we don't run into problems as the word list grows. : THoughts? : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: How to do this without the subselect?
These two didn't work out, Stephen. Never mind Looks like Jochem's solution did it. My first one should have been the same as Jochem's just wasn't paying attention and stuck the RW date checks in the wrong place... :o/ I think the two solutions you suggested didn't work because they both required that the RentalWaiverDate's had to match the Form dates. Because the only hits in the query would be those that did have matching RentalWaiver dates, that caused nothing to be returned even though there were 3 records that should have been returned for the test date. I had a feeling that nothing would be return from RentalWaiver table Sorry about that... I've just always found the joins, especially left, outer, inner, etc., to be unintuitive when looking at the code. I guess I just haven't worked with them enough. Makes more sense when you match them up with Venn diagrams. I've always worked around them with subselects, which mySQL won't do. (Until 4.2) All subqueries can be replaced with an appropriate JOIN, it just depends on how intuitive that query actually is Of course, when all else fails You could, ~shudder~, use query of queries Or perhaps I'm too dense! :o) ~lol~ yeah that's it Of course that makes the rest of us that didn't quite get it right dense too... ;o) cfset filter = valuelist(getWaivers1,clientID) ^you've got a comma here It should be a stop. Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFEXECUTE aborting on Solaris
We called Macromedia on this one back when we had a support plan. The official fix is to restart the server when you notice the problem. Gah! Ryan -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:02 AM To: CF-Talk Subject: CFEXECUTE aborting on Solaris We have a really odd problem I hope somebody else has come across (and solved!). One of our applications allows users to upload a zip file and then does a CFEXECUTE to run the /usr/bin/unzip function. After a while it just stops working with the following error: The process /usr/bin/unzip caused the unix exec function to return abnormally, ... aborting this process. This seems to happen for no obvious reason and restarting ColdFusion (5.0) seems to clear up the problem temporarily. The unzip command continues to work just fine from the command line. Any ideas? Thanks! Cathy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: MX and Apache 2.0.43
I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some long number#, please contact the vendor for the appropriate version. Anyone have MX running with Apache 2.0.43? Yes, it works fine with Apache 2.0.43 on Windows. You'll need to reinstall the Apache connector, as described in the Updater release notes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Is there a Better Way to do this?
select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like '%#word#%') can be done like this, without the () around the %#word#% part ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:06 PM To: CF-Talk Subject: RE: Is there a Better Way to do this? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 11:38 AM : To: CF-Talk : Subject: Is there a Better Way to do this? : : : Ok here is what i am doing and I am just trying to find out if 1. : there is a : better way and 2. if it can be done on the SQL side (as a stored proc) : instaed of the CF side. Just not all that familiar with looping : outside of : CF. : : ANyway I have one table that is a dictionary with about 1500 : words. THen I : have another table that has dreams people have entered. THe idea : is to take : the list of words and see if any of them show up in the dream and then : display those words to the user. What I built works and it's : actually pretty : speedy, but the dictionary is very small right now and it may be : closer to : 1 by the time we are done which is a MUCH larger list of : words to loop : through. : : So right now I am doing a query to get the words : CFQUERY name=wordS : SELECT word : from dictionary : /CFQUERY : : THen we grab a dream : CFQUERY name=dream : SELECT dream : from dreams : where dream_id = 3 : /CFQUERY : : Then I Loop through like so: : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword : Then I check to see if the dream contains the word. : CFIF dream.dream contains #theword# OR dream.dream contains : #theword#s : Then I grab the definition if it found that word. : CFQUERY name=getdef : SELECT definition from dictionary : where word = '#theword#' : /CFQUERY : Then I display it #theword#BR#getdef.definition#P : /CFIF : /CFLOOP : : This words fine and with a dream thats a few thousand words it : completes in : a few seconds. I just wonder if there is a faster or better way : to do this : so down the road we don't run into problems as the word list grows. : THoughts? : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is there a Better Way to do this?
typo, without the ) at the very end. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:10 PM To: CF-Talk Subject: RE: Is there a Better Way to do this? select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like '%#word#%') can be done like this, without the () around the %#word#% part .tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:06 PM To: CF-Talk Subject: RE: Is there a Better Way to do this? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 11:38 AM : To: CF-Talk : Subject: Is there a Better Way to do this? : : : Ok here is what i am doing and I am just trying to find out if 1. : there is a : better way and 2. if it can be done on the SQL side (as a stored proc) : instaed of the CF side. Just not all that familiar with looping : outside of : CF. : : ANyway I have one table that is a dictionary with about 1500 : words. THen I : have another table that has dreams people have entered. THe idea : is to take : the list of words and see if any of them show up in the dream and then : display those words to the user. What I built works and it's : actually pretty : speedy, but the dictionary is very small right now and it may be : closer to : 1 by the time we are done which is a MUCH larger list of : words to loop : through. : : So right now I am doing a query to get the words : CFQUERY name=wordS : SELECT word : from dictionary : /CFQUERY : : THen we grab a dream : CFQUERY name=dream : SELECT dream : from dreams : where dream_id = 3 : /CFQUERY : : Then I Loop through like so: : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword : Then I check to see if the dream contains the word. : CFIF dream.dream contains #theword# OR dream.dream contains : #theword#s : Then I grab the definition if it found that word. : CFQUERY name=getdef : SELECT definition from dictionary : where word = '#theword#' : /CFQUERY : Then I display it #theword#BR#getdef.definition#P : /CFIF : /CFLOOP : : This words fine and with a dream thats a few thousand words it : completes in : a few seconds. I just wonder if there is a faster or better way : to do this : so down the road we don't run into problems as the word list grows. : THoughts? : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is there a Better Way to do this?
I did this for an FAQ not long ago... something like this worked for me select dictionary.word from dictionary inner join dreams on dreams.dream like '%' + dictionary.word + '%' order by dictionary.word In the case of my faq the user was entering another question and the text of the question was compared against the dictionary and then again compared to other questions, so if you've got someone entering a new dream, you could put this in a stored procedure like CREATE PROCEDURE sp_DreamNewLookup @txt_dream nvarchar(8000) AS select dictionary.word, dreams.dream from dictionary inner join dreams on dreams.dream like '%' + dictionary.word + '%' where @txt_dream like '%' + dictionary.word + '%' order by dictionary.word GO hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 11:38 AM : To: CF-Talk : Subject: Is there a Better Way to do this? : : : Ok here is what i am doing and I am just trying to find out if 1. : there is a : better way and 2. if it can be done on the SQL side (as a stored proc) : instaed of the CF side. Just not all that familiar with looping : outside of : CF. : : ANyway I have one table that is a dictionary with about 1500 : words. THen I : have another table that has dreams people have entered. THe idea : is to take : the list of words and see if any of them show up in the dream and then : display those words to the user. What I built works and it's : actually pretty : speedy, but the dictionary is very small right now and it may be : closer to : 1 by the time we are done which is a MUCH larger list of : words to loop : through. : : So right now I am doing a query to get the words : CFQUERY name=wordS : SELECT word : from dictionary : /CFQUERY : : THen we grab a dream : CFQUERY name=dream : SELECT dream : from dreams : where dream_id = 3 : /CFQUERY : : Then I Loop through like so: : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword : Then I check to see if the dream contains the word. : CFIF dream.dream contains #theword# OR dream.dream contains : #theword#s : Then I grab the definition if it found that word. : CFQUERY name=getdef : SELECT definition from dictionary : where word = '#theword#' : /CFQUERY : Then I display it #theword#BR#getdef.definition#P : /CFIF : /CFLOOP : : This words fine and with a dream thats a few thousand words it : completes in : a few seconds. I just wonder if there is a faster or better way : to do this : so down the road we don't run into problems as the word list grows. : THoughts? : : : : : ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Is there a Better Way to do this?
If you pound the word like that, won't you get whatever is stored in a cf variable named 'word' instead of the contents of the word column from the outer select? Or am I missing something? --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Tony Weeg [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 12:10 PM : To: CF-Talk : Subject: RE: Is there a Better Way to do this? : : : select word from dictionary where : (select dream from dreams where dream_id = #dreamid#) : like '%#word#%') : : can be done like this, without the () around the %#word#% : part : : ..tony : : Tony Weeg : Senior Web Developer : UnCertified Advanced ColdFusion Developer : Information System Design : Navtrak, Inc. : Mobile workforce monitoring, mapping reporting : www.navtrak.net : 410.548.2337 : : -Original Message- : From: Ben Doom [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 12:06 PM : To: CF-Talk : Subject: RE: Is there a Better Way to do this? : : : I'm not a SQL wizard and am doing this off the top of my head, but I'd : try : something along the lines of : : select word from dictionary where : (select dream from dreams where dream_id = #dreamid#) : like ('%' + word + '%') : : But, again, that's off the top of my head. : : : : --Ben Doom : Programmer General Lackey : Moonbow Software : : : -Original Message- : : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : : Sent: Thursday, December 19, 2002 11:38 AM : : To: CF-Talk : : Subject: Is there a Better Way to do this? : : : : : : Ok here is what i am doing and I am just trying to find out if 1. : : there is a : : better way and 2. if it can be done on the SQL side (as a stored proc) : : instaed of the CF side. Just not all that familiar with looping : : outside of : : CF. : : : : ANyway I have one table that is a dictionary with about 1500 : : words. THen I : : have another table that has dreams people have entered. THe idea : : is to take : : the list of words and see if any of them show up in the dream and then : : display those words to the user. What I built works and it's : : actually pretty : : speedy, but the dictionary is very small right now and it may be : : closer to : : 1 by the time we are done which is a MUCH larger list of : : words to loop : : through. : : : : So right now I am doing a query to get the words : : CFQUERY name=wordS : : SELECT word : : from dictionary : : /CFQUERY : : : : THen we grab a dream : : CFQUERY name=dream : : SELECT dream : : from dreams : : where dream_id = 3 : : /CFQUERY : : : : Then I Loop through like so: : : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword : : Then I check to see if the dream contains the word. : : CFIF dream.dream contains #theword# OR dream.dream contains : : #theword#s : : Then I grab the definition if it found that word. : : CFQUERY name=getdef : : SELECT definition from dictionary : : where word = '#theword#' : : /CFQUERY : : Then I display it #theword#BR#getdef.definition#P : : /CFIF : : /CFLOOP : : : : This words fine and with a dream thats a few thousand words it : : completes in : : a few seconds. I just wonder if there is a faster or better way : : to do this : : so down the road we don't run into problems as the word list grows. : : THoughts? : : : : : : : : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: How to do this without the subselect?
~lol~ yeah that's it Of course that makes the rest of us that didn't quite get it right dense too... ;o) No, the difference is, you hadn't already spent half a day and night trying to figure out how to code the query! I had! :o) Rick -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:06 PM To: CF-Talk Subject: Re: How to do this without the subselect? These two didn't work out, Stephen. Never mind Looks like Jochem's solution did it. My first one should have been the same as Jochem's just wasn't paying attention and stuck the RW date checks in the wrong place... :o/ I think the two solutions you suggested didn't work because they both required that the RentalWaiverDate's had to match the Form dates. Because the only hits in the query would be those that did have matching RentalWaiver dates, that caused nothing to be returned even though there were 3 records that should have been returned for the test date. I had a feeling that nothing would be return from RentalWaiver table Sorry about that... I've just always found the joins, especially left, outer, inner, etc., to be unintuitive when looking at the code. I guess I just haven't worked with them enough. Makes more sense when you match them up with Venn diagrams. I've always worked around them with subselects, which mySQL won't do. (Until 4.2) All subqueries can be replaced with an appropriate JOIN, it just depends on how intuitive that query actually is Of course, when all else fails You could, ~shudder~, use query of queries Or perhaps I'm too dense! :o) ~lol~ yeah that's it Of course that makes the rest of us that didn't quite get it right dense too... ;o) cfset filter = valuelist(getWaivers1,clientID) ^you've got a comma here It should be a stop. Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFMX App Server Failing?
I have a copy of CFMX Pro installed on my laptop (Win2K Pro). It is setup to utilize IIS if that matters. Whenever I boot my laptop however, the App Server fails. The error in the event log is that the CFMX App Server service terminated with service specific error 2. Anybody got any idea what is happening? I have installed CFMX Pro on a development server and everything works great there. I have updated both with the latest updater as well. Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is there a Better Way to do this?
Aye, that's what I was trying to think of. Too much blood in my caffiene stream this morning. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 12:28 PM : To: CF-Talk : Subject: RE: Is there a Better Way to do this? : : : I did this for an FAQ not long ago... something like this worked for me : : select dictionary.word : from dictionary : inner join dreams on : dreams.dream like '%' + dictionary.word + '%' : order by dictionary.word : : In the case of my faq the user was entering another question and : the text of : the question was compared against the dictionary and then again : compared to : other questions, so if you've got someone entering a new dream, you could : put this in a stored procedure like : : CREATE PROCEDURE sp_DreamNewLookup : @txt_dream nvarchar(8000) : AS : select dictionary.word, dreams.dream from dictionary : inner join dreams on dreams.dream like '%' + dictionary.word + '%' : where @txt_dream like '%' + dictionary.word + '%' : order by dictionary.word : GO : : : hth : : : s. isaac dealey954-776-0046 : : new epoch http://www.turnkey.to : : lead architect, tapestry cms http://products.turnkey.to : : certified advanced coldfusion 5 developer : http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 : : : : I'm not a SQL wizard and am doing this off the top of my : head, but I'd try : something along the lines of : : select word from dictionary where : (select dream from dreams where dream_id = #dreamid#) : like ('%' + word + '%') : : But, again, that's off the top of my head. : : : :--Ben Doom : Programmer General Lackey : Moonbow Software : : : -Original Message- : : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : : Sent: Thursday, December 19, 2002 11:38 AM : : To: CF-Talk : : Subject: Is there a Better Way to do this? : : : : : : Ok here is what i am doing and I am just trying to find : out if 1. : : there is a : : better way and 2. if it can be done on the SQL side (as : a stored proc) : : instaed of the CF side. Just not all that familiar with : looping : : outside of : : CF. : : : : ANyway I have one table that is a dictionary with about : 1500 : : words. THen I : : have another table that has dreams people have entered. : THe idea : : is to take : : the list of words and see if any of them show up in the : dream and then : : display those words to the user. What I built works and : it's : : actually pretty : : speedy, but the dictionary is very small right now and : it may be : : closer to : : 1 by the time we are done which is a MUCH larger : list of : : words to loop : : through. : : : : So right now I am doing a query to get the words : : CFQUERY name=wordS : : SELECT word : : from dictionary : : /CFQUERY : : : : THen we grab a dream : : CFQUERY name=dream : : SELECT dream : : from dreams : : where dream_id = 3 : : /CFQUERY : : : : Then I Loop through like so: : : CFLOOP list=#valuelist(words.word)# delimiters=, : index=theword : : Then I check to see if the dream contains the word. : : CFIF dream.dream contains #theword# OR dream.dream : contains : : #theword#s : : Then I grab the definition if it found that word. : : CFQUERY name=getdef : : SELECT definition from dictionary : : where word = '#theword#' : : /CFQUERY : : Then I display it #theword#BR#getdef.definition#P : : /CFIF : : /CFLOOP : : : : This words fine and with a dream thats a few thousand : words it : : completes in : : a few seconds. I just wonder if there is a faster or : better way : : to do this : : so down the road we don't run into problems as the word : list grows. : : THoughts? : : : : : : : : : : : ~~ : ~~~| : Archives: : http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 : Subscription: http://www.houseoffusion.com/cf_lists/index. : cfm?method=subscribeforumid=4 : FAQ: http://www.thenetprofits.co.uk/coldfusion/faq : Structure your ColdFusion code with Fusebox. Get the : official book at http://www.fusionauthority.com/bkinfo.cfm : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: How to do this without the subselect?
Hey, Jochem... Since you've got a good grip on how the joins work, would my explanation for my notes concerning why this query works be accurate? Notes: This query works to select UtilityWaivers that were issued within a given month and which were issued without an accompanying RentalWaiver. The part of the query before the where clause selects all UtilityWaivers which were issued within the specified month and which have accompanying RentalWaivers with matching ClientID's for the same month. The where clause then specifies that the joined group should be limited to those UtilityWaivers whose ClientID does match any RentalWaiver ClientID. CFQUERY Name=GetUCSWCount Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW left join RentalWaivers RW on (UW.ClientID = RW.ClientID and Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year# ) where UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and RW.ClientID IS NULL /CFQUERY Thanks, Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:21 AM To: CF-Talk Subject: RE: How to do this without the subselect? Quoting Rick Faircloth [EMAIL PROTECTED]: Now, that's a good question. I've always used subselects to get around having to spend time with those unfriendly (at least to me!) joins. Then maybe MySQL isn't the database for you :) Select UW.UtilityWaiverID from utilitywaivers UW where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]# and Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) I think it should be: SELECT UW.UtilityWaiverID FROM utilitywaivers UW LEFT JOIN RentalWaivers RW ON (UW.ClientID = RW.ClientID AND Month(RW.RentalWaiverDate) = #Form.Month# AND Year(RW.RentalWaiverDate) = #Form.Year# ) WHERE UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]# AND Month(UW.IssueDate) = #Form.Month# AND Year(UW.IssueDate) = #Form.Year# AND RW.ClientID IS NULL Don't forget to add the appropriate cfqueryparam tags. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Is there a Better Way to do this?
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is there a Better Way to do this?
Nasty thing that blood... I say who needs it. ;) Aye, that's what I was trying to think of. Too much blood in my caffiene stream this morning. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 12:28 PM : To: CF-Talk : Subject: RE: Is there a Better Way to do this? : : : I did this for an FAQ not long ago... something like this worked for me : : select dictionary.word : from dictionary : inner join dreams on : dreams.dream like '%' + dictionary.word + '%' : order by dictionary.word : : In the case of my faq the user was entering another question and : the text of : the question was compared against the dictionary and then again : compared to : other questions, so if you've got someone entering a new dream, you could : put this in a stored procedure like : : CREATE PROCEDURE sp_DreamNewLookup : @txt_dream nvarchar(8000) : AS : select dictionary.word, dreams.dream from dictionary : inner join dreams on dreams.dream like '%' + dictionary.word + '%' : where @txt_dream like '%' + dictionary.word + '%' : order by dictionary.word : GO : : : hth : : : s. isaac dealey954-776-0046 : : new epoch http://www.turnkey.to : : lead architect, tapestry cms http://products.turnkey.to : : certified advanced coldfusion 5 developer : http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 : : : : I'm not a SQL wizard and am doing this off the top of my : head, but I'd try : something along the lines of : : select word from dictionary where : (select dream from dreams where dream_id = #dreamid#) : like ('%' + word + '%') : : But, again, that's off the top of my head. : : : :--Ben Doom : Programmer General Lackey : Moonbow Software : : : -Original Message- : : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : : Sent: Thursday, December 19, 2002 11:38 AM : : To: CF-Talk : : Subject: Is there a Better Way to do this? : : : : : : Ok here is what i am doing and I am just trying to find : out if 1. : : there is a : : better way and 2. if it can be done on the SQL side (as : a stored proc) : : instaed of the CF side. Just not all that familiar with : looping : : outside of : : CF. : : : : ANyway I have one table that is a dictionary with about : 1500 : : words. THen I : : have another table that has dreams people have entered. : THe idea : : is to take : : the list of words and see if any of them show up in the : dream and then : : display those words to the user. What I built works and : it's : : actually pretty : : speedy, but the dictionary is very small right now and : it may be : : closer to : : 1 by the time we are done which is a MUCH larger : list of : : words to loop : : through. : : : : So right now I am doing a query to get the words : : CFQUERY name=wordS : : SELECT word : : from dictionary : : /CFQUERY : : : : THen we grab a dream : : CFQUERY name=dream : : SELECT dream : : from dreams : : where dream_id = 3 : : /CFQUERY : : : : Then I Loop through like so: : : CFLOOP list=#valuelist(words.word)# delimiters=, : index=theword : : Then I check to see if the dream contains the word. : : CFIF dream.dream contains #theword# OR dream.dream : contains : : #theword#s : : Then I grab the definition if it found that word. : : CFQUERY name=getdef : : SELECT definition from dictionary : : where word = '#theword#' : : /CFQUERY : : Then I display it #theword#BR#getdef.definition#P : : /CFIF : : /CFLOOP : : : : This words fine and with a dream thats a few thousand : words it : : completes in : : a few seconds. I just wonder if there is a faster or : better way : : to do this : : so down the road we don't run into problems as the word : list grows. : : THoughts? : : : : : : : : : : : ~~ : ~~~| : Archives: : http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 : Subscription: http://www.houseoffusion.com/cf_lists/index. : cfm?method=subscribeforumid=4 : FAQ: http://www.thenetprofits.co.uk/coldfusion/faq : Structure your ColdFusion code with Fusebox. Get the : official book at http://www.fusionauthority.com/bkinfo.cfm : : : : ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm s. isaac dealey
Re: Is there a Better Way to do this?
I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: CFMX App Server Failing?
Jeff, I have a copy of CFMX Pro installed on my laptop (Win2K Pro). It is setup to utilize IIS if that matters. Whenever I boot my laptop however, the App Server fails. The error in the event log is that the CFMX App Server service terminated with service specific error 2. Anybody got any idea what is happening? I have installed CFMX Pro on a development server and everything works great there. I have updated both with the latest updater as well. According to net helpmsg 2 The system cannot find the file specified. So possibly the service can't find the exe for the app server because its moved/deleted or the permissions are preventing SYSTEM from accessing the file. Have a look around the event logs. Theoretically, it should tell you what that missing file is. Hope that helps Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is there a Better Way to do this?
Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... ~sigh~ Right! that does it You are of course correct Too much darkness outside now... Time for me to quit and go home Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFMX App Server Failing?
Stephen, I checked the logs again and the message is exactly as I stated, no file name included. If I restart the service a couple of times and maybe do a restart on the laptop, it will eventually work. This seems to only occur after a cold boot, not after I just do a restart. Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Simplest translation of simple XML file to CF5 structure?
Lets pretend that abc.xml contains... ?xml version=1.0? book authorjon/author titlea question/title /book What is the most easy way to magically turn that into a coldfusion structure where I can do #book.author# and #book.title#? There has GOT to be a CF5 xmlParse() UDF out there somewhere. Please advise. Thank you, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is there a Better Way to do this?
No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Self Join Question
Almost got a self join working the way I want, but not quite... I've got a table of Office Branches. Some of them are MAIN BRANCHES (value main under sub_branch in table). Others are SUB BRANCHES and would have the branch_ID of the main branch listed in the sub_branch cell. So, I need a self join to get this to work, correct? Can't get the syntax just right Table: BRANCHES --- ID branch_name branch_ID sub_branch Return results like -- Main Branch 1 SubBranch 1 SubBranch 2 Main Branch 2 Main Branch 3 SubBranch 3 Some assistance please? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Is there a Better Way to do this?
Quick guess, change like ('%' + word + '%') to like (word) ??/ WG -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 17:52 To: CF-Talk Subject: Re: Is there a Better Way to do this? No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: CFMX / JVM
On Thursday, Dec 19, 2002, at 06:53 US/Pacific, Samuel R. Neff wrote: I don't think there is an official recommendation. I think you're right because the question has been asked and gone unanswered here before. I believe the IBM one is bundled with CFMX and many have reported problems with CFHTTP fixed only by installing a new JVM--the SUN one in particular. Yes, CFMX Standalone ships with the IBM JVM, 1.3.1 I believe. Our own documentation mentions the 1.4.0 JVM in connection with certain tags (cfhttp may well be one of them). The 1.4.0 JVM is substantially faster than the 1.3.1 JVM so it's a 'safe' upgrade. I've read reports that the BEA JVM, JRockit, is a lot faster than IBM SUN JVM. Several people seem to have had a lot of success with JRockit although I recall some problems reported with it early on (perhaps an earlier version?). I don't believe CFMX w/ JRockit is a supported configuration however. Also, CFMX for J2EE is much faster than standalone CFMX (even CFMX for JRUN is faster than CFMX Enterprise which uses JRun). By way of explanation, CFMX for J2EE has been optimized to take better advantage of the underlying J2EE system. Yes, it is faster than CFMX Standalone but it's also very dependent on the J2EE system in use and the difference is more noticeable as you move up the multi-processor scale. Check out the CFMX for WebSphere performance brief in the ColdFusion MX Whitepapers section of mm.com. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: MX and Apache 2.0.43
On Thursday, Dec 19, 2002, at 07:08 US/Pacific, Haggerty, Mike wrote: I have installed updater 2 and am trying to get MX to work with Apache 2.0.43 on a Win2K box with no success. I don't have the error message in front of me, something about requiring #some long number# and having #some long number#, please contact the vendor for the appropriate version. Sounds like the 'magic numbers' don't match which suggests that either wsconfig is finding a different Apache version or your Updater 2 installer didn't properly update wsconfig. Anyone have MX running with Apache 2.0.43? Yes, we have it running on Solaris (on several servers) but we're using CFMX for J2EE. I'll forward this to some product team folks and see if they can suggest how to debug the problem you're seeing. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Is there a Better Way to do this?
Yea, there's a couple things you can do ... Make sure that every word in the dream is bounded by spaces You can do this with a couple regular expressions like this: cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1 \2,ALL) cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1 \2,ALL) To give you a quick run-down ( in case you're unfamiliar with regular expressions ), this says find an alphabetic character [[:alpha:]] followed by a character that is not a space and not alphabetical [^ [:alpha:]], and replace them with the first character \1 a space and the second character \2 -- it then reverses the position of the alpha and the non alpha characters and places spaces in front of words which are prepended with something other than a space. Then feed your massaged dream text into the stored procedure with an extra space on either side of the text and add the spaces to the query like so: WHERE dreams.dream LIKE '% ' + dictionary.word + ' %' Alternatively, you could just change anything that's not a space into a space before you feed it to the stored procedure like this: cfquery ... exec sp_DreamNewLookup @txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# '; /cfquery This is going to also replace numbers and punctuation, however, so you probably won't want to store the text after this REReplace() function call. If you need / want more help with regular expressions, check out the cf-regex list also on www.houseoffusion.com hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
ODBC Data Source [Merant dBase/FoxPro Driver]
hi all Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro Driver] in CF admin? I haven't used it before and cant seem to find any examples. I have tried the simple queries: cfquery name=Qtransferrequests datasource=temp1610 dbtype=ODBC SELECT STATION, ORG_ELMT FROM t16101; /cfquery cfquery name=Qtransferrequests datasource=temp1610 dbtype=ODBC DELETE t16101.* FROM t16101; /cfquery for the select I get: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag for the delete I get the error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC dBase driver]Missing FROM keyword in DELETE statement SQL = Delete t16101.* FROM t16101; I can verify the connection in CF Admin and it says its OK any examples would be a great help Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Is there a Better Way to do this?
awesome thanks :))) From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Is there a Better Way to do this? Date: Thu, 19 Dec 2002 13:26:40 -0500 Yea, there's a couple things you can do ... Make sure that every word in the dream is bounded by spaces You can do this with a couple regular expressions like this: cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1 \2,ALL) cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1 \2,ALL) To give you a quick run-down ( in case you're unfamiliar with regular expressions ), this says find an alphabetic character [[:alpha:]] followed by a character that is not a space and not alphabetical [^ [:alpha:]], and replace them with the first character \1 a space and the second character \2 -- it then reverses the position of the alpha and the non alpha characters and places spaces in front of words which are prepended with something other than a space. Then feed your massaged dream text into the stored procedure with an extra space on either side of the text and add the spaces to the query like so: WHERE dreams.dream LIKE '% ' + dictionary.word + ' %' Alternatively, you could just change anything that's not a space into a space before you feed it to the stored procedure like this: cfquery ... exec sp_DreamNewLookup @txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# '; /cfquery This is going to also replace numbers and punctuation, however, so you probably won't want to store the text after this REReplace() function call. If you need / want more help with regular expressions, check out the cf-regex list also on www.houseoffusion.com hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Is there a Better Way to do this?
Quick guess, change like ('%' + word + '%') to like (word) At least in sql server afaik ( not sure about other db's, but I suspect it's fairly standard ) using like word is the same as using = word because the db is looking for a wildcard % or _ ( single character wildcard in sql server iirc ) for the like comparison. If you leave them out afaik it doesn't assume % on either side of the string. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Is there a Better Way to do this?
That's what we're here for. :) awesome thanks :))) From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Is there a Better Way to do this? Date: Thu, 19 Dec 2002 13:26:40 -0500 Yea, there's a couple things you can do ... Make sure that every word in the dream is bounded by spaces You can do this with a couple regular expressions like this: cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1 \2,ALL) cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1 \2,ALL) To give you a quick run-down ( in case you're unfamiliar with regular expressions ), this says find an alphabetic character [[:alpha:]] followed by a character that is not a space and not alphabetical [^ [:alpha:]], and replace them with the first character \1 a space and the second character \2 -- it then reverses the position of the alpha and the non alpha characters and places spaces in front of words which are prepended with something other than a space. Then feed your massaged dream text into the stored procedure with an extra space on either side of the text and add the spaces to the query like so: WHERE dreams.dream LIKE '% ' + dictionary.word + ' %' Alternatively, you could just change anything that's not a space into a space before you feed it to the stored procedure like this: cfquery ... exec sp_DreamNewLookup @txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# '; /cfquery This is going to also replace numbers and punctuation, however, so you probably won't want to store the text after this REReplace() function call. If you need / want more help with regular expressions, check out the cf-regex list also on www.houseoffusion.com hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 No you were correct I only want to pull the dictionary words that were found in the dream. The code you gave me worked great the only issue i see now for example let's say the word is FEEL then it pulls EEL out of the dictionary. IS there a way to avoid that? I'm not a SQL wizard and am doing this off the top of my head, but I'd try something along the lines of select word from dictionary where (select dream from dreams where dream_id = #dreamid#) like ('%' + word + '%') But, again, that's off the top of my head. What you mean is : SELECT dictionary.word, dictionary.definition FROM dictionary LEFT JOIN dream ON dreams.dream LIKE '%' + dictionary.word + '%' Which is what Isaac's got in his stored proc... ;o) Accept that if you left join dream, you'll get every word from the dictionary -- I was under the impression ( possibly mistaken ) he was looking for only words appearing in the dream text ... s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=2181 6 ~~~ ~~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFMail - Multiple Attachments
Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im wondering can 2 or 3 forms be sent out via cfmail for certain benefit selections an employee has made within our benefit selection system for our annual enrollment process. I found 1 site referencing cfmailparam. Can I assume that the cfmailparam could be dynamically populated to pull the forms we needed. Thanks! Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: CFMail - Multiple Attachments
Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im wondering can 2 or 3 forms be sent out via cfmail for certain benefit selections an employee has made within our benefit selection system for our annual enrollment process. I found 1 site referencing cfmailparam. Can I assume that the cfmailparam could be dynamically populated to pull the forms we needed. Thanks! Casey Cook Absolutely ... here's some pseudocode cfquery name=rsSelected SELECT benefits.FileName FROM benefits INNER JOIN employee_benefits ON ( employee_benefits.employeeid = #employeeid# ) /cfquery cfset variables.sourcefolder = c:\benefitsfiles cfmail ... cfloop query=rsSelected cfmailparam file=#variables.sourcefolder#/#rsSelected.FileName# /cfloop /cfmail s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMail - Multiple Attachments
Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing an estimate on amount of time needed to build the functionality. CC S. Isaac Dealey infoTo: CF-Talk [EMAIL PROTECTED] @turnkey.to cc: Subject: Re: CFMail - Multiple Attachments 12/19/02 12:53 PM Please respond to cf-talk Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im wondering can 2 or 3 forms be sent out via cfmail for certain benefit selections an employee has made within our benefit selection system for our annual enrollment process. I found 1 site referencing cfmailparam. Can I assume that the cfmailparam could be dynamically populated to pull the forms we needed. Thanks! Casey Cook Absolutely ... here's some pseudocode cfquery name=rsSelected SELECT benefits.FileName FROM benefits INNER JOIN employee_benefits ON ( employee_benefits.employeeid = #employeeid# ) /cfquery cfset variables.sourcefolder = c:\benefitsfiles cfmail ... cfloop query=rsSelected cfmailparam file= #variables.sourcefolder#/#rsSelected.FileName# /cfloop /cfmail s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMail - Multiple Attachments
Here's a tutorial on this also: http://tutorial27.easycfm.com/ Pablo I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im wondering can 2 or 3 forms be sent out via cfmail for certain benefit selections an employee has made within our benefit selection system for our annual enrollment process. I found 1 site referencing cfmailparam. Can I assume that the cfmailparam could be dynamically populated to pull the forms we needed. Thanks! Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
ColdFusion and DDE
Is it possible to use DDE links in ColdFusion? Jacob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: CFMail - Multiple Attachments
Welcome. :) Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing an estimate on amount of time needed to build the functionality. CC S. Isaac Dealey infoTo: CF-Talk [EMAIL PROTECTED] @turnkey.to cc: Subject: Re: CFMail - Multiple Attachments 12/19/02 12:53 PM Please respond to cf-talk Hello, I would think this is an easy question, but I have not easily found the answer yet. Is it possible to send multiple attachments out with cfmail, and can the number of attachments and attachment names be dynamically determined based on user selections within the application. Basically Im wondering can 2 or 3 forms be sent out via cfmail for certain benefit selections an employee has made within our benefit selection system for our annual enrollment process. I found 1 site referencing cfmailparam. Can I assume that the cfmailparam could be dynamically populated to pull the forms we needed. Thanks! Casey Cook Absolutely ... here's some pseudocode cfquery name=rsSelected SELECT benefits.FileName FROM benefits INNER JOIN employee_benefits ON ( employee_benefits.employeeid = #employeeid# ) /cfquery cfset variables.sourcefolder = c:\benefitsfiles cfmail ... cfloop query=rsSelected cfmailparam file= #variables.sourcefolder#/#rsSelected.FileName# /cfloop /cfmail s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: ColdFusion and DDE
Um... Are you referring to Windows Drag'n'drop? If so, that's going to be browser-dependent unless you are talking about CFStudio. And, to be honest, I can't really think of anything you could dnd to a CF page except file uploads. If that's not what you're talking about then I'm lost anyway. :-) --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Jacob [mailto:[EMAIL PROTECTED]] : Sent: Thursday, December 19, 2002 2:03 PM : To: CF-Talk : Subject: ColdFusion and DDE : : : Is it possible to use DDE links in ColdFusion? : : Jacob : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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