RE: Java Mailing List
Great forums at the Big Moose Saloon here: www.javaranch.com http://www.javaranch.com/ Regards, Andr -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 17:11 To: CF-Talk Subject: Re: Java Mailing List Does anyone have any recommendations in regards to a decent Java mailing list? I was not too impressed with the forums over at suns site. Not to generalize but the developers there seem to snub beginners, which is too bad since we all start somewhere. really? i found the new to java forums to be relatively helpful, ditto for the i18n forums (though i've really never seen anythig like the cf community). maybe something here: http://www.cafeaulait.org/mailinglists.html you might also post questions to the java cf forums. there are some sharp folks there. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
If you are actually on the ColdFusion server can you browse to that same URL? Andr -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:55 To: CF-Talk Subject: Re:CFHTTP Question! When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp But when I include this url in cfhttp I get You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. error. Here is my code: CFHTTP url=""> METHOD=GET RESOLVEURL=true throwonerror=yes/ cfoutput#CFHTTP.FileContent# /cfoutput Am I missing some attributes in my cfhttp tag? Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic page processing
2) Create actual blank pages on the filesystem named astronomy.cfm, etc when the content is created, then use application.cfm to get the ball rolling.Is there much, if any, overhead in using the application.cfm file in this manner? A variant of this approach that is used by content management systems like CommonSpot (http://www.paperthin.com http://www.paperthin.com/ ) is to have stub pages which set up various variables etc. that the framework uses e.g. have an astronomy.cfm stub page which simply includes/redirects/modules the actual content. This requires the publishing and synchronizing of these stub pages when content is being added/updated but you can utilize this to your advantage by allowing them to cache various page settings. This approach is somewhere in between having fully published static pages which are very fast to serve and fully dynamic pages which are always up to date but draining on the server. Andr [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is a Datasource really setup?
Dwayne, Try this: cfscript // Get the MX Service Factory... factory = CreateObject(java,coldfusion.server.ServiceFactory); // Get the data source service... dataSourceService = factory.dataSourceService; // Finally, Get the datasources! datasources = dataSourceService.getDataSources(); /cfscript cfdump var=#datasources# Might do the trick for you. Andr -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 02:14 To: CF-Talk Subject: Is a Datasource really setup? Is there some code that I can run to check the existance of datasource. My code reporting that the tables in database does not exist. My host ISP says that the Datasource has been registered with CF.This is a new setup and I just don't think the datasource was setup correctly.Is there any code that I can run to test it Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: developing java cfx
This is a known issue, no way around it as far as I recall other than getting your code right first time :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 October 2003 10:28 To: CF-Talk Subject: developing java cfx According the the CF docs reload=always is supposed to keep me from having to restart CF everytime I recompile my cfx tag, but it doesn't seem to be working. How do you guys do it? -- mailto:[EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nesting CFTRANSACTION?
Jim, There are several approaches one can take here. One of those possibilities is to utilize the Composite Design Pattern (google will give you endless examples including: http://www.javaworld.com/javaworld/jw-09-2002/jw-0913-designpatterns_p.h tml) perhaps in combination with the Strategy Design Pattern to implement the transaction control (again google will help) Another approach, if Composite is not appropriate for your parent-child hierarchy is to allow transaction control to be handled by a service-oriented CFC leaving the finer granular CFCs free to ignore the issues of transactions. After all, once you include the transaction control at the lowest level, it precludes that CFC being used as part of any larger transaction in the future and that includes ones you havent thought of yet. Andr -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: 03 October 2003 06:14 To: CF-Talk Subject: Nesting CFTRANSACTION? I'm in a position where a component can have a parent/child relationship with other components of the same type. When I delete a single component, no problem - the method starts a transaction, deletes the component information from the database, cleans up references to it in several join tables and updates a couple of administrative tables. When a component has Children I would like to delete them as well in the same transaction.The best way to do this, of course, is to loop through the children and call their delete() methods. However when I do this (as I am) from with the parents delete() method (making the call sorta recursive-like) I get the error we all know and love: Cannot nest CFTRANSACTIONS In short I don't want to really nest a transaction (that makes no real sense) I simply want a way to include all the work in a single transaction.Some way to determine if I'm in a transaction already and not try to start a new one. I'm trying to find some way to do this, perhaps by catching and using the nesting error itself - but nothing remotely elegant is presenting itself. Any solutions, ideas or workarounds? Jim Davis _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Customg tag that will ring a phone
I suspect this will only be really feasible via a C++ based CFX leveraging the Telephone API (TAPI) if you are on Windows (not sure of the solution to use on a Unix based OS). I know there is some C++ code floating about to do this (try google) and all it would require is wrapping it up in a CFX your development team is probably already aware of this. I doubt there is already a CFX implemented for this purpose. Andr -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: 03 October 2003 16:08 To: CF-Talk Subject: Customg tag that will ring a phone Hi, is anyone aware of a CFX tag free or for purchase that will ring a mobile phone. We have a modem in place here for doing the task, its just getting a go between CF to the modem. Our software development team are looking into this although they asked to put a feeler out to the community. Thanks, J _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Customg tag that will ring a phone
Jim, That certainly sounds like a valid and potentially much simpler approach. Andr -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: 03 October 2003 16:30 To: CF-Talk Subject: Re: Customg tag that will ring a phone What if the modem has a command-line interface you could invoke directly from the OS?Then it could just be a matter of sending ATDT and whatnot via CFEXECUTE, wouldn't it? - Jim Andre Mohamed wrote: I suspect this will only be really feasible via a C++ based CFX leveraging the Telephone API (TAPI) if you are on Windows (not sure of the solution to use on a Unix based OS). I know there is some C++ code floating about to do this (try google) and all it would require is wrapping it up in a CFX - your development team is probably already aware of this. I doubt there is already a CFX implemented for this purpose. Andr -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: 03 October 2003 16:08 To: CF-Talk Subject: Customg tag that will ring a phone Hi, is anyone aware of a CFX tag free or for purchase that will ring a mobile phone. We have a modem in place here for doing the task, its just getting a go between CF to the modem. Our software development team are looking into this although they asked to put a feeler out to the community. Thanks, J _ [Todays _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Erm,just to be anal and incite multiple flames (Ive learnt thistechnique from others on the list) I believe UTF actually stands forUCS transformation format rather than the more popular interpretationof Unicode Transformation Format :-) UCS Stands for Universal Character Set a.k.a Universal Multiple-OctetCoded Character Set which is defined as being a superset of Unicode. So if we are to believe all of that then UTF-8 (UCS transformationformat 8) is not strictly Unicode specific. Now that Ive put you all to sleep with this exciting information, wecan get back to addressing the original question of this thread. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 07:40To: CF-TalkSubject: Re: Multilingual site? And no, UTF-8 is NOT Unicode : UTF8 is an 8 bit encodeing system andUnicode is a 16 bit code. UTF-8 suports Unicode (or any other 16 bitsystem), just as base64 is NOT ASCII, it suports ASCII (or any 8 bitssystem), and ASCII is NOT English (or any other language).Unicode Transformation Format. i rather doubt anyone would have createdUTFsw/out unicode. do they somehow predate unicode? are the UTF ever usedwithanything besides unicode? what character sequence codes do they use? international ms office comes with arial unicode ms, As I told you, it was 2 years ago.it was in international ms office two years ago. Just try a page in Unicode with Netscape 4.7 and you will see ;-(why bring up that pile of dead code?you personally don't want to use unicode, fine. you personally don'tneedthe euro symbol, fine. however, this discussion was about m11n(multilingual) sites. unicode is by far the best choice for these sortsofapplications. it offers developers the widest range of languages withtheleast cost/resistance in cf._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Doh! Hoping no one would be as anal as me and actually check that out ohwell. I did try (secretly trying to prolong this exciting debate) Interesting how an abbreviation can mean two things, not ambiguous atall. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 16:06To: CF-TalkSubject: Re: Multilingual site? Erm,just to be anal and incite multiple flames (I've learnt this technique from others on the list).I believe UTF actually stands for UCS transformation format rather than the more popularinterpretation of Unicode Transformation Format :-)no thats not quite correct. its unicode OR ucs. theUTF-8 definitionactually states Unicode (or UCS) Transformation Format, 8-bit encodingform. UTF-8 is the Unicode Transformation Format that serializes aUnicodescalar value (code point) as a sequence of one to four bytes, asspecifiedin...http://www.unicode.org/glossary/nice try though._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Yes, although originally the U in UTF stood for UCS, it seems that overtime there has been some kind of revisionism leaning towards Unicode probably to avoid confusion and more specifically to prevent these kindsof discussions turning up on mailing lists ;) Ive now managed to successfully bore my self to sleep with thisriveting subject matter. Just enough energy left to sign off Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 17:07To: CF-TalkSubject: Re: Multilingual site? Not that I am an expert on any of this, but can you really go tounicode.org an expect any acronym with a U in it not to mean Unicode?well they actually acknowledge UCS in the OR bit. they also have UCS-2,etcdefined in their glossary and they have synched up to ISO 10646,etc.--sothey aren't that one-sided. but since the unicode consortium is doingmostof the work these days (or did, the commercial driving force behind itlooksto be satisified with the encoding as is and may actually peter out) iguess i'll take their definition. Reading rfc2044 at ietf.org, I get...UTF-8, a transformation format of Unicode and ISO 10646 So Andre may still be correct.hard to say. for me its still unicode as the char codes represented inthattransform is unicode. its not used by anything else, etc._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: dreamweaver stuff
1) Code Templates If you mean the ability to create and load templates to use as new files then the Dreamweaver does support this. 2) Search and save as a file If you mean the ability to save search/replace queries and load them again at a later point then yes, Dreamweaver does support this. André -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:28 To: CF-Talk Subject: RE: dreamweaver stuff Massimo Before I cast my vote - not having the opportunity to yet download DWMX 2004 does anyone know if any of the following features are now supported? . Split code view . Collapsible code . Code templates . Bookmarks . Search and save as a file Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:18 To: CF-Talk Subject: Re: dreamweaver stuff One thing I miss or can't seem to find is the Split View. Is this gone? It was really helpful to look at 2 areas of code on a page at once. Cast your vote: http://www.macromedia.com/support/email/wishform/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137894 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: dreamweaver stuff
Not a solution but: In Dreamweaver, using just the Tab key will indent blocks of code for you. You can't do that in Studio. You can write your own extensions to create your own toolbars if you want. André -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:51 To: CF-Talk Subject: RE: dreamweaver stuff I also would like to have a custom Tool Bar and be able to create a button for it by selecting a Shortcut. I guess that would like a MACRO. Create a button that does a list of commands in order and with conditions. I liked the buttons on the side in Studio for indenting code, now it's a shortcut under 'Text'. I am a mouse user and not so much on the short cuts. Rick -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 8:41 AM To: CF-Talk Subject: RE: dreamweaver stuff 1) Code Templates If you mean the ability to create and load templates to use as new files then the Dreamweaver does support this. 2) Search and save as a file If you mean the ability to save search/replace queries and load them again at a later point then yes, Dreamweaver does support this. André -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:28 To: CF-Talk Subject: RE: dreamweaver stuff Massimo Before I cast my vote - not having the opportunity to yet download DWMX 2004 does anyone know if any of the following features are now supported? . Split code view . Collapsible code . Code templates . Bookmarks . Search and save as a file Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:18 To: CF-Talk Subject: Re: dreamweaver stuff One thing I miss or can't seem to find is the Split View. Is this gone? It was really helpful to look at 2 areas of code on a page at once. Cast your vote: http://www.macromedia.com/support/email/wishform/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137912 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: dreamweaver stuff
F10 Code Inspector. André -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 14:42 To: CF-Talk Subject: RE: dreamweaver stuff No I am referring to Split View in CF Studio it gives you 2 views of the code. Example: So you can look at a query at the top of the Doc and a CFOUTPUT at the bottom at the same time. Collapsible code is nice also. Rick -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 8:29 AM To: CF-Talk Subject: RE: dreamweaver stuff Hey Rick, If you are referring to viewing your page in Code View and Design View at the same time, then Yes this feature is still present in MX 2004. When you open a document you will see on the top tab three buttons, Code, Split and Design. Click on Split to switch to split screen mode. This is defiantly one the most useful features of Dreamweaver. - Neal -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 7:20 AM To: CF-Talk Subject: RE: dreamweaver stuff While we are on DW subject... I just started using it last week now that I have multiple sites and different developers working on them Studio just didn't seem like the way to go. One thing I miss or can't seem to find is the Split View. Is this gone? It was really helpful to look at 2 areas of code on a page at once. Rick -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 7:43 AM To: CF-Talk Subject: Re: dreamweaver stuff I do know the answer to the first question is definitely no. Part of the problem with the title bar is that it is not a relative path based on the Site, it's relative to the document and only goes one directory, so a file that looks like this: C:\MySites\myCoolSite\mySubDir\myOtherDir\myChildDir\myfile.cfm where myCoolSite is the DW site root, will display like this in both DWMX and 2004: myCoolSite (myChildDir/myfile.cfm) If indeed DWMX DID show the entire path relative to the site, then it would be reasonable :) I have partially written an extension to show the full file path (Windows only) in a toolbar... HTH, Calvin - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 22, 2003 8:38 AM Subject: RE: dreamweaver stuff I'm trying to acclimatize to dreamweaver and I'm hoping somebody on the list can tell me if theres a way to do these 2 things: 1) display the entire file path in the dreamweaver title bar. Having only the file name and the last directory visible and not being able to get the full path from file properties, etc. makes it really difficult for me to keep track of what I'm doing, especially when I've got more than one site with the same directory and I need to know which site I'm editing. 2) eliminate the Update Files: Scan site for links to renamed files? dialog when I remove or rename files. First, let me preface this by saying I haven't worked much with DWMX 2004; I have worked quite a bit with DWMX 6.1, though. Unfortunately, I don't have definitive answers for either question, and suspect that for both of them, the answer is no, you can't do that. However, within the site-based work style encouraged by Dreamweaver, these behaviors make sense. When you create a site, one of the benefits of this is that you don't have to deal with file paths directly, when working with that site. Dreamweaver provides a site-relative path in the title bar, and in theory, you shouldn't have to worry too much about where on the filesystem the site files actually are - after all, you may have local and remote site information within your site definition, and those paths may well change between the two. It would be nice, though, if the Site panel updated to show the site containing the file you're actually working on. Also, when you move or rename a file through Dreamweaver, the Update files dialog box is one of the benefits - it automatically fixes any references to that file. If you do these operations through your filesystem browser instead of through Dreamweaver, you won't get a prompt within Dreamweaver, though. A lot of the Site stuff is best suited to a specific way of working, and if you work that way, it's very helpful. If you don't, though, it may be less helpful. I find it very useful for working with static HTML, and for managing Contribute users. For application development, I find it less helpful, although I still typically use it anyway. DWMX 2004 deemphasizes the reliance on setting up sites, as I understand it, so you may want to take a look at it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137913 Archives:
RE: dreamweaver stuff
Right you are. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 15:20 To: CF-Talk Subject: RE: dreamweaver stuff Not a solution but: In Dreamweaver, using just the Tab key will indent blocks of code for you. You can't do that in Studio. Sure you can. In HomeSite+, hit F8 to bring up the Options. Click on the Editor option in the left nav pane. Check the 4th checkbox from the bottom (Tab/Shift+Tab performs block indent/unindent) and then Apply and you're good to go. Regards, Dave. _ Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! http://join.msn.com/?page=dept/byoa ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137919 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: dreamweaver stuff
In order to get Homesite+ I'm pretty sure you need to buy DW. You can get Homesite by itself but not Homesite+or something like that. It's changing every 5 minutes so who knows. You have to ask yourself, will MM continue developing two products that have such a large overlap of functionality? André -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 15:37 To: CF-Talk Subject: RE: dreamweaver stuff A Now I see what MM is up to - we're supposed to buy both products and use Dreamweaver side by side with CF studio ;-) Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 15:29 To: CF-Talk Subject: Re: dreamweaver stuff Out of those 5 developer-centric features only 1 of them is possible in DWMX? I don't believe in knocking things before you've tried it but this isn't a good start is it? Perhaps I'm the only one using those features. I never suggested DW MX can replace Homesite/CF Studio, not here, not ever. Personally I am happy using both side by side (plus TopStyle) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137934 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: dreamweaver stuff
In order to get Homesite+ I'm pretty sure you need to buy DW. Right. But if you, like me, don't need the additional functionalities, Homesite 5.5 is 99 bucks (29 for the upgrade) You can get Homesite by itself but not Homesite+or something like that. It's changing every 5 minutes so who knows. It never changed since DW MX was released, almost a year and an half ago That'll shut me up. You have to ask yourself, will MM continue developing two products that have such a large overlap of functionality? That's indeed a good question Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137942 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: dreamweaver stuff
Eh? This was done about a year ago I think. It's not flipped back and forth at all. MACR simply stopped selling ColdFusion Studio, renamed it as HS+ and put it with DW. Whether you like that move or not, I don't think MACR is being wishy-washy about it. I've been corrected on this point already. That'll teach me to comment. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137943 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Correction
Just to be anal, you don't need any #'s or the GT 0 at end as GT 0 evaluates to true. cfif listFind(variables.accesslist,cat_ID) André -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 September 2003 17:32 To: CF-Talk Subject: Correction Don't you just love when people make suggestions on how to change code and their suggestion is hosed? Like the one I just publihsed. I dropped a pound sign: cfif #listfind(variables.accesslist, cat_ID)# GT 0 There, THAT'S better... Put the pound signs outside the function: cfif #listfind(variables.accesslist, cat_ID) GT 0 I'm not sure what I'm doing wrong with this list function. I have a variable with a list in it, I want to take an action when the variable is equal to the query row variable. I can get it to work with listcontains but that will return more values than I want. I can also get it to recognize the first value in the list when I hardcode the list rather than use a value. It's almost like it doesn't evaluate the variable and treat it as a list. Here's the code, cfset variables.accesslist = 1, 82, 104 !--- Cat_ID equals 1 --- cfif listfind(#variables.accesslist#, #cat_ID#) GT 0 Blah, Blah, Blah cfelse .. /cfif The cfelse condition is always returned. I've tried every combination of quotes and pound signs also, to no avail. Any help would be appreciated. Daron Smith ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137699 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: ListFind not working properly
Replace all spaces on the list first. -Original Message- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] Sent: 19 September 2003 17:06 To: CF-Talk Subject: FW: ListFind not working properly I'm not sure what I'm doing wrong with this list function. I have a variable with a list in it, I want to take an action when the variable is equal to the query row variable. I can get it to work with listcontains but that will return more values than I want. I can also get it to recognize the first value in the list when I hardcode the list rather than use a value. It's almost like it doesn't evaluate the variable and treat it as a list. Here's the code, cfset variables.accesslist = 1, 82, 104 !--- Cat_ID equals 1 --- cfif listfind(#variables.accesslist#, #cat_ID#) GT 0 Blah, Blah, Blah cfelse .. /cfif The cfelse condition is always returned. I've tried every combination of quotes and pound signs also, to no avail. Any help would be appreciated. Daron Smith ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137700 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: wanted features (was Re: (Admin) disclosure)
Michael, You should be able to utilize the underlying HttpSessionListener interface to monitor session creations and destructions, though that requires writing an appropriate Java class which isn't a big deal if you don't mind getting your hands dirty with Java. You'll also need to use J2EE sessions. Admittedly, having a native ColdFusion hook for these events would be useful i.e. you register a CFC that listens for these events and when the event occurs all the listening CFCs get notified with the appropriate event. Unfortunately, CFCs don't support interfaces so this might be a little tricky to implement i.e. deciding which method in the CFC to call. Are you aware of the SessionTracker class that maintains a collection of sessions for a given ColdFusion application? André -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 18 September 2003 06:07 To: CF-Talk Subject: Re: wanted features (was Re: (Admin) disclosure) The two biggest requests for new functionality I here are: 1) End of session processing (however it's done, an event model, a special template handler, etc - people are always asking how do I tell when a user is about to time-out). That would be great. OnEventEnd as a setting of some sort in the CFAPPLICATION tag to run a template when the specific event ends (OnSessionEnd, OnApplicationEnd). An admin or programatic way of watching the current session information would also be great. You can hack such a thing now, but built in would be so much nicer. 2) Direct Image manipulation (at the very least information access and resizing - it seems like every other week somebody is asking how to do a thumbnail gallery). This is pretty easy nowadays if you know a little Java - but many CFers don't. Direct image, PDF, RTF, etc. manipulation/creation. We can create graphs on the fly nativly in CF, we can create images using the CFX_Image tag, we can use X,Y, or Z product to create PDFs. Why not make it all native to CF. Even if NNTP's not in demand it does seem like one of the only major protocols that CF doesn't support natively. For that reason alone it might be nice to see it in there (Supports all major Internet protocols). My point. :) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137508 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Gzipping cold fusion pages on IIS 5.0
I concur. HTTP compression works well with IIS5.0 and ColdFusion MX. No added purchase or change to code necessary. See here for a good description of how to set it up: http://www.eggheadcafe.com/articles/20020716.asp The gzip filter from Servlet Suite also works well: http://www.servletsuite.com/servlets/gzipflt.htm But is not as efficient as implementing compression via IIS. André -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 01:21 To: CF-Talk Subject: Re: Gzipping cold fusion pages on IIS 5.0 Scott Ashman wrote: Anyone know of a good product / method that can incorporate the gzipping of files with cold fusion output? IIS 5.0 has compression ability but it seems to really only be useful with static pages. I've seen a couple of $1k+ solutions, but would rather have a cheaper solution. The IIS 5 compression works fine with CF MX. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Sending binary directly to the browser?
Are you sure it's binary data? Does it return true when you try isBinary(gifdatahere)?? You can try outputting the data to the output stream directly by utilizing the underlying page context. Christian Cantrell blogged an example of doing this here: http://www.markme.com/cantrell/archives/002658.cfm André -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 05 September 2003 16:04 To: CF-Talk Subject: Re: Sending binary directly to the browser? cfcontent type=image/gif; charset=8859_1 cfoutput#gifdatahere#/cfoutput I've tried, but it does not work. If gifdatahere contains binary, CFCONTENT complains it can accept only a string, if it is a string, the string is truncated to the first zero byte. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Massaged query output to Excel file (was query output to Excel fi le)
George, I have done this and it works quite successfully. I use XSLT to transform the XML into both tab delimited and csv format amongst others then in combination with cfcontent I allow the user to export/save the data in their desired format. The XML document is built up at the same time as it is being displayed in HTML e.g. In your cfloop cfloop td#column1#/td cfset xmlDoc.xmlRoot.xmlChildren[rowIndex].xmlChildren[i].xmlText = column1 /cfloop You could of course generate the HTML/Report output using XSL too but I found it more efficient to generate the HTML and XML document concurrently because the HTML view will always be seen before the user optionally exports it to another format. André -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 18:23 To: CF-Talk Subject: Massaged query output to Excel file (was query output to Excel fi le) Petr said: What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. Different but similar. I need to create an Excel file (or a CSV file, or a tab delimited file, or a print file) from query output that has been massaged into reports that are already displaying on the screen (i.e., save the displayed report output to Excel, CSV, tab delimited or print). We have a guy on our team looking into saving the formatted query output to xml from which we would then generate any of the other formats. Has anyone tried this? Does anyone have other ideas on how to do this? George [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: meeting room booking application
Mike, Does it need to be ColdFusion? And if it is, does it need to be customizable? If not there are plenty around in other languages. Regards, André -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 17:01 To: CF-Talk Subject: meeting room booking application Anybody know of a 'meeting room booking' application in CF? I've done some searches but not found quite the right thing. Seems to me it must be a common kind of requirement to manage shared resources on an intranet. Of course if we had the time we could write one... ;-) Michael Traher Systems Manager ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: query output to Excel file
Tony, Alternatively, just append the data to a variable as you are looping through with commas as delimiters etc. and then write the variable to the file when you are done. André -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:55 To: CF-Talk Subject: RE: query output to Excel file but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will function exactly like excel. The following code will trick the browser into thinking it's dealing with excel: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=sample.xls CFCONTENT TYPE=application/excel If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file trouble is, I cant do it all in 1 query, I have cf logic that HAS to be there, and it is then emailed to a client :( so, is there a way to take a cfquery object that is returned, and just dump that into something, and send it, versus writing line by line by line tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:53 AM To: CF-Talk Subject: RE: query output to Excel file Youre using SQL server yes? So DTS would be the best option for that amount of data, Jon Hall posted all about it a few months back, check the archives. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 15:54 To: CF-Talk Subject: RE: query output to Excel file id love to know myself, I have a query that returns an assload of data, that I have to write to csv, and now it takes 45 minutes to complete...there has to be a better way! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Petr Kysela [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:45 AM To: CF-Talk Subject: query output to Excel file What would you say is the best way of creating an Excel file from query data? I don't need to know how to create a .csv file. I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. But surely there must be something quick and easy. Cheers ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Load Balancing
Shahzad, A few pointers: If you locate the relevant services via the services applet you can specify files to run on various events including: First Failure Second Failure Subsequent Failures In addition to specifying a file to execute you can indicate you want the service automatically restarted. If you go with the batch file route, its just a matter of using net start with the appropriate service name e.g. Net start ColdFusion MX Application Server You can find the name of the service name by right clicking on the appropriate service and looking at the general tab. There are already batch files provided for stopping and starting MX services: Start.bat Stop.bat Located here: {cfroot}\bin André -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 11:37 To: CF-Talk Subject: RE: Load Balancing How does that batch file know when to be executed. Or shall I schedule every 1 min? which I don't feel is right. Because I want to start the restart the services whenever it crashes not just one off. Also can I have a copy of that batch file (to stop or restart IIS/CFMX services) if someone has written Thanks Shaz -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 10:40 To: CF-Talk Subject: Re: Load Balancing On Tuesday 02 Sep 2003 09:20 am, Shahzad.Butt wrote: So all I need is that if for some reason either IIS or CF server is crashed or stopped then either it shuts down the server or it restart that services. Seems easy enough - write a batch file that requests a file from your webserver, and if it doesn't get it, stops the service. I use CygWin for stuff like this. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: machII(too much)
Perhaps you thinking of the Heisenberg Uncertainty principle. André -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 14:45 To: CF-Talk Subject: RE: machII(too much) But then it dawned on me that maybe the debug output was causing the higher times. Does anyone know the name of this effect. Where you change the environment you are measuring? I'm sure is has a name. Ade -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 16:49 To: CF-Talk Subject: RE: machII(too much) That's what I was saying last week, but not so fast... To get the fast times, you need to turn off the debug output and then you'll see those times *drastically* reduced. I was banging my head against the wall last week not understanding why a simple contact manager would take 500 - 1000ms (according to cfmx debug output). But then it dawned on me that maybe the debug output was causing the higher times. Sure enough, that's what it was. I'm now consistently getting 50 - 100ms rendering times. I would like to see some benchmark times on larger applications though. Mark ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Mutiple SQL Inserts
No help whatsoever but for future reference: This arrangement is sometimes referred to as a Vertical Partition as opposed to Horizontal Partitions which is what you might use for archiving data etc. Vertical Partitions are definitely worth considering for saving space if the circumstances are as you describe. The most convenient way to deal with them is to create a database view - preferably and updatable view that joins the two tables. Then you just perform the single insert/update on the view as normal. André -Original Message- From: Rick Kennerly [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 13:54 To: CF-Talk Subject: Mutiple SQL Inserts I didn't realize until this project that all of my relational database work was kind of one-dimensional, all of the related tables were built with dropdowns to feed the main table in mind. None of the related tables update information by users. Now I have a project where I need to add several fields to a well-established table in a db. However, only one in 500 new inserts would need these fields, so a related (sub)table is the way to go to save space. The problem is, not one of my references addresses an example of multiple Inserts into a DB. I've thought of two approaches. Is there a best practice? (or something I haven't thought of?) Action_Form Queryinsert info into new related table Queryget row number from new related table Querypass the row number of the new related table to the form and Insert the entire form into main table all in one shot or a series of forms and action pages that kind of step through the transaction. Rick ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Logging users in with CFC
Mike, Macromedia has an article about this very topic: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfc_practices.ht ml Its been there for about a year so Im sure there are more comprehensive examples around by now. Regards, André -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 26 August 2003 04:24 To: CF-Talk Subject: RE: Logging users in with CFC Tony, to be honest, I'm not sure. It's just that I haven't seen any examples of CFCs being used for that functionality, so I wondered why. It seems that one of the ways to collect all the functionality related to users is to have a users.cfc where you'd have a method called login, one called listusers, one called updateprofile, one called emailpassword etc, and then all the database access, and action related to user access is in the one place. This is what's advocated in other applications about CFCs, but I haven't seen login, authentication, updating last login date, number of logins etc - all that user access stuff - gathered into a CFC. So I wondered if that was because people have always done it without CFCs and therefore old habits are at play, or whether there was a logical reason not to include this stuff in CFCs, that I wasn't seeing. (Believe me there's a LOT about my world that I don't see. Just ask my wife!) Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 1:05 PM To: CF-Talk Subject: RE: Logging users in with CFC what things might you be worried about? security? just wondering...i hadnt given it much thought but now that you mention it, what things are you wondering about? later. tw ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Good News: (was RE: Mach II 1.0 )
Murat, There are plenty of resources covering OOP which are language agnostic and indeed OOAD is of course language neutral. I believe that's what Hal was referring to and even if he wasn't it's still a valid. I'm pretty sure there have been recommendations for OO books/resources on this list in the past. There are even a couple of titles which in fact do cover OOP with CF and I have no doubt that in the near future there will be a proliferation of these titles/resources specific to CF. André -Original Message- From: Murat Demirci [mailto:[EMAIL PROTECTED] Sent: 14 August 2003 11:58 To: CF-Talk Subject: RE: Good News: (was RE: Mach II 1.0 ) Who is the audience? You say we, CFMX developers, need to learn OO. OK. I want to learn it to create powerful apps but how? There is no source for OO programming in CF? -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 11:40 AM To: CF-Talk Subject: RE: Good News: (was RE: Mach II 1.0 ) You won't really need to know much about XML, Michael, but you will need to know OO to do a lot with Mach-II. Hal Helms Java for CF Programmers class in Las Vegas, August 18-22 www.halhelms.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 1:35 AM To: CF-Talk Subject: Good News: (was RE: Mach II 1.0 ) Hal put a new version of Mach-II on the site Mach-II.com last night, and bingo! The problem was I wasn't using US date format. In a jiffy, he corrected the bug so it accepted international date formats and now it goes. Like lightning it goes! It installed and the sample apps worked just like that - right out of the box. No muss, no fuss. Now I want to know more about how this whole thing works. I get the impression that working in the Mach-II environment is going to require a knowledge of object-oriented programming terminology that I don't have. Is that right? For example I rather get the impression that expressions like MVC - Model View Conroller are familiar to people who've done other programming. Is this so? If I want to become adept at using Mach-ii am I going to have to learn about OO Programming? I can see that amongst the disciplines I'm going to have to know well are XML, but I need to learn more about that anyway. Anything else? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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: Webservices, Components passing parameters
Try this: Go to your ColdFusion Administrator. Locate the web service in question via Data Services - Web Services. Click on the refresh icon. Try running your code again. André -Original Message- From: A.Little [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 10:00 To: CF-Talk Subject: Webservices, Components passing parameters Hi all, OK, can anyone tell me what I;m doing wrong here... I have created a very simple webservice (see code below), which works fine if I try to call it as a cfc, but as soon as I try to call the method as a webservice, I get the error 'Web service operation getDocTitle with parameters {5459} could not be found.' If I comment out the parameter/argument bits - so nothing is passed and nothing is expected by the cfc - it all works fine. I'm sure there must be something simple I've missed TIA Alex Code samples: cfc page: cfcomponent cffunction name=getDocTitle access=remote returntype=string cfargument name=DocumentID type=numeric required=yes cfquery name=qry_getDoc datasource=#request.dsn# SELECT DocumentTitle FROM tblDocument WHERE DocumentID = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.documentid# /cfquery cfreturn qry_getDoc.DocumentTitle /cffunction /cfcomponent Calling page: cfscript DocumentID = 5459; ws = createobject(webservice,http://kn-dev.open.ac.uk/testarea/webservice/ docu ment.cfc?wsdl); testvar = ws.getDocTitle(#DocumentID#); /cfscript cfdump var=#testvar# ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Caller access to query
Some people (not necessarily me) believe doing this is better: cf_mytag theQuery=#myQuery#/ i.e. passing the query by value and hence avoiding breaking any kind of encapsulation. Inside the tag you refer to the query in the normal way e.g. cfset localQuery = attributes.theQuery or just: cfloop query=attributes.theQuery ... /cfloop However, if you follow the syntax of native ColdFusion tags then the analogous approach is to do what you have opted to do. E.g. cf_mytag theQuery=myQuery/ Inside the tag: cfset localQuery = caller[attributes.theQuery]/ André -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 19:13 To: CF-Talk Subject: RE: Caller access to query Thanks everyone, I was passing the queryname in as an attribute and cfset _localQuery = Evaluate(Caller. + Attributes.query) / was just what I needed. I had to change the + to for concatenation though. Thanks John Venable -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 12:58 PM To: CF-Talk Subject: RE: Caller access to query If myquery is the query on your page then in your custom tag cfset _localQuery = Caller.myquery / Better is to pass the query in the tag cf_mytag query=myquery / and in the tag cfset _localQuery = Evaluate(Caller. + Attributes.query) / WG -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 17:45 To: CF-Talk Subject: Caller access to query Is there a way to access an existing query recordset from a custom tag called on the page? So if I have a query in a page, and I call a custom tag, can i use the query data through come sort of caller scope object? I can't seem to make it work. Thanks John Venable ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Problem calling CFC from .NET
In other words you need to come up with your own mechanism for maintaining a session across web service invocations. This is fairly trivial and there are different approaches you can take. If you called the CFC as a web service from within ColdFusion you'd have the same problem. However, you called it as a local object which meant it would maintain its state. The access attribute being set to remote only indicates that the CFC can be called as a web service not that it IS a web service only CFC. André -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: 08 August 2003 09:01 To: CF-Talk Subject: Re: Problem calling CFC from .NET On Thursday, Aug 7, 2003, at 17:12 US/Pacific, kevin ruggiero wrote: Well, I'm not sure it warranted an of course not, seeing as how it did work fine when called from ColdFusion If you call if from CF, it's like a local function call. If you call it as a web service, there's no sense of session management - the calling client could be anything so there is no standard way to maintain a session. Sorry, I thought this was very obvious but I guess I'm making assumptions - no offense intended :( That would make sense, I just was not aware that CF will not maintain state on calls to web services. Well, it's more that the *client* isn't maintaining session so each time CF is called, it treats it as a new session (imagine turning off cookies and not being able to add tokens to the URL). I was hoping that it could maintain state through some mechanism similar to session management, which I don't believe is unreasonable to fathom. Normally session management occurs through collaboration between the server and the client. It relies on the client following a protocol, either through cookies being passed back and forth or through URL data. Web Services can be called by a wide variety of clients that know nothing about cookies or URL parameters - so there is nothing for the server to hang on to... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple html question
You can't get smaller than 1 pixel thickness (unless you consider dotted/dashed borders) table style=border:1px solid black tr tdhello world/td /tr /table That's as thin as you can get (it definitely doesn't look the same the default border - though that depends on your browser) André -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 17:36 To: CF-Talk Subject: Simple html question Hi, Just a very simple question, is it possible to apply a style to a table to manipulate its border, border=1 is just a tab to thick for the fine layout our designer has done. I tried table style=border:1px;border-color:#00, but this just gives the default border of one. Can't seem to find anything in the style editor shipped with CF studio 4.5, Respectfully, j. ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: THE FIX (struct question)
You might just escape punishment this once before the # Nazi's come along... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 13:32 To: CF-Talk Subject: RE: THE FIX (struct question) laziness brings in more #'s its easy to use #'s its hard to remember every instance every time where one doesnt need #'s I think last night I was dreaming in myriad patterns of #'s and ()'s analysis tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 5:47 AM To: CF-Talk Subject: RE: THE FIX (struct question) Tony, Minor point but you shouldn't need the #'s. André -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 04:46 To: CF-Talk Subject: THE FIX (struct question) heres how... cfset numberOfThesePuppies = #arraylen(structFindKey(session.cart,product.id))# -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 11:43 PM To: CF-Talk Subject: struct question what function(s) do i need to use, if i want to know how many occurences of a value are present in a structure? thanks! im drawing a blank here.. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: THE FIX (struct question)
Tony, Minor point but you shouldn't need the #'s. André -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 04:46 To: CF-Talk Subject: THE FIX (struct question) heres how... cfset numberOfThesePuppies = #arraylen(structFindKey(session.cart,product.id))# -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2003 11:43 PM To: CF-Talk Subject: struct question what function(s) do i need to use, if i want to know how many occurences of a value are present in a structure? thanks! im drawing a blank here.. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load testing...
Ryan, Try Google and free load testing tools. More specifically, you'll want to search for Load/Stress testing specific to web sites e.g. the following are all free: 1)Microsoft's Web Application Stress Tool http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062a-4 39e-a67d-75a89aa36495DisplayLang=en 2)Apache's JMeter http://jakarta.apache.org/jmeter 3)OpenSTA http://www.opensta.org Amongst MANY MANY MANY others. Micrsoft's tool is good to get started with if you are new to the area though somewhat limited in more advanced functionality. André -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 09:36 To: CF-Talk Subject: Load testing... Hello I want to load test one of my sites, to see what sort of traffic it can handle, to see if there are areas I need to improve etc... Am I dreaming thinking their are tools (free is good) out there to do this? Ryan ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMAIL Send Failure
Is the SMTP server accessible from your new box? Can you ping 65.110.72.126 from the box? I suspect not because that is what the log files say. Verify the correct IP address to use for your SMTP server. André -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 13:51 To: CF-Talk Subject: CFMAIL Send Failure I've got a dedicated box running win2003, IIS 6.0 and CFMX 6.1. I'm a newbie at server admin BTW. Since moving a few of my sites to this box, my cfmail tags have quit working. I must be missing a config issue, because in CFAdmin, the Mail server verification fails. In addition, in the mail logs, I get these errors: Could not connect to SMTP host: 65.110.72.126, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect Invalid Addresses; nested exception is: javax.mail.SendFailedException: 500 Unkown temp error Invalid Addresses; nested exception is: javax.mail.SendFailedException: 550 Mail rejected ; nested exception is: javax.mail.SendFailedException: 550 Mail rejected How do I solve? (SMTP services in IIS are not installed, could this be the problem)? Thanks, Mark ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GetPageContext() function...cfinclude from a cfscript?
GetPageContext() allows you to gain access to the underlying JSP/Servlet page context. This allows you to share sessions and requests with JSP's and Servlets as well as letting you perform server-side re-directs and forwards. cflocation as I'm sure you know performs a client-side redirect. The full scope of possibilities that access to the page context is not covered here. For more information refer to your CF Documentation (Integrating J2EE and Java elements in CFML Applications) For more information on methods available to the page context refer to the JSP/Servlet API's available from java.sun.com. Alternatively, look for any JSP tutorial that mentions the context. That should get you on your way. André -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 13:56 To: CF-Talk Subject: GetPageContext() function...cfinclude from a cfscript? Could someone please explain what GetPageContext() does within CFMX? I just came across it in one of the other posts and it got me thinking about using GetPageContext().include(somefile.cfm) for cfincludes within cfscripts, but it doesn't seem to share the same memory/variables (which, I guess, could be a benefit.) What is possible with this tag? Is it slow? What other functions are available, etc? I've gotta know! Tyler ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFUnit
Although I haven't got the DRK or seen the code for CFUnit, what I gather from Christian's article is that the CFUnit framework is merely just one single CFC!! i.e. it is vastly simplified compared with JUnit. Again, this is mostly guess work but it probably goes something like this: A singe CFC called TestCase.cfc containing a method run(). This run method implements the Template Method design pattern i.e. it calls some other private methods like setUp() and teardown() etc. At some point during the proceedings CFC metadata is used to introspect the CFC for all methods beginning with test. These test methods are called one by one. Inside of each of the test methods you invoke the CFC you are testing and subsequently invoke some assertion methods (which are defined in the base TestCase.cfc). These assertion methods are presumably fairly trivial and comprise of things like assertEquals, assertTrue etc. Obviously you can add your own assert methods to the base class as needed. Again, I'm guessing but I think all these assert methods do is output an HTML table row with the results of the assertion. I could be way off because as I said I haven't seen the implementation of CFUnit but I think that's pretty much it i.e. ONE CFC! And no where near as complex as JUnit. On your point about having an equals method: This would be feasible if the CFC you were testing implemented and equals method which was able to tell whether it was equal to another CFC by way of comparing instance variables/object state etc. i.e. it would require a custom implementation of an equals() method for every CFC that you built - just as you would have to do in Java (using the default implementation of equals() defined in the Object base class that everything extends USUALLY doesn't provide the results you are after) André -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 18:06 To: CF-Talk Subject: RE: CFUnit It can quite easily be transferred to CFC. I started down this road but found several barriers to replicating junit in CFMX for testing cfcs. when is object a equal to object b for example. If anyone has replicated the example in the Junit example (called test infected I think? ) in cf I'd love to see it. testing custom tags, I guess would be easier as you can look for the output your are expecting. What can you do/test with the DRK CFunit? Unfortunately, there are some of us that can't afford the DRKs!! Well I'd prefer an ipod. WG -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:48 To: CF-Talk Subject: RE: CFUnit I'm hoping it will be released separatelyor continue writing my own version. It's not hard to do and have already developed a version for unit testing custom tags. See the links I just posted to see how you could implement your own (even more comprehensive) version. Unfortunately, there are some of us that can't afford the DRKs!! André -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:49 To: CF-Talk Subject: RE: CFUnit Anyway to get this without the drk ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:33 To: CF-Talk Subject: RE: CFUnit Christian Cantrall. And it rocks. I _love_ the unit tester (and even added some more stuff to it). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:30 AM To: CF-Talk Subject: CFUnit Anyone got any ideas who came up with the CFUnit stuff on the DRK3? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFUnit
Try www.junit.org? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 04 July 2003 08:56 To: CF-Talk Subject: Re: CFUnit On Thursday 03 Jul 2003 23:43 pm, Christian Cantrell wrote: I wrote the code (it is not based on anyone else's work), but the concept is based on the JUnit testing framework: What license was junit under ? http://junit.sourceforge.net/cpl-v10.html is a 404... -- Thomas C Advanced ColdFusion Programmer PLEASE NOTE: When the Recipient Is Not Directly Observing This E-mail, It May Cease to Exist or Will Exist Only in a Vague and Undetermined State. PLEASE ALSO NOTE: I don't speak for the company that sent this. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Caching cfc objects in the application scope
Raymond, Can you perhaps quantify a little in terms of the level of stress that you have found to trigger this behavior? If it does turn out to be a bug and it isn't rectified in Red Sky then there are some serious implications for CFC based application frameworks such as FBMX which of course relies on an application level CFC. In addition, migrating to use of the server scope instead (if that turns out to be a solution) would not be practical in most cases. André -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 04 July 2003 05:41 To: CF-Talk Subject: RE: Caching cfc objects in the application scope On Thursday, Jul 3, 2003, at 08:53 US/Pacific, Raymond Camden wrote: It does improve performance. However, I (and others) have found issues with CFCs that are cached and under load. (And I don't mean big honkin amazon.com load, just medium level load.) Issues like: It does improve performance is a bit of a blanket statement. It *may* improve performance depending on what your CFC does and how you use it. Well, if you take the process of recreating the object out, you _will_ save time. It may just be a very small amount of time. ;) As for load issues, macromedia.com is heavily CFC-based and uses a lot of CFCs stored in server scope (we're the only application in town so we don't use application scope :) and we've never seen the sort of issues Ray has seen - even with tens of thousands of active concurrent users (we have 15,000-20,000 active sessions across six CFMX instances during morning peak load). The bugs I found were confirmed by MACR engineering, however, they were always stored in the application scope, so maybe that had an impact. Actually, since it was so easy for me to reproduce the bugs locally with a stress tool, I'll see if the server scope makes a difference. -Ray ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFUnit
Christian, Thanks for filling in the blanks. I may implement my own version at some point or begrudgingly hand over some money to get the DRK as it also appears to have some other great stuff. Regarding my comments on CFUnit's apparent simplicity compared to JUnit, these comments were not meant to be taken as criticisms (just in case you thought so!) On the contrary, the ability to implement a unit testing framework with just 2 tag based objects is one of the most blinding testaments to ColdFusion's power and ease of use! Nice work. André -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED] Sent: 04 July 2003 16:25 To: CF-Talk Subject: Re: CFUnit On Friday, July 4, 2003, at 04:55 AM, Andre Mohamed wrote: Although I haven't got the DRK or seen the code for CFUnit, what I gather from Christian's article is that the CFUnit framework is merely just one single CFC There are two components: test_case.cfc and test_suite.cfc. Test case is the base component for all cfunit tests, and test_suite allows you to bundle multiple test cases into a set, and run them all together. it is vastly simplified compared with JUnit. ColdFusion components are vastly simplified compared to Java objects, therefore I think a vastly simplified testing framework is appropriate. These assertion methods are presumably fairly trivial and comprise of things like assertEquals, assertTrue etc. There are about 10 assert functions. Obviously you can add your own assert methods to the base class as needed. Absolutely. They are very easy to add. I could be way off because as I said I haven't seen the implementation of CFUnit but I think that's pretty much it You're pretty close! i.e. ONE CFC! And no where near as complex as JUnit. No, it is not nearly as complex as JUnit. JUnit is designed to solve much more complex problems. CFUnit is designed to introduce the concept of unit testing to ColdFusion developers and provide them with a sound, straightforward implementation which can be extended as necessary. However I doubt many ColdFusion developers would have a need to extend it much beyond what it already provides. On your point about having an equals method: This would be feasible if the CFC you were testing implemented and equals method which was able to tell whether it was equal to another CFC by way of comparing instance variables/object state etc. i.e. it would require a custom implementation of an equals() method for every CFC that you built This is exactly right, which is why CFUnit does not provide this type of equals method. It certainly wouldn't be difficult to add, however, if you were inclined to do that level of unit testing. Christian ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parse formated list
You would use ListFind not ListContains because ListContains looks at elements to see if they contain the specified substring. -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:29 To: CF-Talk Subject: RE: Parse formated list This ??? ListContains(list, substring [, delimiters ]) Description Determines the index of the first list element that contains a specified substring. Return value Index of the first list element that contains substring. If not found, returns zero. Category List functions Syntax ListContains(list, substring [, delimiters ]) WG -Original Message- From: jeremy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:16 To: CF-Talk Subject: Parse formated list I have a list of days in a month being returned from a query. Example record set would be 2,19,19,21,27 Number between 1 and 31. I then loop through this query with the code below which generates a list var that looks like 19,19,21,27 when outputted. CFLOCK Scope=Session Type=Exclusive Timeout=5 CFSET Session.Calendar.EventListingDate = CFLOOP Query=getmonth CFSET Days = #DateFormat(getmonth.auctiondate, dd)# CFSET Session.Calendar.EventListingDate = ListAppend( Session.Calendar.EventListingDate, Variables.Days) /CFLOOP /CFLOCK That is all well. HERE IS THE PROBLEM. The problem is here with this cfif. Session.Calendar.EventListingDate contains the above list 2,19,19,21,27 And Variables.CurrentDay is a single number between 1 and 30. If CurrentDy is say 7 then this if evaluates true as 7 is in 27, but I don't want that. I want the cfif to check for JUST 7 in the comma delimited list. How would I do this. It seems like there should be a list fucntion for this but I can't find it. cfif Session.Calendar.EventListingDate contains Variables.CurrentDay /cfif ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Capturing signature input from PDA
Providing it was the PDA that was browsing the page then yes, this is possible. You could use an ActiveX component or a Java applet amongst other possibilities to achieve this. The component would need to be able to run on the PDA naturally and would be embedded in the particular web page the PDA was browsing. A quick google brings up this as a basic example (without the save functionality): http://www.lawrencegoetz.com/programs/signature/ André -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:31 To: CF-Talk Subject: Capturing signature input from PDA Is it possible to write a web component (perhaps ActiveX) that would allow a signature to be entered from a WinCE PDA onto a webpage and saved as a bmp/jpg on the server? T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Flash (crazy idea?)
Is there a particular reason why Flash is being mandated or needs to be used? If not, it would be just as possible to build using DHTML though that doesn't mean Flash shouldn't be used after all you'll have to deal with cross browser issues with the DHTML approach - however I believe the database interaction would be slightly easier. I would perhaps implement this as a two step process: 1) The user builds up a list of form elements - no wysiwyg involved - just normal web application stuff selecting from a pre-defined set. Then they would set properties for each element they add. You could allow the ability of setting maximum and minimum sizes, mandatory/non-mandatory, look up values etc. This list is then persisted - perhaps to a database of some sort. You can also create a table which would be able to hold the contents of the form. 2) Step 2 allows the user to arrange the elements they selected in step 1 on the screen via drag and drop techniques. In addition, you could allow the appropriate styling of the elements at this stage. Once this is done, the co-ordinates and positioning can be persisted - again perhaps to a database. It should then be feasible to build the form dynamically on-demand - including client-side and server-side validation and also perform the database insert into the newly created table by automatically creating the appropriate SQL provided you captured enough data initially. There doesn't seem to be any reason why this can't be done and indeed it has been done to varying degrees e.g. CommonSpot's simple form builder etc. André -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 15:59 To: CF-Talk Subject: CF Flash (crazy idea?) Hi everyone. I have an idea and need to know if it is within the capabilities of Flash and CF. What I would like to do is provide an interface for users to come to, where they can create forms and position the form elements and element labels wherever they wish (within a maximum area). How I envision this working would be to provide within the interface an area that contained a list of possible form elements to choose from (text input, text area, radio, check). When a user dragged one of these into the form area they could give it a label and fill in the attributes of that element as well as position the element and its label wherever they wanted (within the bounds of course). Now for the crazy part... Would it be possible to take that Flash movie that the user interacted with to create the initial form and process it into an HTML form where the layout was almost identical if not exactly identical to how it was created via the Flash interface (from a positioning and layout standpoint)? I was thinking maybe there are some functions in flash to get element coordinates, etc... The idea would be that this form could be used within an HTML email or website to gather user feedback. The second part would be to build some kind of container on the backend whereas those results/responses could be stored. Obviously this is a complex idea, one in which is beyond the scope of my abilities at this time. Anyone have thoughts, ideas, technologies to look at, etc... ? 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFUnit
It is based on the XUnit testing framework originally developed by Kent Beck along with Extreme Programming. http://www.xprogramming.com/software.htm I see no reason why Macromedia should charge for this though - it should be submitted along with all the other XUnit tools for public use. A good explanation (for JUnit) is here: http://junit.sourceforge.net/doc/cookstour/cookstour.htm It can quite easily be transferred to CFCs You should also look at these extensions here: http://www.junit.org/news/extension/index.htm André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:38 To: CF-Talk Subject: RE: CFUnit not a dig...just curious on how the MM thought process is done. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:36 To: CF-Talk Subject: RE: CFUnit Did he do it though? Is it a total new development by MM or is it a redevelopment of someone elses work -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:33 To: CF-Talk Subject: RE: CFUnit Christian Cantrall. And it rocks. I _love_ the unit tester (and even added some more stuff to it). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:30 AM To: CF-Talk Subject: CFUnit Anyone got any ideas who came up with the CFUnit stuff on the DRK3? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFUnit
I'm hoping it will be released separatelyor continue writing my own version. It's not hard to do and have already developed a version for unit testing custom tags. See the links I just posted to see how you could implement your own (even more comprehensive) version. Unfortunately, there are some of us that can't afford the DRKs!! André -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:49 To: CF-Talk Subject: RE: CFUnit Anyway to get this without the drk ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 17:33 To: CF-Talk Subject: RE: CFUnit Christian Cantrall. And it rocks. I _love_ the unit tester (and even added some more stuff to it). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 10:30 AM To: CF-Talk Subject: CFUnit Anyone got any ideas who came up with the CFUnit stuff on the DRK3? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Upload a document?
You can get cffile to create a unique file name if you set the nameConflict attribute to makeUnique. The name of the file as saved on the server is accessed in the variable: Cffile.serverFile See the ColdFusion Tag Reference for cffile action=upload for more information. Yes, Verity can index MS Word and RTF documents. Here is a partial list of supported types: Applix Words (v4.2, 4.3, 4.4, 4.41) ASCII Text (All versions) ANSI Text (All versions) Folio Flat File (v3.1) HTML (Verity Zone Filter) Lotus AmiPro (v2.3) Lotus Ami Professional Write Plus (All versions) Lotus Word Pro (v96, 97, R9) Maker Interchange Format (MIF) v5.5 Microsoft RTF (All versions) Microsoft Word (v2, 6, 95, 97, 2000) Microsoft Word Mac (v4, 5, 6, 98) Microsoft Word PC (v4.,5, 6) Microsoft Works (v1.0, 2.0, 3.0, 4.0) Microsoft Write (v1.0, 2.0, 3.0) PDF (Verity PDF Filter) Text files (Verity Text Filter) Unicode Text (All versions) WordPerfect (v5.x, 6, 7, 8) WordPerfect Mac (v2, 3) XyWrite (v4.12) See the Verity documentation in your ColdFusion Help Files or online at Live docs for more Verity information. André -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 15:22 To: CF-Talk Subject: Re: Upload a document? Mike, Can verity search a MS Word document and or RTF? Also how would I address the naming of the document that I place in the folder so there are no conflicts and the right name goes to the SQL database? Thanks for the information! Regards, JB Michael T. Tangorre wrote: Upload the document into a reusme folder record the name of the doc in the DB. Use verity to allow the search of those resumes in the resume folder? Im not a huge fan of storing mass amounts of text in a DB, although it is necessary sometimes. Mike - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 8:36 AM Subject: Upload a document? Hello All: I have a job posting site I'm working on and wanted to know if there is a way to have a user upload their resume, possibly scan it for a virus's and make it a searchable document in a SQL server 7 database? This may be a pipe dream. Any suggestions are welcome or a best practice you might use already. Regards, James Blaha ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Active PDF?
Have a look here: http://www.cfcomet.com/pdf/ More specifically, look at solutions utilizing FDF files and not needing COM. These FDFs can be generated server-side allowing you to pre-populate some of the form information from a database etc. before sending to the user who can then fill in the rest online. Have a look at the Adobe website for their form toolkit API. Depending on your exact requirements it might be easier than you think and won't require a third-party product like Active PDF. André -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: 25 June 2003 05:10 To: CF-Talk Subject: Active PDF? Howdy - I have a client who wanted to convert a number of Word-created forms to PDF's and put them up on their site. No sweat. Then, they wanted the user to be able to fill out form fields and have Acrobat do all the math, and they could print out a nice, cleanly filled-out form to sign and fax. Again, no problem at all. Now, however, they'd like to take the final step and have fully interactive PDF's - where certain dynamic fields are populated from database information, and the user can submit the PDF like they would any other web form and have CF process it accordingly. I've looked at ActivePDF, but before I dive into that, I wanted to send out some feelers to the group to see if anyone's worked with that with CF5 before. Money's not an object (to a point), so if there's a particularly awesome package there I should look into, I'm open to some suggestions. I am fiddling with XSL:FO syntax right now, but it's not exactly what I'm looking for, since I have to work off a previously-existing document (and I don't have a great deal of time to really get elbow-deep in *yet another* XML spec.) :) Thanks, - Jim ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Active PDF?
I couldn't agree more. I have achieved a similar work flow using FDFs and ColdFusion without problems (except some people not having Acrobat Reader installed) at a rate of approximately 100 per hour. I also have used Active PDF and believe it to be overpriced and overkill for the requirements outlined though for certain things relating to PDF generation it is the most suitable solution on the market. André -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 25 June 2003 13:42 To: CF-Talk Subject: RE: Active PDF? Jim, I'm using cfml to dynamically create fdf files. The link you supply to your interface calls the fdf. Within the fdf are all your dynamic data. The fdf itself hold a pointer to a blank pdf template. The template is loaded and all the data goes in the right holes. Acrobat reader (free version) supports form submission. Basically all the data comes back to you via http and is in the form scope when you go to process it. Overall there are many ways to do this , but this one is free. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 {at} columbia [dot] edu -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 12:10 AM To: CF-Talk Subject: Active PDF? Howdy - I have a client who wanted to convert a number of Word-created forms to PDF's and put them up on their site. No sweat. Then, they wanted the user to be able to fill out form fields and have Acrobat do all the math, and they could print out a nice, cleanly filled-out form to sign and fax. Again, no problem at all. Now, however, they'd like to take the final step and have fully interactive PDF's - where certain dynamic fields are populated from database information, and the user can submit the PDF like they would any other web form and have CF process it accordingly. I've looked at ActivePDF, but before I dive into that, I wanted to send out some feelers to the group to see if anyone's worked with that with CF5 before. Money's not an object (to a point), so if there's a particularly awesome package there I should look into, I'm open to some suggestions. I am fiddling with XSL:FO syntax right now, but it's not exactly what I'm looking for, since I have to work off a previously-existing document (and I don't have a great deal of time to really get elbow-deep in *yet another* XML spec.) :) Thanks, - Jim ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parse cfm templates stored in a variable?
There is no alternative but to include the file. However, if the code is all cfscript, it would technically be possible to evaluate the whole lot at run time. André -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 11:15 To: CF-Talk Subject: Parse cfm templates stored in a variable? Hello! I am reading files using cffile and storing them in a application variable (because they are very often accessed). If the file is a cfm template I would like to execute it - is there a simple way to do that? The only solution I've seen so far would be to save the application variable to a file and than do a cfinclude with that temporary file. Best regards, Peter ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parse cfm templates stored in a variable?
Mathew, Actually you can evaluate functions too e.g. #Evaluate(Len('foo'))# Naturally, you cant easily deal with loop constructs or conditional logic. When I said it would technically be possible - I meant it would be possible by using a suitable mechanism e.g. You could parse the file by semi-colon and then Evaluate each line e.g. If the file contained this: Foo = 'bar'; Bar = 'foo'; Baz = Left(foo bar,3); Then you could turn that into: Evaluate(foo = 'bar',Bar = 'foo',Baz = Left(foo bar,3)); Or a separate Evaluate for each line. I have done this successfully in the past when it was advantageous to allow a knowledgable user to enter some scripting which could then get executed at run time - much like you would do with VBScript/Javascript. HOWEVER, this is all way too much for what the original question was. It all depends on the context of why the include files are being put into the application scope for in the first place. If they are being held there to be used dynamically whereby the output or result of the include is going to be different each time (this is what I understood) then caching the output using cfsavecontent is not an appropriate solution. If, however, it is the output of the include that needs to be cached then using cfsavecontent to save the output is obviously the way to go. Under any circumstances it makes no sense to read the file in using cffile only to have to write it out again when you want to include it! The most suitable approach is just to cfinclude the file as needed. Regards, André -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 12:34 To: CF-Talk Subject: Re: Parse cfm templates stored in a variable? Actually you can only evaluate expressions, not whole chunks of cfscript such as loops, functions, etc. What's wrong with cfincluding them? Also BTW instead of using cffile why not simply use cfsavecontent and cfinclude? Perhaps you might consider cfincluding the CF templates and caching the result for a given period of time? Regards, Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:52 PM Subject: RE: Parse cfm templates stored in a variable? There is no alternative but to include the file. However, if the code is all cfscript, it would technically be possible to evaluate the whole lot at run time. André -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 11:15 To: CF-Talk Subject: Parse cfm templates stored in a variable? Hello! I am reading files using cffile and storing them in a application variable (because they are very often accessed). If the file is a cfm template I would like to execute it - is there a simple way to do that? The only solution I've seen so far would be to save the application variable to a file and than do a cfinclude with that temporary file. Best regards, Peter ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parse cfm templates stored in a variable?
Yes, I realised during lunch - just now - that's probably what you meant! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 13:48 To: CF-Talk Subject: Re: Parse cfm templates stored in a variable? Actually you can evaluate functions too e.g. Right. I think I meant function declarations rather than invocations -- too late on a Friday night for me. ;-) ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Consuming CFMX Web Services in ASP.NET
This is a known issue and has I believe been acknowleged by various parties. It is the result of a limitation of the underlying Axis engine that CFMX uses. I believe there were plans for Axis in the future (possibly the version that is used in the next point release of MX - I haven't tried yet) to mitigate problems concerning result set incompatibilities between .NET and CFMX. Since, the issue could be construed as lying with Axis it is somewhat out of Macromedia's hands. In the mean time, as suggested you could use an array of structs or develop your own CFC to represent result sets. André -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: 12 June 2003 01:22 To: CF-Talk Subject: RE: Consuming CFMX Web Services in ASP.NET Try returning an array of structs...should be a lot easier to work with in .NET -Stace -Original Message- From: Murat Demirci [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:21 AM To: CF-Talk Subject: Consuming CFMX Web Services in ASP.NET My friend has a problem when calling a web service method which returns CFMX query object. When I return a query object from CFC function, .NET cannot get the recordset object. I'm using CFMX U3. Any experiences? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Prevent Refresh
To avoid the refresh problem the best way to handle idempotent actions i.e form submissions is to perform a redirection after the relevant action has occurred. Note: This requires a client-side redirect which cflocation will do for you. So the page flow becomes this: 1) Form 2) Action Page - Database insert/update etc. 3) Redirect 4) End Page/Confirmation/Form again... If a refresh is done once on step 4, the Action page will not be run again. Hope that helps, André -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:18 To: CF-Talk Subject: Prevent Refresh What is best way of preventing multiple entries in DB through form submission when user clicks on REFRESH or BACK button of browser? Thanks Shaz ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQUERY - cachedwithin
Try this: In your application.cfm cfif IsDefined(URL.refreshQueryCache) cfset request.cachetimespan = CreateTimeSpan(0,0,0,0) cfelse cfset request.cachetimespan = CreateTimeSpan(1,0,0,0) /cfif Then... cfquery name=query datasource=dsn cachedwithin=#request.cachetimespan# ...BLAH... /cfquery For this to work you need to call the page with a URL parameter and it needs to be the page that has the query on it. Alternatively, for more granular control: cfif isDefined(application.recache) cfset request.cachetimespan = CreateTimeSpan(0,1,0,0) !--- Remove the application variable so this doesn't get re-cached again next time until it is set again else where... --- cfset StructDelete(application,recache) cfelse cfset request.cachetimespan = application.cachetimespan /cfif cfquery name=query datasource=dsn cachedwithin=#request.cachetimespan# ...BLAH... /cfquery etc. Hope that helps, André -Original Message- From: Jim Banks [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 13:19 To: CF-Talk Subject: CFQUERY - cachedwithin When you have used cachedwithin in CFQUERY, is it possible to override that before the cachedtime is up? For example, cfif not isdefined(application.recache) cfquery name=query datasource=dsn cachedwithin=#createtimespan(0,1,0,0)# ...BLAH... /cfquery cfelse cfquery name=query datasource=dsn ...BLAH... /cfquery cfset temp = structdelete(application, recache) /cfif Here, it'd be great if I could 'reset' the query so that if I've defined somewhere else on the site that the query has changed using the application variable, I can get it to use the new query results and cache that for next time, instead. Thanks! - Yahoo! Plus - For a better Internet experience ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how to share servlet's session with Cold Fusion MX template?
Unfortunately its not quite as simple as being able to see each others session or application variables in the same way. Request variables can be seen as you would expect. To put a variable into a ColdFusion session you have to do something like this: In your JSP/Servlet (Map) session.getAttribute(yourCFApplicationName).put(foo,bar); And then you can access it in a .cfm like this: #session.foo# Application variables are easier: application.setAttribute(yourCFApplicationNam.foo,bar); In you .cfm you access it like this: #application.foo# The key to remember is that it is all oriented around the application name you defined for your ColdFusion app using cfapplication I believe there is more comprehensive coverage in the cfdocs. Regards, André -Original Message- From: Steve [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 15:07 To: CF-Talk Subject: how to share servlet's session with Cold Fusion MX template? Hello everyone, I deployed ColdFusion MX as a web application to WebLogic7.0. I have a J2EE servlet that invokes a CFM page. This works. However, if I try to set an attribute in the servlet's session, and try to pass that session along to the CFM Page, in the CFM Page, it will NOT understand that attribute. In the CFM page, i have // test forwarding to cfm page. String userArr[] = new String[1]; userArr[0] = Wednesday; HttpSession session = request.getSession(true); session.setAttribute(sess, userArr); getServletConfig().getServletContext().getRequestDispatcher (/test/UserResultForm.cfm).forward(request, response); And in the invoked CFM page, I cfdump the session info with this line, cfdump var=#session# I don't see sess as a valid attribute! in fact, when I try to access it with !--- cfoutput debug : #session.sess#/cfoutput --- ColdFusion would throw an error saying sess is NOT defined. In the Cold fusion Adminstrator, i have certainly turned on Enable Session Variables and Use J2EE session variables flags and restarted the server. and in my application.cfm, I already have the following attributes set, as follows, cfapplication name=form175 SESSIONMANAGEMENT=YES SESSIONTIMEOUT=#CREATETIMESPAN(0,0,30,0)# Thx a lot in advance for any suggestions/examples! Steven - Do you Yahoo!? Free online calendar with sync to Outlook(TM). ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex replacing whole words
Standing on the shoulders of giants a very quick and dirty way of dealing with the case issue: cfset oldname=ben cfset newname=mike cfset t=rereplace(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName# \2,ALL) cfset oldname=Ben cfset newname=Mike cfset t=rereplace(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#newName# \2,ALL) i.e. not using REReplaceNoCase, just REReplace. André -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 15:46 To: CF-Talk Subject: Re: Regex replacing whole words This gets you part of the way: cfset oldname=ben cfset str=Ben lives in benland. But ben is actually not called ben. He's called ben-dabble. cfset newname=mike cfset t=rereplaceNoCase(str,(^|[^[a-zA-Z]]?)#oldName#([^[a-zA-Z]]?|$),\1#ne wName#\2,ALL) cfoutput#t#/cfoutput Note that it does not retain the proper capitalization from the original, but instead uses the name as supplied by newName. To get the proper capitalization, I think you will either need to run through every permutation of capitalization as different case-specific regex, or do a find-and-replace instead. Ninja, any ideas here? Jerry Johnson [EMAIL PROTECTED] 06/04/03 10:34AM I can't get my head around regular expressions! Help me please before I go mad! I need to replace one word with another, matching cases (if possible), but in a smart way. eg. Ben lives in benland. But ben is actually not called ben. He's called ben-dabble Say I want to replace 'ben' (any case) with 'mike', I would like to get: Mike lives in benland. But mike is actually not called mike. He's called mike-dabble Note the punctuation - I only want whole words, or words which are surrounded by punctuation. Does that make sense? I know I'm asking a lot but doing it using normal code and replace() is a slow operation. Even a reg-ex which will just replace whole words (including if they're at the beginning or end of a string) would be fantastic. I could do 2 regexs to do the case-matching, if it's not possible to do it in 1. Many Thanks! - Yahoo! Plus - For a better Internet experience ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS help
innerText is what you are after. You'll need to locate the relevant anchor object using DOM and then once you have that object it is just: anchorObject.innerText; That should set you on your way, André -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 16:25 To: CF-Talk Subject: OT: JS help Ok, this is an odd request but: I was curiosu if it is possible with javascript to reference the value of the text contained inbetween the a href=mylink.htm?search=JavascripforMyValueThevalue/a Any help would be awesome. I need to do this with JS only Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selecting form
Try something like this: select name=selectSystem size=1 class=inputfield option value= cfif NOT Len(form.value)selected/cfifSelect system.../option option value= Nintendo GameCube cfif NOT CompareNoCase(Nintendo GameCube,form.value)selected/cfif Nintendo GameCube/option ... /select If your drop down box is being populated from a query it becomes easier: select name=selectSystem cfloop query=systemSelect option value=#value# cfif NOT CompareNoCase(value,form.selectSystem)selected/cfif#display#/option /cfloop /select André -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 13:07 To: CF-Talk Subject: Selecting form Hi, I have a form where I'm storing all the input fields into FORM.variables so if the user hits the refresh the form is reloaded and all the input fields are retained. I have a dropdown menu selection in my form. How can I have the below code do the same. What am I doing wrong? Consolenbsp;System:nbsp; select name=selectSystem size=1 class=inputfield cfif value is FORM.value cfset isSelected='selected' cfelse cfset isSelected = '' /cfif option value= defaultSelect System.../option option value=Nintendo GameCube #isSelected#Nintendo GameCube/option option value=Nintendo GameBoy #isSelected#Nintendo GameBoy/option option value=Microsoft XBox #isSelected#Microsoft XBox/option /select ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCDEV List
I still receive posts from there so yes, it does appear to still be alive. André -Original Message- From: D. Delcomminette [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 13:23 To: CF-Talk Subject: SOT: CFCDEV List Is CFCDEV list still alive? I didn't receive any posts for more than a week, although I made 2 posts myself. Thanks Dominique ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: exporting DSN list
Create a ColdFusion Archive (using the archive tool found in the administrator) of the relevant bits and pieces you want to transfer. André -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: 02 June 2003 14:38 To: CF-Talk Subject: exporting DSN list Is it possible to export a DSN list using Cold Fusion Server Administrator or otherwise (CF 5) ... so that I don't have to manually reenter the DSN's whenever I redo a box Thanks in advance Tim ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can someone help me understand how to import com.allaire.cfx
You need to make sure com.allaire.cfx is on your classpath by setting a system variable. Alternatively you can compile with the -c switch specifiying where the library is e.g. Javac -c c:/cfusionmx/lib/ SimpleMessage.java Etc. André -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 11:10 To: CF-Talk Subject: Can someone help me understand how to import com.allaire.cfx Hi all, Im trying to write a small java app with the view to pulling them in with CF for some tasks suited to the job. This app has been copied straight from Java for CF Developers, //SimpleMessage.java import com.allaire.cfx.*; import java.util.*; import java.text.DateFormat; public class SimpleMessage implements CustomTag{ Date now=new Date(); DateFormat f=DateFormat.getDateInstance(DateFormat.FULL,Local.US); public void processRequest(Request request, Response response) throws Exception { f.format(now); String name=request.getAttribute(NAME); response.write(Hello, +name+! Today is +f); } } this file sits in c:/cfusionmx/wwwroot/web-inf/public/ obviously I want to implement this as a custom tag so Im trying to import the Allaire interfaces - com.allaire.cfx, this sits at c:\cfusionmx\lib\cfx.jar The problem is I can't, the classpath is set in administrator as c:\cfusionmx\lib\cfx.jar, I tried putting the jar file in the same directory as my java file, I also tried javac -classpath %classpath%;c:cfusionmx\lib\cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java, anyway this command gave this error, C:\CFusionMX\wwwroot\WEB-INF\publicjavac -classpath %classpath%;c:cfusionmx\lib \cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java:1: package com.allaire.cf x does not exist import com.allaire.cfx.*; ^ etc The compiler just doesnt know where the jar file is, I don't understand either how com.allaire is being called in the package reference either, I dont know where com.allaire is coming from, I know about designing packages, and if i'm right packages are directories, well cfx.jar is sitting in cfusionmx/lib/ not com/allaire/ overall error, I do understand the falling errors are caused due the tag having not been inplemented, well some! javac SimpleMessage.java SimpleMessage.java:1: package com.allaire.cfx does not exist import com.allaire.cfx.*; ^ SimpleMessage.java:5: cannot resolve symbol symbol : class CustomTag location: class SimpleMessage public class SimpleMessage implements CustomTag{ ^ SimpleMessage.java:9: cannot resolve symbol symbol : class Request location: class SimpleMessage public void processRequest(Request request, Response response) ^ SimpleMessage.java:9: cannot resolve symbol symbol : class Response location: class SimpleMessage public void processRequest(Request request, Response response) ^ SimpleMessage.java:7: cannot resolve symbol symbol : variable Local location: class SimpleMessage DateFormat f=DateFormat.getDateInstance(DateFormat.FULL,Local.US); ^ 5 errors J ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can someone help me understand how to import com.allaire.cfx
Err... Just realized my last post wasn't very helpful. Try this: javac -c {Installation Path}\lib\cfx.jar SimpleMessage.java André -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 11:10 To: CF-Talk Subject: Can someone help me understand how to import com.allaire.cfx Hi all, Im trying to write a small java app with the view to pulling them in with CF for some tasks suited to the job. This app has been copied straight from Java for CF Developers, //SimpleMessage.java import com.allaire.cfx.*; import java.util.*; import java.text.DateFormat; public class SimpleMessage implements CustomTag{ Date now=new Date(); DateFormat f=DateFormat.getDateInstance(DateFormat.FULL,Local.US); public void processRequest(Request request, Response response) throws Exception { f.format(now); String name=request.getAttribute(NAME); response.write(Hello, +name+! Today is +f); } } this file sits in c:/cfusionmx/wwwroot/web-inf/public/ obviously I want to implement this as a custom tag so Im trying to import the Allaire interfaces - com.allaire.cfx, this sits at c:\cfusionmx\lib\cfx.jar The problem is I can't, the classpath is set in administrator as c:\cfusionmx\lib\cfx.jar, I tried putting the jar file in the same directory as my java file, I also tried javac -classpath %classpath%;c:cfusionmx\lib\cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java, anyway this command gave this error, C:\CFusionMX\wwwroot\WEB-INF\publicjavac -classpath %classpath%;c:cfusionmx\lib \cfx.jar c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java c:\cfusionmx\wwwroot\web-inf\public\SimpleMessage.java:1: package com.allaire.cf x does not exist import com.allaire.cfx.*; ^ etc The compiler just doesnt know where the jar file is, I don't understand either how com.allaire is being called in the package reference either, I dont know where com.allaire is coming from, I know about designing packages, and if i'm right packages are directories, well cfx.jar is sitting in cfusionmx/lib/ not com/allaire/ overall error, I do understand the falling errors are caused due the tag having not been inplemented, well some! javac SimpleMessage.java SimpleMessage.java:1: package com.allaire.cfx does not exist import com.allaire.cfx.*; ^ SimpleMessage.java:5: cannot resolve symbol symbol : class CustomTag location: class SimpleMessage public class SimpleMessage implements CustomTag{ ^ SimpleMessage.java:9: cannot resolve symbol symbol : class Request location: class SimpleMessage public void processRequest(Request request, Response response) ^ SimpleMessage.java:9: cannot resolve symbol symbol : class Response location: class SimpleMessage public void processRequest(Request request, Response response) ^ SimpleMessage.java:7: cannot resolve symbol symbol : variable Local location: class SimpleMessage DateFormat f=DateFormat.getDateInstance(DateFormat.FULL,Local.US); ^ 5 errors J ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Removing bad emails from newsletter db
Blood, It's fairly straight forward to code yourself. You can access the undeliverables folder using CFDIRECTORY and then parse the messages for the e-mail address that bounced and use that to update the database. If on MX I suggest using server.coldfusion.rootDir etc. to locate the undeliverable folder etc. On CF5 and Windows you can use CFREGISTRY etc. Note: the .cfmail file formats are different from CF5 to CFMX. Also, if you want to re-spool messages in CFMX you need to rename the file and restart the CF's mail spool service...which is technically possible to do programmatically using yet more undocumented functions. André -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 16:40 To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: is an object with a lot of methods a memory buster?
Dave, Another possibility: Perhaps all of the instances of the persisted CFC merely carry a name/pointer pair which points to a singe stale copy of the method and hence Sean's statement still holds partially true regarding not taking up a great deal of space. However, I'm merely making a similar conjecture. André -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 27 May 2003 17:25 To: CF-Talk Subject: RE: is an object with a lot of methods a memory buster? However, I believe that when you create a CFC instance, you get (effectively) a Java Map (actually an implementation of a Map) that has entries for each method. Each entry is merely a 'pointer' to the representation of the method. I'm guessing that based on the fact that you can access methods of a CFC instance as variables: fn.cfc: cfcomponent cffunction name=foo /cffunction /cfcomponent tfn.cfm: cfscript x = createObject(component,fn); y = x[foo]; y = x.foo; /cfscript So, in each CFC instance you create, you will get entries in the Map for every method (or, at least, every public method) but those entries won't take up a great deal of space (since they are just name, pointer pairs). Good answer; that's just what I wanted to hear. Thanks very much! While that may be what you wanted to hear, I have my doubts about it. When you create an instance from a CFC and put it in a persistent scope, then change one of the methods within the CFC code, the instance doesn't use the new code, but rather the original code that was there when it was instantiated. This leads me to believe that it carries its own copy of the method code with it. 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...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: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...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: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
MySQL has an AUTO_INCREMENT column type (well it used to). It depends what scope of uniqueness you need for the ID - if unique at the table level is sufficient then this will do, though it does tie your code down to MySQL. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() yep, as noted in another post, if it fits your development, then you can still use it; back on track : does and will mySQL support newid() -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...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: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RegEx Help!
Oliver, Try something like this: cfset yourNewString = ReReplaceNoCase(yourOldString, [^]*, , ALL) Thanks, André -Original Message- From: Oliver Cookson [mailto:[EMAIL PROTECTED] Sent: 14 March 2003 11:13 To: CF-Talk Subject: SOT: RegEx Help! Any ninja's out there? ;) Im having trouble with a regular expression i wonder if anyone could help? Im looking for this string (see bottom) and want to remove EVERYTHING except the word a string here. This string could be any length or any combo of chars\integers. Also the JS arg (14) is dynamic so that could be any number, everything else is static. A class=jargon href=javascript:popUpJargonDefinition(14)a string here/A Hope someone can help, mail me off list if preferred. Thanks Oliver ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query of Queries w/ subquery in CF 5?
Rob, Not sure if CF5 query of queries can handling your sub-selects. Anyway, try this as a possible alternative: Select * from Query1 where Q1MachineName not in (#QuotedValueList(Query2.Q2MachineName)#) UNION Select * from Query2 where Q2MachineName not in (#QuotedValueList(Query1.Q1MachineName)#) Thanks, André -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 14:37 To: CF-Talk Subject: Query of Queries w/ subquery in CF 5? I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Talking to a EJB
Michael, You're right, you'll need to import javax.rmi.PortableRemoteObject or perhaps cfobject one. This whole thing might be best written as a Servlet or JSP which you then include or forward to. Just a thought. André -Original Message- From: Michael Hoffman [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 16:24 To: CF-Talk Subject: RE: CF Talking to a EJB How would I do this line? PortableRemoteObject.narrow(o, TitleSessionEJBHome.class); the .class is what I am not sure how to do. Plus the constructor for PortableRemoteObject is protected. Original Message Follows From: webguy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF Talking to a EJB Date: Thu, 13 Mar 2003 15:44:39 - Received: from houseoffusion.com ([64.118.64.245]) by mc6-f27.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 13 Mar 2003 07:46:28 -0800 X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP Message-ID: [EMAIL PROTECTED] Precedence: bulk References: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 13 Mar 2003 15:46:29.0025 (UTC) FILETIME=[B6650910:01C2E977] You might need to create a instance or javax.rmi.PortableRemoteObject ?? WG -Original Message- From: Michael Hoffman [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 15:12 To: CF-Talk Subject: CF Talking to a EJB All the code that I have found for a CF page talking to a EJB it does not include the PortableRemoteObject.narrow call. Any ideas on this? Narrowing is used on remote interfaces and not local interfaces? Narrowing checks to ensure that an object of a remote or abstract interface type can be cast to a desired type. Does anyone have any narrowing code that works within a CF page? cfobject action =create type =java class =javax.naming.InitialContext name =ictx cfscript ictx.addToEnvironment(java.naming.provider.url, w2k069.sysadmin.suny.edu:2908); /cfscript cfset ejbHome =ictx.lookup(TitleSessionEJB) cfset bean =ejbHome.create() cfset myString =javaCast(String,bean.getTitle()) 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to access row in loop
Depending on the impact you might want to reimplement your cdjwebdoc.cdweb structure as a query using QueryNew etc. as long as each row has the same columns...this certainly seems to be what you are trying to achieve. Then you can use cfloop query=... as normal. A little easier to read and manage. ...but to answer your query...the currentrow variable isn't set when looping over a structure as far as I know. Thanks, André -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 17:22 To: CF-Talk Subject: How to access row in loop Here's my busted attempt to get certain items from a structure while looping through it...can someone tell me where I messed up? (structure is like this: cdjwebdoc.cdweb.1.sku cdjwebdoc.cdweb.1.unitcost cdjwebdoc.cdweb.2.sku and so on heres my busted attempt: cfloop collection=cdjwebdoc.cdweb !---Check for existence of SKU cfquery name=check datasource=#dsn# Select id from inventory where sku = '#trim(cdjwebdoc.cdweb.[currentrow].sku)#' /cfquery cfif check.recordcount EQ 1 !--- IF SO, Update--- cfquery name=updateinv datasource=#dsn# Update inventory set intcontent = '#cdjwebdoc.cdweb.[currentrow].internetdescription#', invtitle = '#cdjwebdoc.cdweb.[currentrow].invoicedescription#', sellprice = #cdjwebdoc.cdweb.[currentrow].internetsellfor#, sale = #cdjwebdoc.cdweb.[currentrow].sale#, item_cost = #cdjwebdoc.cdweb.[currentrow].unitcost#, inventory_minimum = #cdjwebdoc.cdweb.[currentrow].minimuminventory# Where sku = '#trim(cdjwebdoc.cdweb.[currentrow].sku)#' /cfquery How does a guy go about making that work?? Or am I in the wrong ballpark? Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Custom Tag Question
Try something LIKE this inside of your custom tag: cfset theQuery = caller.#attributes.queryname# cfoutput query=theQuery blah blah /cfoutput Thanks, André -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:29 To: CF-Talk Subject: Custom Tag Question I am creating a custom tag that will display the results of a query. I know there are already some out there, but I wanna do it myself. I have an attribute called queryname that i refer to in the call of the custom tag. cf_mytag queryname=get_users inside the custom tag i refer to it as attributes.queryname as in the following cfoutput query=#attributes.queryname# blah blah /cfoutput I keep getting the following error. Attribute validation error for tag cfoutput. The value of the attribute query, which is currently get_users, is invalid. The error occurred in C:\CFusionMX\CustomTags\tabledata.cfm: line 20 18 :th/thnbsp;/th 19 : /tr 20 :cfoutput query=#attributes.queryname# I have called the custom tag after the query. Does the custom tag still execute first? The custom tag appears before the query in debugging. If so what is a competent work around for this problem.? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: site wide error handling
A few additions: You don't really need the conditional logic around the cferror tag. It might be wise to also include a request error handler e.g. cferror type=request... Although you are restricted to the number of variables you can use in this template (and you can't log/mail etc.) it provides a fallback in case there happens to be an error in your exception handler defined by cferror type=exception... And thus you avoid being hosed. If you want to replace try/catch for queries then the most appropriate exception type to specify is database e.g. cferror type=exception exception=database Naturally, the most logical place to put these tags is in Application.cfm though, as with cfapplication etc., you are not restricted to doing so i.e. you can override the exception handler on any given page as necessary or appropriate. You also need to be aware that if an error or exception occurs before you have called cferror e.g. somewhere high up in Application.cfm then your error handlers won't run. This contribution is purely for my own benefit as I wanted something to type. André -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 March 2003 18:05 To: CF-Talk Subject: site wide error handling Instead of using the try/catch blocks around each query, use a site-wide error catcher that you set up in the Application.cfm file: cfif (#CGI.SCRIPT_NAME# NEQ /includes/errorhandler.cfm) cferror template=/includes/errorhandler.cfm type=exception exception=ANY /cfif The key is to use the type of exception and exception=any (I think this came in to either v4.51 or v5). So if an error is caught, the users is tossed to the errorhandler.cfm page, where you display a Sorry, error occured or whatever message and you set the following params: cfparam name=error.template default=unknown cfparam name=error.querystring default=unknown cfparam name=error.remoteaddress default=unknown cfparam name=error.HTTPreferer default/index.cfm cfparam name=error.diagnostics default=unknown You can use the error structure (error.[whatever]) to then send mail to an admin and/or dump into a database (I do both). Just make sure to CFPARAM everything that will be called, or you will get an error in the error-handler page and you'll be hosed. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New Macromedia.com launched!
Pity the top toolbar on the home page doesn't work how it's supposed to :) Other than that, looks great. I wouldn't like to load it over a modem though! -Original Message- From: Oliver Cookson [mailto:[EMAIL PROTECTED] Sent: 05 March 2003 09:45 To: CF-Talk Subject: New Macromedia.com launched! Maybe there has already been a post, if not there is now! :) The new Macromedia.com has been launched and its looks excellent (if a little slow in places). Well done MM. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent to the relevant approver. They view their e-mail and click on the link which opens up their admin screen. From here they can see they have content to approve. The approver reads through the story and if they are happy they approve the data and it is entered into the database and goes live on the site. If the approver declines the story it sends the user who created the content an e-mail with why the data was not approved and the changes needed to be made, and the story does not go live on the site. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is it possible to achieve workflow in Coldfusion ???
Ian, I see no flaws the logic you outlined; seems perfectly acceptable to me. As for adding more features and or more advanced settings, that is entirely dependent on whether they are justified, required or are likely to be required - something which only you are in a position to judge at present. If what you outlined is all that you need then I see no reason to expand. It is conceivable, as in other workflow systems, that you may in the future need more than one level of approval i.e. the article/story may go through a whole chain of people before it is finally ready to be published e.g. author - editor - creative/formatting - publisher etc. however, I don't know if that is appropriate for your circumstances but it might be worth bearing in mind. Hope you are successful in your endeavors. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:54 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Andre Thanks for the explanation!! Ok I understand how it is working - A user fills in the fields and clicks submit the data in entered into the db with a 'status' field set to a default of 'Pending' Ok Then when the form is submitted I use CFMail to send an e-mail to the approver informing them they have a story to approve. (Is this process correct ?) The approver clicks on the link in the e-mail and they are taken to the 'Pending Jobs' Screen. The approver opens the relevant pending job. At the bottom of this page there are two buttons 'Approve' and 'Decline' If the aprrover clicks approve the 'status' field changes to 'approve' However if the approver clicks decline then the 'status' field stays the same and an e-mail is sent back to the content owner informing them that the content has been declined. Does this make sense logically ?? Or would you add more features and or more advanced settings?? - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:24 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, Perhaps I can clarify/expand on what Adam suggested: 1) You do not stop the data entering the database when a story is submitted. Instead, it is inserted as normal but you also set another column probably in the same table, perhaps named status with a value of P for pending when you perform the insert e.g. insert into stories (story_id, foo, bar, status) values (666,'Foo','Bar','P') 2) Only display stories on the website if the status column is not P, perhaps only if the status column is A for approved e.g. select foo, bar from stories where status = 'A' 3) When the approver approves a story to be published, the appropriate row in the database gets updated and the status column is changed appropriately. e.g. update stories set status = 'A' where story_id = 666 You could extend this model quite simply to allow for multi-level approvals and multiple types of status. It's important to note that this is not a ColdFusion specific problem. It is merely a programming issue and there is more than one way to skin a cat. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:02 To: CF-Talk Subject: Re: Is it possible to achieve workflow in Coldfusion ??? Adam There is only one administrator or approver. How would you achieve this, do you have example code so I can see how it may function, how do you stop the data entering the database ?? As part of the submit page, have it save the document away with a flag 'pending'. - Original Message - From: Adam Reynolds [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:46 AM Subject: RE: Is it possible to achieve workflow in Coldfusion ??? Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'. Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 09:38 To: CF-Talk Subject: Is it possible to achieve workflow in Coldfusion ??? Hi I am trying to add a workflow element into a news application, and would just like to hear if anybody else on the list have been able to achieve this? or best practices on how to achieve this? I have an admin form that allows users to add news stories. At present when the form is submitted the data is entered into the database table. What I would like to achieve is when the user submits the form an e-mail is sent
RE: CFMX DSN woes
Pete, There is a patch floating around somewhere for CF's administrator which gives you more meaningful error messages when connecting to data sources other than the generic JDBC pool error. Search macromedia.com For SQL Server: 1) Make sure you are using Mixed Mode Authentication (not Windows only). 2) Make sure your password is not more than 16 chars. 3) Do not use (local) as the server. Hope this helps. Setting up a SQL data source should be a snap. Thanks, André -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password Everything else is default except I have Unicode enabled in the String Format checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
Bryan, Did you try the usual: 1) Make sure you're using mixed mode authentication on SQL server. 2) Make sure your passwords are not more than 16 chars. 3) Make sure you aren't using (local) as the server etc. Thanks, André PS Good luck with the dating web app! -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 17:59 To: CF-Talk Subject: CFMX Updater 2 to blame? Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting a recordset to XML
Taco, The original post pointed out that they were still using SQL Server 7.0 which I don't believe has the XML publishing features of SQL Server 2000 Thanks, André -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 08:56 To: CF-Talk Subject: Re: Converting a recordset to XML If you are using MS SQL you can convert the record set to XML with its XML publishing tools.. - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:50 AM Subject: RE: Converting a recordset to XML Brook, If you're going via CF, you could try using WDDX as long as wherever you are sending it to can understand it. You'd this via the cfwddx tags passing in a CF variable e.g. a recordset. If converting a recordset into XML the quickest and EASIEST way is your MAIN criteria then this is probably the way to go. If WDDX isn't what you want then there are a bunch of options, including using a Servlet filters to transform the WDDX XML into another XML format if need be but that requires some knowledge of XSLT etc. You could also just loop through the recordset and manually create the XML document in CF but this probably isn't recommended if the number of rows is large. Naturally, you could also do this inside of a stored procedure. Thanks, André -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 14:41 To: CF-Talk Subject: Converting a recordset to XML Hello, I'm trying to figure out what is the best way to convert a recordset in CFMX to XML. We're still using SQL 7.0, so we can not use the native XML features of SQL Server 2000. Would it make sense to select the data like this: Select 'title' + title + ',/title as title from movies Or is there a better way convert a record set to XML quickly? Are there any plugins for SQL Server. Brook Davies logiforms.com ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dsn on cfmx - can't create
Rich, A couple of things that might help: 1) Make sure you are using Mixed Mode authentication (not Windows only) on your SQL server DBMS. 2) Make sure your password is not more than 16 chars otherwise it gets truncated by the CF Administrator App! 3) There is a patch for the CF Administrator (can't find it just now) which produces more accurate error messages when you are unable to verify data sources...without the patch you get a generic JDBC Pool Exception which although correct in some cases is not in others and can be misleading. You'll have to locate this patch yourself because I'm supposed to be working right now! (also, not sure if its included in the updaters) Thanks, André -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:27 To: CF-Talk Subject: dsn on cfmx - can't create I've checked the archive on this + the forums + the technotes, but haven't been able to resolve it. We cannot add a DSN to a SQL Server 2000 database through CFMX. we have 2 cfmx machines and 3 sql server machines. 2 of these machines are sql server 2000, and 1 is SQL 7. Each cfmx machine is win2000 with sp3 installed (mdac 2.7 etc). each install of cfmx is patched to updater 2. We can't add a DSN either via the type 4 drivers (SQL server) or via an ODBC socket to a DSN setup successfully to connect to the a database on a sql2000 machine. We *can* add type 4 and type 3 DSNs that connect to any SQL server 7 machine. Oddly, we also have some CF5 machines that can connect to the sql 2000 databases using exactly the same details that were used for the cfmx machines' DSNs. All machines have the same firewall configuration. We also tried adding the ODBC Server service in CFMX to a new security account in win2000, but this hasn't worked either. We've now run out of options. Can anyone help? Many thanks, --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting a recordset to XML
Brook, If you're going via CF, you could try using WDDX as long as wherever you are sending it to can understand it. You'd this via the cfwddx tags passing in a CF variable e.g. a recordset. If converting a recordset into XML the quickest and EASIEST way is your MAIN criteria then this is probably the way to go. If WDDX isn't what you want then there are a bunch of options, including using a Servlet filters to transform the WDDX XML into another XML format if need be but that requires some knowledge of XSLT etc. You could also just loop through the recordset and manually create the XML document in CF but this probably isn't recommended if the number of rows is large. Naturally, you could also do this inside of a stored procedure. Thanks, André -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 14:41 To: CF-Talk Subject: Converting a recordset to XML Hello, I'm trying to figure out what is the best way to convert a recordset in CFMX to XML. We're still using SQL 7.0, so we can not use the native XML features of SQL Server 2000. Would it make sense to select the data like this: Select 'title' + title + ',/title as title from movies Or is there a better way convert a record set to XML quickly? Are there any plugins for SQL Server. Brook Davies logiforms.com ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Correct Syntax for this piece of SQL ??
Just a stab in the dark: Is orgname always uppercase in your DB? If so, that might explain why searching by orgname always works but searching by the others doesn't. You might have to do this: ...AND UPPER(funding) LIKE UPPER('%#Form.funding#%') or EVEN (the same): ...AND UPPER(funding) LIKE '%#UCase(Form.funding)#%' etc. Thanks, André -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 14:49 To: CF-Talk Subject: Correct Syntax for this piece of SQL ?? Hi I have the following form which is being used to search against my database table. When I search using the 'orgname' field and there are matches then results are returned. However if I search in the other two fields then it displays no results found when it should bring back results ? Is this because of my sql ?? CFQUERY datasource=liv8 name=funding cachedwithin=#CreateTimeSpan(0,6,0,0)# blockfactor=100 select * from funding Where orgname LIKE UPPER('%#Form.orgname#%') AND funding LIKE UPPER('%#Form.funding#%') AND commapproval LIKE UPPER('%#Form.commapproval#%') ORDER BY recordid /CFQUERY This is my search form form method=POST action=/testpages/fundingresults.cfm name=search input type=Hidden name=MaxRows value=100 input type=hidden name=StartRow value=1 font color=#00 face=Verdanaspan class=black10 p input type=text class=mini name=orgname size=22 style=WIDTH: 200pxb Organization Name/b /p input type=text class=mini name=funding size=22 style=WIDTH: 200pxbSource of Funding/b p input type=text class=mini name=commapproval size=22 style=WIDTH: 200pxbCommittee Approval Date/b /p p input type=submit value=Search name=B1nbsp;nbsp; input type=reset value=Reset Form name=B2 p /form ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anti-cfflush
You probably want to refer to the JSP specs here: http://java.sun.com/products/jsp/download.html#specs to get the best understanding of full capabilities of the Page Context object. Thanks, André -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 24 February 2003 15:26 To: CF-Talk Subject: Re: anti-cfflush cfset GetPageContext().getOut().clearBuffer() i suppose i should know this but what else is hungoff of getPageContext()? its kind of lacking in terms of docs. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anti-cfflush
More specifically, see here: http://java.sun.com/j2ee/sdk_1.3/techdocs/api/javax/servlet/jsp/PageCont ext.html Thanks, André -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 24 February 2003 15:26 To: CF-Talk Subject: Re: anti-cfflush cfset GetPageContext().getOut().clearBuffer() i suppose i should know this but what else is hungoff of getPageContext()? its kind of lacking in terms of docs. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FBX3 AND CFMX
One small note with FBX3 and CFMX - just need to make sure that in your index.cfm you include the CF5 core file (even though you are running on CFMX) e.g. cfinclude template=fbx_fusebox30_CF50.cfm Everything else works same as on 5. As for performance, no issues have arisen so far - debugging execution times can be a little tricky as MX tends to accumulate execution times into the core file rather than the separate includes and custom tags that make up the page on some occasions. André -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:37 To: CF-Talk Subject: RE: FBX3 AND CFMX Yes. You deliver code in half the time, can hand it on easily to people, working out how to do updates is simpler and can estimate more precisely so you can come in under budget. :) As to performance issues. Not really had any that I am aware of. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:31 To: CF-Talk Subject: RE: FBX3 AND CFMX Any performance issues? Kola -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:16 To: CF-Talk Subject: RE: FBX3 AND CFMX WhHo!! Right, lets Migrate this baby. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:19 To: CF-Talk Subject: RE: FBX3 AND CFMX No problems. Running smoothly. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 10:44 To: CF-Talk Subject: FBX3 AND CFMX Hi, just wondering, is there any issues with FBX3 and MX, our will it run fine as it does under 5.0, I know this is a topica question really, but I'm having problems sending to the list, I am recieving though, strange. Respectfully, J ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Should be easy :)
Specify ONE as your scope. e.g. cfset temp = Replace(temp,.,,ONE) The CF docs are quite comprehensive on tag use. André -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 12:21 To: CF-Talk Subject: Re: Should be easy :) Will that not replace ALL periods ? I just want the first... On 20/2/03 12:17, Simon Whittaker [EMAIL PROTECTED] wrote: say that temp is your variable cfset temp = Replace(temp,.,) Cheers Simon - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:14 PM Subject: Should be easy :) This should be an easy one. How do I remove the first fullstop/period in a string ? TIA Ryan ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Should be easy :)
Btw...ONE is the default scope for replace! André -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 12:21 To: CF-Talk Subject: Re: Should be easy :) Will that not replace ALL periods ? I just want the first... On 20/2/03 12:17, Simon Whittaker [EMAIL PROTECTED] wrote: say that temp is your variable cfset temp = Replace(temp,.,) Cheers Simon - Original Message - From: Ryan Mitchell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:14 PM Subject: Should be easy :) This should be an easy one. How do I remove the first fullstop/period in a string ? TIA Ryan ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: astrological sign
Luck for me I am a dragonno really :) André -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 16:26 To: CF-Talk Subject: Re: astrological sign the placemats at the chinese restaurants arent always correct u know! haha sure...we all wanna be the dragon:) i think im a pig Dave - Original Message - From: Ben Arledge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 10:49 AM Subject: RE: astrological sign Doesn't the Chinese New Year start in late January or early February depending on the year? :) I think this script would make me a Snake whereas I'm really a Dragon. Cheers, Ben -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: February 20, 2003 12:12 AM To: CF-Talk Subject: Re: astrological sign cfscript /** * Returns the Chinese Zodiac animal corresponding to the given year of birth. * * @param Year (in the format ) you want the Chinese Zodiac animal for. * @return Returns a string. * @author Sierra Bufe ([EMAIL PROTECTED]) * @version 1, December 3, 2001 */ function ChineseZodiac() { var Animals = ListToArray(Monkey,Chicken,Dog,Pig,Mouse,Ox,Tiger,Rabbit,Dragon,Snake,H orse ,Sheep); return Animals[( MOD 12) + 1]; } /cfscript Dave - Original Message - From: Benjamin Rosenthal [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 10:47 PM Subject: astrological sign Took a look at CFLIB but didn't see anything there. I'm not what you would call a believer so I mistakenly assumed it HAD to be more complicated than date alone. Go figure -- who knew figuring out one's personality could be so simple? ;) Here are the date ranges if someone wants to go to town. Yes, I'd be happy if anyone wants to post their UDF. (Michael T., tried to contact you but could't see your email anywhere.) Aries March 21-April 19 Taurus April 20-May 20 Gemini May 21-June 21 Cancer June 22-July 22 Leo July 23-August 22 Virgo August 23-September 22 Libra September 23-October 22 Scorpio October 23 - November 21 Sagittarius November 22-December 21 Capricorn December 22-January 19 Aquarius January 20-February 18 Pisces February 19-March 20 ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFTransaction and looping through multiple inserts
Thane, No need to have a separate CommitWrite variable. Just do this: cftransaction!--- Begin is implied --- cftry cfloop ...DB Inserts here... /cfloop cfcatch type=Database cftransaction action=rollback/ /cfcatch /cftry /cftransaction!--- Commit is implied --- Provided you want all inserts to be performed or none at all...otherwise you need to adjust where the loop is etc. André -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 14:43 To: CF-Talk Subject: CFTransaction and looping through multiple inserts I'm entering a series of answers into a table, so I have a loop like this: cfloop index=QuestionID list=#Form.SurveyQuestionIDList# !--- Get the answer. --- CFSET NumericAnswer=Form[AnswerQuestionID] !--- Run the query. --- cfquery datasource=#Datasource# name=InsertSurveyAnswers INSERT INTO SurveyAnswers(QuestionID, SurveySubjectID, NumericAnswer, SurveyDate) VALUES (#QuestionID#, #Form.SubjectID#, #NumericAnswer#,#Form.DateSurveyEntered#) /cfquery /CFLOOP If I want to use CFTransaction, would I set it up like this? CFSET CommitWrite=True cftransaction action=begin cftry cfloop index=QuestionID list=#Form.SurveyQuestionIDList# !--- Get the answer. --- CFSET NumericAnswer=Form[AnswerQuestionID] !--- Run the query. --- cfquery datasource=#Datasource# name=InsertSurveyAnswers INSERT INTO SurveyAnswers(QuestionID, SurveySubjectID,NumericAnswer, SurveyDate) VALUES (#QuestionID#, #Form.SubjectID#, #NumericAnswer#,#Form.DateSurveyEntered#) /cfquery /CFLOOP cfcatch type='database' cfset CommitWrite=FALSE /cfcatch /cftry cfif CommitWrite is 'TRUE' cftransaction action='Commit' cfelse cftransaction action='Rollback' /cfif /cftransaction Or like this? CFSET CommitWrite=True cftransaction action=begin cfloop index=QuestionID list=#Form.SurveyQuestionIDList# !--- Get the answer. --- CFSET NumericAnswer=Form[AnswerQuestionID] !--- Run the query. --- cftry cfquery datasource=#Datasource# name=InsertSurveyAnswers INSERT INTO SurveyAnswers(QuestionID, SurveySubjectID,NumericAnswer, SurveyDate) VALUES (#QuestionID#, #Form.SubjectID#, #NumericAnswer#,#Form.DateSurveyEntered#) /cfquery cfcatch type='database' cfset CommitWrite=FALSE /cfcatch /cftry /CFLOOP cfif CommitWrite is 'TRUE' cftransaction action='Commit' cfelse cftransaction action='Rollback' /cfif /cftransaction Or can CFTransaction be used in this situation? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFTransaction and looping through multiple inserts
Doh! That's true! Only need to explicitly rollback for example if there is something else inside of the transaction tags that is NOT a db query and hence won't necessarily exit the transaction automatically e.g. cftransaction ...DB Queries cf_chargecreditcard cfif chargeError cftransaction action=rollback/ /cfif /cftransaction ...but...this was not what the original question was so I'll shut up now! André -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 16:00 To: CF-Talk Subject: RE: CFTransaction and looping through multiple inserts No need to have a separate CommitWrite variable. Just do this: cftransaction!--- Begin is implied --- cftry cfloop ...DB Inserts here... /cfloop cfcatch type=Database cftransaction action=rollback/ /cfcatch /cftry /cftransaction!--- Commit is implied --- Provided you want all inserts to be performed or none at all...otherwise you need to adjust where the loop is etc. There's no need to have a CFTRY/CFCATCH just to rollback, either - if any query fails, the entire transaction will rollback automatically. You only need to use ACTION=COMMIT or ACTION=ROLLBACK within a CFTRANSACTION tag if you want a partial commit or rollback. cftransaction isolation=a_level_that_will_be_safe_for_your_transaction cfloop ... DB inserts here ... /cfloop /cftransaction 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Set HTTP Headers
Jeff, You could also do a CFHTTP call to the page you are setting the headers on. Then cfdump cfhttp.header for the raw response header you get back from your page or cfdump cfhttp.responseHeader (which is a Structure) or use cfhttp.responseHeader[testVar] to see if you get testVarValue as expected etc. André -Original Message- From: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 16:31 To: CF-Talk Subject: RE: Set HTTP Headers Hi Jeff, I am working on a project where I need to create a new HTTP Header variable. I thought this was what the cfheader tag was for, but I am not being able to make it work. What am I missing here? cfheader name=testVar value=testVarValue -- A header is something you send to the client in the response stream. So doing getHTTPRequestDate() like you do below is getting the request stream (what the client is sending to you). If you want to see the headers you're sending back to the client, there are a couple tools that plug into IE that let you see that kinda thing, or, if you want to get really geeky, break out Network Monitor in Windows 2000 and view the TCP/IP packets and filter for HTTP data. AJ Aaron Johnson [EMAIL PROTECTED] http://cephas.net/blog/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Set HTTP Headers
Jeff, Are you trying to read request headers i.e. those set by the browser when requesting one of your pages, or are you trying to read response headers set by another server e.g. when you request a resource/page programmatically via cfhttp? André -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 16:42 To: CF-Talk Subject: RE: Set HTTP Headers Okay, that makes since. Now let me explain the problem better. I am building some functionality to read a set of header variables and do some processing on them. As a test, I was trying to insert certain values into the header and then call my functions to make sure they work correctly. So basically you are saying that I need to set the header variables and then somehow call or go to another page that runs the function in question? Thanks -- Jeff -Original Message- From: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:31 AM To: CF-Talk Subject: RE: Set HTTP Headers Hi Jeff, I am working on a project where I need to create a new HTTP Header variable. I thought this was what the cfheader tag was for, but I am not being able to make it work. What am I missing here? cfheader name=testVar value=testVarValue -- A header is something you send to the client in the response stream. So doing getHTTPRequestDate() like you do below is getting the request stream (what the client is sending to you). If you want to see the headers you're sending back to the client, there are a couple tools that plug into IE that let you see that kinda thing, or, if you want to get really geeky, break out Network Monitor in Windows 2000 and view the TCP/IP packets and filter for HTTP data. AJ Aaron Johnson [EMAIL PROTECTED] http://cephas.net/blog/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Set HTTP Headers
Jeff, If you want to pass in some test data you need some kind of custom browser or HTTP client that lets you set some headers when making requests to your page. There are a few of these around, or you could write a simple Java/VB app to do it. Alternatively, a load testing tool (probably overkill) e.g. MS WAS lets you set some headers. André -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 16:50 To: CF-Talk Subject: RE: Set HTTP Headers The headers that are sent by the browser are all that I am interested in at this point. I am just trying to figure out how to pass in some test data. Thanks -- Jeff -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:47 AM To: CF-Talk Subject: RE: Set HTTP Headers Jeff, You might want to try a tool like HTTP Analyzer (www.coolfusion.com) It will easily let you see what you are sending down to the browser. getHTTPRequestData() will only show you what the browser sends you when it makes its request. Matt -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:27 AM To: CF-Talk Subject: Set HTTP Headers I am working on a project where I need to create a new HTTP Header variable. I thought this was what the cfheader tag was for, but I am not being able to make it work. What am I missing here? cfheader name=testVar value=testVarValue When I do cfset x = getHTTPRequestData() cfdump var=#x# ... I do not see the testVar header. 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Set HTTP Headers
Jeff, It may well be that PlumTree is manipulating the headers before calling third party pages but that doesn't necessarily mean it is doing it via CF code. You can do v.limited header manipulation using CFHTTP...well, you can set the user-agent header, and you can set some cookies but other than that I'm not aware of another way using purely CF. It is not that difficult to write a CFX or JSP Custom Tag...or indeed access java.net.URL class to open a connection to port 80 or whatever and then manually/programmatically create an HTTP request (including the desired headers) to another resource...well, its not that difficult if you know some Java, but may be you don't! As other people have suggested, a quick and dirty way of testing is to use Telnet and manually create the requests- headers included. How much work do you want to do? André -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 17:43 To: CF-Talk Subject: RE: Set HTTP Headers Okay, let me clear this up then, because setting http header variables can be done. I have an instance of a PlumTree portal sitting on a set of production servers. I am trying to put together another application that PlumTree can be nice and talk to. Now, PlumTree passes information from the portal itself to third party applications via the http header. So somehow the PlumTree portal is manipulating the http header before it calls my function. The http header when I receive it (i.e. I can dump the header variables and see the values) includes things like ... CSP-CAN-SET = 'Gadget,User' CSP-GATEWAY-TYPE = 'PlumTree' CSP-PROTOCOL-VERSION = '1.1' My function can then, through the use of getHttpRequestData, see/read/use these header values. I am attempting to test my function on a development box - separate from the PlumTree system - and was trying to figure out how to set these variables before calling my function - i.e. make it look like PlumTree is doing the calling. Hopefully this is more clear. Thanks -- Jeff -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:23 AM To: CF-Talk Subject: Re: Set HTTP Headers Jeff Chastain wrote: The headers that are sent by the browser are all that I am interested in at this point. I am just trying to figure out how to pass in some test data. You need a custom browser for that. Telnet is a nice one ;-) The reason for this is quite simple actually. Suppose that just any website could tell any browser from now on you will send this header, with 'this' being a unique identification. Sounds like something the EFF and the /. crowd would go rather nuts about, wouldn't they? 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: changing mx serial number from developer to professional
Craig, Not sure if the license file is in the same location/format on nix versions of CF but on Win versions the license file is located here: installation_root\lib\license.properties e.g. C:\CFusionMX\lib\license.properties You might like to try doing a find for this file when you SSH providing you have permissions for the relevant directory etc. André -Original Message- From: Craig Zingerline [mailto:[EMAIL PROTECTED]] Sent: 17 February 2003 19:00 To: CF-Talk Subject: RE: changing mx serial number from developer to professional Matt, thanks for the reply. The problem is that my box is at a co-location provider so I don't have direct access to the box other than through SSH. Any ideas? Thanks! Craig UP:Thought -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 7:28 AM To: CF-Talk Subject: RE: changing mx serial number from developer to professional Craig: I believe the developer version will allow connections from the local box and one additional IP. Not sure how you are connected to the server, but are you able to open a browser on it? If so, you should be able to get into the cfadmin from there without worrying about the IP restrictions. Matt -Original Message- From: Craig Zingerline [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 1:04 PM To: CF-Talk Subject: changing mx serial number from developer to professional Hello, I have a dedicated Linux box and I installed Coldfusion MX a month ago on it and was using as the 1 IP development version. Since then I bought MX Professional and I want to update my serial number so I have unlimited users. However, I cannot log into the administrator because my IP is not the IP that is allowed by ColdFusion on my server. Someone else must have been on the site when the 30 day trial timed out, and their IP is locked in. I've tried shutting down and restarting ColdFusion to no avail. Does anyone know how to change the serial number through SSH, or without having to be in the CF administrator?? Help would be greatly appreciated! Thanks, Craig Up:Thought ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4