RE: Regex help
Oops, you're right, this is what I should have said: [^c]at That matches any AT except CAT Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:25 PM To: CF-Talk Subject: Re: Regex help but not in CAT or CATalog or CATastrophe, etc. Neither tattoo, in [^cat] any of c, a or t may not precede at. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Homesite+ is ONLY available via a purchase of DWMX2004. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 04:47 To: CF-Talk Subject: Any way to get Homesite+ 5.5 without Dreamweaver? I own Studio MX, but I don't want to pay the $200 for the DW upgrade just for Homesite+. Is there any other option? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CMFX 6.1 much better
On Friday 12 Sep 2003 01:48 am, Brook Davies wrote: Have others also found better stability and speed with 6.1? Much faster (start-up and running). There is some evidence for it using more memory, but we changed more than just CF when we upgraded, so it's difficult for us to tell. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
If you own Studio MX you already have Homesite+ on the CD. Gotta dig down through the directories to find it, though, since MM prefers not to emphasize it. I didn't see anything new noted for Homesite+ that would warrant an upgrade. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 11:47 PM To: CF-Talk Subject: Any way to get Homesite+ 5.5 without Dreamweaver? I own Studio MX, but I don't want to pay the $200 for the DW upgrade just for Homesite+. Is there any other option? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: count and strip words from string.
just never f**ked with verity before. that's all. plus, this will end up in a shared hosting environment, and its not that complex of searching going on... that's all...but ill look into it, then also, look at looping through the list with space as the delimiter too!!! thanks guys! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:41 PM To: CF-Talk Subject: RE: count and strip words from string. cfset firstWordBreak = find(' ',search,1) cfif firstWordBreak cfset secondWordBreak = find(' ',search,firstWordBreak) /cfif cfif isDefined(secondWordBreak) and secondWordBreak cfset thirdWordBreak = find(' ',search,secondWordBreak) /cfif cfif isDefined(thirdWordBreak) and thirdWordBreak cfset fourthWordBreak = find(' ',search,thirdWordBreak) /cfif got it. thats what ill do, then mid the strings out, and build the dynamic query based on the presence of a 1st, 2nd, 3rd, or 4th word that may be there, should i make them separate by commas, since st. anne would return, st. joseph as well as many other possibilities, but if i make them separate by commas, then ill be good, cause they will be separating it themselves, and then i can just find commasmore reliable i think. huh? A few things: 1) You might be better off finding a different delimiter if you use your solution and are expecting search terms like St. Anne's. 2) You'd probably be better off treating the search terms as a list with a space as a delimiter instead of the find() function, i.e.: SELECT myColumn FROM myTable WHERE 0 = 0 cfloop list=#Form.searchTerms# index=term delimiter= AND myColumn LIKE %#term#% /cfloop This way you don't have to worry about how many search terms are entered, which your proposed solution seems to be (i.e., firstWordBreak, etc.) 3) Though not related to breaking up the search terms, why not use Verity? I think you'll find that the performance and accuracy of your results are enhanced by creating a collection that's populated by the results of a database query. Regards, Dave. _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: How Many CFMX Instances?
I'm curious Sean, can you tell me what type of box you are running? What JVM version are you using? - Alex -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:40 PM To: CF-Talk Subject: Re: How Many CFMX Instances? On Thursday, Sep 11, 2003, at 10:13 US/Pacific, Demarco, Alex wrote: What is a good rule of thumb as to how many jrun/CFMX instances you need? We have one instance that handles all our web sites, should I break it down and split the sites amongst several instances? It depends on a number of factors. If you want robustness (so one website doesn't trample on another) then yes, multiple instances will help - and give you a separate CF Admin for each instance. But you also need to consider the number of CPUs and the amount of RAM on your server (assuming you're talking about everything on one server). You'd need to experiment, performance-wise, but I'd say not to have more instances that you have CPUs for example. We have two instances (each with a 2-3Gb JVM heap) on each of our 8 CPU, 8Gb RAM servers but then we're running a very high traffic site (up to 20,000 concurrent sessions during peak traffic). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
error template snippet
hi there. just trying to throw together a good error template to email me when any page on our site experiences and error, does anyone have a good set of code that would include some good error information that I could snag? thanks. tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: error template snippet
Tony... do you mean something like below? This is the application.cfm code: !--- code for sending error message to web developer cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] This table code displays in the browser and the cfmail code below that is what comes to you TR TD class=menu1b CF logged the following error information: cfoutput#error.Diagnostics#/cfoutput cfoutput UL LIError occurred on B#DateFormat(Now())#/Bnbsp;nbsp;at b#TimeFormat(Now(),h:m tt)#/B LIIP Address of Page Viewer was b#CGI.Remote_Addr#/b LIViewers Browser: b#http_user_agent#/b LIPage error was generated: #error.template# LIURL Query string of Client's request: #error.QueryString# /UL/cfoutput /TD /TR cfmail from=[EMAIL PROTECTED] subject=Code Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:57 AM To: CF-Talk Subject: error template snippet hi there. just trying to throw together a good error template to email me when any page on our site experiences and error, does anyone have a good set of code that would include some good error information that I could snag? thanks. tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: error template snippet
This displays the error: !DOCTYPE HTML PUBLIC -//IETF//DTD HTML//EN HTML HEAD TITLETBP - Page Request Error/TITLE /HEAD pAn unexpected Page Request error has occurred. If the error persists, the following error details can provide the development team with valuable information to help identify and correct the condition which caused this error. We apologize for the inconvenience and solicit your help in improving the Tau Beta Pi Web-based application. Please provide a short description of what you were doing when the error occurred to the A HREF=mailto:#Error.Mailto#;Development Team/a. i[NOTE: This information can be sent to the development team by clicking on the EMAIL button located at the lower portion of the screen.]/i pbPage Request Error Details:/b/p small form action=ErrorScriptDispatcher.cfm method=post table width=100% border=1 cellpadding=2 tr th width=35%Attribute/th th width=65%Description/th /tr tr td width=35% align=right valign=middleDate Time:/td td width=65%#Error.DateTime#/td /tr tr td width=35% align=right valign=middleError Message:/td td width=65%textarea cols=50 rows=18 name=ErrorDiagnostics onFocus=this.blur();#Error.Diagnostics#/textarea/td /tr tr td width=35% align=right valign=middleError Page:/td td width=65%#Error.Template#/td /tr tr td width=35% align=right valign=middleReferring Page:/td td width=65%#Error.HTTPReferer#/td /tr tr td width=35% align=right valign=middleURL Params:/td td width=65%#Error.QueryString#/td /tr tr td width=35% align=right valign=middleClient Address:/td td width=65%#Error.RemoteAddress#/td /tr tr td width=35% align=right valign=middleClient Browser:/td td width=65%#Error.Browser#/td /tr /table table tr td colspan=2Your Email Address:nbsp;input type=text name=EmailAddress size=30 maxlength=50/td /tr tr tdinput type=submit name=btnAction value=EMail to Developers/td tdinput type=submit name=btnAction value=Continue/td /tr /table input type=hidden name=ErrorDateTime value=#Error.DateTime# input type=hidden name=ErrorTemplate value=#Error.Template# input type=hidden name=ErrorHTTPReferer value=#Error.HTTPReferer# input type=hidden name=ErrorQueryString value=#Error.QueryString# input type=hidden name=ErrorRemoteAddress value=#Error.RemoteAddress# input type=hidden name=ErrorBrowser value=#Error.Browser# input type=hidden name=FormID value=ErrorCFRequest /form /small /body /html And this is where it posts to email the message. ! Send e-mail notification of script error to developers - cfsetting enablecfoutputonly=Yes cfset LF=Chr(10) cfset TErrorDiagnostics=Form.ErrorDiagnostics cfset TErrorDiagnostics=ReplaceNoCase(Form.ErrorDiagnostics,/ppp,,ALL) cfset TErrorDiagnostics=ReplaceNoCase(TErrorDiagnostics,p ,LF,ALL) cfset TErrorDiagnostics=ReplaceNoCase(TErrorDiagnostics,p,LF,ALL) cfset TErrorPage=Form.ErrorTemplate cfset TErrorDateTime=ParseDateTime(Form.ErrorDateTime) cfmail to=#TMailAddr# from=#LCase(Variables.From)# subject=Scripting Logic Flaw A script error has occurred in the application on #DateFormat(TErrorDateTime,, D, )# at #TimeFormat(TErrorDateTime,h:mm:ss tt)#. The following provides details of the error message and information to aid in the correction of the error. Error Message: #TErrorDiagnostics# Error Page: #TErrorPage# Referring Page: #GetFileFromPath(Form.ErrorHTTPReferer)# URL Parameters: #Form.ErrorQueryString# Remote Address of WorkStation: #Form.ErrorRemoteAddress# Browser Type: #Form.ErrorBrowser# This error message has also been logged on the ColdFusion server and can be view by accessing the APPLICATION.LOG file on the server. /cfmail cfsetting enablecfoutputonly=No Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:57 AM To: CF-Talk Subject: error template snippet hi there. just trying to throw together a good error template to email me when any page on our site experiences and error, does anyone have a good set of code that would include some good error information that I could snag? thanks. tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: error template snippet
thank you tim, ray and qasimjust what I was looking for...i knew what to do, just needed something quick that was inclusive of all things I could catch, so I could catch an elusive little bugger this morning... thanks! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ray Thompson [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 9:06 AM To: CF-Talk Subject: RE: error template snippet This displays the error: !DOCTYPE HTML PUBLIC -//IETF//DTD HTML//EN HTML HEAD TITLETBP - Page Request Error/TITLE /HEAD pAn unexpected Page Request error has occurred. If the error persists, the following error details can provide the development team with valuable information to help identify and correct the condition which caused this error. We apologize for the inconvenience and solicit your help in improving the Tau Beta Pi Web-based application. Please provide a short description of what you were doing when the error occurred to the A HREF=mailto:#Error.Mailto#;Development Team/a. i[NOTE: This information can be sent to the development team by clicking on the EMAIL button located at the lower portion of the screen.]/i pbPage Request Error Details:/b/p small form action=ErrorScriptDispatcher.cfm method=post table width=100% border=1 cellpadding=2 tr th width=35%Attribute/th th width=65%Description/th /tr tr td width=35% align=right valign=middleDate Time:/td td width=65%#Error.DateTime#/td /tr tr td width=35% align=right valign=middleError Message:/td td width=65%textarea cols=50 rows=18 name=ErrorDiagnostics onFocus=this.blur();#Error.Diagnostics#/textarea/td /tr tr td width=35% align=right valign=middleError Page:/td td width=65%#Error.Template#/td /tr tr td width=35% align=right valign=middleReferring Page:/td td width=65%#Error.HTTPReferer#/td /tr tr td width=35% align=right valign=middleURL Params:/td td width=65%#Error.QueryString#/td /tr tr td width=35% align=right valign=middleClient Address:/td td width=65%#Error.RemoteAddress#/td /tr tr td width=35% align=right valign=middleClient Browser:/td td width=65%#Error.Browser#/td /tr /table table tr td colspan=2Your Email Address:nbsp;input type=text name=EmailAddress size=30 maxlength=50/td /tr tr tdinput type=submit name=btnAction value=EMail to Developers/td tdinput type=submit name=btnAction value=Continue/td /tr /table input type=hidden name=ErrorDateTime value=#Error.DateTime# input type=hidden name=ErrorTemplate value=#Error.Template# input type=hidden name=ErrorHTTPReferer value=#Error.HTTPReferer# input type=hidden name=ErrorQueryString value=#Error.QueryString# input type=hidden name=ErrorRemoteAddress value=#Error.RemoteAddress# input type=hidden name=ErrorBrowser value=#Error.Browser# input type=hidden name=FormID value=ErrorCFRequest /form /small /body /html And this is where it posts to email the message. ! Send e-mail notification of script error to developers - cfsetting enablecfoutputonly=Yes cfset LF=Chr(10) cfset TErrorDiagnostics=Form.ErrorDiagnostics cfset TErrorDiagnostics=ReplaceNoCase(Form.ErrorDiagnostics,/ppp,,A LL) cfset TErrorDiagnostics=ReplaceNoCase(TErrorDiagnostics,p ,LF,ALL) cfset TErrorDiagnostics=ReplaceNoCase(TErrorDiagnostics,p,LF,ALL) cfset TErrorPage=Form.ErrorTemplate cfset TErrorDateTime=ParseDateTime(Form.ErrorDateTime) cfmail to=#TMailAddr# from=#LCase(Variables.From)# subject=Scripting Logic Flaw A script error has occurred in the application on #DateFormat(TErrorDateTime,, D, )# at #TimeFormat(TErrorDateTime,h:mm:ss tt)#. The following provides details of the error message and information to aid in the correction of the error. Error Message: #TErrorDiagnostics# Error Page: #TErrorPage# Referring Page: #GetFileFromPath(Form.ErrorHTTPReferer)# URL Parameters: #Form.ErrorQueryString# Remote Address of WorkStation: #Form.ErrorRemoteAddress# Browser Type: #Form.ErrorBrowser# This error message has also been logged on the ColdFusion server and can be view by accessing the APPLICATION.LOG file on the server. /cfmail cfsetting enablecfoutputonly=No Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:57 AM To: CF-Talk Subject: error template snippet hi there. just trying to throw together a good error template to email me when any page on our site experiences and error, does anyone have a good set of code that would include some good error information that I could snag? thanks. tony tony weeg sr. web applications architect navtrak, inc. [EMAIL
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Repost: SQL Help
I might be wrong about what you're trying to get, but does this do it? Select SUM(Case ( Select etp.etprocedureid from eTransferProtocolLink etp Where etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End) as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid - Original Message - From: Patricia G. L. Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 5:20 PM Subject: Re: Repost: SQL Help You should be able to just do a MAX() around the Gift field (if I understand your intentions correctly, you need them around some other CASE statements as well) and add group by statements as needed. I tried to implement this 3 ways. 2 gave me errors (cause they're wrong) and 1 didn't give me the results I needed. Referring back to the shorter query I started out with: This: Select Max ( Case ( Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End ) as GIFT, et.caseid from etprocedure et Group by et.caseid Gives me this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery and so does: Select Case ( Select count( max( etp.etprocedureid) ) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid This gave me no error, but the results were still wrong: Select Case ( Select max(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Repost: SQL Help
Well, I don't need the Sum. And also this causes the error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery Thanks - Patti I might be wrong about what you're trying to get, but does this do it? Select SUM(Case ( Select etp.etprocedureid from eTransferProtocolLink etp Where etp.protocolid = 12 ) When then 0 When null then 0 Else 1 End) as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid - Original Message - From: Patricia G. L. Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 5:20 PM Subject: Re: Repost: SQL Help You should be able to just do a MAX() around the Gift field (if I understand your intentions correctly, you need them around some other CASE statements as well) and add group by statements as needed. I tried to implement this 3 ways. 2 gave me errors (cause they're wrong) and 1 didn't give me the results I needed. Referring back to the shorter query I started out with: This: Select Max ( Case ( Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When then 0 When null then 0 Else 1 End ) as GIFT, et.caseid from etprocedure et Group by et.caseid Gives me this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery and so does: Select Case ( Select count( max( etp.etprocedureid) ) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid This gave me no error, but the results were still wrong: Select Case ( Select max(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid = 12 ) When then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Cracking the RDS protocol?
But, aren't cgi variables determined by the server? These are internal apps, LDAP-protected to our employees. They're not designed to be portable. So, I know what server the app is running on. I know when and if a change is made to that server. I do a few apps where I query LDAP directly and use session variables to authenticate. But, for the majority of our apps that are protected to our employees, we just let LDAP take care of it, and I use their username to determine who they are for various functions. - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 7:48 PM Subject: Re: Cracking the RDS protocol? On Wednesday, Sep 10, 2003, at 05:42 US/Pacific, Deanna Schneider wrote: live (in our case development) server, where we rely on the cgi.remote_user variable to determine who someone is. Do you use LDAP to Unless you are writing code for a very specific environment where you can guarantee cgi.remote_user will work, I'd be very wary of relying on any CGI variables... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
oi Raymond!! RC If you closed HS+ 5.2 when a folder on a ColdFusion 5 server had focus, upon restarting the application, you would get an error stating that The system cannot find the file specified. This error no longer occurs (49117). ah. so that's what caused that. well hell, that is GOOD to know!!! -- Friday, September 12, 2003, 9:16:10 AM, you wrote: RC http://www.macromedia.com/support/documentation/en/homesite/55/releaseno RC tes_plus.html#new RC RC === RC Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RC (www.mindseye.com) RC Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RC Email: [EMAIL PROTECTED] RC Blog : www.camdenfamily.com/morpheus/blog RC Yahoo IM : morpheus RC My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. RC ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: error template snippet
CF_MailTemplateErrors is the best tag I've ever downloaded from the cf exchange. I use it on every site I do. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106viewName=Exchange%20Search%20Detailsauthorid=31287442page=0scrollPos=0subcatid=0snid=sn106itemnumber=0extid=1001525catid=0 -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 8:56:39 AM, you wrote: TW hi there. TW just trying to throw together a good error template to email me when any TW page on our site TW experiences and error, does anyone have a good set of code that would TW include some good error information TW that I could snag? TW thanks. TW tony TW tony weeg TW sr. web applications architect TW navtrak, inc. TW [EMAIL PROTECTED] TW www.navtrak.net TW office 410.548.2337 TW fax 410.860.2337 TW ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFERROR
I have setup cferror my application.cfm, with a type of REQUEST that calls a local CF page. For some reason, when a syntax error occurs, the tag does not get called, and the standard error code shows. Any Ideas? I have included the code. Code within application.cfm !---Request Error Code --- cferror type=Request template=error_request.cfm Error_Request.cfm !--- ---Page..: error_request.cfm ---Date..: 09/12/2003 ---Author: Dave Sueltenfuss ---Desc..: Displays error message ---Called By.: ---Calls.: ---Modifications *** --- --- EditorDate Description ---Dave Sueltenfuss 08/29/03 Created as new --- html !---Defines style sheet--- STYLE TYPE=text/css BODY { background : #7690C3; color:black; } A { color: #0017D1; font: Latha; } table{ background-color : #DDE5CD; } /STYLE body div align=center img src=images/hrmslogo.gif/br The system has encountered an error while processing this page.br Please go a href=javascript:history.go(-1)back/a, and try again.br If you still encounter this message, please contact a href=mailto:[EMAIL PROTECTED] onmouseover=window.status='';return trueHRMS Technical Support/a,br with the information located belowbr Error:#error.message#br Template:#error.template#br /div /body /html Thanks Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-836-2760 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Strange problem
Thanks for all your help. Since our IE had a defined proxy server it could get out to the web. I had to add the proxy server info and login to my cfinvoke and now I am all set. Thanks again KP -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:44 PM To: CF-Talk Subject: Re: Strange problem Sounds like your client (desktop) machine can hit port 80 on that system but your CF server (which is a different machine?) cannot? On Thursday, Sep 11, 2003, at 12:53 US/Pacific, Kris Pilles wrote: Its weird because I can resolve the URL in the vrowser but it seems like Coldfusion can not... Any ideas how to fix on the firewall side? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:46 PM To: CF-Talk Subject: RE: Strange problem What happens if you switch to CFHTTP and just dump out the results? == = = === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 1:44 PM To: CF-Talk Subject: RE: Strange problem Still erroriing out, has been doing so since yesturday... -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:42 PM To: CF-Talk Subject: RE: Strange problem Could it have been a temporary network problem? Can you try again? == == === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 1:10 PM To: CF-Talk Subject: RE: Strange problem I did also notice that it was not putting an entry in the webservices in the admin.. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:01 PM To: CF-Talk Subject: RE: Strange problem If you go to that machine, open a browser and enter the URL, does it work? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to 5.5. I think you only get it if you buy DWMX 2004. Don't quote me on that though. By the way, I've been playing some with DWMX 2004, and it's _really_ nice. The performance is much better (still not as good as HS+, but close) and I'm _almost_ considering switching for a little while. Almost. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
There isnt one AFAIK. 5.5 is only available via DWMX2004. -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:49 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I still find the startup time too slow and the way it 100% ties you to sites is a real PITA. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:57 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to 5.5. I think you only get it if you buy DWMX 2004. Don't quote me on that though. By the way, I've been playing some with DWMX 2004, and it's _really_ nice. The performance is much better (still not as good as HS+, but close) and I'm _almost_ considering switching for a little while. Almost. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I have to back Ray on this... I've been a die hard for CF Studio through all the past iterations of Dreamweaver (1.0 - MX) and MX 2004 is the best they've released. I'm now using it for all new development... I've committed myself to using it for a while. It really is a huge improvement over the base MX version. I still use HS+ for quick edits to files and such, but I haven't seen any reason to go back, yet. The CSS support alone makes it worth the upgrade for me. Jeff -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 6:57 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to 5.5. I think you only get it if you buy DWMX 2004. Don't quote me on that though. By the way, I've been playing some with DWMX 2004, and it's _really_ nice. The performance is much better (still not as good as HS+, but close) and I'm _almost_ considering switching for a little while. Almost. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? http://www.macromedia.com/support/documentation/en/homesite/55/releaseno tes_plus.html#new === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
oi Neil!! ummm i thought the new version of DWMX2k4 did NOT require sites? -- Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties you to sites RRNR is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to RRNR 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's _really_ RRNR nice. The performance is much better (still not as good as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR http://www.macromedia.com/support/documentation/en/homesite/55/releaseno RRNR tes_plus.html#new RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. RRNR ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Well, I dont believe that to be 100% true.Things like internal links etc, especially in design view require some form of mapping : its still nor a true 100% code editor. -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 15:13 To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? oi Neil!! ummm i thought the new version of DWMX2k4 did NOT require sites? -- Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties you to sites RRNR is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to RRNR 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's _really_ RRNR nice. The performance is much better (still not as good as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR http://www.macromedia.com/support/documentation/en/homesite/55/releaseno RRNR tes_plus.html#new RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. RRNR ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
DWMX2004 allows you to use stuff w/o sites, even remote stuff. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:00 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? I still find the startup time too slow and the way it 100% ties you to sites is a real PITA. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:57 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Cracking the RDS protocol?
Unless you are writing code for a very specific environment where you can guarantee cgi.remote_user will work, I'd be very wary of relying on any CGI variables... But, aren't cgi variables determined by the server? These are internal apps, LDAP-protected to our employees. They're not designed to be portable. So, I know what server the app is running on. I know when and if a change is made to that server. That would qualify as the very specific environment that Sean mentions, I think. So, go ahead and use them! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Yeah it does, but so did MX top a degree. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 15:17 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? DWMX2004 allows you to use stuff w/o sites, even remote stuff. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:00 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? I still find the startup time too slow and the way it 100% ties you to sites is a real PITA. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:57 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties you to sites RRNR is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 to RRNR 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's _really_ RRNR nice. The performance is much better (still not as good as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR http://www.macromedia.com/support/documentation/en/homesite/55/releaseno RRNR tes_plus.html#new RRNR RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. RRNR ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties RRNR you to sites is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 RRNR to 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's RRNR _really_ nice. The performance is much better (still not as good RRNR as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR http://www.macromedia.com/support/documentation/en/homesite/55/rel RRNR easeno RRNR tes_plus.html#new RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:20 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. RRNR
File Upload on MAC
So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Possible to change doc root for cfmx in a Cluster?
I have two instances on the same machine in our dev validation environment (clustered)...I'd like to configure each instance to point to the same directory outside of their default roots: {jrun}/servers/myinstance Rather than continually updating both sites. Anyone know how to do this? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Possible to change doc root for cfmx in a Cluster?
Cancel that! :) http://www.bpurcell.org/blog/index.cfm?mode=entryentry=937 Stace -Original Message- From: Stacy Young Sent: September 12, 2003 10:50 AM To: '[EMAIL PROTECTED]' Subject: Possible to change doc root for cfmx in a Cluster? I have two instances on the same machine in our dev validation environment (clustered)...I'd like to configure each instance to point to the same directory outside of their default roots: {jrun}/servers/myinstance Rather than continually updating both sites. Anyone know how to do this? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFERROR
Type request is only called if no other handler catches the error. In your case, you probably have an error page defined in the administrator. -Oorspronkelijk bericht- Van: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Verzonden: vr 12/09/2003 15:48 Aan: CF-Talk CC: Onderwerp: CFERROR I have setup cferror my application.cfm, with a type of REQUEST that calls a local CF page. For some reason, when a syntax error occurs, the tag does not get called, and the standard error code shows. Any Ideas? I have included the code. Code within application.cfm !---Request Error Code --- cferror type=Request template=error_request.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CFERROR
No, there is no error page defined in the CFAdmin. Dave -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:01 AM To: CF-Talk Subject: RE: CFERROR Type request is only called if no other handler catches the error. In your case, you probably have an error page defined in the administrator. -Oorspronkelijk bericht- Van: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Verzonden: vr 12/09/2003 15:48 Aan: CF-Talk CC: Onderwerp: CFERROR I have setup cferror my application.cfm, with a type of REQUEST that calls a local CF page. For some reason, when a syntax error occurs, the tag does not get called, and the standard error code shows. Any Ideas? I have included the code. Code within application.cfm !---Request Error Code --- cferror type=Request template=error_request.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
I jst have one thing to say... Everyone needs to remember that DW in all its forms was never and probably will not ever be touted as a code only editor. To expect to be is silly because MM is targeting multiple levels of abilities with one tool. Clint Tony Weeg wrote: I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
grouping a query on date
Hi, I have a table with a date/time field in an Access database. I want to have a query grouped on the date, with no regard to time, so that all records from the same day are grouped. I need a function (in SQL-Access) that will extract the day part of a date/time value, in a form that is still suitable for sorting, and I connot find any one. I tried LEFT(mydate, 8), but it generates a date like mm/dd/yy not suitable for sorting. What I need is the date of the day in true date format, not as a string. Any idea ? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Free Zip-latitude/longitude db
Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Free Zip-latitude/longitude db
Hi, Not free, but a $29 database. Looks like it has everything you'd need! Geoff B -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Free Zip-latitude/longitude db
Free may be the problem here. Have a quickl search of the archives as this one has come up at least 2-3 times in the last few months. The main site pointed to is something like www.zipinfo.com I beleivenot freebut reasonable. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:13 AM Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Free Zip-latitude/longitude db
http://www.kchost.net/media/ I exported mine from SQL to access ZipCode.mdb I got this from someone I think on this list about 6 months ago Rick -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: grouping a query on date
How about using the Year(), Month(), and Day() functions against the field and sort on those. Use year as the major, month as the intermediate, and day as the minor. Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:04 AM To: CF-Talk Subject: grouping a query on date Hi, I have a table with a date/time field in an Access database. I want to have a query grouped on the date, with no regard to time, so that all records from the same day are grouped. I need a function (in SQL-Access) that will extract the day part of a date/time value, in a form that is still suitable for sorting, and I connot find any one. I tried LEFT(mydate, 8), but it generates a date like mm/dd/yy not suitable for sorting. What I need is the date of the day in true date format, not as a string. Any idea ? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Free Zip-latitude/longitude db
Thanks. Exactly what I was looking for. -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:22 AM To: CF-Talk Subject: RE: Free Zip-latitude/longitude db http://www.kchost.net/media/ I exported mine from SQL to access ZipCode.mdb I got this from someone I think on this list about 6 months ago Rick -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Free Zip-latitude/longitude db
I used a db call FreeZip in the SMB code. Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Free Zip-latitude/longitude db
I'd agree that it is reasonable. There are even more cost effective services available. But until I know how much this feature will be used, I just don't want to spend the money. Thanks, Andy -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:21 AM To: CF-Talk Subject: Re: Free Zip-latitude/longitude db Free may be the problem here. Have a quickl search of the archives as this one has come up at least 2-3 times in the last few months. The main site pointed to is something like www.zipinfo.com I beleivenot freebut reasonable. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:13 AM Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Free Zip-latitude/longitude db
Hi, Forgot the link: http://www.zipcodedownload.com/ Geoff B -Original Message- From: Geoffrey Brown [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:21 AM To: CF-Talk Subject: RE: Free Zip-latitude/longitude db Hi, Not free, but a $29 database. Looks like it has everything you'd need! Geoff B -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
CF MX *right* book.
Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
A couple months before the Macromedia buyout of Allaire, I remember quite distinctly how Allaire put out a call for a new Product Manager - I was one of many who applied, and got to the pre-interview call stage, though I was passed over because my experience was heavy on the PROJECT management side and weak on the PRODUCT management side... THEN they radically raised the cost of Cold Fusion. - My interpretation was and still is that they did this as a pre-cursor to being audited for valuation by MM staff... the more you make on your products the more you'll be bought for. SO With the new fees, new license structure, forced purchase of DW to get HomeSite, it sounds like me they're positioning to eventually go from MacroMedia to MicroMedia when Microsoft makes the take-over move. At 10:28 AM 9/12/2003, you wrote: I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties RRNR you to sites is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 RRNR to 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's RRNR _really_ nice. The performance is much better (still not as good RRNR as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR http://www.macromedia.com/support/documentation/en/homesite/55/rel RRNR easeno RRNR tes_plus.html#new RRNR == RRNR ==
RE: CF MX *right* book.
uncle bens advanced macromedia cfmx app dev. is always a nice read! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:31 AM To: CF-Talk Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Free Zip-latitude/longitude db
Here is another zip code DB in text format. http://www.emerle.net/zipcode/ -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: File Upload on MAC
Hi, I haven't seen this problem. One thing I can tell you, especially with file uploads from Macs - always trim() your form fields. Macs seem to have a tendancy to insert line breaks at the end of form fields, which will certainly trash your attempt to upload a file. Geoff B -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:44 AM To: CF-Talk Subject: File Upload on MAC So what do you guys do about uploading files from a MAC? It seems that a MAC by default does not use file extension. So the CFFILE tag errors with the invalid MIME TYPE. Rick ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Crazy Query Data Droppings
I am quering a table during login, and setting a session scope with the results to allow the branding of each unique client to fly... I have two colors Main Color and Back color along with 12 other variables. When I output the session scope, *every field* is correct save those two variables. It *always* shows the last digit of the field. So then I output the query before setting the sesssion...same thing! Run the query directly in SQL, results are correct. So from SQL 2000 to CF 5 Pro is has decided religiously to punk those numbers. Anyone seen this and/or have an idea why this is occurring? Thanks! Eric ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
SO With the new fees, new license structure, forced purchase of DW to get HomeSite, it sounds like me they're positioning to eventually go from MacroMedia to MicroMedia when Microsoft makes the take-over move. Question - if you were forced to buy DWMX to get a new copy of Studio - why would this upset you if the cost was _less_ than it was before? It's obvious that Macromedia has NOT abandonded CFS (now HS+), so I'm a bit confused as to how anyone can complain. Should Macromedia start selling HS+ separately at the old price? ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re:calling all users of PostgreSQL on Windows
OK Bryan - You say you're an OSS newbie. That's fine; we all were once. Why Postgres? Personally, I virtually always use Postgres when I can, but there is another OSS database available (well, a bunch, but it often comes down to Postgres vs): mySQL. Up front, let me say that I'm not a fan of mySQL. To me, mySQL = Access; Postgres = Oracle (roughly, in both cases). But there are time when you just need Access. Here's a quick hit list of the pros and cons of each (my opinions, but backed by experience and reading): POSTGRES Pros: - Robust, scalable - ACID compliant - ANSI 92 compliant; contains a plethora of functions that make life easier - Fast (used to be a dog; in v7.1 and up, much faster - see Tim Perdue's articles as www.phpbuilder.net) - Excellent security model - Many tuning options POSTGRES Cons: - More complex (including set up) - Lack of GUI tools (I have not found one I like yet; I do all my PSQL from the command line) - Overkill in some cases - Just like you would not install Oracle for Bob's Pet Shoppe Web site, Postgres is sometimes unnecessary - Not really cross-platform yet. Hopefully in 2004. MYSQL Pros: - Trivial set up - Fast, at least for selects (main Web Server use) - Cross platform; runs well on *NIX or Windows. Big plus - Some good GUI tools out there (I use SQLYog; which I like a lot) - It's improving rapidly - the cons outlined below may go away shortly MYSQL Cons: - You can outgrow it quickly (the locking mechanism is particularily troublesome; can take a real performance hit on high-traffic sites - Weird, proprietary SQL - No subselects (my biggest complaint) - No transactions! (with the innoDB extension you can get transactions, but that's not currently a native solution, I believe) Like the platform wars, a lot of folks take the mySQL vs. Postgres comparison as a war; I view them as two tools. Pick the best one, but be aware of the costs/benefits of each. RE: Cost, as in $$: Yep, both are free, with some businesses offering bundles for cost (as RedHat does with Linux etc). One other note: For clients that are going to have a NON-dedicated server: It's almost impossible to find hosting for Postgres. Everyone has mySQL; very few with Postgres, and it's usually a managed business solution that is expensive. It's the chicken and the egg thing: Everyone has mySQL, so it's cheap; few have Postgres and it's not cheap, so they don't run it... ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: RE: CFERROR
Use type=exception - Original Message - From: Dave Sueltenfuss [EMAIL PROTECTED] Date: Friday, September 12, 2003 9:01 am Subject: RE: CFERROR No, there is no error page defined in the CFAdmin. Dave -Original Message- From: Pascal Peters [EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:01 AM To: CF-Talk Subject: RE: CFERROR Type request is only called if no other handler catches the error. In your case, you probably have an error page defined in the administrator. -Oorspronkelijk bericht- Van: Dave Sueltenfuss [EMAIL PROTECTED] Verzonden: vr 12/09/2003 15:48 Aan: CF-Talk CC: Onderwerp: CFERROR I have setup cferror my application.cfm, with a type of REQUEST that calls a local CF page. For some reason, when a syntax error occurs, the tag does not get called, and the standard error code shows. Any Ideas? I have included the code. Code within application.cfm !---Request Error Code --- cferror type=Request template=error_request.cfm ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
oh god...Microsoft makes the take-over move not again.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:34 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? A couple months before the Macromedia buyout of Allaire, I remember quite distinctly how Allaire put out a call for a new Product Manager - I was one of many who applied, and got to the pre-interview call stage, though I was passed over because my experience was heavy on the PROJECT management side and weak on the PRODUCT management side... THEN they radically raised the cost of Cold Fusion. - My interpretation was and still is that they did this as a pre-cursor to being audited for valuation by MM staff... the more you make on your products the more you'll be bought for. SO With the new fees, new license structure, forced purchase of DW to get HomeSite, it sounds like me they're positioning to eventually go from MacroMedia to MicroMedia when Microsoft makes the take-over move. At 10:28 AM 9/12/2003, you wrote: I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties RRNR you to sites is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 RRNR to 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's RRNR _really_ nice. The performance is much better (still not as good RRNR as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 14:16 To: CF-Talk Subject:
Re: Free Zip-latitude/longitude db
I have one on my server It's two tables - zip codes with Lat, Long, FIPS code, and a couple other fields I don't use, cross referenced to a FIPS table that pulls the State and County names. If my memory serves properly, it came from the Census bureau www.brionanet.com/ziplookup.mdb At 11:13 AM 9/12/2003, you wrote: Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re:grouping a query on date
Use the datePart function DatePart(m,date_added) will return the integer of the month in date_added (a datetime field) Use this to either construct a string that you then convert to a date, or three fields (day, month, year) that you apply three order criteria on. Make sense? Hi, I have a table with a date/time field in an Access database. I want to have a query grouped on the date, with no regard to time, so that all records from the same day are grouped. I need a function (in SQL-Access) that will extract the day part of a date/time value, in a form that is still suitable for sorting, and I connot find any one. I tried LEFT(mydate, 8), but it generates a date like mm/dd/yy not suitable for sorting. What I need is the date of the day in true date format, not as a string. Any idea ? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Re:calling all users of PostgreSQL on Windows
Thanks Lee Yup I already investigated the MySQL route.and simply puit...it ain't no database if it doesn't have SPs,views. triggers, proper referential integrity etc. ;-) If PostgreSQL isn't ready for Windows in production then I'm going the MSDE routeit will cost the client a couple extra bucks to get an MSDE licence via Office (or the other ways you can get through MS licensing issues). BTW this will be a co-lo box so at least the shared hosting available technology restrictions do not come into play ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:43 AM Subject: Re:calling all users of PostgreSQL on Windows OK Bryan - You say you're an OSS newbie. That's fine; we all were once. Why Postgres? Personally, I virtually always use Postgres when I can, but there is another OSS database available (well, a bunch, but it often comes down to Postgres vs): mySQL. Up front, let me say that I'm not a fan of mySQL. To me, mySQL = Access; Postgres = Oracle (roughly, in both cases). But there are time when you just need Access. Here's a quick hit list of the pros and cons of each (my opinions, but backed by experience and reading): POSTGRES Pros: - Robust, scalable - ACID compliant - ANSI 92 compliant; contains a plethora of functions that make life easier - Fast (used to be a dog; in v7.1 and up, much faster - see Tim Perdue's articles as www.phpbuilder.net) - Excellent security model - Many tuning options POSTGRES Cons: - More complex (including set up) - Lack of GUI tools (I have not found one I like yet; I do all my PSQL from the command line) - Overkill in some cases - Just like you would not install Oracle for Bob's Pet Shoppe Web site, Postgres is sometimes unnecessary - Not really cross-platform yet. Hopefully in 2004. MYSQL Pros: - Trivial set up - Fast, at least for selects (main Web Server use) - Cross platform; runs well on *NIX or Windows. Big plus - Some good GUI tools out there (I use SQLYog; which I like a lot) - It's improving rapidly - the cons outlined below may go away shortly MYSQL Cons: - You can outgrow it quickly (the locking mechanism is particularily troublesome; can take a real performance hit on high-traffic sites - Weird, proprietary SQL - No subselects (my biggest complaint) - No transactions! (with the innoDB extension you can get transactions, but that's not currently a native solution, I believe) Like the platform wars, a lot of folks take the mySQL vs. Postgres comparison as a war; I view them as two tools. Pick the best one, but be aware of the costs/benefits of each. RE: Cost, as in $$: Yep, both are free, with some businesses offering bundles for cost (as RedHat does with Linux etc). One other note: For clients that are going to have a NON-dedicated server: It's almost impossible to find hosting for Postgres. Everyone has mySQL; very few with Postgres, and it's usually a managed business solution that is expensive. It's the chicken and the egg thing: Everyone has mySQL, so it's cheap; few have Postgres and it's not cheap, so they don't run it... ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: grouping a query on date
Thanks, Ok, I manage to get this: SELECT year(moment) month(moment) day(moment) AS theDay, ... FROM theTable WHERE moment #createODBCDate(Now()-15)# GROUP BY year(moment) month(moment) day(moment), ... ORDER BY year(moment) month(moment) day(moment) DESC, ... And it almost works. The problem is that these functions generate only one digit values between 1 and 9, the the sorting is not correct. I get 200398 instead of 20030908. Is there a way I can format them on two digits? The problem also is to find where such functions are documented. - They are not in my SQL book (not standard functions). - They are not in the Access documentation, - I have 3 books about Access, including one well documented about SQL specificities in Access, but none of them says a sinble word about functions one may call in SQL ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
how about intellisense cfquery name=getSomeStuff datasource= (and here would be a list of available datasources you have set up) cfloop query = (and here would be a list of queries on this page.) that would be cool, save some typing. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:55 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
hehe here we go (strapping on my seat harness) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:51 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? oh god...Microsoft makes the take-over move not again.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:34 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? A couple months before the Macromedia buyout of Allaire, I remember quite distinctly how Allaire put out a call for a new Product Manager - I was one of many who applied, and got to the pre-interview call stage, though I was passed over because my experience was heavy on the PROJECT management side and weak on the PRODUCT management side... THEN they radically raised the cost of Cold Fusion. - My interpretation was and still is that they did this as a pre-cursor to being audited for valuation by MM staff... the more you make on your products the more you'll be bought for. SO With the new fees, new license structure, forced purchase of DW to get HomeSite, it sounds like me they're positioning to eventually go from MacroMedia to MicroMedia when Microsoft makes the take-over move. At 10:28 AM 9/12/2003, you wrote: I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties RRNR you to sites is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 RRNR to 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's RRNR _really_ nice. The performance is much better (still not as good RRNR as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Question - if you were forced to buy DWMX to get a new copy of Studio - why would this upset you if the cost was _less_ than it was before? It's obvious that Macromedia has NOT abandonded CFS (now HS+), so I'm a bit confused as to how anyone can complain. Should Macromedia start selling HS+ separately at the old price? ;) Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install,upgrade, and bug implications as well. Unbundled, stand-alone. Bundling and tying it in is what Microsoft has been doing since day one, and I've always disagreed with it, though I've adapted because it's the Operating system. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. Lost revenue to Macromedia, yet their own staff frankly admits that the CF community is by far a TINY fraction of their income base, so they really have no motive from their view to ever consider doing that which is purely in favor of the CF community in anything other than CF itself. SO - Why not bundle HomeSite with CF instead? Bet they never considered it! ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
staff frankly admits that the CF community is by far a TINY fraction of their income base Strange since CF is their #1 focus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:07 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Question - if you were forced to buy DWMX to get a new copy of Studio - why would this upset you if the cost was _less_ than it was before? It's obvious that Macromedia has NOT abandonded CFS (now HS+), so I'm a bit confused as to how anyone can complain. Should Macromedia start selling HS+ separately at the old price? ;) Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install,upgrade, and bug implications as well. Unbundled, stand-alone. Bundling and tying it in is what Microsoft has been doing since day one, and I've always disagreed with it, though I've adapted because it's the Operating system. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. Lost revenue to Macromedia, yet their own staff frankly admits that the CF community is by far a TINY fraction of their income base, so they really have no motive from their view to ever consider doing that which is purely in favor of the CF community in anything other than CF itself. SO - Why not bundle HomeSite with CF instead? Bet they never considered it! ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: grouping a query on date
Use this to either construct a string Same problem as with month(): how can I format the string to mmdd? If only I could say datepart('mm', moment), but it won't take it. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install,upgrade, and bug implications as well. You do realize that the installer is 100% separate? You can easily put HS+ on your system w/o installing DW. While the products _can_ talk to each other, you do not have to use their integration. I've used HS+ and never tied it to DW. Unbundled, stand-alone. Bundling and tying it in is what Microsoft has been doing since day one, and I've always disagreed with it, though I've adapted because it's the Operating system. MS bundles _different_ crap. Ie, they sell an OS, and bundle in a media player, etc. DW and HS+ are both IDEs. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. Lost revenue to Macromedia, yet their own staff frankly admits that the CF community is by far a TINY fraction of their income base, so they really have no motive from their view to ever consider doing that which is purely in favor of the CF community in anything other than CF itself. If you think MACR doesn't care about hard core coders, why would they update HS+? Oh, I get it. It's part of the evil plan of Let's update their favorite editor and sell it for a cheaper price plan. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: grouping a query on date
Hi, It's been a while since I did any work in access, but you can try something like this: ... ORDER BY year(moment) '/' month(moment) '/' day(moment) DESC, ... SQL Server / TSQL allows you to cast a date into a format without the time. Off the top of my head, I believe the format would be: ORDER BY cast(moment,102) Of course, access has some limitations in its tsql support. If you drop by the msdn.microsoft.com, they have complete documentation of what is and is not supported. Geoff B -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:56 AM To: CF-Talk Subject: Re: grouping a query on date Thanks, Ok, I manage to get this: SELECT year(moment) month(moment) day(moment) AS theDay, ... FROM theTable WHERE moment #createODBCDate(Now()-15)# GROUP BY year(moment) month(moment) day(moment), ... ORDER BY year(moment) month(moment) day(moment) DESC, ... And it almost works. The problem is that these functions generate only one digit values between 1 and 9, the the sorting is not correct. I get 200398 instead of 20030908. Is there a way I can format them on two digits? The problem also is to find where such functions are documented. - They are not in my SQL book (not standard functions). - They are not in the Access documentation, - I have 3 books about Access, including one well documented about SQL specificities in Access, but none of them says a sinble word about functions one may call in SQL ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install, upgrade, and bug implications as well. You don't need to install Dreamweaver MX to use Homesite+. You just need to buy it. They're separate executables on the CD. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. I really fail to comprehend this at all. You're not paying more than before, you're paying less. You get two products instead of one, but you can choose to use either or both. You want one of those products. Would it make you happy if MM changed the box so that it said Homesite+ (with Dreamweaver MX)? SO - Why not bundle HomeSite with CF instead? Bet they never considered it! Perhaps because there's typically more than one CF developer per CF server? Or maybe because the people who buy server applications aren't the same ones who buy development tools? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: error template snippet
thanks jon! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 9:50 AM To: CF-Talk Subject: Re: error template snippet CF_MailTemplateErrors is the best tag I've ever downloaded from the cf exchange. I use it on every site I do. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn10 6viewName=Exchange%20Search%20Detailsauthorid=31287442page=0scrollPo s=0subcatid=0snid=sn106itemnumber=0extid=1001525catid=0 -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 8:56:39 AM, you wrote: TW hi there. TW just trying to throw together a good error template to email me when TW any page on our site experiences and error, does anyone have a good TW set of code that would include some good error information TW that I could snag? TW thanks. TW tony TW tony weeg TW sr. web applications architect TW navtrak, inc. TW [EMAIL PROTECTED] TW www.navtrak.net TW office 410.548.2337 TW fax 410.860.2337 TW ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Relax guys... I was just tossing the old thread into the mix for the heck of it been awake about 50 hours and counting... At 12:04 PM 9/12/2003, you wrote: hehe here we go (strapping on my seat harness) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:51 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? oh god...Microsoft makes the take-over move not again.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:34 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? A couple months before the Macromedia buyout of Allaire, I remember quite distinctly how Allaire put out a call for a new Product Manager - I was one of many who applied, and got to the pre-interview call stage, though I was passed over because my experience was heavy on the PROJECT management side and weak on the PRODUCT management side... THEN they radically raised the cost of Cold Fusion. - My interpretation was and still is that they did this as a pre-cursor to being audited for valuation by MM staff... the more you make on your products the more you'll be bought for. SO With the new fees, new license structure, forced purchase of DW to get HomeSite, it sounds like me they're positioning to eventually go from MacroMedia to MicroMedia when Microsoft makes the take-over move. At 10:28 AM 9/12/2003, you wrote: I second that. im not sure where they are/were going with the whole dwmx thing, to be quite honest it doesn't seem to be much of a choice of an ide for most CODERS but what it does do, is give the *my cousin is a web master and is going to build me a web commerce email website thingie for $250 bucks* something to work with, really slow, and produce shit, so that we can get the takeover on those types of sites, and make money ,faster better and cheaper using a real ide, like hs+ or cfs. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:26 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Yeah...I tried DW 2004... I tried navigating to this file I wanted to open, but I think I fell asleep actually trying to navigate to it with that lovely little file pane, but not before being amazed by how much time must have been spent on all those really cute, Fisher-Price looking, rounded edges everywhere. After I passed out...my face must have hit the keyboard and it got uninstalled somehow. The DW UI team should really spend some time at a usability seminar or two imo. Just like on a web site, the content should be the focus, in an IDE, the code should be the focus. The code should not be overshadowed by all these bright colorful buttons, and other distractions. Of course...since the DW team is probably in San Francisco.oh nevermind. -- jon mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 9:59:36 AM, you wrote: RRNR I still find the startup time too slow and the way it 100% ties RRNR you to sites is a real PITA. RRNR -Original Message- RRNR From: Raymond Camden [mailto:[EMAIL PROTECTED] RRNR Sent: 12 September 2003 14:57 RRNR To: CF-Talk RRNR Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? RRNR Is it not on the CD? I _believe_ there is no free upgrade from 5.2 RRNR to 5.5. I think you only get it if you buy DWMX 2004. RRNR Don't quote me on that though. RRNR By the way, I've been playing some with DWMX 2004, and it's RRNR _really_ nice. The performance is much better (still not as good RRNR as HS+, but RRNR close) and I'm _almost_ considering switching for a little while. RRNR Almost. ;) RRNR == RRNR == RRNR === RRNR Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc RRNR (www.mindseye.com) RRNR Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) RRNR Email: [EMAIL PROTECTED] RRNR Blog : www.camdenfamily.com/morpheus/blog RRNR Yahoo IM : morpheus RRNR My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 7:49 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? OK I give up where exactly is the updater to upgrade Homesite+ 5.2 to 5.5? Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
SO - Why not bundle HomeSite with CF instead? Bet they never considered it! Perhaps because there's typically more than one CF developer per CF server? Or maybe because the people who buy server applications aren't the same ones who buy development tools? You hit the nail on the head, Dave. Most CF developers never see the CF server, never even see the CF Admin, and never even see the box that the product comes in. This is actually part of why we unbundled the language docs way back when, admins did not want them and developers who did want them did not get them. CF and the IDE are usually used by totally different audiences. Developers using an IDE should have access to a developer edition of CF, which is why they get just that. Truth is, if we bundled an IDE with CF Server, people would complain that they are being made to buy an IDE that they don't want. Damned if you do, damned if you don't. --- Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:23 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install, upgrade, and bug implications as well. You don't need to install Dreamweaver MX to use Homesite+. You just need to buy it. They're separate executables on the CD. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. I really fail to comprehend this at all. You're not paying more than before, you're paying less. You get two products instead of one, but you can choose to use either or both. You want one of those products. Would it make you happy if MM changed the box so that it said Homesite+ (with Dreamweaver MX)? SO - Why not bundle HomeSite with CF instead? Bet they never considered it! Perhaps because there's typically more than one CF developer per CF server? Or maybe because the people who buy server applications aren't the same ones who buy development tools? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
Question - if you were forced to buy DWMX to get a new copy of Studio - Actually, it is DWMX that should be a free gift for kids on the CF-Studio disk! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: grouping a query on date
ORDER BY year(moment) '/' month(moment) '/' day(moment) Thanks, but the '/' does not change anything in the sort. The problem is that I need the month and days as '09', not '9' ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
staff frankly admits that the CF community is by far a TINY fraction of their income base Strange since CF is their #1 focus. Yeah? With all the MX family, CF is just one to many... In an unofficial quote it was stated here on this list that apparently the vast majority of CF developers use the free version and therefor the revenue is not there. This came up during our recent pleas to optimize the CF Tag gallery for the CF community rather and the reason it is the way it is has to do with the fact that the majority of users are made up of all the MM client base, which dwarfs the CF base. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:07 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Question - if you were forced to buy DWMX to get a new copy of Studio - why would this upset you if the cost was _less_ than it was before? It's obvious that Macromedia has NOT abandonded CFS (now HS+), so I'm a bit confused as to how anyone can complain. Should Macromedia start selling HS+ separately at the old price? ;) Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install,upgrade, and bug implications as well. Unbundled, stand-alone. Bundling and tying it in is what Microsoft has been doing since day one, and I've always disagreed with it, though I've adapted because it's the Operating system. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. Lost revenue to Macromedia, yet their own staff frankly admits that the CF community is by far a TINY fraction of their income base, so they really have no motive from their view to ever consider doing that which is purely in favor of the CF community in anything other than CF itself. SO - Why not bundle HomeSite with CF instead? Bet they never considered it! ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I'd have to say Flash and all its related products are clumped into #1, then DW, then CF. At least from a revenue perspective. Stace -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 12:07 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? staff frankly admits that the CF community is by far a TINY fraction of their income base Strange since CF is their #1 focus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:07 To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Question - if you were forced to buy DWMX to get a new copy of Studio - why would this upset you if the cost was _less_ than it was before? It's obvious that Macromedia has NOT abandonded CFS (now HS+), so I'm a bit confused as to how anyone can complain. Should Macromedia start selling HS+ separately at the old price? ;) Actually, YES. I have no need, desire, or willingness to have software I'll never use on my computer. If it's tied together at the back end, then it's potentially going to have install,upgrade, and bug implications as well. Unbundled, stand-alone. Bundling and tying it in is what Microsoft has been doing since day one, and I've always disagreed with it, though I've adapted because it's the Operating system. Until MM unbundles HomeSite, I'll stay with my OLD stand-alone version, and not shell out any more money. Lost revenue to Macromedia, yet their own staff frankly admits that the CF community is by far a TINY fraction of their income base, so they really have no motive from their view to ever consider doing that which is purely in favor of the CF community in anything other than CF itself. SO - Why not bundle HomeSite with CF instead? Bet they never considered it! ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Nice! And how about popping up ur available methods on ur CFC too? :) cfset myCFC. show method list Stace -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 12:02 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? how about intellisense cfquery name=getSomeStuff datasource= (and here would be a list of available datasources you have set up) cfloop query = (and here would be a list of queries on this page.) that would be cool, save some typing. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:55 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
zackly! now we are talking!!! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:20 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Nice! And how about popping up ur available methods on ur CFC too? :) cfset myCFC. show method list Stace -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 12:02 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? how about intellisense cfquery name=getSomeStuff datasource= (and here would be a list of available datasources you have set up) cfloop query = (and here would be a list of queries on this page.) that would be cool, save some typing. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:55 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Oh yeah! A data aware IDE. I was begging for that back in CF Studio days. That level of integration is #1 on my feature list for any future IDE. --- Ben -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:20 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Nice! And how about popping up ur available methods on ur CFC too? :) cfset myCFC. show method list Stace -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 12:02 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? how about intellisense cfquery name=getSomeStuff datasource= (and here would be a list of available datasources you have set up) cfloop query = (and here would be a list of queries on this page.) that would be cool, save some typing. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:55 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
You do realize that the installer is 100% separate? You can easily put HS+ on your system w/o installing DW. While the products _can_ talk to each other, you do not have to use their integration. I've used HS+ and never tied it to DW. Right, but there's excess technology in there, and every upgrade requires waiting for a DW upgrade... and that pricing issue may be for now, what about down the road? Will it always be a separate install? Just my lone opinion here - if the team the evolves HS are the same team that evolves DW, it's two different mind sets being forced into one team, which dilutes the potential quality of where HS can go so to me that detracts from it even more. If they're a different team, then there's no real reason why they can't give it to us stand-alone. I mean I'm GIVING them a reason to make more money here by splitting it out. OR as stated already, bundle it with CF because I bet we're the majority of users right? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: grouping a query on date
Ok, convert character, add a leading zero, take the rightmost two characters. Ray Thompson Systems Administrator Tau Beta Pi Association www.tbp.org The Engineering Honor Society Integrity and Excellence in Engineering -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:18 PM To: CF-Talk Subject: Re: grouping a query on date ORDER BY year(moment) '/' month(moment) '/' day(moment) Thanks, but the '/' does not change anything in the sort. The problem is that I need the month and days as '09', not '9' ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: grouping a query on date: GOT IT!
format(moment, 'mmdd') will do the trick! But I'm kind of tired having to guess and shoot in the dark very time. WHERE are those ^%$ functions available in Access SQL documented? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: RE: CF MX *right* book.
Rob Brooks-Bilson has a book published by O'Reilley which has content for 6.1 release of CFMX. It is called Programming ColdFusion MX, 2nd Edition and you can find details here in our blog. http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID=20030818084646 Hth Kind Regards - Mike Brunt Original Message --- uncle bens advanced macromedia cfmx app dev. is always a nice read! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:31 AM To: CF-Talk Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
t'would be very cooli mean they do it in visualStudio so we should be able to cf studio/hs+ I meant ;) tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:30 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Oh yeah! A data aware IDE. I was begging for that back in CF Studio days. That level of integration is #1 on my feature list for any future IDE. --- Ben -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:20 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? Nice! And how about popping up ur available methods on ur CFC too? :) cfset myCFC. show method list Stace -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 12:02 PM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? how about intellisense cfquery name=getSomeStuff datasource= (and here would be a list of available datasources you have set up) cfloop query = (and here would be a list of queries on this page.) that would be cool, save some typing. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:55 AM To: CF-Talk Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? It's extremely difficult for a single product to be 'the best' at serving two distinct personas... All I want out of DW is a fast, solid code editing tool with some advanced text manipulation (like column selection etc), a service browser so I can drag and drop my methods, DB access panel w/ basic SQL queries (sometimes its convenient for quick lookups)...and a robust file browser...and up-to-date tag/function insight for CFMX and AS1 + AS2. Overall speed is essential...waiting 4-5 seconds for an IDE to refresh is absurd. I've been trying 2004 and right now...and at this point I'm less than enthusiastic. Sure there are other options but I'm not interested in having to hack and tweak another tool to get code insight etc. I think there's more than a legitimate demand for a streamlined coding IDE...just not sure why it hasn't been addressed yet. Stace -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: September 12, 2003 11:31 AM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? Not really. What is more cost effective, having one tool that multiple levels of people can use or multiple tools for different levels of people? We may not agree or like what MM is doing with DW, but I for one and happy with the new enhancements and I still use other editors for different purposes. Clint Claude Schneegans wrote: MM is targeting multiple levels of abilities with one tool. Now THIS is what is silly! ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Right, but there's excess technology in there, and every upgrade requires waiting for a DW upgrade... and that pricing issue may be for now, what about down the road? Will it always be a separate install? I'm not saying that I wouldn't mind it if MACR sold HS+ separately, but to be honest, I know diddly about product marketing, so I'm not going to pretend to know what makes sense for them. But how can you complain about pricing? _Any_ company can raise prices. Who knows what MACR will do? But it's not fair to hold a _potential_ price increase against them when you have no proof that one will ever come about. Just my lone opinion here - if the team the evolves HS are the same team that evolves DW, it's two different mind sets being forced into one team, which dilutes the potential quality of where HS can go so to me that detracts from it even more. Err, ok. Let's say you are right. Take a look at HS+ 5.5. Do you see a lack of quality? I don't. And as I have stated before, DWMX2004 is dang nice as well. To be honest, I don't care if its ONE guy doing all the work. I don't care if it's the guy's dog doing the work. All I care about is the finished product, and both kick major butt. That's not to say that MACR won't screw up, fire the wrong people (ahem), etc, but again, that's in the future. If they're a different team, then there's no real reason why they can't give it to us stand-alone. I mean I'm GIVING them a reason to make more money here by splitting it out. OR as stated already, bundle it with CF because I bet we're the majority of users right? I think Ben and others answered the bundle w/ server question already. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I do need to say thanks for reminding me about the ridiculousness of bundling HS with CF... been up too long to have thought that aspect through. All the other points regarding our desires for a lean high end coder stand though in terms of stand-alone, more focus on delivery of an evolving code writer that doesnt need to wait for the next DW deliverable, etc. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Right, but there's excess technology in there, and every upgrade requires waiting for a DW upgrade... and that pricing issue may be for now, what about down the road? Will it always be a separate install? Who knows what it'll be in the future? That's hardly an argument against the present. You're basically saying, I don't like the way things are now, because they might change later! You're free, now, not to install the excess technology and just install Homesite+. Just my lone opinion here - if the team the evolves HS are the same team that evolves DW, it's two different mind sets being forced into one team, which dilutes the potential quality of where HS can go so to me that detracts from it even more. I don't think that the people developing Homesite+ are the same people working on Dreamweaver MX. I wouldn't be surprised if Homesite+ is still written in Delphi. I do think that, in the future, Homesite+ may disappear, as Dreamweaver becomes more suitable for people currently using Homesite+. I don't think that's a bad thing, either. To me, it makes sense for Macromedia to build one really good editor rather than two mediocre ones. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
Friday, September 12, 2003, 12:26:07 PM, you wrote: RB Yeah? With all the MX family, CF is just one to many... In an RB unofficial quote it was stated here on this list that apparently the vast RB majority of CF developers use the free version and therefor the revenue is RB not there. This came up during our recent pleas to optimize the CF Tag RB gallery for the CF community rather and the reason it is the way it is has RB to do with the fact that the majority of users are made up of all the MM RB client base, which dwarfs the CF base. Speaking of the tag gallery If they aren't going to change the tag gallery, they should document and expose the web services that power it. Then we could put up our best efforts. Bet we could put those MM guys to shame! Heck...with the new editable DW start page stuff, we could presumably bring the tag gallery right into DW. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re:grouping a query on date
Well, it's a hack, but append a lead 0 to each element that needs it (month and day) and then take the RIGHT two chars to construct the field i.e. month = June (6) - 06 month = Dec (12) - 012 Do a right on each to get 06 and 12 That's why I hate Access. Just a pain in the ass for this stuff Use this to either construct a string Same problem as with month(): how can I format the string to mmdd? If only I could say datepart('mm', moment), but it won't take it. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
How to test for existence of XML element?
I'm trying to convert an XML document object to a query, but I'm getting stuck when I'm doing my QuerySetCell()s. If the element doesn't exist in that node, it bombs. However, I don't know how to test for the existence of the element, since isDefined() doesn't work on them (e.g. isDefined(MyNotes.Notes.Page[i].XmlAttributes['name'] bombs). Code sample follows. Thanks, Jamie cfscript // set notesAry to array of page elements (which are basically notes elements). notesAry = MyNotes.Notes.XmlChildren; // number of notes found in the file numOfNotes = ArrayLen(notesAry); // initialize notesQuery, which will contain notes data from xml file notesQuery = QueryNew(name, pageName, queryString, timeStamp, note); // add as many records to the notesQuery as there are notes in the xml file QueryAddRow(notesQuery, #numOfNotes#); /cfscript cfloop index=i from = 1 to = #numOfNotes# cfscript QuerySetCell(notesQuery, name, #MyNotes.Notes.Page[i].XmlAttributes['name']#, #i#); QuerySetCell(notesQuery, pageName, #MyNotes.Notes.Page[i].XmlAttributes['pageName']#, #i#); QuerySetCell(notesQuery, 'queryString', #MyNotes.Notes.Page[i].XmlAttributes[queryString]#, #i#); QuerySetCell(notesQuery, 'time_Stamp', #MyNotes.Notes.Page[i].XmlAttributes['time_Stamp']#, #i#); QuerySetCell(notesQuery, note, #MyNotes.Notes.Page[i].note.XmlText#, #i#); /cfscript ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
Speaking of the tag gallery If they aren't going to change the tag gallery, they should document and expose the web services that power it. Then we could put up our best efforts. Bet we could put those MM guys to shame! That's been requested for ages. Heck, I think I even offered to write one a while back. MACR, is there _any_ update on exposing the tag gallery to outsiders? Please? Pretty please? Etc? :) I'm almost tempted to replicate cflib.org for customtags. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Anyone know of a decent SQL ide?
Hi everyone, I am searching for a good SQL IDE. I currently use Query Analyzer, but would really like to find something a bit more robust. Since most of you guys also write SQL, I figured this would be the best place to ask. Anyone have any suggestions? Thanks in advance, Chris ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Anyone know of a decent SQL ide?
Chris, check out Aqua Data Studio, we have a link to it here. http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID=20030904071557 Kind Regards - Mike Brunt Original Message --- Hi everyone, I am searching for a good SQL IDE. I currently use Query Analyzer, but would really like to find something a bit more robust. Since most of you guys also write SQL, I figured this would be the best place to ask. Anyone have any suggestions? Thanks in advance, Chris ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: grouping a query on date
Ok, convert character, add a leading zero, take the rightmost two characters. Well, I know this, question was HOW? ;-) Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Anyone know of a decent SQL ide?
This was suggested yesterday, but try out AquaData Studio from www.aquafold.com - Jim Chris wrote: Hi everyone, I am searching for a good SQL IDE. I currently use Query Analyzer, but would really like to find something a bit more robust. Since most of you guys also write SQL, I figured this would be the best place to ask. Anyone have any suggestions? Thanks in advance, Chris ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Repost: SQL Help
Patricia G.L.Hall wrote: A patient's records are stored throughout many tables in the db. For the most part it is one row per patient record. Sometimes, in some tables, there can be multiple records per patient record. I have to flatten the patient record into a text file. The format the text file takes is spec'ed out by a third party and it is what I have to conform to. It turns out that this text file does not expect there to be multiple records per patient record... ever. So I have to query the database and deal with the cases where I have multiple records, but I have to flatten them into one. I can think of two ways to do it in theory... but I don't know how to make it work in SQL in practice. 1) Somehow cause the query to only return the Top 1 record per primary key. That wold be acceptable, but I have no idea if its a legal idea. 2) Somehow, through subqueries, aggregate the multiple values when they appear. That is what I was attempting to do in the question I originally posted. The Case statement works fine unless I hit a record with multiple rows. It returns both rows and that violates my parameters. For arguments sake, say you have 1 record for a patient, and 3 X-ray records for that patient because there are 3 X-ray photo's. Which X-ray record do you want to send to the third party? A random one, the last one? Or do you just want to send a boolean indicating there is a number of X-ray records? From your code I get the impression you just want to send the boolean, so I will give an example of that based on your original post: SELECT et.caseid, SUM( CASE etp.protocolid WHEN 12 THEN 1 ELSE 0 END ) FROM etprocedure et LEFT JOIN eTransferProtocolLink etp ON etp.etProcedureid = et.etProcedureid GROUP BY et.caseid (This will not really return a boolean, it will return the number of records but CF will be able to interpret it as a boolean. Use another CASE statement if you really want a boolean.) Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
I don't think that the people developing Homesite+ are the same people working on Dreamweaver MX. I wouldn't be surprised if Homesite+ is still written in Delphi. Yes, it's still written in Delphi. Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re:calling all users of PostgreSQL on Windows
Well, we're of the same mind. If you're tied to Windoze, MS SQL is a great database, for my money. Perfect? No. But what is? If you do get to running some Linux etc, Postgres rocks. Good luck. Thanks Lee Yup I already investigated the MySQL route.and simply puit...it ain't no database if it doesn't have SPs,views. triggers, proper referential integrity etc. ;-) If PostgreSQL isn't ready for Windows in production then I'm going the MSDE routeit will cost the client a couple extra bucks to get an MSDE licence via Office (or the other ways you can get through MS licensing issues). BTW this will be a co-lo box so at least the shared hosting available technology restrictions do not come into play ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:43 AM Subject: Re:calling all users of PostgreSQL on Windows OK Bryan - You say you're an OSS newbie. That's fine; we all were once. Why Postgres? Personally, I virtually always use Postgres when I can, but there is another OSS database available (well, a bunch, but it often comes down to Postgres vs): mySQL. Up front, let me say that I'm not a fan of mySQL. To me, mySQL = Access; Postgres = Oracle (roughly, in both cases). But there are time when you just need Access. Here's a quick hit list of the pros and cons of each (my opinions, but backed by experience and reading): POSTGRES Pros: - Robust, scalable - ACID compliant - ANSI 92 compliant; contains a plethora of functions that make life easier - Fast (used to be a dog; in v7.1 and up, much faster - see Tim Perdue's articles as www.phpbuilder.net) - Excellent security model - Many tuning options POSTGRES Cons: - More complex (including set up) - Lack of GUI tools (I have not found one I like yet; I do all my PSQL from the command line) - Overkill in some cases - Just like you would not install Oracle for Bob's Pet Shoppe Web site, Postgres is sometimes unnecessary - Not really cross-platform yet. Hopefully in 2004. MYSQL Pros: - Trivial set up - Fast, at least for selects (main Web Server use) - Cross platform; runs well on *NIX or Windows. Big plus - Some good GUI tools out there (I use SQLYog; which I like a lot) - It's improving rapidly - the cons outlined below may go away shortly MYSQL Cons: - You can outgrow it quickly (the locking mechanism is particularily troublesome; can take a real performance hit on high-traffic sites - Weird, proprietary SQL - No subselects (my biggest complaint) - No transactions! (with the innoDB extension you can get transactions, but that's not currently a native solution, I believe) Like the platform wars, a lot of folks take the mySQL vs. Postgres comparison as a war; I view them as two tools. Pick the best one, but be aware of the costs/benefits of each. RE: Cost, as in $$: Yep, both are free, with some businesses offering bundles for cost (as RedHat does with Linux etc). One other note: For clients that are going to have a NON-dedicated server: It's almost impossible to find hosting for Postgres. Everyone has mySQL; very few with Postgres, and it's usually a managed business solution that is expensive. It's the chicken and the egg thing: Everyone has mySQL, so it's cheap; few have Postgres and it's not cheap, so they don't run it... ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm