Moved CFMX7 CFIDE and now it won't work?
So I moved my CFIDE directory to another location for safety. I wanted to temporarily move it back, but every time I do, it responds with: File not found: /CFIDE/administrator/index.cfm but it's there! Is this one of those situations where a service restart is required? Thanks! MT ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dynamic variable Name in cfif
I'm having no trouble setting and outputting a dynamic variable name: cfoutputExpires_#UpdateMe#= #form[ 'Expires_' UpdateMe]#/cfoutput but when I go to evaluate that variable: cfif form[ 'Expires_' UpdateMe ] EQ Yes it returns: Variable YES is undefined because the VALUE of the Variable named Expires7 is indeed YES. I know there's a simple fix to this, but can't remember how. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting IIS 404 errors handled by CFM?
Is there a way to get the IIS 404 pages handled by the CF engine? This is CF8 on Win2003 Server. Currently, it displays the page, but when you View Source, you see all the CFML code. Switched back to a plain HTM file for now. Thanks! MarieT ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Apache Tomcat Training?
Hi, Has anyone taken Apache Tomcat training from the any of the vendors listed at: http://wiki.apache.org/tomcat/SupportAndTraining (scroll down to Training section) It include vendors: Kippdata, DevelopIntelligence, SpringSource, MuleSoft, NobleProg, OpenLogic and Savoir-faire Linux. Just wondering if anyone can recommend any of them, or others? Thanks! We're most interested in Best Practices, Java Memory Sizing and Garbage Collection Tuning, so the Kippdata looks good, but wanted to see if others had any experience or input about this. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex to parse cfhttp.filecontent?
Hi all, I need help in parsing returned cfhttp.filecontent contents. I need to find the line with AUTHORIZATION RESULT: and then get all the text that follows on that same line. I'm sure there's a simple way to do that with ReFind, but I'm a Regex idiot. Any help would be appreciated. Thanks! MarieT ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Highlighting non-standard ASCII characters?
Bobby, Thank you! This works great! MarieT Something like this? rereplace(str, '([^A-Za-z0-9_\r\s\n!\.\?''\(\),;:])', 'span class=highlight\1/span', 'all') If you donât mind characters like ñ, then just use \w instead of A-Za-z0-9_ rereplace(str, '([^\w\r\s\n!\.\?''\(\),;:])', 'span class=highlight\1/span', 'all') .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Highlighting non-standard ASCII characters?
Hi all, I'm looking for a way to *highlight* any characters that fall out of the range of A-z/0-9/standard punctuation characters. Most of the cflib utilities are made to remove those characters. Anyone know of (or have) a function that will make them stand out? I need to find them in an Oracle database field and highlight any characters that may not belong, so-to-speak. Any help is appreciated. Thanks! MarieT ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rotating CF Logs - best way?
I've done this. It rotates all logs except cfserver.log which is 48MB and growing. Anyone seen this behavior, or know how to get around it? On 3/17/2010 3:58 PM, Cameron Childress wrote: On Wed, Mar 17, 2010 at 1:30 PM, Marie Taylore mt4yl...@yahoo.com wrote: I have some ColdFusion logs that have been growing a long time and I need to finally get rotation going. http://livedocs.adobe.com/coldfusion/7/htmldocs/1718.htm -Cameron ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Rotating CF Logs - best way?
I have some ColdFusion logs that have been growing a long time and I need to finally get rotation going. I'm running CF7 Enterprise on RedHat Linux. Any advice on the best way to rotate them while the server is still running? I know cronolog is great for web logs - can it be configured to process CF logs as well? Anyone done that and care to share their configuration/s? Thanks! MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Validating that only .5 decimal gets through?
I have an app that I need to validate that they enter either whole numbers (1,2,3, etc.) or if they DO enter a decimal, it can only be in half increments, so 2.5 is okay, but not 2.1, 2.2, 2.25, etc. Of course, 2.0 would be okay too, so .0 after the number is fine. Is there a good way to check that with Regex rather than parsing the string and checking that the value after the period is a 5 or a 0? Thanks, MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Zipping files in CF7?
I seem to recall there's a way to call some Java routines in ColdFusion 7 to zip or unzip files. Can anyone point me to any how to's on this? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Zipping files in CF7?
yah, I could use that, although I thought I remember there was some Java-Zip functionality you could call directly within ColdFusion? Not true? --- On Thu, 1/21/10, Charlie Griefer charlie.grie...@gmail.com wrote: From: Charlie Griefer charlie.grie...@gmail.com Subject: Re: Zipping files in CF7? To: cf-talk cf-talk@houseoffusion.com Date: Thursday, January 21, 2010, 12:58 PM whoops. looks like the download link doesn't work from riaforge. googling brings up http://www.newsight.de/2005/06/28/finished-work-on-zip-cfc/ On Thu, Jan 21, 2010 at 12:56 PM, Charlie Griefer charlie.grie...@gmail.com wrote: http://zipcfc.riaforge.org/ On Thu, Jan 21, 2010 at 12:55 PM, Marie Taylore mt4yl...@yahoo.comwrote: I seem to recall there's a way to call some Java routines in ColdFusion 7 to zip or unzip files. Can anyone point me to any how to's on this? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Zipping files in CF7?
Ah yes! Thanks for jarring my memory. Now I remember I had used two cflib.org functions: zipFileNew() by Nathan Dintenfass and unzipFile() Samuel Neff both of which greatly simplify the calls to java.util.zip libraries and work in ColdFusion MX and up. You pointed me in the right direction! Thanks! --- On Thu, 1/21/10, Charlie Griefer charlie.grie...@gmail.com wrote: From: Charlie Griefer charlie.grie...@gmail.com Subject: Re: Zipping files in CF7? To: cf-talk cf-talk@houseoffusion.com Date: Thursday, January 21, 2010, 9:18 PM http://www.koders.com/coldfusion/fidBEB0DE5D42A343D22523C79368CC143BF331CC8A.aspx On Thu, Jan 21, 2010 at 7:42 PM, Marie Taylore mt4yl...@yahoo.com wrote: yah, I could use that, although I thought I remember there was some Java-Zip functionality you could call directly within ColdFusion? Not true? --- On Thu, 1/21/10, Charlie Griefer charlie.grie...@gmail.com wrote: From: Charlie Griefer charlie.grie...@gmail.com Subject: Re: Zipping files in CF7? To: cf-talk cf-talk@houseoffusion.com Date: Thursday, January 21, 2010, 12:58 PM whoops. looks like the download link doesn't work from riaforge. googling brings up http://www.newsight.de/2005/06/28/finished-work-on-zip-cfc/ On Thu, Jan 21, 2010 at 12:56 PM, Charlie Griefer charlie.grie...@gmail.com wrote: http://zipcfc.riaforge.org/ On Thu, Jan 21, 2010 at 12:55 PM, Marie Taylore mt4yl...@yahoo.com wrote: I seem to recall there's a way to call some Java routines in ColdFusion 7 to zip or unzip files. Can anyone point me to any how to's on this? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Custom Tag (etc.) libraries online?
Hey all, what are some of the best or latest and greatest custom tag / function / cfc sites available out there? All the old links I have (haven't search for any in a while) look like they're pretty out of date and Adobe's developer exchange is just dismal - has tags there that don't even exist when you click on them. What I'm looking for is a good free utility that helps in paging query results, with a first / previous / next / last or even one with nearby numbered pages showing. Would love if it was really simple to use, and shouldn't BE (or create) the result page (i.e. replacing mine) but rather *integrate* with a page already built, simply placing paging links on the page. This is for CF 7 Enterprise and is not a CFC app. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Deploying a WAR (or EAR) file to JRun under CF9?
Hi all, I have the trial of ColdFusion 9 running on Linux and am wondering... if I have a Java WAR (or EAR) file how do I deploy that into a JRun instance on my server? I installed as 2- Enterprise Multiserver configuration so I'm assuming that includes the full J2EE engine, but I'm curious how I deploy a (non-CF) Java application. Is it under the Packaging Deployment J2EE Archives area in the CF Administrator? If so, how do I ensure it runs in its own space on the server? i.e. so that it won't bring down CF and vice versa? (as you can tell, I'm a newbie at the Java stuff... this is for someone else who wants to proof of concept some apps on the server) Thanks for any help you can provide. MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying a WAR (or EAR) file to JRun under CF9?
Thanks Dave! I tried going to localhost:8000, but nothing is listening there. Do I need to start a separate JRun server/service? I thought it would already be running along with ColdFusion?? The only port listening in the 8000 range is 8300 (CF web trial server). Any help anyone can provide is appreciated. Thanks! MarieT --- On Tue, 11/3/09, Dave Watts dwa...@figleaf.com wrote: From: Dave Watts dwa...@figleaf.com Subject: Re: Deploying a WAR (or EAR) file to JRun under CF9? To: cf-talk cf-talk@houseoffusion.com Date: Tuesday, November 3, 2009, 4:05 PM You don't use the CF Administrator for any of this. You have to do this directly through your J2EE server. In this case, that would be JRun. You can use the JRun admin console (http://localhost:8000/) to do this. You can also do it by expanding EARs and WARs directly within the appropriate JRun directory. It's actually not all that hard, but you'll probably have to refer to the JRun docs (online at livedocs.adobe.com I think, otherwise available to download as PDF I'm sure). There are also docs at \jrun4\docs, but I don't really know exactly what's in there offhand. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Marie Taylore wrote I have the trial of ColdFusion 9 running on Linux and am wondering... if I have a Java WAR (or EAR) file how do I deploy that into a JRun instance on my server? I installed as 2- Enterprise Multiserver configuration so I'm assuming that includes the full J2EE engine, but I'm curious how I deploy a (non-CF) Java application. Is it under the Packaging Deployment J2EE Archives area in the CF Administrator? If so, how do I ensure it runs in its own space on the server? i.e. so that it won't bring down CF and vice versa? (as you can tell, I'm a newbie at the Java stuff... this is for someone else who wants to proof of concept some apps on the server) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying a WAR (or EAR) file to JRun under CF9?
I think I got it. Run ./bin/jrun -start admin Now I can get into the Java Management Console (JMC). Will see if I can deploy a WAR now. Thanks! --- On Tue, 11/3/09, Marie Taylore mt4yl...@yahoo.com wrote: From: Marie Taylore mt4yl...@yahoo.com Subject: Re: Deploying a WAR (or EAR) file to JRun under CF9? To: cf-talk cf-talk@houseoffusion.com Date: Tuesday, November 3, 2009, 10:51 PM Thanks Dave! I tried going to localhost:8000, but nothing is listening there. Do I need to start a separate JRun server/service? I thought it would already be running along with ColdFusion?? The only port listening in the 8000 range is 8300 (CF web trial server). Any help anyone can provide is appreciated. Thanks! MarieT --- On Tue, 11/3/09, Dave Watts dwa...@figleaf.com wrote: From: Dave Watts dwa...@figleaf.com Subject: Re: Deploying a WAR (or EAR) file to JRun under CF9? To: cf-talk cf-talk@houseoffusion.com Date: Tuesday, November 3, 2009, 4:05 PM You don't use the CF Administrator for any of this. You have to do this directly through your J2EE server. In this case, that would be JRun. You can use the JRun admin console (http://localhost:8000/) to do this. You can also do it by expanding EARs and WARs directly within the appropriate JRun directory. It's actually not all that hard, but you'll probably have to refer to the JRun docs (online at livedocs.adobe.com I think, otherwise available to download as PDF I'm sure). There are also docs at \jrun4\docs, but I don't really know exactly what's in there offhand. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Marie Taylore wrote I have the trial of ColdFusion 9 running on Linux and am wondering... if I have a Java WAR (or EAR) file how do I deploy that into a JRun instance on my server? I installed as 2- Enterprise Multiserver configuration so I'm assuming that includes the full J2EE engine, but I'm curious how I deploy a (non-CF) Java application. Is it under the Packaging Deployment J2EE Archives area in the CF Administrator? If so, how do I ensure it runs in its own space on the server? i.e. so that it won't bring down CF and vice versa? (as you can tell, I'm a newbie at the Java stuff... this is for someone else who wants to proof of concept some apps on the server) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327986 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Compare Two MySQL Databases?
What's the easiest quickest way to compare two MySQL Schemas (databases)? I don't need to compare the *data*... just the tables and their field definitions. My production instance is getting an error that my test instance is not. The code is identical, so I figure I must have left something out of the database updates, but going through all those tables and fields by hand will take forever. Just thought I'd see if anyone here has any tips. Thanks! MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare Two MySQL Databases?
Sonny Gerald, Thanks for the suggestion! I downloaded it and I have a few questions: Can I have it just *show* me the differences instead of running a Sync? I don't want the *data* copied, I just want to know which field definitions might be different. Would you use database sync or schema sync for something like this? Or is there another compare option? Thanks! MarieT --- On Tue, 7/14/09, Gerald Guido gerald.gu...@gmail.com wrote: From: Gerald Guido gerald.gu...@gmail.com Subject: Re: Compare Two MySQL Databases? To: cf-talk cf-talk@houseoffusion.com Date: Tuesday, July 14, 2009, 4:53 PM +1 for SQLyog. SQLyog's schema and data sync tools are great IMHO. G! On Tue, Jul 14, 2009 at 7:33 PM, Sonny Savage sonnysav...@gmail.com wrote: I've used SQLyog and found it to be pretty impressive. It's around $100, but there's a 30-day trial that might get you through this issue: http://www.webyog.com/en/downloads.php#sqlyog Edward Sonny Savage On Tue, Jul 14, 2009 at 7:24 PM, Marie Taylore mt4yl...@yahoo.com wrote: What's the easiest quickest way to compare two MySQL Schemas (databases)? I don't need to compare the *data*... just the tables and their field definitions. My production instance is getting an error that my test instance is not. The code is identical, so I figure I must have left something out of the database updates, but going through all those tables and fields by hand will take forever. Just thought I'd see if anyone here has any tips. Thanks! MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Join Two fields in one table to One field in Another?
I know this is probably simpler than I'm making it, but I have Table A with two different references to the primary key in table B. Table A === From To == 1 2 2 4 3 7 Table B === PK Firstname Lastname == = 1 John Doe 2 Jane Doe 3 John Smith 4 Jane Smith 7 Frank Jones I need to be able to show the first and last names from Table A's references to the PK in Table B (for both fields From and To). Basically, I'm trying to get the following output: Sent From Sent To == === John DoeJane Doe Jane DoeJane Smith John Smith Frank Jones What kind of join do I need to make this work? Or does my table design not allow this? Regular inner joins don't seem to be working, and I'm certainly no SQL wiz. Any help is appreciated. MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Join Two fields in one table to One field in Another?
Solution I received from BACFUG member Jim Flannery: This should work in MS-SQL: SELECT sender = sentfrom.firstname + ' ' + sentfrom.lastname, receiver = sentto.firstname + ' ' + sentto.lastname FROM TableA INNER JOIN TableB sentfrom ON TableA.From = sentfrom.PK INNER JOIN TableB sentto ON TableA.To = sentto.PK had to slightly modify it for MySQL, but it works like a charm! I know this is probably simpler than I'm making it, but I have Table A with two different references to the primary key in table B. Table A === From To == 1 2 2 4 3 7 Table B === PK Firstname Lastname == = 1 John Doe 2 Jane Doe 3 John Smith 4 Jane Smith 7 Frank Jones I need to be able to show the first and last names from Table A's references to the PK in Table B (for both fields From and To). Basically, I'm trying to get the following output: Sent From Sent To == === John DoeJane Doe Jane DoeJane Smith John Smith Frank Jones What kind of join do I need to make this work? Or does my table design not allow this? Regular inner joins don't seem to be working, and I'm certainly no SQL wiz. Any help is appreciated. MarieT ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam vs cfstoredproc?
Question... the more I read about CFQUERYPARAM the more it seems it mitigates many of the problems that using stored procedures also solves. I realize with stored procedures you have a lot more power in terms of SQL scripting, but for basic queries, is CFQUERYPARAM just as fast as (or faster than) running CFSTOREDPROC? For a CFSTOREDPROC vs CFQUERYPARAM debate what would be the better thans on each side of the argument? A few I can think of off the top of my head would be: Stored Procedures - can contain advanced SQL procedural code. Encapsulate code outside of you application for a layer of abstraction. CFQUERYPARAM - allows non-DBAs to take advantage of pre-compiled queries, providing speedier and more secured code. You can encapsulate much the same way a stored procedure does with CFCs. Would love to hear from others on the advantages/disadvantages of each Thanks! Marie keywords for searching: cfprocparam vs cfqueryparam, cfqueryparam vs cfprocparam, cfprocresult, cfquery, cftransaction, cfupdate, cfinsert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Proper Authentication with CFLDAP?
I just received this code as the proper way to bind someone during an LDAP login to a ColdFusion App. Is this really the right way? cfset UserIsValid = 0 CFTRY cfldap action=QUERY name=Authenticate start=uid=#username#,ou=#OurOU#,dc=#OurDC#,dc=#OurDC2# attributes=cn scope=SUBTREE server=#OurServer# username=uid=#username#,ou=#OurOU#,dc=#OurDC#,dc=#OurDC2# password=#password# cfif Authenticate.RecordCount GT 0 cfset UserIsValid = 1 cfelse cfset UserIsValid = 0 /cfif cfcatch type=Any cfset UserIsValid = 0 !--- DEBUG CODE HERE --- /cfcatch /CFTRY cfif UserIsValid EQ 0 Sorry, login failed. cfabort /cfif If they pass the CFABORT above, they're authenticated to your app. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4