RE: MS Access in CFMX 6.1
I had the same problem on a dev machine. The install wizard did not run after installation (see link below). I don't remember if this helped, because I got a new machine 1 week later and made a fresh install. I only use access for teaching CF classes. http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_sequelink .htm Pascal -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 20:31 To: CF-Talk Subject: MS Access in CFMX 6.1 Curious about an issue I have ran accross.I am trying to setup a MS Access datasource on a CFMX 6.1 box (windows 2003) and when I try to use the MS Access driver, I get this error: The ColFusion MX ODBC Server service is not running or has not been installed When I use the MS Access with Unicode it works just fine... 1) What could the problem be 2) Does it hurt anything to use the Unicode? Thanks Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
File not found: /cfide/administrator/index.cfm
I have a new CFMX 6.1 install with the latest updater. Everything is good (although I can't get any SSL connections to work...), but the administrator is acting funny. I can access any of the pages in the CFIDE/administrator/ directory, and they are served up correctly. For example, I can load http://www.mysite.com/cfide/administrator/left.cfm just fine and even use it to manage the cf server. BUT!! If I go to CFIDE/administrator/index.cfm - I get the message 'File not found: /cfide/administrator/index.cfm '. Does anyone know what this means? Brook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: File not found: /cfide/administrator/index.cfm
Nevermind, I fixed this, it was a permissions issue I believe. Brook At 12:02 AM 9/24/2004, you wrote: I have a new CFMX 6.1 install with the latest updater. Everything is good (although I can't get any SSL connections to work...), but the administrator is acting funny. I can access any of the pages in the CFIDE/administrator/ directory, and they are served up correctly. For example, I can load http://www.mysite.com/cfide/administrator/left.cfm just fine and even use it to manage the cf server. BUT!! If I go to CFIDE/administrator/index.cfm - I get the message 'File not found: /cfide/administrator/index.cfm '. Does anyone know what this means? Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:179605This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=35 1ae3f11.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: deleting folders
On Thursday 23 Sep 2004 22:17 pm, Coleman, Brian wrote: The two things I've though of so far is either a) write something in cold fusion, where I don't know how to reach the remote servers via CF or b) some kind of VBscript which can do it when ran, but I don't really have much vbscript knowledge The remote machines will need to share the folder root(s), and the CF box will have to connect as a user with prilileges that allow it to delete things. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
How do you make EM suck the remote database down, replace the tables etc, but set up the identity indexes and primary keys? I find when I use DTS to bring a table into my local database, the identity attribute isnt set on the ID field, and the ID field isnt set as primary key,so when I'm doing testing inserts fail. Is there an option somewhere I'm missing? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 10:21:02 -0700 Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) To: CF-Talk [EMAIL PROTECTED] Ahhh...you didn't pick the right optiondon't just pick the copy all tables option (or whatever it's called...it's the default selection)...there's another option on the same screen that says something along the lines of Copy objects and data After picking that you can pick which objects to pick (think the default is everything) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Change .cfm to .xxx - Legal or not?
Just to add, one company which i think make good use of this by incoporating their name is Hotchilli.com (and i think as well that it is CF that they use) e.g. http://hotchilli.com/hosting/domains.hot Andy www.andyjarrett.co.uk - Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 21:03:35 -0300 Subject: Re: Change .cfm to .xxx - Legal or not? To: CF-Talk [EMAIL PROTECTED] Thanx Jim We're using W2K3 Server/IIS 6/CFMX 6.1 This link by Ben Forta is very cool http://forta.com/blog/index.cfm?mode=eentry=681 Thanx all Marco On Thu, 23 Sep 2004 19:54:28 -0400, Jim Davis [EMAIL PROTECTED] wrote: There is no legalities concerning this at all - you can change the extension to whatever you like. You would do this in the web server (not CF) - let us know what server you're using and somebody should be able to tell you how to change it.I've got an old article detailing how to do this in IIS 5 (and some reasons why you might want to) that I think is applicable to later versions of IIS (no promises): http://www.depressedpress.com/depressedpress/Content/Development/ColdFusion/ Articles/MultipleExtensions/Index.cfm Jim Davis _ From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:41 PM To: CF-Talk Subject: Change .cfm to .xxx - Legal or not? Hi it's possible to change the CF extensions(.cfm) to .anything??? It's legal or not? What's the law point of view? And MM? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: javascript check?
Or how about doing a redirect in JS, same logic as the cookie example but you don't have to load a new page if JS is disabled. Ade -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 20:12 To: CF-Talk Subject: RE: _javascript_ check? good call man.i will do just that. Ray At 03:14 PM 9/23/2004, you wrote: From: Ray Champagne [mailto:[EMAIL PROTECTED] Is there a way to detect if the client browser has _javascript_ turned on using CF?In other words, when the client makes a cfm page request, is there some kind of CGI variable that is passed through?I can clarify more if need be Try setting a cookie using JS then reading that cookie. If you can read it JS is on, if not JS is off. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hot-fixes
Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, jb. On Fri, 24 Sep 2004 11:33:38 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: javascript check?
Try setting a cookie using JS then reading that cookie. If you can read it JS is on, if not JS is off. But if they have a cookie switched off or a firewall that blocks them then this will not work. _javascript_ might be on but cookie off. This is what I use: In the head tag add this: script type=text/_javascript_ self.location=/index.cfm?jsenabled=1; /script meta http-equiv=refresh content=1;url=""> Then in you code check the value of the jsenabled url variable. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Ok, but do you install them all? Because from what MM said they don't think you should. Andrew. - Original Message - From: John Beynon [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 11:38:48 +0100 Subject: Re: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, jb. On Fri, 24 Sep 2004 11:33:38 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
no, i don't by default install them all. I'll decide if it affects something i know i use and if so apply the hotfix, eg I don't use CFFORM so never applied http://www.macromedia.com/support/coldfusion/ts/documents/cfform_hotfix.htm On Fri, 24 Sep 2004 11:44:28 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Ok, but do you install them all? Because from what MM said they don't think you should. Andrew. - Original Message - From: John Beynon [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 11:38:48 +0100 Subject: Re: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, jb. On Fri, 24 Sep 2004 11:33:38 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
I evaluate each one and then decide whether it is required or not. Andy On Fri, 24 Sep 2004 11:48:54 +0100, John Beynon [EMAIL PROTECTED] wrote: no, i don't by default install them all. I'll decide if it affects something i know i use and if so apply the hotfix, eg I don't use CFFORM so never applied http://www.macromedia.com/support/coldfusion/ts/documents/cfform_hotfix.htm On Fri, 24 Sep 2004 11:44:28 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Ok, but do you install them all? Because from what MM said they don't think you should. Andrew. - Original Message - From: John Beynon [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 11:38:48 +0100 Subject: Re: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, jb. On Fri, 24 Sep 2004 11:33:38 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Andrew Dixon wrote: Ok, but do you install them all? Depends on the system. Servers in production are as frozen as possible and only what is absolutely necessary is installed. But on development systems I install everything. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
But on development systems I install everything. But then your development environment and production environment are different. So if you create something that works in the development environment it might not work in the production environment. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Andrew Dixon wrote: But on development systems I install everything. But then your development environment and production environment are different. So if you create something that works in the development environment it might not work in the production environment. That is a given anyway, I rarely develop something that I deploy on a server I run myself. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: javascript check?
It might be worth leaving out the meta refresh and just assume the current page is the one needed for disabled JS. Meta refresh may also be turned off. Ade -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 11:44 To: CF-Talk Subject: Re: _javascript_ check? Try setting a cookie using JS then reading that cookie. If you can read it JS is on, if not JS is off. But if they have a cookie switched off or a firewall that blocks them then this will not work. _javascript_ might be on but cookie off. This is what I use: In the head tag add this: script type=text/_javascript_ self.location=/index.cfm?jsenabled=1; /script meta http-equiv=refresh content=1;url=""> Then in you code check the value of the jsenabled url variable. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
Right Click on your database, under all tasks choose Export data In the Wizard Choose your source --Next Choose your destination--Next Choose Select Objects to Copy--Next Uncheck Copy All Objects Uncheck Use Default Objects Choose (Select Objects Button) Select those items you want to copy Click ok Choose (Options Button) Set up the appropriate items. Run or schedule the DTS. Another thing that I usually do is script the database including the relationships (from Right Click, all tasks, choose (generate SQL). I then create two scripts from that, one for the tables and the others to apply the relationships.I have found (and I am not a SQL guru so I am probably doing it wrong) that sometimes when I create a new database and import data that some data doesn't move over because of foreign key constraints.So if I copy the data over without the indexes, then run the sql script containing the indexes, constraints etc, that it works better. Sandy Clark http://www.shayna.com http://www.shayna.com/ CF Pretty Accessible at http://www.shayna.com/blog Now offering 4 days Hands on CSS training October 11-14th. Rockville, MD. For more information go to: http://www.teratech.com/training/oc_classes.cfm#css _ From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 5:25 AM To: CF-Talk Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) How do you make EM suck the remote database down, replace the tables etc, but set up the identity indexes and primary keys? I find when I use DTS to bring a table into my local database, the identity attribute isnt set on the ID field, and the ID field isnt set as primary key,so when I'm doing testing inserts fail. Is there an option somewhere I'm missing? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 10:21:02 -0700 Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) To: CF-Talk [EMAIL PROTECTED] Ahhh...you didn't pick the right optiondon't just pick the copy all tables option (or whatever it's called...it's the default selection)...there's another option on the same screen that says something along the lines of Copy objects and data After picking that you can pick which objects to pick (think the default is everything) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
But on development systems I install everything. But then your development environment and production environment are different. So if you create something that works in the development environment it might not work in the production environment. Which is why you should have a staging server that replicates the production server. ;) Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
John Beynon wrote: I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, Ooo... which extension is that? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Comparing a list against an 2 element array?
Hope this is what you're looking for. cfset currentRoles = 1,2,4,6,9 cfloop list=#currentRoles# item=role cfloop from=1 to=#ArrayLen(Element1)# index=x cfloop from=1 to=#ArrayLen(Element2)# index=y cfif ( role eq Element1(x) ) and ( role eq Element2(y) ) !--- Code to remove the user from the invalid role --- cfbreak /cfif /cfloop /cfloop /cfloop From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 4:26 PM To: CF-Talk Subject: Comparing a list against an 2 element array? This request has blown me away, I cant get my hands around it. The current user roles lists all the roles the user is in. The 2 element array is combinations of roles which are not allowed. The end result is the user will be removed from the roles which conflict. I dont really know where to start on this one. Has anyone done anything like this or know where to look? please see below. Current User roles 1 2 4 6 9 Invalid Combinations Element1Element2 12 21 33 46 57 98 So, if I look at the data the user is currently in 3 invalid combinations of roles. (1 and 2) (2 and 1) and (4 and 6) Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: File names not correctly ordered
The only thing I can think of is to add a new QueryColumn and use ListLast(Filename, _) as the new columns value then sort by that or rename your files to something like File_001 File_002 File_003 File_010 File_020 File_030 cfloop query=GetAllFIles cfset NewFile = File_ NumberFormat(ListLast(name, _), 000) cffile action="" source=#serverdir##docpath#\#name# destination=#serverdir##docpath#\#newfilename# /cfloop Just use a larger mask if you think there will ever be more than 100 files (000) or a file name greater than FILE_100 -OR- You could just sort by the date attribute if those files were created in sequential order : ) _ From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:53 PM To: CF-Talk Subject: File names not correctly ordered hrmm..I just noticed in my output after a directory query, when displaying files it orders them as follows... file_1 file_10 file_2 file_20 file_3 etc etc, instead of the preferred file_1 file_2 file_3 file_10 file_20 I know how to correct this when dealing with *just* numeric info, but not with letters and numbers. My queries are pretty straightfoward... cfdirectory name=getAllFiles action=""> directory=#serverdir##docpath# sort=name ASC cfquery dbtype=query name=getAllFiles_#docpath# SELECT * FROM getAllFiles /cfquery Any ideas on how to sort this out?? Regards Mark H _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:179599This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=11 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Query/DB design problem
I understand now that it should do an aggregate.After I posted this and went home for the day, a friend posted me a solution that worked ok and his emphasized the aggregate too, but looks a bit more complicated to read: SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r WHERE p.p_id = a.pA_pollID AND a.pA_id = r.pV_poll_answer AND p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id union all select p.p_id,p.p_question, a.pA_answer, 0 AS total FROM fsnep_polls p, fsnep_pollAnswers a WHERE p.p_id = a.pA_pollID AND p.p_id = #url.poll# AND not exists (select 1 from fsnep_pollresults r where a.pA_id = r.pV_poll_answer) order by 2,3,1 Thank you for replying.I read through your sql and understand it.I'm learning alot each time I do one of these.This is my first relational and it sure seem to complicate the query side of the db work. The query has to select the aggregrate and then outer join the related table. This is just a stab in the dark as to how the query would look, but if you can see what I'm trying to do, you can follow the concept to completion.I'm not a DBA so take this as a guideline and not the solution (unless, of course, it *is* the solution in which case feel free to praise me) cfquery name=poll_results datasource=eatsmart SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p INNER JOIN rfsnep_pollAnswers aON a.pA_pollID = p.p_id OUTER JOIN fsnep_pollresults r ON r.pV_poll_answer = a.pA_id WHERE p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id ORDER BY p.p_question, a.pA_answer /cfquery From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:26 AM To: CF-Talk Subject: Query/DB design problem I recently asked how to structure a query to request poll results from my db. I've listed the db structure and the query below. The problem that I now have is that it only lists poll answers that have been answered once.I know that this is because it's querying the Results table (fsnep_pollresults) and that if there are answers that have not been selected, then they won't show up in the results table. I don't know of a good, clean way of making this query includethem. The only way I know to do it is to get a list of the answers and set up a query that looks for the count of each of the answers.So if there are 5 answers, I'll have 5 queries.It sounds like a resource hog to me. Any thoughts? Query: cfquery name=poll_results datasource=eatsmart SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r WHERE p.p_id = a.pA_pollID AND a.pA_id = r.pV_poll_answer AND p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id ORDER BY p.p_question, a.pA_answer, p.p_id /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: File names not correctly ordered
Your message is a reply to anothers = (anothers) post and is more than 100 lines of text. Unless you are a major writer, your = (youre) probably adding a lot of the previous replies. Please trim your posts when replying. Thank you. The only thing I can think of is to add a new QueryColumn and use ListLast(Filename, _) as the new columns value then sort by that or rename your files to something like File_001 File_002 File_003 File_010 File_020 File_030 cfloop query=GetAllFIles cfset NewFile = File_ NumberFormat(ListLast(name, _), 000) cffile action="" source=#serverdir##docpath#\#name# destination=#serverdir##docpath#\#newfilename# /cfloop Just use a larger mask if you think there will ever be more than 100 files (000) or a file name greater than FILE_100 -OR- You could just sort by the date attribute if those files were created in sequential order : ) --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: refresh inserts my form content
ok, charlie and Dave, that's a good point.Now, I'm gonna go do it, but my first thought is that when the user clicks the back button, it'll re-insert then. Greg, I'm rereading your solution again, but I'm not sure which primary key that you mean.For the actual answer/result into the results table?So insert, get the PK,then write that to a cookie?You say that I have a primary key on the form page, and I do, but it's the poll Id.That poll can be answered multiple times on one machine, since alot of our user base uses community machines.I just want it set up so that they MUST click a poll answer and submit each time they vote. one solution is to use a 3-page approach. form page - update page - thank you page the form page is self-explanatory.contains your form. the update page has your updat query in it.once the query succeeds, do a cflocation to... the thank you page.this is the page that lets your user know the update completed successfully.and since it contains no UPDATE query itself, it can be refreshed over and over and over with no adverse effects on your data :) On Wed, 22 Sep 2004 14:04:36 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: refresh inserts my form content
cflocation actually does the equivalent of the _javascript_ function location.replace().The header actually gets redirected to a different page than the one originally requested.This means that on the thank you page, clicking the back button will take the user to the form page and not the processing page. From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 8:28 AM To: CF-Talk Subject: Re: refresh inserts my form content ok, charlie and Dave, that's a good point.Now, I'm gonna go do it, but my first thought is that when the user clicks the back button, it'll re-insert then. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: refresh inserts my form content
Or use a challenge response. This cannot be spoofed in any way. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
datetime problems - 01/01/1900
Hello, I'm assuming this one should be an easy one.I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as NULL, but instead, it's going in as 1/1/1900. How should I do my query where I can send a NULL Value? Thanks, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
it was built into to v0.9 but it looks like they've taken it out of the 1.0 release. :( On Fri, 24 Sep 2004 12:46:16 +0100, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: John Beynon wrote: I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, Ooo... which extension is that? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
Sounds like the field itself is set to NOT NULL in the database.When that's the case, not sending it a value will make the DB insert the value that you're seeing.You need to redefine that field so that it accepts NULL values. From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 8:52 AM To: CF-Talk Subject: datetime problems - 01/01/1900 Hello, I'm assuming this one should be an easy one.I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as NULL, but instead, it's going in as 1/1/1900. How should I do my query where I can send a NULL Value? Thanks, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
cfqueryparam cfsqltype=cf_sql_timestamp value=#myvar# null=#YesNoFormat(NOT Len(myvar))# Maybe the cfsqltype needs another value depending on the DB Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 14:52 To: CF-Talk Subject: datetime problems - 01/01/1900 Hello, I'm assuming this one should be an easy one.I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as NULL, but instead, it's going in as 1/1/1900. How should I do my query where I can send a NULL Value? Thanks, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: datetime problems - 01/01/1900
The table column allows null values. Hey Pascal, hope you're doing well mate! I copied your code. I am checking for some condition; if it is false, I want to insert null in the datetime column. ActionDateTime = cfqueryparam cfsqltype=cf_sql_timestamp value= null=#YesNoFormat(0)# I get an error when I submit the form Error Occurred While Processing Request The cause of this output exception was that: java.lang.NullPointerException. Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: refresh inserts my form content
cflocation actually does the equivalent of the _javascript_ function location.replace().The header actually gets redirected to a different page than the one originally requested.This means that on the thank you page, clicking the back button will take the user to the form page and not the processing page. That worked great.I didn't realize that it did a replace().Good to know too. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
On Friday 24 Sep 2004 13:51 pm, John Beynon wrote: it was built into to v0.9 but it looks like they've taken it out of the 1.0 release. Possibly because it didn't work :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: datetime problems - 01/01/1900
my bad. It works now, I changed the null attribute to yes and it submits 'null' in the db Thanks for your help guys [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
It should look something like: INSERT INTO table (datecolumn,...) VALUES ( cfqueryparam cfsqltype=cf_sql_timestamp value=#myvar# null=#YesNoFormat(NOT Len(myvar))#, ... ) Where myvar holds the date/time value and you want to insert null if it is empty. If you want to insert null if mycondition is false : VALUES ( cfqueryparam cfsqltype=cf_sql_timestamp value=#myvar# null=#YesNoFormat(NOT mycondition)#, ... ) Just make sure that myvar always exists (it will be ignored if mycondition is false. Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 15:14 To: CF-Talk Subject: Re: datetime problems - 01/01/1900 The table column allows null values. Hey Pascal, hope you're doing well mate! I copied your code. I am checking for some condition; if it is false, I want to insert null in the datetime column. ActionDateTime = cfqueryparam cfsqltype=cf_sql_timestamp value= null=#YesNoFormat(0)# I get an error when I submit the form Error Occurred While Processing Request The cause of this output exception was that: java.lang.NullPointerException. Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hot-fixes
I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What makes you think the hotfix has no bugs of its own? If something works satisfactorily, you may be better off leaving it as it is. Hotfixes address specific problems, but they potentially introduce new unknown problems. The best example I can think of is with the database drivers. There were all sorts of problems with the database drivers shipped with CFMX 6.1, but there are also problems with the newer drivers. For most people I've dealt with, the new problems are less serious than the old ones, but it hasn't been that way for everyone. Granted, some of the hotfixes are very simple, and unlikely to have bugs, but this is something you'd want to evaluate on a case-by-case basis. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
Just a point to note: cfqueryparam ... null=#YesNoFormat(NOT Len(myvar))# You don't actually need the yesnoformat() function call in there -- the null= field takes a boolean value; a numeric value can be treated as a boolean (any non-zero value is TRUE), and len() returns a numeric value, so you can just use: cfqueryparam ... null=#NOT len(myvar)# Maybe it's just me being picky...:) Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
I'm still working a lot on CF5 and #NOT len(myvar)# doesn't work then! You need to wrap it in a function. Pascal -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 15:23 To: CF-Talk Subject: [Spam?] RE: datetime problems - 01/01/1900 Just a point to note: cfqueryparam ... null=#YesNoFormat(NOT Len(myvar))# You don't actually need the yesnoformat() function call in there -- the null= field takes a boolean value; a numeric value can be treated as a boolean (any non-zero value is TRUE), and len() returns a numeric value, so you can just use: cfqueryparam ... null=#NOT len(myvar)# Maybe it's just me being picky...:) Tim. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Ok, but until you install it you are not going to know if the hot-fix has extra bugs in it. I agree that if a server is stable then installing hot-fixes doesn't make sense. I guess my point is more that would be nice to be informed a new fix is available and be given the chance to evaulate it. Andrew. - Original Message - From: Dave Watts [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 09:27:09 -0400 Subject: RE: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What makes you think the hotfix has no bugs of its own? If something works satisfactorily, you may be better off leaving it as it is. Hotfixes address specific problems, but they potentially introduce new unknown problems. The best example I can think of is with the database drivers. There were all sorts of problems with the database drivers shipped with CFMX 6.1, but there are also problems with the newer drivers. For most people I've dealt with, the new problems are less serious than the old ones, but it hasn't been that way for everyone. Granted, some of the hotfixes are very simple, and unlikely to have bugs, but this is something you'd want to evaluate on a case-by-case basis. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: datetime problems - 01/01/1900
I'm still working a lot on CF5 and #NOT len(myvar)# doesn't work then!You need to wrap it in a function. OK, you win on that one...;) I'll qualify: *In CFMX* you don't actually need the yesnoformat() function call in there... Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: datetime problems - 01/01/1900
cheers guys! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
.cgi conversion
Hi, Is there any tool out there which is basically convert the .cgi scripts to any other language like php or possibly cfm or maybe asp thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Oracle connection refused error with CFSCHEDULE task only
We're getting an Oracle error when we run a page through CFSCHEDULE but not when we browse to the page.The page does a full-text index on the database by querying all the data, writing out text files for each record, and then indexing the text files.(we found that writing text files and indexing those is at least 10 times faster than indexing the query directly--no idea why). So when we browse to the page it runs though and indexes everythign fine. When we run it via cfschedule, we get this weird error I've never seen before and couldn't find anything about online. Also look at the file list, it's odd that it lists the CF call stack twice with part of the error message in between as a Called from template.The Java stack trace is correct though. Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' The error occurred in E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 Called from DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=125 00)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BU F='32-bit Windows Error: 2: line -1 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 32 : 33 : AND t.id = #id# 34 : ORDER BY 35 : t.nasa_id SQL SELECT t.ID, t.UPN_ID, t.SUB_UPN, t.TASK_NAME, t.COMMENTS, t.CCCLEVEL, t.RELEASE_NAME, t.URL, t.DATE_MODIFIED, m.Maturity_Descrip, users.LoginName AS Modified_By, e.Enterprise_Name, c.center_name FROM Task t, Maturity_LU m, InventoryUsers users, UPN_Lu upn, Enterprise_LU e, Center_LU c WHERE t.Maturity_ID = m.Maturity_ID AND t.Modified_By_ID = users.User_ID AND t.RecordStatus != 'D' AND upn.enterprise_id = e.enterprise_id AND t.center_id = c.center_id AND t.upn_id = upn.upn_id ORDER BY t.id DATASOURCE SystemTestInput2005 Please try the following: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser CFSCHEDULE Remote Address 128.183.235.210 Referrer Date/Time 23-Sep-04 11:00 PM Stack Trace at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:677 ) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.ja va:123) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java: 138) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java: 125) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at
RE: datetime problems - 01/01/1900
If I can give a solution that works in cf5 AND cfmx, I will always give that one. I will usually specify if a solution is cfmx specific. A lot of people are still using CF5 (or even cf4.5). Sometimes it's worth giving a CFMX only solution, because the cf5 solution is more complicated or even impossible. But in this case it was just the YesNoFormat(), so not much difference. Whenever I answer (and sometimes ask) questions on this list, I try to be as precise as possible. Although it's not always Friday afternoon, so I don't always have the time to write a lot of prose to explain myself ;) Pascal -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 15:34 To: CF-Talk Subject: [Spam?] RE: datetime problems - 01/01/1900 I'm still working a lot on CF5 and #NOT len(myvar)# doesn't work then!You need to wrap it in a function. OK, you win on that one...;) I'll qualify: *In CFMX* you don't actually need the yesnoformat() function call in there... Tim. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
searching .gz compressed files
Does anyone know if the standard Verity server with CF 5 or 6.1 can catalog the contents of .gz files?I'm building a tool to archive all incomign and outgoing mail to a server and to offer a web based search tool that can be used to search through the arcived mail based on date ranges, and search for either plain text contents of mail messages, or all mail from: or all mail to: etc. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: .cgi conversion
Is there any tool out there which is basically convert the .cgi scripts to any other language like php or possibly cfm or maybe asp No, not to my knowledge. I think that generic CGI programs might be written in all sorts of languages - some of which may not be scripting languages at all. If I recall correctly, most CGI programs with a .cgi extension are compiled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Regex Question
Hi All, Got a regex question. Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> I've got the following regex ,\[GT:([a-zA-Z0-9 \'\\/]*)\], but the problem is that I really need to check for any character between [GT: and ]. I know it should be something like \[GT:(.*)\] but I cant figure out how to enter in the exception for ] TIA, Duane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex Question
Duane Boudreau wrote: Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> I've got the following regex ,\[GT:([a-zA-Z0-9 \'\\/]*)\], but the problem is that I really need to check for any character between [GT: and ]. \[GT:([^\]]+)\] Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex Question
On CFMX, this is the cleanest to read: \[GT:(.*?)\] On CF5, you'll have to use: \[GT:([^]])\] Not tested, may need tweaking, YMMV, etc. --Ben Duane Boudreau wrote: Hi All, Got a regex question. Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> I've got the following regex ,\[GT:([a-zA-Z0-9 \'\\/]*)\], but the problem is that I really need to check for any character between [GT: and ]. I know it should be something like \[GT:(.*)\] but I cant figure out how to enter in the exception for ] TIA, Duane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Action Canceled, XP Service Pack 2
I'm using a combination of Flash and Coldfusion web services to generate an Excel Spreadhseet (technically, the web service saves an html file on the server with a .xls extension), and returns the URL to Flash.Flash then uses getURL to open the .xls file in a new browser window. This worked great but now with Windows XP Service Pack 2, the new window pops up and then is filled with an Action Canceled message.If you click Refresh in the toolbar of that window, it opens the spreadsheet just fine. Has anyone experience a similar problem and solved it? -- Another annoyance with Service Pack 2 is the popup blocker, which also blocks the new window.. it's not technically a popup... it's just a new browser window.. like a target=_blank .../a But even after allowing popups from the domain, you still get the Action canceled message.. - rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regex Question
Both Jochem and Ben were very close, here's what worked: \[GT:([^]]*)\] All I had to do was add the * Thanks Guys! Duane _ From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 10:29 AM To: CF-Talk Subject: Re: Regex Question On CFMX, this is the cleanest to read: \[GT:(.*?)\] On CF5, you'll have to use: \[GT:([^]])\] Not tested, may need tweaking, YMMV, etc. --Ben Duane Boudreau wrote: Hi All, Got a regex question. Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> I've got the following regex ,\[GT:([a-zA-Z0-9 \'\\/]*)\], but the problem is that I really need to check for any character between [GT: and ]. I know it should be something like \[GT:(.*)\] but I cant figure out how to enter in the exception for ] TIA, Duane _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle connection refused error with CFSCHEDULE task only
Do you have any limitations on the number of sessions the Oracle account you are using is allowed? -Adam - Original Message - From: Samuel Neff [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 09:39:54 -0400 Subject: Oracle connection refused error with CFSCHEDULE task only To: CF-Talk [EMAIL PROTECTED] We're getting an Oracle error when we run a page through CFSCHEDULE but not when we browse to the page.The page does a full-text index on the database by querying all the data, writing out text files for each record, and then indexing the text files.(we found that writing text files and indexing those is at least 10 times faster than indexing the query directly--no idea why). So when we browse to the page it runs though and indexes everythign fine. When we run it via cfschedule, we get this weird error I've never seen before and couldn't find anything about online. Also look at the file list, it's odd that it lists the CF call stack twice with part of the error message in between as a Called from template.The Java stack trace is correct though. Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' The error occurred in E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 Called from DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=125 00)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BU F='32-bit Windows Error: 2: line -1 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 32 : 33 : AND t.id = #id# 34 : ORDER BY 35 : t.nasa_id SQL SELECT t.ID, t.UPN_ID, t.SUB_UPN, t.TASK_NAME, t.COMMENTS, t.CCCLEVEL, t.RELEASE_NAME, t.URL, t.DATE_MODIFIED, m.Maturity_Descrip, users.LoginName AS Modified_By, e.Enterprise_Name, c.center_name FROM Task t, Maturity_LU m, InventoryUsers users, UPN_Lu upn, Enterprise_LU e, Center_LU c WHERE t.Maturity_ID = m.Maturity_ID AND t.Modified_By_ID = users.User_ID AND t.RecordStatus != 'D' AND upn.enterprise_id = e.enterprise_id AND t.center_id = c.center_id AND t.upn_id = upn.upn_id ORDER BY t.id DATASOURCESystemTestInput2005 Please try the following: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser CFSCHEDULE Remote Address 128.183.235.210 Referrer Date/Time 23-Sep-04 11:00 PM Stack Trace at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:677 ) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.ja va:123) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java: 138) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java: 125) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207) at
RE: Oracle connection refused error with CFSCHEDULE task only
No limitations, and at that time of day, there should be zero activity (it's an intranet site, US only).We did try changing the time of day from 2:00 AM to 11:00 PM but that didn't have any affect. Sam -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 10:56 AM To: CF-Talk Subject: Re: Oracle connection refused error with CFSCHEDULE task only Do you have any limitations on the number of sessions the Oracle account you are using is allowed? -Adam - Original Message - From: Samuel Neff [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 09:39:54 -0400 Subject: Oracle connection refused error with CFSCHEDULE task only To: CF-Talk [EMAIL PROTECTED] (snip) Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex Question
Oops.Heh.Well, that's why I put the disclaimer at the bottom.:-) --Ben Duane Boudreau wrote: Both Jochem and Ben were very close, here's what worked: \[GT:([^]]*)\] All I had to do was add the * Thanks Guys! Duane _ From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 10:29 AM To: CF-Talk Subject: Re: Regex Question On CFMX, this is the cleanest to read: \[GT:(.*?)\] On CF5, you'll have to use: \[GT:([^]])\] Not tested, may need tweaking, YMMV, etc. --Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: .cgi conversion
The tool below will turn .class files to .java files. .cgi files can be created from c, c++, java Many languages. If it is java byte code (like a class file) then you can use this reverse engineering tool. You can then use the .java source file that is generated to create your .cfm or .asp page. It will take work to create the CF page from the java source, but it is better than not having the source at all. Also, you could hire or get a java consultant who could easily turn the .java source file into CF or ASP. http://members.fortunecity.com/neshkov/dj.html http://members.fortunecity.com/neshkov/dj.html Good luck. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 9:03 AM To: CF-Talk Subject: RE: .cgi conversion Is there any tool out there which is basically convert the .cgi scripts to any other language like php or possibly cfm or maybe asp No, not to my knowledge. I think that generic CGI programs might be written in all sorts of languages - some of which may not be scripting languages at all. If I recall correctly, most CGI programs with a .cgi extension are compiled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle connection refused error with CFSCHEDULE task only
One of the first things I always check with CFSHEDULE problems is does the user account that the Cold Fusion service run as, usually system if not modified, have permission to all the resources necessary to do its task.In your case I would check the file security on the directories to which you are trying to write.You may also want to double check the permissions to Oracle as well. The basic issue is that when you browse to the template the system uses your premisssions and can access resources that you have permission to utilize.But when CFSHEDULE runs the same template it can only use the permissions of the account used by the CF service and these are usually very limited if left to the defaults. Hope that helps. Ian BloodSource www.bloodsource.org We're getting an Oracle error when we run a page through CFSCHEDULE but not when we browse to the page.The page does a full-text index on the database by querying all the data, writing out text files for each record, and then indexing the text files.(we found that writing text files and indexing those is at least 10 times faster than indexing the query directly--no idea why). So when we browse to the page it runs though and indexes everythign fine. When we run it via cfschedule, we get this weird error I've never seen before and couldn't find anything about online. Also look at the file list, it's odd that it lists the CF call stack twice with part of the error message in between as a Called from template.The Java stack trace is correct though. Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' The error occurred in E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 Called from DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=125 00)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BU F='32-bit Windows Error: 2: line -1 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select _All.cfm: line 33 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw ord_docs.cfm: line 9 Called from E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line 11 32 : 33 : AND t.id = #id# 34 : ORDER BY 35 : t.nasa_id SQL SELECT t.ID, t.UPN_ID, t.SUB_UPN, t.TASK_NAME, t.COMMENTS, t.CCCLEVEL, t.RELEASE_NAME, t.URL, t.DATE_MODIFIED, m.Maturity_Descrip, users.LoginName AS Modified_By, e.Enterprise_Name, c.center_name FROM Task t, Maturity_LU m, InventoryUsers users, UPN_Lu upn, Enterprise_LU e, Center_LU c WHERE t.Maturity_ID = m.Maturity_ID AND t.Modified_By_ID = users.User_ID AND t.RecordStatus != 'D' AND upn.enterprise_id = e.enterprise_id AND t.center_id = c.center_id AND t.upn_id = upn.upn_id ORDER BY t.id DATASOURCE SystemTestInput2005 Please try the following: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser CFSCHEDULE Remote Address 128.183.235.210 Referrer Date/Time 23-Sep-04 11:00 PM Stack Trace at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory 2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12 500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B UF='32-bit Windows Error: 2: No such file or directory' at
RE: Oracle connection refused error with CFSCHEDULE task only
We're not using any type of HTTP-level authentication and users browsing the site don't have any accounts or anythign on the server.It's all default setup for CF server users. And besides that, the error is on the query, before we ever get to the file write. Could what you describe still be the problem? Thanks, Sam -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 11:13 AM To: CF-Talk Subject: Re: Oracle connection refused error with CFSCHEDULE task only One of the first things I always check with CFSHEDULE problems is does the user account that the Cold Fusion service run as, usually system if not modified, have permission to all the resources necessary to do its task.In your case I would check the file security on the directories to which you are trying to write.You may also want to double check the permissions to Oracle as well. The basic issue is that when you browse to the template the system uses your premisssions and can access resources that you have permission to utilize.But when CFSHEDULE runs the same template it can only use the permissions of the account used by the CF service and these are usually very limited if left to the defaults. Hope that helps. Ian BloodSource www.bloodsource.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex Question
WIthout sounding silly. Isn't this more of a simple replace rather than using RegEx? replace(string, '[GT:moons]', 'a href=""> ', 'all') Just a thought Andy On Fri, 24 Sep 2004 10:18:53 -0400, Duane Boudreau [EMAIL PROTECTED] wrote: Hi All, Got a regex question. Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> I've got the following regex ,\[GT:([a-zA-Z0-9 \'\\/]*)\], but the problem is that I really need to check for any character between [GT: and ]. I know it should be something like \[GT:(.*)\] but I cant figure out how to enter in the exception for ] TIA, Duane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: .cgi conversion
I was talking about Common Gateway Interface (CGI) which uses Perl scripts. The previous developer was developing apps in CGI, and its almost obsolete now, so I was thinking to convert those apps in cf or asp. But .cgi/perl scripts are very confusing. I thought maybe some knows about any tool who can at least convert those Perl scripts to any language which then easy to understand But thanks anyway. The tool below will turn .class files to .java files. .cgi files can be created from c, c++, java Many languages. If it is java byte code (like a class file) then you can use this reverse engineering tool. You can then use the .java source file that is generated to create your .cfm or .asp page. It will take work to create the CF page from the java source, but it is better than not having the source at all. Also, you could hire or get a java consultant who could easily turn the .java source file into CF or ASP. http://members.fortunecity.com/neshkov/dj.html http://members.fortunecity.com/neshkov/dj.html Good luck. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 9:03 AM To: CF-Talk Subject: RE: .cgi conversion Is there any tool out there which is basically convert the .cgi scripts to any other language like php or possibly cfm or maybe asp No, not to my knowledge. I think that generic CGI programs might be written in all sorts of languages - some of which may not be scripting languages at all. If I recall correctly, most CGI programs with a .cgi extension are compiled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex Question
Andy Jarrett wrote: WIthout sounding silly. Isn't this more of a simple replace rather than using RegEx? A replace is actually more difficult since you would probably want to preserve case. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle connection refused error with CFSCHEDULE task only
We're not using any type of HTTP-level authentication and users browsing the site don't have any accounts or anythign on the server.It's all default setup for CF server users. And besides that, the error is on the query, before we ever get to the file write. Could what you describe still be the problem? I don't know, but it should be easy enough to check. Just comment out the file write section, and rerun your scheduled task. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle connection refused error with CFSCHEDULE task only
Any hints in your oracle logs? I don't think it matters what local account is used to run the scheduler as it is accessing everything it needs and making the request to Oracle. There is somthing about that connection/session that oracle doesn't like. This sounds really stupid, but if you don't have anything better to try why not call the template you are trying to execute via cfhttp. Then setup the template which makes teh cfhttp call in the scheduler. I would imagine if it has anything to do at all with how the scheduler processes the template, this should work. What drivers are you using? -Adam - Original Message - From: Samuel Neff [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 11:12:22 -0400 Subject: RE: Oracle connection refused error with CFSCHEDULE task only To: CF-Talk [EMAIL PROTECTED] We're not using any type of HTTP-level authentication and users browsing the site don't have any accounts or anythign on the server.It's all default setup for CF server users. And besides that, the error is on the query, before we ever get to the file write. Could what you describe still be the problem? Thanks, Sam -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 11:13 AM To: CF-Talk Subject: Re: Oracle connection refused error with CFSCHEDULE task only One of the first things I always check with CFSHEDULE problems is does the user account that the Cold Fusion service run as, usually system if not modified, have permission to all the resources necessary to do its task.In your case I would check the file security on the directories to which you are trying to write.You may also want to double check the permissions to Oracle as well. The basic issue is that when you browse to the template the system uses your premisssions and can access resources that you have permission to utilize.But when CFSHEDULE runs the same template it can only use the permissions of the account used by the CF service and these are usually very limited if left to the defaults. Hope that helps. Ian BloodSource www.bloodsource.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: .cgi conversion
I was talking about Common Gateway Interface (CGI) which uses Perl scripts. The previous developer was developing apps in CGI, and it's almost obsolete now, so I was thinking to convert those apps in cf or asp. But .cgi/perl scripts are very confusing. Just to clarify, CGI is an API, not a programming language. You can write CGI programs in Perl, but you can also write them in C (and of course, those programs are compiled). Up until recently, CF supported CGI. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Issues searching for text within files
set up a verity collection and indexed a directory of .cfm files on our server that I want to be able to search the contents for some string values. I did a cfsearch with the criteria as * so I could be sure the all the files were indexed and they were. So I did a cfsearch for a particular word that I had a count of occurrences from doing a grep search which returned a resultset of 12 files. Using cfsearch only 6 files were returned to me. I've tried switching to the k2 engine. I've tried searching other words and find the same issue---not an accurate resultset. One of the text strings appears in the same manner in one file as it does in another (it's the name of a procedure that is in the cfstoredproc procedure attribute) yet only one of the of the files comes back in the result set. This is my cfsearch text: cfsearch collection=SMC name=smc_search type=simple criteria=#lcase(form.search_string)# If I switch the type to explicit, I get this error: coldfusion.tagext.lang.CFSearchTagException: Error # -2 Error E1-0106 (Query Builder): No topic built.. Does anyone have any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Spam?] Re: Regex Question
I suspect that he wants to replace all glossary terms, not just moons: REReplace(string,'\[GT:([^]]+)\]','a href=""> Pascal -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 17:28 To: CF-Talk Subject: [Spam?] Re: Regex Question WIthout sounding silly. Isn't this more of a simple replace rather than using RegEx? replace(string, '[GT:moons]', 'a href=""> ', 'all') Just a thought Andy On Fri, 24 Sep 2004 10:18:53 -0400, Duane Boudreau [EMAIL PROTECTED] wrote: Hi All, Got a regex question. Sample content block: There are 31 [GT:moons] that surround Saturn I need to replace [GT:moons] with a href=""> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle connection refused error with CFSCHEDULE task only
We're not using any type of HTTP-level authentication and users browsing the site don't have any accounts or anything on the server.It's all default setup for CF server users. And besides that, the error is on the query, before we ever get to the file write. Could what you describe still be the problem? Thanks, Sam It could be, even if the users do not log in, they have a default user account, ISSR_USER or something like that on Windows systems, and even this default basic user often has more permissions then the default system user that the CF service runs under.The way to check this is to go to Admin - Services on the server, right click on the Cold Fusion Application Server Service, select Properties and then the Log On tab.It is probably set to the default Local System account.If so, try selecting This account and then give it an account you know has plenty of permissions (such as yours).Then of course restart the service.See if this fixes the problem.If it does, then you will probably want to create an account specifically for the Cold Fusion Server, and then assign the appropriate permissions to this account.That is what we have done here. This is of course assuming a Windows server; I have no knowledge on how this works in the linix/unix world. I'm not sure if this applies to a problem with the query, but I have often found this is the problem if a template works when directly browsed but does not work when accessed by CFSCHEDULE. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle connection refused error with CFSCHEDULE task only
It could be, even if the users do not log in, they have a default user account, ISSR_USER or something like that on Windows systems, and even this default basic user often has more permissions then the default system user that the CF service runs under. There are two problems with that theory. First, when you use CFSCHEDULE or CFHTTP, the CF server simply sends an HTTP request to your web server. If you don't provide a username and password, and none is needed for that URL, IIS will use the anonymous login to authenticate against the OS. So, that shouldn't make any difference. Second, the anonymous login account (IUSR_WHATEVER) is a guest account and has very few privileges by default. CF, on the other hand, runs as SYSTEM by default, which is a very privileged local security context. As long as CF doesn't require any resources elsewhere on the network, SYSTEM is as privileged as you can get! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Change Default Untitled template in cfstudio 4.5?
Hi all, I want to change my default document, using cfstudio 4.5. Basically I wish to use a different Doctype, etc for all new Untitled files. Have check the settings, registry and options but can't seem to find where this is done. Anyone know? TIA, Dave __ Dave Wilson, CTO Integrated Autos Solutions Ltd. (Karsystems) 155 Northumberland Street, Belfast, BT13 2JF t: +44 (0) 28 9024 3123 f: +44 (0) 28 9024 3124 e: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: print output
Does anyone have a link for theCF_HTML2PDF3 tag I cant seem to find anything through Google. Brant, It seems that the macromedia exchange is down right now. Contact me off list at larryclyons(at)gmail(dot)com and I'll forward you a copy of it. regards, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Change Default Untitled template in cfstudio 4.5?
I want to change my default document, using cfstudio 4.5. Basically I wish to use a different Doctype, etc for all new Untitled files. Have check the settings, registry and options but can't seem to find where this is done. Within your CF Studio installation directory, you should have a file somewhere called Default Template.htm. You can edit that file directly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Change Default Untitled template in cfstudio 4.5?
options settings file locations Doug - Original Message - From: Dave Wilson [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 17:39:56 +0100 Subject: Change Default Untitled template in cfstudio 4.5? To: CF-Talk [EMAIL PROTECTED] Hi all, I want to change my default document, using cfstudio 4.5. Basically I wish to use a different Doctype, etc for all new Untitled files. Have check the settings, registry and options but can't seem to find where this is done. Anyone know? TIA, Dave __ Dave Wilson, CTO Integrated Autos Solutions Ltd. (Karsystems) 155 Northumberland Street, Belfast, BT13 2JF t: +44 (0) 28 9024 3123 f: +44 (0) 28 9024 3124 e: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Linux IDE
I am looking for a decent cf editor to use on my Linux workstation.Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Change Default Untitled template in cfstudio 4.5?
Within your CF Studio installation directory, you should have a file somewhere called Default Template.htm. You can edit that file directly. Excellent thanks Dave. Should have thought of that myself really :) Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux IDE
CFEclipse is an Eclipse plugin for CFML development.It's quite nice. If you're running KDE (or at least have the libs installed), also check out Quanta.It's a generic web editor, but I worked for a while getting CFML tag insight and all that set up on it a couple years ago. cheers, barneyb On Fri, 24 Sep 2004 13:07:14 -0400, Noah Mudge [EMAIL PROTECTED] wrote: I am looking for a decent cf editor to use on my Linux workstation.Any ideas? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com I currently have 6 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Linux IDE
I am looking for a decent cf editor to use on my Linux workstation.Any ideas? If you're comfy enough with vim, you can set it to use coldfusion syntax as follows: :set syntax=coldfusion :syntax on HTH, Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Linux IDE
From: Noah Mudge [mailto:[EMAIL PROTECTED] I am looking for a decent cf editor to use on my Linux workstation.Any ideas? When on linux I strictly use PICO! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hot-fixes
... snipped ... I agree that if a server is stable then installing hot-fixes doesn't make sense. ... snipped ... Andrew. What if you are building a new server (migrating from CF 5) - do you install CFMX 6.1 and stop there, or do you also install the recently released updater, or do you install individual hot fixes based on your knowledge and what you feel is appropriate? George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Hot-fixes
What if you are building a new server (migrating from CF 5) - do you install CFMX 6.1 and stop there, or do you also install the recently released updater, or do you install individual hot fixes based on your knowledge and what you feel is appropriate? At this point, I think I'd immediately install the updater. Most of the hotfixes are pretty innocuous - the only one that I know is problematic is the database drivers, and in the vast majority of cases the newer ones work much better than the older ones. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux IDE
A couple of other options, both Java-based: - Jedit from jedit.org, CF-specific customization advice at http://www.joshuasmiller.com/jedit/index.cfm - He3, early beta version available from http://richpalette.com -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux IDE
On Fri, 24 Sep 2004 14:09:52 -0400, hofo [EMAIL PROTECTED] wrote: A couple of other options, both Java-based: - Jedit from jedit.org, CF-specific customization advice at http://www.joshuasmiller.com/jedit/index.cfm - He3, early beta version available from http://richpalette.com When I went to the HE3 site it indicated that Linux support is planned for the future... or are you saying that earlier Beta versions of it will work? Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux IDE
Noah Mudge wrote: I am looking for a decent cf editor to use on my Linux workstation.Any ideas? Vivio Technologies is a Linux-only shop. Even our workstations are Linux. We've been using DreamWeaver MX and Crossover Office with great success. =) HTH, -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux IDE
Doh! Reading doesn't work without comprehension! No, there's no current release that will work in Linux. Sorry. So much for write once, run anywhere. On Fri, 24 Sep 2004 14:26:08 -0400, C. Hatton Humphrey [EMAIL PROTECTED] wrote: On Fri, 24 Sep 2004 14:09:52 -0400, hofo [EMAIL PROTECTED] wrote: A couple of other options, both Java-based: - Jedit from jedit.org, CF-specific customization advice at http://www.joshuasmiller.com/jedit/index.cfm - He3, early beta version available from http://richpalette.com When I went to the HE3 site it indicated that Linux support is planned for the future... or are you saying that earlier Beta versions of it will work? Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Fwd: New Macromedia Security Zone Bulletins Posted]
If you've already updated CFMX 6.1 with the 6.1 Updater, you do not need to take any action. The release notes for the CFMX 6.1 Updater (http://www.macromedia.com/support/documentation/en/coldfusion/mx61updater/releasenotes_cfmx61_updater.html) clearly explain installation procedures and requirements for the different configurations of ColdFusion including running on top of JRun. Jim Schley ColdFusion Team Macromedia Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Linux IDE
We don't currently support Linux as we only have installers for Windows and Mac OS X. He3 will run on Linux, but it is expected you know what you are doing. That will change in the future when we provide installers for Linux as well. With all that being said, if you want to run He3 on Linux and need some help we are glad to help. I highly recommend the He3 mailing list, which is hosted by House of Fusion. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of C. Hatton Humphrey Sent: Friday, September 24, 2004 2:26 PM To: CF-Talk Subject: Re: Linux IDE On Fri, 24 Sep 2004 14:09:52 -0400, hofo [EMAIL PROTECTED] wrote: A couple of other options, both Java-based: - Jedit from jedit.org, CF-specific customization advice at http://www.joshuasmiller.com/jedit/index.cfm - He3, early beta version available from http://richpalette.com When I went to the HE3 site it indicated that Linux support is planned for the future... or are you saying that earlier Beta versions of it will work? Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cflocation inside of cflock?
Quick question...If I put a cflocation tag inside of a cflock tag, will it prevent the lock from being released? Here's an example situation: cflock name=addProgram timeout=15 cfinvoke component=components.engineer_skill method=checkProgram returnvariable=checkProgram argumentcollection=#FORM# cfif checkProgram.RecordCount NEQ 0 cfset SESSION.message = The program you selected has already been added to this skill. cfelse cfinvoke component=components.engineer_skill method=insertProgram argumentcollection=#FORM# cfinvokeargument name=SKILLSET_ID value=#SESSION.SKILLSET_ID# /cfinvoke cfset SESSION.message = You have successfully added a program. cflocation url="" addtoken=no /cfif /cflock Should I end the lock before doing the cflocation? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Database Management Tool
I'm only allowed to access our Oracle DBs through CF.So, I was wondering if there was a DB management tool built on CF that I could drop into my site (free is best since I have no budget here, but I would like to know either way). I want to be able to edit information in tables and other basic functions - nothin fancy schmancy.I just want to give it a datasource and go. I did a search on database management tools and it returned very little. thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
You can't use TOAD or SQL*Plus? -Adam - Original Message - From: Daniel Kessler [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 15:32:58 -0400 Subject: Database Management Tool To: CF-Talk [EMAIL PROTECTED] I'm only allowed to access our Oracle DBs through CF.So, I was wondering if there was a DB management tool built on CF that I could drop into my site (free is best since I have no budget here, but I would like to know either way). I want to be able to edit information in tables and other basic functions - nothin fancy schmancy.I just want to give it a datasource and go. I did a search on database management tools and it returned very little. thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Fwd: New Macromedia Security Zone Bulletins Posted]
If you've already updated CFMX 6.1 with the 6.1 Updater, you do not need to take any action. The release notes for the CFMX 6.1 Updater (http://www.macromedia.com/support/documentation/en/coldfusion /mx61updater/releasenotes_cfmx61_updater.html) clearly explain installation procedures and requirements for the different configurations of ColdFusion including running on top of JRun. If you're running CFMX on top of JRun, I was under the impression that JRun provides the web server configuration utility. According to the Security Zone bulletin, you have to install JRun Updater 4 in that case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Fwd: New Macromedia Security Zone Bulletins Posted]
If you're running CFMX on top of JRun, I was under the impression that JRun provides the web server configuration utility. According to the Security Zone bulletin, you have to install JRun Updater 4 in that case. You are correct. In that case, you should be installing both the Updater for ColdFusion MX 6.1 and Updater 4 for JRun 4. Sorry I wasn't more clear about that in my last message. -Jim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
yeah, dood, if you can use TOAD do!it simply rawks!I use it logging in with the same uid/pwd as CF does. Doug - Original Message - From: Adrocknaphobia [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 14:36:33 -0500 Subject: Re: Database Management Tool To: CF-Talk [EMAIL PROTECTED] You can't use TOAD or SQL*Plus? -Adam - Original Message - From: Daniel Kessler [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 15:32:58 -0400 Subject: Database Management Tool To: CF-Talk [EMAIL PROTECTED] I'm only allowed to access our Oracle DBs through CF.So, I was wondering if there was a DB management tool built on CF that I could drop into my site (free is best since I have no budget here, but I would like to know either way). I want to be able to edit information in tables and other basic functions - nothin fancy schmancy.I just want to give it a datasource and go. I did a search on database management tools and it returned very little. thanks! -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cflocation inside of cflock?
You are on CFMX, are you absolutely certain you need the cflock?If so, I suggest clocking only what you need and using the scope attribute too.Something like this. cflock name=addProgram timeout=15 cfinvoke component=components.engineer_skill method=checkProgram returnvariable=checkProgram argumentcollection=#FORM# cfif checkProgram.RecordCount NEQ 0 cflock scope=session timeout=15 cfset SESSION.message = The program you selected has already been added to this skill. /cflock cfelse cfinvoke component=components.engineer_skill method=insertProgram argumentcollection=#FORM# cfinvokeargument name=SKILLSET_ID value=#SESSION.SKILLSET_ID# /cfinvoke cflock scope=session timeout=15 cfset SESSION.message = You have successfully added a program. /cflock cflocation url=""> addtoken=no /cfif - Original Message - From: Adrienne Brown [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 15:26:21 -0400 Subject: cflocation inside of cflock? To: CF-Talk [EMAIL PROTECTED] Quick question...If I put a cflocation tag inside of a cflock tag, will it prevent the lock from being released? Here's an example situation: cflock name=addProgram timeout=15 cfinvoke component=components.engineer_skill method=checkProgram returnvariable=checkProgram argumentcollection=#FORM# cfif checkProgram.RecordCount NEQ 0 cfset SESSION.message = The program you selected has already been added to this skill. cfelse cfinvoke component=components.engineer_skill method=insertProgram argumentcollection=#FORM# cfinvokeargument name=SKILLSET_ID value=#SESSION.SKILLSET_ID# /cfinvoke cfset SESSION.message = You have successfully added a program. cflocation url=""> addtoken=no /cfif /cflock Should I end the lock before doing the cflocation? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Database Management Tool
OraEdit has most of the features and a fraction of the price.I personally like the interface better too (cleaner).Support has been very good too. http://www.oraedit.com/oraeditpro.htm Sam -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 3:45 PM To: CF-Talk Subject: Re: Database Management Tool yeah, dood, if you can use TOAD do!it simply rawks!I use it logging in with the same uid/pwd as CF does. Doug - Original Message - From: Adrocknaphobia [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 14:36:33 -0500 Subject: Re: Database Management Tool To: CF-Talk [EMAIL PROTECTED] You can't use TOAD or SQL*Plus? -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Database Management Tool
On Fri, 24 Sep 2004 15:32:58 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I'm only allowed to access our Oracle DBs through CF.So, I was wondering if there was a DB management tool built on CF that I could drop into my site (free is best since I have no budget here, but I would like to know either way). I want to be able to edit information in tables and other basic functions - nothin fancy schmancy.I just want to give it a datasource and go. I did a search on database management tools and it returned very little. Give Aqua Data Studio[1] and DBVisualizer[2] a look. Both offer free, or personal, version and can connect to any DB. [1] http://www.aquafold.com/ [2] http://www.minq.se/products/dbvis/ -- chris johnston www.fuzzylizard.com For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk. Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Fwd: New Macromedia Security Zone Bulletins Posted]
IIRC, the instructions for the CFMX updater for the CFMX on JRun installs said to run the JRun updater first, then the CFMX updater. Having followed that, nothing to do. Doug - Original Message - From: jschley @ macromedia. com jschley @ macromedia. com [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 15:47:04 -0400 Subject: Re: [Fwd: New Macromedia Security Zone Bulletins Posted] To: CF-Talk [EMAIL PROTECTED] If you're running CFMX on top of JRun, I was under the impression that JRun provides the web server configuration utility. According to the Security Zone bulletin, you have to install JRun Updater 4 in that case. You are correct. In that case, you should be installing both the Updater for ColdFusion MX 6.1 and Updater 4 for JRun 4. Sorry I wasn't more clear about that in my last message. -Jim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Express
Does anyone have a copy of this? I have a client that I need to build a small app for but it's a non-profit organization and they can't afford the full version. I have an FTP I can setup if anyone has it and willing to upload. Thanks! -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
How to tell if CFMX 6.1 Updater has been installed?
Is there a way to identify if CFMX 6.1 Updater has been installed? I went into the CF admin and clicked the system properties tab the version says: 6,1,0,63958 Regards, Dave Bosky HTC Disclaimer:The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF Express
Is there any particular reason that you're looking for Express?As I remember the it's actually based on CF 4.5 and lacks quire a bit of the functionality is missing. On the other hand BlueDragon is (I'm almost sure) free for such a purpose, has much more functionality and is (damn near) feature compatible with CF MX.Check out NewAtlanta.com for more information - I think you'll be pleasantly surprised. Jim Davis _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 4:10 PM To: CF-Talk Subject: CF Express Does anyone have a copy of this? I have a client that I need to build a small app for but it's a non-profit organization and they can't afford the full version. I have an FTP I can setup if anyone has it and willing to upload. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Express
Thanks Jim, I can't get www.newatlanta.com to load ? Donna - Original Message - From: Jim Davis [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 16:27:55 -0400 Subject: RE: CF Express To: CF-Talk [EMAIL PROTECTED] Is there any particular reason that you're looking for Express?As I remember the it's actually based on CF 4.5 and lacks quire a bit of the functionality is missing. On the other hand BlueDragon is (I'm almost sure) free for such a purpose, has much more functionality and is (damn near) feature compatible with CF MX.Check out NewAtlanta.com for more information - I think you'll be pleasantly surprised. Jim Davis _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 4:10 PM To: CF-Talk Subject: CF Express Does anyone have a copy of this? I have a client that I need to build a small app for but it's a non-profit organization and they can't afford the full version. I have an FTP I can setup if anyone has it and willing to upload. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to tell if CFMX 6.1 Updater has been installed?
On Fri, 24 Sep 2004 16:19:17 -0400, Bosky, Dave [EMAIL PROTECTED] wrote: Is there a way to identify if CFMX 6.1 Updater has been installed? I went into the CF admin and clicked the system properties tab the version says: 6,1,0,63958 You don't have it installed. My version is 6,1,0,83762 with the Updater installed on the J2EE version. I believe the standalone version is the same number, but I don't use it so I don't know for sure. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
