RE: CFFLUSH and tables
No, it's just 3000 records, all displayed in table format, by date. The page itself is just under 400k. -Original Message- From: Reuben Poon [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 11:16 PM To: CF-Talk Subject: RE: CFFLUSH and tables Ian, Yes, it is a good idea to separate one big table into multiple tables so the browser can render each table individually. Netscape will not render a table unless it has all the information for that table. What is taking so long for the page to load? Maybe the problem is somewhere other than the HTML? Reuben Poon -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 11:09 PM To: CF-Talk Subject: CFFLUSH and tables Importance: Low Hi all, I'm trying to use CFFLUSH for a long, slow loading page. Problem is, both IE 5 and NS 6 seem to ignore the FLUSH command. Do some browsers require the whole table be completed before delivery? Ian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Windows 2000 Website
Start / Settings / Control Panel / Administrative Tools / Internet Services Manager Right click on the computer in the let pane. Choose New and then Web Site from the popup window. The website creation wizard comes up. The prompts are: Description. I usually put the domain name here. IP and port settings. Pick the IP that this site will answer to. Leave everything else alone. Path. Sounds like this should be c:\inetpub\wwwroot\abc for your example. Click Next and finish. Now right-click on the web site you just created (it just appeared in the left pane of IIS Mgr underneath the default web site). Choose Properties from the menu and click the Home Directory tab. Set Application Protection to Low (IIS Process). Click OK. Those are the very basic steps. You should definitely look into how to set the server up as securely as possible before diving in. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 9:11 PM To: CF-Talk Subject: CF and Windows 2000 Website Hi everyone. I am trying to do the following (never done it before): On one of our test servers we have Windows 2000 Server running IIS 5 and CF 5. The default website is setup and I need to create a new one. Well the cfdocs and cfide folders are inside the wwwroot folder which is the path to the default website. How do I create a new site that will work.. Right now I have a folder inside the wwwroot folder (default website) that is called ABC and want to be able to execute Cf templates inside it but right now I get a 404 error displayed by CF server. Any ideas? Do I need to remove the ABC folder and redefine thesite? Any suggestions would be much appreciated. Thanks, Mike __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFLUSH and tables
Ian, That is a large page size to download. I guess I meant there are several potential areas for a bottleneck: Server problems: Database interaction (lots of joins??) Lots of Cold Fusion processing required Bandwidth problems: Slow connection from client to server? Problem download large amounts of data? Client problems: HTML table not rendering piece by piece If the problem is with the client, just splice your table into several smaller tables and they should render when they receive data. Reuben Poon -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 11:16 PM To: CF-Talk Subject: RE: CFFLUSH and tables Importance: Low No, it's just 3000 records, all displayed in table format, by date. The page itself is just under 400k. -Original Message- From: Reuben Poon [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 11:16 PM To: CF-Talk Subject: RE: CFFLUSH and tables Ian, Yes, it is a good idea to separate one big table into multiple tables so the browser can render each table individually. Netscape will not render a table unless it has all the information for that table. What is taking so long for the page to load? Maybe the problem is somewhere other than the HTML? Reuben Poon -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 11:09 PM To: CF-Talk Subject: CFFLUSH and tables Importance: Low Hi all, I'm trying to use CFFLUSH for a long, slow loading page. Problem is, both IE 5 and NS 6 seem to ignore the FLUSH command. Do some browsers require the whole table be completed before delivery? Ian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Opera and cgi.HTTP_REFERER
I have a page which allows access only if a user is coming from a specific page, and I use http_referer to grant or deny access. But I don't think Opera gives this variable. can anyone else verify that? And how do you get around it? The situation is people buy access to an article or series of articles through an online shop, and I am reasoning that if they have got as far as page 101625, they must have paid or been given appropriate access. (that means I can leave it to the guy who looks after page 101625 to make sure he restricts access appropriately. The code I'm using is as follows: cfif isdefined(HTTP_REFERER) AND ( ! if he's coming from the article page - (#HTTP_REFERER# contains #articleID#) OR ! or he is coming back from the results page for another go round --- (#HTTP_REFERER# contains #calcfilename#) ) ! if that's the case do nothing, i.e. let him in cfelse !--- Otherwise send him to the head page of the article, where the user will be bounced if not logged in --- cflocation url=http://www.mydomain.com/goArticle.asp?ID=#articleID#p=01; cfabort /cfif Can anyone see the flaw in this snippet that lets it work for IE and NN but not for Opera? Cheers Mike Kear AFP Webworks Windsor, NSW, Australia __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFObject - creating an instance on the workstation
You need the application you are going to use. Has to be installed under the same account as the one running CF, and you should set the service to allow interaction with the desktop (double click on the service in services manager). Biggest problem you have to be aware of is the automated application throwing up dialogs on the server, and your app just hanging. You need to handle all possible instances in code. You can set these on your application object: xlApp.AlertBeforeOverwriting = False xlApp.AskToUpdateLinks = False xlApp.DisplayAlerts = False xlApp.FeatureInstall = msoFeatureInstallNone But I'm not sure whether they are 100%. You also have to beware of sharing conflicts if multiple users are accessing the same file. Also see www.cfcomet.com -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 14:47 To: CF-Talk Subject: RE: CFObject - creating an instance on the workstation At 09:31 AM 10/05/02 -0400, Carlisle, Eric wrote: No. ColdFusion can only use COM objects installed on the server. What do I need installed on the server to do this? Office Extensions? T __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do i pass FORM variables from one action page to another one ?
Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. Any help would be greatly appreciated! Contentment is not the fulfillment of what you want, it is the realization of how much you already have. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: check for mixed case plus a numeric
Brian Scandale wrote: Trying to check for mixed case, and at least one digit in a prospective password. Any ... snippets that might help me get started?? Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do i pass FORM variables from one action page to another one ?
If you'#re getting from B to C via a form submit, send them as hidden form fields, if it's a link, as URL vars. Althought you're limited with this method if they're long -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 07:15 To: CF-Talk Subject: How do i pass FORM variables from one action page to another one ? Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. Any help would be greatly appreciated! Contentment is not the fulfillment of what you want, it is the realization of how much you already have. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: check for mixed case plus a numeric
bOK = Refind([A-Z],pass) AND ReFind([a-z],pass) AND ReFind([0-9],pass) -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: maandag 13 mei 2002 13:13 To: CF-Talk Subject: Re: check for mixed case plus a numeric Brian Scandale wrote: Trying to check for mixed case, and at least one digit in a prospective password. Any ... snippets that might help me get started?? Thanks, Brian __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Opera and cgi.HTTP_REFERER
Hi Michael, I've checked out Opera for you and yup, cgi.HTTP_REFERER exists. In regards to your code all i would do is rewrite it like this, but that doesn't affect how it works in the browser: Cfif isdefined(cgi.HTTP_REFERER) and (cgi.HTTP_REFERER CONTAINS #articleID# OR cgi.HTTP_REFERER CONTAINS #calcfilename#).../cfif Rgds Dave A. -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:14 AM To: CF-Talk Subject: Opera and cgi.HTTP_REFERER I have a page which allows access only if a user is coming from a specific page, and I use http_referer to grant or deny access. But I don't think Opera gives this variable. can anyone else verify that? And how do you get around it? The situation is people buy access to an article or series of articles through an online shop, and I am reasoning that if they have got as far as page 101625, they must have paid or been given appropriate access. (that means I can leave it to the guy who looks after page 101625 to make sure he restricts access appropriately. The code I'm using is as follows: cfif isdefined(HTTP_REFERER) AND ( ! if he's coming from the article page - (#HTTP_REFERER# contains #articleID#) OR ! or he is coming back from the results page for another go round --- (#HTTP_REFERER# contains #calcfilename#) ) ! if that's the case do nothing, i.e. let him in cfelse !--- Otherwise send him to the head page of the article, where the user will be bounced if not logged in --- cflocation url=http://www.mydomain.com/goArticle.asp?ID=#articleID#p=01; cfabort /cfif Can anyone see the flaw in this snippet that lets it work for IE and NN but not for Opera? Cheers Mike Kear AFP Webworks Windsor, NSW, Australia __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: list delimiters
OK... So I have each record (line) of the CSV in a separate list. I now need to loop over each record (list) and pull the individual fields out. In order to change the commas to pipes, I'd have to know which ones to change and which ones not to, no? The only way I can think of involves lots of regexes, which unfortunately I'm not good at. I was thinking I could go through the list and find a single double-quote. Then keep looking until I find another single double-quote (there are double quotes within the string, but they are escaped ie 'she said hello to him'). Then change all the commas within that field to pipes, loop over and pull them into a structure, then change all the pipes back to commas. Whew. I have no idea where to start. Bud, I think that having a list qualifier parameter would be much much simpler! Kay. P.S. In case I'm not being clear here, a single record looks like this: 11,Apollo 13,Drama,It had been less than a year since man first walked on the moon, but as far as the American Public was concerned, Apollo 13 was just another routine space flight - until these words pierced the immense void of space: Houston we have a problem. Ron Howard directs Academy Award winner Tom Hanks, Kevin Bacon, Bill Paxton, Gary Sinise and Ed Harris in a riveting suspense-thriller from Imagine Entertainment.,18/08/1999 Bud [EMAIL PROTECTED] wrote in message news:p04320409b9049fb704b0@[192.168.0.1]... On 5/12/02, Reuben Poon penned: Kay, You could try this (written in psudo-code) 1 replace , with || 2 loop through items using , as delimiter 3 set || back to , This would remove the problem with the multiple commas and seems to be a relatively easy solution. You should only have to add two lines of code (#1 and #3). Actually, you've got the right idea, but I think you should have said to change , to | then use | as the delimiter, then change the | back to ,. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Opera and cgi.HTTP_REFERER
I have a page which allows access only if a user is coming from a specific page, and I use http_referer to grant or deny access. But I don't think Opera gives this variable. can anyone else verify that? And how do you get around it? The situation is people buy access to an article or series of articles through an online shop, and I am reasoning that if they have got as far as page 101625, they must have paid or been given appropriate access. (that means I can leave it to the guy who looks after page 101625 to make sure he restricts access appropriately. The code I'm using is as follows: cfif isdefined(HTTP_REFERER) AND ... I don't know how Opera behaves, offhand, but would like to point out a couple of things anyway. First, you don't have to check for the existence of CGI variables, as long as you use the CGI scope prefix. CF will always create such variables if they don't exist. So, for example, this code would work: cfif CGI.FOO_BAR is not baz even though there's no variable called CGI.FOO_BAR. Second, and more important, you can't rely on CGI.HTTP_REFERER for any serious security anyway, since it's sent by the browser, and can easily be set to whatever value the end user wants it to be (typically, they'd set it to the value that you're expecting, I suppose). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5 Developer Edition
Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
You can get a copy from here: http://www.macromedia.com/support/coldfusion/downloads.html Deb -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 8:40 AM To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF5 Developer Edition
Hi Anthony, just download the 5.0 Enterprise Trial. It'll convert to Developer Edition after 30 days. regards Patric WA Does anybody remember the URL to the CF5 developers edition? Macromedia WA seems to have purged every metion of 5.0 from their site. WA WA Tony Weaver WA Limited Technology Services WA Technology Planning WA Programmer/Analyst WA Phone: 614.415.7647 WA E-mail: [EMAIL PROTECTED] WA THE LIMITED, INC. WA __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: list delimiters
Theres a custom tag called CFX_CSVToQuery... cant remember off hand where i got it... probably from the Dev Exchange but can send it to you off-list if you want... This takes a CSV file and converts it into a CFQuery Object.. This handles commas in the fields (assuming they are within quotations i beleive) HTH Kay Smoljak wrote: OK... So I have each record (line) of the CSV in a separate list. I now need to loop over each record (list) and pull the individual fields out. In order to change the commas to pipes, I'd have to know which ones to change and which ones not to, no? The only way I can think of involves lots of regexes, which unfortunately I'm not good at. I was thinking I could go through the list and find a single double-quote. Then keep looking until I find another single double-quote (there are double quotes within the string, but they are escaped ie 'she said hello to him'). Then change all the commas within that field to pipes, loop over and pull them into a structure, then change all the pipes back to commas. Whew. I have no idea where to start. Bud, I think that having a list qualifier parameter would be much much simpler! Kay. P.S. In case I'm not being clear here, a single record looks like this: 11,Apollo 13,Drama,It had been less than a year since man first walked on the moon, but as far as the American Public was concerned, Apollo 13 was just another routine space flight - until these words pierced the immense void of space: Houston we have a problem. Ron Howard directs Academy Award winner Tom Hanks, Kevin Bacon, Bill Paxton, Gary Sinise and Ed Harris in a riveting suspense-thriller from Imagine Entertainment.,18/08/1999 Bud [EMAIL PROTECTED] wrote in message news:p04320409b9049fb704b0@[192.168.0.1]... On 5/12/02, Reuben Poon penned: Kay, You could try this (written in psudo-code) 1 replace , with || 2 loop through items using , as delimiter 3 set || back to , This would remove the problem with the multiple commas and seems to be a relatively easy solution. You should only have to add two lines of code (#1 and #3). Actually, you've got the right idea, but I think you should have said to change , to | then use | as the delimiter, then change the | back to ,. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Does anyone know how I can get the CD version rather than downloading it? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:42 To: CF-Talk Subject: RE: CF5 Developer Edition It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and SES urls
http://www.somesite.com/index/19/ that is a true 'search engine safe' url, otherwise known as a 'directory-style-querystring' But that would require passing any file - at least any file without extention to the CF engine. Bit of a problem no ? not a huge problem, really. how important are search engine rankings to your site? pretty important, i.ve found. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: list delimiters
Hey, this sounds perfect! I'm off to find it now. Thanks a lot :) Mike Townend [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Theres a custom tag called CFX_CSVToQuery... cant remember off hand where i got it... probably from the Dev Exchange but can send it to you off-list if you want... This takes a CSV file and converts it into a CFQuery Object.. This handles commas in the fields (assuming they are within quotations i beleive) HTH Kay Smoljak wrote: OK... So I have each record (line) of the CSV in a separate list. I now need to loop over each record (list) and pull the individual fields out. In order to change the commas to pipes, I'd have to know which ones to change and which ones not to, no? The only way I can think of involves lots of regexes, which unfortunately I'm not good at. I was thinking I could go through the list and find a single double-quote. Then keep looking until I find another single double-quote (there are double quotes within the string, but they are escaped ie 'she said hello to him'). Then change all the commas within that field to pipes, loop over and pull them into a structure, then change all the pipes back to commas. Whew. I have no idea where to start. Bud, I think that having a list qualifier parameter would be much much simpler! Kay. P.S. In case I'm not being clear here, a single record looks like this: 11,Apollo 13,Drama,It had been less than a year since man first walked on the moon, but as far as the American Public was concerned, Apollo 13 was just another routine space flight - until these words pierced the immense void of space: Houston we have a problem. Ron Howard directs Academy Award winner Tom Hanks, Kevin Bacon, Bill Paxton, Gary Sinise and Ed Harris in a riveting suspense-thriller from Imagine Entertainment.,18/08/1999 Bud [EMAIL PROTECTED] wrote in message news:p04320409b9049fb704b0@[192.168.0.1]... On 5/12/02, Reuben Poon penned: Kay, You could try this (written in psudo-code) 1 replace , with || 2 loop through items using , as delimiter 3 set || back to , This would remove the problem with the multiple commas and seems to be a relatively easy solution. You should only have to add two lines of code (#1 and #3). Actually, you've got the right idea, but I think you should have said to change , to | then use | as the delimiter, then change the | back to ,. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Vern maybe able to help you, I am sure someone could burn a copy for you, as long is did not contravene MM legalities! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:04 To: CF-Talk Subject: RE: CF5 Developer Edition Does anyone know how I can get the CD version rather than downloading it? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:42 To: CF-Talk Subject: RE: CF5 Developer Edition It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Cheers for that, but I really wanted a nice shiney new copy. Do you know if they still send them out? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:03 To: CF-Talk Subject: RE: CF5 Developer Edition Vern maybe able to help you, I am sure someone could burn a copy for you, as long is did not contravene MM legalities! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:04 To: CF-Talk Subject: RE: CF5 Developer Edition Does anyone know how I can get the CD version rather than downloading it? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:42 To: CF-Talk Subject: RE: CF5 Developer Edition It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Hmmm? I doubt if they are still being produced - what with MX coming soon, but you know what it is like : there are probably loads around the MM office. Vern should be on the list later, but I will ping him as well :-) Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:14 To: CF-Talk Subject: RE: CF5 Developer Edition Cheers for that, but I really wanted a nice shiney new copy. Do you know if they still send them out? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:03 To: CF-Talk Subject: RE: CF5 Developer Edition Vern maybe able to help you, I am sure someone could burn a copy for you, as long is did not contravene MM legalities! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:04 To: CF-Talk Subject: RE: CF5 Developer Edition Does anyone know how I can get the CD version rather than downloading it? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:42 To: CF-Talk Subject: RE: CF5 Developer Edition It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Developer Edition
Like you said, someones contacted me with an offer of one, thanks for everyones replies though Ade :O) -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:11 To: CF-Talk Subject: RE: CF5 Developer Edition Hmmm? I doubt if they are still being produced - what with MX coming soon, but you know what it is like : there are probably loads around the MM office. Vern should be on the list later, but I will ping him as well :-) Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:14 To: CF-Talk Subject: RE: CF5 Developer Edition Cheers for that, but I really wanted a nice shiney new copy. Do you know if they still send them out? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:03 To: CF-Talk Subject: RE: CF5 Developer Edition Vern maybe able to help you, I am sure someone could burn a copy for you, as long is did not contravene MM legalities! Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 14:04 To: CF-Talk Subject: RE: CF5 Developer Edition Does anyone know how I can get the CD version rather than downloading it? -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:42 To: CF-Talk Subject: RE: CF5 Developer Edition It was re-added a last week. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:40 To: CF-Talk Subject: RE: CF5 Developer Edition Anthony, It has vanished. I can't seem to find it anywhere on the site. Stephen -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 13:39 To: CF-Talk Subject: CF5 Developer Edition Does anybody remember the URL to the CF5 developers edition? Macromedia seems to have purged every metion of 5.0 from their site. Tony Weaver Limited Technology Services Technology Planning Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] THE LIMITED, INC. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do i pass FORM variables from one action page to another one ?
You can do your checking on B. If checking is false, CFinclude A, but if it is correct, CFinclude C. - j -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:15 AM To: CF-Talk Subject: How do i pass FORM variables from one action page to another one ? Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. Any help would be greatly appreciated! Contentment is not the fulfillment of what you want, it is the realization of how much you already have. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i pass FORM variables from one action page to another one ?
On 5/13/02, JAIME HOI penned: Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. The simplest way is to loop through form.fieldnames. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#evaluate(send)# /cfloop You'll obviously have to pass them through a form again with a Continue or Next Page button or whatnot. Also, if you're passing a field to tell the page what to process, ie; doing all the processing on the same page. cfif form.action is this Do this cfelseif form.action is that Do that /cfif then you'll want to not pass the original action, or you'll be passing a comma delimited list with the original action and the new action. So do it like this: cfloop index=send list = #form.fieldnames# cfif send is not action input type=hidden name=#send# value=#evaluate(send)# /cfif /cfloop input type=hidden name=action value=New Action -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I pass FORM variables from one action page to another one ?
Look for the custom tag embed form fields. One suggestion though. You need to doctor the tag to replace any ' or that are in the fields with quote; and such so you don't break it on the next page. Page b will do a form submit (can be handled in javascript with an onload function) that will just pass all the hidden fields to page c for processing or whatever. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:35 AM To: CF-Talk Subject: RE: How do i pass FORM variables from one action page to another one ? You can do your checking on B. If checking is false, CFinclude A, but if it is correct, CFinclude C. - j -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:15 AM To: CF-Talk Subject: How do i pass FORM variables from one action page to another one ? Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. Any help would be greatly appreciated! Contentment is not the fulfillment of what you want, it is the realization of how much you already have. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do i pass FORM variables from one action page to another one ?
I guess I could have explained that better. CF_EMBEDFORMFIELDS will write all existing form variables to hidden fields. You need to write something to submit the form. It uses form.fieldnames, and evaluate() to generate the new form. Again if you need any more help with this just let me know. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:15 AM To: CF-Talk Subject: How do i pass FORM variables from one action page to another one ? Hi Let's sayi have Page A , action page is Page B. From page B after some checking i will call page C. But how can Page C get the form variables from Page A? Does anyone knows how i can have a quick access of all the form variables and pass it to Page C. For eg, if it is URL variables, i can use CGI.Query_String to pass them to Page C. But for FORM variables, how do i access it? As an alternative, i was thinking of using WDDX . Construct one CFML2WDDX and have it as one of the hidden variable in Page A. Then simply access that single hidden variable and pass to Page C as URL variable. Anyone sees any problem with this? I'm quite confused, i am looking for a quick method to handle the passing of data. Any help would be greatly appreciated! Contentment is not the fulfillment of what you want, it is the realization of how much you already have. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Find match in string
Hi, The code below checks for the filenames and extensions: cfif (ListFindNoCase(dat,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(job,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(inc,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(log,listLast(#Session.stDirFileName[i]#, .))) /cfif Some of the file have a ~ at the end. For example, test.dat~ How can I easily check the above variable for the ~. Note that the file extension could be more than three characters to the right of the . +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i pass FORM variables from one action page to another one ?
/me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop jon - Original Message - The simplest way is to loop through form.fieldnames. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#evaluate(send)# /cfloop __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Geographical redundancy?
BoardWatch Magazine publishes a summary of country-wide backbone providers once or twice a year. If you look specifically for this publication you can get a good overview of which networks connect to which cities and NAPs (MAE-East is a NAP). Personally, I don't think you're really looking for a solution like this in the end. You might want to consider pooling data locally at your collection centers and, as someone already mentioned, replicate this data to a central source. Then, if you choose to use a web interface for collection and display of this data, you can have multiple webservers, each local to the pooled data, and a master server residing over the central data. With this model, the central repository's reports could conceivably be impaired by net traffic, but the local centers, where the data is entered, will remain up to date and functioning regardless of disasters in other locations or loss of connectivity. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/12/02 01:16PM Exodus is now owned by Cable Wireless. C W also bought Digital Island, so they have some great technology for distribute web sites. Global Crossing is another Enron, so you best stay away. AboveNet, which was always owned by Metromedia Fiber Network (MFN); has been sucked back into the parent company. MFN has had and continues to have one of the best IP networks in the world. Their claim to fame is also that they run the MAEs. UUnet has a great network, but they are part of WorldCom, which is having serious trouble theses days. Savvis has some really nice offerings and has weathered the downturn thanks to their monopoly on finical services networks that their parent company Bridge gave them. Level3 Communications also has some good stuff these days. There are plenty of other ISPs and hosting providers, but they really can't compete with the above list. -Matt -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 9:59 AM To: CF-Talk Subject: RE: Geographical redundancy? You'll need to rely on one of the larger ISP/hosting providers for this, it won't be cheap. Exodus (are they still around?), is an example of a well known provider that can accommodate you. Their NOC's (network operation center) are notoriously renowned as being the biggest and the baddest (including guards armed with AR15's back in the dot com hay days). You'll also want to do a little research on your hosting provider's providers - they should have redundant uplinks to at least two of the larger pipes (abovenet, UUNet, gblX, etc). They should provide you with evidence of their uptime (MRTG charting) - as you see downtimes for one routing interface, there should be significant jumps for the others to show that they're in fact picking up the slack. This is what I believe the CCIE certifications were meant to teach people - becoming conversant with the various protocols (OSPF, RIP, HSRP, insert TLA here) and how to configure them to make the Beast happy. As for keeping your application/database transactions synchronized, that could fill a book in it's own right. You're better off dumping the responsibility onto somebody that's done it before. When everything is set up, you'll want to document and test a disaster recovery plan. Adam. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 11, 2002 1:05 PM To: CF-Talk Subject: Geographical redundancy? I have to put together a proposal for a medical office management application which will be used in an ASP (application service provider - not the MS language:) model.. one of the requirements is that the application has to be hosted in such a way that a major disaster (natural or otherwise) in 1 location can't cause the loss of any data, and only a small (maybe an hour) downtime for the application. After the Sept. 11 tragedy, my websites had connectivity problems on and off for a few days. We also had 24 hours of downtime when a hurricane knocked down a bunch of telephone poles near my ISP a few years ago. For this application, that wouldn't have been acceptable. I have no idea how to approach it. Any ideas? Al a1webs.com At 06:08 PM 5/10/2002 -0400, Justin Greene wrote: I Have to agree. Hardware based clustering for the front end... and either SQL Enterprise or Veritas on the backend to handle the database cluster. Very solid configuration. We have been hardware clustering CF with Alteons for over 3 years. Just need to keep sessions in the DB and make sure the web boxes keep the file systems synched. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:
OT: Is there a flash-talk list?
Anyone have a line on a flash talk list similar to this list? I'd use the news server but I can't get it from where I'm at (and it would be slow anyways). Thanks, David Schmidt, Macromedia Advanced ColdFusion Developer Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a flash-talk list?
Go to chatty.figleaf.com they have a few different ones. Ben -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 10:24 AM To: CF-Talk Subject: OT: Is there a flash-talk list? Anyone have a line on a flash talk list similar to this list? I'd use the news server but I can't get it from where I'm at (and it would be slow anyways). Thanks, David Schmidt, Macromedia Advanced ColdFusion Developer Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a flash-talk list?
There is a Flash/ColdFusion one : www.flashcfm.com Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: 12 May 2002 15:24 To: CF-Talk Subject: OT: Is there a flash-talk list? Anyone have a line on a flash talk list similar to this list? I'd use the news server but I can't get it from where I'm at (and it would be slow anyways). Thanks, David Schmidt, Macromedia Advanced ColdFusion Developer Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a flash-talk list?
Anyone have a line on a flash talk list similar to this list? There are several Flash lists here: http://chattyfig.figleaf.com/ If you're interested in basic Flash stuff, the Flashnewbie list is probably what you're looking for. If you're interested in ActionScript-specific coding topics, check out Flashcoders. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Linux MSSQL frontend
Does anyone know of a frontend for Linux to manage MS SQL databases? Thanks Chuck __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: weird query to excel problem
Hi Douglas, Thanks for the help. I reinstalled Office...no luck. I applied the IE 5.5 service pack...no luck. I applied the Office SP2...no luck. I am at a loss as to why this is happening only for me. My next step is a full reinstall of IE. I'm grasping at straws here. Thanks! -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 5:11 PM To: CF-Talk Subject: Re: weird query to excel problem It sounds like it may simply be an excel problem...You may want to consider reinstalling excel and see what happens. It is weird that it is giving you a access violation. Have you rebooted recently? It may be trying to reference a workbook that the OS thinks is still open. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Stocke Terri [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 1:49 PM Subject: RE: weird query to excel problem Nope, they don't get the error. I asked them whether they tried it with Excel open or closed, and they told me that it works either way for them. Weird, huh? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 4:59 PM To: CF-Talk Subject: Re: weird query to excel problem I do not notice right off the bat any problems. Have you had the other people try the same thing? Do they get the same error running your code on their machine? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Stocke Terri [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 1:35 PM Subject: RE: weird query to excel problem Yep, sure thing. Bear with me--I didn't have anything to do with this implementation, so I'm still just wading through the code on it. And I know very little about COM objects, so... THANKS! Here's the link that calls the page: a href=app/testing.cfm?ses_id=#url.ses_id#Excel Report /a * Here's the testing.cfm page: cfquery name=GetAnything datasource=#dbname# Select * From cf_fpr.fpr_proj_main /cfquery html head titleTesting Excel tag/title /head body CF_Query2Excel Query=GetAnything AlternateColor = ff /body /html ** Here's the custom tag: html head titleSQL Database Dump to Excel/title /head body !--- Surpress Output --- cfsetting enableCFoutputOnly = Yes !--- Database user name --- CFSET UserName = username !--- Database password --- CFSET Password = passsword !--- Datasource name --- CFSET Datasource = datasource !--- Excel Filename --- CFSET filename = filename !--- Setup Alpha References -- Add to go beyond 26 --- cfset alpha=A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z cfset alpha_array = listToArray(alpha) cfquery name=gettable datasource=#datasource# SELECT sysobjects.id as tableid, sysobjects.name as tablename, syscolumns.name as columnname FROM sysobjects, syscolumns WHERE sysobjects.type = 'U' ANDsysobjects.id = syscolumns.id ORDER by sysobjects.id /cfquery !--- Try to connect to the Excel application object --- CFTRY !--- If it exists, connect to it --- CFOBJECT ACTION=CONNECT CLASS=Excel.Application NAME=objExcel TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- CFOBJECT ACTION=CREATE CLASS=Excel.Application NAME=objExcel TYPE=COM /CFCATCH /CFTRY CFSCRIPT // Open Excel in the background objExcel.Visible = false; // Disable client alerts such as: 'Save this workbook?' objExcel.DisplayAlerts = false; // Define the workbooks object objWorkBook = objExcel.Workbooks; // Add a new workbook objOpenedBook = objWorkBook.Add(); /cfscript !--- Set Defaults --- cfset currenttable = !--- Loop through tables --- cfloop query=gettable !--- On table change --- cfif gettable.tableid neq currenttable !--- If not first loop --- cfif currenttable neq !--- Process Field List --- cfset fieldlist = right(sqlquery, len(sqlquery) - 7) cfset fieldlist = left(fieldlist, len(fieldlist) - 2) !--- Build SQL Query --- cfset sqlquery = left(sqlquery, len(sqlquery)-2) FROM oldtablename !--- Add Label Worksheet with Table Names --- cfscript // Get the WorkSheets' collection objWorkSheets = objExcel.WorkSheets; // Add a new worksheet (this will contain our data) objWorkSheet = objWorkSheets.Add(); objWorkSheet.Name = #oldtablename#; /cfscript !--- Add Column Names --- cfset row = 1 cfset col = 0 cfloop list=#fieldlist# index=item cfset col = col + 1 cfset range = alpha_array[col] row cfset cellvalue = trim(item) cfscript objRange =
Re: How do i pass FORM variables from one action page to another one ?
Way easier and more compact: cfwddx action=cfml2wddx input=#form# output=#variables.avariable# input type=hidden name=aname value=#htmlEditFormat (variables.avariable)# - Original Message - From: Jon Hall [EMAIL PROTECTED] Date: Monday, May 13, 2002 7:55 am Subject: Re: How do i pass FORM variables from one action page to another one ? /me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop jon - Original Message - The simplest way is to loop through form.fieldnames. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#evaluate(send)# /cfloop __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a flash-talk list?
Also FlashCFM at http://www.flashcfm.com/mailing_list.cfm --- Ben -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 10:24 AM To: CF-Talk Subject: OT: Is there a flash-talk list? Anyone have a line on a flash talk list similar to this list? I'd use the news server but I can't get it from where I'm at (and it would be slow anyways). Thanks, David Schmidt, Macromedia Advanced ColdFusion Developer Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a flash-talk list?
There are also some lists at chinwag.com. But figleaf I have found to be consistently the best. Some smart coders hang out there. Jerry Johnson [EMAIL PROTECTED] 05/13/02 10:31AM Anyone have a line on a flash talk list similar to this list? There are several Flash lists here: http://chattyfig.figleaf.com/ If you're interested in basic Flash stuff, the Flashnewbie list is probably what you're looking for. If you're interested in ActionScript-specific coding topics, check out Flashcoders. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Linux MSSQL frontend
http://www.hotscripts.com/Detailed/7180.html - j -Original Message- From: Brockman, Chuck [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:35 AM To: CF-Talk Subject: OT: Linux MSSQL frontend Does anyone know of a frontend for Linux to manage MS SQL databases? Thanks Chuck __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
load java class from a package
Hi, which is the way one can load a java class from a package in a .cfm file ? (for a single class, that is not in a package the operation is quite streight forward, but when I trry to load a class from a package a get a class not found error message) package : mailer it has three classes : mainMailer.class, saxMailer.class, smtpMailer.class I need to load the mainMailer.class (from the mailer package) and create an object. Thank you, Florin FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i pass FORM variables from one action page to another one ?
Oops, it should be: cfwddx action=cfml2wddx input=#form# output=variables.avariable - Original Message - From: [EMAIL PROTECTED] Date: Monday, May 13, 2002 8:48 am Subject: Re: How do i pass FORM variables from one action page to another one ? Way easier and more compact: cfwddx action=cfml2wddx input=#form# output=#variables.avariable# input type=hidden name=aname value=#htmlEditFormat (variables.avariable)# - Original Message - From: Jon Hall [EMAIL PROTECTED] Date: Monday, May 13, 2002 7:55 am Subject: Re: How do i pass FORM variables from one action page to another one ? /me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop jon - Original Message - The simplest way is to loop through form.fieldnames. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#evaluate(send)# /cfloop __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is there a flash-talk list?
You might also check out www.flashkit.com It is a good resource too. -Drew Harris On 5/13/02 9:40 AM, Jerry Johnson [EMAIL PROTECTED] wrote: There are also some lists at chinwag.com. But figleaf I have found to be consistently the best. Some smart coders hang out there. Jerry Johnson [EMAIL PROTECTED] 05/13/02 10:31AM Anyone have a line on a flash talk list similar to this list? There are several Flash lists here: http://chattyfig.figleaf.com/ If you're interested in basic Flash stuff, the Flashnewbie list is probably what you're looking for. If you're interested in ActionScript-specific coding topics, check out Flashcoders. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Find and Replace custom tag.
Hello All, I am trying to build a find and replace funstion into my content management tool. The user can click on a linktype in a search string see a table showing all the matches and click a box if they want that text to be replaced. I am having a hard time trying to code this. I have just found the CFX_pcregex custom tag and just wondered if anyone had used it and could offer me advice on how to set it up ! Cheers, Darren Adams Web Developer Mob:07759 965523 Office:01252 556220 Data + Structure = Information Message End. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Linux MSSQL frontend
You could use WINE to run Enterprise Manager, or one written in any web platform that supports SQL Server (like PHP or CF) --- Billy Cravens -Original Message- From: Brockman, Chuck [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:35 AM To: CF-Talk Subject: OT: Linux MSSQL frontend Does anyone know of a frontend for Linux to manage MS SQL databases? Thanks Chuck __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Pop a window with content...
You could submit a form to the popup or pass the string through the URL and then display it in the popup.. I would try the form post first as URL passing would be quite messy. -- Clint Tredway -- Through Him, anything is possible. Is there a way to pop a window from a page loading without having its contents as a physical file? I.e. I would like to pass the contents of the window pop in the javascript? Thanks, Neil __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: load java class from a package
Make sure the you have a Class Path setup for the package you are trying to use in ColdFusion Administrator (located under Java). cfscript mailerObj = CreateObject(Java,mailer.mainMailer); /cfscript If the class constructor takes arguments, simple call the init() function and pass the args in the appropriate order. cfscript mailerObj = CreateObject(Java,mailer.mainMailer); mailerObj.init(arg1,arg2,#arg3#,...); /cfscript HTH #_# -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] -Original Message- From: Florin Chitu [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 8:01 AM To: CF-Talk Subject: load java class from a package Hi, which is the way one can load a java class from a package in a .cfm file ? (for a single class, that is not in a package the operation is quite streight forward, but when I trry to load a class from a package a get a class not found error message) package : mailer it has three classes : mainMailer.class, saxMailer.class, smtpMailer.class I need to load the mainMailer.class (from the mailer package) and create an object. Thank you, Florin FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Joining Verity Search Results and Query
I'm attempting to join a verity search result and a query into one query, for some reason when I dump the joined query to cfdump I get wrong information in the columns. For example I get score for the identifier from my database query and for lastedit date I get title. Individually both queries have the proper data in the proper places. Has anyone experienced this before? Is this an SQL problem or a CF one? I've tried both Join and Where neither seem to work properly. My queries are as follows: !--- Initial Verity Search -- cfsearch name = results !---Query for extended record info--- cfquery name=articles datasource=memberdb select article_id, article_title, article_lasteditdt, cat_name, cat_parentid from pi_articles, pi_site_map where article_active = 1 and article_parentcat = cat_id order by article_lasteditdt desc /cfquery !---Joined Query-- cfquery name=results1 dbtype=query Select results.Key, articles.article_title as title, article_LastEditDT, articles.cat_Name as Issue, articles.article_ID, articles.article_Title as T1 From results, articles Inner Join results on results.key = articles.article_ID!--- I've tried both Join and Where neither seem to work properly --- Order by LastEditDT DESC /cfquery Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Linux MSSQL frontend
I have a CF based SQL Server front end that I could send you. Its not completely ready but it allows for data reading, writting, dropping/creating stored procedures and dropping tables. Let me know... -- Clint Tredway -- Through Him, anything is possible. You could use WINE to run Enterprise Manager, or one written in any web platform that supports SQL Server (like PHP or CF) --- Billy Cravens -Original Message- From: Brockman, Chuck [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:35 AM To: CF-Talk Subject: OT: Linux MSSQL frontend Does anyone know of a frontend for Linux to manage MS SQL databases? Thanks Chuck __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MX review by Yankee Group
13. Macromedia Warms Up ColdFusion Application Infrastructure Software Platforms by Robert Perry Event Summary On April 29, Macromedia announced ColdFusion MX, an update to the early Web application platform originally offered by Allaire. ColdFusion MX is a development platform that runs on J2EE application servers. Market Analysis The success of Java as a server development language has raised questions about the future of ColdFusion. ColdFusion was very successful as a development and deployment platform for Web applications. It was an early entrant and offered a easy to use scripting language that worked well for many developers. Today, it enjoys the support of a large developer community and a host of third-party applications. A 2001 Yankee Group survey showed that it remained a popular corporate application platform with 13% of respondents indicating they were running applications on ColdFusion. Yet, it wasn't Java and everyone is talking about Java, .NET, and Web services. ColdFusion seemed destined to gradually fade away as these newer development platforms continued their momentum. ColdFusion MX not only breathes life into ColdFusion, it applies it strengths in ease of use and rapid application delivery to the harder to use J2EE platform. ColdFusion developers can transfer their skills to the Java platform seeing the benefits of its highly scalable architecture. Conclusions/Recommendations a.. The Macromedia MX rollout shows the company understands the needs of users by offering the tools to create rich applications that are easier to use while offering a more enjoyable interaction and the requirements of developers' tools to build these applications rapidly. b.. Corporate IT groups wondering what to do with their ColdFusion applications and their ColdFusion developers can wonder no more. They should adopt ColdFusion MX and migrate their existing applications to the scalable J2EE platform. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i pass FORM variables from one action page to another one ?
On 5/13/02, Jon Hall penned: /me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop Neato. Does that work in 4.5 and earlier? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
can this be done?
Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfexecute
My cfexecute code runs and displays the message in the window afterwards. How can I modify the output window? Do I have to write the output to a file and then read the file in? Does the cfexecute dump the results to a variable? +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i pass FORM variables from one action page to another one ?
4.5 yeah...earlier I don't know. I can't remeber if the form variables where put in a structure before 4.5... jon - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 13, 2002 12:00 PM Subject: Re: How do i pass FORM variables from one action page to another one ? On 5/13/02, Jon Hall penned: /me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop Neato. Does that work in 4.5 and earlier? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Of course it is, the replies will come flooding in just you wait... ;O) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:05 To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
I am not sure about in Access. In T-SQL you have functions like charindex, and subsrtring and right, and left that would make it easy to do this all in SQL. Using access I don't think you have those functions, however you can use CF to do it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
You need to select just the surname part in your select list and then order by that. e.g. if your field is called name try sommat like the following.. SELECT name, LEFT(name,CHARINDEX( ,name)) as 'fname', RIGHT(name,CHARINDEX( ,name)) as 'sname' FROM table ORDER by sname This assumes that your data is all ok - i.e. all confors to the format fname sname. i.e. if there is someone who's first or surnames have a space in them then you are a bit stuffed. I have no idea if this will work in access but should work in SQL. Sticky tape job but there you go.. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:07 To: CF-Talk Subject: RE: can this be done? Of course it is, the replies will come flooding in just you wait... ;O) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:05 To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Save yourself some pain and create two DB columns. Use CF to loop over them and re-insert the proper values. You only need to do this once of course... cfquery name=myQuery .. cfoutput query=myQuery cfquery name= INSERT INTO theTable (firstName, lastName) VALUES( '#listFirst(fullName, )#', '#listLast(fullName, )#') .. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:10 AM To: CF-Talk Subject: RE: can this be done? I am not sure about in Access. In T-SQL you have functions like charindex, and subsrtring and right, and left that would make it easy to do this all in SQL. Using access I don't think you have those functions, however you can use CF to do it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can this be done?
At 12:04 PM 5/13/02 -0400, Jeff Fongemie wrote: So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. I'd run a query through the table, picking up the names, breaking them in two using FindNoCase( ,Name,1) and grabbing to the left and right of the space. Then write the data back into the database into the two new fields you've created. (I don't give the customer the choice on this sort of thing, because they generally don't understand the ramifications.) T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
It can be done in access... Create two field within your table for first_name and last_name Then cfquery name=queryname datasoure=datasource Update table set first_name = left(fullname, instr(fullname,' ')), last_name=right(fullname, instrrev(fullname,' ')) /cfquery This should work. I haven't tried it so there might be some logical error I haven't thought of but the functions are in access to achieve the solution. - Matt Small -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:10 PM To: CF-Talk Subject: RE: can this be done? I am not sure about in Access. In T-SQL you have functions like charindex, and subsrtring and right, and left that would make it easy to do this all in SQL. Using access I don't think you have those functions, however you can use CF to do it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access SQL
starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work. 3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
You ought show them a comparison (cost) of how much time (therefore money) you are putting into the fix and how much it would have cost had they listened to you in the first place ($0.00) Let the figures speak for you again, proof the client really has no idea what they really wantsigh. feeling pessimistic today. Jon -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can this be done?
At 12:04 PM 5/13/02 -0400, you wrote: Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? I planned for something like this before and depending on the data, it might be more complicated than you think. The problem comes in when you have people with middle name, middle initials, Jr., Sr., III, etc. These things don't fit easily into a break at the first whitespace plan. Of course, if you don't actually have that kind of data, there's no problem. Change it once and never go back because eventually you will have that problem. Take a look at the data and see what kind of anomalies exist in the field before you proceed. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
I second this - even though I posted a selotape solution, to break down the info into 2 separate entities is the better option -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:24 To: CF-Talk Subject: RE: can this be done? I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Yes, it can be done. But it will require manual review afterwards. I'd probably just right a quick and dirty CF page to do this work for you (a bit easier to understand/code than T-SQL), or if you have the skills, use SQL directly. However, what about cases where the name is something like John Van Dusen ? Is the Van portion a middle name, or part of the last name? How do you write that logic into the code? Hence the reason I say you need a manual review afterwards. (or before, to be certain you do not have any of these situations.) If you are going the CF route, then you might be able to use the list functions to do this. For instance: cfscript sFullName = Shawn Grover; sFirstName = ListGetAt(sFullName, 1, ); sLastName = ListGetAt(sLastName, 2, ); /cfscript Or you can be more elaborate, and get the first name, then using the left/right functions, strip that string from the full name, and assume the rest is the last name. My thoughts Shawn Grover -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:05 AM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
It can also be done by creating a query using SQL in access. ColdFusion is not necessary. - Matt Small -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:29 PM To: CF-Talk Subject: RE: can this be done? It can be done in access... Create two field within your table for first_name and last_name Then cfquery name=queryname datasoure=datasource Update table set first_name = left(fullname, instr(fullname,' ')), last_name=right(fullname, instrrev(fullname,' ')) /cfquery This should work. I haven't tried it so there might be some logical error I haven't thought of but the functions are in access to achieve the solution. - Matt Small -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:10 PM To: CF-Talk Subject: RE: can this be done? I am not sure about in Access. In T-SQL you have functions like charindex, and subsrtring and right, and left that would make it easy to do this all in SQL. Using access I don't think you have those functions, however you can use CF to do it, and use the space as a list delimiter. It would be time consuming if it's a big db, and it would not scale at all :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MacBinary Xtraction Component 1.0
The guys at this site: http://www.alphasierrapapa.com/IisDev/Components/MacBinary/ , have come up with a C++ component for fixing MacBinary uploaded files. Being an ASP site, they have written an ASP page for running this component. Is there a way of running this component from CF? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
next previous with grouped output
Hello all, I'm having a hard time wrapping my brain around doing a next page type output where the query output is grouped. Basically, the table has products made up of three records (each) that are output as one. I wish the differences were simply attributes to I could normalize the product table, but unfortunately, they need to be treated as seperate products. The number of records returned is NOT always going to be three times the number of products listed. Sometimes each product will only have one record, and sometimes up to three. Any ideas?? Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Give this a shot - should get you on the right track. == cfscript i=1; fname=ArrayNew(1); lname=ArrayNew(1); if(not isdefined(url.orderby)){ url.orderby=fname; } if(not isdefined(url.updn)){ updn=ASC; } /cfscript cfquery name=qGetAll datasource=#request.dsn# SELECT fullname FROM mytable /cfquery cfoutput query=qGetAll fname[i]=ListGetAt(fullname,1, ); lname[i]=ListGetAt(fullname,2, ); cfset i=i+1 /cfoutput cfscript tmp=QueryAddColumn(qGetAll, fname, fname); tmp=QueryAddColumn(qGetAll, lname, lname); /cfscript cfquery name=qGetAll_2 dbtype=query SELECT * FROM qGetAll ORDER BY #url.orderby# #url.updn# /cfquery cfscript if(updn is ASC){ updn=DESC; }else{ updn=ASC; } /cfscript cfoutput query=qGetAll_2 a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a br /cfoutput == Hope this helps! Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access SQL
Try SELECT S.Name, R.Cert, C.Status, FROM C LEFT JOIN s ON S.SID = C.SID LEFT JOIN r ON C.RID = R.RID WHERE r.rid is not null Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:21 PM To: CF-Talk Subject: Access SQL starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work. 3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MacBinary Xtraction Component 1.0
The guys at this site: http://www.alphasierrapapa.com/IisDev/Components/MacBinary/ , have come up with a C++ component for fixing MacBinary uploaded files. Being an ASP site, they have written an ASP page for running this component. Is there a way of running this component from CF? You can run many COM objects using the CFOBJECT tag and/or the CreateObject function. Whether this specific COM object will work, I don't know; you'll have to try it and find out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Although several folks had much better solutions using SQL - take their advice - don't do it the CF way unless you have to for some reason. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:32 PM To: CF-Talk Subject: RE: can this be done? Give this a shot - should get you on the right track. == cfscript i=1; fname=ArrayNew(1); lname=ArrayNew(1); if(not isdefined(url.orderby)){ url.orderby=fname; } if(not isdefined(url.updn)){ updn=ASC; } /cfscript cfquery name=qGetAll datasource=#request.dsn# SELECT fullname FROM mytable /cfquery cfoutput query=qGetAll fname[i]=ListGetAt(fullname,1, ); lname[i]=ListGetAt(fullname,2, ); cfset i=i+1 /cfoutput cfscript tmp=QueryAddColumn(qGetAll, fname, fname); tmp=QueryAddColumn(qGetAll, lname, lname); /cfscript cfquery name=qGetAll_2 dbtype=query SELECT * FROM qGetAll ORDER BY #url.orderby# #url.updn# /cfquery cfscript if(updn is ASC){ updn=DESC; }else{ updn=ASC; } /cfscript cfoutput query=qGetAll_2 a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a br /cfoutput == Hope this helps! Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
How about really easy. You set up a where that looks for whatever they entered. Select name from personnel where name like '%#form.firstname#%' or name like '%#form.lastname#%' I mean it wouldn't be exact but there shouldn't be to many over lapping names. Not a lot of people out there with a last name containing Tim or bob or whatever. It wouldn't be exact but it would probably fit the middle ground and save you some trouble. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:32 PM To: CF-Talk Subject: RE: can this be done? Give this a shot - should get you on the right track. == cfscript i=1; fname=ArrayNew(1); lname=ArrayNew(1); if(not isdefined(url.orderby)){ url.orderby=fname; } if(not isdefined(url.updn)){ updn=ASC; } /cfscript cfquery name=qGetAll datasource=#request.dsn# SELECT fullname FROM mytable /cfquery cfoutput query=qGetAll fname[i]=ListGetAt(fullname,1, ); lname[i]=ListGetAt(fullname,2, ); cfset i=i+1 /cfoutput cfscript tmp=QueryAddColumn(qGetAll, fname, fname); tmp=QueryAddColumn(qGetAll, lname, lname); /cfscript cfquery name=qGetAll_2 dbtype=query SELECT * FROM qGetAll ORDER BY #url.orderby# #url.updn# /cfquery cfscript if(updn is ASC){ updn=DESC; }else{ updn=ASC; } /cfscript cfoutput query=qGetAll_2 a href=mypage.cfm?sortby=fnameupdn=#updn##fname#/a a href=mypage.cfm?sortby=lnameupdn=#updn##lname#/a br /cfoutput == Hope this helps! Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:05 PM To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can this be done?
Yes, Just create the two new columns and do like you suggested, find the first space and insert the name into the firstname column and then copy the remaining length of the string into the lastname column minus the space. Then run a quick output to visually inspect the contents of the fields. It'll be a small pain to do but lesson learned: never let the client define the database. :) Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/13/02 12:04PM Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: next previous with grouped output
use a DISTINCT clause in your SELECT statement. That way each product will only have one record and the rest of the problem solves itself... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:27 AM To: CF-Talk Subject: next previous with grouped output Hello all, I'm having a hard time wrapping my brain around doing a next page type output where the query output is grouped. Basically, the table has products made up of three records (each) that are output as one. I wish the differences were simply attributes to I could normalize the product table, but unfortunately, they need to be treated as seperate products. The number of records returned is NOT always going to be three times the number of products listed. Sometimes each product will only have one record, and sometimes up to three. Any ideas?? Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MacBinary Xtraction Component 1.0
Most likely it can, after looking at the source it is a very simple COM object that doesn't return anything that CF might choke on. The key function is the ConvertMacFile function. In that function these two lines would be key, and they would look exactly the same in cfscript without the Set keyword, and adding semicolons. Set MacBin = CreateObject(Softwing.MacBinary) bRetVal = MacBin.ConvertFromMacBinary(File,strCurrentTempFile) CreateObject in VBScript does the same thing as cfscript's CreateObject. The second line is calling the ConvertFromMacBinary method with the uploaded filename as the first argument, and a temporary filename to write out the actual file minus the MacBinary stuff. It goes on to overwrite the original uploaded file with the temporary file as long as the COM object didn't return an error. Thanks for pointing this component out, new bookmark for me... As a side note, that has to be the most readable VBScript I have ever seen (still sucks though :)) . Kudos to them... jon - Original Message - From: Lon Lentz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 13, 2002 12:36 PM Subject: MacBinary Xtraction Component 1.0 The guys at this site: http://www.alphasierrapapa.com/IisDev/Components/MacBinary/ , have come up with a C++ component for fixing MacBinary uploaded files. Being an ASP site, they have written an ASP page for running this component. Is there a way of running this component from CF? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
Some cautions when you go through the potential redesign and subsequent parsing: 1. If you are dealing with far eastern names (Hebrew and Arabic as well if my memory serves me right), names have a different structure then we do in Western culture. 2. If these names where input by the individuals themselves and the program did not do any clean-up before storing, You may have to deal with the following sorts of combinations: Andy Ousterhout Andrew C. Ousterhout A Channing Ousterhout AC Ousterhout Mr Andrew Channing Ousterhout, Senior, Ph.d, JD, and other god-like qualifications... You might want to check to see if anyone has some good name-parsing code. Good luck Andy -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 11:24 AM To: CF-Talk Subject: RE: can this be done? I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do i pass FORM variables from one action page to another one ?
No it won't work in v4.01. Believe me I've tried. Prior to v4.5 form fields were a pseudo-structure. The only way I've gotten anything to work is by evauating the form.fieldname. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:07 PM To: CF-Talk Subject: Re: How do i pass FORM variables from one action page to another one ? 4.5 yeah...earlier I don't know. I can't remeber if the form variables where put in a structure before 4.5... jon - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 13, 2002 12:00 PM Subject: Re: How do i pass FORM variables from one action page to another one ? On 5/13/02, Jon Hall penned: /me plays virtual Raymond :) Just say no to evaluate! Here is a speedier way to do it. cfloop index=send list = #form.fieldnames# input type=hidden name=#send# value=#form[send]# /cfloop Neato. Does that work in 4.5 and earlier? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access SQL
SELECT S.Name, R.Cert, C.Status, FROM (C LEFT OUTER JOIN s ON S.SID = C.SID) LEFT OUTER JOIN r ON C.RID = R.RID WHERE r.rid is not null +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:33 AM To: CF-Talk Subject: RE: Access SQL Try SELECT S.Name, R.Cert, C.Status, FROM C LEFT JOIN s ON S.SID = C.SID LEFT JOIN r ON C.RID = R.RID WHERE r.rid is not null Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:21 PM To: CF-Talk Subject: Access SQL starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work. 3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access SQL
I am looking for: select s.name, r.cert from s, r as a result set - or you could think of it as a crosstab report. Staff by Training Types and I am looking to put the c.status in as a data cell if it exists, and null if it doesn't eric From: Timothy Heald [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Access SQL Date: Mon, 13 May 2002 12:33:12 -0400 Try SELECT S.Name, R.Cert, C.Status, FROM C LEFT JOIN s ON S.SID = C.SID LEFT JOIN r ON C.RID = R.RID WHERE r.rid is not null Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:21 PM To: CF-Talk Subject: Access SQL starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work. 3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access SQL
am i right in thinking this query would return: Query Results Sid Cert Status Eric Filing A Eric Ethics A Tara Ethics A I am looking for Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A From: Bryan Love [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Access SQL Date: Mon, 13 May 2002 10:18:58 -0700 SELECT S.Name, R.Cert, C.Status, FROM (C LEFT OUTER JOIN s ON S.SID = C.SID) LEFT OUTER JOIN r ON C.RID = R.RID WHERE r.rid is not null +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:33 AM To: CF-Talk Subject: RE: Access SQL Try SELECT S.Name, R.Cert, C.Status, FROM C LEFT JOIN s ON S.SID = C.SID LEFT JOIN r ON C.RID = R.RID WHERE r.rid is not null Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 12:21 PM To: CF-Talk Subject: Access SQL starting to get frustrated... Trying to do something quick but I can't find the syntax to make it work. 3 tables in access S (SID, Name) R (RID, Cert) C (CID, SID, RID, Status) sample data. S (Eric,Bill,Tara) R (Filing,Ethics) C (1,Eric,Filing,A, 2,Eric,Ethics,A, 3,Tara,Ethics,A) I need to get all the Requirements for each staff and check to see if there is a certification record. In one Access query... Something like... SELECT S.Name, R.Cert, C.Status, FROM S, R LEFT JOIN C ON (R.RID = C.RID and S.SID = C.SID) to paraphrase: all staff (S) boxed with Requirements (R) with C if a record exists. Query Results Sid Cert Status Eric Filing A Eric Ethics A Bill Filing NULL Bill Ethics NULL Tara Filing NULL Tara Ethics A I know there is an easy answer, I just can't find the syntax to do this. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
calling a java method
Hi, I have a java package, from which I load a class. This class has several methods, out of which some return values , some do different jobs (like sending mail ) I have no problems getting the returned value from methods like : public static String returnS() { String mystr = ok; return mystr; } to get the value I'm using : cfset retVal = mailer.returnS() Are there some specific cfm tags that I'm supposed to use in order to execute a method that is defined as void , in the java program ? Thank you, Florin __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists