Re: cfadmin 404 with apache
It would also help if you posted snippets of your http.config. I run Apache and IIS locally (not at the same time :-). I seem to remember having a few issues at the beginning but it then became easier once you sort the settings/quirks. What happens if you place a .cfm file in the htdocs dir and run it from there? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Doug Brown To: CF-Talk Sent: Wed Oct 18 01:32:09 2006 Subject: Re: cfadmin 404 with apache Rob When I installed MX it asked where my web root was and I had made a directoy of d:\webroot The CFIDE directory is in that folder if that helps any. - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 17, 2006 6:20 PM Subject: Re: cfadmin 404 with apache That's a completely different error, so I'm a little confused. But, back to this question...is the CFIDE directory in your web root? Are you using virtual hosts? On Oct 17, 2006, at 8:09 PM, Doug Brown wrote: Rob, Thanks for the reply. I think the problem was that I was using apache 2.23 I installed 2.0.59 and now I am just getting a CF error saying that it cannot find /CFIDE/administrator/index.cfm. Any ideas on this? - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 17, 2006 6:03 PM Subject: Re: cfadmin 404 with apache On Oct 17, 2006, at 7:40 PM, Doug Brown wrote: Ok, I removed and reinstalled apache and CF and I am getting the following error. Cannot load D:\CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so into server. The specified procedure could not be found. Any ideas on this one? Again this is windows 2000 adv svr In this case, it looks like your problem might be the backslash (\). Even on Windows, Apache likes forward slashes in your paths. You can often get away with backslashes if your path is quoted, but forward slashes are safer, I think. Rob Wilkerson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Portal application
Hi: There are many many portals made with PHP or .Net with many features but coldfusion portals look very basic. Is there any advanced CF protal out there? Or does any company/programmer team work on a CF portal that can compete with others? Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257140 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 Portal application
The beauty of CF has always been that you could do this very quickly yourself, without having to rely on buggy open-source projects which do more than most people would ever need, need some horrible PHP hacking to work properly, and look the same as 1001 other sites. There have been some CF versions of things like Nuke in the past but they've never really taken off. -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: 18 October 2006 11:03 To: CF-Talk Subject: Coldfusion Portal application Hi: There are many many portals made with PHP or .Net with many features but coldfusion portals look very basic. Is there any advanced CF protal out there? Or does any company/programmer team work on a CF portal that can compete with others? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
On Oct 17, 2006, at 10:50 PM, Doug Brown wrote: Ok, now I have it to the point where it can find the administrator/index.cfm, but it wants to download it instead of run it. Man I should have known apache was going to be a pain in the arse for someone who never used it... I understand your frustration, but it's really not bad. It's actually a bit more intuitive, I think. But you definitely have to get used to it. There is a connector for Apache 2.2.x which is different from the 2.0.x connector (Apache changed it's module API again) so you definitely need that. You've probably already pasted it somewhere, but if you don't mind sending me your httpd.conf file, I'll take a look and see how it compares to mine. I'm running 2.0.x on my Windows box, but it shouldn't be that different. It sounds like the connector is still not quite right. Did you run wsconfig? If so, can you send the command line args you used? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
connector error redhat linux es 3 and apache
HI can somebody help me with this.. tried installing coldfusion on redhat linux es 3 with apache as web server it installs fine but when i load it there's always this connector error problem.. tried all the instructions of macromedia and also any service pack but to no avail.. can somebody please help thanks alex ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
Rob, I (was) using apache version 2.23 and when I could never get it working with the 2.0 version of macromedia connector I removed it and installed the 2.0 version of apache with the 2.0 connector. So right now I am running apache 2.0 with a 2.0 connector. Right now I can click on the CF Admin link and it will open it in homesite instead of in a browser... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connector error redhat linux es 3 and apache
On 10/18/06, alex poyaoan [EMAIL PROTECTED] wrote: HI can somebody help me with this.. tried installing coldfusion on redhat linux es 3 with apache as web server it installs fine but when i load it there's always this connector error problem.. tried all the instructions of macromedia and also any service pack but to no avail.. can somebody please help I've never seen errors in an ES3 install. Can you pass along the error message? Do your apache logs offer any insight? If memory serves, ES3 ships with SELinux enabled. Can you disable that to determine whether it might be playing a role? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Old Bit mask Presentation
Howdy! There was a presentation on the use of bit masks and user permissions made to the Arizona CFUG back in 2000-2001. I'm trying to find a copy of that presentation or something similar. I went to the current Arizona CFUG but it doesn't come up when I search their archives. There's an old thread buried here in these archives that mentions it also. Any pointers? Thx Ken ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
Nope, still want to open the Admin in homesite...Weird My apache error log [Wed Oct 18 06:09:48 2006] [notice] jrApache[2412: 30468] Server has not been properly configured for JRun. [Wed Oct 18 06:09:48 2006] [error] [client 127.0.0.1] File does not exist: D:/Program Files/Apache Group/Apache2/htdocs/CFIDE [Wed Oct 18 06:13:46 2006] [notice] jrApache[2412: 36612] Server has not been properly configured for JRun. [Wed Oct 18 06:17:03 2006] [notice] jrApache[2412: 43780] Server has not been properly configured for JRun. - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 18, 2006 6:09 AM Subject: Re: cfadmin 404 with apache Check the AddHandler directive within your jrun20.so block. This is the JRun-specific config data for my installation (Apache 2.0.58 on WinXP): LoadModule jrun_module D:/macromedia/jrun4/lib/wsconfig/1/mod_jrun20.so IfModule mod_jrun20.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore D:/macromedia/jrun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51020 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps. On 10/18/06, Doug Brown [EMAIL PROTECTED] wrote: Rob, I (was) using apache version 2.23 and when I could never get it working with the 2.0 version of macromedia connector I removed it and installed the 2.0 version of apache with the 2.0 connector. So right now I am running apache 2.0 with a 2.0 connector. Right now I can click on the CF Admin link and it will open it in homesite instead of in a browser... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Performance
Not sure there is much to do be on this question but never know. We use seefusion to keep an eye on threads and lately the site has been getting hit hard, what I see in seefusion though is that the same request person is holding up 20 threads and the requests are within seconds of each other at times. So what is happening is they get a slow page and then start to jam on the refresh button a ton of times causing more threads and creating a bottleneck and eventually eating up all the threads. Any suggestions on something like this? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PLEASE HELP! Why is this application.cfc erroring out?
Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Old Bit mask Presentation
Ken Monroe wrote: Howdy! There was a presentation on the use of bit masks and user permissions made to the Arizona CFUG back in 2000-2001. I'm trying to find a copy of that presentation or something similar. I went to the current Arizona CFUG but it doesn't come up when I search their archives. There's an old thread buried here in these archives that mentions it also. Any pointers? Thx Ken Hal Helms wrote a paper about using bit masks for permissions many years back... http://halhelms.com/writings/ProposedSecurityModel.pdf ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF blog application
Doh! -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 3:33 PM To: CF-Talk Subject: Re: CF blog application By a long shot. I'm at 5.5.something. Please see www.blogcfc.com. On 10/17/06, Mark A Kruger [EMAIL PROTECTED] wrote: Ray, I don't see a link to a slide show piece in the admin blogCFC 5.003 Did I miss another release :) -mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 1:39 PM To: CF-Talk Subject: Re: CF blog application Rick was talking about stuff NOT in his blogware but in mine. :) By slideshows I mean this: You can create a slideshow by just uploading images to a directory. Or you can create one in the admin. If you make one in the admin, you can add captions and a title to show. Basically you have multiple ways to add pictures to your blog. On 10/17/06, Mark A Kruger [EMAIL PROTECTED] wrote: Rick, Where's the slideshow feature... And what the heck is it? -mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 11:52 AM To: CF-Talk Subject: Re: CF blog application Here's a list of Ray's features that aren't in BlogCFM =) * Send Entry * Related Entries * Trackbacks (with a powerful spam fighting system) * Print format (cfmx7 only) * Localization support via 'language' skins * Stats * XML-RC * Slide shows * Basic CMS functionality (for writing pages outside of entries) * Extensible rendering engine (also, with regard to subscriptions, only registered users can subscribe to my blog entries - non registered users posting comments (if allowed)) cannot subscribe, so I can avoid certain kinds of comment spam abuse) No, Ray's blog definately isn't basic. In fact, if I weren't so lazy, I'd probably convert to his blog software - and the only things I'd change would be implementing an HTML editor, and eliminating the javascript popup comment windows... I'd much rather the comments - and the comment form - be inline. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists(arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Oxalto Error Handling subject=Error: Brabant Ensemble type=html cfif IsDefined(variables.error)cfdump var=#variables.error# label=Error Variables//cfif cfdump var=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput !DOCTYPE html PUBLIC -//W3C// DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 / style type=text/css media=all body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} /style titleFooe/title /head body div id=container h1An Error has Occured/h1 p/p pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /div /body /html /cfoutput /cfif /cffunction On 18 Oct 2006, at 13:39, Ben Nadel wrote: Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
It just gets stranger and strangerI created a hello world in a test.cfm file and ran ran it from the htdocs folder and it displays fine. It will not open the CF Admin in anything other than homesite though. Also if I put cfset myVar = hello world cfoutput#myVar#/cfoutput It will only display the string of #myVar# and not hello world - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 18, 2006 1:48 AM Subject: Re: cfadmin 404 with apache It would also help if you posted snippets of your http.config. I run Apache and IIS locally (not at the same time :-). I seem to remember having a few issues at the beginning but it then became easier once you sort the settings/quirks. What happens if you place a .cfm file in the htdocs dir and run it from there? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Doug Brown To: CF-Talk Sent: Wed Oct 18 01:32:09 2006 Subject: Re: cfadmin 404 with apache Rob When I installed MX it asked where my web root was and I had made a directoy of d:\webroot The CFIDE directory is in that folder if that helps any. - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 17, 2006 6:20 PM Subject: Re: cfadmin 404 with apache That's a completely different error, so I'm a little confused. But, back to this question...is the CFIDE directory in your web root? Are you using virtual hosts? On Oct 17, 2006, at 8:09 PM, Doug Brown wrote: Rob, Thanks for the reply. I think the problem was that I was using apache 2.23 I installed 2.0.59 and now I am just getting a CF error saying that it cannot find /CFIDE/administrator/index.cfm. Any ideas on this? - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 17, 2006 6:03 PM Subject: Re: cfadmin 404 with apache On Oct 17, 2006, at 7:40 PM, Doug Brown wrote: Ok, I removed and reinstalled apache and CF and I am getting the following error. Cannot load D:\CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so into server. The specified procedure could not be found. Any ideas on this one? Again this is windows 2000 adv svr In this case, it looks like your problem might be the backslash (\). Even on Windows, Apache likes forward slashes in your paths. You can often get away with backslashes if your path is quoted, but forward slashes are safer, I think. Rob Wilkerson ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:52 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists(arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Oxalto Error Handling subject=Error: Brabant Ensemble type=html cfif IsDefined(variables.error)cfdump var=#variables.error# label=Error Variables//cfif cfdump var=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput !DOCTYPE html PUBLIC -//W3C// DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 / style type=text/css media=all body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} /style titleFooe/title /head body div id=container h1An Error has Occured/h1 p/p pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /div /body /html /cfoutput /cfif /cffunction On 18 Oct 2006, at 13:39, Ben Nadel wrote: Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben ... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T On 18 Oct 2006, at 13:56, Ben Nadel wrote: Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:52 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists(arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Oxalto Error Handling subject=Error: Brabant Ensemble type=html cfif IsDefined(variables.error)cfdump var=#variables.error# label=Error Variables//cfif cfdump var=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput !DOCTYPE html PUBLIC -// W3C// DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 / style type=text/css media=all body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} /style titleFooe/title /head body div id=container h1An Error has Occured/h1 p/p pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /div /body /html /cfoutput /cfif /cffunction On 18 Oct 2006, at 13:39, Ben Nadel wrote: Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a
Re: cfadmin 404 with apache
Check the AddHandler directive within your jrun20.so block. This is the JRun-specific config data for my installation (Apache 2.0.58 on WinXP): LoadModule jrun_module D:/macromedia/jrun4/lib/wsconfig/1/mod_jrun20.so IfModule mod_jrun20.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ssl false JRunConfig Ignoresuffixmap false JRunConfig Serverstore D:/macromedia/jrun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51020 #JRunConfig Errorurl optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 #JRunConfig ConnectTimeout 15 #JRunConfig RecvTimeout 300 #JRunConfig SendTimeout 15 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Hope this helps. On 10/18/06, Doug Brown [EMAIL PROTECTED] wrote: Rob, I (was) using apache version 2.23 and when I could never get it working with the 2.0 version of macromedia connector I removed it and installed the 2.0 version of apache with the 2.0 connector. So right now I am running apache 2.0 with a 2.0 connector. Right now I can click on the CF Admin link and it will open it in homesite instead of in a browser... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, Just to be clear, you cannot see the error on the page... It only get's written to that HTML file. Are you not seeing the error on page or is it not writing any HTML file? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
On Wednesday 18 October 2006 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Remove the offending method. What happens ? Could you do it another way ? -- Tom Chiverton Helping to heterogeneously drive professional markets 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T On 18 Oct 2006, at 14:11, Ben Nadel wrote: Tom, Just to be clear, you cannot see the error on the page... It only get's written to that HTML file. Are you not seeing the error on page or is it not writing any HTML file? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Hmmm, good to know it works somewhere. Thanks for the help Tom. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:16 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Performance
Brian, Not sure there is much to do be on this question but never know. We use seefusion to keep an eye on threads and lately the site has been getting hit hard, what I see in seefusion though is that the same request person is holding up 20 threads and the requests are within seconds of each other at times. So what is happening is they get a slow page and then start to jam on the refresh button a ton of times causing more threads and creating a bottleneck and eventually eating up all the threads. Any suggestions on something like this? Well I'm sure you'll get a fair share of fix your code comments ;), the bottom line is there are occasionally times when you'll write a poor performing template (i.e. a seldom run report year-to-date report, etc.) Obviously if this is a page that is accessed a lot, I'd look into caching the results to improve performance. If it's not a page that need to be in realtime, look into pre-caching the page (generate the cache at some pre-determined interval and the page can only view from the cached data.) However, if caching isn't an option, one thing I've done for report generation in the past is create a report lock that prevents the report from being run again until the original process finishes. If the report is still running and the user tries to re-access the page, you just display a This report is still processing message. You can then have the page refresh every XX number of seconds checking to see if the report is done. This does involve writing the report to disk or storing in a persistent memory scope--so that when the report is done you can display it from a different thread other than the one that originally created the results. -Dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257164 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 Portal application
Ray Camden started a CF portal: http://www.coldfusionportal.org/ Teddy On 10/18/06, David Low [EMAIL PROTECTED] wrote: The beauty of CF has always been that you could do this very quickly yourself, without having to rely on buggy open-source projects which do more than most people would ever need, need some horrible PHP hacking to work properly, and look the same as 1001 other sites. There have been some CF versions of things like Nuke in the past but they've never really taken off. -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: 18 October 2006 11:03 To: CF-Talk Subject: Coldfusion Portal application Hi: There are many many portals made with PHP or .Net with many features but coldfusion portals look very basic. Is there any advanced CF protal out there? Or does any company/programmer team work on a CF portal that can compete with others? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
Can you send you JRun module block like I did earlier? That might help. On 10/18/06, Doug Brown [EMAIL PROTECTED] wrote: Nope, still want to open the Admin in homesite...Weird My apache error log [Wed Oct 18 06:09:48 2006] [notice] jrApache[2412: 30468] Server has not been properly configured for JRun. [Wed Oct 18 06:09:48 2006] [error] [client 127.0.0.1] File does not exist: D:/Program Files/Apache Group/Apache2/htdocs/CFIDE I assume that your CFIDE directory is located at the path specified in this log entry. Is that the case? Is htdocs listed as the web root for the server in your httpd.conf (should be unless you modified it). What is the value for your DocumentRoot directive in httpd.conf? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Just tried restarting the CF machine... Still same errors :( .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Announce: RIAForge
So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
Ray, Nice design! .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Announce: RIAForge
SAWEET! :) I've got a little project that I've been on the verge of releasing, but I didn't want to build a site for it (and I didn't want to use Google code or any of the others). This should be just what I needed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 7:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
SWEET! -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Announce: RIAForge
I should point out - if anyone compares this to Google Code and decides Google Code is better - I understand, but _please_ email me and tell me so I can improve the site. On 10/18/06, Munson, Jacob [EMAIL PROTECTED] wrote: SAWEET! :) I've got a little project that I've been on the verge of releasing, but I didn't want to build a site for it (and I didn't want to use Google code or any of the others). This should be just what I needed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 7:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange URL pointing to CFM page
All, I've never seen this type of hyperlink before. It resolves to a cfm page. Is it pointing to a directory or a file? http://www.domainname.com/coupons?subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZXJAYXR0Lm5ldA== Thanks D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Announce: RIAForge
Trully awesome stuff, once again, Ray! I am so not worthy :-) Suggestion: I'm sure you're already on this, but are you going to incorporate some sort of tags or subcategories method for keeping projects organized and easy to find within their group? My biggest beef with many open source project sites is how difficult they are to index and find things. Sourceforge, especially, can be a bear unless you happen to find what you're looking for in a Google search. -Jon On Oct 18, 2006, at 9:48 AM, Raymond Camden wrote: So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- == = Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org \ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
The thing I don't like about Google Code is that it's very plain vanilla. Honestly I haven't used it, but when I've poked around in other people's projects, I find myself wondering where certain features are (like file downloads outside of SVN), but I don't think they exist. I guess it could be that the project manager just didn't turn that stuff on... -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 7:59 AM I should point out - if anyone compares this to Google Code and decides Google Code is better - I understand, but _please_ email me and tell me so I can improve the site. On 10/18/06, Munson, Jacob [EMAIL PROTECTED] wrote: SAWEET! :) I've got a little project that I've been on the verge of releasing, but I didn't want to build a site for it (and I didn't want to use Google code or any of the others). This should be just what I needed. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange URL pointing to CFM page
It's pointing to a directory and would resolve to /coupons/index.cfm? subscriberemail=yadayada - assuming index.cfm is your default index page. Jon On Oct 18, 2006, at 10:00 AM, [EMAIL PROTECTED] wrote: All, I've never seen this type of hyperlink before. It resolves to a cfm page. Is it pointing to a directory or a file? http://www.domainname.com/coupons? subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZXJAYXR0Lm5ldA== Thanks D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
Ray... The site looks awesome and the idea is great! What a good way of putting forth Coldfusion mixed in with the other stuff that people are going to come looking for. A few suggestions: 1) At the bottom of each page is a disclaimer, but in IE the disclaimer pushes right against the browser chrome making it hard to read. I suggest putting a break or two after that to give it at least one full return of space. 2) Clicking the ColdFusion tag (and the other tabs I'm sure) displays a list of projects with HUGE headers, you're using H2s. I suggest styling them to appear smaller. They're way too large at the moment. 3) Most importantly, when I click the CF button, all of a sudden the page has about an extra 3 inches of horizontal scrolling. Nothing's there, but the page shows a scrollbar. It does it on the other tabs too even though there's nothing there. 4) Tables? The site looks so good that the source code should look the same. Do you need someone to help you convert this to a pure CSS design? I'd be happy to volunteer. 5) You might also consider adding InDesign and Illustrator buttons as those two are very popular as well. Everything else is great. This is really exciting. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Announce: RIAForge
To support the CF Community, using RIA Forge would be my first choice. Teddy On 10/18/06, Raymond Camden [EMAIL PROTECTED] wrote: I should point out - if anyone compares this to Google Code and decides Google Code is better - I understand, but _please_ email me and tell me so I can improve the site. On 10/18/06, Munson, Jacob [EMAIL PROTECTED] wrote: SAWEET! :) I've got a little project that I've been on the verge of releasing, but I didn't want to build a site for it (and I didn't want to use Google code or any of the others). This should be just what I needed. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 7:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257179 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 compare software
Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). It still doesn't work for one of my tables, and I haven't really been using it in depth, but once my RedGate's Trial is over, I guess I'll have a tough decision to make. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 11:47 PM To: CF-Talk Subject: SQL compare software Been using RedGate's Compare tools, and I must say, they really rock. However, for my limited home/freelance use, they are a little expensive ($295 license). Anyone ever use a similar tool that they really like that is a little cheaper? I may just go ahead and fork over the fee anyway, since it already has saved me a ton of time, but don't want to buy it just yet until I know that this is the best deal out there for this kind of software. Needs to be able to synch SQL Server 2000, 2005 DB's (MySQL would be cool too, but not a requirement) - both objects and data. Thanks, Ray -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.0.408 / Virus Database: 268.13.4/480 - Release Date: 10/17/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
Jon, I agree with you. We just need to come up with the right sorting/grouping mechanism, and will figure that out when we have more projects (enough to warrant it). --- Ben -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:03 AM To: CF-Talk Subject: Re: Announce: RIAForge Trully awesome stuff, once again, Ray! I am so not worthy :-) Suggestion: I'm sure you're already on this, but are you going to incorporate some sort of tags or subcategories method for keeping projects organized and easy to find within their group? My biggest beef with many open source project sites is how difficult they are to index and find things. Sourceforge, especially, can be a bear unless you happen to find what you're looking for in a Google search. -Jon On Oct 18, 2006, at 9:48 AM, Raymond Camden wrote: So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- == = Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org \ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Announce: RIAForge
Ray, Do you have any plans to release the forge itself as a project? It looks like it makes use of many of your other projects, and the integrated product would probably make a pretty good project management/issue tracking app for many dev shops. My initial impression is a clean, uncluttered, easy to use app...good work! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257182 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 compare software
Also have a butchers at ApexSQL - quite nice though I think Redgate is the defacto standard, -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 18 October 2006 15:17 To: CF-Talk Subject: RE: SQL compare software Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). It still doesn't work for one of my tables, and I haven't really been using it in depth, but once my RedGate's Trial is over, I guess I'll have a tough decision to make. Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 11:47 PM To: CF-Talk Subject: SQL compare software Been using RedGate's Compare tools, and I must say, they really rock. However, for my limited home/freelance use, they are a little expensive ($295 license). Anyone ever use a similar tool that they really like that is a little cheaper? I may just go ahead and fork over the fee anyway, since it already has saved me a ton of time, but don't want to buy it just yet until I know that this is the best deal out there for this kind of software. Needs to be able to synch SQL Server 2000, 2005 DB's (MySQL would be cool too, but not a requirement) - both objects and data. Thanks, Ray -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.0.408 / Virus Database: 268.13.4/480 - Release Date: 10/17/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257183 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 compare software
Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). I'm using DB Explorer. It also is a lot cheaper and does both the schema and data compare and synchronize. I've run into a few bugs but nothing that was real major to work around. http://www.sliksoftware.co.nz/ Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Strange URL pointing to CFM page
Probably pointing to index.cfm inside the coupons directory. Or they could have the web server set to parse a file named coupons !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:01 AM To: CF-Talk Subject: Strange URL pointing to CFM page All, I've never seen this type of hyperlink before. It resolves to a cfm page. Is it pointing to a directory or a file? http://www.domainname.com/coupons?subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZX JAYXR0Lm5ldA== Thanks D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom C., There is nothing to be done another way, as the application pretty much does nothing. All it does is define the Application events and writes errors to file. That's it. I can't tell what to remove. I can't remove the OnError method, obviously, or I wouldn't be able to get at the errors. When I comment out every method BUT the OnError method, get: An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. The method 'onSessionEnd' could not be found in component Exception Type: Application Then, I think , ok maybe it needs to have the method defined, so then I put back in JUST the onSessionEnd method and run again. I get the same error: An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. But this time the detailed message is EMPTY STRING AND, the exception type has changed from application: Exception Type: Expression After fooling around, it seems if OnApplicationEnd or OnSessionEnd is NOT defined, they throw erorrs of type APPLICATION. However, if they are defined, they are throwing errors of type EXPRESSION. No idea what is going on. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? On Wednesday 18 October 2006 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Remove the offending method. What happens ? Could you do it another way ? -- Tom Chiverton Helping to heterogeneously drive professional markets ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
On Wednesday 18 October 2006 14:30, Ben Nadel wrote: I can't tell what to remove. I can't remove the OnError method, obviously, or I wouldn't be able to get at the errors. When I comment out every method BUT the OnError method, get: If you take out onError, do you get an error you can read ? -- Tom Chiverton Helping to simultaneously transition strategic IPOs 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Announce: RIAForge
Andy - some of these are fixed now. On 10/18/06, Andy Matthews [EMAIL PROTECTED] wrote: Ray... The site looks awesome and the idea is great! What a good way of putting forth Coldfusion mixed in with the other stuff that people are going to come looking for. A few suggestions: 1) At the bottom of each page is a disclaimer, but in IE the disclaimer pushes right against the browser chrome making it hard to read. I suggest putting a break or two after that to give it at least one full return of space. 2) Clicking the ColdFusion tag (and the other tabs I'm sure) displays a list of projects with HUGE headers, you're using H2s. I suggest styling them to appear smaller. They're way too large at the moment. 3) Most importantly, when I click the CF button, all of a sudden the page has about an extra 3 inches of horizontal scrolling. Nothing's there, but the page shows a scrollbar. It does it on the other tabs too even though there's nothing there. 4) Tables? The site looks so good that the source code should look the same. Do you need someone to help you convert this to a pure CSS design? I'd be happy to volunteer. 5) You might also consider adding InDesign and Illustrator buttons as those two are very popular as well. Everything else is great. This is really exciting. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Announce: RIAForge
Honestly I don't think the code is that exciting. It's really a BIG CMS built in Model-Glue. But sure - I can share it. However, it needs more polish first. Remind me in a month. :) On 10/18/06, Jim Wright [EMAIL PROTECTED] wrote: Ray, Do you have any plans to release the forge itself as a project? It looks like it makes use of many of your other projects, and the integrated product would probably make a pretty good project management/issue tracking app for many dev shops. My initial impression is a clean, uncluttered, easy to use app...good work! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom C., I can't Read the OnError since it is firing for onSessionEnd and OnApplicationEnd, which are not visible to the browser... However, I have noticed that when I pull out the OnError method, nothing get's written to the log files! What's up with that??? Shouldn't that be showing up in the Application.log? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:36 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? On Wednesday 18 October 2006 14:30, Ben Nadel wrote: I can't tell what to remove. I can't remove the OnError method, obviously, or I wouldn't be able to get at the errors. When I comment out every method BUT the OnError method, get: If you take out onError, do you get an error you can read ? -- Tom Chiverton Helping to simultaneously transition strategic IPOs 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Select distinct on multiple columns
I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. For example let's say the most recent 10 entries includes the search phrase 'foo' 3 times - if I selected TOP 10 I'd actually only have 8 unique results. I've tried using DISTINCT in various ways but, because I need the 'search_datetime' and 'search_page' columns in the select list, the 'foo' entries are all considered unique. So, I'm wondering if it's possible to get unique values for my search phrases but include the other column data? I'm stuck. Any ideas? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Announce: RIAForge
FYI... If you'd like a list of OS Flash projects, the following link has almost every one: http://osflash.org/ Cheers, !k -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 7:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
I can't Read the OnError since it is firing for onSessionEnd and OnApplicationEnd, which are not visible to the browser... However, I have noticed that when I pull out the OnError method, nothing get's written to the log files! What's up with that??? Shouldn't that be showing up in the Application.log? Do you have another error handler elsewhere that is catching things? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange URL pointing to CFM page
I've never seen this type of hyperlink before. It resolves to a cfm page. Is it pointing to a directory or a file? http://www.domainname.com/coupons?subscriberemail=Y29sZGZ1c2lv bi5kZXZlbG9wZXJAYXR0Lm5ldA== You can't tell, but it doesn't really matter. You can have whatever URLs you want going to whatever resources you want, with enough jiggering. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select distinct on multiple columns
Gareth Hughes wrote: I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. Maybe something like... SELECT TOP 10 search_criteria, search_page, max(search_datetime) AS latestdate FROM tblSearches GROUP BY search_criteria, search_page ORDER BY latestdate DESC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Select/combine two years
I wrote a search form to search for different years. I'm using cfloop and would like a user to be able to display different years in their search. So far it just shows one year at a time. I'm not a daily CF programmer so I'm a bit stick here. Any help appreciated. Robert O. Here is what I have: cfloop list=#form.year# index=i cfquery name=getlist dataSource=printprices SELECT * FROM purchases where year = '#i#' order by orderid desc /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select distinct on multiple columns
Create a view to combine all of your data and select a distinct search from the view. Teddy On 10/18/06, Gareth Hughes [EMAIL PROTECTED] wrote: I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. For example let's say the most recent 10 entries includes the search phrase 'foo' 3 times - if I selected TOP 10 I'd actually only have 8 unique results. I've tried using DISTINCT in various ways but, because I need the 'search_datetime' and 'search_page' columns in the select list, the 'foo' entries are all considered unique. So, I'm wondering if it's possible to get unique values for my search phrases but include the other column data? I'm stuck. Any ideas? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select/combine two years
From: Orlini, Robert [EMAIL PROTECTED] cfloop list=#form.year# index=i cfquery name=getlist dataSource=printprices SELECT * FROM purchases where year = '#i#' order by orderid desc /cfquery /cfloop cfquery name=getlist dataSource=printprices SELECT * FROM purchases WHERE year IN (cfqueryparam list=true value=#trim(form.year)# /) ORDER BY orderid desc /cfquery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select distinct on multiple columns
From: Gareth Hughes [EMAIL PROTECTED] I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. For example let's say the most recent 10 entries includes the search phrase 'foo' 3 times - if I selected TOP 10 I'd actually only have 8 unique results. I've tried using DISTINCT in various ways but, because I need the 'search_datetime' and 'search_page' columns in the select list, the 'foo' entries are all considered unique. So, I'm wondering if it's possible to get unique values for my search phrases but include the other column data? SELECT TOP 10 DT.search_criteria, ST.search_datetime, ST.search_page FROM ( SELECT DISTINCT search_criteria FROM search_table ) DT INNER JOIN search_table ST ON DT.search_criteria = ST.search_criteria ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Select/combine two years
May not be the elegant way but should work: Rearrange the order of processing: cfset lCount = 0 cfquery name=getlist dataSource=printprices SELECT * FROM purchases where cfloop list=#form.year# index=i cfset lCount = lCount+1 year = '#i#' cfif lCount NEQ ListLen(form.year)OR /cfif /cfloop order by orderid desc /cfquery -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:07 AM To: CF-Talk Subject: Select/combine two years I wrote a search form to search for different years. I'm using cfloop and would like a user to be able to display different years in their search. So far it just shows one year at a time. I'm not a daily CF programmer so I'm a bit stick here. Any help appreciated. Robert O. Here is what I have: cfloop list=#form.year# index=i cfquery name=getlist dataSource=printprices SELECT * FROM purchases where year = '#i#' order by orderid desc /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257199 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 compare software
Thanks for all the replies. Looks like I have to get crackin on these suggestions. -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:19 AM To: CF-Talk Subject: Re: SQL compare software Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). I'm using DB Explorer. It also is a lot cheaper and does both the schema and data compare and synchronize. I've run into a few bugs but nothing that was real major to work around. http://www.sliksoftware.co.nz/ Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Select distinct on multiple columns
I ditto the grouping method. Then you will have a distinct list of the keywords, and you can use your aggregates like count() to get the number of times it was searched for, and order by that desc. ~Brad -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:06 AM To: CF-Talk Subject: Re: Select distinct on multiple columns Gareth Hughes wrote: I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. Maybe something like... SELECT TOP 10 search_criteria, search_page, max(search_datetime) AS latestdate FROM tblSearches GROUP BY search_criteria, search_page ORDER BY latestdate DESC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Avalara Tax Web Service
Hi Jonese, I'm the web developer for Avalara.com, which happen to be a CF site. I've developed a CFX tag that allows me to easily call the AvaTax service for both address validation and sales tax rates. With the Java SDK and a little time you can make a single CFX tag that will return back a query of taxing rates/jurisdictions, etc. I have heard of people skipping the CFX step and loading the necessary classes at the CFM level via object creation / cfscript, but I have not tried that route. The CFX technique appeared more portable, maintainable, and structured. If you've signed up for or used AvaRates Now(tm), that's a CF application hitting the AvaTax web service in the background. This is availabe at www.freetaxrates.com. For additional help feel free to contact me at [EMAIL PROTECTED] Regards, Jon Has anyone implemented or used the Avalara Tax Web Service inside Coldfusion? jonese ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Announce: RIAForge
Not in IE6/PC. I can send you screencaps if you like. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:50 AM To: CF-Talk Subject: Re: Announce: RIAForge Andy - some of these are fixed now. On 10/18/06, Andy Matthews [EMAIL PROTECTED] wrote: Ray... The site looks awesome and the idea is great! What a good way of putting forth Coldfusion mixed in with the other stuff that people are going to come looking for. A few suggestions: 1) At the bottom of each page is a disclaimer, but in IE the disclaimer pushes right against the browser chrome making it hard to read. I suggest putting a break or two after that to give it at least one full return of space. 2) Clicking the ColdFusion tag (and the other tabs I'm sure) displays a list of projects with HUGE headers, you're using H2s. I suggest styling them to appear smaller. They're way too large at the moment. 3) Most importantly, when I click the CF button, all of a sudden the page has about an extra 3 inches of horizontal scrolling. Nothing's there, but the page shows a scrollbar. It does it on the other tabs too even though there's nothing there. 4) Tables? The site looks so good that the source code should look the same. Do you need someone to help you convert this to a pure CSS design? I'd be happy to volunteer. 5) You might also consider adding InDesign and Illustrator buttons as those two are very popular as well. Everything else is great. This is really exciting. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Announce: RIAForge So - I've been dropping hints left and right over the past few weeks about a secret project that I've been working on, and today I finally get to announce it. Please say hello to RIAForge.org. What is RIAForge? RIAForge is a place to host open source projects built with Adobe technologies - from ColdFusion applications to Photoshop plugins to Flash ActionScript libraries. What I really like about the site is that you can use it as much or as little as you want. As an open source author, you can simply list your project and point to the resources you already have. But what if you don't already have a web site? RIAForge offers: A unique project url: http://cfyahoo.riaforge.org/ File hosting Bug tracking Forums Blogging Basic stats Subversion access You can pick and choose which, if any, services you need. The site is still going under a bit of development, so you will definitely see a rough edge or two. (Firefox users, see PS at bottom.) But check it out - and if you have code to share, bPLEASE/b post your project. This site is Adobe supported and was the brainchild of Ben Forta. I did the primary development work with a lot of help and support from others, including Brian Rinaldi and Rob Gonda (SVN support is all from Rob, and will be a hosted project shortly.) p.s. Firefox users: You may see a white screen when saving edits to your project. This is a known issue and is being worked on. -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Dave, There is nothing else in the application happening, as far as I know. It's literally the Application.cfm file and the index file and all index is doing is dumping out APPLICATION. I just put a CFFILE/APPEND in every Application event handler and this is what I get: OnApplicationStart OnSessionStart OnRequestStart OnRequest OnRequestEnd OnSessionEnd : [ID - 43666] [TOKEN - 32723233] OnError : [Event Handler Exception. - Expression] An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. OnApplicationEnd : [NAME - App Event Testing] OnError : [Event Handler Exception. - Expression] An exception occurred when invoking a event handler method from Application.cfc The method name is: onApplicationEnd. As you can see, ALL of the events are firing. The OnsessionEnd fires and correctly references the Session scope info. The OnApplicationEnd fires and correctly references the Application scope info. But, both session and app end also generated an OnError event. Very strange. And still nothing showing up in the Application.log file or anything (even if I take out the OnError handler). .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:00 AM To: CF-Talk Subject: RE: PLEASE HELP! Why is this application.cfc erroring out? I can't Read the OnError since it is firing for onSessionEnd and OnApplicationEnd, which are not visible to the browser... However, I have noticed that when I pull out the OnError method, nothing get's written to the log files! What's up with that??? Shouldn't that be showing up in the Application.log? Do you have another error handler elsewhere that is catching things? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!
Am I the only one that thinks this way??? What a convoluted MESS it was to get CFMX7 running on my new Macbook Pro. Anyone know when the hell Adobe is going to fix this? I needed to install Macromedia J2EE Server version and use a special (thank GOD someone created) CFMX service loader and unloader. Otherwise there was HUGE workaround that was ugly to do to install it without the J2EE server. Anyone have any new and updated information? Like a universal installer that will work with the new version of Java?? The new Mac laptop is kick ass, but man was the CFinstall horrid. Jeff ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Announce: RIAForge
FYI, when I go to riaforge.org without the www it redirects you to flex.org. Don't know if anyone else has seen this. Mike ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
onRequestStart
In my onRequestStart a variable is set for request.user some processing is done and it never really needs to be updated again. Im trying to do cfif isdefined(request.user) to see if it has been set in the onrequeststart but it is never defined. As I write this I am guessing the request variable needs to be set each time in there to. First Page Load --- event.user is set Second Page --- check if event.user is set, but I guess it may not carry page to page? Not sure if I am being clear enough. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Announce: RIAForge
Dude-- me too!! It totally weirded me out. ~Brad -Original Message- From: Michael Sprague [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:36 AM To: CF-Talk Subject: Re: Announce: RIAForge FYI, when I go to riaforge.org without the www it redirects you to flex.org. Don't know if anyone else has seen this. Mike ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Announce: RIAForge
Yep, http://www.riaforge.org works, but http://riaforge.org is redirecting to http://flex.org which is actually hosted on the same box. It's on the list of things to fix. --- Ben -Original Message- From: Michael Sprague [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:36 AM To: CF-Talk Subject: Re: Announce: RIAForge FYI, when I go to riaforge.org without the www it redirects you to flex.org. Don't know if anyone else has seen this. Mike ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!
Well, considering that the MacTel shipped *after* CFMX7 it is not surprising that it is not properly supported yet. Heck, it is not even officially supported! We will be adding support for MacTel computers, stay tuned. --- Ben -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:31 AM To: CF-Talk Subject: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!! Am I the only one that thinks this way??? What a convoluted MESS it was to get CFMX7 running on my new Macbook Pro. Anyone know when the hell Adobe is going to fix this? I needed to install Macromedia J2EE Server version and use a special (thank GOD someone created) CFMX service loader and unloader. Otherwise there was HUGE workaround that was ugly to do to install it without the J2EE server. Anyone have any new and updated information? Like a universal installer that will work with the new version of Java?? The new Mac laptop is kick ass, but man was the CFinstall horrid. Jeff ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Announce: RIAForge
I said some, not all. ;) The disclaimer should be pushed over now. I don't quite think the project names are huge - but I'll consider making it smaller. 3) should be fixed. 4) Ugh. Well - I agree that Pure CSS is good, but every Pure CSS site I've worked on has had issues of one sort or another. I'm not convinced it is practical. That being said - there is a LOT of cleanup that needs to happn in the HTML. I definitely rushed it a bit. 5) I'm going to add those categories soon. On 10/18/06, Andy Matthews [EMAIL PROTECTED] wrote: Not in IE6/PC. I can send you screencaps if you like. 1) At the bottom of each page is a disclaimer, but in IE the disclaimer pushes right against the browser chrome making it hard to read. I suggest putting a break or two after that to give it at least one full return of space. 2) Clicking the ColdFusion tag (and the other tabs I'm sure) displays a list of projects with HUGE headers, you're using H2s. I suggest styling them to appear smaller. They're way too large at the moment. 3) Most importantly, when I click the CF button, all of a sudden the page has about an extra 3 inches of horizontal scrolling. Nothing's there, but the page shows a scrollbar. It does it on the other tabs too even though there's nothing there. 4) Tables? The site looks so good that the source code should look the same. Do you need someone to help you convert this to a pure CSS design? I'd be happy to volunteer. 5) You might also consider adding InDesign and Illustrator buttons as those two are very popular as well. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Opening PDF issue
Problem solved, turned out to be a dns caching issue on their network. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 9:44 AM To: CF-Talk Subject: Re: Opening PDF issue On Tuesday 17 October 2006 13:40, Scott Mulholland wrote: Anyone have any thoughts, I want to make sure I'm not missing something before I tell them to get their IT involved being that I feel it's more a hardware or network issue on their side. Normally it's fairly easy to assign blame when this happens - do you get a hit in your web server log when the broken people try ? -- Tom Chiverton Helping to enthusiastically aggregate advanced models 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select/combine two years
Worked real god Mike. Thanks! I'm going to make note of this for future use. That's how to learn this at times. Robert O. -Original Message- From: Mike Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:14 AM To: CF-Talk Subject:Re: Select/combine two years From: Orlini, Robert [EMAIL PROTECTED] cfloop list=#form.year# index=i cfquery name=getlist dataSource=printprices SELECT * FROM purchases where year = '#i#' order by orderid desc /cfquery /cfloop cfquery name=getlist dataSource=printprices SELECT * FROM purchases WHERE year IN (cfqueryparam list=true value=#trim(form.year)# /) ORDER BY orderid desc /cfquery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!
Jeff, Adobe offers a toll free service to assist any CF user with installation of CF on servers and laptops. They can instruct you on how to isntall J2EE on Windows and Mac. I have called them in the past and they are very knowledgeable and eager to help. I forgot the number, but it was not difficult to find. Teddy On 10/18/06, J W [EMAIL PROTECTED] wrote: Am I the only one that thinks this way??? What a convoluted MESS it was to get CFMX7 running on my new Macbook Pro. Anyone know when the hell Adobe is going to fix this? I needed to install Macromedia J2EE Server version and use a special (thank GOD someone created) CFMX service loader and unloader. Otherwise there was HUGE workaround that was ugly to do to install it without the J2EE server. Anyone have any new and updated information? Like a universal installer that will work with the new version of Java?? The new Mac laptop is kick ass, but man was the CFinstall horrid. Jeff ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: onRequestStart
You are correct, REQUEST is a single-page persisting object. In only lasts for the duration of the page request and then is destroyed. SESSION and APPLICATION are cross-page persisting scopes. You might want to try setting it into SESSION. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:37 AM To: CF-Talk Subject: onRequestStart In my onRequestStart a variable is set for request.user some processing is done and it never really needs to be updated again. Im trying to do cfif isdefined(request.user) to see if it has been set in the onrequeststart but it is never defined. As I write this I am guessing the request variable needs to be set each time in there to. First Page Load --- event.user is set Second Page --- check if event.user is set, but I guess it may not carry page to page? Not sure if I am being clear enough. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: onRequestStart
Request is not a scope that is available across multiple requests, it has to be recreated for each page request. Your looking for session or client. -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:37 AM To: CF-Talk Subject: onRequestStart In my onRequestStart a variable is set for request.user some processing is done and it never really needs to be updated again. Im trying to do cfif isdefined(request.user) to see if it has been set in the onrequeststart but it is never defined. As I write this I am guessing the request variable needs to be set each time in there to. First Page Load --- event.user is set Second Page --- check if event.user is set, but I guess it may not carry page to page? Not sure if I am being clear enough. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: onRequestStart
How often does the variable need to be updated? OnRequestStart will execute prior to every page request. If it less frequent than that, I would recommend putting it in the application start. You can use onRequestStart to check to see if the variable needs to be updated in the application scope. Teddy On 10/18/06, Brian Peddle [EMAIL PROTECTED] wrote: In my onRequestStart a variable is set for request.user some processing is done and it never really needs to be updated again. Im trying to do cfif isdefined(request.user) to see if it has been set in the onrequeststart but it is never defined. As I write this I am guessing the request variable needs to be set each time in there to. First Page Load --- event.user is set Second Page --- check if event.user is set, but I guess it may not carry page to page? Not sure if I am being clear enough. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Announce: RIAForge
-Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED] Announce: RIAForge sorting/grouping mechanism, and will figure that out when we have more projects (enough to warrant it). This seems like a good use for tags... Do you have any plans to release the forge itself as a project? It looks like it makes use of many of your other projects, and the I'll add my me too - we're currently evaluating Gforge but I'd love to learn more about the software behind this - as a CF shop - we'd be much more comfortable hacking on something that's familiar... Jim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select distinct on multiple columns
That's so simple compared to the things I'd been trying! It works perfectly and as Brad suggested I can easily get counts as well which is a major bonus. Many thanks Jim. Mike, I tried your suggestion but it didn't seem to produce the desired result. I'll tinker with it though to see what I can learn. Teddy, I'm not too familiar with views so my attempt produced incorrect results. As above though, I'll play with it to see what I can learn. Thanks for the help, its most appreciated. - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 18, 2006 4:05 PM Subject: Re: Select distinct on multiple columns Maybe something like... SELECT TOP 10 search_criteria, search_page, max(search_datetime) AS latestdate FROM tblSearches GROUP BY search_criteria, search_page ORDER BY latestdate DESC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange URL pointing to CFM page
All, I've never seen this type of hyperlink before. It resolves to a cfm page. Is it pointing to a directory or a file? http://www.domainname. com/coupons?subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZXJAYXR0Lm5ldA== It is possible to have IIS forward all 404 not found pages to a specified cfm page where you can parse the url and do with it what you wish. I've used this technique to produce rails style urls. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select/combine two years
You really shouldn't be looping over a query like this. Given the code provided by the other user, your final SQL might look like this: SELECT * FROM purchases WHERE year IN (2001,2004,2006) ORDER BY orderid desc That's what you're looking to accomplish. Now you just need to determine where the years are coming from and go from there. Assuming you have a form which allows you to enter a start and end year, then your SQL could look like this: SELECT * FROM purchases WHERE year BETWEEN '#FORM.start#' AND '#FORM.end#' ORDER BY orderid desc That would give you all records with years between the two provided. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:07 AM To: CF-Talk Subject: Select/combine two years I wrote a search form to search for different years. I'm using cfloop and would like a user to be able to display different years in their search. So far it just shows one year at a time. I'm not a daily CF programmer so I'm a bit stick here. Any help appreciated. Robert O. Here is what I have: cfloop list=#form.year# index=i cfquery name=getlist dataSource=printprices SELECT * FROM purchases where year = '#i#' order by orderid desc /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!
Yeah, it's pretty much a PIA to get going, but once you set it up and get it integrated with Apache, it's a very nice development environment. I used this reference and it made my life much easier: http:// webmages.com/cfmxIntelOSXguide.html If you want to run your development environment on Port 80, here's a good tutorial on setting up localhost subdomains in Apache: http://allforces.com/2005/08/23/wordpress-on-mac-subdomains/ Jon On Oct 18, 2006, at 11:30 AM, J W wrote: Am I the only one that thinks this way??? What a convoluted MESS it was to get CFMX7 running on my new Macbook Pro. Anyone know when the hell Adobe is going to fix this? I needed to install Macromedia J2EE Server version and use a special (thank GOD someone created) CFMX service loader and unloader. Otherwise there was HUGE workaround that was ugly to do to install it without the J2EE server. Anyone have any new and updated information? Like a universal installer that will work with the new version of Java?? The new Mac laptop is kick ass, but man was the CFinstall horrid. Jeff ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Action Query
Has anyone run a MS Access action query using a cfquery statement or any other way in CF? I need to somehow do a Make Table query in Access and would appreciate any Input to help figure this out if it is possible. Terry Troxel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfadmin 404 with apache
Doug - make sure you have the following in your httpd.conf file (in the conf directory of your apache directory): DirectoryIndex index.html index.shtml index.cfm You have to have that index.cfm on the end -- sometimes it gets stripped when you do a reinstall of CF. Don't know if that is what your issue is but it sounds like something I went through when I installed Apache. -- Josh - Original Message - From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 18, 2006 6:33 AM Subject: Re: cfadmin 404 with apache Can you send you JRun module block like I did earlier? That might help. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257224 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 compare software
Remember that the database is the most important part of the Web site, and you don't want to use any tool that may have some bug that could result in data loss. I believe that RedGate does a good job with QA testing and they have been supporting their software for a long time. That said, if anyone has experience with both RedGate SQL Compare and these alternatives, I would be curious if anything comes close. I use RedGate SQL Compare and SQL Data Compare all the time. Thank you, Mike Chabot On 10/18/06, Ray Champagne [EMAIL PROTECTED] wrote: Thanks for all the replies. Looks like I have to get crackin on these suggestions. -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:19 AM To: CF-Talk Subject: Re: SQL compare software Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). I'm using DB Explorer. It also is a lot cheaper and does both the schema and data compare and synchronize. I've run into a few bugs but nothing that was real major to work around. http://www.sliksoftware.co.nz/ Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257225 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 compare software
Mike Chabot wrote: Remember that the database is the most important part of the Web site, and you don't want to use any tool that may have some bug that could result in data loss. I believe that RedGate does a good job with QA testing and they have been supporting their software for a long time. I'd say this is some good advice...I've used the Red Gate tools for a couple of years now, and they have steadily improved their capabilities. I haven't seen any of the other tools match their usability or speed. And speaking of speed, always be careful with tools like this...they do have the ability to screw things up mighty fast if you don't watch what you are doing (ie, don't use them if sleep8 or beers1). ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to adjust recorded update to users timezone
I am looking for the best way to display a last update date based on the users preferred timezone. The datetime record is entered on the db using #now()# timestamp, which is of course, that is the server time. Every user has a preferred utc timezone on file. Unfortunately I am not using it. Any suggestions on where I should begin using GetTimeZoneInfo()? I would prefer not to use a javascript based solution that captures the users machine time. Thank you in advance. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Action Query
Terry Troxel wrote: Has anyone run a MS Access action query using a cfquery statement or any other way in CF? I need to somehow do a Make Table query in Access and would appreciate any Input to help figure this out if it is possible. Terry Troxel This may help you... http://support.microsoft.com/default.aspx?scid=kb;en-us;180841 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
equivalent of isDefined in ASP?
Anybody got an idea? Google isn't helping me out right now. (VB) Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Action Query
My bad. I obviously stated my problem wrong. I have a make table query defined already in access as MakeAR1 that takes a link to an existing table(Mas90 ODBC source named AR1_CustomerMaster) and creates a new Access table(AR1). I would like to somehow run that MakeAR1 query in Coldfusion rather then running Access from a batch file command that executes a the query. d: cd\program files\microsoft office\office msaccess d:\inetpub\databa~1\ARMASTER.mdb /x updateAR msaccess d:\inetpub\databa~1\ARMASTER.mdb /compact Exit Terry Troxel -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:27 AM To: CF-Talk Subject: Re: Action Query Terry Troxel wrote: Has anyone run a MS Access action query using a cfquery statement or any other way in CF? I need to somehow do a Make Table query in Access and would appreciate any Input to help figure this out if it is possible. Terry Troxel This may help you... http://support.microsoft.com/default.aspx?scid=kb;en-us;1808 41 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: equivalent of isDefined in ASP?
Do the equivalent of cfparam and set it to at the top. Then, just test to see what it's value is. variable Ray Champagne wrote: Anybody got an idea? Google isn't helping me out right now. (VB) Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: equivalent of isDefined in ASP?
Yea, that won't quite work, and what you're doing really isn't like cfparam, is it? Your suggestion is more like cfset. Here is my loose logic: If the variable is passed into the page, then use it's value, if not, set it to a default (like cfparam). If I explicitly set it to , then it will overwrite the variable being passed into the page...thus defeating the purpose. -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:45 PM To: CF-Talk Subject: Re: equivalent of isDefined in ASP? Importance: High Do the equivalent of cfparam and set it to at the top. Then, just test to see what it's value is. variable Ray Champagne wrote: Anybody got an idea? Google isn't helping me out right now. (VB) Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257232 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 Portal application
What makes a portal a portal? On 10/18/06, Teddy Payne [EMAIL PROTECTED] wrote: Ray Camden started a CF portal: http://www.coldfusionportal.org/ Teddy On 10/18/06, David Low [EMAIL PROTECTED] wrote: The beauty of CF has always been that you could do this very quickly yourself, without having to rely on buggy open-source projects which do more than most people would ever need, need some horrible PHP hacking to work properly, and look the same as 1001 other sites. There have been some CF versions of things like Nuke in the past but they've never really taken off. -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: 18 October 2006 11:03 To: CF-Talk Subject: Coldfusion Portal application Hi: There are many many portals made with PHP or .Net with many features but coldfusion portals look very basic. Is there any advanced CF protal out there? Or does any company/programmer team work on a CF portal that can compete with others? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: equivalent of isDefined in ASP?
Says alot about asp don't it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257234 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 to adjust recorded update to users timezone
I've wanted to make a post like this as well. need the same kinda solution. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257235 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 to adjust recorded update to users timezone
Use TimeZone.cfc at http://www.cfczone.org/cfcs/index.cfm I am looking for the best way to display a last update date based on the users preferred timezone. The datetime record is entered on the db using #now()# timestamp, which is of course, that is the server time. Every user has a preferred utc timezone on file. Unfortunately I am not using it. Any suggestions on where I should begin using GetTimeZoneInfo()? I would prefer not to use a javascript based solution that captures the users machine time. Thank you in advance. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Form Fields - storing unsaved values with a Page refresh
Can anyone help me with this? I have an onChange function that refreshes my coldfusion page and puts the new ID in the URL and then the SQL uses this ID to get certain information from the database. But when it refreshes with the new ID I lose any changed data in the form... any suggestions? My code goes kinda like this SCRIPT function filter(ID){ self.location.href=('index.cfm?ID=' + ID + ''); } /script cfquery SELECT FROM WHERE url.Id /cfquery form input type=text select onChange=filter(ID) option option /select /form Let me know if you need more details. Thanks so much for your time. I dont know where coders would be without forums. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257236 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 compare software
I have evaluated both ApexSQL and the RedGate Suite, I have found them both to be fast, reliable and easy to use. It just comes down to personal choice. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Mike Chabot To: CF-Talk Sent: Wed Oct 18 17:41:47 2006 Subject: Re: SQL compare software Remember that the database is the most important part of the Web site, and you don't want to use any tool that may have some bug that could result in data loss. I believe that RedGate does a good job with QA testing and they have been supporting their software for a long time. That said, if anyone has experience with both RedGate SQL Compare and these alternatives, I would be curious if anything comes close. I use RedGate SQL Compare and SQL Data Compare all the time. Thank you, Mike Chabot On 10/18/06, Ray Champagne [EMAIL PROTECTED] wrote: Thanks for all the replies. Looks like I have to get crackin on these suggestions. -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:19 AM To: CF-Talk Subject: Re: SQL compare software Try Teratrax SQL Compare. It just came out of beta. It's not as polished as Red-Gate's tools, but it's cheaper, and it's all one product (both schema and data compare). I'm using DB Explorer. It also is a lot cheaper and does both the schema and data compare and synchronize. I've run into a few bugs but nothing that was real major to work around. http://www.sliksoftware.co.nz/ Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4