RE: Oracle RAW(50) - string conversion
About 10 mins later I figured this out with isBinary and BinaryEncode(blah, Hex), in case anyone comes across the same issue. -Original Message- From: Matt Barfoot [mailto:[EMAIL PROTECTED] Sent: 26 November 2007 23:27 To: CF-Talk Subject: Oracle RAW(50) - string conversion When I cfquery a Oracle database row with a RAW column in it, it is returned as a ByteArray. If I view the column in a SQLNet client like Toad you see a string, probably hex I'm guessing. I'm wondering how I correctly detect it and convert it to a string afterwards? I want to avoid doing it within the select statement with cast or convert, because I'm generating dynamic select * from mytable statements and the code doesn't know it will end up with a raw (ByteArray). Any ideas? Thanks, Matt ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How good is cfreport?
On Nov 26, 2007 2:28 PM, Billy Cox [EMAIL PROTECTED] wrote: Does anyone have experience with outputting Crystal Reports using ColdFusion? We have a number of existing Crystal Reports that I would like to leverage if possible. I am also making a purchase decision between Blue Dragon Server JX and CF Server 8.0, so I want to know whether CF Server (cfreport tag) is worth the extra bucks. You should be able to do pretty much anything that Crystal Reports supports with the built-in cfreport and the (free) Report Builder. Talk to Dean Harmon at Adobe if you have specific questions (since he wrote most of the reporting subsystem). -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating to Eclipse 3.3...
On Monday 26 Nov 2007, Dave Watts wrote: from 3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I don't know how to preserve or import settings. File, Export, General, Settings. -- Tom Chiverton Helping to heterogeneously brand next-generation e-business on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex 2 books for CF/AS3
On Friday 23 Nov 2007, j s wrote: Can anyone recommend some titles on Flex 2 with focus on CF and AS3. Given the 'real soon' release of Flex 3, you might want one that does that. -- Tom Chiverton Helping to globally harness sexy systems on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 and CFmail, sending duplicate emails
Hi, We recently upgraded our server to CF8. We have a number of clients who use emailing tools to send out emails to opt in lists. One of these clients did a mailout last week to a couple of lists, and it would appear that the emails all went at least twice to every member of the list. The code has run perfectly on CF7 for a couple of years, so I'm pretty sure it's not a code issue. I've tried replicating this issue, and I haven't been able to. Does anyone know of anything that might cause this to happen. The lists are not that large - the largest has about 3,500 email addresses, the smallest about 300. Did CF8 change the way it handles CFMAIL? Thanks Will ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT:Flex image manipulator
On Monday 26 Nov 2007, Andy Matthews wrote: Have any of you seen some sort of image manipulator for Flex? I'm just looking for really basic stuff like scaling and rotating (then saving). Should be possible, rotate/scale is built into Image, and I think you can snapshot any Flex component. -- Tom Chiverton Helping to carefully generate strategic relationships on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: image effects
I forgot to mention the entertainment value of the family feud between you, Dave1, and Will. :o) Rick -Original Message- From: Dave l [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 1:46 AM To: CF-Talk Subject: Re: image effects I come here just to pick on Will ;)~ I'm surprised. This is such a valuable list, especially for those of us not so advanced, but I would assume that even advanced programmers would get good ideas, too. Rick What other major lists are there? None that I'm aware of. I'm fairly certain that most CF programmers don't subscribe to any CF list. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 and CFmail, sending duplicate emails
A related question - Is this a good place to use the new CFTHREAD tag? Strikes me that it probably is. Would you put it inside the loop and create a new thread for each email sent, or create one new thread separate to the page thread to handle all the emails. I've not used this tag before and am trying to get my head around it. Cheers Will -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: 27 November 2007 11:40 To: CF-Talk Subject: CF8 and CFmail, sending duplicate emails Hi, We recently upgraded our server to CF8. We have a number of clients who use emailing tools to send out emails to opt in lists. One of these clients did a mailout last week to a couple of lists, and it would appear that the emails all went at least twice to every member of the list. The code has run perfectly on CF7 for a couple of years, so I'm pretty sure it's not a code issue. I've tried replicating this issue, and I haven't been able to. Does anyone know of anything that might cause this to happen. The lists are not that large - the largest has about 3,500 email addresses, the smallest about 300. Did CF8 change the way it handles CFMAIL? Thanks Will ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE error:formfield File does not contain a file
Here's the solution: Use cffile action=upload destination=#dir# filefield=FORM.file1 nameconflict=makeunique NOT cffile action=upload destination=#dir# filefield=FORM['file1'] nameconflict=makeunique For some reason CF doesn't see an uploaded file if u use the string notation FORM['file1'] to reference the file upload field instead of dot notation FORM.file1 This occurred on CFMX 8 (and Apache 2.0.59, WinXP SP2 fwiw0) Marc ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fixed!
Here's the solution: Use cffile action=upload destination=#dir# filefield=FORM.file1 nameconflict=makeunique NOT cffile action=upload destination=#dir# filefield=FORM['file1'] nameconflict=makeunique For some reason CF doesn't see an uploaded file if u use the string notation FORM['file1'] to reference the file upload field instead of dot notation FORM.file1 This occurred on CFMX 8 (and Apache 2.0.59, WinXP SP2 fwiw) Marc ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 7 MX - Oracle Stored Proc Calls
On Monday 26 Nov 2007, Mike Garner wrote: we are seeing that ColdFusion is issuing the stored proc call twice for a single transaction and have verified it is not due to multiple clicks How ? Just curious if there are any known threading issues with CF and Oracle stored proc calls in Oracle that anyone has come across. We are using the Could it be as simple as an un-var'ed method-local variable in a CFC ? -- Tom Chiverton Helping to confidentially repurpose leading-edge synergies on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 and CFmail, sending duplicate emails
Will, We recently upgraded our server to CF8. We have a number of clients who use emailing tools to send out emails to opt in lists. One of these clients did a mailout last week to a couple of lists, and it would appear that the emails all went at least twice to every member of the list. The code has run perfectly on CF7 for a couple of years, so I'm pretty sure it's not a code issue. I wouldn't be so quick to dismiss a code problem. I've seen a lot of code in my time that once worked that stopped working on an upgrade. It could be the use of a depreciated function or tag, or simply code that worked due to issues in the CF engine at the time--but which shouldn't have run. Also, I believe I remember reading CF8 changed some behavior of nested cfoutput/cfloop tags in CF8, but I can't recall exactly what I read. Finally, I will say don't overlook the obvious. If a user clicks on a link/button multiple times, unless your script explicitly prevents the behavior, the server will process the request multiple times. This is the most common cause of duplicates that I've seen. -Dan ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating to Eclipse 3.3...
from 3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I don't know how to preserve or import settings. File, Export, General, Settings. My personal experience is it's just easier to rebuild. I've tried the export settings, but it's caused me problems in the past. I think the problem stems from the fact that so many plug-ins are completely re-written for different versions of Eclipse. The good news is you should be able to go to File Import Existing Projects into Workspace and it should import your project into your new build (although things like the local history won't be imported.) From there it's just a matter of installing the plug-ins you want. Maybe it's because I only use a handful of plug-ins (CFEclipse, Aptana, FileSync, Flex and the various Adobe Eclipse plug-ins,) but it usually only takes me 30 minutes or so to get all my plug-ins restored. Also, I definitely think v3.3 is worth upgrading to. Performance for me has been much, much better. -Dan ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Updating to Eclipse 3.3...
-Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 8:50 AM To: CF-Talk Subject: RE: Updating to Eclipse 3.3... from 3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I don't know how to preserve or import settings. File, Export, General, Settings. My personal experience is it's just easier to rebuild. I've tried the export settings, but it's caused me problems in the past. Yeah... Export Settings does indeed export settings. A few of them. Maybe. ;^) I think the problem stems from the fact that so many plug-ins are completely re-written for different versions of Eclipse. And so many plugins maintain their own settings and configuration information. Also, I definitely think v3.3 is worth upgrading to. Performance for me has been much, much better. I agree... but Eclipse really needs to consolidate and streamline the upgrade process. It's ridiculous to do this for every point release. Jim Davis ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How good is cfreport?
You should be able to do pretty much anything that Crystal Reports supports with the built-in cfreport and the (free) Report Builder. Talk to Dean Harmon at Adobe if you have specific questions (since he wrote most of the reporting subsystem). Sorry, but I'm not convinced of this. I've written some pretty complex Crystal Reports way back when, and after working with the Report Builder for a year +, can say that it isn't quite there yet. Good tool, no doubt, but still buggy, and doesn't support some things that I could use. (How about being able to pass in multiple queries to the report.) The IDE is very mouse-unfriendly, and I've seen instances of objects getting stuck in invisible places (how does an object get set to a negative y axis inside of a section?). Granted, I'm not on CF8 yet either (we're on 7.02) -- hopefully there's been huge progress made since? Cheers, Kris ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 and CFmail, sending duplicate emails
Thanks for the reply Dan, I take your point on the code. It's just that the actual code is really rather simple: cfset unsent_list = cfinvoke component=#request.cfc_root#mailing method=getListEmails returnvariable=qry_getListEmails cfinvokeargument name=listID value=#Form.mailing_list# /cfinvoke cfloop query=qry_getListEmails cfset trimmed_email = Trim(email_address) cfif IsEmail(#trimmed_email#) IS 'yes' Send the email cfelse Log that the email address was not valid and don't send email /cfif The query is returning the expected data - I've tried dumping it and I can see that email addresses aren't duplicated. I've tried duplicating the problem and have so far been unable to. I'm going to try with a large list of safe email addresses shortly. Normally, I'd agree that this is probably down to the user clicking submit more than once, but this particular client is very reliable. However, I will look at implementing something that prevents this from happening - I'm think CFTHREAD is perfect here. Anyone have any thoughts on this? Cheers Will ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating to Eclipse 3.3...
Crow... What settings are you talking about? Is there a single file, or a folder? Do I have to reinstall all my plugins as well? andy -Original Message- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 4:25 PM To: CF-Talk Subject: Re: Updating to Eclipse 3.3... No need to uninstall at alljust install 3.3 to a new folder and copy your setting over. That way you have the best of both worlds - both installs are there for you if you need one or the other. On Nov 26, 2007 3:09 PM, Andy Matthews [EMAIL PROTECTED] wrote: I currently use 3.2.2 and I'd like to upgrade to 3.3 so that I can start using the CF 8 debugger. But when I go to Help Software Updates Find Instal Current installs (or new features), I only see updates to the 3.2 branch. Is it possible to upgrade to 3.3 without uninstalling my current build? If it's not, how can I back up my files so that I don't lose my preferences and settings? I'd rather not even bother upgrading if it might lose my settings. Thanks in advance. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How good is cfreport?
Not positive on this, but I believe the multiple query thing was handled with CF 8... Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Kris Jones wrote: You should be able to do pretty much anything that Crystal Reports supports with the built-in cfreport and the (free) Report Builder. Talk to Dean Harmon at Adobe if you have specific questions (since he wrote most of the reporting subsystem). Sorry, but I'm not convinced of this. I've written some pretty complex Crystal Reports way back when, and after working with the Report Builder for a year +, can say that it isn't quite there yet. Good tool, no doubt, but still buggy, and doesn't support some things that I could use. (How about being able to pass in multiple queries to the report.) The IDE is very mouse-unfriendly, and I've seen instances of objects getting stuck in invisible places (how does an object get set to a negative y axis inside of a section?). Granted, I'm not on CF8 yet either (we're on 7.02) -- hopefully there's been huge progress made since? Cheers, Kris ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Consuming a .Net Control
Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating to Eclipse 3.3...
Andy, What settings are you talking about? Is there a single file, or a folder? Do I have to reinstall all my plugins as well? I'd recommend just extracting Eclipse v3.3 into a new folder and then re-installing the plug-ins (as I stated in another thread.) I think in the long run it'll make life for you smoother. Re-installing the plug-ins shouldn't take long. -Dan ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updating to Eclipse 3.3...
On Tuesday 27 Nov 2007, Jim Davis wrote: I agree... but Eclipse really needs to consolidate and streamline the upgrade process. It's ridiculous to do this for every point release. I *believe* that it's on the roadmap somewhere to support upgrading Eclipse itself, not just plugins, via the current update mechanism. -- Tom Chiverton Helping to dynamically target frictionless products on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating to Eclipse 3.3...
Yea, Dan beat me to it, but that is what I meant in my post. I've never had luck, like others who have responded, with exporting settings or plugins. easier to just install a clean new install in another folder. On Nov 27, 2007 9:26 AM, Dan G. Switzer, II [EMAIL PROTECTED] wrote: Andy, What settings are you talking about? Is there a single file, or a folder? Do I have to reinstall all my plugins as well? I'd recommend just extracting Eclipse v3.3 into a new folder and then re-installing the plug-ins (as I stated in another thread.) I think in the long run it'll make life for you smoother. Re-installing the plug-ins shouldn't take long. -Dan ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Consuming a .Net Control
You should be able to with CF8. Call it as a cfobject -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 10:34 AM To: CF-Talk Subject: Coldfusion Consuming a .Net Control Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: error caused by cfqueryparam inside cfif
Get rid of the * in the SELECT * Ben, That did the trick. Thank you! Nicholas Vacek Vivid Image - Programmer 320-587-8974 ext. 111 [EMAIL PROTECTED] http://www.vimm.com Ben Nadel wrote: Get rid of the * in the SELECT *. Using CFQueryParam causes the structure to be cached. Then, if the underlying DB changes, the structure no longer applies, but since CF sees it as the same thing, weirdness ensues. In general get rid of all SELECT *'s in your code. They are evil and cause headaches like this. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 and CFmail, sending duplicate emails
On Tuesday 27 Nov 2007, Will Swain wrote: will look at implementing something that prevents this from happening - I'm think CFTHREAD is perfect here. Anyone have any thoughts on this? Yes, CFTHREAD the sending assuming the mail server can handle it. A simple thing to do for the button is use javascript to disable it onClick. 'course, if javascript is disabled there isn't much you can do except embed a one-time token in the form, and invalidate the token the first time it is used. -- Tom Chiverton Helping to enthusiastically participate market-driven communities on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Updating to Eclipse 3.3...
Yea, Dan beat me to it, but that is what I meant in my post. I've never had luck, like others who have responded, with exporting settings or plugins. easier to just install a clean new install in another folder. Just to further elaborate. The last time I tried to migrate my installation to a new build of Eclipse (I think it was from 3.1 (or maybe 3.0) to 3.2) I spent over 2 hours trying to get things working without errors. I finally gave up and just did a fresh install. It only took me about 40 minutes to get a fresh new install with all new plug-ins configured. Maybe a fresh install isn't going to be required, but you do get the benefit of purging all the old obsolete plug-ins and old versions from Eclipse. You'll probably notice that Eclipse boots a lot faster too. -Dan ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How good is cfreport?
I've been using Crystal Reports viewed via the web for sometime. As I am using an IIS server I've been using asp pages and it works great. I am using a program called recrystallize (www.recrystallize.com) which is a wizard that processes your rpt file and you need to provide the database connection information, parameters and how you want the report to be displayed. Once the process is completed it generates the ASP pages which you place on your web server. I've been using it for years and it's a great tool. Jim Pennington On Nov 27, 2007 10:17 AM, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Not positive on this, but I believe the multiple query thing was handled with CF 8... Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Kris Jones wrote: You should be able to do pretty much anything that Crystal Reports supports with the built-in cfreport and the (free) Report Builder. Talk to Dean Harmon at Adobe if you have specific questions (since he wrote most of the reporting subsystem). Sorry, but I'm not convinced of this. I've written some pretty complex Crystal Reports way back when, and after working with the Report Builder for a year +, can say that it isn't quite there yet. Good tool, no doubt, but still buggy, and doesn't support some things that I could use. (How about being able to pass in multiple queries to the report.) The IDE is very mouse-unfriendly, and I've seen instances of objects getting stuck in invisible places (how does an object get set to a negative y axis inside of a section?). Granted, I'm not on CF8 yet either (we're on 7.02) -- hopefully there's been huge progress made since? Cheers, Kris ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RDS with Eclipse
using latest eclipse v3.3.1.1 Build id: M20071023-1652 trying to use the debugging option. for Ref. I use the Ben's post here http://www.forta.com/blog/index.cfm/2007/5/30/CF8-Debugger-Getting-Started But every time it comes back with the error unable to contact the rds server. It is the standard CF8 install.. in Eclipse. the hostname is the ip of the server. port is 80 no context root then username/password. in cf administrator. *Allow Line Debugging is checked and under *Security RDS *Use a single password only (default) is selected.* any help would be really appreciated. -- ... Regards, ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Consuming a .Net Control
Yes, this is possible with BlueDragon.NET (I can send you an example if you need it). No, I don't think this is possible with CF8, because CF8 does not provide any integration with ASP.NET, and .NET controls require the ASP.NET runtime context. CF8 integration with .NET is done via a separate Windows process--you can see this in the Services control panel or task manager--and this process does not provide any integration with ASP.NET. In contrast, BlueDragon.NET is implemented entirely on top of (within?) the ASP.NET runtime. Vince Bonfanti New Atlanta Communications, LLC Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Consuming a .Net Control
Actually, that won't work. CF8 can consume .NET classes etc. You have access to the .NET framework and any .NET code you write yourself. But CF cannot use ASP.NET controls. I see that Vince also responded, and he is correct. --- Ben -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 11:22 AM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control You should be able to with CF8. Call it as a cfobject -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 10:34 AM To: CF-Talk Subject: Coldfusion Consuming a .Net Control Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion Consuming a .Net Control
So the .net code would then call whatever controls you wanted to use. Or is there a complete disconnect between ColdFusion and .Net controls? Sorry for putting out inaccurate information. :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 12:06 PM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control Actually, that won't work. CF8 can consume .NET classes etc. You have access to the .NET framework and any .NET code you write yourself. But CF cannot use ASP.NET controls. I see that Vince also responded, and he is correct. --- Ben -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 11:22 AM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control You should be able to with CF8. Call it as a cfobject -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 10:34 AM To: CF-Talk Subject: Coldfusion Consuming a .Net Control Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Indexing a single pdf/word document
I need to index a pdf document into plaintext, and insert that text into a database column - not put it into a collection. Anyone ever done anything like that before? My goal is to make pdf/word documents searchable but at the same time be able to tie them back to a database record. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 and CFmail, sending duplicate emails
Thanks for the reply Tom, Are you talking about one thread for all the cfmails (outside the loop), or one for each mail? I'm assuming the latter wouldn't be a good plan where there might be thousands of emails, particularly on CF8 Standard. Also, with the former option, if the thread was named then I could presumably check that a thread of that name wasn't already running and not run the code if it was - my thinking was this could help deal with double clicks on the submit button. I'm looking at this at the moment. I'm still not convinced that the duplicated emails were caused by the user double clicking though. Cheers Will -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 27 November 2007 16:15 To: CF-Talk Subject: Re: CF8 and CFmail, sending duplicate emails On Tuesday 27 Nov 2007, Will Swain wrote: will look at implementing something that prevents this from happening - I'm think CFTHREAD is perfect here. Anyone have any thoughts on this? Yes, CFTHREAD the sending assuming the mail server can handle it. A simple thing to do for the button is use javascript to disable it onClick. 'course, if javascript is disabled there isn't much you can do except embed a one-time token in the form, and invalidate the token the first time it is used. -- Tom Chiverton Helping to enthusiastically participate market-driven communities on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS with Eclipse
I had issues with my proxy server effing things up here at work. Have you ruled out that possibility? On Nov 27, 2007 11:07 AM, Asim Manzur [EMAIL PROTECTED] wrote: using latest eclipse v3.3.1.1 Build id: M20071023-1652 trying to use the debugging option. for Ref. I use the Ben's post here http://www.forta.com/blog/index.cfm/2007/5/30/CF8-Debugger-Getting-Started But every time it comes back with the error unable to contact the rds server. It is the standard CF8 install.. in Eclipse. the hostname is the ip of the server. port is 80 no context root then username/password. in cf administrator. *Allow Line Debugging is checked and under *Security RDS *Use a single password only (default) is selected.* any help would be really appreciated. -- ... Regards, ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Conceptual Search against Database(s)
Greetings to all, I know Verity and Google search etc. etc. Try the following if you're interested in the topic, but before you begin let me issue some warnings: a) I'm not implementing some of the stuff that a beginner programmer would have implemented such as telling peole, oh query does not find such and such... just provide the core function... b) Please do no ask me for source code nor alg... c) Now let's get to the 'meat' part :) You may try the following 'concepts' respectively luck computer environmental protection Hollywood star --- another perspective, get a feel of what's on people's mind back then... try, future energy -- our interest in other nation Japan (hint, you may try any of the following respectively as well japanese archipelago japanese islands nihon nippon ) -- my own opinion, the 'thing' is good enough but not perfect. e.g. concept of 'energy' would get department of energy, good, but meantime, it would get 'zip' as well, wtf? NOW, here you go (the server is an old box, bear with me...) http://24.254.6.28:8000/myta/search.cfm P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: same line number keeps showing with cftrace
Now that everyone is back from the Holiday I'd like to try again. When I use cftrace on my local IIS or Apache Cold Fusion server the line number and file that the function was called from is displayed. When I do the same thing on our UNIX development server it always displays cfusion\wwwroot\WEB-INF\cftags\trace.cfm @ line: 86 Does anyone know how I can fix this? Bryan ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion Consuming a .Net Control
Not really, ASP.NET is not part of the integration story. Another way to look at it, kinda, is that CF8 integrates with server side ..NET stuff, but not client side .NET stuff, like the ASP.NET UI controls. --- Ben -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 12:43 PM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control So the .net code would then call whatever controls you wanted to use. Or is there a complete disconnect between ColdFusion and .Net controls? Sorry for putting out inaccurate information. :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 12:06 PM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control Actually, that won't work. CF8 can consume .NET classes etc. You have access to the .NET framework and any .NET code you write yourself. But CF cannot use ASP.NET controls. I see that Vince also responded, and he is correct. --- Ben -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 11:22 AM To: CF-Talk Subject: RE: Coldfusion Consuming a .Net Control You should be able to with CF8. Call it as a cfobject -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks Boycott Sys-Con http://www.sstwebworks.com/blog/index.cfm/2007/10/16/Boycotting-SysCon -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 10:34 AM To: CF-Talk Subject: Coldfusion Consuming a .Net Control Hello All, I have had the following request past onto me: Can we pass CF a .net 3.0 dll containing a control - say the calendar control, and then allow CF to consume this dll and display the calendar. I am using CF8 and I am aware that BlueDragon could be a possible answer to this, I was wondering if this is possible with CF8. The most I have done so far is use cfobject to expose some .net methods and display the data they return. Hope this makes sense. Thanks, Jose Diaz ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using View Templates and Subtemplates
Hello all, In the past, I applied a global template by creating header and footer includes. However, I am impressed with the implementation of templates and subtemplates by Model-Glue:Unity for the view. The problem is MG:U may be overkill for our small projects. Is there a simple solution to achieve similar results? Richard ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Dynamic Dropdowns
Hi All, Can I get some help figuring out how to connect two dropdowns dynamically? I am working a shoe database and I need to allow the user to select a size from a dropdown and then from there I need to have another dropdown called quantity updated with the amount of quantity based on the size that is selected. All the data is coming from a MSSQL Database and I am using ColdFusion 8. I would like to do this via Ajax and not refresh the entire page. I know how to do it by refreshing the entire page but not the Ajax way. Any help on this would be great. Thanks in advance. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conceptual Search against Database(s)
dl, I was the one who posted about Verity. Sadly, I didnt understand your email or find any more information on your website. What exactly is your approach? How would I implement it on my site? Is it proprietary? Does it build on verity? Does it cost money? Greetings to all, I know Verity and Google search etc. etc. Try the following if you're interested in the topic, but before you begin let me issue some warnings: a) I'm not implementing some of the stuff that a beginner programmer would have implemented such as telling peole, oh query does not find such and such... just provide the core function... b) Please do no ask me for source code nor alg... c) Now let's get to the 'meat' part :) You may try the following 'concepts' respectively luck computer environmental protection Hollywood star --- another perspective, get a feel of what's on people's mind back then... try, future energy -- our interest in other nation Japan (hint, you may try any of the following respectively as well japanese archipelago japanese islands nihon nippon ) -- my own opinion, the 'thing' is good enough but not perfect. e.g. concept of 'energy' would get department of energy, good, but meantime, it would get 'zip' as well, wtf? NOW, here you go (the server is an old box, bear with me...) http://24.254.6.28:8000/myta/search.cfm P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dynamic Dropdowns
just to throw another option out there... it could potentially all be done client side via javascript. create a 2d javascript array based on your query data. the onchange event from dropdown 1 would update the options in dropdown 2 based on that array. On Nov 27, 2007 11:35 AM, Steve Sequenzia [EMAIL PROTECTED] wrote: Hi All, Can I get some help figuring out how to connect two dropdowns dynamically? I am working a shoe database and I need to allow the user to select a size from a dropdown and then from there I need to have another dropdown called quantity updated with the amount of quantity based on the size that is selected. All the data is coming from a MSSQL Database and I am using ColdFusion 8. I would like to do this via Ajax and not refresh the entire page. I know how to do it by refreshing the entire page but not the Ajax way. Any help on this would be great. Thanks in advance. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Consuming a .Net Control
Another way to look at it, kinda, is that CF8 integrates with server side .NET stuff, but not client side .NET stuff, like the ASP.NET UI controls. I see the point you're trying to make, but this isn't really accurate. An ASP.NET control is equivalent to a CFML tag, and is rendered completely on the server. Another analogy you can make is between ASP.NET controls and JSP taglibs, which are also rendered completely on the server. Your first statement was more accurate (the for CF8 in parentheses was added by me): Not really, ASP.NET is not part of the integration story (for CF8). I'm not sure what you mean by CF8 integrates with server side .NET stuff. To me, .NET integration in CF8 is very much like Java integration was in CF5. In CF5, you can create Java objects via CFOBJECT, but there's no integration with server-side Java (J2EE, or now, just JEE). Prior to CFMX, there was no integration with J2EE servers, such as the J2EE Sessions option, or the ability to use JSP taglibs within CFML pages. Similarly, CF8 lets you create .NET objects via CFOBJECT, but provides no integration with ASP.NET, which is the .NET server-side equivalent of JSP/J2EE. Contrast this to BlueDragon.NET, which provides full integration with ASP.NET in much the same way that CFMX (and the Java/J2EE editions of BD) provide full integration with J2EE. BD.NET has an ASP.NET Sessions option, which allows you to share session scope variables between CFML and ASP.NET pages, and allows you to include (via CFINCLUDE) ASP.NET pages within CFML pages (these included ASP.NET pages can contain ASP.NET controls, which was the original question here). More information can be found in the BD 7.0 Integrating CFML with ASP.NET document: http://www.newatlanta.com/products/bluedragon/self_help/docs/7_0/BlueDragon_70_Integrating_CFML_with_ASPNET.pdf Vince Bonfanti New Atlanta Communications, LLC ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conceptual Search against Database(s)
James, Yes, it would cost money but not expensive... It has nothing to do with Verity nor Google. What's your email address? We could discuss more offline. Don dl, I was the one who posted about Verity. Sadly, I didnt understand your email or find any more information on your website. ... What exactly is your approach? How would I implement it on my site? Is it proprietary? Does it build on verity? Does it cost money? Greetings to all, P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Dynamic Dropdowns
Ben Forta wrote a post back in May that covers the basics of how to do this with CF 8: http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Related-Selects Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Steve Sequenzia wrote: Hi All, Can I get some help figuring out how to connect two dropdowns dynamically? I am working a shoe database and I need to allow the user to select a size from a dropdown and then from there I need to have another dropdown called quantity updated with the amount of quantity based on the size that is selected. All the data is coming from a MSSQL Database and I am using ColdFusion 8. I would like to do this via Ajax and not refresh the entire page. I know how to do it by refreshing the entire page but not the Ajax way. Any help on this would be great. Thanks in advance. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dynamic Dropdowns
Hi All, Can I get some help figuring out how to connect two dropdowns dynamically? I do it like charlie said, but I use mxajax. Works nicely, and I even have up to 8 related menus. Will ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Dynamic Dropdowns
hi, jquery has some plugins to do dynamic dropdowns. The footprints for jquery and the plugins are fairly small, and the ramp up time to use it in production is insignificant. http://jquery.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updating to Eclipse 3.3...
To copy existing projects along with local history, copy the folder .metadata\.plugins\org.eclipse.core.resources from your workspace. You can also copy the snippets folder. The default location is .metadata\.plugins\org.cfeclipse.cfml\snippets, or you can check CFEclipse preferences if they're in another location. The good news is you should be able to go to File Import Existing Projects into Workspace and it should import your project into your new build (although things like the local history won't be imported.) ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How good is cfreport?
Thanks for the input. It is very helpful. -Original Message- From: Jim Pennington [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 10:46 AM To: CF-Talk Subject: Re: How good is cfreport? I've been using Crystal Reports viewed via the web for sometime. As I am using an IIS server I've been using asp pages and it works great. I am using a program called recrystallize (www.recrystallize.com) which is a wizard that processes your rpt file and you need to provide the database connection information, parameters and how you want the report to be displayed. Once the process is completed it generates the ASP pages which you place on your web server. I've been using it for years and it's a great tool. Jim Pennington On Nov 27, 2007 10:17 AM, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Not positive on this, but I believe the multiple query thing was handled with CF 8... Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Kris Jones wrote: You should be able to do pretty much anything that Crystal Reports supports with the built-in cfreport and the (free) Report Builder. Talk to Dean Harmon at Adobe if you have specific questions (since he wrote most of the reporting subsystem). Sorry, but I'm not convinced of this. I've written some pretty complex Crystal Reports way back when, and after working with the Report Builder for a year +, can say that it isn't quite there yet. Good tool, no doubt, but still buggy, and doesn't support some things that I could use. (How about being able to pass in multiple queries to the report.) The IDE is very mouse-unfriendly, and I've seen instances of objects getting stuck in invisible places (how does an object get set to a negative y axis inside of a section?). Granted, I'm not on CF8 yet either (we're on 7.02) -- hopefully there's been huge progress made since? Cheers, Kris ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Connecting to a mysql database
I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders in my DW site local folder, remote folder and testing server folders all to C:\CFusionMX\db\, I can connect to my mysql database in CF Administrator. However, with these DW site folder settings, DW doesn't recognize any databases (Access or Mysql) at all. When I change my DW site folder settings to 'wwwroot' (e.g.local folder C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all my CF Administrator databases. The problem is CF Administrator can't connect to my Mysql data sources. It gives me the error: Connection verification failed for data source: javaserver []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 I've tried changing the 3306 port to 8500, but this doesn't help. My java path and connector file is: C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar, Is this a ID/password problem? I've tried both 'root' and leaving the ID field in the CF Administrator add data source block, both to no avail. I don't have a password set in Mysql for 'root' either. Any help would be gratefully appreciated. I've been working on this for weeks and keep running into one problem after another. Thanks a million in advance. Sincerely, Graham A. Kerby ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checking that a file is to be uploaded
Hi there I was just looking at your product Terraform and am interested in getting some more information on the product and possibly even purchasing it (for a future project). One piece of info I am after right now â is this. I have a site developed - http://conference.bellamedia.com.au/call_for_papers.cfm I have forma validation working with the exception of validating the file input box. Could you suggest something for a quick fix so that people cannot submit the form without including the file. I have used Checkform from Yarromat to perform the validation on other form elements. Can someone suggest a simple approach. Thanks in advance. Pete P.S. Donât want to really have to redo the form for just one thing. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Connecting to a mysql database
What version of ColdFusion are you running. There is a special connector that you may ahve to install to enable you to connect to a MySQL database. It is the mysql-connector-odbc-3.51.21-win32 available form the MySQL website. Download it and instal and then you also have to place a copy in a folder in CF, the lib folder but you better check on that one. Hope that helps a little. T I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders in my DW site local folder, remote folder and testing server folders all to C:\CFusionMX\db\, I can connect to my mysql database in CF Administrator. However, with these DW site folder settings, DW doesn't recognize any databases (Access or Mysql) at all. When I change my DW site folder settings to 'wwwroot' (e.g.local folder C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all my CF Administrator databases. The problem is CF Administrator can't connect to my Mysql data sources. It gives me the error: Connection verification failed for data source: javaserver []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 I've tried changing the 3306 port to 8500, but this doesn't help. My java path and connector file is: C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar, Is this a ID/password problem? I've tried both 'root' and leaving the ID field in the CF Administrator add data source block, both to no avail. I don't have a password set in Mysql for 'root' either. Any help would be gratefully appreciated. I've been working on this for weeks and keep running into one problem after another. Thanks a million in advance. Sincerely, Graham A. Kerby ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking that a file is to be uploaded
Try this: Change this line if (o.type=='text'||o.type=='password'||o.type=='hidden'){ to if (o.type=='text'||o.type=='password'||o.type=='hidden'||o.type=='file'){ And add this to your form tag ,'attachment_1','#q','0','Please upload an abstract' After 'email','S','2','Please enter a valid email address' HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: image effects
lol Will's more like the family dog that gets beat. I forgot to mention the entertainment value of the family feud between you, Dave1, and Will. :o) Rick ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: SQL Data Type
What are the benefits on using a CHAR field versus VARCHAR? I know with a CHAR(10) field that if the data is: START then the actual value is: START_ _ _ _ _ rather than a VARCHAR(10) of START. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Data Type
What are the benefits on using a CHAR field versus VARCHAR? Well, using char can be a bit speedier when querying, but takes up more disk space. You want to use char when all the data in that field will be close to the same length. the db will pad it, so it ends up taking up more space than if you used varchar and it set the length to the exact length of the data. I just converted some varchars to char as a small optimization to an app. Will ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Data Type
But when using CHAR within a SQL Statement don't you need to use a REPEATSTRING or a TRIM statement for proper validation so ensure that the value in the database matches the same length of the variable itself? I mainly use VARCHAR set to a size of the largest value expected. I only use CHAR when I know the length will always be the same such as: Where sex = 'M' or sex = 'F' This case sex would have a CHAR(1). Other than a small optimization within the query, coding would be a bit more to account for the complete length of the string? -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 8:53 PM To: CF-Talk Subject: Re: SQL Data Type What are the benefits on using a CHAR field versus VARCHAR? Well, using char can be a bit speedier when querying, but takes up more disk space. You want to use char when all the data in that field will be close to the same length. the db will pad it, so it ends up taking up more space than if you used varchar and it set the length to the exact length of the data. I just converted some varchars to char as a small optimization to an app. Will ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connecting to a mysql database
You've almost got it: JDBC URL - jdbc:mysql://localhost:3306/test Driver Class - com.mysql.jdbc.Driver Driver Name - MySQL Connector/J HTH, Adrian I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4