Re: Best Practices (was: Re: 33 and 33d the same?
On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas (e.g. use cfif x rather than cfif x neq 0) over and over. And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is genuinely boolean, then 'cfif x' is the more intentional way to write it (although 'x' is a *terrible* name for a boolean variable! :) If 'x' is an integer, then the comparison should be against zero - again, emphasizing the *intention* behind the code. With a decent compiler, there should be no speed difference - and even if there is, the readability of the code would almost always outweigh any marginal performance gain. When would I sanction using the faster code instead of the more readable code? Only when someone had proved to me that in their particular application, changing that fragment made a measurable - and significant - improvement in execution speed. I spent years doing code audits and writing coding guidelines around the world so I'm fairly passionate about this sort of thing! :) If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Express
On Wednesday, August 14, 2002, at 09:16 , John Wilker wrote: Except for the project I have a need of, even pro is more than I need, IIRC express was priced right and did the job, I don't need a great many features for this project but price is kinda an issue. So the *free* Developer Edition sounds like what you need then? Or do you need the server to allow more than one external IP address to connect to it? Note: Developer Edition is what you get in Studio MX and also what the Trial Download version turns into after 30 days (it is Enterprise for the first 30 days). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices (was: Re: 33 and 33d the same?
And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is genuinely boolean, then 'cfif x' is the more intentional way to write it (although 'x' is a *terrible* name for a boolean variable! :) If 'x' is an integer, then the comparison should be against zero - again, emphasizing the *intention* behind the code. Interesting. I would do this for readability, not speed. To take a common example I would see cfif myQuery.RecordCount as more readable and immediately understandable than cfif myQuery.RecordCount gt 0 I guess I am treating this integer as if it's a boolean meaning Query record set has rows. I guess also I think of any non-zero value as boolean as I come from a CF background. Those from a more strict background might not. I guess fundamentally we find what we normally do to be more readable than what other people normally do. ;-) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CGI Sun Vs. CF NT HELP!!!!
On Wednesday, August 14, 2002, at 06:51 , Will Ryan wrote: Well I don't want to name the vendor, they have a good product, it works and is being used. I'm just concerned that using CGI rather then CF or even ASP for that matter is a step in the wrong direction. I'm even more concerned about using a text file vs. a modern database. I just need to explain to management the pros/cons of CGI Vs CF. I'm a little puzzled as to why you're classing Informix as 'a text file'? Or is this new application using just the ISAM format? See: http://www-3.ibm.com/software/data/informix/ for more details about the Informix product family. As for CGI vs CF... it all depends on what the CGI is written in, I suppose. Perl is commonly used for CGIs and it's free. Moreover, such CGIs can be compiled into the web server (Apache) so that they are very fast. And modern Perl has OO features. A lot of solid, commercial products run successfully in Perl. Probably more than in CF, in fact. Now, you've since said this new application is written in BASIC... which I must admit is completely new to me (CGI applications in BASIC, not BASIC itself!). Especially on Solaris! I really think you need to tell us which product you're talking about... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practices (was: Re: 33 and 33d the same?
On Wednesday, August 14, 2002, at 11:42 , Matthew Walker wrote: Interesting. I would do this for readability, not speed. To take a common example I would see cfif myQuery.RecordCount as more readable and immediately understandable than cfif myQuery.RecordCount gt 0 Ugh! :) I'd always write the latter (or ... eq 1 since I'm usually trying to get back just a single record in many of my queries!). I guess also I think of any non-zero value as boolean as I come from a CF background. Probably. As I think I've said before on this list (I've said it several times on other lists!): the languages you know inform the way you program. . If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practices
OK...let's just cut the name of the thread to 'Best Practices' :) While there will always be some 'subjectivity' as to 'how' to code, there certainly are 'better' ways, 'worse' ways, and yes...'best' ways. It's the 'best' ways that I'm interested in. Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that...but I can also see that where a beginner would learn the 'most simple' or 'most straightforward' way (ie learning cfif myVar is before learning cfif len(trim(myVar))). My contention/issue/point is that there are almost always 'better' ways to code (by better, I'm referring to more efficient). If I can be a better coder (which I know I can), I would want to know how. Yes, one can certainly pick up tidbits of information here and there (whether it be on the forums, newsgroup, this list, or any of the cf-related sites out there)...but I'm sure very few of us have the luxury of that kind of time to look (heck, we wouldn't even know what to look for). Might be nice to start a cf coding tips site...I'd be more than happy to throw a form online to collect tips from anybody who wants to enter a few (as well as a page to output them). Over time it might even become the basis for a best practices doc (maybe setting up a 'rate this tip' to see if it really is something that people have found works for them). I know that I'd benefit greatly from such a site. I'd like to think that many others would as well. Anybody have any thoughts on that? Thoughts on hosting? I can do it, and would be more than happy to...but perhaps a better known cf-related site would be a better 'home' for it (i'd still be willing to code it). Feedback/comments/suggestions appreciated :) Charlie - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:28 PM Subject: Re: Best Practices (was: Re: 33 and 33d the same? On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas (e.g. use cfif x rather than cfif x neq 0) over and over. And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is genuinely boolean, then 'cfif x' is the more intentional way to write it (although 'x' is a *terrible* name for a boolean variable! :) If 'x' is an integer, then the comparison should be against zero - again, emphasizing the *intention* behind the code. With a decent compiler, there should be no speed difference - and even if there is, the readability of the code would almost always outweigh any marginal performance gain. When would I sanction using the faster code instead of the more readable code? Only when someone had proved to me that in their particular application, changing that fragment made a measurable - and significant - improvement in execution speed. I spent years doing code audits and writing coding guidelines around the world so I'm fairly passionate about this sort of thing! :) If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Doc to HTML with basic tags
I saw a thing on CFCOMET, using an MS Word control (obviously on a Win server) opening a doc and saving it as a html. Then you would get MS Word's nightmare-html -- but don't fear. I think there is a mode for the program tidy that cleans up that mess. (Alternatively, save it as text?) /Hugo __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX variable issues
It doesn't appear to be. Also #structKeyExists(CGI,Referer)# outputs YES. Cheers Maybe CGI.REFERER is actually variables[CGI.REFERER] There is something a little unusual about the CGI scope in CFMX. Consider the following piece of code, it outputs the variable CGI.REFERER, which while is should be CGI.HTTP_REFERER, nonetheless exists, and if you click on check, you will find that it is populated. However, if you do a dump of CGI, it is not present. This 'feature' exists for a whole pile of variable names in the CGI scope. Cheers, Mark code !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body cfoutput a href=#cgi.script_name#Check/a Referer=#cgi.referer# /cfoutput cfdump var=#cgi# /body /html /code Ok, what you are seeing is a variable scope conflict. To fix your issue, all you need to do is change your if statement to check variables.http, variables.https, etc. When you just checked http, apparently it checked another scoped version first, and that value could not be translated to boolean. What's odd is that I don't see http in the cgi scope, so I'm not sure where it is conflicting. I'll get back to you on this. = == Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 4:45 PM To: CF-Talk Subject: Re: CFMX variable issues (web protocols + dot notation in URL scope) If you can send a test script, I can test it over here, and if I can verify it, enter a bug for you. Thanks... didn't the code come through? I don't have access to a live CFMX server. I've uploaded two test files that seem to reproduce the same error: http://www.tengai.co.uk/test/CFMX_error.zip Extract these to the same folder and browse to formtest.cfm. Submit nothing - no error. Submit http://; - no error. Submit http://www.test.com/ gives the error. Let me know if it happens for you... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available == = Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:47 PM To: CF-Talk Subject: Re: CFMX variable issues (web protocols + dot notation in URL scope) I can't confirm this. I used this code and it worked fine. I think you have an error elsewhere. cfset fieldValue = foo cfscript http = Left(fieldValue, 7) EQ http://;; https = Left(fieldValue, 8) EQ https://;; ftp = Left(fieldValue, 6) EQ ftp://;; gopher = Left(fieldValue, 9) EQ gopher://;; telnet = Left(fieldValue, 9) EQ telnet://;; nntp = Left(fieldValue, 7) EQ nntp://;; wais = Left(fieldValue, 7) EQ wais://;; /cfscript The full tag code is at the bottom. It works with form input. I think the error might be something to do with the long testing statement after the variables for the protocols are set, but it is definitely something to do with the variable names. I consistently get the coldfusion.runtime.CGIscope error when the var names are as above; when I change them so they aren't the same as the protocols, works fine. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Office XP SQL server
Best thing to do is to install the full blown SQL Server MMC admin console on your PC and point it at the MSDE - it's the easiest way to administer it...it was on microsoft.com once but I can't find it anymore HTH, Jb. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 03:11 To: CF-Talk Subject: RE: Office XP SQL server I remember seeing some discussion about a lite version of SQL server that came with office xp (and 2000) pro. I installed it and so far cannot do anything with it. How do I create a db with it, and then the DNS ? There's no GUI for MSDE, so you have to do everything from an ODBC (or other) client. First, make sure the MSSQLSERVER service is running. Then, you can connect via osql.exe (which could be in various places, depending on which MSDE version you installed - just search the drive on which you installed MSDE). From osql, you can type whatever SQL commands you like, to create databases, and to create tables and other objects within those databases. Alternatively, you can use MS Access 2000/XP as a front-end to MSDE, by creating an Access Project. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to administer CFMX's built in web server?
I've found it: http://devex.macromedia.com/developer/gallery/info.cfm?ID=B2DDA339-850B-11D 6-84508B94F85Amethod=Full Careful with the wrap Jb. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 14:32 To: CF-Talk Subject: How to administer CFMX's built in web server? I'm running a parallel install of CF MX Enterprise on my development workstation and I want to set the default document attribute (I use default.cfm which apparently isn't the default on MX). Is there any way to administer or change settings on CF MX's built in web server? Also, out of curiosity, is there a way to detect a USER'S locale from the server (i.e. via a HTTP header)? I'm doing some I18N and would like to sniff for user locale and redirect them to a site tailored to their language and locale. Thanks Pete __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practices
Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that... I really cannot see that. If a person is taught The best practice to begin with, then he has nothing to fear. Following general rule of thumb is a good thing when coding is at use, and learning it right way the first time through is by far better than trying to teach an old bad coding dog a new trick or two. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:58 PM Subject: Re: Best Practices OK...let's just cut the name of the thread to 'Best Practices' :) While there will always be some 'subjectivity' as to 'how' to code, there certainly are 'better' ways, 'worse' ways, and yes...'best' ways. It's the 'best' ways that I'm interested in. Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that...but I can also see that where a beginner would learn the 'most simple' or 'most straightforward' way (ie learning cfif myVar is before learning cfif len(trim(myVar))). My contention/issue/point is that there are almost always 'better' ways to code (by better, I'm referring to more efficient). If I can be a better coder (which I know I can), I would want to know how. Yes, one can certainly pick up tidbits of information here and there (whether it be on the forums, newsgroup, this list, or any of the cf-related sites out there)...but I'm sure very few of us have the luxury of that kind of time to look (heck, we wouldn't even know what to look for). Might be nice to start a cf coding tips site...I'd be more than happy to throw a form online to collect tips from anybody who wants to enter a few (as well as a page to output them). Over time it might even become the basis for a best practices doc (maybe setting up a 'rate this tip' to see if it really is something that people have found works for them). I know that I'd benefit greatly from such a site. I'd like to think that many others would as well. Anybody have any thoughts on that? Thoughts on hosting? I can do it, and would be more than happy to...but perhaps a better known cf-related site would be a better 'home' for it (i'd still be willing to code it). Feedback/comments/suggestions appreciated :) Charlie - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:28 PM Subject: Re: Best Practices (was: Re: 33 and 33d the same? On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas (e.g. use cfif x rather than cfif x neq 0) over and over. And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is genuinely boolean, then 'cfif x' is the more intentional way to write it (although 'x' is a *terrible* name for a boolean variable! :) If 'x' is an integer, then the comparison should be against zero - again, emphasizing the *intention* behind the code. With a decent compiler, there should be no speed difference - and even if there is, the readability of the code would almost always outweigh any marginal performance gain. When would I sanction using the faster code instead of the more readable code? Only when someone had proved to me that in their particular application, changing that fragment made a measurable - and significant - improvement in execution speed. I spent years doing code audits and writing coding guidelines around the world so I'm fairly passionate about this sort of thing! :)
Re: Best Practices
Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 1:00 AM Subject: Re: Best Practices Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that... I really cannot see that. If a person is taught The best practice to begin with, then he has nothing to fear. Following general rule of thumb is a good thing when coding is at use, and learning it right way the first time through is by far better than trying to teach an old bad coding dog a new trick or two. Playing devil's advocate here (somewhat), since I agree that teaching 'right' from the start isn't the worst thing that can happen...one of CF's biggest strenghts is that it allows 'non-programmers' to rapidly deploy powerful web-based applications. While that may be a double-edged sword at times, it's important to remember. To a newbie, cfif myStringVar is is much easier to comprehend than cfif len(trim(myStringVar)). Being somebody who is working with two very very very newbies, I think it would definitely be easier to teach them the simple comparison, versus explaining two functions and the concept of a boolean true/false. So while I do agree that teaching the 'right' way is better than having to unteach a 'wrong' way...remember that a big reason CF is as popular as it is is due to the fact that its learning curve is the bunny hill. charlie __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS / CFServer Problem
I've WinXP with IIS installed with Cold Fusion Server 5, default website IP all unassigned, CF administrator shows up http://127.0.0.1/CFIDE/Administrator/index.cfm. I can view html CFM pages on the sites on my computer just fine as long as my cable modem is not hooked up to the internet. The moment I connect, I get an internal server error 500 and I can no longer view any of the pages. I've changed the IP in the default site to be my real IP, but now I'm getting Gateway Timeout - The following error occurred: A gateway timeout occurred. The server is unreachable. So where do I go from here to be able to access the pages when I'm hooked up to the net? I'm just starting with this. I'd like to know if I just need to change a setting or if this is some complicated mess... Thanks so much for you time - I really appreicate it! Britta __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Microsoft Excel under MX
I think I have nearly got this MX thing under control ;-) Have I missed something or does MX not take any notice of DSN's set up from the system ODBC manager anymore, and if not how can I set up an Excel file as a datasource? -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with embed object and proxy server
Hi, sorry about the ugly code here, I am experiencing a problem where some customers can successfully use an active X graphing tool called TeeChart, and others cannot, all customers who cannot are being relayed by a proxy server, customers who can view it are not, This a more generalised question about proxy servers and what I am doing below as appossed to the coding itself, any help on this would be great, respectfully, j OBJECT id=TeeCommander1 style=LEFT: 0px; WIDTH: %=width%px; TOP: 0px; HEIGHT: 32px codeBase=http://www.andronics.co.uk/tChartCab/Teechart.cab#version=4,0,0,7; type=application/x-oleobject height=32 width=%=width% data=data:application/x-oleobject;base64,FXLpvjaF0hGAjABglzhf9VRQRjANVFRlZUN vbW1hbmRlcgAETGVmdAIAA1RvcAIABVdpZHRoA0gCBkhlaWdodAIgAAA= classid=CLSID:BEE97215-8536-11D2-808C-006097385FF5 /OBJECT OBJECT id=TChart1 style=LEFT: 0px; WIDTH:%=width%px; COLOR: white; TOP: 0px; HEIGHT: %=height%px codeBase=http://www.andronics.co.uk/tChartCab/Teechart.cab#version=4,0,0,7; type=application/x-oleobject height=%=height% width=%=width% data=data:application/x-oleobject;base64,fr6LAJbA0BG04wCgyQHWgVRQRjAKVE9EQkN DaGFydAAETGVmdAIAA1RvcAIABVdpZHRoA0gCBkhlaWdodANKARRCYWNrV2FsbC5CcnVzaC5Db2x vcgcHY2xXaGl0ZRRCYWNrV2FsbC5CcnVzaC5TdHlsZQcHYnNDbGVhchFUaXRsZS5BZGp1c3RGcmF tZQgSVGl0bGUuVGV4dC5TdHJpbmdzAQYPQ3VzdG9taXNlZCBWaWV3AA1UaXRsZS5WaXNpYmxlCBJ MZWZ0QXhpcy5BdXRvbWF0aWMIGUxlZnRBeGlzLkF1dG9tYXRpY01heGltdW0IGUxlZnRBeGlzLkF 1dG9tYXRpY01pbmltdW0IDkxlZ2VuZC5WaXNpYmxlCAZWaWV3M0QIBUNvbG9yBwhjbFNpbHZlcgA AAAEA/w== align=center classid=clsid:008BBE7E-C096-11D0-B4E3-00A0C901D681/OBJECT __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Another CSS Issue
I have tried a lot of things, from adding the element to existing styles to creating a custom class just for the page break (i.e.: .PBAfter { page-break-after : always}). I have also tried implementing it in several ways but I would have thought a simple p class=PBAfter or div class=PBAfternbsp;/div would have done it. What simple little thing am I missing? -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 4:58 PM Subject: Re: OT: Another CSS Issue James Smith wrote: Has any one got 'page-break-before' or 'page-break-after' to work? http://www.w3.org/TR/REC-CSS2/page.html#page-breaks has the appropriate elements listed and Bradbury TopStyle lists the 3 elements as valid for IE 4 and onwards, however no matter how hard I try it just will not force page breaks. :( I have used it in the past. Do you have some code we can see? Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Microsoft Excel under MX
Damn it, sorry people, found it, that whole ODBC Socket thing threw me. I should know better than to do things like this before 10am ;-) -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... - Original Message - From: James Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 9:48 AM Subject: Microsoft Excel under MX I think I have nearly got this MX thing under control ;-) Have I missed something or does MX not take any notice of DSN's set up from the system ODBC manager anymore, and if not how can I set up an Excel file as a datasource? -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Survey Launching
Hi, I have been asked to investigate the possibility of adding the functionality of an on_close survey to all our sites. It would be a generic survey across them all. This should behave as follows. 1) activate when the user leaves the domain - i.e. clicks some where else. 2) activate when the user closes the site down. How easy is this to achieve? Obviously the onClose is pretty straightforward but what about the domain etc Any ideas/thoughts. How long would it take to implement this(1 hour, 2 hoursetc...?)? Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CFServer Problem
http://127.0.0.1 should work - do you have any proxy server setup or are you proxying requests? You might try ticking the box in IE under connections LAN Settings - Bypass proxy server for local addresses. How about via http://localhost does that do the same? Jb. -Original Message- From: Britta [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 09:13 To: CF-Talk Subject: IIS / CFServer Problem I've WinXP with IIS installed with Cold Fusion Server 5, default website IP all unassigned, CF administrator shows up http://127.0.0.1/CFIDE/Administrator/index.cfm. I can view html CFM pages on the sites on my computer just fine as long as my cable modem is not hooked up to the internet. The moment I connect, I get an internal server error 500 and I can no longer view any of the pages. I've changed the IP in the default site to be my real IP, but now I'm getting Gateway Timeout - The following error occurred: A gateway timeout occurred. The server is unreachable. So where do I go from here to be able to access the pages when I'm hooked up to the net? I'm just starting with this. I'd like to know if I just need to change a setting or if this is some complicated mess... Thanks so much for you time - I really appreicate it! Britta __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with embed object and proxy server
Just thought I'd reply to myself, problem fixed, IE browser, tools / internet options / advanced / http 1.1 settings / user http 1.1 through proxy connections j -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: Problem with embed object and proxy server Hi, sorry about the ugly code here, I am experiencing a problem where some customers can successfully use an active X graphing tool called TeeChart, and others cannot, all customers who cannot are being relayed by a proxy server, customers who can view it are not, This a more generalised question about proxy servers and what I am doing below as appossed to the coding itself, any help on this would be great, respectfully, j OBJECT id=TeeCommander1 style=LEFT: 0px; WIDTH: %=width%px; TOP: 0px; HEIGHT: 32px codeBase=http://www.andronics.co.uk/tChartCab/Teechart.cab#version=4,0,0,7; type=application/x-oleobject height=32 width=%=width% data=data:application/x-oleobject;base64,FXLpvjaF0hGAjABglzhf9VRQRjANVFRlZUN vbW1hbmRlcgAETGVmdAIAA1RvcAIABVdpZHRoA0gCBkhlaWdodAIgAAA= classid=CLSID:BEE97215-8536-11D2-808C-006097385FF5 /OBJECT OBJECT id=TChart1 style=LEFT: 0px; WIDTH:%=width%px; COLOR: white; TOP: 0px; HEIGHT: %=height%px codeBase=http://www.andronics.co.uk/tChartCab/Teechart.cab#version=4,0,0,7; type=application/x-oleobject height=%=height% width=%=width% data=data:application/x-oleobject;base64,fr6LAJbA0BG04wCgyQHWgVRQRjAKVE9EQkN DaGFydAAETGVmdAIAA1RvcAIABVdpZHRoA0gCBkhlaWdodANKARRCYWNrV2FsbC5CcnVzaC5Db2x vcgcHY2xXaGl0ZRRCYWNrV2FsbC5CcnVzaC5TdHlsZQcHYnNDbGVhchFUaXRsZS5BZGp1c3RGcmF tZQgSVGl0bGUuVGV4dC5TdHJpbmdzAQYPQ3VzdG9taXNlZCBWaWV3AA1UaXRsZS5WaXNpYmxlCBJ MZWZ0QXhpcy5BdXRvbWF0aWMIGUxlZnRBeGlzLkF1dG9tYXRpY01heGltdW0IGUxlZnRBeGlzLkF 1dG9tYXRpY01pbmltdW0IDkxlZ2VuZC5WaXNpYmxlCAZWaWV3M0QIBUNvbG9yBwhjbFNpbHZlcgA AAAEA/w== align=center classid=clsid:008BBE7E-C096-11D0-B4E3-00A0C901D681/OBJECT __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Survey Launching
Give each site an ID, then in the URL string that opens the window, include the ID in the URL string. Have your page that produces the form parce out the ID and put it in a hidden form field. Should be very easy to do. Dave - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:00 AM Subject: Survey Launching Hi, I have been asked to investigate the possibility of adding the functionality of an on_close survey to all our sites. It would be a generic survey across them all. This should behave as follows. 1) activate when the user leaves the domain - i.e. clicks some where else. 2) activate when the user closes the site down. How easy is this to achieve? Obviously the onClose is pretty straightforward but what about the domain etc Any ideas/thoughts. How long would it take to implement this(1 hour, 2 hoursetc...?)? Neil __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Problem
For you SQL guys out there. Do you know if there is an easy way to combine values from multiple rows? e.g. If I have a select from a table that brings back 1 column of names say... id Name 1 Andy 2 Steve 3 Ian 4 James Is there a way of combining these into a list without having to use cursors? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Another CSS Issue
James Smith wrote: I have tried a lot of things, from adding the element to existing styles to creating a custom class just for the page break (i.e.: .PBAfter { page-break-after : always}). I have also tried implementing it in several ways but I would have thought a simple p class=PBAfter or div class=PBAfternbsp;/div would have done it. What simple little thing am I missing? media=printer in your style tag perhaps? Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Problem
How about ValueList(QueryName.FieldName) -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:28 AM To: CF-Talk Subject: SQL Problem For you SQL guys out there. Do you know if there is an easy way to combine values from multiple rows? e.g. If I have a select from a table that brings back 1 column of names say... id Name 1 Andy 2 Steve 3 Ian 4 James Is there a way of combining these into a list without having to use cursors? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Automated FTP
This will be running on a box that doesn't have codfusion on it. Sounds fishy to me. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Express
John, You might want to take a look at BlueDragon Server. It's priced at $249 per server, and is CF5-compatible: http://www.newatlanta.com/products/bluedragon/index.jsp Vince Bonfanti New Atlanta Communications, LLC -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:16 AM To: CF-Talk Subject: RE: CF Express Except for the project I have a need of, even pro is more than I need, IIRC express was priced right and did the job, I don't need a great many features for this project but price is kinda an issue. I'll dig around some. J. John Wilker Codito, ergo sum Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked Do you know DOS? The reply was: No, but I met Tom and Drew a few minutes ago. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Problem
select name+', '+id as Name_Concat from MyTable is this what u where looking for? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:28 AM To: CF-Talk Subject: SQL Problem For you SQL guys out there. Do you know if there is an easy way to combine values from multiple rows? e.g. If I have a select from a table that brings back 1 column of names say... id Name 1 Andy 2 Steve 3 Ian 4 James Is there a way of combining these into a list without having to use cursors? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Express
Shameless I like it :-) -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:24 To: CF-Talk Subject: RE: CF Express John, You might want to take a look at BlueDragon Server. It's priced at $249 per server, and is CF5-compatible: http://www.newatlanta.com/products/bluedragon/index.jsp Vince Bonfanti New Atlanta Communications, LLC -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:16 AM To: CF-Talk Subject: RE: CF Express Except for the project I have a need of, even pro is more than I need, IIRC express was priced right and did the job, I don't need a great many features for this project but price is kinda an issue. I'll dig around some. J. John Wilker Codito, ergo sum Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked Do you know DOS? The reply was: No, but I met Tom and Drew a few minutes ago. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Another CSS Issue
ok, would someone please shoot me now! I read this one and thought no, I am using media=all which should work but no harm in trying I suppose. So I loaded up the page and wouldn't you know it, like an complete twonk I am using this on the only page on the entire site that doesn't load the linked stylesheet AT ALL! Quickly added a Style tag at the top and it works like a charm. Go on then, point and laugh, you know you want to -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 12:45 PM Subject: Re: OT: Another CSS Issue James Smith wrote: I have tried a lot of things, from adding the element to existing styles to creating a custom class just for the page break (i.e.: .PBAfter { page-break-after : always}). I have also tried implementing it in several ways but I would have thought a simple p class=PBAfter or div class=PBAfternbsp;/div would have done it. What simple little thing am I missing? media=printer in your style tag perhaps? Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Exchange and CFMAIL
In order to let CF relay, Exchange has to allow everyone relay, or CF has to be on the same box as Exchange, neither of these are good options. I just use the built in SMTP that comes with IIS, works pretty good. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 10:45 PM To: CF-Talk Subject: MS Exchange and CFMAIL My IT person cannot seem to set MS Exchange Server so that it will allow the Coldfusion Server to Relay mail. Could someone point me in the right direction on this? Thanks, Jim Watkins __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
I'm all for a Generally Accepted Best Practices document, as long as it has the following to bits of informaton: 1. Why is it a 'Best Practice?' I've seen too many things that say do it this way without an explanation as to why. (I will refer the reader to the parable of 'The Chimpanzees and the Water Cannon') 2. Situations where breaking the 'Best Practice' might make sense. Cases where circumstances may allow significant gains in performance by giving up some readability, for instance. MHO -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:01 AM To: CF-Talk Subject: Re: Best Practices Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that... I really cannot see that. If a person is taught The best practice to begin with, then he has nothing to fear. Following general rule of thumb is a good thing when coding is at use, and learning it right way the first time through is by far better than trying to teach an old bad coding dog a new trick or two. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:58 PM Subject: Re: Best Practices OK...let's just cut the name of the thread to 'Best Practices' :) While there will always be some 'subjectivity' as to 'how' to code, there certainly are 'better' ways, 'worse' ways, and yes...'best' ways. It's the 'best' ways that I'm interested in. Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that...but I can also see that where a beginner would learn the 'most simple' or 'most straightforward' way (ie learning cfif myVar is before learning cfif len(trim(myVar))). My contention/issue/point is that there are almost always 'better' ways to code (by better, I'm referring to more efficient). If I can be a better coder (which I know I can), I would want to know how. Yes, one can certainly pick up tidbits of information here and there (whether it be on the forums, newsgroup, this list, or any of the cf-related sites out there)...but I'm sure very few of us have the luxury of that kind of time to look (heck, we wouldn't even know what to look for). Might be nice to start a cf coding tips site...I'd be more than happy to throw a form online to collect tips from anybody who wants to enter a few (as well as a page to output them). Over time it might even become the basis for a best practices doc (maybe setting up a 'rate this tip' to see if it really is something that people have found works for them). I know that I'd benefit greatly from such a site. I'd like to think that many others would as well. Anybody have any thoughts on that? Thoughts on hosting? I can do it, and would be more than happy to...but perhaps a better known cf-related site would be a better 'home' for it (i'd still be willing to code it). Feedback/comments/suggestions appreciated :) Charlie - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:28 PM Subject: Re: Best Practices (was: Re: 33 and 33d the same? On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas (e.g. use cfif x rather than cfif x neq 0) over and over. And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is
RE: Best Practices
Have you got the CF Best Practice doc from MM? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:39 To: CF-Talk Subject: RE: Best Practices I'm all for a Generally Accepted Best Practices document, as long as it has the following to bits of informaton: 1. Why is it a 'Best Practice?' I've seen too many things that say do it this way without an explanation as to why. (I will refer the reader to the parable of 'The Chimpanzees and the Water Cannon') 2. Situations where breaking the 'Best Practice' might make sense. Cases where circumstances may allow significant gains in performance by giving up some readability, for instance. MHO -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:01 AM To: CF-Talk Subject: Re: Best Practices Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that... I really cannot see that. If a person is taught The best practice to begin with, then he has nothing to fear. Following general rule of thumb is a good thing when coding is at use, and learning it right way the first time through is by far better than trying to teach an old bad coding dog a new trick or two. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:58 PM Subject: Re: Best Practices OK...let's just cut the name of the thread to 'Best Practices' :) While there will always be some 'subjectivity' as to 'how' to code, there certainly are 'better' ways, 'worse' ways, and yes...'best' ways. It's the 'best' ways that I'm interested in. Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that...but I can also see that where a beginner would learn the 'most simple' or 'most straightforward' way (ie learning cfif myVar is before learning cfif len(trim(myVar))). My contention/issue/point is that there are almost always 'better' ways to code (by better, I'm referring to more efficient). If I can be a better coder (which I know I can), I would want to know how. Yes, one can certainly pick up tidbits of information here and there (whether it be on the forums, newsgroup, this list, or any of the cf-related sites out there)...but I'm sure very few of us have the luxury of that kind of time to look (heck, we wouldn't even know what to look for). Might be nice to start a cf coding tips site...I'd be more than happy to throw a form online to collect tips from anybody who wants to enter a few (as well as a page to output them). Over time it might even become the basis for a best practices doc (maybe setting up a 'rate this tip' to see if it really is something that people have found works for them). I know that I'd benefit greatly from such a site. I'd like to think that many others would as well. Anybody have any thoughts on that? Thoughts on hosting? I can do it, and would be more than happy to...but perhaps a better known cf-related site would be a better 'home' for it (i'd still be willing to code it). Feedback/comments/suggestions appreciated :) Charlie - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:28 PM Subject: Re: Best Practices (was: Re: 33 and 33d the same? On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas
Grammar Police (was RE: Best Practices)
(Let he without sin yadda yadda) I'm all for a Generally Accepted Best Practices document, as long as it has the following to bits of informaton: That's *two* bits of information (Decaffienated syndrome) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CFServer Problem
Is this possibly due to the fact that most cable modems block port 80, since they don't want home users running web servers? At home, I set IIS to run on port 8080 and then specify it in the url. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:56 AM To: CF-Talk Subject: RE: IIS / CFServer Problem http://127.0.0.1 should work - do you have any proxy server setup or are you proxying requests? You might try ticking the box in IE under connections LAN Settings - Bypass proxy server for local addresses. How about via http://localhost does that do the same? Jb. -Original Message- From: Britta [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 09:13 To: CF-Talk Subject: IIS / CFServer Problem I've WinXP with IIS installed with Cold Fusion Server 5, default website IP all unassigned, CF administrator shows up http://127.0.0.1/CFIDE/Administrator/index.cfm. I can view html CFM pages on the sites on my computer just fine as long as my cable modem is not hooked up to the internet. The moment I connect, I get an internal server error 500 and I can no longer view any of the pages. I've changed the IP in the default site to be my real IP, but now I'm getting Gateway Timeout - The following error occurred: A gateway timeout occurred. The server is unreachable. So where do I go from here to be able to access the pages when I'm hooked up to the net? I'm just starting with this. I'd like to know if I just need to change a setting or if this is some complicated mess... Thanks so much for you time - I really appreicate it! Britta __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
Have you got the CF Best Practice doc from MM? Somewhere around here probably. I've got (or had) something from a presentation by Uncle Ben a month or two ago, but that was a previous job and was for CFMX. Since we're still using 4.5 'round here (*cough*) some of it won't apply. If you can point me to an URL that would be great. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Problem
While Andy's out to lunch, I'll answer for him. He needs to get the names into one field. So from. id Name 1 Andy 2 Steve 3 Ian 4 James We need to get in to another table. AllNames Andy, Steve, Ian, James And in SQL if possible Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:25 To: CF-Talk Subject: RE: SQL Problem select name+', '+id as Name_Concat from MyTable is this what u where looking for? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:28 AM To: CF-Talk Subject: SQL Problem For you SQL guys out there. Do you know if there is an easy way to combine values from multiple rows? e.g. If I have a select from a table that brings back 1 column of names say... id Name 1 Andy 2 Steve 3 Ian 4 James Is there a way of combining these into a list without having to use cursors? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Another CSS Issue
James Smith wrote: ok, would someone please shoot me now! BOOM!! I read this one and thought no, I am using media=all which should work but no harm in trying I suppose. So I loaded up the page and wouldn't you know it, like an complete twonk I am using this on the only page on the entire site that doesn't load the linked stylesheet AT ALL! Quickly added a Style tag at the top and it works like a charm. cfhtmlhead in Application.cfm Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
here ya go fella : http://www.corfield.org/coldfusion/codingStandards.htm it is geared toward CFMX a little, but prob 90% of it is still CFX.X.X specific. Neil -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:48 To: CF-Talk Subject: RE: Best Practices Have you got the CF Best Practice doc from MM? Somewhere around here probably. I've got (or had) something from a presentation by Uncle Ben a month or two ago, but that was a previous job and was for CFMX. Since we're still using 4.5 'round here (*cough*) some of it won't apply. If you can point me to an URL that would be great. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
Ah. Already have that one. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:46 AM To: CF-Talk Subject: RE: Best Practices here ya go fella : http://www.corfield.org/coldfusion/codingStandards.htm it is geared toward CFMX a little, but prob 90% of it is still CFX.X.X specific. Neil -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:48 To: CF-Talk Subject: RE: Best Practices Have you got the CF Best Practice doc from MM? Somewhere around here probably. I've got (or had) something from a presentation by Uncle Ben a month or two ago, but that was a previous job and was for CFMX. Since we're still using 4.5 'round here (*cough*) some of it won't apply. If you can point me to an URL that would be great. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
Thats enough then... it tells ya what not to do and why not to do it... Jobs a a good 'un nuff said. -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:55 To: CF-Talk Subject: RE: Best Practices Ah. Already have that one. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:46 AM To: CF-Talk Subject: RE: Best Practices here ya go fella : http://www.corfield.org/coldfusion/codingStandards.htm it is geared toward CFMX a little, but prob 90% of it is still CFX.X.X specific. Neil -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:48 To: CF-Talk Subject: RE: Best Practices Have you got the CF Best Practice doc from MM? Somewhere around here probably. I've got (or had) something from a presentation by Uncle Ben a month or two ago, but that was a previous job and was for CFMX. Since we're still using 4.5 'round here (*cough*) some of it won't apply. If you can point me to an URL that would be great. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CFServer Problem
It shouldn't go out over the cable modem to request it, if you are using localhost or 127.0.0.1 then it should just loop back, right? /Hugo __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS / CFServer Problem
yeap. -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:59 To: CF-Talk Subject: RE: IIS / CFServer Problem It shouldn't go out over the cable modem to request it, if you are using localhost or 127.0.0.1 then it should just loop back, right? /Hugo __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Doc to HTML with basic tags
I am looking for a doc to html converter that will convert a doc to a decent html document, no crazy tags, no crazy css, just straight text with placement. Anyone have anything out there? Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
VSS
Nah, its simply far far too unpredictable I cant seem to switch projects without it asking if I want to save changes to the APF file... if I click Yes, it loses all reference to the files within VSS, if I click No, it loses all reference to files within VSS... I have 2 projects and I want to have them both in VSSI want to be able to switch between them easily.without it arsing up. I dont know what this is; Studio or VSS? N __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
REGEX
Anyone got a regex hanging around which would search a comma delimited file e.g. 1,f,g,h,4,56,lk,lk,re,tr,yt,,2,3,4,er,re,tr, locate text within the speech marks and replace the commas with another character (e.g ¬), thereby producing 1,f,g,h,4,56,lk¬k¬re¬tr¬yt,2,3,4,er¬re¬tr¬ many thanks Mark Mark Smyth Systems Union eBusiness Solutions 01865 880800 www.systemsunion.net __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
http=cgi
So, I checked with one of the engineers and the thing with HTTP being the same as CGI is old behavior. I never ran into this before - but now you know. Another interesting thing you may not know about cgi - you can output ANY cgi variable, even if it doesn't exist: cfoutput #cgi.raycanttype#br #structkeyExists(cgi,raycanttype)# /cfoutput When outputting, the value returned is an empty string, and structkeyExists will return Yes. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Exclude pages from Verity collection
Al Musella, DPM wrote: I may do things the hard way, but the approach I take is to put a comment in the files that I do not want indexed, like: ! DO NOT INDEX!!! -- Then, when indexing them, I use cffile to list the files in the directories, and cfhttp to read them. I look for that comment, and if not there, add them to a database, which is then indexed. This solves the problem of indexing the second page of a form, my header and footer files, lets me index pages that are made up of multiple included pages or dynamic text, and lets me get the page's title - which I set with a cfset pagetitle='' before I include the header.. how about meta name=ROBOTS content=NOINDEX __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REGEX
I don't think you need a regex, although it might be faster. Using double quotes as the delimiter, all the even numbered elements will be the ones you want to convert. Grab these then replace all the commas. Ade -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:02 To: CF-Talk Subject: REGEX Anyone got a regex hanging around which would search a comma delimited file e.g. 1,f,g,h,4,56,lk,lk,re,tr,yt,,2,3,4,er,re,tr, locate text within the speech marks and replace the commas with another character (e.g ¬), thereby producing 1,f,g,h,4,56,lk¬k¬re¬tr¬yt,2,3,4,er¬re¬tr¬ many thanks Mark Mark Smyth Systems Union eBusiness Solutions 01865 880800 www.systemsunion.net __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http=cgi
FYI, it is a bug in CFMX that you can do: cfset http=1. We should throw an error on any assignment to it. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:14 AM To: CF-Talk Subject: http=cgi So, I checked with one of the engineers and the thing with HTTP being the same as CGI is old behavior. I never ran into this before - but now you know. Another interesting thing you may not know about cgi - you can output ANY cgi variable, even if it doesn't exist: cfoutput #cgi.raycanttype#br #structkeyExists(cgi,raycanttype)# /cfoutput When outputting, the value returned is an empty string, and structkeyExists will return Yes. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Access is not locked, but it is locked as someone has it open or it is being used by CF. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:28 PM To: CF-Talk Subject: RE: access db Can you edit that table using only access? or is it locked their as well? -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 12:14 PM To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Exclude pages from Verity collection
I tried that, but Verity (at least with 4.5.2) seems to ignore it. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practices
Charlie, I think this is a great idea, I have no formal background in any language, but picking things up here and there has made my life easier. I think your idea of a place for tips would be great... and since this list has provide such a great service, maybe it should be here on HoF! It would also be nice to have a 'board' if you will that approves a 'Best' practice before it is placed as a valid best practice. Maybe even to go as far as placing 'tips' online with advantages and disadvantages ... Just to explain why it is good and why it is not so a best practice can then be determined depending on usage. Example would be: cfif if only 1-2 variables, but use cfswitch if comparing many Both are good practices, both yield the same results, but one (cfif) is much quicker to code and the savings in execution may be minimal and thus cfif would be the 'best' practice... with explination that would be useful to a user. I guess I what I am saying is have best practices, tips or whatever you want to call it, but give the explination as to WHAT they do and their advantage, disadvantage. Then have a group, approve disapprove and you will have one heck of a document. Just my .02 I think it would be great ... Mike D, do you want to have something like this? Paul Giesenhagen QuillDesign - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 1:58 AM Subject: Re: Best Practices OK...let's just cut the name of the thread to 'Best Practices' :) While there will always be some 'subjectivity' as to 'how' to code, there certainly are 'better' ways, 'worse' ways, and yes...'best' ways. It's the 'best' ways that I'm interested in. Somebody brought up previously that there shouldn't be a central 'best practices' document, as it may be intimidating to beginners (if i understood correctly). I can see that...but I can also see that where a beginner would learn the 'most simple' or 'most straightforward' way (ie learning cfif myVar is before learning cfif len(trim(myVar))). My contention/issue/point is that there are almost always 'better' ways to code (by better, I'm referring to more efficient). If I can be a better coder (which I know I can), I would want to know how. Yes, one can certainly pick up tidbits of information here and there (whether it be on the forums, newsgroup, this list, or any of the cf-related sites out there)...but I'm sure very few of us have the luxury of that kind of time to look (heck, we wouldn't even know what to look for). Might be nice to start a cf coding tips site...I'd be more than happy to throw a form online to collect tips from anybody who wants to enter a few (as well as a page to output them). Over time it might even become the basis for a best practices doc (maybe setting up a 'rate this tip' to see if it really is something that people have found works for them). I know that I'd benefit greatly from such a site. I'd like to think that many others would as well. Anybody have any thoughts on that? Thoughts on hosting? I can do it, and would be more than happy to...but perhaps a better known cf-related site would be a better 'home' for it (i'd still be willing to code it). Feedback/comments/suggestions appreciated :) Charlie - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 11:28 PM Subject: Re: Best Practices (was: Re: 33 and 33d the same? On Wednesday, August 14, 2002, at 04:22 , Matthew Walker wrote: In this particular case I didn't think the thread had changed. I thought I was talking about whether the concept of using Compare() negated the existence of the issue regarding 33d. I was just woken up and was eating breakfast at the time, so I may have been mistaken, as often I am at that terrible hour. Ah, the not enough coffee yet time... I know it well. Yes, looking back at the posts, there were still elements of the original question but I think I was frustrated by the 100+ (lots anyway) posts with the same subject, many of which weren't really dealing with the original issue... I just happened to pick your post to reply to because it raised a different point that I wanted to address... My bad, too, I suppose. While best practices do change from company to company / version to version etc, I think it's reasonable to say there is a more or less established but unwritten set of best practice ideas circulating. Well, I'm not quite so convinced since there seem to be so many disagreements on anything held up as 'best practice'... reasoning for that is that I hear the same ideas (e.g. use cfif x rather than cfif x neq 0) over and over. And as an example, that's one I would disagree (vehemently) with, unless 'x' is a boolean (true/false). If 'x' is genuinely boolean, then 'cfif x' is the more intentional
Joining tables across 2 DB2 databases
Thanks but the database names are in the query: MSHAREA and MCASA. Date: Wed, 14 Aug 2002 13:36:27 -0700 From: Tim Do [EMAIL PROTECTED] To: Subject: RE: Joining tables across 2 DB2 databases Message-ID: [EMAIL PROTECTED] try putting dbname..table name -Original Message- From: Bhandari, Sona [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 1:28 PM To: CF-Talk Subject: Joining tables across 2 DB2 databases I'm currently running the SQL below on the mainframe against a two DB2 databases and it works fine. However, when I run the same query in COLD FUSION, it hangs up. Can Cold Fusion handle joining 3 tables across two DB2 databases even with the same datasource? Could there be something wrong with my query? Thanks for your help. SELECT COUNT(A.ALPHA_POSN_CD), C.OCD, A.ALPHA_POSN_CD From MSHAREA.HRPOSNRF A, MCASA.TA B, MSHAREA.TKNUMRF C Where A.HR_POSN_CD = B.HR_POSN_CD and B.TKNUM = C.TKNUM and A.ALPHA_POSN_CD IN ('01', '02', '03', '04') and C.OCD IN ('A01', 'E99') Group by C.OCD, A.ALPHA_POSN_CD; __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REGEX
good thinking that man thanks -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:18 To: CF-Talk Subject: RE: REGEX I don't think you need a regex, although it might be faster. Using double quotes as the delimiter, all the even numbered elements will be the ones you want to convert. Grab these then replace all the commas. Ade -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:02 To: CF-Talk Subject: REGEX Anyone got a regex hanging around which would search a comma delimited file e.g. 1,f,g,h,4,56,lk,lk,re,tr,yt,,2,3,4,er,re,tr, locate text within the speech marks and replace the commas with another character (e.g ¬), thereby producing 1,f,g,h,4,56,lk¬k¬re¬tr¬yt,2,3,4,er¬re¬tr¬ many thanks Mark Mark Smyth Systems Union eBusiness Solutions 01865 880800 www.systemsunion.net __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
YUP already did that. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Practices
Most of CF best practices only talk about simple naming conventions and code layout (which is already very good). But, there isn't many things about patterns/frameworks/methodology (except Fusebox) to build complete Enterprise class web applications (with caching, internationalization, configuration files...). In the J2EE world, they might be too many (Jakarta Struts is the most famous one), but in CFMX world, there isn't many. I am currently finishing a CFMX framework/methodology based on the MVC pattern (Model/View/Controller). It is applied on the project I am currently working on and works pretty well. I should have finished the doc by the end of the week. I'll put it online with a downloadable full featured sample application. Hope you'll like it... ;) Benoit Hediard www.benorama.com -Message d'origine- De : Everett, Al [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 15 août 2002 14:55 À : CF-Talk Objet : RE: Best Practices Ah. Already have that one. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:46 AM To: CF-Talk Subject: RE: Best Practices here ya go fella : http://www.corfield.org/coldfusion/codingStandards.htm it is geared toward CFMX a little, but prob 90% of it is still CFX.X.X specific. Neil -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 13:48 To: CF-Talk Subject: RE: Best Practices Have you got the CF Best Practice doc from MM? Somewhere around here probably. I've got (or had) something from a presentation by Uncle Ben a month or two ago, but that was a previous job and was for CFMX. Since we're still using 4.5 'round here (*cough*) some of it won't apply. If you can point me to an URL that would be great. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
any javascripters
I know its not CF and apologise in advance, I,ve got a hidden frame, there is a timeout set and it will make a http request to check for a new instance of data, If there is a new instance, I want to write the new data to a table in the visible frame, I can do this successfully, code- function writeNewData(){ // assign long reference to shorter var name var delay = 1400, blinks = 3; var theTable = parent.f_userView.myTable // append new row to the end of the table var newRow = theTable.insertRow(theTable.rows[0]) // give the row its own ID newRow.id = newRow.uniqueID // declare cell variable var newCell // an inserted row has no cells, so insert the cells newCell = newRow.insertCell(0) // give this cell its own id newCell.id = newCell.uniqueID // display the row's id as the cell text newCell.innerText = a date and time string // re-use cell var for second cell insertion newCell = newRow.insertCell(1) newCell.id = newCell.uniqueID newCell.innerText = new reservoir data for ( var i = 1; i blinks; i++ ){ setTimeout(runBlink( + newRow.id + , + 0 + ), delay * i - ( delay / 2 ) ); setTimeout(runBlink( + newRow.id + , + 1 + ), (delay * i) ); } } function runBlink(idNewRow,blinker){ if(blinker){idNewRow.bgColor = }else{idNewRow.bgColor = orange} } but when I then try to blink the new row I just get a error in bottom left corner in the status bar (error on page), It works fine within a single document window, any help would be greatly appreciated, j __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query of Query Oddness
This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: cfquery dbtype=query name=qGetContent SELECT * FROM myQuery WHERE section LIKE '%#s#%' /cfquery Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered section at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:37 AM To: CF-Talk Subject: RE: access db P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5: Query A Query migration trouble
I'm trying to migrate over to CFMX and I'm having some trouble. I'm using this Query Statement: CFQUERY name=GetUsers datasource=GetAllUsers dbtype=query SELECT EmpID, FirstName, LastName, OfficeAbrv, SubOfficeAbrv, ArchiveStatus FROMGetAllUsers CFIF #URL.SearchValue# EQ USER WHERE cfif localOfficeID NEQ ALL OfficeFilterID = #ListLast(localOfficeID)# AND /cfif( LowFirst LIKE '#LCase (localFirstName)#') OR (LowLast LIKE '#LCase(localLastName)#')/CFIF cfif localOfficeID NEQ All WHERE OfficeFilterID = #ListLast(localOfficeID)# /cfif /CFQUERY This is generating the Error: Data source GetAllUsers could not be found. GetAllUsers is a query that is performed just previous to the above query. All worked just fine in CF5 Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Section is a reserved word. I checked the docs and it _wasnt_ on the list, so I'm going to add it to livedocs. To correct, just change section to [section]. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:43 AM To: CF-Talk Subject: Query of Query Oddness This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: cfquery dbtype=query name=qGetContent SELECT * FROM myQuery WHERE section LIKE '%#s#%' /cfquery Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered section at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Actually, it WAS in the table of reserved words - I was just reading the table wrong. As a general warning - CFMX QofQ has a large number of reserved words to watch out for (although QofQ in CFMX is a heck of a lot better, so it's not a big deal ;) === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:43 AM To: CF-Talk Subject: Query of Query Oddness This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Josh, Try putting the search string in parenthasis - i.e. WHERE SECTION LIKE ('%Membership%') -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:43 AM To: CF-Talk Subject: Query of Query Oddness This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: cfquery dbtype=query name=qGetContent SELECT * FROM myQuery WHERE section LIKE '%#s#%' /cfquery Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered section at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Yes, this is true...mostly. But in my case, when the last person closes the db it does not unlock. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:39 AM To: CF-Talk Subject: RE: access db Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:37 AM To: CF-Talk Subject: RE: access db P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Try adding a new datasource for the new db...then delete the old one. Its a pain, but if you set the datasource name in your Application.cfm it should be relatively easy to change. Or restart the server? w -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:39 To: CF-Talk Subject: RE: access db Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:37 AM To: CF-Talk Subject: RE: access db P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5: Query A Query migration trouble
When doing a QofQ, you do not pass datasource= Remove that part from your cfquery tag. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:54 AM To: CF-Talk Subject: CF5: Query A Query migration trouble I'm trying to migrate over to CFMX and I'm having some trouble. I'm using this Query Statement: CFQUERY name=GetUsers datasource=GetAllUsers dbtype=query SELECT EmpID, FirstName, LastName, OfficeAbrv, SubOfficeAbrv, ArchiveStatus FROMGetAllUsers CFIF #URL.SearchValue# EQ USER WHERE cfif localOfficeID NEQ ALL OfficeFilterID = #ListLast(localOfficeID)# AND /cfif( LowFirst LIKE '#LCase (localFirstName)#') OR (LowLast LIKE '#LCase(localLastName)#')/CFIF cfif localOfficeID NEQ All WHERE OfficeFilterID = #ListLast(localOfficeID)# /cfif /CFQUERY This is generating the Error: Data source GetAllUsers could not be found. GetAllUsers is a query that is performed just previous to the above query. All worked just fine in CF5 Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
Ray, If section is reserved, do you know what it is reserved for? Where is it used? -mk -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:52 AM To: CF-Talk Subject: RE: Query of Query Oddness Section is a reserved word. I checked the docs and it _wasnt_ on the list, so I'm going to add it to livedocs. To correct, just change section to [section]. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:43 AM To: CF-Talk Subject: Query of Query Oddness This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: cfquery dbtype=query name=qGetContent SELECT * FROM myQuery WHERE section LIKE '%#s#%' /cfquery Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered section at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WYSIWYG html editor applet?
Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Replacement for CFX_fMAKETREE
So where you putting the new tag up so we may look at? Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 1:59 PM To: CF-Talk Subject: Re: Replacement for CFX_fMAKETREE I've got a new one that I'm releasing tomorrow night at my presentation that's faster, smoother and just all around better (IMHO). I'll have it up the next morning. Don't thank me, thank Mike D. He wrote the tag, I just happen to have found a use for it and have it up in the public forum with my app. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Tormod Guldvog [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 12:22 PM To: CF-Talk Subject: RE: Replacement for CFX_fMAKETREE Oh *slapping my forehead*...it works like I charm if you just read the instructions... :) It needed a returnvar to work. Thank you thank you thank you! My content management system works again - with no CFX tag. That saved me a cool $120/year. With kind regards, Tormod Guldvog Editor, Hypography Sci-Tech http://www.hypography.com/ -Original Message- From: Tormod Guldvog [mailto:[EMAIL PROTECTED]] Sent: 12. august 2002 18:13 To: CF-Talk Subject: RE: Replacement for CFX_fMAKETREE Thanks for the tip - but this tag gives me the exact same results as the old CF_maketree, ie all the folders are displayed as root folders, ie no nested folders...(so I get 250 folders in a long, long column). With kind regards, Tormod Guldvog Editor, Hypography Sci-Tech http://www.hypography.com/ -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: 12. august 2002 14:37 To: CF-Talk Subject: RE: Replacement for CFX_fMAKETREE Actually Mike D make one that is pure CFML, it should work beautifully in MX, though I haven't tested. I don't know where he keeps his copy at but there is a copy included with CosMoS at http://sourceforge.net/project/showfiles.php?group_id=32780release_id =7 9755 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query of Query Oddness
To steal from the docs: ColdFusion has a list of reserved keywords, which are typically part of the SQL language and are not normally used for names of columns or tables. To escape a reserved keyword for a column name or table name, enclose it in brackets. Caution: Earlier versions of ColdFusion let you use some reserved keywords without escaping them. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:02 AM To: CF-Talk Subject: RE: Query of Query Oddness Ray, If section is reserved, do you know what it is reserved for? Where is it used? -mk -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:52 AM To: CF-Talk Subject: RE: Query of Query Oddness Section is a reserved word. I checked the docs and it _wasnt_ on the list, so I'm going to add it to livedocs. To correct, just change section to [section]. == = Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:43 AM To: CF-Talk Subject: Query of Query Oddness This is really odd, this is a very simple Query of Query and the function keeps crapping out on me in CFMX ... any ideas? I did a cfdump of the query myQuery and it contains all the fields I'd expect: HELPDOC (string) SECTION (string) TITLE (string) Here's the Query: cfquery dbtype=query name=qGetContent SELECT * FROM myQuery WHERE section LIKE '%#s#%' /cfquery Here's the actual SQL: SELECT * FROM myQuery WHERE section LIKE '%Membership%' Here's the Error: Query Of Queries syntax error. Encountered section at line 3, column 15. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Thanks, Joshua Miller __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Reboot Machine, you will problem fix, will it. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:56 To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
loadsa them.. SiteObjects (my fave!) : www.siteobjects.com Ektron Editor : www.ektron.com Active Edit : www.cfdev.com Neil -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 15:08 To: CF-Talk Subject: WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: access db
Here is what my host, www.HostMySite.com, recommends to unlock an Access db. (I have not tried this). FAQ: How to Overwrite an Existing Database I would like to upload an updated version of my access database. When I attempt to overwrite the existing database I am unable to. As a normal part of ODBC operation, your database file is locked by the ODBC connection. There is a trick you can use to unlock the database temporarily. You can write a page to query a non-existent column in an existing table in your database. This will temporarily unlock the database so that you can overwrite the file. Since the file will be re-locked quickly, especially if other pages are accessing the database, it is best to rename or delete the old database before uploading the new one. As soon as you upload the new database and run a good query, normal ODBC operation will resume. There are a few things you can do to maximize the success of the unlock page: 1. Make sure that no other pages are executing queries on the database. If a valid query is run right after your invalid query, the database will be locked again. 2. Since the database can be re-locked quickly, rename the .mdb file as soon as you run the invalid query. Then you can upload the new database and not worry about it locking again before you have a chance. 3. This trick often requires some patience - if it doesn't work at first, try it again a few times. Also, you may want to wait a few minutes and then try. You may want to rename, disable, or move any pages that query the database to prevent them from re-locking it. 4. If all else fails, upload another copy of the database with a different name. Email [EMAIL PROTECTED] and we will adjust the DSN. Hope this helps. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:52 AM Subject: RE: access db Yes, this is true...mostly. But in my case, when the last person closes the db it does not unlock. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:39 AM To: CF-Talk Subject: RE: access db Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: any javascripters
What is the actual error though? Double click on the question mark. That would be very helpful. Thursday, August 15, 2002, 9:41:15 AM, you wrote: JM code- JM function writeNewData(){ JM // assign long reference to shorter var name JM var delay = 1400, blinks = 3; JM var theTable = parent.f_userView.myTable So this function is running in the frame, right? Does the theTable object return the object correctly? Do an alert(theTable), you should get [object]. snip/ JM It works fine within a single document window, This makes me suspect that one of your object references isn't working correctly from the frame. Generally I've had better luck passing the data in the frame back to a function in the parent document that gets the object references. No need to worry about the different document objects. Just on a hunch try this instead of the above line. Might work...This is IE only right? var theTable = parent.document.all.f_userView.myTable; -- jon mailto:[EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Joining tables across 2 DB2 databases
CF doesn't have any problem joining multiple databases, it's more likely that the problem is with the ODBC driver. Could be a lot of things though. What is the error that CF throws? -- jon mailto:[EMAIL PROTECTED] Thursday, August 15, 2002, 9:29:51 AM, you wrote: BS Thanks but the database names are in the query: MSHAREA and MCASA. BS Date: Wed, 14 Aug 2002 13:36:27 -0700 BS From: Tim Do [EMAIL PROTECTED] BS To: BS Subject: RE: Joining tables across 2 DB2 databases BS Message-ID: BS [EMAIL PROTECTED] BS try putting dbname..table name BS -Original Message- BS From: Bhandari, Sona [mailto:[EMAIL PROTECTED]] BS Sent: Wednesday, August 14, 2002 1:28 PM BS To: CF-Talk BS Subject: Joining tables across 2 DB2 databases BS I'm currently running the SQL below on the mainframe against a two DB2 BS databases and it works fine. However, when I run the same BS query in COLD FUSION, it hangs up. Can Cold Fusion handle joining 3 tables BS across two DB2 databases even with the same datasource? Could there be BS something wrong with my query? Thanks for your help. BS SELECT COUNT(A.ALPHA_POSN_CD), C.OCD, A.ALPHA_POSN_CD BS From MSHAREA.HRPOSNRF A, MCASA.TA B, MSHAREA.TKNUMRF C BS Where A.HR_POSN_CD = B.HR_POSN_CD and BS B.TKNUM = C.TKNUM and BS A.ALPHA_POSN_CD IN ('01', '02', '03', '04') and BS C.OCD IN ('A01', 'E99') BS Group by C.OCD, A.ALPHA_POSN_CD; __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
Perhaps you should use the MSHTML capabilities of Internet Explorer : http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/editing/ mshtmleditor.asp http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredcom/h tml/dhtmledit.asp http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredcom/h tml/edcomfaq.asp The great things with it : you don't need to install any plug-in or to download any applet (and it's free...). Benoit -Message d'origine- De : Chris Edwards [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 15 août 2002 16:08 À : CF-Talk Objet : WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
thank you, but have already done this. -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:12 AM To: CF-Talk Subject: Re: access db Here is what my host, www.HostMySite.com, recommends to unlock an Access db. (I have not tried this). FAQ: How to Overwrite an Existing Database I would like to upload an updated version of my access database. When I attempt to overwrite the existing database I am unable to. As a normal part of ODBC operation, your database file is locked by the ODBC connection. There is a trick you can use to unlock the database temporarily. You can write a page to query a non-existent column in an existing table in your database. This will temporarily unlock the database so that you can overwrite the file. Since the file will be re-locked quickly, especially if other pages are accessing the database, it is best to rename or delete the old database before uploading the new one. As soon as you upload the new database and run a good query, normal ODBC operation will resume. There are a few things you can do to maximize the success of the unlock page: 1. Make sure that no other pages are executing queries on the database. If a valid query is run right after your invalid query, the database will be locked again. 2. Since the database can be re-locked quickly, rename the .mdb file as soon as you run the invalid query. Then you can upload the new database and not worry about it locking again before you have a chance. 3. This trick often requires some patience - if it doesn't work at first, try it again a few times. Also, you may want to wait a few minutes and then try. You may want to rename, disable, or move any pages that query the database to prevent them from re-locking it. 4. If all else fails, upload another copy of the database with a different name. Email [EMAIL PROTECTED] and we will adjust the DSN. Hope this helps. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:52 AM Subject: RE: access db Yes, this is true...mostly. But in my case, when the last person closes the db it does not unlock. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:39 AM To: CF-Talk Subject: RE: access db Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WYSIWYG html editor applet?
Chris: I like soEditor Lite. Check it out here: http://www.siteobjects.com/pages/soeditoroverview.cfm You can download an encrypted free trial. HTH! Joel - Original Message - From: Chris Edwards [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 10:08 AM Subject: WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
thanks, already tried that. I'm just going to eat the cost and make it SQL 2000. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:05 AM To: CF-Talk Subject: RE: access db Reboot Machine, you will problem fix, will it. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:56 To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WYSIWYG html editor applet?
any idea how i18n these are? Perhaps you should use the MSHTML capabilities of Internet Explorer : __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
The next version of ActivEdit will include a WYSIWYG HTML editor applet. It will be released very soon. It however is not free, I don't think you will find an applet that does this for free. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:08 AM To: CF-Talk Subject: WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
Very cool. Thanks for the URL *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] -Original Message- From: Benoit Hediard [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:23 AM To: CF-Talk Subject: RE: WYSIWYG html editor applet? Perhaps you should use the MSHTML capabilities of Internet Explorer : http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/edit ing/ mshtmleditor.asp http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc om/h tml/dhtmledit.asp http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc om/h tml/edcomfaq.asp The great things with it : you don't need to install any plug-in or to download any applet (and it's free...). Benoit -Message d'origine- De : Chris Edwards [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 15 août 2002 16:08 À : CF-Talk Objet : WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Scheduled Tasks On MX
Excellent. Although I don't understand why it works with a Unix plug-in I'll try it out. Thanks Dave. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 9:53 PM Subject: RE: Scheduled Tasks On MX 1. Is it possible to use NT scheduler to run cfm pages as we do with 4.x? Yes, although I haven't figured out how to do this without using a command-line HTTP client, like I could with CF 5 using the CGI interface. I've used wget to do this with CF MX - you'd simply add something like wget http://www.myserver.com/myfile.cfm; to your batch file. You can get wget with Cygwin, or various other places. 2. Can you confirm the bug with CFMX scheduler which doesn't respect run times. No, because I haven't been using it - I've always stuck with the OS scheduler. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
Although CFDev's is great, I personally use soeditor, but I think there is one on the dreamweaver exchange built in JScript. It might work for you. It doesn't have all of the features that ActivEdit or soeditor does though. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:35 AM To: CF-Talk Subject: RE: WYSIWYG html editor applet? The next version of ActivEdit will include a WYSIWYG HTML editor applet. It will be released very soon. It however is not free, I don't think you will find an applet that does this for free. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:08 AM To: CF-Talk Subject: WYSIWYG html editor applet? Anyone know of a free and decent java applet that will do simple html editing for a client who wants to create simple html documents for email. this would go in place of a standard textarea. thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5: Query A Query migration trouble
Thanxs, that was it. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:57 AM To: CF-Talk Subject: RE: CF5: Query A Query migration trouble When doing a QofQ, you do not pass datasource= Remove that part from your cfquery tag. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:54 AM To: CF-Talk Subject: CF5: Query A Query migration trouble I'm trying to migrate over to CFMX and I'm having some trouble. I'm using this Query Statement: CFQUERY name=GetUsers datasource=GetAllUsers dbtype=query SELECT EmpID, FirstName, LastName, OfficeAbrv, SubOfficeAbrv, ArchiveStatus FROMGetAllUsers CFIF #URL.SearchValue# EQ USER WHERE cfif localOfficeID NEQ ALL OfficeFilterID = #ListLast(localOfficeID)# AND /cfif( LowFirst LIKE '#LCase (localFirstName)#') OR (LowLast LIKE '#LCase(localLastName)#')/CFIF cfif localOfficeID NEQ All WHERE OfficeFilterID = #ListLast(localOfficeID)# /cfif /CFQUERY This is generating the Error: Data source GetAllUsers could not be found. GetAllUsers is a query that is performed just previous to the above query. All worked just fine in CF5 Thanks in advance Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WYSIWYG html editor applet?
If you are interested in rolling your own, here is a nice tutorial to supplement the MSDN articles. http://webfx.eae.net/dhtml/richedit/richedit.html These guys have one that works in Mozilla as well as IE, although it is planned to be integrated into the browser soon. http://www.xopus.org/index.jsp?menu=mozce Check out their demo of the coolest looking CMS I've seen either way. http://q42.nl/xopus/ -- jon mailto:[EMAIL PROTECTED] Thursday, August 15, 2002, 10:34:16 AM, you wrote: JJ Very cool. Thanks for the URL JJ *** JJ James Johnson JJ SMB-Studios JJ Innovative Online Learning for Spirit, Mind and Body JJ www.smb-studios.com JJ [EMAIL PROTECTED] JJ -Original Message- JJ From: Benoit Hediard [mailto:[EMAIL PROTECTED]] JJ Sent: Thursday, August 15, 2002 7:23 AM JJ To: CF-Talk JJ Subject: RE: WYSIWYG html editor applet? JJ Perhaps you should use the MSHTML capabilities of Internet Explorer : JJ http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/edit JJ ing/ JJ mshtmleditor.asp JJ http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc JJ om/h JJ tml/dhtmledit.asp JJ http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc JJ om/h JJ tml/edcomfaq.asp JJ The great things with it : you don't need to install any plug-in or to JJ download any applet (and it's free...). JJ Benoit __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
I suppose that the i18n capabilities of MSHTML are the same as the IE ones. I use it with french locale and it works well. If anyone wants, I can send you a complete editor based on MSHTML (it would be better if I give the link, but I can't remember where I've downloaded it .. I think it was on Microsoft web site). Benoit -Message d'origine- De : Paul Hastings [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 15 août 2002 16:25 À : CF-Talk Objet : Re: WYSIWYG html editor applet? any idea how i18n these are? Perhaps you should use the MSHTML capabilities of Internet Explorer : __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any javascripters
What is the actual error though? Line: 1 Char: 1 Error: 'ms_id127' is undefined Code: 0 Do an alert(theTable), you should get [object]. Yep, I do, ms_id127 is the uniqueid given for the row, it can successfully insert cells to the row and output within theTable, I removed, + newRow.id + , + 0 + and + newRow.id + , + 1 + from within, setTimeout(runBlink( + newRow.id + , + 0 + ), delay * i - ( delay / 2 ) ); setTimeout(runBlink( + newRow.id + , + 1 + ), (delay * i) ); then, function runBlink(){ //if(blinker){idNewRow.bgColor = }else{idNewRow.bgColor = orange} alert('test') } the object reference newRow.id seems to get lost at this point, if just before my for loop I do newRow.bgColor = red; it runs fine, I tried, var theTable = parent.document.all.f_userView.myTable but it killed the script, I tried alerting each new instance of alert(newRow.id) to check if truely unique, maybe that might have been causing the problem but they are unique, truly confused here, -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 3:12 PM To: CF-Talk Subject: Re: any javascripters What is the actual error though? Double click on the question mark. That would be very helpful. Thursday, August 15, 2002, 9:41:15 AM, you wrote: JM code- JM function writeNewData(){ JM // assign long reference to shorter var name JM var delay = 1400, blinks = 3; JM var theTable = parent.f_userView.myTable So this function is running in the frame, right? Does the theTable object return the object correctly? Do an alert(theTable), you should get [object]. snip/ JM It works fine within a single document window, This makes me suspect that one of your object references isn't working correctly from the frame. Generally I've had better luck passing the data in the frame back to a function in the parent document that gets the object references. No need to worry about the different document objects. Just on a hunch try this instead of the above line. Might work...This is IE only right? var theTable = parent.document.all.f_userView.myTable; -- jon mailto:[EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS / CFServer Problem
I found the solution! I had to go in and manually configure the LAN Settings -(Network Settings-Change Settings-Advanced-Change Settings, which brings you to Services) and checking web server and inputting my specific IP. Then I changed 127.0.0.1 to my IP in the IIS Site Manager as well, and changed the IP of http://127.0.0.1/CFIDE/Administrator/index.cfm to include my IP instead as well. Installing IIS and CF Server for some reason did not automatically recoginize and configure this connection. I'm incuding these details just in case another newbie has the same problem... Thanks very much for your help everybody, your suggestions got me started on the road to discovery! Cheers, Britta - Original Message - From: John Beynon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 2:56 AM Subject: RE: IIS / CFServer Problem http://127.0.0.1 should work - do you have any proxy server setup or are you proxying requests? You might try ticking the box in IE under connections LAN Settings - Bypass proxy server for local addresses. How about via http://localhost does that do the same? Jb. -Original Message- From: Britta [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 09:13 To: CF-Talk Subject: IIS / CFServer Problem I've WinXP with IIS installed with Cold Fusion Server 5, default website IP all unassigned, CF administrator shows up http://127.0.0.1/CFIDE/Administrator/index.cfm. I can view html CFM pages on the sites on my computer just fine as long as my cable modem is not hooked up to the internet. The moment I connect, I get an internal server error 500 and I can no longer view any of the pages. I've changed the IP in the default site to be my real IP, but now I'm getting Gateway Timeout - The following error occurred: A gateway timeout occurred. The server is unreachable. So where do I go from here to be able to access the pages when I'm hooked up to the net? I'm just starting with this. I'd like to know if I just need to change a setting or if this is some complicated mess... Thanks so much for you time - I really appreicate it! Britta __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WYSIWYG html editor applet?
can you download and use for yourself. ? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 15:47 To: CF-Talk Subject: Re: WYSIWYG html editor applet? If you are interested in rolling your own, here is a nice tutorial to supplement the MSDN articles. http://webfx.eae.net/dhtml/richedit/richedit.html These guys have one that works in Mozilla as well as IE, although it is planned to be integrated into the browser soon. http://www.xopus.org/index.jsp?menu=mozce Check out their demo of the coolest looking CMS I've seen either way. http://q42.nl/xopus/ -- jon mailto:[EMAIL PROTECTED] Thursday, August 15, 2002, 10:34:16 AM, you wrote: JJ Very cool. Thanks for the URL JJ *** JJ James Johnson JJ SMB-Studios JJ Innovative Online Learning for Spirit, Mind and Body JJ www.smb-studios.com JJ [EMAIL PROTECTED] JJ -Original Message- JJ From: Benoit Hediard [mailto:[EMAIL PROTECTED]] JJ Sent: Thursday, August 15, 2002 7:23 AM JJ To: CF-Talk JJ Subject: RE: WYSIWYG html editor applet? JJ Perhaps you should use the MSHTML capabilities of Internet Explorer : JJ http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/edit JJ ing/ JJ mshtmleditor.asp JJ http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc JJ om/h JJ tml/dhtmledit.asp JJ http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaredc JJ om/h JJ tml/edcomfaq.asp JJ The great things with it : you don't need to install any plug-in or to JJ download any applet (and it's free...). JJ Benoit __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
With everyone out of the database is there still a ldb hanging around in the file?? If so here's a microsoft article... http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136128 -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:40 AM To: CF-Talk Subject: RE: access db Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists