Re: Freelance Sites
this discussion list? e - Original Message - From: Brad Roberts To: CF-Talk Sent: Wednesday, October 01, 2003 9:24 AM Subject: OT: Freelance Sites Anyone have suggestions on freelance sites (like rentacoder.com)?I need a few websites designed, and didn't have much luck with rentacoder. If you've worked with someone who does nice design work (for a reasonable price), please send me their username and what site they're on (or how to get a hold of them). Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Windows 2000 or 2003 Server?
Hi all, I'm looking at setting up a new CFMX installation and have been given the option of Windows 2000 Server , or 2003 Server. Which would be the safer option? Not had having a great deal of experience with 2003 I was going to say 2000, but are there any significant advantages of 2003? thanks, bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2000 or 2003 Server?
Had the same choice last week and went for 2003, MX doesn't have any isues installing on either. We went for 2003 as it's supposedly more stable/secure and is likley to be supported longer. Craig. -Original Message- From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 09:01 To: CF-Talk Subject: Windows 2000 or 2003 Server? Hi all, I'm looking at setting up a new CFMX installation and have been given the option of Windows 2000 Server , or 2003 Server. Which would be the safer option? Not had having a great deal of experience with 2003 I was going to say 2000, but are there any significant advantages of 2003? thanks, bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compressing Javascript
Is it possible to gzip encode .js (as you can with text/html in http 1.1). That could be an option then. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Barney Boisvert [mailto:[EMAIL PROTECTED] | Sent: Wednesday, October 01, 2003 19:01 | To: CF-Talk | Subject: RE: Compressing _javascript_ | | | The simplest way is to just remove any whitespace that | follows a semicolon. | That's where most of the extra characters are, especially if | you have more | than a level or two of indentation.You can also remove | spaces from around | these characters: |= + - { } ( ) | | Those the the biggest culprits of white space in my JS, and | should let you | reduce stuff a bunch.Of course, if you still want readable | code, then | you'll want to be a little less complete with removing line breaks and | stuff, but if you're donig your stripping as part of the publishing | procedure, then you can just kill it all. | | barneyb | |-Original Message- | From: Brook Davies [mailto:[EMAIL PROTECTED] | Sent: Wednesday, October 01, 2003 8:30 AM | To: CF-Talk | Subject: Compressing _javascript_ | | |Does anyone know of a UDF or customtag that will compress | _javascript_ to | cut |down on file size? I know there are apps that do this, and | I would like to |include this functionality with some of our dynamically | generated pages. | |Thanks! | |Brook Davies | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2000 or 2003 Server?
As one who is running servers in both configurations, I strongly recommend the Win 2003 server. First, it does not have the vulnerabilities that are found in Win2k, and do not require patching anywhere near as often. Second, Most services are default to OFF, which requires a little more attention to configuration, but it is easier to leave unused or unneeded services turned off. Third, the interface is XP like and requires less technical expertise to set up and maintain, == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Ryan Sabir [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:00 AM Subject: Windows 2000 or 2003 Server? | Hi all, | | I'm looking at setting up a new CFMX installation and have been given | the option of Windows 2000 Server , or 2003 Server. | | Which would be the safer option? | | Not had having a great deal of experience with 2003 I was going to say | 2000, but are there any significant advantages of 2003? | | thanks, bye! | | --- | Ryan Sabir | Newgency Pty Ltd | 2a Broughton St | Paddington 2021 | Sydney, Australia | Ph (02) 9331 2133 | Fax (02) 9331 5199 | Mobile: 0411 512 454 | http://www.newgency.com/index.cfm?referer=rysig | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2000 or 2003 Server?
Personally I'd wait for SP1 before even thinking about it. However, if I had some wiggle room (meaning huge client wasn't going to kill me if the server had a few hiccups), and upgrading to 2003 in 6 months or so didn't look likely...it might be worth it to bite the bullet now rather than be stuck with old tech for the foreseeable future. I've been running Win2k3 on my home machine since release and have found two specific issues so far. IIS6 by default caches all static files for one minute, makes development a headache. The cache can be turned off in the metabase xml file. I haven't confirmed it on any other machine, but the ODBC Text Driver is broken on my machine. It just doesn't work. As far as advantages go, IIS6 is much faster than IIS5, and has lots of new features. Shadow Copy can be handy for quite a few things, and the new Task Manager is nice too. Just to name a few. The permissions system has had quite an overhaul in 2003...I think it is a lot more drastic than even the change from NT4 to 2000 was. I'd want to hit the books for a week or so just to understand the changes before implementing a production system on 2003. -- mailto:[EMAIL PROTECTED] Thursday, October 2, 2003, 4:00:55 AM, you wrote: RS Hi all, RS I'm looking at setting up a new CFMX installation and have been given RS the option of Windows 2000 Server , or 2003 Server. RS Which would be the safer option? RS Not had having a great deal of experience with 2003 I was going to say RS 2000, but are there any significant advantages of 2003? RS thanks, bye! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2000 or 2003 Server?
That is total crap as Win2003 is based on WinXP code which was based on Win2K code and as suchshares many of the same vulnerabilities. Do not consider installing Win2003 to be as safe as an unpatched Win2K installation. -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Thursday, 2 October 2003 6:35 PM To: CF-Talk Subject: Re: Windows 2000 or 2003 Server? As one who is running servers in both configurations, I strongly recommend the Win 2003 server. First, it does not have the vulnerabilities that are found in Win2k, and do not require patching anywhere near as often. Second, Most services are default to OFF, which requires a little more attention to configuration, but it is easier to leave unused or unneeded services turned off. Third, the interface is XP like and requires less technical expertise to set up and maintain, == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Ryan Sabir [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:00 AM Subject: Windows 2000 or 2003 Server? | Hi all, | | I'm looking at setting up a new CFMX installation and have been given | the option of Windows 2000 Server , or 2003 Server. | | Which would be the safer option? | | Not had having a great deal of experience with 2003 I was going to say | 2000, but are there any significant advantages of 2003? | | thanks, bye! | | --- | Ryan Sabir | Newgency Pty Ltd | 2a Broughton St | Paddington 2021 | Sydney, Australia | Ph (02) 9331 2133 | Fax (02) 9331 5199 | Mobile: 0411 512 454 | http://www.newgency.com/index.cfm?referer=rysig | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2000 or 2003 Server?
You are incorrect. Win2k supports IIS 5.0 and Win 2003 is IIS 6.0 There are patched vulnerabilities in IIS 5.0 which are not needed in Win2003 as the release is a redesign. For instance the ISAPIfilter URLScan is not needed on Win 2003. This is not to say that one should not keep up with patches as they are made available. CFMX 6.1 install on Win2003 is straight forward and relatively easy when compared to the CFMX 6.0 install on Win2k and appears to be more stable. IIS6.0 is faster than IIS 5.0 == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:45 AM Subject: RE: Windows 2000 or 2003 Server? | That is total crap as Win2003 is based on WinXP code which was based on | Win2K code and as suchshares many of the same vulnerabilities. | | Do not consider installing Win2003 to be as safe as an unpatched Win2K | installation. | | -Original Message- | From: Doug White [mailto:[EMAIL PROTECTED] | Sent: Thursday, 2 October 2003 6:35 PM | To: CF-Talk | Subject: Re: Windows 2000 or 2003 Server? | | | As one who is running servers in both configurations, I strongly recommend | the | Win 2003 server. | First, it does not have the vulnerabilities that are found in Win2k, and do | not | require patching anywhere near as often. | Second, Most services are default to OFF, which requires a little more | attention | to configuration, but it is easier to leave unused or unneeded services | turned | off. | Third, the interface is XP like and requires less technical expertise to set | up | and maintain, | | == | Stop spam on your domain, use our gateway! | For hosting solutions http://www.clickdoug.com | Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. | ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 | Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf | == | If you are not satisfied with my service, my job isn't done! | | - Original Message - | From: Ryan Sabir [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Thursday, October 02, 2003 3:00 AM | Subject: Windows 2000 or 2003 Server? | | | | Hi all, | | | | I'm looking at setting up a new CFMX installation and have been given | | the option of Windows 2000 Server , or 2003 Server. | | | | Which would be the safer option? | | | | Not had having a great deal of experience with 2003 I was going to say | | 2000, but are there any significant advantages of 2003? | | | | thanks, bye! | | | | --- | | Ryan Sabir | | Newgency Pty Ltd | | 2a Broughton St | | Paddington 2021 | | Sydney, Australia | | Ph (02) 9331 2133 | | Fax (02) 9331 5199 | | Mobile: 0411 512 454 | | http://www.newgency.com/index.cfm?referer=rysig | | | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2000 or 2003 Server?
I'm not sure how you can claim that Win 2003 do not require patching anywhere near as often - the bad boy has only been out for a few months!Give it a while - it may surprise us with many, many patches. ;^) That being said I've been impressed with 2003 myself - I'm running it now as a Virtual Server host (although the four servers that run inside it on VMs are all Windows 2000) and it's been rock solid for several months.Granted my use is somewhat light - but it is running a lot (two CFMX vms, one SQL Server 2000 vm and one CF 5.0 vm). I was going to use it for my personal web server, but all I had left was the web edition copy and it won't allow SQL server to be installed (I'm using the Enterprise edition on my VM host) so that scuttled that idea. I'm generally in the wait until the first service pack group myself - but the product is pretty sweet.I don't think that you'll go wrong by adopting it early. Jim Davis -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 4:35 AM To: CF-Talk Subject: Re: Windows 2000 or 2003 Server? As one who is running servers in both configurations, I strongly recommend the Win 2003 server. First, it does not have the vulnerabilities that are found in Win2k, and do not require patching anywhere near as often. Second, Most services are default to OFF, which requires a little more attention to configuration, but it is easier to leave unused or unneeded services turned off. Third, the interface is XP like and requires less technical expertise to set up and maintain, == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Ryan Sabir [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:00 AM Subject: Windows 2000 or 2003 Server? | Hi all, | | I'm looking at setting up a new CFMX installation and have been given | the option of Windows 2000 Server , or 2003 Server. | | Which would be the safer option? | | Not had having a great deal of experience with 2003 I was going to say | 2000, but are there any significant advantages of 2003? | | thanks, bye! | | --- | Ryan Sabir | Newgency Pty Ltd | 2a Broughton St | Paddington 2021 | Sydney, Australia | Ph (02) 9331 2133 | Fax (02) 9331 5199 | Mobile: 0411 512 454 | http://www.newgency.com/index.cfm?referer=rysig | | _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
coldfusion, apache and mod_rewrite
Hello! Using the popular mod_rewrite module I would like to offer simple entry points to our website like http://www.somewhere.com/go/customer1/ Internally, these requests should be redirected to http://www.somewhere.com/gocustomer.cfm?customer=customer1 Using mod_rewrite I have declared the following rule: RewriteRule ^/go/([a-z,A-Z,0-9,/]+)$ /gocustom.cfm?customer$1 The request are correcly forwarded - but the cfm file is not parsed by the coldfusion/jrun engine (apache delivers the whole source file). If I add a [R] to the rule, it works properly, but the client browser is really redirected to this location (what I want to avoid). Any hints? Software: ColdFusion MX 6.1; Apache 1.3.27 Best regards, Peter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: coldfusion, apache and mod_rewrite
On Thursday 02 Oct 2003 11:15 am, Peter Mayer wrote: Any hints? [P] ? -- Tom Chiverton 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application and Request scope
If I set my site wide DSN in the request scope will this be set every time a template is requested? Should I put the following code in application.cfm cfif Not IsDefined(Request.DSN) cfset Request.DSN =mydsn /cfif Can you access the Request scope from inside CFC's? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 01 October 2003 06:38 To: CF-Talk Subject: RE: Application and Request scope i won a free subscription to it, so price isnt an issue, lol personally, i think there is so great stuff in there. Sowhere I think you can do a trial run for free. Maybe I'm missing an inside joke. but that site just seems really pricey. $2.00 per article or $25.00 per month?That's more than I pay for ColdFusion hosting, my ISP, NetFlix, and all magazines.Even annually (with which you save $100) is 200 bucks a year. I don't mind paying for content but there seems to be a tremendous amount of free, quality content for this stuff.Is the content really that good? Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 9:00 PM To: CF-Talk Subject: RE: Application and Request scope good article today on locking at www.communitymx.com hint tony, haha! jk If you're on CFMX locking the Session/Application/Server scopes is not a stability issue as it was in 4.5/5.0 - but it is needed to prevent race conditions.However if you're using them in a read-only manner (and you're on MX) then locking isn't needed.In 4.5/5.0 locking is needed to maintain server integrity. For your App information - that's up to you.I might suggest, at the very least, using the REQUEST scope for them - that way they're available to all custom tags as well. Broadly speaking I generally recommend for users of MX to store this stuff in the Application scope: you can read the information with no locking and it uses less system resources under load.For CF 4.5/5.0 I would say use the Request scope: not having to lock everything is well worth the system resources used by repeating the information for each request. Jim Davis -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 9:37 AM To: CF-Talk Subject: RE: Application and Request scope I read this and now I am questioning my Application. I have been building a document Library system. The Application is shared between all the sites using it by Virtual Directories. I use session variables in the login.cfm to set the User information (GUID, Directory, IsAdmin) after login authentication. cfset SESSION.Auth = StructNew() cfset SESSION.Auth.Email = QryCheckLogin.Email cfset SESSION.Auth.UserGUID = QryCheckLogin.UserGUID cfset SESSION.Auth.LibraryGUID = QryCheckLogin.DocLibOwnerGUID cfset SESSION.Auth.IsLoggedIn = 'YES' cfset SESSION.Auth.Admin = '#App_Admin#' I am not locking the above. Everything seems to be working when multiple users are on the site (on the same website or sharing). I also named the Application dynamically by cfset AppName = #ListGetAt(CGI.HTTP_Host,'2','.')# cfapplication name=DocumentLibrary#AppName# sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,30,0)# applicationtimeout=#CreateTimeSpan(0,0,30,0)# Then I just use cfparam to set variables. cfparam name=App_DataSource default=TheDatabase cfparam name=App_DataBaseUser default=TheUserName!--- cfparam name=App_DataBasePass default=ThePassword cfparam name=App_Admin default=NO cfparam name=APP_Path default=#expandPath('../../../../')# cfparam name=APP_LibraryOwnerURL default=#CGI.HTTP_Host# Should I use Application Variables? Should I be locking them? Rick _ From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 7:36 AM To: CF-Talk I explain this pretty thoroughly in my guide to CF variables here: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/ V http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/ V%3e ariables/Index.cfm I'm sure other people have other (perhaps better) opinions but that should give you the skinny at least. Jim Davis -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:08 AM To: CF-Talk Subject: Application and Request scope I've been reading a few threads that advise on storing various things (that's a technical description btw) in the application or request scope. Why is this a good idea and what things should be stored there? Thanks! _ [Todays _ [Todays _ [Todays _ [Todays _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Tab Delimiter
Setting up CFHTTP, need to set the delimiter for a tab-separated file. What is the proper syntax for specifying the delimiter as tab-separated? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Tab Delimiter
#chr(9)# -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: donderdag 2 oktober 2003 13:48 To: CF-Talk Subject: Tab Delimiter Setting up CFHTTP, need to set the delimiter for a tab-separated file. What is the proper syntax for specifying the delimiter as tab-separated? Thanks, Mark _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Tab Delimiter
Thanks, Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 7:54 AM To: CF-Talk Subject: RE: Tab Delimiter #chr(9)# -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: donderdag 2 oktober 2003 13:48 To: CF-Talk Subject: Tab Delimiter Setting up CFHTTP, need to set the delimiter for a tab-separated file. What is the proper syntax for specifying the delimiter as tab-separated? Thanks, Mark _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Fwd: [Stats] Cold Fusion Talk List Stats; September 2003
Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: parsing txt file - seems unparsable
This might help. cfobject type=JAVA name=jFR class=java.io.FileReader action=""> cfset jFRobj = jFR.init('c:/somefile.txt') cfobject type=JAVA name=jBR class=java.io.BufferedReader action=""> cfset jBRobj = jBR.init(jFRobj) pre cfscript line = ; while ( len(line) ){ line = jBRobj.readLine(); writeoutput(line #chr(13)#); } jBRobj.close(); /cfscript /pre -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 01 October 2003 19:19 To: CF-Talk Subject: Re:parsing txt file - seems unparsable Is this CF 5 or earlier? If so, it is probably actually a NULL chr(0) character. Notepad will get rid of it when you open and save the file. CF 5 and earlier have trouble with strings containing NULLs, since it uses NULLs to mark the end of strings (I think). The data is still in the string, but all of the output string functions stop at that character. Solution? I don't have one. This is where Java and Custom Tags come in handy. Jerry Johnson [EMAIL PROTECTED] 10/01/03 02:08PM This sounds line an end -f line or carriage return character (or both) Do a replace of each [chr(10) chr(13); replace with white space or some marker for your illumination ~~~ or whatever ] in the variable and see if that helps. Are you SURE it's not in the database, as well? Just kicked down a line? If i open the file in notepad, then save it (without making any changes) it works fine. h...wonder how/if i can use cfexecute to have notepad open the file and then save it? other than that, i can't think of anything else... Steph _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] Cold Fusion Talk List Stats; September 2003
Still now seeing any stats Dave -Original Message- From: Bill Doerrfeld [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 8:29 AM To: CF-Talk Subject: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003 Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] Cold Fusion Talk List Stats; September 2003
Boy, either that line monster is a meanie or I'm going blind... i still don't see any stats Mitch Shameless plug for my wife's business: http://www.mygccandle.com/showmescents -Original Message- From: Bill Doerrfeld [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 7:29 AM To: CF-Talk Subject: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003 Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Column Attribute Problem in CFHTTP
I'm working to retrieve a tab-delimited list of members from a remote server using CFHTTP. Problem is, the source list headers in the first row have spaces in between some of the words.For example, first name.CFHTTP doesn't like column names with spaces.I've tried specifying my own columns, such as firstname, but then CFHTTP states that there are an incorrect number of columns in the row.I'm only testing with one column. Is there any work arounds, or is there another way to do this? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: parsing txt file - seems unparsable
This is better though. cfobject type=JAVA name=jFR class=java.io.FileReader action=""> cfset jFRobj = jFR.init('d:/sites/test/dates.cfm') cfobject type=JAVA name=jBR class=java.io.BufferedReader action=""> cfset jBRobj = jBR.init(jFRobj) pre cfscript line = ; while ( isDefined(line) ){ line = jBRobj.readLine(); if ( isDefined(line) ){ writeoutput(line #chr(13)#); } } jBRobj.close(); /cfscript /pre Seems as soon as we reach EOF, jBRobj.readLine() returns null (expected) and variable 'line' is no longer defined, quite handy in this case. -Original Message- From: Craig Dudley Sent: 02 October 2003 13:30 To: CF-Talk Subject: RE: parsing txt file - seems unparsable This might help. cfobject type=JAVA name=jFR class=java.io.FileReader action=""> cfset jFRobj = jFR.init('c:/somefile.txt') cfobject type=JAVA name=jBR class=java.io.BufferedReader action=""> cfset jBRobj = jBR.init(jFRobj) pre cfscript line = ; while ( len(line) ){ line = jBRobj.readLine(); writeoutput(line #chr(13)#); } jBRobj.close(); /cfscript /pre -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 01 October 2003 19:19 To: CF-Talk Subject: Re:parsing txt file - seems unparsable Is this CF 5 or earlier? If so, it is probably actually a NULL chr(0) character. Notepad will get rid of it when you open and save the file. CF 5 and earlier have trouble with strings containing NULLs, since it uses NULLs to mark the end of strings (I think). The data is still in the string, but all of the output string functions stop at that character. Solution? I don't have one. This is where Java and Custom Tags come in handy. Jerry Johnson [EMAIL PROTECTED] 10/01/03 02:08PM This sounds line an end -f line or carriage return character (or both) Do a replace of each [chr(10) chr(13); replace with white space or some marker for your illumination ~~~ or whatever ] in the variable and see if that helps. Are you SURE it's not in the database, as well? Just kicked down a line? If i open the file in notepad, then save it (without making any changes) it works fine. h...wonder how/if i can use cfexecute to have notepad open the file and then save it? other than that, i can't think of anything else... Steph _ [ Todays Threads _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2000 or 2003 Server?
That is total crap as Win2003 is based on WinXP code which was based on Win2K code and as such shares many of the same vulnerabilities. Do not consider installing Win2003 to be as safe as an unpatched Win2K installation. The default install of Windows Server 2003 is much safer in many respects than the default install of Windows 2000 Server. This is especially true with the Web Edition. As for reliability, it seems pretty good so far, and I've been recommending it for use with our clients for about a month. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion Scheduler problem
Is there anyway to tell when the next time ColdFusion thinks (used loosely) that a job is supposed to be run? My problem is that I have a job that has a start date of Aug 6, 2003 and is scheduled to run monthly at 4:00 am.It actually runs on the 1st of each month at 4:00 am. I also have another one that is scheduled with a start date of Aug 1, 2003 at 3:30 am.It actually runs on the 26th of the month at 3:30 am. Any suggestions would be appreciated. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] Cold Fusion Talk List Stats; September 2003
was it an attachment? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Bill Doerrfeld [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 8:29 AM To: CF-Talk Subject: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003 Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 'Enable Debugging' Option Turns Itself Off?
I've had the same problem, but it isn't consistent. Never been able to track it down to any one thing. Steve -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 5:35 PM To: CF-Talk Subject: 'Enable Debugging' Option Turns Itself Off? Hi all, Has anybody noticed CF Admin's 'Enable Debugging' option being turned off automatically by a server restart or other action?I've had a couple of mysterious instances here that I cannot explain, ever since updating to MX 6.1. Any feedback is appreciated. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com http://www.circa3k.com 775-832-2445 _ [ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003
Okay, I give up. There's something going on with this listserver which is preventing my post from going through in it's entirety. We have searchable archives for this list which also provide detailed stats on usage of this list. You can view reports on the number of posts by author and thread over any given date range. You can also view reports showing what people are searching for in the archives. Of course, you can search for any post by various criteria. Link to http://www.listsearch.com/coldfusion.lasso to access the archive. To generate the stats, click on the Browse tab. To learn more about this free service, click on the Info tab. Enjoy! At 5:29 AM -0700 10/2/03, Bill Doerrfeld wrote: Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?]
The bulk of the reasons that the default install is safer is that it turns off a lot of unnecessary services/etc. If you standard firewall/DMZ setup, you weren't really vunerable to external attack on those services anyhow. And running IIS Lockdown takes care of most of the rest... So Windows 2000 plus IIS lockdown tool vs Windows 2003 default install -- I'm kind of waiting for Windows 2003 SP1 :) Or running Apache on the windows box so the point becomes moot. But I *am* interested in folks impressions of the Windows 2003 web edition vs standard. I run a small farm of 1U web/cf (only) servers on Windows 2000 that connect to a more powerful db server (running MS-SQL 2000 and MySQL of all things under Win 2000). I was considering replacing Windows 2000 with RedHat Enterprise ES 2.1 (3.0 in mid Oct) based in part on cost considerations and in part on security issues. But the Web Edition of Windows 2003 is price competetive (both are less than $500/server) so I'm a little torn. Since all either runs is web/cf, Windows 2003 Web Edition becomes a sensible upgrade path. Thoughts? I know Dave said he had liked what he had seen with 2003 so far. Has anyone tried to license it? Seemed like OEM-only (eg buy a new server) was the idea when it was released. I've got it through MSDN so no prob testing it -- but curious about folks using it in produciton or getting ready to. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Dave Watts To: CF-Talk Sent: Thursday, October 02, 2003 9:03 AM Subject: RE: Windows 2000 or 2003 Server? That is total crap as Win2003 is based on WinXP code which was based on Win2K code and as such shares many of the same vulnerabilities. Do not consider installing Win2003 to be as safe as an unpatched Win2K installation. The default install of Windows Server 2003 is much safer in many respects than the default install of Windows 2000 Server. This is especially true with the Web Edition. As for reliability, it seems pretty good so far, and I've been recommending it for use with our clients for about a month. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2000 or 2003 Server?
Ah ha!This explains a problem I've been hitting my head over.Thanks! There are a number of subtle, yet significant differences between IIS 5 and 6 that I keep learning about and have made this Windows upgrade challenging.All in all, though,I like the lock everything down by default philosophy in W2K3 so far. [EMAIL PROTECTED] wrote: IIS6 by default caches all static files for one minute, makes development a headache. The cache can be turned off in the metabase xml file. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do I tell what fields are in my tables...
I have a site that I have no access to the DB from work (SQL Server).I am getting an error with one of my queries.It looks as if the field is either not there or spelled wrong.Can anyone tell me how I can tell what fields I have for a table? Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I tell what fields are in my tables...
you can use this: cfoutput#yourQuery.columnlist#/cfouput that will dump a list of your fields. Shawn Regan Head Applications Developer pacifictechnologysolutions -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 7:10 AM To: CF-Talk Subject: How do I tell what fields are in my tables... I have a site that I have no access to the DB from work (SQL Server).I am getting an error with one of my queries.It looks as if the field is either not there or spelled wrong.Can anyone tell me how I can tell what fields I have for a table? Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] _ [ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I tell what fields are in my tables...
I have a site that I have no access to the DB from work (SQL Server). I am getting an error with one of my queries.It looks as if the field is either not there or spelled wrong.Can anyone tell me how I can tell what fields I have for a table? Select column_name From information_schema.columns Where table_name='myTable' If you check the information_schema views, they allow you too check on all sorts of information HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
oi cf!! select top 10 * from table cfdump var=#query# or output query.columnlist -- Thursday, October 2, 2003, 10:09:51 AM, you wrote: ct I have a site that I have no access to the DB from work (SQL Server).I am getting an ct error with one of my queries.It looks as if the field is either not there or spelled wrong. ct Can anyone tell me how I can tell what fields I have for a table? ct Thanks, ct Brian Yager ct President - North Alabama ct Cold Fusion Users Group ct http://www.nacfug.com ct Ground-Based Midcourse Defense JPO ct Contractor CSC ct (256)313-9668 ct [EMAIL PROTECTED] ct [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 on Windows 2003 = Service Unavailable !!!
I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate. After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh install of CFMX 6.1. To my joy, the install was successful, but I received a message that the last step was to be done in CF Administrator. To my disbelief, when IE poped up, I got a Service Unavailable message. Not only could I not open CF Administrator, but every site on the server is down - even the ASP.NET sites. Every http request renders the same white screen with 'Service Unavailble' in bold black letters. I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Many thanks, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Odd Netscape/CFMX/IIS5 problem
Hi Folks, I'm wondering if anyone's run into this before.We recently upgraded one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.One of the applications running on the server uses a dynamically generated menu - lots of _javascript_.Everything seemed to be running fine - until one of our clients, who's still running Netscape 4.61 (yes, I know - but we can't do anything about it) reported some weird behaviour.It seems now that most of the time, all the text on the page is showing up as small, hollow rectangles. The text is actually still there - if you re-size the browser window, it'll show as regular text again... for a while.If you flip to another window, then flip back, it'll once again redraw as little rectangles. If you copy paste the 'rectangles' into something else, it shows up as the correct text.The links still work, etc - you just can't tell what anything says.I'll be happy to provide screen shots upon request. :) Has anyone run into anything like this before?Anyone have any suggestions? Thanks, Dirk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote: I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Is IIS running ? Are the CFMX adapters in place ? Are you fully patched with windowsupdate ... -- Tom Chiverton 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
Have you gone into IIS and made sure IIS is started? It's possible CFMX stopped the service and didn't start it back up. Go to Start Settings Control Panel then go into Administrative Tools and Open IIS. In there you can tell if the web server is stopped or not. Ben -Original Message- From: Sutton Yamanashi [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:34 AM To: CF-Talk Subject: CFMX 6.1 on Windows 2003 = Service Unavailable !!! I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate. After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh install of CFMX 6.1. To my joy, the install was successful, but I received a message that the last step was to be done in CF Administrator. To my disbelief, when IE poped up, I got a Service Unavailable message. Not only could I not open CF Administrator, but every site on the server is down - even the ASP.NET sites. Every http request renders the same white screen with 'Service Unavailble' in bold black letters. I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Many thanks, [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
1.Is IIS running ? 1A:The IIS Admin Service has status of 'started'. 2. Are the CFMX adapters in place ? 2A: I don't know.How do I determine this? 3. Are you fully patched with windowsupdate ... 3A:Yes. Thanks for you help! -sutton -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:36 AM To: CF-Talk Subject: Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!! On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote: I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Is IIS running ? Are the CFMX adapters in place ? Are you fully patched with windowsupdate ... -- Tom Chiverton 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.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
Check the front page of http://www.houseoffusion.com/ http://www.houseoffusion.com/Michael has some examples of problems and solutions. I had the same thing happen to me when we upgraded. I bet the solution might be something like this: ODBC services do not start - This is an interesting error that comes up once in a blue moon and probably has to do with a failure somewhere in the install. Basically, once you install and are about to go to the migration tool, you find that you just can't log into the admin to finish your migration. The reason is that the ODBC services are not running. You try to start them up and they fail. Why? Because there's an error in their config files. The fix is rather easy. Do a search on the string c:\program files\merant in the c:\cfusionmx\db directory (or whatever drive you've installed it on). You'll find 3 files. Replace that string (c:\program files\merant) with the string c:\cfusionmx\db (or whatever drive letter you have the cfusionmx directory in). After replacing all of the instances in all 3 files, start the services and finish migrating. Easy to do and only 3 people have ever reported seeing it. -Original Message- From: Sutton Yamanashi [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:34 AM To: CF-Talk Subject: CFMX 6.1 on Windows 2003 = Service Unavailable !!! I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate. After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh install of CFMX 6.1. To my joy, the install was successful, but I received a message that the last step was to be done in CF Administrator. To my disbelief, when IE poped up, I got a Service Unavailable message. Not only could I not open CF Administrator, but every site on the server is down - even the ASP.NET sites. Every http request renders the same white screen with 'Service Unavailble' in bold black letters. I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Many thanks, [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Montara Softwares Black Knight now available
Montara Software today announced the immediate availability of its newest product, Black Knight, a powerful new .NET runtime extension for Macromedias ColdFusion application servers. Black Knight, priced at $199.95 per server, is the first CF extension to allow ColdFusion developers to make full use of native .NET objects without having to use a Java-COM bridge to a COM wrapper around the objects. Press release: http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8f Product page: http://www.montarasoftware.com/go/9d58a59e-df02-1157-affb-e87c411e1c8f Tutorial: http://www.montarasoftware.com/go/47f9e1e1-f448-1157-affb-e87c411e1c8f Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I tell what fields are in my tables...
Where'd you find that out? I've been looking through CFWACK for the CFQUERY tag, and I can't find anything that mentions the columnlist variable for CFQuery. Is there also some other variable that stores field type? -Gel -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED] you can use this: cfoutput#yourQuery.columnlist#/cfouput that will dump a list of your fields. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?]
We are using Windows Server 2003 Web Edition with ColdFusion MX 6.1 standard; similar setup to you in that it is a 1U hooked up to a more powerful database server. Works really well and we like Win2k3 overall. Matt -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:02 AM To: CF-Talk Subject: Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?] The bulk of the reasons that the default install is safer is that it turns off a lot of unnecessary services/etc. If you standard firewall/DMZ setup, you weren't really vunerable to external attack on those services anyhow. And running IIS Lockdown takes care of most of the rest... So Windows 2000 plus IIS lockdown tool vs Windows 2003 default install -- I'm kind of waiting for Windows 2003 SP1 :) Or running Apache on the windows box so the point becomes moot. But I *am* interested in folks impressions of the Windows 2003 web edition vs standard. I run a small farm of 1U web/cf (only) servers on Windows 2000 that connect to a more powerful db server (running MS-SQL 2000 and MySQL of all things under Win 2000). I was considering replacing Windows 2000 with RedHat Enterprise ES 2.1 (3.0 in mid Oct) based in part on cost considerations and in part on security issues. But the Web Edition of Windows 2003 is price competetive (both are less than $500/server) so I'm a little torn. Since all either runs is web/cf, Windows 2003 Web Edition becomes a sensible upgrade path. Thoughts? I know Dave said he had liked what he had seen with 2003 so far. Has anyone tried to license it? Seemed like OEM-only (eg buy a new server) was the idea when it was released. I've got it through MSDN so no prob testing it -- but curious about folks using it in produciton or getting ready to. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Dave Watts To: CF-Talk Sent: Thursday, October 02, 2003 9:03 AM Subject: RE: Windows 2000 or 2003 Server? That is total crap as Win2003 is based on WinXP code which was based on Win2K code and as such shares many of the same vulnerabilities. Do not consider installing Win2003 to be as safe as an unpatched Win2K installation. The default install of Windows Server 2003 is much safer in many respects than the default install of Windows 2000 Server. This is especially true with the Web Edition. As for reliability, it seems pretty good so far, and I've been recommending it for use with our clients for about a month. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Softwares Black Knight now available
On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote: http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8f What horriable URL's -- Tom Chiverton 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd Netscape/CFMX/IIS5 problem
Dirk, On 10/2/2003 at 10:35, you wrote: DS I'm wondering if anyone's run into this before.We recently upgraded DS one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.One of the DS applications running on the server uses a dynamically generated menu - DS lots of _javascript_.Everything seemed to be running fine - until one of DS our clients, who's still running Netscape 4.61 (yes, I know - but we DS can't do anything about it) reported some weird behaviour.It seems now DS that most of the time, all the text on the page is showing up as small, DS hollow rectangles. DS The text is actually still there - if you re-size the browser window, DS it'll show as regular text again... for a while.If you flip to another DS window, then flip back, it'll once again redraw as little rectangles. DS If you copy paste the 'rectangles' into something else, it shows up as DS the correct text.The links still work, etc - you just can't tell what DS anything says.I'll be happy to provide screen shots upon request. :) Are you using CSS to format the links? I've run into display issues with older NN versions as well, specifically when using border formatting on buttons or form fields--buttons still appear without formatting, but have a rectangle below them; form fields tend to disappear and get ignored by the form processor (though they are in the browser source). If CSS is the culprit, I would say that the work around is to either dumb down your CSS, or uses a browser sniffer and serve up different style sheets accordingly. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
I checked it out as you suggested.It appears to be running.In Services, the IIS Admin Service has status of 'started'.Isn't this the same thing? Thanks! -sutton -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:34 AM To: CF-Talk Subject: RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!! Have you gone into IIS and made sure IIS is started? It's possible CFMX stopped the service and didn't start it back up. Go to Start Settings Control Panel then go into Administrative Tools and Open IIS. In there you can tell if the web server is stopped or not. Ben -Original Message- From: Sutton Yamanashi [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:34 AM To: CF-Talk Subject: CFMX 6.1 on Windows 2003 = Service Unavailable !!! I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate. After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh install of CFMX 6.1. To my joy, the install was successful, but I received a message that the last step was to be done in CF Administrator. To my disbelief, when IE poped up, I got a Service Unavailable message. Not only could I not open CF Administrator, but every site on the server is down - even the ASP.NET sites. Every http request renders the same white screen with 'Service Unavailble' in bold black letters. I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Many thanks, [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
IIS's service name is World Wide Web Publishing Service, the admin service is somethgin different. -Original Message- From: Sutton Yamanashi [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 15:46 To: CF-Talk Subject: RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!! 1.Is IIS running ? 1A:The IIS Admin Service has status of 'started'. 2. Are the CFMX adapters in place ? 2A: I don't know.How do I determine this? 3. Are you fully patched with windowsupdate ... 3A:Yes. Thanks for you help! -sutton -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:36 AM To: CF-Talk Subject: Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!! On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote: I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. Is IIS running ? Are the CFMX adapters in place ? Are you fully patched with windowsupdate ... -- Tom Chiverton 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.*** _ _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Softwares Black Knight now a vailable
Is that something that really concerns you? -Raymond Camden -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 2 Oct 2003 15:49:55 +0100 On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote: http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8f What horriable URL's -- Tom Chiverton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?]
From what I have been told from a Microsoft Rep if you are an Internet service provider (WebHost) you are supposed to be running Web Addition. This is because it is a stripped down version and does not require any CALs. The full version will require CALs for all users accessing the server including website visitors. I think that is going to be the hardest to enforce as I still haven't seen anyone running Web Addition but all of them host. The best thing I have seen is the SPLA from MS. You can get a license for Web Addition for around $25/Month per CPU that includes the full support package as well. SQL Server for around $120 per CPU. (Prices are from my corrupted memory but I do have the price list) To be in the SPLA you must employ 2 MCP's. You cab also join the SPLA Light and get a 6 month window to get the 2 MCP's. Rick _ From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:02 AM To: CF-Talk The bulk of the reasons that the default install is safer is that it turns off a lot of unnecessary services/etc. If you standard firewall/DMZ setup, you weren't really vunerable to external attack on those services anyhow. And running IIS Lockdown takes care of most of the rest... So Windows 2000 plus IIS lockdown tool vs Windows 2003 default install -- I'm kind of waiting for Windows 2003 SP1 :) Or running Apache on the windows box so the point becomes moot. But I *am* interested in folks impressions of the Windows 2003 web edition vs standard. I run a small farm of 1U web/cf (only) servers on Windows 2000 that connect to a more powerful db server (running MS-SQL 2000 and MySQL of all things under Win 2000). I was considering replacing Windows 2000 with RedHat Enterprise ES 2.1 (3.0 in mid Oct) based in part on cost considerations and in part on security issues. But the Web Edition of Windows 2003 is price competetive (both are less than $500/server) so I'm a little torn. Since all either runs is web/cf, Windows 2003 Web Edition becomes a sensible upgrade path. Thoughts? I know Dave said he had liked what he had seen with 2003 so far. Has anyone tried to license it? Seemed like OEM-only (eg buy a new server) was the idea when it was released. I've got it through MSDN so no prob testing it -- but curious about folks using it in produciton or getting ready to. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Dave Watts To: CF-Talk Sent: Thursday, October 02, 2003 9:03 AM Subject: RE: Windows 2000 or 2003 Server? That is total crap as Win2003 is based on WinXP code which was based on Win2K code and as such shares many of the same vulnerabilities. Do not consider installing Win2003 to be as safe as an unpatched Win2K installation. The default install of Windows Server 2003 is much safer in many respects than the default install of Windows 2000 Server. This is especially true with the Web Edition. As for reliability, it seems pretty good so far, and I've been recommending it for use with our clients for about a month. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
After the install, make sure that both Web publishing and ColdFusion server is running if both are running, then open administrator, and it will then complete the Jrun connectors, etc. The service unavailable message is due to one of the services not running. This is a issue with CFMX 6.1 relating to timeouts on a fairly heavily loaded server. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Sutton Yamanashi [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:33 AM Subject: CFMX 6.1 on Windows 2003 = Service Unavailable !!! | I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate. | | After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh install of CFMX 6.1. To my joy, the install was successful, but I received a message that the last step was to be done in CF Administrator. To my disbelief, when IE poped up, I got a Service Unavailable message. Not only could I not open CF Administrator, but every site on the server is down - even the ASP.NET sites. Every http request renders the same white screen with 'Service Unavailble' in bold black letters. | | I don't know how to fix this. I am dead in the water until I figure this out. I am trying to research the error message, but can't find the answer. If you can, please help me. | | Many thanks, | [EMAIL PROTECTED] | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion Scheduler problem
You could always run an external scheduler, windows scheduled tasks works fine for us, just fire off wget to a specific cf template, very reliable. Other than that, both your tasks are firing 5 days early each month, which is mostly likely not a co-incidence, you sure the server date is correct? ;-) -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 14:01 To: CF-Talk Subject: ColdFusion Scheduler problem Is there anyway to tell when the next time ColdFusion thinks (used loosely) that a job is supposed to be run? My problem is that I have a job that has a start date of Aug 6, 2003 and is scheduled to run monthly at 4:00 am.It actually runs on the 1st of each month at 4:00 am. I also have another one that is scheduled with a start date of Aug 1, 2003 at 3:30 am.It actually runs on the 26th of the month at 3:30 am. Any suggestions would be appreciated. Steve _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Softwares Black Knight now availab le
What horriable URL's Why do you feel that way? What makes them horrible? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
nothing that returns field type. cfquery returns 3 'special' vars in addition to the actual database values. 1) queryname.columnlist - comma delimited list of column names 2) queryname.recordcount - the number of records returned from the query 3) queryname.currentrow - when cfoutputting over a query, the row currently being output. charlie - Original Message - From: Angel Stewart To: CF-Talk Sent: Thursday, October 02, 2003 7:47 AM Subject: RE: How do I tell what fields are in my tables... Where'd you find that out? I've been looking through CFWACK for the CFQUERY tag, and I can't find anything that mentions the columnlist variable for CFQuery. Is there also some other variable that stores field type? -Gel -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED] you can use this: cfoutput#yourQuery.columnlist#/cfouput that will dump a list of your fields. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
In some cases, a system reboot is required to get all services up and running. After the reboot, check to see that CF server is running, and IIS is running. If so, CF administrator should come up. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Sutton Yamanashi [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:46 AM Subject: RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!! | 1.Is IIS running ? | 1A:The IIS Admin Service has status of 'started'. | | 2. Are the CFMX adapters in place ? | 2A: I don't know.How do I determine this? | | 3. Are you fully patched with windowsupdate ... | 3A:Yes. | | Thanks for you help! | -sutton | | -Original Message- | From: Thomas Chiverton [mailto:[EMAIL PROTECTED] | Sent: Thursday, October 02, 2003 10:36 AM | To: CF-Talk | Subject: Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!! | | | On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote: | I don't know how to fix this. I am dead in the water until I figure this | out. I am trying to research the error message, but can't find the answer. | If you can, please help me. | | Is IIS running ? | Are the CFMX adapters in place ? | Are you fully patched with windowsupdate ... | | -- | Tom Chiverton | 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.*** | |_ | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE:_Montara_Software's_Black_Knight_now_a_vailable
matt is entering those into the Obfuscated URL Contest :) I had to. im sorry. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:46 AM To: CF-Talk Subject: Re: Montara Software's Black Knight now a vailable Is that something that really concerns you? -Raymond Camden -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 2 Oct 2003 15:49:55 +0100 On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote: http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8 f What horriable URL's -- Tom Chiverton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?]
My production server is running Win 2003 Enterprise.I have not tested Web Edition or Standard edition. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Matthew Fusfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:50 AM Subject: RE: Windows 2003 editions: Web vs Standard [WAS Re: Windows 2000 or 2003 Server?] | We are using Windows Server 2003 Web Edition with ColdFusion MX 6.1 | standard; similar setup to you in that it is a 1U hooked up to a more | powerful database server. Works really well and we like Win2k3 overall. | | Matt | | -Original Message- | From: John Paul Ashenfelter | [mailto:[EMAIL PROTECTED] | Sent: Thursday, October 02, 2003 10:02 AM | To: CF-Talk | Subject: Windows 2003 editions: Web vs Standard [WAS Re: Windows | 2000 or 2003 Server?] | | | The bulk of the reasons that the default install is safer is | that it turns off a lot of unnecessary services/etc. If you standard | firewall/DMZ setup, you weren't really vunerable to external attack on | those services anyhow. And running IIS Lockdown takes care of most of | the rest... | | So Windows 2000 plus IIS lockdown tool vs Windows 2003 default | install -- I'm kind of waiting for Windows 2003 SP1 :) Or running Apache | on the windows box so the point becomes moot. | | But I *am* interested in folks impressions of the Windows 2003 | web edition vs standard. I run a small farm of 1U web/cf (only) servers | on Windows 2000 that connect to a more powerful db server (running | MS-SQL 2000 and MySQL of all things under Win 2000). I was considering | replacing Windows 2000 with RedHat Enterprise ES 2.1 (3.0 in mid Oct) | based in part on cost considerations and in part on security issues. But | the Web Edition of Windows 2003 is price competetive (both are less than | $500/server) so I'm a little torn. Since all either runs is web/cf, | Windows 2003 Web Edition becomes a sensible upgrade path. | | Thoughts? I know Dave said he had liked what he had seen with | 2003 so far. Has anyone tried to license it? Seemed like OEM-only (eg | buy a new server) was the idea when it was released. I've got it through | MSDN so no prob testing it -- but curious about folks using it in | produciton or getting ready to. | | Regards, | | John Paul Ashenfelter | CTO/Transitionpoint | [EMAIL PROTECTED] |- Original Message - |From: Dave Watts |To: CF-Talk |Sent: Thursday, October 02, 2003 9:03 AM |Subject: RE: Windows 2000 or 2003 Server? | | | That is total crap as Win2003 is based on WinXP code which | was based on Win2K code and as such shares many of the same | vulnerabilities. | | Do not consider installing Win2003 to be as safe as an | unpatched Win2K installation. | |The default install of Windows Server 2003 is much safer in | many respects |than the default install of Windows 2000 Server. This is | especially true |with the Web Edition. | |As for reliability, it seems pretty good so far, and I've been | recommending |it for use with our clients for about a month. | |Dave Watts, CTO, Fig Leaf Software |http://www.figleaf.com/ |voice: (202) 797-5496 |fax: (202) 797-5444 | | |_ | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Softwares Black Knight now a vailable
On Thursday 02 Oct 2003 15:46 pm, Raymond Camden wrote: Is that something that really concerns you? Imagine me saying to my boss: Hay, check out this bril new bit of thing we can use That's nice, what's the URL and I'll look at it on my desk w-w-w-.-montara-software-.com-/-go-/-9-d-5-8-a-5-9-e---d-... Stop there, I'm too busy. I mean, that URL is going to look bad in just about everywhere you use it, isn't it ? I thought the point of /go/id URL's was to provide a convient link down into the bowels of a site in a quick and easy to use URL... -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003
Were you sending it as an attachment? The list strips out all attachments for security. Can you send me the post you sent to the list so I can see what's up with it. Thanks Okay, I give up. There's something going on with this listserver which is preventing my post from going through in it's entirety. We have searchable archives for this list which also provide detailed stats on usage of this list. You can view reports on the number of posts by author and thread over any given date range. You can also view reports showing what people are searching for in the archives. Of course, you can search for any post by various criteria. Link to http://www.listsearch.com/coldfusion.lasso to access the archive. To generate the stats, click on the Browse tab. To learn more about this free service, click on the Info tab. Enjoy! At 5:29 AM -0700 10/2/03, Bill Doerrfeld wrote: Looks like there might be a line monster somewhere. Here's this post resent again. Date: Wed, 1 Oct 2003 14:07:01 -0700 To: [EMAIL PROTECTED] From: Bill Doerrfeld [EMAIL PROTECTED] Subject: [Stats] Cold Fusion Talk List Stats; September 2003 Cc: Bcc: X-Attachments: Greetings: For those of you curious to see the stats for usage of this list, please check out the following. Enjoy! -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I tell what fields are in my tables...
I'm confused... won't this just list the columns in your query? It doesn't list all of the columns in the table does it? (Which is what the original question was). Mitch Shameless plug for my wife's business: http://www.mygccandle.com/showmescents -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:47 AM To: CF-Talk Subject: RE: How do I tell what fields are in my tables... Where'd you find that out? I've been looking through CFWACK for the CFQUERY tag, and I can't find anything that mentions the columnlist variable for CFQuery. Is there also some other variable that stores field type? -Gel -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED] you can use this: cfoutput#yourQuery.columnlist#/cfouput that will dump a list of your fields. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Montara Software's Black Knight now availab le
I must admit, I'm with Thomas, I only like short, descriptive url's. Personal preference maybe, but big long urls with lots seemingly random characters do tend to annoy me. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 16:01 To: CF-Talk Subject: Re: Montara Software's Black Knight now availab le What horriable URL's Why do you feel that way? What makes them horrible? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I tell what fields are in my tables...
Hmm.. So how would you determine the field type of the underlying table for a query? Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ? -Gel -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] nothing that returns field type. cfquery returns 3 'special' vars in addition to the actual database values. 1) queryname.columnlist - comma delimited list of column names 2) queryname.recordcount - the number of records returned from the query 3) queryname.currentrow - when cfoutputting over a query, the row currently being output. charlie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
URLs (was Re: Montara Softwares Black Knight now available)
Imagine me saying to my boss: Hay, check out this bril new bit of thing we can use That's nice, what's the URL and I'll look at it on my desk w-w-w-.-montara-software-.com-/-go-/-9-d-5-8-a-5-9-e---d-... Stop there, I'm too busy. I completely agree with you, the URLs that I used in my email to the list are not the kind that you could share orally or even remember. However, I don't expect the above scenario to play out like that. I would more expect you to forward the email to your boss and thus the link would be in the email for easy clicking. I mean, that URL is going to look bad in just about everywhere you use it, isn't it ? Just to be clear, we have didn't URL formats that lead to the same page and make use of those different formats for different reasons. In the case of UUID-based URLs, we use those for public communication in email and HTML since those URLs will never break no matter how we reorganize the site. In this case of an advertisement or some other format where we expect people to remember the URL, we would use a different format entirely. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFDump stopped working (along w/ cftrace)
All of a sudden cfdump stopped displaying formatting for me, anybody else having this problem? Basically the text is all still there, but I lost my precious tables and color-coding like so: cfdumpinited TRUE somestruct struct YOMAMMY blah blah YOPAPPY [empty string] YOSISTERTOO [empty string] I've checked on multiple machines/browsers, and it's the same.I also checked the dump tag in the CF tags directory, and it's still encoded, which hopefully means it's not corrupted. And I can't live/code without my borders and color-coded arrays, and structures, and objects, and cookies, and... Tyler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Softwares Black Knight now a vailable
Heh, I don't typically tell my boss anything, I just IM or email it. ;) Guess I'm a spoiled telecommuter. -Ray -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 2 Oct 2003 16:03:53 +0100 On Thursday 02 Oct 2003 15:46 pm, Raymond Camden wrote: Is that something that really concerns you? Imagine me saying to my boss: Hay, check out this bril new bit of thing we can use That's nice, what's the URL and I'll look at it on my desk w-w-w-.-montara-software-.com-/-go-/-9-d-5-8-a-5-9-e---d-... Stop there, I'm too busy. I mean, that URL is going to look bad in just about everywhere you use it, isn't it ? I thought the point of /go/id URL's was to provide a convient link down into the bowels of a site in a quick and easy to use URL... -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Tux and CFMX 6.1
Folks, As I said in a previous post, I'm looking at Win 2003 Web Edition vs RedHat Enterprise ES 3.0 for a small farm of web servers. I'm comfortable with Apache, but since RH ES comes with the tux web server as well, which is part of what I assume I'm paying a premium for, has anyone used CFMX with that web server? Since only Advanced Server 2.1 is listed on the supported platform list, I'm a little curious about specific experiences. Regards, John Paul Ashenfelter CTO/Transitionpoint [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: URLs (was Re: Montara Softwares Black Knight now available)
On Thursday 02 Oct 2003 16:17 pm, Matt Liotta wrote: Just to be clear, we have didn't URL formats that lead to the same page and make use of those different formats for different reasons. In the case of UUID-based URLs, we use those for public communication in email and HTML since those URLs will never break no matter how we reorganize the site. In this case of an advertisement or some other format where we expect people to remember the URL, we would use a different format entirely. Of course, it's your URL scheme, but why not just have one format, and make it the 'remember the URL' format :-) ? -- Tom Chiverton 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
Angel Stewart wrote: So how would you determine the field type of the underlying table for a query? Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ? That is why you should use the INFORMATION_SCHEMA. Just try cfquery datasource= name=qColumns SELECT * FROM information_schema.columns WHERE table_name = 'myTable' /cfquery cfdump var=qColumns You should also check out the rest of the INFORMATION_SCHEMA, it allows you to see (almost) everything of the schema (in a compliant database), from the datatypes and defaults of columns to the permissions and triggers defined on a table. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: _Montara_Software's_Black_Knight_now_a_vailable
Matt, The price list is almost invisible...at least on my portable screen. Was looking around for about 5 mins hehe. Congrats on the release tho..good stuff. Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 2, 2003 11:01 AM To: CF-Talk Subject: RE:_Montara_Software's_Black_Knight_now_a_vailable matt is entering those into the Obfuscated URL Contest :) I had to. im sorry. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:46 AM To: CF-Talk Subject: Re: Montara Software's Black Knight now a vailable Is that something that really concerns you? -Raymond Camden -- Original Message -- From: Thomas Chiverton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 2 Oct 2003 15:49:55 +0100 On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote: http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8 f What horriable URL's -- Tom Chiverton _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
Not really sure why you'd need to, what with CF not being strongly typed... I guess if the need arose, yes, you could probably whip up a UDF to loop over the columns of one of the rows returned, testing with the various functions you named...store that in a struct...with columnname as the key and the datatype as the value (?) charlie - Original Message - From: Angel Stewart To: CF-Talk Sent: Thursday, October 02, 2003 8:09 AM Subject: RE: How do I tell what fields are in my tables... Hmm.. So how would you determine the field type of the underlying table for a query? Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ? -Gel -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] nothing that returns field type. cfquery returns 3 'special' vars in addition to the actual database values. 1) queryname.columnlist - comma delimited list of column names 2) queryname.recordcount - the number of records returned from the query 3) queryname.currentrow - when cfoutputting over a query, the row currently being output. charlie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
Thanks Critz! This worked like a charm. I'm alos going to look at what you recomended Philip. Thanks to all! Brian oi cf!! select top 10 * from table cfdump var=#query# or output query.columnlist [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Montara Software's Black Knight now availab le
Figures this thread would turn into a debate on 'clean' URLs. All that aside: Matt is there a developer's version I could mess around with? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:03 AM To: CF-Talk Subject: RE: Montara Software's Black Knight now availab le I must admit, I'm with Thomas, I only like short, descriptive url's. Personal preference maybe, but big long urls with lots seemingly random characters do tend to annoy me. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 16:01 To: CF-Talk Subject: Re: Montara Software's Black Knight now availab le What horriable URL's Why do you feel that way? What makes them horrible? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 _ [ Todays Threads _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Montara Software's Black Knight now availab le
yeah...matt? is there? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:36 AM To: CF-Talk Subject: RE: Montara Software's Black Knight now availab le Figures this thread would turn into a debate on 'clean' URLs. All that aside: Matt is there a developer's version I could mess around with? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:03 AM To: CF-Talk Subject: RE: Montara Software's Black Knight now availab le I must admit, I'm with Thomas, I only like short, descriptive url's. Personal preference maybe, but big long urls with lots seemingly random characters do tend to annoy me. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 16:01 To: CF-Talk Subject: Re: Montara Software's Black Knight now availab le What horriable URL's Why do you feel that way? What makes them horrible? Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 _ [ Todays Threads _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: URLs (was Re: Montara Softwares Black Kn ight now available)
Of course, it's your URL scheme, but why not just have one format, and make it the 'remember the URL' format :-) ? Because history has shown that those URLs tend to break over time. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:_Montara_Software's_Black_Knight_now_a_vailable
Is that really how things go around your office? I didn't think that happened anymore.. You copy and paste a URL into an email, boss clicks on it, away he/she goes. I can't possibly imagine why the content of a reasonably lengthened URL would be of ANY concern in this day and age (short of offensive words, etc)? I'd be much more interested in a discussion about the merits of the new product than this other nonsense. Has anyone run through the tutorials? Brian - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Thursday, October 02, 2003 10:03 AM Subject: Re: Montara Software's Black Knight now a vailable On Thursday 02 Oct 2003 15:46 pm, Raymond Camden wrote: Is that something that really concerns you? Imagine me saying to my boss: Hay, check out this bril new bit of thing we can use That's nice, what's the URL and I'll look at it on my desk w-w-w-.-montara-software-.com-/-go-/-9-d-5-8-a-5-9-e---d-... Stop there, I'm too busy. I mean, that URL is going to look bad in just about everywhere you use it, isn't it ? I thought the point of /go/id URL's was to provide a convient link down into the bowels of a site in a quick and easy to use URL... -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Software's Black Knight now availab le
Matt is there a developer's version I could mess around with? We are planning on making a 30-day evaluation available for download from our site next week. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFDump stopped working (along w/ cftrace)
There are some issues with both the HTML and the style sheets used with CFDump (don't know about CFTrace but I assume it's the same story). In short, they are incompatible with several different DTDs. You can experiment with different DTDs or, as I do, just remove the DTD declaration from the DOCTYPE tag, which will place many modern browsers (Internet Explorer, Mozilla) in compatibility or quirky mode. Of course, the rendering of the rest of your page may change, so you may want to make the inclusion of the DTD dependent on a debug parameter. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:21 AM To: CF-Talk Subject: CFDump stopped working (along w/ cftrace) All of a sudden cfdump stopped displaying formatting for me, anybody else having this problem? Basically the text is all still there, but I lost my precious tables and color-coding like so: cfdumpinited TRUE somestruct struct YOMAMMY blah blah YOPAPPY [empty string] YOSISTERTOO [empty string] I've checked on multiple machines/browsers, and it's the same.I also checked the dump tag in the CF tags directory, and it's still encoded, which hopefully means it's not corrupted. And I can't live/code without my borders and color-coded arrays, and structures, and objects, and cookies, and... Tyler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Montara Software's Black Knight now availab le
cool. and I know what we have read on the site, but what, give us a real live this is what it could do type thing. I have a .net guy here who, well, for the sake of argument, doesn't really love cf like we do.(That's a nice as I could say anything) anyway, can you give us a real world example? or did I miss it on the site? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:41 AM To: CF-Talk Subject: Re: Montara Software's Black Knight now availab le Matt is there a developer's version I could mess around with? We are planning on making a 30-day evaluation available for download from our site next week. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Retaining Database Row Locks Across User Requests
We are using CFMX 6.1 and Oracle 9i.How do we retain database row locks from one request (query of information to display in a HTML form) to the next (updating the information)?Data integrity is the concern of course...how to keep two users from updating the same record from the database at the same time. I've been trying to use SELECT...FOR UPDATE without any success. Thanks, Ryan A. Geesaman Applications Developer Penn State College of Medicine Health Evaluation Sciences [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Lock Rows?
How can I lock a database row?Does anyone know any good examples of database locking everything accompanies it? Thanks! Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Wed/Thu) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 Massena (Fri) Massena Central School Massena, NY P.315-769-3700 x 3049 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: _Montara_Software's_Black_Knight_now_a_vailable
The price list is almost invisible...at least on my portable screen. Was looking around for about 5 mins hehe. That has been fixed. Congrats on the release tho..good stuff. Thanks! Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: _Montara_Software's_Black_Knight_now_a_vailable
I'd be much more interested in a discussion about the merits of the new product than this other nonsense. Has anyone run through the tutorials? There have been over 50 downloads of the tutorial so far this morning, so certainly others are reading it. It is my hope that the tutorial will show everyone just how easy Black Knight is and that it really is the .NET equivalent of the Java CFX API. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Retaining Database Row Locks Across User Requests
A great site for oracle stufflike this is : http://asktom.oracle.com/ Theres a great search engine and Tom seems to spend a lot of his time answering questions. -Original Message- From: Ryan Geesaman [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 04:46 PM To: CF-Talk Subject: Retaining Database Row Locks Across User Requests We are using CFMX 6.1 and Oracle 9i.How do we retain database row locks from one request (query of information to display in a HTML form) to the next (updating the information)?Data integrity is the concern of course...how to keep two users from updating the same record from the database at the same time. I've been trying to use SELECT...FOR UPDATE without any success. Thanks, Ryan A. Geesaman Applications Developer Penn State College of Medicine Health Evaluation Sciences _ [ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: _Montara_Software's_Black_Knight_now_a_vailable
looking at it...thanks, just found that! :) thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:55 AM To: CF-Talk Subject: Re: _Montara_Software's_Black_Knight_now_a_vailable I'd be much more interested in a discussion about the merits of the new product than this other nonsense. Has anyone run through the tutorials? There have been over 50 downloads of the tutorial so far this morning, so certainly others are reading it. It is my hope that the tutorial will show everyone just how easy Black Knight is and that it really is the .NET equivalent of the Java CFX API. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Montara Software's Black Knight now availab le
and I know what we have read on the site, but what, give us a real live this is what it could do type thing. I have a .net guy here who, well, for the sake of argument, doesn't really love cf like we do. (That's a nice as I could say anything) anyway, can you give us a real world example? or did I miss it on the site? I believe someone on this list asked the other day about determining the size of a directory including everything nested inside it. Using cfdirectory one would have to traverse the entire directory to calculate its entire size. As someone else pointed out in reply to the question, the Windows file system object supports this functionality, but of course you can only access the file system object through COM. Using Black Knight, you could make use of a native .NET file system API instead, which would be much more efficient. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WAP CF
Has anyone created a web page or more along the lines as a file to synch a PDA with in order for someone to view Appt times from a CF Application? What I need to do is have an online Appt calendar and with all those appts, be able to sync that to a PDA. Any good tutorials, examples, products already designed? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:How do I tell what fields are in my tables...
There is another way to do much of this in SQL Server: Use the following two queries and do a cfdump on them: -- To get all tables in a database, just do: SELECT * from sysobjects where type='u' (the type='u' means just show USER tables, not system tables) -- To get info on table, including datatypes etc, use the following SQL Server stored proc (comes with database): sp_help [yourTableName] Will return seven result sets; the second one is the interesting one - run it is query analyzer to see what you can get from it. I use this instead of Enterprise Manager, for the most part - Query Analyzer is much lower overhead and faster. Thanks Critz! This worked like a charm. I'm alos going to look at what you recomended Philip. Thanks to all! Brian oi cf!! select top 10 * from table cfdump var=#query# or output query.columnlist [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Retaining Database Row Locks Across User Requests
We are using CFMX 6.1 and Oracle 9i.How do we retain database row locks from one request (query of information to display in a HTML form) to the next (updating the information)?Data integrity is the concern of course...how to keep two users from updating the same record from the database at the same time. I've been trying to use SELECT...FOR UPDATE without any success. Practically speaking, you can't successfully retain database locks across multiple requests - and even if you could, it would be a bad idea. What happens if the second request never comes - would you want the lock to persist indefinitely? Instead, to ensure data integrity, you have to write additional code to manage the editing process. This can be pretty simple, actually. For example, you can use a timestamp field to track when the record was last updated, and only allow an edit to succeed if the timestamp field hasn't changed since the record was selected for editing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sql question pt 2
Tony, SQL doesn't do things in order it actually starts with the where clause and works up. This makes sense when you think about it - it filters out the stuff that you don't want before it selects the stuff that you do. - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:28 PM Subject: RE: sql question pt 2 that doesn't jive. why? because the values of those two things arent calculated until you get down into the where clause qualifiers. isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:34 PM To: CF-Talk Subject: RE: sql question pt 2 I just work with SQL Server and there you DON'T use calculated values in the HAVING clause.You have to re-compute SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount from orders WHERE tony = tony HAVING Abs((count(tony)-sum(jayme))/count(tony)) 0 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 11:24 AM To: CF-Talk Subject: sql question pt 2 question: how does one use calculated variable names(not sure if this is what they are called) in queries, later on in the query? ie. select count(tony) as tonysCount, sum(jayme) as jaymesCount from orders where tony = tony HAVING Abs((tonysCount-jaymesCount)/tonysCount) 0 the problem is im getting an error like Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'tonysCount'. Server: Msg 207, Level 16, State 1, Line 1 Invalid column name 'jaymesCount'. (which tony minus jayme would mean im not married anymore so it would always = 0 :) or would my count go up...hee hee hee, just kidding.. thanks... ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql question pt 2
yeah, I remember hearing that. the only reason I was trying to do this, in the first place was because I wanted to take some calculation effort off the cfmx server and put it on the sql server, but its not a biggie, just wanted to try it to expand my brain a bit, and try a real world example of a having clause that could both help me out, and make me understand how/when to use :) that's all. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:36 PM To: CF-Talk Subject: Re: sql question pt 2 Tony, SQL doesn't do things in order it actually starts with the where clause and works up. This makes sense when you think about it - it filters out the stuff that you don't want before it selects the stuff that you do. - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:28 PM Subject: RE: sql question pt 2 that doesn't jive. why? because the values of those two things arent calculated until you get down into the where clause qualifiers. isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:34 PM To: CF-Talk Subject: RE: sql question pt 2 I just work with SQL Server and there you DON'T use calculated values in the HAVING clause.You have to re-compute SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount from orders WHERE tony = tony HAVING Abs((count(tony)-sum(jayme))/count(tony)) 0 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 11:24 AM To: CF-Talk Subject: sql question pt 2 question: how does one use calculated variable names(not sure if this is what they are called) in queries, later on in the query? ie. select count(tony) as tonysCount, sum(jayme) as jaymesCount from orders where tony = tony HAVING Abs((tonysCount-jaymesCount)/tonysCount) 0 the problem is im getting an error like Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'tonysCount'. Server: Msg 207, Level 16, State 1, Line 1 Invalid column name 'jaymesCount'. (which tony minus jayme would mean im not married anymore so it would always = 0 :) or would my count go up...hee hee hee, just kidding.. thanks... ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
weird caching?
I am using windows 2000 with CFMX 6.0. The server is currently serving 3 web sites, and here is the problem I am running into. If I name a page from one site the same as I name a page from another site cold fusion will show the page of the of the wrong site. Has any one dealt with this before? Any one have any ideas on how to fix it? Thanks in advance. -Randy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird caching?
yeah, there is a fix on macromedia.com, there is basically an xml file that you have to turn that kind of caching off. someone will have it soon in a post, im sure. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Randy Morse [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:45 PM To: CF-Talk Subject: weird caching? I am using windows 2000 with CFMX 6.0. The server is currently serving 3 web sites, and here is the problem I am running into. If I name a page from one site the same as I name a page from another site cold fusion will show the page of the of the wrong site. Has any one dealt with this before? Any one have any ideas on how to fix it? Thanks in advance. -Randy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weird caching?
http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm -Original Message- From: Randy Morse [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:45 PM To: CF-Talk Subject: weird caching? I am using windows 2000 with CFMX 6.0. The server is currently serving 3 web sites, and here is the problem I am running into. If I name a page from one site the same as I name a page from another site cold fusion will show the page of the of the wrong site. Has any one dealt with this before? Any one have any ideas on how to fix it? Thanks in advance. -Randy _ [ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sql question pt 2
Tony Weeg wrote: isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? SELECT * FROM ( SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount FROM orders ) a WHERE Abs(tonysCount-jaymesCount)/tonysCount) 0 Whether this is faster depends on the circumstances. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql question pt 2
with about 5000 lines coming from sql server, if I do the math with a cfloop and cf tags in between, versus, calculating in sql server and discarding what I don't want? what do you think? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:48 PM To: CF-Talk Subject: Re: sql question pt 2 Tony Weeg wrote: isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? SELECT * FROM ( SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount FROM orders ) a WHERE Abs(tonysCount-jaymesCount)/tonysCount) 0 Whether this is faster depends on the circumstances. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sql question pt 2
Tony Weeg wrote: with about 5000 lines coming from sql server, if I do the math with a cfloop and cf tags in between, versus, calculating in sql server and discarding what I don't want? what do you think? SQL of course. Don't put off to the business layer what you can do in the data layer. And who cares about performance when it is only 5000 lines (probably SQL is faster anyway). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql question pt 2
a quick non-scientific test says DON'T USE THIS QUERY TONY, that's actually what query analyzer said too much too long, can get better data quicker calc'ing in cf. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:50 PM To: CF-Talk Subject: RE: sql question pt 2 with about 5000 lines coming from sql server, if I do the math with a cfloop and cf tags in between, versus, calculating in sql server and discarding what I don't want? what do you think? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 12:48 PM To: CF-Talk Subject: Re: sql question pt 2 Tony Weeg wrote: isnt there just a way to use those calculated values, referenced in the beginning of the query, later on down in the query? SELECT * FROM ( SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount FROM orders ) a WHERE Abs(tonysCount-jaymesCount)/tonysCount) 0 Whether this is faster depends on the circumstances. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql question pt 2
here is the whole thing, in its entirety now, and it takes about 3 minutes. not good. select * from (select r.IpAddressNum, v.VehicleIp, v.firmwareRev, Count(r.ReportId) as ReportsInDatabase, Count(DISTINCT timeId) as DistinctTimes, v.VehicleName, c.companyName from reportsView r INNER JOIN vehicletable v on v.IpAddressNumber = r.IpAddressNum INNER JOIN companyTable c on v.companyIdNumber = c.companyIdNumber where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003 23:59:59.999' Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp, c.companyName,v.firmwareRev ) a where Abs((reportsInDatabase-distinctTimes)/reportsInDatabase * 100) 50 Order by ReportsInDatabase DESC ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 1:00 PM To: CF-Talk Subject: Re: sql question pt 2 Tony Weeg wrote: with about 5000 lines coming from sql server, if I do the math with a cfloop and cf tags in between, versus, calculating in sql server and discarding what I don't want? what do you think? SQL of course. Don't put off to the business layer what you can do in the data layer. And who cares about performance when it is only 5000 lines (probably SQL is faster anyway). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2000 or 2003 Server?
Actually Win 2003 is IIS 5.2 and XP is IIS 6.x Don't ask me why.I just happen to have a Win 2003 server right here and a cfdump reveals IIS 5.2 :-) Also... as far as Win2003 is concerned.I've had CFMX 6.1 running on Win2003 for a couple months now and couldn't be happier. -Novak - Original Message - From: Doug White [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 2:19 AM Subject: Re: Windows 2000 or 2003 Server? You are incorrect. Win2k supports IIS 5.0 and Win 2003 is IIS 6.0 There are patched vulnerabilities in IIS 5.0 which are not needed in Win2003 as the release is a redesign. For instance the ISAPIfilter URLScan is not needed on Win 2003. This is not to say that one should not keep up with patches as they are made available. CFMX 6.1 install on Win2003 is straight forward and relatively easy when compared to the CFMX 6.0 install on Win2k and appears to be more stable. IIS6.0 is faster than IIS 5.0 == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:45 AM Subject: RE: Windows 2000 or 2003 Server? | That is total crap as Win2003 is based on WinXP code which was based on | Win2K code and as suchshares many of the same vulnerabilities. | | Do not consider installing Win2003 to be as safe as an unpatched Win2K | installation. | | -Original Message- | From: Doug White [mailto:[EMAIL PROTECTED] | Sent: Thursday, 2 October 2003 6:35 PM | To: CF-Talk | Subject: Re: Windows 2000 or 2003 Server? | | | As one who is running servers in both configurations, I strongly recommend | the | Win 2003 server. | First, it does not have the vulnerabilities that are found in Win2k, and do | not | require patching anywhere near as often. | Second, Most services are default to OFF, which requires a little more | attention | to configuration, but it is easier to leave unused or unneeded services | turned | off. | Third, the interface is XP like and requires less technical expertise to set | up | and maintain, | | == | Stop spam on your domain, use our gateway! | For hosting solutions http://www.clickdoug.com | Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. | ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 | Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf | == | If you are not satisfied with my service, my job isn't done! | | - Original Message - | From: Ryan Sabir [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Thursday, October 02, 2003 3:00 AM | Subject: Windows 2000 or 2003 Server? | | | | Hi all, | | | | I'm looking at setting up a new CFMX installation and have been given | | the option of Windows 2000 Server , or 2003 Server. | | | | Which would be the safer option? | | | | Not had having a great deal of experience with 2003 I was going to say | | 2000, but are there any significant advantages of 2003? | | | | thanks, bye! | | | | --- | | Ryan Sabir | | Newgency Pty Ltd | | 2a Broughton St | | Paddington 2021 | | Sydney, Australia | | Ph (02) 9331 2133 | | Fax (02) 9331 5199 | | Mobile: 0411 512 454 | | http://www.newgency.com/index.cfm?referer=rysig | | | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sql question pt 2
Tony Weeg wrote: here is the whole thing, in its entirety now, and it takes about 3 minutes. not good. It is impossible to debug performance issues without a complete query plan and schema (including cardinality). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bank Of America CC processing
Stan wrote: Can you show an example of how you would use cfheader or cfhttp? cfhttpparam type=CGI name=http_referer value=https://foohbar.com I was given a way to do it with cfheader (here, I think) but I've lost the thing now.Deleted the file I originally tested it on :-(.Not sure how something like that would actually work, since cfheader is server-side, but I'm pretty green when it comes to monkeying with headers.Maybe someone else knows. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 7:10 PM To: CF-Talk Subject: Re:Bank Of America CC processing Yes, I mean validating referrers in general. What's the best practise for validating a referrer other than from Bank Of America? You mean validating referrers in general?As far as I know referrers can be fairly easily faked, so authentication using just that isn't something you can do and expect it to mean much.CF can do it pretty easily via cfheader or cfhttp. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I tell what fields are in my tables...
Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ? Nope, this will only test for the CF variables containing values returned by a query, which is quite fuzzy. For instance 1234 stored as a text field in the database will be declared numeric by CF. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
Thanks.I did reboot, and they are both running.But I am still getting the same 'Service Unavailable' message on every http request.Any other solutions? -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:02 AM To: CF-Talk Subject: Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!! In some cases, a system reboot is required to get all services up and running. After the reboot, check to see that CF server is running, and IIS is running. If so, CF administrator should come up. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Sutton Yamanashi [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:46 AM Subject: RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!! | 1.Is IIS running ? | 1A:The IIS Admin Service has status of 'started'. | | 2. Are the CFMX adapters in place ? | 2A: I don't know.How do I determine this? | | 3. Are you fully patched with windowsupdate ... | 3A:Yes. | | Thanks for you help! | -sutton | | -Original Message- | From: Thomas Chiverton [mailto:[EMAIL PROTECTED] | Sent: Thursday, October 02, 2003 10:36 AM | To: CF-Talk | Subject: Re: CFMX 6.1 on Windows 2003 = Service Unavailable !!! | | | On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote: | I don't know how to fix this. I am dead in the water until I figure this | out. I am trying to research the error message, but can't find the answer. | If you can, please help me. | | Is IIS running ? | Are the CFMX adapters in place ? | Are you fully patched with windowsupdate ... | | -- | Tom Chiverton | 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.*** | |_ | | | _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]